查询
List<EvaluationDTO> getSpotCheckUserIdArray(@Param("spotCHeckUser") String[] spotCHeckUser); <select id="getSpotCheckUserIdArray" resultType="com.hyzs.szzf.lawcase.core.dto.EvaluationDTO"> <foreach collection="spotCHeckUser" item="userId" index="index" open="" separator=" union " close=""> ( SELECT DISTINCT u.id userId, u.user_name userName, area.`code` areaCode, concat(area.`name`,"执法队") areaCodeName, area.pcode parentAreaCode, u.user_account evaluationUserAccount FROM zw_tibmas2.`user` u, zw_tibmas2.`user_role` ur, zw_tibmas2.`role` r, zw_tibmas2.`dept` d, zw_tibmas2.`area` area WHERE u.id = ur.user_id AND u.id = #{userId} AND ur.role_id = r.id AND d.id = u.dept_id AND area.id = d.area_id AND u.is_deleted=0 AND ur.is_deleted=0 AND r.is_deleted=0 AND d.is_deleted=0 AND area.is_deleted=0 ) </foreach> </select>删除
<delete id="deleteUserByList"> delete from user where id in <foreach collection="spotCHeckUser" open="(" separator="," close=")" item="userId"> #{userId} </foreach> </delete>
