fj-dc/.svn/pristine/47/4726b1b79964e5e28e2826899c8b03d0b60a4c8a.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.BisInspBasePresExtDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspBasePresExt" id="bisInspBasePresExtResultMap">
        <result property="hasAttendTrainNote" column="HAS_ATTEND_TRAIN_NOTE"/>
        <result property="hasAttendTrain" column="HAS_ATTEND_TRAIN"/>
        <result property="patrolFundSour" column="PATROL_FUND_SOUR"/>
        <result property="patrolReward" column="PATROL_REWARD"/>
        <result property="hasExtPatrol" column="HAS_EXT_PATROL"/>
        <result property="isPatrolMsgComp" column="IS_PATROL_MSG_COMP"/>
        <result property="protalRate" column="PROTAL_RATE"/>
        <result property="hasRepDangReal" column="HAS_REP_DANG_REAL"/>
        <result property="dangReportObj" column="DANG_REPORT_OBJ"/>
        <result property="hasReport" column="HAS_REPORT"/>
        <result property="hasFlLowLimLev" column="HAS_FL_LOW_LIM_LEV"/>
        <result property="hasKnowEmerPlanSame" column="HAS_KNOW_EMER_PLAN_SAME"/>
        <result property="otherReasonNote" column="OTHER_REASON_NOTE"/>
        <result property="recPersId" column="REC_PERS_ID"/>
        <result property="recPers2" column="REC_PERS2"/>
        <result property="recPersTel" column="REC_PERS_TEL"/>
        <result property="createTime" column="CREATE_TIME"/>
        <result property="updateTime" column="UPDATE_TIME"/>
        <result property="status" column="STATUS"/>
        <result property="dtyprsnId" column="DTYPRSN_ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="dutyId" column="DUTY_ID"/>
        <result property="command" column="COMMAND"/>
        <result property="specialManage" column="SPECIAL_MANAGE"/>
        <result property="manaOrg" column="MANA_ORG"/>
        <result property="orgProp" column="ORG_PROP"/>
        <result property="fundSour" column="FUND_SOUR"/>
        <result property="fundSourCount" column="FUND_SOUR_COUNT"/>
        <result property="noManHasPres" column="NO_MAN_HAS_PRES"/>
        <result property="hasWiunWaoLegPers" column="HAS_WIUN_WAO_LEG_PERS"/>
        <result property="wiunWaoLegPersId" column="WIUN_WAO_LEG_PERS_ID"/>
        <result property="wiunWaoLegPers" column="WIUN_WAO_LEG_PERS"/>
        <result property="wiunWaoLegPersTel" column="WIUN_WAO_LEG_PERS_TEL"/>
        <result property="wiunWaoLegPersDuty" column="WIUN_WAO_LEG_PERS_DUTY"/>
        <result property="wiunWaoLegPersResu" column="WIUN_WAO_LEG_PERS_RESU"/>
        <result property="hasTechPers" column="HAS_TECH_PERS"/>
        <result property="techPersId" column="TECH_PERS_ID"/>
        <result property="techPers" column="TECH_PERS"/>
        <result property="techPersTel" column="TECH_PERS_TEL"/>
        <result property="techPersDuty" column="TECH_PERS_DUTY"/>
        <result property="techPresNote" column="TECH_PRES_NOTE"/>
        <result property="techPersResuNote" column="TECH_PERS_RESU_NOTE"/>
        <result property="techPersResu" column="TECH_PERS_RESU"/>
        <result property="hasPatrolPers" column="HAS_PATROL_PERS"/>
        <result property="patrolPersId" column="PATROL_PERS_ID"/>
        <result property="patrolPers" column="PATROL_PERS"/>
        <result property="patrolPersTel" column="PATROL_PERS_TEL"/>
        <result property="patrolPersNote" column="PATROL_PERS_NOTE"/>
        <result property="patrolPersDuty" column="PATROL_PERS_DUTY"/>
        <result property="patrolPersResuNote" column="PATROL_PERS_RESU_NOTE"/>
        <result property="patrolPersResu" column="PATROL_PERS_RESU"/>

        <result property="wiunWaoLegPersTrain" column="WIUN_WAO_LEG_PERS_TRAIN"/>
        <result property="wiunWaoLegPersCnps" column="WIUN_WAO_LEG_PERS_CNPS"/>
        <result property="techPersTrain" column="TECH_PERS_TRAIN"/>
        <result property="techPersCnps" column="TECH_PERS_CNPS"/>
        <result property="patrolPersTrain" column="PATROL_PERS_TRAIN"/>
        <result property="patrolPersCnps" column="PATROL_PERS_CNPS"/>


    </resultMap>

    <sql id="table_columns">
        HAS_ATTEND_TRAIN_NOTE,WIUN_WAO_LEG_PERS_TRAIN,WIUN_WAO_LEG_PERS_CNPS,TECH_PERS_TRAIN,TECH_PERS_CNPS,
        PATROL_PERS_TRAIN,PATROL_PERS_CNPS,
        HAS_ATTEND_TRAIN,
        PATROL_FUND_SOUR,
        PATROL_REWARD,
        HAS_EXT_PATROL,
        IS_PATROL_MSG_COMP,
        PROTAL_RATE,
        HAS_REP_DANG_REAL,
        DANG_REPORT_OBJ,
        HAS_REPORT,
        HAS_FL_LOW_LIM_LEV,
        HAS_KNOW_EMER_PLAN_SAME,
        OTHER_REASON_NOTE,
        REC_PERS_ID,
        REC_PERS2,
        REC_PERS_TEL,
        CREATE_TIME,
        UPDATE_TIME,
        STATUS,
        DTYPRSN_ID,
        RGSTR_ID,
        DUTY_ID,
        COMMAND,
        SPECIAL_MANAGE,
        MANA_ORG,
        ORG_PROP,
        FUND_SOUR,
        FUND_SOUR_COUNT,
        NO_MAN_HAS_PRES,
        HAS_WIUN_WAO_LEG_PERS,
        WIUN_WAO_LEG_PERS_ID,
        WIUN_WAO_LEG_PERS,
        WIUN_WAO_LEG_PERS_TEL,
        WIUN_WAO_LEG_PERS_DUTY,
        WIUN_WAO_LEG_PERS_RESU,
        HAS_TECH_PERS,
        TECH_PERS_ID,
        TECH_PERS,
        TECH_PERS_TEL,
        TECH_PERS_DUTY,
        TECH_PRES_NOTE,
        TECH_PERS_RESU_NOTE,
        TECH_PERS_RESU,
        HAS_PATROL_PERS,
        PATROL_PERS_ID,
        PATROL_PERS,
        PATROL_PERS_TEL,
        PATROL_PERS_NOTE,
        PATROL_PERS_DUTY,
        PATROL_PERS_RESU_NOTE,
        PATROL_PERS_RESU
    </sql>
    <sql id="entity_properties">
        #{hasAttendTrainNote},#{wiunWaoLegPersTrain},#{wiunWaoLegPersCnps},#{techPersTrain},#{techPersCnps},#{patrolPersTrain},#{patrolPersCnps},
        #{hasAttendTrain},
        #{patrolFundSour},
        #{patrolReward},
        #{hasExtPatrol},
        #{isPatrolMsgComp},
        #{protalRate},
        #{hasRepDangReal},
        #{dangReportObj},
        #{hasReport},
        #{hasFlLowLimLev},
        #{hasKnowEmerPlanSame},
        #{otherReasonNote},
        #{recPersId},
        #{recPers2},
        #{recPersTel},
        #{createTime},
        #{updateTime},
        #{status},
        #{dtyprsnId},
        #{rgstrId},
        #{dutyId},
        #{command},
        #{specialManage},
        #{manaOrg},
        #{orgProp},
        #{fundSour},
        #{fundSourCount},
        #{noManHasPres},
        #{hasWiunWaoLegPers},
        #{wiunWaoLegPersId},
        #{wiunWaoLegPers},
        #{wiunWaoLegPersTel},
        #{wiunWaoLegPersDuty},
        #{wiunWaoLegPersResu},
        #{hasTechPers},
        #{techPersId},
        #{techPers},
        #{techPersTel},
        #{techPersDuty},
        #{techPresNote},
        #{techPersResuNote},
        #{techPersResu},
        #{hasPatrolPers},
        #{patrolPersId},
        #{patrolPers},
        #{patrolPersTel},
        #{patrolPersNote},
        #{patrolPersDuty},
        #{patrolPersResuNote},
        #{patrolPersResu}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="hasAttendTrain != null and hasAttendTrain != ''">and HAS_ATTEND_TRAIN = #{hasAttendTrain}</if>
            <if test="patrolFundSour != null and patrolFundSour != ''">and PATROL_FUND_SOUR = #{patrolFundSour}</if>
            <if test="patrolReward != null and patrolReward != ''">and PATROL_REWARD = #{patrolReward}</if>
            <if test="hasExtPatrol != null and hasExtPatrol != ''">and HAS_EXT_PATROL = #{hasExtPatrol}</if>
            <if test="isPatrolMsgComp != null and isPatrolMsgComp != ''">and IS_PATROL_MSG_COMP = #{isPatrolMsgComp}
            </if>
            <if test="protalRate != null and protalRate != ''">and PROTAL_RATE = #{protalRate}</if>
            <if test="hasRepDangReal != null and hasRepDangReal != ''">and HAS_REP_DANG_REAL = #{hasRepDangReal}</if>
            <if test="dangReportObj != null and dangReportObj != ''">and DANG_REPORT_OBJ = #{dangReportObj}</if>
            <if test="hasReport != null and hasReport != ''">and HAS_REPORT = #{hasReport}</if>
            <if test="hasFlLowLimLev != null and hasFlLowLimLev != ''">and HAS_FL_LOW_LIM_LEV = #{hasFlLowLimLev}</if>
            <if test="hasKnowEmerPlanSame != null and hasKnowEmerPlanSame != ''">and HAS_KNOW_EMER_PLAN_SAME =
                #{hasKnowEmerPlanSame}
            </if>
            <if test="otherReasonNote != null and otherReasonNote != ''">and OTHER_REASON_NOTE = #{otherReasonNote}</if>
            <if test="recPersId != null and recPersId != ''">and REC_PERS_ID = #{recPersId}</if>
            <if test="recPers2 != null and recPers2 != ''">and REC_PERS2 = #{recPers2}</if>
            <if test="recPersTel != null and recPersTel != ''">and REC_PERS_TEL = #{recPersTel}</if>
            <if test="createTime != null">and CREATE_TIME = #{createTime}</if>
            <if test="updateTime != null">and UPDATE_TIME = #{updateTime}</if>
            <if test="status != null and status != ''">and STATUS = #{status}</if>
            <if test="dtyprsnId != null and dtyprsnId != ''">and DTYPRSN_ID = #{dtyprsnId}</if>
            <if test="rgstrId != null and rgstrId != ''">and RGSTR_ID = #{rgstrId}</if>
            <if test="dutyId != null and dutyId != ''">and DUTY_ID = #{dutyId}</if>
            <if test="command != null and command != ''">and COMMAND = #{command}</if>
            <if test="specialManage != null and specialManage != ''">and SPECIAL_MANAGE = #{specialManage}</if>
            <if test="manaOrg != null and manaOrg != ''">and MANA_ORG = #{manaOrg}</if>
            <if test="orgProp != null and orgProp != ''">and ORG_PROP = #{orgProp}</if>
            <if test="fundSour != null and fundSour != ''">and FUND_SOUR = #{fundSour}</if>
            <if test="fundSourCount != null and fundSourCount != ''">and FUND_SOUR_COUNT = #{fundSourCount}</if>
            <if test="noManHasPres != null and noManHasPres != ''">and NO_MAN_HAS_PRES = #{noManHasPres}</if>
            <if test="hasWiunWaoLegPers != null and hasWiunWaoLegPers != ''">and HAS_WIUN_WAO_LEG_PERS =
                #{hasWiunWaoLegPers}
            </if>
            <if test="wiunWaoLegPersId != null and wiunWaoLegPersId != ''">and WIUN_WAO_LEG_PERS_ID =
                #{wiunWaoLegPersId}
            </if>
            <if test="wiunWaoLegPers != null and wiunWaoLegPers != ''">and WIUN_WAO_LEG_PERS = #{wiunWaoLegPers}</if>
            <if test="wiunWaoLegPersTel != null and wiunWaoLegPersTel != ''">and WIUN_WAO_LEG_PERS_TEL =
                #{wiunWaoLegPersTel}
            </if>
            <if test="wiunWaoLegPersDuty != null and wiunWaoLegPersDuty != ''">and WIUN_WAO_LEG_PERS_DUTY =
                #{wiunWaoLegPersDuty}
            </if>
            <if test="wiunWaoLegPersResu != null and wiunWaoLegPersResu != ''">and WIUN_WAO_LEG_PERS_RESU =
                #{wiunWaoLegPersResu}
            </if>
            <if test="hasTechPers != null and hasTechPers != ''">and HAS_TECH_PERS = #{hasTechPers}</if>
            <if test="techPersId != null and techPersId != ''">and TECH_PERS_ID = #{techPersId}</if>
            <if test="techPers != null and techPers != ''">and TECH_PERS = #{techPers}</if>
            <if test="techPersTel != null and techPersTel != ''">and TECH_PERS_TEL = #{techPersTel}</if>
            <if test="techPersDuty != null and techPersDuty != ''">and TECH_PERS_DUTY = #{techPersDuty}</if>
            <if test="techPresNote != null and techPresNote != ''">and TECH_PRES_NOTE = #{techPresNote}</if>
            <if test="techPersResuNote != null and techPersResuNote != ''">and TECH_PERS_RESU_NOTE =
                #{techPersResuNote}
            </if>
            <if test="techPersResu != null and techPersResu != ''">and TECH_PERS_RESU = #{techPersResu}</if>
            <if test="hasPatrolPers != null and hasPatrolPers != ''">and HAS_PATROL_PERS = #{hasPatrolPers}</if>
            <if test="patrolPersId != null and patrolPersId != ''">and PATROL_PERS_ID = #{patrolPersId}</if>
            <if test="patrolPers != null and patrolPers != ''">and PATROL_PERS = #{patrolPers}</if>
            <if test="patrolPersTel != null and patrolPersTel != ''">and PATROL_PERS_TEL = #{patrolPersTel}</if>
            <if test="patrolPersNote != null and patrolPersNote != ''">and PATROL_PERS_NOTE = #{patrolPersNote}</if>
            <if test="patrolPersDuty != null and patrolPersDuty != ''">and PATROL_PERS_DUTY = #{patrolPersDuty}</if>
            <if test="patrolPersResuNote != null and patrolPersResuNote != ''">and PATROL_PERS_RESU_NOTE =
                #{patrolPersResuNote}
            </if>
            <if test="patrolPersResu != null and patrolPersResu != ''">and PATROL_PERS_RESU = #{patrolPersResu}</if>
            <if test="wiunWaoLegPersTrain != null and wiunWaoLegPersTrain != ''">and WIUN_WAO_LEG_PERS_TRAIN =
                #{wiunWaoLegPersTrain}
            </if>
            <if test="wiunWaoLegPersCnps != null and wiunWaoLegPersCnps != ''">and WIUN_WAO_LEG_PERS_CNPS =
                #{wiunWaoLegPersCnps}
            </if>
            <if test="techPersTrain != null and techPersTrain != ''">and TECH_PERS_TRAIN = #{techPersTrain}</if>
            <if test="techPersCnps != null and techPersCnps != ''">and TECH_PERS_CNPS = #{techPersCnps}</if>
            <if test="patrolPersTrain != null and patrolPersTrain != ''">and PATROL_PERS_TRAIN = #{patrolPersTrain}</if>
            <if test="patrolPersCnps != null and patrolPersCnps != ''">and PATROL_PERS_CNPS = #{patrolPersCnps}</if>
        </trim>
    </sql>


    <select id="get" resultMap="bisInspBasePresExtResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from bis_insp_base_pres_ext where DUTY_ID = #{dutyId}
        <if test="dtyprsnId !=null and dtyprsnId !=''">
            and DTYPRSN_ID=#{dtyprsnId}
        </if>
    </select>

    <select id="getById" resultMap="bisInspBasePresExtResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from bis_insp_base_pres_ext where DUTY_ID = #{dutyId}
    </select>

    <select id="getBy" resultMap="bisInspBasePresExtResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_BASE_PRES_EXT
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="bisInspBasePresExtResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_BASE_PRES_EXT
    </select>

    <select id="findList" resultMap="bisInspBasePresExtResultMap">
        select
        <include refid="table_columns"/>
        from BIS_INSP_BASE_PRES_EXT
        <include refid="page_where"/>
    </select>

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


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

    <delete id="delete" parameterType="java.lang.String">
        delete from bis_insp_base_pres_ext where DUTY_ID = #{DUTY_ID} and DTYPRSN_ID=#{DTYPRSN_ID}
    </delete>

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspBasePresExt">
        update BIS_INSP_BASE_PRES_EXT
        <trim prefix="set" suffixOverrides=",">
            <if test="hasAttendTrain != null and hasAttendTrain != ''">HAS_ATTEND_TRAIN = #{hasAttendTrain},</if>
            <if test="patrolFundSour != null and patrolFundSour != ''">PATROL_FUND_SOUR = #{patrolFundSour},</if>
            <if test="patrolReward != null and patrolReward != ''">PATROL_REWARD = #{patrolReward},</if>
            <if test="hasExtPatrol != null and hasExtPatrol != ''">HAS_EXT_PATROL = #{hasExtPatrol},</if>
            <if test="isPatrolMsgComp != null and isPatrolMsgComp != ''">IS_PATROL_MSG_COMP = #{isPatrolMsgComp},</if>
            <if test="protalRate != null and protalRate != ''">PROTAL_RATE = #{protalRate},</if>
            <if test="hasRepDangReal != null and hasRepDangReal != ''">HAS_REP_DANG_REAL = #{hasRepDangReal},</if>
            <if test="dangReportObj != null and dangReportObj != ''">DANG_REPORT_OBJ = #{dangReportObj},</if>
            <if test="hasReport != null and hasReport != ''">HAS_REPORT = #{hasReport},</if>
            <if test="hasFlLowLimLev != null and hasFlLowLimLev != ''">HAS_FL_LOW_LIM_LEV = #{hasFlLowLimLev},</if>
            <if test="hasKnowEmerPlanSame != null and hasKnowEmerPlanSame != ''">HAS_KNOW_EMER_PLAN_SAME =
                #{hasKnowEmerPlanSame},
            </if>
            <if test="otherReasonNote != null and otherReasonNote != ''">OTHER_REASON_NOTE = #{otherReasonNote},</if>
            <if test="recPersId != null and recPersId != ''">REC_PERS_ID = #{recPersId},</if>
            <if test="recPers2 != null and recPers2 != ''">REC_PERS2 = #{recPers2},</if>
            <if test="recPersTel != null and recPersTel != ''">REC_PERS_TEL = #{recPersTel},</if>
            <if test="createTime != null">CREATE_TIME = #{createTime},</if>
            <if test="updateTime != null">UPDATE_TIME = #{updateTime},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="dtyprsnId != null and dtyprsnId != ''">DTYPRSN_ID = #{dtyprsnId},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="dutyId != null and dutyId != ''">DUTY_ID = #{dutyId},</if>
            <if test="command != null and command != ''">COMMAND = #{command},</if>
            <if test="specialManage != null and specialManage != ''">SPECIAL_MANAGE = #{specialManage},</if>
            <if test="manaOrg != null and manaOrg != ''">MANA_ORG = #{manaOrg},</if>
            <if test="orgProp != null and orgProp != ''">ORG_PROP = #{orgProp},</if>
            <if test="fundSour != null and fundSour != ''">FUND_SOUR = #{fundSour},</if>
            <if test="fundSourCount != null and fundSourCount != ''">FUND_SOUR_COUNT = #{fundSourCount},</if>
            <if test="noManHasPres != null and noManHasPres != ''">NO_MAN_HAS_PRES = #{noManHasPres},</if>
            <if test="hasWiunWaoLegPers != null and hasWiunWaoLegPers != ''">HAS_WIUN_WAO_LEG_PERS =
                #{hasWiunWaoLegPers},
            </if>
            <if test="wiunWaoLegPersId != null and wiunWaoLegPersId != ''">WIUN_WAO_LEG_PERS_ID = #{wiunWaoLegPersId},
            </if>
            <if test="wiunWaoLegPers != null and wiunWaoLegPers != ''">WIUN_WAO_LEG_PERS = #{wiunWaoLegPers},</if>
            <if test="wiunWaoLegPersTel != null and wiunWaoLegPersTel != ''">WIUN_WAO_LEG_PERS_TEL =
                #{wiunWaoLegPersTel},
            </if>
            <if test="wiunWaoLegPersDuty != null and wiunWaoLegPersDuty != ''">WIUN_WAO_LEG_PERS_DUTY =
                #{wiunWaoLegPersDuty},
            </if>
            <if test="wiunWaoLegPersResu != null and wiunWaoLegPersResu != ''">WIUN_WAO_LEG_PERS_RESU =
                #{wiunWaoLegPersResu},
            </if>
            <if test="hasTechPers != null and hasTechPers != ''">HAS_TECH_PERS = #{hasTechPers},</if>
            <if test="techPersId != null and techPersId != ''">TECH_PERS_ID = #{techPersId},</if>
            <if test="techPers != null and techPers != ''">TECH_PERS = #{techPers},</if>
            <if test="techPersTel != null and techPersTel != ''">TECH_PERS_TEL = #{techPersTel},</if>
            <if test="techPersDuty != null and techPersDuty != ''">TECH_PERS_DUTY = #{techPersDuty},</if>
            <if test="techPresNote != null and techPresNote != ''">TECH_PRES_NOTE = #{techPresNote},</if>
            <if test="techPersResuNote != null and techPersResuNote != ''">TECH_PERS_RESU_NOTE = #{techPersResuNote},
            </if>
            <if test="techPersResu != null and techPersResu != ''">TECH_PERS_RESU = #{techPersResu},</if>
            <if test="hasPatrolPers != null and hasPatrolPers != ''">HAS_PATROL_PERS = #{hasPatrolPers},</if>
            <if test="patrolPersId != null and patrolPersId != ''">PATROL_PERS_ID = #{patrolPersId},</if>
            <if test="patrolPers != null and patrolPers != ''">PATROL_PERS = #{patrolPers},</if>
            <if test="patrolPersTel != null and patrolPersTel != ''">PATROL_PERS_TEL = #{patrolPersTel},</if>
            <if test="patrolPersNote != null and patrolPersNote != ''">PATROL_PERS_NOTE = #{patrolPersNote},</if>
            <if test="patrolPersDuty != null and patrolPersDuty != ''">PATROL_PERS_DUTY = #{patrolPersDuty},</if>
            <if test="patrolPersResuNote != null and patrolPersResuNote != ''">PATROL_PERS_RESU_NOTE =
                #{patrolPersResuNote},
            </if>
            <if test="patrolPersResu != null and patrolPersResu != ''">PATROL_PERS_RESU = #{patrolPersResu},</if>
            <if test="wiunWaoLegPersTrain != null and wiunWaoLegPersTrain != ''">WIUN_WAO_LEG_PERS_TRAIN =
                #{wiunWaoLegPersTrain},
            </if>
            <if test="wiunWaoLegPersCnps != null and wiunWaoLegPersCnps != ''">WIUN_WAO_LEG_PERS_CNPS =
                #{wiunWaoLegPersCnps},
            </if>
            <if test="techPersTrain != null and techPersTrain != ''">TECH_PERS_TRAIN = #{techPersTrain},</if>
            <if test="techPersCnps != null and techPersCnps != ''">TECH_PERS_CNPS = #{techPersCnps},</if>
            <if test="patrolPersTrain != null and patrolPersTrain != ''">PATROL_PERS_TRAIN = #{patrolPersTrain},</if>
            <if test="patrolPersCnps != null and patrolPersCnps != ''">PATROL_PERS_CNPS = #{patrolPersCnps},</if>
        </trim>
        <where>DUTY_ID = #{dutyId}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspBasePresExt">
        update BIS_INSP_BASE_PRES_EXT
        <trim prefix="set" suffixOverrides=",">
            <if test="hasAttendTrain != null and hasAttendTrain != ''">HAS_ATTEND_TRAIN = #{hasAttendTrain},</if>
            <if test="patrolFundSour != null and patrolFundSour != ''">PATROL_FUND_SOUR = #{patrolFundSour},</if>
            <if test="patrolReward != null and patrolReward != ''">PATROL_REWARD = #{patrolReward},</if>
            <if test="hasExtPatrol != null and hasExtPatrol != ''">HAS_EXT_PATROL = #{hasExtPatrol},</if>
            <if test="isPatrolMsgComp != null and isPatrolMsgComp != ''">IS_PATROL_MSG_COMP = #{isPatrolMsgComp},</if>
            <if test="protalRate != null and protalRate != ''">PROTAL_RATE = #{protalRate},</if>
            <if test="hasRepDangReal != null and hasRepDangReal != ''">HAS_REP_DANG_REAL = #{hasRepDangReal},</if>
            <if test="dangReportObj != null and dangReportObj != ''">DANG_REPORT_OBJ = #{dangReportObj},</if>
            <if test="hasReport != null and hasReport != ''">HAS_REPORT = #{hasReport},</if>
            <if test="hasFlLowLimLev != null and hasFlLowLimLev != ''">HAS_FL_LOW_LIM_LEV = #{hasFlLowLimLev},</if>
            <if test="hasKnowEmerPlanSame != null and hasKnowEmerPlanSame != ''">HAS_KNOW_EMER_PLAN_SAME =
                #{hasKnowEmerPlanSame},
            </if>
            <if test="otherReasonNote != null and otherReasonNote != ''">OTHER_REASON_NOTE = #{otherReasonNote},</if>
            <if test="recPersId != null and recPersId != ''">REC_PERS_ID = #{recPersId},</if>
            <if test="recPers2 != null and recPers2 != ''">REC_PERS2 = #{recPers2},</if>
            <if test="recPersTel != null and recPersTel != ''">REC_PERS_TEL = #{recPersTel},</if>
            <if test="createTime != null">CREATE_TIME = #{createTime},</if>
            <if test="updateTime != null">UPDATE_TIME = #{updateTime},</if>
            <if test="status != null and status != ''">STATUS = #{status},</if>
            <if test="dtyprsnId != null and dtyprsnId != ''">DTYPRSN_ID = #{dtyprsnId},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="dutyId != null and dutyId != ''">DUTY_ID = #{dutyId},</if>
            <if test="command != null and command != ''">COMMAND = #{command},</if>
            <if test="specialManage != null and specialManage != ''">SPECIAL_MANAGE = #{specialManage},</if>
            <if test="manaOrg != null and manaOrg != ''">MANA_ORG = #{manaOrg},</if>
            <if test="orgProp != null and orgProp != ''">ORG_PROP = #{orgProp},</if>
            <if test="fundSour != null and fundSour != ''">FUND_SOUR = #{fundSour},</if>
            <if test="fundSourCount != null and fundSourCount != ''">FUND_SOUR_COUNT = #{fundSourCount},</if>
            <if test="noManHasPres != null and noManHasPres != ''">NO_MAN_HAS_PRES = #{noManHasPres},</if>
            <if test="hasWiunWaoLegPers != null and hasWiunWaoLegPers != ''">HAS_WIUN_WAO_LEG_PERS =
                #{hasWiunWaoLegPers},
            </if>
            <if test="wiunWaoLegPersId != null and wiunWaoLegPersId != ''">WIUN_WAO_LEG_PERS_ID = #{wiunWaoLegPersId},
            </if>
            <if test="wiunWaoLegPers != null and wiunWaoLegPers != ''">WIUN_WAO_LEG_PERS = #{wiunWaoLegPers},</if>
            <if test="wiunWaoLegPersTel != null and wiunWaoLegPersTel != ''">WIUN_WAO_LEG_PERS_TEL =
                #{wiunWaoLegPersTel},
            </if>
            <if test="wiunWaoLegPersDuty != null and wiunWaoLegPersDuty != ''">WIUN_WAO_LEG_PERS_DUTY =
                #{wiunWaoLegPersDuty},
            </if>
            <if test="wiunWaoLegPersResu != null and wiunWaoLegPersResu != ''">WIUN_WAO_LEG_PERS_RESU =
                #{wiunWaoLegPersResu},
            </if>
            <if test="hasTechPers != null and hasTechPers != ''">HAS_TECH_PERS = #{hasTechPers},</if>
            <if test="techPersId != null and techPersId != ''">TECH_PERS_ID = #{techPersId},</if>
            <if test="techPers != null and techPers != ''">TECH_PERS = #{techPers},</if>
            <if test="techPersTel != null and techPersTel != ''">TECH_PERS_TEL = #{techPersTel},</if>
            <if test="techPersDuty != null and techPersDuty != ''">TECH_PERS_DUTY = #{techPersDuty},</if>
            <if test="techPresNote != null and techPresNote != ''">TECH_PRES_NOTE = #{techPresNote},</if>
            <if test="techPersResuNote != null and techPersResuNote != ''">TECH_PERS_RESU_NOTE = #{techPersResuNote},
            </if>
            <if test="techPersResu != null and techPersResu != ''">TECH_PERS_RESU = #{techPersResu},</if>
            <if test="hasPatrolPers != null and hasPatrolPers != ''">HAS_PATROL_PERS = #{hasPatrolPers},</if>
            <if test="patrolPersId != null and patrolPersId != ''">PATROL_PERS_ID = #{patrolPersId},</if>
            <if test="patrolPers != null and patrolPers != ''">PATROL_PERS = #{patrolPers},</if>
            <if test="patrolPersTel != null and patrolPersTel != ''">PATROL_PERS_TEL = #{patrolPersTel},</if>
            <if test="patrolPersNote != null and patrolPersNote != ''">PATROL_PERS_NOTE = #{patrolPersNote},</if>
            <if test="patrolPersDuty != null and patrolPersDuty != ''">PATROL_PERS_DUTY = #{patrolPersDuty},</if>
            <if test="patrolPersResuNote != null and patrolPersResuNote != ''">PATROL_PERS_RESU_NOTE =
                #{patrolPersResuNote},
            </if>
            <if test="patrolPersResu != null and patrolPersResu != ''">PATROL_PERS_RESU = #{patrolPersResu},</if>
            <if test="wiunWaoLegPersTrain != null and wiunWaoLegPersTrain != ''">WIUN_WAO_LEG_PERS_TRAIN =
                #{wiunWaoLegPersTrain},
            </if>
            <if test="wiunWaoLegPersCnps != null and wiunWaoLegPersCnps != ''">WIUN_WAO_LEG_PERS_CNPS =
                #{wiunWaoLegPersCnps},
            </if>
            <if test="techPersTrain != null and techPersTrain != ''">TECH_PERS_TRAIN = #{techPersTrain},</if>
            <if test="techPersCnps != null and techPersCnps != ''">TECH_PERS_CNPS = #{techPersCnps},</if>
            <if test="patrolPersTrain != null and patrolPersTrain != ''">PATROL_PERS_TRAIN = #{patrolPersTrain},</if>
            <if test="patrolPersCnps != null and patrolPersCnps != ''">PATROL_PERS_CNPS = #{patrolPersCnps},</if>
        </trim>
        <include refid="page_where"/>
    </update>


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


</mapper>