dzhh-backend/.svn/pristine/ed/eda46d2fa699217b8cc8f57bac37e9b1b178e279.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.xxgl.hdmx.mapper.RmPmtxxMapper">

	<delete id="deleteByMainId" parameterType="java.lang.String">
		DELETE 
		FROM  rm_pmtxx 
		WHERE
			 rvid = #{mainId} 
	</delete>
	
	<select id="selectByMainId" parameterType="java.lang.String" resultType="org.jeecg.modules.demo.hzz.xxgl.hdmx.entity.RmPmtxx">
		SELECT * 
		FROM  rm_pmtxx
		WHERE
			 rvid = #{mainId} 
	</select>
	<insert id="addzdm" parameterType="Object">
        insert into rm_hdmzxdgeo(geom,zh,zbid) values (ST_Transform(st_geometryfromtext(#{geom}, 4548),4490),#{zh},#{zbid});
    </insert>
	<insert id="addzdm2" parameterType="Object">
        insert into rm_hdmzxdgeo(geom,zh,zbid) values (st_geometryfromtext(#{geom},4490),#{zh},#{zbid});
    </insert>
	<insert id="addzdm3" parameterType="Object">
        insert into rm_hdmzxdgeo(geom,zh,zbid) values (ST_Transform(st_geometryfromtext(#{geom}, 4527),4490),#{zh},#{zbid});
    </insert>
	<update id="updzdm" parameterType="Object">
        update  rm_hdmzxdgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4548),4490)),zh=#{zh} where zbid=#{zbid};
    </update>
	<update id="updzdm2" parameterType="Object">
        update  rm_hdmzxdgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4527),4490)),zh=#{zh} where zbid=#{zbid};
    </update>
	<update id="updzdm3" parameterType="Object">
        update  rm_hdmzxdgeo set geom=(st_geometryfromtext(#{geom},4490)),zh=#{zh} where zbid=#{zbid};
    </update>
	<select id="getGeojson" parameterType="java.lang.String" resultType="java.lang.String">
        select st_asGeojson(geom) from rm_hdmzxdgeo where zbid = #{relId};
    </select>
	<delete id="delzdm" parameterType="String">
        delete from rm_hdmzxdgeo where zbid=#{id};
    </delete>
</mapper>