Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java =================================================================== diff -u -r37803 -r37805 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 37803) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 37805) @@ -297,7 +297,7 @@ String sterilizerNameSql = ""; if(CssdUtils.isProject("gdsy")){ //gdsy有聚力康推送的包实例,没有灭菌记录,只能通过灭菌炉名称过滤 - sterilizerNameSql = " or (po.sterilizationRecord_id is null and po.sterilizerName = '%s') "; + sterilizerNameSql = String.format(" or (po.sterilizationRecord_id is null and po.sterilizerName = '%s') ", sterilizerName); } sqlBuilder.append(String.format(" AND (po.sterilizationRecord_id in (select sr.id from %s sr where sr.sterilizer.id = %s) %s) ", SterilizationRecord.class.getSimpleName(),