Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/action/ContainerAction.java =================================================================== diff -u -r15180 -r15183 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/action/ContainerAction.java (.../ContainerAction.java) (revision 15180) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/container/action/ContainerAction.java (.../ContainerAction.java) (revision 15183) @@ -114,11 +114,17 @@ if (searchKeyWord != null && searchColumns != null) { //关键字检索执行的函数(cjr) - String searchKeyWord2 = searchKeyWord.equals(TousseInstance.STATUS_STERILING) ? Container.CONTAINER_STATUS_STERILIZING : searchKeyWord; //如果状态是"灭菌中"转成"灭菌"去数据库查找 + String searchKeyWord2 = ""; //界面显示的是"灭菌中",数据库是"灭菌",这里需要处理一下在进行检索 String[] searchColumnArray = searchColumns.split(";"); for (String searchColumn : searchColumnArray) { if ("status".equals(searchColumn)) { - sql += "po." + searchColumn + " like '%" + searchKeyWord2 + "%' or "; + if (searchKeyWord.equals(TousseInstance.STATUS_STERILING) || searchKeyWord.equals("菌中") + || searchKeyWord.equals("中")) { + searchKeyWord2 = Container.CONTAINER_STATUS_STERILIZING; + sql += "po." + searchColumn + "='" + searchKeyWord2 + "' or "; + } else { + sql += "po." + searchColumn + " like '%" + searchKeyWord + "%' or "; + } } else { sql += "po." + searchColumn + " like '%" + searchKeyWord + "%' or "; }