<?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.RegBaseLjzDao">
    
	<sql id="regBaseLjzColumns">
		a.id AS "id",
		a.ljzh AS "ljzh",
		a.zrzh AS "zrzh",
		a.ysdm AS "ysdm",
		a.mph AS "mph",
		a.ycjzmj AS "ycjzmj",
		a.ycdxmj AS "ycdxmj",
		a.ycqtmj AS "ycqtmj",
		a.scjzmj AS "scjzmj",
		a.scdxmj AS "scdxmj",
		a.scqtmj AS "scqtmj",
		a.jgrq AS "jgrq",
		a.fwjg1 AS "fwjg1",
		a.fwjg2 AS "fwjg2",
		a.fwjg3 AS "fwjg3",
		a.jzwzt AS "jzwzt",
		a.fwyt1 AS "fwyt1",
		a.fwyt2 AS "fwyt2",
		a.fwyt3 AS "fwyt3",
		a.zcs AS "zcs",
		a.dscs AS "dscs",
		a.dxcs AS "dxcs",
		a.bz AS "bz",
		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="regBaseLjzJoins">
	</sql>
    
	<select id="get" resultType="RegBaseLjz">
		SELECT 
			<include refid="regBaseLjzColumns"/>
		FROM reg_base_ljz a
		<include refid="regBaseLjzJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="RegBaseLjz">
		SELECT 
			<include refid="regBaseLjzColumns"/>
		FROM reg_base_ljz a
		<include refid="regBaseLjzJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
			<if test="ljzh != null and ljzh != ''">
				AND a.ljzh = #{ljzh}
			</if>
			<if test="zrzh != null and zrzh != ''">
				AND a.zrzh = #{zrzh}
			</if>
			<if test="mph != null and mph != ''">
				AND a.mph = #{mph}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.update_date DESC
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="RegBaseLjz">
		SELECT 
			<include refid="regBaseLjzColumns"/>
		FROM reg_base_ljz a
		<include refid="regBaseLjzJoins"/>
		<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.update_date DESC
			</otherwise>
		</choose>
	</select>
	
	<insert id="insert">
		INSERT INTO reg_base_ljz(
			id,
			ljzh,
			zrzh,
			ysdm,
			mph,
			ycjzmj,
			ycdxmj,
			ycqtmj,
			scjzmj,
			scdxmj,
			scqtmj,
			jgrq,
			fwjg1,
			fwjg2,
			fwjg3,
			jzwzt,
			fwyt1,
			fwyt2,
			fwyt3,
			zcs,
			dscs,
			dxcs,
			bz,
			create_by,
			create_date,
			update_by,
			update_date,
			del_flag
		) VALUES (
			#{id},
			#{ljzh},
			#{zrzh},
			#{ysdm},
			#{mph},
			#{ycjzmj},
			#{ycdxmj},
			#{ycqtmj},
			#{scjzmj},
			#{scdxmj},
			#{scqtmj},
			#{jgrq},
			#{fwjg1},
			#{fwjg2},
			#{fwjg3},
			#{jzwzt},
			#{fwyt1},
			#{fwyt2},
			#{fwyt3},
			#{zcs},
			#{dscs},
			#{dxcs},
			#{bz},
			#{createBy.id},
			#{createDate},
			#{updateBy.id},
			#{updateDate},
			#{delFlag}
		)
	</insert>
	
	<update id="update">
		UPDATE reg_base_ljz SET 	
			ljzh = #{ljzh},
			zrzh = #{zrzh},
			ysdm = #{ysdm},
			mph = #{mph},
			ycjzmj = #{ycjzmj},
			ycdxmj = #{ycdxmj},
			ycqtmj = #{ycqtmj},
			scjzmj = #{scjzmj},
			scdxmj = #{scdxmj},
			scqtmj = #{scqtmj},
			jgrq = #{jgrq},
			fwjg1 = #{fwjg1},
			fwjg2 = #{fwjg2},
			fwjg3 = #{fwjg3},
			jzwzt = #{jzwzt},
			fwyt1 = #{fwyt1},
			fwyt2 = #{fwyt2},
			fwyt3 = #{fwyt3},
			zcs = #{zcs},
			dscs = #{dscs},
			dxcs = #{dxcs},
			bz = #{bz},
			del_flag = #{delFlag},
			update_by = #{updateBy.id},
			update_date = #{updateDate}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		UPDATE reg_base_ljz SET 
			del_flag = #{DEL_FLAG_DELETE}
		WHERE id = #{id}
	</update>
	
	<select id="MaxZh" resultType="string" >
		SELECT
		max(SUBSTR(ljzh, -2)) from reg_base_ljz where zrzh = #{zrzh}
	</select>
    <!-- 权籍接口用 -->
	<select id="getByZrzhLjzh" resultType="RegBaseLjz">
		SELECT 
			<include refid="regBaseLjzColumns"/>
		FROM reg_base_ljz a
		<include refid="regBaseLjzJoins"/>
		WHERE a.zrzh = #{0} 
		and a.ljzh = #{1}
		AND a.del_flag = '0'
	</select>
</mapper>