package com.zteits.pay.domain;

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

public class TdCCustInvoiceSaleExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TdCCustInvoiceSaleExample() {
        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;
    }

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

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

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

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

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

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

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

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

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

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

        public Criteria andSaleNameIsNull() {
            addCriterion("sale_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleNameIsNotNull() {
            addCriterion("sale_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleNameEqualTo(String value) {
            addCriterion("sale_name =", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotEqualTo(String value) {
            addCriterion("sale_name <>", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameGreaterThan(String value) {
            addCriterion("sale_name >", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_name >=", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameLessThan(String value) {
            addCriterion("sale_name <", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameLessThanOrEqualTo(String value) {
            addCriterion("sale_name <=", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameLike(String value) {
            addCriterion("sale_name like", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotLike(String value) {
            addCriterion("sale_name not like", value, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameIn(List<String> values) {
            addCriterion("sale_name in", values, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotIn(List<String> values) {
            addCriterion("sale_name not in", values, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameBetween(String value1, String value2) {
            addCriterion("sale_name between", value1, value2, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleNameNotBetween(String value1, String value2) {
            addCriterion("sale_name not between", value1, value2, "saleName");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidIsNull() {
            addCriterion("sale_taxID is null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidIsNotNull() {
            addCriterion("sale_taxID is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidEqualTo(String value) {
            addCriterion("sale_taxID =", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotEqualTo(String value) {
            addCriterion("sale_taxID <>", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidGreaterThan(String value) {
            addCriterion("sale_taxID >", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidGreaterThanOrEqualTo(String value) {
            addCriterion("sale_taxID >=", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidLessThan(String value) {
            addCriterion("sale_taxID <", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidLessThanOrEqualTo(String value) {
            addCriterion("sale_taxID <=", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidLike(String value) {
            addCriterion("sale_taxID like", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotLike(String value) {
            addCriterion("sale_taxID not like", value, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidIn(List<String> values) {
            addCriterion("sale_taxID in", values, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotIn(List<String> values) {
            addCriterion("sale_taxID not in", values, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidBetween(String value1, String value2) {
            addCriterion("sale_taxID between", value1, value2, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleTaxidNotBetween(String value1, String value2) {
            addCriterion("sale_taxID not between", value1, value2, "saleTaxid");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameIsNull() {
            addCriterion("sale_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameIsNotNull() {
            addCriterion("sale_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameEqualTo(String value) {
            addCriterion("sale_bank_name =", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotEqualTo(String value) {
            addCriterion("sale_bank_name <>", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameGreaterThan(String value) {
            addCriterion("sale_bank_name >", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("sale_bank_name >=", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameLessThan(String value) {
            addCriterion("sale_bank_name <", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameLessThanOrEqualTo(String value) {
            addCriterion("sale_bank_name <=", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameLike(String value) {
            addCriterion("sale_bank_name like", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotLike(String value) {
            addCriterion("sale_bank_name not like", value, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameIn(List<String> values) {
            addCriterion("sale_bank_name in", values, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotIn(List<String> values) {
            addCriterion("sale_bank_name not in", values, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameBetween(String value1, String value2) {
            addCriterion("sale_bank_name between", value1, value2, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNameNotBetween(String value1, String value2) {
            addCriterion("sale_bank_name not between", value1, value2, "saleBankName");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoIsNull() {
            addCriterion("sale_bank_no is null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoIsNotNull() {
            addCriterion("sale_bank_no is not null");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoEqualTo(String value) {
            addCriterion("sale_bank_no =", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoNotEqualTo(String value) {
            addCriterion("sale_bank_no <>", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoGreaterThan(String value) {
            addCriterion("sale_bank_no >", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoGreaterThanOrEqualTo(String value) {
            addCriterion("sale_bank_no >=", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoLessThan(String value) {
            addCriterion("sale_bank_no <", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoLessThanOrEqualTo(String value) {
            addCriterion("sale_bank_no <=", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoLike(String value) {
            addCriterion("sale_bank_no like", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoNotLike(String value) {
            addCriterion("sale_bank_no not like", value, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoIn(List<String> values) {
            addCriterion("sale_bank_no in", values, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoNotIn(List<String> values) {
            addCriterion("sale_bank_no not in", values, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoBetween(String value1, String value2) {
            addCriterion("sale_bank_no between", value1, value2, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andSaleBankNoNotBetween(String value1, String value2) {
            addCriterion("sale_bank_no not between", value1, value2, "saleBankNo");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumIsNull() {
            addCriterion("invoice_total_num is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumIsNotNull() {
            addCriterion("invoice_total_num is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumEqualTo(Integer value) {
            addCriterion("invoice_total_num =", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumNotEqualTo(Integer value) {
            addCriterion("invoice_total_num <>", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumGreaterThan(Integer value) {
            addCriterion("invoice_total_num >", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_total_num >=", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumLessThan(Integer value) {
            addCriterion("invoice_total_num <", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_total_num <=", value, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumIn(List<Integer> values) {
            addCriterion("invoice_total_num in", values, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumNotIn(List<Integer> values) {
            addCriterion("invoice_total_num not in", values, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumBetween(Integer value1, Integer value2) {
            addCriterion("invoice_total_num between", value1, value2, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceTotalNumNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_total_num not between", value1, value2, "invoiceTotalNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumIsNull() {
            addCriterion("invoice_surplus_num is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumIsNotNull() {
            addCriterion("invoice_surplus_num is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumEqualTo(Integer value) {
            addCriterion("invoice_surplus_num =", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumNotEqualTo(Integer value) {
            addCriterion("invoice_surplus_num <>", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumGreaterThan(Integer value) {
            addCriterion("invoice_surplus_num >", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_surplus_num >=", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumLessThan(Integer value) {
            addCriterion("invoice_surplus_num <", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_surplus_num <=", value, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumIn(List<Integer> values) {
            addCriterion("invoice_surplus_num in", values, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumNotIn(List<Integer> values) {
            addCriterion("invoice_surplus_num not in", values, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumBetween(Integer value1, Integer value2) {
            addCriterion("invoice_surplus_num between", value1, value2, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceSurplusNumNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_surplus_num not between", value1, value2, "invoiceSurplusNum");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

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

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

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

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

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

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andPhoneNoIsNull() {
            addCriterion("phone_no is null");
            return (Criteria) this;
        }

        public Criteria andPhoneNoIsNotNull() {
            addCriterion("phone_no is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneNoEqualTo(String value) {
            addCriterion("phone_no =", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoNotEqualTo(String value) {
            addCriterion("phone_no <>", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoGreaterThan(String value) {
            addCriterion("phone_no >", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoGreaterThanOrEqualTo(String value) {
            addCriterion("phone_no >=", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoLessThan(String value) {
            addCriterion("phone_no <", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoLessThanOrEqualTo(String value) {
            addCriterion("phone_no <=", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoLike(String value) {
            addCriterion("phone_no like", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoNotLike(String value) {
            addCriterion("phone_no not like", value, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoIn(List<String> values) {
            addCriterion("phone_no in", values, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoNotIn(List<String> values) {
            addCriterion("phone_no not in", values, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoBetween(String value1, String value2) {
            addCriterion("phone_no between", value1, value2, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andPhoneNoNotBetween(String value1, String value2) {
            addCriterion("phone_no not between", value1, value2, "phoneNo");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeIsNull() {
            addCriterion("register_code is null");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeIsNotNull() {
            addCriterion("register_code is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeEqualTo(String value) {
            addCriterion("register_code =", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeNotEqualTo(String value) {
            addCriterion("register_code <>", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeGreaterThan(String value) {
            addCriterion("register_code >", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeGreaterThanOrEqualTo(String value) {
            addCriterion("register_code >=", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeLessThan(String value) {
            addCriterion("register_code <", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeLessThanOrEqualTo(String value) {
            addCriterion("register_code <=", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeLike(String value) {
            addCriterion("register_code like", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeNotLike(String value) {
            addCriterion("register_code not like", value, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeIn(List<String> values) {
            addCriterion("register_code in", values, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeNotIn(List<String> values) {
            addCriterion("register_code not in", values, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeBetween(String value1, String value2) {
            addCriterion("register_code between", value1, value2, "registerCode");
            return (Criteria) this;
        }

        public Criteria andRegisterCodeNotBetween(String value1, String value2) {
            addCriterion("register_code not between", value1, value2, "registerCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeIsNull() {
            addCriterion("authorization_code is null");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeIsNotNull() {
            addCriterion("authorization_code is not null");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeEqualTo(String value) {
            addCriterion("authorization_code =", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeNotEqualTo(String value) {
            addCriterion("authorization_code <>", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeGreaterThan(String value) {
            addCriterion("authorization_code >", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("authorization_code >=", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeLessThan(String value) {
            addCriterion("authorization_code <", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeLessThanOrEqualTo(String value) {
            addCriterion("authorization_code <=", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeLike(String value) {
            addCriterion("authorization_code like", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeNotLike(String value) {
            addCriterion("authorization_code not like", value, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeIn(List<String> values) {
            addCriterion("authorization_code in", values, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeNotIn(List<String> values) {
            addCriterion("authorization_code not in", values, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeBetween(String value1, String value2) {
            addCriterion("authorization_code between", value1, value2, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andAuthorizationCodeNotBetween(String value1, String value2) {
            addCriterion("authorization_code not between", value1, value2, "authorizationCode");
            return (Criteria) this;
        }

        public Criteria andServerTypeIsNull() {
            addCriterion("server_type is null");
            return (Criteria) this;
        }

        public Criteria andServerTypeIsNotNull() {
            addCriterion("server_type is not null");
            return (Criteria) this;
        }

        public Criteria andServerTypeEqualTo(Integer value) {
            addCriterion("server_type =", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeNotEqualTo(Integer value) {
            addCriterion("server_type <>", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeGreaterThan(Integer value) {
            addCriterion("server_type >", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("server_type >=", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeLessThan(Integer value) {
            addCriterion("server_type <", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeLessThanOrEqualTo(Integer value) {
            addCriterion("server_type <=", value, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeIn(List<Integer> values) {
            addCriterion("server_type in", values, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeNotIn(List<Integer> values) {
            addCriterion("server_type not in", values, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeBetween(Integer value1, Integer value2) {
            addCriterion("server_type between", value1, value2, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("server_type not between", value1, value2, "serverType");
            return (Criteria) this;
        }

        public Criteria andServerIpIsNull() {
            addCriterion("server_ip is null");
            return (Criteria) this;
        }

        public Criteria andServerIpIsNotNull() {
            addCriterion("server_ip is not null");
            return (Criteria) this;
        }

        public Criteria andServerIpEqualTo(String value) {
            addCriterion("server_ip =", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpNotEqualTo(String value) {
            addCriterion("server_ip <>", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpGreaterThan(String value) {
            addCriterion("server_ip >", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpGreaterThanOrEqualTo(String value) {
            addCriterion("server_ip >=", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpLessThan(String value) {
            addCriterion("server_ip <", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpLessThanOrEqualTo(String value) {
            addCriterion("server_ip <=", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpLike(String value) {
            addCriterion("server_ip like", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpNotLike(String value) {
            addCriterion("server_ip not like", value, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpIn(List<String> values) {
            addCriterion("server_ip in", values, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpNotIn(List<String> values) {
            addCriterion("server_ip not in", values, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpBetween(String value1, String value2) {
            addCriterion("server_ip between", value1, value2, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerIpNotBetween(String value1, String value2) {
            addCriterion("server_ip not between", value1, value2, "serverIp");
            return (Criteria) this;
        }

        public Criteria andServerPortIsNull() {
            addCriterion("server_port is null");
            return (Criteria) this;
        }

        public Criteria andServerPortIsNotNull() {
            addCriterion("server_port is not null");
            return (Criteria) this;
        }

        public Criteria andServerPortEqualTo(Integer value) {
            addCriterion("server_port =", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortNotEqualTo(Integer value) {
            addCriterion("server_port <>", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortGreaterThan(Integer value) {
            addCriterion("server_port >", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortGreaterThanOrEqualTo(Integer value) {
            addCriterion("server_port >=", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortLessThan(Integer value) {
            addCriterion("server_port <", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortLessThanOrEqualTo(Integer value) {
            addCriterion("server_port <=", value, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortIn(List<Integer> values) {
            addCriterion("server_port in", values, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortNotIn(List<Integer> values) {
            addCriterion("server_port not in", values, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortBetween(Integer value1, Integer value2) {
            addCriterion("server_port between", value1, value2, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerPortNotBetween(Integer value1, Integer value2) {
            addCriterion("server_port not between", value1, value2, "serverPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailIsNull() {
            addCriterion("server_email is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailIsNotNull() {
            addCriterion("server_email is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailEqualTo(String value) {
            addCriterion("server_email =", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailNotEqualTo(String value) {
            addCriterion("server_email <>", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailGreaterThan(String value) {
            addCriterion("server_email >", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailGreaterThanOrEqualTo(String value) {
            addCriterion("server_email >=", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailLessThan(String value) {
            addCriterion("server_email <", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailLessThanOrEqualTo(String value) {
            addCriterion("server_email <=", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailLike(String value) {
            addCriterion("server_email like", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailNotLike(String value) {
            addCriterion("server_email not like", value, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailIn(List<String> values) {
            addCriterion("server_email in", values, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailNotIn(List<String> values) {
            addCriterion("server_email not in", values, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailBetween(String value1, String value2) {
            addCriterion("server_email between", value1, value2, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailNotBetween(String value1, String value2) {
            addCriterion("server_email not between", value1, value2, "serverEmail");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthIsNull() {
            addCriterion("server_email_auth is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthIsNotNull() {
            addCriterion("server_email_auth is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthEqualTo(String value) {
            addCriterion("server_email_auth =", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthNotEqualTo(String value) {
            addCriterion("server_email_auth <>", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthGreaterThan(String value) {
            addCriterion("server_email_auth >", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthGreaterThanOrEqualTo(String value) {
            addCriterion("server_email_auth >=", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthLessThan(String value) {
            addCriterion("server_email_auth <", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthLessThanOrEqualTo(String value) {
            addCriterion("server_email_auth <=", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthLike(String value) {
            addCriterion("server_email_auth like", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthNotLike(String value) {
            addCriterion("server_email_auth not like", value, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthIn(List<String> values) {
            addCriterion("server_email_auth in", values, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthNotIn(List<String> values) {
            addCriterion("server_email_auth not in", values, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthBetween(String value1, String value2) {
            addCriterion("server_email_auth between", value1, value2, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailAuthNotBetween(String value1, String value2) {
            addCriterion("server_email_auth not between", value1, value2, "serverEmailAuth");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameIsNull() {
            addCriterion("server_email_name is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameIsNotNull() {
            addCriterion("server_email_name is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameEqualTo(String value) {
            addCriterion("server_email_name =", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameNotEqualTo(String value) {
            addCriterion("server_email_name <>", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameGreaterThan(String value) {
            addCriterion("server_email_name >", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameGreaterThanOrEqualTo(String value) {
            addCriterion("server_email_name >=", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameLessThan(String value) {
            addCriterion("server_email_name <", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameLessThanOrEqualTo(String value) {
            addCriterion("server_email_name <=", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameLike(String value) {
            addCriterion("server_email_name like", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameNotLike(String value) {
            addCriterion("server_email_name not like", value, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameIn(List<String> values) {
            addCriterion("server_email_name in", values, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameNotIn(List<String> values) {
            addCriterion("server_email_name not in", values, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameBetween(String value1, String value2) {
            addCriterion("server_email_name between", value1, value2, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailNameNotBetween(String value1, String value2) {
            addCriterion("server_email_name not between", value1, value2, "serverEmailName");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeIsNull() {
            addCriterion("server_email_type is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeIsNotNull() {
            addCriterion("server_email_type is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeEqualTo(String value) {
            addCriterion("server_email_type =", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeNotEqualTo(String value) {
            addCriterion("server_email_type <>", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeGreaterThan(String value) {
            addCriterion("server_email_type >", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeGreaterThanOrEqualTo(String value) {
            addCriterion("server_email_type >=", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeLessThan(String value) {
            addCriterion("server_email_type <", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeLessThanOrEqualTo(String value) {
            addCriterion("server_email_type <=", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeLike(String value) {
            addCriterion("server_email_type like", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeNotLike(String value) {
            addCriterion("server_email_type not like", value, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeIn(List<String> values) {
            addCriterion("server_email_type in", values, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeNotIn(List<String> values) {
            addCriterion("server_email_type not in", values, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeBetween(String value1, String value2) {
            addCriterion("server_email_type between", value1, value2, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailTypeNotBetween(String value1, String value2) {
            addCriterion("server_email_type not between", value1, value2, "serverEmailType");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostIsNull() {
            addCriterion("server_email_host is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostIsNotNull() {
            addCriterion("server_email_host is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostEqualTo(String value) {
            addCriterion("server_email_host =", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostNotEqualTo(String value) {
            addCriterion("server_email_host <>", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostGreaterThan(String value) {
            addCriterion("server_email_host >", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostGreaterThanOrEqualTo(String value) {
            addCriterion("server_email_host >=", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostLessThan(String value) {
            addCriterion("server_email_host <", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostLessThanOrEqualTo(String value) {
            addCriterion("server_email_host <=", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostLike(String value) {
            addCriterion("server_email_host like", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostNotLike(String value) {
            addCriterion("server_email_host not like", value, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostIn(List<String> values) {
            addCriterion("server_email_host in", values, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostNotIn(List<String> values) {
            addCriterion("server_email_host not in", values, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostBetween(String value1, String value2) {
            addCriterion("server_email_host between", value1, value2, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailHostNotBetween(String value1, String value2) {
            addCriterion("server_email_host not between", value1, value2, "serverEmailHost");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortIsNull() {
            addCriterion("server_email_port is null");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortIsNotNull() {
            addCriterion("server_email_port is not null");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortEqualTo(Integer value) {
            addCriterion("server_email_port =", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortNotEqualTo(Integer value) {
            addCriterion("server_email_port <>", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortGreaterThan(Integer value) {
            addCriterion("server_email_port >", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortGreaterThanOrEqualTo(Integer value) {
            addCriterion("server_email_port >=", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortLessThan(Integer value) {
            addCriterion("server_email_port <", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortLessThanOrEqualTo(Integer value) {
            addCriterion("server_email_port <=", value, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortIn(List<Integer> values) {
            addCriterion("server_email_port in", values, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortNotIn(List<Integer> values) {
            addCriterion("server_email_port not in", values, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortBetween(Integer value1, Integer value2) {
            addCriterion("server_email_port between", value1, value2, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andServerEmailPortNotBetween(Integer value1, Integer value2) {
            addCriterion("server_email_port not between", value1, value2, "serverEmailPort");
            return (Criteria) this;
        }

        public Criteria andItemNameIsNull() {
            addCriterion("item_name is null");
            return (Criteria) this;
        }

        public Criteria andItemNameIsNotNull() {
            addCriterion("item_name is not null");
            return (Criteria) this;
        }

        public Criteria andItemNameEqualTo(String value) {
            addCriterion("item_name =", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotEqualTo(String value) {
            addCriterion("item_name <>", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameGreaterThan(String value) {
            addCriterion("item_name >", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameGreaterThanOrEqualTo(String value) {
            addCriterion("item_name >=", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLessThan(String value) {
            addCriterion("item_name <", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLessThanOrEqualTo(String value) {
            addCriterion("item_name <=", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameLike(String value) {
            addCriterion("item_name like", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotLike(String value) {
            addCriterion("item_name not like", value, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameIn(List<String> values) {
            addCriterion("item_name in", values, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotIn(List<String> values) {
            addCriterion("item_name not in", values, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameBetween(String value1, String value2) {
            addCriterion("item_name between", value1, value2, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemNameNotBetween(String value1, String value2) {
            addCriterion("item_name not between", value1, value2, "itemName");
            return (Criteria) this;
        }

        public Criteria andItemCodeIsNull() {
            addCriterion("item_code is null");
            return (Criteria) this;
        }

        public Criteria andItemCodeIsNotNull() {
            addCriterion("item_code is not null");
            return (Criteria) this;
        }

        public Criteria andItemCodeEqualTo(String value) {
            addCriterion("item_code =", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotEqualTo(String value) {
            addCriterion("item_code <>", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeGreaterThan(String value) {
            addCriterion("item_code >", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeGreaterThanOrEqualTo(String value) {
            addCriterion("item_code >=", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLessThan(String value) {
            addCriterion("item_code <", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLessThanOrEqualTo(String value) {
            addCriterion("item_code <=", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeLike(String value) {
            addCriterion("item_code like", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotLike(String value) {
            addCriterion("item_code not like", value, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeIn(List<String> values) {
            addCriterion("item_code in", values, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotIn(List<String> values) {
            addCriterion("item_code not in", values, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeBetween(String value1, String value2) {
            addCriterion("item_code between", value1, value2, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemCodeNotBetween(String value1, String value2) {
            addCriterion("item_code not between", value1, value2, "itemCode");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateIsNull() {
            addCriterion("item_tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateIsNotNull() {
            addCriterion("item_tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateEqualTo(Double value) {
            addCriterion("item_tax_rate =", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateNotEqualTo(Double value) {
            addCriterion("item_tax_rate <>", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateGreaterThan(Double value) {
            addCriterion("item_tax_rate >", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateGreaterThanOrEqualTo(Double value) {
            addCriterion("item_tax_rate >=", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateLessThan(Double value) {
            addCriterion("item_tax_rate <", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateLessThanOrEqualTo(Double value) {
            addCriterion("item_tax_rate <=", value, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateIn(List<Double> values) {
            addCriterion("item_tax_rate in", values, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateNotIn(List<Double> values) {
            addCriterion("item_tax_rate not in", values, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateBetween(Double value1, Double value2) {
            addCriterion("item_tax_rate between", value1, value2, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andItemTaxRateNotBetween(Double value1, Double value2) {
            addCriterion("item_tax_rate not between", value1, value2, "itemTaxRate");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchIsNull() {
            addCriterion("wx_card_pack_switch is null");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchIsNotNull() {
            addCriterion("wx_card_pack_switch is not null");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchEqualTo(Integer value) {
            addCriterion("wx_card_pack_switch =", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchNotEqualTo(Integer value) {
            addCriterion("wx_card_pack_switch <>", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchGreaterThan(Integer value) {
            addCriterion("wx_card_pack_switch >", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchGreaterThanOrEqualTo(Integer value) {
            addCriterion("wx_card_pack_switch >=", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchLessThan(Integer value) {
            addCriterion("wx_card_pack_switch <", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchLessThanOrEqualTo(Integer value) {
            addCriterion("wx_card_pack_switch <=", value, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchIn(List<Integer> values) {
            addCriterion("wx_card_pack_switch in", values, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchNotIn(List<Integer> values) {
            addCriterion("wx_card_pack_switch not in", values, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchBetween(Integer value1, Integer value2) {
            addCriterion("wx_card_pack_switch between", value1, value2, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andWxCardPackSwitchNotBetween(Integer value1, Integer value2) {
            addCriterion("wx_card_pack_switch not between", value1, value2, "wxCardPackSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchIsNull() {
            addCriterion("message_push_switch is null");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchIsNotNull() {
            addCriterion("message_push_switch is not null");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchEqualTo(Integer value) {
            addCriterion("message_push_switch =", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchNotEqualTo(Integer value) {
            addCriterion("message_push_switch <>", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchGreaterThan(Integer value) {
            addCriterion("message_push_switch >", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchGreaterThanOrEqualTo(Integer value) {
            addCriterion("message_push_switch >=", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchLessThan(Integer value) {
            addCriterion("message_push_switch <", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchLessThanOrEqualTo(Integer value) {
            addCriterion("message_push_switch <=", value, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchIn(List<Integer> values) {
            addCriterion("message_push_switch in", values, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchNotIn(List<Integer> values) {
            addCriterion("message_push_switch not in", values, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchBetween(Integer value1, Integer value2) {
            addCriterion("message_push_switch between", value1, value2, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andMessagePushSwitchNotBetween(Integer value1, Integer value2) {
            addCriterion("message_push_switch not between", value1, value2, "messagePushSwitch");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlIsNull() {
            addCriterion("wsdl_url is null");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlIsNotNull() {
            addCriterion("wsdl_url is not null");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlEqualTo(String value) {
            addCriterion("wsdl_url =", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlNotEqualTo(String value) {
            addCriterion("wsdl_url <>", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlGreaterThan(String value) {
            addCriterion("wsdl_url >", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlGreaterThanOrEqualTo(String value) {
            addCriterion("wsdl_url >=", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlLessThan(String value) {
            addCriterion("wsdl_url <", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlLessThanOrEqualTo(String value) {
            addCriterion("wsdl_url <=", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlLike(String value) {
            addCriterion("wsdl_url like", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlNotLike(String value) {
            addCriterion("wsdl_url not like", value, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlIn(List<String> values) {
            addCriterion("wsdl_url in", values, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlNotIn(List<String> values) {
            addCriterion("wsdl_url not in", values, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlBetween(String value1, String value2) {
            addCriterion("wsdl_url between", value1, value2, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andWsdlUrlNotBetween(String value1, String value2) {
            addCriterion("wsdl_url not between", value1, value2, "wsdlUrl");
            return (Criteria) this;
        }

        public Criteria andDrawerIsNull() {
            addCriterion("drawer is null");
            return (Criteria) this;
        }

        public Criteria andDrawerIsNotNull() {
            addCriterion("drawer is not null");
            return (Criteria) this;
        }

        public Criteria andDrawerEqualTo(String value) {
            addCriterion("drawer =", value, "drawer");
            return (Criteria) this;
        }

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

        public Criteria andDrawerGreaterThan(String value) {
            addCriterion("drawer >", value, "drawer");
            return (Criteria) this;
        }

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

        public Criteria andDrawerLessThan(String value) {
            addCriterion("drawer <", value, "drawer");
            return (Criteria) this;
        }

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

        public Criteria andDrawerLike(String value) {
            addCriterion("drawer like", value, "drawer");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andCheckerIsNull() {
            addCriterion("checker is null");
            return (Criteria) this;
        }

        public Criteria andCheckerIsNotNull() {
            addCriterion("checker is not null");
            return (Criteria) this;
        }

        public Criteria andCheckerEqualTo(String value) {
            addCriterion("checker =", value, "checker");
            return (Criteria) this;
        }

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

        public Criteria andCheckerGreaterThan(String value) {
            addCriterion("checker >", value, "checker");
            return (Criteria) this;
        }

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

        public Criteria andCheckerLessThan(String value) {
            addCriterion("checker <", value, "checker");
            return (Criteria) this;
        }

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

        public Criteria andCheckerLike(String value) {
            addCriterion("checker like", value, "checker");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andPryeeIsNull() {
            addCriterion("pryee is null");
            return (Criteria) this;
        }

        public Criteria andPryeeIsNotNull() {
            addCriterion("pryee is not null");
            return (Criteria) this;
        }

        public Criteria andPryeeEqualTo(String value) {
            addCriterion("pryee =", value, "pryee");
            return (Criteria) this;
        }

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

        public Criteria andPryeeGreaterThan(String value) {
            addCriterion("pryee >", value, "pryee");
            return (Criteria) this;
        }

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

        public Criteria andPryeeLessThan(String value) {
            addCriterion("pryee <", value, "pryee");
            return (Criteria) this;
        }

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

        public Criteria andPryeeLike(String value) {
            addCriterion("pryee like", value, "pryee");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andDataStateIsNull() {
            addCriterion("data_state is null");
            return (Criteria) this;
        }

        public Criteria andDataStateIsNotNull() {
            addCriterion("data_state is not null");
            return (Criteria) this;
        }

        public Criteria andDataStateEqualTo(Integer value) {
            addCriterion("data_state =", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotEqualTo(Integer value) {
            addCriterion("data_state <>", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThan(Integer value) {
            addCriterion("data_state >", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_state >=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThan(Integer value) {
            addCriterion("data_state <", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateLessThanOrEqualTo(Integer value) {
            addCriterion("data_state <=", value, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateIn(List<Integer> values) {
            addCriterion("data_state in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotIn(List<Integer> values) {
            addCriterion("data_state not in", values, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateBetween(Integer value1, Integer value2) {
            addCriterion("data_state between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andDataStateNotBetween(Integer value1, Integer value2) {
            addCriterion("data_state not between", value1, value2, "dataState");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidIsNull() {
            addCriterion("create_empid is null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidIsNotNull() {
            addCriterion("create_empid is not null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidEqualTo(String value) {
            addCriterion("create_empid =", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotEqualTo(String value) {
            addCriterion("create_empid <>", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidGreaterThan(String value) {
            addCriterion("create_empid >", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidGreaterThanOrEqualTo(String value) {
            addCriterion("create_empid >=", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidLessThan(String value) {
            addCriterion("create_empid <", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidLessThanOrEqualTo(String value) {
            addCriterion("create_empid <=", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidLike(String value) {
            addCriterion("create_empid like", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotLike(String value) {
            addCriterion("create_empid not like", value, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidIn(List<String> values) {
            addCriterion("create_empid in", values, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotIn(List<String> values) {
            addCriterion("create_empid not in", values, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidBetween(String value1, String value2) {
            addCriterion("create_empid between", value1, value2, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateEmpidNotBetween(String value1, String value2) {
            addCriterion("create_empid not between", value1, value2, "createEmpid");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidIsNull() {
            addCriterion("modfiy_empid is null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidIsNotNull() {
            addCriterion("modfiy_empid is not null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidEqualTo(String value) {
            addCriterion("modfiy_empid =", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotEqualTo(String value) {
            addCriterion("modfiy_empid <>", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidGreaterThan(String value) {
            addCriterion("modfiy_empid >", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidGreaterThanOrEqualTo(String value) {
            addCriterion("modfiy_empid >=", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidLessThan(String value) {
            addCriterion("modfiy_empid <", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidLessThanOrEqualTo(String value) {
            addCriterion("modfiy_empid <=", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidLike(String value) {
            addCriterion("modfiy_empid like", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotLike(String value) {
            addCriterion("modfiy_empid not like", value, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidIn(List<String> values) {
            addCriterion("modfiy_empid in", values, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotIn(List<String> values) {
            addCriterion("modfiy_empid not in", values, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidBetween(String value1, String value2) {
            addCriterion("modfiy_empid between", value1, value2, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpidNotBetween(String value1, String value2) {
            addCriterion("modfiy_empid not between", value1, value2, "modfiyEmpid");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIsNull() {
            addCriterion("modfiy_date is null");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIsNotNull() {
            addCriterion("modfiy_date is not null");
            return (Criteria) this;
        }

        public Criteria andModfiyDateEqualTo(Date value) {
            addCriterion("modfiy_date =", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotEqualTo(Date value) {
            addCriterion("modfiy_date <>", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateGreaterThan(Date value) {
            addCriterion("modfiy_date >", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateGreaterThanOrEqualTo(Date value) {
            addCriterion("modfiy_date >=", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateLessThan(Date value) {
            addCriterion("modfiy_date <", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateLessThanOrEqualTo(Date value) {
            addCriterion("modfiy_date <=", value, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateIn(List<Date> values) {
            addCriterion("modfiy_date in", values, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotIn(List<Date> values) {
            addCriterion("modfiy_date not in", values, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateBetween(Date value1, Date value2) {
            addCriterion("modfiy_date between", value1, value2, "modfiyDate");
            return (Criteria) this;
        }

        public Criteria andModfiyDateNotBetween(Date value1, Date value2) {
            addCriterion("modfiy_date not between", value1, value2, "modfiyDate");
            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 andOrgIdIsNull() {
            addCriterion("org_id is null");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNotNull() {
            addCriterion("org_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrgIdEqualTo(Long value) {
            addCriterion("org_id =", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotEqualTo(Long value) {
            addCriterion("org_id <>", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThan(Long value) {
            addCriterion("org_id >", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThanOrEqualTo(Long value) {
            addCriterion("org_id >=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThan(Long value) {
            addCriterion("org_id <", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThanOrEqualTo(Long value) {
            addCriterion("org_id <=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdIn(List<Long> values) {
            addCriterion("org_id in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotIn(List<Long> values) {
            addCriterion("org_id not in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdBetween(Long value1, Long value2) {
            addCriterion("org_id between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotBetween(Long value1, Long value2) {
            addCriterion("org_id not between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIsNull() {
            addCriterion("sale_type is null");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIsNotNull() {
            addCriterion("sale_type is not null");
            return (Criteria) this;
        }

        public Criteria andSaleTypeEqualTo(Integer value) {
            addCriterion("sale_type =", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotEqualTo(Integer value) {
            addCriterion("sale_type <>", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeGreaterThan(Integer value) {
            addCriterion("sale_type >", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("sale_type >=", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeLessThan(Integer value) {
            addCriterion("sale_type <", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeLessThanOrEqualTo(Integer value) {
            addCriterion("sale_type <=", value, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeIn(List<Integer> values) {
            addCriterion("sale_type in", values, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotIn(List<Integer> values) {
            addCriterion("sale_type not in", values, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeBetween(Integer value1, Integer value2) {
            addCriterion("sale_type between", value1, value2, "saleType");
            return (Criteria) this;
        }

        public Criteria andSaleTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("sale_type not between", value1, value2, "saleType");
            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);
        }
    }
}