fj-dc/.svn/pristine/c8/c8d6b074b30055e21036a4e3d89d007280b80ca5.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.BisInspWrwsRgstrWtupDao">

	<resultMap type="cn.com.goldenwater.dcproj.model.BisInspWrwsRgstrWtup" id="bisInspWrwsRgstrWtupResultMap">
		<result property="id" column="ID"/>
		<result property="rgstrId" column="RGSTR_ID"/>
		<result property="isWtuIn" column="IS_WTU_IN"/>
		<result property="isPlanWt" column="IS_PLAN_WT"/>
		<result property="planWtNum" column="PLAN_WT_NUM"/>
		<result property="planWtNote" column="PLAN_WT_NOTE"/>
		<result property="isNorm" column="IS_NORM"/>
		<result property="noNormNum" column="NO_NORM_NUM"/>
		<result property="noNormNote" column="NO_NORM_NOTE"/>
		<result property="isOplanPay" column="IS_OPLAN_PAY"/>
		<result property="oplanNum" column="OPLAN_NUM"/>
		<result property="oplanNote" column="OPLAN_NOTE"/>
		<result property="isBuldPwt" column="IS_BULD_PWT"/>
		<result property="isPubWtpl" column="IS_PUB_WTPL"/>
		<result property="isPubPlan" column="IS_PUB_PLAN"/>
		<result property="noPubNum" column="NO_PUB_NUM"/>
		<result property="noPubNote" column="NO_PUB_NOTE"/>
		<result property="isOplanApay" column="IS_OPLAN_APAY"/>
		<result property="noOplanNum" column="NO_OPLAN_NUM"/>
		<result property="noOplanNote" column="NO_OPLAN_NOTE"/>
		<result property="isPipeLowc" column="IS_PIPE_LOWC"/>
		<result property="isNwtInc" column="IS_NWT_INC"/>
		<result property="isAddWt" column="IS_ADD_WT"/>
		<result property="persId" column="PERS_ID"/>
		<result property="intm" column="INTM"/>
		<result property="uptm" column="UPTM"/>
		<result property="state" column="STATE"/>
		<result property="dataStat" column="DATA_STAT"/>
	</resultMap>
	
	<sql id="table_columns">
		ID,
		RGSTR_ID,
		IS_WTU_IN,
		IS_PLAN_WT,
		PLAN_WT_NUM,
		PLAN_WT_NOTE,
		IS_NORM,
		NO_NORM_NUM,
		NO_NORM_NOTE,
		IS_OPLAN_PAY,
		OPLAN_NUM,
		OPLAN_NOTE,
		IS_BULD_PWT,
		IS_PUB_WTPL,
		IS_PUB_PLAN,
		NO_PUB_NUM,
		NO_PUB_NOTE,
		IS_OPLAN_APAY,
		NO_OPLAN_NUM,
		NO_OPLAN_NOTE,
		IS_PIPE_LOWC,
		IS_NWT_INC,
		IS_ADD_WT,
		PERS_ID,
		INTM,
		UPTM,
		STATE,
		DATA_STAT
    </sql>
	<sql id="entity_properties">
		#{id},
		#{rgstrId},
		#{isWtuIn},
		#{isPlanWt},
		#{planWtNum},
		#{planWtNote},
		#{isNorm},
		#{noNormNum},
		#{noNormNote},
		#{isOplanPay},
		#{oplanNum},
		#{oplanNote},
		#{isBuldPwt},
		#{isPubWtpl},
		#{isPubPlan},
		#{noPubNum},
		#{noPubNote},
		#{isOplanApay},
		#{noOplanNum},
		#{noOplanNote},
		#{isPipeLowc},
		#{isNwtInc},
		#{isAddWt},
		#{persId},
		#{intm},
		#{uptm},
		#{state},
		#{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="isWtuIn != null and isWtuIn != ''">and IS_WTU_IN = #{isWtuIn}</if>
            <if test="isPlanWt != null and isPlanWt != ''">and IS_PLAN_WT = #{isPlanWt}</if>
            <if test="planWtNum != null and planWtNum != ''">and PLAN_WT_NUM = #{planWtNum}</if>
            <if test="planWtNote != null and planWtNote != ''">and PLAN_WT_NOTE = #{planWtNote}</if>
            <if test="isNorm != null and isNorm != ''">and IS_NORM = #{isNorm}</if>
            <if test="noNormNum != null and noNormNum != ''">and NO_NORM_NUM = #{noNormNum}</if>
            <if test="noNormNote != null and noNormNote != ''">and NO_NORM_NOTE = #{noNormNote}</if>
            <if test="isOplanPay != null and isOplanPay != ''">and IS_OPLAN_PAY = #{isOplanPay}</if>
            <if test="oplanNum != null and oplanNum != ''">and OPLAN_NUM = #{oplanNum}</if>
            <if test="oplanNote != null and oplanNote != ''">and OPLAN_NOTE = #{oplanNote}</if>
            <if test="isBuldPwt != null and isBuldPwt != ''">and IS_BULD_PWT = #{isBuldPwt}</if>
            <if test="isPubWtpl != null and isPubWtpl != ''">and IS_PUB_WTPL = #{isPubWtpl}</if>
            <if test="isPubPlan != null and isPubPlan != ''">and IS_PUB_PLAN = #{isPubPlan}</if>
            <if test="noPubNum != null and noPubNum != ''">and NO_PUB_NUM = #{noPubNum}</if>
            <if test="noPubNote != null and noPubNote != ''">and NO_PUB_NOTE = #{noPubNote}</if>
            <if test="isOplanApay != null and isOplanApay != ''">and IS_OPLAN_APAY = #{isOplanApay}</if>
            <if test="noOplanNum != null and noOplanNum != ''">and NO_OPLAN_NUM = #{noOplanNum}</if>
            <if test="noOplanNote != null and noOplanNote != ''">and NO_OPLAN_NOTE = #{noOplanNote}</if>
            <if test="isPipeLowc != null and isPipeLowc != ''">and IS_PIPE_LOWC = #{isPipeLowc}</if>
            <if test="isNwtInc != null and isNwtInc != ''">and IS_NWT_INC = #{isNwtInc}</if>
            <if test="isAddWt != null and isAddWt != ''">and IS_ADD_WT = #{isAddWt}</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="state != null and state != ''">and STATE = #{state}</if>
            <if test="dataStat != null and dataStat != ''">and DATA_STAT = #{dataStat}</if>
            and DATA_STAT='0'
        </trim>
    </sql>


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

    <select id="getBy" resultMap="bisInspWrwsRgstrWtupResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WRWS_RGSTR_WTUP <include refid="page_where" />
    </select>

    <select id="findAll" resultMap="bisInspWrwsRgstrWtupResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WRWS_RGSTR_WTUP
    </select>

    <select id="findList" resultMap="bisInspWrwsRgstrWtupResultMap">
        select <include refid="table_columns" /> from BIS_INSP_WRWS_RGSTR_WTUP <include refid="page_where" />
    </select>

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


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

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

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

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

	<update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspWrwsRgstrWtup">
		update BIS_INSP_WRWS_RGSTR_WTUP 
		<trim prefix="set" suffixOverrides=",">
			<if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
			<if test="isWtuIn != null and isWtuIn != ''">IS_WTU_IN = #{isWtuIn},</if>
			<if test="isPlanWt != null and isPlanWt != ''">IS_PLAN_WT = #{isPlanWt},</if>
			<if test="planWtNum != null and planWtNum != ''">PLAN_WT_NUM = #{planWtNum},</if>
			<if test="planWtNote != null and planWtNote != ''">PLAN_WT_NOTE = #{planWtNote},</if>
			<if test="isNorm != null and isNorm != ''">IS_NORM = #{isNorm},</if>
			<if test="noNormNum != null and noNormNum != ''">NO_NORM_NUM = #{noNormNum},</if>
			<if test="noNormNote != null and noNormNote != ''">NO_NORM_NOTE = #{noNormNote},</if>
			<if test="isOplanPay != null and isOplanPay != ''">IS_OPLAN_PAY = #{isOplanPay},</if>
			<if test="oplanNum != null and oplanNum != ''">OPLAN_NUM = #{oplanNum},</if>
			<if test="oplanNote != null and oplanNote != ''">OPLAN_NOTE = #{oplanNote},</if>
			<if test="isBuldPwt != null and isBuldPwt != ''">IS_BULD_PWT = #{isBuldPwt},</if>
			<if test="isPubWtpl != null and isPubWtpl != ''">IS_PUB_WTPL = #{isPubWtpl},</if>
			<if test="isPubPlan != null and isPubPlan != ''">IS_PUB_PLAN = #{isPubPlan},</if>
			<if test="noPubNum != null and noPubNum != ''">NO_PUB_NUM = #{noPubNum},</if>
			<if test="noPubNote != null and noPubNote != ''">NO_PUB_NOTE = #{noPubNote},</if>
			<if test="isOplanApay != null and isOplanApay != ''">IS_OPLAN_APAY = #{isOplanApay},</if>
			<if test="noOplanNum != null and noOplanNum != ''">NO_OPLAN_NUM = #{noOplanNum},</if>
			<if test="noOplanNote != null and noOplanNote != ''">NO_OPLAN_NOTE = #{noOplanNote},</if>
			<if test="isPipeLowc != null and isPipeLowc != ''">IS_PIPE_LOWC = #{isPipeLowc},</if>
			<if test="isNwtInc != null and isNwtInc != ''">IS_NWT_INC = #{isNwtInc},</if>
			<if test="isAddWt != null and isAddWt != ''">IS_ADD_WT = #{isAddWt},</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="state != null and state != ''">STATE = #{state},</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.BisInspWrwsRgstrWtup">
        update BIS_INSP_WRWS_RGSTR_WTUP
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="isWtuIn != null and isWtuIn != ''">IS_WTU_IN = #{isWtuIn},</if>
            <if test="isPlanWt != null and isPlanWt != ''">IS_PLAN_WT = #{isPlanWt},</if>
            <if test="planWtNum != null and planWtNum != ''">PLAN_WT_NUM = #{planWtNum},</if>
            <if test="planWtNote != null and planWtNote != ''">PLAN_WT_NOTE = #{planWtNote},</if>
            <if test="isNorm != null and isNorm != ''">IS_NORM = #{isNorm},</if>
            <if test="noNormNum != null and noNormNum != ''">NO_NORM_NUM = #{noNormNum},</if>
            <if test="noNormNote != null and noNormNote != ''">NO_NORM_NOTE = #{noNormNote},</if>
            <if test="isOplanPay != null and isOplanPay != ''">IS_OPLAN_PAY = #{isOplanPay},</if>
            <if test="oplanNum != null and oplanNum != ''">OPLAN_NUM = #{oplanNum},</if>
            <if test="oplanNote != null and oplanNote != ''">OPLAN_NOTE = #{oplanNote},</if>
            <if test="isBuldPwt != null and isBuldPwt != ''">IS_BULD_PWT = #{isBuldPwt},</if>
            <if test="isPubWtpl != null and isPubWtpl != ''">IS_PUB_WTPL = #{isPubWtpl},</if>
            <if test="isPubPlan != null and isPubPlan != ''">IS_PUB_PLAN = #{isPubPlan},</if>
            <if test="noPubNum != null and noPubNum != ''">NO_PUB_NUM = #{noPubNum},</if>
            <if test="noPubNote != null and noPubNote != ''">NO_PUB_NOTE = #{noPubNote},</if>
            <if test="isOplanApay != null and isOplanApay != ''">IS_OPLAN_APAY = #{isOplanApay},</if>
            <if test="noOplanNum != null and noOplanNum != ''">NO_OPLAN_NUM = #{noOplanNum},</if>
            <if test="noOplanNote != null and noOplanNote != ''">NO_OPLAN_NOTE = #{noOplanNote},</if>
            <if test="isPipeLowc != null and isPipeLowc != ''">IS_PIPE_LOWC = #{isPipeLowc},</if>
            <if test="isNwtInc != null and isNwtInc != ''">IS_NWT_INC = #{isNwtInc},</if>
            <if test="isAddWt != null and isAddWt != ''">IS_ADD_WT = #{isAddWt},</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="state != null and state != ''">STATE = #{state},</if>
            <if test="dataStat != null and dataStat != ''">DATA_STAT = #{dataStat},</if>
        </trim>
        <include refid="page_where" />
    </update>


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


</mapper>