<?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.TyJhxxzbDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyJhxxzbDO" >
    <id column="JHXXID" property="jhxxid" jdbcType="VARCHAR" />
    <result column="JHH" property="jhh" jdbcType="VARCHAR" />
    <result column="JHBT" property="jhbt" jdbcType="VARCHAR" />
    <result column="JHMS" property="jhms" 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="JHLX" property="jhlx" jdbcType="VARCHAR" />
    <result column="LSYQSL" property="lsyqsl" jdbcType="DECIMAL" />
    <result column="LSNQ" property="lsnq" jdbcType="VARCHAR" />
    <result column="LSWCSL" property="lswcsl" jdbcType="DECIMAL" />
    <result column="LSJG" property="lsjg" jdbcType="DECIMAL" />
    <result column="JHKSSJ" property="jhkssj" jdbcType="TIMESTAMP" />
    <result column="JHJZSJ" property="jhjzsj" jdbcType="TIMESTAMP" />
    <result column="BZSJ" property="bzsj" jdbcType="TIMESTAMP" />
    <result column="BZRBM" property="bzrbm" jdbcType="VARCHAR" />
    <result column="BZRMC" property="bzrmc" jdbcType="VARCHAR" />
    <result column="SHSJ" property="shsj" jdbcType="TIMESTAMP" />
    <result column="SHRBM" property="shrbm" jdbcType="VARCHAR" />
    <result column="SHRMC" property="shrmc" jdbcType="VARCHAR" />
    <result column="QFSJ" property="qfsj" jdbcType="TIMESTAMP" />
    <result column="QFRBM" property="qfrbm" jdbcType="VARCHAR" />
    <result column="QFRMC" property="qfrmc" jdbcType="VARCHAR" />
    <result column="JHZXZT" property="jhzxzt" 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="LHND" property="lhnd" 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" >
    JHXXID, JHH, JHBT, JHMS, SSKDDM, SSKDMC, SSQYDM, SSYQMC, JHLX, LSYQSL, LSNQ, LSWCSL, 
    LSJG, JHKSSJ, JHJZSJ, BZSJ, BZRBM, BZRMC, SHSJ, SHRBM, SHRMC, QFSJ, QFRBM, QFRMC, 
    JHZXZT, STATUS, CREATOR, CREATOR_CODE, CREATE_DATE, REFRESHER, REFRESHER_CODE, REFRESH_TIME, 
    REMARK, lhnd
  </sql>
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyJhxxzbExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_JHXXZB
    <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_JHXXZB
    where JHXXID = #{jhxxid,jdbcType=VARCHAR}
  </select> -->

  <select id="selectAlls" resultMap="BaseResultMap">
    select * from TY_JHXXZB where status = 1
  </select>

  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_JHXXZB
    where JHXXID = #{jhxxid,jdbcType=VARCHAR}
  </select>
  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_JHXXZB
    where JHXXID = #{jhxxid,jdbcType=VARCHAR}
  </delete> -->
 <!--  <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyJhxxzbExample" >
    delete from TY_JHXXZB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyJhxxzbDO" >
    insert into TY_JHXXZB (JHXXID, JHH, JHBT, 
      JHMS, SSKDDM, SSKDMC, 
      SSQYDM, SSYQMC, JHLX, 
      LSYQSL, LSNQ, LSWCSL, 
      LSJG, JHKSSJ, JHJZSJ, 
      BZSJ, BZRBM, BZRMC, 
      SHSJ, SHRBM, SHRMC, 
      QFSJ, QFRBM, QFRMC, 
      JHZXZT, STATUS, CREATOR, 
      CREATOR_CODE, CREATE_DATE, REFRESHER, 
      REFRESHER_CODE, REFRESH_TIME, REMARK, lhnd
      )
    values (#{jhxxid,jdbcType=VARCHAR}, #{jhh,jdbcType=VARCHAR}, #{jhbt,jdbcType=VARCHAR}, 
      #{jhms,jdbcType=VARCHAR}, #{sskddm,jdbcType=VARCHAR}, #{sskdmc,jdbcType=VARCHAR}, 
      #{ssqydm,jdbcType=VARCHAR}, #{ssyqmc,jdbcType=VARCHAR}, #{jhlx,jdbcType=VARCHAR}, 
      #{lsyqsl,jdbcType=DECIMAL}, #{lsnq,jdbcType=VARCHAR}, #{lswcsl,jdbcType=DECIMAL}, 
      #{lsjg,jdbcType=DECIMAL}, #{jhkssj,jdbcType=TIMESTAMP}, #{jhjzsj,jdbcType=TIMESTAMP}, 
      #{bzsj,jdbcType=TIMESTAMP}, #{bzrbm,jdbcType=VARCHAR}, #{bzrmc,jdbcType=VARCHAR}, 
      #{shsj,jdbcType=TIMESTAMP}, #{shrbm,jdbcType=VARCHAR}, #{shrmc,jdbcType=VARCHAR}, 
      #{qfsj,jdbcType=TIMESTAMP}, #{qfrbm,jdbcType=VARCHAR}, #{qfrmc,jdbcType=VARCHAR}, 
      #{jhzxzt,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}, #{lhnd,jdbcType=VARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyJhxxzbDO" >
    insert into TY_JHXXZB
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="jhxxid != null" >
        JHXXID,
      </if>
      <if test="jhh != null" >
        JHH,
      </if>
      <if test="jhbt != null" >
        JHBT,
      </if>
      <if test="jhms != null" >
        JHMS,
      </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="jhlx != null" >
        JHLX,
      </if>
      <if test="lsyqsl != null" >
        LSYQSL,
      </if>
      <if test="lsnq != null" >
        LSNQ,
      </if>
      <if test="lswcsl != null" >
        LSWCSL,
      </if>
      <if test="lsjg != null" >
        LSJG,
      </if>
      <if test="jhkssj != null" >
        JHKSSJ,
      </if>
      <if test="jhjzsj != null" >
        JHJZSJ,
      </if>
      <if test="bzsj != null" >
        BZSJ,
      </if>
      <if test="bzrbm != null" >
        BZRBM,
      </if>
      <if test="bzrmc != null" >
        BZRMC,
      </if>
      <if test="shsj != null" >
        SHSJ,
      </if>
      <if test="shrbm != null" >
        SHRBM,
      </if>
      <if test="shrmc != null" >
        SHRMC,
      </if>
      <if test="qfsj != null" >
        QFSJ,
      </if>
      <if test="qfrbm != null" >
        QFRBM,
      </if>
      <if test="qfrmc != null" >
        QFRMC,
      </if>
      <if test="jhzxzt != null" >
        JHZXZT,
      </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="lhnd != null" >
        LHND,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="jhxxid != null" >
        #{jhxxid,jdbcType=VARCHAR},
      </if>
      <if test="jhh != null" >
        #{jhh,jdbcType=VARCHAR},
      </if>
      <if test="jhbt != null" >
        #{jhbt,jdbcType=VARCHAR},
      </if>
      <if test="jhms != null" >
        #{jhms,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="jhlx != null" >
        #{jhlx,jdbcType=VARCHAR},
      </if>
      <if test="lsyqsl != null" >
        #{lsyqsl,jdbcType=DECIMAL},
      </if>
      <if test="lsnq != null" >
        #{lsnq,jdbcType=VARCHAR},
      </if>
      <if test="lswcsl != null" >
        #{lswcsl,jdbcType=DECIMAL},
      </if>
      <if test="lsjg != null" >
        #{lsjg,jdbcType=DECIMAL},
      </if>
      <if test="jhkssj != null" >
        #{jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhjzsj != null" >
        #{jhjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bzsj != null" >
        #{bzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bzrbm != null" >
        #{bzrbm,jdbcType=VARCHAR},
      </if>
      <if test="bzrmc != null" >
        #{bzrmc,jdbcType=VARCHAR},
      </if>
      <if test="shsj != null" >
        #{shsj,jdbcType=TIMESTAMP},
      </if>
      <if test="shrbm != null" >
        #{shrbm,jdbcType=VARCHAR},
      </if>
      <if test="shrmc != null" >
        #{shrmc,jdbcType=VARCHAR},
      </if>
      <if test="qfsj != null" >
        #{qfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="qfrbm != null" >
        #{qfrbm,jdbcType=VARCHAR},
      </if>
      <if test="qfrmc != null" >
        #{qfrmc,jdbcType=VARCHAR},
      </if>
      <if test="jhzxzt != null" >
        #{jhzxzt,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="lhnd != null" >
        #{lhnd,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyJhxxzbExample" resultType="java.lang.Integer" >
    select count(1) from TY_JHXXZB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_JHXXZB
    <set >
      <if test="record.jhxxid != null" >
        JHXXID = #{record.jhxxid,jdbcType=VARCHAR},
      </if>
      <if test="record.jhh != null" >
        JHH = #{record.jhh,jdbcType=VARCHAR},
      </if>
      <if test="record.jhbt != null" >
        JHBT = #{record.jhbt,jdbcType=VARCHAR},
      </if>
      <if test="record.jhms != null" >
        JHMS = #{record.jhms,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.jhlx != null" >
        JHLX = #{record.jhlx,jdbcType=VARCHAR},
      </if>
      <if test="record.lsyqsl != null" >
        LSYQSL = #{record.lsyqsl,jdbcType=DECIMAL},
      </if>
      <if test="record.lsnq != null" >
        LSNQ = #{record.lsnq,jdbcType=VARCHAR},
      </if>
      <if test="record.lswcsl != null" >
        LSWCSL = #{record.lswcsl,jdbcType=DECIMAL},
      </if>
      <if test="record.lsjg != null" >
        LSJG = #{record.lsjg,jdbcType=DECIMAL},
      </if>
      <if test="record.jhkssj != null" >
        JHKSSJ = #{record.jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.jhjzsj != null" >
        JHJZSJ = #{record.jhjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.bzsj != null" >
        BZSJ = #{record.bzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.bzrbm != null" >
        BZRBM = #{record.bzrbm,jdbcType=VARCHAR},
      </if>
      <if test="record.bzrmc != null" >
        BZRMC = #{record.bzrmc,jdbcType=VARCHAR},
      </if>
      <if test="record.shsj != null" >
        SHSJ = #{record.shsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.shrbm != null" >
        SHRBM = #{record.shrbm,jdbcType=VARCHAR},
      </if>
      <if test="record.shrmc != null" >
        SHRMC = #{record.shrmc,jdbcType=VARCHAR},
      </if>
      <if test="record.qfsj != null" >
        QFSJ = #{record.qfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.qfrbm != null" >
        QFRBM = #{record.qfrbm,jdbcType=VARCHAR},
      </if>
      <if test="record.qfrmc != null" >
        QFRMC = #{record.qfrmc,jdbcType=VARCHAR},
      </if>
      <if test="record.jhzxzt != null" >
        JHZXZT = #{record.jhzxzt,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_JHXXZB
    set JHXXID = #{record.jhxxid,jdbcType=VARCHAR},
      JHH = #{record.jhh,jdbcType=VARCHAR},
      JHBT = #{record.jhbt,jdbcType=VARCHAR},
      JHMS = #{record.jhms,jdbcType=VARCHAR},
      SSKDDM = #{record.sskddm,jdbcType=VARCHAR},
      SSKDMC = #{record.sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{record.ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      JHLX = #{record.jhlx,jdbcType=VARCHAR},
      LSYQSL = #{record.lsyqsl,jdbcType=DECIMAL},
      LSNQ = #{record.lsnq,jdbcType=VARCHAR},
      LSWCSL = #{record.lswcsl,jdbcType=DECIMAL},
      LSJG = #{record.lsjg,jdbcType=DECIMAL},
      JHKSSJ = #{record.jhkssj,jdbcType=TIMESTAMP},
      JHJZSJ = #{record.jhjzsj,jdbcType=TIMESTAMP},
      BZSJ = #{record.bzsj,jdbcType=TIMESTAMP},
      BZRBM = #{record.bzrbm,jdbcType=VARCHAR},
      BZRMC = #{record.bzrmc,jdbcType=VARCHAR},
      SHSJ = #{record.shsj,jdbcType=TIMESTAMP},
      SHRBM = #{record.shrbm,jdbcType=VARCHAR},
      SHRMC = #{record.shrmc,jdbcType=VARCHAR},
      QFSJ = #{record.qfsj,jdbcType=TIMESTAMP},
      QFRBM = #{record.qfrbm,jdbcType=VARCHAR},
      QFRMC = #{record.qfrmc,jdbcType=VARCHAR},
      JHZXZT = #{record.jhzxzt,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.TyJhxxzbDO" >
    update TY_JHXXZB
    <set >
      <if test="jhh != null" >
        JHH = #{jhh,jdbcType=VARCHAR},
      </if>
      <if test="jhbt != null" >
        JHBT = #{jhbt,jdbcType=VARCHAR},
      </if>
      <if test="jhms != null" >
        JHMS = #{jhms,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="jhlx != null" >
        JHLX = #{jhlx,jdbcType=VARCHAR},
      </if>
      <if test="lsyqsl != null" >
        LSYQSL = #{lsyqsl,jdbcType=DECIMAL},
      </if>
      <if test="lsnq != null" >
        LSNQ = #{lsnq,jdbcType=VARCHAR},
      </if>
      <if test="lswcsl != null" >
        LSWCSL = #{lswcsl,jdbcType=DECIMAL},
      </if>
      <if test="lsjg != null" >
        LSJG = #{lsjg,jdbcType=DECIMAL},
      </if>
      <if test="jhkssj != null" >
        JHKSSJ = #{jhkssj,jdbcType=TIMESTAMP},
      </if>
      <if test="jhjzsj != null" >
        JHJZSJ = #{jhjzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bzsj != null" >
        BZSJ = #{bzsj,jdbcType=TIMESTAMP},
      </if>
      <if test="bzrbm != null" >
        BZRBM = #{bzrbm,jdbcType=VARCHAR},
      </if>
      <if test="bzrmc != null" >
        BZRMC = #{bzrmc,jdbcType=VARCHAR},
      </if>
      <if test="shsj != null" >
        SHSJ = #{shsj,jdbcType=TIMESTAMP},
      </if>
      <if test="shrbm != null" >
        SHRBM = #{shrbm,jdbcType=VARCHAR},
      </if>
      <if test="shrmc != null" >
        SHRMC = #{shrmc,jdbcType=VARCHAR},
      </if>
      <if test="qfsj != null" >
        QFSJ = #{qfsj,jdbcType=TIMESTAMP},
      </if>
      <if test="qfrbm != null" >
        QFRBM = #{qfrbm,jdbcType=VARCHAR},
      </if>
      <if test="qfrmc != null" >
        QFRMC = #{qfrmc,jdbcType=VARCHAR},
      </if>
      <if test="jhzxzt != null" >
        JHZXZT = #{jhzxzt,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 JHXXID = #{jhxxid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyJhxxzbDO" >
    update TY_JHXXZB
    set JHH = #{jhh,jdbcType=VARCHAR},
      JHBT = #{jhbt,jdbcType=VARCHAR},
      JHMS = #{jhms,jdbcType=VARCHAR},
      SSKDDM = #{sskddm,jdbcType=VARCHAR},
      SSKDMC = #{sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      JHLX = #{jhlx,jdbcType=VARCHAR},
      LSYQSL = #{lsyqsl,jdbcType=DECIMAL},
      LSNQ = #{lsnq,jdbcType=VARCHAR},
      LSWCSL = #{lswcsl,jdbcType=DECIMAL},
      LSJG = #{lsjg,jdbcType=DECIMAL},
      JHKSSJ = #{jhkssj,jdbcType=TIMESTAMP},
      JHJZSJ = #{jhjzsj,jdbcType=TIMESTAMP},
      BZSJ = #{bzsj,jdbcType=TIMESTAMP},
      BZRBM = #{bzrbm,jdbcType=VARCHAR},
      BZRMC = #{bzrmc,jdbcType=VARCHAR},
      SHSJ = #{shsj,jdbcType=TIMESTAMP},
      SHRBM = #{shrbm,jdbcType=VARCHAR},
      SHRMC = #{shrmc,jdbcType=VARCHAR},
      QFSJ = #{qfsj,jdbcType=TIMESTAMP},
      QFRBM = #{qfrbm,jdbcType=VARCHAR},
      QFRMC = #{qfrmc,jdbcType=VARCHAR},
      JHZXZT = #{jhzxzt,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},
      LHND = #{lhnd,jdbcType=VARCHAR}
    where JHXXID = #{jhxxid,jdbcType=VARCHAR}
  </update>
</mapper>