fj-dc/.svn/pristine/a8/a8cd801ff4ba1da90d17c295f8dac2223f06e1a6.svn-base

<?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="cn.com.goldenwater.dcproj.dao.BisInspRsvrynRgstrChkInfoDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspRsvrynRgstrChkInfo" id="bisInspRsvrynRgstrChkInfoResultMap">
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="inspYear" column="INSP_YEAR"/>
        <result property="wcEvltOld" column="WC_EVLT_OLD"/>
        <result property="wcEvltNow" column="WC_EVLT_NOW"/>
        <result property="mshTmp" column="MSH_TMP"/>
        <result property="chkType" column="CHK_TYPE"/>
        <result property="isTrhbco" column="IS_TRHBCO"/>
        <result property="trhbcoInfo" column="TRHBCO_INFO"/>
        <result property="trhbcoSttm" column="TRHBCO_STTM"/>
        <result property="trhbcoEntm" column="TRHBCO_ENTM"/>
        <result property="mngUnit" column="MNG_UNIT"/>
        <result property="dutyUnit" column="DUTY_UNIT"/>
        <result property="note" column="NOTE"/>
        <result property="status" column="STATUS"/>
        <result property="persId" column="PERS_ID"/>
        <result property="intm" column="INTM"/>
        <result property="uptm" column="UPTM"/>
        <result property="isSite" column="IS_SITE"/>
        <result property="chkDesc" column="CHK_DESC"/>
    </resultMap>

    <sql id="table_columns">
		ID,
		RGSTR_ID,
		INSP_YEAR,
		WC_EVLT_OLD,
		WC_EVLT_NOW,
		MSH_TMP,
		CHK_TYPE,
		IS_TRHBCO,
		TRHBCO_INFO,
		TRHBCO_STTM,
		TRHBCO_ENTM,
		MNG_UNIT,
		DUTY_UNIT,
		NOTE,
		STATUS,
		PERS_ID,
		INTM,
		UPTM,
		IS_SITE,
		CHK_DESC
    </sql>
    <sql id="entity_properties">
		#{id},
		#{rgstrId},
		#{inspYear},
		#{wcEvltOld},
		#{wcEvltNow},
		#{mshTmp},
		#{chkType},
		#{isTrhbco},
		#{trhbcoInfo},
		#{trhbcoSttm},
		#{trhbcoEntm},
		#{mngUnit},
		#{dutyUnit},
		#{note},
		#{status},
		#{persId},
		#{intm},
		#{uptm},
		#{isSite},
		#{chkDesc}
	</sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="chkDesc != null and chkDesc != ''">and CHK_DESC = #{chkDesc}</if>
            <if test="isSite != null and isSite != ''">and IS_SITE = #{isSite}</if>
            <if test="rgstrId != null and rgstrId != ''">and RGSTR_ID = #{rgstrId}</if>
            <if test="inspYear != null and inspYear != ''">and INSP_YEAR = #{inspYear}</if>
            <if test="wcEvltOld != null and wcEvltOld != ''">and WC_EVLT_OLD = #{wcEvltOld}</if>
            <if test="wcEvltNow != null and wcEvltNow != ''">and WC_EVLT_NOW = #{wcEvltNow}</if>
            <if test="mshTmp != null and mshTmp != ''">and MSH_TMP = #{mshTmp}</if>
            <if test="chkType != null and chkType != ''">and CHK_TYPE = #{chkType}</if>
            <if test="isTrhbco != null and isTrhbco != ''">and IS_TRHBCO = #{isTrhbco}</if>
            <if test="trhbcoInfo != null and trhbcoInfo != ''">and TRHBCO_INFO = #{trhbcoInfo}</if>
            <if test="trhbcoSttm != null">and TRHBCO_STTM = #{trhbcoSttm}</if>
            <if test="trhbcoEntm != null">and TRHBCO_ENTM = #{trhbcoEntm}</if>
            <if test="mngUnit != null and mngUnit != ''">and MNG_UNIT = #{mngUnit}</if>
            <if test="dutyUnit != null and dutyUnit != ''">and DUTY_UNIT = #{dutyUnit}</if>
            <if test="note != null and note != ''">and NOTE = #{note}</if>
            <if test="status != null and status != ''">and STATUS = #{status}</if>
            <if test="persId != null and persId != ''">and PERS_ID = #{persId}</if>
            <if test="intm != null">and INTM = #{intm}</if>
            <if test="uptm != null">and UPTM = #{uptm}</if>
        </trim>
    </sql>


    <select id="get" resultMap="bisInspRsvrynRgstrChkInfoResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from BIS_INSP_RSVRYN_RGSTR_CHK_INFO where RGSTR_ID = #{id}
    </select>

    <select id="getBy" resultMap="bisInspRsvrynRgstrChkInfoResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="bisInspRsvrynRgstrChkInfoResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_RSVRYN_RGSTR_CHK_INFO
    </select>

    <select id="findList" resultMap="bisInspRsvrynRgstrChkInfoResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <include refid="page_where"/>
    </select>

    <select id="selectCount" resultType="int">
        select count(ID) from BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <include refid="page_where"/>
    </select>


    <insert id="insert" parameterType="cn.com.goldenwater.dcproj.model.BisInspRsvrynRgstrChkInfo">
        insert into BIS_INSP_RSVRYN_RGSTR_CHK_INFO(
        <include refid="table_columns"/>
        )
        values (
        <include refid="entity_properties"/>
        )
    </insert>


    <delete id="delete" parameterType="java.lang.String">
        delete from BIS_INSP_RSVRYN_RGSTR_CHK_INFO where ID = #{id}
    </delete>

    <delete id="deleteBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspRsvrynRgstrChkInfo">
        delete from BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <include refid="page_where"/>
    </delete>

    <update id="deleteInFlag" parameterType="java.lang.String">
        update BIS_INSP_RSVRYN_RGSTR_CHK_INFO set flag_valid = 0 where ID = #{id}
    </update>

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspRsvrynRgstrChkInfo">
        update BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <trim prefix="set" suffixOverrides=",">
            <if test="chkDesc != null and chkDesc != ''">CHK_DESC = #{chkDesc},</if>
            <if test="isSite != null and isSite != ''">IS_SITE = #{isSite},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="inspYear != null and inspYear != ''">INSP_YEAR = #{inspYear},</if>
            <if test="wcEvltOld != null and wcEvltOld != ''">WC_EVLT_OLD = #{wcEvltOld},</if>
            <if test="wcEvltNow != null and wcEvltNow != ''">WC_EVLT_NOW = #{wcEvltNow},</if>
            <if test="mshTmp != null and mshTmp != ''">MSH_TMP = #{mshTmp},</if>
            <if test="chkType != null and chkType != ''">CHK_TYPE = #{chkType},</if>
            <if test="isTrhbco != null and isTrhbco != ''">IS_TRHBCO = #{isTrhbco},</if>
            <if test="trhbcoInfo != null and trhbcoInfo != ''">TRHBCO_INFO = #{trhbcoInfo},</if>
            <if test="trhbcoSttm != null">TRHBCO_STTM = #{trhbcoSttm},</if>
            <if test="trhbcoEntm != null">TRHBCO_ENTM = #{trhbcoEntm},</if>
            <if test="mngUnit != null and mngUnit != ''">MNG_UNIT = #{mngUnit},</if>
            <if test="dutyUnit != null and dutyUnit != ''">DUTY_UNIT = #{dutyUnit},</if>
            <if test="note != null and note != ''">NOTE = #{note},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="persId != null and persId != ''">PERS_ID = #{persId},</if>
            <if test="intm != null">INTM = #{intm},</if>
            <if test="uptm != null">UPTM = #{uptm},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspRsvrynRgstrChkInfo">
        update BIS_INSP_RSVRYN_RGSTR_CHK_INFO
        <trim prefix="set" suffixOverrides=",">
			<if test="chkDesc != null and chkDesc != ''">CHK_DESC = #{chkDesc},</if>
            <if test="isSite != null and isSite != ''">IS_SITE = #{isSite},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="inspYear != null and inspYear != ''">INSP_YEAR = #{inspYear},</if>
            <if test="wcEvltOld != null and wcEvltOld != ''">WC_EVLT_OLD = #{wcEvltOld},</if>
            <if test="wcEvltNow != null and wcEvltNow != ''">WC_EVLT_NOW = #{wcEvltNow},</if>
            <if test="mshTmp != null and mshTmp != ''">MSH_TMP = #{mshTmp},</if>
            <if test="chkType != null and chkType != ''">CHK_TYPE = #{chkType},</if>
            <if test="isTrhbco != null and isTrhbco != ''">IS_TRHBCO = #{isTrhbco},</if>
            <if test="trhbcoInfo != null and trhbcoInfo != ''">TRHBCO_INFO = #{trhbcoInfo},</if>
            <if test="trhbcoSttm != null">TRHBCO_STTM = #{trhbcoSttm},</if>
            <if test="trhbcoEntm != null">TRHBCO_ENTM = #{trhbcoEntm},</if>
            <if test="mngUnit != null and mngUnit != ''">MNG_UNIT = #{mngUnit},</if>
            <if test="dutyUnit != null and dutyUnit != ''">DUTY_UNIT = #{dutyUnit},</if>
            <if test="note != null and note != ''">NOTE = #{note},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="persId != null and persId != ''">PERS_ID = #{persId},</if>
            <if test="intm != null">INTM = #{intm},</if>
            <if test="uptm != null">UPTM = #{uptm},</if>
        </trim>
        <include refid="page_where"/>
    </update>


    <!-- 其他自定义SQL -->


</mapper>