Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r28665 -r28669 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 28665) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 28669) @@ -6460,6 +6460,7 @@ InvoiceQuerySummaryService summaryService = new InvoiceQuerySummaryService(isSummary); //System.out.println("执行sql:" + sql); + logger.debug("发货物品查询:"+sql); ResultSet rs2 = objectDao.executeSql(sql); try { while (rs2.next()) { @@ -6737,6 +6738,7 @@ + ") tl group by monthstr "); ResultSet totalTousseRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表处理器械总件数查询:"+sql); totalTousseRs = objectDao.executeSql(sql); while (totalTousseRs.next()) { Integer totalTousseAmount = totalTousseRs.getInt("amount"); @@ -6756,6 +6758,7 @@ + ") tl group by monthstr "); ResultSet totalForeignTousseRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表处理外来器械总件数查询:"+sql); totalForeignTousseRs = objectDao.executeSql(sql); while (totalForeignTousseRs.next()) { Integer totalForeignTousseAmount = totalForeignTousseRs.getInt("amount"); @@ -6783,6 +6786,7 @@ + ") tl group by monthstr"); ResultSet disinfectionRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表消毒物品数量查询:"+sql); disinfectionRs = objectDao.executeSql(sql); while (disinfectionRs.next()) { Integer disinfectionAmount = disinfectionRs.getInt("amount"); @@ -6804,6 +6808,7 @@ + ") tl group by monthstr"); ResultSet sterileRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表灭菌无菌包数查询:"+sterileSql); sterileRs = objectDao.executeSql(sterileSql); while (sterileRs.next()) { Integer sterilizaAmount = sterileRs.getInt("amount"); @@ -6827,6 +6832,7 @@ ResultSet sterileForeignRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表灭菌外来手术器械包数查询:"+sterileForeignSql); sterileForeignRs = objectDao.executeSql(sterileForeignSql); while (sterileForeignRs.next()) { Integer sterilizaForeignAmount = sterileForeignRs.getInt("amount"); @@ -6854,6 +6860,7 @@ + monthlyStr; ResultSet rs3 = null; try { + logger.debug("年度消毒中心指标工作量统计报表灭菌炉使用次数查询:"+sql3); rs3 = objectDao.executeSql(sql3); while (rs3.next()) { Integer amount5 = rs3.getInt("amount"); @@ -6903,6 +6910,7 @@ + ") tl group by monthStr"); ResultSet tousseInvoiceSendRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表器械包发放数量查询:"+tousseSendSql); tousseInvoiceSendRs = objectDao.executeSql(tousseSendSql); while (tousseInvoiceSendRs.next()) { Integer tousseInvoiceSendAmount = tousseInvoiceSendRs.getInt("amount"); @@ -6924,6 +6932,7 @@ + ") tl group by monthStr"); ResultSet disposableGoodsSendRs = null; try { + logger.debug("年度消毒中心指标工作量统计报表一次性物品发放数量查询:"+disposableGoodsSendSql); disposableGoodsSendRs = objectDao.executeSql(disposableGoodsSendSql); while (disposableGoodsSendRs.next()) { Integer disposableGoodsInvoiceSendAmount = disposableGoodsSendRs.getInt("amount"); @@ -6950,6 +6959,7 @@ + monthlyStr; ResultSet rs7 = null; try { + logger.debug("年度消毒中心指标工作量统计报表腔镜器械查询:"+sql7); rs7 = objectDao.executeSql(sql7); while (rs7.next()) { Integer amount7 = rs7.getInt("amount"); @@ -6991,6 +7001,7 @@ + monthlyStr; ResultSet rs8 = null; try { + logger.debug("年度消毒中心指标工作量统计报表下收下送数量查询:"+sql8); rs8 = objectDao.executeSql(sql8); while (rs8.next()) { Integer amount8 = rs8.getInt("amount"); @@ -11033,7 +11044,7 @@ Map> typeOfChild = new HashMap>(); GoodsOption option = goodsOptionManager.getGoodsOption(GoodsOption.MODEL_TOUSSEWORKLOAD, departCoding); - logger.debug("getTousseWorkLoadData sql...=" + sql); + logger.debug(" 器械包工作量统计报表后台查询sql...=" + sql); //ResultSet result = objectDao.executeSql(sql); try { // 若用户自定义了需要查询的器械包,则根据自定义查询,否则查全部的器械包