Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java =================================================================== diff -u -r37734 -r37735 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 37734) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 37735) @@ -419,11 +419,11 @@ //通过在器械包下拉里输入但未从下拉选项选中的物品名称(采用模糊匹配) String tousseNameFuzzy = sqlWhereParamMap.get("tousseNameFuzzy"); if (StringUtils.isNotBlank(tousseName)) { - String tousseNameFuzzySql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("po.tousseName", tousseName, ";"); - sqlBuilder.append(tousseNameFuzzySql); + sqlBuilder.append(" AND po.tousseName = '" + tousseName + "'"); }else if (StringUtils.isNotBlank(tousseNameFuzzy)) { - String tousseNameFuzzySql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparator("po.tousseName", tousseNameFuzzy, ";"); - sqlBuilder.append(tousseNameFuzzySql); + String tousseNameFuzzySql = String.format("select distinct po.name from %s po where po.name like '%" + tousseNameFuzzy + "%'", TousseDefinition.class.getSimpleName()); + List idList = objectDao.findByHql(tousseNameFuzzySql); + sqlBuilder.append(" and " + SqlUtils.getStringFieldInLargeCollectionsPredicate("po.tousseName", idList)); } //器械包状态 String tousseStatus = sqlWhereParamMap.get("tousseStatus");