Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r17203 -r17227 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 17203) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 17227) @@ -2736,6 +2736,7 @@ .getSimpleName(), "name", ti.getSterilizerName()); if(ser != null && "是".equals(ser.getIsRoutineMonitoring())){ String sql = "select qi.name from QualityMonitoringInstance qi,Sterilizer ser where qi.sterilizerName = ser.name and ser.isRoutineMonitoring = '是' " + + " and qi.type = '定期监测' " + " and qi.sterilizerDate = '" + sterilizerDate + "'" + " and qi.sterilizerName = '" + ti.getSterilizerName() + "'" + " and qi.sterilizerFrequency = '" + ti.getSterileFrequency() + "'";