Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java =================================================================== diff -u -r16628 -r16630 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java (.../ReAppTableSqlHandler.java) (revision 16628) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/ReAppTableSqlHandler.java (.../ReAppTableSqlHandler.java) (revision 16630) @@ -60,7 +60,7 @@ public void createTousseGroupFilterSql(Map sqlWhereParamMap, StringBuilder sqlBuilder) { String tousseGroupId = sqlWhereParamMap.get("tousseGroupId"); if (!"all".equals(tousseGroupId)) { - sqlBuilder.append(String.format(" and (po.id in (select ti.invoicePlan.id from TousseItem ti,TousseDefinition td,TousseGroup tg where ti.tousseDefinitionId = td.id and td.tousseGroupID = tg.id and tg.id = %s and ti.diposable = '否'))", tousseGroupId)); + sqlBuilder.append(String.format(" and (po.id in (select ti.invoicePlan.id from TousseItem ti,TousseDefinition td,TousseGroup tg where ti.tousseDefinitionId = td.id and td.tousseGroupID = tg.id and tg.id = %s and ti.tousseType = '器械包'))", tousseGroupId)); } }