package com.bailuntec.domain.example;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

public class DcBaseOmsPickExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    protected Integer offset;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    protected Integer rows;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public DcBaseOmsPickExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public static Criteria newAndCreateCriteria() {
        DcBaseOmsPickExample example = new DcBaseOmsPickExample();
        return example.createCriteria();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public Integer getOffset() {
        return this.offset;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public void setRows(Integer rows) {
        this.rows = rows;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public Integer getRows() {
        return this.rows;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcBaseOmsPickExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdIsNull() {
            addCriterion("origin_order_id is null");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdIsNotNull() {
            addCriterion("origin_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdEqualTo(String value) {
            addCriterion("origin_order_id =", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdNotEqualTo(String value) {
            addCriterion("origin_order_id <>", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdGreaterThan(String value) {
            addCriterion("origin_order_id >", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("origin_order_id >=", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdLessThan(String value) {
            addCriterion("origin_order_id <", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdLessThanOrEqualTo(String value) {
            addCriterion("origin_order_id <=", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdLike(String value) {
            addCriterion("origin_order_id like", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdNotLike(String value) {
            addCriterion("origin_order_id not like", value, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdIn(List<String> values) {
            addCriterion("origin_order_id in", values, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdNotIn(List<String> values) {
            addCriterion("origin_order_id not in", values, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdBetween(String value1, String value2) {
            addCriterion("origin_order_id between", value1, value2, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andOriginOrderIdNotBetween(String value1, String value2) {
            addCriterion("origin_order_id not between", value1, value2, "originOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdIsNull() {
            addCriterion("bailun_account_id is null");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdIsNotNull() {
            addCriterion("bailun_account_id is not null");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdEqualTo(Integer value) {
            addCriterion("bailun_account_id =", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdNotEqualTo(Integer value) {
            addCriterion("bailun_account_id <>", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdGreaterThan(Integer value) {
            addCriterion("bailun_account_id >", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bailun_account_id >=", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdLessThan(Integer value) {
            addCriterion("bailun_account_id <", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdLessThanOrEqualTo(Integer value) {
            addCriterion("bailun_account_id <=", value, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdIn(List<Integer> values) {
            addCriterion("bailun_account_id in", values, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdNotIn(List<Integer> values) {
            addCriterion("bailun_account_id not in", values, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdBetween(Integer value1, Integer value2) {
            addCriterion("bailun_account_id between", value1, value2, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunAccountIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bailun_account_id not between", value1, value2, "bailunAccountId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdIsNull() {
            addCriterion("bailun_order_id is null");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdIsNotNull() {
            addCriterion("bailun_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdEqualTo(String value) {
            addCriterion("bailun_order_id =", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdNotEqualTo(String value) {
            addCriterion("bailun_order_id <>", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdGreaterThan(String value) {
            addCriterion("bailun_order_id >", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("bailun_order_id >=", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdLessThan(String value) {
            addCriterion("bailun_order_id <", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdLessThanOrEqualTo(String value) {
            addCriterion("bailun_order_id <=", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdLike(String value) {
            addCriterion("bailun_order_id like", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdNotLike(String value) {
            addCriterion("bailun_order_id not like", value, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdIn(List<String> values) {
            addCriterion("bailun_order_id in", values, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdNotIn(List<String> values) {
            addCriterion("bailun_order_id not in", values, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdBetween(String value1, String value2) {
            addCriterion("bailun_order_id between", value1, value2, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andBailunOrderIdNotBetween(String value1, String value2) {
            addCriterion("bailun_order_id not between", value1, value2, "bailunOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdIsNull() {
            addCriterion("pick_order_id is null");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdIsNotNull() {
            addCriterion("pick_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdEqualTo(String value) {
            addCriterion("pick_order_id =", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdNotEqualTo(String value) {
            addCriterion("pick_order_id <>", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdGreaterThan(String value) {
            addCriterion("pick_order_id >", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("pick_order_id >=", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdLessThan(String value) {
            addCriterion("pick_order_id <", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdLessThanOrEqualTo(String value) {
            addCriterion("pick_order_id <=", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdLike(String value) {
            addCriterion("pick_order_id like", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdNotLike(String value) {
            addCriterion("pick_order_id not like", value, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdIn(List<String> values) {
            addCriterion("pick_order_id in", values, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdNotIn(List<String> values) {
            addCriterion("pick_order_id not in", values, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdBetween(String value1, String value2) {
            addCriterion("pick_order_id between", value1, value2, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andPickOrderIdNotBetween(String value1, String value2) {
            addCriterion("pick_order_id not between", value1, value2, "pickOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderIsNull() {
            addCriterion("tracking_provider is null");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderIsNotNull() {
            addCriterion("tracking_provider is not null");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderEqualTo(String value) {
            addCriterion("tracking_provider =", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderNotEqualTo(String value) {
            addCriterion("tracking_provider <>", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderGreaterThan(String value) {
            addCriterion("tracking_provider >", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderGreaterThanOrEqualTo(String value) {
            addCriterion("tracking_provider >=", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderLessThan(String value) {
            addCriterion("tracking_provider <", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderLessThanOrEqualTo(String value) {
            addCriterion("tracking_provider <=", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderLike(String value) {
            addCriterion("tracking_provider like", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderNotLike(String value) {
            addCriterion("tracking_provider not like", value, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderIn(List<String> values) {
            addCriterion("tracking_provider in", values, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderNotIn(List<String> values) {
            addCriterion("tracking_provider not in", values, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderBetween(String value1, String value2) {
            addCriterion("tracking_provider between", value1, value2, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingProviderNotBetween(String value1, String value2) {
            addCriterion("tracking_provider not between", value1, value2, "trackingProvider");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdIsNull() {
            addCriterion("tracking_order_id is null");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdIsNotNull() {
            addCriterion("tracking_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdEqualTo(String value) {
            addCriterion("tracking_order_id =", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdNotEqualTo(String value) {
            addCriterion("tracking_order_id <>", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdGreaterThan(String value) {
            addCriterion("tracking_order_id >", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("tracking_order_id >=", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdLessThan(String value) {
            addCriterion("tracking_order_id <", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdLessThanOrEqualTo(String value) {
            addCriterion("tracking_order_id <=", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdLike(String value) {
            addCriterion("tracking_order_id like", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdNotLike(String value) {
            addCriterion("tracking_order_id not like", value, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdIn(List<String> values) {
            addCriterion("tracking_order_id in", values, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdNotIn(List<String> values) {
            addCriterion("tracking_order_id not in", values, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdBetween(String value1, String value2) {
            addCriterion("tracking_order_id between", value1, value2, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andTrackingOrderIdNotBetween(String value1, String value2) {
            addCriterion("tracking_order_id not between", value1, value2, "trackingOrderId");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIsNull() {
            addCriterion("shipping_status is null");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIsNotNull() {
            addCriterion("shipping_status is not null");
            return (Criteria) this;
        }

        public Criteria andShippingStatusEqualTo(String value) {
            addCriterion("shipping_status =", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotEqualTo(String value) {
            addCriterion("shipping_status <>", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusGreaterThan(String value) {
            addCriterion("shipping_status >", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusGreaterThanOrEqualTo(String value) {
            addCriterion("shipping_status >=", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusLessThan(String value) {
            addCriterion("shipping_status <", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusLessThanOrEqualTo(String value) {
            addCriterion("shipping_status <=", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusLike(String value) {
            addCriterion("shipping_status like", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotLike(String value) {
            addCriterion("shipping_status not like", value, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusIn(List<String> values) {
            addCriterion("shipping_status in", values, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotIn(List<String> values) {
            addCriterion("shipping_status not in", values, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusBetween(String value1, String value2) {
            addCriterion("shipping_status between", value1, value2, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andShippingStatusNotBetween(String value1, String value2) {
            addCriterion("shipping_status not between", value1, value2, "shippingStatus");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(LocalDateTime value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(LocalDateTime value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(LocalDateTime value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(LocalDateTime value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<LocalDateTime> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<LocalDateTime> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeIsNull() {
            addCriterion("shipping_time is null");
            return (Criteria) this;
        }

        public Criteria andShippingTimeIsNotNull() {
            addCriterion("shipping_time is not null");
            return (Criteria) this;
        }

        public Criteria andShippingTimeEqualTo(LocalDateTime value) {
            addCriterion("shipping_time =", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeNotEqualTo(LocalDateTime value) {
            addCriterion("shipping_time <>", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeGreaterThan(LocalDateTime value) {
            addCriterion("shipping_time >", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("shipping_time >=", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeLessThan(LocalDateTime value) {
            addCriterion("shipping_time <", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("shipping_time <=", value, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeIn(List<LocalDateTime> values) {
            addCriterion("shipping_time in", values, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeNotIn(List<LocalDateTime> values) {
            addCriterion("shipping_time not in", values, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("shipping_time between", value1, value2, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andShippingTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("shipping_time not between", value1, value2, "shippingTime");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameIsNull() {
            addCriterion("warehouse_name is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameIsNotNull() {
            addCriterion("warehouse_name is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameEqualTo(String value) {
            addCriterion("warehouse_name =", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotEqualTo(String value) {
            addCriterion("warehouse_name <>", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameGreaterThan(String value) {
            addCriterion("warehouse_name >", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_name >=", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameLessThan(String value) {
            addCriterion("warehouse_name <", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameLessThanOrEqualTo(String value) {
            addCriterion("warehouse_name <=", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameLike(String value) {
            addCriterion("warehouse_name like", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotLike(String value) {
            addCriterion("warehouse_name not like", value, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameIn(List<String> values) {
            addCriterion("warehouse_name in", values, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotIn(List<String> values) {
            addCriterion("warehouse_name not in", values, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameBetween(String value1, String value2) {
            addCriterion("warehouse_name between", value1, value2, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseNameNotBetween(String value1, String value2) {
            addCriterion("warehouse_name not between", value1, value2, "warehouseName");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeIsNull() {
            addCriterion("warehouse_code is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeIsNotNull() {
            addCriterion("warehouse_code is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeEqualTo(String value) {
            addCriterion("warehouse_code =", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotEqualTo(String value) {
            addCriterion("warehouse_code <>", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeGreaterThan(String value) {
            addCriterion("warehouse_code >", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_code >=", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeLessThan(String value) {
            addCriterion("warehouse_code <", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeLessThanOrEqualTo(String value) {
            addCriterion("warehouse_code <=", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeLike(String value) {
            addCriterion("warehouse_code like", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotLike(String value) {
            addCriterion("warehouse_code not like", value, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeIn(List<String> values) {
            addCriterion("warehouse_code in", values, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotIn(List<String> values) {
            addCriterion("warehouse_code not in", values, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeBetween(String value1, String value2) {
            addCriterion("warehouse_code between", value1, value2, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andWarehouseCodeNotBetween(String value1, String value2) {
            addCriterion("warehouse_code not between", value1, value2, "warehouseCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdIsNull() {
            addCriterion("logistics_order_id is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdIsNotNull() {
            addCriterion("logistics_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdEqualTo(String value) {
            addCriterion("logistics_order_id =", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdNotEqualTo(String value) {
            addCriterion("logistics_order_id <>", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdGreaterThan(String value) {
            addCriterion("logistics_order_id >", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_order_id >=", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdLessThan(String value) {
            addCriterion("logistics_order_id <", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdLessThanOrEqualTo(String value) {
            addCriterion("logistics_order_id <=", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdLike(String value) {
            addCriterion("logistics_order_id like", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdNotLike(String value) {
            addCriterion("logistics_order_id not like", value, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdIn(List<String> values) {
            addCriterion("logistics_order_id in", values, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdNotIn(List<String> values) {
            addCriterion("logistics_order_id not in", values, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdBetween(String value1, String value2) {
            addCriterion("logistics_order_id between", value1, value2, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderIdNotBetween(String value1, String value2) {
            addCriterion("logistics_order_id not between", value1, value2, "logisticsOrderId");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameIsNull() {
            addCriterion("logistics_order_name is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameIsNotNull() {
            addCriterion("logistics_order_name is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameEqualTo(String value) {
            addCriterion("logistics_order_name =", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameNotEqualTo(String value) {
            addCriterion("logistics_order_name <>", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameGreaterThan(String value) {
            addCriterion("logistics_order_name >", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_order_name >=", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameLessThan(String value) {
            addCriterion("logistics_order_name <", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameLessThanOrEqualTo(String value) {
            addCriterion("logistics_order_name <=", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameLike(String value) {
            addCriterion("logistics_order_name like", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameNotLike(String value) {
            addCriterion("logistics_order_name not like", value, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameIn(List<String> values) {
            addCriterion("logistics_order_name in", values, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameNotIn(List<String> values) {
            addCriterion("logistics_order_name not in", values, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameBetween(String value1, String value2) {
            addCriterion("logistics_order_name between", value1, value2, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andLogisticsOrderNameNotBetween(String value1, String value2) {
            addCriterion("logistics_order_name not between", value1, value2, "logisticsOrderName");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDateTime value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDateTime value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDateTime value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDateTime value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDateTime> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDateTime> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDateTime value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDateTime value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDateTime> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDateTime> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedIsNull() {
            addCriterion("quantity_picked is null");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedIsNotNull() {
            addCriterion("quantity_picked is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedEqualTo(Integer value) {
            addCriterion("quantity_picked =", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedNotEqualTo(Integer value) {
            addCriterion("quantity_picked <>", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedGreaterThan(Integer value) {
            addCriterion("quantity_picked >", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_picked >=", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedLessThan(Integer value) {
            addCriterion("quantity_picked <", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_picked <=", value, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedIn(List<Integer> values) {
            addCriterion("quantity_picked in", values, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedNotIn(List<Integer> values) {
            addCriterion("quantity_picked not in", values, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedBetween(Integer value1, Integer value2) {
            addCriterion("quantity_picked between", value1, value2, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityPickedNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_picked not between", value1, value2, "quantityPicked");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedIsNull() {
            addCriterion("quantity_shipped is null");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedIsNotNull() {
            addCriterion("quantity_shipped is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedEqualTo(Integer value) {
            addCriterion("quantity_shipped =", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedNotEqualTo(Integer value) {
            addCriterion("quantity_shipped <>", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedGreaterThan(Integer value) {
            addCriterion("quantity_shipped >", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_shipped >=", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedLessThan(Integer value) {
            addCriterion("quantity_shipped <", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_shipped <=", value, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedIn(List<Integer> values) {
            addCriterion("quantity_shipped in", values, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedNotIn(List<Integer> values) {
            addCriterion("quantity_shipped not in", values, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedBetween(Integer value1, Integer value2) {
            addCriterion("quantity_shipped between", value1, value2, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andQuantityShippedNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_shipped not between", value1, value2, "quantityShipped");
            return (Criteria) this;
        }

        public Criteria andBailunSkuIsNull() {
            addCriterion("bailun_sku is null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuIsNotNull() {
            addCriterion("bailun_sku is not null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuEqualTo(String value) {
            addCriterion("bailun_sku =", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotEqualTo(String value) {
            addCriterion("bailun_sku <>", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuGreaterThan(String value) {
            addCriterion("bailun_sku >", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuGreaterThanOrEqualTo(String value) {
            addCriterion("bailun_sku >=", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuLessThan(String value) {
            addCriterion("bailun_sku <", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuLessThanOrEqualTo(String value) {
            addCriterion("bailun_sku <=", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuLike(String value) {
            addCriterion("bailun_sku like", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotLike(String value) {
            addCriterion("bailun_sku not like", value, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuIn(List<String> values) {
            addCriterion("bailun_sku in", values, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotIn(List<String> values) {
            addCriterion("bailun_sku not in", values, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuBetween(String value1, String value2) {
            addCriterion("bailun_sku between", value1, value2, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andBailunSkuNotBetween(String value1, String value2) {
            addCriterion("bailun_sku not between", value1, value2, "bailunSku");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceIsNull() {
            addCriterion("declare_price is null");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceIsNotNull() {
            addCriterion("declare_price is not null");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceEqualTo(BigDecimal value) {
            addCriterion("declare_price =", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceNotEqualTo(BigDecimal value) {
            addCriterion("declare_price <>", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceGreaterThan(BigDecimal value) {
            addCriterion("declare_price >", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("declare_price >=", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceLessThan(BigDecimal value) {
            addCriterion("declare_price <", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("declare_price <=", value, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceIn(List<BigDecimal> values) {
            addCriterion("declare_price in", values, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceNotIn(List<BigDecimal> values) {
            addCriterion("declare_price not in", values, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("declare_price between", value1, value2, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andDeclarePriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("declare_price not between", value1, value2, "declarePrice");
            return (Criteria) this;
        }

        public Criteria andCostShippingIsNull() {
            addCriterion("cost_shipping is null");
            return (Criteria) this;
        }

        public Criteria andCostShippingIsNotNull() {
            addCriterion("cost_shipping is not null");
            return (Criteria) this;
        }

        public Criteria andCostShippingEqualTo(BigDecimal value) {
            addCriterion("cost_shipping =", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingNotEqualTo(BigDecimal value) {
            addCriterion("cost_shipping <>", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingGreaterThan(BigDecimal value) {
            addCriterion("cost_shipping >", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_shipping >=", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingLessThan(BigDecimal value) {
            addCriterion("cost_shipping <", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_shipping <=", value, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingIn(List<BigDecimal> values) {
            addCriterion("cost_shipping in", values, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingNotIn(List<BigDecimal> values) {
            addCriterion("cost_shipping not in", values, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_shipping between", value1, value2, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostShippingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_shipping not between", value1, value2, "costShipping");
            return (Criteria) this;
        }

        public Criteria andCostPackagingIsNull() {
            addCriterion("cost_packaging is null");
            return (Criteria) this;
        }

        public Criteria andCostPackagingIsNotNull() {
            addCriterion("cost_packaging is not null");
            return (Criteria) this;
        }

        public Criteria andCostPackagingEqualTo(BigDecimal value) {
            addCriterion("cost_packaging =", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingNotEqualTo(BigDecimal value) {
            addCriterion("cost_packaging <>", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingGreaterThan(BigDecimal value) {
            addCriterion("cost_packaging >", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_packaging >=", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingLessThan(BigDecimal value) {
            addCriterion("cost_packaging <", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cost_packaging <=", value, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingIn(List<BigDecimal> values) {
            addCriterion("cost_packaging in", values, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingNotIn(List<BigDecimal> values) {
            addCriterion("cost_packaging not in", values, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_packaging between", value1, value2, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andCostPackagingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cost_packaging not between", value1, value2, "costPackaging");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightIsNull() {
            addCriterion("outbound_weight is null");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightIsNotNull() {
            addCriterion("outbound_weight is not null");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightEqualTo(BigDecimal value) {
            addCriterion("outbound_weight =", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightNotEqualTo(BigDecimal value) {
            addCriterion("outbound_weight <>", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightGreaterThan(BigDecimal value) {
            addCriterion("outbound_weight >", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("outbound_weight >=", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightLessThan(BigDecimal value) {
            addCriterion("outbound_weight <", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("outbound_weight <=", value, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightIn(List<BigDecimal> values) {
            addCriterion("outbound_weight in", values, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightNotIn(List<BigDecimal> values) {
            addCriterion("outbound_weight not in", values, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outbound_weight between", value1, value2, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andOutboundWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("outbound_weight not between", value1, value2, "outboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingIsNull() {
            addCriterion("bailun_sku_cost_shipping is null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingIsNotNull() {
            addCriterion("bailun_sku_cost_shipping is not null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping =", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingNotEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping <>", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingGreaterThan(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping >", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping >=", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingLessThan(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping <", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_shipping <=", value, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_cost_shipping in", values, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingNotIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_cost_shipping not in", values, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_cost_shipping between", value1, value2, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostShippingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_cost_shipping not between", value1, value2, "bailunSkuCostShipping");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingIsNull() {
            addCriterion("bailun_sku_cost_packaging is null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingIsNotNull() {
            addCriterion("bailun_sku_cost_packaging is not null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging =", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingNotEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging <>", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingGreaterThan(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging >", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging >=", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingLessThan(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging <", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_cost_packaging <=", value, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_cost_packaging in", values, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingNotIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_cost_packaging not in", values, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_cost_packaging between", value1, value2, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuCostPackagingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_cost_packaging not between", value1, value2, "bailunSkuCostPackaging");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightIsNull() {
            addCriterion("bailun_sku_outbound_weight is null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightIsNotNull() {
            addCriterion("bailun_sku_outbound_weight is not null");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight =", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightNotEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight <>", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightGreaterThan(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight >", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight >=", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightLessThan(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight <", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bailun_sku_outbound_weight <=", value, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_outbound_weight in", values, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightNotIn(List<BigDecimal> values) {
            addCriterion("bailun_sku_outbound_weight not in", values, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_outbound_weight between", value1, value2, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andBailunSkuOutboundWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bailun_sku_outbound_weight not between", value1, value2, "bailunSkuOutboundWeight");
            return (Criteria) this;
        }

        public Criteria andHasDeleteIsNull() {
            addCriterion("has_delete is null");
            return (Criteria) this;
        }

        public Criteria andHasDeleteIsNotNull() {
            addCriterion("has_delete is not null");
            return (Criteria) this;
        }

        public Criteria andHasDeleteEqualTo(Boolean value) {
            addCriterion("has_delete =", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteNotEqualTo(Boolean value) {
            addCriterion("has_delete <>", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteGreaterThan(Boolean value) {
            addCriterion("has_delete >", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteGreaterThanOrEqualTo(Boolean value) {
            addCriterion("has_delete >=", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteLessThan(Boolean value) {
            addCriterion("has_delete <", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteLessThanOrEqualTo(Boolean value) {
            addCriterion("has_delete <=", value, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteIn(List<Boolean> values) {
            addCriterion("has_delete in", values, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteNotIn(List<Boolean> values) {
            addCriterion("has_delete not in", values, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteBetween(Boolean value1, Boolean value2) {
            addCriterion("has_delete between", value1, value2, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andHasDeleteNotBetween(Boolean value1, Boolean value2) {
            addCriterion("has_delete not between", value1, value2, "hasDelete");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("company_id is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("company_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(Integer value) {
            addCriterion("company_id =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(Integer value) {
            addCriterion("company_id <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(Integer value) {
            addCriterion("company_id >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("company_id >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(Integer value) {
            addCriterion("company_id <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(Integer value) {
            addCriterion("company_id <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<Integer> values) {
            addCriterion("company_id in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<Integer> values) {
            addCriterion("company_id not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(Integer value1, Integer value2) {
            addCriterion("company_id between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("company_id not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andHasPushedIsNull() {
            addCriterion("has_pushed is null");
            return (Criteria) this;
        }

        public Criteria andHasPushedIsNotNull() {
            addCriterion("has_pushed is not null");
            return (Criteria) this;
        }

        public Criteria andHasPushedEqualTo(Boolean value) {
            addCriterion("has_pushed =", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedNotEqualTo(Boolean value) {
            addCriterion("has_pushed <>", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedGreaterThan(Boolean value) {
            addCriterion("has_pushed >", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("has_pushed >=", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedLessThan(Boolean value) {
            addCriterion("has_pushed <", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedLessThanOrEqualTo(Boolean value) {
            addCriterion("has_pushed <=", value, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedIn(List<Boolean> values) {
            addCriterion("has_pushed in", values, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedNotIn(List<Boolean> values) {
            addCriterion("has_pushed not in", values, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedBetween(Boolean value1, Boolean value2) {
            addCriterion("has_pushed between", value1, value2, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andHasPushedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("has_pushed not between", value1, value2, "hasPushed");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNull() {
            addCriterion("total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNotNull() {
            addCriterion("total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeEqualTo(BigDecimal value) {
            addCriterion("total_fee =", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("total_fee <>", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("total_fee >", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee >=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThan(BigDecimal value) {
            addCriterion("total_fee <", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee <=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIn(List<BigDecimal> values) {
            addCriterion("total_fee in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("total_fee not in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee not between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andShippingIsNull() {
            addCriterion("shipping is null");
            return (Criteria) this;
        }

        public Criteria andShippingIsNotNull() {
            addCriterion("shipping is not null");
            return (Criteria) this;
        }

        public Criteria andShippingEqualTo(BigDecimal value) {
            addCriterion("shipping =", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotEqualTo(BigDecimal value) {
            addCriterion("shipping <>", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingGreaterThan(BigDecimal value) {
            addCriterion("shipping >", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping >=", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingLessThan(BigDecimal value) {
            addCriterion("shipping <", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping <=", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingIn(List<BigDecimal> values) {
            addCriterion("shipping in", values, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotIn(List<BigDecimal> values) {
            addCriterion("shipping not in", values, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping between", value1, value2, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping not between", value1, value2, "shipping");
            return (Criteria) this;
        }

        public Criteria andOpfIsNull() {
            addCriterion("opf is null");
            return (Criteria) this;
        }

        public Criteria andOpfIsNotNull() {
            addCriterion("opf is not null");
            return (Criteria) this;
        }

        public Criteria andOpfEqualTo(BigDecimal value) {
            addCriterion("opf =", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfNotEqualTo(BigDecimal value) {
            addCriterion("opf <>", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfGreaterThan(BigDecimal value) {
            addCriterion("opf >", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("opf >=", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfLessThan(BigDecimal value) {
            addCriterion("opf <", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("opf <=", value, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfIn(List<BigDecimal> values) {
            addCriterion("opf in", values, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfNotIn(List<BigDecimal> values) {
            addCriterion("opf not in", values, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("opf between", value1, value2, "opf");
            return (Criteria) this;
        }

        public Criteria andOpfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("opf not between", value1, value2, "opf");
            return (Criteria) this;
        }

        public Criteria andFscIsNull() {
            addCriterion("fsc is null");
            return (Criteria) this;
        }

        public Criteria andFscIsNotNull() {
            addCriterion("fsc is not null");
            return (Criteria) this;
        }

        public Criteria andFscEqualTo(BigDecimal value) {
            addCriterion("fsc =", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscNotEqualTo(BigDecimal value) {
            addCriterion("fsc <>", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscGreaterThan(BigDecimal value) {
            addCriterion("fsc >", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fsc >=", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscLessThan(BigDecimal value) {
            addCriterion("fsc <", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fsc <=", value, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscIn(List<BigDecimal> values) {
            addCriterion("fsc in", values, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscNotIn(List<BigDecimal> values) {
            addCriterion("fsc not in", values, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fsc between", value1, value2, "fsc");
            return (Criteria) this;
        }

        public Criteria andFscNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fsc not between", value1, value2, "fsc");
            return (Criteria) this;
        }

        public Criteria andDtIsNull() {
            addCriterion("dt is null");
            return (Criteria) this;
        }

        public Criteria andDtIsNotNull() {
            addCriterion("dt is not null");
            return (Criteria) this;
        }

        public Criteria andDtEqualTo(BigDecimal value) {
            addCriterion("dt =", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotEqualTo(BigDecimal value) {
            addCriterion("dt <>", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtGreaterThan(BigDecimal value) {
            addCriterion("dt >", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("dt >=", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtLessThan(BigDecimal value) {
            addCriterion("dt <", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("dt <=", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtIn(List<BigDecimal> values) {
            addCriterion("dt in", values, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotIn(List<BigDecimal> values) {
            addCriterion("dt not in", values, "dt");
            return (Criteria) this;
        }

        public Criteria andDtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dt between", value1, value2, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dt not between", value1, value2, "dt");
            return (Criteria) this;
        }

        public Criteria andRsfIsNull() {
            addCriterion("rsf is null");
            return (Criteria) this;
        }

        public Criteria andRsfIsNotNull() {
            addCriterion("rsf is not null");
            return (Criteria) this;
        }

        public Criteria andRsfEqualTo(BigDecimal value) {
            addCriterion("rsf =", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfNotEqualTo(BigDecimal value) {
            addCriterion("rsf <>", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfGreaterThan(BigDecimal value) {
            addCriterion("rsf >", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("rsf >=", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfLessThan(BigDecimal value) {
            addCriterion("rsf <", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("rsf <=", value, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfIn(List<BigDecimal> values) {
            addCriterion("rsf in", values, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfNotIn(List<BigDecimal> values) {
            addCriterion("rsf not in", values, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rsf between", value1, value2, "rsf");
            return (Criteria) this;
        }

        public Criteria andRsfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("rsf not between", value1, value2, "rsf");
            return (Criteria) this;
        }

        public Criteria andOtfIsNull() {
            addCriterion("otf is null");
            return (Criteria) this;
        }

        public Criteria andOtfIsNotNull() {
            addCriterion("otf is not null");
            return (Criteria) this;
        }

        public Criteria andOtfEqualTo(BigDecimal value) {
            addCriterion("otf =", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfNotEqualTo(BigDecimal value) {
            addCriterion("otf <>", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfGreaterThan(BigDecimal value) {
            addCriterion("otf >", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("otf >=", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfLessThan(BigDecimal value) {
            addCriterion("otf <", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("otf <=", value, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfIn(List<BigDecimal> values) {
            addCriterion("otf in", values, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfNotIn(List<BigDecimal> values) {
            addCriterion("otf not in", values, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("otf between", value1, value2, "otf");
            return (Criteria) this;
        }

        public Criteria andOtfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("otf not between", value1, value2, "otf");
            return (Criteria) this;
        }

        public Criteria andWhfIsNull() {
            addCriterion("whf is null");
            return (Criteria) this;
        }

        public Criteria andWhfIsNotNull() {
            addCriterion("whf is not null");
            return (Criteria) this;
        }

        public Criteria andWhfEqualTo(BigDecimal value) {
            addCriterion("whf =", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfNotEqualTo(BigDecimal value) {
            addCriterion("whf <>", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfGreaterThan(BigDecimal value) {
            addCriterion("whf >", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("whf >=", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfLessThan(BigDecimal value) {
            addCriterion("whf <", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfLessThanOrEqualTo(BigDecimal value) {
            addCriterion("whf <=", value, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfIn(List<BigDecimal> values) {
            addCriterion("whf in", values, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfNotIn(List<BigDecimal> values) {
            addCriterion("whf not in", values, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("whf between", value1, value2, "whf");
            return (Criteria) this;
        }

        public Criteria andWhfNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("whf not between", value1, value2, "whf");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIsNull() {
            addCriterion("currency_code is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIsNotNull() {
            addCriterion("currency_code is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeEqualTo(String value) {
            addCriterion("currency_code =", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotEqualTo(String value) {
            addCriterion("currency_code <>", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThan(String value) {
            addCriterion("currency_code >", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("currency_code >=", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThan(String value) {
            addCriterion("currency_code <", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThanOrEqualTo(String value) {
            addCriterion("currency_code <=", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLike(String value) {
            addCriterion("currency_code like", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotLike(String value) {
            addCriterion("currency_code not like", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIn(List<String> values) {
            addCriterion("currency_code in", values, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotIn(List<String> values) {
            addCriterion("currency_code not in", values, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeBetween(String value1, String value2) {
            addCriterion("currency_code between", value1, value2, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotBetween(String value1, String value2) {
            addCriterion("currency_code not between", value1, value2, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateIsNull() {
            addCriterion("wms_to_cny_exchange_rate is null");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateIsNotNull() {
            addCriterion("wms_to_cny_exchange_rate is not null");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateEqualTo(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate =", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateNotEqualTo(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate <>", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateGreaterThan(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate >", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate >=", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateLessThan(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate <", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("wms_to_cny_exchange_rate <=", value, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateIn(List<BigDecimal> values) {
            addCriterion("wms_to_cny_exchange_rate in", values, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateNotIn(List<BigDecimal> values) {
            addCriterion("wms_to_cny_exchange_rate not in", values, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wms_to_cny_exchange_rate between", value1, value2, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToCnyExchangeRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wms_to_cny_exchange_rate not between", value1, value2, "wmsToCnyExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateIsNull() {
            addCriterion("wms_to_usd_exchange_rate is null");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateIsNotNull() {
            addCriterion("wms_to_usd_exchange_rate is not null");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateEqualTo(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate =", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateNotEqualTo(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate <>", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateGreaterThan(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate >", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate >=", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateLessThan(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate <", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("wms_to_usd_exchange_rate <=", value, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateIn(List<BigDecimal> values) {
            addCriterion("wms_to_usd_exchange_rate in", values, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateNotIn(List<BigDecimal> values) {
            addCriterion("wms_to_usd_exchange_rate not in", values, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wms_to_usd_exchange_rate between", value1, value2, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }

        public Criteria andWmsToUsdExchangeRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("wms_to_usd_exchange_rate not between", value1, value2, "wmsToUsdExchangeRate");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {
        /**
         * This field was generated by MyBatis Generator.
         * This field corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        private DcBaseOmsPickExample example;

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        protected Criteria(DcBaseOmsPickExample example) {
            super();
            this.example = example;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public DcBaseOmsPickExample example() {
            return this.example;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        /**
         * This interface was generated by MyBatis Generator.
         * This interface corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        @Deprecated
        public interface ICriteriaAdd {
            /**
             * This method was generated by MyBatis Generator.
             * This method corresponds to the database table dc_base_oms_pick
             *
             * @mbg.generated
             * @project https://github.com/itfsw/mybatis-generator-plugin
             */
            Criteria add(Criteria add);
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    /**
     * This interface was generated by MyBatis Generator.
     * This interface corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public interface ICriteriaWhen {
        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void criteria(Criteria criteria);
    }

    /**
     * This interface was generated by MyBatis Generator.
     * This interface corresponds to the database table dc_base_oms_pick
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public interface IExampleWhen {
        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_base_oms_pick
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void example(DcBaseOmsPickExample example);
    }
}