<?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.TOrderOriginalMapper">
  <resultMap id="BaseResultMap" type="com.bailuntec.domain.entity.TOrderOriginal">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="Id" jdbcType="BIGINT" property="id" />
    <id column="PayTime" jdbcType="TIMESTAMP" property="paytime" />
    <result column="OrderNoPlatform" jdbcType="VARCHAR" property="ordernoplatform" />
    <result column="OrderNoSystem" jdbcType="VARCHAR" property="ordernosystem" />
    <result column="OrderSource" jdbcType="VARCHAR" property="ordersource" />
    <result column="OrderStatus" jdbcType="VARCHAR" property="orderstatus" />
    <result column="OrderSite" jdbcType="VARCHAR" property="ordersite" />
    <result column="SellAccount" jdbcType="VARCHAR" property="sellaccount" />
    <result column="OrderAmount" jdbcType="DECIMAL" property="orderamount" />
    <result column="ShipWarehouse" jdbcType="VARCHAR" property="shipwarehouse" />
    <result column="ProductTitle" jdbcType="VARCHAR" property="producttitle" />
    <result column="OrderTime" jdbcType="TIMESTAMP" property="ordertime" />
    <result column="PaypalInAccount" jdbcType="VARCHAR" property="paypalinaccount" />
    <result column="PaypalOutAccount" jdbcType="VARCHAR" property="paypaloutaccount" />
    <result column="BuyerId" jdbcType="VARCHAR" property="buyerid" />
    <result column="BuyerName" jdbcType="VARCHAR" property="buyername" />
    <result column="Country" jdbcType="VARCHAR" property="country" />
    <result column="Address1" jdbcType="VARCHAR" property="address1" />
    <result column="Address2" jdbcType="VARCHAR" property="address2" />
    <result column="City" jdbcType="VARCHAR" property="city" />
    <result column="Province" jdbcType="VARCHAR" property="province" />
    <result column="PostCode" jdbcType="VARCHAR" property="postcode" />
    <result column="PhoneNumber" jdbcType="VARCHAR" property="phonenumber" />
    <result column="MobileNumber" jdbcType="INTEGER" property="mobilenumber" />
    <result column="Email" jdbcType="VARCHAR" property="email" />
    <result column="CreateTime" jdbcType="TIMESTAMP" property="createtime" />
    <result column="UpdateTime" jdbcType="TIMESTAMP" property="updatetime" />
    <result column="Hid" jdbcType="BIGINT" property="hid" />
    <result column="ItemId" jdbcType="VARCHAR" property="itemid" />
    <result column="Freight" jdbcType="DECIMAL" property="freight" />
    <result column="IsSystemShip" jdbcType="INTEGER" property="issystemship" />
    <result column="OmsUpdateTime" jdbcType="TIMESTAMP" property="omsupdatetime" />
    <result column="OmsCreateTime" jdbcType="TIMESTAMP" property="omscreatetime" />
    <result column="MatchTime" jdbcType="TIMESTAMP" property="matchtime" />
    <result column="OriginalCurrency" jdbcType="VARCHAR" property="originalcurrency" />
    <result column="OriginalTotal" jdbcType="DECIMAL" property="originaltotal" />
    <result column="IsRefund" jdbcType="INTEGER" property="isrefund" />
    <result column="BjPayTime" jdbcType="TIMESTAMP" property="bjpaytime" />
    <result column="InterceptStatus" jdbcType="INTEGER" property="interceptstatus" />
    <result column="_ts" jdbcType="TIMESTAMP" property="ts" />
    <result column="is_abroad" jdbcType="INTEGER" property="isAbroad" />
    <result column="country_en_name" jdbcType="VARCHAR" property="countryEnName" />
    <result column="order_system" jdbcType="VARCHAR" property="orderSystem" />
  </resultMap>
  <resultMap extends="BaseResultMap" id="ResultMapWithBLOBs" type="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <result column="SkuInfo" jdbcType="LONGVARCHAR" property="skuinfo" />
    <result column="EbayTransactionId" jdbcType="LONGVARCHAR" property="ebaytransactionid" />
    <result column="PlatformNoSources" jdbcType="LONGVARCHAR" property="platformnosources" />
  </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, PayTime, OrderNoPlatform, OrderNoSystem, OrderSource, OrderStatus, OrderSite, 
    SellAccount, OrderAmount, ShipWarehouse, ProductTitle, OrderTime, PaypalInAccount, 
    PaypalOutAccount, BuyerId, BuyerName, Country, Address1, Address2, City, Province, 
    PostCode, PhoneNumber, MobileNumber, Email, CreateTime, UpdateTime, Hid, ItemId, 
    Freight, IsSystemShip, OmsUpdateTime, OmsCreateTime, MatchTime, OriginalCurrency, 
    OriginalTotal, IsRefund, BjPayTime, InterceptStatus, _ts, is_abroad, country_en_name, 
    order_system
  </sql>
  <sql id="Blob_Column_List">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    SkuInfo, EbayTransactionId, PlatformNoSources
  </sql>
  <select id="selectByExampleWithBLOBs" parameterType="com.bailuntec.domain.example.TOrderOriginalExample" resultMap="ResultMapWithBLOBs">
    <!--
      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" />
    ,
    <include refid="Blob_Column_List" />
    from t_order_original
    <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="selectByExample" parameterType="com.bailuntec.domain.example.TOrderOriginalExample" 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 t_order_original
    <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="com.bailuntec.domain.entity.TOrderOriginalKey" resultMap="ResultMapWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from t_order_original
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="com.bailuntec.domain.entity.TOrderOriginalKey">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from t_order_original
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </delete>
  <delete id="deleteByExample" parameterType="com.bailuntec.domain.example.TOrderOriginalExample">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    delete from t_order_original
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into t_order_original (Id, PayTime, OrderNoPlatform, 
      OrderNoSystem, OrderSource, OrderStatus, 
      OrderSite, SellAccount, OrderAmount, 
      ShipWarehouse, ProductTitle, OrderTime, 
      PaypalInAccount, PaypalOutAccount, BuyerId, 
      BuyerName, Country, Address1, 
      Address2, City, Province, 
      PostCode, PhoneNumber, MobileNumber, 
      Email, CreateTime, UpdateTime, 
      Hid, ItemId, Freight, 
      IsSystemShip, OmsUpdateTime, OmsCreateTime, 
      MatchTime, OriginalCurrency, OriginalTotal, 
      IsRefund, BjPayTime, InterceptStatus, 
      _ts, is_abroad, country_en_name, 
      order_system, SkuInfo, EbayTransactionId, 
      PlatformNoSources)
    values (#{id,jdbcType=BIGINT}, #{paytime,jdbcType=TIMESTAMP}, #{ordernoplatform,jdbcType=VARCHAR},
      #{ordernosystem,jdbcType=VARCHAR}, #{ordersource,jdbcType=VARCHAR}, #{orderstatus,jdbcType=VARCHAR}, 
      #{ordersite,jdbcType=VARCHAR}, #{sellaccount,jdbcType=VARCHAR}, #{orderamount,jdbcType=DECIMAL}, 
      #{shipwarehouse,jdbcType=VARCHAR}, #{producttitle,jdbcType=VARCHAR}, #{ordertime,jdbcType=TIMESTAMP},
      #{paypalinaccount,jdbcType=VARCHAR}, #{paypaloutaccount,jdbcType=VARCHAR}, #{buyerid,jdbcType=VARCHAR}, 
      #{buyername,jdbcType=VARCHAR}, #{country,jdbcType=VARCHAR}, #{address1,jdbcType=VARCHAR}, 
      #{address2,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, 
      #{postcode,jdbcType=VARCHAR}, #{phonenumber,jdbcType=VARCHAR}, #{mobilenumber,jdbcType=INTEGER}, 
      #{email,jdbcType=VARCHAR}, #{createtime,jdbcType=TIMESTAMP}, #{updatetime,jdbcType=TIMESTAMP},
      #{hid,jdbcType=BIGINT}, #{itemid,jdbcType=VARCHAR}, #{freight,jdbcType=DECIMAL}, 
      #{issystemship,jdbcType=INTEGER}, #{omsupdatetime,jdbcType=TIMESTAMP}, #{omscreatetime,jdbcType=TIMESTAMP},
      #{matchtime,jdbcType=TIMESTAMP}, #{originalcurrency,jdbcType=VARCHAR}, #{originaltotal,jdbcType=DECIMAL},
      #{isrefund,jdbcType=INTEGER}, #{bjpaytime,jdbcType=TIMESTAMP}, #{interceptstatus,jdbcType=INTEGER},
      #{ts,jdbcType=TIMESTAMP}, #{isAbroad,jdbcType=INTEGER}, #{countryEnName,jdbcType=VARCHAR},
      #{orderSystem,jdbcType=VARCHAR}, #{skuinfo,jdbcType=LONGVARCHAR}, #{ebaytransactionid,jdbcType=LONGVARCHAR}, 
      #{platformnosources,jdbcType=LONGVARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    insert into t_order_original
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        Id,
      </if>
      <if test="paytime != null">
        PayTime,
      </if>
      <if test="ordernoplatform != null">
        OrderNoPlatform,
      </if>
      <if test="ordernosystem != null">
        OrderNoSystem,
      </if>
      <if test="ordersource != null">
        OrderSource,
      </if>
      <if test="orderstatus != null">
        OrderStatus,
      </if>
      <if test="ordersite != null">
        OrderSite,
      </if>
      <if test="sellaccount != null">
        SellAccount,
      </if>
      <if test="orderamount != null">
        OrderAmount,
      </if>
      <if test="shipwarehouse != null">
        ShipWarehouse,
      </if>
      <if test="producttitle != null">
        ProductTitle,
      </if>
      <if test="ordertime != null">
        OrderTime,
      </if>
      <if test="paypalinaccount != null">
        PaypalInAccount,
      </if>
      <if test="paypaloutaccount != null">
        PaypalOutAccount,
      </if>
      <if test="buyerid != null">
        BuyerId,
      </if>
      <if test="buyername != null">
        BuyerName,
      </if>
      <if test="country != null">
        Country,
      </if>
      <if test="address1 != null">
        Address1,
      </if>
      <if test="address2 != null">
        Address2,
      </if>
      <if test="city != null">
        City,
      </if>
      <if test="province != null">
        Province,
      </if>
      <if test="postcode != null">
        PostCode,
      </if>
      <if test="phonenumber != null">
        PhoneNumber,
      </if>
      <if test="mobilenumber != null">
        MobileNumber,
      </if>
      <if test="email != null">
        Email,
      </if>
      <if test="createtime != null">
        CreateTime,
      </if>
      <if test="updatetime != null">
        UpdateTime,
      </if>
      <if test="hid != null">
        Hid,
      </if>
      <if test="itemid != null">
        ItemId,
      </if>
      <if test="freight != null">
        Freight,
      </if>
      <if test="issystemship != null">
        IsSystemShip,
      </if>
      <if test="omsupdatetime != null">
        OmsUpdateTime,
      </if>
      <if test="omscreatetime != null">
        OmsCreateTime,
      </if>
      <if test="matchtime != null">
        MatchTime,
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency,
      </if>
      <if test="originaltotal != null">
        OriginalTotal,
      </if>
      <if test="isrefund != null">
        IsRefund,
      </if>
      <if test="bjpaytime != null">
        BjPayTime,
      </if>
      <if test="interceptstatus != null">
        InterceptStatus,
      </if>
      <if test="ts != null">
        _ts,
      </if>
      <if test="isAbroad != null">
        is_abroad,
      </if>
      <if test="countryEnName != null">
        country_en_name,
      </if>
      <if test="orderSystem != null">
        order_system,
      </if>
      <if test="skuinfo != null">
        SkuInfo,
      </if>
      <if test="ebaytransactionid != null">
        EbayTransactionId,
      </if>
      <if test="platformnosources != null">
        PlatformNoSources,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordernoplatform != null">
        #{ordernoplatform,jdbcType=VARCHAR},
      </if>
      <if test="ordernosystem != null">
        #{ordernosystem,jdbcType=VARCHAR},
      </if>
      <if test="ordersource != null">
        #{ordersource,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        #{orderstatus,jdbcType=VARCHAR},
      </if>
      <if test="ordersite != null">
        #{ordersite,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="orderamount != null">
        #{orderamount,jdbcType=DECIMAL},
      </if>
      <if test="shipwarehouse != null">
        #{shipwarehouse,jdbcType=VARCHAR},
      </if>
      <if test="producttitle != null">
        #{producttitle,jdbcType=VARCHAR},
      </if>
      <if test="ordertime != null">
        #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="paypalinaccount != null">
        #{paypalinaccount,jdbcType=VARCHAR},
      </if>
      <if test="paypaloutaccount != null">
        #{paypaloutaccount,jdbcType=VARCHAR},
      </if>
      <if test="buyerid != null">
        #{buyerid,jdbcType=VARCHAR},
      </if>
      <if test="buyername != null">
        #{buyername,jdbcType=VARCHAR},
      </if>
      <if test="country != null">
        #{country,jdbcType=VARCHAR},
      </if>
      <if test="address1 != null">
        #{address1,jdbcType=VARCHAR},
      </if>
      <if test="address2 != null">
        #{address2,jdbcType=VARCHAR},
      </if>
      <if test="city != null">
        #{city,jdbcType=VARCHAR},
      </if>
      <if test="province != null">
        #{province,jdbcType=VARCHAR},
      </if>
      <if test="postcode != null">
        #{postcode,jdbcType=VARCHAR},
      </if>
      <if test="phonenumber != null">
        #{phonenumber,jdbcType=VARCHAR},
      </if>
      <if test="mobilenumber != null">
        #{mobilenumber,jdbcType=INTEGER},
      </if>
      <if test="email != null">
        #{email,jdbcType=VARCHAR},
      </if>
      <if test="createtime != null">
        #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="hid != null">
        #{hid,jdbcType=BIGINT},
      </if>
      <if test="itemid != null">
        #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="freight != null">
        #{freight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="omsupdatetime != null">
        #{omsupdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="omscreatetime != null">
        #{omscreatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="matchtime != null">
        #{matchtime,jdbcType=TIMESTAMP},
      </if>
      <if test="originalcurrency != null">
        #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="interceptstatus != null">
        #{interceptstatus,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="isAbroad != null">
        #{isAbroad,jdbcType=INTEGER},
      </if>
      <if test="countryEnName != null">
        #{countryEnName,jdbcType=VARCHAR},
      </if>
      <if test="orderSystem != null">
        #{orderSystem,jdbcType=VARCHAR},
      </if>
      <if test="skuinfo != null">
        #{skuinfo,jdbcType=LONGVARCHAR},
      </if>
      <if test="ebaytransactionid != null">
        #{ebaytransactionid,jdbcType=LONGVARCHAR},
      </if>
      <if test="platformnosources != null">
        #{platformnosources,jdbcType=LONGVARCHAR},
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.bailuntec.domain.example.TOrderOriginalExample" resultType="java.lang.Long">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    select count(*) from t_order_original
    <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 t_order_original
    <set>
      <if test="record.id != null">
        Id = #{record.id,jdbcType=BIGINT},
      </if>
      <if test="record.paytime != null">
        PayTime = #{record.paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.ordernoplatform != null">
        OrderNoPlatform = #{record.ordernoplatform,jdbcType=VARCHAR},
      </if>
      <if test="record.ordernosystem != null">
        OrderNoSystem = #{record.ordernosystem,jdbcType=VARCHAR},
      </if>
      <if test="record.ordersource != null">
        OrderSource = #{record.ordersource,jdbcType=VARCHAR},
      </if>
      <if test="record.orderstatus != null">
        OrderStatus = #{record.orderstatus,jdbcType=VARCHAR},
      </if>
      <if test="record.ordersite != null">
        OrderSite = #{record.ordersite,jdbcType=VARCHAR},
      </if>
      <if test="record.sellaccount != null">
        SellAccount = #{record.sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="record.orderamount != null">
        OrderAmount = #{record.orderamount,jdbcType=DECIMAL},
      </if>
      <if test="record.shipwarehouse != null">
        ShipWarehouse = #{record.shipwarehouse,jdbcType=VARCHAR},
      </if>
      <if test="record.producttitle != null">
        ProductTitle = #{record.producttitle,jdbcType=VARCHAR},
      </if>
      <if test="record.ordertime != null">
        OrderTime = #{record.ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.paypalinaccount != null">
        PaypalInAccount = #{record.paypalinaccount,jdbcType=VARCHAR},
      </if>
      <if test="record.paypaloutaccount != null">
        PaypalOutAccount = #{record.paypaloutaccount,jdbcType=VARCHAR},
      </if>
      <if test="record.buyerid != null">
        BuyerId = #{record.buyerid,jdbcType=VARCHAR},
      </if>
      <if test="record.buyername != null">
        BuyerName = #{record.buyername,jdbcType=VARCHAR},
      </if>
      <if test="record.country != null">
        Country = #{record.country,jdbcType=VARCHAR},
      </if>
      <if test="record.address1 != null">
        Address1 = #{record.address1,jdbcType=VARCHAR},
      </if>
      <if test="record.address2 != null">
        Address2 = #{record.address2,jdbcType=VARCHAR},
      </if>
      <if test="record.city != null">
        City = #{record.city,jdbcType=VARCHAR},
      </if>
      <if test="record.province != null">
        Province = #{record.province,jdbcType=VARCHAR},
      </if>
      <if test="record.postcode != null">
        PostCode = #{record.postcode,jdbcType=VARCHAR},
      </if>
      <if test="record.phonenumber != null">
        PhoneNumber = #{record.phonenumber,jdbcType=VARCHAR},
      </if>
      <if test="record.mobilenumber != null">
        MobileNumber = #{record.mobilenumber,jdbcType=INTEGER},
      </if>
      <if test="record.email != null">
        Email = #{record.email,jdbcType=VARCHAR},
      </if>
      <if test="record.createtime != null">
        CreateTime = #{record.createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.updatetime != null">
        UpdateTime = #{record.updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.hid != null">
        Hid = #{record.hid,jdbcType=BIGINT},
      </if>
      <if test="record.itemid != null">
        ItemId = #{record.itemid,jdbcType=VARCHAR},
      </if>
      <if test="record.freight != null">
        Freight = #{record.freight,jdbcType=DECIMAL},
      </if>
      <if test="record.issystemship != null">
        IsSystemShip = #{record.issystemship,jdbcType=INTEGER},
      </if>
      <if test="record.omsupdatetime != null">
        OmsUpdateTime = #{record.omsupdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.omscreatetime != null">
        OmsCreateTime = #{record.omscreatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.matchtime != null">
        MatchTime = #{record.matchtime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.originalcurrency != null">
        OriginalCurrency = #{record.originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="record.originaltotal != null">
        OriginalTotal = #{record.originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="record.isrefund != null">
        IsRefund = #{record.isrefund,jdbcType=INTEGER},
      </if>
      <if test="record.bjpaytime != null">
        BjPayTime = #{record.bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="record.interceptstatus != null">
        InterceptStatus = #{record.interceptstatus,jdbcType=INTEGER},
      </if>
      <if test="record.ts != null">
        _ts = #{record.ts,jdbcType=TIMESTAMP},
      </if>
      <if test="record.isAbroad != null">
        is_abroad = #{record.isAbroad,jdbcType=INTEGER},
      </if>
      <if test="record.countryEnName != null">
        country_en_name = #{record.countryEnName,jdbcType=VARCHAR},
      </if>
      <if test="record.orderSystem != null">
        order_system = #{record.orderSystem,jdbcType=VARCHAR},
      </if>
      <if test="record.skuinfo != null">
        SkuInfo = #{record.skuinfo,jdbcType=LONGVARCHAR},
      </if>
      <if test="record.ebaytransactionid != null">
        EbayTransactionId = #{record.ebaytransactionid,jdbcType=LONGVARCHAR},
      </if>
      <if test="record.platformnosources != null">
        PlatformNoSources = #{record.platformnosources,jdbcType=LONGVARCHAR},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExampleWithBLOBs" parameterType="map">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_original
    set Id = #{record.id,jdbcType=BIGINT},
      PayTime = #{record.paytime,jdbcType=TIMESTAMP},
      OrderNoPlatform = #{record.ordernoplatform,jdbcType=VARCHAR},
      OrderNoSystem = #{record.ordernosystem,jdbcType=VARCHAR},
      OrderSource = #{record.ordersource,jdbcType=VARCHAR},
      OrderStatus = #{record.orderstatus,jdbcType=VARCHAR},
      OrderSite = #{record.ordersite,jdbcType=VARCHAR},
      SellAccount = #{record.sellaccount,jdbcType=VARCHAR},
      OrderAmount = #{record.orderamount,jdbcType=DECIMAL},
      ShipWarehouse = #{record.shipwarehouse,jdbcType=VARCHAR},
      ProductTitle = #{record.producttitle,jdbcType=VARCHAR},
      OrderTime = #{record.ordertime,jdbcType=TIMESTAMP},
      PaypalInAccount = #{record.paypalinaccount,jdbcType=VARCHAR},
      PaypalOutAccount = #{record.paypaloutaccount,jdbcType=VARCHAR},
      BuyerId = #{record.buyerid,jdbcType=VARCHAR},
      BuyerName = #{record.buyername,jdbcType=VARCHAR},
      Country = #{record.country,jdbcType=VARCHAR},
      Address1 = #{record.address1,jdbcType=VARCHAR},
      Address2 = #{record.address2,jdbcType=VARCHAR},
      City = #{record.city,jdbcType=VARCHAR},
      Province = #{record.province,jdbcType=VARCHAR},
      PostCode = #{record.postcode,jdbcType=VARCHAR},
      PhoneNumber = #{record.phonenumber,jdbcType=VARCHAR},
      MobileNumber = #{record.mobilenumber,jdbcType=INTEGER},
      Email = #{record.email,jdbcType=VARCHAR},
      CreateTime = #{record.createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{record.updatetime,jdbcType=TIMESTAMP},
      Hid = #{record.hid,jdbcType=BIGINT},
      ItemId = #{record.itemid,jdbcType=VARCHAR},
      Freight = #{record.freight,jdbcType=DECIMAL},
      IsSystemShip = #{record.issystemship,jdbcType=INTEGER},
      OmsUpdateTime = #{record.omsupdatetime,jdbcType=TIMESTAMP},
      OmsCreateTime = #{record.omscreatetime,jdbcType=TIMESTAMP},
      MatchTime = #{record.matchtime,jdbcType=TIMESTAMP},
      OriginalCurrency = #{record.originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{record.originaltotal,jdbcType=DECIMAL},
      IsRefund = #{record.isrefund,jdbcType=INTEGER},
      BjPayTime = #{record.bjpaytime,jdbcType=TIMESTAMP},
      InterceptStatus = #{record.interceptstatus,jdbcType=INTEGER},
      _ts = #{record.ts,jdbcType=TIMESTAMP},
      is_abroad = #{record.isAbroad,jdbcType=INTEGER},
      country_en_name = #{record.countryEnName,jdbcType=VARCHAR},
      order_system = #{record.orderSystem,jdbcType=VARCHAR},
      SkuInfo = #{record.skuinfo,jdbcType=LONGVARCHAR},
      EbayTransactionId = #{record.ebaytransactionid,jdbcType=LONGVARCHAR},
      PlatformNoSources = #{record.platformnosources,jdbcType=LONGVARCHAR}
    <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 t_order_original
    set Id = #{record.id,jdbcType=BIGINT},
      PayTime = #{record.paytime,jdbcType=TIMESTAMP},
      OrderNoPlatform = #{record.ordernoplatform,jdbcType=VARCHAR},
      OrderNoSystem = #{record.ordernosystem,jdbcType=VARCHAR},
      OrderSource = #{record.ordersource,jdbcType=VARCHAR},
      OrderStatus = #{record.orderstatus,jdbcType=VARCHAR},
      OrderSite = #{record.ordersite,jdbcType=VARCHAR},
      SellAccount = #{record.sellaccount,jdbcType=VARCHAR},
      OrderAmount = #{record.orderamount,jdbcType=DECIMAL},
      ShipWarehouse = #{record.shipwarehouse,jdbcType=VARCHAR},
      ProductTitle = #{record.producttitle,jdbcType=VARCHAR},
      OrderTime = #{record.ordertime,jdbcType=TIMESTAMP},
      PaypalInAccount = #{record.paypalinaccount,jdbcType=VARCHAR},
      PaypalOutAccount = #{record.paypaloutaccount,jdbcType=VARCHAR},
      BuyerId = #{record.buyerid,jdbcType=VARCHAR},
      BuyerName = #{record.buyername,jdbcType=VARCHAR},
      Country = #{record.country,jdbcType=VARCHAR},
      Address1 = #{record.address1,jdbcType=VARCHAR},
      Address2 = #{record.address2,jdbcType=VARCHAR},
      City = #{record.city,jdbcType=VARCHAR},
      Province = #{record.province,jdbcType=VARCHAR},
      PostCode = #{record.postcode,jdbcType=VARCHAR},
      PhoneNumber = #{record.phonenumber,jdbcType=VARCHAR},
      MobileNumber = #{record.mobilenumber,jdbcType=INTEGER},
      Email = #{record.email,jdbcType=VARCHAR},
      CreateTime = #{record.createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{record.updatetime,jdbcType=TIMESTAMP},
      Hid = #{record.hid,jdbcType=BIGINT},
      ItemId = #{record.itemid,jdbcType=VARCHAR},
      Freight = #{record.freight,jdbcType=DECIMAL},
      IsSystemShip = #{record.issystemship,jdbcType=INTEGER},
      OmsUpdateTime = #{record.omsupdatetime,jdbcType=TIMESTAMP},
      OmsCreateTime = #{record.omscreatetime,jdbcType=TIMESTAMP},
      MatchTime = #{record.matchtime,jdbcType=TIMESTAMP},
      OriginalCurrency = #{record.originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{record.originaltotal,jdbcType=DECIMAL},
      IsRefund = #{record.isrefund,jdbcType=INTEGER},
      BjPayTime = #{record.bjpaytime,jdbcType=TIMESTAMP},
      InterceptStatus = #{record.interceptstatus,jdbcType=INTEGER},
      _ts = #{record.ts,jdbcType=TIMESTAMP},
      is_abroad = #{record.isAbroad,jdbcType=INTEGER},
      country_en_name = #{record.countryEnName,jdbcType=VARCHAR},
      order_system = #{record.orderSystem,jdbcType=VARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_original
    <set>
      <if test="ordernoplatform != null">
        OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR},
      </if>
      <if test="ordernosystem != null">
        OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR},
      </if>
      <if test="ordersource != null">
        OrderSource = #{ordersource,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        OrderStatus = #{orderstatus,jdbcType=VARCHAR},
      </if>
      <if test="ordersite != null">
        OrderSite = #{ordersite,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        SellAccount = #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="orderamount != null">
        OrderAmount = #{orderamount,jdbcType=DECIMAL},
      </if>
      <if test="shipwarehouse != null">
        ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR},
      </if>
      <if test="producttitle != null">
        ProductTitle = #{producttitle,jdbcType=VARCHAR},
      </if>
      <if test="ordertime != null">
        OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="paypalinaccount != null">
        PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR},
      </if>
      <if test="paypaloutaccount != null">
        PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR},
      </if>
      <if test="buyerid != null">
        BuyerId = #{buyerid,jdbcType=VARCHAR},
      </if>
      <if test="buyername != null">
        BuyerName = #{buyername,jdbcType=VARCHAR},
      </if>
      <if test="country != null">
        Country = #{country,jdbcType=VARCHAR},
      </if>
      <if test="address1 != null">
        Address1 = #{address1,jdbcType=VARCHAR},
      </if>
      <if test="address2 != null">
        Address2 = #{address2,jdbcType=VARCHAR},
      </if>
      <if test="city != null">
        City = #{city,jdbcType=VARCHAR},
      </if>
      <if test="province != null">
        Province = #{province,jdbcType=VARCHAR},
      </if>
      <if test="postcode != null">
        PostCode = #{postcode,jdbcType=VARCHAR},
      </if>
      <if test="phonenumber != null">
        PhoneNumber = #{phonenumber,jdbcType=VARCHAR},
      </if>
      <if test="mobilenumber != null">
        MobileNumber = #{mobilenumber,jdbcType=INTEGER},
      </if>
      <if test="email != null">
        Email = #{email,jdbcType=VARCHAR},
      </if>
      <if test="createtime != null">
        CreateTime = #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="hid != null">
        Hid = #{hid,jdbcType=BIGINT},
      </if>
      <if test="itemid != null">
        ItemId = #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="freight != null">
        Freight = #{freight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        IsSystemShip = #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="omsupdatetime != null">
        OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="omscreatetime != null">
        OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="matchtime != null">
        MatchTime = #{matchtime,jdbcType=TIMESTAMP},
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        IsRefund = #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="interceptstatus != null">
        InterceptStatus = #{interceptstatus,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        _ts = #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="isAbroad != null">
        is_abroad = #{isAbroad,jdbcType=INTEGER},
      </if>
      <if test="countryEnName != null">
        country_en_name = #{countryEnName,jdbcType=VARCHAR},
      </if>
      <if test="orderSystem != null">
        order_system = #{orderSystem,jdbcType=VARCHAR},
      </if>
      <if test="skuinfo != null">
        SkuInfo = #{skuinfo,jdbcType=LONGVARCHAR},
      </if>
      <if test="ebaytransactionid != null">
        EbayTransactionId = #{ebaytransactionid,jdbcType=LONGVARCHAR},
      </if>
      <if test="platformnosources != null">
        PlatformNoSources = #{platformnosources,jdbcType=LONGVARCHAR},
      </if>
    </set>
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </update>
  <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_original
    set OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR},
      OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR},
      OrderSource = #{ordersource,jdbcType=VARCHAR},
      OrderStatus = #{orderstatus,jdbcType=VARCHAR},
      OrderSite = #{ordersite,jdbcType=VARCHAR},
      SellAccount = #{sellaccount,jdbcType=VARCHAR},
      OrderAmount = #{orderamount,jdbcType=DECIMAL},
      ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR},
      ProductTitle = #{producttitle,jdbcType=VARCHAR},
      OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR},
      PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR},
      BuyerId = #{buyerid,jdbcType=VARCHAR},
      BuyerName = #{buyername,jdbcType=VARCHAR},
      Country = #{country,jdbcType=VARCHAR},
      Address1 = #{address1,jdbcType=VARCHAR},
      Address2 = #{address2,jdbcType=VARCHAR},
      City = #{city,jdbcType=VARCHAR},
      Province = #{province,jdbcType=VARCHAR},
      PostCode = #{postcode,jdbcType=VARCHAR},
      PhoneNumber = #{phonenumber,jdbcType=VARCHAR},
      MobileNumber = #{mobilenumber,jdbcType=INTEGER},
      Email = #{email,jdbcType=VARCHAR},
      CreateTime = #{createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      Hid = #{hid,jdbcType=BIGINT},
      ItemId = #{itemid,jdbcType=VARCHAR},
      Freight = #{freight,jdbcType=DECIMAL},
      IsSystemShip = #{issystemship,jdbcType=INTEGER},
      OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
      OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
      MatchTime = #{matchtime,jdbcType=TIMESTAMP},
      OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      IsRefund = #{isrefund,jdbcType=INTEGER},
      BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      InterceptStatus = #{interceptstatus,jdbcType=INTEGER},
      _ts = #{ts,jdbcType=TIMESTAMP},
      is_abroad = #{isAbroad,jdbcType=INTEGER},
      country_en_name = #{countryEnName,jdbcType=VARCHAR},
      order_system = #{orderSystem,jdbcType=VARCHAR},
      SkuInfo = #{skuinfo,jdbcType=LONGVARCHAR},
      EbayTransactionId = #{ebaytransactionid,jdbcType=LONGVARCHAR},
      PlatformNoSources = #{platformnosources,jdbcType=LONGVARCHAR}
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.bailuntec.domain.entity.TOrderOriginal">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    update t_order_original
    set OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR},
      OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR},
      OrderSource = #{ordersource,jdbcType=VARCHAR},
      OrderStatus = #{orderstatus,jdbcType=VARCHAR},
      OrderSite = #{ordersite,jdbcType=VARCHAR},
      SellAccount = #{sellaccount,jdbcType=VARCHAR},
      OrderAmount = #{orderamount,jdbcType=DECIMAL},
      ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR},
      ProductTitle = #{producttitle,jdbcType=VARCHAR},
      OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR},
      PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR},
      BuyerId = #{buyerid,jdbcType=VARCHAR},
      BuyerName = #{buyername,jdbcType=VARCHAR},
      Country = #{country,jdbcType=VARCHAR},
      Address1 = #{address1,jdbcType=VARCHAR},
      Address2 = #{address2,jdbcType=VARCHAR},
      City = #{city,jdbcType=VARCHAR},
      Province = #{province,jdbcType=VARCHAR},
      PostCode = #{postcode,jdbcType=VARCHAR},
      PhoneNumber = #{phonenumber,jdbcType=VARCHAR},
      MobileNumber = #{mobilenumber,jdbcType=INTEGER},
      Email = #{email,jdbcType=VARCHAR},
      CreateTime = #{createtime,jdbcType=TIMESTAMP},
      UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      Hid = #{hid,jdbcType=BIGINT},
      ItemId = #{itemid,jdbcType=VARCHAR},
      Freight = #{freight,jdbcType=DECIMAL},
      IsSystemShip = #{issystemship,jdbcType=INTEGER},
      OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
      OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
      MatchTime = #{matchtime,jdbcType=TIMESTAMP},
      OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      IsRefund = #{isrefund,jdbcType=INTEGER},
      BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      InterceptStatus = #{interceptstatus,jdbcType=INTEGER},
      _ts = #{ts,jdbcType=TIMESTAMP},
      is_abroad = #{isAbroad,jdbcType=INTEGER},
      country_en_name = #{countryEnName,jdbcType=VARCHAR},
      order_system = #{orderSystem,jdbcType=VARCHAR}
    where Id = #{id,jdbcType=BIGINT}
      and PayTime = #{paytime,jdbcType=TIMESTAMP}
  </update>
  <insert id="upsertSelective" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into t_order_original
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        Id,
      </if>
      <if test="paytime != null">
        PayTime,
      </if>
      <if test="ordernoplatform != null">
        OrderNoPlatform,
      </if>
      <if test="ordernosystem != null">
        OrderNoSystem,
      </if>
      <if test="ordersource != null">
        OrderSource,
      </if>
      <if test="orderstatus != null">
        OrderStatus,
      </if>
      <if test="ordersite != null">
        OrderSite,
      </if>
      <if test="sellaccount != null">
        SellAccount,
      </if>
      <if test="orderamount != null">
        OrderAmount,
      </if>
      <if test="shipwarehouse != null">
        ShipWarehouse,
      </if>
      <if test="producttitle != null">
        ProductTitle,
      </if>
      <if test="ordertime != null">
        OrderTime,
      </if>
      <if test="paypalinaccount != null">
        PaypalInAccount,
      </if>
      <if test="paypaloutaccount != null">
        PaypalOutAccount,
      </if>
      <if test="buyerid != null">
        BuyerId,
      </if>
      <if test="buyername != null">
        BuyerName,
      </if>
      <if test="country != null">
        Country,
      </if>
      <if test="address1 != null">
        Address1,
      </if>
      <if test="address2 != null">
        Address2,
      </if>
      <if test="city != null">
        City,
      </if>
      <if test="province != null">
        Province,
      </if>
      <if test="postcode != null">
        PostCode,
      </if>
      <if test="phonenumber != null">
        PhoneNumber,
      </if>
      <if test="mobilenumber != null">
        MobileNumber,
      </if>
      <if test="email != null">
        Email,
      </if>
      <if test="createtime != null">
        CreateTime,
      </if>
      <if test="updatetime != null">
        UpdateTime,
      </if>
      <if test="hid != null">
        Hid,
      </if>
      <if test="itemid != null">
        ItemId,
      </if>
      <if test="freight != null">
        Freight,
      </if>
      <if test="issystemship != null">
        IsSystemShip,
      </if>
      <if test="omsupdatetime != null">
        OmsUpdateTime,
      </if>
      <if test="omscreatetime != null">
        OmsCreateTime,
      </if>
      <if test="matchtime != null">
        MatchTime,
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency,
      </if>
      <if test="originaltotal != null">
        OriginalTotal,
      </if>
      <if test="isrefund != null">
        IsRefund,
      </if>
      <if test="bjpaytime != null">
        BjPayTime,
      </if>
      <if test="interceptstatus != null">
        InterceptStatus,
      </if>
      <if test="ts != null">
        _ts,
      </if>
      <if test="isAbroad != null">
        is_abroad,
      </if>
      <if test="countryEnName != null">
        country_en_name,
      </if>
      <if test="orderSystem != null">
        order_system,
      </if>
      <if test="skuinfo != null">
        SkuInfo,
      </if>
      <if test="ebaytransactionid != null">
        EbayTransactionId,
      </if>
      <if test="platformnosources != null">
        PlatformNoSources,
      </if>
    </trim>
    values
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordernoplatform != null">
        #{ordernoplatform,jdbcType=VARCHAR},
      </if>
      <if test="ordernosystem != null">
        #{ordernosystem,jdbcType=VARCHAR},
      </if>
      <if test="ordersource != null">
        #{ordersource,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        #{orderstatus,jdbcType=VARCHAR},
      </if>
      <if test="ordersite != null">
        #{ordersite,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="orderamount != null">
        #{orderamount,jdbcType=DECIMAL},
      </if>
      <if test="shipwarehouse != null">
        #{shipwarehouse,jdbcType=VARCHAR},
      </if>
      <if test="producttitle != null">
        #{producttitle,jdbcType=VARCHAR},
      </if>
      <if test="ordertime != null">
        #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="paypalinaccount != null">
        #{paypalinaccount,jdbcType=VARCHAR},
      </if>
      <if test="paypaloutaccount != null">
        #{paypaloutaccount,jdbcType=VARCHAR},
      </if>
      <if test="buyerid != null">
        #{buyerid,jdbcType=VARCHAR},
      </if>
      <if test="buyername != null">
        #{buyername,jdbcType=VARCHAR},
      </if>
      <if test="country != null">
        #{country,jdbcType=VARCHAR},
      </if>
      <if test="address1 != null">
        #{address1,jdbcType=VARCHAR},
      </if>
      <if test="address2 != null">
        #{address2,jdbcType=VARCHAR},
      </if>
      <if test="city != null">
        #{city,jdbcType=VARCHAR},
      </if>
      <if test="province != null">
        #{province,jdbcType=VARCHAR},
      </if>
      <if test="postcode != null">
        #{postcode,jdbcType=VARCHAR},
      </if>
      <if test="phonenumber != null">
        #{phonenumber,jdbcType=VARCHAR},
      </if>
      <if test="mobilenumber != null">
        #{mobilenumber,jdbcType=INTEGER},
      </if>
      <if test="email != null">
        #{email,jdbcType=VARCHAR},
      </if>
      <if test="createtime != null">
        #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="hid != null">
        #{hid,jdbcType=BIGINT},
      </if>
      <if test="itemid != null">
        #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="freight != null">
        #{freight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="omsupdatetime != null">
        #{omsupdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="omscreatetime != null">
        #{omscreatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="matchtime != null">
        #{matchtime,jdbcType=TIMESTAMP},
      </if>
      <if test="originalcurrency != null">
        #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="interceptstatus != null">
        #{interceptstatus,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="isAbroad != null">
        #{isAbroad,jdbcType=INTEGER},
      </if>
      <if test="countryEnName != null">
        #{countryEnName,jdbcType=VARCHAR},
      </if>
      <if test="orderSystem != null">
        #{orderSystem,jdbcType=VARCHAR},
      </if>
      <if test="skuinfo != null">
        #{skuinfo,jdbcType=LONGVARCHAR},
      </if>
      <if test="ebaytransactionid != null">
        #{ebaytransactionid,jdbcType=LONGVARCHAR},
      </if>
      <if test="platformnosources != null">
        #{platformnosources,jdbcType=LONGVARCHAR},
      </if>
    </trim>
    on duplicate key update 
    <trim suffixOverrides=",">
      <if test="id != null">
        Id = #{id,jdbcType=BIGINT},
      </if>
      <if test="paytime != null">
        PayTime = #{paytime,jdbcType=TIMESTAMP},
      </if>
      <if test="ordernoplatform != null">
        OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR},
      </if>
      <if test="ordernosystem != null">
        OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR},
      </if>
      <if test="ordersource != null">
        OrderSource = #{ordersource,jdbcType=VARCHAR},
      </if>
      <if test="orderstatus != null">
        OrderStatus = #{orderstatus,jdbcType=VARCHAR},
      </if>
      <if test="ordersite != null">
        OrderSite = #{ordersite,jdbcType=VARCHAR},
      </if>
      <if test="sellaccount != null">
        SellAccount = #{sellaccount,jdbcType=VARCHAR},
      </if>
      <if test="orderamount != null">
        OrderAmount = #{orderamount,jdbcType=DECIMAL},
      </if>
      <if test="shipwarehouse != null">
        ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR},
      </if>
      <if test="producttitle != null">
        ProductTitle = #{producttitle,jdbcType=VARCHAR},
      </if>
      <if test="ordertime != null">
        OrderTime = #{ordertime,jdbcType=TIMESTAMP},
      </if>
      <if test="paypalinaccount != null">
        PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR},
      </if>
      <if test="paypaloutaccount != null">
        PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR},
      </if>
      <if test="buyerid != null">
        BuyerId = #{buyerid,jdbcType=VARCHAR},
      </if>
      <if test="buyername != null">
        BuyerName = #{buyername,jdbcType=VARCHAR},
      </if>
      <if test="country != null">
        Country = #{country,jdbcType=VARCHAR},
      </if>
      <if test="address1 != null">
        Address1 = #{address1,jdbcType=VARCHAR},
      </if>
      <if test="address2 != null">
        Address2 = #{address2,jdbcType=VARCHAR},
      </if>
      <if test="city != null">
        City = #{city,jdbcType=VARCHAR},
      </if>
      <if test="province != null">
        Province = #{province,jdbcType=VARCHAR},
      </if>
      <if test="postcode != null">
        PostCode = #{postcode,jdbcType=VARCHAR},
      </if>
      <if test="phonenumber != null">
        PhoneNumber = #{phonenumber,jdbcType=VARCHAR},
      </if>
      <if test="mobilenumber != null">
        MobileNumber = #{mobilenumber,jdbcType=INTEGER},
      </if>
      <if test="email != null">
        Email = #{email,jdbcType=VARCHAR},
      </if>
      <if test="createtime != null">
        CreateTime = #{createtime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatetime != null">
        UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="hid != null">
        Hid = #{hid,jdbcType=BIGINT},
      </if>
      <if test="itemid != null">
        ItemId = #{itemid,jdbcType=VARCHAR},
      </if>
      <if test="freight != null">
        Freight = #{freight,jdbcType=DECIMAL},
      </if>
      <if test="issystemship != null">
        IsSystemShip = #{issystemship,jdbcType=INTEGER},
      </if>
      <if test="omsupdatetime != null">
        OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="omscreatetime != null">
        OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
      </if>
      <if test="matchtime != null">
        MatchTime = #{matchtime,jdbcType=TIMESTAMP},
      </if>
      <if test="originalcurrency != null">
        OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR},
      </if>
      <if test="originaltotal != null">
        OriginalTotal = #{originaltotal,jdbcType=DECIMAL},
      </if>
      <if test="isrefund != null">
        IsRefund = #{isrefund,jdbcType=INTEGER},
      </if>
      <if test="bjpaytime != null">
        BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
      </if>
      <if test="interceptstatus != null">
        InterceptStatus = #{interceptstatus,jdbcType=INTEGER},
      </if>
      <if test="ts != null">
        _ts = #{ts,jdbcType=TIMESTAMP},
      </if>
      <if test="isAbroad != null">
        is_abroad = #{isAbroad,jdbcType=INTEGER},
      </if>
      <if test="countryEnName != null">
        country_en_name = #{countryEnName,jdbcType=VARCHAR},
      </if>
      <if test="orderSystem != null">
        order_system = #{orderSystem,jdbcType=VARCHAR},
      </if>
      <if test="skuinfo != null">
        SkuInfo = #{skuinfo,jdbcType=LONGVARCHAR},
      </if>
      <if test="ebaytransactionid != null">
        EbayTransactionId = #{ebaytransactionid,jdbcType=LONGVARCHAR},
      </if>
      <if test="platformnosources != null">
        PlatformNoSources = #{platformnosources,jdbcType=LONGVARCHAR},
      </if>
    </trim>
  </insert>
  <insert id="upsert" parameterType="com.bailuntec.domain.entity.TOrderOriginal">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into t_order_original
    (Id, PayTime, OrderNoPlatform, OrderNoSystem, OrderSource, OrderStatus, OrderSite, 
      SellAccount, OrderAmount, ShipWarehouse, ProductTitle, OrderTime, PaypalInAccount, 
      PaypalOutAccount, BuyerId, BuyerName, Country, Address1, Address2, City, Province, 
      PostCode, PhoneNumber, MobileNumber, Email, CreateTime, UpdateTime, Hid, ItemId, 
      Freight, IsSystemShip, OmsUpdateTime, OmsCreateTime, MatchTime, OriginalCurrency, 
      OriginalTotal, IsRefund, BjPayTime, InterceptStatus, _ts, is_abroad, country_en_name, 
      order_system)
    values
    (#{id,jdbcType=BIGINT}, #{paytime,jdbcType=TIMESTAMP}, #{ordernoplatform,jdbcType=VARCHAR},
      #{ordernosystem,jdbcType=VARCHAR}, #{ordersource,jdbcType=VARCHAR}, #{orderstatus,jdbcType=VARCHAR}, 
      #{ordersite,jdbcType=VARCHAR}, #{sellaccount,jdbcType=VARCHAR}, #{orderamount,jdbcType=DECIMAL}, 
      #{shipwarehouse,jdbcType=VARCHAR}, #{producttitle,jdbcType=VARCHAR}, #{ordertime,jdbcType=TIMESTAMP},
      #{paypalinaccount,jdbcType=VARCHAR}, #{paypaloutaccount,jdbcType=VARCHAR}, #{buyerid,jdbcType=VARCHAR}, 
      #{buyername,jdbcType=VARCHAR}, #{country,jdbcType=VARCHAR}, #{address1,jdbcType=VARCHAR}, 
      #{address2,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, 
      #{postcode,jdbcType=VARCHAR}, #{phonenumber,jdbcType=VARCHAR}, #{mobilenumber,jdbcType=INTEGER}, 
      #{email,jdbcType=VARCHAR}, #{createtime,jdbcType=TIMESTAMP}, #{updatetime,jdbcType=TIMESTAMP},
      #{hid,jdbcType=BIGINT}, #{itemid,jdbcType=VARCHAR}, #{freight,jdbcType=DECIMAL}, 
      #{issystemship,jdbcType=INTEGER}, #{omsupdatetime,jdbcType=TIMESTAMP}, #{omscreatetime,jdbcType=TIMESTAMP},
      #{matchtime,jdbcType=TIMESTAMP}, #{originalcurrency,jdbcType=VARCHAR}, #{originaltotal,jdbcType=DECIMAL},
      #{isrefund,jdbcType=INTEGER}, #{bjpaytime,jdbcType=TIMESTAMP}, #{interceptstatus,jdbcType=INTEGER},
      #{ts,jdbcType=TIMESTAMP}, #{isAbroad,jdbcType=INTEGER}, #{countryEnName,jdbcType=VARCHAR},
      #{orderSystem,jdbcType=VARCHAR})
    on duplicate key update 
    Id = #{id,jdbcType=BIGINT}, 
    PayTime = #{paytime,jdbcType=TIMESTAMP},
    OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR}, 
    OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR}, 
    OrderSource = #{ordersource,jdbcType=VARCHAR}, 
    OrderStatus = #{orderstatus,jdbcType=VARCHAR}, 
    OrderSite = #{ordersite,jdbcType=VARCHAR}, 
    SellAccount = #{sellaccount,jdbcType=VARCHAR}, 
    OrderAmount = #{orderamount,jdbcType=DECIMAL}, 
    ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR}, 
    ProductTitle = #{producttitle,jdbcType=VARCHAR}, 
    OrderTime = #{ordertime,jdbcType=TIMESTAMP},
    PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR}, 
    PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR}, 
    BuyerId = #{buyerid,jdbcType=VARCHAR}, 
    BuyerName = #{buyername,jdbcType=VARCHAR}, 
    Country = #{country,jdbcType=VARCHAR}, 
    Address1 = #{address1,jdbcType=VARCHAR}, 
    Address2 = #{address2,jdbcType=VARCHAR}, 
    City = #{city,jdbcType=VARCHAR}, 
    Province = #{province,jdbcType=VARCHAR}, 
    PostCode = #{postcode,jdbcType=VARCHAR}, 
    PhoneNumber = #{phonenumber,jdbcType=VARCHAR}, 
    MobileNumber = #{mobilenumber,jdbcType=INTEGER}, 
    Email = #{email,jdbcType=VARCHAR}, 
    CreateTime = #{createtime,jdbcType=TIMESTAMP},
    UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
    Hid = #{hid,jdbcType=BIGINT}, 
    ItemId = #{itemid,jdbcType=VARCHAR}, 
    Freight = #{freight,jdbcType=DECIMAL}, 
    IsSystemShip = #{issystemship,jdbcType=INTEGER}, 
    OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
    OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
    MatchTime = #{matchtime,jdbcType=TIMESTAMP},
    OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR}, 
    OriginalTotal = #{originaltotal,jdbcType=DECIMAL}, 
    IsRefund = #{isrefund,jdbcType=INTEGER}, 
    BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
    InterceptStatus = #{interceptstatus,jdbcType=INTEGER}, 
    _ts = #{ts,jdbcType=TIMESTAMP},
    is_abroad = #{isAbroad,jdbcType=INTEGER}, 
    country_en_name = #{countryEnName,jdbcType=VARCHAR}, 
    order_system = #{orderSystem,jdbcType=VARCHAR}
  </insert>
  <insert id="upsertWithBLOBs" parameterType="com.bailuntec.domain.entity.TOrderOriginalWithBLOBs">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
      @project https://github.com/itfsw/mybatis-generator-plugin
    -->
    insert into t_order_original
    (Id, PayTime, OrderNoPlatform, OrderNoSystem, OrderSource, OrderStatus, OrderSite, 
      SellAccount, OrderAmount, ShipWarehouse, ProductTitle, OrderTime, PaypalInAccount, 
      PaypalOutAccount, BuyerId, BuyerName, Country, Address1, Address2, City, Province, 
      PostCode, PhoneNumber, MobileNumber, Email, CreateTime, UpdateTime, Hid, ItemId, 
      Freight, IsSystemShip, OmsUpdateTime, OmsCreateTime, MatchTime, OriginalCurrency, 
      OriginalTotal, IsRefund, BjPayTime, InterceptStatus, _ts, is_abroad, country_en_name, 
      order_system, SkuInfo, EbayTransactionId, PlatformNoSources)
    values
    (#{id,jdbcType=BIGINT}, #{paytime,jdbcType=TIMESTAMP}, #{ordernoplatform,jdbcType=VARCHAR},
      #{ordernosystem,jdbcType=VARCHAR}, #{ordersource,jdbcType=VARCHAR}, #{orderstatus,jdbcType=VARCHAR}, 
      #{ordersite,jdbcType=VARCHAR}, #{sellaccount,jdbcType=VARCHAR}, #{orderamount,jdbcType=DECIMAL}, 
      #{shipwarehouse,jdbcType=VARCHAR}, #{producttitle,jdbcType=VARCHAR}, #{ordertime,jdbcType=TIMESTAMP},
      #{paypalinaccount,jdbcType=VARCHAR}, #{paypaloutaccount,jdbcType=VARCHAR}, #{buyerid,jdbcType=VARCHAR}, 
      #{buyername,jdbcType=VARCHAR}, #{country,jdbcType=VARCHAR}, #{address1,jdbcType=VARCHAR}, 
      #{address2,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, 
      #{postcode,jdbcType=VARCHAR}, #{phonenumber,jdbcType=VARCHAR}, #{mobilenumber,jdbcType=INTEGER}, 
      #{email,jdbcType=VARCHAR}, #{createtime,jdbcType=TIMESTAMP}, #{updatetime,jdbcType=TIMESTAMP},
      #{hid,jdbcType=BIGINT}, #{itemid,jdbcType=VARCHAR}, #{freight,jdbcType=DECIMAL}, 
      #{issystemship,jdbcType=INTEGER}, #{omsupdatetime,jdbcType=TIMESTAMP}, #{omscreatetime,jdbcType=TIMESTAMP},
      #{matchtime,jdbcType=TIMESTAMP}, #{originalcurrency,jdbcType=VARCHAR}, #{originaltotal,jdbcType=DECIMAL},
      #{isrefund,jdbcType=INTEGER}, #{bjpaytime,jdbcType=TIMESTAMP}, #{interceptstatus,jdbcType=INTEGER},
      #{ts,jdbcType=TIMESTAMP}, #{isAbroad,jdbcType=INTEGER}, #{countryEnName,jdbcType=VARCHAR},
      #{orderSystem,jdbcType=VARCHAR}, #{skuinfo,jdbcType=LONGVARCHAR}, #{ebaytransactionid,jdbcType=LONGVARCHAR}, 
      #{platformnosources,jdbcType=LONGVARCHAR})
    on duplicate key update 
    Id = #{id,jdbcType=BIGINT}, 
    PayTime = #{paytime,jdbcType=TIMESTAMP},
    OrderNoPlatform = #{ordernoplatform,jdbcType=VARCHAR}, 
    OrderNoSystem = #{ordernosystem,jdbcType=VARCHAR}, 
    OrderSource = #{ordersource,jdbcType=VARCHAR}, 
    OrderStatus = #{orderstatus,jdbcType=VARCHAR}, 
    OrderSite = #{ordersite,jdbcType=VARCHAR}, 
    SellAccount = #{sellaccount,jdbcType=VARCHAR}, 
    OrderAmount = #{orderamount,jdbcType=DECIMAL}, 
    ShipWarehouse = #{shipwarehouse,jdbcType=VARCHAR}, 
    ProductTitle = #{producttitle,jdbcType=VARCHAR}, 
    OrderTime = #{ordertime,jdbcType=TIMESTAMP},
    PaypalInAccount = #{paypalinaccount,jdbcType=VARCHAR}, 
    PaypalOutAccount = #{paypaloutaccount,jdbcType=VARCHAR}, 
    BuyerId = #{buyerid,jdbcType=VARCHAR}, 
    BuyerName = #{buyername,jdbcType=VARCHAR}, 
    Country = #{country,jdbcType=VARCHAR}, 
    Address1 = #{address1,jdbcType=VARCHAR}, 
    Address2 = #{address2,jdbcType=VARCHAR}, 
    City = #{city,jdbcType=VARCHAR}, 
    Province = #{province,jdbcType=VARCHAR}, 
    PostCode = #{postcode,jdbcType=VARCHAR}, 
    PhoneNumber = #{phonenumber,jdbcType=VARCHAR}, 
    MobileNumber = #{mobilenumber,jdbcType=INTEGER}, 
    Email = #{email,jdbcType=VARCHAR}, 
    CreateTime = #{createtime,jdbcType=TIMESTAMP},
    UpdateTime = #{updatetime,jdbcType=TIMESTAMP},
    Hid = #{hid,jdbcType=BIGINT}, 
    ItemId = #{itemid,jdbcType=VARCHAR}, 
    Freight = #{freight,jdbcType=DECIMAL}, 
    IsSystemShip = #{issystemship,jdbcType=INTEGER}, 
    OmsUpdateTime = #{omsupdatetime,jdbcType=TIMESTAMP},
    OmsCreateTime = #{omscreatetime,jdbcType=TIMESTAMP},
    MatchTime = #{matchtime,jdbcType=TIMESTAMP},
    OriginalCurrency = #{originalcurrency,jdbcType=VARCHAR}, 
    OriginalTotal = #{originaltotal,jdbcType=DECIMAL}, 
    IsRefund = #{isrefund,jdbcType=INTEGER}, 
    BjPayTime = #{bjpaytime,jdbcType=TIMESTAMP},
    InterceptStatus = #{interceptstatus,jdbcType=INTEGER}, 
    _ts = #{ts,jdbcType=TIMESTAMP},
    is_abroad = #{isAbroad,jdbcType=INTEGER}, 
    country_en_name = #{countryEnName,jdbcType=VARCHAR}, 
    order_system = #{orderSystem,jdbcType=VARCHAR}, 
    SkuInfo = #{skuinfo,jdbcType=LONGVARCHAR}, 
    EbayTransactionId = #{ebaytransactionid,jdbcType=LONGVARCHAR}, 
    PlatformNoSources = #{platformnosources,jdbcType=LONGVARCHAR}
  </insert>
  <select id="selectOneByExample" parameterType="com.bailuntec.domain.example.TOrderOriginalExample" 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 t_order_original
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
  <select id="selectOneByExampleWithBLOBs" parameterType="com.bailuntec.domain.example.TOrderOriginalExample" resultMap="ResultMapWithBLOBs">
    <!--
      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" />
    ,
    <include refid="Blob_Column_List" />
    from t_order_original
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
    limit 1
  </select>
</mapper>