银河线上娱乐场-澳门银河官网-澳门银河官网app

官网首页 > 信息资讯 > 公司动态 >
最新案例
点击这里给我发消息
建站咨询热线:
公司动态

初始化出库任务

来源:   日期:2019-12-07 08:50
--初始化出库单汇总,去除出库使命单,清空波次号update out_sale_billing_m set sf_ycw_sl='否' where DJBH =......

--初始化出库单汇总,去除出库使命单,清空波次号
update out_sale_billing_m set sf_ycw_sl='否' where DJBH ='XHBB00000414140';
BEGIN
FOR C IN LOOP
UPDATE out_sale_billing_m T
SET zyzt ='0',T.SF_YCW_SL ='否',t.sf_gq='否'--,SF_YBDD='否'
WHERE djbh = c.djbh
AND yzid = c.yzid;








UPDATE out_sale_billing_D T
 SET zyzt ='0',T.SL_LHWCL =T.SL,T.SL_ZJWCL =0, T.SL_KCBZ = 0,t.sf_gq='否',T.SF_YCW_SL ='否'
 WHERE djbh = c.djbh
 AND yzid = c.yzid; 
DELETE FROM OUT_SALE_TASK_D WHERE DJBH= C.DJBH AND YZID = C.YZID;
DELETE FROM OUT_SALE_TASK_M WHERE DJBH= C.DJBH AND YZID = C.YZID;

END LOOP;
END;


UPDATE out_sale_billing_m set BCH='' WHERE DJBH ='XHBB00000414140';