fj-dc/.svn/pristine/2f/2f1d17f07f4e8ccb8cd21808fc39a94c43e1ba8b.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.TacPawpBitopqQmsDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.TacPawpBitopqQms" id="tacPawpBitopqQmsResultMap">
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="sysType" column="SYS_TYPE"/>
        <result property="sysNm" column="SYS_NM"/>
        <result property="orgNm" column="ORG_NM"/>
        <result property="stfSttn" column="STF_STTN"/>
        <result property="qasms" column="QASMS"/>
        <result property="qasm" column="QASM"/>
        <result property="qsorgIsDamp" column="QSORG_IS_DAMP"/>
        <result property="qsorgIsCpd" column="QSORG_IS_CPD"/>
        <result property="qsorgQassai" column="QSORG_QASSAI"/>
        <result property="remark" column="REMARK"/>
        <result property="persId" column="PERS_ID"/>
        <result property="intm" column="INTM"/>
        <result property="uptm" column="UPTM"/>
        <result property="dataStat" column="DATA_STAT"/>
        <result property="subName" column="SUB_NAME"/>
    </resultMap>

    <sql id="table_columns">
        ID,
        RGSTR_ID,
        SYS_TYPE,
        SYS_NM,
        ORG_NM,
        STF_STTN,
        QASMS,
        QASM,
        QSORG_IS_DAMP,
        QSORG_IS_CPD,
        QSORG_QASSAI,
        REMARK,
        PERS_ID,
        INTM,
        UPTM,
        DATA_STAT
    </sql>
    <sql id="entity_properties">
        #{id},
        #{rgstrId},
        #{sysType},
        #{sysNm},
        #{orgNm},
        #{stfSttn},
        #{qasms},
        #{qasm},
        #{qsorgIsDamp},
        #{qsorgIsCpd},
        #{qsorgQassai},
        #{remark},
        #{persId},
        #{intm},
        #{uptm},
        #{dataStat}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="rgstrId != null and rgstrId != ''">and RGSTR_ID = #{rgstrId}</if>
            <if test="sysType != null and sysType != ''">and SYS_TYPE = #{sysType}</if>
            <if test="sysNm != null and sysNm != ''">and SYS_NM like '%${sysNm}%'</if>
            <if test="orgNm != null and orgNm != ''">and ORG_NM like '%${orgNm}%'</if>
            <if test="stfSttn != null and stfSttn != ''">and STF_STTN = #{stfSttn}</if>
            <if test="qasms != null and qasms != ''">and QASMS = #{qasms}</if>
            <if test="qasm != null and qasm != ''">and QASM = #{qasm}</if>
            <if test="qsorgIsDamp != null and qsorgIsDamp != ''">and QSORG_IS_DAMP = #{qsorgIsDamp}</if>
            <if test="qsorgIsCpd != null and qsorgIsCpd != ''">and QSORG_IS_CPD = #{qsorgIsCpd}</if>
            <if test="qsorgQassai != null and qsorgQassai != ''">and QSORG_QASSAI = #{qsorgQassai}</if>
            <if test="remark != null and remark != ''">and REMARK like '%${remark}%'</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>
            <if test="dataStat != null and dataStat != ''">and DATA_STAT = #{dataStat}</if>
        </trim>
    </sql>


    <select id="get" resultMap="tacPawpBitopqQmsResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BITOPQ_QMS where ID = #{id}
    </select>

    <select id="getBy" resultMap="tacPawpBitopqQmsResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BITOPQ_QMS
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="tacPawpBitopqQmsResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BITOPQ_QMS
    </select>

    <select id="findList" resultMap="tacPawpBitopqQmsResultMap">
        select t.* ,O.SUB_NAME from TAC_PAWP_BITOPQ_QMS t,TAC_OBJ_SUBJECT O where t.sys_type=O.Id
        <if test="rgstrId != null and rgstrId != ''">and t.RGSTR_ID = #{rgstrId}</if>
        <if test="sysType != null and sysType != ''">and t.SYS_TYPE = #{sysType}</if>
        <if test="sysNm != null and sysNm != ''">and t.SYS_NM = #{sysNm}</if>
        <if test="orgNm != null and orgNm != ''">and t.ORG_NM = #{orgNm}</if>
        <if test="stfSttn != null and stfSttn != ''">and t.STF_STTN = #{stfSttn}</if>
        <if test="qasms != null and qasms != ''">and t.QASMS = #{qasms}</if>
        <if test="qasm != null and qasm != ''">and t.QASM = #{qasm}</if>
        <if test="qsorgIsDamp != null and qsorgIsDamp != ''">and t.QSORG_IS_DAMP = #{qsorgIsDamp}</if>
        <if test="qsorgIsCpd != null and qsorgIsCpd != ''">and t.QSORG_IS_CPD = #{qsorgIsCpd}</if>
        <if test="qsorgQassai != null and qsorgQassai != ''">and t.QSORG_QASSAI = #{qsorgQassai}</if>
        <if test="remark != null and remark != ''">and t.REMARK = #{remark}</if>
        <if test="persId != null and persId != ''">and t.PERS_ID = #{persId}</if>
        <if test="intm != null">and t.INTM = #{intm}</if>
        <if test="uptm != null">and t.UPTM = #{uptm}</if>
        <if test="dataStat != null and dataStat != ''">and t.DATA_STAT = #{dataStat}</if>
        <if test="subName != null and subName != ''">and O.SUB_NAME = #{subName}</if>
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.TacPawpBitopqQms">
        update TAC_PAWP_BITOPQ_QMS
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="sysType != null and sysType != ''">SYS_TYPE = #{sysType},</if>
            <if test="sysNm != null and sysNm != ''">SYS_NM = #{sysNm},</if>
            <if test="orgNm != null">ORG_NM = #{orgNm},</if>
            <if test="stfSttn != null">STF_STTN = #{stfSttn},</if>
            <if test="qasms != null">QASMS = #{qasms},</if>
            <if test="qasm != null">QASM = #{qasm},</if>
            <if test="qsorgIsDamp != null">QSORG_IS_DAMP = #{qsorgIsDamp},</if>
            <if test="qsorgIsCpd != null">QSORG_IS_CPD = #{qsorgIsCpd},</if>
            <if test="qsorgQassai != null">QSORG_QASSAI = #{qsorgQassai},</if>
            <if test="remark != null">REMARK = #{remark},</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>
            <if test="dataStat != null and dataStat != ''">DATA_STAT = #{dataStat},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.TacPawpBitopqQms">
        update TAC_PAWP_BITOPQ_QMS
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="sysType != null and sysType != ''">SYS_TYPE = #{sysType},</if>
            <if test="sysNm != null">SYS_NM = #{sysNm},</if>
            <if test="orgNm != null">ORG_NM = #{orgNm},</if>
            <if test="stfSttn != null">STF_STTN = #{stfSttn},</if>
            <if test="qasms != null">QASMS = #{qasms},</if>
            <if test="qasm != null">QASM = #{qasm},</if>
            <if test="qsorgIsDamp != null">QSORG_IS_DAMP = #{qsorgIsDamp},</if>
            <if test="qsorgIsCpd != null">QSORG_IS_CPD = #{qsorgIsCpd},</if>
            <if test="qsorgQassai != null">QSORG_QASSAI = #{qsorgQassai},</if>
            <if test="remark != null">REMARK = #{remark},</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>
            <if test="dataStat != null and dataStat != ''">DATA_STAT = #{dataStat},</if>
        </trim>
        <include refid="page_where"/>
    </update>


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


</mapper>