DFWMS捡货上架前单据删除代码

--查询WMS订单

select WOID,* from WAT_WareOrder where bindid='XSGZDA00064745' 
select * from WAT_WareOrderDetail where bindid='XSGZDA00054476'

--删除预约、收货、验收、上架表数据

DELETE from WAT_Appointment where WOID=57854 
DELETE from WAT_Receive where WOID=11147 
DELETE from WAT_Examine where WOID=11147 
DELETE from WAT_UpJob where WOID=11147

--初始化采购单

UPDATE WAT_WareOrder SET WOstate=0 where bindid='JHGZDA00001590' 
UPDATE WAT_WareOrderDetail SET WODstate=0 where bindid='JHGZDA00001590'

--查询WMS订单

select WOID,* from WAT_WareOrder where bindid like 'XSGZDA00053795%' 60235
select * from WAT_WareOrderDetail where bindid like 'XSGZDA00049408%'

--删除、复核、拣货表数据

select * from WAT_Review where WOID='65347'
select * from WAT_PickJob where WOID='65347'
select * from WBT_Staff
update WAT_PickJob set pjstaff_id='107' where WOID='65347'

--初始化销售单

UPDATE WAT_WareOrder SET WOstate=0 where bindid='XSGZDA00049408'
UPDATE WAT_WareOrderDetail SET WODstate=0 where bindid='XSGZDA00000011'