package com.minpay.db.table.model;

import java.util.ArrayList;
import java.util.List;

public class TpOrderDetailExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table tp_order_detail
     *
     * @mbggenerated
     */
    protected String orderByClause;

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

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

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

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

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

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

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

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

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table tp_order_detail
     *
     * @mbggenerated
     */
    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 tp_order_detail
     *
     * @mbggenerated
     */
    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 tp_order_detail
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

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

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table tp_order_detail
     *
     * @mbggenerated
     */
    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> 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("ODT_ID is null");
            return (Criteria) this;
        }

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

        public Criteria andIdEqualTo(String value) {
            if(value == null ){
                andIdIsNull();
            } else {
                addCriterion("ODT_ID =", value, "id");
            }
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            if(value == null ){
                andIdIsNotNull();
            } else {
                addCriterion("ODT_ID <>", value, "id");
            }
            return (Criteria) this;
        }

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

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

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

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

        public Criteria andIdLike(String value) {
            addCriterion("ODT_ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ODT_ID not like", value, "id");
            return (Criteria) this;
        }

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

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

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

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

        public Criteria andOrdernoIsNull() {
            addCriterion("ODT_ORDERNO is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("ODT_ORDERNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            if(value == null ){
                andOrdernoIsNull();
            } else {
                addCriterion("ODT_ORDERNO =", value, "orderno");
            }
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            if(value == null ){
                andOrdernoIsNotNull();
            } else {
                addCriterion("ODT_ORDERNO <>", value, "orderno");
            }
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("ODT_ORDERNO >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_ORDERNO >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("ODT_ORDERNO <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("ODT_ORDERNO <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("ODT_ORDERNO like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("ODT_ORDERNO not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("ODT_ORDERNO in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("ODT_ORDERNO not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("ODT_ORDERNO between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("ODT_ORDERNO not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("ODT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("ODT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            if(value == null ){
                andNameIsNull();
            } else {
                addCriterion("ODT_NAME =", value, "name");
            }
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            if(value == null ){
                andNameIsNotNull();
            } else {
                addCriterion("ODT_NAME <>", value, "name");
            }
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("ODT_NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("ODT_NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("ODT_NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("ODT_NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("ODT_NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("ODT_NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("ODT_NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("ODT_NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("ODT_NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNull() {
            addCriterion("ODT_CATEGORY is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNotNull() {
            addCriterion("ODT_CATEGORY is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryEqualTo(String value) {
            if(value == null ){
                andCategoryIsNull();
            } else {
                addCriterion("ODT_CATEGORY =", value, "category");
            }
            return (Criteria) this;
        }

        public Criteria andCategoryNotEqualTo(String value) {
            if(value == null ){
                andCategoryIsNotNull();
            } else {
                addCriterion("ODT_CATEGORY <>", value, "category");
            }
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThan(String value) {
            addCriterion("ODT_CATEGORY >", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_CATEGORY >=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThan(String value) {
            addCriterion("ODT_CATEGORY <", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThanOrEqualTo(String value) {
            addCriterion("ODT_CATEGORY <=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLike(String value) {
            addCriterion("ODT_CATEGORY like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotLike(String value) {
            addCriterion("ODT_CATEGORY not like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryIn(List<String> values) {
            addCriterion("ODT_CATEGORY in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotIn(List<String> values) {
            addCriterion("ODT_CATEGORY not in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryBetween(String value1, String value2) {
            addCriterion("ODT_CATEGORY between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotBetween(String value1, String value2) {
            addCriterion("ODT_CATEGORY not between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andBrandIsNull() {
            addCriterion("ODT_BRAND is null");
            return (Criteria) this;
        }

        public Criteria andBrandIsNotNull() {
            addCriterion("ODT_BRAND is not null");
            return (Criteria) this;
        }

        public Criteria andBrandEqualTo(String value) {
            if(value == null ){
                andBrandIsNull();
            } else {
                addCriterion("ODT_BRAND =", value, "brand");
            }
            return (Criteria) this;
        }

        public Criteria andBrandNotEqualTo(String value) {
            if(value == null ){
                andBrandIsNotNull();
            } else {
                addCriterion("ODT_BRAND <>", value, "brand");
            }
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThan(String value) {
            addCriterion("ODT_BRAND >", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_BRAND >=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThan(String value) {
            addCriterion("ODT_BRAND <", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLessThanOrEqualTo(String value) {
            addCriterion("ODT_BRAND <=", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandLike(String value) {
            addCriterion("ODT_BRAND like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotLike(String value) {
            addCriterion("ODT_BRAND not like", value, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandIn(List<String> values) {
            addCriterion("ODT_BRAND in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotIn(List<String> values) {
            addCriterion("ODT_BRAND not in", values, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandBetween(String value1, String value2) {
            addCriterion("ODT_BRAND between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andBrandNotBetween(String value1, String value2) {
            addCriterion("ODT_BRAND not between", value1, value2, "brand");
            return (Criteria) this;
        }

        public Criteria andOriginCountryIsNull() {
            addCriterion("ODT_ORIGIN_COUNTRY is null");
            return (Criteria) this;
        }

        public Criteria andOriginCountryIsNotNull() {
            addCriterion("ODT_ORIGIN_COUNTRY is not null");
            return (Criteria) this;
        }

        public Criteria andOriginCountryEqualTo(String value) {
            if(value == null ){
                andOriginCountryIsNull();
            } else {
                addCriterion("ODT_ORIGIN_COUNTRY =", value, "originCountry");
            }
            return (Criteria) this;
        }

        public Criteria andOriginCountryNotEqualTo(String value) {
            if(value == null ){
                andOriginCountryIsNotNull();
            } else {
                addCriterion("ODT_ORIGIN_COUNTRY <>", value, "originCountry");
            }
            return (Criteria) this;
        }

        public Criteria andOriginCountryGreaterThan(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY >", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY >=", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryLessThan(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY <", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryLessThanOrEqualTo(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY <=", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryLike(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY like", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryNotLike(String value) {
            addCriterion("ODT_ORIGIN_COUNTRY not like", value, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryIn(List<String> values) {
            addCriterion("ODT_ORIGIN_COUNTRY in", values, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryNotIn(List<String> values) {
            addCriterion("ODT_ORIGIN_COUNTRY not in", values, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryBetween(String value1, String value2) {
            addCriterion("ODT_ORIGIN_COUNTRY between", value1, value2, "originCountry");
            return (Criteria) this;
        }

        public Criteria andOriginCountryNotBetween(String value1, String value2) {
            addCriterion("ODT_ORIGIN_COUNTRY not between", value1, value2, "originCountry");
            return (Criteria) this;
        }

        public Criteria andNormsIsNull() {
            addCriterion("ODT_NORMS is null");
            return (Criteria) this;
        }

        public Criteria andNormsIsNotNull() {
            addCriterion("ODT_NORMS is not null");
            return (Criteria) this;
        }

        public Criteria andNormsEqualTo(String value) {
            if(value == null ){
                andNormsIsNull();
            } else {
                addCriterion("ODT_NORMS =", value, "norms");
            }
            return (Criteria) this;
        }

        public Criteria andNormsNotEqualTo(String value) {
            if(value == null ){
                andNormsIsNotNull();
            } else {
                addCriterion("ODT_NORMS <>", value, "norms");
            }
            return (Criteria) this;
        }

        public Criteria andNormsGreaterThan(String value) {
            addCriterion("ODT_NORMS >", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_NORMS >=", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsLessThan(String value) {
            addCriterion("ODT_NORMS <", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsLessThanOrEqualTo(String value) {
            addCriterion("ODT_NORMS <=", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsLike(String value) {
            addCriterion("ODT_NORMS like", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsNotLike(String value) {
            addCriterion("ODT_NORMS not like", value, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsIn(List<String> values) {
            addCriterion("ODT_NORMS in", values, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsNotIn(List<String> values) {
            addCriterion("ODT_NORMS not in", values, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsBetween(String value1, String value2) {
            addCriterion("ODT_NORMS between", value1, value2, "norms");
            return (Criteria) this;
        }

        public Criteria andNormsNotBetween(String value1, String value2) {
            addCriterion("ODT_NORMS not between", value1, value2, "norms");
            return (Criteria) this;
        }

        public Criteria andValidityIsNull() {
            addCriterion("ODT_VALIDITY is null");
            return (Criteria) this;
        }

        public Criteria andValidityIsNotNull() {
            addCriterion("ODT_VALIDITY is not null");
            return (Criteria) this;
        }

        public Criteria andValidityEqualTo(String value) {
            if(value == null ){
                andValidityIsNull();
            } else {
                addCriterion("ODT_VALIDITY =", value, "validity");
            }
            return (Criteria) this;
        }

        public Criteria andValidityNotEqualTo(String value) {
            if(value == null ){
                andValidityIsNotNull();
            } else {
                addCriterion("ODT_VALIDITY <>", value, "validity");
            }
            return (Criteria) this;
        }

        public Criteria andValidityGreaterThan(String value) {
            addCriterion("ODT_VALIDITY >", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_VALIDITY >=", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityLessThan(String value) {
            addCriterion("ODT_VALIDITY <", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityLessThanOrEqualTo(String value) {
            addCriterion("ODT_VALIDITY <=", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityLike(String value) {
            addCriterion("ODT_VALIDITY like", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotLike(String value) {
            addCriterion("ODT_VALIDITY not like", value, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityIn(List<String> values) {
            addCriterion("ODT_VALIDITY in", values, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotIn(List<String> values) {
            addCriterion("ODT_VALIDITY not in", values, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityBetween(String value1, String value2) {
            addCriterion("ODT_VALIDITY between", value1, value2, "validity");
            return (Criteria) this;
        }

        public Criteria andValidityNotBetween(String value1, String value2) {
            addCriterion("ODT_VALIDITY not between", value1, value2, "validity");
            return (Criteria) this;
        }

        public Criteria andPriceExitIsNull() {
            addCriterion("ODT_PRICE_EXIT is null");
            return (Criteria) this;
        }

        public Criteria andPriceExitIsNotNull() {
            addCriterion("ODT_PRICE_EXIT is not null");
            return (Criteria) this;
        }

        public Criteria andPriceExitEqualTo(String value) {
            if(value == null ){
                andPriceExitIsNull();
            } else {
                addCriterion("ODT_PRICE_EXIT =", value, "priceExit");
            }
            return (Criteria) this;
        }

        public Criteria andPriceExitNotEqualTo(String value) {
            if(value == null ){
                andPriceExitIsNotNull();
            } else {
                addCriterion("ODT_PRICE_EXIT <>", value, "priceExit");
            }
            return (Criteria) this;
        }

        public Criteria andPriceExitGreaterThan(String value) {
            addCriterion("ODT_PRICE_EXIT >", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_EXIT >=", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitLessThan(String value) {
            addCriterion("ODT_PRICE_EXIT <", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitLessThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_EXIT <=", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitLike(String value) {
            addCriterion("ODT_PRICE_EXIT like", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitNotLike(String value) {
            addCriterion("ODT_PRICE_EXIT not like", value, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitIn(List<String> values) {
            addCriterion("ODT_PRICE_EXIT in", values, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitNotIn(List<String> values) {
            addCriterion("ODT_PRICE_EXIT not in", values, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_EXIT between", value1, value2, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceExitNotBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_EXIT not between", value1, value2, "priceExit");
            return (Criteria) this;
        }

        public Criteria andPriceCifIsNull() {
            addCriterion("ODT_PRICE_CIF is null");
            return (Criteria) this;
        }

        public Criteria andPriceCifIsNotNull() {
            addCriterion("ODT_PRICE_CIF is not null");
            return (Criteria) this;
        }

        public Criteria andPriceCifEqualTo(String value) {
            if(value == null ){
                andPriceCifIsNull();
            } else {
                addCriterion("ODT_PRICE_CIF =", value, "priceCif");
            }
            return (Criteria) this;
        }

        public Criteria andPriceCifNotEqualTo(String value) {
            if(value == null ){
                andPriceCifIsNotNull();
            } else {
                addCriterion("ODT_PRICE_CIF <>", value, "priceCif");
            }
            return (Criteria) this;
        }

        public Criteria andPriceCifGreaterThan(String value) {
            addCriterion("ODT_PRICE_CIF >", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_CIF >=", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifLessThan(String value) {
            addCriterion("ODT_PRICE_CIF <", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifLessThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_CIF <=", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifLike(String value) {
            addCriterion("ODT_PRICE_CIF like", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifNotLike(String value) {
            addCriterion("ODT_PRICE_CIF not like", value, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifIn(List<String> values) {
            addCriterion("ODT_PRICE_CIF in", values, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifNotIn(List<String> values) {
            addCriterion("ODT_PRICE_CIF not in", values, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_CIF between", value1, value2, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceCifNotBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_CIF not between", value1, value2, "priceCif");
            return (Criteria) this;
        }

        public Criteria andPriceSaleIsNull() {
            addCriterion("ODT_PRICE_SALE is null");
            return (Criteria) this;
        }

        public Criteria andPriceSaleIsNotNull() {
            addCriterion("ODT_PRICE_SALE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceSaleEqualTo(String value) {
            if(value == null ){
                andPriceSaleIsNull();
            } else {
                addCriterion("ODT_PRICE_SALE =", value, "priceSale");
            }
            return (Criteria) this;
        }

        public Criteria andPriceSaleNotEqualTo(String value) {
            if(value == null ){
                andPriceSaleIsNotNull();
            } else {
                addCriterion("ODT_PRICE_SALE <>", value, "priceSale");
            }
            return (Criteria) this;
        }

        public Criteria andPriceSaleGreaterThan(String value) {
            addCriterion("ODT_PRICE_SALE >", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_SALE >=", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleLessThan(String value) {
            addCriterion("ODT_PRICE_SALE <", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleLessThanOrEqualTo(String value) {
            addCriterion("ODT_PRICE_SALE <=", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleLike(String value) {
            addCriterion("ODT_PRICE_SALE like", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleNotLike(String value) {
            addCriterion("ODT_PRICE_SALE not like", value, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleIn(List<String> values) {
            addCriterion("ODT_PRICE_SALE in", values, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleNotIn(List<String> values) {
            addCriterion("ODT_PRICE_SALE not in", values, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_SALE between", value1, value2, "priceSale");
            return (Criteria) this;
        }

        public Criteria andPriceSaleNotBetween(String value1, String value2) {
            addCriterion("ODT_PRICE_SALE not between", value1, value2, "priceSale");
            return (Criteria) this;
        }

        public Criteria andCountIsNull() {
            addCriterion("ODT_COUNT is null");
            return (Criteria) this;
        }

        public Criteria andCountIsNotNull() {
            addCriterion("ODT_COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCountEqualTo(String value) {
            if(value == null ){
                andCountIsNull();
            } else {
                addCriterion("ODT_COUNT =", value, "count");
            }
            return (Criteria) this;
        }

        public Criteria andCountNotEqualTo(String value) {
            if(value == null ){
                andCountIsNotNull();
            } else {
                addCriterion("ODT_COUNT <>", value, "count");
            }
            return (Criteria) this;
        }

        public Criteria andCountGreaterThan(String value) {
            addCriterion("ODT_COUNT >", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_COUNT >=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThan(String value) {
            addCriterion("ODT_COUNT <", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLessThanOrEqualTo(String value) {
            addCriterion("ODT_COUNT <=", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountLike(String value) {
            addCriterion("ODT_COUNT like", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotLike(String value) {
            addCriterion("ODT_COUNT not like", value, "count");
            return (Criteria) this;
        }

        public Criteria andCountIn(List<String> values) {
            addCriterion("ODT_COUNT in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotIn(List<String> values) {
            addCriterion("ODT_COUNT not in", values, "count");
            return (Criteria) this;
        }

        public Criteria andCountBetween(String value1, String value2) {
            addCriterion("ODT_COUNT between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andCountNotBetween(String value1, String value2) {
            addCriterion("ODT_COUNT not between", value1, value2, "count");
            return (Criteria) this;
        }

        public Criteria andSumAmtIsNull() {
            addCriterion("ODT_SUM_AMT is null");
            return (Criteria) this;
        }

        public Criteria andSumAmtIsNotNull() {
            addCriterion("ODT_SUM_AMT is not null");
            return (Criteria) this;
        }

        public Criteria andSumAmtEqualTo(String value) {
            if(value == null ){
                andSumAmtIsNull();
            } else {
                addCriterion("ODT_SUM_AMT =", value, "sumAmt");
            }
            return (Criteria) this;
        }

        public Criteria andSumAmtNotEqualTo(String value) {
            if(value == null ){
                andSumAmtIsNotNull();
            } else {
                addCriterion("ODT_SUM_AMT <>", value, "sumAmt");
            }
            return (Criteria) this;
        }

        public Criteria andSumAmtGreaterThan(String value) {
            addCriterion("ODT_SUM_AMT >", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_SUM_AMT >=", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtLessThan(String value) {
            addCriterion("ODT_SUM_AMT <", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtLessThanOrEqualTo(String value) {
            addCriterion("ODT_SUM_AMT <=", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtLike(String value) {
            addCriterion("ODT_SUM_AMT like", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtNotLike(String value) {
            addCriterion("ODT_SUM_AMT not like", value, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtIn(List<String> values) {
            addCriterion("ODT_SUM_AMT in", values, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtNotIn(List<String> values) {
            addCriterion("ODT_SUM_AMT not in", values, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtBetween(String value1, String value2) {
            addCriterion("ODT_SUM_AMT between", value1, value2, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andSumAmtNotBetween(String value1, String value2) {
            addCriterion("ODT_SUM_AMT not between", value1, value2, "sumAmt");
            return (Criteria) this;
        }

        public Criteria andMarginLevelIsNull() {
            addCriterion("ODT_Margin_level is null");
            return (Criteria) this;
        }

        public Criteria andMarginLevelIsNotNull() {
            addCriterion("ODT_Margin_level is not null");
            return (Criteria) this;
        }

        public Criteria andMarginLevelEqualTo(String value) {
            if(value == null ){
                andMarginLevelIsNull();
            } else {
                addCriterion("ODT_Margin_level =", value, "marginLevel");
            }
            return (Criteria) this;
        }

        public Criteria andMarginLevelNotEqualTo(String value) {
            if(value == null ){
                andMarginLevelIsNotNull();
            } else {
                addCriterion("ODT_Margin_level <>", value, "marginLevel");
            }
            return (Criteria) this;
        }

        public Criteria andMarginLevelGreaterThan(String value) {
            addCriterion("ODT_Margin_level >", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelGreaterThanOrEqualTo(String value) {
            addCriterion("ODT_Margin_level >=", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelLessThan(String value) {
            addCriterion("ODT_Margin_level <", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelLessThanOrEqualTo(String value) {
            addCriterion("ODT_Margin_level <=", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelLike(String value) {
            addCriterion("ODT_Margin_level like", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelNotLike(String value) {
            addCriterion("ODT_Margin_level not like", value, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelIn(List<String> values) {
            addCriterion("ODT_Margin_level in", values, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelNotIn(List<String> values) {
            addCriterion("ODT_Margin_level not in", values, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelBetween(String value1, String value2) {
            addCriterion("ODT_Margin_level between", value1, value2, "marginLevel");
            return (Criteria) this;
        }

        public Criteria andMarginLevelNotBetween(String value1, String value2) {
            addCriterion("ODT_Margin_level not between", value1, value2, "marginLevel");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table tp_order_detail
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table tp_order_detail
     *
     * @mbggenerated
     */
    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;

        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;
        }

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

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

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