dzhh-backend/.svn/pristine/d9/d912259a37864cccae5bde2f00e1e15647577f21.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.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,xmlx,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},#{xmlx},#{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},xmlx=#{xmlx} 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>
    <insert id="addXmxx" parameterType="Object">
        insert into rm_xmxxgeo(geom,xmid,jszt,xmmc) values (ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490),#{id},#{jszt},#{xmmc});
    </insert>
    <insert id="addXmxx2" parameterType="Object">
        insert into rm_xmxxgeo(geom,xmid,jszt,xmmc) values (ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490),#{id},#{jszt},#{xmmc});
    </insert>
    <insert id="addXmxx3" parameterType="Object">
        insert into rm_xmxxgeo(geom,xmid,jszt,xmmc) values (st_geometryfromtext(#{wkt},4490),#{id},#{jszt},#{xmmc});
    </insert>
    <update id="updXmxx" parameterType="Object">
        update rm_xmxxgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490)),jszt=#{jszt},xmmc=#{xmmc} where xmid=#{id};
    </update>
    <update id="updXmxx2" parameterType="Object">
        update rm_xmxxgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490)),jszt=#{jszt},xmmc=#{xmmc} where xmid=#{id};
    </update>
    <update id="updXmxx3" parameterType="Object">
        update rm_xmxxgeo set geom=(st_geometryfromtext(#{wkt},4490)),jszt=#{jszt},xmmc=#{xmmc} where xmid=#{id};
    </update>
    <delete id="delxmxx" parameterType="String">
        delete from rm_xmxxgeo where xmid=#{id};
    </delete>
    <select id="getGeojson" parameterType="java.lang.String" resultType="String">
        select st_asGeojson(geom) from rm_xmxxgeo where xmid = #{id};
    </select>
    <select id="selectXmxxByid" parameterType="String" resultType="int">
        select count(1)
        from rm_xmxxgeo
        where
             xmid=#{id}
    </select>
</mapper>