fj-dc/.svn/pristine/f6/f6be40ebfafe5cc1122e463a4b9d4d6cd8782de4.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.BisInspSchemeDao">

    <resultMap type="cn.com.goldenwater.dcproj.model.BisInspScheme" id="bisInspSchemeResultMap">
        <result property="guid" column="GUID"/>
        <result property="schmId" column="SCHM_ID"/>
        <result property="schmTitle" column="SCHM_TITLE"/>
        <result property="schmContent" column="SCHM_CONTENT"/>
        <result property="schmMkps" column="SCHM_MKPS"/>
        <result property="schmSttm" column="SCHM_STTM"/>
        <result property="schmEnttm" column="SCHM_ENTTM"/>
        <result property="schmIntm" column="SCHM_INTM"/>
        <result property="schmUptm" column="SCHM_UPTM"/>
        <result property="schmNote" column="SCHM_NOTE"/>
    </resultMap>

    <sql id="table_columns">
        SCHM_ID,
        SCHM_NUM,
        SCHM_TITLE,
        SCHM_STTM,
        SCHM_ENTTM,
        SCHM_TYPE,
        SCHM_CDPCODE,
        SCHM_MKPS,
        GUID,
        SCHM_INTM,
        SCHM_UPTM,
        SCHM_NOTE
    </sql>
    <sql id="entity_properties">
        #{schmId},
        #{schmNum},
        #{schmTitle},
        #{schmSttm},
        #{schmEnttm},
        #{schmType},
        #{schmCdpcode},
        #{schmMkps},
        #{guid},
        #{schmIntm},
        #{schmUptm},
        #{schmNote}
    </sql>

    <!-- 使用like用法：columnName like concat('%',#columnName#,'%') -->
    <sql id="page_where">
        <trim prefix="where" prefixOverrides="and | or ">
            <if test="schmId != null and schmId != ''">and SCHM_ID = #{schmId}</if>
            <if test="schmTitle != null and schmTitle != ''">and SCHM_TITLE = #{schmTitle}</if>
            <if test="schmContent != null and schmContent != ''">and SCHM_CONTENT = #{schmContent}</if>
            <if test="schmMkps != null and schmMkps != ''">and SCHM_MKPS = #{schmMkps}</if>
            <if test="schmSttm != null">and SCHM_STTM = #{schmSttm}</if>
            <if test="schmEnttm != null">and SCHM_ENTTM = #{schmEnttm}</if>
            <if test="schmIntm != null">and SCHM_INTM = #{schmIntm}</if>
            <if test="schmUptm != null">and SCHM_UPTM = #{schmUptm}</if>
            <if test="schmNote != null and schmNote != ''">and SCHM_NOTE = #{schmNote}</if>
        </trim>
    </sql>


    <select id="get" resultMap="bisInspSchemeResultMap" parameterType="String">
        select
        <include refid="table_columns"/>
        from bis_insp_scheme where SCHM_ID = #{id}
    </select>

    <select id="getBy" resultMap="bisInspSchemeResultMap">
        select
        <include refid="table_columns"/>
        from bis_insp_scheme
        <include refid="page_where"/>
    </select>

    <select id="findAll" resultMap="bisInspSchemeResultMap">
        select
        <include refid="table_columns"/>
        from bis_insp_scheme
    </select>

    <select id="findList" resultMap="bisInspSchemeResultMap">
        select
        <include refid="table_columns"/>
        from bis_insp_scheme
        <include refid="page_where"/>
    </select>

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


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

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

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

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

    <update id="update" parameterType="cn.com.goldenwater.dcproj.model.BisInspScheme">
        update bis_insp_scheme
        <trim prefix="set" suffixOverrides=",">
            <if test="schmId != null and schmId != ''">SCHM_ID = #{schmId},</if>
            <if test="schmTitle != null and schmTitle != ''">SCHM_TITLE = #{schmTitle},</if>
            <if test="schmContent != null and schmContent != ''">SCHM_CONTENT = #{schmContent},</if>
            <if test="schmMkps != null and schmMkps != ''">SCHM_MKPS = #{schmMkps},</if>
            <if test="schmSttm != null">SCHM_STTM = #{schmSttm},</if>
            <if test="schmEnttm != null">SCHM_ENTTM = #{schmEnttm},</if>
            <if test="schmIntm != null">SCHM_INTM = #{schmIntm},</if>
            <if test="schmUptm != null">SCHM_UPTM = #{schmUptm},</if>
            <if test="schmNote != null and schmNote != ''">SCHM_NOTE = #{schmNote},</if>
        </trim>
        <where>ID = #{id}</where>
    </update>

    <update id="updateBy" parameterType="cn.com.goldenwater.dcproj.model.BisInspScheme">
        update bis_insp_scheme
        <trim prefix="set" suffixOverrides=",">
            <if test="schmId != null and schmId != ''">SCHM_ID = #{schmId},</if>
            <if test="schmTitle != null and schmTitle != ''">SCHM_TITLE = #{schmTitle},</if>
            <if test="schmContent != null and schmContent != ''">SCHM_CONTENT = #{schmContent},</if>
            <if test="schmMkps != null and schmMkps != ''">SCHM_MKPS = #{schmMkps},</if>
            <if test="schmSttm != null">SCHM_STTM = #{schmSttm},</if>
            <if test="schmEnttm != null">SCHM_ENTTM = #{schmEnttm},</if>
            <if test="schmIntm != null">SCHM_INTM = #{schmIntm},</if>
            <if test="schmUptm != null">SCHM_UPTM = #{schmUptm},</if>
            <if test="schmNote != null and schmNote != ''">SCHM_NOTE = #{schmNote},</if>
        </trim>
        <include refid="page_where"/>
    </update>


    <!-- 其他自定义SQL -->
    <select id="getDCFAListByOrgId" resultType="cn.com.goldenwater.dcproj.model.BisInspScheme">
        select t.*,B.org_name schmCdpname
        from BIS_INSP_SCHEME t LEFT JOIN ATT_ORG_BASE B ON t.SCHM_CDPCODE = B.guid
        where
        TRIM(t.guid) = #{id}
    </select>

    <select id="getDCFAListByType" resultType="cn.com.goldenwater.dcproj.model.BisInspScheme">
        select t.*
        from BIS_INSP_SCHEME t
        where
        t.schmType = #{type}
    </select>

    <!--添加接收单位或抄送单位信息-->
    <insert id="insertSrdp">
        INSERT INTO BIS_INSP_SRDP VALUES (#{uuid},#{guid},#{s},#{s1})
    </insert>
</mapper>