package com.farriver.bwf.data.master.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderActiveExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    /**
     * 这是Mybatis Generator拓展插件生成的属性(请勿删除).
     * This field corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    protected Integer offset;

    /**
     * 这是Mybatis Generator拓展插件生成的属性(请勿删除).
     * This field corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    protected Integer rows;

    public OrderActiveExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public Integer getOffset() {
        return offset;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public void setRows(Integer rows) {
        this.rows = rows;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public Integer getRows() {
        return rows;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public OrderActiveExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public OrderActiveExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    /**
     * 这是Mybatis Generator拓展插件生成的方法(请勿删除).
     * This method corresponds to the database table fr_bwf..order_active
     *
     * @mbg.generated
     * @author hewei
     */
    public OrderActiveExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    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(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andNoIsNull() {
            addCriterion("no is null");
            return (Criteria) this;
        }

        public Criteria andNoIsNotNull() {
            addCriterion("no is not null");
            return (Criteria) this;
        }

        public Criteria andNoEqualTo(String value) {
            addCriterion("no =", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoNotEqualTo(String value) {
            addCriterion("no <>", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoGreaterThan(String value) {
            addCriterion("no >", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoGreaterThanOrEqualTo(String value) {
            addCriterion("no >=", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoLessThan(String value) {
            addCriterion("no <", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoLessThanOrEqualTo(String value) {
            addCriterion("no <=", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoLike(String value) {
            addCriterion("no like", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoNotLike(String value) {
            addCriterion("no not like", value, "no");
            return (Criteria) this;
        }

        public Criteria andNoIn(List<String> values) {
            addCriterion("no in", values, "no");
            return (Criteria) this;
        }

        public Criteria andNoNotIn(List<String> values) {
            addCriterion("no not in", values, "no");
            return (Criteria) this;
        }

        public Criteria andNoBetween(String value1, String value2) {
            addCriterion("no between", value1, value2, "no");
            return (Criteria) this;
        }

        public Criteria andNoNotBetween(String value1, String value2) {
            addCriterion("no not between", value1, value2, "no");
            return (Criteria) this;
        }

        public Criteria andTotalmoneyIsNull() {
            addCriterion("totalmoney is null");
            return (Criteria) this;
        }

        public Criteria andTotalmoneyIsNotNull() {
            addCriterion("totalmoney is not null");
            return (Criteria) this;
        }

        public Criteria andTotalmoneyEqualTo(BigDecimal value) {
            addCriterion("totalmoney =", value, "totalmoney");
            return (Criteria) this;
        }

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

        public Criteria andTotalmoneyGreaterThan(BigDecimal value) {
            addCriterion("totalmoney >", value, "totalmoney");
            return (Criteria) this;
        }

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

        public Criteria andTotalmoneyLessThan(BigDecimal value) {
            addCriterion("totalmoney <", value, "totalmoney");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andPayedmoneyIsNull() {
            addCriterion("payedmoney is null");
            return (Criteria) this;
        }

        public Criteria andPayedmoneyIsNotNull() {
            addCriterion("payedmoney is not null");
            return (Criteria) this;
        }

        public Criteria andPayedmoneyEqualTo(BigDecimal value) {
            addCriterion("payedmoney =", value, "payedmoney");
            return (Criteria) this;
        }

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

        public Criteria andPayedmoneyGreaterThan(BigDecimal value) {
            addCriterion("payedmoney >", value, "payedmoney");
            return (Criteria) this;
        }

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

        public Criteria andPayedmoneyLessThan(BigDecimal value) {
            addCriterion("payedmoney <", value, "payedmoney");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andPaymentmethodIsNull() {
            addCriterion("paymentmethod is null");
            return (Criteria) this;
        }

        public Criteria andPaymentmethodIsNotNull() {
            addCriterion("paymentmethod is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentmethodEqualTo(Integer value) {
            addCriterion("paymentmethod =", value, "paymentmethod");
            return (Criteria) this;
        }

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

        public Criteria andPaymentmethodGreaterThan(Integer value) {
            addCriterion("paymentmethod >", value, "paymentmethod");
            return (Criteria) this;
        }

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

        public Criteria andPaymentmethodLessThan(Integer value) {
            addCriterion("paymentmethod <", value, "paymentmethod");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andDiscountmoneyIsNull() {
            addCriterion("discountmoney is null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyIsNotNull() {
            addCriterion("discountmoney is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountmoneyEqualTo(BigDecimal value) {
            addCriterion("discountmoney =", value, "discountmoney");
            return (Criteria) this;
        }

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

        public Criteria andDiscountmoneyGreaterThan(BigDecimal value) {
            addCriterion("discountmoney >", value, "discountmoney");
            return (Criteria) this;
        }

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

        public Criteria andDiscountmoneyLessThan(BigDecimal value) {
            addCriterion("discountmoney <", value, "discountmoney");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

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

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

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

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andOrdertimeIsNull() {
            addCriterion("ordertime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("ordertime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(Date value) {
            addCriterion("ordertime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(Date value) {
            addCriterion("ordertime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(Date value) {
            addCriterion("ordertime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ordertime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(Date value) {
            addCriterion("ordertime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(Date value) {
            addCriterion("ordertime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<Date> values) {
            addCriterion("ordertime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<Date> values) {
            addCriterion("ordertime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(Date value1, Date value2) {
            addCriterion("ordertime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(Date value1, Date value2) {
            addCriterion("ordertime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("paytime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("paytime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("paytime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("paytime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("paytime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("paytime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("paytime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("paytime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("paytime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("paytime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("paytime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("paytime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andSendtimeIsNull() {
            addCriterion("sendtime is null");
            return (Criteria) this;
        }

        public Criteria andSendtimeIsNotNull() {
            addCriterion("sendtime is not null");
            return (Criteria) this;
        }

        public Criteria andSendtimeEqualTo(Date value) {
            addCriterion("sendtime =", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotEqualTo(Date value) {
            addCriterion("sendtime <>", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeGreaterThan(Date value) {
            addCriterion("sendtime >", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("sendtime >=", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeLessThan(Date value) {
            addCriterion("sendtime <", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeLessThanOrEqualTo(Date value) {
            addCriterion("sendtime <=", value, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeIn(List<Date> values) {
            addCriterion("sendtime in", values, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotIn(List<Date> values) {
            addCriterion("sendtime not in", values, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeBetween(Date value1, Date value2) {
            addCriterion("sendtime between", value1, value2, "sendtime");
            return (Criteria) this;
        }

        public Criteria andSendtimeNotBetween(Date value1, Date value2) {
            addCriterion("sendtime not between", value1, value2, "sendtime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeIsNull() {
            addCriterion("receivetime is null");
            return (Criteria) this;
        }

        public Criteria andReceivetimeIsNotNull() {
            addCriterion("receivetime is not null");
            return (Criteria) this;
        }

        public Criteria andReceivetimeEqualTo(Date value) {
            addCriterion("receivetime =", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeNotEqualTo(Date value) {
            addCriterion("receivetime <>", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeGreaterThan(Date value) {
            addCriterion("receivetime >", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receivetime >=", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeLessThan(Date value) {
            addCriterion("receivetime <", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeLessThanOrEqualTo(Date value) {
            addCriterion("receivetime <=", value, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeIn(List<Date> values) {
            addCriterion("receivetime in", values, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeNotIn(List<Date> values) {
            addCriterion("receivetime not in", values, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeBetween(Date value1, Date value2) {
            addCriterion("receivetime between", value1, value2, "receivetime");
            return (Criteria) this;
        }

        public Criteria andReceivetimeNotBetween(Date value1, Date value2) {
            addCriterion("receivetime not between", value1, value2, "receivetime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeIsNull() {
            addCriterion("commenttime is null");
            return (Criteria) this;
        }

        public Criteria andCommenttimeIsNotNull() {
            addCriterion("commenttime is not null");
            return (Criteria) this;
        }

        public Criteria andCommenttimeEqualTo(Date value) {
            addCriterion("commenttime =", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeNotEqualTo(Date value) {
            addCriterion("commenttime <>", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeGreaterThan(Date value) {
            addCriterion("commenttime >", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("commenttime >=", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeLessThan(Date value) {
            addCriterion("commenttime <", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeLessThanOrEqualTo(Date value) {
            addCriterion("commenttime <=", value, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeIn(List<Date> values) {
            addCriterion("commenttime in", values, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeNotIn(List<Date> values) {
            addCriterion("commenttime not in", values, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeBetween(Date value1, Date value2) {
            addCriterion("commenttime between", value1, value2, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCommenttimeNotBetween(Date value1, Date value2) {
            addCriterion("commenttime not between", value1, value2, "commenttime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeIsNull() {
            addCriterion("completetime is null");
            return (Criteria) this;
        }

        public Criteria andCompletetimeIsNotNull() {
            addCriterion("completetime is not null");
            return (Criteria) this;
        }

        public Criteria andCompletetimeEqualTo(Date value) {
            addCriterion("completetime =", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeNotEqualTo(Date value) {
            addCriterion("completetime <>", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeGreaterThan(Date value) {
            addCriterion("completetime >", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("completetime >=", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeLessThan(Date value) {
            addCriterion("completetime <", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeLessThanOrEqualTo(Date value) {
            addCriterion("completetime <=", value, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeIn(List<Date> values) {
            addCriterion("completetime in", values, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeNotIn(List<Date> values) {
            addCriterion("completetime not in", values, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeBetween(Date value1, Date value2) {
            addCriterion("completetime between", value1, value2, "completetime");
            return (Criteria) this;
        }

        public Criteria andCompletetimeNotBetween(Date value1, Date value2) {
            addCriterion("completetime not between", value1, value2, "completetime");
            return (Criteria) this;
        }

        public Criteria andIsdeletedIsNull() {
            addCriterion("isdeleted is null");
            return (Criteria) this;
        }

        public Criteria andIsdeletedIsNotNull() {
            addCriterion("isdeleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsdeletedEqualTo(Boolean value) {
            addCriterion("isdeleted =", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedNotEqualTo(Boolean value) {
            addCriterion("isdeleted <>", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedGreaterThan(Boolean value) {
            addCriterion("isdeleted >", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("isdeleted >=", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedLessThan(Boolean value) {
            addCriterion("isdeleted <", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("isdeleted <=", value, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedIn(List<Boolean> values) {
            addCriterion("isdeleted in", values, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedNotIn(List<Boolean> values) {
            addCriterion("isdeleted not in", values, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("isdeleted between", value1, value2, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andIsdeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("isdeleted not between", value1, value2, "isdeleted");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("updatetime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("updatetime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("updatetime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("updatetime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("updatetime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("updatetime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("updatetime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("updatetime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("updatetime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("updatetime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("updatetime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("updatetime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andSendernameIsNull() {
            addCriterion("sendername is null");
            return (Criteria) this;
        }

        public Criteria andSendernameIsNotNull() {
            addCriterion("sendername is not null");
            return (Criteria) this;
        }

        public Criteria andSendernameEqualTo(String value) {
            addCriterion("sendername =", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameNotEqualTo(String value) {
            addCriterion("sendername <>", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameGreaterThan(String value) {
            addCriterion("sendername >", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameGreaterThanOrEqualTo(String value) {
            addCriterion("sendername >=", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameLessThan(String value) {
            addCriterion("sendername <", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameLessThanOrEqualTo(String value) {
            addCriterion("sendername <=", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameLike(String value) {
            addCriterion("sendername like", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameNotLike(String value) {
            addCriterion("sendername not like", value, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameIn(List<String> values) {
            addCriterion("sendername in", values, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameNotIn(List<String> values) {
            addCriterion("sendername not in", values, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameBetween(String value1, String value2) {
            addCriterion("sendername between", value1, value2, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendernameNotBetween(String value1, String value2) {
            addCriterion("sendername not between", value1, value2, "sendername");
            return (Criteria) this;
        }

        public Criteria andSendercodeIsNull() {
            addCriterion("sendercode is null");
            return (Criteria) this;
        }

        public Criteria andSendercodeIsNotNull() {
            addCriterion("sendercode is not null");
            return (Criteria) this;
        }

        public Criteria andSendercodeEqualTo(String value) {
            addCriterion("sendercode =", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeNotEqualTo(String value) {
            addCriterion("sendercode <>", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeGreaterThan(String value) {
            addCriterion("sendercode >", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeGreaterThanOrEqualTo(String value) {
            addCriterion("sendercode >=", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeLessThan(String value) {
            addCriterion("sendercode <", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeLessThanOrEqualTo(String value) {
            addCriterion("sendercode <=", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeLike(String value) {
            addCriterion("sendercode like", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeNotLike(String value) {
            addCriterion("sendercode not like", value, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeIn(List<String> values) {
            addCriterion("sendercode in", values, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeNotIn(List<String> values) {
            addCriterion("sendercode not in", values, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeBetween(String value1, String value2) {
            addCriterion("sendercode between", value1, value2, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercodeNotBetween(String value1, String value2) {
            addCriterion("sendercode not between", value1, value2, "sendercode");
            return (Criteria) this;
        }

        public Criteria andSendercontactnoIsNull() {
            addCriterion("sendercontactno is null");
            return (Criteria) this;
        }

        public Criteria andSendercontactnoIsNotNull() {
            addCriterion("sendercontactno is not null");
            return (Criteria) this;
        }

        public Criteria andSendercontactnoEqualTo(Integer value) {
            addCriterion("sendercontactno =", value, "sendercontactno");
            return (Criteria) this;
        }

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

        public Criteria andSendercontactnoGreaterThan(Integer value) {
            addCriterion("sendercontactno >", value, "sendercontactno");
            return (Criteria) this;
        }

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

        public Criteria andSendercontactnoLessThan(Integer value) {
            addCriterion("sendercontactno <", value, "sendercontactno");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andTargetaddressIsNull() {
            addCriterion("targetaddress is null");
            return (Criteria) this;
        }

        public Criteria andTargetaddressIsNotNull() {
            addCriterion("targetaddress is not null");
            return (Criteria) this;
        }

        public Criteria andTargetaddressEqualTo(String value) {
            addCriterion("targetaddress =", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressNotEqualTo(String value) {
            addCriterion("targetaddress <>", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressGreaterThan(String value) {
            addCriterion("targetaddress >", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressGreaterThanOrEqualTo(String value) {
            addCriterion("targetaddress >=", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressLessThan(String value) {
            addCriterion("targetaddress <", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressLessThanOrEqualTo(String value) {
            addCriterion("targetaddress <=", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressLike(String value) {
            addCriterion("targetaddress like", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressNotLike(String value) {
            addCriterion("targetaddress not like", value, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressIn(List<String> values) {
            addCriterion("targetaddress in", values, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressNotIn(List<String> values) {
            addCriterion("targetaddress not in", values, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressBetween(String value1, String value2) {
            addCriterion("targetaddress between", value1, value2, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andTargetaddressNotBetween(String value1, String value2) {
            addCriterion("targetaddress not between", value1, value2, "targetaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressIsNull() {
            addCriterion("deliveryaddress is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressIsNotNull() {
            addCriterion("deliveryaddress is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressEqualTo(String value) {
            addCriterion("deliveryaddress =", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressNotEqualTo(String value) {
            addCriterion("deliveryaddress <>", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressGreaterThan(String value) {
            addCriterion("deliveryaddress >", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressGreaterThanOrEqualTo(String value) {
            addCriterion("deliveryaddress >=", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressLessThan(String value) {
            addCriterion("deliveryaddress <", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressLessThanOrEqualTo(String value) {
            addCriterion("deliveryaddress <=", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressLike(String value) {
            addCriterion("deliveryaddress like", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressNotLike(String value) {
            addCriterion("deliveryaddress not like", value, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressIn(List<String> values) {
            addCriterion("deliveryaddress in", values, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressNotIn(List<String> values) {
            addCriterion("deliveryaddress not in", values, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressBetween(String value1, String value2) {
            addCriterion("deliveryaddress between", value1, value2, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andDeliveryaddressNotBetween(String value1, String value2) {
            addCriterion("deliveryaddress not between", value1, value2, "deliveryaddress");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponIsNull() {
            addCriterion("optimalcoupon is null");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponIsNotNull() {
            addCriterion("optimalcoupon is not null");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponEqualTo(String value) {
            addCriterion("optimalcoupon =", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponNotEqualTo(String value) {
            addCriterion("optimalcoupon <>", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponGreaterThan(String value) {
            addCriterion("optimalcoupon >", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponGreaterThanOrEqualTo(String value) {
            addCriterion("optimalcoupon >=", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponLessThan(String value) {
            addCriterion("optimalcoupon <", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponLessThanOrEqualTo(String value) {
            addCriterion("optimalcoupon <=", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponLike(String value) {
            addCriterion("optimalcoupon like", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponNotLike(String value) {
            addCriterion("optimalcoupon not like", value, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponIn(List<String> values) {
            addCriterion("optimalcoupon in", values, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponNotIn(List<String> values) {
            addCriterion("optimalcoupon not in", values, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponBetween(String value1, String value2) {
            addCriterion("optimalcoupon between", value1, value2, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andOptimalcouponNotBetween(String value1, String value2) {
            addCriterion("optimalcoupon not between", value1, value2, "optimalcoupon");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIsNull() {
            addCriterion("logisticscompany is null");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIsNotNull() {
            addCriterion("logisticscompany is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyEqualTo(String value) {
            addCriterion("logisticscompany =", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotEqualTo(String value) {
            addCriterion("logisticscompany <>", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyGreaterThan(String value) {
            addCriterion("logisticscompany >", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyGreaterThanOrEqualTo(String value) {
            addCriterion("logisticscompany >=", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLessThan(String value) {
            addCriterion("logisticscompany <", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLessThanOrEqualTo(String value) {
            addCriterion("logisticscompany <=", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyLike(String value) {
            addCriterion("logisticscompany like", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotLike(String value) {
            addCriterion("logisticscompany not like", value, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyIn(List<String> values) {
            addCriterion("logisticscompany in", values, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotIn(List<String> values) {
            addCriterion("logisticscompany not in", values, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyBetween(String value1, String value2) {
            addCriterion("logisticscompany between", value1, value2, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticscompanyNotBetween(String value1, String value2) {
            addCriterion("logisticscompany not between", value1, value2, "logisticscompany");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNull() {
            addCriterion("logisticsno is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIsNotNull() {
            addCriterion("logisticsno is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoEqualTo(String value) {
            addCriterion("logisticsno =", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotEqualTo(String value) {
            addCriterion("logisticsno <>", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThan(String value) {
            addCriterion("logisticsno >", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoGreaterThanOrEqualTo(String value) {
            addCriterion("logisticsno >=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThan(String value) {
            addCriterion("logisticsno <", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLessThanOrEqualTo(String value) {
            addCriterion("logisticsno <=", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoLike(String value) {
            addCriterion("logisticsno like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotLike(String value) {
            addCriterion("logisticsno not like", value, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoIn(List<String> values) {
            addCriterion("logisticsno in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotIn(List<String> values) {
            addCriterion("logisticsno not in", values, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoBetween(String value1, String value2) {
            addCriterion("logisticsno between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andLogisticsnoNotBetween(String value1, String value2) {
            addCriterion("logisticsno not between", value1, value2, "logisticsno");
            return (Criteria) this;
        }

        public Criteria andTransportmodeIsNull() {
            addCriterion("transportmode is null");
            return (Criteria) this;
        }

        public Criteria andTransportmodeIsNotNull() {
            addCriterion("transportmode is not null");
            return (Criteria) this;
        }

        public Criteria andTransportmodeEqualTo(String value) {
            addCriterion("transportmode =", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeNotEqualTo(String value) {
            addCriterion("transportmode <>", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeGreaterThan(String value) {
            addCriterion("transportmode >", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeGreaterThanOrEqualTo(String value) {
            addCriterion("transportmode >=", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeLessThan(String value) {
            addCriterion("transportmode <", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeLessThanOrEqualTo(String value) {
            addCriterion("transportmode <=", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeLike(String value) {
            addCriterion("transportmode like", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeNotLike(String value) {
            addCriterion("transportmode not like", value, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeIn(List<String> values) {
            addCriterion("transportmode in", values, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeNotIn(List<String> values) {
            addCriterion("transportmode not in", values, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeBetween(String value1, String value2) {
            addCriterion("transportmode between", value1, value2, "transportmode");
            return (Criteria) this;
        }

        public Criteria andTransportmodeNotBetween(String value1, String value2) {
            addCriterion("transportmode not between", value1, value2, "transportmode");
            return (Criteria) this;
        }

        public Criteria andBoxcountIsNull() {
            addCriterion("boxcount is null");
            return (Criteria) this;
        }

        public Criteria andBoxcountIsNotNull() {
            addCriterion("boxcount is not null");
            return (Criteria) this;
        }

        public Criteria andBoxcountEqualTo(Integer value) {
            addCriterion("boxcount =", value, "boxcount");
            return (Criteria) this;
        }

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

        public Criteria andBoxcountGreaterThan(Integer value) {
            addCriterion("boxcount >", value, "boxcount");
            return (Criteria) this;
        }

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

        public Criteria andBoxcountLessThan(Integer value) {
            addCriterion("boxcount <", value, "boxcount");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andBoxweightIsNull() {
            addCriterion("boxweight is null");
            return (Criteria) this;
        }

        public Criteria andBoxweightIsNotNull() {
            addCriterion("boxweight is not null");
            return (Criteria) this;
        }

        public Criteria andBoxweightEqualTo(BigDecimal value) {
            addCriterion("boxweight =", value, "boxweight");
            return (Criteria) this;
        }

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

        public Criteria andBoxweightGreaterThan(BigDecimal value) {
            addCriterion("boxweight >", value, "boxweight");
            return (Criteria) this;
        }

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

        public Criteria andBoxweightLessThan(BigDecimal value) {
            addCriterion("boxweight <", value, "boxweight");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andFreightIsNull() {
            addCriterion("freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(BigDecimal value) {
            addCriterion("freight =", value, "freight");
            return (Criteria) this;
        }

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

        public Criteria andFreightGreaterThan(BigDecimal value) {
            addCriterion("freight >", value, "freight");
            return (Criteria) this;
        }

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

        public Criteria andFreightLessThan(BigDecimal value) {
            addCriterion("freight <", value, "freight");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andCommentcontentIsNull() {
            addCriterion("commentcontent is null");
            return (Criteria) this;
        }

        public Criteria andCommentcontentIsNotNull() {
            addCriterion("commentcontent is not null");
            return (Criteria) this;
        }

        public Criteria andCommentcontentEqualTo(String value) {
            addCriterion("commentcontent =", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentNotEqualTo(String value) {
            addCriterion("commentcontent <>", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentGreaterThan(String value) {
            addCriterion("commentcontent >", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentGreaterThanOrEqualTo(String value) {
            addCriterion("commentcontent >=", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentLessThan(String value) {
            addCriterion("commentcontent <", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentLessThanOrEqualTo(String value) {
            addCriterion("commentcontent <=", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentLike(String value) {
            addCriterion("commentcontent like", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentNotLike(String value) {
            addCriterion("commentcontent not like", value, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentIn(List<String> values) {
            addCriterion("commentcontent in", values, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentNotIn(List<String> values) {
            addCriterion("commentcontent not in", values, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentBetween(String value1, String value2) {
            addCriterion("commentcontent between", value1, value2, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentcontentNotBetween(String value1, String value2) {
            addCriterion("commentcontent not between", value1, value2, "commentcontent");
            return (Criteria) this;
        }

        public Criteria andCommentlevelIsNull() {
            addCriterion("commentlevel is null");
            return (Criteria) this;
        }

        public Criteria andCommentlevelIsNotNull() {
            addCriterion("commentlevel is not null");
            return (Criteria) this;
        }

        public Criteria andCommentlevelEqualTo(Integer value) {
            addCriterion("commentlevel =", value, "commentlevel");
            return (Criteria) this;
        }

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

        public Criteria andCommentlevelGreaterThan(Integer value) {
            addCriterion("commentlevel >", value, "commentlevel");
            return (Criteria) this;
        }

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

        public Criteria andCommentlevelLessThan(Integer value) {
            addCriterion("commentlevel <", value, "commentlevel");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andReceiveridIsNull() {
            addCriterion("receiverid is null");
            return (Criteria) this;
        }

        public Criteria andReceiveridIsNotNull() {
            addCriterion("receiverid is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveridEqualTo(String value) {
            addCriterion("receiverid =", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridNotEqualTo(String value) {
            addCriterion("receiverid <>", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridGreaterThan(String value) {
            addCriterion("receiverid >", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridGreaterThanOrEqualTo(String value) {
            addCriterion("receiverid >=", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridLessThan(String value) {
            addCriterion("receiverid <", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridLessThanOrEqualTo(String value) {
            addCriterion("receiverid <=", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridLike(String value) {
            addCriterion("receiverid like", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridNotLike(String value) {
            addCriterion("receiverid not like", value, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridIn(List<String> values) {
            addCriterion("receiverid in", values, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridNotIn(List<String> values) {
            addCriterion("receiverid not in", values, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridBetween(String value1, String value2) {
            addCriterion("receiverid between", value1, value2, "receiverid");
            return (Criteria) this;
        }

        public Criteria andReceiveridNotBetween(String value1, String value2) {
            addCriterion("receiverid not between", value1, value2, "receiverid");
            return (Criteria) this;
        }

        public Criteria andVipuseridIsNull() {
            addCriterion("vipuserId is null");
            return (Criteria) this;
        }

        public Criteria andVipuseridIsNotNull() {
            addCriterion("vipuserId is not null");
            return (Criteria) this;
        }

        public Criteria andVipuseridEqualTo(String value) {
            addCriterion("vipuserId =", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridNotEqualTo(String value) {
            addCriterion("vipuserId <>", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridGreaterThan(String value) {
            addCriterion("vipuserId >", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridGreaterThanOrEqualTo(String value) {
            addCriterion("vipuserId >=", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridLessThan(String value) {
            addCriterion("vipuserId <", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridLessThanOrEqualTo(String value) {
            addCriterion("vipuserId <=", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridLike(String value) {
            addCriterion("vipuserId like", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridNotLike(String value) {
            addCriterion("vipuserId not like", value, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridIn(List<String> values) {
            addCriterion("vipuserId in", values, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridNotIn(List<String> values) {
            addCriterion("vipuserId not in", values, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridBetween(String value1, String value2) {
            addCriterion("vipuserId between", value1, value2, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipuseridNotBetween(String value1, String value2) {
            addCriterion("vipuserId not between", value1, value2, "vipuserid");
            return (Criteria) this;
        }

        public Criteria andVipnameIsNull() {
            addCriterion("vipname is null");
            return (Criteria) this;
        }

        public Criteria andVipnameIsNotNull() {
            addCriterion("vipname is not null");
            return (Criteria) this;
        }

        public Criteria andVipnameEqualTo(String value) {
            addCriterion("vipname =", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotEqualTo(String value) {
            addCriterion("vipname <>", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameGreaterThan(String value) {
            addCriterion("vipname >", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameGreaterThanOrEqualTo(String value) {
            addCriterion("vipname >=", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLessThan(String value) {
            addCriterion("vipname <", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLessThanOrEqualTo(String value) {
            addCriterion("vipname <=", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameLike(String value) {
            addCriterion("vipname like", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotLike(String value) {
            addCriterion("vipname not like", value, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameIn(List<String> values) {
            addCriterion("vipname in", values, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotIn(List<String> values) {
            addCriterion("vipname not in", values, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameBetween(String value1, String value2) {
            addCriterion("vipname between", value1, value2, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipnameNotBetween(String value1, String value2) {
            addCriterion("vipname not between", value1, value2, "vipname");
            return (Criteria) this;
        }

        public Criteria andVipphoneIsNull() {
            addCriterion("vipphone is null");
            return (Criteria) this;
        }

        public Criteria andVipphoneIsNotNull() {
            addCriterion("vipphone is not null");
            return (Criteria) this;
        }

        public Criteria andVipphoneEqualTo(String value) {
            addCriterion("vipphone =", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneNotEqualTo(String value) {
            addCriterion("vipphone <>", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneGreaterThan(String value) {
            addCriterion("vipphone >", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneGreaterThanOrEqualTo(String value) {
            addCriterion("vipphone >=", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneLessThan(String value) {
            addCriterion("vipphone <", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneLessThanOrEqualTo(String value) {
            addCriterion("vipphone <=", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneLike(String value) {
            addCriterion("vipphone like", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneNotLike(String value) {
            addCriterion("vipphone not like", value, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneIn(List<String> values) {
            addCriterion("vipphone in", values, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneNotIn(List<String> values) {
            addCriterion("vipphone not in", values, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneBetween(String value1, String value2) {
            addCriterion("vipphone between", value1, value2, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipphoneNotBetween(String value1, String value2) {
            addCriterion("vipphone not between", value1, value2, "vipphone");
            return (Criteria) this;
        }

        public Criteria andVipdiamondtypeIsNull() {
            addCriterion("vipdiamondtype is null");
            return (Criteria) this;
        }

        public Criteria andVipdiamondtypeIsNotNull() {
            addCriterion("vipdiamondtype is not null");
            return (Criteria) this;
        }

        public Criteria andVipdiamondtypeEqualTo(Integer value) {
            addCriterion("vipdiamondtype =", value, "vipdiamondtype");
            return (Criteria) this;
        }

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

        public Criteria andVipdiamondtypeGreaterThan(Integer value) {
            addCriterion("vipdiamondtype >", value, "vipdiamondtype");
            return (Criteria) this;
        }

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

        public Criteria andVipdiamondtypeLessThan(Integer value) {
            addCriterion("vipdiamondtype <", value, "vipdiamondtype");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andViptypeIsNull() {
            addCriterion("viptype is null");
            return (Criteria) this;
        }

        public Criteria andViptypeIsNotNull() {
            addCriterion("viptype is not null");
            return (Criteria) this;
        }

        public Criteria andViptypeEqualTo(Integer value) {
            addCriterion("viptype =", value, "viptype");
            return (Criteria) this;
        }

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

        public Criteria andViptypeGreaterThan(Integer value) {
            addCriterion("viptype >", value, "viptype");
            return (Criteria) this;
        }

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

        public Criteria andViptypeLessThan(Integer value) {
            addCriterion("viptype <", value, "viptype");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andVippictureIsNull() {
            addCriterion("vippicture is null");
            return (Criteria) this;
        }

        public Criteria andVippictureIsNotNull() {
            addCriterion("vippicture is not null");
            return (Criteria) this;
        }

        public Criteria andVippictureEqualTo(String value) {
            addCriterion("vippicture =", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureNotEqualTo(String value) {
            addCriterion("vippicture <>", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureGreaterThan(String value) {
            addCriterion("vippicture >", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureGreaterThanOrEqualTo(String value) {
            addCriterion("vippicture >=", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureLessThan(String value) {
            addCriterion("vippicture <", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureLessThanOrEqualTo(String value) {
            addCriterion("vippicture <=", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureLike(String value) {
            addCriterion("vippicture like", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureNotLike(String value) {
            addCriterion("vippicture not like", value, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureIn(List<String> values) {
            addCriterion("vippicture in", values, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureNotIn(List<String> values) {
            addCriterion("vippicture not in", values, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureBetween(String value1, String value2) {
            addCriterion("vippicture between", value1, value2, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVippictureNotBetween(String value1, String value2) {
            addCriterion("vippicture not between", value1, value2, "vippicture");
            return (Criteria) this;
        }

        public Criteria andVipcarddiscountrateIsNull() {
            addCriterion("vipcarddiscountrate is null");
            return (Criteria) this;
        }

        public Criteria andVipcarddiscountrateIsNotNull() {
            addCriterion("vipcarddiscountrate is not null");
            return (Criteria) this;
        }

        public Criteria andVipcarddiscountrateEqualTo(BigDecimal value) {
            addCriterion("vipcarddiscountrate =", value, "vipcarddiscountrate");
            return (Criteria) this;
        }

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

        public Criteria andVipcarddiscountrateGreaterThan(BigDecimal value) {
            addCriterion("vipcarddiscountrate >", value, "vipcarddiscountrate");
            return (Criteria) this;
        }

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

        public Criteria andVipcarddiscountrateLessThan(BigDecimal value) {
            addCriterion("vipcarddiscountrate <", value, "vipcarddiscountrate");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

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

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

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

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

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

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

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

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

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

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

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