<?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.unis.base.server.dao.TyTfzyxxDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyTfzyxxDO" >
    <id column="TFZYID" property="tfzyid" jdbcType="VARCHAR" />
    <result column="FABH" property="fabh" jdbcType="VARCHAR" />
    <result column="FAMC" property="famc" jdbcType="VARCHAR" />
    <result column="PZBM" property="pzbm" jdbcType="VARCHAR" />
    <result column="PZMC" property="pzmc" jdbcType="VARCHAR" />
    <result column="LSDJBM" property="lsdjbm" jdbcType="VARCHAR" />
    <result column="LSDJMC" property="lsdjmc" jdbcType="VARCHAR" />
    <result column="LSXZBM" property="lsxzbm" jdbcType="VARCHAR" />
    <result column="LSXZMC" property="lsxzmc" jdbcType="VARCHAR" />
    <result column="CFBH" property="cfbh" jdbcType="VARCHAR" />
    <result column="CFMC" property="cfmc" jdbcType="VARCHAR" />
    <result column="SSKDDM" property="sskddm" jdbcType="VARCHAR" />
    <result column="SSKDMC" property="sskdmc" jdbcType="VARCHAR" />
    <result column="SSQYDM" property="ssqydm" jdbcType="VARCHAR" />
    <result column="SSYQMC" property="ssyqmc" jdbcType="VARCHAR" />
    <result column="BGYBM" property="bgybm" jdbcType="VARCHAR" />
    <result column="BGYMC" property="bgymc" jdbcType="VARCHAR" />
    <result column="TFFS" property="tffs" jdbcType="VARCHAR" />
    <result column="TFCJR" property="tfcjr" jdbcType="VARCHAR" />
    <result column="ZYZT" property="zyzt" jdbcType="VARCHAR" />
    <result column="ZYJSSJ" property="zyjssj" jdbcType="TIMESTAMP" />
    <result column="CFLX" property="cflx" jdbcType="VARCHAR" />
    <result column="CFCC" property="cfcc" jdbcType="VARCHAR" />
    <result column="CFSL" property="cfsl" jdbcType="VARCHAR" />
    <result column="CDDW" property="cddw" jdbcType="VARCHAR" />
    <result column="BGDW" property="bgdw" jdbcType="VARCHAR" />
    <result column="SJZLGD" property="sjzlgd" jdbcType="VARCHAR" />
    <result column="CFBGY" property="cfbgy" jdbcType="VARCHAR" />
    <result column="FJLXJXH" property="fjlxjxh" jdbcType="VARCHAR" />
    <result column="QLFX" property="qlfx" jdbcType="VARCHAR" />
    <result column="FWZZL" property="fwzzl" jdbcType="VARCHAR" />
    <result column="CFZFL" property="cfzfl" jdbcType="VARCHAR" />
    <result column="CFFJGL" property="cffjgl" jdbcType="VARCHAR" />
    <result column="DWTFL" property="dwtfl" jdbcType="VARCHAR" />
    <result column="DCORDSL" property="dcordsl" jdbcType="VARCHAR" />
    <result column="DCORDSLCC" property="dcordslcc" jdbcType="VARCHAR" />
    <result column="KQTJB" property="kqtjb" jdbcType="VARCHAR" />
    <result column="KBKKL" property="kbkkl" jdbcType="VARCHAR" />
    <result column="KSTFSJ" property="kstfsj" jdbcType="TIMESTAMP" />
    <result column="JSTFSJ" property="jstfsj" jdbcType="TIMESTAMP" />
    <result column="TFTJSJ" property="tftjsj" jdbcType="VARCHAR" />
    <result column="LJTFSJ" property="ljtfsj" jdbcType="VARCHAR" />
    <result column="TFSQWZGZ" property="tfsqwzgz" jdbcType="DECIMAL" />
    <result column="TFSQWZDZ" property="tfsqwzdz" jdbcType="DECIMAL" />
    <result column="TFSQWPJZ" property="tfsqwpjz" jdbcType="DECIMAL" />
    <result column="TFSQSZGZ" property="tfsqszgz" jdbcType="DECIMAL" />
    <result column="TFSQSZDZ" property="tfsqszdz" jdbcType="DECIMAL" />
    <result column="TFSQSPJZ" property="tfsqspjz" jdbcType="DECIMAL" />
    <result column="TFQZDGW" property="tfqzdgw" jdbcType="DECIMAL" />
    <result column="TFQZDLW" property="tfqzdlw" jdbcType="DECIMAL" />
    <result column="TFQPJLW" property="tfqpjlw" jdbcType="DECIMAL" />
    <result column="TFQLWZDTD" property="tfqlwzdtd" jdbcType="DECIMAL" />
    <result column="TFHLWZGZ" property="tfhlwzgz" jdbcType="DECIMAL" />
    <result column="TFHLSWDZDZ" property="tfhlswdzdz" jdbcType="DECIMAL" />
    <result column="TFHLSWDPJZ" property="tfhlswdpjz" jdbcType="DECIMAL" />
    <result column="TFHLWZDTD" property="tfhlwzdtd" jdbcType="DECIMAL" />
    <result column="TFQLSSFZGZ" property="tfqlssfzgz" jdbcType="DECIMAL" />
    <result column="TFQLSSFZDZ" property="tfqlssfzdz" jdbcType="DECIMAL" />
    <result column="TFQLSSFPJZ" property="tfqlssfpjz" jdbcType="DECIMAL" />
    <result column="TFQSFZDTD" property="tfqsfzdtd" jdbcType="DECIMAL" />
    <result column="TFHLSSFZGZ" property="tfhlssfzgz" jdbcType="DECIMAL" />
    <result column="TFHLSSFZDZ" property="tfhlssfzdz" jdbcType="DECIMAL" />
    <result column="TFHLSSFPJZ" property="tfhlssfpjz" jdbcType="DECIMAL" />
    <result column="TFHLSSFZDTD" property="tfhlssfzdtd" jdbcType="DECIMAL" />
    <result column="ZHD" property="zhd" jdbcType="DECIMAL" />
    <result column="DWNH" property="dwnh" jdbcType="DECIMAL" />
    <result column="CZR" property="czr" jdbcType="VARCHAR" />
    <result column="FZR" property="fzr" jdbcType="VARCHAR" />
    <result column="XGFX" property="xgfx" jdbcType="VARCHAR" />
    <result column="XZQB" property="xzqb" jdbcType="VARCHAR" />
    <result column="STATUS" property="status" jdbcType="DECIMAL" />
    <result column="CREATOR" property="creator" jdbcType="VARCHAR" />
    <result column="CREATOR_CODE" property="creatorCode" jdbcType="VARCHAR" />
    <result column="CREATE_DATE" property="createDate" jdbcType="TIMESTAMP" />
    <result column="REFRESHER" property="refresher" jdbcType="VARCHAR" />
    <result column="REFRESHER_CODE" property="refresherCode" jdbcType="VARCHAR" />
    <result column="REFRESH_TIME" property="refreshTime" jdbcType="TIMESTAMP" />
    <result column="REMARK" property="remark" jdbcType="VARCHAR" />
    <result column="SFBA" property="sfba" jdbcType="DECIMAL" />
  </resultMap>
  <sql id="Example_Where_Clause" >
    <where >
      <foreach collection="oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause" >
    <where >
      <foreach collection="example.oredCriteria" item="criteria" separator="or" >
        <if test="criteria.valid" >
          <trim prefix="(" suffix=")" prefixOverrides="and" >
            <foreach collection="criteria.criteria" item="criterion" >
              <choose >
                <when test="criterion.noValue" >
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue" >
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue" >
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue" >
                  and ${criterion.condition}
                  <foreach collection="criterion.value" item="listItem" open="(" close=")" separator="," >
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List" >
    TFZYID, FABH, FAMC, PZBM, PZMC, LSDJBM, LSDJMC, LSXZBM, LSXZMC, CFBH, CFMC, SSKDDM, 
    SSKDMC, SSQYDM, SSYQMC, BGYBM, BGYMC, TFFS, TFCJR, ZYZT, ZYJSSJ, CFLX, CFCC, CFSL, 
    CDDW, BGDW, SJZLGD, CFBGY, FJLXJXH, QLFX, FWZZL, CFZFL, CFFJGL, DWTFL, DCORDSL, DCORDSLCC, 
    KQTJB, KBKKL, KSTFSJ, JSTFSJ, TFTJSJ, LJTFSJ, TFSQWZGZ, TFSQWZDZ, TFSQWPJZ, TFSQSZGZ, 
    TFSQSZDZ, TFSQSPJZ, TFQZDGW, TFQZDLW, TFQPJLW, TFQLWZDTD, TFHLWZGZ, TFHLSWDZDZ, TFHLSWDPJZ, 
    TFHLWZDTD, TFQLSSFZGZ, TFQLSSFZDZ, TFQLSSFPJZ, TFQSFZDTD, TFHLSSFZGZ, TFHLSSFZDZ, 
    TFHLSSFPJZ, TFHLSSFZDTD, ZHD, DWNH, CZR, FZR, XGFX, XZQB, STATUS, CREATOR, CREATOR_CODE, 
    CREATE_DATE, REFRESHER, REFRESHER_CODE, REFRESH_TIME, REMARK,SFBA
  </sql>
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyTfzyxxExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_TFZYXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null" >
      order by ${orderByClause}
    </if>
  </select> -->
  <!-- <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_TFZYXX
    where TFZYID = #{tfzyid,jdbcType=VARCHAR}
  </select> -->
  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_TFZYXX
     <where>
		   STATUS=1  
		<if test="tfzyid != null and tfzyid != ''">
		   AND TFZYID = #{tfzyid,jdbcType=VARCHAR}
		</if>
		<if test="sskdmc != null and sskdmc != ''">
		   AND SSKDMC = #{sskdmc,jdbcType=VARCHAR}
		</if>
		<if test="tffs != null and tffs != ''">
		   AND TFFS = #{tffs,jdbcType=VARCHAR}
		</if>
		<if test="cfmc != null and cfmc != ''">
		   AND CFMC = #{cfmc,jdbcType=VARCHAR}
		</if>
		<if test="zyzt != null and zyzt != ''">
		   AND ZYZT = #{zyzt,jdbcType=VARCHAR}
		</if>
		
	</where>
		  ORDER BY CREATE_DATE DESC
  </select>
  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_TFZYXX
    where TFZYID = #{tfzyid,jdbcType=VARCHAR}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyTfzyxxExample" >
    delete from TY_TFZYXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyTfzyxxDO" >
    insert into TY_TFZYXX (TFZYID, FABH, FAMC, 
      PZBM, PZMC, LSDJBM, 
      LSDJMC, LSXZBM, LSXZMC, 
      CFBH, CFMC, SSKDDM, 
      SSKDMC, SSQYDM, SSYQMC, 
      BGYBM, BGYMC, TFFS, 
      TFCJR, ZYZT, ZYJSSJ, 
      CFLX, CFCC, CFSL, CDDW, 
      BGDW, SJZLGD, CFBGY, 
      FJLXJXH, QLFX, FWZZL, 
      CFZFL, CFFJGL, DWTFL, 
      DCORDSL, DCORDSLCC, KQTJB, 
      KBKKL, KSTFSJ, JSTFSJ, 
      TFTJSJ, LJTFSJ, TFSQWZGZ, 
      TFSQWZDZ, TFSQWPJZ, TFSQSZGZ, 
      TFSQSZDZ, TFSQSPJZ, TFQZDGW, 
      TFQZDLW, TFQPJLW, TFQLWZDTD, 
      TFHLWZGZ, TFHLSWDZDZ, TFHLSWDPJZ, 
      TFHLWZDTD, TFQLSSFZGZ, TFQLSSFZDZ, 
      TFQLSSFPJZ, TFQSFZDTD, TFHLSSFZGZ, 
      TFHLSSFZDZ, TFHLSSFPJZ, TFHLSSFZDTD, 
      ZHD, DWNH, CZR, FZR, 
      XGFX, XZQB, STATUS, 
      CREATOR, CREATOR_CODE, CREATE_DATE, 
      REFRESHER, REFRESHER_CODE, REFRESH_TIME, 
      REMARK,SFBA)
    values (#{tfzyid,jdbcType=VARCHAR}, #{fabh,jdbcType=VARCHAR}, #{famc,jdbcType=VARCHAR}, 
      #{pzbm,jdbcType=VARCHAR}, #{pzmc,jdbcType=VARCHAR}, #{lsdjbm,jdbcType=VARCHAR}, 
      #{lsdjmc,jdbcType=VARCHAR}, #{lsxzbm,jdbcType=VARCHAR}, #{lsxzmc,jdbcType=VARCHAR}, 
      #{cfbh,jdbcType=VARCHAR}, #{cfmc,jdbcType=VARCHAR}, #{sskddm,jdbcType=VARCHAR}, 
      #{sskdmc,jdbcType=VARCHAR}, #{ssqydm,jdbcType=VARCHAR}, #{ssyqmc,jdbcType=VARCHAR}, 
      #{bgybm,jdbcType=VARCHAR}, #{bgymc,jdbcType=VARCHAR}, #{tffs,jdbcType=VARCHAR}, 
      #{tfcjr,jdbcType=VARCHAR}, #{zyzt,jdbcType=VARCHAR}, #{zyjssj,jdbcType=TIMESTAMP}, 
      #{cflx,jdbcType=VARCHAR}, #{cfcc,jdbcType=VARCHAR}, #{cfsl,jdbcType=VARCHAR}, #{cddw,jdbcType=VARCHAR}, 
      #{bgdw,jdbcType=VARCHAR}, #{sjzlgd,jdbcType=VARCHAR}, #{cfbgy,jdbcType=VARCHAR}, 
      #{fjlxjxh,jdbcType=VARCHAR}, #{qlfx,jdbcType=VARCHAR}, #{fwzzl,jdbcType=VARCHAR}, 
      #{cfzfl,jdbcType=VARCHAR}, #{cffjgl,jdbcType=VARCHAR}, #{dwtfl,jdbcType=VARCHAR}, 
      #{dcordsl,jdbcType=VARCHAR}, #{dcordslcc,jdbcType=VARCHAR}, #{kqtjb,jdbcType=VARCHAR}, 
      #{kbkkl,jdbcType=VARCHAR}, #{kstfsj,jdbcType=TIMESTAMP}, #{jstfsj,jdbcType=TIMESTAMP}, 
      #{tftjsj,jdbcType=VARCHAR}, #{ljtfsj,jdbcType=VARCHAR}, #{tfsqwzgz,jdbcType=DECIMAL}, 
      #{tfsqwzdz,jdbcType=DECIMAL}, #{tfsqwpjz,jdbcType=DECIMAL}, #{tfsqszgz,jdbcType=DECIMAL}, 
      #{tfsqszdz,jdbcType=DECIMAL}, #{tfsqspjz,jdbcType=DECIMAL}, #{tfqzdgw,jdbcType=DECIMAL}, 
      #{tfqzdlw,jdbcType=DECIMAL}, #{tfqpjlw,jdbcType=DECIMAL}, #{tfqlwzdtd,jdbcType=DECIMAL}, 
      #{tfhlwzgz,jdbcType=DECIMAL}, #{tfhlswdzdz,jdbcType=DECIMAL}, #{tfhlswdpjz,jdbcType=DECIMAL}, 
      #{tfhlwzdtd,jdbcType=DECIMAL}, #{tfqlssfzgz,jdbcType=DECIMAL}, #{tfqlssfzdz,jdbcType=DECIMAL}, 
      #{tfqlssfpjz,jdbcType=DECIMAL}, #{tfqsfzdtd,jdbcType=DECIMAL}, #{tfhlssfzgz,jdbcType=DECIMAL}, 
      #{tfhlssfzdz,jdbcType=DECIMAL}, #{tfhlssfpjz,jdbcType=DECIMAL}, #{tfhlssfzdtd,jdbcType=DECIMAL}, 
      #{zhd,jdbcType=DECIMAL}, #{dwnh,jdbcType=DECIMAL}, #{czr,jdbcType=VARCHAR}, #{fzr,jdbcType=VARCHAR}, 
      #{xgfx,jdbcType=VARCHAR}, #{xzqb,jdbcType=VARCHAR}, #{status,jdbcType=DECIMAL}, 
      #{creator,jdbcType=VARCHAR}, #{creatorCode,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, 
      #{refresher,jdbcType=VARCHAR}, #{refresherCode,jdbcType=VARCHAR}, #{refreshTime,jdbcType=TIMESTAMP}, 
      #{remark,jdbcType=VARCHAR},#{sfba,jdbcType=DECIMAL})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyTfzyxxDO" >
    insert into TY_TFZYXX
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="tfzyid != null" >
        TFZYID,
      </if>
      <if test="fabh != null" >
        FABH,
      </if>
      <if test="famc != null" >
        FAMC,
      </if>
      <if test="pzbm != null" >
        PZBM,
      </if>
      <if test="pzmc != null" >
        PZMC,
      </if>
      <if test="lsdjbm != null" >
        LSDJBM,
      </if>
      <if test="lsdjmc != null" >
        LSDJMC,
      </if>
      <if test="lsxzbm != null" >
        LSXZBM,
      </if>
      <if test="lsxzmc != null" >
        LSXZMC,
      </if>
      <if test="cfbh != null" >
        CFBH,
      </if>
      <if test="cfmc != null" >
        CFMC,
      </if>
      <if test="sskddm != null" >
        SSKDDM,
      </if>
      <if test="sskdmc != null" >
        SSKDMC,
      </if>
      <if test="ssqydm != null" >
        SSQYDM,
      </if>
      <if test="ssyqmc != null" >
        SSYQMC,
      </if>
      <if test="bgybm != null" >
        BGYBM,
      </if>
      <if test="bgymc != null" >
        BGYMC,
      </if>
      <if test="tffs != null" >
        TFFS,
      </if>
      <if test="tfcjr != null" >
        TFCJR,
      </if>
      <if test="zyzt != null" >
        ZYZT,
      </if>
      <if test="zyjssj != null" >
        ZYJSSJ,
      </if>
      <if test="cflx != null" >
        CFLX,
      </if>
      <if test="cfcc != null" >
        CFCC,
      </if>
      <if test="cfsl != null" >
        CFSL,
      </if>
      <if test="cddw != null" >
        CDDW,
      </if>
      <if test="bgdw != null" >
        BGDW,
      </if>
      <if test="sjzlgd != null" >
        SJZLGD,
      </if>
      <if test="cfbgy != null" >
        CFBGY,
      </if>
      <if test="fjlxjxh != null" >
        FJLXJXH,
      </if>
      <if test="qlfx != null" >
        QLFX,
      </if>
      <if test="fwzzl != null" >
        FWZZL,
      </if>
      <if test="cfzfl != null" >
        CFZFL,
      </if>
      <if test="cffjgl != null" >
        CFFJGL,
      </if>
      <if test="dwtfl != null" >
        DWTFL,
      </if>
      <if test="dcordsl != null" >
        DCORDSL,
      </if>
      <if test="dcordslcc != null" >
        DCORDSLCC,
      </if>
      <if test="kqtjb != null" >
        KQTJB,
      </if>
      <if test="kbkkl != null" >
        KBKKL,
      </if>
      <if test="kstfsj != null" >
        KSTFSJ,
      </if>
      <if test="jstfsj != null" >
        JSTFSJ,
      </if>
      <if test="tftjsj != null" >
        TFTJSJ,
      </if>
      <if test="ljtfsj != null" >
        LJTFSJ,
      </if>
      <if test="tfsqwzgz != null" >
        TFSQWZGZ,
      </if>
      <if test="tfsqwzdz != null" >
        TFSQWZDZ,
      </if>
      <if test="tfsqwpjz != null" >
        TFSQWPJZ,
      </if>
      <if test="tfsqszgz != null" >
        TFSQSZGZ,
      </if>
      <if test="tfsqszdz != null" >
        TFSQSZDZ,
      </if>
      <if test="tfsqspjz != null" >
        TFSQSPJZ,
      </if>
      <if test="tfqzdgw != null" >
        TFQZDGW,
      </if>
      <if test="tfqzdlw != null" >
        TFQZDLW,
      </if>
      <if test="tfqpjlw != null" >
        TFQPJLW,
      </if>
      <if test="tfqlwzdtd != null" >
        TFQLWZDTD,
      </if>
      <if test="tfhlwzgz != null" >
        TFHLWZGZ,
      </if>
      <if test="tfhlswdzdz != null" >
        TFHLSWDZDZ,
      </if>
      <if test="tfhlswdpjz != null" >
        TFHLSWDPJZ,
      </if>
      <if test="tfhlwzdtd != null" >
        TFHLWZDTD,
      </if>
      <if test="tfqlssfzgz != null" >
        TFQLSSFZGZ,
      </if>
      <if test="tfqlssfzdz != null" >
        TFQLSSFZDZ,
      </if>
      <if test="tfqlssfpjz != null" >
        TFQLSSFPJZ,
      </if>
      <if test="tfqsfzdtd != null" >
        TFQSFZDTD,
      </if>
      <if test="tfhlssfzgz != null" >
        TFHLSSFZGZ,
      </if>
      <if test="tfhlssfzdz != null" >
        TFHLSSFZDZ,
      </if>
      <if test="tfhlssfpjz != null" >
        TFHLSSFPJZ,
      </if>
      <if test="tfhlssfzdtd != null" >
        TFHLSSFZDTD,
      </if>
      <if test="zhd != null" >
        ZHD,
      </if>
      <if test="dwnh != null" >
        DWNH,
      </if>
      <if test="czr != null" >
        CZR,
      </if>
      <if test="fzr != null" >
        FZR,
      </if>
      <if test="xgfx != null" >
        XGFX,
      </if>
      <if test="xzqb != null" >
        XZQB,
      </if>
      <if test="status != null" >
        STATUS,
      </if>
      <if test="creator != null" >
        CREATOR,
      </if>
      <if test="creatorCode != null" >
        CREATOR_CODE,
      </if>
      <if test="createDate != null" >
        CREATE_DATE,
      </if>
      <if test="refresher != null" >
        REFRESHER,
      </if>
      <if test="refresherCode != null" >
        REFRESHER_CODE,
      </if>
      <if test="refreshTime != null" >
        REFRESH_TIME,
      </if>
      <if test="remark != null" >
        REMARK,
      </if>
       <if test="sfba != null" >
        SFBA,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="tfzyid != null" >
        #{tfzyid,jdbcType=VARCHAR},
      </if>
      <if test="fabh != null" >
        #{fabh,jdbcType=VARCHAR},
      </if>
      <if test="famc != null" >
        #{famc,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="pzmc != null" >
        #{pzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsdjbm != null" >
        #{lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="lsdjmc != null" >
        #{lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="lsxzbm != null" >
        #{lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzmc != null" >
        #{lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="cfbh != null" >
        #{cfbh,jdbcType=VARCHAR},
      </if>
      <if test="cfmc != null" >
        #{cfmc,jdbcType=VARCHAR},
      </if>
      <if test="sskddm != null" >
        #{sskddm,jdbcType=VARCHAR},
      </if>
      <if test="sskdmc != null" >
        #{sskdmc,jdbcType=VARCHAR},
      </if>
      <if test="ssqydm != null" >
        #{ssqydm,jdbcType=VARCHAR},
      </if>
      <if test="ssyqmc != null" >
        #{ssyqmc,jdbcType=VARCHAR},
      </if>
      <if test="bgybm != null" >
        #{bgybm,jdbcType=VARCHAR},
      </if>
      <if test="bgymc != null" >
        #{bgymc,jdbcType=VARCHAR},
      </if>
      <if test="tffs != null" >
        #{tffs,jdbcType=VARCHAR},
      </if>
      <if test="tfcjr != null" >
        #{tfcjr,jdbcType=VARCHAR},
      </if>
      <if test="zyzt != null" >
        #{zyzt,jdbcType=VARCHAR},
      </if>
      <if test="zyjssj != null" >
        #{zyjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="cflx != null" >
        #{cflx,jdbcType=VARCHAR},
      </if>
      <if test="cfcc != null" >
        #{cfcc,jdbcType=VARCHAR},
      </if>
      <if test="cfsl != null" >
        #{cfsl,jdbcType=VARCHAR},
      </if>
      <if test="cddw != null" >
        #{cddw,jdbcType=VARCHAR},
      </if>
      <if test="bgdw != null" >
        #{bgdw,jdbcType=VARCHAR},
      </if>
      <if test="sjzlgd != null" >
        #{sjzlgd,jdbcType=VARCHAR},
      </if>
      <if test="cfbgy != null" >
        #{cfbgy,jdbcType=VARCHAR},
      </if>
      <if test="fjlxjxh != null" >
        #{fjlxjxh,jdbcType=VARCHAR},
      </if>
      <if test="qlfx != null" >
        #{qlfx,jdbcType=VARCHAR},
      </if>
      <if test="fwzzl != null" >
        #{fwzzl,jdbcType=VARCHAR},
      </if>
      <if test="cfzfl != null" >
        #{cfzfl,jdbcType=VARCHAR},
      </if>
      <if test="cffjgl != null" >
        #{cffjgl,jdbcType=VARCHAR},
      </if>
      <if test="dwtfl != null" >
        #{dwtfl,jdbcType=VARCHAR},
      </if>
      <if test="dcordsl != null" >
        #{dcordsl,jdbcType=VARCHAR},
      </if>
      <if test="dcordslcc != null" >
        #{dcordslcc,jdbcType=VARCHAR},
      </if>
      <if test="kqtjb != null" >
        #{kqtjb,jdbcType=VARCHAR},
      </if>
      <if test="kbkkl != null" >
        #{kbkkl,jdbcType=VARCHAR},
      </if>
      <if test="kstfsj != null" >
        #{kstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="jstfsj != null" >
        #{jstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="tftjsj != null" >
        #{tftjsj,jdbcType=VARCHAR},
      </if>
      <if test="ljtfsj != null" >
        #{ljtfsj,jdbcType=VARCHAR},
      </if>
      <if test="tfsqwzgz != null" >
        #{tfsqwzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqwzdz != null" >
        #{tfsqwzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqwpjz != null" >
        #{tfsqwpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqszgz != null" >
        #{tfsqszgz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqszdz != null" >
        #{tfsqszdz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqspjz != null" >
        #{tfsqspjz,jdbcType=DECIMAL},
      </if>
      <if test="tfqzdgw != null" >
        #{tfqzdgw,jdbcType=DECIMAL},
      </if>
      <if test="tfqzdlw != null" >
        #{tfqzdlw,jdbcType=DECIMAL},
      </if>
      <if test="tfqpjlw != null" >
        #{tfqpjlw,jdbcType=DECIMAL},
      </if>
      <if test="tfqlwzdtd != null" >
        #{tfqlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfhlwzgz != null" >
        #{tfhlwzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlswdzdz != null" >
        #{tfhlswdzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlswdpjz != null" >
        #{tfhlswdpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlwzdtd != null" >
        #{tfhlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfzgz != null" >
        #{tfqlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfzdz != null" >
        #{tfqlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfpjz != null" >
        #{tfqlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfqsfzdtd != null" >
        #{tfqsfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzgz != null" >
        #{tfhlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzdz != null" >
        #{tfhlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfpjz != null" >
        #{tfhlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzdtd != null" >
        #{tfhlssfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="zhd != null" >
        #{zhd,jdbcType=DECIMAL},
      </if>
      <if test="dwnh != null" >
        #{dwnh,jdbcType=DECIMAL},
      </if>
      <if test="czr != null" >
        #{czr,jdbcType=VARCHAR},
      </if>
      <if test="fzr != null" >
        #{fzr,jdbcType=VARCHAR},
      </if>
      <if test="xgfx != null" >
        #{xgfx,jdbcType=VARCHAR},
      </if>
      <if test="xzqb != null" >
        #{xzqb,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        #{status,jdbcType=DECIMAL},
      </if>
      <if test="creator != null" >
        #{creator,jdbcType=VARCHAR},
      </if>
      <if test="creatorCode != null" >
        #{creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="refresher != null" >
        #{refresher,jdbcType=VARCHAR},
      </if>
      <if test="refresherCode != null" >
        #{refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="refreshTime != null" >
        #{refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="remark != null" >
        #{remark,jdbcType=VARCHAR},
      </if>
      <if test="sfba != null" >
        #{sfba,jdbcType=DECIMAL},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyTfzyxxExample" resultType="java.lang.Integer" >
    select count(*) from TY_TFZYXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_TFZYXX
    <set >
      <if test="record.tfzyid != null" >
        TFZYID = #{record.tfzyid,jdbcType=VARCHAR},
      </if>
      <if test="record.fabh != null" >
        FABH = #{record.fabh,jdbcType=VARCHAR},
      </if>
      <if test="record.famc != null" >
        FAMC = #{record.famc,jdbcType=VARCHAR},
      </if>
      <if test="record.pzbm != null" >
        PZBM = #{record.pzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.pzmc != null" >
        PZMC = #{record.pzmc,jdbcType=VARCHAR},
      </if>
      <if test="record.lsdjbm != null" >
        LSDJBM = #{record.lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lsdjmc != null" >
        LSDJMC = #{record.lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="record.lsxzbm != null" >
        LSXZBM = #{record.lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lsxzmc != null" >
        LSXZMC = #{record.lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="record.cfbh != null" >
        CFBH = #{record.cfbh,jdbcType=VARCHAR},
      </if>
      <if test="record.cfmc != null" >
        CFMC = #{record.cfmc,jdbcType=VARCHAR},
      </if>
      <if test="record.sskddm != null" >
        SSKDDM = #{record.sskddm,jdbcType=VARCHAR},
      </if>
      <if test="record.sskdmc != null" >
        SSKDMC = #{record.sskdmc,jdbcType=VARCHAR},
      </if>
      <if test="record.ssqydm != null" >
        SSQYDM = #{record.ssqydm,jdbcType=VARCHAR},
      </if>
      <if test="record.ssyqmc != null" >
        SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      </if>
      <if test="record.bgybm != null" >
        BGYBM = #{record.bgybm,jdbcType=VARCHAR},
      </if>
      <if test="record.bgymc != null" >
        BGYMC = #{record.bgymc,jdbcType=VARCHAR},
      </if>
      <if test="record.tffs != null" >
        TFFS = #{record.tffs,jdbcType=VARCHAR},
      </if>
      <if test="record.tfcjr != null" >
        TFCJR = #{record.tfcjr,jdbcType=VARCHAR},
      </if>
      <if test="record.zyzt != null" >
        ZYZT = #{record.zyzt,jdbcType=VARCHAR},
      </if>
      <if test="record.zyjssj != null" >
        ZYJSSJ = #{record.zyjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.cflx != null" >
        CFLX = #{record.cflx,jdbcType=VARCHAR},
      </if>
      <if test="record.cfcc != null" >
        CFCC = #{record.cfcc,jdbcType=VARCHAR},
      </if>
      <if test="record.cfsl != null" >
        CFSL = #{record.cfsl,jdbcType=VARCHAR},
      </if>
      <if test="record.cddw != null" >
        CDDW = #{record.cddw,jdbcType=VARCHAR},
      </if>
      <if test="record.bgdw != null" >
        BGDW = #{record.bgdw,jdbcType=VARCHAR},
      </if>
      <if test="record.sjzlgd != null" >
        SJZLGD = #{record.sjzlgd,jdbcType=VARCHAR},
      </if>
      <if test="record.cfbgy != null" >
        CFBGY = #{record.cfbgy,jdbcType=VARCHAR},
      </if>
      <if test="record.fjlxjxh != null" >
        FJLXJXH = #{record.fjlxjxh,jdbcType=VARCHAR},
      </if>
      <if test="record.qlfx != null" >
        QLFX = #{record.qlfx,jdbcType=VARCHAR},
      </if>
      <if test="record.fwzzl != null" >
        FWZZL = #{record.fwzzl,jdbcType=VARCHAR},
      </if>
      <if test="record.cfzfl != null" >
        CFZFL = #{record.cfzfl,jdbcType=VARCHAR},
      </if>
      <if test="record.cffjgl != null" >
        CFFJGL = #{record.cffjgl,jdbcType=VARCHAR},
      </if>
      <if test="record.dwtfl != null" >
        DWTFL = #{record.dwtfl,jdbcType=VARCHAR},
      </if>
      <if test="record.dcordsl != null" >
        DCORDSL = #{record.dcordsl,jdbcType=VARCHAR},
      </if>
      <if test="record.dcordslcc != null" >
        DCORDSLCC = #{record.dcordslcc,jdbcType=VARCHAR},
      </if>
      <if test="record.kqtjb != null" >
        KQTJB = #{record.kqtjb,jdbcType=VARCHAR},
      </if>
      <if test="record.kbkkl != null" >
        KBKKL = #{record.kbkkl,jdbcType=VARCHAR},
      </if>
      <if test="record.kstfsj != null" >
        KSTFSJ = #{record.kstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.jstfsj != null" >
        JSTFSJ = #{record.jstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.tftjsj != null" >
        TFTJSJ = #{record.tftjsj,jdbcType=VARCHAR},
      </if>
      <if test="record.ljtfsj != null" >
        LJTFSJ = #{record.ljtfsj,jdbcType=VARCHAR},
      </if>
      <if test="record.tfsqwzgz != null" >
        TFSQWZGZ = #{record.tfsqwzgz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfsqwzdz != null" >
        TFSQWZDZ = #{record.tfsqwzdz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfsqwpjz != null" >
        TFSQWPJZ = #{record.tfsqwpjz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfsqszgz != null" >
        TFSQSZGZ = #{record.tfsqszgz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfsqszdz != null" >
        TFSQSZDZ = #{record.tfsqszdz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfsqspjz != null" >
        TFSQSPJZ = #{record.tfsqspjz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqzdgw != null" >
        TFQZDGW = #{record.tfqzdgw,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqzdlw != null" >
        TFQZDLW = #{record.tfqzdlw,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqpjlw != null" >
        TFQPJLW = #{record.tfqpjlw,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqlwzdtd != null" >
        TFQLWZDTD = #{record.tfqlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlwzgz != null" >
        TFHLWZGZ = #{record.tfhlwzgz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlswdzdz != null" >
        TFHLSWDZDZ = #{record.tfhlswdzdz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlswdpjz != null" >
        TFHLSWDPJZ = #{record.tfhlswdpjz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlwzdtd != null" >
        TFHLWZDTD = #{record.tfhlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqlssfzgz != null" >
        TFQLSSFZGZ = #{record.tfqlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqlssfzdz != null" >
        TFQLSSFZDZ = #{record.tfqlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqlssfpjz != null" >
        TFQLSSFPJZ = #{record.tfqlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfqsfzdtd != null" >
        TFQSFZDTD = #{record.tfqsfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlssfzgz != null" >
        TFHLSSFZGZ = #{record.tfhlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlssfzdz != null" >
        TFHLSSFZDZ = #{record.tfhlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlssfpjz != null" >
        TFHLSSFPJZ = #{record.tfhlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="record.tfhlssfzdtd != null" >
        TFHLSSFZDTD = #{record.tfhlssfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="record.zhd != null" >
        ZHD = #{record.zhd,jdbcType=DECIMAL},
      </if>
      <if test="record.dwnh != null" >
        DWNH = #{record.dwnh,jdbcType=DECIMAL},
      </if>
      <if test="record.czr != null" >
        CZR = #{record.czr,jdbcType=VARCHAR},
      </if>
      <if test="record.fzr != null" >
        FZR = #{record.fzr,jdbcType=VARCHAR},
      </if>
      <if test="record.xgfx != null" >
        XGFX = #{record.xgfx,jdbcType=VARCHAR},
      </if>
      <if test="record.xzqb != null" >
        XZQB = #{record.xzqb,jdbcType=VARCHAR},
      </if>
      <if test="record.status != null" >
        STATUS = #{record.status,jdbcType=DECIMAL},
      </if>
      <if test="record.creator != null" >
        CREATOR = #{record.creator,jdbcType=VARCHAR},
      </if>
      <if test="record.creatorCode != null" >
        CREATOR_CODE = #{record.creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="record.createDate != null" >
        CREATE_DATE = #{record.createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.refresher != null" >
        REFRESHER = #{record.refresher,jdbcType=VARCHAR},
      </if>
      <if test="record.refresherCode != null" >
        REFRESHER_CODE = #{record.refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="record.refreshTime != null" >
        REFRESH_TIME = #{record.refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.remark != null" >
        REMARK = #{record.remark,jdbcType=VARCHAR},
      </if>
    </set>
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update> -->
  <!-- <update id="updateByExample" parameterType="map" >
    update TY_TFZYXX
    set TFZYID = #{record.tfzyid,jdbcType=VARCHAR},
      FABH = #{record.fabh,jdbcType=VARCHAR},
      FAMC = #{record.famc,jdbcType=VARCHAR},
      PZBM = #{record.pzbm,jdbcType=VARCHAR},
      PZMC = #{record.pzmc,jdbcType=VARCHAR},
      LSDJBM = #{record.lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{record.lsdjmc,jdbcType=VARCHAR},
      LSXZBM = #{record.lsxzbm,jdbcType=VARCHAR},
      LSXZMC = #{record.lsxzmc,jdbcType=VARCHAR},
      CFBH = #{record.cfbh,jdbcType=VARCHAR},
      CFMC = #{record.cfmc,jdbcType=VARCHAR},
      SSKDDM = #{record.sskddm,jdbcType=VARCHAR},
      SSKDMC = #{record.sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{record.ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      BGYBM = #{record.bgybm,jdbcType=VARCHAR},
      BGYMC = #{record.bgymc,jdbcType=VARCHAR},
      TFFS = #{record.tffs,jdbcType=VARCHAR},
      TFCJR = #{record.tfcjr,jdbcType=VARCHAR},
      ZYZT = #{record.zyzt,jdbcType=VARCHAR},
      ZYJSSJ = #{record.zyjssj,jdbcType=TIMESTAMP},
      CFLX = #{record.cflx,jdbcType=VARCHAR},
      CFCC = #{record.cfcc,jdbcType=VARCHAR},
      CFSL = #{record.cfsl,jdbcType=VARCHAR},
      CDDW = #{record.cddw,jdbcType=VARCHAR},
      BGDW = #{record.bgdw,jdbcType=VARCHAR},
      SJZLGD = #{record.sjzlgd,jdbcType=VARCHAR},
      CFBGY = #{record.cfbgy,jdbcType=VARCHAR},
      FJLXJXH = #{record.fjlxjxh,jdbcType=VARCHAR},
      QLFX = #{record.qlfx,jdbcType=VARCHAR},
      FWZZL = #{record.fwzzl,jdbcType=VARCHAR},
      CFZFL = #{record.cfzfl,jdbcType=VARCHAR},
      CFFJGL = #{record.cffjgl,jdbcType=VARCHAR},
      DWTFL = #{record.dwtfl,jdbcType=VARCHAR},
      DCORDSL = #{record.dcordsl,jdbcType=VARCHAR},
      DCORDSLCC = #{record.dcordslcc,jdbcType=VARCHAR},
      KQTJB = #{record.kqtjb,jdbcType=VARCHAR},
      KBKKL = #{record.kbkkl,jdbcType=VARCHAR},
      KSTFSJ = #{record.kstfsj,jdbcType=TIMESTAMP},
      JSTFSJ = #{record.jstfsj,jdbcType=TIMESTAMP},
      TFTJSJ = #{record.tftjsj,jdbcType=VARCHAR},
      LJTFSJ = #{record.ljtfsj,jdbcType=VARCHAR},
      TFSQWZGZ = #{record.tfsqwzgz,jdbcType=DECIMAL},
      TFSQWZDZ = #{record.tfsqwzdz,jdbcType=DECIMAL},
      TFSQWPJZ = #{record.tfsqwpjz,jdbcType=DECIMAL},
      TFSQSZGZ = #{record.tfsqszgz,jdbcType=DECIMAL},
      TFSQSZDZ = #{record.tfsqszdz,jdbcType=DECIMAL},
      TFSQSPJZ = #{record.tfsqspjz,jdbcType=DECIMAL},
      TFQZDGW = #{record.tfqzdgw,jdbcType=DECIMAL},
      TFQZDLW = #{record.tfqzdlw,jdbcType=DECIMAL},
      TFQPJLW = #{record.tfqpjlw,jdbcType=DECIMAL},
      TFQLWZDTD = #{record.tfqlwzdtd,jdbcType=DECIMAL},
      TFHLWZGZ = #{record.tfhlwzgz,jdbcType=DECIMAL},
      TFHLSWDZDZ = #{record.tfhlswdzdz,jdbcType=DECIMAL},
      TFHLSWDPJZ = #{record.tfhlswdpjz,jdbcType=DECIMAL},
      TFHLWZDTD = #{record.tfhlwzdtd,jdbcType=DECIMAL},
      TFQLSSFZGZ = #{record.tfqlssfzgz,jdbcType=DECIMAL},
      TFQLSSFZDZ = #{record.tfqlssfzdz,jdbcType=DECIMAL},
      TFQLSSFPJZ = #{record.tfqlssfpjz,jdbcType=DECIMAL},
      TFQSFZDTD = #{record.tfqsfzdtd,jdbcType=DECIMAL},
      TFHLSSFZGZ = #{record.tfhlssfzgz,jdbcType=DECIMAL},
      TFHLSSFZDZ = #{record.tfhlssfzdz,jdbcType=DECIMAL},
      TFHLSSFPJZ = #{record.tfhlssfpjz,jdbcType=DECIMAL},
      TFHLSSFZDTD = #{record.tfhlssfzdtd,jdbcType=DECIMAL},
      ZHD = #{record.zhd,jdbcType=DECIMAL},
      DWNH = #{record.dwnh,jdbcType=DECIMAL},
      CZR = #{record.czr,jdbcType=VARCHAR},
      FZR = #{record.fzr,jdbcType=VARCHAR},
      XGFX = #{record.xgfx,jdbcType=VARCHAR},
      XZQB = #{record.xzqb,jdbcType=VARCHAR},
      STATUS = #{record.status,jdbcType=DECIMAL},
      CREATOR = #{record.creator,jdbcType=VARCHAR},
      CREATOR_CODE = #{record.creatorCode,jdbcType=VARCHAR},
      CREATE_DATE = #{record.createDate,jdbcType=TIMESTAMP},
      REFRESHER = #{record.refresher,jdbcType=VARCHAR},
      REFRESHER_CODE = #{record.refresherCode,jdbcType=VARCHAR},
      REFRESH_TIME = #{record.refreshTime,jdbcType=TIMESTAMP},
      REMARK = #{record.remark,jdbcType=VARCHAR}
    <if test="_parameter != null" >
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update> -->
  <!-- <update id="updateByPrimaryKeySelective" parameterType="com.unis.base.server.entity.TyTfzyxxDO" >
    update TY_TFZYXX
    <set >
      <if test="fabh != null" >
        FABH = #{fabh,jdbcType=VARCHAR},
      </if>
      <if test="famc != null" >
        FAMC = #{famc,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        PZBM = #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="pzmc != null" >
        PZMC = #{pzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsdjbm != null" >
        LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="lsdjmc != null" >
        LSDJMC = #{lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="lsxzbm != null" >
        LSXZBM = #{lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzmc != null" >
        LSXZMC = #{lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="cfbh != null" >
        CFBH = #{cfbh,jdbcType=VARCHAR},
      </if>
      <if test="cfmc != null" >
        CFMC = #{cfmc,jdbcType=VARCHAR},
      </if>
      <if test="sskddm != null" >
        SSKDDM = #{sskddm,jdbcType=VARCHAR},
      </if>
      <if test="sskdmc != null" >
        SSKDMC = #{sskdmc,jdbcType=VARCHAR},
      </if>
      <if test="ssqydm != null" >
        SSQYDM = #{ssqydm,jdbcType=VARCHAR},
      </if>
      <if test="ssyqmc != null" >
        SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      </if>
      <if test="bgybm != null" >
        BGYBM = #{bgybm,jdbcType=VARCHAR},
      </if>
      <if test="bgymc != null" >
        BGYMC = #{bgymc,jdbcType=VARCHAR},
      </if>
      <if test="tffs != null" >
        TFFS = #{tffs,jdbcType=VARCHAR},
      </if>
      <if test="tfcjr != null" >
        TFCJR = #{tfcjr,jdbcType=VARCHAR},
      </if>
      <if test="zyzt != null" >
        ZYZT = #{zyzt,jdbcType=VARCHAR},
      </if>
      <if test="zyjssj != null" >
        ZYJSSJ = #{zyjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="cflx != null" >
        CFLX = #{cflx,jdbcType=VARCHAR},
      </if>
      <if test="cfcc != null" >
        CFCC = #{cfcc,jdbcType=VARCHAR},
      </if>
      <if test="cfsl != null" >
        CFSL = #{cfsl,jdbcType=VARCHAR},
      </if>
      <if test="cddw != null" >
        CDDW = #{cddw,jdbcType=VARCHAR},
      </if>
      <if test="bgdw != null" >
        BGDW = #{bgdw,jdbcType=VARCHAR},
      </if>
      <if test="sjzlgd != null" >
        SJZLGD = #{sjzlgd,jdbcType=VARCHAR},
      </if>
      <if test="cfbgy != null" >
        CFBGY = #{cfbgy,jdbcType=VARCHAR},
      </if>
      <if test="fjlxjxh != null" >
        FJLXJXH = #{fjlxjxh,jdbcType=VARCHAR},
      </if>
      <if test="qlfx != null" >
        QLFX = #{qlfx,jdbcType=VARCHAR},
      </if>
      <if test="fwzzl != null" >
        FWZZL = #{fwzzl,jdbcType=VARCHAR},
      </if>
      <if test="cfzfl != null" >
        CFZFL = #{cfzfl,jdbcType=VARCHAR},
      </if>
      <if test="cffjgl != null" >
        CFFJGL = #{cffjgl,jdbcType=VARCHAR},
      </if>
      <if test="dwtfl != null" >
        DWTFL = #{dwtfl,jdbcType=VARCHAR},
      </if>
      <if test="dcordsl != null" >
        DCORDSL = #{dcordsl,jdbcType=VARCHAR},
      </if>
      <if test="dcordslcc != null" >
        DCORDSLCC = #{dcordslcc,jdbcType=VARCHAR},
      </if>
      <if test="kqtjb != null" >
        KQTJB = #{kqtjb,jdbcType=VARCHAR},
      </if>
      <if test="kbkkl != null" >
        KBKKL = #{kbkkl,jdbcType=VARCHAR},
      </if>
      <if test="kstfsj != null" >
        KSTFSJ = #{kstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="jstfsj != null" >
        JSTFSJ = #{jstfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="tftjsj != null" >
        TFTJSJ = #{tftjsj,jdbcType=VARCHAR},
      </if>
      <if test="ljtfsj != null" >
        LJTFSJ = #{ljtfsj,jdbcType=VARCHAR},
      </if>
      <if test="tfsqwzgz != null" >
        TFSQWZGZ = #{tfsqwzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqwzdz != null" >
        TFSQWZDZ = #{tfsqwzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqwpjz != null" >
        TFSQWPJZ = #{tfsqwpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqszgz != null" >
        TFSQSZGZ = #{tfsqszgz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqszdz != null" >
        TFSQSZDZ = #{tfsqszdz,jdbcType=DECIMAL},
      </if>
      <if test="tfsqspjz != null" >
        TFSQSPJZ = #{tfsqspjz,jdbcType=DECIMAL},
      </if>
      <if test="tfqzdgw != null" >
        TFQZDGW = #{tfqzdgw,jdbcType=DECIMAL},
      </if>
      <if test="tfqzdlw != null" >
        TFQZDLW = #{tfqzdlw,jdbcType=DECIMAL},
      </if>
      <if test="tfqpjlw != null" >
        TFQPJLW = #{tfqpjlw,jdbcType=DECIMAL},
      </if>
      <if test="tfqlwzdtd != null" >
        TFQLWZDTD = #{tfqlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfhlwzgz != null" >
        TFHLWZGZ = #{tfhlwzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlswdzdz != null" >
        TFHLSWDZDZ = #{tfhlswdzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlswdpjz != null" >
        TFHLSWDPJZ = #{tfhlswdpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlwzdtd != null" >
        TFHLWZDTD = #{tfhlwzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfzgz != null" >
        TFQLSSFZGZ = #{tfqlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfzdz != null" >
        TFQLSSFZDZ = #{tfqlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfqlssfpjz != null" >
        TFQLSSFPJZ = #{tfqlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfqsfzdtd != null" >
        TFQSFZDTD = #{tfqsfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzgz != null" >
        TFHLSSFZGZ = #{tfhlssfzgz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzdz != null" >
        TFHLSSFZDZ = #{tfhlssfzdz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfpjz != null" >
        TFHLSSFPJZ = #{tfhlssfpjz,jdbcType=DECIMAL},
      </if>
      <if test="tfhlssfzdtd != null" >
        TFHLSSFZDTD = #{tfhlssfzdtd,jdbcType=DECIMAL},
      </if>
      <if test="zhd != null" >
        ZHD = #{zhd,jdbcType=DECIMAL},
      </if>
      <if test="dwnh != null" >
        DWNH = #{dwnh,jdbcType=DECIMAL},
      </if>
      <if test="czr != null" >
        CZR = #{czr,jdbcType=VARCHAR},
      </if>
      <if test="fzr != null" >
        FZR = #{fzr,jdbcType=VARCHAR},
      </if>
      <if test="xgfx != null" >
        XGFX = #{xgfx,jdbcType=VARCHAR},
      </if>
      <if test="xzqb != null" >
        XZQB = #{xzqb,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        STATUS = #{status,jdbcType=DECIMAL},
      </if>
      <if test="creator != null" >
        CREATOR = #{creator,jdbcType=VARCHAR},
      </if>
      <if test="creatorCode != null" >
        CREATOR_CODE = #{creatorCode,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="refresher != null" >
        REFRESHER = #{refresher,jdbcType=VARCHAR},
      </if>
      <if test="refresherCode != null" >
        REFRESHER_CODE = #{refresherCode,jdbcType=VARCHAR},
      </if>
      <if test="refreshTime != null" >
        REFRESH_TIME = #{refreshTime,jdbcType=TIMESTAMP},
      </if>
      <if test="remark != null" >
        REMARK = #{remark,jdbcType=VARCHAR},
      </if>
    </set>
    where TFZYID = #{tfzyid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyTfzyxxDO" >
    update TY_TFZYXX
    set FABH = #{fabh,jdbcType=VARCHAR},
      FAMC = #{famc,jdbcType=VARCHAR},
      PZBM = #{pzbm,jdbcType=VARCHAR},
      PZMC = #{pzmc,jdbcType=VARCHAR},
      LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{lsdjmc,jdbcType=VARCHAR},
      LSXZBM = #{lsxzbm,jdbcType=VARCHAR},
      LSXZMC = #{lsxzmc,jdbcType=VARCHAR},
      CFBH = #{cfbh,jdbcType=VARCHAR},
      CFMC = #{cfmc,jdbcType=VARCHAR},
      SSKDDM = #{sskddm,jdbcType=VARCHAR},
      SSKDMC = #{sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      BGYBM = #{bgybm,jdbcType=VARCHAR},
      BGYMC = #{bgymc,jdbcType=VARCHAR},
      TFFS = #{tffs,jdbcType=VARCHAR},
      TFCJR = #{tfcjr,jdbcType=VARCHAR},
      ZYZT = #{zyzt,jdbcType=VARCHAR},
      ZYJSSJ = #{zyjssj,jdbcType=TIMESTAMP},
      CFLX = #{cflx,jdbcType=VARCHAR},
      CFCC = #{cfcc,jdbcType=VARCHAR},
      CFSL = #{cfsl,jdbcType=VARCHAR},
      CDDW = #{cddw,jdbcType=VARCHAR},
      BGDW = #{bgdw,jdbcType=VARCHAR},
      SJZLGD = #{sjzlgd,jdbcType=VARCHAR},
      CFBGY = #{cfbgy,jdbcType=VARCHAR},
      FJLXJXH = #{fjlxjxh,jdbcType=VARCHAR},
      QLFX = #{qlfx,jdbcType=VARCHAR},
      FWZZL = #{fwzzl,jdbcType=VARCHAR},
      CFZFL = #{cfzfl,jdbcType=VARCHAR},
      CFFJGL = #{cffjgl,jdbcType=VARCHAR},
      DWTFL = #{dwtfl,jdbcType=VARCHAR},
      DCORDSL = #{dcordsl,jdbcType=VARCHAR},
      DCORDSLCC = #{dcordslcc,jdbcType=VARCHAR},
      KQTJB = #{kqtjb,jdbcType=VARCHAR},
      KBKKL = #{kbkkl,jdbcType=VARCHAR},
      KSTFSJ = #{kstfsj,jdbcType=TIMESTAMP},
      JSTFSJ = #{jstfsj,jdbcType=TIMESTAMP},
      TFTJSJ = #{tftjsj,jdbcType=VARCHAR},
      LJTFSJ = #{ljtfsj,jdbcType=VARCHAR},
      TFSQWZGZ = #{tfsqwzgz,jdbcType=DECIMAL},
      TFSQWZDZ = #{tfsqwzdz,jdbcType=DECIMAL},
      TFSQWPJZ = #{tfsqwpjz,jdbcType=DECIMAL},
      TFSQSZGZ = #{tfsqszgz,jdbcType=DECIMAL},
      TFSQSZDZ = #{tfsqszdz,jdbcType=DECIMAL},
      TFSQSPJZ = #{tfsqspjz,jdbcType=DECIMAL},
      TFQZDGW = #{tfqzdgw,jdbcType=DECIMAL},
      TFQZDLW = #{tfqzdlw,jdbcType=DECIMAL},
      TFQPJLW = #{tfqpjlw,jdbcType=DECIMAL},
      TFQLWZDTD = #{tfqlwzdtd,jdbcType=DECIMAL},
      TFHLWZGZ = #{tfhlwzgz,jdbcType=DECIMAL},
      TFHLSWDZDZ = #{tfhlswdzdz,jdbcType=DECIMAL},
      TFHLSWDPJZ = #{tfhlswdpjz,jdbcType=DECIMAL},
      TFHLWZDTD = #{tfhlwzdtd,jdbcType=DECIMAL},
      TFQLSSFZGZ = #{tfqlssfzgz,jdbcType=DECIMAL},
      TFQLSSFZDZ = #{tfqlssfzdz,jdbcType=DECIMAL},
      TFQLSSFPJZ = #{tfqlssfpjz,jdbcType=DECIMAL},
      TFQSFZDTD = #{tfqsfzdtd,jdbcType=DECIMAL},
      TFHLSSFZGZ = #{tfhlssfzgz,jdbcType=DECIMAL},
      TFHLSSFZDZ = #{tfhlssfzdz,jdbcType=DECIMAL},
      TFHLSSFPJZ = #{tfhlssfpjz,jdbcType=DECIMAL},
      TFHLSSFZDTD = #{tfhlssfzdtd,jdbcType=DECIMAL},
      ZHD = #{zhd,jdbcType=DECIMAL},
      DWNH = #{dwnh,jdbcType=DECIMAL},
      CZR = #{czr,jdbcType=VARCHAR},
      FZR = #{fzr,jdbcType=VARCHAR},
      XGFX = #{xgfx,jdbcType=VARCHAR},
      XZQB = #{xzqb,jdbcType=VARCHAR},
      STATUS = #{status,jdbcType=DECIMAL},
      CREATOR = #{creator,jdbcType=VARCHAR},
      CREATOR_CODE = #{creatorCode,jdbcType=VARCHAR},
      CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      REFRESHER = #{refresher,jdbcType=VARCHAR},
      REFRESHER_CODE = #{refresherCode,jdbcType=VARCHAR},
      REFRESH_TIME = #{refreshTime,jdbcType=TIMESTAMP},
      REMARK = #{remark,jdbcType=VARCHAR},
      SFBA = #{sfba,jdbcType=DECIMAL}
    where TFZYID = #{tfzyid,jdbcType=VARCHAR}
  </update>
    	<!--	更改备案状态-->
	<update id="ventilationOperationStatus" parameterType="java.util.Map">
		UPDATE TY_TFZYXX
		SET SFBA = #{sfba}
		where TFZYID = #{tfzyid}
	</update>
</mapper>