fj-dc/.svn/pristine/fc/fcb93b7675ef591c8e468bc4e3c5132e01a701d2.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.TacPawpBiofuamDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.TacPawpBiofuam" id="tacPawpBiofuamResultMap">
        <result property="invmntCpltnYearSumRate" column="INVMNT_CPLTN_YEAR_SUM_RATE"/>
        <result property="invmntCpltnYearCai" column="INVMNT_CPLTN_YEAR_CAI"/>
        <result property="invmntCpltnYearEi" column="INVMNT_CPLTN_YEAR_EI"/>
        <result property="invmntCpltnYearDi" column="INVMNT_CPLTN_YEAR_DI"/>
        <result property="invmntCpltnYearOther" column="INVMNT_CPLTN_YEAR_OTHER"/>
        <result property="invmntCpltnTotal" column="INVMNT_CPLTN_TOTAL"/>
        <result property="invmntCpltnTotalRate" column="INVMNT_CPLTN_TOTAL_RATE"/>
        <result property="invmntCpltnTotalCai" column="INVMNT_CPLTN_TOTAL_CAI"/>
        <result property="invmntCpltnTotalEi" column="INVMNT_CPLTN_TOTAL_EI"/>
        <result property="invmntCpltnTotalDi" column="INVMNT_CPLTN_TOTAL_DI"/>
        <result property="invmntCpltnTotalOther" column="INVMNT_CPLTN_TOTAL_OTHER"/>
        <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"/>
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="caMnagUnit" column="CA_MNAG_UNIT"/>
        <result property="numppIsEqp" column="NUMPP_IS_EQP"/>
        <result property="bkkpNum" column="BKKP_NUM"/>
        <result property="tllNum" column="TLL_NUM"/>
        <result property="fnclCtrlSys" column="FNCL_CTRL_SYS"/>
        <result property="suzas" column="SUZAS"/>
        <result property="implmttnAcntSys" column="IMPLMTTN_ACNT_SYS"/>
        <result property="fundArvYear" column="FUND_ARV_YEAR"/>
        <result property="fundArvYearSum" column="FUND_ARV_YEAR_SUM"/>
        <result property="fundArvYearSumRate" column="FUND_ARV_YEAR_SUM_RATE"/>
        <result property="fundArvYearCenter" column="FUND_ARV_YEAR_CENTER"/>
        <result property="fundArvYearCenterRate" column="FUND_ARV_YEAR_CENTER_RATE"/>
        <result property="fundArvYearPro" column="FUND_ARV_YEAR_PRO"/>
        <result property="fundArvYearProRate" column="FUND_ARV_YEAR_PRO_RATE"/>
        <result property="fundArvYearCity" column="FUND_ARV_YEAR_CITY"/>
        <result property="fundArvYearCityRate" column="FUND_ARV_YEAR_CITY_RATE"/>
        <result property="fundArvYearCnty" column="FUND_ARV_YEAR_CNTY"/>
        <result property="fundArvYearCntyRate" column="FUND_ARV_YEAR_CNTY_RATE"/>
        <result property="fundArvYearOther" column="FUND_ARV_YEAR_OTHER"/>
        <result property="fundArvYearOtherRate" column="FUND_ARV_YEAR_OTHER_RATE"/>
        <result property="fundArvTotalSum" column="FUND_ARV_TOTAL_SUM"/>
        <result property="fundArvTotalSumRate" column="FUND_ARV_TOTAL_SUM_RATE"/>
        <result property="fundArvTotalCenter" column="FUND_ARV_TOTAL_CENTER"/>
        <result property="fundArvTotalCenterRate" column="FUND_ARV_TOTAL_CENTER_RATE"/>
        <result property="fundArvTotalPro" column="FUND_ARV_TOTAL_PRO"/>
        <result property="fundArvTotalProRate" column="FUND_ARV_TOTAL_PRO_RATE"/>
        <result property="fundArvTotalCity" column="FUND_ARV_TOTAL_CITY"/>
        <result property="fundArvTotalCityRate" column="FUND_ARV_TOTAL_CITY_RATE"/>
        <result property="fundArvTotalCnty" column="FUND_ARV_TOTAL_CNTY"/>
        <result property="fundArvTotalCntyRate" column="FUND_ARV_TOTAL_CNTY_RATE"/>
        <result property="fundArvTotalOther" column="FUND_ARV_TOTAL_OTHER"/>
        <result property="fundArvTotalOtherRate" column="FUND_ARV_TOTAL_OTHER_RATE"/>
        <result property="invmntCpltnYear" column="INVMNT_CPLTN_YEAR"/>
        <result property="invmntCpltnYearSum" column="INVMNT_CPLTN_YEAR_SUM"/>
        <result property="invmntCpltnYearLaiai" column="INVMNT_CPLTN_YEAR_LAIAI"/>
        <result property="invmntCpltnTotalLaiai" column="INVMNT_CPLTN_TOTAL_LAIAI"/>
    </resultMap>

    <sql id="table_columns">
        INVMNT_CPLTN_YEAR_SUM_RATE,INVMNT_CPLTN_YEAR_LAIAI,INVMNT_CPLTN_TOTAL_LAIAI,
        INVMNT_CPLTN_YEAR_CAI,
        INVMNT_CPLTN_YEAR_EI,
        INVMNT_CPLTN_YEAR_DI,
        INVMNT_CPLTN_YEAR_OTHER,
        INVMNT_CPLTN_TOTAL,
        INVMNT_CPLTN_TOTAL_RATE,
        INVMNT_CPLTN_TOTAL_CAI,
        INVMNT_CPLTN_TOTAL_EI,
        INVMNT_CPLTN_TOTAL_DI,
        INVMNT_CPLTN_TOTAL_OTHER,
        REMARK,
        NOTE,
        PERS_ID,
        INTM,
        UPTM,
        DATA_STAT,
        ID,
        RGSTR_ID,
        CA_MNAG_UNIT,
        NUMPP_IS_EQP,
        BKKP_NUM,
        TLL_NUM,
        FNCL_CTRL_SYS,
        SUZAS,
        IMPLMTTN_ACNT_SYS,
        FUND_ARV_YEAR,
        FUND_ARV_YEAR_SUM,
        FUND_ARV_YEAR_SUM_RATE,
        FUND_ARV_YEAR_CENTER,
        FUND_ARV_YEAR_CENTER_RATE,
        FUND_ARV_YEAR_PRO,
        FUND_ARV_YEAR_PRO_RATE,
        FUND_ARV_YEAR_CITY,
        FUND_ARV_YEAR_CITY_RATE,
        FUND_ARV_YEAR_CNTY,
        FUND_ARV_YEAR_CNTY_RATE,
        FUND_ARV_YEAR_OTHER,
        FUND_ARV_YEAR_OTHER_RATE,
        FUND_ARV_TOTAL_SUM,
        FUND_ARV_TOTAL_SUM_RATE,
        FUND_ARV_TOTAL_CENTER,
        FUND_ARV_TOTAL_CENTER_RATE,
        FUND_ARV_TOTAL_PRO,
        FUND_ARV_TOTAL_PRO_RATE,
        FUND_ARV_TOTAL_CITY,
        FUND_ARV_TOTAL_CITY_RATE,
        FUND_ARV_TOTAL_CNTY,
        FUND_ARV_TOTAL_CNTY_RATE,
        FUND_ARV_TOTAL_OTHER,
        FUND_ARV_TOTAL_OTHER_RATE,
        INVMNT_CPLTN_YEAR,
        INVMNT_CPLTN_YEAR_SUM
    </sql>
    <sql id="entity_properties">
        #{invmntCpltnYearSumRate},#{invmntCpltnYearLaiai},#{invmntCpltnTotalLaiai},
        #{invmntCpltnYearCai},
        #{invmntCpltnYearEi},
        #{invmntCpltnYearDi},
        #{invmntCpltnYearOther},
        #{invmntCpltnTotal},
        #{invmntCpltnTotalRate},
        #{invmntCpltnTotalCai},
        #{invmntCpltnTotalEi},
        #{invmntCpltnTotalDi},
        #{invmntCpltnTotalOther},
        #{remark},
        #{note},
        #{persId},
        #{intm},
        #{uptm},
        #{dataStat},
        #{id},
        #{rgstrId},
        #{caMnagUnit},
        #{numppIsEqp},
        #{bkkpNum},
        #{tllNum},
        #{fnclCtrlSys},
        #{suzas},
        #{implmttnAcntSys},
        #{fundArvYear},
        #{fundArvYearSum},
        #{fundArvYearSumRate},
        #{fundArvYearCenter},
        #{fundArvYearCenterRate},
        #{fundArvYearPro},
        #{fundArvYearProRate},
        #{fundArvYearCity},
        #{fundArvYearCityRate},
        #{fundArvYearCnty},
        #{fundArvYearCntyRate},
        #{fundArvYearOther},
        #{fundArvYearOtherRate},
        #{fundArvTotalSum},
        #{fundArvTotalSumRate},
        #{fundArvTotalCenter},
        #{fundArvTotalCenterRate},
        #{fundArvTotalPro},
        #{fundArvTotalProRate},
        #{fundArvTotalCity},
        #{fundArvTotalCityRate},
        #{fundArvTotalCnty},
        #{fundArvTotalCntyRate},
        #{fundArvTotalOther},
        #{fundArvTotalOtherRate},
        #{invmntCpltnYear},
        #{invmntCpltnYearSum}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="invmntCpltnYearSumRate != null and invmntCpltnYearSumRate != ''">and INVMNT_CPLTN_YEAR_SUM_RATE =
                #{invmntCpltnYearSumRate}
            </if>
            <if test="invmntCpltnYearCai != null and invmntCpltnYearCai != ''">and INVMNT_CPLTN_YEAR_CAI =
                #{invmntCpltnYearCai}
            </if>
            <if test="invmntCpltnYearLaiai != null and invmntCpltnYearLaiai != ''">and INVMNT_CPLTN_YEAR_LAIAI =
                #{invmntCpltnYearLaiai}
            </if>
            <if test="invmntCpltnTotalLaiai != null and invmntCpltnTotalLaiai != ''">and INVMNT_CPLTN_TOTAL_LAIAI =
                #{invmntCpltnTotalLaiai}
            </if>
            <if test="invmntCpltnYearEi != null and invmntCpltnYearEi != ''">and INVMNT_CPLTN_YEAR_EI =
                #{invmntCpltnYearEi}
            </if>
            <if test="invmntCpltnYearDi != null and invmntCpltnYearDi != ''">and INVMNT_CPLTN_YEAR_DI =
                #{invmntCpltnYearDi}
            </if>
            <if test="invmntCpltnYearOther != null and invmntCpltnYearOther != ''">and INVMNT_CPLTN_YEAR_OTHER =
                #{invmntCpltnYearOther}
            </if>
            <if test="invmntCpltnTotal != null and invmntCpltnTotal != ''">and INVMNT_CPLTN_TOTAL =
                #{invmntCpltnTotal}
            </if>
            <if test="invmntCpltnTotalRate != null and invmntCpltnTotalRate != ''">and INVMNT_CPLTN_TOTAL_RATE =
                #{invmntCpltnTotalRate}
            </if>
            <if test="invmntCpltnTotalCai != null and invmntCpltnTotalCai != ''">and INVMNT_CPLTN_TOTAL_CAI =
                #{invmntCpltnTotalCai}
            </if>
            <if test="invmntCpltnTotalEi != null and invmntCpltnTotalEi != ''">and INVMNT_CPLTN_TOTAL_EI =
                #{invmntCpltnTotalEi}
            </if>
            <if test="invmntCpltnTotalDi != null and invmntCpltnTotalDi != ''">and INVMNT_CPLTN_TOTAL_DI =
                #{invmntCpltnTotalDi}
            </if>
            <if test="invmntCpltnTotalOther != null and invmntCpltnTotalOther != ''">and INVMNT_CPLTN_TOTAL_OTHER =
                #{invmntCpltnTotalOther}
            </if>
            <if test="remark != null and remark != ''">and REMARK = #{remark}</if>
            <if test="note != null and note != ''">and NOTE = #{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>
            <if test="id != null and id != ''">and ID = #{id}</if>
            <if test="rgstrId != null and rgstrId != ''">and RGSTR_ID = #{rgstrId}</if>
            <if test="caMnagUnit != null and caMnagUnit != ''">and CA_MNAG_UNIT = #{caMnagUnit}</if>
            <if test="numppIsEqp != null and numppIsEqp != ''">and NUMPP_IS_EQP = #{numppIsEqp}</if>
            <if test="bkkpNum != null and bkkpNum != ''">and BKKP_NUM = #{bkkpNum}</if>
            <if test="tllNum != null and tllNum != ''">and TLL_NUM = #{tllNum}</if>
            <if test="fnclCtrlSys != null and fnclCtrlSys != ''">and FNCL_CTRL_SYS = #{fnclCtrlSys}</if>
            <if test="suzas != null and suzas != ''">and SUZAS = #{suzas}</if>
            <if test="implmttnAcntSys != null and implmttnAcntSys != ''">and IMPLMTTN_ACNT_SYS = #{implmttnAcntSys}</if>
            <if test="fundArvYear != null and fundArvYear != ''">and FUND_ARV_YEAR = #{fundArvYear}</if>
            <if test="fundArvYearSum != null and fundArvYearSum != ''">and FUND_ARV_YEAR_SUM = #{fundArvYearSum}</if>
            <if test="fundArvYearSumRate != null and fundArvYearSumRate != ''">and FUND_ARV_YEAR_SUM_RATE =
                #{fundArvYearSumRate}
            </if>
            <if test="fundArvYearCenter != null and fundArvYearCenter != ''">and FUND_ARV_YEAR_CENTER =
                #{fundArvYearCenter}
            </if>
            <if test="fundArvYearCenterRate != null and fundArvYearCenterRate != ''">and FUND_ARV_YEAR_CENTER_RATE =
                #{fundArvYearCenterRate}
            </if>
            <if test="fundArvYearPro != null and fundArvYearPro != ''">and FUND_ARV_YEAR_PRO = #{fundArvYearPro}</if>
            <if test="fundArvYearProRate != null and fundArvYearProRate != ''">and FUND_ARV_YEAR_PRO_RATE =
                #{fundArvYearProRate}
            </if>
            <if test="fundArvYearCity != null and fundArvYearCity != ''">and FUND_ARV_YEAR_CITY = #{fundArvYearCity}
            </if>
            <if test="fundArvYearCityRate != null and fundArvYearCityRate != ''">and FUND_ARV_YEAR_CITY_RATE =
                #{fundArvYearCityRate}
            </if>
            <if test="fundArvYearCnty != null and fundArvYearCnty != ''">and FUND_ARV_YEAR_CNTY = #{fundArvYearCnty}
            </if>
            <if test="fundArvYearCntyRate != null and fundArvYearCntyRate != ''">and FUND_ARV_YEAR_CNTY_RATE =
                #{fundArvYearCntyRate}
            </if>
            <if test="fundArvYearOther != null and fundArvYearOther != ''">and FUND_ARV_YEAR_OTHER =
                #{fundArvYearOther}
            </if>
            <if test="fundArvYearOtherRate != null and fundArvYearOtherRate != ''">and FUND_ARV_YEAR_OTHER_RATE =
                #{fundArvYearOtherRate}
            </if>
            <if test="fundArvTotalSum != null and fundArvTotalSum != ''">and FUND_ARV_TOTAL_SUM = #{fundArvTotalSum}
            </if>
            <if test="fundArvTotalSumRate != null and fundArvTotalSumRate != ''">and FUND_ARV_TOTAL_SUM_RATE =
                #{fundArvTotalSumRate}
            </if>
            <if test="fundArvTotalCenter != null and fundArvTotalCenter != ''">and FUND_ARV_TOTAL_CENTER =
                #{fundArvTotalCenter}
            </if>
            <if test="fundArvTotalCenterRate != null and fundArvTotalCenterRate != ''">and FUND_ARV_TOTAL_CENTER_RATE =
                #{fundArvTotalCenterRate}
            </if>
            <if test="fundArvTotalPro != null and fundArvTotalPro != ''">and FUND_ARV_TOTAL_PRO = #{fundArvTotalPro}
            </if>
            <if test="fundArvTotalProRate != null and fundArvTotalProRate != ''">and FUND_ARV_TOTAL_PRO_RATE =
                #{fundArvTotalProRate}
            </if>
            <if test="fundArvTotalCity != null and fundArvTotalCity != ''">and FUND_ARV_TOTAL_CITY =
                #{fundArvTotalCity}
            </if>
            <if test="fundArvTotalCityRate != null and fundArvTotalCityRate != ''">and FUND_ARV_TOTAL_CITY_RATE =
                #{fundArvTotalCityRate}
            </if>
            <if test="fundArvTotalCnty != null and fundArvTotalCnty != ''">and FUND_ARV_TOTAL_CNTY =
                #{fundArvTotalCnty}
            </if>
            <if test="fundArvTotalCntyRate != null and fundArvTotalCntyRate != ''">and FUND_ARV_TOTAL_CNTY_RATE =
                #{fundArvTotalCntyRate}
            </if>
            <if test="fundArvTotalOther != null and fundArvTotalOther != ''">and FUND_ARV_TOTAL_OTHER =
                #{fundArvTotalOther}
            </if>
            <if test="fundArvTotalOtherRate != null and fundArvTotalOtherRate != ''">and FUND_ARV_TOTAL_OTHER_RATE =
                #{fundArvTotalOtherRate}
            </if>
            <if test="invmntCpltnYear != null and invmntCpltnYear != ''">and INVMNT_CPLTN_YEAR = #{invmntCpltnYear}</if>
            <if test="invmntCpltnYearSum != null and invmntCpltnYearSum != ''">and INVMNT_CPLTN_YEAR_SUM =
                #{invmntCpltnYearSum}
            </if>
        </trim>
    </sql>


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

    <select id="getBy" resultMap="tacPawpBiofuamResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BIOFUAM
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="tacPawpBiofuamResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BIOFUAM
    </select>

    <select id="findList" resultMap="tacPawpBiofuamResultMap">
        select
        <include refid="table_columns"/>
        from TAC_PAWP_BIOFUAM
        <include refid="page_where"/>
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.TacPawpBiofuam">
        update TAC_PAWP_BIOFUAM
        <trim prefix="set" suffixOverrides=",">
            <if test="invmntCpltnYearSumRate != null">INVMNT_CPLTN_YEAR_SUM_RATE = #{invmntCpltnYearSumRate},</if>
            <if test="invmntCpltnYearCai != null">INVMNT_CPLTN_YEAR_CAI = #{invmntCpltnYearCai},</if>
            <if test="invmntCpltnYearEi != null">INVMNT_CPLTN_YEAR_EI = #{invmntCpltnYearEi},</if>
            <if test="invmntCpltnYearDi != null">INVMNT_CPLTN_YEAR_DI = #{invmntCpltnYearDi},</if>
            <if test="invmntCpltnYearOther != null">INVMNT_CPLTN_YEAR_OTHER = #{invmntCpltnYearOther},</if>
            <if test="invmntCpltnTotal != null">INVMNT_CPLTN_TOTAL = #{invmntCpltnTotal},</if>
            <if test="invmntCpltnTotalRate != null">INVMNT_CPLTN_TOTAL_RATE = #{invmntCpltnTotalRate},</if>
            <if test="invmntCpltnTotalCai != null">INVMNT_CPLTN_TOTAL_CAI = #{invmntCpltnTotalCai},</if>
            <if test="invmntCpltnTotalEi != null">INVMNT_CPLTN_TOTAL_EI = #{invmntCpltnTotalEi},</if>
            <if test="invmntCpltnTotalDi != null">INVMNT_CPLTN_TOTAL_DI = #{invmntCpltnTotalDi},</if>
            <if test="invmntCpltnTotalOther != null">INVMNT_CPLTN_TOTAL_OTHER = #{invmntCpltnTotalOther},</if>
            <if test="invmntCpltnYearLaiai != null">INVMNT_CPLTN_YEAR_LAIAI = #{invmntCpltnYearLaiai},</if>
            <if test="invmntCpltnTotalLaiai != null">INVMNT_CPLTN_TOTAL_LAIAI = #{invmntCpltnTotalLaiai},</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>
            <if test="id != null and id != ''">ID = #{id},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="caMnagUnit != null">CA_MNAG_UNIT = #{caMnagUnit},</if>
            <if test="numppIsEqp != null">NUMPP_IS_EQP = #{numppIsEqp},</if>
            <if test="bkkpNum != null">BKKP_NUM = #{bkkpNum},</if>
            <if test="tllNum != null">TLL_NUM = #{tllNum},</if>
            <if test="fnclCtrlSys != null">FNCL_CTRL_SYS = #{fnclCtrlSys},</if>
            <if test="suzas != null">SUZAS = #{suzas},</if>
            <if test="implmttnAcntSys != null">IMPLMTTN_ACNT_SYS = #{implmttnAcntSys},</if>
            <if test="fundArvYear != null">FUND_ARV_YEAR = #{fundArvYear},</if>
            <if test="fundArvYearSum != null">FUND_ARV_YEAR_SUM = #{fundArvYearSum},</if>
            <if test="fundArvYearSumRate != null">FUND_ARV_YEAR_SUM_RATE = #{fundArvYearSumRate},</if>
            <if test="fundArvYearCenter != null">FUND_ARV_YEAR_CENTER = #{fundArvYearCenter},</if>
            <if test="fundArvYearCenterRate != null">FUND_ARV_YEAR_CENTER_RATE = #{fundArvYearCenterRate},</if>
            <if test="fundArvYearPro != null">FUND_ARV_YEAR_PRO = #{fundArvYearPro},</if>
            <if test="fundArvYearProRate != null">FUND_ARV_YEAR_PRO_RATE = #{fundArvYearProRate},</if>
            <if test="fundArvYearCity != null">FUND_ARV_YEAR_CITY = #{fundArvYearCity},</if>
            <if test="fundArvYearCityRate != null">FUND_ARV_YEAR_CITY_RATE = #{fundArvYearCityRate},</if>
            <if test="fundArvYearCnty != null">FUND_ARV_YEAR_CNTY = #{fundArvYearCnty},</if>
            <if test="fundArvYearCntyRate != null">FUND_ARV_YEAR_CNTY_RATE = #{fundArvYearCntyRate},</if>
            <if test="fundArvYearOther != null">FUND_ARV_YEAR_OTHER = #{fundArvYearOther},</if>
            <if test="fundArvYearOtherRate != null">FUND_ARV_YEAR_OTHER_RATE = #{fundArvYearOtherRate},</if>
            <if test="fundArvTotalSum != null">FUND_ARV_TOTAL_SUM = #{fundArvTotalSum},</if>
            <if test="fundArvTotalSumRate != null">FUND_ARV_TOTAL_SUM_RATE = #{fundArvTotalSumRate},</if>
            <if test="fundArvTotalCenter != null">FUND_ARV_TOTAL_CENTER = #{fundArvTotalCenter},</if>
            <if test="fundArvTotalCenterRate != null">FUND_ARV_TOTAL_CENTER_RATE = #{fundArvTotalCenterRate},</if>
            <if test="fundArvTotalPro != null">FUND_ARV_TOTAL_PRO = #{fundArvTotalPro},</if>
            <if test="fundArvTotalProRate != null">FUND_ARV_TOTAL_PRO_RATE = #{fundArvTotalProRate},</if>
            <if test="fundArvTotalCity != null">FUND_ARV_TOTAL_CITY = #{fundArvTotalCity},</if>
            <if test="fundArvTotalCityRate != null">FUND_ARV_TOTAL_CITY_RATE = #{fundArvTotalCityRate},</if>
            <if test="fundArvTotalCnty != null">FUND_ARV_TOTAL_CNTY = #{fundArvTotalCnty},</if>
            <if test="fundArvTotalCntyRate != null">FUND_ARV_TOTAL_CNTY_RATE = #{fundArvTotalCntyRate},</if>
            <if test="fundArvTotalOther != null">FUND_ARV_TOTAL_OTHER = #{fundArvTotalOther},</if>
            <if test="fundArvTotalOtherRate != null">FUND_ARV_TOTAL_OTHER_RATE = #{fundArvTotalOtherRate},</if>
            <if test="invmntCpltnYear != null">INVMNT_CPLTN_YEAR = #{invmntCpltnYear},</if>
            <if test="invmntCpltnYearSum != null">INVMNT_CPLTN_YEAR_SUM = #{invmntCpltnYearSum},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.TacPawpBiofuam">
        update TAC_PAWP_BIOFUAM
        <trim prefix="set" suffixOverrides=",">
            <if test="invmntCpltnYearSumRate != null">INVMNT_CPLTN_YEAR_SUM_RATE = #{invmntCpltnYearSumRate},</if>
            <if test="invmntCpltnYearCai != null">INVMNT_CPLTN_YEAR_CAI = #{invmntCpltnYearCai},</if>
            <if test="invmntCpltnYearEi != null">INVMNT_CPLTN_YEAR_EI = #{invmntCpltnYearEi},</if>
            <if test="invmntCpltnYearDi != null">INVMNT_CPLTN_YEAR_DI = #{invmntCpltnYearDi},</if>
            <if test="invmntCpltnYearOther != null">INVMNT_CPLTN_YEAR_OTHER = #{invmntCpltnYearOther},</if>
            <if test="invmntCpltnTotal != null">INVMNT_CPLTN_TOTAL = #{invmntCpltnTotal},</if>
            <if test="invmntCpltnTotalRate != null">INVMNT_CPLTN_TOTAL_RATE = #{invmntCpltnTotalRate},</if>
            <if test="invmntCpltnTotalCai != null">INVMNT_CPLTN_TOTAL_CAI = #{invmntCpltnTotalCai},</if>
            <if test="invmntCpltnTotalEi != null">INVMNT_CPLTN_TOTAL_EI = #{invmntCpltnTotalEi},</if>
            <if test="invmntCpltnTotalDi != null">INVMNT_CPLTN_TOTAL_DI = #{invmntCpltnTotalDi},</if>
            <if test="invmntCpltnTotalOther != null">INVMNT_CPLTN_TOTAL_OTHER = #{invmntCpltnTotalOther},</if>
            <if test="remark != null">REMARK = #{remark},</if>
            <if test="note != null">NOTE = #{note},</if>
            <if test="invmntCpltnYearLaiai != null">INVMNT_CPLTN_YEAR_LAIAI = #{invmntCpltnYearLaiai},</if>
            <if test="invmntCpltnTotalLaiai != null">INVMNT_CPLTN_TOTAL_LAIAI = #{invmntCpltnTotalLaiai},</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>
            <if test="id != null and id != ''">ID = #{id},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="caMnagUnit != null">CA_MNAG_UNIT = #{caMnagUnit},</if>
            <if test="numppIsEqp != null">NUMPP_IS_EQP = #{numppIsEqp},</if>
            <if test="bkkpNum != null">BKKP_NUM = #{bkkpNum},</if>
            <if test="tllNum != null">TLL_NUM = #{tllNum},</if>
            <if test="fnclCtrlSys != null">FNCL_CTRL_SYS = #{fnclCtrlSys},</if>
            <if test="suzas != null">SUZAS = #{suzas},</if>
            <if test="implmttnAcntSys != null">IMPLMTTN_ACNT_SYS = #{implmttnAcntSys},</if>
            <if test="fundArvYear != null">FUND_ARV_YEAR = #{fundArvYear},</if>
            <if test="fundArvYearSum != null">FUND_ARV_YEAR_SUM = #{fundArvYearSum},</if>
            <if test="fundArvYearSumRate != null">FUND_ARV_YEAR_SUM_RATE = #{fundArvYearSumRate},</if>
            <if test="fundArvYearCenter != null">FUND_ARV_YEAR_CENTER = #{fundArvYearCenter},</if>
            <if test="fundArvYearCenterRate != null">FUND_ARV_YEAR_CENTER_RATE = #{fundArvYearCenterRate},</if>
            <if test="fundArvYearPro != null">FUND_ARV_YEAR_PRO = #{fundArvYearPro},</if>
            <if test="fundArvYearProRate != null">FUND_ARV_YEAR_PRO_RATE = #{fundArvYearProRate},</if>
            <if test="fundArvYearCity != null">FUND_ARV_YEAR_CITY = #{fundArvYearCity},</if>
            <if test="fundArvYearCityRate != null">FUND_ARV_YEAR_CITY_RATE = #{fundArvYearCityRate},</if>
            <if test="fundArvYearCnty != null">FUND_ARV_YEAR_CNTY = #{fundArvYearCnty},</if>
            <if test="fundArvYearCntyRate != null">FUND_ARV_YEAR_CNTY_RATE = #{fundArvYearCntyRate},</if>
            <if test="fundArvYearOther != null">FUND_ARV_YEAR_OTHER = #{fundArvYearOther},</if>
            <if test="fundArvYearOtherRate != null">FUND_ARV_YEAR_OTHER_RATE = #{fundArvYearOtherRate},</if>
            <if test="fundArvTotalSum != null">FUND_ARV_TOTAL_SUM = #{fundArvTotalSum},</if>
            <if test="fundArvTotalSumRate != null">FUND_ARV_TOTAL_SUM_RATE = #{fundArvTotalSumRate},</if>
            <if test="fundArvTotalCenter != null">FUND_ARV_TOTAL_CENTER = #{fundArvTotalCenter},</if>
            <if test="fundArvTotalCenterRate != null">FUND_ARV_TOTAL_CENTER_RATE = #{fundArvTotalCenterRate},</if>
            <if test="fundArvTotalPro != null">FUND_ARV_TOTAL_PRO = #{fundArvTotalPro},</if>
            <if test="fundArvTotalProRate != null">FUND_ARV_TOTAL_PRO_RATE = #{fundArvTotalProRate},</if>
            <if test="fundArvTotalCity != null">FUND_ARV_TOTAL_CITY = #{fundArvTotalCity},</if>
            <if test="fundArvTotalCityRate != null">FUND_ARV_TOTAL_CITY_RATE = #{fundArvTotalCityRate},</if>
            <if test="fundArvTotalCnty != null">FUND_ARV_TOTAL_CNTY = #{fundArvTotalCnty},</if>
            <if test="fundArvTotalCntyRate != null">FUND_ARV_TOTAL_CNTY_RATE = #{fundArvTotalCntyRate},</if>
            <if test="fundArvTotalOther != null">FUND_ARV_TOTAL_OTHER = #{fundArvTotalOther},</if>
            <if test="fundArvTotalOtherRate != null">FUND_ARV_TOTAL_OTHER_RATE = #{fundArvTotalOtherRate},</if>
            <if test="invmntCpltnYear != null">INVMNT_CPLTN_YEAR = #{invmntCpltnYear},</if>
            <if test="invmntCpltnYearSum != null">INVMNT_CPLTN_YEAR_SUM = #{invmntCpltnYearSum},</if>
        </trim>
        <include refid="page_where"/>
    </update>


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


</mapper>