森林防火 供应商管理

rentaiming

2024-07-01 4ac7a80816405d4fd37739a2eae231a84927945d

森林防火 供应商管理

 ruoyi-modules/ruoyi-management/target/classes/mapper/management/SlRegionMapper.xml

New file
@@ -0,0 +1,23 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.rouyi.management.mapper.SlRegionMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SlRegion">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="code" property="code" />
        <result column="citycode" property="citycode" />
        <result column="parent_id" property="parentId" />
        <result column="english" property="english" />
        <result column="level" property="level" />
        <result column="hierarchy" property="hierarchy" />
        <result column="all_name" property="allName" />
    </resultMap>

    <select id="listRegionVo" resultType="com.ruoyi.management.domain.vo.RegionVo">
        SELECT tr.id id, tr.parent_id parentId, tr.level level, tr.code value, tr.name label
        FROM t_region tr
    </select>

</mapper>