各位坛主进来看看

王超打字复印

你自己可以选择不要音乐

王超打字复印

SELECT        CUR_STOCK.DEPART ,
                        CUR_STOCK.CODE ,
                        (SELECT CASE WHEN ISNULL(CUR_STOCK.BARCODE,"") = "" THEN MAX(BARCODE) ELSE CUR_STOCK.BARCODE END
                        FROM COMM_BARCODE WHERE COMM_BARCODE.CODE = CUR_STOCK.CODE ) AS BARCODE,
         "  "+COMMODITY.NAME + (case when spec = null or spec = "" then "" else "["+commodity.spec +"]" end ) as name,   
         COMMODITY.UNIT,
                        COMMODITY.CONVERSION,   
         sum(CUR_STOCK.AMOUNT) as amount,   
         sum(CUR_STOCK.SUM_COST) / sum(CUR_STOCK.AMOUNT) as costprice,   
         sum(CUR_STOCK.SUM_COST)  as sum_cost,   
         sum(CUR_STOCK.SUM_COST * 100 / (100 + isnull(commodity.incometax,0))) as sum_wscost,   
         commodity.price as price,  
         sum(CUR_STOCK.AMOUNT * commodity.price) as sum_price ,
                        (SELECT MIN(SPEC_PRICE) FROM POP_INFO WHERE CODE = CUR_STOCK.CODE AND DEPART = CUR_STOCK.DEPART AND
                                        ENDDATE>DATEADD(DD,-1,GETDATE())) as spec_price
        FROM CUR_STOCK , COMMODITY
        WHERE (commodity.sort like "10503008%" )  and         CUR_STOCK.CODE = COMMODITY.CODE AND COMMODITY.NATURE not like "联营%"
                        and (COMMODITY.ifstock = 1 or (commodity.ifstock = 0 and depart in (select code from depart where nature = "s2")))
                        and cur_stock.depart not in (select code from operator_fun where operator = :as_op_depart and type = "部门" group by code)
                        and commodity.sort not in (select code from operator_fun where operator = :as_op_depart and type = "类别" group by code)
         AND CUR_STOCK.acctype LIKE :as_taxtype
        GROUP BY CUR_STOCK.DEPART , CUR_STOCK.CODE ,CUR_STOCK.BARCODE,commodity.name,commodity.spec,COMMODITY.UNIT,commodity.price,COMMODITY.CONVERSION
        Having sum(CUR_STOCK.AMOUNT)<>0

王超打字复印

王超打字复印:  退出 | 短消息 | 搜索 | 开音乐 | 版主工资 | 图片中心 | 问卷调查 | 照相馆 | 控制面板 | 道具 | 设施 | 统计

荆山读霸

原帖由 郑斌 于 7-16 13:33 发表
麻烦你们把这该死的铃声取消了吧，吵死人了。

是不是有短信没有看?

这是提示音

看过就没有了

郑斌

哈哈，没声音了，多谢了

郑斌

麻烦你们把这该死的铃声取消了吧，吵死人了。