Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java =================================================================== diff -u -r14524 -r14527 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 14524) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java (.../JasperreportsAction.java) (revision 14527) @@ -1937,9 +1937,24 @@ + " and po.orgUnitCoding = '" + querySupplyRoom + "'"; if( StringUtils.isNotBlank(materialName)){ - sql += " and po.material like '%" + materialName + "%'"; + // 如果字符串中有"[",进行转译 + if(materialName.contains("[")){ + int index = materialName.indexOf("["); + materialName = materialName.substring(0, index) + "\\" + materialName.substring(index, materialName.length()); + sql += " and po.material like '%" + materialName + "%'" + " escape '\\' "; + }else{ + sql += " and po.material like '%" + materialName + "%'"; + } } if( StringUtils.isNotBlank(tousseName)){ + // 如果字符串中有"[",进行转译 + if(tousseName.contains("[")){ + int index = tousseName.indexOf("["); + tousseName = tousseName.substring(0, index) + "\\" + tousseName.substring(index, materialName.length()); + sql += " and po.tousseName like '%" + tousseName + "%'" + " escape '\\' "; + }else{ + sql += " and po.tousseName like '%" + tousseName + "%'"; + } sql += " and po.tousseName like '%" + tousseName + "%'"; } // 根据材料名称排序