Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_sqlserver.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_sqlserver.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_sqlserver.sql (revision 22739) @@ -0,0 +1,2 @@ +update TousseInstance set virtualBasketSeqNum = '0' + virtualBasketSeqNum + where status in ('已装配','已审核','已灭菌') and virtualBasketSeqNum is not null and len(virtualBasketSeqNum) = 3; \ No newline at end of file Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_oracle.sql =================================================================== diff -u --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_oracle.sql (revision 0) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.14_4.9.15_oracle.sql (revision 22739) @@ -0,0 +1,2 @@ +update TousseInstance set virtualBasketSeqNum = '0' || virtualBasketSeqNum + where status in ('已装配','已审核','已灭菌') and virtualBasketSeqNum is not null and length(virtualBasketSeqNum) = 3; \ No newline at end of file