Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java =================================================================== diff -u -r16519 -r16611 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java (.../SupplyRoomConfigManagerImpl.java) (revision 16519) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/basedatamanager/supplyroomconfig/service/SupplyRoomConfigManagerImpl.java (.../SupplyRoomConfigManagerImpl.java) (revision 16611) @@ -338,9 +338,9 @@ */ @Override public Integer getOrgUnitSequence(String departCoding) { - String sql = "where po.supplyRoomType = '" + String sql = "where po.supplyRoomType = " + SupplyRoomConfig.SUPPLYROOM_TYPE_3 - + "' and po.orgUnitCoding = '" + departCoding + "'"; + + " and po.orgUnitCoding = '" + departCoding + "'"; SupplyRoomConfig config = (SupplyRoomConfig) objectDao.getBySql( SupplyRoomConfig.class.getSimpleName(), sql); if (config != null) {