Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql
===================================================================
diff -u -r37566 -r37570
--- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql	(.../5.0.20_5.0.21.sql)	(revision 37566)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.20_5.0.21.sql	(.../5.0.20_5.0.21.sql)	(revision 37570)
@@ -15,4 +15,21 @@
 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
+);
+update InvoiceItem set settlementPrice=(
+select sum(price) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null
+), settlementDiscountPrice =(
+select sum(settlementDiscountPrice ) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null
+)
+where settlementPrice<>(
+select sum(price) from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null
+)
+and exists (
+select 1 from TousseInstance ti where ti.invoice_id=InvoiceItem.invoice_id and ti.tousseDefinition_id=InvoiceItem.tousseDefinitionId and ti.comboTousseInstanceId is not null
+);
+update Invoice set totalPrice=(
+select sum(settlementPrice) from InvoiceItem where invoice_id=Invoice.id
+)
+where totalPrice<>(
+select sum(settlementPrice) from InvoiceItem where invoice_id=Invoice.id
+);
\ No newline at end of file