57 lines
1.9 KiB
MySQL
57 lines
1.9 KiB
MySQL
|
|
|||
|
|
go
|
|||
|
|
update kwjbxx set ˫<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD>л<EFBFBD>=0,hdh=1,
|
|||
|
|
|
|||
|
|
wckw = CASE
|
|||
|
|
WHEN (0+pai)=1
|
|||
|
|
THEN '02'
|
|||
|
|
END
|
|||
|
|
+ lie + CASE
|
|||
|
|
WHEN ceng=1
|
|||
|
|
THEN '01'
|
|||
|
|
WHEN ceng=2
|
|||
|
|
THEN '02'
|
|||
|
|
WHEN ceng=3
|
|||
|
|
THEN '03'
|
|||
|
|
WHEN ceng=4
|
|||
|
|
THEN '04'
|
|||
|
|
WHEN ceng=5
|
|||
|
|
THEN '05'
|
|||
|
|
WHEN ceng=6
|
|||
|
|
THEN '06'
|
|||
|
|
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
where
|
|||
|
|
xnkw = 0 and pai =1; -- <20>趨<EFBFBD><E8B6A8><EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ
|
|||
|
|
|
|||
|
|
update kwjbxx set ˫<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD>л<EFBFBD>=0,hdh=1,
|
|||
|
|
nckw = CASE
|
|||
|
|
WHEN (0+pai)=2
|
|||
|
|
THEN '01'
|
|||
|
|
END
|
|||
|
|
+ lie + CASE
|
|||
|
|
WHEN ceng=1
|
|||
|
|
THEN '01'
|
|||
|
|
WHEN ceng=2
|
|||
|
|
THEN '02'
|
|||
|
|
WHEN ceng=3
|
|||
|
|
THEN '03'
|
|||
|
|
WHEN ceng=4
|
|||
|
|
THEN '04'
|
|||
|
|
WHEN ceng=5
|
|||
|
|
THEN '05'
|
|||
|
|
WHEN ceng=6
|
|||
|
|
THEN '06'
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
where
|
|||
|
|
xnkw = 0 and pai =2; -- <20>趨<EFBFBD>ڲ<EFBFBD><DAB2><EFBFBD>λ
|
|||
|
|
|
|||
|
|
|
|||
|
|
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ת<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><EFBFBD><EFBFBD>ſ<EFBFBD>λ<EFBFBD><EFBFBD>˳<EFBFBD><EFBFBD>Ϊ<EFBFBD>Ѷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1-4<EFBFBD>Ű<EFBFBD><EFBFBD>ź<EFBFBD><EFBFBD>ڰ<EFBFBD><EFBFBD><EFBFBD>5-8
|
|||
|
|
--update kwjbxx set storeDist = 1718000 * 4 + storeDist where xnkw = 0 and pai IN('05','06', '07', '08');
|
|||
|
|
--update kwjbxx set storeDist = 1718000 * 4 + storeDist where xnkw = 0 and pai IN('13','14', '15', '16');
|
|||
|
|
-- update kwjbxx set storeDist = 1718000 * 4 + storeDist where xnkw = 0 and pai IN('21','22', '23', '24');
|
|||
|
|
-- update kwjbxx set storeDist = 1718000 * 4 + storeDist where xnkw = 0 and pai IN('29','30', '31', '32');
|