<?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.base.DmlRecordsDao">
    
	<sql id="dmlRecordsColumns">
		a.id AS "id",
		a.dmllx AS "dmllx",
		a.tablename AS "tablename",
		a.tableid AS "tableid",
		a.tableoldid AS "tableoldid",
		a.syncbz AS "syncbz",
		a.createdate AS "createdate",
		a.createby AS "createby",
		a.createip AS "createip",
		a.syncdate AS "syncdate",
		a.syncby AS "syncby",
		a.syncip AS "syncip",
		a.syncmsg AS "syncmsg",
		a.fhbz AS "fhbz"
	</sql>
	
	<sql id="dmlRecordsJoins">
	</sql>
    
	<select id="get" resultType="DmlRecords">
		SELECT 
			<include refid="dmlRecordsColumns"/>
		FROM dml_records a
		<include refid="dmlRecordsJoins"/>
		WHERE a.id = #{id}
	</select>
	
	<select id="findList" resultType="DmlRecords">
		SELECT 
			<include refid="dmlRecordsColumns"/>
		FROM dml_records a
		<include refid="dmlRecordsJoins"/>
		<where>
			<if test="tablename != null and tablename != ''">
				AND a.tablename = #{tablename}
			</if>
			<if test="dmllx != null and dmllx != ''">
				AND a.dmllx = #{dmllx}
			</if>
			AND (a.syncbz = '0' or a.syncbz = '2')
			AND ROWNUM &lt;= #{rowNum}
		</where>
		<choose>
			<when test="page !=null and page.orderBy != null and page.orderBy != ''">
				ORDER BY ${page.orderBy}
			</when>
			<otherwise>
			</otherwise>
		</choose>
	</select>

	<select id="fhList" resultType="String">
		SELECT 
			wm_concat(a.id) ids
		FROM dml_records a
		<where>
			AND a.syncbz = '1' 
			AND nvl(a.fhbz,0) != 1
			AND ROWNUM &lt;= 2
		</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="DmlRecords">
		SELECT 
			<include refid="dmlRecordsColumns"/>
		FROM dml_records a
		<include refid="dmlRecordsJoins"/>
		<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 dml_records(
			id,
			dmllx,
			tablename,
			tableid,
			tableoldid,
			syncbz,
			createdate,
			createby,
			createip,
			syncdate,
			syncby,
			syncip,
			syncmsg,
			fhbz
		) VALUES (
			#{id},
			#{dmllx},
			#{tablename},
			#{tableid},
			#{tableoldid},
			#{syncbz},
			#{createdate},
			#{createby},
			#{createip},
			#{syncdate},
			#{syncby},
			#{syncip},
			#{syncmsg},
			#{fhbz}
		)
	</insert>
	
	<update id="update">
		UPDATE dml_records SET 	
			dmllx = #{dmllx},
			tablename = #{tablename},
			tableid = #{tableid},
			tableoldid = #{tableoldid},
			syncbz = #{syncbz},
			createdate = #{createdate},
			createby = #{createby},
			createip = #{createip},
			syncdate = #{syncdate},
			syncby = #{syncby},
			syncip = #{syncip},
			syncmsg = #{syncmsg},
			fhbz = #{fhbz}
		WHERE id = #{id}
	</update>

	<update id="update1">
		UPDATE dml_records SET 	
			dmllx = #{dmllx},
			tablename = #{tablename},
			tableid = #{tableid},
			tableoldid = #{tableoldid},
			syncbz = #{syncbz},
			createdate = #{createdate},
			createby = #{createby},
			createip = #{createip},
			syncdate = #{syncdate},
			syncby = #{syncby},
			syncip = #{syncip},
			syncmsg = #{syncmsg},
			fhbz = #{fhbz}
		WHERE id = #{id}
	</update>

	<update id="update2">
		UPDATE dml_records SET 	
			fhbz = '1'
		WHERE id in #{id}
	</update>

	<update id="update3">
		UPDATE dml_records SET 	
			syncbz = '2',
			syncdate = '',
			syncby = '',
			syncip = '',
			syncmsg = ''
		WHERE id in #{id}
	</update>
	
	<update id="delete">
		DELETE FROM dml_records
		WHERE id = #{id}
	</update>
	
</mapper>