Index: ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java =================================================================== diff -u -r34022 -r34083 --- ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 34022) +++ ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 34083) @@ -3377,11 +3377,11 @@ String sql = String.format("select count(*) from %s td " + "join %s mi on mi.tousse_id = td.id " - + "join %s md on md.id = mi.materialDefinition_id where md.isImplant= '%s' and td.id = %s", + + "join %s md on md.id = mi.materialDefinition_id where (md.isImplant <> '%s' or md.isImplant is null) and td.id = %s", TousseDefinition.class.getSimpleName(), MaterialInstance.class.getSimpleName(), MaterialDefinition.class.getSimpleName(), - Constants.STR_NO, + Constants.STR_YES, tousseDefinitionId); int unImplantCont = objectDao.countBySql(sql); if(unImplantCont > 0){