<?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.TyZjxxmxbDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyZjxxmxbDO" >
    <id column="ZJXXID" property="zjxxid" jdbcType="VARCHAR" />
    <id column="SXH" property="sxh" jdbcType="DECIMAL" />
    <result column="JYDH" property="jydh" jdbcType="VARCHAR" />
    <result column="JYBZBH" property="jybzbh" jdbcType="VARCHAR" />
    <result column="JYXM" property="jyxm" jdbcType="VARCHAR" />
    <result column="JYJL" property="jyjl" jdbcType="VARCHAR" />
    <result column="ZJBGFJ" property="zjbgfj" jdbcType="VARCHAR" />
    <result column="BZYQPDGZ" property="bzyqpdgz" jdbcType="VARCHAR" />
    <result column="JYJG" property="jyjg" jdbcType="VARCHAR" />
    <result column="DXPD" property="dxpd" jdbcType="VARCHAR" />
    <result column="JCRBM" property="jcrbm" jdbcType="VARCHAR" />
    <result column="JCRMC" property="jcrmc" jdbcType="VARCHAR" />
    <result column="ZKLBL" property="zklbl" jdbcType="DECIMAL" />
    <result column="ZKSL" property="zksl" jdbcType="DECIMAL" />
    <result column="ZKJE" property="zkje" jdbcType="DECIMAL" />
    <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="SPAQXM" property="spaqxm" jdbcType="VARCHAR" />
    <result column="SYQK" property="syqk" jdbcType="VARCHAR" />
    <result column="ZJSYSJ" property="zjsysj" jdbcType="TIMESTAMP" />
    <result column="SYYJMC" property="syyjmc" jdbcType="VARCHAR" />
    <result column="CLJS" property="cljs" jdbcType="VARCHAR" />
    <result column="CHFSQK" property="chfsqk" jdbcType="VARCHAR" />
    <result column="LCSYMC" property="lcsymc" jdbcType="VARCHAR" />
    <result column="BZ" property="bz" jdbcType="VARCHAR" />
    <result column="TYJG" property="tyjg" jdbcType="VARCHAR" />
    <result column="TYFZRQZ" property="tyfzrqz" jdbcType="VARCHAR" />
    <result column="CCQYFZR" property="ccqyfzr" jdbcType="VARCHAR" />
    <result column="CCQYLXDH" property="ccqylxdh" jdbcType="VARCHAR" />
    <result column="TYXXFJ" property="tyxxfj" jdbcType="VARCHAR" /> -->
    
    
    <result column="SFYC" property="sfyc" 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" >
    ZJXXID, SXH, JYDH, JYBZBH, JYXM, JYJL, ZJBGFJ, BZYQPDGZ, JYJG, DXPD, JCRBM, JCRMC, ZKLBL, ZKSL,
    ZKJE, STATUS, CREATOR, CREATOR_CODE, CREATE_DATE, REFRESHER, REFRESHER_CODE, REFRESH_TIME, 

    SFYC
    
