package com.idea.oa.apply.model;

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

public class ApplyWorkReceivableExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

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

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        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 andPlannoIsNull() {
            addCriterion("planNo is null");
            return (Criteria) this;
        }

        public Criteria andPlannoIsNotNull() {
            addCriterion("planNo is not null");
            return (Criteria) this;
        }

        public Criteria andPlannoEqualTo(String value) {
            addCriterion("planNo =", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoNotEqualTo(String value) {
            addCriterion("planNo <>", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoGreaterThan(String value) {
            addCriterion("planNo >", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoGreaterThanOrEqualTo(String value) {
            addCriterion("planNo >=", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoLessThan(String value) {
            addCriterion("planNo <", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoLessThanOrEqualTo(String value) {
            addCriterion("planNo <=", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoLike(String value) {
            addCriterion("planNo like", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoNotLike(String value) {
            addCriterion("planNo not like", value, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoIn(List<String> values) {
            addCriterion("planNo in", values, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoNotIn(List<String> values) {
            addCriterion("planNo not in", values, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoBetween(String value1, String value2) {
            addCriterion("planNo between", value1, value2, "planno");
            return (Criteria) this;
        }

        public Criteria andPlannoNotBetween(String value1, String value2) {
            addCriterion("planNo not between", value1, value2, "planno");
            return (Criteria) this;
        }

        public Criteria andPlanstatusIsNull() {
            addCriterion("planStatus is null");
            return (Criteria) this;
        }

        public Criteria andPlanstatusIsNotNull() {
            addCriterion("planStatus is not null");
            return (Criteria) this;
        }

        public Criteria andPlanstatusEqualTo(String value) {
            addCriterion("planStatus =", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusNotEqualTo(String value) {
            addCriterion("planStatus <>", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusGreaterThan(String value) {
            addCriterion("planStatus >", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusGreaterThanOrEqualTo(String value) {
            addCriterion("planStatus >=", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusLessThan(String value) {
            addCriterion("planStatus <", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusLessThanOrEqualTo(String value) {
            addCriterion("planStatus <=", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusLike(String value) {
            addCriterion("planStatus like", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusNotLike(String value) {
            addCriterion("planStatus not like", value, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusIn(List<String> values) {
            addCriterion("planStatus in", values, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusNotIn(List<String> values) {
            addCriterion("planStatus not in", values, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusBetween(String value1, String value2) {
            addCriterion("planStatus between", value1, value2, "planstatus");
            return (Criteria) this;
        }

        public Criteria andPlanstatusNotBetween(String value1, String value2) {
            addCriterion("planStatus not between", value1, value2, "planstatus");
            return (Criteria) this;
        }

        public Criteria andCtridIsNull() {
            addCriterion("ctrId is null");
            return (Criteria) this;
        }

        public Criteria andCtridIsNotNull() {
            addCriterion("ctrId is not null");
            return (Criteria) this;
        }

        public Criteria andCtridEqualTo(String value) {
            addCriterion("ctrId =", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridNotEqualTo(String value) {
            addCriterion("ctrId <>", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridGreaterThan(String value) {
            addCriterion("ctrId >", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridGreaterThanOrEqualTo(String value) {
            addCriterion("ctrId >=", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridLessThan(String value) {
            addCriterion("ctrId <", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridLessThanOrEqualTo(String value) {
            addCriterion("ctrId <=", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridLike(String value) {
            addCriterion("ctrId like", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridNotLike(String value) {
            addCriterion("ctrId not like", value, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridIn(List<String> values) {
            addCriterion("ctrId in", values, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridNotIn(List<String> values) {
            addCriterion("ctrId not in", values, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridBetween(String value1, String value2) {
            addCriterion("ctrId between", value1, value2, "ctrid");
            return (Criteria) this;
        }

        public Criteria andCtridNotBetween(String value1, String value2) {
            addCriterion("ctrId not between", value1, value2, "ctrid");
            return (Criteria) this;
        }

        public Criteria andContractnoIsNull() {
            addCriterion("contractNo is null");
            return (Criteria) this;
        }

        public Criteria andContractnoIsNotNull() {
            addCriterion("contractNo is not null");
            return (Criteria) this;
        }

        public Criteria andContractnoEqualTo(String value) {
            addCriterion("contractNo =", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoNotEqualTo(String value) {
            addCriterion("contractNo <>", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoGreaterThan(String value) {
            addCriterion("contractNo >", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoGreaterThanOrEqualTo(String value) {
            addCriterion("contractNo >=", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoLessThan(String value) {
            addCriterion("contractNo <", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoLessThanOrEqualTo(String value) {
            addCriterion("contractNo <=", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoLike(String value) {
            addCriterion("contractNo like", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoNotLike(String value) {
            addCriterion("contractNo not like", value, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoIn(List<String> values) {
            addCriterion("contractNo in", values, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoNotIn(List<String> values) {
            addCriterion("contractNo not in", values, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoBetween(String value1, String value2) {
            addCriterion("contractNo between", value1, value2, "contractno");
            return (Criteria) this;
        }

        public Criteria andContractnoNotBetween(String value1, String value2) {
            addCriterion("contractNo not between", value1, value2, "contractno");
            return (Criteria) this;
        }

        public Criteria andCustidIsNull() {
            addCriterion("custId is null");
            return (Criteria) this;
        }

        public Criteria andCustidIsNotNull() {
            addCriterion("custId is not null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andCustnameIsNull() {
            addCriterion("custName is null");
            return (Criteria) this;
        }

        public Criteria andCustnameIsNotNull() {
            addCriterion("custName is not null");
            return (Criteria) this;
        }

        public Criteria andCustnameEqualTo(String value) {
            addCriterion("custName =", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameNotEqualTo(String value) {
            addCriterion("custName <>", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameGreaterThan(String value) {
            addCriterion("custName >", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameGreaterThanOrEqualTo(String value) {
            addCriterion("custName >=", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameLessThan(String value) {
            addCriterion("custName <", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameLessThanOrEqualTo(String value) {
            addCriterion("custName <=", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameLike(String value) {
            addCriterion("custName like", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameNotLike(String value) {
            addCriterion("custName not like", value, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameIn(List<String> values) {
            addCriterion("custName in", values, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameNotIn(List<String> values) {
            addCriterion("custName not in", values, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameBetween(String value1, String value2) {
            addCriterion("custName between", value1, value2, "custname");
            return (Criteria) this;
        }

        public Criteria andCustnameNotBetween(String value1, String value2) {
            addCriterion("custName not between", value1, value2, "custname");
            return (Criteria) this;
        }

        public Criteria andProidIsNull() {
            addCriterion("proId is null");
            return (Criteria) this;
        }

        public Criteria andProidIsNotNull() {
            addCriterion("proId is not null");
            return (Criteria) this;
        }

        public Criteria andProidEqualTo(String value) {
            addCriterion("proId =", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidNotEqualTo(String value) {
            addCriterion("proId <>", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidGreaterThan(String value) {
            addCriterion("proId >", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidGreaterThanOrEqualTo(String value) {
            addCriterion("proId >=", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidLessThan(String value) {
            addCriterion("proId <", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidLessThanOrEqualTo(String value) {
            addCriterion("proId <=", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidLike(String value) {
            addCriterion("proId like", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidNotLike(String value) {
            addCriterion("proId not like", value, "proid");
            return (Criteria) this;
        }

        public Criteria andProidIn(List<String> values) {
            addCriterion("proId in", values, "proid");
            return (Criteria) this;
        }

        public Criteria andProidNotIn(List<String> values) {
            addCriterion("proId not in", values, "proid");
            return (Criteria) this;
        }

        public Criteria andProidBetween(String value1, String value2) {
            addCriterion("proId between", value1, value2, "proid");
            return (Criteria) this;
        }

        public Criteria andProidNotBetween(String value1, String value2) {
            addCriterion("proId not between", value1, value2, "proid");
            return (Criteria) this;
        }

        public Criteria andPronameIsNull() {
            addCriterion("proName is null");
            return (Criteria) this;
        }

        public Criteria andPronameIsNotNull() {
            addCriterion("proName is not null");
            return (Criteria) this;
        }

        public Criteria andPronameEqualTo(String value) {
            addCriterion("proName =", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameNotEqualTo(String value) {
            addCriterion("proName <>", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameGreaterThan(String value) {
            addCriterion("proName >", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameGreaterThanOrEqualTo(String value) {
            addCriterion("proName >=", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameLessThan(String value) {
            addCriterion("proName <", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameLessThanOrEqualTo(String value) {
            addCriterion("proName <=", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameLike(String value) {
            addCriterion("proName like", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameNotLike(String value) {
            addCriterion("proName not like", value, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameIn(List<String> values) {
            addCriterion("proName in", values, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameNotIn(List<String> values) {
            addCriterion("proName not in", values, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameBetween(String value1, String value2) {
            addCriterion("proName between", value1, value2, "proname");
            return (Criteria) this;
        }

        public Criteria andPronameNotBetween(String value1, String value2) {
            addCriterion("proName not between", value1, value2, "proname");
            return (Criteria) this;
        }

        public Criteria andChargedbyIsNull() {
            addCriterion("chargedBy is null");
            return (Criteria) this;
        }

        public Criteria andChargedbyIsNotNull() {
            addCriterion("chargedBy is not null");
            return (Criteria) this;
        }

        public Criteria andChargedbyEqualTo(String value) {
            addCriterion("chargedBy =", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyNotEqualTo(String value) {
            addCriterion("chargedBy <>", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyGreaterThan(String value) {
            addCriterion("chargedBy >", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyGreaterThanOrEqualTo(String value) {
            addCriterion("chargedBy >=", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyLessThan(String value) {
            addCriterion("chargedBy <", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyLessThanOrEqualTo(String value) {
            addCriterion("chargedBy <=", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyLike(String value) {
            addCriterion("chargedBy like", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyNotLike(String value) {
            addCriterion("chargedBy not like", value, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyIn(List<String> values) {
            addCriterion("chargedBy in", values, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyNotIn(List<String> values) {
            addCriterion("chargedBy not in", values, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyBetween(String value1, String value2) {
            addCriterion("chargedBy between", value1, value2, "chargedby");
            return (Criteria) this;
        }

        public Criteria andChargedbyNotBetween(String value1, String value2) {
            addCriterion("chargedBy not between", value1, value2, "chargedby");
            return (Criteria) this;
        }

        public Criteria andArdateIsNull() {
            addCriterion("arDate is null");
            return (Criteria) this;
        }

        public Criteria andArdateIsNotNull() {
            addCriterion("arDate is not null");
            return (Criteria) this;
        }

        public Criteria andArdateEqualTo(Date value) {
            addCriterionForJDBCDate("arDate =", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateNotEqualTo(Date value) {
            addCriterionForJDBCDate("arDate <>", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateGreaterThan(Date value) {
            addCriterionForJDBCDate("arDate >", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("arDate >=", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateLessThan(Date value) {
            addCriterionForJDBCDate("arDate <", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("arDate <=", value, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateIn(List<Date> values) {
            addCriterionForJDBCDate("arDate in", values, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateNotIn(List<Date> values) {
            addCriterionForJDBCDate("arDate not in", values, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("arDate between", value1, value2, "ardate");
            return (Criteria) this;
        }

        public Criteria andArdateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("arDate not between", value1, value2, "ardate");
            return (Criteria) this;
        }

        public Criteria andAramountIsNull() {
            addCriterion("arAmount is null");
            return (Criteria) this;
        }

        public Criteria andAramountIsNotNull() {
            addCriterion("arAmount is not null");
            return (Criteria) this;
        }

        public Criteria andAramountEqualTo(Double value) {
            addCriterion("arAmount =", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountNotEqualTo(Double value) {
            addCriterion("arAmount <>", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountGreaterThan(Double value) {
            addCriterion("arAmount >", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountGreaterThanOrEqualTo(Double value) {
            addCriterion("arAmount >=", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountLessThan(Double value) {
            addCriterion("arAmount <", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountLessThanOrEqualTo(Double value) {
            addCriterion("arAmount <=", value, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountIn(List<Double> values) {
            addCriterion("arAmount in", values, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountNotIn(List<Double> values) {
            addCriterion("arAmount not in", values, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountBetween(Double value1, Double value2) {
            addCriterion("arAmount between", value1, value2, "aramount");
            return (Criteria) this;
        }

        public Criteria andAramountNotBetween(Double value1, Double value2) {
            addCriterion("arAmount not between", value1, value2, "aramount");
            return (Criteria) this;
        }

        public Criteria andArnameIsNull() {
            addCriterion("arName is null");
            return (Criteria) this;
        }

        public Criteria andArnameIsNotNull() {
            addCriterion("arName is not null");
            return (Criteria) this;
        }

        public Criteria andArnameEqualTo(String value) {
            addCriterion("arName =", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameNotEqualTo(String value) {
            addCriterion("arName <>", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameGreaterThan(String value) {
            addCriterion("arName >", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameGreaterThanOrEqualTo(String value) {
            addCriterion("arName >=", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameLessThan(String value) {
            addCriterion("arName <", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameLessThanOrEqualTo(String value) {
            addCriterion("arName <=", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameLike(String value) {
            addCriterion("arName like", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameNotLike(String value) {
            addCriterion("arName not like", value, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameIn(List<String> values) {
            addCriterion("arName in", values, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameNotIn(List<String> values) {
            addCriterion("arName not in", values, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameBetween(String value1, String value2) {
            addCriterion("arName between", value1, value2, "arname");
            return (Criteria) this;
        }

        public Criteria andArnameNotBetween(String value1, String value2) {
            addCriterion("arName not between", value1, value2, "arname");
            return (Criteria) this;
        }

        public Criteria andReceiptnoIsNull() {
            addCriterion("receiptNo is null");
            return (Criteria) this;
        }

        public Criteria andReceiptnoIsNotNull() {
            addCriterion("receiptNo is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptnoEqualTo(String value) {
            addCriterion("receiptNo =", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoNotEqualTo(String value) {
            addCriterion("receiptNo <>", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoGreaterThan(String value) {
            addCriterion("receiptNo >", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoGreaterThanOrEqualTo(String value) {
            addCriterion("receiptNo >=", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoLessThan(String value) {
            addCriterion("receiptNo <", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoLessThanOrEqualTo(String value) {
            addCriterion("receiptNo <=", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoLike(String value) {
            addCriterion("receiptNo like", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoNotLike(String value) {
            addCriterion("receiptNo not like", value, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoIn(List<String> values) {
            addCriterion("receiptNo in", values, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoNotIn(List<String> values) {
            addCriterion("receiptNo not in", values, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoBetween(String value1, String value2) {
            addCriterion("receiptNo between", value1, value2, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptnoNotBetween(String value1, String value2) {
            addCriterion("receiptNo not between", value1, value2, "receiptno");
            return (Criteria) this;
        }

        public Criteria andReceiptdateIsNull() {
            addCriterion("receiptDate is null");
            return (Criteria) this;
        }

        public Criteria andReceiptdateIsNotNull() {
            addCriterion("receiptDate is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptdateEqualTo(Date value) {
            addCriterion("receiptDate =", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateNotEqualTo(Date value) {
            addCriterion("receiptDate <>", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateGreaterThan(Date value) {
            addCriterion("receiptDate >", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateGreaterThanOrEqualTo(Date value) {
            addCriterion("receiptDate >=", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateLessThan(Date value) {
            addCriterion("receiptDate <", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateLessThanOrEqualTo(Date value) {
            addCriterion("receiptDate <=", value, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateIn(List<Date> values) {
            addCriterion("receiptDate in", values, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateNotIn(List<Date> values) {
            addCriterion("receiptDate not in", values, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateBetween(Date value1, Date value2) {
            addCriterion("receiptDate between", value1, value2, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptdateNotBetween(Date value1, Date value2) {
            addCriterion("receiptDate not between", value1, value2, "receiptdate");
            return (Criteria) this;
        }

        public Criteria andReceiptamountIsNull() {
            addCriterion("receiptAmount is null");
            return (Criteria) this;
        }

        public Criteria andReceiptamountIsNotNull() {
            addCriterion("receiptAmount is not null");
            return (Criteria) this;
        }

        public Criteria andReceiptamountEqualTo(Double value) {
            addCriterion("receiptAmount =", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountNotEqualTo(Double value) {
            addCriterion("receiptAmount <>", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountGreaterThan(Double value) {
            addCriterion("receiptAmount >", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountGreaterThanOrEqualTo(Double value) {
            addCriterion("receiptAmount >=", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountLessThan(Double value) {
            addCriterion("receiptAmount <", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountLessThanOrEqualTo(Double value) {
            addCriterion("receiptAmount <=", value, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountIn(List<Double> values) {
            addCriterion("receiptAmount in", values, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountNotIn(List<Double> values) {
            addCriterion("receiptAmount not in", values, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountBetween(Double value1, Double value2) {
            addCriterion("receiptAmount between", value1, value2, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceiptamountNotBetween(Double value1, Double value2) {
            addCriterion("receiptAmount not between", value1, value2, "receiptamount");
            return (Criteria) this;
        }

        public Criteria andReceivedateIsNull() {
            addCriterion("receiveDate is null");
            return (Criteria) this;
        }

        public Criteria andReceivedateIsNotNull() {
            addCriterion("receiveDate is not null");
            return (Criteria) this;
        }

        public Criteria andReceivedateEqualTo(Date value) {
            addCriterion("receiveDate =", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateNotEqualTo(Date value) {
            addCriterion("receiveDate <>", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateGreaterThan(Date value) {
            addCriterion("receiveDate >", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateGreaterThanOrEqualTo(Date value) {
            addCriterion("receiveDate >=", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateLessThan(Date value) {
            addCriterion("receiveDate <", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateLessThanOrEqualTo(Date value) {
            addCriterion("receiveDate <=", value, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateIn(List<Date> values) {
            addCriterion("receiveDate in", values, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateNotIn(List<Date> values) {
            addCriterion("receiveDate not in", values, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateBetween(Date value1, Date value2) {
            addCriterion("receiveDate between", value1, value2, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceivedateNotBetween(Date value1, Date value2) {
            addCriterion("receiveDate not between", value1, value2, "receivedate");
            return (Criteria) this;
        }

        public Criteria andReceiveamountIsNull() {
            addCriterion("receiveAmount is null");
            return (Criteria) this;
        }

        public Criteria andReceiveamountIsNotNull() {
            addCriterion("receiveAmount is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveamountEqualTo(Double value) {
            addCriterion("receiveAmount =", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountNotEqualTo(Double value) {
            addCriterion("receiveAmount <>", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountGreaterThan(Double value) {
            addCriterion("receiveAmount >", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountGreaterThanOrEqualTo(Double value) {
            addCriterion("receiveAmount >=", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountLessThan(Double value) {
            addCriterion("receiveAmount <", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountLessThanOrEqualTo(Double value) {
            addCriterion("receiveAmount <=", value, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountIn(List<Double> values) {
            addCriterion("receiveAmount in", values, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountNotIn(List<Double> values) {
            addCriterion("receiveAmount not in", values, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountBetween(Double value1, Double value2) {
            addCriterion("receiveAmount between", value1, value2, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andReceiveamountNotBetween(Double value1, Double value2) {
            addCriterion("receiveAmount not between", value1, value2, "receiveamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountIsNull() {
            addCriterion("adjustAmount is null");
            return (Criteria) this;
        }

        public Criteria andAdjustamountIsNotNull() {
            addCriterion("adjustAmount is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustamountEqualTo(Double value) {
            addCriterion("adjustAmount =", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountNotEqualTo(Double value) {
            addCriterion("adjustAmount <>", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountGreaterThan(Double value) {
            addCriterion("adjustAmount >", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountGreaterThanOrEqualTo(Double value) {
            addCriterion("adjustAmount >=", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountLessThan(Double value) {
            addCriterion("adjustAmount <", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountLessThanOrEqualTo(Double value) {
            addCriterion("adjustAmount <=", value, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountIn(List<Double> values) {
            addCriterion("adjustAmount in", values, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountNotIn(List<Double> values) {
            addCriterion("adjustAmount not in", values, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountBetween(Double value1, Double value2) {
            addCriterion("adjustAmount between", value1, value2, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andAdjustamountNotBetween(Double value1, Double value2) {
            addCriterion("adjustAmount not between", value1, value2, "adjustamount");
            return (Criteria) this;
        }

        public Criteria andDealedbyIsNull() {
            addCriterion("dealedBy is null");
            return (Criteria) this;
        }

        public Criteria andDealedbyIsNotNull() {
            addCriterion("dealedBy is not null");
            return (Criteria) this;
        }

        public Criteria andDealedbyEqualTo(String value) {
            addCriterion("dealedBy =", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyNotEqualTo(String value) {
            addCriterion("dealedBy <>", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyGreaterThan(String value) {
            addCriterion("dealedBy >", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyGreaterThanOrEqualTo(String value) {
            addCriterion("dealedBy >=", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyLessThan(String value) {
            addCriterion("dealedBy <", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyLessThanOrEqualTo(String value) {
            addCriterion("dealedBy <=", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyLike(String value) {
            addCriterion("dealedBy like", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyNotLike(String value) {
            addCriterion("dealedBy not like", value, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyIn(List<String> values) {
            addCriterion("dealedBy in", values, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyNotIn(List<String> values) {
            addCriterion("dealedBy not in", values, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyBetween(String value1, String value2) {
            addCriterion("dealedBy between", value1, value2, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedbyNotBetween(String value1, String value2) {
            addCriterion("dealedBy not between", value1, value2, "dealedby");
            return (Criteria) this;
        }

        public Criteria andDealedatIsNull() {
            addCriterion("dealedAt is null");
            return (Criteria) this;
        }

        public Criteria andDealedatIsNotNull() {
            addCriterion("dealedAt is not null");
            return (Criteria) this;
        }

        public Criteria andDealedatEqualTo(Date value) {
            addCriterion("dealedAt =", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatNotEqualTo(Date value) {
            addCriterion("dealedAt <>", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatGreaterThan(Date value) {
            addCriterion("dealedAt >", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatGreaterThanOrEqualTo(Date value) {
            addCriterion("dealedAt >=", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatLessThan(Date value) {
            addCriterion("dealedAt <", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatLessThanOrEqualTo(Date value) {
            addCriterion("dealedAt <=", value, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatIn(List<Date> values) {
            addCriterion("dealedAt in", values, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatNotIn(List<Date> values) {
            addCriterion("dealedAt not in", values, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatBetween(Date value1, Date value2) {
            addCriterion("dealedAt between", value1, value2, "dealedat");
            return (Criteria) this;
        }

        public Criteria andDealedatNotBetween(Date value1, Date value2) {
            addCriterion("dealedAt not between", value1, value2, "dealedat");
            return (Criteria) this;
        }

        public Criteria andNoticedateIsNull() {
            addCriterion("noticeDate is null");
            return (Criteria) this;
        }

        public Criteria andNoticedateIsNotNull() {
            addCriterion("noticeDate is not null");
            return (Criteria) this;
        }

        public Criteria andNoticedateEqualTo(Date value) {
            addCriterionForJDBCDate("noticeDate =", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateNotEqualTo(Date value) {
            addCriterionForJDBCDate("noticeDate <>", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateGreaterThan(Date value) {
            addCriterionForJDBCDate("noticeDate >", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("noticeDate >=", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateLessThan(Date value) {
            addCriterionForJDBCDate("noticeDate <", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("noticeDate <=", value, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateIn(List<Date> values) {
            addCriterionForJDBCDate("noticeDate in", values, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateNotIn(List<Date> values) {
            addCriterionForJDBCDate("noticeDate not in", values, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("noticeDate between", value1, value2, "noticedate");
            return (Criteria) this;
        }

        public Criteria andNoticedateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("noticeDate not between", value1, value2, "noticedate");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyIsNull() {
            addCriterion("updatedBy is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyIsNotNull() {
            addCriterion("updatedBy is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyEqualTo(String value) {
            addCriterion("updatedBy =", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyNotEqualTo(String value) {
            addCriterion("updatedBy <>", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyGreaterThan(String value) {
            addCriterion("updatedBy >", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyGreaterThanOrEqualTo(String value) {
            addCriterion("updatedBy >=", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyLessThan(String value) {
            addCriterion("updatedBy <", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyLessThanOrEqualTo(String value) {
            addCriterion("updatedBy <=", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyLike(String value) {
            addCriterion("updatedBy like", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyNotLike(String value) {
            addCriterion("updatedBy not like", value, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyIn(List<String> values) {
            addCriterion("updatedBy in", values, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyNotIn(List<String> values) {
            addCriterion("updatedBy not in", values, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyBetween(String value1, String value2) {
            addCriterion("updatedBy between", value1, value2, "updatedby");
            return (Criteria) this;
        }

        public Criteria andUpdatedbyNotBetween(String value1, String value2) {
            addCriterion("updatedBy not between", value1, value2, "updatedby");
            return (Criteria) this;
        }

        public Criteria andCreatedatIsNull() {
            addCriterion("createdAt is null");
            return (Criteria) this;
        }

        public Criteria andCreatedatIsNotNull() {
            addCriterion("createdAt is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedatEqualTo(Date value) {
            addCriterion("createdAt =", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatNotEqualTo(Date value) {
            addCriterion("createdAt <>", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatGreaterThan(Date value) {
            addCriterion("createdAt >", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatGreaterThanOrEqualTo(Date value) {
            addCriterion("createdAt >=", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatLessThan(Date value) {
            addCriterion("createdAt <", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatLessThanOrEqualTo(Date value) {
            addCriterion("createdAt <=", value, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatIn(List<Date> values) {
            addCriterion("createdAt in", values, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatNotIn(List<Date> values) {
            addCriterion("createdAt not in", values, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatBetween(Date value1, Date value2) {
            addCriterion("createdAt between", value1, value2, "createdat");
            return (Criteria) this;
        }

        public Criteria andCreatedatNotBetween(Date value1, Date value2) {
            addCriterion("createdAt not between", value1, value2, "createdat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatIsNull() {
            addCriterion("updatedAt is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedatIsNotNull() {
            addCriterion("updatedAt is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedatEqualTo(Date value) {
            addCriterion("updatedAt =", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatNotEqualTo(Date value) {
            addCriterion("updatedAt <>", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatGreaterThan(Date value) {
            addCriterion("updatedAt >", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatGreaterThanOrEqualTo(Date value) {
            addCriterion("updatedAt >=", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatLessThan(Date value) {
            addCriterion("updatedAt <", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatLessThanOrEqualTo(Date value) {
            addCriterion("updatedAt <=", value, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatIn(List<Date> values) {
            addCriterion("updatedAt in", values, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatNotIn(List<Date> values) {
            addCriterion("updatedAt not in", values, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatBetween(Date value1, Date value2) {
            addCriterion("updatedAt between", value1, value2, "updatedat");
            return (Criteria) this;
        }

        public Criteria andUpdatedatNotBetween(Date value1, Date value2) {
            addCriterion("updatedAt not between", value1, value2, "updatedat");
            return (Criteria) this;
        }

        public Criteria andSysIdIsNull() {
            addCriterion("sys_id is null");
            return (Criteria) this;
        }

        public Criteria andSysIdIsNotNull() {
            addCriterion("sys_id is not null");
            return (Criteria) this;
        }

        public Criteria andSysIdEqualTo(String value) {
            addCriterion("sys_id =", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotEqualTo(String value) {
            addCriterion("sys_id <>", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdGreaterThan(String value) {
            addCriterion("sys_id >", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdGreaterThanOrEqualTo(String value) {
            addCriterion("sys_id >=", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLessThan(String value) {
            addCriterion("sys_id <", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLessThanOrEqualTo(String value) {
            addCriterion("sys_id <=", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLike(String value) {
            addCriterion("sys_id like", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotLike(String value) {
            addCriterion("sys_id not like", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdIn(List<String> values) {
            addCriterion("sys_id in", values, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotIn(List<String> values) {
            addCriterion("sys_id not in", values, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdBetween(String value1, String value2) {
            addCriterion("sys_id between", value1, value2, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotBetween(String value1, String value2) {
            addCriterion("sys_id not between", value1, value2, "sysId");
            return (Criteria) this;
        }

        public Criteria andDeliverymethodIsNull() {
            addCriterion("deliverymethod is null");
            return (Criteria) this;
        }

        public Criteria andDeliverymethodIsNotNull() {
            addCriterion("deliverymethod is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverymethodEqualTo(String value) {
            addCriterion("deliverymethod =", value, "deliverymethod");
            return (Criteria) this;
        }

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

        public Criteria andDeliverymethodGreaterThan(String value) {
            addCriterion("deliverymethod >", value, "deliverymethod");
            return (Criteria) this;
        }

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

        public Criteria andDeliverymethodLessThan(String value) {
            addCriterion("deliverymethod <", value, "deliverymethod");
            return (Criteria) this;
        }

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

        public Criteria andDeliverymethodLike(String value) {
            addCriterion("deliverymethod like", value, "deliverymethod");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andDeliverydateIsNull() {
            addCriterion("deliverydate is null");
            return (Criteria) this;
        }

        public Criteria andDeliverydateIsNotNull() {
            addCriterion("deliverydate is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverydateEqualTo(Date value) {
            addCriterion("deliverydate =", value, "deliverydate");
            return (Criteria) this;
        }

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

        public Criteria andDeliverydateGreaterThan(Date value) {
            addCriterion("deliverydate >", value, "deliverydate");
            return (Criteria) this;
        }

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

        public Criteria andDeliverydateLessThan(Date value) {
            addCriterion("deliverydate <", value, "deliverydate");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andReceiveuserIsNull() {
            addCriterion("receiveuser is null");
            return (Criteria) this;
        }

        public Criteria andReceiveuserIsNotNull() {
            addCriterion("receiveuser is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveuserEqualTo(String value) {
            addCriterion("receiveuser =", value, "receiveuser");
            return (Criteria) this;
        }

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

        public Criteria andReceiveuserGreaterThan(String value) {
            addCriterion("receiveuser >", value, "receiveuser");
            return (Criteria) this;
        }

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

        public Criteria andReceiveuserLessThan(String value) {
            addCriterion("receiveuser <", value, "receiveuser");
            return (Criteria) this;
        }

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

        public Criteria andReceiveuserLike(String value) {
            addCriterion("receiveuser like", value, "receiveuser");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andSupplementIsNull() {
            addCriterion("supplement is null");
            return (Criteria) this;
        }

        public Criteria andSupplementIsNotNull() {
            addCriterion("supplement is not null");
            return (Criteria) this;
        }

        public Criteria andSupplementEqualTo(String value) {
            addCriterion("supplement =", value, "supplement");
            return (Criteria) this;
        }

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

        public Criteria andSupplementGreaterThan(String value) {
            addCriterion("supplement >", value, "supplement");
            return (Criteria) this;
        }

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

        public Criteria andSupplementLessThan(String value) {
            addCriterion("supplement <", value, "supplement");
            return (Criteria) this;
        }

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

        public Criteria andSupplementLike(String value) {
            addCriterion("supplement like", value, "supplement");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andPaymentmethodLike(String value) {
            addCriterion("paymentmethod like", value, "paymentmethod");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andOthermethodIsNull() {
            addCriterion("othermethod is null");
            return (Criteria) this;
        }

        public Criteria andOthermethodIsNotNull() {
            addCriterion("othermethod is not null");
            return (Criteria) this;
        }

        public Criteria andOthermethodEqualTo(String value) {
            addCriterion("othermethod =", value, "othermethod");
            return (Criteria) this;
        }

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

        public Criteria andOthermethodGreaterThan(String value) {
            addCriterion("othermethod >", value, "othermethod");
            return (Criteria) this;
        }

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

        public Criteria andOthermethodLessThan(String value) {
            addCriterion("othermethod <", value, "othermethod");
            return (Criteria) this;
        }

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

        public Criteria andOthermethodLike(String value) {
            addCriterion("othermethod like", value, "othermethod");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andCashamountIsNull() {
            addCriterion("cashamount is null");
            return (Criteria) this;
        }

        public Criteria andCashamountIsNotNull() {
            addCriterion("cashamount is not null");
            return (Criteria) this;
        }

        public Criteria andCashamountEqualTo(Double value) {
            addCriterion("cashamount =", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountNotEqualTo(Double value) {
            addCriterion("cashamount <>", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountGreaterThan(Double value) {
            addCriterion("cashamount >", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountGreaterThanOrEqualTo(Double value) {
            addCriterion("cashamount >=", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountLessThan(Double value) {
            addCriterion("cashamount <", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountLessThanOrEqualTo(Double value) {
            addCriterion("cashamount <=", value, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountIn(List<Double> values) {
            addCriterion("cashamount in", values, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountNotIn(List<Double> values) {
            addCriterion("cashamount not in", values, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountBetween(Double value1, Double value2) {
            addCriterion("cashamount between", value1, value2, "cashamount");
            return (Criteria) this;
        }

        public Criteria andCashamountNotBetween(Double value1, Double value2) {
            addCriterion("cashamount not between", value1, value2, "cashamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountIsNull() {
            addCriterion("telegraphicamount is null");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountIsNotNull() {
            addCriterion("telegraphicamount is not null");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountEqualTo(Double value) {
            addCriterion("telegraphicamount =", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountNotEqualTo(Double value) {
            addCriterion("telegraphicamount <>", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountGreaterThan(Double value) {
            addCriterion("telegraphicamount >", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountGreaterThanOrEqualTo(Double value) {
            addCriterion("telegraphicamount >=", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountLessThan(Double value) {
            addCriterion("telegraphicamount <", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountLessThanOrEqualTo(Double value) {
            addCriterion("telegraphicamount <=", value, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountIn(List<Double> values) {
            addCriterion("telegraphicamount in", values, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountNotIn(List<Double> values) {
            addCriterion("telegraphicamount not in", values, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountBetween(Double value1, Double value2) {
            addCriterion("telegraphicamount between", value1, value2, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andTelegraphicamountNotBetween(Double value1, Double value2) {
            addCriterion("telegraphicamount not between", value1, value2, "telegraphicamount");
            return (Criteria) this;
        }

        public Criteria andOtheramountIsNull() {
            addCriterion("otheramount is null");
            return (Criteria) this;
        }

        public Criteria andOtheramountIsNotNull() {
            addCriterion("otheramount is not null");
            return (Criteria) this;
        }

        public Criteria andOtheramountEqualTo(Double value) {
            addCriterion("otheramount =", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountNotEqualTo(Double value) {
            addCriterion("otheramount <>", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountGreaterThan(Double value) {
            addCriterion("otheramount >", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountGreaterThanOrEqualTo(Double value) {
            addCriterion("otheramount >=", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountLessThan(Double value) {
            addCriterion("otheramount <", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountLessThanOrEqualTo(Double value) {
            addCriterion("otheramount <=", value, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountIn(List<Double> values) {
            addCriterion("otheramount in", values, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountNotIn(List<Double> values) {
            addCriterion("otheramount not in", values, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountBetween(Double value1, Double value2) {
            addCriterion("otheramount between", value1, value2, "otheramount");
            return (Criteria) this;
        }

        public Criteria andOtheramountNotBetween(Double value1, Double value2) {
            addCriterion("otheramount not between", value1, value2, "otheramount");
            return (Criteria) this;
        }

        public Criteria andAdjustuserIsNull() {
            addCriterion("adjustuser is null");
            return (Criteria) this;
        }

        public Criteria andAdjustuserIsNotNull() {
            addCriterion("adjustuser is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustuserEqualTo(String value) {
            addCriterion("adjustuser =", value, "adjustuser");
            return (Criteria) this;
        }

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

        public Criteria andAdjustuserGreaterThan(String value) {
            addCriterion("adjustuser >", value, "adjustuser");
            return (Criteria) this;
        }

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

        public Criteria andAdjustuserLessThan(String value) {
            addCriterion("adjustuser <", value, "adjustuser");
            return (Criteria) this;
        }

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

        public Criteria andAdjustuserLike(String value) {
            addCriterion("adjustuser like", value, "adjustuser");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andGroupIdIsNull() {
            addCriterion("group_id is null");
            return (Criteria) this;
        }

        public Criteria andGroupIdIsNotNull() {
            addCriterion("group_id is not null");
            return (Criteria) this;
        }

        public Criteria andGroupIdEqualTo(String value) {
            addCriterion("group_id =", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotEqualTo(String value) {
            addCriterion("group_id <>", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdGreaterThan(String value) {
            addCriterion("group_id >", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdGreaterThanOrEqualTo(String value) {
            addCriterion("group_id >=", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdLessThan(String value) {
            addCriterion("group_id <", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdLessThanOrEqualTo(String value) {
            addCriterion("group_id <=", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdLike(String value) {
            addCriterion("group_id like", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotLike(String value) {
            addCriterion("group_id not like", value, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdIn(List<String> values) {
            addCriterion("group_id in", values, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotIn(List<String> values) {
            addCriterion("group_id not in", values, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdBetween(String value1, String value2) {
            addCriterion("group_id between", value1, value2, "groupId");
            return (Criteria) this;
        }

        public Criteria andGroupIdNotBetween(String value1, String value2) {
            addCriterion("group_id not between", value1, value2, "groupId");
            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);
        }
    }
}