Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java =================================================================== diff -u -r38406 -r38407 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 38406) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 38407) @@ -856,15 +856,14 @@ StringBuffer countSql = new StringBuffer(); countSql.append("select count(*) from "); countSql.append(HttpOption.class.getSimpleName()); - countSql.append(" po where 1=1 "); - if(DatabaseUtil.isPoIdValid(httpOption.getId())){ - countSql.append(" and po.id<>").append(httpOption.getId()); - } - countSql.append(" and po.optionListId='"); + countSql.append(" po where po.optionListId='"); countSql.append(httpOption.getOptionListId()); countSql.append("' and po.optionText='"); countSql.append(httpOption.getOptionText()); countSql.append("'"); + if(DatabaseUtil.isPoIdValid(httpOption.getId())){ + countSql.append(" and po.id<>").append(httpOption.getId()); + } int count = objectDao.countBySql(countSql.toString()); if(count > 0){ throw new SystemException(httpOption.getOptionText()+"已存在,不可重复添加");