Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java =================================================================== diff -u -r37189 -r37190 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java (.../YearWorkloadReportHelper.java) (revision 37189) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java (.../YearWorkloadReportHelper.java) (revision 37190) @@ -155,7 +155,7 @@ Map endoscopicMap = new HashMap();//内窥镜map Map nextSendAmountMap = new HashMap();//下收下送map Map manualWashAmountMap = new HashMap();//器械手工清洗总件数map - Map rinserTotalUseAmountMap = new HashMap();//灭菌炉使用次数map + Map rinserTotalUseAmountMap = new HashMap();//清洗机使用次数map SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); Map amountTotalMap = new HashMap(); @@ -199,7 +199,7 @@ } if(dataIndexSources.contains("器械手工清洗件数")){ // 处理器械总件数 - params.extraQuery= " and wr.rinserId in (select id from Rinser where isManualClean='是') and wr.endDate is not null "; + params.extraQuery= " and wr.rinserId in (select id from Rinser where isManualClean='是') "; sql = String.format("select sum(tl.amount) amount, monthstr from (" +dataIndex.getWorkAmountByMaterialSQL("清洗数量", params, dataSoureOfMaterialsCountOfToussesInReports) + ") tl group by monthstr "); @@ -537,7 +537,7 @@ + " monthStr from "+ WashAndDisinfectRecord.class.getSimpleName() +" wr " + " where wr.orgUnitCoding='" + querySupplyRoom + "' " + " and wr.startDate between " + startDay + " and " + endDay - + " and wr.rinserId not in (select id from Rinser where isManualClean='是' ) group by " + + " and wr.rinserId not in (select id from Rinser where isManualClean='是' ) and wr.endDate is not null group by " + monthlyStr; ResultSet rs = null; try {