<?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="com.thinkgem.jeesite.modules.sumdata.dao.datatable.SRegBusSjhjtableDao">
    
	<sql id="sRegBusSjhjtableColumns">
		a.bizmsgid AS "bizmsgid",
		a.s_area_code AS "sareaCode",
		a.asid AS "asid",
		a.areacode AS "areacode",
		a.rectype AS "rectype",
		a.righttype AS "righttype",
		a.regtype AS "regtype",
		a.createdate AS "createdate",
		a.recflowid AS "recflowid",
		a.regorgid AS "regorgid",
		a.parcelid AS "parcelid",
		a.estatenum AS "estatenum",
		a.preestatenum AS "preestatenum",
		a.precertid AS "precertid",
		a.certcount AS "certcount",
		a.proofcount AS "proofcount",
		a.digitalsign AS "digitalsign",
		a.qxid AS "qxid"
	</sql>
	
	<sql id="sRegBusSjhjtableJoins">
	</sql>
    
	<select id="get" resultType="SRegBusSjhjtable">
		SELECT 
			<include refid="sRegBusSjhjtableColumns"/>
		FROM s_reg_bus_sjhjtable a
		<include refid="sRegBusSjhjtableJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="getqxid" resultType="SRegBusSjhjtable">
		SELECT 
			<include refid="sRegBusSjhjtableColumns"/>
		FROM s_reg_bus_sjhjtable a
		<include refid="sRegBusSjhjtableJoins"/>
		WHERE a.qxid = #{qxid}
	</select>
	
	<select id="findList" resultType="SRegBusSjhjtable">
		SELECT 
			<include refid="sRegBusSjhjtableColumns"/>
		FROM s_reg_bus_sjhjtable a
		<include refid="sRegBusSjhjtableJoins"/>
		<where>
			<if test="sareaCode != null and sareaCode != ''">
				AND a.s_area_code = #{sareaCode}
			</if>
			<if test="qxid != null and qxid != ''">
				AND a.qxid = #{qxid}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="SRegBusSjhjtable">
		SELECT 
			<include refid="sRegBusSjhjtableColumns"/>
		FROM s_reg_bus_sjhjtable a
		<include refid="sRegBusSjhjtableJoins"/>
		<where>
			
		</where>		
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<insert id="insert">
		INSERT INTO s_reg_bus_sjhjtable(
			bizmsgid,
			s_area_code,
			asid,
			areacode,
			rectype,
			righttype,
			regtype,
			createdate,
			recflowid,
			regorgid,
			parcelid,
			estatenum,
			preestatenum,
			precertid,
			certcount,
			proofcount,
			digitalsign,
			qxid
		) VALUES (
			#{bizmsgid},
			#{sareaCode},
			#{asid},
			#{areacode},
			#{rectype},
			#{righttype},
			#{regtype},
			#{createdate},
			#{recflowid},
			#{regorgid},
			#{parcelid},
			#{estatenum},
			#{preestatenum},
			#{precertid},
			#{certcount},
			#{proofcount},
			#{digitalsign},
			#{qxid}
		)
	</insert>
	
	<update id="update">
		UPDATE s_reg_bus_sjhjtable SET 	
			bizmsgid = #{bizmsgid},
			s_area_code = #{sareaCode},
			asid = #{asid},
			areacode = #{areacode},
			rectype = #{rectype},
			righttype = #{righttype},
			regtype = #{regtype},
			createdate = #{createdate},
			recflowid = #{recflowid},
			regorgid = #{regorgid},
			parcelid = #{parcelid},
			estatenum = #{estatenum},
			preestatenum = #{preestatenum},
			precertid = #{precertid},
			certcount = #{certcount},
			proofcount = #{proofcount},
			digitalsign = #{digitalsign},
			qxid = #{qxid}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		DELETE FROM s_reg_bus_sjhjtable
		WHERE id = #{id}
	</update>
	
</mapper>