package com.platform.pojo;

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

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

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

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

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

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

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

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

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

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

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

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

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ORDER_REG
     *
     * @mbggenerated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ORDER_REG
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

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

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_REG
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> 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 || value.toString().equals("") ) {
                 addCriterion("1=1"); 
                 return; 
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null || value1.toString().equals("")|| value2.toString().equals("") ) {
                 addCriterion("1=1"); 
                 return; 
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andOrderDateIsNull() {
            addCriterion("ORDER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andOrderDateIsNotNull() {
            addCriterion("ORDER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDateEqualTo(String value) {
            addCriterion("ORDER_DATE =", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotEqualTo(String value) {
            addCriterion("ORDER_DATE <>", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateGreaterThan(String value) {
            addCriterion("ORDER_DATE >", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_DATE >=", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateLessThan(String value) {
            addCriterion("ORDER_DATE <", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateLessThanOrEqualTo(String value) {
            addCriterion("ORDER_DATE <=", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateLike(String value) {
            addCriterion("ORDER_DATE like", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotLike(String value) {
            addCriterion("ORDER_DATE not like", value, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateIn(List<String> values) {
            addCriterion("ORDER_DATE in", values, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotIn(List<String> values) {
            addCriterion("ORDER_DATE not in", values, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateBetween(String value1, String value2) {
            addCriterion("ORDER_DATE between", value1, value2, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderDateNotBetween(String value1, String value2) {
            addCriterion("ORDER_DATE not between", value1, value2, "orderDate");
            return (Criteria) this;
        }

        public Criteria andOrderNameIsNull() {
            addCriterion("ORDER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrderNameIsNotNull() {
            addCriterion("ORDER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNameEqualTo(String value) {
            addCriterion("ORDER_NAME =", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameNotEqualTo(String value) {
            addCriterion("ORDER_NAME <>", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameGreaterThan(String value) {
            addCriterion("ORDER_NAME >", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_NAME >=", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameLessThan(String value) {
            addCriterion("ORDER_NAME <", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameLessThanOrEqualTo(String value) {
            addCriterion("ORDER_NAME <=", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameLike(String value) {
            addCriterion("ORDER_NAME like", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameNotLike(String value) {
            addCriterion("ORDER_NAME not like", value, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameIn(List<String> values) {
            addCriterion("ORDER_NAME in", values, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameNotIn(List<String> values) {
            addCriterion("ORDER_NAME not in", values, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameBetween(String value1, String value2) {
            addCriterion("ORDER_NAME between", value1, value2, "orderName");
            return (Criteria) this;
        }

        public Criteria andOrderNameNotBetween(String value1, String value2) {
            addCriterion("ORDER_NAME not between", value1, value2, "orderName");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNull() {
            addCriterion("PHONE_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNotNull() {
            addCriterion("PHONE_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberEqualTo(String value) {
            addCriterion("PHONE_NUMBER =", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotEqualTo(String value) {
            addCriterion("PHONE_NUMBER <>", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThan(String value) {
            addCriterion("PHONE_NUMBER >", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThanOrEqualTo(String value) {
            addCriterion("PHONE_NUMBER >=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThan(String value) {
            addCriterion("PHONE_NUMBER <", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThanOrEqualTo(String value) {
            addCriterion("PHONE_NUMBER <=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLike(String value) {
            addCriterion("PHONE_NUMBER like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotLike(String value) {
            addCriterion("PHONE_NUMBER not like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIn(List<String> values) {
            addCriterion("PHONE_NUMBER in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotIn(List<String> values) {
            addCriterion("PHONE_NUMBER not in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberBetween(String value1, String value2) {
            addCriterion("PHONE_NUMBER between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotBetween(String value1, String value2) {
            addCriterion("PHONE_NUMBER not between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoIsNull() {
            addCriterion("ORDER_SECTION_NO is null");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoIsNotNull() {
            addCriterion("ORDER_SECTION_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoEqualTo(String value) {
            addCriterion("ORDER_SECTION_NO =", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoNotEqualTo(String value) {
            addCriterion("ORDER_SECTION_NO <>", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoGreaterThan(String value) {
            addCriterion("ORDER_SECTION_NO >", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_SECTION_NO >=", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoLessThan(String value) {
            addCriterion("ORDER_SECTION_NO <", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoLessThanOrEqualTo(String value) {
            addCriterion("ORDER_SECTION_NO <=", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoLike(String value) {
            addCriterion("ORDER_SECTION_NO like", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoNotLike(String value) {
            addCriterion("ORDER_SECTION_NO not like", value, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoIn(List<String> values) {
            addCriterion("ORDER_SECTION_NO in", values, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoNotIn(List<String> values) {
            addCriterion("ORDER_SECTION_NO not in", values, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoBetween(String value1, String value2) {
            addCriterion("ORDER_SECTION_NO between", value1, value2, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNoNotBetween(String value1, String value2) {
            addCriterion("ORDER_SECTION_NO not between", value1, value2, "orderSectionNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoIsNull() {
            addCriterion("ORDER_DOCTOR_NO is null");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoIsNotNull() {
            addCriterion("ORDER_DOCTOR_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NO =", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoNotEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NO <>", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoGreaterThan(String value) {
            addCriterion("ORDER_DOCTOR_NO >", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NO >=", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoLessThan(String value) {
            addCriterion("ORDER_DOCTOR_NO <", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoLessThanOrEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NO <=", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoLike(String value) {
            addCriterion("ORDER_DOCTOR_NO like", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoNotLike(String value) {
            addCriterion("ORDER_DOCTOR_NO not like", value, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoIn(List<String> values) {
            addCriterion("ORDER_DOCTOR_NO in", values, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoNotIn(List<String> values) {
            addCriterion("ORDER_DOCTOR_NO not in", values, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoBetween(String value1, String value2) {
            addCriterion("ORDER_DOCTOR_NO between", value1, value2, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNoNotBetween(String value1, String value2) {
            addCriterion("ORDER_DOCTOR_NO not between", value1, value2, "orderDoctorNo");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("ORDER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("ORDER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("ORDER_TYPE =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("ORDER_TYPE <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("ORDER_TYPE >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_TYPE >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("ORDER_TYPE <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("ORDER_TYPE <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("ORDER_TYPE like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("ORDER_TYPE not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("ORDER_TYPE in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("ORDER_TYPE not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("ORDER_TYPE between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("ORDER_TYPE not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andRegTypeIsNull() {
            addCriterion("REG_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andRegTypeIsNotNull() {
            addCriterion("REG_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRegTypeEqualTo(String value) {
            addCriterion("REG_TYPE =", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeNotEqualTo(String value) {
            addCriterion("REG_TYPE <>", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeGreaterThan(String value) {
            addCriterion("REG_TYPE >", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeGreaterThanOrEqualTo(String value) {
            addCriterion("REG_TYPE >=", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeLessThan(String value) {
            addCriterion("REG_TYPE <", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeLessThanOrEqualTo(String value) {
            addCriterion("REG_TYPE <=", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeLike(String value) {
            addCriterion("REG_TYPE like", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeNotLike(String value) {
            addCriterion("REG_TYPE not like", value, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeIn(List<String> values) {
            addCriterion("REG_TYPE in", values, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeNotIn(List<String> values) {
            addCriterion("REG_TYPE not in", values, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeBetween(String value1, String value2) {
            addCriterion("REG_TYPE between", value1, value2, "regType");
            return (Criteria) this;
        }

        public Criteria andRegTypeNotBetween(String value1, String value2) {
            addCriterion("REG_TYPE not between", value1, value2, "regType");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoIsNull() {
            addCriterion("REG_CATEGORY_NO is null");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoIsNotNull() {
            addCriterion("REG_CATEGORY_NO is not null");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoEqualTo(String value) {
            addCriterion("REG_CATEGORY_NO =", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoNotEqualTo(String value) {
            addCriterion("REG_CATEGORY_NO <>", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoGreaterThan(String value) {
            addCriterion("REG_CATEGORY_NO >", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoGreaterThanOrEqualTo(String value) {
            addCriterion("REG_CATEGORY_NO >=", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoLessThan(String value) {
            addCriterion("REG_CATEGORY_NO <", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoLessThanOrEqualTo(String value) {
            addCriterion("REG_CATEGORY_NO <=", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoLike(String value) {
            addCriterion("REG_CATEGORY_NO like", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoNotLike(String value) {
            addCriterion("REG_CATEGORY_NO not like", value, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoIn(List<String> values) {
            addCriterion("REG_CATEGORY_NO in", values, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoNotIn(List<String> values) {
            addCriterion("REG_CATEGORY_NO not in", values, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoBetween(String value1, String value2) {
            addCriterion("REG_CATEGORY_NO between", value1, value2, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNoNotBetween(String value1, String value2) {
            addCriterion("REG_CATEGORY_NO not between", value1, value2, "regCategoryNo");
            return (Criteria) this;
        }

        public Criteria andLimitNumberIsNull() {
            addCriterion("LIMIT_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andLimitNumberIsNotNull() {
            addCriterion("LIMIT_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andLimitNumberEqualTo(BigDecimal value) {
            addCriterion("LIMIT_NUMBER =", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberNotEqualTo(BigDecimal value) {
            addCriterion("LIMIT_NUMBER <>", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberGreaterThan(BigDecimal value) {
            addCriterion("LIMIT_NUMBER >", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LIMIT_NUMBER >=", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberLessThan(BigDecimal value) {
            addCriterion("LIMIT_NUMBER <", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LIMIT_NUMBER <=", value, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberIn(List<BigDecimal> values) {
            addCriterion("LIMIT_NUMBER in", values, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberNotIn(List<BigDecimal> values) {
            addCriterion("LIMIT_NUMBER not in", values, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LIMIT_NUMBER between", value1, value2, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andLimitNumberNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LIMIT_NUMBER not between", value1, value2, "limitNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberIsNull() {
            addCriterion("ORDERED_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberIsNotNull() {
            addCriterion("ORDERED_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberEqualTo(BigDecimal value) {
            addCriterion("ORDERED_NUMBER =", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberNotEqualTo(BigDecimal value) {
            addCriterion("ORDERED_NUMBER <>", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberGreaterThan(BigDecimal value) {
            addCriterion("ORDERED_NUMBER >", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERED_NUMBER >=", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberLessThan(BigDecimal value) {
            addCriterion("ORDERED_NUMBER <", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERED_NUMBER <=", value, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberIn(List<BigDecimal> values) {
            addCriterion("ORDERED_NUMBER in", values, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberNotIn(List<BigDecimal> values) {
            addCriterion("ORDERED_NUMBER not in", values, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERED_NUMBER between", value1, value2, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderedNumberNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERED_NUMBER not between", value1, value2, "orderedNumber");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIsNull() {
            addCriterion("ORDER_SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIsNotNull() {
            addCriterion("ORDER_SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSourceEqualTo(String value) {
            addCriterion("ORDER_SOURCE =", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotEqualTo(String value) {
            addCriterion("ORDER_SOURCE <>", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceGreaterThan(String value) {
            addCriterion("ORDER_SOURCE >", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_SOURCE >=", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLessThan(String value) {
            addCriterion("ORDER_SOURCE <", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLessThanOrEqualTo(String value) {
            addCriterion("ORDER_SOURCE <=", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceLike(String value) {
            addCriterion("ORDER_SOURCE like", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotLike(String value) {
            addCriterion("ORDER_SOURCE not like", value, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceIn(List<String> values) {
            addCriterion("ORDER_SOURCE in", values, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotIn(List<String> values) {
            addCriterion("ORDER_SOURCE not in", values, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceBetween(String value1, String value2) {
            addCriterion("ORDER_SOURCE between", value1, value2, "orderSource");
            return (Criteria) this;
        }

        public Criteria andOrderSourceNotBetween(String value1, String value2) {
            addCriterion("ORDER_SOURCE not between", value1, value2, "orderSource");
            return (Criteria) this;
        }

        public Criteria andSortNoIsNull() {
            addCriterion("SORT_NO is null");
            return (Criteria) this;
        }

        public Criteria andSortNoIsNotNull() {
            addCriterion("SORT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andSortNoEqualTo(String value) {
            addCriterion("SORT_NO =", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotEqualTo(String value) {
            addCriterion("SORT_NO <>", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoGreaterThan(String value) {
            addCriterion("SORT_NO >", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoGreaterThanOrEqualTo(String value) {
            addCriterion("SORT_NO >=", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoLessThan(String value) {
            addCriterion("SORT_NO <", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoLessThanOrEqualTo(String value) {
            addCriterion("SORT_NO <=", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoLike(String value) {
            addCriterion("SORT_NO like", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotLike(String value) {
            addCriterion("SORT_NO not like", value, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoIn(List<String> values) {
            addCriterion("SORT_NO in", values, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotIn(List<String> values) {
            addCriterion("SORT_NO not in", values, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoBetween(String value1, String value2) {
            addCriterion("SORT_NO between", value1, value2, "sortNo");
            return (Criteria) this;
        }

        public Criteria andSortNoNotBetween(String value1, String value2) {
            addCriterion("SORT_NO not between", value1, value2, "sortNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoIsNull() {
            addCriterion("PATIENT_IDCARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoIsNotNull() {
            addCriterion("PATIENT_IDCARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoEqualTo(String value) {
            addCriterion("PATIENT_IDCARD_NO =", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoNotEqualTo(String value) {
            addCriterion("PATIENT_IDCARD_NO <>", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoGreaterThan(String value) {
            addCriterion("PATIENT_IDCARD_NO >", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoGreaterThanOrEqualTo(String value) {
            addCriterion("PATIENT_IDCARD_NO >=", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoLessThan(String value) {
            addCriterion("PATIENT_IDCARD_NO <", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoLessThanOrEqualTo(String value) {
            addCriterion("PATIENT_IDCARD_NO <=", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoLike(String value) {
            addCriterion("PATIENT_IDCARD_NO like", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoNotLike(String value) {
            addCriterion("PATIENT_IDCARD_NO not like", value, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoIn(List<String> values) {
            addCriterion("PATIENT_IDCARD_NO in", values, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoNotIn(List<String> values) {
            addCriterion("PATIENT_IDCARD_NO not in", values, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoBetween(String value1, String value2) {
            addCriterion("PATIENT_IDCARD_NO between", value1, value2, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientIdcardNoNotBetween(String value1, String value2) {
            addCriterion("PATIENT_IDCARD_NO not between", value1, value2, "patientIdcardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoIsNull() {
            addCriterion("PATIENT_CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoIsNotNull() {
            addCriterion("PATIENT_CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoEqualTo(String value) {
            addCriterion("PATIENT_CARD_NO =", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoNotEqualTo(String value) {
            addCriterion("PATIENT_CARD_NO <>", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoGreaterThan(String value) {
            addCriterion("PATIENT_CARD_NO >", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoGreaterThanOrEqualTo(String value) {
            addCriterion("PATIENT_CARD_NO >=", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoLessThan(String value) {
            addCriterion("PATIENT_CARD_NO <", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoLessThanOrEqualTo(String value) {
            addCriterion("PATIENT_CARD_NO <=", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoLike(String value) {
            addCriterion("PATIENT_CARD_NO like", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoNotLike(String value) {
            addCriterion("PATIENT_CARD_NO not like", value, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoIn(List<String> values) {
            addCriterion("PATIENT_CARD_NO in", values, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoNotIn(List<String> values) {
            addCriterion("PATIENT_CARD_NO not in", values, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoBetween(String value1, String value2) {
            addCriterion("PATIENT_CARD_NO between", value1, value2, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andPatientCardNoNotBetween(String value1, String value2) {
            addCriterion("PATIENT_CARD_NO not between", value1, value2, "patientCardNo");
            return (Criteria) this;
        }

        public Criteria andRegStatusIsNull() {
            addCriterion("REG_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andRegStatusIsNotNull() {
            addCriterion("REG_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andRegStatusEqualTo(String value) {
            addCriterion("REG_STATUS =", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusNotEqualTo(String value) {
            addCriterion("REG_STATUS <>", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusGreaterThan(String value) {
            addCriterion("REG_STATUS >", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusGreaterThanOrEqualTo(String value) {
            addCriterion("REG_STATUS >=", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusLessThan(String value) {
            addCriterion("REG_STATUS <", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusLessThanOrEqualTo(String value) {
            addCriterion("REG_STATUS <=", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusLike(String value) {
            addCriterion("REG_STATUS like", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusNotLike(String value) {
            addCriterion("REG_STATUS not like", value, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusIn(List<String> values) {
            addCriterion("REG_STATUS in", values, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusNotIn(List<String> values) {
            addCriterion("REG_STATUS not in", values, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusBetween(String value1, String value2) {
            addCriterion("REG_STATUS between", value1, value2, "regStatus");
            return (Criteria) this;
        }

        public Criteria andRegStatusNotBetween(String value1, String value2) {
            addCriterion("REG_STATUS not between", value1, value2, "regStatus");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameIsNull() {
            addCriterion("ORDER_SECTION_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameIsNotNull() {
            addCriterion("ORDER_SECTION_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameEqualTo(String value) {
            addCriterion("ORDER_SECTION_NAME =", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameNotEqualTo(String value) {
            addCriterion("ORDER_SECTION_NAME <>", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameGreaterThan(String value) {
            addCriterion("ORDER_SECTION_NAME >", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_SECTION_NAME >=", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameLessThan(String value) {
            addCriterion("ORDER_SECTION_NAME <", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameLessThanOrEqualTo(String value) {
            addCriterion("ORDER_SECTION_NAME <=", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameLike(String value) {
            addCriterion("ORDER_SECTION_NAME like", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameNotLike(String value) {
            addCriterion("ORDER_SECTION_NAME not like", value, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameIn(List<String> values) {
            addCriterion("ORDER_SECTION_NAME in", values, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameNotIn(List<String> values) {
            addCriterion("ORDER_SECTION_NAME not in", values, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameBetween(String value1, String value2) {
            addCriterion("ORDER_SECTION_NAME between", value1, value2, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderSectionNameNotBetween(String value1, String value2) {
            addCriterion("ORDER_SECTION_NAME not between", value1, value2, "orderSectionName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameIsNull() {
            addCriterion("ORDER_DOCTOR_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameIsNotNull() {
            addCriterion("ORDER_DOCTOR_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NAME =", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameNotEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NAME <>", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameGreaterThan(String value) {
            addCriterion("ORDER_DOCTOR_NAME >", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NAME >=", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameLessThan(String value) {
            addCriterion("ORDER_DOCTOR_NAME <", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameLessThanOrEqualTo(String value) {
            addCriterion("ORDER_DOCTOR_NAME <=", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameLike(String value) {
            addCriterion("ORDER_DOCTOR_NAME like", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameNotLike(String value) {
            addCriterion("ORDER_DOCTOR_NAME not like", value, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameIn(List<String> values) {
            addCriterion("ORDER_DOCTOR_NAME in", values, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameNotIn(List<String> values) {
            addCriterion("ORDER_DOCTOR_NAME not in", values, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameBetween(String value1, String value2) {
            addCriterion("ORDER_DOCTOR_NAME between", value1, value2, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andOrderDoctorNameNotBetween(String value1, String value2) {
            addCriterion("ORDER_DOCTOR_NAME not between", value1, value2, "orderDoctorName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameIsNull() {
            addCriterion("REG_CATEGORY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameIsNotNull() {
            addCriterion("REG_CATEGORY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameEqualTo(String value) {
            addCriterion("REG_CATEGORY_NAME =", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameNotEqualTo(String value) {
            addCriterion("REG_CATEGORY_NAME <>", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameGreaterThan(String value) {
            addCriterion("REG_CATEGORY_NAME >", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameGreaterThanOrEqualTo(String value) {
            addCriterion("REG_CATEGORY_NAME >=", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameLessThan(String value) {
            addCriterion("REG_CATEGORY_NAME <", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameLessThanOrEqualTo(String value) {
            addCriterion("REG_CATEGORY_NAME <=", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameLike(String value) {
            addCriterion("REG_CATEGORY_NAME like", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameNotLike(String value) {
            addCriterion("REG_CATEGORY_NAME not like", value, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameIn(List<String> values) {
            addCriterion("REG_CATEGORY_NAME in", values, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameNotIn(List<String> values) {
            addCriterion("REG_CATEGORY_NAME not in", values, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameBetween(String value1, String value2) {
            addCriterion("REG_CATEGORY_NAME between", value1, value2, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andRegCategoryNameNotBetween(String value1, String value2) {
            addCriterion("REG_CATEGORY_NAME not between", value1, value2, "regCategoryName");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("ORDER_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("ORDER_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(String value) {
            addCriterion("ORDER_TIME =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(String value) {
            addCriterion("ORDER_TIME <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(String value) {
            addCriterion("ORDER_TIME >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_TIME >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(String value) {
            addCriterion("ORDER_TIME <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(String value) {
            addCriterion("ORDER_TIME <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLike(String value) {
            addCriterion("ORDER_TIME like", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotLike(String value) {
            addCriterion("ORDER_TIME not like", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<String> values) {
            addCriterion("ORDER_TIME in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<String> values) {
            addCriterion("ORDER_TIME not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(String value1, String value2) {
            addCriterion("ORDER_TIME between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(String value1, String value2) {
            addCriterion("ORDER_TIME not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andVisitDateIsNull() {
            addCriterion("VISIT_DATE is null");
            return (Criteria) this;
        }

        public Criteria andVisitDateIsNotNull() {
            addCriterion("VISIT_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andVisitDateEqualTo(String value) {
            addCriterion("VISIT_DATE =", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateNotEqualTo(String value) {
            addCriterion("VISIT_DATE <>", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateGreaterThan(String value) {
            addCriterion("VISIT_DATE >", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateGreaterThanOrEqualTo(String value) {
            addCriterion("VISIT_DATE >=", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateLessThan(String value) {
            addCriterion("VISIT_DATE <", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateLessThanOrEqualTo(String value) {
            addCriterion("VISIT_DATE <=", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateLike(String value) {
            addCriterion("VISIT_DATE like", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateNotLike(String value) {
            addCriterion("VISIT_DATE not like", value, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateIn(List<String> values) {
            addCriterion("VISIT_DATE in", values, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateNotIn(List<String> values) {
            addCriterion("VISIT_DATE not in", values, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateBetween(String value1, String value2) {
            addCriterion("VISIT_DATE between", value1, value2, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitDateNotBetween(String value1, String value2) {
            addCriterion("VISIT_DATE not between", value1, value2, "visitDate");
            return (Criteria) this;
        }

        public Criteria andVisitTimeIsNull() {
            addCriterion("VISIT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andVisitTimeIsNotNull() {
            addCriterion("VISIT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andVisitTimeEqualTo(String value) {
            addCriterion("VISIT_TIME =", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeNotEqualTo(String value) {
            addCriterion("VISIT_TIME <>", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeGreaterThan(String value) {
            addCriterion("VISIT_TIME >", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeGreaterThanOrEqualTo(String value) {
            addCriterion("VISIT_TIME >=", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeLessThan(String value) {
            addCriterion("VISIT_TIME <", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeLessThanOrEqualTo(String value) {
            addCriterion("VISIT_TIME <=", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeLike(String value) {
            addCriterion("VISIT_TIME like", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeNotLike(String value) {
            addCriterion("VISIT_TIME not like", value, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeIn(List<String> values) {
            addCriterion("VISIT_TIME in", values, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeNotIn(List<String> values) {
            addCriterion("VISIT_TIME not in", values, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeBetween(String value1, String value2) {
            addCriterion("VISIT_TIME between", value1, value2, "visitTime");
            return (Criteria) this;
        }

        public Criteria andVisitTimeNotBetween(String value1, String value2) {
            addCriterion("VISIT_TIME not between", value1, value2, "visitTime");
            return (Criteria) this;
        }

        public Criteria andPlanIdIsNull() {
            addCriterion("PLAN_ID is null");
            return (Criteria) this;
        }

        public Criteria andPlanIdIsNotNull() {
            addCriterion("PLAN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPlanIdEqualTo(String value) {
            addCriterion("PLAN_ID =", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotEqualTo(String value) {
            addCriterion("PLAN_ID <>", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdGreaterThan(String value) {
            addCriterion("PLAN_ID >", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdGreaterThanOrEqualTo(String value) {
            addCriterion("PLAN_ID >=", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdLessThan(String value) {
            addCriterion("PLAN_ID <", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdLessThanOrEqualTo(String value) {
            addCriterion("PLAN_ID <=", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdLike(String value) {
            addCriterion("PLAN_ID like", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotLike(String value) {
            addCriterion("PLAN_ID not like", value, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdIn(List<String> values) {
            addCriterion("PLAN_ID in", values, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotIn(List<String> values) {
            addCriterion("PLAN_ID not in", values, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdBetween(String value1, String value2) {
            addCriterion("PLAN_ID between", value1, value2, "planId");
            return (Criteria) this;
        }

        public Criteria andPlanIdNotBetween(String value1, String value2) {
            addCriterion("PLAN_ID not between", value1, value2, "planId");
            return (Criteria) this;
        }
    }

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

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_REG
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

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