<?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.zhj.dao.ZhjZdjgmsbDao">
    
	<sql id="zhjZdjgmsbColumns">
		a.id AS "id",
		a.bdcdyh AS "bdcdyh",
		a.djqdm AS "djqdm",
		a.djqmc AS "djqmc",
		a.djzqdm AS "djzqdm",
		a.djzqmc AS "djzqmc",
		a.bdcqzh AS "bdcqzh",
		a.zl AS "zl",
		a.zdmj AS "zdmj",
		a.qszt AS "qszt",
		a.cgbz AS "cgbz",
		a.errormsg AS "errormsg",
		a.del_flag AS "delFlag",
		a.create_by AS "createBy.id",
		a.create_date AS "createDate",
		a.update_by AS "updateBy.id",
		a.update_date AS "updateDate"
	</sql>
	
	<sql id="zhjZdjgmsbJoins">
	</sql>
    
	<select id="get" resultType="ZhjZdjgmsb">
		SELECT 
			<include refid="zhjZdjgmsbColumns"/>
		FROM zhj_zdjgmsb a
		<include refid="zhjZdjgmsbJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="ZhjZdjgmsb">
		SELECT 
			<include refid="zhjZdjgmsbColumns"/>
		FROM zhj_zdjgmsb a
		<include refid="zhjZdjgmsbJoins"/>
		<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>
	
	<select id="findAllList" resultType="ZhjZdjgmsb">
		SELECT 
			<include refid="zhjZdjgmsbColumns"/>
		FROM zhj_zdjgmsb a
		<include refid="zhjZdjgmsbJoins"/>
		<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 zhj_zdjgmsb(
			id,
			bdcdyh,
			djqdm,
			djqmc,
			djzqdm,
			djzqmc,
			bdcqzh,
			zl,
			zdmj,
			qszt,
			cgbz,
			errormsg,
			del_flag,
			create_by,
			create_date,
			update_by,
			update_date
		) VALUES (
			#{id},
			#{bdcdyh},
			#{djqdm},
			#{djqmc},
			#{djzqdm},
			#{djzqmc},
			#{bdcqzh},
			#{zl},
			#{zdmj},
			#{qszt},
			#{cgbz},
			#{errormsg},
			#{delFlag},
			#{createBy.id},
			#{createDate},
			#{updateBy.id},
			#{updateDate}
		)
	</insert>
	
	<update id="update">
		UPDATE zhj_zdjgmsb SET 	
			bdcdyh = #{bdcdyh},
			djqdm = #{djqdm},
			djqmc = #{djqmc},
			djzqdm = #{djzqdm},
			djzqmc = #{djzqmc},
			bdcqzh = #{bdcqzh},
			zl = #{zl},
			zdmj = #{zdmj},
			qszt = #{qszt},
			cgbz = #{cgbz},
			errormsg = #{errormsg},
			update_by = #{updateBy.id},
			update_date = #{updateDate}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		UPDATE zhj_zdjgmsb SET 
			del_flag = #{DEL_FLAG_DELETE}
		WHERE id = #{id}
	</update>
	
</mapper>