fj-dc/.svn/pristine/e2/e2dfcb0a6687d88e159f52c040c13deb90b7c25e.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.BisInspWagaSapRgstrDamIfDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspWagaSapRgstrDamIf" id="bisInspWagaSapRgstrDamIfResultMap">
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="isCoarScw" column="IS_COAR_SCW"/>
        <result property="isHirIrs" column="IS_HIR_IRS"/>
        <result property="isIafditTemtdwi" column="IS_IAFDIT_TEMTDWI"/>
        <result property="isPrdRm" column="IS_PRD_RM"/>
        <result property="isMipThopeiee" column="IS_MIP_THOPEIEE"/>
        <result property="socIsDe" column="SOC_IS_DE"/>
        <result property="socIsIc" column="SOC_IS_IC"/>
        <result property="socIsAtetsotp" column="SOC_IS_ATETSOTP"/>
        <result property="sopIsDe" column="SOP_IS_DE"/>
        <result property="sopIsIc" column="SOP_IS_IC"/>
        <result property="sopIsAtetsotp" column="SOP_IS_ATETSOTP"/>
        <result property="recPersId" column="REC_PERS_ID"/>
        <result property="intm" column="INTM"/>
        <result property="uptm" column="UPTM"/>
        <result property="status" column="STATUS"/>
        <result property="msIsFaiMsftoolp" column="MS_IS_FAI_MSFTOOLP"/>
    </resultMap>

    <sql id="table_columns">
    ID,
    RGSTR_ID,
    IS_COAR_SCW,
    IS_HIR_IRS,
    IS_IAFDIT_TEMTDWI,
    IS_PRD_RM,
    IS_MIP_THOPEIEE,
    SOC_IS_DE,
    SOC_IS_IC,
    SOC_IS_ATETSOTP,
    SOP_IS_DE,
    SOP_IS_IC,
    SOP_IS_ATETSOTP,
    REC_PERS_ID,
    INTM,
    UPTM,
    STATUS,
    MS_IS_FAI_MSFTOOLP
    </sql>
    <sql id="entity_properties">
    #{id},
    #{rgstrId},
    #{isCoarScw},
    #{isHirIrs},
    #{isIafditTemtdwi},
    #{isPrdRm},
    #{isMipThopeiee},
    #{socIsDe},
    #{socIsIc},
    #{socIsAtetsotp},
    #{sopIsDe},
    #{sopIsIc},
    #{sopIsAtetsotp},
    #{recPersId},
    #{intm},
    #{uptm},
    #{status},
    #{msIsFaiMsftoolp}
    </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="isCoarScw != null and isCoarScw != ''">and IS_COAR_SCW = #{isCoarScw}</if>
            <if test="isHirIrs != null and isHirIrs != ''">and IS_HIR_IRS = #{isHirIrs}</if>
            <if test="isIafditTemtdwi != null and isIafditTemtdwi != ''">and IS_IAFDIT_TEMTDWI = #{isIafditTemtdwi}</if>
            <if test="isPrdRm != null and isPrdRm != ''">and IS_PRD_RM = #{isPrdRm}</if>
            <if test="isMipThopeiee != null and isMipThopeiee != ''">and IS_MIP_THOPEIEE = #{isMipThopeiee}</if>
            <if test="socIsDe != null and socIsDe != ''">and SOC_IS_DE = #{socIsDe}</if>
            <if test="socIsIc != null and socIsIc != ''">and SOC_IS_IC = #{socIsIc}</if>
            <if test="socIsAtetsotp != null and socIsAtetsotp != ''">and SOC_IS_ATETSOTP = #{socIsAtetsotp}</if>
            <if test="sopIsDe != null and sopIsDe != ''">and SOP_IS_DE = #{sopIsDe}</if>
            <if test="sopIsIc != null and sopIsIc != ''">and SOP_IS_IC = #{sopIsIc}</if>
            <if test="sopIsAtetsotp != null and sopIsAtetsotp != ''">and SOP_IS_ATETSOTP = #{sopIsAtetsotp}</if>
            <if test="recPersId != null and recPersId != ''">and REC_PERS_ID = #{recPersId}</if>
            <if test="intm != null">and INTM = #{intm}</if>
            <if test="uptm != null">and UPTM = #{uptm}</if>
            <if test="status != null and status != ''">and STATUS = #{status}</if>
            <if test="msIsFaiMsftoolp != null and msIsFaiMsftoolp != ''">and MS_IS_FAI_MSFTOOLP = #{msIsFaiMsftoolp}</if>
        </trim>
    </sql>


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

    <select id="getBy" resultMap="bisInspWagaSapRgstrDamIfResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WAGA_SAP_RGSTR_DAM_IF <include refid="page_where" />
    </select>

    <select id="findAll" resultMap="bisInspWagaSapRgstrDamIfResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WAGA_SAP_RGSTR_DAM_IF
    </select>

    <select id="findList" resultMap="bisInspWagaSapRgstrDamIfResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WAGA_SAP_RGSTR_DAM_IF <include refid="page_where" />
    </select>

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


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

    <delete id="delete" parameterType="java.lang.String">
        update  BIS_INSP_WAGA_SAP_RGSTR_DAM_IF set DATA_STAT='9' where ID = #{id}
    </delete>

    <delete id="deleteBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspWagaSapRgstrDamIf">
        update  BIS_INSP_WAGA_SAP_RGSTR_DAM_IF set DATA_STAT='9' <include refid="page_where" />
    </delete>

    <update id="deleteInFlag" parameterType="java.lang.String">
        update BIS_INSP_WAGA_SAP_RGSTR_DAM_IF set DATA_STAT = '9' where ID = #{id}
    </update>

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspWagaSapRgstrDamIf">
        update BIS_INSP_WAGA_SAP_RGSTR_DAM_IF
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="isCoarScw != null and isCoarScw != ''">IS_COAR_SCW = #{isCoarScw},</if>
            <if test="isHirIrs != null and isHirIrs != ''">IS_HIR_IRS = #{isHirIrs},</if>
            <if test="isIafditTemtdwi != null and isIafditTemtdwi != ''">IS_IAFDIT_TEMTDWI = #{isIafditTemtdwi},</if>
            <if test="isPrdRm != null and isPrdRm != ''">IS_PRD_RM = #{isPrdRm},</if>
            <if test="isMipThopeiee != null and isMipThopeiee != ''">IS_MIP_THOPEIEE = #{isMipThopeiee},</if>
            <if test="socIsDe != null and socIsDe != ''">SOC_IS_DE = #{socIsDe},</if>
            <if test="socIsIc != null and socIsIc != ''">SOC_IS_IC = #{socIsIc},</if>
            <if test="socIsAtetsotp != null and socIsAtetsotp != ''">SOC_IS_ATETSOTP = #{socIsAtetsotp},</if>
            <if test="sopIsDe != null and sopIsDe != ''">SOP_IS_DE = #{sopIsDe},</if>
            <if test="sopIsIc != null and sopIsIc != ''">SOP_IS_IC = #{sopIsIc},</if>
            <if test="sopIsAtetsotp != null and sopIsAtetsotp != ''">SOP_IS_ATETSOTP = #{sopIsAtetsotp},</if>
            <if test="recPersId != null and recPersId != ''">REC_PERS_ID = #{recPersId},</if>
            <if test="intm != null">INTM = #{intm},</if>
            <if test="uptm != null">UPTM = #{uptm},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="msIsFaiMsftoolp != null and msIsFaiMsftoolp != ''">MS_IS_FAI_MSFTOOLP = #{msIsFaiMsftoolp},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspWagaSapRgstrDamIf">
        update BIS_INSP_WAGA_SAP_RGSTR_DAM_IF
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="isCoarScw != null and isCoarScw != ''">IS_COAR_SCW = #{isCoarScw},</if>
            <if test="isHirIrs != null and isHirIrs != ''">IS_HIR_IRS = #{isHirIrs},</if>
            <if test="isIafditTemtdwi != null and isIafditTemtdwi != ''">IS_IAFDIT_TEMTDWI = #{isIafditTemtdwi},</if>
            <if test="isPrdRm != null and isPrdRm != ''">IS_PRD_RM = #{isPrdRm},</if>
            <if test="isMipThopeiee != null and isMipThopeiee != ''">IS_MIP_THOPEIEE = #{isMipThopeiee},</if>
            <if test="socIsDe != null and socIsDe != ''">SOC_IS_DE = #{socIsDe},</if>
            <if test="socIsIc != null and socIsIc != ''">SOC_IS_IC = #{socIsIc},</if>
            <if test="socIsAtetsotp != null and socIsAtetsotp != ''">SOC_IS_ATETSOTP = #{socIsAtetsotp},</if>
            <if test="sopIsDe != null and sopIsDe != ''">SOP_IS_DE = #{sopIsDe},</if>
            <if test="sopIsIc != null and sopIsIc != ''">SOP_IS_IC = #{sopIsIc},</if>
            <if test="sopIsAtetsotp != null and sopIsAtetsotp != ''">SOP_IS_ATETSOTP = #{sopIsAtetsotp},</if>
            <if test="recPersId != null and recPersId != ''">REC_PERS_ID = #{recPersId},</if>
            <if test="intm != null">INTM = #{intm},</if>
            <if test="uptm != null">UPTM = #{uptm},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="msIsFaiMsftoolp != null and msIsFaiMsftoolp != ''">MS_IS_FAI_MSFTOOLP = #{msIsFaiMsftoolp},</if>
        </trim>
        <include refid="page_where" />
    </update>


    <!-- 其他自定义SQL -->
    <delete id="deleteByRgstrId">
        delete from BIS_INSP_WAGA_SAP_RGSTR_DAM_IF where RGSTR_ID = #{rgstrId}
    </delete>
    <select id="getWagaSapRgstrDamIfInfoByRgstrId" resultMap="bisInspWagaSapRgstrDamIfResultMap">
        select
          <include refid="table_columns"/>
        from BIS_INSP_WAGA_SAP_RGSTR_DAM_IF where RGSTR_ID = #{rgstrId}
    </select>
</mapper>