<?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.TyLqxxDao" >
  <resultMap id="BaseResultMap" type="com.unis.base.server.entity.TyLqxxDO" >
    <id column="LQID" property="lqid" jdbcType="VARCHAR" />
    <result column="JCSJ" property="jcsj" jdbcType="TIMESTAMP" />
    <result column="HWBM" property="hwbm" jdbcType="VARCHAR" />
    <result column="CFBH" property="cfbh" jdbcType="VARCHAR" />
    <result column="CFMC" property="cfmc" 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="CFWW" property="cfww" jdbcType="DECIMAL" />
    <result column="CFWS" property="cfws" jdbcType="DECIMAL" />
    <result column="CFNW" property="cfnw" jdbcType="DECIMAL" />
    <result column="CFNS" property="cfns" jdbcType="DECIMAL" />
    <result column="CFZGWD" property="cfzgwd" jdbcType="DECIMAL" />
    <result column="CFZDWD" property="cfzdwd" jdbcType="DECIMAL" />
    <result column="CFPJWD" property="cfpjwd" jdbcType="DECIMAL" />
    <result column="CFWDXX" property="cfwdxx" jdbcType="VARCHAR" />
    <result column="CFSDXX" property="cfsdxx" jdbcType="VARCHAR" />
    <result column="CFSFXX" property="cfsfxx" 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" />
  </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" >
    LQID, JCSJ, HWBM, CFBH, CFMC, SSKDDM, SSKDMC, SSQYDM, SSYQMC, CFWW, CFWS, CFNW, CFNS, 
    CFZGWD, CFZDWD, CFPJWD, CFWDXX, CFSDXX, CFSFXX, STATUS, CREATOR, CREATOR_CODE, CREATE_DATE, 
    REFRESHER, REFRESHER_CODE, REFRESH_TIME, REMARK
  </sql>
  <!-- <select id="selectByExample" resultMap="BaseResultMap" parameterType="com.unis.base.server.example.TyLqxxExample" >
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="Base_Column_List" />
    from TY_LQXX
    <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_LQXX
    where LQID = #{lqid,jdbcType=VARCHAR}
  </select> -->

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

  <select id="selectByKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    from TY_LQXX
    where LQID = #{lqid,jdbcType=VARCHAR}
  </select>
  <!-- <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from TY_LQXX
    where LQID = #{lqid,jdbcType=VARCHAR}
  </delete> -->
  <!-- <delete id="deleteByExample" parameterType="com.unis.base.server.example.TyLqxxExample" >
    delete from TY_LQXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </delete> -->
  <insert id="insert" parameterType="com.unis.base.server.entity.TyLqxxDO" >
    insert into TY_LQXX (LQID, JCSJ, HWBM, 
      CFBH, CFMC, SSKDDM, 
      SSKDMC, SSQYDM, SSYQMC, 
      CFWW, CFWS, CFNW, CFNS, 
      CFZGWD, CFZDWD, CFPJWD, 
      CFWDXX, CFSDXX, CFSFXX, 
      STATUS, CREATOR, CREATOR_CODE, 
      CREATE_DATE, REFRESHER, REFRESHER_CODE, 
      REFRESH_TIME, REMARK)
    values (#{lqid,jdbcType=VARCHAR}, #{jcsj,jdbcType=TIMESTAMP}, #{hwbm,jdbcType=VARCHAR}, 
      #{cfbh,jdbcType=VARCHAR}, #{cfmc,jdbcType=VARCHAR}, #{sskddm,jdbcType=VARCHAR}, 
      #{sskdmc,jdbcType=VARCHAR}, #{ssqydm,jdbcType=VARCHAR}, #{ssyqmc,jdbcType=VARCHAR}, 
      #{cfww,jdbcType=DECIMAL}, #{cfws,jdbcType=DECIMAL}, #{cfnw,jdbcType=DECIMAL}, #{cfns,jdbcType=DECIMAL}, 
      #{cfzgwd,jdbcType=DECIMAL}, #{cfzdwd,jdbcType=DECIMAL}, #{cfpjwd,jdbcType=DECIMAL}, 
      #{cfwdxx,jdbcType=VARCHAR}, #{cfsdxx,jdbcType=VARCHAR}, #{cfsfxx,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})
  </insert>
  <insert id="insertSelective" parameterType="com.unis.base.server.entity.TyLqxxDO" >
    insert into TY_LQXX
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="lqid != null" >
        LQID,
      </if>
      <if test="jcsj != null" >
        JCSJ,
      </if>
      <if test="hwbm != null" >
        HWBM,
      </if>
      <if test="cfbh != null" >
        CFBH,
      </if>
      <if test="cfmc != null" >
        CFMC,
      </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="cfww != null" >
        CFWW,
      </if>
      <if test="cfws != null" >
        CFWS,
      </if>
      <if test="cfnw != null" >
        CFNW,
      </if>
      <if test="cfns != null" >
        CFNS,
      </if>
      <if test="cfzgwd != null" >
        CFZGWD,
      </if>
      <if test="cfzdwd != null" >
        CFZDWD,
      </if>
      <if test="cfpjwd != null" >
        CFPJWD,
      </if>
      <if test="cfwdxx != null" >
        CFWDXX,
      </if>
      <if test="cfsdxx != null" >
        CFSDXX,
      </if>
      <if test="cfsfxx != null" >
        CFSFXX,
      </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>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="lqid != null" >
        #{lqid,jdbcType=VARCHAR},
      </if>
      <if test="jcsj != null" >
        #{jcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="hwbm != null" >
        #{hwbm,jdbcType=VARCHAR},
      </if>
      <if test="cfbh != null" >
        #{cfbh,jdbcType=VARCHAR},
      </if>
      <if test="cfmc != null" >
        #{cfmc,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="cfww != null" >
        #{cfww,jdbcType=DECIMAL},
      </if>
      <if test="cfws != null" >
        #{cfws,jdbcType=DECIMAL},
      </if>
      <if test="cfnw != null" >
        #{cfnw,jdbcType=DECIMAL},
      </if>
      <if test="cfns != null" >
        #{cfns,jdbcType=DECIMAL},
      </if>
      <if test="cfzgwd != null" >
        #{cfzgwd,jdbcType=DECIMAL},
      </if>
      <if test="cfzdwd != null" >
        #{cfzdwd,jdbcType=DECIMAL},
      </if>
      <if test="cfpjwd != null" >
        #{cfpjwd,jdbcType=DECIMAL},
      </if>
      <if test="cfwdxx != null" >
        #{cfwdxx,jdbcType=VARCHAR},
      </if>
      <if test="cfsdxx != null" >
        #{cfsdxx,jdbcType=VARCHAR},
      </if>
      <if test="cfsfxx != null" >
        #{cfsfxx,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>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.unis.base.server.example.TyLqxxExample" resultType="java.lang.Integer" >
    select count(1) from TY_LQXX
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <!-- <update id="updateByExampleSelective" parameterType="map" >
    update TY_LQXX
    <set >
      <if test="record.lqid != null" >
        LQID = #{record.lqid,jdbcType=VARCHAR},
      </if>
      <if test="record.jcsj != null" >
        JCSJ = #{record.jcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="record.hwbm != null" >
        HWBM = #{record.hwbm,jdbcType=VARCHAR},
      </if>
      <if test="record.cfbh != null" >
        CFBH = #{record.cfbh,jdbcType=VARCHAR},
      </if>
      <if test="record.cfmc != null" >
        CFMC = #{record.cfmc,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.cfww != null" >
        CFWW = #{record.cfww,jdbcType=DECIMAL},
      </if>
      <if test="record.cfws != null" >
        CFWS = #{record.cfws,jdbcType=DECIMAL},
      </if>
      <if test="record.cfnw != null" >
        CFNW = #{record.cfnw,jdbcType=DECIMAL},
      </if>
      <if test="record.cfns != null" >
        CFNS = #{record.cfns,jdbcType=DECIMAL},
      </if>
      <if test="record.cfzgwd != null" >
        CFZGWD = #{record.cfzgwd,jdbcType=DECIMAL},
      </if>
      <if test="record.cfzdwd != null" >
        CFZDWD = #{record.cfzdwd,jdbcType=DECIMAL},
      </if>
      <if test="record.cfpjwd != null" >
        CFPJWD = #{record.cfpjwd,jdbcType=DECIMAL},
      </if>
      <if test="record.cfwdxx != null" >
        CFWDXX = #{record.cfwdxx,jdbcType=VARCHAR},
      </if>
      <if test="record.cfsdxx != null" >
        CFSDXX = #{record.cfsdxx,jdbcType=VARCHAR},
      </if>
      <if test="record.cfsfxx != null" >
        CFSFXX = #{record.cfsfxx,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_LQXX
    set LQID = #{record.lqid,jdbcType=VARCHAR},
      JCSJ = #{record.jcsj,jdbcType=TIMESTAMP},
      HWBM = #{record.hwbm,jdbcType=VARCHAR},
      CFBH = #{record.cfbh,jdbcType=VARCHAR},
      CFMC = #{record.cfmc,jdbcType=VARCHAR},
      SSKDDM = #{record.sskddm,jdbcType=VARCHAR},
      SSKDMC = #{record.sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{record.ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{record.ssyqmc,jdbcType=VARCHAR},
      CFWW = #{record.cfww,jdbcType=DECIMAL},
      CFWS = #{record.cfws,jdbcType=DECIMAL},
      CFNW = #{record.cfnw,jdbcType=DECIMAL},
      CFNS = #{record.cfns,jdbcType=DECIMAL},
      CFZGWD = #{record.cfzgwd,jdbcType=DECIMAL},
      CFZDWD = #{record.cfzdwd,jdbcType=DECIMAL},
      CFPJWD = #{record.cfpjwd,jdbcType=DECIMAL},
      CFWDXX = #{record.cfwdxx,jdbcType=VARCHAR},
      CFSDXX = #{record.cfsdxx,jdbcType=VARCHAR},
      CFSFXX = #{record.cfsfxx,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.TyLqxxDO" >
    update TY_LQXX
    <set >
      <if test="jcsj != null" >
        JCSJ = #{jcsj,jdbcType=TIMESTAMP},
      </if>
      <if test="hwbm != null" >
        HWBM = #{hwbm,jdbcType=VARCHAR},
      </if>
      <if test="cfbh != null" >
        CFBH = #{cfbh,jdbcType=VARCHAR},
      </if>
      <if test="cfmc != null" >
        CFMC = #{cfmc,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="cfww != null" >
        CFWW = #{cfww,jdbcType=DECIMAL},
      </if>
      <if test="cfws != null" >
        CFWS = #{cfws,jdbcType=DECIMAL},
      </if>
      <if test="cfnw != null" >
        CFNW = #{cfnw,jdbcType=DECIMAL},
      </if>
      <if test="cfns != null" >
        CFNS = #{cfns,jdbcType=DECIMAL},
      </if>
      <if test="cfzgwd != null" >
        CFZGWD = #{cfzgwd,jdbcType=DECIMAL},
      </if>
      <if test="cfzdwd != null" >
        CFZDWD = #{cfzdwd,jdbcType=DECIMAL},
      </if>
      <if test="cfpjwd != null" >
        CFPJWD = #{cfpjwd,jdbcType=DECIMAL},
      </if>
      <if test="cfwdxx != null" >
        CFWDXX = #{cfwdxx,jdbcType=VARCHAR},
      </if>
      <if test="cfsdxx != null" >
        CFSDXX = #{cfsdxx,jdbcType=VARCHAR},
      </if>
      <if test="cfsfxx != null" >
        CFSFXX = #{cfsfxx,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 LQID = #{lqid,jdbcType=VARCHAR}
  </update> -->
  <update id="updateByPrimaryKey" parameterType="com.unis.base.server.entity.TyLqxxDO" >
    update TY_LQXX
    set JCSJ = #{jcsj,jdbcType=TIMESTAMP},
      HWBM = #{hwbm,jdbcType=VARCHAR},
      CFBH = #{cfbh,jdbcType=VARCHAR},
      CFMC = #{cfmc,jdbcType=VARCHAR},
      SSKDDM = #{sskddm,jdbcType=VARCHAR},
      SSKDMC = #{sskdmc,jdbcType=VARCHAR},
      SSQYDM = #{ssqydm,jdbcType=VARCHAR},
      SSYQMC = #{ssyqmc,jdbcType=VARCHAR},
      CFWW = #{cfww,jdbcType=DECIMAL},
      CFWS = #{cfws,jdbcType=DECIMAL},
      CFNW = #{cfnw,jdbcType=DECIMAL},
      CFNS = #{cfns,jdbcType=DECIMAL},
      CFZGWD = #{cfzgwd,jdbcType=DECIMAL},
      CFZDWD = #{cfzdwd,jdbcType=DECIMAL},
      CFPJWD = #{cfpjwd,jdbcType=DECIMAL},
      CFWDXX = #{cfwdxx,jdbcType=VARCHAR},
      CFSDXX = #{cfsdxx,jdbcType=VARCHAR},
      CFSFXX = #{cfsfxx,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}
    where LQID = #{lqid,jdbcType=VARCHAR}
  </update>
</mapper>