Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java =================================================================== diff -u -r28664 -r28828 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java (.../SterilizationRecordManagerImpl.java) (revision 28664) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java (.../SterilizationRecordManagerImpl.java) (revision 28828) @@ -1248,7 +1248,6 @@ ResultSet rs = null; try{ int c1 = 0; - int c2 = 0; String sql = "select max(sr.cycleCounter) from sterilizationrecord sr" + " where sr.sterilizer_id = " + sterilizer.getId() @@ -1257,16 +1256,7 @@ if (rs != null && rs.next()) { c1 = (int) rs.getLong(1) + 1; } - sql = "select max(sr.cycleCounter) from sterilizerrecord sr" - + " where sr.machineNo = '" - + sterilizer.getMachineNumber() - + "' and sr.deviceInterfaceID = '" - + sterilizer.getDeviceInterfaceId() + "'"; - rs = objectDao.executeSql(sql); - if (rs != null && rs.next()) { - c2 = (int) rs.getLong(1) + 1; - } - return Math.max(c1, c2); + return c1; }catch(Exception e) { e.printStackTrace();