package com.zteits.pay.domain;

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

public class TdCCouponPersonExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TdCCouponPersonExample() {
        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 andCardNoIsNull() {
            addCriterion("card_no is null");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNotNull() {
            addCriterion("card_no is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoEqualTo(String value) {
            addCriterion("card_no =", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotEqualTo(String value) {
            addCriterion("card_no <>", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThan(String value) {
            addCriterion("card_no >", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThanOrEqualTo(String value) {
            addCriterion("card_no >=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThan(String value) {
            addCriterion("card_no <", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThanOrEqualTo(String value) {
            addCriterion("card_no <=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLike(String value) {
            addCriterion("card_no like", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotLike(String value) {
            addCriterion("card_no not like", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoIn(List<String> values) {
            addCriterion("card_no in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotIn(List<String> values) {
            addCriterion("card_no not in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoBetween(String value1, String value2) {
            addCriterion("card_no between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotBetween(String value1, String value2) {
            addCriterion("card_no not between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeIsNull() {
            addCriterion("acquire_type is null");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeIsNotNull() {
            addCriterion("acquire_type is not null");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeEqualTo(Integer value) {
            addCriterion("acquire_type =", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeNotEqualTo(Integer value) {
            addCriterion("acquire_type <>", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeGreaterThan(Integer value) {
            addCriterion("acquire_type >", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("acquire_type >=", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeLessThan(Integer value) {
            addCriterion("acquire_type <", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeLessThanOrEqualTo(Integer value) {
            addCriterion("acquire_type <=", value, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeIn(List<Integer> values) {
            addCriterion("acquire_type in", values, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeNotIn(List<Integer> values) {
            addCriterion("acquire_type not in", values, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeBetween(Integer value1, Integer value2) {
            addCriterion("acquire_type between", value1, value2, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("acquire_type not between", value1, value2, "acquireType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeIsNull() {
            addCriterion("acquire_detail_type is null");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeIsNotNull() {
            addCriterion("acquire_detail_type is not null");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeEqualTo(Integer value) {
            addCriterion("acquire_detail_type =", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeNotEqualTo(Integer value) {
            addCriterion("acquire_detail_type <>", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeGreaterThan(Integer value) {
            addCriterion("acquire_detail_type >", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("acquire_detail_type >=", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeLessThan(Integer value) {
            addCriterion("acquire_detail_type <", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeLessThanOrEqualTo(Integer value) {
            addCriterion("acquire_detail_type <=", value, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeIn(List<Integer> values) {
            addCriterion("acquire_detail_type in", values, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeNotIn(List<Integer> values) {
            addCriterion("acquire_detail_type not in", values, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeBetween(Integer value1, Integer value2) {
            addCriterion("acquire_detail_type between", value1, value2, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireDetailTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("acquire_detail_type not between", value1, value2, "acquireDetailType");
            return (Criteria) this;
        }

        public Criteria andAcquireNoIsNull() {
            addCriterion("acquire_no is null");
            return (Criteria) this;
        }

        public Criteria andAcquireNoIsNotNull() {
            addCriterion("acquire_no is not null");
            return (Criteria) this;
        }

        public Criteria andAcquireNoEqualTo(String value) {
            addCriterion("acquire_no =", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoNotEqualTo(String value) {
            addCriterion("acquire_no <>", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoGreaterThan(String value) {
            addCriterion("acquire_no >", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoGreaterThanOrEqualTo(String value) {
            addCriterion("acquire_no >=", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoLessThan(String value) {
            addCriterion("acquire_no <", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoLessThanOrEqualTo(String value) {
            addCriterion("acquire_no <=", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoLike(String value) {
            addCriterion("acquire_no like", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoNotLike(String value) {
            addCriterion("acquire_no not like", value, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoIn(List<String> values) {
            addCriterion("acquire_no in", values, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoNotIn(List<String> values) {
            addCriterion("acquire_no not in", values, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoBetween(String value1, String value2) {
            addCriterion("acquire_no between", value1, value2, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andAcquireNoNotBetween(String value1, String value2) {
            addCriterion("acquire_no not between", value1, value2, "acquireNo");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNull() {
            addCriterion("cust_id is null");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNotNull() {
            addCriterion("cust_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustIdEqualTo(String value) {
            addCriterion("cust_id =", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotEqualTo(String value) {
            addCriterion("cust_id <>", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThan(String value) {
            addCriterion("cust_id >", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThanOrEqualTo(String value) {
            addCriterion("cust_id >=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThan(String value) {
            addCriterion("cust_id <", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThanOrEqualTo(String value) {
            addCriterion("cust_id <=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLike(String value) {
            addCriterion("cust_id like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotLike(String value) {
            addCriterion("cust_id not like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdIn(List<String> values) {
            addCriterion("cust_id in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotIn(List<String> values) {
            addCriterion("cust_id not in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdBetween(String value1, String value2) {
            addCriterion("cust_id between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotBetween(String value1, String value2) {
            addCriterion("cust_id not between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCarNumIsNull() {
            addCriterion("car_num is null");
            return (Criteria) this;
        }

        public Criteria andCarNumIsNotNull() {
            addCriterion("car_num is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumEqualTo(String value) {
            addCriterion("car_num =", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotEqualTo(String value) {
            addCriterion("car_num <>", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumGreaterThan(String value) {
            addCriterion("car_num >", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumGreaterThanOrEqualTo(String value) {
            addCriterion("car_num >=", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumLessThan(String value) {
            addCriterion("car_num <", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumLessThanOrEqualTo(String value) {
            addCriterion("car_num <=", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumLike(String value) {
            addCriterion("car_num like", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotLike(String value) {
            addCriterion("car_num not like", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumIn(List<String> values) {
            addCriterion("car_num in", values, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotIn(List<String> values) {
            addCriterion("car_num not in", values, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumBetween(String value1, String value2) {
            addCriterion("car_num between", value1, value2, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotBetween(String value1, String value2) {
            addCriterion("car_num not between", value1, value2, "carNum");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIsNull() {
            addCriterion("begin_time is null");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIsNotNull() {
            addCriterion("begin_time is not null");
            return (Criteria) this;
        }

        public Criteria andBeginTimeEqualTo(Date value) {
            addCriterion("begin_time =", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotEqualTo(Date value) {
            addCriterion("begin_time <>", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeGreaterThan(Date value) {
            addCriterion("begin_time >", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("begin_time >=", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeLessThan(Date value) {
            addCriterion("begin_time <", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeLessThanOrEqualTo(Date value) {
            addCriterion("begin_time <=", value, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeIn(List<Date> values) {
            addCriterion("begin_time in", values, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotIn(List<Date> values) {
            addCriterion("begin_time not in", values, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeBetween(Date value1, Date value2) {
            addCriterion("begin_time between", value1, value2, "beginTime");
            return (Criteria) this;
        }

        public Criteria andBeginTimeNotBetween(Date value1, Date value2) {
            addCriterion("begin_time not between", value1, value2, "beginTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andIsUesedIsNull() {
            addCriterion("is_uesed is null");
            return (Criteria) this;
        }

        public Criteria andIsUesedIsNotNull() {
            addCriterion("is_uesed is not null");
            return (Criteria) this;
        }

        public Criteria andIsUesedEqualTo(Integer value) {
            addCriterion("is_uesed =", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedNotEqualTo(Integer value) {
            addCriterion("is_uesed <>", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedGreaterThan(Integer value) {
            addCriterion("is_uesed >", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_uesed >=", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedLessThan(Integer value) {
            addCriterion("is_uesed <", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedLessThanOrEqualTo(Integer value) {
            addCriterion("is_uesed <=", value, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedIn(List<Integer> values) {
            addCriterion("is_uesed in", values, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedNotIn(List<Integer> values) {
            addCriterion("is_uesed not in", values, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedBetween(Integer value1, Integer value2) {
            addCriterion("is_uesed between", value1, value2, "isUesed");
            return (Criteria) this;
        }

        public Criteria andIsUesedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_uesed not between", value1, value2, "isUesed");
            return (Criteria) this;
        }

        public Criteria andUsedTimeIsNull() {
            addCriterion("used_time is null");
            return (Criteria) this;
        }

        public Criteria andUsedTimeIsNotNull() {
            addCriterion("used_time is not null");
            return (Criteria) this;
        }

        public Criteria andUsedTimeEqualTo(Date value) {
            addCriterion("used_time =", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeNotEqualTo(Date value) {
            addCriterion("used_time <>", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeGreaterThan(Date value) {
            addCriterion("used_time >", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("used_time >=", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeLessThan(Date value) {
            addCriterion("used_time <", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeLessThanOrEqualTo(Date value) {
            addCriterion("used_time <=", value, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeIn(List<Date> values) {
            addCriterion("used_time in", values, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeNotIn(List<Date> values) {
            addCriterion("used_time not in", values, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeBetween(Date value1, Date value2) {
            addCriterion("used_time between", value1, value2, "usedTime");
            return (Criteria) this;
        }

        public Criteria andUsedTimeNotBetween(Date value1, Date value2) {
            addCriterion("used_time not between", value1, value2, "usedTime");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdIsNull() {
            addCriterion("pay_order_id is null");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdIsNotNull() {
            addCriterion("pay_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdEqualTo(String value) {
            addCriterion("pay_order_id =", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdNotEqualTo(String value) {
            addCriterion("pay_order_id <>", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdGreaterThan(String value) {
            addCriterion("pay_order_id >", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("pay_order_id >=", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdLessThan(String value) {
            addCriterion("pay_order_id <", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdLessThanOrEqualTo(String value) {
            addCriterion("pay_order_id <=", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdLike(String value) {
            addCriterion("pay_order_id like", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdNotLike(String value) {
            addCriterion("pay_order_id not like", value, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdIn(List<String> values) {
            addCriterion("pay_order_id in", values, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdNotIn(List<String> values) {
            addCriterion("pay_order_id not in", values, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdBetween(String value1, String value2) {
            addCriterion("pay_order_id between", value1, value2, "payOrderId");
            return (Criteria) this;
        }

        public Criteria andPayOrderIdNotBetween(String value1, String value2) {
            addCriterion("pay_order_id not between", value1, value2, "payOrderId");
            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 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 andOrgNameIsNull() {
            addCriterion("org_name is null");
            return (Criteria) this;
        }

        public Criteria andOrgNameIsNotNull() {
            addCriterion("org_name is not null");
            return (Criteria) this;
        }

        public Criteria andOrgNameEqualTo(String value) {
            addCriterion("org_name =", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotEqualTo(String value) {
            addCriterion("org_name <>", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThan(String value) {
            addCriterion("org_name >", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameGreaterThanOrEqualTo(String value) {
            addCriterion("org_name >=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThan(String value) {
            addCriterion("org_name <", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLessThanOrEqualTo(String value) {
            addCriterion("org_name <=", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameLike(String value) {
            addCriterion("org_name like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotLike(String value) {
            addCriterion("org_name not like", value, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameIn(List<String> values) {
            addCriterion("org_name in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotIn(List<String> values) {
            addCriterion("org_name not in", values, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameBetween(String value1, String value2) {
            addCriterion("org_name between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOrgNameNotBetween(String value1, String value2) {
            addCriterion("org_name not between", value1, value2, "orgName");
            return (Criteria) this;
        }

        public Criteria andOwenerIsNull() {
            addCriterion("owener is null");
            return (Criteria) this;
        }

        public Criteria andOwenerIsNotNull() {
            addCriterion("owener is not null");
            return (Criteria) this;
        }

        public Criteria andOwenerEqualTo(String value) {
            addCriterion("owener =", value, "owener");
            return (Criteria) this;
        }

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

        public Criteria andOwenerGreaterThan(String value) {
            addCriterion("owener >", value, "owener");
            return (Criteria) this;
        }

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

        public Criteria andOwenerLessThan(String value) {
            addCriterion("owener <", value, "owener");
            return (Criteria) this;
        }

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

        public Criteria andOwenerLike(String value) {
            addCriterion("owener like", value, "owener");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andOwenerNameIsNull() {
            addCriterion("owener_name is null");
            return (Criteria) this;
        }

        public Criteria andOwenerNameIsNotNull() {
            addCriterion("owener_name is not null");
            return (Criteria) this;
        }

        public Criteria andOwenerNameEqualTo(String value) {
            addCriterion("owener_name =", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameNotEqualTo(String value) {
            addCriterion("owener_name <>", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameGreaterThan(String value) {
            addCriterion("owener_name >", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameGreaterThanOrEqualTo(String value) {
            addCriterion("owener_name >=", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameLessThan(String value) {
            addCriterion("owener_name <", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameLessThanOrEqualTo(String value) {
            addCriterion("owener_name <=", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameLike(String value) {
            addCriterion("owener_name like", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameNotLike(String value) {
            addCriterion("owener_name not like", value, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameIn(List<String> values) {
            addCriterion("owener_name in", values, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameNotIn(List<String> values) {
            addCriterion("owener_name not in", values, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameBetween(String value1, String value2) {
            addCriterion("owener_name between", value1, value2, "owenerName");
            return (Criteria) this;
        }

        public Criteria andOwenerNameNotBetween(String value1, String value2) {
            addCriterion("owener_name not between", value1, value2, "owenerName");
            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);
        }
    }
}