查询配送申请单， 已作废的

wbv123

select  *  from    t_distapply_h  where
billcode = 'APP' AND t_distapply_h.compid=2  and status=2
and applyno='23123112212105'

wbv123

---重置已作废的配送申请单

INSERT INTO tmp_disable_trigger (table_name) VALUES ('t_distapply_h');
update   t_distapply_h  set status=0,CHECKER1='',CHECKBIT1=0, CHECKER2='',CHECKBIT2=0 where
billcode = 'APP' AND t_distapply_h.compid=2  and status=2
and applyno='23122123411007705' ;  
delete from tmp_disable_trigger where table_name='t_distapply_h';