fj-dc/.svn/pristine/3d/3dd97c5b7ecdb2cae0c1b9adf0f583484dc92bcd.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.GwPblmShrDao">

    <select id="getSomeBisInspPblmDataByCondition" resultType="cn.com.goldenwater.dcproj.model.BisInspPblm">
        select * from BIS_INSP_PBLM
        where BELONG_AD_CODE = #{belongAdCode} and OBJ_TYPE in ('1','80') and ZG_STATE = '0'
    </select>
    <update id="updateBisInspPblmById" parameterType="String">
        update BIS_INSP_PBLM set ZG_STATE = '1' where PBLM_ID = #{pblmId}
    </update>
    <insert id="insertGwPblmShr" parameterType="cn.com.goldenwater.dcproj.model.GwPblmShr">
        insert into YHCL_GX.GW_PBLM_SHR
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">ID,</if>
            <if test="code != null">CODE,</if>
            <if test="name != null">NAME,</if>
            <if test="adCode != null">AD_CODE,</if>
            <if test="pblmNameBz != null">PBLM_NAME_BZ,</if>
            <if test="checkPointBz != null">CHECK_POINT_BZ,</if>
            <if test="pblmDescBz != null">PBLM_DESC_BZ,</if>
            <if test="inspPblmDesc != null">INSP_PBLM_DESC,</if>
            <if test="note != null">NOTE,</if>
            <if test="pblmTm != null">PBLM_TM,</if>
            <if test="intm != null">INTM,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="code != null">#{code},</if>
            <if test="name != null">#{name},</if>
            <if test="adCode != null">#{adCode},</if>
            <if test="pblmNameBz != null">#{pblmNameBz},</if>
            <if test="checkPointBz != null">#{checkPointBz},</if>
            <if test="pblmDescBz != null">#{pblmDescBz},</if>
            <if test="inspPblmDesc != null">#{inspPblmDesc},</if>
            <if test="note != null">#{note},</if>
            <if test="pblmTm != null">#{pblmTm},</if>
            <if test="intm != null">#{intm},</if>
         </trim>
    </insert>
    <select id="selectGwPblmShrByCondition" parameterType="cn.com.goldenwater.dcproj.param.GwPblmShrParam" resultType="cn.com.goldenwater.dcproj.model.GwPblmShr">
        select * from YHCL_GX.GW_PBLM_SHR
        where 1=1
        <if test="pblmNameBz != null and pblmNameBz != ''">and PBLM_NAME_BZ = #{pblmNameBz}</if>
        <if test="id != null and id != ''">and ID = #{id}</if>
        <if test="code != null and code != ''">and CODE like '%'||#{code}||'%'</if>
        <if test="name != null and name != ''">and NAME like '%'||#{name}||'%'</if>
        <if test="checkPointBz != null and checkPointBz != ''">and CHECK_POINT_BZ like '%'||#{checkPointBz}||'%'</if>
    </select>
    <select id="getGwPblmShr" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmShr">
        select * from YHCL_GX.GW_PBLM_SHR where ID=#{id}
    </select>
    <select id="selectGwPblmShrFileByCondition" parameterType="cn.com.goldenwater.dcproj.param.GwPblmShrFileParam" resultType="cn.com.goldenwater.dcproj.model.GwPblmShrFile">
        select * from YHCL_GX.GW_PBLM_SHR_FILE
        where 1=1
        <if test="pblmId != null and pblmId != ''">and PBLM_ID = #{pblmId}</if>
        <if test="fileName != null and fileName != ''">and FILE_NAME like '%'||#{fileName}||'%'</if>
    </select>
    <select id="getGwPblmShrFile" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmShrFile">
        select * from YHCL_GX.GW_PBLM_SHR_FILE where PBLM_ID=#{id}
    </select>
    <select id="selectGwPblmRectByCondition" parameterType="cn.com.goldenwater.dcproj.param.GwPblmRectParam" resultType="cn.com.goldenwater.dcproj.model.GwPblmRect">
        select * from YHCL_GX.GW_PBLM_RECT
        where 1=1
        <if test="pblmId != null and pblmId != ''">and PBLM_ID = #{pblmId}</if>
        <if test="pblmState != null and pblmState != ''">and PBLM_STATE = #{pblmState}</if>
    </select>
    <select id="getGwPblmRect" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmRect">
        select * from YHCL_GX.GW_PBLM_RECT where PBLM_ID=#{id}
    </select>
    <select id="getGwPblmRectById" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmRect">
        select * from YHCL_GX.GW_PBLM_RECT where ID=#{id}
    </select>
    <select id="selectGwPblmRectRecordByCondition" parameterType="cn.com.goldenwater.dcproj.param.GwPblmRectRecordParam" resultType="cn.com.goldenwater.dcproj.model.GwPblmRectRecord">
        select * from YHCL_GX.GW_PBLM_RECT_RECORD
        where 1=1
        <if test="pblmId != null and pblmId != ''">and PBLM_ID = #{pblmId}</if>
        <if test="pblmRectDuty != null and pblmRectDuty != ''">and PBLM_RECT_DUTY like '%'||#{pblmRectDuty}||'%'</if>
        <if test="pblmRectName != null and pblmRectName != ''">and PBLM_RECT_NAME like '%'||#{pblmRectName}||'%'</if>
    </select>
    <select id="getGwPblmRectRecord" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmRectRecord">
        select * from YHCL_GX.GW_PBLM_RECT_RECORD where PBLM_ID=#{id} order by PBLM_RECT_TM DESC
    </select>
    <select id="selectGwPblmRectFileByCondition" parameterType="cn.com.goldenwater.dcproj.param.GwPblmRectFileParam" resultType="cn.com.goldenwater.dcproj.model.GwPblmRectFile">
        select * from YHCL_GX.GW_PBLM_RECT_FILE
        where 1=1
        <if test="pblmId != null and pblmId != ''">and PBLM_ID = #{pblmId}</if>
        <if test="fileName != null and fileName != ''">and FILE_NAME like '%'||#{fileName}||'%'</if>
    </select>
    <select id="getGwPblmRectFile" parameterType="java.lang.String" resultType="cn.com.goldenwater.dcproj.model.GwPblmRectFile">
        select * from YHCL_GX.GW_PBLM_RECT_FILE where PBLM_ID=#{id}
    </select>
    <insert id="insertGwPblmShrFile" parameterType="cn.com.goldenwater.dcproj.model.GwPblmShrFile">
        insert into YHCL_GX.GW_PBLM_SHR_FILE
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">ID,</if>
            <if test="pblmId != null">PBLM_ID,</if>
            <if test="fileExt != null">FILE_EXT,</if>
            <if test="fileSize != null">FILE_SIZE,</if>
            <if test="filePath != null">FILE_PATH,</if>
            <if test="fileName != null">FILE_NAME,</if>
            <if test="createDate != null">CREATE_DATE,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="pblmId != null">#{pblmId},</if>
            <if test="fileExt != null">#{fileExt},</if>
            <if test="fileSize != null">#{fileSize},</if>
            <if test="filePath != null">#{filePath},</if>
            <if test="fileName != null">#{fileName},</if>
            <if test="createDate != null">#{createDate},</if>
        </trim>
    </insert>
    <insert id="insertGwPblmRect" parameterType="cn.com.goldenwater.dcproj.model.GwPblmRect">
        insert into YHCL_GX.GW_PBLM_RECT
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">ID,</if>
            <if test="pblmId != null">PBLM_ID,</if>
            <if test="pblmState != null">PBLM_STATE,</if>
            <if test="pblmRectTm != null">PBLM_RECT_TM,</if>
            <if test="pblmNote != null">PBLM_NOTE,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="pblmId != null">#{pblmId},</if>
            <if test="pblmState != null">#{pblmState},</if>
            <if test="pblmRectTm != null">#{pblmRectTm},</if>
            <if test="pblmNote != null">#{pblmNote},</if>
        </trim>
    </insert>
    <insert id="insertGwPblmRectFile" parameterType="cn.com.goldenwater.dcproj.model.GwPblmRectFile">
        insert into YHCL_GX.GW_PBLM_RECT_FILE
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">ID,</if>
            <if test="pblmId != null">PBLM_ID,</if>
            <if test="fileExt != null">FILE_EXT,</if>
            <if test="fileSize != null">FILE_SIZE,</if>
            <if test="filePath != null">FILE_PATH,</if>
            <if test="fileName != null">FILE_NAME,</if>
            <if test="createDate != null">CREATE_DATE,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="pblmId != null">#{pblmId},</if>
            <if test="fileExt != null">#{fileExt},</if>
            <if test="fileSize != null">#{fileSize},</if>
            <if test="filePath != null">#{filePath},</if>
            <if test="fileName != null">#{fileName},</if>
            <if test="createDate != null">#{createDate},</if>
        </trim>
    </insert>
    <insert id="insertGwPblmRectRecord" parameterType="cn.com.goldenwater.dcproj.model.GwPblmRectRecord">
        insert into YHCL_GX.GW_PBLM_RECT_RECORD
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">ID,</if>
            <if test="pblmId != null">PBLM_ID,</if>
            <if test="pblmRectNote != null">PBLM_RECT_NOTE,</if>
            <if test="pblmRectDuty != null">PBLM_RECT_DUTY,</if>
            <if test="pblmRectName != null">PBLM_RECT_NAME,</if>
            <if test="pblmRectTm != null">PBLM_RECT_TM,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="pblmId != null">#{pblmId},</if>
            <if test="pblmRectNote != null">#{pblmRectNote},</if>
            <if test="pblmRectDuty != null">#{pblmRectDuty},</if>
            <if test="pblmRectName != null">#{pblmRectName},</if>
            <if test="pblmRectTm != null">#{pblmRectTm},</if>
        </trim>
    </insert>
</mapper>