<?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.DcBaseOmsPickMapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="origin_order_id" jdbcType="VARCHAR" property="originOrderId" />
    <result column="bailun_account_id" jdbcType="INTEGER" property="bailunAccountId" />
    <result column="bailun_order_id" jdbcType="VARCHAR" property="bailunOrderId" />
    <result column="pick_order_id" jdbcType="VARCHAR" property="pickOrderId" />
    <result column="tracking_provider" jdbcType="VARCHAR" property="trackingProvider" />
    <result column="tracking_order_id" jdbcType="VARCHAR" property="trackingOrderId" />
    <result column="shipping_status" jdbcType="VARCHAR" property="shippingStatus" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="shipping_time" jdbcType="TIMESTAMP" property="shippingTime" />
    <result column="warehouse_name" jdbcType="VARCHAR" property="warehouseName" />
    <result column="warehouse_code" jdbcType="VARCHAR" property="warehouseCode" />
    <result column="logistics_order_id" jdbcType="VARCHAR" property="logisticsOrderId" />
    <result column="logistics_order_name" jdbcType="VARCHAR" property="logisticsOrderName" />
    <result column="gmt_create" jdbcType="TIMESTAMP" property="gmtCreate" />
    <result column="gmt_modified" jdbcType="TIMESTAMP" property="gmtModified" />
    <result column="quantity_picked" jdbcType="INTEGER" property="quantityPicked" />
    <result column="quantity_shipped" jdbcType="INTEGER" property="quantityShipped" />
    <result column="bailun_sku" jdbcType="VARCHAR" property="bailunSku" />
    <result column="declare_price" jdbcType="DECIMAL" property="declarePrice" />
    <result column="cost_shipping" jdbcType="DECIMAL" property="costShipping" />
    <result column="cost_packaging" jdbcType="DECIMAL" property="costPackaging" />
    <result column="outbound_weight" jdbcType="DECIMAL" property="outboundWeight" />
    <result column="bailun_sku_cost_shipping" jdbcType="DECIMAL" property="bailunSkuCostShipping" />
    <result column="bailun_sku_cost_packaging" jdbcType="DECIMAL" property="bailunSkuCostPackaging" />
    <result column="bailun_sku_outbound_weight" jdbcType="DECIMAL" property="bailunSkuOutboundWeight" />
    <result column="has_delete" jdbcType="BIT" property="hasDelete" />
    <result column="company_id" jdbcType="INTEGER" property="companyId" />
    <result column="has_pushed" jdbcType="BIT" property="hasPushed" />
    <result column="total_fee" jdbcType="DECIMAL" property="totalFee" />
    <result column="shipping" jdbcType="DECIMAL" property="shipping" />
    <result column="opf" jdbcType="DECIMAL" property="opf" />
    <result column="fsc" jdbcType="DECIMAL" property="fsc" />
    <result column="dt" jdbcType="DECIMAL" property="dt" />
    <result column="rsf" jdbcType="DECIMAL" property="rsf" />
    <result column="otf" jdbcType="DECIMAL" property="otf" />
    <result column="whf" jdbcType="DECIMAL" property="whf" />
    <result column="currency_code" jdbcType="VARCHAR" property="currencyCode" />
    <result column="wms_to_cny_exchange_rate" jdbcType="DECIMAL" property="wmsToCnyExchangeRate" />
    <result column="wms_to_usd_exchange_rate" jdbcType="DECIMAL" property="wmsToUsdExchangeRate" />
  </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, origin_order_id, bailun_account_id, bailun_order_id, pick_order_id, tracking_provider, 
    tracking_order_id, shipping_status, create_time, shipping_time, warehouse_name, warehouse_code, 
    logistics_order_id, logistics_order_name, gmt_create, gmt_modified, quantity_picked, 
    quantity_shipped, bailun_sku, declare_price, cost_shipping, cost_packaging, outbound_weight, 
    bailun_sku_cost_shipping, bailun_sku_cost_packaging, bailun_sku_outbound_weight, 
    has_delete, company_id, has_pushed, total_fee, shipping, opf, fsc, dt, rsf, otf, 
    whf, currency_code, wms_to_cny_exchange_rate, wms_to_usd_exchange_rate
  </sql>
  <select id="selectByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPickExample" 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_oms_pick
    <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_oms_pick
    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_oms_pick
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPickExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from dc_base_oms_pick
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_pick (id, origin_order_id, bailun_account_id, 
      bailun_order_id, pick_order_id, tracking_provider, 
      tracking_order_id, shipping_status, create_time, 
      shipping_time, warehouse_name, warehouse_code, 
      logistics_order_id, logistics_order_name, gmt_create, 
      gmt_modified, quantity_picked, quantity_shipped, 
      bailun_sku, declare_price, cost_shipping, 
      cost_packaging, outbound_weight, bailun_sku_cost_shipping, 
      bailun_sku_cost_packaging, bailun_sku_outbound_weight, 
      has_delete, company_id, has_pushed, 
      total_fee, shipping, opf, 
      fsc, dt, rsf, otf, 
      whf, currency_code, wms_to_cny_exchange_rate, 
      wms_to_usd_exchange_rate)
    values (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER}, 
      #{bailunOrderId,jdbcType=VARCHAR}, #{pickOrderId,jdbcType=VARCHAR}, #{trackingProvider,jdbcType=VARCHAR}, 
      #{trackingOrderId,jdbcType=VARCHAR}, #{shippingStatus,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, 
      #{shippingTime,jdbcType=TIMESTAMP}, #{warehouseName,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, 
      #{logisticsOrderId,jdbcType=VARCHAR}, #{logisticsOrderName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP}, 
      #{gmtModified,jdbcType=TIMESTAMP}, #{quantityPicked,jdbcType=INTEGER}, #{quantityShipped,jdbcType=INTEGER}, 
      #{bailunSku,jdbcType=VARCHAR}, #{declarePrice,jdbcType=DECIMAL}, #{costShipping,jdbcType=DECIMAL}, 
      #{costPackaging,jdbcType=DECIMAL}, #{outboundWeight,jdbcType=DECIMAL}, #{bailunSkuCostShipping,jdbcType=DECIMAL}, 
      #{bailunSkuCostPackaging,jdbcType=DECIMAL}, #{bailunSkuOutboundWeight,jdbcType=DECIMAL}, 
      #{hasDelete,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{hasPushed,jdbcType=BIT}, 
      #{totalFee,jdbcType=DECIMAL}, #{shipping,jdbcType=DECIMAL}, #{opf,jdbcType=DECIMAL}, 
      #{fsc,jdbcType=DECIMAL}, #{dt,jdbcType=DECIMAL}, #{rsf,jdbcType=DECIMAL}, #{otf,jdbcType=DECIMAL}, 
      #{whf,jdbcType=DECIMAL}, #{currencyCode,jdbcType=VARCHAR}, #{wmsToCnyExchangeRate,jdbcType=DECIMAL}, 
      #{wmsToUsdExchangeRate,jdbcType=DECIMAL})
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into dc_base_oms_pick
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="originOrderId != null">
        origin_order_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="pickOrderId != null">
        pick_order_id,
      </if>
      <if test="trackingProvider != null">
        tracking_provider,
      </if>
      <if test="trackingOrderId != null">
        tracking_order_id,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="shippingTime != null">
        shipping_time,
      </if>
      <if test="warehouseName != null">
        warehouse_name,
      </if>
      <if test="warehouseCode != null">
        warehouse_code,
      </if>
      <if test="logisticsOrderId != null">
        logistics_order_id,
      </if>
      <if test="logisticsOrderName != null">
        logistics_order_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="quantityPicked != null">
        quantity_picked,
      </if>
      <if test="quantityShipped != null">
        quantity_shipped,
      </if>
      <if test="bailunSku != null">
        bailun_sku,
      </if>
      <if test="declarePrice != null">
        declare_price,
      </if>
      <if test="costShipping != null">
        cost_shipping,
      </if>
      <if test="costPackaging != null">
        cost_packaging,
      </if>
      <if test="outboundWeight != null">
        outbound_weight,
      </if>
      <if test="bailunSkuCostShipping != null">
        bailun_sku_cost_shipping,
      </if>
      <if test="bailunSkuCostPackaging != null">
        bailun_sku_cost_packaging,
      </if>
      <if test="bailunSkuOutboundWeight != null">
        bailun_sku_outbound_weight,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="companyId != null">
        company_id,
      </if>
      <if test="hasPushed != null">
        has_pushed,
      </if>
      <if test="totalFee != null">
        total_fee,
      </if>
      <if test="shipping != null">
        shipping,
      </if>
      <if test="opf != null">
        opf,
      </if>
      <if test="fsc != null">
        fsc,
      </if>
      <if test="dt != null">
        dt,
      </if>
      <if test="rsf != null">
        rsf,
      </if>
      <if test="otf != null">
        otf,
      </if>
      <if test="whf != null">
        whf,
      </if>
      <if test="currencyCode != null">
        currency_code,
      </if>
      <if test="wmsToCnyExchangeRate != null">
        wms_to_cny_exchange_rate,
      </if>
      <if test="wmsToUsdExchangeRate != null">
        wms_to_usd_exchange_rate,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="pickOrderId != null">
        #{pickOrderId,jdbcType=VARCHAR},
      </if>
      <if test="trackingProvider != null">
        #{trackingProvider,jdbcType=VARCHAR},
      </if>
      <if test="trackingOrderId != null">
        #{trackingOrderId,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="shippingTime != null">
        #{shippingTime,jdbcType=TIMESTAMP},
      </if>
      <if test="warehouseName != null">
        #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderId != null">
        #{logisticsOrderId,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderName != null">
        #{logisticsOrderName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="quantityPicked != null">
        #{quantityPicked,jdbcType=INTEGER},
      </if>
      <if test="quantityShipped != null">
        #{quantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSku != null">
        #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="declarePrice != null">
        #{declarePrice,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackaging != null">
        #{costPackaging,jdbcType=DECIMAL},
      </if>
      <if test="outboundWeight != null">
        #{outboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostShipping != null">
        #{bailunSkuCostShipping,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostPackaging != null">
        #{bailunSkuCostPackaging,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuOutboundWeight != null">
        #{bailunSkuOutboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        #{companyId,jdbcType=INTEGER},
      </if>
      <if test="hasPushed != null">
        #{hasPushed,jdbcType=BIT},
      </if>
      <if test="totalFee != null">
        #{totalFee,jdbcType=DECIMAL},
      </if>
      <if test="shipping != null">
        #{shipping,jdbcType=DECIMAL},
      </if>
      <if test="opf != null">
        #{opf,jdbcType=DECIMAL},
      </if>
      <if test="fsc != null">
        #{fsc,jdbcType=DECIMAL},
      </if>
      <if test="dt != null">
        #{dt,jdbcType=DECIMAL},
      </if>
      <if test="rsf != null">
        #{rsf,jdbcType=DECIMAL},
      </if>
      <if test="otf != null">
        #{otf,jdbcType=DECIMAL},
      </if>
      <if test="whf != null">
        #{whf,jdbcType=DECIMAL},
      </if>
      <if test="currencyCode != null">
        #{currencyCode,jdbcType=VARCHAR},
      </if>
      <if test="wmsToCnyExchangeRate != null">
        #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="wmsToUsdExchangeRate != null">
        #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPickExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from dc_base_oms_pick
    <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_oms_pick
    <set>
      <if test="record.id != null">
        id = #{record.id,jdbcType=INTEGER},
      </if>
      <if test="record.originOrderId != null">
        origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.bailunAccountId != null">
        bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="record.bailunOrderId != null">
        bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.pickOrderId != null">
        pick_order_id = #{record.pickOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.trackingProvider != null">
        tracking_provider = #{record.trackingProvider,jdbcType=VARCHAR},
      </if>
      <if test="record.trackingOrderId != null">
        tracking_order_id = #{record.trackingOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.shippingStatus != null">
        shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="record.createTime != null">
        create_time = #{record.createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.shippingTime != null">
        shipping_time = #{record.shippingTime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.warehouseName != null">
        warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="record.warehouseCode != null">
        warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="record.logisticsOrderId != null">
        logistics_order_id = #{record.logisticsOrderId,jdbcType=VARCHAR},
      </if>
      <if test="record.logisticsOrderName != null">
        logistics_order_name = #{record.logisticsOrderName,jdbcType=VARCHAR},
      </if>
      <if test="record.gmtCreate != null">
        gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="record.gmtModified != null">
        gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="record.quantityPicked != null">
        quantity_picked = #{record.quantityPicked,jdbcType=INTEGER},
      </if>
      <if test="record.quantityShipped != null">
        quantity_shipped = #{record.quantityShipped,jdbcType=INTEGER},
      </if>
      <if test="record.bailunSku != null">
        bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="record.declarePrice != null">
        declare_price = #{record.declarePrice,jdbcType=DECIMAL},
      </if>
      <if test="record.costShipping != null">
        cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
      </if>
      <if test="record.costPackaging != null">
        cost_packaging = #{record.costPackaging,jdbcType=DECIMAL},
      </if>
      <if test="record.outboundWeight != null">
        outbound_weight = #{record.outboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunSkuCostShipping != null">
        bailun_sku_cost_shipping = #{record.bailunSkuCostShipping,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunSkuCostPackaging != null">
        bailun_sku_cost_packaging = #{record.bailunSkuCostPackaging,jdbcType=DECIMAL},
      </if>
      <if test="record.bailunSkuOutboundWeight != null">
        bailun_sku_outbound_weight = #{record.bailunSkuOutboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="record.hasDelete != null">
        has_delete = #{record.hasDelete,jdbcType=BIT},
      </if>
      <if test="record.companyId != null">
        company_id = #{record.companyId,jdbcType=INTEGER},
      </if>
      <if test="record.hasPushed != null">
        has_pushed = #{record.hasPushed,jdbcType=BIT},
      </if>
      <if test="record.totalFee != null">
        total_fee = #{record.totalFee,jdbcType=DECIMAL},
      </if>
      <if test="record.shipping != null">
        shipping = #{record.shipping,jdbcType=DECIMAL},
      </if>
      <if test="record.opf != null">
        opf = #{record.opf,jdbcType=DECIMAL},
      </if>
      <if test="record.fsc != null">
        fsc = #{record.fsc,jdbcType=DECIMAL},
      </if>
      <if test="record.dt != null">
        dt = #{record.dt,jdbcType=DECIMAL},
      </if>
      <if test="record.rsf != null">
        rsf = #{record.rsf,jdbcType=DECIMAL},
      </if>
      <if test="record.otf != null">
        otf = #{record.otf,jdbcType=DECIMAL},
      </if>
      <if test="record.whf != null">
        whf = #{record.whf,jdbcType=DECIMAL},
      </if>
      <if test="record.currencyCode != null">
        currency_code = #{record.currencyCode,jdbcType=VARCHAR},
      </if>
      <if test="record.wmsToCnyExchangeRate != null">
        wms_to_cny_exchange_rate = #{record.wmsToCnyExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="record.wmsToUsdExchangeRate != null">
        wms_to_usd_exchange_rate = #{record.wmsToUsdExchangeRate,jdbcType=DECIMAL},
      </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_oms_pick
    set id = #{record.id,jdbcType=INTEGER},
      origin_order_id = #{record.originOrderId,jdbcType=VARCHAR},
      bailun_account_id = #{record.bailunAccountId,jdbcType=INTEGER},
      bailun_order_id = #{record.bailunOrderId,jdbcType=VARCHAR},
      pick_order_id = #{record.pickOrderId,jdbcType=VARCHAR},
      tracking_provider = #{record.trackingProvider,jdbcType=VARCHAR},
      tracking_order_id = #{record.trackingOrderId,jdbcType=VARCHAR},
      shipping_status = #{record.shippingStatus,jdbcType=VARCHAR},
      create_time = #{record.createTime,jdbcType=TIMESTAMP},
      shipping_time = #{record.shippingTime,jdbcType=TIMESTAMP},
      warehouse_name = #{record.warehouseName,jdbcType=VARCHAR},
      warehouse_code = #{record.warehouseCode,jdbcType=VARCHAR},
      logistics_order_id = #{record.logisticsOrderId,jdbcType=VARCHAR},
      logistics_order_name = #{record.logisticsOrderName,jdbcType=VARCHAR},
      gmt_create = #{record.gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{record.gmtModified,jdbcType=TIMESTAMP},
      quantity_picked = #{record.quantityPicked,jdbcType=INTEGER},
      quantity_shipped = #{record.quantityShipped,jdbcType=INTEGER},
      bailun_sku = #{record.bailunSku,jdbcType=VARCHAR},
      declare_price = #{record.declarePrice,jdbcType=DECIMAL},
      cost_shipping = #{record.costShipping,jdbcType=DECIMAL},
      cost_packaging = #{record.costPackaging,jdbcType=DECIMAL},
      outbound_weight = #{record.outboundWeight,jdbcType=DECIMAL},
      bailun_sku_cost_shipping = #{record.bailunSkuCostShipping,jdbcType=DECIMAL},
      bailun_sku_cost_packaging = #{record.bailunSkuCostPackaging,jdbcType=DECIMAL},
      bailun_sku_outbound_weight = #{record.bailunSkuOutboundWeight,jdbcType=DECIMAL},
      has_delete = #{record.hasDelete,jdbcType=BIT},
      company_id = #{record.companyId,jdbcType=INTEGER},
      has_pushed = #{record.hasPushed,jdbcType=BIT},
      total_fee = #{record.totalFee,jdbcType=DECIMAL},
      shipping = #{record.shipping,jdbcType=DECIMAL},
      opf = #{record.opf,jdbcType=DECIMAL},
      fsc = #{record.fsc,jdbcType=DECIMAL},
      dt = #{record.dt,jdbcType=DECIMAL},
      rsf = #{record.rsf,jdbcType=DECIMAL},
      otf = #{record.otf,jdbcType=DECIMAL},
      whf = #{record.whf,jdbcType=DECIMAL},
      currency_code = #{record.currencyCode,jdbcType=VARCHAR},
      wms_to_cny_exchange_rate = #{record.wmsToCnyExchangeRate,jdbcType=DECIMAL},
      wms_to_usd_exchange_rate = #{record.wmsToUsdExchangeRate,jdbcType=DECIMAL}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_pick
    <set>
      <if test="originOrderId != null">
        origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="pickOrderId != null">
        pick_order_id = #{pickOrderId,jdbcType=VARCHAR},
      </if>
      <if test="trackingProvider != null">
        tracking_provider = #{trackingProvider,jdbcType=VARCHAR},
      </if>
      <if test="trackingOrderId != null">
        tracking_order_id = #{trackingOrderId,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="shippingTime != null">
        shipping_time = #{shippingTime,jdbcType=TIMESTAMP},
      </if>
      <if test="warehouseName != null">
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderId != null">
        logistics_order_id = #{logisticsOrderId,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderName != null">
        logistics_order_name = #{logisticsOrderName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="quantityPicked != null">
        quantity_picked = #{quantityPicked,jdbcType=INTEGER},
      </if>
      <if test="quantityShipped != null">
        quantity_shipped = #{quantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSku != null">
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="declarePrice != null">
        declare_price = #{declarePrice,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackaging != null">
        cost_packaging = #{costPackaging,jdbcType=DECIMAL},
      </if>
      <if test="outboundWeight != null">
        outbound_weight = #{outboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostShipping != null">
        bailun_sku_cost_shipping = #{bailunSkuCostShipping,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostPackaging != null">
        bailun_sku_cost_packaging = #{bailunSkuCostPackaging,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuOutboundWeight != null">
        bailun_sku_outbound_weight = #{bailunSkuOutboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        company_id = #{companyId,jdbcType=INTEGER},
      </if>
      <if test="hasPushed != null">
        has_pushed = #{hasPushed,jdbcType=BIT},
      </if>
      <if test="totalFee != null">
        total_fee = #{totalFee,jdbcType=DECIMAL},
      </if>
      <if test="shipping != null">
        shipping = #{shipping,jdbcType=DECIMAL},
      </if>
      <if test="opf != null">
        opf = #{opf,jdbcType=DECIMAL},
      </if>
      <if test="fsc != null">
        fsc = #{fsc,jdbcType=DECIMAL},
      </if>
      <if test="dt != null">
        dt = #{dt,jdbcType=DECIMAL},
      </if>
      <if test="rsf != null">
        rsf = #{rsf,jdbcType=DECIMAL},
      </if>
      <if test="otf != null">
        otf = #{otf,jdbcType=DECIMAL},
      </if>
      <if test="whf != null">
        whf = #{whf,jdbcType=DECIMAL},
      </if>
      <if test="currencyCode != null">
        currency_code = #{currencyCode,jdbcType=VARCHAR},
      </if>
      <if test="wmsToCnyExchangeRate != null">
        wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="wmsToUsdExchangeRate != null">
        wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update dc_base_oms_pick
    set origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      pick_order_id = #{pickOrderId,jdbcType=VARCHAR},
      tracking_provider = #{trackingProvider,jdbcType=VARCHAR},
      tracking_order_id = #{trackingOrderId,jdbcType=VARCHAR},
      shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      shipping_time = #{shippingTime,jdbcType=TIMESTAMP},
      warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      logistics_order_id = #{logisticsOrderId,jdbcType=VARCHAR},
      logistics_order_name = #{logisticsOrderName,jdbcType=VARCHAR},
      gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      quantity_picked = #{quantityPicked,jdbcType=INTEGER},
      quantity_shipped = #{quantityShipped,jdbcType=INTEGER},
      bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      declare_price = #{declarePrice,jdbcType=DECIMAL},
      cost_shipping = #{costShipping,jdbcType=DECIMAL},
      cost_packaging = #{costPackaging,jdbcType=DECIMAL},
      outbound_weight = #{outboundWeight,jdbcType=DECIMAL},
      bailun_sku_cost_shipping = #{bailunSkuCostShipping,jdbcType=DECIMAL},
      bailun_sku_cost_packaging = #{bailunSkuCostPackaging,jdbcType=DECIMAL},
      bailun_sku_outbound_weight = #{bailunSkuOutboundWeight,jdbcType=DECIMAL},
      has_delete = #{hasDelete,jdbcType=BIT},
      company_id = #{companyId,jdbcType=INTEGER},
      has_pushed = #{hasPushed,jdbcType=BIT},
      total_fee = #{totalFee,jdbcType=DECIMAL},
      shipping = #{shipping,jdbcType=DECIMAL},
      opf = #{opf,jdbcType=DECIMAL},
      fsc = #{fsc,jdbcType=DECIMAL},
      dt = #{dt,jdbcType=DECIMAL},
      rsf = #{rsf,jdbcType=DECIMAL},
      otf = #{otf,jdbcType=DECIMAL},
      whf = #{whf,jdbcType=DECIMAL},
      currency_code = #{currencyCode,jdbcType=VARCHAR},
      wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
      wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL}
    where id = #{id,jdbcType=INTEGER}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      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_oms_pick
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="originOrderId != null">
        origin_order_id,
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id,
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id,
      </if>
      <if test="pickOrderId != null">
        pick_order_id,
      </if>
      <if test="trackingProvider != null">
        tracking_provider,
      </if>
      <if test="trackingOrderId != null">
        tracking_order_id,
      </if>
      <if test="shippingStatus != null">
        shipping_status,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="shippingTime != null">
        shipping_time,
      </if>
      <if test="warehouseName != null">
        warehouse_name,
      </if>
      <if test="warehouseCode != null">
        warehouse_code,
      </if>
      <if test="logisticsOrderId != null">
        logistics_order_id,
      </if>
      <if test="logisticsOrderName != null">
        logistics_order_name,
      </if>
      <if test="gmtCreate != null">
        gmt_create,
      </if>
      <if test="gmtModified != null">
        gmt_modified,
      </if>
      <if test="quantityPicked != null">
        quantity_picked,
      </if>
      <if test="quantityShipped != null">
        quantity_shipped,
      </if>
      <if test="bailunSku != null">
        bailun_sku,
      </if>
      <if test="declarePrice != null">
        declare_price,
      </if>
      <if test="costShipping != null">
        cost_shipping,
      </if>
      <if test="costPackaging != null">
        cost_packaging,
      </if>
      <if test="outboundWeight != null">
        outbound_weight,
      </if>
      <if test="bailunSkuCostShipping != null">
        bailun_sku_cost_shipping,
      </if>
      <if test="bailunSkuCostPackaging != null">
        bailun_sku_cost_packaging,
      </if>
      <if test="bailunSkuOutboundWeight != null">
        bailun_sku_outbound_weight,
      </if>
      <if test="hasDelete != null">
        has_delete,
      </if>
      <if test="companyId != null">
        company_id,
      </if>
      <if test="hasPushed != null">
        has_pushed,
      </if>
      <if test="totalFee != null">
        total_fee,
      </if>
      <if test="shipping != null">
        shipping,
      </if>
      <if test="opf != null">
        opf,
      </if>
      <if test="fsc != null">
        fsc,
      </if>
      <if test="dt != null">
        dt,
      </if>
      <if test="rsf != null">
        rsf,
      </if>
      <if test="otf != null">
        otf,
      </if>
      <if test="whf != null">
        whf,
      </if>
      <if test="currencyCode != null">
        currency_code,
      </if>
      <if test="wmsToCnyExchangeRate != null">
        wms_to_cny_exchange_rate,
      </if>
      <if test="wmsToUsdExchangeRate != null">
        wms_to_usd_exchange_rate,
      </if>
    </trim>
    values
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="bailunOrderId != null">
        #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="pickOrderId != null">
        #{pickOrderId,jdbcType=VARCHAR},
      </if>
      <if test="trackingProvider != null">
        #{trackingProvider,jdbcType=VARCHAR},
      </if>
      <if test="trackingOrderId != null">
        #{trackingOrderId,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="shippingTime != null">
        #{shippingTime,jdbcType=TIMESTAMP},
      </if>
      <if test="warehouseName != null">
        #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderId != null">
        #{logisticsOrderId,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderName != null">
        #{logisticsOrderName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="quantityPicked != null">
        #{quantityPicked,jdbcType=INTEGER},
      </if>
      <if test="quantityShipped != null">
        #{quantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSku != null">
        #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="declarePrice != null">
        #{declarePrice,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackaging != null">
        #{costPackaging,jdbcType=DECIMAL},
      </if>
      <if test="outboundWeight != null">
        #{outboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostShipping != null">
        #{bailunSkuCostShipping,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostPackaging != null">
        #{bailunSkuCostPackaging,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuOutboundWeight != null">
        #{bailunSkuOutboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="hasDelete != null">
        #{hasDelete,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        #{companyId,jdbcType=INTEGER},
      </if>
      <if test="hasPushed != null">
        #{hasPushed,jdbcType=BIT},
      </if>
      <if test="totalFee != null">
        #{totalFee,jdbcType=DECIMAL},
      </if>
      <if test="shipping != null">
        #{shipping,jdbcType=DECIMAL},
      </if>
      <if test="opf != null">
        #{opf,jdbcType=DECIMAL},
      </if>
      <if test="fsc != null">
        #{fsc,jdbcType=DECIMAL},
      </if>
      <if test="dt != null">
        #{dt,jdbcType=DECIMAL},
      </if>
      <if test="rsf != null">
        #{rsf,jdbcType=DECIMAL},
      </if>
      <if test="otf != null">
        #{otf,jdbcType=DECIMAL},
      </if>
      <if test="whf != null">
        #{whf,jdbcType=DECIMAL},
      </if>
      <if test="currencyCode != null">
        #{currencyCode,jdbcType=VARCHAR},
      </if>
      <if test="wmsToCnyExchangeRate != null">
        #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="wmsToUsdExchangeRate != null">
        #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
    </trim>
    on duplicate key update 
    <trim suffixOverrides=",">
      <if test="id != null">
        id = #{id,jdbcType=INTEGER},
      </if>
      <if test="originOrderId != null">
        origin_order_id = #{originOrderId,jdbcType=VARCHAR},
      </if>
      <if test="bailunAccountId != null">
        bailun_account_id = #{bailunAccountId,jdbcType=INTEGER},
      </if>
      <if test="bailunOrderId != null">
        bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR},
      </if>
      <if test="pickOrderId != null">
        pick_order_id = #{pickOrderId,jdbcType=VARCHAR},
      </if>
      <if test="trackingProvider != null">
        tracking_provider = #{trackingProvider,jdbcType=VARCHAR},
      </if>
      <if test="trackingOrderId != null">
        tracking_order_id = #{trackingOrderId,jdbcType=VARCHAR},
      </if>
      <if test="shippingStatus != null">
        shipping_status = #{shippingStatus,jdbcType=VARCHAR},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="shippingTime != null">
        shipping_time = #{shippingTime,jdbcType=TIMESTAMP},
      </if>
      <if test="warehouseName != null">
        warehouse_name = #{warehouseName,jdbcType=VARCHAR},
      </if>
      <if test="warehouseCode != null">
        warehouse_code = #{warehouseCode,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderId != null">
        logistics_order_id = #{logisticsOrderId,jdbcType=VARCHAR},
      </if>
      <if test="logisticsOrderName != null">
        logistics_order_name = #{logisticsOrderName,jdbcType=VARCHAR},
      </if>
      <if test="gmtCreate != null">
        gmt_create = #{gmtCreate,jdbcType=TIMESTAMP},
      </if>
      <if test="gmtModified != null">
        gmt_modified = #{gmtModified,jdbcType=TIMESTAMP},
      </if>
      <if test="quantityPicked != null">
        quantity_picked = #{quantityPicked,jdbcType=INTEGER},
      </if>
      <if test="quantityShipped != null">
        quantity_shipped = #{quantityShipped,jdbcType=INTEGER},
      </if>
      <if test="bailunSku != null">
        bailun_sku = #{bailunSku,jdbcType=VARCHAR},
      </if>
      <if test="declarePrice != null">
        declare_price = #{declarePrice,jdbcType=DECIMAL},
      </if>
      <if test="costShipping != null">
        cost_shipping = #{costShipping,jdbcType=DECIMAL},
      </if>
      <if test="costPackaging != null">
        cost_packaging = #{costPackaging,jdbcType=DECIMAL},
      </if>
      <if test="outboundWeight != null">
        outbound_weight = #{outboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostShipping != null">
        bailun_sku_cost_shipping = #{bailunSkuCostShipping,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuCostPackaging != null">
        bailun_sku_cost_packaging = #{bailunSkuCostPackaging,jdbcType=DECIMAL},
      </if>
      <if test="bailunSkuOutboundWeight != null">
        bailun_sku_outbound_weight = #{bailunSkuOutboundWeight,jdbcType=DECIMAL},
      </if>
      <if test="hasDelete != null">
        has_delete = #{hasDelete,jdbcType=BIT},
      </if>
      <if test="companyId != null">
        company_id = #{companyId,jdbcType=INTEGER},
      </if>
      <if test="hasPushed != null">
        has_pushed = #{hasPushed,jdbcType=BIT},
      </if>
      <if test="totalFee != null">
        total_fee = #{totalFee,jdbcType=DECIMAL},
      </if>
      <if test="shipping != null">
        shipping = #{shipping,jdbcType=DECIMAL},
      </if>
      <if test="opf != null">
        opf = #{opf,jdbcType=DECIMAL},
      </if>
      <if test="fsc != null">
        fsc = #{fsc,jdbcType=DECIMAL},
      </if>
      <if test="dt != null">
        dt = #{dt,jdbcType=DECIMAL},
      </if>
      <if test="rsf != null">
        rsf = #{rsf,jdbcType=DECIMAL},
      </if>
      <if test="otf != null">
        otf = #{otf,jdbcType=DECIMAL},
      </if>
      <if test="whf != null">
        whf = #{whf,jdbcType=DECIMAL},
      </if>
      <if test="currencyCode != null">
        currency_code = #{currencyCode,jdbcType=VARCHAR},
      </if>
      <if test="wmsToCnyExchangeRate != null">
        wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL},
      </if>
      <if test="wmsToUsdExchangeRate != null">
        wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.DcBaseOmsPick">
    <!--
      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_oms_pick
    (id, origin_order_id, bailun_account_id, bailun_order_id, pick_order_id, tracking_provider, 
      tracking_order_id, shipping_status, create_time, shipping_time, warehouse_name, 
      warehouse_code, logistics_order_id, logistics_order_name, gmt_create, gmt_modified, 
      quantity_picked, quantity_shipped, bailun_sku, declare_price, cost_shipping, cost_packaging, 
      outbound_weight, bailun_sku_cost_shipping, bailun_sku_cost_packaging, bailun_sku_outbound_weight, 
      has_delete, company_id, has_pushed, total_fee, shipping, opf, fsc, dt, rsf, otf, 
      whf, currency_code, wms_to_cny_exchange_rate, wms_to_usd_exchange_rate)
    values
    (#{id,jdbcType=INTEGER}, #{originOrderId,jdbcType=VARCHAR}, #{bailunAccountId,jdbcType=INTEGER}, 
      #{bailunOrderId,jdbcType=VARCHAR}, #{pickOrderId,jdbcType=VARCHAR}, #{trackingProvider,jdbcType=VARCHAR}, 
      #{trackingOrderId,jdbcType=VARCHAR}, #{shippingStatus,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, 
      #{shippingTime,jdbcType=TIMESTAMP}, #{warehouseName,jdbcType=VARCHAR}, #{warehouseCode,jdbcType=VARCHAR}, 
      #{logisticsOrderId,jdbcType=VARCHAR}, #{logisticsOrderName,jdbcType=VARCHAR}, #{gmtCreate,jdbcType=TIMESTAMP}, 
      #{gmtModified,jdbcType=TIMESTAMP}, #{quantityPicked,jdbcType=INTEGER}, #{quantityShipped,jdbcType=INTEGER}, 
      #{bailunSku,jdbcType=VARCHAR}, #{declarePrice,jdbcType=DECIMAL}, #{costShipping,jdbcType=DECIMAL}, 
      #{costPackaging,jdbcType=DECIMAL}, #{outboundWeight,jdbcType=DECIMAL}, #{bailunSkuCostShipping,jdbcType=DECIMAL}, 
      #{bailunSkuCostPackaging,jdbcType=DECIMAL}, #{bailunSkuOutboundWeight,jdbcType=DECIMAL}, 
      #{hasDelete,jdbcType=BIT}, #{companyId,jdbcType=INTEGER}, #{hasPushed,jdbcType=BIT}, 
      #{totalFee,jdbcType=DECIMAL}, #{shipping,jdbcType=DECIMAL}, #{opf,jdbcType=DECIMAL}, 
      #{fsc,jdbcType=DECIMAL}, #{dt,jdbcType=DECIMAL}, #{rsf,jdbcType=DECIMAL}, #{otf,jdbcType=DECIMAL}, 
      #{whf,jdbcType=DECIMAL}, #{currencyCode,jdbcType=VARCHAR}, #{wmsToCnyExchangeRate,jdbcType=DECIMAL}, 
      #{wmsToUsdExchangeRate,jdbcType=DECIMAL})
    on duplicate key update 
    id = #{id,jdbcType=INTEGER}, 
    origin_order_id = #{originOrderId,jdbcType=VARCHAR}, 
    bailun_account_id = #{bailunAccountId,jdbcType=INTEGER}, 
    bailun_order_id = #{bailunOrderId,jdbcType=VARCHAR}, 
    pick_order_id = #{pickOrderId,jdbcType=VARCHAR}, 
    tracking_provider = #{trackingProvider,jdbcType=VARCHAR}, 
    tracking_order_id = #{trackingOrderId,jdbcType=VARCHAR}, 
    shipping_status = #{shippingStatus,jdbcType=VARCHAR}, 
    create_time = #{createTime,jdbcType=TIMESTAMP}, 
    shipping_time = #{shippingTime,jdbcType=TIMESTAMP}, 
    warehouse_name = #{warehouseName,jdbcType=VARCHAR}, 
    warehouse_code = #{warehouseCode,jdbcType=VARCHAR}, 
    logistics_order_id = #{logisticsOrderId,jdbcType=VARCHAR}, 
    logistics_order_name = #{logisticsOrderName,jdbcType=VARCHAR}, 
    gmt_create = #{gmtCreate,jdbcType=TIMESTAMP}, 
    gmt_modified = #{gmtModified,jdbcType=TIMESTAMP}, 
    quantity_picked = #{quantityPicked,jdbcType=INTEGER}, 
    quantity_shipped = #{quantityShipped,jdbcType=INTEGER}, 
    bailun_sku = #{bailunSku,jdbcType=VARCHAR}, 
    declare_price = #{declarePrice,jdbcType=DECIMAL}, 
    cost_shipping = #{costShipping,jdbcType=DECIMAL}, 
    cost_packaging = #{costPackaging,jdbcType=DECIMAL}, 
    outbound_weight = #{outboundWeight,jdbcType=DECIMAL}, 
    bailun_sku_cost_shipping = #{bailunSkuCostShipping,jdbcType=DECIMAL}, 
    bailun_sku_cost_packaging = #{bailunSkuCostPackaging,jdbcType=DECIMAL}, 
    bailun_sku_outbound_weight = #{bailunSkuOutboundWeight,jdbcType=DECIMAL}, 
    has_delete = #{hasDelete,jdbcType=BIT}, 
    company_id = #{companyId,jdbcType=INTEGER}, 
    has_pushed = #{hasPushed,jdbcType=BIT}, 
    total_fee = #{totalFee,jdbcType=DECIMAL}, 
    shipping = #{shipping,jdbcType=DECIMAL}, 
    opf = #{opf,jdbcType=DECIMAL}, 
    fsc = #{fsc,jdbcType=DECIMAL}, 
    dt = #{dt,jdbcType=DECIMAL}, 
    rsf = #{rsf,jdbcType=DECIMAL}, 
    otf = #{otf,jdbcType=DECIMAL}, 
    whf = #{whf,jdbcType=DECIMAL}, 
    currency_code = #{currencyCode,jdbcType=VARCHAR}, 
    wms_to_cny_exchange_rate = #{wmsToCnyExchangeRate,jdbcType=DECIMAL}, 
    wms_to_usd_exchange_rate = #{wmsToUsdExchangeRate,jdbcType=DECIMAL}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.DcBaseOmsPickExample" 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_oms_pick
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
</mapper>