<?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.bus.RegBusYwrDao">
    
	<sql id="regBusYwrColumns">
		a.id AS "id",
		a.ysdm AS "ysdm",
		a.ywh AS "ywh",
		a.bdcdyh AS "bdcdyh",
		a.sxh AS "sxh",
		a.qlrmc AS "qlrmc",
		a.pcode AS "pcode",
		a.bdcqzh AS "bdcqzh",
		a.qzysxlh AS "qzysxlh",
		a.sfczr AS "sfczr",
		a.zjzl AS "zjzl",
		a.zjh AS "zjh",
		a.fzjg AS "fzjg",
		a.sshy AS "sshy",
		a.gj AS "gj",
		a.hjszss AS "hjszss",
		a.xb AS "xb",
		a.dh AS "dh",
		a.dz AS "dz",
		a.yb AS "yb",
		a.gzdw AS "gzdw",
		a.dzyj AS "dzyj",
		a.qlrlx AS "qlrlx",
		a.qlbl AS "qlbl",
		a.gyfs AS "gyfs",
		a.gyqk AS "gyqk",
		a.fddbrfzr AS "fddbrfzr",
		a.fddbrfzrdh AS "fddbrfzrdh",
		a.dlrmc AS "dlrmc",
		a.dlrdh AS "dlrdh",
		a.dljgmc AS "dljgmc",
		a.bz AS "bz",
		a.qszt AS "qszt",
		a.qllx AS "qllx",
		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="regBusYwrJoins">
	</sql>
    
	<select id="get" resultType="RegBusYwr">
		SELECT 
			<include refid="regBusYwrColumns"/>
		FROM reg_bus_ywr a
		<include refid="regBusYwrJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="RegBusYwr">
		SELECT 
			<include refid="regBusYwrColumns"/>
		FROM reg_bus_ywr a
		<include refid="regBusYwrJoins"/>
		<where>
			a.del_flag = #{DEL_FLAG_NORMAL}
			<if test="ywh != null and ywh != ''">
				AND a.ywh = #{ywh}
			</if>
			<if test="qlrmc != null and qlrmc != ''">
				AND a.qlrmc LIKE 
					<if test="dbName == 'oracle'">'%'||#{qlrmc}||'%'</if>
					<if test="dbName == 'mssql'">'%'+#{qlrmc}+'%'</if>
					<if test="dbName == 'mysql'">concat('%',#{qlrmc},'%')</if>
			</if>
			<if test="bdcdyh != null and bdcdyh != ''">
				AND a.bdcdyh LIKE 
					<if test="dbName == 'oracle'">'%'||#{bdcdyh}||'%'</if>
					<if test="dbName == 'mssql'">'%'+#{bdcdyh}+'%'</if>
					<if test="dbName == 'mysql'">concat('%',#{bdcdyh},'%')</if>
			</if>
			<if test="pcode != null and pcode != ''">
				AND a.pcode = #{pcode}
			</if>
			<if test="qszt != null and qszt != ''">
				AND a.qszt = #{qszt}
			</if>
			<if test="zjh != null and zjh != ''">
				AND a.zjh = #{zjh}
			</if>
			<if test="zjzl != null and zjzl != ''">
				AND a.zjzl = #{zjzl}
			</if>
			<if test="sxh != null and sxh != ''">
				AND a.sxh = #{sxh}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.sxh ASC
			</otherwise>
		</choose>
	</select>
	
	<select id="findListSxh" resultType="RegBusYwr">
		SELECT 
			<include refid="regBusYwrColumns"/>
		FROM reg_bus_ywr a
		<include refid="regBusYwrJoins"/>
		<where>
			a.del_flag = 0
			<if test="bdcdyh != null and bdcdyh != ''">
				AND a.bdcdyh = #{bdcdyh}
			</if>
			<if test="sxh != null and sxh != ''">
				AND a.sxh = #{sxh}
			</if>
			<if test="sfczr != null and sfczr != ''">
				AND a.sfczr = #{sfczr}
			</if>
			<if test="qlrmc != null and qlrmc != ''">
				AND a.qlrmc LIKE 
					<if test="dbName == 'oracle'">'%'||#{qlrmc}||'%'</if>
					<if test="dbName == 'mssql'">'%'+#{qlrmc}+'%'</if>
					<if test="dbName == 'mysql'">concat('%',#{qlrmc},'%')</if>
			</if>
			<if test="ywh != null and ywh != ''">
				AND a.ywh = #{ywh}
			</if>
			<if test="qszt != null and qszt != ''">
				AND a.qszt = #{qszt}
			</if>
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
				ORDER BY a.sxh ASC
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="RegBusYwr">
		SELECT 
			<include refid="regBusYwrColumns"/>
		FROM reg_bus_ywr a
		<include refid="regBusYwrJoins"/>
		<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_bus_ywr(
			id,
			ysdm,
			ywh,
			bdcdyh,
			sxh,
			qlrmc,
			pcode,
			bdcqzh,
			qzysxlh,
			sfczr,
			zjzl,
			zjh,
			fzjg,
			sshy,
			gj,
			hjszss,
			xb,
			dh,
			dz,
			yb,
			gzdw,
			dzyj,
			qlrlx,
			qlbl,
			gyfs,
			gyqk,
			fddbrfzr,
			fddbrfzrdh,
			dlrmc,
			dlrdh,
			dljgmc,
			bz,
			qszt,
			qllx,
			create_by,
			create_date,
			update_by,
			update_date,
			remarks,
			del_flag
		) VALUES (
			#{id},
			#{ysdm},
			#{ywh},
			#{bdcdyh},
			#{sxh},
			#{qlrmc},
			#{pcode},
			#{bdcqzh},
			#{qzysxlh},
			#{sfczr},
			#{zjzl},
			#{zjh},
			#{fzjg},
			#{sshy},
			#{gj},
			#{hjszss},
			#{xb},
			#{dh},
			#{dz},
			#{yb},
			#{gzdw},
			#{dzyj},
			#{qlrlx},
			#{qlbl},
			#{gyfs},
			#{gyqk},
			#{fddbrfzr},
			#{fddbrfzrdh},
			#{dlrmc},
			#{dlrdh},
			#{dljgmc},
			#{bz},
			#{qszt},
			#{qllx},
			#{createBy.id},
			#{createDate},
			#{updateBy.id},
			#{updateDate},
			#{remarks},
			#{delFlag}
		)
	</insert>
	
	<update id="update">
		UPDATE reg_bus_ywr SET 	
			ysdm = #{ysdm},
			ywh = #{ywh},
			bdcdyh = #{bdcdyh},
			sxh = #{sxh},
			qlrmc = #{qlrmc},
			pcode = #{pcode},
			bdcqzh = #{bdcqzh},
			qzysxlh = #{qzysxlh},
			sfczr = #{sfczr},
			zjzl = #{zjzl},
			zjh = #{zjh},
			fzjg = #{fzjg},
			sshy = #{sshy},
			gj = #{gj},
			hjszss = #{hjszss},
			xb = #{xb},
			dh = #{dh},
			dz = #{dz},
			yb = #{yb},
			gzdw = #{gzdw},
			dzyj = #{dzyj},
			qlrlx = #{qlrlx},
			qlbl = #{qlbl},
			gyfs = #{gyfs},
			gyqk = #{gyqk},
			fddbrfzr = #{fddbrfzr},
			fddbrfzrdh = #{fddbrfzrdh},
			dlrmc = #{dlrmc},
			dlrdh = #{dlrdh},
			dljgmc = #{dljgmc},
			bz = #{bz},
			qszt = #{qszt},
			qllx = #{qllx},
			update_by = #{updateBy.id},
			update_date = #{updateDate},
			remarks = #{remarks}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		DELETE from reg_bus_ywr 
		WHERE id = #{id}
	</update>
	
	<update id="deleteywr">
		delete from reg_bus_ywr 
		<where>
			<if test="ywh != null and ywh != ''">
				AND ywh = #{ywh}
			</if>
			<if test="bdcdyh != null and bdcdyh != ''">
				AND bdcdyh = #{bdcdyh}
			</if>
		</where>
	</update>
	
	<update id="deleteywh">
		DELETE from reg_bus_ywr
		WHERE ywh = #{ywh}
	</update>
	
	
	<select id="findByYwh" resultType="RegBusYwr">
		SELECT 
			<include refid="regBusYwrColumns"/>
		FROM reg_bus_ywr a
		<include refid="regBusYwrJoins"/>
		<where>
			a.del_flag = '0'
				AND a.ywh = #{ywh}
		</where>
		
	</select>
</mapper>