Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql =================================================================== diff -u -r37551 -r37564 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37551) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql (.../5.0.20_5.0.21.sql) (revision 37564) @@ -1,4 +1,15 @@ update TousseInstance set returnGoodsItem_ID=(select max(returnGoodsItem_ID) from TousseInstance t where comboTousseInstanceId=TousseInstance.id) where returnGoodsItem_ID is null and exists ( select 1 from TousseInstance t where t.comboTousseInstanceId=TousseInstance.id and t.returnGoodsItem_ID is not null +); +update TousseInstance set price=( +select td.price from TousseDefinition td where id=TousseInstance.tousseDefinition_id +), + discountPrice=( +select td.discountPrice from TousseDefinition td where id=TousseInstance.tousseDefinition_id +) +where comboTousseInstanceId is not null and price<>( +select td.price from TousseDefinition td where id=TousseInstance.tousseDefinition_id +) and not exists ( +select 1 from Sterilizer s join sterilizationRecord sr on sr.sterilizer_id=s.id where rapidFurnace='是' and sr.id=TousseInstance.id ); \ No newline at end of file