Index: ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java =================================================================== diff -u -r20845 -r20861 --- ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java (.../ExpensiveGoodsManagerImpl.java) (revision 20845) +++ ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java (.../ExpensiveGoodsManagerImpl.java) (revision 20861) @@ -1884,14 +1884,14 @@ @Override public List getExpensiveGoodsByKeyword(String keyword) { - String hql = "where 1=1 "; + String hql = "where 1=1 and isApplicationMaterial='" + Constants.STR_CAN + "' "; if (StringUtils.isNotBlank(keyword)) { keyword = keyword.trim(); Matcher matcher = Pattern.compile("[\\u4E00-\\u9FA5]+").matcher(keyword); String searchMode = AcegiHelper.getLoginUser().getSearchMode(); if (matcher.find()) { hql += " and (spelling like '%" + keyword + "%' or wbCode like '%" - + keyword + "%' or externalCode like '" + keyword + + keyword + "%' or externalCode like '%" + keyword + "%' or po.name like '%" + keyword + "%')"; } else { keyword = keyword.toUpperCase();