<?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.bonus.material.basic.mapper.BmUnitTypeMapper">
    <resultMap type="com.bonus.material.basic.domain.BmUnitType" id="BmUnitTypeResult">
        <id     property="dictCode"   column="dict_code"   />
        <result property="dictSort"   column="dict_sort"   />
        <result property="dictLabel"  column="dict_label"  />
        <result property="dictValue"  column="dict_value"  />
        <result property="dictType"   column="dict_type"   />
        <result property="status"     column="status"      />
        <result property="createTime" column="create_time" />
        <result property="remark" column="remark" />
    </resultMap>


    <select id="selectBmUnitTypeDataList" parameterType="com.bonus.material.basic.domain.BmUnitType" resultMap="BmUnitTypeResult">
        select dict_code, dict_sort, dict_label, dict_value, dict_type, status, create_time, remark
        from sys_dict_data
        <where>
            <if test="dictType != null and dictType != ''">
                AND dict_type = #{dictType}
            </if>
            <if test="dictLabel != null and dictLabel != ''">
                AND dict_label like concat('%', #{dictLabel}, '%')
            </if>
        </where>
        order by dict_sort asc
    </select>

</mapper>