货位数量为负数的数量调整

update hwsp set hwshl=128-128,hwje=1526.29-1526.26 where spid='SPH00000609' and hw='HWI00000003'

update hwsp set hwshl=-40+128,hwje=-478.64+1526.26 where spid='SPH00000609' and hw='HWI00000025'

update hwsp set hwshl=120-120,hwje=2784.61-2784.61 where spid='SPH00003344' and hw='HWI00000002'

update hwsp set hwshl=1+120,hwje=23.19+2784.61 where spid='SPH00003344' and hw='HWI00000025'

update sphwph set hw='HWI00000025' where spid='SPH00003344' and pici='JHAYMA00019351_1'  and hw='HWI00000002'

  update hwsp set hwshl=1+3600,hwje=10.22+36830.78 where spid='SPH00006562' and hw='HWI00000025'

  update hwsp set hwshl=3600-3600,hwje=36830.78-36830.78  where spid='SPH00006562' and hw='HWI00000030'

转载于:https://blog.51cto.com/bks2015/1924250