Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r33041 -r33043 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33041) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 33043) @@ -7792,7 +7792,7 @@ } ResultSet sterilizationRecordCountRs = null; try { - String monthStr = dateQueryAdapter.dateConverAdapter3("sr.startDate","mm"); + String monthStr = dateQueryAdapter.dateConverAdapter3("sr.biologicalMonitoringEndDate","mm"); String sterilizationRecordCountSql = "select count(*) count,"+ monthStr +" monthStr from "+ SterilizationRecord.class.getSimpleName() +" sr where sr.biologyResult in('合格','不合格') and sr.orgUnitCoding='"+ querySupplyRoom +"' and sr.biologicalMonitoringEndDate between " + startDay +" and " +endDay + " group by " + monthStr; logger.debug("年度消毒中心指标工作量统计灭菌记录中的生物监测结果为合格和不合格的灭菌记录的条数查询:"+ sterilizationRecordCountSql); sterilizationRecordCountRs = objectDao.executeSql(sterilizationRecordCountSql);