<?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.unis.crk.business.qcrk.mapper.DataCrkywTzdxxFlt001Mapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.unis.crk.business.qcrk.entity.DataCrkywTzdxxFlt001">
        <id column="DataID" property="DataID"/>
        <result column="UnitID" property="UnitID"/>
        <result column="PeriodID" property="PeriodID"/>
        <result column="RoundID" property="RoundID"/>
        <result column="ModifyDate" property="ModifyDate"/>
        <result column="builder" property="builder"/>
        <result column="UPDATE_TIME" property="updateTime"/>
        <result column="DeptID" property="DeptID"/>
        <result column="SytelInfoID" property="SytelInfoID"/>
        <result column="BuildDate" property="BuildDate"/>
        <result column="editor" property="editor"/>
        <result column="MainDataID" property="MainDataID"/>
        <result column="ch" property="ch"/>
        <result column="chmc" property="chmc"/>
        <result column="hwf" property="hwf"/>
        <result column="hwhmc" property="hwhmc"/>
        <result column="nrsl" property="nrsl"/>
        <result column="sjsl" property="sjsl"/>
        <result column="hlbs" property="hlbs"/>
        <result column="sjcksj" property="sjcksj"/>
    </resultMap>

    <select id="selectMyMapsPage" resultType="java.util.Map">
        SELECT * FROM data_crkyw_tzdxx_flt_001
        <if test="ew.sqlSegment != null and ew.sqlSegment != ''">
            where ${ew.sqlSegment}
        </if>
    </select>
    <select id="getLitByMainDatId" resultType="java.util.Map">
       SELECT
	a.hwf AS "hwf",
	a.ch AS "ch",
	a.sjcksj AS "sjcksj",
	a.hwhmc AS "hwhmc",
	a.nrsl AS "nrsl",
	a.chmc AS "chmc",
	a.sjsl AS "sjsl",
	a.MainDataId as "maindataID",
	a.DataID as "dataID"
FROM
	DATA_CRKYW_TZDXX_FLT_001 a
WHERE
	 a.MainDataId = #{mainDataId}
    </select>
</mapper>