BJ_ZTEITS-Developers / parking-cloud

package com.zteits.park.domain;

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

public class TpPTgsPassedcarExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TpPTgsPassedcarExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

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

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

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andNidIsNull() {
            addCriterion("NID is null");
            return (Criteria) this;
        }

        public Criteria andNidIsNotNull() {
            addCriterion("NID is not null");
            return (Criteria) this;
        }

        public Criteria andNidEqualTo(Integer value) {
            addCriterion("NID =", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidNotEqualTo(Integer value) {
            addCriterion("NID <>", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidGreaterThan(Integer value) {
            addCriterion("NID >", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidGreaterThanOrEqualTo(Integer value) {
            addCriterion("NID >=", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidLessThan(Integer value) {
            addCriterion("NID <", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidLessThanOrEqualTo(Integer value) {
            addCriterion("NID <=", value, "nid");
            return (Criteria) this;
        }

        public Criteria andNidIn(List<Integer> values) {
            addCriterion("NID in", values, "nid");
            return (Criteria) this;
        }

        public Criteria andNidNotIn(List<Integer> values) {
            addCriterion("NID not in", values, "nid");
            return (Criteria) this;
        }

        public Criteria andNidBetween(Integer value1, Integer value2) {
            addCriterion("NID between", value1, value2, "nid");
            return (Criteria) this;
        }

        public Criteria andNidNotBetween(Integer value1, Integer value2) {
            addCriterion("NID not between", value1, value2, "nid");
            return (Criteria) this;
        }

        public Criteria andClicensetypeIsNull() {
            addCriterion("CLICENSETYPE is null");
            return (Criteria) this;
        }

        public Criteria andClicensetypeIsNotNull() {
            addCriterion("CLICENSETYPE is not null");
            return (Criteria) this;
        }

        public Criteria andClicensetypeEqualTo(String value) {
            addCriterion("CLICENSETYPE =", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeNotEqualTo(String value) {
            addCriterion("CLICENSETYPE <>", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeGreaterThan(String value) {
            addCriterion("CLICENSETYPE >", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeGreaterThanOrEqualTo(String value) {
            addCriterion("CLICENSETYPE >=", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeLessThan(String value) {
            addCriterion("CLICENSETYPE <", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeLessThanOrEqualTo(String value) {
            addCriterion("CLICENSETYPE <=", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeLike(String value) {
            addCriterion("CLICENSETYPE like", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeNotLike(String value) {
            addCriterion("CLICENSETYPE not like", value, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeIn(List<String> values) {
            addCriterion("CLICENSETYPE in", values, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeNotIn(List<String> values) {
            addCriterion("CLICENSETYPE not in", values, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeBetween(String value1, String value2) {
            addCriterion("CLICENSETYPE between", value1, value2, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andClicensetypeNotBetween(String value1, String value2) {
            addCriterion("CLICENSETYPE not between", value1, value2, "clicensetype");
            return (Criteria) this;
        }

        public Criteria andCcarnumberIsNull() {
            addCriterion("CCARNUMBER is null");
            return (Criteria) this;
        }

        public Criteria andCcarnumberIsNotNull() {
            addCriterion("CCARNUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andCcarnumberEqualTo(String value) {
            addCriterion("CCARNUMBER =", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberNotEqualTo(String value) {
            addCriterion("CCARNUMBER <>", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberGreaterThan(String value) {
            addCriterion("CCARNUMBER >", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberGreaterThanOrEqualTo(String value) {
            addCriterion("CCARNUMBER >=", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberLessThan(String value) {
            addCriterion("CCARNUMBER <", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberLessThanOrEqualTo(String value) {
            addCriterion("CCARNUMBER <=", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberLike(String value) {
            addCriterion("CCARNUMBER like", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberNotLike(String value) {
            addCriterion("CCARNUMBER not like", value, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberIn(List<String> values) {
            addCriterion("CCARNUMBER in", values, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberNotIn(List<String> values) {
            addCriterion("CCARNUMBER not in", values, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberBetween(String value1, String value2) {
            addCriterion("CCARNUMBER between", value1, value2, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andCcarnumberNotBetween(String value1, String value2) {
            addCriterion("CCARNUMBER not between", value1, value2, "ccarnumber");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateIsNull() {
            addCriterion("DCOLLECTIONDATE is null");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateIsNotNull() {
            addCriterion("DCOLLECTIONDATE is not null");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateEqualTo(Date value) {
            addCriterion("DCOLLECTIONDATE =", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateNotEqualTo(Date value) {
            addCriterion("DCOLLECTIONDATE <>", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateGreaterThan(Date value) {
            addCriterion("DCOLLECTIONDATE >", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateGreaterThanOrEqualTo(Date value) {
            addCriterion("DCOLLECTIONDATE >=", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateLessThan(Date value) {
            addCriterion("DCOLLECTIONDATE <", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateLessThanOrEqualTo(Date value) {
            addCriterion("DCOLLECTIONDATE <=", value, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateIn(List<Date> values) {
            addCriterion("DCOLLECTIONDATE in", values, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateNotIn(List<Date> values) {
            addCriterion("DCOLLECTIONDATE not in", values, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateBetween(Date value1, Date value2) {
            addCriterion("DCOLLECTIONDATE between", value1, value2, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andDcollectiondateNotBetween(Date value1, Date value2) {
            addCriterion("DCOLLECTIONDATE not between", value1, value2, "dcollectiondate");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeIsNull() {
            addCriterion("CADDRESSCODE is null");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeIsNotNull() {
            addCriterion("CADDRESSCODE is not null");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeEqualTo(String value) {
            addCriterion("CADDRESSCODE =", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeNotEqualTo(String value) {
            addCriterion("CADDRESSCODE <>", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeGreaterThan(String value) {
            addCriterion("CADDRESSCODE >", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeGreaterThanOrEqualTo(String value) {
            addCriterion("CADDRESSCODE >=", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeLessThan(String value) {
            addCriterion("CADDRESSCODE <", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeLessThanOrEqualTo(String value) {
            addCriterion("CADDRESSCODE <=", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeLike(String value) {
            addCriterion("CADDRESSCODE like", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeNotLike(String value) {
            addCriterion("CADDRESSCODE not like", value, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeIn(List<String> values) {
            addCriterion("CADDRESSCODE in", values, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeNotIn(List<String> values) {
            addCriterion("CADDRESSCODE not in", values, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeBetween(String value1, String value2) {
            addCriterion("CADDRESSCODE between", value1, value2, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCaddresscodeNotBetween(String value1, String value2) {
            addCriterion("CADDRESSCODE not between", value1, value2, "caddresscode");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressIsNull() {
            addCriterion("CCOLLECTIONADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressIsNotNull() {
            addCriterion("CCOLLECTIONADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressEqualTo(String value) {
            addCriterion("CCOLLECTIONADDRESS =", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressNotEqualTo(String value) {
            addCriterion("CCOLLECTIONADDRESS <>", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressGreaterThan(String value) {
            addCriterion("CCOLLECTIONADDRESS >", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressGreaterThanOrEqualTo(String value) {
            addCriterion("CCOLLECTIONADDRESS >=", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressLessThan(String value) {
            addCriterion("CCOLLECTIONADDRESS <", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressLessThanOrEqualTo(String value) {
            addCriterion("CCOLLECTIONADDRESS <=", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressLike(String value) {
            addCriterion("CCOLLECTIONADDRESS like", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressNotLike(String value) {
            addCriterion("CCOLLECTIONADDRESS not like", value, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressIn(List<String> values) {
            addCriterion("CCOLLECTIONADDRESS in", values, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressNotIn(List<String> values) {
            addCriterion("CCOLLECTIONADDRESS not in", values, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressBetween(String value1, String value2) {
            addCriterion("CCOLLECTIONADDRESS between", value1, value2, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionaddressNotBetween(String value1, String value2) {
            addCriterion("CCOLLECTIONADDRESS not between", value1, value2, "ccollectionaddress");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesIsNull() {
            addCriterion("CCOLLECTIONAGENCIES is null");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesIsNotNull() {
            addCriterion("CCOLLECTIONAGENCIES is not null");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesEqualTo(String value) {
            addCriterion("CCOLLECTIONAGENCIES =", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesNotEqualTo(String value) {
            addCriterion("CCOLLECTIONAGENCIES <>", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesGreaterThan(String value) {
            addCriterion("CCOLLECTIONAGENCIES >", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesGreaterThanOrEqualTo(String value) {
            addCriterion("CCOLLECTIONAGENCIES >=", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesLessThan(String value) {
            addCriterion("CCOLLECTIONAGENCIES <", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesLessThanOrEqualTo(String value) {
            addCriterion("CCOLLECTIONAGENCIES <=", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesLike(String value) {
            addCriterion("CCOLLECTIONAGENCIES like", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesNotLike(String value) {
            addCriterion("CCOLLECTIONAGENCIES not like", value, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesIn(List<String> values) {
            addCriterion("CCOLLECTIONAGENCIES in", values, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesNotIn(List<String> values) {
            addCriterion("CCOLLECTIONAGENCIES not in", values, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesBetween(String value1, String value2) {
            addCriterion("CCOLLECTIONAGENCIES between", value1, value2, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCcollectionagenciesNotBetween(String value1, String value2) {
            addCriterion("CCOLLECTIONAGENCIES not between", value1, value2, "ccollectionagencies");
            return (Criteria) this;
        }

        public Criteria andCdatasourceIsNull() {
            addCriterion("CDATASOURCE is null");
            return (Criteria) this;
        }

        public Criteria andCdatasourceIsNotNull() {
            addCriterion("CDATASOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andCdatasourceEqualTo(String value) {
            addCriterion("CDATASOURCE =", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceNotEqualTo(String value) {
            addCriterion("CDATASOURCE <>", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceGreaterThan(String value) {
            addCriterion("CDATASOURCE >", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceGreaterThanOrEqualTo(String value) {
            addCriterion("CDATASOURCE >=", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceLessThan(String value) {
            addCriterion("CDATASOURCE <", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceLessThanOrEqualTo(String value) {
            addCriterion("CDATASOURCE <=", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceLike(String value) {
            addCriterion("CDATASOURCE like", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceNotLike(String value) {
            addCriterion("CDATASOURCE not like", value, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceIn(List<String> values) {
            addCriterion("CDATASOURCE in", values, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceNotIn(List<String> values) {
            addCriterion("CDATASOURCE not in", values, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceBetween(String value1, String value2) {
            addCriterion("CDATASOURCE between", value1, value2, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCdatasourceNotBetween(String value1, String value2) {
            addCriterion("CDATASOURCE not between", value1, value2, "cdatasource");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeIsNull() {
            addCriterion("CSNAPTYPE is null");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeIsNotNull() {
            addCriterion("CSNAPTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeEqualTo(String value) {
            addCriterion("CSNAPTYPE =", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeNotEqualTo(String value) {
            addCriterion("CSNAPTYPE <>", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeGreaterThan(String value) {
            addCriterion("CSNAPTYPE >", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeGreaterThanOrEqualTo(String value) {
            addCriterion("CSNAPTYPE >=", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeLessThan(String value) {
            addCriterion("CSNAPTYPE <", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeLessThanOrEqualTo(String value) {
            addCriterion("CSNAPTYPE <=", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeLike(String value) {
            addCriterion("CSNAPTYPE like", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeNotLike(String value) {
            addCriterion("CSNAPTYPE not like", value, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeIn(List<String> values) {
            addCriterion("CSNAPTYPE in", values, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeNotIn(List<String> values) {
            addCriterion("CSNAPTYPE not in", values, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeBetween(String value1, String value2) {
            addCriterion("CSNAPTYPE between", value1, value2, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCsnaptypeNotBetween(String value1, String value2) {
            addCriterion("CSNAPTYPE not between", value1, value2, "csnaptype");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeIsNull() {
            addCriterion("CDEVICECODE is null");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeIsNotNull() {
            addCriterion("CDEVICECODE is not null");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeEqualTo(String value) {
            addCriterion("CDEVICECODE =", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeNotEqualTo(String value) {
            addCriterion("CDEVICECODE <>", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeGreaterThan(String value) {
            addCriterion("CDEVICECODE >", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeGreaterThanOrEqualTo(String value) {
            addCriterion("CDEVICECODE >=", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeLessThan(String value) {
            addCriterion("CDEVICECODE <", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeLessThanOrEqualTo(String value) {
            addCriterion("CDEVICECODE <=", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeLike(String value) {
            addCriterion("CDEVICECODE like", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeNotLike(String value) {
            addCriterion("CDEVICECODE not like", value, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeIn(List<String> values) {
            addCriterion("CDEVICECODE in", values, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeNotIn(List<String> values) {
            addCriterion("CDEVICECODE not in", values, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeBetween(String value1, String value2) {
            addCriterion("CDEVICECODE between", value1, value2, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andCdevicecodeNotBetween(String value1, String value2) {
            addCriterion("CDEVICECODE not between", value1, value2, "cdevicecode");
            return (Criteria) this;
        }

        public Criteria andClanenumberIsNull() {
            addCriterion("CLANENUMBER is null");
            return (Criteria) this;
        }

        public Criteria andClanenumberIsNotNull() {
            addCriterion("CLANENUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andClanenumberEqualTo(String value) {
            addCriterion("CLANENUMBER =", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberNotEqualTo(String value) {
            addCriterion("CLANENUMBER <>", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberGreaterThan(String value) {
            addCriterion("CLANENUMBER >", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberGreaterThanOrEqualTo(String value) {
            addCriterion("CLANENUMBER >=", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberLessThan(String value) {
            addCriterion("CLANENUMBER <", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberLessThanOrEqualTo(String value) {
            addCriterion("CLANENUMBER <=", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberLike(String value) {
            addCriterion("CLANENUMBER like", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberNotLike(String value) {
            addCriterion("CLANENUMBER not like", value, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberIn(List<String> values) {
            addCriterion("CLANENUMBER in", values, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberNotIn(List<String> values) {
            addCriterion("CLANENUMBER not in", values, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberBetween(String value1, String value2) {
            addCriterion("CLANENUMBER between", value1, value2, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andClanenumberNotBetween(String value1, String value2) {
            addCriterion("CLANENUMBER not between", value1, value2, "clanenumber");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedIsNull() {
            addCriterion("NVEHICLESPEED is null");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedIsNotNull() {
            addCriterion("NVEHICLESPEED is not null");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedEqualTo(Integer value) {
            addCriterion("NVEHICLESPEED =", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedNotEqualTo(Integer value) {
            addCriterion("NVEHICLESPEED <>", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedGreaterThan(Integer value) {
            addCriterion("NVEHICLESPEED >", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedGreaterThanOrEqualTo(Integer value) {
            addCriterion("NVEHICLESPEED >=", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedLessThan(Integer value) {
            addCriterion("NVEHICLESPEED <", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedLessThanOrEqualTo(Integer value) {
            addCriterion("NVEHICLESPEED <=", value, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedIn(List<Integer> values) {
            addCriterion("NVEHICLESPEED in", values, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedNotIn(List<Integer> values) {
            addCriterion("NVEHICLESPEED not in", values, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedBetween(Integer value1, Integer value2) {
            addCriterion("NVEHICLESPEED between", value1, value2, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andNvehiclespeedNotBetween(Integer value1, Integer value2) {
            addCriterion("NVEHICLESPEED not between", value1, value2, "nvehiclespeed");
            return (Criteria) this;
        }

        public Criteria andCpic1pathIsNull() {
            addCriterion("CPIC1PATH is null");
            return (Criteria) this;
        }

        public Criteria andCpic1pathIsNotNull() {
            addCriterion("CPIC1PATH is not null");
            return (Criteria) this;
        }

        public Criteria andCpic1pathEqualTo(String value) {
            addCriterion("CPIC1PATH =", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathNotEqualTo(String value) {
            addCriterion("CPIC1PATH <>", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathGreaterThan(String value) {
            addCriterion("CPIC1PATH >", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathGreaterThanOrEqualTo(String value) {
            addCriterion("CPIC1PATH >=", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathLessThan(String value) {
            addCriterion("CPIC1PATH <", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathLessThanOrEqualTo(String value) {
            addCriterion("CPIC1PATH <=", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathLike(String value) {
            addCriterion("CPIC1PATH like", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathNotLike(String value) {
            addCriterion("CPIC1PATH not like", value, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathIn(List<String> values) {
            addCriterion("CPIC1PATH in", values, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathNotIn(List<String> values) {
            addCriterion("CPIC1PATH not in", values, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathBetween(String value1, String value2) {
            addCriterion("CPIC1PATH between", value1, value2, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic1pathNotBetween(String value1, String value2) {
            addCriterion("CPIC1PATH not between", value1, value2, "cpic1path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathIsNull() {
            addCriterion("CPIC2PATH is null");
            return (Criteria) this;
        }

        public Criteria andCpic2pathIsNotNull() {
            addCriterion("CPIC2PATH is not null");
            return (Criteria) this;
        }

        public Criteria andCpic2pathEqualTo(String value) {
            addCriterion("CPIC2PATH =", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathNotEqualTo(String value) {
            addCriterion("CPIC2PATH <>", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathGreaterThan(String value) {
            addCriterion("CPIC2PATH >", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathGreaterThanOrEqualTo(String value) {
            addCriterion("CPIC2PATH >=", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathLessThan(String value) {
            addCriterion("CPIC2PATH <", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathLessThanOrEqualTo(String value) {
            addCriterion("CPIC2PATH <=", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathLike(String value) {
            addCriterion("CPIC2PATH like", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathNotLike(String value) {
            addCriterion("CPIC2PATH not like", value, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathIn(List<String> values) {
            addCriterion("CPIC2PATH in", values, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathNotIn(List<String> values) {
            addCriterion("CPIC2PATH not in", values, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathBetween(String value1, String value2) {
            addCriterion("CPIC2PATH between", value1, value2, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic2pathNotBetween(String value1, String value2) {
            addCriterion("CPIC2PATH not between", value1, value2, "cpic2path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathIsNull() {
            addCriterion("CPIC3PATH is null");
            return (Criteria) this;
        }

        public Criteria andCpic3pathIsNotNull() {
            addCriterion("CPIC3PATH is not null");
            return (Criteria) this;
        }

        public Criteria andCpic3pathEqualTo(String value) {
            addCriterion("CPIC3PATH =", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathNotEqualTo(String value) {
            addCriterion("CPIC3PATH <>", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathGreaterThan(String value) {
            addCriterion("CPIC3PATH >", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathGreaterThanOrEqualTo(String value) {
            addCriterion("CPIC3PATH >=", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathLessThan(String value) {
            addCriterion("CPIC3PATH <", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathLessThanOrEqualTo(String value) {
            addCriterion("CPIC3PATH <=", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathLike(String value) {
            addCriterion("CPIC3PATH like", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathNotLike(String value) {
            addCriterion("CPIC3PATH not like", value, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathIn(List<String> values) {
            addCriterion("CPIC3PATH in", values, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathNotIn(List<String> values) {
            addCriterion("CPIC3PATH not in", values, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathBetween(String value1, String value2) {
            addCriterion("CPIC3PATH between", value1, value2, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andCpic3pathNotBetween(String value1, String value2) {
            addCriterion("CPIC3PATH not between", value1, value2, "cpic3path");
            return (Criteria) this;
        }

        public Criteria andNderictrionIsNull() {
            addCriterion("NDERICTRION is null");
            return (Criteria) this;
        }

        public Criteria andNderictrionIsNotNull() {
            addCriterion("NDERICTRION is not null");
            return (Criteria) this;
        }

        public Criteria andNderictrionEqualTo(Integer value) {
            addCriterion("NDERICTRION =", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionNotEqualTo(Integer value) {
            addCriterion("NDERICTRION <>", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionGreaterThan(Integer value) {
            addCriterion("NDERICTRION >", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionGreaterThanOrEqualTo(Integer value) {
            addCriterion("NDERICTRION >=", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionLessThan(Integer value) {
            addCriterion("NDERICTRION <", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionLessThanOrEqualTo(Integer value) {
            addCriterion("NDERICTRION <=", value, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionIn(List<Integer> values) {
            addCriterion("NDERICTRION in", values, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionNotIn(List<Integer> values) {
            addCriterion("NDERICTRION not in", values, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionBetween(Integer value1, Integer value2) {
            addCriterion("NDERICTRION between", value1, value2, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andNderictrionNotBetween(Integer value1, Integer value2) {
            addCriterion("NDERICTRION not between", value1, value2, "nderictrion");
            return (Criteria) this;
        }

        public Criteria andIsillIsNull() {
            addCriterion("ISILL is null");
            return (Criteria) this;
        }

        public Criteria andIsillIsNotNull() {
            addCriterion("ISILL is not null");
            return (Criteria) this;
        }

        public Criteria andIsillEqualTo(String value) {
            addCriterion("ISILL =", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillNotEqualTo(String value) {
            addCriterion("ISILL <>", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillGreaterThan(String value) {
            addCriterion("ISILL >", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillGreaterThanOrEqualTo(String value) {
            addCriterion("ISILL >=", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillLessThan(String value) {
            addCriterion("ISILL <", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillLessThanOrEqualTo(String value) {
            addCriterion("ISILL <=", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillLike(String value) {
            addCriterion("ISILL like", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillNotLike(String value) {
            addCriterion("ISILL not like", value, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillIn(List<String> values) {
            addCriterion("ISILL in", values, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillNotIn(List<String> values) {
            addCriterion("ISILL not in", values, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillBetween(String value1, String value2) {
            addCriterion("ISILL between", value1, value2, "isill");
            return (Criteria) this;
        }

        public Criteria andIsillNotBetween(String value1, String value2) {
            addCriterion("ISILL not between", value1, value2, "isill");
            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);
        }
    }
}