package com.bailuntec.domain.example;

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

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

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

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

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table dc_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     */
    public DcAverageWarehouseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample 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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public static Criteria newAndCreateCriteria() {
        DcAverageWarehouseExample example = new DcAverageWarehouseExample();
        return example.createCriteria();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample 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_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample 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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table dc_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample 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_average_warehouse
     *
     * @mbg.generated
     * @project https://github.com/itfsw/mybatis-generator-plugin
     */
    public DcAverageWarehouseExample 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_average_warehouse
     *
     * @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 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 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 andInboundDaysIsNull() {
            addCriterion("inbound_days is null");
            return (Criteria) this;
        }

        public Criteria andInboundDaysIsNotNull() {
            addCriterion("inbound_days is not null");
            return (Criteria) this;
        }

        public Criteria andInboundDaysEqualTo(Integer value) {
            addCriterion("inbound_days =", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysNotEqualTo(Integer value) {
            addCriterion("inbound_days <>", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysGreaterThan(Integer value) {
            addCriterion("inbound_days >", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("inbound_days >=", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysLessThan(Integer value) {
            addCriterion("inbound_days <", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysLessThanOrEqualTo(Integer value) {
            addCriterion("inbound_days <=", value, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysIn(List<Integer> values) {
            addCriterion("inbound_days in", values, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysNotIn(List<Integer> values) {
            addCriterion("inbound_days not in", values, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysBetween(Integer value1, Integer value2) {
            addCriterion("inbound_days between", value1, value2, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andInboundDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("inbound_days not between", value1, value2, "inboundDays");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(LocalDateTime value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(LocalDateTime value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(LocalDateTime value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(LocalDateTime value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<LocalDateTime> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<LocalDateTime> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysIsNull() {
            addCriterion("transfer_type_1_days is null");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysIsNotNull() {
            addCriterion("transfer_type_1_days is not null");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysEqualTo(BigDecimal value) {
            addCriterion("transfer_type_1_days =", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysNotEqualTo(BigDecimal value) {
            addCriterion("transfer_type_1_days <>", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysGreaterThan(BigDecimal value) {
            addCriterion("transfer_type_1_days >", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_type_1_days >=", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysLessThan(BigDecimal value) {
            addCriterion("transfer_type_1_days <", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_type_1_days <=", value, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysIn(List<BigDecimal> values) {
            addCriterion("transfer_type_1_days in", values, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysNotIn(List<BigDecimal> values) {
            addCriterion("transfer_type_1_days not in", values, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_type_1_days between", value1, value2, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType1DaysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_type_1_days not between", value1, value2, "transferType1Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysIsNull() {
            addCriterion("transfer_type_2_days is null");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysIsNotNull() {
            addCriterion("transfer_type_2_days is not null");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysEqualTo(BigDecimal value) {
            addCriterion("transfer_type_2_days =", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysNotEqualTo(BigDecimal value) {
            addCriterion("transfer_type_2_days <>", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysGreaterThan(BigDecimal value) {
            addCriterion("transfer_type_2_days >", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_type_2_days >=", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysLessThan(BigDecimal value) {
            addCriterion("transfer_type_2_days <", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_type_2_days <=", value, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysIn(List<BigDecimal> values) {
            addCriterion("transfer_type_2_days in", values, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysNotIn(List<BigDecimal> values) {
            addCriterion("transfer_type_2_days not in", values, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_type_2_days between", value1, value2, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferType2DaysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_type_2_days not between", value1, value2, "transferType2Days");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIsNull() {
            addCriterion("transfer_bale_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIsNotNull() {
            addCriterion("transfer_bale_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery =", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery <>", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryGreaterThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery >", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery >=", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryLessThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery <", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery <=", value, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery in", values, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery not in", values, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery between", value1, value2, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery not between", value1, value2, "transferBaleDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysIsNull() {
            addCriterion("transfer_sail_days is null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysIsNotNull() {
            addCriterion("transfer_sail_days is not null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days =", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysNotEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days <>", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysGreaterThan(BigDecimal value) {
            addCriterion("transfer_sail_days >", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days >=", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysLessThan(BigDecimal value) {
            addCriterion("transfer_sail_days <", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days <=", value, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days in", values, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysNotIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days not in", values, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days between", value1, value2, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days not between", value1, value2, "transferSailDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysIsNull() {
            addCriterion("transfer_order_days is null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysIsNotNull() {
            addCriterion("transfer_order_days is not null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days =", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysNotEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days <>", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysGreaterThan(BigDecimal value) {
            addCriterion("transfer_order_days >", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days >=", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysLessThan(BigDecimal value) {
            addCriterion("transfer_order_days <", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days <=", value, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days in", values, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysNotIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days not in", values, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days between", value1, value2, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days not between", value1, value2, "transferOrderDays");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIsNull() {
            addCriterion("abroad_inbound_delivery is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIsNotNull() {
            addCriterion("abroad_inbound_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery =", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery <>", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryGreaterThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery >", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery >=", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryLessThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery <", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryLessThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery <=", value, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery in", values, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery not in", values, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery between", value1, value2, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery not between", value1, value2, "abroadInboundDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIsNull() {
            addCriterion("transfer_delivery is null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIsNotNull() {
            addCriterion("transfer_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery =", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery <>", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryGreaterThan(BigDecimal value) {
            addCriterion("transfer_delivery >", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery >=", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryLessThan(BigDecimal value) {
            addCriterion("transfer_delivery <", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery <=", value, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery in", values, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery not in", values, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery between", value1, value2, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery not between", value1, value2, "transferDelivery");
            return (Criteria) this;
        }

        public Criteria andProductCountIsNull() {
            addCriterion("product_count is null");
            return (Criteria) this;
        }

        public Criteria andProductCountIsNotNull() {
            addCriterion("product_count is not null");
            return (Criteria) this;
        }

        public Criteria andProductCountEqualTo(Integer value) {
            addCriterion("product_count =", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountNotEqualTo(Integer value) {
            addCriterion("product_count <>", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountGreaterThan(Integer value) {
            addCriterion("product_count >", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("product_count >=", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountLessThan(Integer value) {
            addCriterion("product_count <", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountLessThanOrEqualTo(Integer value) {
            addCriterion("product_count <=", value, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountIn(List<Integer> values) {
            addCriterion("product_count in", values, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountNotIn(List<Integer> values) {
            addCriterion("product_count not in", values, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountBetween(Integer value1, Integer value2) {
            addCriterion("product_count between", value1, value2, "productCount");
            return (Criteria) this;
        }

        public Criteria andProductCountNotBetween(Integer value1, Integer value2) {
            addCriterion("product_count not between", value1, value2, "productCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountIsNull() {
            addCriterion("order_count is null");
            return (Criteria) this;
        }

        public Criteria andOrderCountIsNotNull() {
            addCriterion("order_count is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCountEqualTo(Integer value) {
            addCriterion("order_count =", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountNotEqualTo(Integer value) {
            addCriterion("order_count <>", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountGreaterThan(Integer value) {
            addCriterion("order_count >", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_count >=", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountLessThan(Integer value) {
            addCriterion("order_count <", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountLessThanOrEqualTo(Integer value) {
            addCriterion("order_count <=", value, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountIn(List<Integer> values) {
            addCriterion("order_count in", values, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountNotIn(List<Integer> values) {
            addCriterion("order_count not in", values, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountBetween(Integer value1, Integer value2) {
            addCriterion("order_count between", value1, value2, "orderCount");
            return (Criteria) this;
        }

        public Criteria andOrderCountNotBetween(Integer value1, Integer value2) {
            addCriterion("order_count not between", value1, value2, "orderCount");
            return (Criteria) this;
        }

        public Criteria andProductCount2IsNull() {
            addCriterion("product_count_2 is null");
            return (Criteria) this;
        }

        public Criteria andProductCount2IsNotNull() {
            addCriterion("product_count_2 is not null");
            return (Criteria) this;
        }

        public Criteria andProductCount2EqualTo(Integer value) {
            addCriterion("product_count_2 =", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2NotEqualTo(Integer value) {
            addCriterion("product_count_2 <>", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2GreaterThan(Integer value) {
            addCriterion("product_count_2 >", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2GreaterThanOrEqualTo(Integer value) {
            addCriterion("product_count_2 >=", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2LessThan(Integer value) {
            addCriterion("product_count_2 <", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2LessThanOrEqualTo(Integer value) {
            addCriterion("product_count_2 <=", value, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2In(List<Integer> values) {
            addCriterion("product_count_2 in", values, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2NotIn(List<Integer> values) {
            addCriterion("product_count_2 not in", values, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2Between(Integer value1, Integer value2) {
            addCriterion("product_count_2 between", value1, value2, "productCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount2NotBetween(Integer value1, Integer value2) {
            addCriterion("product_count_2 not between", value1, value2, "productCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2IsNull() {
            addCriterion("order_count_2 is null");
            return (Criteria) this;
        }

        public Criteria andOrderCount2IsNotNull() {
            addCriterion("order_count_2 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCount2EqualTo(Integer value) {
            addCriterion("order_count_2 =", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2NotEqualTo(Integer value) {
            addCriterion("order_count_2 <>", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2GreaterThan(Integer value) {
            addCriterion("order_count_2 >", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2GreaterThanOrEqualTo(Integer value) {
            addCriterion("order_count_2 >=", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2LessThan(Integer value) {
            addCriterion("order_count_2 <", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2LessThanOrEqualTo(Integer value) {
            addCriterion("order_count_2 <=", value, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2In(List<Integer> values) {
            addCriterion("order_count_2 in", values, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2NotIn(List<Integer> values) {
            addCriterion("order_count_2 not in", values, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2Between(Integer value1, Integer value2) {
            addCriterion("order_count_2 between", value1, value2, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andOrderCount2NotBetween(Integer value1, Integer value2) {
            addCriterion("order_count_2 not between", value1, value2, "orderCount2");
            return (Criteria) this;
        }

        public Criteria andProductCount3IsNull() {
            addCriterion("product_count_3 is null");
            return (Criteria) this;
        }

        public Criteria andProductCount3IsNotNull() {
            addCriterion("product_count_3 is not null");
            return (Criteria) this;
        }

        public Criteria andProductCount3EqualTo(Integer value) {
            addCriterion("product_count_3 =", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3NotEqualTo(Integer value) {
            addCriterion("product_count_3 <>", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3GreaterThan(Integer value) {
            addCriterion("product_count_3 >", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3GreaterThanOrEqualTo(Integer value) {
            addCriterion("product_count_3 >=", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3LessThan(Integer value) {
            addCriterion("product_count_3 <", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3LessThanOrEqualTo(Integer value) {
            addCriterion("product_count_3 <=", value, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3In(List<Integer> values) {
            addCriterion("product_count_3 in", values, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3NotIn(List<Integer> values) {
            addCriterion("product_count_3 not in", values, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3Between(Integer value1, Integer value2) {
            addCriterion("product_count_3 between", value1, value2, "productCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount3NotBetween(Integer value1, Integer value2) {
            addCriterion("product_count_3 not between", value1, value2, "productCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3IsNull() {
            addCriterion("order_count_3 is null");
            return (Criteria) this;
        }

        public Criteria andOrderCount3IsNotNull() {
            addCriterion("order_count_3 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCount3EqualTo(Integer value) {
            addCriterion("order_count_3 =", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3NotEqualTo(Integer value) {
            addCriterion("order_count_3 <>", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3GreaterThan(Integer value) {
            addCriterion("order_count_3 >", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3GreaterThanOrEqualTo(Integer value) {
            addCriterion("order_count_3 >=", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3LessThan(Integer value) {
            addCriterion("order_count_3 <", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3LessThanOrEqualTo(Integer value) {
            addCriterion("order_count_3 <=", value, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3In(List<Integer> values) {
            addCriterion("order_count_3 in", values, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3NotIn(List<Integer> values) {
            addCriterion("order_count_3 not in", values, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3Between(Integer value1, Integer value2) {
            addCriterion("order_count_3 between", value1, value2, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andOrderCount3NotBetween(Integer value1, Integer value2) {
            addCriterion("order_count_3 not between", value1, value2, "orderCount3");
            return (Criteria) this;
        }

        public Criteria andProductCount1IsNull() {
            addCriterion("product_count_1 is null");
            return (Criteria) this;
        }

        public Criteria andProductCount1IsNotNull() {
            addCriterion("product_count_1 is not null");
            return (Criteria) this;
        }

        public Criteria andProductCount1EqualTo(Integer value) {
            addCriterion("product_count_1 =", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1NotEqualTo(Integer value) {
            addCriterion("product_count_1 <>", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1GreaterThan(Integer value) {
            addCriterion("product_count_1 >", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1GreaterThanOrEqualTo(Integer value) {
            addCriterion("product_count_1 >=", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1LessThan(Integer value) {
            addCriterion("product_count_1 <", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1LessThanOrEqualTo(Integer value) {
            addCriterion("product_count_1 <=", value, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1In(List<Integer> values) {
            addCriterion("product_count_1 in", values, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1NotIn(List<Integer> values) {
            addCriterion("product_count_1 not in", values, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1Between(Integer value1, Integer value2) {
            addCriterion("product_count_1 between", value1, value2, "productCount1");
            return (Criteria) this;
        }

        public Criteria andProductCount1NotBetween(Integer value1, Integer value2) {
            addCriterion("product_count_1 not between", value1, value2, "productCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1IsNull() {
            addCriterion("order_count_1 is null");
            return (Criteria) this;
        }

        public Criteria andOrderCount1IsNotNull() {
            addCriterion("order_count_1 is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCount1EqualTo(Integer value) {
            addCriterion("order_count_1 =", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1NotEqualTo(Integer value) {
            addCriterion("order_count_1 <>", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1GreaterThan(Integer value) {
            addCriterion("order_count_1 >", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1GreaterThanOrEqualTo(Integer value) {
            addCriterion("order_count_1 >=", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1LessThan(Integer value) {
            addCriterion("order_count_1 <", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1LessThanOrEqualTo(Integer value) {
            addCriterion("order_count_1 <=", value, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1In(List<Integer> values) {
            addCriterion("order_count_1 in", values, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1NotIn(List<Integer> values) {
            addCriterion("order_count_1 not in", values, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1Between(Integer value1, Integer value2) {
            addCriterion("order_count_1 between", value1, value2, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andOrderCount1NotBetween(Integer value1, Integer value2) {
            addCriterion("order_count_1 not between", value1, value2, "orderCount1");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanIsNull() {
            addCriterion("transfer_bale_delivery_ocean is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanIsNotNull() {
            addCriterion("transfer_bale_delivery_ocean is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean =", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanNotEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean <>", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanGreaterThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean >", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean >=", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanLessThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean <", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_ocean <=", value, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery_ocean in", values, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanNotIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery_ocean not in", values, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery_ocean between", value1, value2, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryOceanNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery_ocean not between", value1, value2, "transferBaleDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanIsNull() {
            addCriterion("abroad_inbound_delivery_ocean is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanIsNotNull() {
            addCriterion("abroad_inbound_delivery_ocean is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean =", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanNotEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean <>", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanGreaterThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean >", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean >=", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanLessThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean <", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanLessThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_ocean <=", value, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery_ocean in", values, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanNotIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery_ocean not in", values, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery_ocean between", value1, value2, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryOceanNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery_ocean not between", value1, value2, "abroadInboundDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanIsNull() {
            addCriterion("transfer_delivery_ocean is null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanIsNotNull() {
            addCriterion("transfer_delivery_ocean is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_ocean =", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanNotEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_ocean <>", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanGreaterThan(BigDecimal value) {
            addCriterion("transfer_delivery_ocean >", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_ocean >=", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanLessThan(BigDecimal value) {
            addCriterion("transfer_delivery_ocean <", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_ocean <=", value, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery_ocean in", values, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanNotIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery_ocean not in", values, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery_ocean between", value1, value2, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryOceanNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery_ocean not between", value1, value2, "transferDeliveryOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanIsNull() {
            addCriterion("transfer_order_days_ocean is null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanIsNotNull() {
            addCriterion("transfer_order_days_ocean is not null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_ocean =", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanNotEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_ocean <>", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanGreaterThan(BigDecimal value) {
            addCriterion("transfer_order_days_ocean >", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_ocean >=", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanLessThan(BigDecimal value) {
            addCriterion("transfer_order_days_ocean <", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_ocean <=", value, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days_ocean in", values, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanNotIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days_ocean not in", values, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days_ocean between", value1, value2, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysOceanNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days_ocean not between", value1, value2, "transferOrderDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanIsNull() {
            addCriterion("transfer_sail_days_ocean is null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanIsNotNull() {
            addCriterion("transfer_sail_days_ocean is not null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean =", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanNotEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean <>", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanGreaterThan(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean >", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean >=", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanLessThan(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean <", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_ocean <=", value, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days_ocean in", values, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanNotIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days_ocean not in", values, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days_ocean between", value1, value2, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysOceanNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days_ocean not between", value1, value2, "transferSailDaysOcean");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyIsNull() {
            addCriterion("transfer_bale_delivery_empty is null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyIsNotNull() {
            addCriterion("transfer_bale_delivery_empty is not null");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty =", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyNotEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty <>", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyGreaterThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty >", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty >=", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyLessThan(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty <", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_bale_delivery_empty <=", value, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery_empty in", values, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyNotIn(List<BigDecimal> values) {
            addCriterion("transfer_bale_delivery_empty not in", values, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery_empty between", value1, value2, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferBaleDeliveryEmptyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_bale_delivery_empty not between", value1, value2, "transferBaleDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyIsNull() {
            addCriterion("abroad_inbound_delivery_empty is null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyIsNotNull() {
            addCriterion("abroad_inbound_delivery_empty is not null");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty =", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyNotEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty <>", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyGreaterThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty >", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty >=", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyLessThan(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty <", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("abroad_inbound_delivery_empty <=", value, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery_empty in", values, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyNotIn(List<BigDecimal> values) {
            addCriterion("abroad_inbound_delivery_empty not in", values, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery_empty between", value1, value2, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andAbroadInboundDeliveryEmptyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("abroad_inbound_delivery_empty not between", value1, value2, "abroadInboundDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyIsNull() {
            addCriterion("transfer_delivery_empty is null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyIsNotNull() {
            addCriterion("transfer_delivery_empty is not null");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_empty =", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyNotEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_empty <>", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyGreaterThan(BigDecimal value) {
            addCriterion("transfer_delivery_empty >", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_empty >=", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyLessThan(BigDecimal value) {
            addCriterion("transfer_delivery_empty <", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_delivery_empty <=", value, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery_empty in", values, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyNotIn(List<BigDecimal> values) {
            addCriterion("transfer_delivery_empty not in", values, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery_empty between", value1, value2, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferDeliveryEmptyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_delivery_empty not between", value1, value2, "transferDeliveryEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyIsNull() {
            addCriterion("transfer_sail_days_empty is null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyIsNotNull() {
            addCriterion("transfer_sail_days_empty is not null");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_empty =", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyNotEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_empty <>", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyGreaterThan(BigDecimal value) {
            addCriterion("transfer_sail_days_empty >", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_empty >=", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyLessThan(BigDecimal value) {
            addCriterion("transfer_sail_days_empty <", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_sail_days_empty <=", value, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days_empty in", values, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyNotIn(List<BigDecimal> values) {
            addCriterion("transfer_sail_days_empty not in", values, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days_empty between", value1, value2, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferSailDaysEmptyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_sail_days_empty not between", value1, value2, "transferSailDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyIsNull() {
            addCriterion("transfer_order_days_empty is null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyIsNotNull() {
            addCriterion("transfer_order_days_empty is not null");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_empty =", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyNotEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_empty <>", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyGreaterThan(BigDecimal value) {
            addCriterion("transfer_order_days_empty >", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_empty >=", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyLessThan(BigDecimal value) {
            addCriterion("transfer_order_days_empty <", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("transfer_order_days_empty <=", value, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days_empty in", values, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyNotIn(List<BigDecimal> values) {
            addCriterion("transfer_order_days_empty not in", values, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days_empty between", value1, value2, "transferOrderDaysEmpty");
            return (Criteria) this;
        }

        public Criteria andTransferOrderDaysEmptyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("transfer_order_days_empty not between", value1, value2, "transferOrderDaysEmpty");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table dc_average_warehouse
     *
     * @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_average_warehouse
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        private DcAverageWarehouseExample example;

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

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

        /**
         * This method was generated by MyBatis Generator.
         * This method corresponds to the database table dc_average_warehouse
         *
         * @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_average_warehouse
         *
         * @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_average_warehouse
         *
         * @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_average_warehouse
         *
         * @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_average_warehouse
             *
             * @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_average_warehouse
     *
     * @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_average_warehouse
     *
     * @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_average_warehouse
         *
         * @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_average_warehouse
     *
     * @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_average_warehouse
         *
         * @mbg.generated
         * @project https://github.com/itfsw/mybatis-generator-plugin
         */
        void example(com.bailuntec.domain.example.DcAverageWarehouseExample example);
    }
}