package com.zteits.business.domain;

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

public class OrderBusinessCouponSubExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderBusinessCouponSubExample() {
        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 andOrderSubNoIsNull() {
            addCriterion("order_sub_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoIsNotNull() {
            addCriterion("order_sub_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoEqualTo(String value) {
            addCriterion("order_sub_no =", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoNotEqualTo(String value) {
            addCriterion("order_sub_no <>", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoGreaterThan(String value) {
            addCriterion("order_sub_no >", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_sub_no >=", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoLessThan(String value) {
            addCriterion("order_sub_no <", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoLessThanOrEqualTo(String value) {
            addCriterion("order_sub_no <=", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoLike(String value) {
            addCriterion("order_sub_no like", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoNotLike(String value) {
            addCriterion("order_sub_no not like", value, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoIn(List<String> values) {
            addCriterion("order_sub_no in", values, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoNotIn(List<String> values) {
            addCriterion("order_sub_no not in", values, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoBetween(String value1, String value2) {
            addCriterion("order_sub_no between", value1, value2, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderSubNoNotBetween(String value1, String value2) {
            addCriterion("order_sub_no not between", value1, value2, "orderSubNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoIsNull() {
            addCriterion("card_rule_no is null");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoIsNotNull() {
            addCriterion("card_rule_no is not null");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoEqualTo(String value) {
            addCriterion("card_rule_no =", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoNotEqualTo(String value) {
            addCriterion("card_rule_no <>", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoGreaterThan(String value) {
            addCriterion("card_rule_no >", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoGreaterThanOrEqualTo(String value) {
            addCriterion("card_rule_no >=", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoLessThan(String value) {
            addCriterion("card_rule_no <", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoLessThanOrEqualTo(String value) {
            addCriterion("card_rule_no <=", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoLike(String value) {
            addCriterion("card_rule_no like", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoNotLike(String value) {
            addCriterion("card_rule_no not like", value, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoIn(List<String> values) {
            addCriterion("card_rule_no in", values, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoNotIn(List<String> values) {
            addCriterion("card_rule_no not in", values, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoBetween(String value1, String value2) {
            addCriterion("card_rule_no between", value1, value2, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNoNotBetween(String value1, String value2) {
            addCriterion("card_rule_no not between", value1, value2, "cardRuleNo");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameIsNull() {
            addCriterion("card_rule_name is null");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameIsNotNull() {
            addCriterion("card_rule_name is not null");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameEqualTo(String value) {
            addCriterion("card_rule_name =", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameNotEqualTo(String value) {
            addCriterion("card_rule_name <>", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameGreaterThan(String value) {
            addCriterion("card_rule_name >", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameGreaterThanOrEqualTo(String value) {
            addCriterion("card_rule_name >=", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameLessThan(String value) {
            addCriterion("card_rule_name <", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameLessThanOrEqualTo(String value) {
            addCriterion("card_rule_name <=", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameLike(String value) {
            addCriterion("card_rule_name like", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameNotLike(String value) {
            addCriterion("card_rule_name not like", value, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameIn(List<String> values) {
            addCriterion("card_rule_name in", values, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameNotIn(List<String> values) {
            addCriterion("card_rule_name not in", values, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameBetween(String value1, String value2) {
            addCriterion("card_rule_name between", value1, value2, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRuleNameNotBetween(String value1, String value2) {
            addCriterion("card_rule_name not between", value1, value2, "cardRuleName");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoIsNull() {
            addCriterion("card_rel_park_no is null");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoIsNotNull() {
            addCriterion("card_rel_park_no is not null");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoEqualTo(String value) {
            addCriterion("card_rel_park_no =", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoNotEqualTo(String value) {
            addCriterion("card_rel_park_no <>", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoGreaterThan(String value) {
            addCriterion("card_rel_park_no >", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoGreaterThanOrEqualTo(String value) {
            addCriterion("card_rel_park_no >=", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoLessThan(String value) {
            addCriterion("card_rel_park_no <", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoLessThanOrEqualTo(String value) {
            addCriterion("card_rel_park_no <=", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoLike(String value) {
            addCriterion("card_rel_park_no like", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoNotLike(String value) {
            addCriterion("card_rel_park_no not like", value, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoIn(List<String> values) {
            addCriterion("card_rel_park_no in", values, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoNotIn(List<String> values) {
            addCriterion("card_rel_park_no not in", values, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoBetween(String value1, String value2) {
            addCriterion("card_rel_park_no between", value1, value2, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCardRelParkNoNotBetween(String value1, String value2) {
            addCriterion("card_rel_park_no not between", value1, value2, "cardRelParkNo");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNull() {
            addCriterion("car_number is null");
            return (Criteria) this;
        }

        public Criteria andCarNumberIsNotNull() {
            addCriterion("car_number is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumberEqualTo(String value) {
            addCriterion("car_number =", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotEqualTo(String value) {
            addCriterion("car_number <>", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThan(String value) {
            addCriterion("car_number >", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberGreaterThanOrEqualTo(String value) {
            addCriterion("car_number >=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThan(String value) {
            addCriterion("car_number <", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLessThanOrEqualTo(String value) {
            addCriterion("car_number <=", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberLike(String value) {
            addCriterion("car_number like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotLike(String value) {
            addCriterion("car_number not like", value, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberIn(List<String> values) {
            addCriterion("car_number in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotIn(List<String> values) {
            addCriterion("car_number not in", values, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberBetween(String value1, String value2) {
            addCriterion("car_number between", value1, value2, "carNumber");
            return (Criteria) this;
        }

        public Criteria andCarNumberNotBetween(String value1, String value2) {
            addCriterion("car_number not between", value1, value2, "carNumber");
            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 andBuyNumIsNull() {
            addCriterion("buy_num is null");
            return (Criteria) this;
        }

        public Criteria andBuyNumIsNotNull() {
            addCriterion("buy_num is not null");
            return (Criteria) this;
        }

        public Criteria andBuyNumEqualTo(Integer value) {
            addCriterion("buy_num =", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotEqualTo(Integer value) {
            addCriterion("buy_num <>", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumGreaterThan(Integer value) {
            addCriterion("buy_num >", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("buy_num >=", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumLessThan(Integer value) {
            addCriterion("buy_num <", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumLessThanOrEqualTo(Integer value) {
            addCriterion("buy_num <=", value, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumIn(List<Integer> values) {
            addCriterion("buy_num in", values, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotIn(List<Integer> values) {
            addCriterion("buy_num not in", values, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumBetween(Integer value1, Integer value2) {
            addCriterion("buy_num between", value1, value2, "buyNum");
            return (Criteria) this;
        }

        public Criteria andBuyNumNotBetween(Integer value1, Integer value2) {
            addCriterion("buy_num not between", value1, value2, "buyNum");
            return (Criteria) this;
        }

        public Criteria andUnitPriceIsNull() {
            addCriterion("unit_price is null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceIsNotNull() {
            addCriterion("unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceEqualTo(Integer value) {
            addCriterion("unit_price =", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceNotEqualTo(Integer value) {
            addCriterion("unit_price <>", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceGreaterThan(Integer value) {
            addCriterion("unit_price >", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("unit_price >=", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceLessThan(Integer value) {
            addCriterion("unit_price <", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceLessThanOrEqualTo(Integer value) {
            addCriterion("unit_price <=", value, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceIn(List<Integer> values) {
            addCriterion("unit_price in", values, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceNotIn(List<Integer> values) {
            addCriterion("unit_price not in", values, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceBetween(Integer value1, Integer value2) {
            addCriterion("unit_price between", value1, value2, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andUnitPriceNotBetween(Integer value1, Integer value2) {
            addCriterion("unit_price not between", value1, value2, "unitPrice");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeIsNull() {
            addCriterion("act_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeIsNotNull() {
            addCriterion("act_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeEqualTo(Integer value) {
            addCriterion("act_total_fee =", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeNotEqualTo(Integer value) {
            addCriterion("act_total_fee <>", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeGreaterThan(Integer value) {
            addCriterion("act_total_fee >", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("act_total_fee >=", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeLessThan(Integer value) {
            addCriterion("act_total_fee <", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeLessThanOrEqualTo(Integer value) {
            addCriterion("act_total_fee <=", value, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeIn(List<Integer> values) {
            addCriterion("act_total_fee in", values, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeNotIn(List<Integer> values) {
            addCriterion("act_total_fee not in", values, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeBetween(Integer value1, Integer value2) {
            addCriterion("act_total_fee between", value1, value2, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andActTotalFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("act_total_fee not between", value1, value2, "actTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeIsNull() {
            addCriterion("total_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeIsNotNull() {
            addCriterion("total_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeEqualTo(Integer value) {
            addCriterion("total_total_fee =", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeNotEqualTo(Integer value) {
            addCriterion("total_total_fee <>", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeGreaterThan(Integer value) {
            addCriterion("total_total_fee >", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("total_total_fee >=", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeLessThan(Integer value) {
            addCriterion("total_total_fee <", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeLessThanOrEqualTo(Integer value) {
            addCriterion("total_total_fee <=", value, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeIn(List<Integer> values) {
            addCriterion("total_total_fee in", values, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeNotIn(List<Integer> values) {
            addCriterion("total_total_fee not in", values, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeBetween(Integer value1, Integer value2) {
            addCriterion("total_total_fee between", value1, value2, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalTotalFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("total_total_fee not between", value1, value2, "totalTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeIsNull() {
            addCriterion("dicount_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeIsNotNull() {
            addCriterion("dicount_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeEqualTo(Integer value) {
            addCriterion("dicount_total_fee =", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeNotEqualTo(Integer value) {
            addCriterion("dicount_total_fee <>", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeGreaterThan(Integer value) {
            addCriterion("dicount_total_fee >", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeGreaterThanOrEqualTo(Integer value) {
            addCriterion("dicount_total_fee >=", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeLessThan(Integer value) {
            addCriterion("dicount_total_fee <", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeLessThanOrEqualTo(Integer value) {
            addCriterion("dicount_total_fee <=", value, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeIn(List<Integer> values) {
            addCriterion("dicount_total_fee in", values, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeNotIn(List<Integer> values) {
            addCriterion("dicount_total_fee not in", values, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeBetween(Integer value1, Integer value2) {
            addCriterion("dicount_total_fee between", value1, value2, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andDicountTotalFeeNotBetween(Integer value1, Integer value2) {
            addCriterion("dicount_total_fee not between", value1, value2, "dicountTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIsNull() {
            addCriterion("pay_order_no is null");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIsNotNull() {
            addCriterion("pay_order_no is not null");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoEqualTo(String value) {
            addCriterion("pay_order_no =", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotEqualTo(String value) {
            addCriterion("pay_order_no <>", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoGreaterThan(String value) {
            addCriterion("pay_order_no >", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("pay_order_no >=", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLessThan(String value) {
            addCriterion("pay_order_no <", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLessThanOrEqualTo(String value) {
            addCriterion("pay_order_no <=", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoLike(String value) {
            addCriterion("pay_order_no like", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotLike(String value) {
            addCriterion("pay_order_no not like", value, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoIn(List<String> values) {
            addCriterion("pay_order_no in", values, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotIn(List<String> values) {
            addCriterion("pay_order_no not in", values, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoBetween(String value1, String value2) {
            addCriterion("pay_order_no between", value1, value2, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayOrderNoNotBetween(String value1, String value2) {
            addCriterion("pay_order_no not between", value1, value2, "payOrderNo");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNull() {
            addCriterion("card_type is null");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNotNull() {
            addCriterion("card_type is not null");
            return (Criteria) this;
        }

        public Criteria andCardTypeEqualTo(Integer value) {
            addCriterion("card_type =", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotEqualTo(Integer value) {
            addCriterion("card_type <>", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThan(Integer value) {
            addCriterion("card_type >", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("card_type >=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThan(Integer value) {
            addCriterion("card_type <", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThanOrEqualTo(Integer value) {
            addCriterion("card_type <=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeIn(List<Integer> values) {
            addCriterion("card_type in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotIn(List<Integer> values) {
            addCriterion("card_type not in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeBetween(Integer value1, Integer value2) {
            addCriterion("card_type between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("card_type not between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeIsNull() {
            addCriterion("coupons_type is null");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeIsNotNull() {
            addCriterion("coupons_type is not null");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeEqualTo(Integer value) {
            addCriterion("coupons_type =", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeNotEqualTo(Integer value) {
            addCriterion("coupons_type <>", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeGreaterThan(Integer value) {
            addCriterion("coupons_type >", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("coupons_type >=", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeLessThan(Integer value) {
            addCriterion("coupons_type <", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("coupons_type <=", value, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeIn(List<Integer> values) {
            addCriterion("coupons_type in", values, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeNotIn(List<Integer> values) {
            addCriterion("coupons_type not in", values, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeBetween(Integer value1, Integer value2) {
            addCriterion("coupons_type between", value1, value2, "couponsType");
            return (Criteria) this;
        }

        public Criteria andCouponsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("coupons_type not between", value1, value2, "couponsType");
            return (Criteria) this;
        }

        public Criteria andUseRuleIsNull() {
            addCriterion("use_rule is null");
            return (Criteria) this;
        }

        public Criteria andUseRuleIsNotNull() {
            addCriterion("use_rule is not null");
            return (Criteria) this;
        }

        public Criteria andUseRuleEqualTo(Integer value) {
            addCriterion("use_rule =", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleNotEqualTo(Integer value) {
            addCriterion("use_rule <>", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleGreaterThan(Integer value) {
            addCriterion("use_rule >", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleGreaterThanOrEqualTo(Integer value) {
            addCriterion("use_rule >=", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleLessThan(Integer value) {
            addCriterion("use_rule <", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleLessThanOrEqualTo(Integer value) {
            addCriterion("use_rule <=", value, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleIn(List<Integer> values) {
            addCriterion("use_rule in", values, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleNotIn(List<Integer> values) {
            addCriterion("use_rule not in", values, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleBetween(Integer value1, Integer value2) {
            addCriterion("use_rule between", value1, value2, "useRule");
            return (Criteria) this;
        }

        public Criteria andUseRuleNotBetween(Integer value1, Integer value2) {
            addCriterion("use_rule not between", value1, value2, "useRule");
            return (Criteria) this;
        }

        public Criteria andDiscValueIsNull() {
            addCriterion("disc_value is null");
            return (Criteria) this;
        }

        public Criteria andDiscValueIsNotNull() {
            addCriterion("disc_value is not null");
            return (Criteria) this;
        }

        public Criteria andDiscValueEqualTo(String value) {
            addCriterion("disc_value =", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueNotEqualTo(String value) {
            addCriterion("disc_value <>", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueGreaterThan(String value) {
            addCriterion("disc_value >", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueGreaterThanOrEqualTo(String value) {
            addCriterion("disc_value >=", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueLessThan(String value) {
            addCriterion("disc_value <", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueLessThanOrEqualTo(String value) {
            addCriterion("disc_value <=", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueLike(String value) {
            addCriterion("disc_value like", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueNotLike(String value) {
            addCriterion("disc_value not like", value, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueIn(List<String> values) {
            addCriterion("disc_value in", values, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueNotIn(List<String> values) {
            addCriterion("disc_value not in", values, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueBetween(String value1, String value2) {
            addCriterion("disc_value between", value1, value2, "discValue");
            return (Criteria) this;
        }

        public Criteria andDiscValueNotBetween(String value1, String value2) {
            addCriterion("disc_value not between", value1, value2, "discValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueIsNull() {
            addCriterion("full_cut_value is null");
            return (Criteria) this;
        }

        public Criteria andFullCutValueIsNotNull() {
            addCriterion("full_cut_value is not null");
            return (Criteria) this;
        }

        public Criteria andFullCutValueEqualTo(Integer value) {
            addCriterion("full_cut_value =", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueNotEqualTo(Integer value) {
            addCriterion("full_cut_value <>", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueGreaterThan(Integer value) {
            addCriterion("full_cut_value >", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueGreaterThanOrEqualTo(Integer value) {
            addCriterion("full_cut_value >=", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueLessThan(Integer value) {
            addCriterion("full_cut_value <", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueLessThanOrEqualTo(Integer value) {
            addCriterion("full_cut_value <=", value, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueIn(List<Integer> values) {
            addCriterion("full_cut_value in", values, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueNotIn(List<Integer> values) {
            addCriterion("full_cut_value not in", values, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueBetween(Integer value1, Integer value2) {
            addCriterion("full_cut_value between", value1, value2, "fullCutValue");
            return (Criteria) this;
        }

        public Criteria andFullCutValueNotBetween(Integer value1, Integer value2) {
            addCriterion("full_cut_value not between", value1, value2, "fullCutValue");
            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 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 andCreateEmpIdIsNull() {
            addCriterion("create_emp_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdIsNotNull() {
            addCriterion("create_emp_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdEqualTo(String value) {
            addCriterion("create_emp_id =", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdNotEqualTo(String value) {
            addCriterion("create_emp_id <>", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdGreaterThan(String value) {
            addCriterion("create_emp_id >", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_emp_id >=", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdLessThan(String value) {
            addCriterion("create_emp_id <", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdLessThanOrEqualTo(String value) {
            addCriterion("create_emp_id <=", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdLike(String value) {
            addCriterion("create_emp_id like", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdNotLike(String value) {
            addCriterion("create_emp_id not like", value, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdIn(List<String> values) {
            addCriterion("create_emp_id in", values, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdNotIn(List<String> values) {
            addCriterion("create_emp_id not in", values, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdBetween(String value1, String value2) {
            addCriterion("create_emp_id between", value1, value2, "createEmpId");
            return (Criteria) this;
        }

        public Criteria andCreateEmpIdNotBetween(String value1, String value2) {
            addCriterion("create_emp_id 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_emp_id is null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdIsNotNull() {
            addCriterion("modfiy_emp_id is not null");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdEqualTo(String value) {
            addCriterion("modfiy_emp_id =", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdNotEqualTo(String value) {
            addCriterion("modfiy_emp_id <>", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdGreaterThan(String value) {
            addCriterion("modfiy_emp_id >", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdGreaterThanOrEqualTo(String value) {
            addCriterion("modfiy_emp_id >=", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdLessThan(String value) {
            addCriterion("modfiy_emp_id <", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdLessThanOrEqualTo(String value) {
            addCriterion("modfiy_emp_id <=", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdLike(String value) {
            addCriterion("modfiy_emp_id like", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdNotLike(String value) {
            addCriterion("modfiy_emp_id not like", value, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdIn(List<String> values) {
            addCriterion("modfiy_emp_id in", values, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdNotIn(List<String> values) {
            addCriterion("modfiy_emp_id not in", values, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdBetween(String value1, String value2) {
            addCriterion("modfiy_emp_id between", value1, value2, "modfiyEmpId");
            return (Criteria) this;
        }

        public Criteria andModfiyEmpIdNotBetween(String value1, String value2) {
            addCriterion("modfiy_emp_id 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 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);
        }
    }
}