8b3d8f6204d9af6c525e114db0c473d11d1cf795.svn-base 1.5 KB

123456789101112131415161718192021222324252627
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="org.jeecg.modules.demo.hzz.shjsgc.xmrk.mapper.RmAxxmxxMapper">
  4. <insert id="insetXmxx" parameterType="hashmap">
  5. insert into rm_xmxx(id,create_by,create_time,update_by,update_time,sys_org_code,xmmc,szsx,xzqh,xmfzr,xjqhdm,hzb,zzb,dha,lxqk,spnd,fhbz,spdw,spjb,spqk,ztbzjs,jszt,qt,min_id) values (#{id},#{createBy},#{createTime},#{updateBy},#{updateTime},#{sysOrgCode},#{xmmc},#{szsx},#{xzqh},#{xmfzr},#{xjqhdm},#{hzb},#{zzb},#{dha},#{lxqk},#{spnd},#{fhbz},#{spdw},#{spjb},#{spqk},#{ztbzjs},#{jszt},#{qt},#{id})
  6. </insert>
  7. <insert id="insertShxmxx" parameterType="String">
  8. insert
  9. into rm_shxmxxb(id,xmmc,jszt)
  10. values
  11. (#{id},
  12. #{xmmc},
  13. #{jszt})
  14. </insert>
  15. <update id="updateXmxx" parameterType="hashmap">
  16. update rm_xmxx set xmmc=#{xmmc},szsx=#{szsx},xzqh=#{xzqh},xmfzr=#{xmfzr},xjqhdm=#{xjqhdm},hzb=#{hzb},zzb=#{zzb},dha=#{dha},lxqk=#{lxqk},spnd=#{spnd},fhbz=#{fhbz},spdw=#{spdw},spjb=#{spjb},spqk=#{spqk},ztbzjs=#{ztbzjs},jszt=#{jszt},qt=#{qt} where id=#{id}
  17. </update>
  18. <update id="updateShxmxx" parameterType="String">
  19. update rm_shxmxxb set xmmc=#{xmmc},jszt=#{jszt}where id=#{id}
  20. </update>
  21. <delete id="deletexmxx">
  22. delete from rm_xmxx where id=#{id}
  23. </delete>
  24. <delete id="deleteshxmxx">
  25. delete from rm_shxmxxb where id=#{id}
  26. </delete>
  27. </mapper>