dzhh-backend/.svn/pristine/aa/aae5b258c9009acd33d09a98cbef7471f63db4f3.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="org.jeecg.modules.demo.hzz.shjsgc.xcjgjl.mapper.RmXcjgjlMapper">
    <insert id="addshxm" keyProperty="id">
        insert into rm_shxmxxb(id,xmmc) values(#{id},#{xmmc})
    </insert>
    <delete id="delshxm" parameterType="String">
        delete from rm_shxmxxb where id=#{id}
    </delete>
    <update id="updatashxm" keyProperty="id">
        update rm_shxmxxb set xmmc=#{xmmc} where id=#{id}
    </update>

    <insert id="insertjg" parameterType="String">
           insert into rm_jgjlb(id,main_id,jsxmmc,jsxmszd,jsqk,czwtjclqk,sgxcsffhyq,out_key) values (#{id},#{main_id},#{jsxmmc},#{jsxmszd},#{jsqk},#{czwtjclqk},#{sgxcsffhyq},#{out_key})
    </insert>
    <insert id="insertjgjl" parameterType="hashmap">
           insert into rm_jgjl(id,main_id,jcmc,jcsj,jgdw,jgfzr,czwtjclqk,out_key) values (#{id},#{main_id},#{jcmc},#{jcsj},#{jgdw},#{jgfzr},#{czwtjclqk},#{out_key})
    </insert>
    <insert id="insertjgjl" parameterType="hashmap">
  insert into rm_jgjl(id,main_id,jcmc,jcsj,jgdw,jgfzr,czwtjclqk,out_key) values (#{id},#{main_id},#{jcmc},#{jcsj},#{jgdw},#{jgfzr},#{czwtjclqk},#{out_key})
--            insert into rm_jgjl(id,main_id,jsxmmc,jsxmszd,jsqk,czwtjclqk,sgxcsffhyq,out_key) values (#{id},#{main_id},#{jsxmmc},#{jsxmszd},#{jsqk},#{czwtjclqk},#{sgxcsffhyq},#{out_key})
    </insert>
    <select id="selectid" parameterType="String" resultType="String">
        select id from rm_shxmxxb where id=#{id}
    </select>
    <select id="selectXmxxid" parameterType="String" resultType="String">
        select id from rm_xmxx where id=#{id}
    </select>
    <delete id="delejgjlb" parameterType="String">
        delete from rm_jgjlb where out_key=#{id}
    </delete>
    <delete id="delejgjl" parameterType="String">
        delete from rm_jgjl where out_key=#{id}
    </delete>
    <select id="selectjsxmid" parameterType="String" resultType="String">
        select jsxmid from rm_xcjgjl where id=#{id}
    </select>
<!--    <select id="selectid" parameterType="String" resultType="String">-->
<!--        select id from rm_jgjlb where main_id=#{id}-->
<!--    </select>-->
    <update id="updatejgjl" parameterType="hashmap">
        update rm_jgjl set jcmc=#{jcmc},jcsj=#{jcsj},jgdw=#{jgdw},jgfzr=#{jgfzr},czwtjclqk=#{czwtcjqk} where out_key=#{id}
    </update>
    <select id="selectjgjl" resultType="hashmap">
        select jcmc,create_by,create_time,czwtjclqk from rm_xcjgjl ORDER BY create_time desc
    </select>
    <insert id="insertXmrk" parameterType="hashmap">
        insert into rm_axxmxx(id,xmmc,xzqh,spqk,jszt) values (#{id},#{xmmc},#{xzqh},#{spqk},#{jszt})
    </insert>
</mapper>