<?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.RegBusFcxxqueryDao">
    
	<sql id="regBusFcxxqueryColumns">
		a.id AS "id",
		a.qlrmc AS "qlrmc",
		a.zjh AS "zjh",
		a.gyqlrmc AS "gyqlrmc",
		a.gyzjh AS "gyzjh",
		a.bdcqzh AS "bdcqzh",
		a.zl AS "zl",
		a.scjzmj AS "scjzmj",
		a.fwyt1 AS "fwyt1",
		a.dbsj AS "dbsj",
		a.sjyxzt AS "sjyxzt",
		a.fwxzzt AS "fwxzzt",
		a.djxl AS "djxl"
	</sql>
	
	<sql id="regBusFcxxqueryJoins">
	</sql>
    
	<select id="get" resultType="RegBusFcxxquery">
		SELECT 
			<include refid="regBusFcxxqueryColumns"/>
		FROM reg_bus_fcxxquery a
		<include refid="regBusFcxxqueryJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="RegBusFcxxquery">
		SELECT 
			<include refid="regBusFcxxqueryColumns"/>
		FROM reg_bus_fcxxquery a
		<include refid="regBusFcxxqueryJoins"/>
		<where>
			
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<select id="findAllList" resultType="RegBusFcxxquery">
		SELECT 
			<include refid="regBusFcxxqueryColumns"/>
		FROM reg_bus_fcxxquery a
		<include refid="regBusFcxxqueryJoins"/>
		<where>
			
		</where>		
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>
	
	<insert id="insert">
		INSERT INTO reg_bus_fcxxquery(
			id,
			qlrmc,
			zjh,
			gyqlrmc,
			gyzjh,
			bdcqzh,
			zl,
			scjzmj,
			fwyt1,
			dbsj,
			sjyxzt,
			fwxzzt,
			djxl
		) VALUES (
			#{id},
			#{qlrmc},
			#{zjh},
			#{gyqlrmc},
			#{gyzjh},
			#{bdcqzh},
			#{zl},
			#{scjzmj},
			#{fwyt1},
			#{dbsj},
			#{sjyxzt},
			#{fwxzzt},
			#{djxl}
		)
	</insert>
	
	<update id="update">
		UPDATE reg_bus_fcxxquery SET 	
			qlrmc = #{qlrmc},
			zjh = #{zjh},
			gyqlrmc = #{gyqlrmc},
			gyzjh = #{gyzjh},
			bdcqzh = #{bdcqzh},
			zl = #{zl},
			scjzmj = #{scjzmj},
			fwyt1 = #{fwyt1},
			dbsj = #{dbsj},
			sjyxzt = #{sjyxzt},
			fwxzzt = #{fwxzzt},
			djxl = #{djxl}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		DELETE FROM reg_bus_fcxxquery
		WHERE id = #{id}
	</update>
	
</mapper>