dzhh-backend/.svn/pristine/bb/bb17f909c0ce2dad6ceaded1c316bf6e3b2bcbb5.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.RmAxshbfgcxxbMapper">

	<delete id="deleteByMainId" parameterType="java.lang.String">
		DELETE 
		FROM  rm_axshbfgcxxb 
		WHERE
			 main_id = #{mainId} 
	</delete>
	
	<select id="selectByMainId" parameterType="java.lang.String" resultType="org.jeecg.modules.demo.hzz.shjsgc.xmrk.entity.RmAxshbfgcxxb">
		SELECT * 
		FROM  rm_axshbfgcxxb
		WHERE
			 main_id = #{mainId} 
	</select>
	<insert id="insertFxJscg" keyProperty="id" parameterType="java.lang.String">
		insert into rm_axfxjszycgb(id,gcmc,main_id) values (#{id},#{gcmc},#{main_id})
	</insert>
	<select id="selectXmxx" resultType="String"  parameterType="String"  >
		select main_id from rm_axshbfgcxxb where id=#{id}
	</select>
	<insert id="insertHdzyzb" parameterType="String" >
		insert into rm_axhdzyzb(id,hqmc,main_id)values (#{id},#{hqmc},#{main_id})
	</insert>

	<insert id="addgshbfgc" parameterType="Object">
        insert into rm_shbfgcxxgeo(geom,gcid,gcmc) values (ST_Transform(st_geometryfromtext(#{geom}, 4548),4490),#{id},#{gcmc});
    </insert>
	<insert id="addgshbfgc2" parameterType="Object">
        insert into  rm_shbfgcxxgeo(geom,gcid,gcmc) values (st_geometryfromtext(#{geom},4490),#{id},#{gcmc});
    </insert>
	<insert id="addgshbfgc3" parameterType="Object">
        insert into  rm_shbfgcxxgeo(geom,gcid,gcmc) values (ST_Transform(st_geometryfromtext(#{geom}, 4527),4490),#{id},#{gcmc});
    </insert>
	<update id="updshbfgc" parameterType="Object">
        update  rm_shbfgcxxgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4548),4490)),gcmc=#{gcmc} where gcid=#{id};
    </update>
	<update id="updshbfgc2" parameterType="Object">
        update  rm_shbfgcxxgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4527),4490)),gcmc=#{gcmc} where gcid=#{id};
    </update>
	<update id="updshbfgc3" parameterType="Object">
        update  rm_shbfgcxxgeo set geom=(st_geometryfromtext(#{geom},4490)),gcmc=#{gcmc}  where gcid=#{id};
    </update>
	<select id="getGeojson" parameterType="java.lang.String" resultType="java.lang.String">
        select st_asGeojson(geom) from rm_shbfgcxxgeo where gcid = #{relId};
    </select>
	<delete id="delshbfgc" parameterType="String">
        delete from rm_shbfgcxxgeo where gcid=#{id};
    </delete>
	<select id="selectgcxx" resultType="hashmap" parameterType="String">
       select id,gcmc,shlx,sjhd,jd,wd from rm_axshbfgcxxb where main_id=#{id}
    </select>
</mapper>