<?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.TyZjxxzbDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyZjxxzbDO" >
    <id column="ZJXXID" property="zjxxid" jdbcType="VARCHAR" />
    <result column="ZJBGBH" property="zjbgbh" jdbcType="VARCHAR" />
    <result column="ZJBGMC" property="zjbgmc" jdbcType="VARCHAR" />
    <result column="HWBM" property="hwbm" jdbcType="VARCHAR" />
    <result column="SSAJBH" property="ssajbh" jdbcType="VARCHAR" />
    <result column="SSAJMC" property="ssajmc" jdbcType="VARCHAR" />
    <result column="SSCFBH" property="sscfbh" jdbcType="VARCHAR" />
    <result column="SSCFMC" property="sscfmc" 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="WTDWDM" property="wtdwdm" jdbcType="VARCHAR" />
    <result column="WTDWMC" property="wtdwmc" jdbcType="VARCHAR" />
    <result column="JYDWDM" property="jydwdm" jdbcType="VARCHAR" />
    <result column="JYDWMC" property="jydwmc" jdbcType="VARCHAR" />
    <result column="LSPZBM" property="lspzbm" jdbcType="VARCHAR" />
    <result column="LSPZMC" property="lspzmc" jdbcType="VARCHAR" />
    <result column="LSDJBM" property="lsdjbm" jdbcType="VARCHAR" />
    <result column="LSDJMC" property="lsdjmc" jdbcType="VARCHAR" />
    <result column="SHND" property="shnd" jdbcType="VARCHAR" />
    <result column="LSGB" property="lsgb" jdbcType="VARCHAR" />
    <result column="LSCD" property="lscd" jdbcType="VARCHAR" />
    <result column="JYLBBM" property="jylbbm" jdbcType="VARCHAR" />
    <result column="JYRQ" property="jyrq" jdbcType="TIMESTAMP" />
    <result column="JYYJ" property="jyyj" jdbcType="VARCHAR" />
    <result column="QYDBH" property="qydbh" jdbcType="VARCHAR" />
    <result column="YPSLDW" property="ypsldw" jdbcType="DECIMAL" />
    <result column="DBSLDW" property="dbsldw" jdbcType="DECIMAL" />
    <result column="GGXH" property="ggxh" jdbcType="VARCHAR" />
    <result column="SCRQPC" property="scrqpc" jdbcType="VARCHAR" />
    <result column="LYFS" property="lyfs" jdbcType="VARCHAR" />
    <result column="YPZTBS" property="ypztbs" jdbcType="VARCHAR" />
    <result column="ZXCPBZH" property="zxcpbzh" jdbcType="VARCHAR" />
    <result column="JYPDYJ" property="jypdyj" jdbcType="VARCHAR" />
    <result column="CHECK_REMARK" property="checkRemark" jdbcType="VARCHAR" />
    <result column="RKNX" property="rknx" jdbcType="DECIMAL" />
    <result column="QYDD" property="qydd" jdbcType="VARCHAR" />
    <result column="QYRBM" property="qyrbm" jdbcType="VARCHAR" />
    <result column="QYRMC" property="qyrmc" jdbcType="VARCHAR" />
    <result column="JYJG" property="jyjg" jdbcType="VARCHAR" />
    <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="ZSBM" property="zsbm" 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="ZGZT" property="zgzt" jdbcType="INTEGER" />
  </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, ZJBGBH, ZJBGMC, HWBM, SSAJBH, SSAJMC, SSCFBH, SSCFMC, SSKDDM, SSKDMC, SSQYDM, 
    SSYQMC, WTDWDM, WTDWMC, JYDWDM, JYDWMC, LSPZBM, LSPZMC, LSDJBM, LSDJMC, SHND, LSGB, 
    LSCD, JYLBBM, JYRQ, JYYJ, QYDBH, YPSLDW, DBSLDW, GGXH, SCRQPC, LYFS, YPZTBS, ZXCPBZH, 
    JYPDYJ, CHECK_REMARK, RKNX, QYDD, QYRBM, QYRMC, JYJG, BZSJ, BZRBM, BZRMC, SHSJ, SHRBM, 
    SHRMC, QFSJ, QFRBM, QFRMC, ZSBM, STATUS, CREATOR, CREATOR_CODE, CREATE_DATE, REFRESHER, 
    REFRESHER_CODE, REFRESH_TIME, REMARK, ZGZT
  </sql>

  <!-- 根据条件查询质检主表信息 -->
  <select id="getTyZjxxzbList" parameterType="com.unis.base.common.vo.TyZjxxzbQueryVO" resultMap="BaseResultMap">
    SELECT
    <include refid="Base_Column_List"></include>
    FROM
    TY_ZJXXZB
    <where>
      1 = 1
      <!-- 强检编号 -->
      <if test="zjbgbh != null and zjbgbh != ''">
        and zjbgbh LIKE concat(CONCAT('%',#{zjbgbh,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 受检单位代码（统一社会信用代码）  -->
      <if test="ssqydm != null and ssqydm != ''">
        and ssqydm LIKE concat(CONCAT('%',#{ssqydm,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 受检单位名称  -->
      <if test="ssyqmc != null and ssyqmc != ''">
        and ssyqmc LIKE concat(CONCAT('%',#{ssyqmc,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 样品单编号 -->
      <if test="qydbh != null and qydbh != ''">
        and qydbh LIKE concat(CONCAT('%',#{qydbh,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 检验开始时间 -->
      <if test="jyksrq != null and jyksrq != ''">
        and date_format(jyrq,'%Y-%d-%m') &gt;= #{jyksrq}
      </if>
      <!-- 检验结束时间 -->
      <if test="jyjsrq != null and jyjsrq != ''">
        and date_format(jyrq,'%Y-%d-%m') &lt;= #{jyjsrq}
      </if>
      <!-- 所属仓房编码 -->
      <if test="sscfbh != null and sscfbh != ''">
        and sscfbh LIKE concat(CONCAT('%',#{sscfbh,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 所属仓房名称 -->
      <if test="sscfmc != null and sscfmc != ''">
        and sscfmc LIKE concat(CONCAT('%',#{sscfmc,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 粮食品种编码 -->
      <if test="lspzbm != null and lspzbm != ''">
        and lspzbm LIKE concat(CONCAT('%',#{lspzbm,jdbcType=VARCHAR}) , '%')
      </if>
      <!-- 粮食品种名称 -->
      <if test="lspzmc != null and lspzmc != ''">
        and lspzmc LIKE concat(CONCAT('%',#{lspzmc,jdbcType=VARCHAR}) , '%')
      </if>
      
      
      <!-- 整改状态 -->
      <if test="zgzt != null ">
        and zgzt = #{zgzt}
      </if>
      and status = 1
    </where>
    ORDER BY zjxxid asc
  </select>

  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyZjxxzbExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_ZJXXZB
    <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_ZJXXZB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </select> -->
  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_ZJXXZB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </select>
  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_ZJXXZB
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyZjxxzbExample" >
    delete from TY_ZJXXZB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyZjxxzbDO" >
    insert into TY_ZJXXZB (ZJXXID, ZJBGBH, ZJBGMC, 
      HWBM, SSAJBH, SSAJMC, 
      SSCFBH, SSCFMC, SSKDDM, 
      SSKDMC, SSQYDM, SSYQMC, 
      WTDWDM, WTDWMC, JYDWDM, 
      JYDWMC, LSPZBM, LSPZMC, 
      LSDJBM, LSDJMC, SHND, 
      LSGB, LSCD, JYLBBM, 
      JYRQ, JYYJ, QYDBH, 
      YPSLDW, DBSLDW, GGXH, 
      SCRQPC, LYFS, YPZTBS, 
      ZXCPBZH, JYPDYJ, CHECK_REMARK, 
      RKNX, QYDD, QYRBM, 
      QYRMC, JYJG, BZSJ, 
      BZRBM, BZRMC, SHSJ, 
      SHRBM, SHRMC, QFSJ, 
      QFRBM, QFRMC, ZSBM, 
      STATUS, CREATOR, CREATOR_CODE, 
      CREATE_DATE, REFRESHER, REFRESHER_CODE, 
      REFRESH_TIME, REMARK, ZGZT)
    values (#{zjxxid,jdbcType=VARCHAR}, #{zjbgbh,jdbcType=VARCHAR}, #{zjbgmc,jdbcType=VARCHAR}, 
      #{hwbm,jdbcType=VARCHAR}, #{ssajbh,jdbcType=VARCHAR}, #{ssajmc,jdbcType=VARCHAR}, 
      #{sscfbh,jdbcType=VARCHAR}, #{sscfmc,jdbcType=VARCHAR}, #{sskddm,jdbcType=VARCHAR}, 
      #{sskdmc,jdbcType=VARCHAR}, #{ssqydm,jdbcType=VARCHAR}, #{ssyqmc,jdbcType=VARCHAR}, 
      #{wtdwdm,jdbcType=VARCHAR}, #{wtdwmc,jdbcType=VARCHAR}, #{jydwdm,jdbcType=VARCHAR}, 
      #{jydwmc,jdbcType=VARCHAR}, #{lspzbm,jdbcType=VARCHAR}, #{lspzmc,jdbcType=VARCHAR}, 
      #{lsdjbm,jdbcType=VARCHAR}, #{lsdjmc,jdbcType=VARCHAR}, #{shnd,jdbcType=VARCHAR}, 
      #{lsgb,jdbcType=VARCHAR}, #{lscd,jdbcType=VARCHAR}, #{jylbbm,jdbcType=VARCHAR}, 
      #{jyrq,jdbcType=TIMESTAMP}, #{jyyj,jdbcType=VARCHAR}, #{qydbh,jdbcType=VARCHAR}, 
      #{ypsldw,jdbcType=DECIMAL}, #{dbsldw,jdbcType=DECIMAL}, #{ggxh,jdbcType=VARCHAR}, 
      #{scrqpc,jdbcType=VARCHAR}, #{lyfs,jdbcType=VARCHAR}, #{ypztbs,jdbcType=VARCHAR}, 
      #{zxcpbzh,jdbcType=VARCHAR}, #{jypdyj,jdbcType=VARCHAR}, #{checkRemark,jdbcType=VARCHAR}, 
      #{rknx,jdbcType=DECIMAL}, #{qydd,jdbcType=VARCHAR}, #{qyrbm,jdbcType=VARCHAR}, 
      #{qyrmc,jdbcType=VARCHAR}, #{jyjg,jdbcType=VARCHAR}, #{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}, #{zsbm,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}, #{zgzt,jdbcType=INTEGER})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyZjxxzbDO" >
    insert into TY_ZJXXZB
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="zjxxid != null" >
        ZJXXID,
      </if>
      <if test="zjbgbh != null" >
        ZJBGBH,
      </if>
      <if test="zjbgmc != null" >
        ZJBGMC,
      </if>
      <if test="hwbm != null" >
        HWBM,
      </if>
      <if test="ssajbh != null" >
        SSAJBH,
      </if>
      <if test="ssajmc != null" >
        SSAJMC,
      </if>
      <if test="sscfbh != null" >
        SSCFBH,
      </if>
      <if test="sscfmc != null" >
        SSCFMC,
      </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="wtdwdm != null" >
        WTDWDM,
      </if>
      <if test="wtdwmc != null" >
        WTDWMC,
      </if>
      <if test="jydwdm != null" >
        JYDWDM,
      </if>
      <if test="jydwmc != null" >
        JYDWMC,
      </if>
      <if test="lspzbm != null" >
        LSPZBM,
      </if>
      <if test="lspzmc != null" >
        LSPZMC,
      </if>
      <if test="lsdjbm != null" >
        LSDJBM,
      </if>
      <if test="lsdjmc != null" >
        LSDJMC,
      </if>
      <if test="shnd != null" >
        SHND,
      </if>
      <if test="lsgb != null" >
        LSGB,
      </if>
      <if test="lscd != null" >
        LSCD,
      </if>
      <if test="jylbbm != null" >
        JYLBBM,
      </if>
      <if test="jyrq != null" >
        JYRQ,
      </if>
      <if test="jyyj != null" >
        JYYJ,
      </if>
      <if test="qydbh != null" >
        QYDBH,
      </if>
      <if test="ypsldw != null" >
        YPSLDW,
      </if>
      <if test="dbsldw != null" >
        DBSLDW,
      </if>
      <if test="ggxh != null" >
        GGXH,
      </if>
      <if test="scrqpc != null" >
        SCRQPC,
      </if>
      <if test="lyfs != null" >
        LYFS,
      </if>
      <if test="ypztbs != null" >
        YPZTBS,
      </if>
      <if test="zxcpbzh != null" >
        ZXCPBZH,
      </if>
      <if test="jypdyj != null" >
        JYPDYJ,
      </if>
      <if test="checkRemark != null" >
        CHECK_REMARK,
      </if>
      <if test="rknx != null" >
        RKNX,
      </if>
      <if test="qydd != null" >
        QYDD,
      </if>
      <if test="qyrbm != null" >
        QYRBM,
      </if>
      <if test="qyrmc != null" >
        QYRMC,
      </if>
      <if test="jyjg != null" >
        JYJG,
      </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="zsbm != null" >
        ZSBM,
      </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="zgzt != null" >
        ZGZT,
      </if>
      
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="zjxxid != null" >
        #{zjxxid,jdbcType=VARCHAR},
      </if>
      <if test="zjbgbh != null" >
        #{zjbgbh,jdbcType=VARCHAR},
      </if>
      <if test="zjbgmc != null" >
        #{zjbgmc,jdbcType=VARCHAR},
      </if>
      <if test="hwbm != null" >
        #{hwbm,jdbcType=VARCHAR},
      </if>
      <if test="ssajbh != null" >
        #{ssajbh,jdbcType=VARCHAR},
      </if>
      <if test="ssajmc != null" >
        #{ssajmc,jdbcType=VARCHAR},
      </if>
      <if test="sscfbh != null" >
        #{sscfbh,jdbcType=VARCHAR},
      </if>
      <if test="sscfmc != null" >
        #{sscfmc,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="wtdwdm != null" >
        #{wtdwdm,jdbcType=VARCHAR},
      </if>
      <if test="wtdwmc != null" >
        #{wtdwmc,jdbcType=VARCHAR},
      </if>
      <if test="jydwdm != null" >
        #{jydwdm,jdbcType=VARCHAR},
      </if>
      <if test="jydwmc != null" >
        #{jydwmc,jdbcType=VARCHAR},
      </if>
      <if test="lspzbm != null" >
        #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsdjbm != null" >
        #{lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="lsdjmc != null" >
        #{lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="shnd != null" >
        #{shnd,jdbcType=VARCHAR},
      </if>
      <if test="lsgb != null" >
        #{lsgb,jdbcType=VARCHAR},
      </if>
      <if test="lscd != null" >
        #{lscd,jdbcType=VARCHAR},
      </if>
      <if test="jylbbm != null" >
        #{jylbbm,jdbcType=VARCHAR},
      </if>
      <if test="jyrq != null" >
        #{jyrq,jdbcType=TIMESTAMP},
      </if>
      <if test="jyyj != null" >
        #{jyyj,jdbcType=VARCHAR},
      </if>
      <if test="qydbh != null" >
        #{qydbh,jdbcType=VARCHAR},
      </if>
      <if test="ypsldw != null" >
        #{ypsldw,jdbcType=DECIMAL},
      </if>
      <if test="dbsldw != null" >
        #{dbsldw,jdbcType=DECIMAL},
      </if>
      <if test="ggxh != null" >
        #{ggxh,jdbcType=VARCHAR},
      </if>
      <if test="scrqpc != null" >
        #{scrqpc,jdbcType=VARCHAR},
      </if>
      <if test="lyfs != null" >
        #{lyfs,jdbcType=VARCHAR},
      </if>
      <if test="ypztbs != null" >
        #{ypztbs,jdbcType=VARCHAR},
      </if>
      <if test="zxcpbzh != null" >
        #{zxcpbzh,jdbcType=VARCHAR},
      </if>
      <if test="jypdyj != null" >
        #{jypdyj,jdbcType=VARCHAR},
      </if>
      <if test="checkRemark != null" >
        #{checkRemark,jdbcType=VARCHAR},
      </if>
      <if test="rknx != null" >
        #{rknx,jdbcType=DECIMAL},
      </if>
      <if test="qydd != null" >
        #{qydd,jdbcType=VARCHAR},
      </if>
      <if test="qyrbm != null" >
        #{qyrbm,jdbcType=VARCHAR},
      </if>
      <if test="qyrmc != null" >
        #{qyrmc,jdbcType=VARCHAR},
      </if>
      <if test="jyjg != null" >
        #{jyjg,jdbcType=VARCHAR},
      </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="zsbm != null" >
        #{zsbm,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="zgzt != null" >
        #{zgzt,jdbcType=INTEGER},
      </if>
      
      
      
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyZjxxzbExample" resultType="java.lang.Integer" >
    select count(1) from TY_ZJXXZB
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_ZJXXZB
    <set >
      <if test="record.zjxxid != null" >
        ZJXXID = #{record.zjxxid,jdbcType=VARCHAR},
      </if>
      <if test="record.zjbgbh != null" >
        ZJBGBH = #{record.zjbgbh,jdbcType=VARCHAR},
      </if>
      <if test="record.zjbgmc != null" >
        ZJBGMC = #{record.zjbgmc,jdbcType=VARCHAR},
      </if>
      <if test="record.hwbm != null" >
        HWBM = #{record.hwbm,jdbcType=VARCHAR},
      </if>
      <if test="record.ssajbh != null" >
        SSAJBH = #{record.ssajbh,jdbcType=VARCHAR},
      </if>
      <if test="record.ssajmc != null" >
        SSAJMC = #{record.ssajmc,jdbcType=VARCHAR},
      </if>
      <if test="record.sscfbh != null" >
        SSCFBH = #{record.sscfbh,jdbcType=VARCHAR},
      </if>
      <if test="record.sscfmc != null" >
        SSCFMC = #{record.sscfmc,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.wtdwdm != null" >
        WTDWDM = #{record.wtdwdm,jdbcType=VARCHAR},
      </if>
      <if test="record.wtdwmc != null" >
        WTDWMC = #{record.wtdwmc,jdbcType=VARCHAR},
      </if>
      <if test="record.jydwdm != null" >
        JYDWDM = #{record.jydwdm,jdbcType=VARCHAR},
      </if>
      <if test="record.jydwmc != null" >
        JYDWMC = #{record.jydwmc,jdbcType=VARCHAR},
      </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.lsdjbm != null" >
        LSDJBM = #{record.lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lsdjmc != null" >
        LSDJMC = #{record.lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="record.shnd != null" >
        SHND = #{record.shnd,jdbcType=VARCHAR},
      </if>
      <if test="record.lsgb != null" >
        LSGB = #{record.lsgb,jdbcType=VARCHAR},
      </if>
      <if test="record.lscd != null" >
        LSCD = #{record.lscd,jdbcType=VARCHAR},
      </if>
      <if test="record.jylbbm != null" >
        JYLBBM = #{record.jylbbm,jdbcType=VARCHAR},
      </if>
      <if test="record.jyrq != null" >
        JYRQ = #{record.jyrq,jdbcType=TIMESTAMP},
      </if>
      <if test="record.jyyj != null" >
        JYYJ = #{record.jyyj,jdbcType=VARCHAR},
      </if>
      <if test="record.qydbh != null" >
        QYDBH = #{record.qydbh,jdbcType=VARCHAR},
      </if>
      <if test="record.ypsldw != null" >
        YPSLDW = #{record.ypsldw,jdbcType=DECIMAL},
      </if>
      <if test="record.dbsldw != null" >
        DBSLDW = #{record.dbsldw,jdbcType=DECIMAL},
      </if>
      <if test="record.ggxh != null" >
        GGXH = #{record.ggxh,jdbcType=VARCHAR},
      </if>
      <if test="record.scrqpc != null" >
        SCRQPC = #{record.scrqpc,jdbcType=VARCHAR},
      </if>
      <if test="record.lyfs != null" >
        LYFS = #{record.lyfs,jdbcType=VARCHAR},
      </if>
      <if test="record.ypztbs != null" >
        YPZTBS = #{record.ypztbs,jdbcType=VARCHAR},
      </if>
      <if test="record.zxcpbzh != null" >
        ZXCPBZH = #{record.zxcpbzh,jdbcType=VARCHAR},
      </if>
      <if test="record.jypdyj != null" >
        JYPDYJ = #{record.jypdyj,jdbcType=VARCHAR},
      </if>
      <if test="record.checkRemark != null" >
        CHECK_REMARK = #{record.checkRemark,jdbcType=VARCHAR},
      </if>
      <if test="record.rknx != null" >
        RKNX = #{record.rknx,jdbcType=DECIMAL},
      </if>
      <if test="record.qydd != null" >
        QYDD = #{record.qydd,jdbcType=VARCHAR},
      </if>
      <if test="record.qyrbm != null" >
        QYRBM = #{record.qyrbm,jdbcType=VARCHAR},
      </if>
      <if test="record.qyrmc != null" >
        QYRMC = #{record.qyrmc,jdbcType=VARCHAR},
      </if>
      <if test="record.jyjg != null" >
        JYJG = #{record.jyjg,jdbcType=VARCHAR},
      </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.zsbm != null" >
        ZSBM = #{record.zsbm,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_ZJXXZB
    set ZJXXID = #{record.zjxxid,jdbcType=VARCHAR},
      ZJBGBH = #{record.zjbgbh,jdbcType=VARCHAR},
      ZJBGMC = #{record.zjbgmc,jdbcType=VARCHAR},
      HWBM = #{record.hwbm,jdbcType=VARCHAR},
      SSAJBH = #{record.ssajbh,jdbcType=VARCHAR},
      SSAJMC = #{record.ssajmc,jdbcType=VARCHAR},
      SSCFBH = #{record.sscfbh,jdbcType=VARCHAR},
      SSCFMC = #{record.sscfmc,jdbcType=VARCHAR},
      SSKDDM = #{record.sskddm,jdbcType=VARCHAR},
      SSKDMC = #{record.sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{record.ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      WTDWDM = #{record.wtdwdm,jdbcType=VARCHAR},
      WTDWMC = #{record.wtdwmc,jdbcType=VARCHAR},
      JYDWDM = #{record.jydwdm,jdbcType=VARCHAR},
      JYDWMC = #{record.jydwmc,jdbcType=VARCHAR},
      LSPZBM = #{record.lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{record.lspzmc,jdbcType=VARCHAR},
      LSDJBM = #{record.lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{record.lsdjmc,jdbcType=VARCHAR},
      SHND = #{record.shnd,jdbcType=VARCHAR},
      LSGB = #{record.lsgb,jdbcType=VARCHAR},
      LSCD = #{record.lscd,jdbcType=VARCHAR},
      JYLBBM = #{record.jylbbm,jdbcType=VARCHAR},
      JYRQ = #{record.jyrq,jdbcType=TIMESTAMP},
      JYYJ = #{record.jyyj,jdbcType=VARCHAR},
      QYDBH = #{record.qydbh,jdbcType=VARCHAR},
      YPSLDW = #{record.ypsldw,jdbcType=DECIMAL},
      DBSLDW = #{record.dbsldw,jdbcType=DECIMAL},
      GGXH = #{record.ggxh,jdbcType=VARCHAR},
      SCRQPC = #{record.scrqpc,jdbcType=VARCHAR},
      LYFS = #{record.lyfs,jdbcType=VARCHAR},
      YPZTBS = #{record.ypztbs,jdbcType=VARCHAR},
      ZXCPBZH = #{record.zxcpbzh,jdbcType=VARCHAR},
      JYPDYJ = #{record.jypdyj,jdbcType=VARCHAR},
      CHECK_REMARK = #{record.checkRemark,jdbcType=VARCHAR},
      RKNX = #{record.rknx,jdbcType=DECIMAL},
      QYDD = #{record.qydd,jdbcType=VARCHAR},
      QYRBM = #{record.qyrbm,jdbcType=VARCHAR},
      QYRMC = #{record.qyrmc,jdbcType=VARCHAR},
      JYJG = #{record.jyjg,jdbcType=VARCHAR},
      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},
      ZSBM = #{record.zsbm,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.TyZjxxzbDO" >
    update TY_ZJXXZB
    <set >
      <if test="zjbgbh != null" >
        ZJBGBH = #{zjbgbh,jdbcType=VARCHAR},
      </if>
      <if test="zjbgmc != null" >
        ZJBGMC = #{zjbgmc,jdbcType=VARCHAR},
      </if>
      <if test="hwbm != null" >
        HWBM = #{hwbm,jdbcType=VARCHAR},
      </if>
      <if test="ssajbh != null" >
        SSAJBH = #{ssajbh,jdbcType=VARCHAR},
      </if>
      <if test="ssajmc != null" >
        SSAJMC = #{ssajmc,jdbcType=VARCHAR},
      </if>
      <if test="sscfbh != null" >
        SSCFBH = #{sscfbh,jdbcType=VARCHAR},
      </if>
      <if test="sscfmc != null" >
        SSCFMC = #{sscfmc,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="wtdwdm != null" >
        WTDWDM = #{wtdwdm,jdbcType=VARCHAR},
      </if>
      <if test="wtdwmc != null" >
        WTDWMC = #{wtdwmc,jdbcType=VARCHAR},
      </if>
      <if test="jydwdm != null" >
        JYDWDM = #{jydwdm,jdbcType=VARCHAR},
      </if>
      <if test="jydwmc != null" >
        JYDWMC = #{jydwmc,jdbcType=VARCHAR},
      </if>
      <if test="lspzbm != null" >
        LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsdjbm != null" >
        LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      </if>
      <if test="lsdjmc != null" >
        LSDJMC = #{lsdjmc,jdbcType=VARCHAR},
      </if>
      <if test="shnd != null" >
        SHND = #{shnd,jdbcType=VARCHAR},
      </if>
      <if test="lsgb != null" >
        LSGB = #{lsgb,jdbcType=VARCHAR},
      </if>
      <if test="lscd != null" >
        LSCD = #{lscd,jdbcType=VARCHAR},
      </if>
      <if test="jylbbm != null" >
        JYLBBM = #{jylbbm,jdbcType=VARCHAR},
      </if>
      <if test="jyrq != null" >
        JYRQ = #{jyrq,jdbcType=TIMESTAMP},
      </if>
      <if test="jyyj != null" >
        JYYJ = #{jyyj,jdbcType=VARCHAR},
      </if>
      <if test="qydbh != null" >
        QYDBH = #{qydbh,jdbcType=VARCHAR},
      </if>
      <if test="ypsldw != null" >
        YPSLDW = #{ypsldw,jdbcType=DECIMAL},
      </if>
      <if test="dbsldw != null" >
        DBSLDW = #{dbsldw,jdbcType=DECIMAL},
      </if>
      <if test="ggxh != null" >
        GGXH = #{ggxh,jdbcType=VARCHAR},
      </if>
      <if test="scrqpc != null" >
        SCRQPC = #{scrqpc,jdbcType=VARCHAR},
      </if>
      <if test="lyfs != null" >
        LYFS = #{lyfs,jdbcType=VARCHAR},
      </if>
      <if test="ypztbs != null" >
        YPZTBS = #{ypztbs,jdbcType=VARCHAR},
      </if>
      <if test="zxcpbzh != null" >
        ZXCPBZH = #{zxcpbzh,jdbcType=VARCHAR},
      </if>
      <if test="jypdyj != null" >
        JYPDYJ = #{jypdyj,jdbcType=VARCHAR},
      </if>
      <if test="checkRemark != null" >
        CHECK_REMARK = #{checkRemark,jdbcType=VARCHAR},
      </if>
      <if test="rknx != null" >
        RKNX = #{rknx,jdbcType=DECIMAL},
      </if>
      <if test="qydd != null" >
        QYDD = #{qydd,jdbcType=VARCHAR},
      </if>
      <if test="qyrbm != null" >
        QYRBM = #{qyrbm,jdbcType=VARCHAR},
      </if>
      <if test="qyrmc != null" >
        QYRMC = #{qyrmc,jdbcType=VARCHAR},
      </if>
      <if test="jyjg != null" >
        JYJG = #{jyjg,jdbcType=VARCHAR},
      </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="zsbm != null" >
        ZSBM = #{zsbm,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 ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyZjxxzbDO" >
    update TY_ZJXXZB
    set ZJBGBH = #{zjbgbh,jdbcType=VARCHAR},
      ZJBGMC = #{zjbgmc,jdbcType=VARCHAR},
      HWBM = #{hwbm,jdbcType=VARCHAR},
      SSAJBH = #{ssajbh,jdbcType=VARCHAR},
      SSAJMC = #{ssajmc,jdbcType=VARCHAR},
      SSCFBH = #{sscfbh,jdbcType=VARCHAR},
      SSCFMC = #{sscfmc,jdbcType=VARCHAR},
      SSKDDM = #{sskddm,jdbcType=VARCHAR},
      SSKDMC = #{sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      WTDWDM = #{wtdwdm,jdbcType=VARCHAR},
      WTDWMC = #{wtdwmc,jdbcType=VARCHAR},
      JYDWDM = #{jydwdm,jdbcType=VARCHAR},
      JYDWMC = #{jydwmc,jdbcType=VARCHAR},
      LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{lsdjmc,jdbcType=VARCHAR},
      SHND = #{shnd,jdbcType=VARCHAR},
      LSGB = #{lsgb,jdbcType=VARCHAR},
      LSCD = #{lscd,jdbcType=VARCHAR},
      JYLBBM = #{jylbbm,jdbcType=VARCHAR},
      JYRQ = #{jyrq,jdbcType=TIMESTAMP},
      JYYJ = #{jyyj,jdbcType=VARCHAR},
      QYDBH = #{qydbh,jdbcType=VARCHAR},
      YPSLDW = #{ypsldw,jdbcType=DECIMAL},
      DBSLDW = #{dbsldw,jdbcType=DECIMAL},
      GGXH = #{ggxh,jdbcType=VARCHAR},
      SCRQPC = #{scrqpc,jdbcType=VARCHAR},
      LYFS = #{lyfs,jdbcType=VARCHAR},
      YPZTBS = #{ypztbs,jdbcType=VARCHAR},
      ZXCPBZH = #{zxcpbzh,jdbcType=VARCHAR},
      JYPDYJ = #{jypdyj,jdbcType=VARCHAR},
      CHECK_REMARK = #{checkRemark,jdbcType=VARCHAR},
      RKNX = #{rknx,jdbcType=DECIMAL},
      QYDD = #{qydd,jdbcType=VARCHAR},
      QYRBM = #{qyrbm,jdbcType=VARCHAR},
      QYRMC = #{qyrmc,jdbcType=VARCHAR},
      JYJG = #{jyjg,jdbcType=VARCHAR},
      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},
      ZSBM = #{zsbm,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},
      ZGZT= #{zgzt,jdbcType=INTEGER},
      
    where ZJXXID = #{zjxxid,jdbcType=VARCHAR}
  </update>
  
  
  <select id="selectAllList" resultMap="BaseResultMap" >
  
  SELECT
    <include refid="Base_Column_List"></include>
    FROM
    TY_ZJXXZB
  
  </select>
  
  
  
</mapper>