Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java =================================================================== diff -u -r40746 -r40747 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 40746) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 40747) @@ -8065,23 +8065,11 @@ +" cm on cm.cleanMethod=td.cleanMethod " + //可选的清洗程序 " left join "+ TousseDefOptionCleanMethod.class.getSimpleName() - //ancestorID +" tc on tc.tousseDefinitionId=td.ancestorID left join " + CleanMethod.class.getSimpleName() +" cmm on cmm.id=tc.cleanMethodId " + " where 1=1 " + SqlUtils.getInLongListSql("td.id",tousseDefinitionIds); - -/* String sql = "select tc.id cleanType1 ,tc.cleanMethodId cleanType2 from " + - TousseDefinition.class.getSimpleName() + - " td" - + " left join "+ TousseDefOptionCleanMethod.class.getSimpleName() - +" tc on tc.tousseDefinitionId=td.id" - //+ " left join " - //+ CleanMethod.class.getSimpleName() - //+" cmm on cmm.id=tc.cleanMethodId " - + " where 1=1 " - + SqlUtils.getInLongListSql("td.id",tousseDefinitionIds);*/ ResultSet rs = null; try { rs = objectDao.executeSql(sql);