机构和区域优化

linwei

2026-01-27 150c3d0b972f93869b6180f59ce03f46774dbe06

机构和区域优化

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/DeptMapper.xml

@@ -287,8 +287,8 @@
        <if test="param2.deptName!=null and param2.deptName!=''">
            and bd.dept_name like concat(concat('%', #{param2.deptName}),'%')
        </if>
        <if test="param2.fullName!=null and param2.fullName!=''">
            and bd.full_name like concat(concat('%', #{param2.fullName}),'%')
        <if test="param2.areaCode!=null and param2.areaCode!=''">
            and bd.area_code like concat(concat('%', #{param2.areaCode}),'%')
        </if>
        <if test="param2.deptCode!=null and param2.deptCode!=''">
            and bd.dept_code = #{param2.deptCode}

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/RegionMapper.xml

@@ -118,6 +118,7 @@
        FROM blade_region
        where length(parent_code) &lt; 12 limit 0,#{size}
    </select>

    <select id="selectRegionPage" resultType="org.sxkj.system.vo.RegionVO">
        SELECT
            id,