Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r30233 -r30234 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 30233) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 30234) @@ -16360,8 +16360,8 @@ String materialSql = ""; String tousseSql = ""; if( StringUtils.isNotBlank(materialName)){ - // 如果字符串中有"[",进行转译 - if(materialName.contains("[")){ + // 如果字符串中有"[",SqlServer需要转译 + if(materialName.contains("[") && dbConnection.isSqlServer()){ int index = materialName.indexOf("["); materialName = materialName.substring(0, index) + "\\" + materialName.substring(index, materialName.length()); materialSql = " qmd.material like '%" + materialName + "%'" + " escape '\\' "; @@ -16370,8 +16370,8 @@ } } if( StringUtils.isNotBlank(tousseName)){ - // 如果字符串中有"[",进行转译 - if(tousseName.contains("[")){ + // 如果字符串中有"[",SqlServer需要转译 + if(tousseName.contains("[") && dbConnection.isSqlServer()){ int index = tousseName.indexOf("["); tousseName = tousseName.substring(0, index) + "\\" + tousseName.substring(index, materialName.length()); tousseSql = " qmd.tousseName like '%" + tousseName + "%'" + " escape '\\' ";