物流配送記錄删除

  将相關單據的pf_ckhx中的is_zx更新為否，再删除xshz_mx和xshz_hx中的相關資料

update pf_ckhz set is_zx='否' where djbh in ('XSAYMA00036212','XSAYMA00036208','XSAYMA00036211','XSAYMA00036209','XSAYMA00036210')

delete xshz_mx where djbh in ('XHZYMA00023714','XHZYMA00023712','XHZYMA00023710','XHZYMA00023711','XHZYMA00023709')    

delete xshz_hz where djbh in ('XHZYMA00023714','XHZYMA00023712','XHZYMA00023710','XHZYMA00023711','XHZYMA00023709')

本文轉自 qvodnet 51CTO部落格，原文連結:http://blog.51cto.com/bks2015/1745876