Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r14275 -r14322 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14275) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14322) @@ -4520,8 +4520,10 @@ String name = goodsName.substring(0, _index); String invoiceplan_id = goodsName.substring( _index + 1, goodsName.length()); - disinfectGoodsStatisticAmount = getDisinfectGoodsStatisticAmount( + if (DatabaseUtil.isPoIdValid(invoiceplan_id)) { + disinfectGoodsStatisticAmount = getDisinfectGoodsStatisticAmount( name, invoiceplan_id); + } } } if (disinfectGoodsStatisticAmount > 0){ @@ -4605,14 +4607,14 @@ private int getDisinfectGoodsStatisticAmount(String disinfectGoodsName,String invoicePlanID) { int statisticsAmount = 0; - + if(StringUtils.isBlank(invoicePlanID)){ + return statisticsAmount; + } String sql = "select sum(i.count) from Toussedefinition t,MaterialInstance i " + "where t.id = i.tousse_id and t.name = '" + disinfectGoodsName + "'"; - if(StringUtils.isNotBlank(invoicePlanID)){ - sql += " and t.invoicePlanID = " + invoicePlanID; - } + sql += " and t.invoicePlanID = " + invoicePlanID; ResultSet rs = objectDao.executeSql(sql); if(rs != null){