Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.6.6_4.6.7.sql
===================================================================
diff -u -r17114 -r17139
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.6.6_4.6.7.sql	(.../4.6.6_4.6.7.sql)	(revision 17114)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.6.6_4.6.7.sql	(.../4.6.6_4.6.7.sql)	(revision 17139)
@@ -3,9 +3,9 @@
 	select sr.id from SterilizationRecord sr,TousseInstance ti where ti.sterilizationRecord_id=sr.id
 	and (sr.biologyResult is null or sr.biologyResult<>'不合格')
 	and (sr.biologicalMonitoringStartDate is null or sr.biologicalMonitoringEndDate<ti.invoiceSendTime)
-);
+) and (isRoutine is null or isRoutine<>'是');
 update TousseInstance set isRoutine='否' where invoice_id is not null
 and sterilizationRecord_id in (
 	select sr.id from SterilizationRecord sr,TousseInstance ti where ti.sterilizationRecord_id=sr.id
 	and (sr.biologicalMonitoringEndDate>ti.invoiceSendTime or sr.biologyResult='不合格')
-);
\ No newline at end of file
+) and (isRoutine is null or isRoutine<>'否');
\ No newline at end of file