| 123456789101112131415161718192021222324252627 |
- <?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.xmrk.mapper.RmAxxmxxMapper">
- <insert id="insetXmxx" parameterType="hashmap">
- 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})
- </insert>
- <insert id="insertShxmxx" parameterType="String">
- insert
- into rm_shxmxxb(id,xmmc,jszt)
- values
- (#{id},
- #{xmmc},
- #{jszt})
- </insert>
- <update id="updateXmxx" parameterType="hashmap">
- 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}
- </update>
- <update id="updateShxmxx" parameterType="String">
- update rm_shxmxxb set xmmc=#{xmmc},jszt=#{jszt}where id=#{id}
- </update>
- <delete id="deletexmxx">
- delete from rm_xmxx where id=#{id}
- </delete>
- <delete id="deleteshxmxx">
- delete from rm_shxmxxb where id=#{id}
- </delete>
- </mapper>
|
