fj-dc/.svn/pristine/dd/dd3bc1d3fa9397e48835bc4dcab6cde297b4a95e.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.TacPawpRaiobisDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.TacPawpRaiobis" id="tacPawpRaiobisResultMap">
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="year" column="YEAR"/>
        <result property="yearIssuedSum" column="YEAR_ISSUED_SUM"/>
        <result property="yearIssuedCenter" column="YEAR_ISSUED_CENTER"/>
        <result property="yearIssuedPro" column="YEAR_ISSUED_PRO"/>
        <result property="yearIssuedCity" column="YEAR_ISSUED_CITY"/>
        <result property="yearIssuedCunty" column="YEAR_ISSUED_CUNTY"/>
        <result property="yearIssuedOther" column="YEAR_ISSUED_OTHER"/>
        <result property="totalIssuedSum" column="TOTAL_ISSUED_SUM"/>
        <result property="totalIssuedCenter" column="TOTAL_ISSUED_CENTER"/>
        <result property="totalIssuedPro" column="TOTAL_ISSUED_PRO"/>
        <result property="totalIssuedCity" column="TOTAL_ISSUED_CITY"/>
        <result property="totalIssuedCunty" column="TOTAL_ISSUED_CUNTY"/>
        <result property="totalIssuedOther" column="TOTAL_ISSUED_OTHER"/>
        <result property="isDat" column="IS_DAT"/>
        <result property="yearInvestYear" column="YEAR_INVEST_YEAR"/>
        <result property="yearInvest" column="YEAR_INVEST"/>
        <result property="yearInvestScale" column="YEAR_INVEST_SCALE"/>
        <result property="totalInvest" column="TOTAL_INVEST"/>
        <result property="totalInvestScale" column="TOTAL_INVEST_SCALE"/>
        <result property="mainWorks" column="MAIN_WORKS"/>
        <result property="pjctImgPgrs" column="PJCT_IMG_PGRS"/>
        <result property="remark" column="REMARK"/>
        <result property="note" column="NOTE"/>
        <result property="persId" column="PERS_ID"/>
        <result property="intm" column="INTM"/>
        <result property="uptm" column="UPTM"/>
        <result property="dataStat" column="DATA_STAT"/>
    </resultMap>

    <sql id="table_columns">
        ID,
        RGSTR_ID,
        YEAR,
        YEAR_ISSUED_SUM,
        YEAR_ISSUED_CENTER,
        YEAR_ISSUED_PRO,
        YEAR_ISSUED_CITY,
        YEAR_ISSUED_CUNTY,
        YEAR_ISSUED_OTHER,
        TOTAL_ISSUED_SUM,
        TOTAL_ISSUED_CENTER,
        TOTAL_ISSUED_PRO,
        TOTAL_ISSUED_CITY,
        TOTAL_ISSUED_CUNTY,
        TOTAL_ISSUED_OTHER,
        IS_DAT,
        YEAR_INVEST_YEAR,
        YEAR_INVEST,
        YEAR_INVEST_SCALE,
        TOTAL_INVEST,
        TOTAL_INVEST_SCALE,
        MAIN_WORKS,
        PJCT_IMG_PGRS,
        REMARK,
        NOTE,
        PERS_ID,
        INTM,
        UPTM,
        DATA_STAT
    </sql>
    <sql id="entity_properties">
        #{id},
        #{rgstrId},
        #{year},
        #{yearIssuedSum},
        #{yearIssuedCenter},
        #{yearIssuedPro},
        #{yearIssuedCity},
        #{yearIssuedCunty},
        #{yearIssuedOther},
        #{totalIssuedSum},
        #{totalIssuedCenter},
        #{totalIssuedPro},
        #{totalIssuedCity},
        #{totalIssuedCunty},
        #{totalIssuedOther},
        #{isDat},
        #{yearInvestYear},
        #{yearInvest},
        #{yearInvestScale},
        #{totalInvest},
        #{totalInvestScale},
        #{mainWorks},
        #{pjctImgPgrs},
        #{remark},
        #{note},
        #{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="year != null and year != ''">and YEAR = #{year}</if>
            <if test="yearIssuedSum != null and yearIssuedSum != ''">and YEAR_ISSUED_SUM = #{yearIssuedSum}</if>
            <if test="yearIssuedCenter != null and yearIssuedCenter != ''">and YEAR_ISSUED_CENTER =
                #{yearIssuedCenter}
            </if>
            <if test="yearIssuedPro != null and yearIssuedPro != ''">and YEAR_ISSUED_PRO = #{yearIssuedPro}</if>
            <if test="yearIssuedCity != null and yearIssuedCity != ''">and YEAR_ISSUED_CITY = #{yearIssuedCity}</if>
            <if test="yearIssuedCunty != null and yearIssuedCunty != ''">and YEAR_ISSUED_CUNTY = #{yearIssuedCunty}</if>
            <if test="yearIssuedOther != null and yearIssuedOther != ''">and YEAR_ISSUED_OTHER = #{yearIssuedOther}</if>
            <if test="totalIssuedSum != null and totalIssuedSum != ''">and TOTAL_ISSUED_SUM = #{totalIssuedSum}</if>
            <if test="totalIssuedCenter != null and totalIssuedCenter != ''">and TOTAL_ISSUED_CENTER =
                #{totalIssuedCenter}
            </if>
            <if test="totalIssuedPro != null and totalIssuedPro != ''">and TOTAL_ISSUED_PRO = #{totalIssuedPro}</if>
            <if test="totalIssuedCity != null and totalIssuedCity != ''">and TOTAL_ISSUED_CITY = #{totalIssuedCity}</if>
            <if test="totalIssuedCunty != null and totalIssuedCunty != ''">and TOTAL_ISSUED_CUNTY =
                #{totalIssuedCunty}
            </if>
            <if test="totalIssuedOther != null and totalIssuedOther != ''">and TOTAL_ISSUED_OTHER =
                #{totalIssuedOther}
            </if>
            <if test="isDat != null and isDat != ''">and IS_DAT = #{isDat}</if>
            <if test="yearInvestYear != null and yearInvestYear != ''">and YEAR_INVEST_YEAR = #{yearInvestYear}</if>
            <if test="yearInvest != null and yearInvest != ''">and YEAR_INVEST = #{yearInvest}</if>
            <if test="yearInvestScale != null and yearInvestScale != ''">and YEAR_INVEST_SCALE = #{yearInvestScale}</if>
            <if test="totalInvest != null and totalInvest != ''">and TOTAL_INVEST = #{totalInvest}</if>
            <if test="totalInvestScale != null and totalInvestScale != ''">and TOTAL_INVEST_SCALE =
                #{totalInvestScale}
            </if>
            <if test="mainWorks != null and mainWorks != ''">and MAIN_WORKS = #{mainWorks}</if>
            <if test="pjctImgPgrs != null and pjctImgPgrs != ''">and PJCT_IMG_PGRS = #{pjctImgPgrs}</if>
            <if test="remark != null and remark != ''">and REMARK like '%${remark}%'</if>
            <if test="note != null and note != ''">and NOTE like '%${note}%'</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="tacPawpRaiobisResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_RAIOBIS where ID = #{id}
    </select>

    <select id="getBy" resultMap="tacPawpRaiobisResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_RAIOBIS
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="tacPawpRaiobisResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_RAIOBIS
    </select>

    <select id="findList" resultMap="tacPawpRaiobisResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_RAIOBIS
        <include refid="page_where"/>
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.TacPawpRaiobis">
        update TAC_PAWP_RAIOBIS
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="year != null">YEAR = #{year},</if>
            <if test="yearIssuedSum != null">YEAR_ISSUED_SUM = #{yearIssuedSum},</if>
            <if test="yearIssuedCenter != null">YEAR_ISSUED_CENTER = #{yearIssuedCenter},</if>
            <if test="yearIssuedPro != null">YEAR_ISSUED_PRO = #{yearIssuedPro},</if>
            <if test="yearIssuedCity != null">YEAR_ISSUED_CITY = #{yearIssuedCity},</if>
            <if test="yearIssuedCunty != null">YEAR_ISSUED_CUNTY = #{yearIssuedCunty},</if>
            <if test="yearIssuedOther != null">YEAR_ISSUED_OTHER = #{yearIssuedOther},</if>
            <if test="totalIssuedSum != null">TOTAL_ISSUED_SUM = #{totalIssuedSum},</if>
            <if test="totalIssuedCenter != null">TOTAL_ISSUED_CENTER = #{totalIssuedCenter},</if>
            <if test="totalIssuedPro != null">TOTAL_ISSUED_PRO = #{totalIssuedPro},</if>
            <if test="totalIssuedCity != null">TOTAL_ISSUED_CITY = #{totalIssuedCity},</if>
            <if test="totalIssuedCunty != null">TOTAL_ISSUED_CUNTY = #{totalIssuedCunty},</if>
            <if test="totalIssuedOther != null">TOTAL_ISSUED_OTHER = #{totalIssuedOther},</if>
            <if test="isDat != null">IS_DAT = #{isDat},</if>
            <if test="yearInvestYear != null">YEAR_INVEST_YEAR = #{yearInvestYear},</if>
            <if test="yearInvest != null">YEAR_INVEST = #{yearInvest},</if>
            <if test="yearInvestScale != null">YEAR_INVEST_SCALE = #{yearInvestScale},</if>
            <if test="totalInvest != null">TOTAL_INVEST = #{totalInvest},</if>
            <if test="totalInvestScale != null">TOTAL_INVEST_SCALE = #{totalInvestScale},</if>
            <if test="mainWorks != null">MAIN_WORKS = #{mainWorks},</if>
            <if test="pjctImgPgrs != null">PJCT_IMG_PGRS = #{pjctImgPgrs},</if>
            <if test="remark != null">REMARK = #{remark},</if>
            <if test="note != null">NOTE = #{note},</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.TacPawpRaiobis">
        update TAC_PAWP_RAIOBIS
        <trim prefix="set" suffixOverrides=",">
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="year != null">YEAR = #{year},</if>
            <if test="yearIssuedSum != null">YEAR_ISSUED_SUM = #{yearIssuedSum},</if>
            <if test="yearIssuedCenter != null">YEAR_ISSUED_CENTER = #{yearIssuedCenter},</if>
            <if test="yearIssuedPro != null">YEAR_ISSUED_PRO = #{yearIssuedPro},</if>
            <if test="yearIssuedCity != null">YEAR_ISSUED_CITY = #{yearIssuedCity},</if>
            <if test="yearIssuedCunty != null">YEAR_ISSUED_CUNTY = #{yearIssuedCunty},</if>
            <if test="yearIssuedOther != null">YEAR_ISSUED_OTHER = #{yearIssuedOther},</if>
            <if test="totalIssuedSum != null">TOTAL_ISSUED_SUM = #{totalIssuedSum},</if>
            <if test="totalIssuedCenter != null">TOTAL_ISSUED_CENTER = #{totalIssuedCenter},</if>
            <if test="totalIssuedPro != null">TOTAL_ISSUED_PRO = #{totalIssuedPro},</if>
            <if test="totalIssuedCity != null">TOTAL_ISSUED_CITY = #{totalIssuedCity},</if>
            <if test="totalIssuedCunty != null">TOTAL_ISSUED_CUNTY = #{totalIssuedCunty},</if>
            <if test="totalIssuedOther != null">TOTAL_ISSUED_OTHER = #{totalIssuedOther},</if>
            <if test="isDat != null">IS_DAT = #{isDat},</if>
            <if test="yearInvestYear != null">YEAR_INVEST_YEAR = #{yearInvestYear},</if>
            <if test="yearInvest != null">YEAR_INVEST = #{yearInvest},</if>
            <if test="yearInvestScale != null">YEAR_INVEST_SCALE = #{yearInvestScale},</if>
            <if test="totalInvest != null">TOTAL_INVEST = #{totalInvest},</if>
            <if test="totalInvestScale != null">TOTAL_INVEST_SCALE = #{totalInvestScale},</if>
            <if test="mainWorks != null">MAIN_WORKS = #{mainWorks},</if>
            <if test="pjctImgPgrs != null">PJCT_IMG_PGRS = #{pjctImgPgrs},</if>
            <if test="remark != null">REMARK = #{remark},</if>
            <if test="note != null">NOTE = #{note},</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>