<!-- , SPAQXM, SYQK, ZJSYSJ, SYYJMC, CLJS, CHFSQK, LCSYMC, BZ, TYJG, TYFZRQZ, CCQYFZR, CCQYLXDH, TYXXFJ -->

  </sql>
  
  
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyZjxxmxbExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_ZJXXMXB
    <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="com.unis.base.server.example.TyZjxxmxbKey" >
    select 
    <include refid="Base_Column_List" />
    from TY_ZJXXMXB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
      and SXH = #{sxh,jdbcType=DECIMAL}
  </select> -->
  
  
  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_ZJXXMXB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
      <!-- and SXH = #{sxh,jdbcType=DECIMAL} -->
  </select>
  
  
  <!-- <delete id="deleteByPrimaryKey" parameterType="com.unis.base.server.example.TyZjxxmxbKey" >
    delete from TY_ZJXXMXB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
      and SXH = #{sxh,jdbcType=DECIMAL}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyZjxxmxbExample" >
    delete from TY_ZJXXMXB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  

  <insert id="insert" parameterType="com.unis.base.server.entity.TyZjxxmxbDO" >
    insert into TY_ZJXXMXB (ZJXXID, SXH, JYDH, 
      JYBZBH, JYXM, JYJL, ZJBGFJ, BZYQPDGZ,
      JYJG, DXPD, JCRBM, 
      JCRMC, ZKLBL, ZKSL, 
      ZKJE, STATUS, CREATOR, 
      CREATOR_CODE, CREATE_DATE, REFRESHER, 
      REFRESHER_CODE, REFRESH_TIME, REMARK, SFYC


      )
    values (#{zjxxid,jdbcType=VARCHAR}, #{sxh,jdbcType=DECIMAL}, #{jydh,jdbcType=VARCHAR}, 
      #{jybzbh,jdbcType=VARCHAR}, #{jyxm,jdbcType=VARCHAR}, #{jyjl,jdbcType=VARCHAR}, #{zjbgfj,jdbcType=VARCHAR}, #{bzyqpdgz,jdbcType=VARCHAR},
      #{jyjg,jdbcType=VARCHAR}, #{dxpd,jdbcType=VARCHAR}, #{jcrbm,jdbcType=VARCHAR}, 
      #{jcrmc,jdbcType=VARCHAR}, #{zklbl,jdbcType=DECIMAL}, #{zksl,jdbcType=DECIMAL}, 
      #{zkje,jdbcType=DECIMAL}, #{status,jdbcType=DECIMAL}, #{creator,jdbcType=VARCHAR}, 
      #{creatorCode,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{refresher,jdbcType=VARCHAR}, 
      #{refresherCode,jdbcType=VARCHAR}, #{refreshTime,jdbcType=TIMESTAMP}, #{remark,jdbcType=VARCHAR},<!-- ,
      #{spaqxm,jdbcType=VARCHAR}, #{syqk,jdbcType=VARCHAR}, #{zjsysj,jdbcType=TIMESTAMP},
      #{syyjmc,jdbcType=VARCHAR}, #{cljs,jdbcType=VARCHAR}, #{chfsqk,jdbcType=VARCHAR},
      #{lcsymc,jdbcType=VARCHAR}, #{bz,jdbcType=VARCHAR}, #{tyjg,jdbcType=VARCHAR},
<<<<<<< HEAD
      #{tyfzrqz,jdbcType=VARCHAR}, #{ccqyfzr,jdbcType=VARCHAR}, #{ccqulxdh,jdbcType=VARCHAR},
      #{tyxxfj,jdbcType=VARCHAR}, #{sfyc,jdbcType=INTEGER})
=======
      #{tyfzrqz,jdbcType=VARCHAR}, #{ccqyfzr,jdbcType=VARCHAR}, #{ccqylxdh,jdbcType=VARCHAR},
<<<<<<< HEAD
      #{tyxxfj,jdbcType=VARCHAR})
>>>>>>> 3ecfa54680f0f7c39d95f052d7e062971625fb7c
  </insert> -->

      #{tyxxfj,jdbcType=VARCHAR} )
  </insert>

  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyZjxxmxbDO" >
    insert into TY_ZJXXMXB
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="zjxxid != null" >
        ZJXXID,
      </if>
      <if test="sxh != null" >
        SXH,
      </if>
      <if test="jydh != null" >
        JYDH,
      </if>
      <if test="jybzbh != null" >
        JYBZBH,
      </if>
      <if test="jyxm != null" >
        JYXM,
      </if>
      <if test="jyjl != null" >
        JYJL,
      </if>
      <if test="zjbgfj != null" >
        ZJBGFJ,
      </if>
      <if test="bzyqpdgz != null" >
        BZYQPDGZ,
      </if>
      <if test="jyjg != null" >
        JYJG,
      </if>
      <if test="dxpd != null" >
        DXPD,
      </if>
      <if test="jcrbm != null" >
        JCRBM,
      </if>
      <if test="jcrmc != null" >
        JCRMC,
      </if>
      <if test="zklbl != null" >
        ZKLBL,
      </if>
      <if test="zksl != null" >
        ZKSL,
      </if>
      <if test="zkje != null" >
        ZKJE,
      </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="spaqxm != null" >
        SPAQXM,
      </if>
      <if test="syqk != null" >
        SYQK,
      </if>
      <if test="zjsysj != null" >
        ZJSYSJ,
      </if>
      <if test="syyjmc != null" >
        SYYJMC,
      </if>
      <if test="cljs != null" >
        CLJS,
      </if>
      <if test="chfsqk != null" >
        CHFSQK,
      </if>
      <if test="lcsymc != null" >
        LCSYMC,
      </if>
      <if test="bz != null" >
        BZ,
      </if>
      <if test="tyjg != null" >
        TYJG,
      </if>
      <if test="tyfzrqz != null" >
        TYFZRZQ,
      </if>
      <if test="ccqyfzr != null" >
        CCQYFZR,
      </if>
      <if test="ccqylxdh != null" >
        CCQyLXDH,	
      </if>
      <if test="tyxxfj != null" >
        TYXXFJ,
      </if> -->
      
       <if test="sfyc != null" >
        SFYC,
      </if>
      
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="zjxxid != null" >
        #{zjxxid,jdbcType=VARCHAR},
      </if>
      <if test="sxh != null" >
        #{sxh,jdbcType=DECIMAL},
      </if>
      <if test="jydh != null" >
        #{jydh,jdbcType=VARCHAR},
      </if>
      <if test="jybzbh != null" >
        #{jybzbh,jdbcType=VARCHAR},
      </if>
      <if test="jyxm != null" >
        #{jyxm,jdbcType=VARCHAR},
      </if>
      <if test="jyjl != null" >
        #{jyjl,jdbcType=VARCHAR},
      </if>
      <if test="zjbgfj != null" >
        #{zjbgfj,jdbcType=VARCHAR},
      </if>
      <if test="bzyqpdgz != null" >
        #{bzyqpdgz,jdbcType=VARCHAR},
      </if>
      <if test="jyjg != null" >
        #{jyjg,jdbcType=VARCHAR},
      </if>
      <if test="dxpd != null" >
        #{dxpd,jdbcType=VARCHAR},
      </if>
      <if test="jcrbm != null" >
        #{jcrbm,jdbcType=VARCHAR},
      </if>
      <if test="jcrmc != null" >
        #{jcrmc,jdbcType=VARCHAR},
      </if>
      <if test="zklbl != null" >
        #{zklbl,jdbcType=DECIMAL},
      </if>
      <if test="zksl != null" >
        #{zksl,jdbcType=DECIMAL},
      </if>
      <if test="zkje != null" >
        #{zkje,jdbcType=DECIMAL},
      </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="spaqxm != null" >
        #{spaqxm,jdbcType=VARCHAR},
      </if>
      <if test="syqk != null" >
        #{syqk,jdbcType=VARCHAR},
      </if>
      <if test="zjsysj != null" >
        #{zjsysj,jdbcType=TIMESTAMP},
      </if>
      <if test="syyjmc != null" >
        #{syyjmc,jdbcType=VARCHAR},
      </if>
      <if test="cljs != null" >
        #{cljs,jdbcType=VARCHAR},
      </if>
      <if test="chfsqk != null" >
        #{chfsqk,jdbcType=VARCHAR},
      </if>
      <if test="lcsymc != null" >
        #{lcsymc,jdbcType=VARCHAR},
      </if>
      <if test="bz != null" >
        #{bz,jdbcType=VARCHAR},
      </if>
      <if test="tyjg != null" >
        #{tyjg,jdbcType=VARCHAR},
      </if>
      <if test="tyfzrqz != null" >
       #{tyfzrqz,jdbcType=VARCHAR},
      </if>
      <if test="ccqyfzr != null" >
        #{ccqyfzr,jdbcType=VARCHAR},
      </if>
      <if test="ccqylxdh != null" >
        #{ccqylxdh,jdbcType=VARCHAR},
      </if>
      <if test="tyxxfj != null" >
      #{tyxxfj,jdbcType=VARCHAR},
<<<<<<< HEAD
      </if>
      
      
      <if test="sfyc != null" >
      #{sfyc,jdbcType=INTEGER},
      </if>
      
=======
      </if> -->
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyZjxxmxbExample" resultType="java.lang.Integer" >
    select count(1) from TY_ZJXXMXB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_ZJXXMXB
    <set >
      <if test="record.zjxxid != null" >
        ZJXXID = #{record.zjxxid,jdbcType=VARCHAR},
      </if>
      <if test="record.sxh != null" >
        SXH = #{record.sxh,jdbcType=DECIMAL},
      </if>
      <if test="record.jydh != null" >
        JYDH = #{record.jydh,jdbcType=VARCHAR},
      </if>
      <if test="record.jybzbh != null" >
        JYBZBH = #{record.jybzbh,jdbcType=VARCHAR},
      </if>
      <if test="record.jyxm != null" >
        JYXM = #{record.jyxm,jdbcType=VARCHAR},
      </if>
      <if test="record.jyjl != null" >
        JYJL = #{record.jyjl,jdbcType=VARCHAR},
      </if>
      <if test="record.zjbgfj != null" >
        ZJBGFJ = #{record.zjbgfj,jdbcType=VARCHAR},
      </if>
      <if test="record.bzyqpdgz != null" >
        BZYQPDGZ = #{record.bzyqpdgz,jdbcType=VARCHAR},
      </if>
      <if test="record.jyjg != null" >
        JYJG = #{record.jyjg,jdbcType=VARCHAR},
      </if>
      <if test="record.dxpd != null" >
        DXPD = #{record.dxpd,jdbcType=VARCHAR},
      </if>
      <if test="record.jcrbm != null" >
        JCRBM = #{record.jcrbm,jdbcType=VARCHAR},
      </if>
      <if test="record.jcrmc != null" >
        JCRMC = #{record.jcrmc,jdbcType=VARCHAR},
      </if>
      <if test="record.zklbl != null" >
        ZKLBL = #{record.zklbl,jdbcType=DECIMAL},
      </if>
      <if test="record.zksl != null" >
        ZKSL = #{record.zksl,jdbcType=DECIMAL},
      </if>
      <if test="record.zkje != null" >
        ZKJE = #{record.zkje,jdbcType=DECIMAL},
      </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_ZJXXMXB
    set ZJXXID = #{record.zjxxid,jdbcType=VARCHAR},
      SXH = #{record.sxh,jdbcType=DECIMAL},
      JYDH = #{record.jydh,jdbcType=VARCHAR},
      JYBZBH = #{record.jybzbh,jdbcType=VARCHAR},
      JYXM = #{record.jyxm,jdbcType=VARCHAR},
      JYJL = #{record.jyjl,jdbcType=VARCHAR},
      ZJBGFJ = #{record.zjbgfj,jdbcType=VARCHAR},
      BZYQPDGZ = #{record.bzyqpdgz,jdbcType=VARCHAR},
      JYJG = #{record.jyjg,jdbcType=VARCHAR},
      DXPD = #{record.dxpd,jdbcType=VARCHAR},
      JCRBM = #{record.jcrbm,jdbcType=VARCHAR},
      JCRMC = #{record.jcrmc,jdbcType=VARCHAR},
      ZKLBL = #{record.zklbl,jdbcType=DECIMAL},
      ZKSL = #{record.zksl,jdbcType=DECIMAL},
      ZKJE = #{record.zkje,jdbcType=DECIMAL},
      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.TyZjxxmxbDO" >
    update TY_ZJXXMXB
    <set >
      <if test="jydh != null" >
        JYDH = #{jydh,jdbcType=VARCHAR},
      </if>
      <if test="jybzbh != null" >
        JYBZBH = #{jybzbh,jdbcType=VARCHAR},
      </if>
      <if test="jyxm != null" >
        JYXM = #{jyxm,jdbcType=VARCHAR},
      </if>
      <if test="jyjl != null" >
        JYJL = #{jyjl,jdbcType=VARCHAR},
      </if>
      <if test="zjbgfj != null" >
        ZJBGFJ = #{zjbgfj,jdbcType=VARCHAR},
      </if>
      <if test="bzyqpdgz != null" >
        BZYQPDGZ = #{bzyqpdgz,jdbcType=VARCHAR},
      </if>
      <if test="jyjg != null" >
        JYJG = #{jyjg,jdbcType=VARCHAR},
      </if>
      <if test="dxpd != null" >
        DXPD = #{dxpd,jdbcType=VARCHAR},
      </if>
      <if test="jcrbm != null" >
        JCRBM = #{jcrbm,jdbcType=VARCHAR},
      </if>
      <if test="jcrmc != null" >
        JCRMC = #{jcrmc,jdbcType=VARCHAR},
      </if>
      <if test="zklbl != null" >
        ZKLBL = #{zklbl,jdbcType=DECIMAL},
      </if>
      <if test="zksl != null" >
        ZKSL = #{zksl,jdbcType=DECIMAL},
      </if>
      <if test="zkje != null" >
        ZKJE = #{zkje,jdbcType=DECIMAL},
      </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 ZJXXID = #{zjxxid,jdbcType=VARCHAR}
      and SXH = #{sxh,jdbcType=DECIMAL}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyZjxxmxbDO" >
    update TY_ZJXXMXB
    set JYDH = #{jydh,jdbcType=VARCHAR},
      JYBZBH = #{jybzbh,jdbcType=VARCHAR},
      JYXM = #{jyxm,jdbcType=VARCHAR},
      JYJL = #{jyjl,jdbcType=VARCHAR},
      ZJBGFJ = #{zjbgfj,jdbcType=VARCHAR},
      BZYQPDGZ = #{bzyqpdgz,jdbcType=VARCHAR},
      JYJG = #{jyjg,jdbcType=VARCHAR},
      DXPD = #{dxpd,jdbcType=VARCHAR},
      JCRBM = #{jcrbm,jdbcType=VARCHAR},
      JCRMC = #{jcrmc,jdbcType=VARCHAR},
      ZKLBL = #{zklbl,jdbcType=DECIMAL},
      ZKSL = #{zksl,jdbcType=DECIMAL},
      ZKJE = #{zkje,jdbcType=DECIMAL},
      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}
      TYXXFJ = #{tyxxfj,jdbcType=VARCHAR},
      SFYC = #{sfyc,jdbcType=INTEGER}
      )
   
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
      and SXH = #{sxh,jdbcType=DECIMAL}
  </update>

  
  <select id="getTyZjxxmxbByzjxxid" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_ZJXXMXB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </select>
  
  </mapper>
