| | |
|---|
| | | |
|---|
| | | --客户信用 |
|---|
| | | RENAME TABLE D_CREDIT TO D_INTOU_CREDIT; |
|---|
| | | |
|---|
| | | |
|---|
| | | -- 升级仓房状态 1=空仓、2=入库中、3=满仓、4=出库中、9=其他 、31气调中、32熏蒸中、33通风中 34温控中 |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; |
|---|
| | | UPDATE D_DEPOT SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; |
|---|
| | | |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '1' WHERE DEPOT_STATUS_ ='01'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '2' WHERE DEPOT_STATUS_ ='03'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '3' WHERE DEPOT_STATUS_ ='02'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '4' WHERE DEPOT_STATUS_ ='04'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '31' WHERE DEPOT_STATUS_ ='05'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '32' WHERE DEPOT_STATUS_ ='06'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07'; |
|---|
| | | UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09'; |
|---|
| | | |
|---|
