fj-dc/.svn/pristine/cd/cd05d0f65383038d95eb6a2f72638f7a2e7c0bfd.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.BisInspIrrChanDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspIrrChan" id="bisInspIrrChanResultMap">
        <result property="id" column="ID"/>
        <result property="rgstrId" column="RGSTR_ID"/>
        <result property="objId" column="OBJ_ID"/>
        <result property="code" column="CODE"/>
        <result property="name" column="NAME"/>
        <result property="adCode" column="AD_CODE"/>
        <result property="adName" column="AD_NAME"/>
        <result property="sour" column="SOUR"/>
        <result property="compDate" column="COMP_DATE"/>
        <result property="irrCode" column="IRR_CODE"/>
        <result property="irrName" column="IRR_NAME"/>
        <result property="chanLen" column="CHAN_LEN"/>
        <result property="irrArea" column="IRR_AREA"/>
        <result property="totFlow" column="TOT_FLOW"/>
        <result property="higStnType" column="HIG_STN_TYPE"/>
        <result property="prjPbmArea" column="PRJ_PBM_AREA"/>
        <result property="prjWhoTend" column="PRJ_WHO_TEND"/>
        <result property="prjUsrType" column="PRJ_USR_TYPE"/>
        <result property="whoTend" column="WHO_TEND"/>
        <result property="isTendRcrd" column="IS_TEND_RCRD"/>
        <result property="tendRcrdType" column="TEND_RCRD_TYPE"/>
        <result property="isWtrFarm" column="IS_WTR_FARM"/>
        <result property="wtrNotFarm" column="WTR_NOT_FARM"/>
        <result property="wtrNotFarmNote" column="WTR_NOT_FARM_NOTE"/>
        <result property="dstyLen" column="DSTY_LEN"/>
        <result property="siltationLen" column="SILTATION_LEN"/>
        <result property="liningLen" column="LINING_LEN"/>
        <result property="isWtrOntm" column="IS_WTR_ONTM"/>
        <result property="wtrFclty" column="WTR_FCLTY"/>
        <result property="isWainFclty" column="IS_WAIN_FCLTY"/>
        <result property="msurWtrUse" column="MSUR_WTR_USE"/>
        <result property="chanFull" column="CHAN_FULL"/>
        <result property="matingFull" column="MATING_FULL"/>
        <result property="evaluate" column="EVALUATE"/>
        <result property="note" column="NOTE"/>
        <result property="invsrName" column="INVSR_NAME"/>
        <result property="invsrPhone" column="INVSR_PHONE"/>
        <result property="invsrTm" column="INVSR_TM"/>
        <result property="persId" column="PERS_ID"/>
        <result property="intm" column="INTM"/>
        <result property="uptm" column="UPTM"/>
        <result property="dataStat" column="DATA_STAT"/>
        <result property="state" column="STATE"/>
        <result property="centerX" column="CENTER_X"/>
        <result property="centerY" column="CENTER_Y"/>
        <result property="gdX" column="GD_X"/>
        <result property="gdY" column="GD_Y"/>
        <result property="sourNote" column="SOUR_NOTE"/>
        <result property="isCurryearComp" column="IS_CURRYEAR_COMP"/>
        <result property="beforeCurryearComp" column="BEFROE_CURRYEAR"/>
        <result property="afterCurryearComp" column="AFTER_CURRYEAR"/>
    </resultMap>

    <sql id="table_columns">
    IS_CURRYEAR_COMP,
    BEFROE_CURRYEAR,
    AFTER_CURRYEAR,
    SOUR_NOTE,
    CENTER_X,
    CENTER_Y,
    GD_X,
    GD_Y,
    ID,
    RGSTR_ID,
    OBJ_ID,
    CODE,
    NAME,
    AD_CODE,
    AD_NAME,
    SOUR,
    COMP_DATE,
    IRR_CODE,
    IRR_NAME,
    CHAN_LEN,
    IRR_AREA,
    TOT_FLOW,
    HIG_STN_TYPE,
    PRJ_PBM_AREA,
    PRJ_WHO_TEND,
    PRJ_USR_TYPE,
    WHO_TEND,
    IS_TEND_RCRD,
    TEND_RCRD_TYPE,
    IS_WTR_FARM,
    WTR_NOT_FARM,
    WTR_NOT_FARM_NOTE,
    DSTY_LEN,
    SILTATION_LEN,
    LINING_LEN,
    IS_WTR_ONTM,
    WTR_FCLTY,
    IS_WAIN_FCLTY,
    MSUR_WTR_USE,
    CHAN_FULL,
    MATING_FULL,
    EVALUATE,
    NOTE,
    INVSR_NAME,
    INVSR_PHONE,
    INVSR_TM,
    PERS_ID,
    INTM,
    UPTM,
    DATA_STAT,
    STATE
    </sql>
    <sql id="entity_properties">
    #{isCurryearComp},
    #{beforeCurryearComp},
    #{afterCurryearComp},
    #{sourNote},
    #{centerX},
    #{centerY},
    #{gdX},
    #{gdY},
    #{id},
    #{rgstrId},
    #{objId},
    #{code},
    #{name},
    #{adCode},
    #{adName},
    #{sour},
    #{compDate},
    #{irrCode},
    #{irrName},
    #{chanLen},
    #{irrArea},
    #{totFlow},
    #{higStnType},
    #{prjPbmArea},
    #{prjWhoTend},
    #{prjUsrType},
    #{whoTend},
    #{isTendRcrd},
    #{tendRcrdType},
    #{isWtrFarm},
    #{wtrNotFarm},
    #{wtrNotFarmNote},
    #{dstyLen},
    #{siltationLen},
    #{liningLen},
    #{isWtrOntm},
    #{wtrFclty},
    #{isWainFclty},
    #{msurWtrUse},
    #{chanFull},
    #{matingFull},
    #{evaluate},
    #{note},
    #{invsrName},
    #{invsrPhone},
    #{invsrTm},
    #{persId},
    #{intm},
    #{uptm},
    #{dataStat},
    #{state}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="isCurryearComp != null and isCurryearComp != ''">and IS_CURRYEAR_COMP = #{isCurryearComp}</if>
            <if test="beforeCurryearComp != null and beforeCurryearComp != ''">and BEFROE_CURRYEAR = #{beforeCurryearComp}</if>
            <if test="afterCurryearComp != null and afterCurryearComp != ''">and AFTER_CURRYEAR = #{afterCurryearComp}</if>
            <if test="sourNote != null and sourNote != ''">and SOUR_NOTE = #{sourNote}</if>
            <if test="centerX != null and centerX != ''">and CENTER_X = #{centerX}</if>
            <if test="centerY != null and centerY != ''">and CENTER_Y = #{centerY}</if>
            <if test="gdX != null and gdX != ''">and GD_X = #{gdX}</if>
            <if test="gdY != null and gdY != ''">and GD_Y = #{gdY}</if>
            <if test="rgstrId != null and rgstrId != ''">and RGSTR_ID = #{rgstrId}</if>
            <if test="objId != null and objId != ''">and OBJ_ID = #{objId}</if>
            <if test="code != null and code != ''">and CODE = #{code}</if>
            <if test="name != null and name != ''">and NAME like concat('%',concat(#{name},'%'))</if>
            <if test="adCode != null and adCode != ''">and AD_CODE = #{adCode}</if>
            <if test="adName != null and adName != ''">and AD_NAME = #{adName}</if>
            <if test="sour != null and sour != ''">and SOUR = #{sour}</if>
            <if test="compDate != null and compDate != ''">and COMP_DATE = #{compDate}</if>
            <if test="irrCode != null and irrCode != ''">and IRR_CODE = #{irrCode}</if>
            <if test="irrName != null and irrName != ''">and IRR_NAME = #{irrName}</if>
            <if test="chanLen != null and chanLen != ''">and CHAN_LEN = #{chanLen}</if>
            <if test="irrArea != null and irrArea != ''">and IRR_AREA = #{irrArea}</if>
            <if test="totFlow != null and totFlow != ''">and TOT_FLOW = #{totFlow}</if>
            <if test="higStnType != null and higStnType != ''">and HIG_STN_TYPE = #{higStnType}</if>
            <if test="prjPbmArea != null and prjPbmArea != ''">and PRJ_PBM_AREA = #{prjPbmArea}</if>
            <if test="prjWhoTend != null and prjWhoTend != ''">and PRJ_WHO_TEND = #{prjWhoTend}</if>
            <if test="prjUsrType != null and prjUsrType != ''">and PRJ_USR_TYPE = #{prjUsrType}</if>
            <if test="whoTend != null and whoTend != ''">and WHO_TEND = #{whoTend}</if>
            <if test="isTendRcrd != null and isTendRcrd != ''">and IS_TEND_RCRD = #{isTendRcrd}</if>
            <if test="tendRcrdType != null and tendRcrdType != ''">and TEND_RCRD_TYPE = #{tendRcrdType}</if>
            <if test="isWtrFarm != null and isWtrFarm != ''">and IS_WTR_FARM = #{isWtrFarm}</if>
            <if test="wtrNotFarm != null and wtrNotFarm != ''">and WTR_NOT_FARM = #{wtrNotFarm}</if>
            <if test="wtrNotFarmNote != null and wtrNotFarmNote != ''">and WTR_NOT_FARM_NOTE = #{wtrNotFarmNote}</if>
            <if test="dstyLen != null and dstyLen != ''">and DSTY_LEN = #{dstyLen}</if>
            <if test="siltationLen != null and siltationLen != ''">and SILTATION_LEN = #{siltationLen}</if>
            <if test="liningLen != null and liningLen != ''">and LINING_LEN = #{liningLen}</if>
            <if test="isWtrOntm != null and isWtrOntm != ''">and IS_WTR_ONTM = #{isWtrOntm}</if>
            <if test="wtrFclty != null and wtrFclty != ''">and WTR_FCLTY = #{wtrFclty}</if>
            <if test="isWainFclty != null and isWainFclty != ''">and IS_WAIN_FCLTY = #{isWainFclty}</if>
            <if test="msurWtrUse != null and msurWtrUse != ''">and MSUR_WTR_USE = #{msurWtrUse}</if>
            <if test="chanFull != null and chanFull != ''">and CHAN_FULL = #{chanFull}</if>
            <if test="matingFull != null and matingFull != ''">and MATING_FULL = #{matingFull}</if>
            <if test="evaluate != null and evaluate != ''">and EVALUATE = #{evaluate}</if>
            <if test="note != null and note != ''">and NOTE = #{note}</if>
            <if test="invsrName != null and invsrName != ''">and INVSR_NAME = #{invsrName}</if>
            <if test="invsrPhone != null and invsrPhone != ''">and INVSR_PHONE = #{invsrPhone}</if>
            <if test="invsrTm != null">and INVSR_TM = #{invsrTm}</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="state != null and state != ''">and STATE = #{state}</if>
            and DATA_STAT='0'
        </trim>
    </sql>


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

    <select id="getBy" resultMap="bisInspIrrChanResultMap">
        select <include refid="table_columns" /> from BIS_INSP_IRR_CHAN <include refid="page_where" />
    </select>

    <select id="findAll" resultMap="bisInspIrrChanResultMap">
        select <include refid="table_columns" /> from BIS_INSP_IRR_CHAN
    </select>

    <select id="findList" resultMap="bisInspIrrChanResultMap">
        select <include refid="table_columns" /> from BIS_INSP_IRR_CHAN <include refid="page_where" />
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspIrrChan">
        update BIS_INSP_IRR_CHAN
        <trim prefix="set" suffixOverrides=",">
            <if test="isCurryearComp != null and isCurryearComp != ''">IS_CURRYEAR_COMP = #{isCurryearComp},</if>
            <if test="beforeCurryearComp != null and beforeCurryearComp != ''">BEFROE_CURRYEAR = #{beforeCurryearComp},</if>
            <if test="afterCurryearComp != null and afterCurryearComp != ''">AFTER_CURRYEAR = #{afterCurryearComp},</if>
            <if test="sourNote != null and sourNote != ''">SOUR_NOTE = #{sourNote},</if>
            <if test="centerX != null and centerX != ''">CENTER_X = #{centerX},</if>
            <if test="centerY != null and centerY != ''">CENTER_Y = #{centerY},</if>
            <if test="gdX != null and gdX != ''">GD_X = #{gdX},</if>
            <if test="gdY != null and gdY != ''">GD_Y = #{gdY},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="objId != null and objId != ''">OBJ_ID = #{objId},</if>
            <if test="code != null and code != ''">CODE = #{code},</if>
            <if test="name != null and name != ''">NAME = #{name},</if>
            <if test="adCode != null and adCode != ''">AD_CODE = #{adCode},</if>
            <if test="adName != null and adName != ''">AD_NAME = #{adName},</if>
            <if test="sour != null and sour != ''">SOUR = #{sour},</if>
            <if test="compDate != null and compDate != ''">COMP_DATE = #{compDate},</if>
            <if test="irrCode != null and irrCode != ''">IRR_CODE = #{irrCode},</if>
            <if test="irrName != null and irrName != ''">IRR_NAME = #{irrName},</if>
            <if test="chanLen != null and chanLen != ''">CHAN_LEN = #{chanLen},</if>
            <if test="irrArea != null and irrArea != ''">IRR_AREA = #{irrArea},</if>
            <if test="totFlow != null and totFlow != ''">TOT_FLOW = #{totFlow},</if>
            <if test="higStnType != null and higStnType != ''">HIG_STN_TYPE = #{higStnType},</if>
            <if test="prjPbmArea != null and prjPbmArea != ''">PRJ_PBM_AREA = #{prjPbmArea},</if>
            <if test="prjWhoTend != null and prjWhoTend != ''">PRJ_WHO_TEND = #{prjWhoTend},</if>
            <if test="prjUsrType != null and prjUsrType != ''">PRJ_USR_TYPE = #{prjUsrType},</if>
            <if test="whoTend != null and whoTend != ''">WHO_TEND = #{whoTend},</if>
            <if test="isTendRcrd != null and isTendRcrd != ''">IS_TEND_RCRD = #{isTendRcrd},</if>
            <if test="tendRcrdType != null and tendRcrdType != ''">TEND_RCRD_TYPE = #{tendRcrdType},</if>
            <if test="isWtrFarm != null and isWtrFarm != ''">IS_WTR_FARM = #{isWtrFarm},</if>
            <if test="wtrNotFarm != null and wtrNotFarm != ''">WTR_NOT_FARM = #{wtrNotFarm},</if>
            <if test="wtrNotFarmNote != null and wtrNotFarmNote != ''">WTR_NOT_FARM_NOTE = #{wtrNotFarmNote},</if>
            <if test="dstyLen != null and dstyLen != ''">DSTY_LEN = #{dstyLen},</if>
            <if test="siltationLen != null and siltationLen != ''">SILTATION_LEN = #{siltationLen},</if>
            <if test="liningLen != null and liningLen != ''">LINING_LEN = #{liningLen},</if>
            <if test="isWtrOntm != null and isWtrOntm != ''">IS_WTR_ONTM = #{isWtrOntm},</if>
            <if test="wtrFclty != null and wtrFclty != ''">WTR_FCLTY = #{wtrFclty},</if>
            <if test="isWainFclty != null and isWainFclty != ''">IS_WAIN_FCLTY = #{isWainFclty},</if>
            <if test="msurWtrUse != null and msurWtrUse != ''">MSUR_WTR_USE = #{msurWtrUse},</if>
            <if test="chanFull != null and chanFull != ''">CHAN_FULL = #{chanFull},</if>
            <if test="matingFull != null and matingFull != ''">MATING_FULL = #{matingFull},</if>
            <if test="evaluate != null and evaluate != ''">EVALUATE = #{evaluate},</if>
            <if test="note != null and note != ''">NOTE = #{note},</if>
            <if test="invsrName != null and invsrName != ''">INVSR_NAME = #{invsrName},</if>
            <if test="invsrPhone != null and invsrPhone != ''">INVSR_PHONE = #{invsrPhone},</if>
            <if test="invsrTm != null">INVSR_TM = #{invsrTm},</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="state != null and state != ''">STATE = #{state},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspIrrChan">
        update BIS_INSP_IRR_CHAN
        <trim prefix="set" suffixOverrides=",">
            <if test="isCurryearComp != null and isCurryearComp != ''">IS_CURRYEAR_COMP = #{isCurryearComp},</if>
            <if test="beforeCurryearComp != null and beforeCurryearComp != ''">BEFROE_CURRYEAR = #{beforeCurryearComp},</if>
            <if test="afterCurryearComp != null and afterCurryearComp != ''">AFTER_CURRYEAR = #{afterCurryearComp},</if>
            <if test="sourNote != null and sourNote != ''">SOUR_NOTE = #{sourNote},</if>
            <if test="centerX != null and centerX != ''">CENTER_X = #{centerX},</if>
            <if test="centerY != null and centerY != ''">CENTER_Y = #{centerY},</if>
            <if test="gdX != null and gdX != ''">GD_X = #{gdX},</if>
            <if test="gdY != null and gdY != ''">GD_Y = #{gdY},</if>
            <if test="rgstrId != null and rgstrId != ''">RGSTR_ID = #{rgstrId},</if>
            <if test="objId != null and objId != ''">OBJ_ID = #{objId},</if>
            <if test="code != null and code != ''">CODE = #{code},</if>
            <if test="name != null and name != ''">NAME = #{name},</if>
            <if test="adCode != null and adCode != ''">AD_CODE = #{adCode},</if>
            <if test="adName != null and adName != ''">AD_NAME = #{adName},</if>
            <if test="sour != null and sour != ''">SOUR = #{sour},</if>
            <if test="compDate != null and compDate != ''">COMP_DATE = #{compDate},</if>
            <if test="irrCode != null and irrCode != ''">IRR_CODE = #{irrCode},</if>
            <if test="irrName != null and irrName != ''">IRR_NAME = #{irrName},</if>
            <if test="chanLen != null and chanLen != ''">CHAN_LEN = #{chanLen},</if>
            <if test="irrArea != null and irrArea != ''">IRR_AREA = #{irrArea},</if>
            <if test="totFlow != null and totFlow != ''">TOT_FLOW = #{totFlow},</if>
            <if test="higStnType != null and higStnType != ''">HIG_STN_TYPE = #{higStnType},</if>
            <if test="prjPbmArea != null and prjPbmArea != ''">PRJ_PBM_AREA = #{prjPbmArea},</if>
            <if test="prjWhoTend != null and prjWhoTend != ''">PRJ_WHO_TEND = #{prjWhoTend},</if>
            <if test="prjUsrType != null and prjUsrType != ''">PRJ_USR_TYPE = #{prjUsrType},</if>
            <if test="whoTend != null and whoTend != ''">WHO_TEND = #{whoTend},</if>
            <if test="isTendRcrd != null and isTendRcrd != ''">IS_TEND_RCRD = #{isTendRcrd},</if>
            <if test="tendRcrdType != null and tendRcrdType != ''">TEND_RCRD_TYPE = #{tendRcrdType},</if>
            <if test="isWtrFarm != null and isWtrFarm != ''">IS_WTR_FARM = #{isWtrFarm},</if>
            <if test="wtrNotFarm != null and wtrNotFarm != ''">WTR_NOT_FARM = #{wtrNotFarm},</if>
            <if test="wtrNotFarmNote != null and wtrNotFarmNote != ''">WTR_NOT_FARM_NOTE = #{wtrNotFarmNote},</if>
            <if test="dstyLen != null and dstyLen != ''">DSTY_LEN = #{dstyLen},</if>
            <if test="siltationLen != null and siltationLen != ''">SILTATION_LEN = #{siltationLen},</if>
            <if test="liningLen != null and liningLen != ''">LINING_LEN = #{liningLen},</if>
            <if test="isWtrOntm != null and isWtrOntm != ''">IS_WTR_ONTM = #{isWtrOntm},</if>
            <if test="wtrFclty != null and wtrFclty != ''">WTR_FCLTY = #{wtrFclty},</if>
            <if test="isWainFclty != null and isWainFclty != ''">IS_WAIN_FCLTY = #{isWainFclty},</if>
            <if test="msurWtrUse != null and msurWtrUse != ''">MSUR_WTR_USE = #{msurWtrUse},</if>
            <if test="chanFull != null and chanFull != ''">CHAN_FULL = #{chanFull},</if>
            <if test="matingFull != null and matingFull != ''">MATING_FULL = #{matingFull},</if>
            <if test="evaluate != null and evaluate != ''">EVALUATE = #{evaluate},</if>
            <if test="note != null and note != ''">NOTE = #{note},</if>
            <if test="invsrName != null and invsrName != ''">INVSR_NAME = #{invsrName},</if>
            <if test="invsrPhone != null and invsrPhone != ''">INVSR_PHONE = #{invsrPhone},</if>
            <if test="invsrTm != null">INVSR_TM = #{invsrTm},</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="state != null and state != ''">STATE = #{state},</if>
        </trim>
        <include refid="page_where" />
    </update>


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


</mapper>