Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r17937 -r17946 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 17937) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 17946) @@ -1934,7 +1934,7 @@ } //查询灭菌时放入灭菌筐的器械包,过滤掉“已经废弃但是还未做灭菌的器械包实例” String sqlToCountTousseInReviewedBasket = " select po.tousseName ,count(*) amount from tousseinstance po where reviewbasket_id in(select reviewedbasket_id from sterilization_reviewed where sterilizationrecord_id="+sterilizationRecord.getId()+") " - + "and (status <> '已废弃' or (status='已废弃' and sterilizationRecord_id is not null)) group by po.tousseName "; + + "and (status <> '" + TousseInstance.STATUS_DISCARD + "' or (status='" + TousseInstance.STATUS_DISCARD + "' and sterilizationRecord_id is not null)) group by po.tousseName "; ResultSet rs2 = objectDao.executeSql(sqlToCountTousseInReviewedBasket); try { while(rs2.next()){