Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.82_4.9.83.sql =================================================================== diff -u -r32519 -r32521 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.82_4.9.83.sql (.../4.9.82_4.9.83.sql) (revision 32519) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.82_4.9.83.sql (.../4.9.82_4.9.83.sql) (revision 32521) @@ -1 +1 @@ -update TousseItem set price=(select price from TousseDefinition where id=TousseItem.tousseDefinitionId),rowPrice=(select price from TousseDefinition where id=TousseItem.tousseDefinitionId) * ( case when amount is null or amount=0 then 1 else amount end) where price<>(select price from TousseDefinition where id=TousseItem.tousseDefinitionId) and tousseDefinitionId in (select id from TousseDefinition where toussetype='消毒物品' and isApplyEntireTousse='是'); \ No newline at end of file +update TousseItem set price=(select price from TousseDefinition where id=TousseItem.tousseDefinitionId),rowPrice=(select price from TousseDefinition where id=TousseItem.tousseDefinitionId) * ( case when amount is null or amount=0 then 1 else amount end) where price<>(select price from TousseDefinition where id=TousseItem.tousseDefinitionId) and tousseDefinitionId in (select id from TousseDefinition where toussetype='消毒物品' and (isApplyEntireTousse='否' or isApplyEntireTousse is null)); \ No newline at end of file