首页 > 代码库 > 20170118修改商品流水

20170118修改商品流水

备份表 fr_spls_rkbak20170118  fr_wlzhkkbak20170118


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‘)


20170118修改商品流水