Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r34016 -r34031 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34016) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 34031) @@ -8687,10 +8687,9 @@ orgUnitCoding + "' " + getInstrumentSetTypeSql("临床各类包","in"); - //统计处理科室为【大院供应室】灭菌炉分组为【低温灭菌炉】的灭菌处理器械包种类为【EO包】的【包数】X 1 + //统计处理科室为【大院供应室】灭菌炉分组为【低温灭菌炉】的【包数】X 1 sql += " union all "; - params.extraQuery = " and sr.sterilizer_id in(select id from Sterilizer where ownGroup='低温灭菌炉') " - + getInstrumentSetTypeSql("EO包", "in"); + params.extraQuery = " and sr.sterilizer_id in(select id from Sterilizer where ownGroup='低温灭菌炉') "; //灭菌记录 sql += String.format(" select 3 orderNumber, '临床各类包' firstColumnName ,'⑧EO包' secondColumnName,sum(tl.amount) amount from (" +dataIndex.getWorkAmountByPackageSQL("灭菌数量", params)