20170118修改商品流水

备份表 fr_spls_rkbak20170118  fr_wlzhkkbak20170118   fr_spls_ckbak20170118

update spls_rk set jcshl=300,jcje=1210.26 where plh='Z0001270771'

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update wlzhk set jfje=jfje+1416,ye=ye+1416 where djbh='JHCYMA00003021' 

update wlzhk set ye=ye+1416 where djbh in ('JHCYMA00003025','JHCYMA00003024','JHCYMA00003023','JHCYMA00003022')

update wlzhk set dwbh='EWI00000129' where djbh='JHAYMA00022870'

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')

update wlzhk set jfje=jfje+1368,ye=ye+1368 where djbh='JHCYMA00003032' 

update wlzhk set dwbh='EWI00000134' where djbh='JHAYMA00022871'

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')

update spls_rk set jcshl=300,jcje=756.41 where plh='Z0001270775'

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')

update wlzhk set ye=ye+885 where djbh in ('JHCYMA00003025','JHCYMA00003024','JHCYMA00003023','JHCYMA00003022','JHCYMA00003021','JHCYMA00003020')

update wlzhk set dwbh='EWI00000129' where djbh in ('JHCYMA00003019','JHAYMA00022872')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')

update spls_rk set jcshl=180,jcje=153.86 where plh='Z0001270697'

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')

update wlzhk set ye=ye+180 where djbh in ('JHAYMA00022860','JHAYMA00022859','JHAYMA00022677','JHAYMA00022461','JHAYMA00022334','JHAYMA00022333','JHAYMA00022332','JHAYMA00022331','JHAYMA00022330','JHDYMA00005335','JHDYMA00005332','JHDYMA00005238','JHDYMA00005237','JHAYMA00021923','JHCYMA00002992','JHCYMA00002991','JHCYMA00002990','JHCYMA00002989','JHCYMA00002988','JHCYMA00002987','JHCYMA00002986','JHCYMA00002985','JHCYMA00002984','JHCYMA00002983','JHCYMA00002982')

update wlzhk set dwbh='EWI00000127' where djbh in ('JHCYMA00002981','JHAYMA00022861')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')

update spls_rk set jcshl=jcshl+360,jcje=jcje+1261.54 where plh in ('Z0001270683','Z0001270420')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')

update wlzhk set ye=ye+1476 where djbh in ('JHAYMA00022442','JHAYMA00022441','JHAYMA00022440','JHAYMA00022439','JHDYMA00005308','JHAYMA00021904','JHCYMA00002887','JHCYMA00002885','JHCYMA00002880')

update wlzhk set dwbh='EWI00000123' where djbh in ('JHCYMA00002879','JHAYMA00022873')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')

update spls_rk set jcshl=jcshl+480,jcje=jcje+11076.92 where plh in ('Z0001271339')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')

update wlzhk set ye=ye+12960.00 where djbh in ('JHCYMA00003287','JHCYMA00003666')

update wlzhk set dwbh='EWI00000151' where djbh in ('JHCYMA00003286','JHAYMA00022874')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')

update wlzhk set dwbh='EWI00004202' where djbh in ('JHCYMA00002913','JHAYMA00022875')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update spls_rk set jcshl=jcshl+900,jcje=jcje+769.23 where plh in ('Z0001272546')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update wlzhk set ye=ye+900 where djbh in ('JHBYMA00000149','JHCYMA00003697','JHDYMA00005170','JHCYMA00003514','JHCYMA00003513','JHCYMA00003512','JHCYMA00003511','JHCYMA00003510','JHCYMA00003509','JHCYMA00003508','JHCYMA00003507','JHCYMA00003506','JHCYMA00003505','JHCYMA00003503','JHCYMA00003499','JHCYMA00003497','JHCYMA00003496','JHCYMA00003494','JHCYMA00003493','JHCYMA00003492','JHCYMA00003491','JHCYMA00003490','JHCYMA00003489','JHCYMA00003488','JHCYMA00003487','JHCYMA00003486','JHCYMA00003485','JHCYMA00003484','JHCYMA00003481','JHCYMA00003479','JHCYMA00003478','JHCYMA00003477','JHCYMA00003476','JHCYMA00003475','JHCYMA00003474','JHCYMA00003473','JHCYMA00003472','JHCYMA00003471','JHCYMA00003470','JHCYMA00003462')

update wlzhk set dwbh='EWI00000162' where djbh in ('JHCYMA00002915','JHAYMA00022876')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update spls_rk set jcshl=jcshl+1000,jcje=jcje+10427.35 where plh in ('Z0001270635','Z0001270387')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update wlzhk set ye=ye+12200 where djbh in ('JHCYMA00002864')

update wlzhk set dwbh='EWI00001856' where djbh in ('JHCYMA00002863','JHAYMA00022877')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update wlzhk set dwbh='EWI00001654' where djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update spls_rk set jcshl=jcshl+4680,jcje=jcje+40000 where plh in ('Z0001270483','Z0001270481','Z0001270479','Z0001270477')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update wlzhk set ye=ye+46800 where djbh in ('JHCYMA00002911','JHCYMA00002910','JHCYMA00002909','JHCYMA00002908')

update wlzhk set dwbh='EWI00000109' where djbh in ('JHCYMA00002907','JHAYMA00022879')

本文转自 qvodnet 51CTO博客，原文链接:http://blog.51cto.com/bks2015/1892979