<?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.SRegBusSjchildDao">
    
	<sql id="sRegBusSjchildColumns">
		a.id AS "id",
		a.s_area_code AS "sareaCode",
		a.main_id AS "mainId.id",
		a.sort AS "sort",
		a.sjlx AS "sjlx",
		a.sjmc AS "sjmc",
		a.sjfj AS "sjfj",
		a.sjsl AS "sjsl",
		a.sfsjsy AS "sfsjsy",
		a.sfewsj AS "sfewsj",
		a.sfbcsj AS "sfbcsj",
		a.ys AS "ys",
		a.ischoice AS "ischoice",
		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",
		a.qxid AS "qxid"
	</sql>
	
	<sql id="sRegBusSjchildJoins">
		LEFT JOIN s_reg_bus_sjmain b ON b.id = a.main_id
	</sql>
    
	<select id="get" resultType="SRegBusSjchild">
		SELECT 
			<include refid="sRegBusSjchildColumns"/>
		FROM s_reg_bus_sjchild a
		<include refid="sRegBusSjchildJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="getqxid" resultType="SRegBusSjchild">
		SELECT 
			<include refid="sRegBusSjchildColumns"/>
		FROM s_reg_bus_sjchild a
		<include refid="sRegBusSjchildJoins"/>
		WHERE a.qxid = #{qxid}
	</select>
	
	<select id="findList" resultType="SRegBusSjchild">
		SELECT 
			<include refid="sRegBusSjchildColumns"/>
		FROM s_reg_bus_sjchild a
		<include refid="sRegBusSjchildJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
			<if test="sareaCode != null and sareaCode != ''">
				AND a.s_area_code = #{sareaCode}
			</if>
			<if test="qxid != null and qxid != ''">
				AND a.qxid = #{qxid}
			</if>
			<if test="mainId != null and mainId.id != null and mainId.id != ''">
				AND a.main_id = #{mainId.id}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.create_date ASC
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="SRegBusSjchild">
		SELECT 
			<include refid="sRegBusSjchildColumns"/>
		FROM s_reg_bus_sjchild a
		<include refid="sRegBusSjchildJoins"/>
		<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.create_date ASC
			</otherwise>
		</choose>
	</select>
	
	<insert id="insert">
		INSERT INTO s_reg_bus_sjchild(
			id,
			s_area_code,
			main_id,
			sort,
			sjlx,
			sjmc,
			sjfj,
			sjsl,
			sfsjsy,
			sfewsj,
			sfbcsj,
			ys,
			ischoice,
			create_by,
			create_date,
			update_by,
			update_date,
			remarks,
			del_flag,
			qxid
		) VALUES (
			#{id},
			#{sareaCode},
			#{mainId.id},
			#{sort},
			#{sjlx},
			#{sjmc},
			#{sjfj},
			#{sjsl},
			#{sfsjsy},
			#{sfewsj},
			#{sfbcsj},
			#{ys},
			#{ischoice},
			#{createBy.id},
			#{createDate},
			#{updateBy.id},
			#{updateDate},
			#{remarks},
			#{delFlag},
			#{qxid}
		)
	</insert>
	
	<update id="update">
		UPDATE s_reg_bus_sjchild SET 	
			s_area_code = #{sareaCode},
			main_id = #{mainId.id},
			sort = #{sort},
			sjlx = #{sjlx},
			sjmc = #{sjmc},
			sjfj = #{sjfj},
			sjsl = #{sjsl},
			sfsjsy = #{sfsjsy},
			sfewsj = #{sfewsj},
			sfbcsj = #{sfbcsj},
			ys = #{ys},
			ischoice = #{ischoice},
			update_by = #{updateBy.id},
			update_date = #{updateDate},
			remarks = #{remarks},
			qxid = #{qxid}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		UPDATE s_reg_bus_sjchild SET 
			del_flag = #{DEL_FLAG_DELETE}
		<choose>
			<when test="id !=null and id != ''">
				WHERE id = #{id}
			</when>
			<otherwise>
				WHERE main_id = #{mainId.id}
			</otherwise>
		</choose>
	</update>
	
</mapper>