<?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.TyHtxxDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyHtxxDO" >
    <id column="HTXXID" property="htxxid" jdbcType="VARCHAR" />
    <result column="HTBH" property="htbh" jdbcType="VARCHAR" />
    <result column="HTMC" property="htmc" jdbcType="VARCHAR" />
    <result column="JFQYDM" property="jfqydm" jdbcType="VARCHAR" />
    <result column="JFQYMC" property="jfqymc" jdbcType="VARCHAR" />
    <result column="JFKDBM" property="jfkdbm" jdbcType="VARCHAR" />
    <result column="JFKDMC" property="jfkdmc" jdbcType="VARCHAR" />
    <result column="JFKHH" property="jfkhh" jdbcType="VARCHAR" />
    <result column="JFYHZH" property="jfyhzh" jdbcType="VARCHAR" />
    <result column="JFQYR" property="jfqyr" jdbcType="VARCHAR" />
    <result column="JFLXDH" property="jflxdh" jdbcType="VARCHAR" />
    <result column="JFQZZT" property="jfqzzt" jdbcType="VARCHAR" />
    <result column="YFQYDM" property="yfqydm" jdbcType="VARCHAR" />
    <result column="YFQYMC" property="yfqymc" jdbcType="VARCHAR" />
    <result column="YFKDBM" property="yfkdbm" jdbcType="VARCHAR" />
    <result column="YFKDMC" property="yfkdmc" jdbcType="VARCHAR" />
    <result column="YFKHH" property="yfkhh" jdbcType="VARCHAR" />
    <result column="YFYHZH" property="yfyhzh" jdbcType="VARCHAR" />
    <result column="YFQYR" property="yfqyr" jdbcType="VARCHAR" />
    <result column="YFLXDH" property="yflxdh" jdbcType="VARCHAR" />
    <result column="YFQZZT" property="yfqzzt" jdbcType="VARCHAR" />
    <result column="HTQSSJ" property="htqssj" jdbcType="TIMESTAMP" />
    <result column="HTQSDD" property="htqsdd" jdbcType="VARCHAR" />
    <result column="HTZJE" property="htzje" jdbcType="DECIMAL" />
    <result column="HTZSL" property="htzsl" jdbcType="DECIMAL" />
    <result column="HTZDJ" property="htzdj" jdbcType="DECIMAL" />
    <result column="HTBZJE" property="htbzje" jdbcType="DECIMAL" />
    <result column="HTSXKSSJ" property="htsxkssj" jdbcType="TIMESTAMP" />
    <result column="HTSXJZSJ" property="htsxjzsj" jdbcType="TIMESTAMP" />
    <result column="JHKSSJ" property="jhkssj" jdbcType="TIMESTAMP" />
    <result column="JHJSSJ" property="jhjssj" jdbcType="TIMESTAMP" />
    <result column="LSPZBM" property="lspzbm" jdbcType="VARCHAR" />
    <result column="LSPZMC" property="lspzmc" jdbcType="VARCHAR" />
    <result column="YSFS" property="ysfs" jdbcType="VARCHAR" />
    <result column="ZFFS" property="zffs" jdbcType="VARCHAR" />
    <result column="ZYJJFS" property="zyjjfs" jdbcType="VARCHAR" />
    <result column="HTWYZR" property="htwyzr" jdbcType="VARCHAR" />
    <result column="HTJCTJ" property="htjctj" jdbcType="VARCHAR" />
    <result column="HTBZXX" property="htbzxx" jdbcType="VARCHAR" />
    <result column="LSPZID" property="lspzid" jdbcType="VARCHAR" />
    <result column="LSPZHM" property="lspzhm" jdbcType="VARCHAR" />
    <result column="SPZT" property="spzt" jdbcType="VARCHAR" />
    <result column="ZXZT" property="zxzt" 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="LSDJBM" property="lsdjbm" jdbcType="VARCHAR" />
    <result column="LSDJMC" property="lsdjmc" jdbcType="VARCHAR" />
  </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" >
    HTXXID, HTBH, HTMC, JFQYDM, JFQYMC, JFKDBM, JFKDMC, JFKHH, JFYHZH, JFQYR, JFLXDH, 
    JFQZZT, YFQYDM, YFQYMC, YFKDBM, YFKDMC, YFKHH, YFYHZH, YFQYR, YFLXDH, YFQZZT, HTQSSJ, 
    HTQSDD, HTZJE, HTZSL, HTZDJ, HTBZJE, HTSXKSSJ, HTSXJZSJ, JHKSSJ, JHJSSJ, LSPZBM, 
    LSPZMC, YSFS, ZFFS, ZYJJFS, HTWYZR, HTJCTJ, HTBZXX, LSPZID, LSPZHM, SPZT, ZXZT, STATUS, 
    CREATOR, CREATOR_CODE, CREATE_DATE, REFRESHER, REFRESHER_CODE, REFRESH_TIME, REMARK, LSDJBM, LSDJMC
  </sql>
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyHtxxExample">
    select
    <if test = "distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_HTXX
    <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_HTXX
    where HTXXID = #{htxxid,jdbcType=VARCHAR}
  </select> -->

  <select id="selectAlls" resultMap="BaseResultMap" >
    select * from TY_HTXX order by refresh_time desc
  </select>

  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_HTXX
    where HTXXID = #{htxxid,jdbcType=VARCHAR}
  </select>
  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_HTXX
    where HTXXID = #{htxxid,jdbcType=VARCHAR}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyHtxxExample" >
    delete from TY_HTXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyHtxxDO" >
    insert into TY_HTXX (HTXXID, HTBH, HTMC, 
      JFQYDM, JFQYMC, JFKDBM, 
      JFKDMC, JFKHH, JFYHZH, 
      JFQYR, JFLXDH, JFQZZT, 
      YFQYDM, YFQYMC, YFKDBM, 
      YFKDMC, YFKHH, YFYHZH, 
      YFQYR, YFLXDH, YFQZZT, 
      HTQSSJ, HTQSDD, HTZJE, 
      HTZSL, HTZDJ, HTBZJE, 
      HTSXKSSJ, HTSXJZSJ, JHKSSJ, 
      JHJSSJ, LSPZBM, LSPZMC, 
      YSFS, ZFFS, ZYJJFS, 
      HTWYZR, HTJCTJ, HTBZXX, 
      LSPZID, LSPZHM, SPZT, 
      ZXZT, STATUS, CREATOR, 
      CREATOR_CODE, CREATE_DATE, REFRESHER, 
      REFRESHER_CODE, REFRESH_TIME, REMARK, LSDJBM, LSDJMC
      )
    values (#{htxxid,jdbcType=VARCHAR}, #{htbh,jdbcType=VARCHAR}, #{htmc,jdbcType=VARCHAR}, 
      #{jfqydm,jdbcType=VARCHAR}, #{jfqymc,jdbcType=VARCHAR}, #{jfkdbm,jdbcType=VARCHAR}, 
      #{jfkdmc,jdbcType=VARCHAR}, #{jfkhh,jdbcType=VARCHAR}, #{jfyhzh,jdbcType=VARCHAR}, 
      #{jfqyr,jdbcType=VARCHAR}, #{jflxdh,jdbcType=VARCHAR}, #{jfqzzt,jdbcType=VARCHAR}, 
      #{yfqydm,jdbcType=VARCHAR}, #{yfqymc,jdbcType=VARCHAR}, #{yfkdbm,jdbcType=VARCHAR}, 
      #{yfkdmc,jdbcType=VARCHAR}, #{yfkhh,jdbcType=VARCHAR}, #{yfyhzh,jdbcType=VARCHAR}, 
      #{yfqyr,jdbcType=VARCHAR}, #{yflxdh,jdbcType=VARCHAR}, #{yfqzzt,jdbcType=VARCHAR}, 
      #{htqssj,jdbcType=TIMESTAMP}, #{htqsdd,jdbcType=VARCHAR}, #{htzje,jdbcType=DECIMAL}, 
      #{htzsl,jdbcType=DECIMAL}, #{htzdj,jdbcType=DECIMAL}, #{htbzje,jdbcType=DECIMAL}, 
      #{htsxkssj,jdbcType=TIMESTAMP}, #{htsxjzsj,jdbcType=TIMESTAMP}, #{jhkssj,jdbcType=TIMESTAMP}, 
      #{jhjssj,jdbcType=TIMESTAMP}, #{lspzbm,jdbcType=VARCHAR}, #{lspzmc,jdbcType=VARCHAR}, 
      #{ysfs,jdbcType=VARCHAR}, #{zffs,jdbcType=VARCHAR}, #{zyjjfs,jdbcType=VARCHAR}, 
      #{htwyzr,jdbcType=VARCHAR}, #{htjctj,jdbcType=VARCHAR}, #{htbzxx,jdbcType=VARCHAR}, 
      #{lspzid,jdbcType=VARCHAR}, #{lspzhm,jdbcType=VARCHAR}, #{spzt,jdbcType=VARCHAR}, 
      #{zxzt,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},
      #{lsdjbm,jdbcType=VARCHAR}, #{lsdjmc,jdbcType=VARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyHtxxDO" >
    insert into TY_HTXX
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="htxxid != null" >
        HTXXID,
      </if>
      <if test="htbh != null" >
        HTBH,
      </if>
      <if test="htmc != null" >
        HTMC,
      </if>
      <if test="jfqydm != null" >
        JFQYDM,
      </if>
      <if test="jfqymc != null" >
        JFQYMC,
      </if>
      <if test="jfkdbm != null" >
        JFKDBM,
      </if>
      <if test="jfkdmc != null" >
        JFKDMC,
      </if>
      <if test="jfkhh != null" >
        JFKHH,
      </if>
      <if test="jfyhzh != null" >
        JFYHZH,
      </if>
      <if test="jfqyr != null" >
        JFQYR,
      </if>
      <if test="jflxdh != null" >
        JFLXDH,
      </if>
      <if test="jfqzzt != null" >
        JFQZZT,
      </if>
      <if test="yfqydm != null" >
        YFQYDM,
      </if>
      <if test="yfqymc != null" >
        YFQYMC,
      </if>
      <if test="yfkdbm != null" >
        YFKDBM,
      </if>
      <if test="yfkdmc != null" >
        YFKDMC,
      </if>
      <if test="yfkhh != null" >
        YFKHH,
      </if>
      <if test="yfyhzh != null" >
        YFYHZH,
      </if>
      <if test="yfqyr != null" >
        YFQYR,
      </if>
      <if test="yflxdh != null" >
        YFLXDH,
      </if>
      <if test="yfqzzt != null" >
        YFQZZT,
      </if>
      <if test="htqssj != null" >
        HTQSSJ,
      </if>
      <if test="htqsdd != null" >
        HTQSDD,
      </if>
      <if test="htzje != null" >
        HTZJE,
      </if>
      <if test="htzsl != null" >
        HTZSL,
      </if>
      <if test="htzdj != null" >
        HTZDJ,
      </if>
      <if test="htbzje != null" >
        HTBZJE,
      </if>
      <if test="htsxkssj != null" >
        HTSXKSSJ,
      </if>
      <if test="htsxjzsj != null" >
        HTSXJZSJ,
      </if>
      <if test="jhkssj != null" >
        JHKSSJ,
      </if>
      <if test="jhjssj != null" >
        JHJSSJ,
      </if>
      <if test="lspzbm != null" >
        LSPZBM,
      </if>
      <if test="lspzmc != null" >
        LSPZMC,
      </if>
      <if test="ysfs != null" >
        YSFS,
      </if>
      <if test="zffs != null" >
        ZFFS,
      </if>
      <if test="zyjjfs != null" >
        ZYJJFS,
      </if>
      <if test="htwyzr != null" >
        HTWYZR,
      </if>
      <if test="htjctj != null" >
        HTJCTJ,
      </if>
      <if test="htbzxx != null" >
        HTBZXX,
      </if>
      <if test="lspzid != null" >
        LSPZID,
      </if>
      <if test="lspzhm != null" >
        LSPZHM,
      </if>
      <if test="spzt != null" >
        SPZT,
      </if>
      <if test="zxzt != null" >
        ZXZT,
      </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="lsdjbm != null" >
        LSDJBM,
      </if>
      <if test="lsdjmc != null" >
        LSDJMC,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="htxxid != null" >
        #{htxxid,jdbcType=VARCHAR},
      </if>
      <if test="htbh != null" >
        #{htbh,jdbcType=VARCHAR},
      </if>
      <if test="htmc != null" >
        #{htmc,jdbcType=VARCHAR},
      </if>
      <if test="jfqydm != null" >
        #{jfqydm,jdbcType=VARCHAR},
      </if>
      <if test="jfqymc != null" >
        #{jfqymc,jdbcType=VARCHAR},
      </if>
      <if test="jfkdbm != null" >
        #{jfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="jfkdmc != null" >
        #{jfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="jfkhh != null" >
        #{jfkhh,jdbcType=VARCHAR},
      </if>
      <if test="jfyhzh != null" >
        #{jfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="jfqyr != null" >
        #{jfqyr,jdbcType=VARCHAR},
      </if>
      <if test="jflxdh != null" >
        #{jflxdh,jdbcType=VARCHAR},
      </if>
      <if test="jfqzzt != null" >
        #{jfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="yfqydm != null" >
        #{yfqydm,jdbcType=VARCHAR},
      </if>
      <if test="yfqymc != null" >
        #{yfqymc,jdbcType=VARCHAR},
      </if>
      <if test="yfkdbm != null" >
        #{yfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="yfkdmc != null" >
        #{yfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="yfkhh != null" >
        #{yfkhh,jdbcType=VARCHAR},
      </if>
      <if test="yfyhzh != null" >
        #{yfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="yfqyr != null" >
        #{yfqyr,jdbcType=VARCHAR},
      </if>
      <if test="yflxdh != null" >
        #{yflxdh,jdbcType=VARCHAR},
      </if>
      <if test="yfqzzt != null" >
        #{yfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="htqssj != null" >
        #{htqssj,jdbcType=TIMESTAMP},
      </if>
      <if test="htqsdd != null" >
        #{htqsdd,jdbcType=VARCHAR},
      </if>
      <if test="htzje != null" >
        #{htzje,jdbcType=DECIMAL},
      </if>
      <if test="htzsl != null" >
        #{htzsl,jdbcType=DECIMAL},
      </if>
      <if test="htzdj != null" >
        #{htzdj,jdbcType=DECIMAL},
      </if>
      <if test="htbzje != null" >
        #{htbzje,jdbcType=DECIMAL},
      </if>
      <if test="htsxkssj != null" >
        #{htsxkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="htsxjzsj != null" >
        #{htsxjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhkssj != null" >
        #{jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhjssj != null" >
        #{jhjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="lspzbm != null" >
        #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="ysfs != null" >
        #{ysfs,jdbcType=VARCHAR},
      </if>
      <if test="zffs != null" >
        #{zffs,jdbcType=VARCHAR},
      </if>
      <if test="zyjjfs != null" >
        #{zyjjfs,jdbcType=VARCHAR},
      </if>
      <if test="htwyzr != null" >
        #{htwyzr,jdbcType=VARCHAR},
      </if>
      <if test="htjctj != null" >
        #{htjctj,jdbcType=VARCHAR},
      </if>
      <if test="htbzxx != null" >
        #{htbzxx,jdbcType=VARCHAR},
      </if>
      <if test="lspzid != null" >
        #{lspzid,jdbcType=VARCHAR},
      </if>
      <if test="lspzhm != null" >
        #{lspzhm,jdbcType=VARCHAR},
      </if>
      <if test="spzt != null" >
        #{spzt,jdbcType=VARCHAR},
      </if>
      <if test="zxzt != null" >
        #{zxzt,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="lsdjbm != null" >
        #{lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="lsdjmc != null" >
        #{lsdjmc,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyHtxxExample" resultType="java.lang.Integer" >
    select count(1) from TY_HTXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_HTXX
    <set >
      <if test="record.htxxid != null" >
        HTXXID = #{record.htxxid,jdbcType=VARCHAR},
      </if>
      <if test="record.htbh != null" >
        HTBH = #{record.htbh,jdbcType=VARCHAR},
      </if>
      <if test="record.htmc != null" >
        HTMC = #{record.htmc,jdbcType=VARCHAR},
      </if>
      <if test="record.jfqydm != null" >
        JFQYDM = #{record.jfqydm,jdbcType=VARCHAR},
      </if>
      <if test="record.jfqymc != null" >
        JFQYMC = #{record.jfqymc,jdbcType=VARCHAR},
      </if>
      <if test="record.jfkdbm != null" >
        JFKDBM = #{record.jfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="record.jfkdmc != null" >
        JFKDMC = #{record.jfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="record.jfkhh != null" >
        JFKHH = #{record.jfkhh,jdbcType=VARCHAR},
      </if>
      <if test="record.jfyhzh != null" >
        JFYHZH = #{record.jfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="record.jfqyr != null" >
        JFQYR = #{record.jfqyr,jdbcType=VARCHAR},
      </if>
      <if test="record.jflxdh != null" >
        JFLXDH = #{record.jflxdh,jdbcType=VARCHAR},
      </if>
      <if test="record.jfqzzt != null" >
        JFQZZT = #{record.jfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="record.yfqydm != null" >
        YFQYDM = #{record.yfqydm,jdbcType=VARCHAR},
      </if>
      <if test="record.yfqymc != null" >
        YFQYMC = #{record.yfqymc,jdbcType=VARCHAR},
      </if>
      <if test="record.yfkdbm != null" >
        YFKDBM = #{record.yfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="record.yfkdmc != null" >
        YFKDMC = #{record.yfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="record.yfkhh != null" >
        YFKHH = #{record.yfkhh,jdbcType=VARCHAR},
      </if>
      <if test="record.yfyhzh != null" >
        YFYHZH = #{record.yfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="record.yfqyr != null" >
        YFQYR = #{record.yfqyr,jdbcType=VARCHAR},
      </if>
      <if test="record.yflxdh != null" >
        YFLXDH = #{record.yflxdh,jdbcType=VARCHAR},
      </if>
      <if test="record.yfqzzt != null" >
        YFQZZT = #{record.yfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="record.htqssj != null" >
        HTQSSJ = #{record.htqssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.htqsdd != null" >
        HTQSDD = #{record.htqsdd,jdbcType=VARCHAR},
      </if>
      <if test="record.htzje != null" >
        HTZJE = #{record.htzje,jdbcType=DECIMAL},
      </if>
      <if test="record.htzsl != null" >
        HTZSL = #{record.htzsl,jdbcType=DECIMAL},
      </if>
      <if test="record.htzdj != null" >
        HTZDJ = #{record.htzdj,jdbcType=DECIMAL},
      </if>
      <if test="record.htbzje != null" >
        HTBZJE = #{record.htbzje,jdbcType=DECIMAL},
      </if>
      <if test="record.htsxkssj != null" >
        HTSXKSSJ = #{record.htsxkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.htsxjzsj != null" >
        HTSXJZSJ = #{record.htsxjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.jhkssj != null" >
        JHKSSJ = #{record.jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.jhjssj != null" >
        JHJSSJ = #{record.jhjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.lspzbm != null" >
        LSPZBM = #{record.lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lspzmc != null" >
        LSPZMC = #{record.lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="record.ysfs != null" >
        YSFS = #{record.ysfs,jdbcType=VARCHAR},
      </if>
      <if test="record.zffs != null" >
        ZFFS = #{record.zffs,jdbcType=VARCHAR},
      </if>
      <if test="record.zyjjfs != null" >
        ZYJJFS = #{record.zyjjfs,jdbcType=VARCHAR},
      </if>
      <if test="record.htwyzr != null" >
        HTWYZR = #{record.htwyzr,jdbcType=VARCHAR},
      </if>
      <if test="record.htjctj != null" >
        HTJCTJ = #{record.htjctj,jdbcType=VARCHAR},
      </if>
      <if test="record.htbzxx != null" >
        HTBZXX = #{record.htbzxx,jdbcType=VARCHAR},
      </if>
      <if test="record.lspzid != null" >
        LSPZID = #{record.lspzid,jdbcType=VARCHAR},
      </if>
      <if test="record.lspzhm != null" >
        LSPZHM = #{record.lspzhm,jdbcType=VARCHAR},
      </if>
      <if test="record.spzt != null" >
        SPZT = #{record.spzt,jdbcType=VARCHAR},
      </if>
      <if test="record.zxzt != null" >
        ZXZT = #{record.zxzt,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_HTXX
    set HTXXID = #{record.htxxid,jdbcType=VARCHAR},
      HTBH = #{record.htbh,jdbcType=VARCHAR},
      HTMC = #{record.htmc,jdbcType=VARCHAR},
      JFQYDM = #{record.jfqydm,jdbcType=VARCHAR},
      JFQYMC = #{record.jfqymc,jdbcType=VARCHAR},
      JFKDBM = #{record.jfkdbm,jdbcType=VARCHAR},
      JFKDMC = #{record.jfkdmc,jdbcType=VARCHAR},
      JFKHH = #{record.jfkhh,jdbcType=VARCHAR},
      JFYHZH = #{record.jfyhzh,jdbcType=VARCHAR},
      JFQYR = #{record.jfqyr,jdbcType=VARCHAR},
      JFLXDH = #{record.jflxdh,jdbcType=VARCHAR},
      JFQZZT = #{record.jfqzzt,jdbcType=VARCHAR},
      YFQYDM = #{record.yfqydm,jdbcType=VARCHAR},
      YFQYMC = #{record.yfqymc,jdbcType=VARCHAR},
      YFKDBM = #{record.yfkdbm,jdbcType=VARCHAR},
      YFKDMC = #{record.yfkdmc,jdbcType=VARCHAR},
      YFKHH = #{record.yfkhh,jdbcType=VARCHAR},
      YFYHZH = #{record.yfyhzh,jdbcType=VARCHAR},
      YFQYR = #{record.yfqyr,jdbcType=VARCHAR},
      YFLXDH = #{record.yflxdh,jdbcType=VARCHAR},
      YFQZZT = #{record.yfqzzt,jdbcType=VARCHAR},
      HTQSSJ = #{record.htqssj,jdbcType=TIMESTAMP},
      HTQSDD = #{record.htqsdd,jdbcType=VARCHAR},
      HTZJE = #{record.htzje,jdbcType=DECIMAL},
      HTZSL = #{record.htzsl,jdbcType=DECIMAL},
      HTZDJ = #{record.htzdj,jdbcType=DECIMAL},
      HTBZJE = #{record.htbzje,jdbcType=DECIMAL},
      HTSXKSSJ = #{record.htsxkssj,jdbcType=TIMESTAMP},
      HTSXJZSJ = #{record.htsxjzsj,jdbcType=TIMESTAMP},
      JHKSSJ = #{record.jhkssj,jdbcType=TIMESTAMP},
      JHJSSJ = #{record.jhjssj,jdbcType=TIMESTAMP},
      LSPZBM = #{record.lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{record.lspzmc,jdbcType=VARCHAR},
      YSFS = #{record.ysfs,jdbcType=VARCHAR},
      ZFFS = #{record.zffs,jdbcType=VARCHAR},
      ZYJJFS = #{record.zyjjfs,jdbcType=VARCHAR},
      HTWYZR = #{record.htwyzr,jdbcType=VARCHAR},
      HTJCTJ = #{record.htjctj,jdbcType=VARCHAR},
      HTBZXX = #{record.htbzxx,jdbcType=VARCHAR},
      LSPZID = #{record.lspzid,jdbcType=VARCHAR},
      LSPZHM = #{record.lspzhm,jdbcType=VARCHAR},
      SPZT = #{record.spzt,jdbcType=VARCHAR},
      ZXZT = #{record.zxzt,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.TyHtxxDO" >
    update TY_HTXX
    <set >
      <if test="htbh != null" >
        HTBH = #{htbh,jdbcType=VARCHAR},
      </if>
      <if test="htmc != null" >
        HTMC = #{htmc,jdbcType=VARCHAR},
      </if>
      <if test="jfqydm != null" >
        JFQYDM = #{jfqydm,jdbcType=VARCHAR},
      </if>
      <if test="jfqymc != null" >
        JFQYMC = #{jfqymc,jdbcType=VARCHAR},
      </if>
      <if test="jfkdbm != null" >
        JFKDBM = #{jfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="jfkdmc != null" >
        JFKDMC = #{jfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="jfkhh != null" >
        JFKHH = #{jfkhh,jdbcType=VARCHAR},
      </if>
      <if test="jfyhzh != null" >
        JFYHZH = #{jfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="jfqyr != null" >
        JFQYR = #{jfqyr,jdbcType=VARCHAR},
      </if>
      <if test="jflxdh != null" >
        JFLXDH = #{jflxdh,jdbcType=VARCHAR},
      </if>
      <if test="jfqzzt != null" >
        JFQZZT = #{jfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="yfqydm != null" >
        YFQYDM = #{yfqydm,jdbcType=VARCHAR},
      </if>
      <if test="yfqymc != null" >
        YFQYMC = #{yfqymc,jdbcType=VARCHAR},
      </if>
      <if test="yfkdbm != null" >
        YFKDBM = #{yfkdbm,jdbcType=VARCHAR},
      </if>
      <if test="yfkdmc != null" >
        YFKDMC = #{yfkdmc,jdbcType=VARCHAR},
      </if>
      <if test="yfkhh != null" >
        YFKHH = #{yfkhh,jdbcType=VARCHAR},
      </if>
      <if test="yfyhzh != null" >
        YFYHZH = #{yfyhzh,jdbcType=VARCHAR},
      </if>
      <if test="yfqyr != null" >
        YFQYR = #{yfqyr,jdbcType=VARCHAR},
      </if>
      <if test="yflxdh != null" >
        YFLXDH = #{yflxdh,jdbcType=VARCHAR},
      </if>
      <if test="yfqzzt != null" >
        YFQZZT = #{yfqzzt,jdbcType=VARCHAR},
      </if>
      <if test="htqssj != null" >
        HTQSSJ = #{htqssj,jdbcType=TIMESTAMP},
      </if>
      <if test="htqsdd != null" >
        HTQSDD = #{htqsdd,jdbcType=VARCHAR},
      </if>
      <if test="htzje != null" >
        HTZJE = #{htzje,jdbcType=DECIMAL},
      </if>
      <if test="htzsl != null" >
        HTZSL = #{htzsl,jdbcType=DECIMAL},
      </if>
      <if test="htzdj != null" >
        HTZDJ = #{htzdj,jdbcType=DECIMAL},
      </if>
      <if test="htbzje != null" >
        HTBZJE = #{htbzje,jdbcType=DECIMAL},
      </if>
      <if test="htsxkssj != null" >
        HTSXKSSJ = #{htsxkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="htsxjzsj != null" >
        HTSXJZSJ = #{htsxjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhkssj != null" >
        JHKSSJ = #{jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhjssj != null" >
        JHJSSJ = #{jhjssj,jdbcType=TIMESTAMP},
      </if>
      <if test="lspzbm != null" >
        LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="ysfs != null" >
        YSFS = #{ysfs,jdbcType=VARCHAR},
      </if>
      <if test="zffs != null" >
        ZFFS = #{zffs,jdbcType=VARCHAR},
      </if>
      <if test="zyjjfs != null" >
        ZYJJFS = #{zyjjfs,jdbcType=VARCHAR},
      </if>
      <if test="htwyzr != null" >
        HTWYZR = #{htwyzr,jdbcType=VARCHAR},
      </if>
      <if test="htjctj != null" >
        HTJCTJ = #{htjctj,jdbcType=VARCHAR},
      </if>
      <if test="htbzxx != null" >
        HTBZXX = #{htbzxx,jdbcType=VARCHAR},
      </if>
      <if test="lspzid != null" >
        LSPZID = #{lspzid,jdbcType=VARCHAR},
      </if>
      <if test="lspzhm != null" >
        LSPZHM = #{lspzhm,jdbcType=VARCHAR},
      </if>
      <if test="spzt != null" >
        SPZT = #{spzt,jdbcType=VARCHAR},
      </if>
      <if test="zxzt != null" >
        ZXZT = #{zxzt,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 HTXXID = #{htxxid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyHtxxDO" >
    update TY_HTXX
    set HTBH = #{htbh,jdbcType=VARCHAR},
      HTMC = #{htmc,jdbcType=VARCHAR},
      JFQYDM = #{jfqydm,jdbcType=VARCHAR},
      JFQYMC = #{jfqymc,jdbcType=VARCHAR},
      JFKDBM = #{jfkdbm,jdbcType=VARCHAR},
      JFKDMC = #{jfkdmc,jdbcType=VARCHAR},
      JFKHH = #{jfkhh,jdbcType=VARCHAR},
      JFYHZH = #{jfyhzh,jdbcType=VARCHAR},
      JFQYR = #{jfqyr,jdbcType=VARCHAR},
      JFLXDH = #{jflxdh,jdbcType=VARCHAR},
      JFQZZT = #{jfqzzt,jdbcType=VARCHAR},
      YFQYDM = #{yfqydm,jdbcType=VARCHAR},
      YFQYMC = #{yfqymc,jdbcType=VARCHAR},
      YFKDBM = #{yfkdbm,jdbcType=VARCHAR},
      YFKDMC = #{yfkdmc,jdbcType=VARCHAR},
      YFKHH = #{yfkhh,jdbcType=VARCHAR},
      YFYHZH = #{yfyhzh,jdbcType=VARCHAR},
      YFQYR = #{yfqyr,jdbcType=VARCHAR},
      YFLXDH = #{yflxdh,jdbcType=VARCHAR},
      YFQZZT = #{yfqzzt,jdbcType=VARCHAR},
      HTQSSJ = #{htqssj,jdbcType=TIMESTAMP},
      HTQSDD = #{htqsdd,jdbcType=VARCHAR},
      HTZJE = #{htzje,jdbcType=DECIMAL},
      HTZSL = #{htzsl,jdbcType=DECIMAL},
      HTZDJ = #{htzdj,jdbcType=DECIMAL},
      HTBZJE = #{htbzje,jdbcType=DECIMAL},
      HTSXKSSJ = #{htsxkssj,jdbcType=TIMESTAMP},
      HTSXJZSJ = #{htsxjzsj,jdbcType=TIMESTAMP},
      JHKSSJ = #{jhkssj,jdbcType=TIMESTAMP},
      JHJSSJ = #{jhjssj,jdbcType=TIMESTAMP},
      LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      YSFS = #{ysfs,jdbcType=VARCHAR},
      ZFFS = #{zffs,jdbcType=VARCHAR},
      ZYJJFS = #{zyjjfs,jdbcType=VARCHAR},
      HTWYZR = #{htwyzr,jdbcType=VARCHAR},
      HTJCTJ = #{htjctj,jdbcType=VARCHAR},
      HTBZXX = #{htbzxx,jdbcType=VARCHAR},
      LSPZID = #{lspzid,jdbcType=VARCHAR},
      LSPZHM = #{lspzhm,jdbcType=VARCHAR},
      SPZT = #{spzt,jdbcType=VARCHAR},
      ZXZT = #{zxzt,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},
      LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{lsdjmc,jdbcType=VARCHAR}
    where HTXXID = #{htxxid,jdbcType=VARCHAR}
  </update>
</mapper>