<select id="selectDeptLevelList" resultType="com.ruoyi.common.core.domain.entity.SysDept">
<include refid="selectDeptVo"/>
WHERE (LENGTH(ancestors) - LENGTH(REPLACE (ancestors, ',', ''))) = #{level}
and d.del_flag = '0'
</select>
若依 获取3级部门
最新推荐文章于 2024-07-07 11:40:38 发布