Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r28603 -r28605 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 28603) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 28605) @@ -8273,7 +8273,7 @@ + tdTousseTypeWhereSql + ssSterilisationWhereSql + tdTousseGroupWhereName - +" group by ti.tousseName"; + +" and ti.amount > 0 group by ti.tousseName"; ResultSet applicationRs = null; try { logger.debug("运作监控申请查询sql:" + appAndRecyAmountSql); @@ -8419,7 +8419,7 @@ }finally { DatabaseUtil.closeResultSetAndStatement(signRs); } - String useSql = ""; +/* String useSql = ""; String dispoSql = ""; String useRecordDepartCodingWhereSql = SqlUtils.getWhereSqlByfilterFieldAndStringValue("u.departCoding", currentOrgUnitCode); useSql = String.format(" select ti.tousseName tousseName ,count(0) amount from userecord u " @@ -8463,7 +8463,7 @@ }finally { DatabaseUtil.closeResultSetAndStatement(useRs); } - } + }*/ return listArr.toString(); } /**