dzhh-backend/.svn/pristine/7c/7c10882fdf34e1036036585e323c42d48e5e51fe.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.sjcjrw.rmcjrk.mapper.RmCjrkMapper">
    <insert id="addcjrkgeo" parameterType="Object">
        insert into rm_cjrkgeo(geom,cjrkid,jd,wd) values (ST_Transform(st_geometryfromtext(#{geom}, 4548),4490),#{id},#{jd},#{wd});
    </insert>
    <insert id="addcjrkgeo2" parameterType="Object">
        insert into  rm_cjrkgeo(geom,cjrkid,jd,wd) values (st_geometryfromtext(#{geom},4490),#{id},#{jd},#{wd});
    </insert>
    <insert id="addcjrkgeo3" parameterType="Object">
        insert into  rm_cjrkgeo(geom,cjrkid,jd,wd) values (ST_Transform(st_geometryfromtext(#{geom}, 4527),4490),#{id},#{jd},#{wd});
    </insert>
    <update id="updcjrkgeo" parameterType="Object">
        update  rm_cjrkgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4548),4490)),jd=#{jd},wd=#{wd} where cjrkid=#{id};
    </update>
    <update id="updcjrkgeo2" parameterType="Object">
        update  rm_cjrkgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4527),4490)),jd=#{jd},wd=#{wd} where cjrkid=#{id};
    </update>
    <update id="updcjrkgeo3" parameterType="Object">
        update  rm_cjrkgeo set geom=(st_geometryfromtext(#{geom},4490)),jd=#{jd},wd=#{wd}  where cjrkid=#{id};
    </update>
    <select id="getGeojson" parameterType="java.lang.String" resultType="java.lang.String">
        select st_asGeojson(geom) from rm_cjrkgeo where cjrkid = #{relId};
    </select>
    <delete id="delcjrkgeo" parameterType="String">
        delete from rm_cjrkgeo where cjrkid=#{id};
    </delete>

</mapper>