<?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.lframework.xingyun.template.inner.mappers.system.SysDeptMapper">

    <sql id="SysDeptDto_sql">
        SELECT
            *
        FROM sys_dept
    </sql>

    <select id="selector" resultType="com.lframework.xingyun.template.inner.entity.SysDept">
        <include refid="SysDeptDto_sql"/>
        ORDER BY code
    </select>
    <select id="findById" resultType="com.lframework.xingyun.template.inner.entity.SysDept">
        <include refid="SysDeptDto_sql"/>
        WHERE id = #{id}
    </select>
</mapper>
