Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r27346 -r27354 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 27346) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 27354) @@ -2370,9 +2370,9 @@ String endMonth, String departCoding, String goodsName) { goodsName = "3M环氧乙烷灭菌包内指示卡"; String startMonthSql = "where "+dateQueryAdapter.dateConverAdapter("po.invoice.sendTime","yyyy-mm")+" like '" - + startMonth + "%' and po.name = '" + goodsName + SqlUtils.get_InSql_Extra("po.invoice.orgUnitCoding", departCoding); + + startMonth + "%' and po.name = '" + goodsName + "'" + SqlUtils.get_InSql_Extra("po.invoice.orgUnitCoding", departCoding); String endMonthSql = "where "+dateQueryAdapter.dateConverAdapter("po.invoice.sendTime","yyyy-mm")+" like '" - + endMonth + "%' and po.name = '" + goodsName + SqlUtils.get_InSql_Extra("po.invoice.orgUnitCoding", departCoding); + + endMonth + "%' and po.name = '" + goodsName + "'" + SqlUtils.get_InSql_Extra("po.invoice.orgUnitCoding", departCoding); @SuppressWarnings("unchecked") List startMonthGoodsItemList = objectDao.findBySql( DiposableGoodsItem.class.getSimpleName(), startMonthSql);