<?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.reg.dao.base.RegBaseCDao">

	<sql id="regBaseCColumns">
		a.id AS "id",
		a.ch AS "ch",
		a.zrzh AS "zrzh",
		a.ysdm AS "ysdm",
		a.sjc AS "sjc",
		a.myc AS "myc",
		a.cjzmj AS "cjzmj",
		a.ctnjzmj AS "ctnjzmj",
		a.cytmj AS "cytmj",
		a.cgyjzmj AS "cgyjzmj",
		a.cftjzmj AS "cftjzmj",
		a.cbqmj AS "cbqmj",
		a.cg AS "cg",
		a.sptymj AS "sptymj",
		a.zid AS "zid",
		a.isnegativelayer AS "isnegativelayer",
		a.ljzh AS "ljzh",
		a.isaudit AS "isaudit",
		a.create_by AS "createBy.id",
		a.create_date AS "createDate",
		a.update_by AS "updateBy.id",
		a.update_date AS "updateDate",
		a.remarks AS "remarks",
		a.del_flag AS "delFlag"
	</sql>

	<sql id="regBaseCJoins">
	</sql>
    
	<select id="get" resultType="RegBaseC">
		SELECT 
			<include refid="regBaseCColumns"/>
		FROM reg_base_c a
		<include refid="regBaseCJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="RegBaseC">
		SELECT 
			<include refid="regBaseCColumns"/>
		FROM reg_base_c a
		<include refid="regBaseCJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
			<if test="sjc != null and sjc != ''">
				AND a.sjc = #{sjc}
			</if>
			<if test="zid != null and zid != ''">
				AND a.zid = #{zid}
			</if>
			<if test="ch != null and ch != ''">
				AND a.ch = #{ch}
			</if>
			<if test="zrzh != null and zrzh != ''">
				AND a.zrzh = #{zrzh}
			</if>
			<if test="ljzh != null and ljzh != ''">
				AND a.ljzh = #{ljzh}
			</if>
			<if test="id != null and id != ''">
				AND a.id = #{id}
			</if>
			<if test="isnegativelayer != null and isnegativelayer != ''">
				AND a.isnegativelayer = #{isnegativelayer}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY to_number(a.sjc) DESC
			</otherwise>
		</choose>
	</select>
	
	<select id="findcsxhList" resultType="RegBaseC">
		SELECT 
			<include refid="regBaseCColumns"/>
		FROM reg_base_c a
		<include refid="regBaseCJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
			<if test="zid != null and zid != ''">
				AND a.zid = #{zid}
			</if>
			<if test="isnegativelayer != null and isnegativelayer != ''">
				AND a.isnegativelayer = #{isnegativelayer}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.ch desc
			</otherwise>
		</choose>
	</select>

	<select id="findAllList" resultType="RegBaseC">
		SELECT 
			<include refid="regBaseCColumns"/>
		FROM reg_base_c a
		<include refid="regBaseCJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
		</where>		
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.ch
			</otherwise>
		</choose>
	</select>

	<insert id="insert">
		INSERT INTO reg_base_c(
			id,
			ch,
			zrzh,
			ysdm,
			sjc,
			myc,
			cjzmj,
			ctnjzmj,
			cytmj,
			cgyjzmj,
			cftjzmj,
			cbqmj,
			cg,
			sptymj,
			zid,
			isnegativelayer,
			ljzh,
			isaudit,
			create_by,
			create_date,
			update_by,
			update_date,
			del_flag
		) VALUES (
			#{id},
			#{ch},
			#{zrzh},
			#{ysdm},
			#{sjc},
			#{myc},
			#{cjzmj},
			#{ctnjzmj},
			#{cytmj},
			#{cgyjzmj},
			#{cftjzmj},
			#{cbqmj},
			#{cg},
			#{sptymj},
			#{zid},
			#{isnegativelayer},
			#{ljzh},
			#{isaudit},
			#{createBy.id},
			#{createDate},
			#{updateBy.id},
			#{updateDate},
			#{delFlag}
		)
	</insert>

	<update id="update">
		UPDATE reg_base_c SET 	
			ch = #{ch},
			zrzh = #{zrzh},
			ysdm = #{ysdm},
			sjc = #{sjc},
			myc = #{myc},
			cjzmj = #{cjzmj},
			ctnjzmj = #{ctnjzmj},
			cytmj = #{cytmj},
			cgyjzmj = #{cgyjzmj},
			cftjzmj = #{cftjzmj},
			cbqmj = #{cbqmj},
			cg = #{cg},
			sptymj = #{sptymj},
			zid = #{zid},
			isnegativelayer = #{isnegativelayer},
			ljzh = #{ljzh},
			isaudit = #{isaudit},
			del_flag = #{delFlag},
			update_by = #{updateBy.id},
			update_date = #{updateDate}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		UPDATE reg_base_c SET 
			del_flag = #{DEL_FLAG_DELETE}
		WHERE id = #{id}
	</update>

	<update id="cdelete">
		DELETE FROM reg_base_c 
		WHERE id = #{id}
	</update>
	
</mapper>