Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/action/RecyclingApplicationAction.java =================================================================== diff -u -r32217 -r33473 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/action/RecyclingApplicationAction.java (.../RecyclingApplicationAction.java) (revision 32217) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/action/RecyclingApplicationAction.java (.../RecyclingApplicationAction.java) (revision 33473) @@ -765,7 +765,7 @@ , TousseDefinition.class.getSimpleName() , ImageFile.IMAGE_TYPE_TOUSSEINSTANCE_CAMERA_PACKING , ImageFile.IMAGE_TYPE_CAMERA_PACKING - , SqlUtils.getNonStringFieldInLargeCollectionsPredicate("v.objectId", tousseInstanceIds)); + , SqlUtils.getNonStringFieldInLargeCollectionsPredicate("i.objectId", tousseInstanceIds)); ResultSet rs3 = null; try { rs3 = objectDao.executeSql(sql); @@ -778,7 +778,7 @@ DatabaseUtil.closeResultSetAndStatement(rs3); } //查装配视频 - sql = String.format("select case when td.parentID is not null then td.parentID else td.id end tousseDefinitionId from %s i join %s ti on ti.id=i.objectId join %s td on td.id=ti.tousseDefinition_id where i.videoType='%s' and %s " + sql = String.format("select case when td.parentID is not null then td.parentID else td.id end tousseDefinitionId from %s v join %s ti on ti.id=v.objectId join %s td on td.id=ti.tousseDefinition_id where v.videoType='%s' and %s " , VideoFile.class.getSimpleName() , TousseInstance.class.getSimpleName() , TousseDefinition.class.getSimpleName()