<?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.qjxt.BdcQlrxxDao">
    
	<sql id="bdcQlrxxColumns">
		a.id0 AS "id0",
		a.zddm AS "zddm",
		a.bdcdyh AS "bdcdyh",
		a.qlrmc AS "qlrmc",
		a.zjzl AS "zjzl",
		a.zjh AS "zjh",
		a.lxdh AS "lxdh",
		a.qlrlx AS "qlrlx",
		a.txdz AS "txdz",
		a.bz AS "bz",
		a.zt AS "zt"
	</sql>
	
	<sql id="bdcQlrxxJoins">
	</sql>
    
	<select id="get" resultType="BdcQlrxx">
		SELECT 
			<include refid="bdcQlrxxColumns"/>
		FROM bdc_qlrxx a
		<include refid="bdcQlrxxJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="BdcQlrxx">
		SELECT 
			<include refid="bdcQlrxxColumns"/>
		FROM bdc_qlrxx a
		<include refid="bdcQlrxxJoins"/>
		<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="BdcQlrxx">
		SELECT 
			<include refid="bdcQlrxxColumns"/>
		FROM bdc_qlrxx a
		<include refid="bdcQlrxxJoins"/>
		<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 bdc_qlrxx(
			id0,
			zddm,
			bdcdyh,
			qlrmc,
			zjzl,
			zjh,
			lxdh,
			qlrlx,
			txdz,
			bz,
			zt
		) VALUES (
			#{id0},
			#{zddm},
			#{bdcdyh},
			#{qlrmc},
			#{zjzl},
			#{zjh},
			#{lxdh},
			#{qlrlx},
			#{txdz},
			#{bz},
			#{zt}
		)
	</insert>
	
	<update id="update">
		UPDATE bdc_qlrxx SET 	
			id0 = #{id0},
			zddm = #{zddm},
			bdcdyh = #{bdcdyh},
			qlrmc = #{qlrmc},
			zjzl = #{zjzl},
			zjh = #{zjh},
			lxdh = #{lxdh},
			qlrlx = #{qlrlx},
			txdz = #{txdz},
			bz = #{bz},
			zt = #{zt}
		WHERE id = #{id}
	</update>
	
	<update id="delete">
		DELETE FROM bdc_qlrxx
		WHERE id = #{id}
	</update>
	
</mapper>