fj-dc/.svn/pristine/b3/b322b4e5f2f42924bff0475085e30ba1ca8d7b95.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.BisInspStstnTmprDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspStstnTmpr" id="bisInspStstnTmprResultMap">
            <result property="iibKillNum" column="IIB_KILL_NUM"/>
            <result property="iibDistNum" column="IIB_DIST_NUM"/>
            <result property="akDistNum" column="AK_DIST_NUM"/>
            <result property="iibNroomNum" column="IIB_NROOM_NUM"/>
            <result property="cablePrctNum" column="CABLE_PRCT_NUM"/>
            <result property="isLineFix" column="IS_LINE_FIX"/>
            <result property="fixLineNum" column="FIX_LINE_NUM"/>
            <result property="isFixSame" column="IS_FIX_SAME"/>
            <result property="fixSameFix" column="FIX_SAME_FIX"/>
            <result property="isPowerSame" column="IS_POWER_SAME"/>
            <result property="powerSameNum" column="POWER_SAME_NUM"/>
            <result property="ledRghtNum" column="LED_RGHT_NUM"/>
            <result property="siteSysNum" column="SITE_SYS_NUM"/>
            <result property="isFrpCnfr" column="IS_FRP_CNFR"/>
            <result property="frpCnfrNum" column="FRP_CNFR_NUM"/>
            <result property="isFrpRqr" column="IS_FRP_RQR"/>
            <result property="frpRqrNum" column="FRP_RQR_NUM"/>
            <result property="isFrpGap" column="IS_FRP_GAP"/>
            <result property="frpGapNum" column="FRP_GAP_NUM"/>
            <result property="isBttmGap" column="IS_BTTM_GAP"/>
            <result property="bttmGapNum" column="BTTM_GAP_NUM"/>
            <result property="isTopGap" column="IS_TOP_GAP"/>
            <result property="topGapNum" column="TOP_GAP_NUM"/>
            <result property="isLngtGap" column="IS_LNGT_GAP"/>
            <result property="lngtGapNum" column="LNGT_GAP_NUM"/>
            <result property="isNaerRqr" column="IS_NAER_RQR"/>
            <result property="naerRqrNum" column="NAER_RQR_NUM"/>
            <result property="isSplcRqr" column="IS_SPLC_RQR"/>
            <result property="splcRqrNum" column="SPLC_RQR_NUM"/>
            <result property="isFrpFix" column="IS_FRP_FIX"/>
            <result property="frpFixNum" column="FRP_FIX_NUM"/>
            <result property="isTfrpFix" column="IS_TFRP_FIX"/>
            <result property="tfrpFixNum" column="TFRP_FIX_NUM"/>
            <result property="isTfrpBuld" column="IS_TFRP_BULD"/>
            <result property="tfrpBuldNum" column="TFRP_BULD_NUM"/>
            <result property="isFloorRqr" column="IS_FLOOR_RQR"/>
            <result property="floorRqrNum" column="FLOOR_RQR_NUM"/>
            <result property="isLfrpFix" column="IS_LFRP_FIX"/>
            <result property="lfrpFixNum" column="LFRP_FIX_NUM"/>
            <result property="isFrpChnn" column="IS_FRP_CHNN"/>
            <result property="frpChnnNum" column="FRP_CHNN_NUM"/>
            <result property="isFrpPass" column="IS_FRP_PASS"/>
            <result property="frpPassNum" column="FRP_PASS_NUM"/>
            <result property="isSiteC30" column="IS_SITE_C30"/>
            <result property="siteC30Num" column="SITE_C30_NUM"/>
            <result property="isSiteLoc" column="IS_SITE_LOC"/>
            <result property="siteLocNum" column="SITE_LOC_NUM"/>
            <result property="isSiteLmt" column="IS_SITE_LMT"/>
            <result property="siteLmtNum" column="SITE_LMT_NUM"/>
            <result property="isRiskPub" column="IS_RISK_PUB"/>
            <result property="riskPubNum" column="RISK_PUB_NUM"/>
            <result property="isSiteRqr" column="IS_SITE_RQR"/>
            <result property="siteRqrNum" column="SITE_RQR_NUM"/>
            <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="total" column="TOTAL"/>
            <result property="actualScore" column="ACTUAL_SCORE"/>
            <result property="id" column="ID"/>
            <result property="rgstrId" column="RGSTR_ID"/>
            <result property="iibPrctNum" column="IIB_PRCT_NUM"/>
    </resultMap>

    <sql id="table_columns">
            IIB_KILL_NUM,
            IIB_DIST_NUM,
            AK_DIST_NUM,
            IIB_NROOM_NUM,
            CABLE_PRCT_NUM,
            IS_LINE_FIX,
            FIX_LINE_NUM,
            IS_FIX_SAME,
            FIX_SAME_FIX,
            IS_POWER_SAME,
            POWER_SAME_NUM,
            LED_RGHT_NUM,
            SITE_SYS_NUM,
            IS_FRP_CNFR,
            FRP_CNFR_NUM,
            IS_FRP_RQR,
            FRP_RQR_NUM,
            IS_FRP_GAP,
            FRP_GAP_NUM,
            IS_BTTM_GAP,
            BTTM_GAP_NUM,
            IS_TOP_GAP,
            TOP_GAP_NUM,
            IS_LNGT_GAP,
            LNGT_GAP_NUM,
            IS_NAER_RQR,
            NAER_RQR_NUM,
            IS_SPLC_RQR,
            SPLC_RQR_NUM,
            IS_FRP_FIX,
            FRP_FIX_NUM,
            IS_TFRP_FIX,
            TFRP_FIX_NUM,
            IS_TFRP_BULD,
            TFRP_BULD_NUM,
            IS_FLOOR_RQR,
            FLOOR_RQR_NUM,
            IS_LFRP_FIX,
            LFRP_FIX_NUM,
            IS_FRP_CHNN,
            FRP_CHNN_NUM,
            IS_FRP_PASS,
            FRP_PASS_NUM,
            IS_SITE_C30,
            SITE_C30_NUM,
            IS_SITE_LOC,
            SITE_LOC_NUM,
            IS_SITE_LMT,
            SITE_LMT_NUM,
            IS_RISK_PUB,
            RISK_PUB_NUM,
            IS_SITE_RQR,
            SITE_RQR_NUM,
            NOTE,
            PERS_ID,
            INTM,
            UPTM,
            DATA_STAT,
            TOTAL,
            ACTUAL_SCORE,
            ID,
            RGSTR_ID,
            IIB_PRCT_NUM
    </sql>
    <sql id="entity_properties">
            #{iibKillNum},
            #{iibDistNum},
            #{akDistNum},
            #{iibNroomNum},
            #{cablePrctNum},
            #{isLineFix},
            #{fixLineNum},
            #{isFixSame},
            #{fixSameFix},
            #{isPowerSame},
            #{powerSameNum},
            #{ledRghtNum},
            #{siteSysNum},
            #{isFrpCnfr},
            #{frpCnfrNum},
            #{isFrpRqr},
            #{frpRqrNum},
            #{isFrpGap},
            #{frpGapNum},
            #{isBttmGap},
            #{bttmGapNum},
            #{isTopGap},
            #{topGapNum},
            #{isLngtGap},
            #{lngtGapNum},
            #{isNaerRqr},
            #{naerRqrNum},
            #{isSplcRqr},
            #{splcRqrNum},
            #{isFrpFix},
            #{frpFixNum},
            #{isTfrpFix},
            #{tfrpFixNum},
            #{isTfrpBuld},
            #{tfrpBuldNum},
            #{isFloorRqr},
            #{floorRqrNum},
            #{isLfrpFix},
            #{lfrpFixNum},
            #{isFrpChnn},
            #{frpChnnNum},
            #{isFrpPass},
            #{frpPassNum},
            #{isSiteC30},
            #{siteC30Num},
            #{isSiteLoc},
            #{siteLocNum},
            #{isSiteLmt},
            #{siteLmtNum},
            #{isRiskPub},
            #{riskPubNum},
            #{isSiteRqr},
            #{siteRqrNum},
            #{note},
            #{persId},
            #{intm},
            #{uptm},
            #{dataStat},
            #{total},
            #{actualScore},
            #{id},
            #{rgstrId},
            #{iibPrctNum}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
                    <if test="iibKillNum != null ">
                        and IIB_KILL_NUM = #{iibKillNum}
                    </if>
                    <if test="iibDistNum != null ">
                        and IIB_DIST_NUM = #{iibDistNum}
                    </if>
                    <if test="akDistNum != null ">
                        and AK_DIST_NUM = #{akDistNum}
                    </if>
                    <if test="iibNroomNum != null ">
                        and IIB_NROOM_NUM = #{iibNroomNum}
                    </if>
                    <if test="cablePrctNum != null ">
                        and CABLE_PRCT_NUM = #{cablePrctNum}
                    </if>
                    <if test="isLineFix != null and isLineFix != ''">
                        and IS_LINE_FIX = #{isLineFix}
                    </if>
                    <if test="fixLineNum != null ">
                        and FIX_LINE_NUM = #{fixLineNum}
                    </if>
                    <if test="isFixSame != null and isFixSame != ''">
                        and IS_FIX_SAME = #{isFixSame}
                    </if>
                    <if test="fixSameFix != null and fixSameFix != ''">
                        and FIX_SAME_FIX = #{fixSameFix}
                    </if>
                    <if test="isPowerSame != null and isPowerSame != ''">
                        and IS_POWER_SAME = #{isPowerSame}
                    </if>
                    <if test="powerSameNum != null ">
                        and POWER_SAME_NUM = #{powerSameNum}
                    </if>
                    <if test="ledRghtNum != null ">
                        and LED_RGHT_NUM = #{ledRghtNum}
                    </if>
                    <if test="siteSysNum != null ">
                        and SITE_SYS_NUM = #{siteSysNum}
                    </if>
                    <if test="isFrpCnfr != null and isFrpCnfr != ''">
                        and IS_FRP_CNFR = #{isFrpCnfr}
                    </if>
                    <if test="frpCnfrNum != null ">
                        and FRP_CNFR_NUM = #{frpCnfrNum}
                    </if>
                    <if test="isFrpRqr != null and isFrpRqr != ''">
                        and IS_FRP_RQR = #{isFrpRqr}
                    </if>
                    <if test="frpRqrNum != null ">
                        and FRP_RQR_NUM = #{frpRqrNum}
                    </if>
                    <if test="isFrpGap != null and isFrpGap != ''">
                        and IS_FRP_GAP = #{isFrpGap}
                    </if>
                    <if test="frpGapNum != null ">
                        and FRP_GAP_NUM = #{frpGapNum}
                    </if>
                    <if test="isBttmGap != null and isBttmGap != ''">
                        and IS_BTTM_GAP = #{isBttmGap}
                    </if>
                    <if test="bttmGapNum != null ">
                        and BTTM_GAP_NUM = #{bttmGapNum}
                    </if>
                    <if test="isTopGap != null and isTopGap != ''">
                        and IS_TOP_GAP = #{isTopGap}
                    </if>
                    <if test="topGapNum != null ">
                        and TOP_GAP_NUM = #{topGapNum}
                    </if>
                    <if test="isLngtGap != null and isLngtGap != ''">
                        and IS_LNGT_GAP = #{isLngtGap}
                    </if>
                    <if test="lngtGapNum != null ">
                        and LNGT_GAP_NUM = #{lngtGapNum}
                    </if>
                    <if test="isNaerRqr != null and isNaerRqr != ''">
                        and IS_NAER_RQR = #{isNaerRqr}
                    </if>
                    <if test="naerRqrNum != null ">
                        and NAER_RQR_NUM = #{naerRqrNum}
                    </if>
                    <if test="isSplcRqr != null and isSplcRqr != ''">
                        and IS_SPLC_RQR = #{isSplcRqr}
                    </if>
                    <if test="splcRqrNum != null ">
                        and SPLC_RQR_NUM = #{splcRqrNum}
                    </if>
                    <if test="isFrpFix != null and isFrpFix != ''">
                        and IS_FRP_FIX = #{isFrpFix}
                    </if>
                    <if test="frpFixNum != null ">
                        and FRP_FIX_NUM = #{frpFixNum}
                    </if>
                    <if test="isTfrpFix != null and isTfrpFix != ''">
                        and IS_TFRP_FIX = #{isTfrpFix}
                    </if>
                    <if test="tfrpFixNum != null ">
                        and TFRP_FIX_NUM = #{tfrpFixNum}
                    </if>
                    <if test="isTfrpBuld != null and isTfrpBuld != ''">
                        and IS_TFRP_BULD = #{isTfrpBuld}
                    </if>
                    <if test="tfrpBuldNum != null ">
                        and TFRP_BULD_NUM = #{tfrpBuldNum}
                    </if>
                    <if test="isFloorRqr != null and isFloorRqr != ''">
                        and IS_FLOOR_RQR = #{isFloorRqr}
                    </if>
                    <if test="floorRqrNum != null ">
                        and FLOOR_RQR_NUM = #{floorRqrNum}
                    </if>
                    <if test="isLfrpFix != null and isLfrpFix != ''">
                        and IS_LFRP_FIX = #{isLfrpFix}
                    </if>
                    <if test="lfrpFixNum != null ">
                        and LFRP_FIX_NUM = #{lfrpFixNum}
                    </if>
                    <if test="isFrpChnn != null and isFrpChnn != ''">
                        and IS_FRP_CHNN = #{isFrpChnn}
                    </if>
                    <if test="frpChnnNum != null ">
                        and FRP_CHNN_NUM = #{frpChnnNum}
                    </if>
                    <if test="isFrpPass != null and isFrpPass != ''">
                        and IS_FRP_PASS = #{isFrpPass}
                    </if>
                    <if test="frpPassNum != null ">
                        and FRP_PASS_NUM = #{frpPassNum}
                    </if>
                    <if test="isSiteC30 != null and isSiteC30 != ''">
                        and IS_SITE_C30 = #{isSiteC30}
                    </if>
                    <if test="siteC30Num != null ">
                        and SITE_C30_NUM = #{siteC30Num}
                    </if>
                    <if test="isSiteLoc != null and isSiteLoc != ''">
                        and IS_SITE_LOC = #{isSiteLoc}
                    </if>
                    <if test="siteLocNum != null ">
                        and SITE_LOC_NUM = #{siteLocNum}
                    </if>
                    <if test="isSiteLmt != null and isSiteLmt != ''">
                        and IS_SITE_LMT = #{isSiteLmt}
                    </if>
                    <if test="siteLmtNum != null ">
                        and SITE_LMT_NUM = #{siteLmtNum}
                    </if>
                    <if test="isRiskPub != null and isRiskPub != ''">
                        and IS_RISK_PUB = #{isRiskPub}
                    </if>
                    <if test="riskPubNum != null ">
                        and RISK_PUB_NUM = #{riskPubNum}
                    </if>
                    <if test="isSiteRqr != null and isSiteRqr != ''">
                        and IS_SITE_RQR = #{isSiteRqr}
                    </if>
                    <if test="siteRqrNum != null ">
                        and SITE_RQR_NUM = #{siteRqrNum}
                    </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="total != null and total != ''">
                        and TOTAL = #{total}
                    </if>
                    <if test="actualScore != null and actualScore != ''">
                        and ACTUAL_SCORE = #{actualScore}
                    </if>
                    <if test="rgstrId != null and rgstrId != ''">
                        and RGSTR_ID = #{rgstrId}
                    </if>
                    <if test="iibPrctNum != null ">
                        and IIB_PRCT_NUM = #{iibPrctNum}
                    </if>
            and DATA_STAT='0'
        </trim>
    </sql>


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

    <select id="getBy" resultMap="bisInspStstnTmprResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_STSTN_TMPR
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="bisInspStstnTmprResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_STSTN_TMPR
    </select>

    <select id="findList" resultMap="bisInspStstnTmprResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_STSTN_TMPR
        <include refid="page_where"/>
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspStstnTmpr">
        update BIS_INSP_STSTN_TMPR
        <trim prefix="set" suffixOverrides=",">
                <if test="iibKillNum != null">IIB_KILL_NUM
                    = #{iibKillNum},
                </if>
                <if test="iibDistNum != null">IIB_DIST_NUM
                    = #{iibDistNum},
                </if>
                <if test="akDistNum != null">AK_DIST_NUM
                    = #{akDistNum},
                </if>
                <if test="iibNroomNum != null">IIB_NROOM_NUM
                    = #{iibNroomNum},
                </if>
                <if test="cablePrctNum != null ">CABLE_PRCT_NUM
                    = #{cablePrctNum},
                </if>
                <if test="isLineFix != null and isLineFix != ''">IS_LINE_FIX
                    = #{isLineFix},
                </if>
                <if test="fixLineNum != null">FIX_LINE_NUM
                    = #{fixLineNum},
                </if>
                <if test="isFixSame != null and isFixSame != ''">IS_FIX_SAME
                    = #{isFixSame},
                </if>
                <if test="fixSameFix != null">FIX_SAME_FIX
                    = #{fixSameFix},
                </if>
                <if test="isPowerSame != null and isPowerSame != ''">IS_POWER_SAME
                    = #{isPowerSame},
                </if>
                <if test="powerSameNum != null">POWER_SAME_NUM
                    = #{powerSameNum},
                </if>
                <if test="ledRghtNum != null">LED_RGHT_NUM
                    = #{ledRghtNum},
                </if>
                <if test="siteSysNum != null">SITE_SYS_NUM
                    = #{siteSysNum},
                </if>
                <if test="isFrpCnfr != null and isFrpCnfr != ''">IS_FRP_CNFR
                    = #{isFrpCnfr},
                </if>
                <if test="frpCnfrNum != null">FRP_CNFR_NUM
                    = #{frpCnfrNum},
                </if>
                <if test="isFrpRqr != null and isFrpRqr != ''">IS_FRP_RQR
                    = #{isFrpRqr},
                </if>
                <if test="frpRqrNum != null">FRP_RQR_NUM
                    = #{frpRqrNum},
                </if>
                <if test="isFrpGap != null and isFrpGap != ''">IS_FRP_GAP
                    = #{isFrpGap},
                </if>
                <if test="frpGapNum != null">FRP_GAP_NUM
                    = #{frpGapNum},
                </if>
                <if test="isBttmGap != null and isBttmGap != ''">IS_BTTM_GAP
                    = #{isBttmGap},
                </if>
                <if test="bttmGapNum != null">BTTM_GAP_NUM
                    = #{bttmGapNum},
                </if>
                <if test="isTopGap != null and isTopGap != ''">IS_TOP_GAP
                    = #{isTopGap},
                </if>
                <if test="topGapNum != null">TOP_GAP_NUM
                    = #{topGapNum},
                </if>
                <if test="isLngtGap != null and isLngtGap != ''">IS_LNGT_GAP
                    = #{isLngtGap},
                </if>
                <if test="lngtGapNum != null">LNGT_GAP_NUM
                    = #{lngtGapNum},
                </if>
                <if test="isNaerRqr != null and isNaerRqr != ''">IS_NAER_RQR
                    = #{isNaerRqr},
                </if>
                <if test="naerRqrNum != null">NAER_RQR_NUM
                    = #{naerRqrNum},
                </if>
                <if test="isSplcRqr != null and isSplcRqr != ''">IS_SPLC_RQR
                    = #{isSplcRqr},
                </if>
                <if test="splcRqrNum != null">SPLC_RQR_NUM
                    = #{splcRqrNum},
                </if>
                <if test="isFrpFix != null and isFrpFix != ''">IS_FRP_FIX
                    = #{isFrpFix},
                </if>
                <if test="frpFixNum != null">FRP_FIX_NUM
                    = #{frpFixNum},
                </if>
                <if test="isTfrpFix != null and isTfrpFix != ''">IS_TFRP_FIX
                    = #{isTfrpFix},
                </if>
                <if test="tfrpFixNum != null">TFRP_FIX_NUM
                    = #{tfrpFixNum},
                </if>
                <if test="isTfrpBuld != null and isTfrpBuld != ''">IS_TFRP_BULD
                    = #{isTfrpBuld},
                </if>
                <if test="tfrpBuldNum != null">TFRP_BULD_NUM
                    = #{tfrpBuldNum},
                </if>
                <if test="isFloorRqr != null and isFloorRqr != ''">IS_FLOOR_RQR
                    = #{isFloorRqr},
                </if>
                <if test="floorRqrNum != null">FLOOR_RQR_NUM
                    = #{floorRqrNum},
                </if>
                <if test="isLfrpFix != null and isLfrpFix != ''">IS_LFRP_FIX
                    = #{isLfrpFix},
                </if>
                <if test="lfrpFixNum != null">LFRP_FIX_NUM
                    = #{lfrpFixNum},
                </if>
                <if test="isFrpChnn != null and isFrpChnn != ''">IS_FRP_CHNN
                    = #{isFrpChnn},
                </if>
                <if test="frpChnnNum != null">FRP_CHNN_NUM
                    = #{frpChnnNum},
                </if>
                <if test="isFrpPass != null and isFrpPass != ''">IS_FRP_PASS
                    = #{isFrpPass},
                </if>
                <if test="frpPassNum != null">FRP_PASS_NUM
                    = #{frpPassNum},
                </if>
                <if test="isSiteC30 != null and isSiteC30 != ''">IS_SITE_C30
                    = #{isSiteC30},
                </if>
                <if test="siteC30Num != null">SITE_C30_NUM
                    = #{siteC30Num},
                </if>
                <if test="isSiteLoc != null and isSiteLoc != ''">IS_SITE_LOC
                    = #{isSiteLoc},
                </if>
                <if test="siteLocNum != null">SITE_LOC_NUM
                    = #{siteLocNum},
                </if>
                <if test="isSiteLmt != null and isSiteLmt != ''">IS_SITE_LMT
                    = #{isSiteLmt},
                </if>
                <if test="siteLmtNum != null">SITE_LMT_NUM
                    = #{siteLmtNum},
                </if>
                <if test="isRiskPub != null and isRiskPub != ''">IS_RISK_PUB
                    = #{isRiskPub},
                </if>
                <if test="riskPubNum != null">RISK_PUB_NUM
                    = #{riskPubNum},
                </if>
                <if test="isSiteRqr != null and isSiteRqr != ''">IS_SITE_RQR
                    = #{isSiteRqr},
                </if>
                <if test="siteRqrNum != null">SITE_RQR_NUM
                    = #{siteRqrNum},
                </if>
                <if test="note != null and note != ''">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="total != null">TOTAL
                    = #{total},
                </if>
                <if test="actualScore != null">ACTUAL_SCORE
                    = #{actualScore},
                </if>
                <if test="rgstrId != null and rgstrId != ''">RGSTR_ID
                    = #{rgstrId},
                </if>
                <if test="iibPrctNum != null">IIB_PRCT_NUM
                    = #{iibPrctNum},
                </if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspStstnTmpr">
        update BIS_INSP_STSTN_TMPR
        <trim prefix="set" suffixOverrides=",">
                <if test="iibKillNum != null ">IIB_KILL_NUM
                    = #{iibKillNum},
                </if>
                <if test="iibDistNum != null ">IIB_DIST_NUM
                    = #{iibDistNum},
                </if>
                <if test="akDistNum != null ">AK_DIST_NUM
                    = #{akDistNum},
                </if>
                <if test="iibNroomNum != null ">IIB_NROOM_NUM
                    = #{iibNroomNum},
                </if>
                <if test="cablePrctNum != null ">CABLE_PRCT_NUM
                    = #{cablePrctNum},
                </if>
                <if test="isLineFix != null and isLineFix != ''">IS_LINE_FIX
                    = #{isLineFix},
                </if>
                <if test="fixLineNum != null ">FIX_LINE_NUM
                    = #{fixLineNum},
                </if>
                <if test="isFixSame != null and isFixSame != ''">IS_FIX_SAME
                    = #{isFixSame},
                </if>
                <if test="fixSameFix != null and fixSameFix != ''">FIX_SAME_FIX
                    = #{fixSameFix},
                </if>
                <if test="isPowerSame != null and isPowerSame != ''">IS_POWER_SAME
                    = #{isPowerSame},
                </if>
                <if test="powerSameNum != null ">POWER_SAME_NUM
                    = #{powerSameNum},
                </if>
                <if test="ledRghtNum != null ">LED_RGHT_NUM
                    = #{ledRghtNum},
                </if>
                <if test="siteSysNum != null ">SITE_SYS_NUM
                    = #{siteSysNum},
                </if>
                <if test="isFrpCnfr != null and isFrpCnfr != ''">IS_FRP_CNFR
                    = #{isFrpCnfr},
                </if>
                <if test="frpCnfrNum != null ">FRP_CNFR_NUM
                    = #{frpCnfrNum},
                </if>
                <if test="isFrpRqr != null and isFrpRqr != ''">IS_FRP_RQR
                    = #{isFrpRqr},
                </if>
                <if test="frpRqrNum != null ">FRP_RQR_NUM
                    = #{frpRqrNum},
                </if>
                <if test="isFrpGap != null and isFrpGap != ''">IS_FRP_GAP
                    = #{isFrpGap},
                </if>
                <if test="frpGapNum != null ">FRP_GAP_NUM
                    = #{frpGapNum},
                </if>
                <if test="isBttmGap != null and isBttmGap != ''">IS_BTTM_GAP
                    = #{isBttmGap},
                </if>
                <if test="bttmGapNum != null ">BTTM_GAP_NUM
                    = #{bttmGapNum},
                </if>
                <if test="isTopGap != null and isTopGap != ''">IS_TOP_GAP
                    = #{isTopGap},
                </if>
                <if test="topGapNum != null ">TOP_GAP_NUM
                    = #{topGapNum},
                </if>
                <if test="isLngtGap != null and isLngtGap != ''">IS_LNGT_GAP
                    = #{isLngtGap},
                </if>
                <if test="lngtGapNum != null ">LNGT_GAP_NUM
                    = #{lngtGapNum},
                </if>
                <if test="isNaerRqr != null and isNaerRqr != ''">IS_NAER_RQR
                    = #{isNaerRqr},
                </if>
                <if test="naerRqrNum != null ">NAER_RQR_NUM
                    = #{naerRqrNum},
                </if>
                <if test="isSplcRqr != null and isSplcRqr != ''">IS_SPLC_RQR
                    = #{isSplcRqr},
                </if>
                <if test="splcRqrNum != null ">SPLC_RQR_NUM
                    = #{splcRqrNum},
                </if>
                <if test="isFrpFix != null and isFrpFix != ''">IS_FRP_FIX
                    = #{isFrpFix},
                </if>
                <if test="frpFixNum != null ">FRP_FIX_NUM
                    = #{frpFixNum},
                </if>
                <if test="isTfrpFix != null and isTfrpFix != ''">IS_TFRP_FIX
                    = #{isTfrpFix},
                </if>
                <if test="tfrpFixNum != null ">TFRP_FIX_NUM
                    = #{tfrpFixNum},
                </if>
                <if test="isTfrpBuld != null and isTfrpBuld != ''">IS_TFRP_BULD
                    = #{isTfrpBuld},
                </if>
                <if test="tfrpBuldNum != null ">TFRP_BULD_NUM
                    = #{tfrpBuldNum},
                </if>
                <if test="isFloorRqr != null and isFloorRqr != ''">IS_FLOOR_RQR
                    = #{isFloorRqr},
                </if>
                <if test="floorRqrNum != null ">FLOOR_RQR_NUM
                    = #{floorRqrNum},
                </if>
                <if test="isLfrpFix != null and isLfrpFix != ''">IS_LFRP_FIX
                    = #{isLfrpFix},
                </if>
                <if test="lfrpFixNum != null ">LFRP_FIX_NUM
                    = #{lfrpFixNum},
                </if>
                <if test="isFrpChnn != null and isFrpChnn != ''">IS_FRP_CHNN
                    = #{isFrpChnn},
                </if>
                <if test="frpChnnNum != null ">FRP_CHNN_NUM
                    = #{frpChnnNum},
                </if>
                <if test="isFrpPass != null and isFrpPass != ''">IS_FRP_PASS
                    = #{isFrpPass},
                </if>
                <if test="frpPassNum != null ">FRP_PASS_NUM
                    = #{frpPassNum},
                </if>
                <if test="isSiteC30 != null and isSiteC30 != ''">IS_SITE_C30
                    = #{isSiteC30},
                </if>
                <if test="siteC30Num != null ">SITE_C30_NUM
                    = #{siteC30Num},
                </if>
                <if test="isSiteLoc != null and isSiteLoc != ''">IS_SITE_LOC
                    = #{isSiteLoc},
                </if>
                <if test="siteLocNum != null ">SITE_LOC_NUM
                    = #{siteLocNum},
                </if>
                <if test="isSiteLmt != null and isSiteLmt != ''">IS_SITE_LMT
                    = #{isSiteLmt},
                </if>
                <if test="siteLmtNum != null ">SITE_LMT_NUM
                    = #{siteLmtNum},
                </if>
                <if test="isRiskPub != null and isRiskPub != ''">IS_RISK_PUB
                    = #{isRiskPub},
                </if>
                <if test="riskPubNum != null ">RISK_PUB_NUM
                    = #{riskPubNum},
                </if>
                <if test="isSiteRqr != null and isSiteRqr != ''">IS_SITE_RQR
                    = #{isSiteRqr},
                </if>
                <if test="siteRqrNum != null ">SITE_RQR_NUM
                    = #{siteRqrNum},
                </if>
                <if test="note != null and note != ''">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="total != null and total != ''">TOTAL
                    = #{total},
                </if>
                <if test="actualScore != null and actualScore != ''">ACTUAL_SCORE
                    = #{actualScore},
                </if>
                <if test="rgstrId != null and rgstrId != ''">RGSTR_ID
                    = #{rgstrId},
                </if>
                <if test="iibPrctNum != null ">IIB_PRCT_NUM
                    = #{iibPrctNum},
                </if>
        </trim>
        <include refid="page_where"/>
    </update>


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


</mapper>