<?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.bailuntec.mapper.DcBaseFinanceCashierMapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="code" jdbcType="VARCHAR" property="code" />
    <result column="apply_id" jdbcType="VARCHAR" property="applyId" />
    <result column="detail_name" jdbcType="VARCHAR" property="detailName" />
    <result column="cashier_type" jdbcType="TINYINT" property="cashierType" />
    <result column="type_name" jdbcType="VARCHAR" property="typeName" />
    <result column="companymain_value_from" jdbcType="INTEGER" property="companymainValueFrom" />
    <result column="companymain_name_from" jdbcType="VARCHAR" property="companymainNameFrom" />
    <result column="unit_code" jdbcType="VARCHAR" property="unitCode" />
    <result column="unit_name" jdbcType="VARCHAR" property="unitName" />
    <result column="paymoney" jdbcType="DECIMAL" property="paymoney" />
    <result column="paymoney_rmb" jdbcType="DECIMAL" property="paymoneyRmb" />
    <result column="payday" jdbcType="INTEGER" property="payday" />
    <result column="expect_paytime" jdbcType="TIMESTAMP" property="expectPaytime" />
    <result column="tradeb_bjecttype" jdbcType="TINYINT" property="tradebBjecttype" />
    <result column="tradeb_bjectid" jdbcType="INTEGER" property="tradebBjectid" />
    <result column="tradeb_bjectname" jdbcType="VARCHAR" property="tradebBjectname" />
    <result column="bankaccountid_to" jdbcType="INTEGER" property="bankaccountidTo" />
    <result column="bankcard_to" jdbcType="VARCHAR" property="bankcardTo" />
    <result column="bankname_to" jdbcType="VARCHAR" property="banknameTo" />
    <result column="bankcarduser_to" jdbcType="VARCHAR" property="bankcarduserTo" />
    <result column="applyremark" jdbcType="VARCHAR" property="applyremark" />
    <result column="cashier_callbackstatus" jdbcType="TINYINT" property="cashierCallbackstatus" />
    <result column="sourcecode" jdbcType="VARCHAR" property="sourcecode" />
    <result column="sourcename" jdbcType="VARCHAR" property="sourcename" />
    <result column="cashier_status" jdbcType="TINYINT" property="cashierStatus" />
    <result column="pay_type" jdbcType="INTEGER" property="payType" />
    <result column="cashier_userid" jdbcType="INTEGER" property="cashierUserid" />
    <result column="cashier_username" jdbcType="VARCHAR" property="cashierUsername" />
    <result column="cashier_time" jdbcType="TIMESTAMP" property="cashierTime" />
    <result column="cashier_remark" jdbcType="VARCHAR" property="cashierRemark" />
    <result column="cashier_bankaccountid" jdbcType="INTEGER" property="cashierBankaccountid" />
    <result column="cashier_bankname" jdbcType="VARCHAR" property="cashierBankname" />
    <result column="cashier_bankcard" jdbcType="VARCHAR" property="cashierBankcard" />
    <result column="cashier_bankcardname" jdbcType="VARCHAR" property="cashierBankcardname" />
    <result column="cashier_unitcode" jdbcType="VARCHAR" property="cashierUnitcode" />
    <result column="cashier_unitname" jdbcType="VARCHAR" property="cashierUnitname" />
    <result column="cashier_rate" jdbcType="DECIMAL" property="cashierRate" />
    <result column="cashier_paymoney" jdbcType="DECIMAL" property="cashierPaymoney" />
    <result column="cashier_paymoneyrmb" jdbcType="DECIMAL" property="cashierPaymoneyrmb" />
    <result column="isquestion" jdbcType="BIT" property="isquestion" />
    <result column="question_remark" jdbcType="VARCHAR" property="questionRemark" />
    <result column="taobao_order_no" jdbcType="VARCHAR" property="taobaoOrderNo" />
    <result column="otherorder_code" jdbcType="VARCHAR" property="otherorderCode" />
    <result column="create_userid" jdbcType="INTEGER" property="createUserid" />
    <result column="create_username" jdbcType="VARCHAR" property="createUsername" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="modify_userid" jdbcType="INTEGER" property="modifyUserid" />
    <result column="modify_username" jdbcType="VARCHAR" property="modifyUsername" />
    <result column="modify_time" jdbcType="TIMESTAMP" property="modifyTime" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <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 close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <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 close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    id, code, apply_id, detail_name, cashier_type, type_name, companymain_value_from, 
    companymain_name_from, unit_code, unit_name, paymoney, paymoney_rmb, payday, expect_paytime, 
    tradeb_bjecttype, tradeb_bjectid, tradeb_bjectname, bankaccountid_to, bankcard_to, 
    bankname_to, bankcarduser_to, applyremark, cashier_callbackstatus, sourcecode, sourcename, 
    cashier_status, pay_type, cashier_userid, cashier_username, cashier_time, cashier_remark, 
    cashier_bankaccountid, cashier_bankname, cashier_bankcard, cashier_bankcardname, 
    cashier_unitcode, cashier_unitname, cashier_rate, cashier_paymoney, cashier_paymoneyrmb, 
    isquestion, question_remark, taobao_order_no, otherorder_code, create_userid, create_username, 
    create_time, modify_userid, modify_username, modify_time
  </sql>
  <select id="selectByExample" parameterType="com.bailuntec.domain.example.DcBaseFinanceCashierExample" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from dc_base_finance_cashier
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    <if test="rows != null">
      <if test="offset != null">
        limit ${offset}, ${rows}
      </if>
      <if test="offset == null">
        limit ${rows}
      </if>
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    from dc_base_finance_cashier
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_finance_cashier
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.DcBaseFinanceCashierExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_finance_cashier
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_finance_cashier (id, code, apply_id, 
      detail_name, cashier_type, type_name, 
      companymain_value_from, companymain_name_from, 
      unit_code, unit_name, paymoney, 
      paymoney_rmb, payday, expect_paytime, 
      tradeb_bjecttype, tradeb_bjectid, tradeb_bjectname, 
      bankaccountid_to, bankcard_to, bankname_to, 
      bankcarduser_to, applyremark, cashier_callbackstatus, 
      sourcecode, sourcename, cashier_status, 
      pay_type, cashier_userid, cashier_username, 
      cashier_time, cashier_remark, cashier_bankaccountid, 
      cashier_bankname, cashier_bankcard, cashier_bankcardname, 
      cashier_unitcode, cashier_unitname, cashier_rate, 
      cashier_paymoney, cashier_paymoneyrmb, isquestion, 
      question_remark, taobao_order_no, otherorder_code, 
      create_userid, create_username, create_time, 
      modify_userid, modify_username, modify_time
      )
    values (#{id,jdbcType=INTEGER}, #{code,jdbcType=VARCHAR}, #{applyId,jdbcType=VARCHAR}, 
      #{detailName,jdbcType=VARCHAR}, #{cashierType,jdbcType=TINYINT}, #{typeName,jdbcType=VARCHAR}, 
      #{companymainValueFrom,jdbcType=INTEGER}, #{companymainNameFrom,jdbcType=VARCHAR}, 
      #{unitCode,jdbcType=VARCHAR}, #{unitName,jdbcType=VARCHAR}, #{paymoney,jdbcType=DECIMAL}, 
      #{paymoneyRmb,jdbcType=DECIMAL}, #{payday,jdbcType=INTEGER}, #{expectPaytime,jdbcType=TIMESTAMP}, 
      #{tradebBjecttype,jdbcType=TINYINT}, #{tradebBjectid,jdbcType=INTEGER}, #{tradebBjectname,jdbcType=VARCHAR}, 
      #{bankaccountidTo,jdbcType=INTEGER}, #{bankcardTo,jdbcType=VARCHAR}, #{banknameTo,jdbcType=VARCHAR}, 
      #{bankcarduserTo,jdbcType=VARCHAR}, #{applyremark,jdbcType=VARCHAR}, #{cashierCallbackstatus,jdbcType=TINYINT}, 
      #{sourcecode,jdbcType=VARCHAR}, #{sourcename,jdbcType=VARCHAR}, #{cashierStatus,jdbcType=TINYINT}, 
      #{payType,jdbcType=INTEGER}, #{cashierUserid,jdbcType=INTEGER}, #{cashierUsername,jdbcType=VARCHAR}, 
      #{cashierTime,jdbcType=TIMESTAMP}, #{cashierRemark,jdbcType=VARCHAR}, #{cashierBankaccountid,jdbcType=INTEGER}, 
      #{cashierBankname,jdbcType=VARCHAR}, #{cashierBankcard,jdbcType=VARCHAR}, #{cashierBankcardname,jdbcType=VARCHAR}, 
      #{cashierUnitcode,jdbcType=VARCHAR}, #{cashierUnitname,jdbcType=VARCHAR}, #{cashierRate,jdbcType=DECIMAL}, 
      #{cashierPaymoney,jdbcType=DECIMAL}, #{cashierPaymoneyrmb,jdbcType=DECIMAL}, #{isquestion,jdbcType=BIT}, 
      #{questionRemark,jdbcType=VARCHAR}, #{taobaoOrderNo,jdbcType=VARCHAR}, #{otherorderCode,jdbcType=VARCHAR}, 
      #{createUserid,jdbcType=INTEGER}, #{createUsername,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, 
      #{modifyUserid,jdbcType=INTEGER}, #{modifyUsername,jdbcType=VARCHAR}, #{modifyTime,jdbcType=TIMESTAMP}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_finance_cashier
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="code != null">
        code,
      </if>
      <if test="applyId != null">
        apply_id,
      </if>
      <if test="detailName != null">
        detail_name,
      </if>
      <if test="cashierType != null">
        cashier_type,
      </if>
      <if test="typeName != null">
        type_name,
      </if>
      <if test="companymainValueFrom != null">
        companymain_value_from,
      </if>
      <if test="companymainNameFrom != null">
        companymain_name_from,
      </if>
      <if test="unitCode != null">
        unit_code,
      </if>
      <if test="unitName != null">
        unit_name,
      </if>
      <if test="paymoney != null">
        paymoney,
      </if>
      <if test="paymoneyRmb != null">
        paymoney_rmb,
      </if>
      <if test="payday != null">
        payday,
      </if>
      <if test="expectPaytime != null">
        expect_paytime,
      </if>
      <if test="tradebBjecttype != null">
        tradeb_bjecttype,
      </if>
      <if test="tradebBjectid != null">
        tradeb_bjectid,
      </if>
      <if test="tradebBjectname != null">
        tradeb_bjectname,
      </if>
      <if test="bankaccountidTo != null">
        bankaccountid_to,
      </if>
      <if test="bankcardTo != null">
        bankcard_to,
      </if>
      <if test="banknameTo != null">
        bankname_to,
      </if>
      <if test="bankcarduserTo != null">
        bankcarduser_to,
      </if>
      <if test="applyremark != null">
        applyremark,
      </if>
      <if test="cashierCallbackstatus != null">
        cashier_callbackstatus,
      </if>
      <if test="sourcecode != null">
        sourcecode,
      </if>
      <if test="sourcename != null">
        sourcename,
      </if>
      <if test="cashierStatus != null">
        cashier_status,
      </if>
      <if test="payType != null">
        pay_type,
      </if>
      <if test="cashierUserid != null">
        cashier_userid,
      </if>
      <if test="cashierUsername != null">
        cashier_username,
      </if>
      <if test="cashierTime != null">
        cashier_time,
      </if>
      <if test="cashierRemark != null">
        cashier_remark,
      </if>
      <if test="cashierBankaccountid != null">
        cashier_bankaccountid,
      </if>
      <if test="cashierBankname != null">
        cashier_bankname,
      </if>
      <if test="cashierBankcard != null">
        cashier_bankcard,
      </if>
      <if test="cashierBankcardname != null">
        cashier_bankcardname,
      </if>
      <if test="cashierUnitcode != null">
        cashier_unitcode,
      </if>
      <if test="cashierUnitname != null">
        cashier_unitname,
      </if>
      <if test="cashierRate != null">
        cashier_rate,
      </if>
      <if test="cashierPaymoney != null">
        cashier_paymoney,
      </if>
      <if test="cashierPaymoneyrmb != null">
        cashier_paymoneyrmb,
      </if>
      <if test="isquestion != null">
        isquestion,
      </if>
      <if test="questionRemark != null">
        question_remark,
      </if>
      <if test="taobaoOrderNo != null">
        taobao_order_no,
      </if>
      <if test="otherorderCode != null">
        otherorder_code,
      </if>
      <if test="createUserid != null">
        create_userid,
      </if>
      <if test="createUsername != null">
        create_username,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="modifyUserid != null">
        modify_userid,
      </if>
      <if test="modifyUsername != null">
        modify_username,
      </if>
      <if test="modifyTime != null">
        modify_time,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="code != null">
        #{code,jdbcType=VARCHAR},
      </if>
      <if test="applyId != null">
        #{applyId,jdbcType=VARCHAR},
      </if>
      <if test="detailName != null">
        #{detailName,jdbcType=VARCHAR},
      </if>
      <if test="cashierType != null">
        #{cashierType,jdbcType=TINYINT},
      </if>
      <if test="typeName != null">
        #{typeName,jdbcType=VARCHAR},
      </if>
      <if test="companymainValueFrom != null">
        #{companymainValueFrom,jdbcType=INTEGER},
      </if>
      <if test="companymainNameFrom != null">
        #{companymainNameFrom,jdbcType=VARCHAR},
      </if>
      <if test="unitCode != null">
        #{unitCode,jdbcType=VARCHAR},
      </if>
      <if test="unitName != null">
        #{unitName,jdbcType=VARCHAR},
      </if>
      <if test="paymoney != null">
        #{paymoney,jdbcType=DECIMAL},
      </if>
      <if test="paymoneyRmb != null">
        #{paymoneyRmb,jdbcType=DECIMAL},
      </if>
      <if test="payday != null">
        #{payday,jdbcType=INTEGER},
      </if>
      <if test="expectPaytime != null">
        #{expectPaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="tradebBjecttype != null">
        #{tradebBjecttype,jdbcType=TINYINT},
      </if>
      <if test="tradebBjectid != null">
        #{tradebBjectid,jdbcType=INTEGER},
      </if>
      <if test="tradebBjectname != null">
        #{tradebBjectname,jdbcType=VARCHAR},
      </if>
      <if test="bankaccountidTo != null">
        #{bankaccountidTo,jdbcType=INTEGER},
      </if>
      <if test="bankcardTo != null">
        #{bankcardTo,jdbcType=VARCHAR},
      </if>
      <if test="banknameTo != null">
        #{banknameTo,jdbcType=VARCHAR},
      </if>
      <if test="bankcarduserTo != null">
        #{bankcarduserTo,jdbcType=VARCHAR},
      </if>
      <if test="applyremark != null">
        #{applyremark,jdbcType=VARCHAR},
      </if>
      <if test="cashierCallbackstatus != null">
        #{cashierCallbackstatus,jdbcType=TINYINT},
      </if>
      <if test="sourcecode != null">
        #{sourcecode,jdbcType=VARCHAR},
      </if>
      <if test="sourcename != null">
        #{sourcename,jdbcType=VARCHAR},
      </if>
      <if test="cashierStatus != null">
        #{cashierStatus,jdbcType=TINYINT},
      </if>
      <if test="payType != null">
        #{payType,jdbcType=INTEGER},
      </if>
      <if test="cashierUserid != null">
        #{cashierUserid,jdbcType=INTEGER},
      </if>
      <if test="cashierUsername != null">
        #{cashierUsername,jdbcType=VARCHAR},
      </if>
      <if test="cashierTime != null">
        #{cashierTime,jdbcType=TIMESTAMP},
      </if>
      <if test="cashierRemark != null">
        #{cashierRemark,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankaccountid != null">
        #{cashierBankaccountid,jdbcType=INTEGER},
      </if>
      <if test="cashierBankname != null">
        #{cashierBankname,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcard != null">
        #{cashierBankcard,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcardname != null">
        #{cashierBankcardname,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitcode != null">
        #{cashierUnitcode,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitname != null">
        #{cashierUnitname,jdbcType=VARCHAR},
      </if>
      <if test="cashierRate != null">
        #{cashierRate,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoney != null">
        #{cashierPaymoney,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoneyrmb != null">
        #{cashierPaymoneyrmb,jdbcType=DECIMAL},
      </if>
      <if test="isquestion != null">
        #{isquestion,jdbcType=BIT},
      </if>
      <if test="questionRemark != null">
        #{questionRemark,jdbcType=VARCHAR},
      </if>
      <if test="taobaoOrderNo != null">
        #{taobaoOrderNo,jdbcType=VARCHAR},
      </if>
      <if test="otherorderCode != null">
        #{otherorderCode,jdbcType=VARCHAR},
      </if>
      <if test="createUserid != null">
        #{createUserid,jdbcType=INTEGER},
      </if>
      <if test="createUsername != null">
        #{createUsername,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyUserid != null">
        #{modifyUserid,jdbcType=INTEGER},
      </if>
      <if test="modifyUsername != null">
        #{modifyUsername,jdbcType=VARCHAR},
      </if>
      <if test="modifyTime != null">
        #{modifyTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.DcBaseFinanceCashierExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from dc_base_finance_cashier
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_finance_cashier
    <set>
      <if test="record.id != null">
        id = #{record.id,jdbcType=INTEGER},
      </if>
      <if test="record.code != null">
        code = #{record.code,jdbcType=VARCHAR},
      </if>
      <if test="record.applyId != null">
        apply_id = #{record.applyId,jdbcType=VARCHAR},
      </if>
      <if test="record.detailName != null">
        detail_name = #{record.detailName,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierType != null">
        cashier_type = #{record.cashierType,jdbcType=TINYINT},
      </if>
      <if test="record.typeName != null">
        type_name = #{record.typeName,jdbcType=VARCHAR},
      </if>
      <if test="record.companymainValueFrom != null">
        companymain_value_from = #{record.companymainValueFrom,jdbcType=INTEGER},
      </if>
      <if test="record.companymainNameFrom != null">
        companymain_name_from = #{record.companymainNameFrom,jdbcType=VARCHAR},
      </if>
      <if test="record.unitCode != null">
        unit_code = #{record.unitCode,jdbcType=VARCHAR},
      </if>
      <if test="record.unitName != null">
        unit_name = #{record.unitName,jdbcType=VARCHAR},
      </if>
      <if test="record.paymoney != null">
        paymoney = #{record.paymoney,jdbcType=DECIMAL},
      </if>
      <if test="record.paymoneyRmb != null">
        paymoney_rmb = #{record.paymoneyRmb,jdbcType=DECIMAL},
      </if>
      <if test="record.payday != null">
        payday = #{record.payday,jdbcType=INTEGER},
      </if>
      <if test="record.expectPaytime != null">
        expect_paytime = #{record.expectPaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.tradebBjecttype != null">
        tradeb_bjecttype = #{record.tradebBjecttype,jdbcType=TINYINT},
      </if>
      <if test="record.tradebBjectid != null">
        tradeb_bjectid = #{record.tradebBjectid,jdbcType=INTEGER},
      </if>
      <if test="record.tradebBjectname != null">
        tradeb_bjectname = #{record.tradebBjectname,jdbcType=VARCHAR},
      </if>
      <if test="record.bankaccountidTo != null">
        bankaccountid_to = #{record.bankaccountidTo,jdbcType=INTEGER},
      </if>
      <if test="record.bankcardTo != null">
        bankcard_to = #{record.bankcardTo,jdbcType=VARCHAR},
      </if>
      <if test="record.banknameTo != null">
        bankname_to = #{record.banknameTo,jdbcType=VARCHAR},
      </if>
      <if test="record.bankcarduserTo != null">
        bankcarduser_to = #{record.bankcarduserTo,jdbcType=VARCHAR},
      </if>
      <if test="record.applyremark != null">
        applyremark = #{record.applyremark,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierCallbackstatus != null">
        cashier_callbackstatus = #{record.cashierCallbackstatus,jdbcType=TINYINT},
      </if>
      <if test="record.sourcecode != null">
        sourcecode = #{record.sourcecode,jdbcType=VARCHAR},
      </if>
      <if test="record.sourcename != null">
        sourcename = #{record.sourcename,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierStatus != null">
        cashier_status = #{record.cashierStatus,jdbcType=TINYINT},
      </if>
      <if test="record.payType != null">
        pay_type = #{record.payType,jdbcType=INTEGER},
      </if>
      <if test="record.cashierUserid != null">
        cashier_userid = #{record.cashierUserid,jdbcType=INTEGER},
      </if>
      <if test="record.cashierUsername != null">
        cashier_username = #{record.cashierUsername,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierTime != null">
        cashier_time = #{record.cashierTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.cashierRemark != null">
        cashier_remark = #{record.cashierRemark,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierBankaccountid != null">
        cashier_bankaccountid = #{record.cashierBankaccountid,jdbcType=INTEGER},
      </if>
      <if test="record.cashierBankname != null">
        cashier_bankname = #{record.cashierBankname,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierBankcard != null">
        cashier_bankcard = #{record.cashierBankcard,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierBankcardname != null">
        cashier_bankcardname = #{record.cashierBankcardname,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierUnitcode != null">
        cashier_unitcode = #{record.cashierUnitcode,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierUnitname != null">
        cashier_unitname = #{record.cashierUnitname,jdbcType=VARCHAR},
      </if>
      <if test="record.cashierRate != null">
        cashier_rate = #{record.cashierRate,jdbcType=DECIMAL},
      </if>
      <if test="record.cashierPaymoney != null">
        cashier_paymoney = #{record.cashierPaymoney,jdbcType=DECIMAL},
      </if>
      <if test="record.cashierPaymoneyrmb != null">
        cashier_paymoneyrmb = #{record.cashierPaymoneyrmb,jdbcType=DECIMAL},
      </if>
      <if test="record.isquestion != null">
        isquestion = #{record.isquestion,jdbcType=BIT},
      </if>
      <if test="record.questionRemark != null">
        question_remark = #{record.questionRemark,jdbcType=VARCHAR},
      </if>
      <if test="record.taobaoOrderNo != null">
        taobao_order_no = #{record.taobaoOrderNo,jdbcType=VARCHAR},
      </if>
      <if test="record.otherorderCode != null">
        otherorder_code = #{record.otherorderCode,jdbcType=VARCHAR},
      </if>
      <if test="record.createUserid != null">
        create_userid = #{record.createUserid,jdbcType=INTEGER},
      </if>
      <if test="record.createUsername != null">
        create_username = #{record.createUsername,jdbcType=VARCHAR},
      </if>
      <if test="record.createTime != null">
        create_time = #{record.createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.modifyUserid != null">
        modify_userid = #{record.modifyUserid,jdbcType=INTEGER},
      </if>
      <if test="record.modifyUsername != null">
        modify_username = #{record.modifyUsername,jdbcType=VARCHAR},
      </if>
      <if test="record.modifyTime != null">
        modify_time = #{record.modifyTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_finance_cashier
    set id = #{record.id,jdbcType=INTEGER},
      code = #{record.code,jdbcType=VARCHAR},
      apply_id = #{record.applyId,jdbcType=VARCHAR},
      detail_name = #{record.detailName,jdbcType=VARCHAR},
      cashier_type = #{record.cashierType,jdbcType=TINYINT},
      type_name = #{record.typeName,jdbcType=VARCHAR},
      companymain_value_from = #{record.companymainValueFrom,jdbcType=INTEGER},
      companymain_name_from = #{record.companymainNameFrom,jdbcType=VARCHAR},
      unit_code = #{record.unitCode,jdbcType=VARCHAR},
      unit_name = #{record.unitName,jdbcType=VARCHAR},
      paymoney = #{record.paymoney,jdbcType=DECIMAL},
      paymoney_rmb = #{record.paymoneyRmb,jdbcType=DECIMAL},
      payday = #{record.payday,jdbcType=INTEGER},
      expect_paytime = #{record.expectPaytime,jdbcType=TIMESTAMP},
      tradeb_bjecttype = #{record.tradebBjecttype,jdbcType=TINYINT},
      tradeb_bjectid = #{record.tradebBjectid,jdbcType=INTEGER},
      tradeb_bjectname = #{record.tradebBjectname,jdbcType=VARCHAR},
      bankaccountid_to = #{record.bankaccountidTo,jdbcType=INTEGER},
      bankcard_to = #{record.bankcardTo,jdbcType=VARCHAR},
      bankname_to = #{record.banknameTo,jdbcType=VARCHAR},
      bankcarduser_to = #{record.bankcarduserTo,jdbcType=VARCHAR},
      applyremark = #{record.applyremark,jdbcType=VARCHAR},
      cashier_callbackstatus = #{record.cashierCallbackstatus,jdbcType=TINYINT},
      sourcecode = #{record.sourcecode,jdbcType=VARCHAR},
      sourcename = #{record.sourcename,jdbcType=VARCHAR},
      cashier_status = #{record.cashierStatus,jdbcType=TINYINT},
      pay_type = #{record.payType,jdbcType=INTEGER},
      cashier_userid = #{record.cashierUserid,jdbcType=INTEGER},
      cashier_username = #{record.cashierUsername,jdbcType=VARCHAR},
      cashier_time = #{record.cashierTime,jdbcType=TIMESTAMP},
      cashier_remark = #{record.cashierRemark,jdbcType=VARCHAR},
      cashier_bankaccountid = #{record.cashierBankaccountid,jdbcType=INTEGER},
      cashier_bankname = #{record.cashierBankname,jdbcType=VARCHAR},
      cashier_bankcard = #{record.cashierBankcard,jdbcType=VARCHAR},
      cashier_bankcardname = #{record.cashierBankcardname,jdbcType=VARCHAR},
      cashier_unitcode = #{record.cashierUnitcode,jdbcType=VARCHAR},
      cashier_unitname = #{record.cashierUnitname,jdbcType=VARCHAR},
      cashier_rate = #{record.cashierRate,jdbcType=DECIMAL},
      cashier_paymoney = #{record.cashierPaymoney,jdbcType=DECIMAL},
      cashier_paymoneyrmb = #{record.cashierPaymoneyrmb,jdbcType=DECIMAL},
      isquestion = #{record.isquestion,jdbcType=BIT},
      question_remark = #{record.questionRemark,jdbcType=VARCHAR},
      taobao_order_no = #{record.taobaoOrderNo,jdbcType=VARCHAR},
      otherorder_code = #{record.otherorderCode,jdbcType=VARCHAR},
      create_userid = #{record.createUserid,jdbcType=INTEGER},
      create_username = #{record.createUsername,jdbcType=VARCHAR},
      create_time = #{record.createTime,jdbcType=TIMESTAMP},
      modify_userid = #{record.modifyUserid,jdbcType=INTEGER},
      modify_username = #{record.modifyUsername,jdbcType=VARCHAR},
      modify_time = #{record.modifyTime,jdbcType=TIMESTAMP}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_finance_cashier
    <set>
      <if test="code != null">
        code = #{code,jdbcType=VARCHAR},
      </if>
      <if test="applyId != null">
        apply_id = #{applyId,jdbcType=VARCHAR},
      </if>
      <if test="detailName != null">
        detail_name = #{detailName,jdbcType=VARCHAR},
      </if>
      <if test="cashierType != null">
        cashier_type = #{cashierType,jdbcType=TINYINT},
      </if>
      <if test="typeName != null">
        type_name = #{typeName,jdbcType=VARCHAR},
      </if>
      <if test="companymainValueFrom != null">
        companymain_value_from = #{companymainValueFrom,jdbcType=INTEGER},
      </if>
      <if test="companymainNameFrom != null">
        companymain_name_from = #{companymainNameFrom,jdbcType=VARCHAR},
      </if>
      <if test="unitCode != null">
        unit_code = #{unitCode,jdbcType=VARCHAR},
      </if>
      <if test="unitName != null">
        unit_name = #{unitName,jdbcType=VARCHAR},
      </if>
      <if test="paymoney != null">
        paymoney = #{paymoney,jdbcType=DECIMAL},
      </if>
      <if test="paymoneyRmb != null">
        paymoney_rmb = #{paymoneyRmb,jdbcType=DECIMAL},
      </if>
      <if test="payday != null">
        payday = #{payday,jdbcType=INTEGER},
      </if>
      <if test="expectPaytime != null">
        expect_paytime = #{expectPaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="tradebBjecttype != null">
        tradeb_bjecttype = #{tradebBjecttype,jdbcType=TINYINT},
      </if>
      <if test="tradebBjectid != null">
        tradeb_bjectid = #{tradebBjectid,jdbcType=INTEGER},
      </if>
      <if test="tradebBjectname != null">
        tradeb_bjectname = #{tradebBjectname,jdbcType=VARCHAR},
      </if>
      <if test="bankaccountidTo != null">
        bankaccountid_to = #{bankaccountidTo,jdbcType=INTEGER},
      </if>
      <if test="bankcardTo != null">
        bankcard_to = #{bankcardTo,jdbcType=VARCHAR},
      </if>
      <if test="banknameTo != null">
        bankname_to = #{banknameTo,jdbcType=VARCHAR},
      </if>
      <if test="bankcarduserTo != null">
        bankcarduser_to = #{bankcarduserTo,jdbcType=VARCHAR},
      </if>
      <if test="applyremark != null">
        applyremark = #{applyremark,jdbcType=VARCHAR},
      </if>
      <if test="cashierCallbackstatus != null">
        cashier_callbackstatus = #{cashierCallbackstatus,jdbcType=TINYINT},
      </if>
      <if test="sourcecode != null">
        sourcecode = #{sourcecode,jdbcType=VARCHAR},
      </if>
      <if test="sourcename != null">
        sourcename = #{sourcename,jdbcType=VARCHAR},
      </if>
      <if test="cashierStatus != null">
        cashier_status = #{cashierStatus,jdbcType=TINYINT},
      </if>
      <if test="payType != null">
        pay_type = #{payType,jdbcType=INTEGER},
      </if>
      <if test="cashierUserid != null">
        cashier_userid = #{cashierUserid,jdbcType=INTEGER},
      </if>
      <if test="cashierUsername != null">
        cashier_username = #{cashierUsername,jdbcType=VARCHAR},
      </if>
      <if test="cashierTime != null">
        cashier_time = #{cashierTime,jdbcType=TIMESTAMP},
      </if>
      <if test="cashierRemark != null">
        cashier_remark = #{cashierRemark,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankaccountid != null">
        cashier_bankaccountid = #{cashierBankaccountid,jdbcType=INTEGER},
      </if>
      <if test="cashierBankname != null">
        cashier_bankname = #{cashierBankname,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcard != null">
        cashier_bankcard = #{cashierBankcard,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcardname != null">
        cashier_bankcardname = #{cashierBankcardname,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitcode != null">
        cashier_unitcode = #{cashierUnitcode,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitname != null">
        cashier_unitname = #{cashierUnitname,jdbcType=VARCHAR},
      </if>
      <if test="cashierRate != null">
        cashier_rate = #{cashierRate,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoney != null">
        cashier_paymoney = #{cashierPaymoney,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoneyrmb != null">
        cashier_paymoneyrmb = #{cashierPaymoneyrmb,jdbcType=DECIMAL},
      </if>
      <if test="isquestion != null">
        isquestion = #{isquestion,jdbcType=BIT},
      </if>
      <if test="questionRemark != null">
        question_remark = #{questionRemark,jdbcType=VARCHAR},
      </if>
      <if test="taobaoOrderNo != null">
        taobao_order_no = #{taobaoOrderNo,jdbcType=VARCHAR},
      </if>
      <if test="otherorderCode != null">
        otherorder_code = #{otherorderCode,jdbcType=VARCHAR},
      </if>
      <if test="createUserid != null">
        create_userid = #{createUserid,jdbcType=INTEGER},
      </if>
      <if test="createUsername != null">
        create_username = #{createUsername,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyUserid != null">
        modify_userid = #{modifyUserid,jdbcType=INTEGER},
      </if>
      <if test="modifyUsername != null">
        modify_username = #{modifyUsername,jdbcType=VARCHAR},
      </if>
      <if test="modifyTime != null">
        modify_time = #{modifyTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_finance_cashier
    set code = #{code,jdbcType=VARCHAR},
      apply_id = #{applyId,jdbcType=VARCHAR},
      detail_name = #{detailName,jdbcType=VARCHAR},
      cashier_type = #{cashierType,jdbcType=TINYINT},
      type_name = #{typeName,jdbcType=VARCHAR},
      companymain_value_from = #{companymainValueFrom,jdbcType=INTEGER},
      companymain_name_from = #{companymainNameFrom,jdbcType=VARCHAR},
      unit_code = #{unitCode,jdbcType=VARCHAR},
      unit_name = #{unitName,jdbcType=VARCHAR},
      paymoney = #{paymoney,jdbcType=DECIMAL},
      paymoney_rmb = #{paymoneyRmb,jdbcType=DECIMAL},
      payday = #{payday,jdbcType=INTEGER},
      expect_paytime = #{expectPaytime,jdbcType=TIMESTAMP},
      tradeb_bjecttype = #{tradebBjecttype,jdbcType=TINYINT},
      tradeb_bjectid = #{tradebBjectid,jdbcType=INTEGER},
      tradeb_bjectname = #{tradebBjectname,jdbcType=VARCHAR},
      bankaccountid_to = #{bankaccountidTo,jdbcType=INTEGER},
      bankcard_to = #{bankcardTo,jdbcType=VARCHAR},
      bankname_to = #{banknameTo,jdbcType=VARCHAR},
      bankcarduser_to = #{bankcarduserTo,jdbcType=VARCHAR},
      applyremark = #{applyremark,jdbcType=VARCHAR},
      cashier_callbackstatus = #{cashierCallbackstatus,jdbcType=TINYINT},
      sourcecode = #{sourcecode,jdbcType=VARCHAR},
      sourcename = #{sourcename,jdbcType=VARCHAR},
      cashier_status = #{cashierStatus,jdbcType=TINYINT},
      pay_type = #{payType,jdbcType=INTEGER},
      cashier_userid = #{cashierUserid,jdbcType=INTEGER},
      cashier_username = #{cashierUsername,jdbcType=VARCHAR},
      cashier_time = #{cashierTime,jdbcType=TIMESTAMP},
      cashier_remark = #{cashierRemark,jdbcType=VARCHAR},
      cashier_bankaccountid = #{cashierBankaccountid,jdbcType=INTEGER},
      cashier_bankname = #{cashierBankname,jdbcType=VARCHAR},
      cashier_bankcard = #{cashierBankcard,jdbcType=VARCHAR},
      cashier_bankcardname = #{cashierBankcardname,jdbcType=VARCHAR},
      cashier_unitcode = #{cashierUnitcode,jdbcType=VARCHAR},
      cashier_unitname = #{cashierUnitname,jdbcType=VARCHAR},
      cashier_rate = #{cashierRate,jdbcType=DECIMAL},
      cashier_paymoney = #{cashierPaymoney,jdbcType=DECIMAL},
      cashier_paymoneyrmb = #{cashierPaymoneyrmb,jdbcType=DECIMAL},
      isquestion = #{isquestion,jdbcType=BIT},
      question_remark = #{questionRemark,jdbcType=VARCHAR},
      taobao_order_no = #{taobaoOrderNo,jdbcType=VARCHAR},
      otherorder_code = #{otherorderCode,jdbcType=VARCHAR},
      create_userid = #{createUserid,jdbcType=INTEGER},
      create_username = #{createUsername,jdbcType=VARCHAR},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      modify_userid = #{modifyUserid,jdbcType=INTEGER},
      modify_username = #{modifyUsername,jdbcType=VARCHAR},
      modify_time = #{modifyTime,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into dc_base_finance_cashier
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="code != null">
        code,
      </if>
      <if test="applyId != null">
        apply_id,
      </if>
      <if test="detailName != null">
        detail_name,
      </if>
      <if test="cashierType != null">
        cashier_type,
      </if>
      <if test="typeName != null">
        type_name,
      </if>
      <if test="companymainValueFrom != null">
        companymain_value_from,
      </if>
      <if test="companymainNameFrom != null">
        companymain_name_from,
      </if>
      <if test="unitCode != null">
        unit_code,
      </if>
      <if test="unitName != null">
        unit_name,
      </if>
      <if test="paymoney != null">
        paymoney,
      </if>
      <if test="paymoneyRmb != null">
        paymoney_rmb,
      </if>
      <if test="payday != null">
        payday,
      </if>
      <if test="expectPaytime != null">
        expect_paytime,
      </if>
      <if test="tradebBjecttype != null">
        tradeb_bjecttype,
      </if>
      <if test="tradebBjectid != null">
        tradeb_bjectid,
      </if>
      <if test="tradebBjectname != null">
        tradeb_bjectname,
      </if>
      <if test="bankaccountidTo != null">
        bankaccountid_to,
      </if>
      <if test="bankcardTo != null">
        bankcard_to,
      </if>
      <if test="banknameTo != null">
        bankname_to,
      </if>
      <if test="bankcarduserTo != null">
        bankcarduser_to,
      </if>
      <if test="applyremark != null">
        applyremark,
      </if>
      <if test="cashierCallbackstatus != null">
        cashier_callbackstatus,
      </if>
      <if test="sourcecode != null">
        sourcecode,
      </if>
      <if test="sourcename != null">
        sourcename,
      </if>
      <if test="cashierStatus != null">
        cashier_status,
      </if>
      <if test="payType != null">
        pay_type,
      </if>
      <if test="cashierUserid != null">
        cashier_userid,
      </if>
      <if test="cashierUsername != null">
        cashier_username,
      </if>
      <if test="cashierTime != null">
        cashier_time,
      </if>
      <if test="cashierRemark != null">
        cashier_remark,
      </if>
      <if test="cashierBankaccountid != null">
        cashier_bankaccountid,
      </if>
      <if test="cashierBankname != null">
        cashier_bankname,
      </if>
      <if test="cashierBankcard != null">
        cashier_bankcard,
      </if>
      <if test="cashierBankcardname != null">
        cashier_bankcardname,
      </if>
      <if test="cashierUnitcode != null">
        cashier_unitcode,
      </if>
      <if test="cashierUnitname != null">
        cashier_unitname,
      </if>
      <if test="cashierRate != null">
        cashier_rate,
      </if>
      <if test="cashierPaymoney != null">
        cashier_paymoney,
      </if>
      <if test="cashierPaymoneyrmb != null">
        cashier_paymoneyrmb,
      </if>
      <if test="isquestion != null">
        isquestion,
      </if>
      <if test="questionRemark != null">
        question_remark,
      </if>
      <if test="taobaoOrderNo != null">
        taobao_order_no,
      </if>
      <if test="otherorderCode != null">
        otherorder_code,
      </if>
      <if test="createUserid != null">
        create_userid,
      </if>
      <if test="createUsername != null">
        create_username,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="modifyUserid != null">
        modify_userid,
      </if>
      <if test="modifyUsername != null">
        modify_username,
      </if>
      <if test="modifyTime != null">
        modify_time,
      </if>
    </trim>
    values
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="code != null">
        #{code,jdbcType=VARCHAR},
      </if>
      <if test="applyId != null">
        #{applyId,jdbcType=VARCHAR},
      </if>
      <if test="detailName != null">
        #{detailName,jdbcType=VARCHAR},
      </if>
      <if test="cashierType != null">
        #{cashierType,jdbcType=TINYINT},
      </if>
      <if test="typeName != null">
        #{typeName,jdbcType=VARCHAR},
      </if>
      <if test="companymainValueFrom != null">
        #{companymainValueFrom,jdbcType=INTEGER},
      </if>
      <if test="companymainNameFrom != null">
        #{companymainNameFrom,jdbcType=VARCHAR},
      </if>
      <if test="unitCode != null">
        #{unitCode,jdbcType=VARCHAR},
      </if>
      <if test="unitName != null">
        #{unitName,jdbcType=VARCHAR},
      </if>
      <if test="paymoney != null">
        #{paymoney,jdbcType=DECIMAL},
      </if>
      <if test="paymoneyRmb != null">
        #{paymoneyRmb,jdbcType=DECIMAL},
      </if>
      <if test="payday != null">
        #{payday,jdbcType=INTEGER},
      </if>
      <if test="expectPaytime != null">
        #{expectPaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="tradebBjecttype != null">
        #{tradebBjecttype,jdbcType=TINYINT},
      </if>
      <if test="tradebBjectid != null">
        #{tradebBjectid,jdbcType=INTEGER},
      </if>
      <if test="tradebBjectname != null">
        #{tradebBjectname,jdbcType=VARCHAR},
      </if>
      <if test="bankaccountidTo != null">
        #{bankaccountidTo,jdbcType=INTEGER},
      </if>
      <if test="bankcardTo != null">
        #{bankcardTo,jdbcType=VARCHAR},
      </if>
      <if test="banknameTo != null">
        #{banknameTo,jdbcType=VARCHAR},
      </if>
      <if test="bankcarduserTo != null">
        #{bankcarduserTo,jdbcType=VARCHAR},
      </if>
      <if test="applyremark != null">
        #{applyremark,jdbcType=VARCHAR},
      </if>
      <if test="cashierCallbackstatus != null">
        #{cashierCallbackstatus,jdbcType=TINYINT},
      </if>
      <if test="sourcecode != null">
        #{sourcecode,jdbcType=VARCHAR},
      </if>
      <if test="sourcename != null">
        #{sourcename,jdbcType=VARCHAR},
      </if>
      <if test="cashierStatus != null">
        #{cashierStatus,jdbcType=TINYINT},
      </if>
      <if test="payType != null">
        #{payType,jdbcType=INTEGER},
      </if>
      <if test="cashierUserid != null">
        #{cashierUserid,jdbcType=INTEGER},
      </if>
      <if test="cashierUsername != null">
        #{cashierUsername,jdbcType=VARCHAR},
      </if>
      <if test="cashierTime != null">
        #{cashierTime,jdbcType=TIMESTAMP},
      </if>
      <if test="cashierRemark != null">
        #{cashierRemark,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankaccountid != null">
        #{cashierBankaccountid,jdbcType=INTEGER},
      </if>
      <if test="cashierBankname != null">
        #{cashierBankname,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcard != null">
        #{cashierBankcard,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcardname != null">
        #{cashierBankcardname,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitcode != null">
        #{cashierUnitcode,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitname != null">
        #{cashierUnitname,jdbcType=VARCHAR},
      </if>
      <if test="cashierRate != null">
        #{cashierRate,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoney != null">
        #{cashierPaymoney,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoneyrmb != null">
        #{cashierPaymoneyrmb,jdbcType=DECIMAL},
      </if>
      <if test="isquestion != null">
        #{isquestion,jdbcType=BIT},
      </if>
      <if test="questionRemark != null">
        #{questionRemark,jdbcType=VARCHAR},
      </if>
      <if test="taobaoOrderNo != null">
        #{taobaoOrderNo,jdbcType=VARCHAR},
      </if>
      <if test="otherorderCode != null">
        #{otherorderCode,jdbcType=VARCHAR},
      </if>
      <if test="createUserid != null">
        #{createUserid,jdbcType=INTEGER},
      </if>
      <if test="createUsername != null">
        #{createUsername,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyUserid != null">
        #{modifyUserid,jdbcType=INTEGER},
      </if>
      <if test="modifyUsername != null">
        #{modifyUsername,jdbcType=VARCHAR},
      </if>
      <if test="modifyTime != null">
        #{modifyTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
    on duplicate key update 
    <trim suffixOverrides=",">
      <if test="id != null">
        id = #{id,jdbcType=INTEGER},
      </if>
      <if test="code != null">
        code = #{code,jdbcType=VARCHAR},
      </if>
      <if test="applyId != null">
        apply_id = #{applyId,jdbcType=VARCHAR},
      </if>
      <if test="detailName != null">
        detail_name = #{detailName,jdbcType=VARCHAR},
      </if>
      <if test="cashierType != null">
        cashier_type = #{cashierType,jdbcType=TINYINT},
      </if>
      <if test="typeName != null">
        type_name = #{typeName,jdbcType=VARCHAR},
      </if>
      <if test="companymainValueFrom != null">
        companymain_value_from = #{companymainValueFrom,jdbcType=INTEGER},
      </if>
      <if test="companymainNameFrom != null">
        companymain_name_from = #{companymainNameFrom,jdbcType=VARCHAR},
      </if>
      <if test="unitCode != null">
        unit_code = #{unitCode,jdbcType=VARCHAR},
      </if>
      <if test="unitName != null">
        unit_name = #{unitName,jdbcType=VARCHAR},
      </if>
      <if test="paymoney != null">
        paymoney = #{paymoney,jdbcType=DECIMAL},
      </if>
      <if test="paymoneyRmb != null">
        paymoney_rmb = #{paymoneyRmb,jdbcType=DECIMAL},
      </if>
      <if test="payday != null">
        payday = #{payday,jdbcType=INTEGER},
      </if>
      <if test="expectPaytime != null">
        expect_paytime = #{expectPaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="tradebBjecttype != null">
        tradeb_bjecttype = #{tradebBjecttype,jdbcType=TINYINT},
      </if>
      <if test="tradebBjectid != null">
        tradeb_bjectid = #{tradebBjectid,jdbcType=INTEGER},
      </if>
      <if test="tradebBjectname != null">
        tradeb_bjectname = #{tradebBjectname,jdbcType=VARCHAR},
      </if>
      <if test="bankaccountidTo != null">
        bankaccountid_to = #{bankaccountidTo,jdbcType=INTEGER},
      </if>
      <if test="bankcardTo != null">
        bankcard_to = #{bankcardTo,jdbcType=VARCHAR},
      </if>
      <if test="banknameTo != null">
        bankname_to = #{banknameTo,jdbcType=VARCHAR},
      </if>
      <if test="bankcarduserTo != null">
        bankcarduser_to = #{bankcarduserTo,jdbcType=VARCHAR},
      </if>
      <if test="applyremark != null">
        applyremark = #{applyremark,jdbcType=VARCHAR},
      </if>
      <if test="cashierCallbackstatus != null">
        cashier_callbackstatus = #{cashierCallbackstatus,jdbcType=TINYINT},
      </if>
      <if test="sourcecode != null">
        sourcecode = #{sourcecode,jdbcType=VARCHAR},
      </if>
      <if test="sourcename != null">
        sourcename = #{sourcename,jdbcType=VARCHAR},
      </if>
      <if test="cashierStatus != null">
        cashier_status = #{cashierStatus,jdbcType=TINYINT},
      </if>
      <if test="payType != null">
        pay_type = #{payType,jdbcType=INTEGER},
      </if>
      <if test="cashierUserid != null">
        cashier_userid = #{cashierUserid,jdbcType=INTEGER},
      </if>
      <if test="cashierUsername != null">
        cashier_username = #{cashierUsername,jdbcType=VARCHAR},
      </if>
      <if test="cashierTime != null">
        cashier_time = #{cashierTime,jdbcType=TIMESTAMP},
      </if>
      <if test="cashierRemark != null">
        cashier_remark = #{cashierRemark,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankaccountid != null">
        cashier_bankaccountid = #{cashierBankaccountid,jdbcType=INTEGER},
      </if>
      <if test="cashierBankname != null">
        cashier_bankname = #{cashierBankname,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcard != null">
        cashier_bankcard = #{cashierBankcard,jdbcType=VARCHAR},
      </if>
      <if test="cashierBankcardname != null">
        cashier_bankcardname = #{cashierBankcardname,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitcode != null">
        cashier_unitcode = #{cashierUnitcode,jdbcType=VARCHAR},
      </if>
      <if test="cashierUnitname != null">
        cashier_unitname = #{cashierUnitname,jdbcType=VARCHAR},
      </if>
      <if test="cashierRate != null">
        cashier_rate = #{cashierRate,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoney != null">
        cashier_paymoney = #{cashierPaymoney,jdbcType=DECIMAL},
      </if>
      <if test="cashierPaymoneyrmb != null">
        cashier_paymoneyrmb = #{cashierPaymoneyrmb,jdbcType=DECIMAL},
      </if>
      <if test="isquestion != null">
        isquestion = #{isquestion,jdbcType=BIT},
      </if>
      <if test="questionRemark != null">
        question_remark = #{questionRemark,jdbcType=VARCHAR},
      </if>
      <if test="taobaoOrderNo != null">
        taobao_order_no = #{taobaoOrderNo,jdbcType=VARCHAR},
      </if>
      <if test="otherorderCode != null">
        otherorder_code = #{otherorderCode,jdbcType=VARCHAR},
      </if>
      <if test="createUserid != null">
        create_userid = #{createUserid,jdbcType=INTEGER},
      </if>
      <if test="createUsername != null">
        create_username = #{createUsername,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="modifyUserid != null">
        modify_userid = #{modifyUserid,jdbcType=INTEGER},
      </if>
      <if test="modifyUsername != null">
        modify_username = #{modifyUsername,jdbcType=VARCHAR},
      </if>
      <if test="modifyTime != null">
        modify_time = #{modifyTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.DcBaseFinanceCashier">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into dc_base_finance_cashier
    (id, code, apply_id, detail_name, cashier_type, type_name, companymain_value_from, 
      companymain_name_from, unit_code, unit_name, paymoney, paymoney_rmb, payday, expect_paytime, 
      tradeb_bjecttype, tradeb_bjectid, tradeb_bjectname, bankaccountid_to, bankcard_to, 
      bankname_to, bankcarduser_to, applyremark, cashier_callbackstatus, sourcecode, 
      sourcename, cashier_status, pay_type, cashier_userid, cashier_username, cashier_time, 
      cashier_remark, cashier_bankaccountid, cashier_bankname, cashier_bankcard, cashier_bankcardname, 
      cashier_unitcode, cashier_unitname, cashier_rate, cashier_paymoney, cashier_paymoneyrmb, 
      isquestion, question_remark, taobao_order_no, otherorder_code, create_userid, create_username, 
      create_time, modify_userid, modify_username, modify_time)
    values
    (#{id,jdbcType=INTEGER}, #{code,jdbcType=VARCHAR}, #{applyId,jdbcType=VARCHAR}, #{detailName,jdbcType=VARCHAR}, 
      #{cashierType,jdbcType=TINYINT}, #{typeName,jdbcType=VARCHAR}, #{companymainValueFrom,jdbcType=INTEGER}, 
      #{companymainNameFrom,jdbcType=VARCHAR}, #{unitCode,jdbcType=VARCHAR}, #{unitName,jdbcType=VARCHAR}, 
      #{paymoney,jdbcType=DECIMAL}, #{paymoneyRmb,jdbcType=DECIMAL}, #{payday,jdbcType=INTEGER}, 
      #{expectPaytime,jdbcType=TIMESTAMP}, #{tradebBjecttype,jdbcType=TINYINT}, #{tradebBjectid,jdbcType=INTEGER}, 
      #{tradebBjectname,jdbcType=VARCHAR}, #{bankaccountidTo,jdbcType=INTEGER}, #{bankcardTo,jdbcType=VARCHAR}, 
      #{banknameTo,jdbcType=VARCHAR}, #{bankcarduserTo,jdbcType=VARCHAR}, #{applyremark,jdbcType=VARCHAR}, 
      #{cashierCallbackstatus,jdbcType=TINYINT}, #{sourcecode,jdbcType=VARCHAR}, #{sourcename,jdbcType=VARCHAR}, 
      #{cashierStatus,jdbcType=TINYINT}, #{payType,jdbcType=INTEGER}, #{cashierUserid,jdbcType=INTEGER}, 
      #{cashierUsername,jdbcType=VARCHAR}, #{cashierTime,jdbcType=TIMESTAMP}, #{cashierRemark,jdbcType=VARCHAR}, 
      #{cashierBankaccountid,jdbcType=INTEGER}, #{cashierBankname,jdbcType=VARCHAR}, 
      #{cashierBankcard,jdbcType=VARCHAR}, #{cashierBankcardname,jdbcType=VARCHAR}, #{cashierUnitcode,jdbcType=VARCHAR}, 
      #{cashierUnitname,jdbcType=VARCHAR}, #{cashierRate,jdbcType=DECIMAL}, #{cashierPaymoney,jdbcType=DECIMAL}, 
      #{cashierPaymoneyrmb,jdbcType=DECIMAL}, #{isquestion,jdbcType=BIT}, #{questionRemark,jdbcType=VARCHAR}, 
      #{taobaoOrderNo,jdbcType=VARCHAR}, #{otherorderCode,jdbcType=VARCHAR}, #{createUserid,jdbcType=INTEGER}, 
      #{createUsername,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, #{modifyUserid,jdbcType=INTEGER}, 
      #{modifyUsername,jdbcType=VARCHAR}, #{modifyTime,jdbcType=TIMESTAMP})
    on duplicate key update 
    id = #{id,jdbcType=INTEGER}, 
    code = #{code,jdbcType=VARCHAR}, 
    apply_id = #{applyId,jdbcType=VARCHAR}, 
    detail_name = #{detailName,jdbcType=VARCHAR}, 
    cashier_type = #{cashierType,jdbcType=TINYINT}, 
    type_name = #{typeName,jdbcType=VARCHAR}, 
    companymain_value_from = #{companymainValueFrom,jdbcType=INTEGER}, 
    companymain_name_from = #{companymainNameFrom,jdbcType=VARCHAR}, 
    unit_code = #{unitCode,jdbcType=VARCHAR}, 
    unit_name = #{unitName,jdbcType=VARCHAR}, 
    paymoney = #{paymoney,jdbcType=DECIMAL}, 
    paymoney_rmb = #{paymoneyRmb,jdbcType=DECIMAL}, 
    payday = #{payday,jdbcType=INTEGER}, 
    expect_paytime = #{expectPaytime,jdbcType=TIMESTAMP}, 
    tradeb_bjecttype = #{tradebBjecttype,jdbcType=TINYINT}, 
    tradeb_bjectid = #{tradebBjectid,jdbcType=INTEGER}, 
    tradeb_bjectname = #{tradebBjectname,jdbcType=VARCHAR}, 
    bankaccountid_to = #{bankaccountidTo,jdbcType=INTEGER}, 
    bankcard_to = #{bankcardTo,jdbcType=VARCHAR}, 
    bankname_to = #{banknameTo,jdbcType=VARCHAR}, 
    bankcarduser_to = #{bankcarduserTo,jdbcType=VARCHAR}, 
    applyremark = #{applyremark,jdbcType=VARCHAR}, 
    cashier_callbackstatus = #{cashierCallbackstatus,jdbcType=TINYINT}, 
    sourcecode = #{sourcecode,jdbcType=VARCHAR}, 
    sourcename = #{sourcename,jdbcType=VARCHAR}, 
    cashier_status = #{cashierStatus,jdbcType=TINYINT}, 
    pay_type = #{payType,jdbcType=INTEGER}, 
    cashier_userid = #{cashierUserid,jdbcType=INTEGER}, 
    cashier_username = #{cashierUsername,jdbcType=VARCHAR}, 
    cashier_time = #{cashierTime,jdbcType=TIMESTAMP}, 
    cashier_remark = #{cashierRemark,jdbcType=VARCHAR}, 
    cashier_bankaccountid = #{cashierBankaccountid,jdbcType=INTEGER}, 
    cashier_bankname = #{cashierBankname,jdbcType=VARCHAR}, 
    cashier_bankcard = #{cashierBankcard,jdbcType=VARCHAR}, 
    cashier_bankcardname = #{cashierBankcardname,jdbcType=VARCHAR}, 
    cashier_unitcode = #{cashierUnitcode,jdbcType=VARCHAR}, 
    cashier_unitname = #{cashierUnitname,jdbcType=VARCHAR}, 
    cashier_rate = #{cashierRate,jdbcType=DECIMAL}, 
    cashier_paymoney = #{cashierPaymoney,jdbcType=DECIMAL}, 
    cashier_paymoneyrmb = #{cashierPaymoneyrmb,jdbcType=DECIMAL}, 
    isquestion = #{isquestion,jdbcType=BIT}, 
    question_remark = #{questionRemark,jdbcType=VARCHAR}, 
    taobao_order_no = #{taobaoOrderNo,jdbcType=VARCHAR}, 
    otherorder_code = #{otherorderCode,jdbcType=VARCHAR}, 
    create_userid = #{createUserid,jdbcType=INTEGER}, 
    create_username = #{createUsername,jdbcType=VARCHAR}, 
    create_time = #{createTime,jdbcType=TIMESTAMP}, 
    modify_userid = #{modifyUserid,jdbcType=INTEGER}, 
    modify_username = #{modifyUsername,jdbcType=VARCHAR}, 
    modify_time = #{modifyTime,jdbcType=TIMESTAMP}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.DcBaseFinanceCashierExample" resultMap="BaseResultMap">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    select
    <include refid="Base_Column_List" />
    from dc_base_finance_cashier
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
</mapper>