<?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.TyLskcxxDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyLskcxxDO" >
    <id column="KCXXID" property="kcxxid" 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="SSYDDM" property="ssyddm" jdbcType="VARCHAR" />
    <result column="SSYQMC" property="ssyqmc" jdbcType="VARCHAR" />
    <result column="LSPZBM" property="lspzbm" jdbcType="VARCHAR" />
    <result column="LSPZMC" property="lspzmc" jdbcType="VARCHAR" />
    <result column="LSND" property="lsnd" jdbcType="VARCHAR" />
    <result column="CCQJ" property="ccqj" jdbcType="VARCHAR" />
    <result column="PZBM" property="pzbm" jdbcType="VARCHAR" />
    <result column="LSXZBM" property="lsxzbm" jdbcType="VARCHAR" />
    <result column="LSXZMC" property="lsxzmc" jdbcType="VARCHAR" />
    <result column="LSCCFSBM" property="lsccfsbm" jdbcType="VARCHAR" />
    <result column="LSCCFSMC" property="lsccfsmc" jdbcType="VARCHAR" />
    <result column="RKSJ" property="rksj" jdbcType="TIMESTAMP" />
    <result column="CZHDDJ" property="czhddj" 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="BGYBM" property="bgybm" jdbcType="VARCHAR" />
    <result column="BGYMC" property="bgymc" jdbcType="VARCHAR" />
    <result column="LQGSDWBM" property="lqgsdwbm" jdbcType="VARCHAR" />
    <result column="LQGSDWMC" property="lqgsdwmc" jdbcType="VARCHAR" />
    <result column="FCSJ" property="fcsj" jdbcType="TIMESTAMP" />
    <result column="FCSL" property="fcsl" jdbcType="DECIMAL" />
    <result column="QCSJ" property="qcsj" jdbcType="TIMESTAMP" />
    <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="SSCFBH_OUT" property="sscfbhOut" jdbcType="VARCHAR" />
    <result column="SSKDDM_OUT" property="sskddmOut" 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" >
    KCXXID, HWBM, SSAJBH, SSAJMC, SSCFBH, SSCFMC, SSKDDM, SSKDMC, SSYDDM, SSYQMC, LSPZBM, 
    LSPZMC, LSND, CCQJ, PZBM, LSXZBM, LSXZMC, LSCCFSBM, LSCCFSMC, RKSJ, CZHDDJ, LSDJBM, LSDJMC, SHND, LSGB, 
    LSCD, BGYBM, BGYMC, LQGSDWBM, LQGSDWMC, FCSJ, FCSL, QCSJ, STATUS, CREATOR, CREATOR_CODE, 
    CREATE_DATE, REFRESHER, REFRESHER_CODE, REFRESH_TIME, REMARK
  </sql>
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyLskcxxExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_LSKCXX
    <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_LSKCXX
    where KCXXID = #{kcxxid,jdbcType=VARCHAR}
  </select> -->

  <!-- 根据信息获取唯一仓房 -->
  <select id="selectById" resultMap="BaseResultMap">
    SELECT
    <include refid="Base_Column_List"></include>
    from TY_LSKCXX
    <where>
      <choose>
        <when test='kcxxid!=null and kcxxid!=""'>
          AND kcxxid = #{kcxxid,jdbcType=VARCHAR}
        </when>
        <when test='sscfbh!=null and sscfbh!=""'>
          AND sscfbh = #{sscfbh,jdbcType=VARCHAR}
        </when>
        <when test='sscfbhOut!=null and sscfbhOut!=""'>
          AND SSCFBH_OUT = #{sscfbhOut,jdbcType=VARCHAR}
        </when>
        <when test='hwbm!=null and hwbm!=""'>
          AND hwbm = #{hwbm,jdbcType=VARCHAR}
        </when>
        <otherwise>
          AND 1=0
        </otherwise>
      </choose>
      and status = 1
    </where>
  </select>

  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_LSKCXX
    where KCXXID = #{kcxxid,jdbcType=VARCHAR}
  </select>

  <!--查询截止时间前的粮食库存信息-->
  <select id="selectLastestByEntity" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from TY_LSKCXX
    <where>
      <if test="sskddm!=null and sskddm!=''">
        AND SSKDDM = #{sskddm,jdbcType=VARCHAR}
      </if>
      <if test="ssyddm!=null and ssyddm!=''">
        AND SSYDDM = #{ssyddm,jdbcType=VARCHAR}
      </if>
      <if test="lspzbm!=null and lspzbm!=''">
        AND LSPZBM = #{lspzbm,jdbcType=VARCHAR}
      </if>
      <if test="sscfbh!=null and sscfbh!=''">
        AND SSCFBH = #{sscfbh,jdbcType=VARCHAR}
      </if>
      <if test="rksj!=null">
        <![CDATA[
          AND RKSJ <= #{rksj,jdbcType=TIMESTAMP}
        ]]>
      </if>
    </where>
    order by rksj desc
  </select>

  <select id="selectByQueryVO" parameterType="com.unis.base.common.vo.TyLskcxxQueryVO" resultMap="BaseResultMap">
    SELECT <include refid="Base_Column_List"/>
    FROM TY_LSKCXX
    WHERE 1=1
    <if test=' ssyqmc != null and ssyqmc != "" '>
      AND ssyqmc LIKE concat(CONCAT('%',#{ssyqmc}),'%')
    </if>
    <if test=" sscfbhArr != null and sscfbhArr.length > 0 ">
      AND sscfbh in
      <foreach collection="sscfbhArr" item="sscfbh" index="index"  open="(" close=")" separator=",">
        #{sscfbh}
      </foreach>
    </if>
    
    
     <if test=' sscfmc != null and sscfmc != "" '>
      AND sscfmc LIKE concat(CONCAT('%',#{sscfmc}),'%')
    </if>

    <if test=' sskddm != null and sskddm != "" '>
      AND sskddm LIKE concat(CONCAT('%',#{sskddm}),'%')
    </if>
    
    <if test=" lspzbmArr != null and lspzbmArr.length > 0 ">
      AND lspzbm in
      <foreach collection="lspzbmArr" item="lspzbm" index="index" open="(" close=")" separator=",">
        #{lspzbm}
      </foreach>
    </if>
    
     <if test=' lspzmc != null and lspzmc != "" '>
      AND lspzmc LIKE concat(CONCAT('%',#{lspzmc}),'%')
    </if> 
    
    <if test=' lsnd != null and lsnd != "" '>
      AND lsnd LIKE concat(CONCAT('%',#{lsnd,jdbcType=VARCHAR}),'%')
    </if>
    <if test=' lsdjbm != null and lsdjbm != "" '>
      AND lsdjbm LIKE concat(CONCAT('%',#{lsdjbm,jdbcType=VARCHAR}),'%')
    </if>
    <if test=' lscd != null and lscd != "" '>
      AND lscd LIKE concat(CONCAT('%',#{lscd,jdbcType=VARCHAR}),'%')
    </if>
    <if test=' lsgb != null and lsgb != "" '>
      AND lsgb = #{lsgb,jdbcType=VARCHAR}
    </if>
    <if test=" startNum != null and endNum != null">
      AND fcsl BETWEEN #{startNum,jdbcType=INTEGER} AND #{endNum,jdbcType=INTEGER}
    </if>
  </select>

  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_LSKCXX
    where KCXXID = #{kcxxid,jdbcType=VARCHAR}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyLskcxxExample" >
    delete from TY_LSKCXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyLskcxxDO" >
    insert into TY_LSKCXX (KCXXID, HWBM, SSAJBH, 
      SSAJMC, SSCFBH, SSCFMC, 
      SSKDDM, SSKDMC, SSYDDM, 
      SSYQMC, LSPZBM, LSPZMC, 
      LSND, CCQJ, PZBM, LSXZBM, 
      LSXZMC, LSCCFSBM, LSCCFSMC, RKSJ, CZHDDJ, 
      LSDJBM, LSDJMC, SHND, 
      LSGB, LSCD, BGYBM, 
      BGYMC, LQGSDWBM, LQGSDWMC, 
      FCSJ, FCSL, QCSJ, 
      STATUS, CREATOR, CREATOR_CODE, 
      CREATE_DATE, REFRESHER, REFRESHER_CODE, 
      REFRESH_TIME, REMARK,SSCFBH_OUT,SSKDDM_OUT)
    values (#{kcxxid,jdbcType=VARCHAR}, #{hwbm,jdbcType=VARCHAR}, #{ssajbh,jdbcType=VARCHAR}, 
      #{ssajmc,jdbcType=VARCHAR}, #{sscfbh,jdbcType=VARCHAR}, #{sscfmc,jdbcType=VARCHAR}, 
      #{sskddm,jdbcType=VARCHAR}, #{sskdmc,jdbcType=VARCHAR}, #{ssyddm,jdbcType=VARCHAR}, 
      #{ssyqmc,jdbcType=VARCHAR}, #{lspzbm,jdbcType=VARCHAR}, #{lspzmc,jdbcType=VARCHAR}, 
      #{lsnd,jdbcType=VARCHAR}, #{ccqj,jdbcType=VARCHAR}, #{pzbm,jdbcType=VARCHAR}, #{lsxzbm,jdbcType=VARCHAR}, 
      #{lsxzmc,jdbcType=VARCHAR}, #{lsccfsbm,jdbcType=VARCHAR}, #{lsccfsmc,jdbcType=VARCHAR}, #{rksj,jdbcType=TIMESTAMP}, 
      #{czhddj,jdbcType=VARCHAR}, #{lsdjbm,jdbcType=VARCHAR}, #{lsdjmc,jdbcType=VARCHAR}, #{shnd,jdbcType=VARCHAR}, 
      #{lsgb,jdbcType=VARCHAR}, #{lscd,jdbcType=VARCHAR}, #{bgybm,jdbcType=VARCHAR}, 
      #{bgymc,jdbcType=VARCHAR}, #{lqgsdwbm,jdbcType=VARCHAR}, #{lqgsdwmc,jdbcType=VARCHAR}, 
      #{fcsj,jdbcType=TIMESTAMP}, #{fcsl,jdbcType=DECIMAL}, #{qcsj,jdbcType=TIMESTAMP}, 
      #{status,jdbcType=DECIMAL}, #{creator,jdbcType=VARCHAR}, #{creatorCode,jdbcType=VARCHAR}, 
      #{createDate,jdbcType=TIMESTAMP}, #{refresher,jdbcType=VARCHAR}, #{refresherCode,jdbcType=VARCHAR},
      #{refreshTime,jdbcType=TIMESTAMP}, #{remark,jdbcType=VARCHAR}
      , #{sscfbhOut,jdbcType=VARCHAR}, #{sskddmOut,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyLskcxxDO" >
    insert into TY_LSKCXX
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="kcxxid != null" >
        KCXXID,
      </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="ssyddm != null" >
        SSYDDM,
      </if>
      <if test="ssyqmc != null" >
        SSYQMC,
      </if>
      <if test="lspzbm != null" >
        LSPZBM,
      </if>
      <if test="lspzmc != null" >
        LSPZMC,
      </if>
      <if test="lsnd != null" >
        LSND,
      </if>
      <if test="ccqj != null" >
        CCQJ,
      </if>
      <if test="pzbm != null" >
        PZBM,
      </if>
      <if test="lsxzbm != null" >
        LSXZBM,
      </if>
      <if test="lsxzmc != null" >
        LSXZMC,
      </if>
      <if test="lsccfsbm != null" >
        LSCCFSBM,
      </if>
      <if test="lsccfsmc != null" >
        LSCCFSMC,
      </if>
      <if test="rksj != null" >
        RKSJ,
      </if>
      <if test="czhddj != null" >
        CZHDDJ,
      </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="bgybm != null" >
        BGYBM,
      </if>
      <if test="bgymc != null" >
        BGYMC,
      </if>
      <if test="lqgsdwbm != null" >
        LQGSDWBM,
      </if>
      <if test="lqgsdwmc != null" >
        LQGSDWMC,
      </if>
      <if test="fcsj != null" >
        FCSJ,
      </if>
      <if test="fcsl != null" >
        FCSL,
      </if>
      <if test="qcsj != null" >
        QCSJ,
      </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="remark != null" >
        SSCFBH_OUT,
      </if>
      <if test="remark != null" >
        SSKDDM_OUT,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="kcxxid != null" >
        #{kcxxid,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="ssyddm != null" >
        #{ssyddm,jdbcType=VARCHAR},
      </if>
      <if test="ssyqmc != null" >
        #{ssyqmc,jdbcType=VARCHAR},
      </if>
      <if test="lspzbm != null" >
        #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsnd != null" >
        #{lsnd,jdbcType=VARCHAR},
      </if>
      <if test="ccqj != null" >
        #{ccqj,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzbm != null" >
        #{lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzmc != null" >
        #{lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsccfsbm != null" >
        #{lsccfsbm,jdbcType=VARCHAR},
      </if>
      <if test="lsccfsmc != null" >
        #{lsccfsmc,jdbcType=VARCHAR},
      </if>
      <if test="rksj != null" >
        #{rksj,jdbcType=TIMESTAMP},
      </if>
      <if test="czhddj != null" >
        #{czhddj,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="bgybm != null" >
        #{bgybm,jdbcType=VARCHAR},
      </if>
      <if test="bgymc != null" >
        #{bgymc,jdbcType=VARCHAR},
      </if>
      <if test="lqgsdwbm != null" >
        #{lqgsdwbm,jdbcType=VARCHAR},
      </if>
      <if test="lqgsdwmc != null" >
        #{lqgsdwmc,jdbcType=VARCHAR},
      </if>
      <if test="fcsj != null" >
        #{fcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="fcsl != null" >
        #{fcsl,jdbcType=DECIMAL},
      </if>
      <if test="qcsj != null" >
        #{qcsj,jdbcType=TIMESTAMP},
      </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="sscfbhOut != null" >
        #{sscfbhOut,jdbcType=VARCHAR},
      </if>
      <if test="sskddmOut != null" >
        #{sskddmOut,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyLskcxxExample" resultType="java.lang.Integer" >
    select count(1) from TY_LSKCXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_LSKCXX
    <set >
      <if test="record.kcxxid != null" >
        KCXXID = #{record.kcxxid,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.ssyddm != null" >
        SSYDDM = #{record.ssyddm,jdbcType=VARCHAR},
      </if>
      <if test="record.ssyqmc != null" >
        SSYQMC = #{record.ssyqmc,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.lsnd != null" >
        LSND = #{record.lsnd,jdbcType=VARCHAR},
      </if>
      <if test="record.ccqj != null" >
        CCQJ = #{record.ccqj,jdbcType=VARCHAR},
      </if>
      <if test="record.pzbm != null" >
        PZBM = #{record.pzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lsxzbm != null" >
        LSXZBM = #{record.lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lsxzmc != null" >
        LSXZMC = #{record.lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="record.rksj != null" >
        RKSJ = #{record.rksj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.czhddj != null" >
        CZHDDJ = #{record.czhddj,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.bgybm != null" >
        BGYBM = #{record.bgybm,jdbcType=VARCHAR},
      </if>
      <if test="record.bgymc != null" >
        BGYMC = #{record.bgymc,jdbcType=VARCHAR},
      </if>
      <if test="record.lqgsdwbm != null" >
        LQGSDWBM = #{record.lqgsdwbm,jdbcType=VARCHAR},
      </if>
      <if test="record.lqgsdwmc != null" >
        LQGSDWMC = #{record.lqgsdwmc,jdbcType=VARCHAR},
      </if>
      <if test="record.fcsj != null" >
        FCSJ = #{record.fcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.fcsl != null" >
        FCSL = #{record.fcsl,jdbcType=DECIMAL},
      </if>
      <if test="record.qcsj != null" >
        QCSJ = #{record.qcsj,jdbcType=TIMESTAMP},
      </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_LSKCXX
    set KCXXID = #{record.kcxxid,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},
      SSYDDM = #{record.ssyddm,jdbcType=VARCHAR},
      SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      LSPZBM = #{record.lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{record.lspzmc,jdbcType=VARCHAR},
      LSND = #{record.lsnd,jdbcType=VARCHAR},
      CCQJ = #{record.ccqj,jdbcType=VARCHAR},
      PZBM = #{record.pzbm,jdbcType=VARCHAR},
      LSXZBM = #{record.lsxzbm,jdbcType=VARCHAR},
      LSXZMC = #{record.lsxzmc,jdbcType=VARCHAR},
      RKSJ = #{record.rksj,jdbcType=TIMESTAMP},
      CZHDDJ = #{record.czhddj,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},
      BGYBM = #{record.bgybm,jdbcType=VARCHAR},
      BGYMC = #{record.bgymc,jdbcType=VARCHAR},
      LQGSDWBM = #{record.lqgsdwbm,jdbcType=VARCHAR},
      LQGSDWMC = #{record.lqgsdwmc,jdbcType=VARCHAR},
      FCSJ = #{record.fcsj,jdbcType=TIMESTAMP},
      FCSL = #{record.fcsl,jdbcType=DECIMAL},
      QCSJ = #{record.qcsj,jdbcType=TIMESTAMP},
      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.TyLskcxxDO" >
    update TY_LSKCXX
    <set >
      <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="ssyddm != null" >
        SSYDDM = #{ssyddm,jdbcType=VARCHAR},
      </if>
      <if test="ssyqmc != null" >
        SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      </if>
      <if test="lspzbm != null" >
        LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      </if>
      <if test="lspzmc != null" >
        LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      </if>
      <if test="lsnd != null" >
        LSND = #{lsnd,jdbcType=VARCHAR},
      </if>
      <if test="ccqj != null" >
        CCQJ = #{ccqj,jdbcType=VARCHAR},
      </if>
      <if test="pzbm != null" >
        PZBM = #{pzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzbm != null" >
        LSXZBM = #{lsxzbm,jdbcType=VARCHAR},
      </if>
      <if test="lsxzmc != null" >
        LSXZMC = #{lsxzmc,jdbcType=VARCHAR},
      </if>
      <if test="rksj != null" >
        RKSJ = #{rksj,jdbcType=TIMESTAMP},
      </if>
      <if test="czhddj != null" >
        CZHDDJ = #{czhddj,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="bgybm != null" >
        BGYBM = #{bgybm,jdbcType=VARCHAR},
      </if>
      <if test="bgymc != null" >
        BGYMC = #{bgymc,jdbcType=VARCHAR},
      </if>
      <if test="lqgsdwbm != null" >
        LQGSDWBM = #{lqgsdwbm,jdbcType=VARCHAR},
      </if>
      <if test="lqgsdwmc != null" >
        LQGSDWMC = #{lqgsdwmc,jdbcType=VARCHAR},
      </if>
      <if test="fcsj != null" >
        FCSJ = #{fcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="fcsl != null" >
        FCSL = #{fcsl,jdbcType=DECIMAL},
      </if>
      <if test="qcsj != null" >
        QCSJ = #{qcsj,jdbcType=TIMESTAMP},
      </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 KCXXID = #{kcxxid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyLskcxxDO" >
    update TY_LSKCXX
    set 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},
      SSYDDM = #{ssyddm,jdbcType=VARCHAR},
      SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      LSPZBM = #{lspzbm,jdbcType=VARCHAR},
      LSPZMC = #{lspzmc,jdbcType=VARCHAR},
      LSND = #{lsnd,jdbcType=VARCHAR},
      CCQJ = #{ccqj,jdbcType=VARCHAR},
      PZBM = #{pzbm,jdbcType=VARCHAR},
      LSXZBM = #{lsxzbm,jdbcType=VARCHAR},
      LSXZMC = #{lsxzmc,jdbcType=VARCHAR},
      LSCCFSBM = #{lsccfsbm,jdbcType=VARCHAR},
      LSCCFSMC = #{lsccfsmc,jdbcType=VARCHAR},
      RKSJ = #{rksj,jdbcType=TIMESTAMP},
      CZHDDJ = #{czhddj,jdbcType=VARCHAR},
      LSDJBM = #{lsdjbm,jdbcType=VARCHAR},
      LSDJMC = #{lsdjmc,jdbcType=VARCHAR},
      SHND = #{shnd,jdbcType=VARCHAR},
      LSGB = #{lsgb,jdbcType=VARCHAR},
      LSCD = #{lscd,jdbcType=VARCHAR},
      BGYBM = #{bgybm,jdbcType=VARCHAR},
      BGYMC = #{bgymc,jdbcType=VARCHAR},
      LQGSDWBM = #{lqgsdwbm,jdbcType=VARCHAR},
      LQGSDWMC = #{lqgsdwmc,jdbcType=VARCHAR},
      FCSJ = #{fcsj,jdbcType=TIMESTAMP},
      FCSL = #{fcsl,jdbcType=DECIMAL},
      QCSJ = #{qcsj,jdbcType=TIMESTAMP},
      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}
    where KCXXID = #{kcxxid,jdbcType=VARCHAR}
  </update>
</mapper>