package com.mvc.entity;

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

public class DeviceAccExample {
    /**
     * device_acc
     */
    protected String orderByClause;

    /**
     * device_acc
     */
    protected boolean distinct;

    /**
     * device_acc
     */
    protected List<Criteria> oredCriteria;

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public DeviceAccExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * @Description: 
     * @Author: guozhao
     * @CreateDate: 2024-11-14 19:01:09
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
    * @Description:
    * @Author: guozhao
    * @CreateDate: 2024-11-14 19:01:09
    */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andAccIdIsNull() {
            addCriterion("ACC_ID is null");
            return (Criteria) this;
        }

        public Criteria andAccIdIsNotNull() {
            addCriterion("ACC_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAccIdEqualTo(String value) {
            addCriterion("ACC_ID =", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdNotEqualTo(String value) {
            addCriterion("ACC_ID <>", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdGreaterThan(String value) {
            addCriterion("ACC_ID >", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdGreaterThanOrEqualTo(String value) {
            addCriterion("ACC_ID >=", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdLessThan(String value) {
            addCriterion("ACC_ID <", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdLessThanOrEqualTo(String value) {
            addCriterion("ACC_ID <=", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdLike(String value) {
            addCriterion("ACC_ID like", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdNotLike(String value) {
            addCriterion("ACC_ID not like", value, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdIn(List<String> values) {
            addCriterion("ACC_ID in", values, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdNotIn(List<String> values) {
            addCriterion("ACC_ID not in", values, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdBetween(String value1, String value2) {
            addCriterion("ACC_ID between", value1, value2, "accId");
            return (Criteria) this;
        }

        public Criteria andAccIdNotBetween(String value1, String value2) {
            addCriterion("ACC_ID not between", value1, value2, "accId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnIsNull() {
            addCriterion("DEVICE_SN is null");
            return (Criteria) this;
        }

        public Criteria andDeviceSnIsNotNull() {
            addCriterion("DEVICE_SN is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceSnEqualTo(String value) {
            addCriterion("DEVICE_SN =", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnNotEqualTo(String value) {
            addCriterion("DEVICE_SN <>", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnGreaterThan(String value) {
            addCriterion("DEVICE_SN >", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_SN >=", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnLessThan(String value) {
            addCriterion("DEVICE_SN <", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_SN <=", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnLike(String value) {
            addCriterion("DEVICE_SN like", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnNotLike(String value) {
            addCriterion("DEVICE_SN not like", value, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnIn(List<String> values) {
            addCriterion("DEVICE_SN in", values, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnNotIn(List<String> values) {
            addCriterion("DEVICE_SN not in", values, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnBetween(String value1, String value2) {
            addCriterion("DEVICE_SN between", value1, value2, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceSnNotBetween(String value1, String value2) {
            addCriterion("DEVICE_SN not between", value1, value2, "deviceSn");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIsNull() {
            addCriterion("DEVICE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIsNotNull() {
            addCriterion("DEVICE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceNameEqualTo(String value) {
            addCriterion("DEVICE_NAME =", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotEqualTo(String value) {
            addCriterion("DEVICE_NAME <>", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameGreaterThan(String value) {
            addCriterion("DEVICE_NAME >", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_NAME >=", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLessThan(String value) {
            addCriterion("DEVICE_NAME <", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_NAME <=", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLike(String value) {
            addCriterion("DEVICE_NAME like", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotLike(String value) {
            addCriterion("DEVICE_NAME not like", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIn(List<String> values) {
            addCriterion("DEVICE_NAME in", values, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotIn(List<String> values) {
            addCriterion("DEVICE_NAME not in", values, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameBetween(String value1, String value2) {
            addCriterion("DEVICE_NAME between", value1, value2, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotBetween(String value1, String value2) {
            addCriterion("DEVICE_NAME not between", value1, value2, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceQrIsNull() {
            addCriterion("DEVICE_QR is null");
            return (Criteria) this;
        }

        public Criteria andDeviceQrIsNotNull() {
            addCriterion("DEVICE_QR is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceQrEqualTo(String value) {
            addCriterion("DEVICE_QR =", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrNotEqualTo(String value) {
            addCriterion("DEVICE_QR <>", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrGreaterThan(String value) {
            addCriterion("DEVICE_QR >", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_QR >=", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrLessThan(String value) {
            addCriterion("DEVICE_QR <", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_QR <=", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrLike(String value) {
            addCriterion("DEVICE_QR like", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrNotLike(String value) {
            addCriterion("DEVICE_QR not like", value, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrIn(List<String> values) {
            addCriterion("DEVICE_QR in", values, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrNotIn(List<String> values) {
            addCriterion("DEVICE_QR not in", values, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrBetween(String value1, String value2) {
            addCriterion("DEVICE_QR between", value1, value2, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceQrNotBetween(String value1, String value2) {
            addCriterion("DEVICE_QR not between", value1, value2, "deviceQr");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIsNull() {
            addCriterion("DEVICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIsNotNull() {
            addCriterion("DEVICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeEqualTo(String value) {
            addCriterion("DEVICE_TYPE =", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotEqualTo(String value) {
            addCriterion("DEVICE_TYPE <>", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeGreaterThan(String value) {
            addCriterion("DEVICE_TYPE >", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DEVICE_TYPE >=", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLessThan(String value) {
            addCriterion("DEVICE_TYPE <", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLessThanOrEqualTo(String value) {
            addCriterion("DEVICE_TYPE <=", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeLike(String value) {
            addCriterion("DEVICE_TYPE like", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotLike(String value) {
            addCriterion("DEVICE_TYPE not like", value, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeIn(List<String> values) {
            addCriterion("DEVICE_TYPE in", values, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotIn(List<String> values) {
            addCriterion("DEVICE_TYPE not in", values, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeBetween(String value1, String value2) {
            addCriterion("DEVICE_TYPE between", value1, value2, "deviceType");
            return (Criteria) this;
        }

        public Criteria andDeviceTypeNotBetween(String value1, String value2) {
            addCriterion("DEVICE_TYPE not between", value1, value2, "deviceType");
            return (Criteria) this;
        }

        public Criteria andCreateManIsNull() {
            addCriterion("CREATE_MAN is null");
            return (Criteria) this;
        }

        public Criteria andCreateManIsNotNull() {
            addCriterion("CREATE_MAN is not null");
            return (Criteria) this;
        }

        public Criteria andCreateManEqualTo(String value) {
            addCriterion("CREATE_MAN =", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManNotEqualTo(String value) {
            addCriterion("CREATE_MAN <>", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManGreaterThan(String value) {
            addCriterion("CREATE_MAN >", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_MAN >=", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManLessThan(String value) {
            addCriterion("CREATE_MAN <", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManLessThanOrEqualTo(String value) {
            addCriterion("CREATE_MAN <=", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManLike(String value) {
            addCriterion("CREATE_MAN like", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManNotLike(String value) {
            addCriterion("CREATE_MAN not like", value, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManIn(List<String> values) {
            addCriterion("CREATE_MAN in", values, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManNotIn(List<String> values) {
            addCriterion("CREATE_MAN not in", values, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManBetween(String value1, String value2) {
            addCriterion("CREATE_MAN between", value1, value2, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateManNotBetween(String value1, String value2) {
            addCriterion("CREATE_MAN not between", value1, value2, "createMan");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCertifFlagIsNull() {
            addCriterion("CERTIF_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andCertifFlagIsNotNull() {
            addCriterion("CERTIF_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andCertifFlagEqualTo(String value) {
            addCriterion("CERTIF_FLAG =", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagNotEqualTo(String value) {
            addCriterion("CERTIF_FLAG <>", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagGreaterThan(String value) {
            addCriterion("CERTIF_FLAG >", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIF_FLAG >=", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagLessThan(String value) {
            addCriterion("CERTIF_FLAG <", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagLessThanOrEqualTo(String value) {
            addCriterion("CERTIF_FLAG <=", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagLike(String value) {
            addCriterion("CERTIF_FLAG like", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagNotLike(String value) {
            addCriterion("CERTIF_FLAG not like", value, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagIn(List<String> values) {
            addCriterion("CERTIF_FLAG in", values, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagNotIn(List<String> values) {
            addCriterion("CERTIF_FLAG not in", values, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagBetween(String value1, String value2) {
            addCriterion("CERTIF_FLAG between", value1, value2, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifFlagNotBetween(String value1, String value2) {
            addCriterion("CERTIF_FLAG not between", value1, value2, "certifFlag");
            return (Criteria) this;
        }

        public Criteria andCertifDateIsNull() {
            addCriterion("CERTIF_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCertifDateIsNotNull() {
            addCriterion("CERTIF_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCertifDateEqualTo(Date value) {
            addCriterion("CERTIF_DATE =", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateNotEqualTo(Date value) {
            addCriterion("CERTIF_DATE <>", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateGreaterThan(Date value) {
            addCriterion("CERTIF_DATE >", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CERTIF_DATE >=", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateLessThan(Date value) {
            addCriterion("CERTIF_DATE <", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateLessThanOrEqualTo(Date value) {
            addCriterion("CERTIF_DATE <=", value, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateIn(List<Date> values) {
            addCriterion("CERTIF_DATE in", values, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateNotIn(List<Date> values) {
            addCriterion("CERTIF_DATE not in", values, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateBetween(Date value1, Date value2) {
            addCriterion("CERTIF_DATE between", value1, value2, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifDateNotBetween(Date value1, Date value2) {
            addCriterion("CERTIF_DATE not between", value1, value2, "certifDate");
            return (Criteria) this;
        }

        public Criteria andCertifManIsNull() {
            addCriterion("CERTIF_MAN is null");
            return (Criteria) this;
        }

        public Criteria andCertifManIsNotNull() {
            addCriterion("CERTIF_MAN is not null");
            return (Criteria) this;
        }

        public Criteria andCertifManEqualTo(String value) {
            addCriterion("CERTIF_MAN =", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManNotEqualTo(String value) {
            addCriterion("CERTIF_MAN <>", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManGreaterThan(String value) {
            addCriterion("CERTIF_MAN >", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIF_MAN >=", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManLessThan(String value) {
            addCriterion("CERTIF_MAN <", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManLessThanOrEqualTo(String value) {
            addCriterion("CERTIF_MAN <=", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManLike(String value) {
            addCriterion("CERTIF_MAN like", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManNotLike(String value) {
            addCriterion("CERTIF_MAN not like", value, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManIn(List<String> values) {
            addCriterion("CERTIF_MAN in", values, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManNotIn(List<String> values) {
            addCriterion("CERTIF_MAN not in", values, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManBetween(String value1, String value2) {
            addCriterion("CERTIF_MAN between", value1, value2, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifManNotBetween(String value1, String value2) {
            addCriterion("CERTIF_MAN not between", value1, value2, "certifMan");
            return (Criteria) this;
        }

        public Criteria andCertifIdIsNull() {
            addCriterion("CERTIF_ID is null");
            return (Criteria) this;
        }

        public Criteria andCertifIdIsNotNull() {
            addCriterion("CERTIF_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCertifIdEqualTo(String value) {
            addCriterion("CERTIF_ID =", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdNotEqualTo(String value) {
            addCriterion("CERTIF_ID <>", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdGreaterThan(String value) {
            addCriterion("CERTIF_ID >", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIF_ID >=", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdLessThan(String value) {
            addCriterion("CERTIF_ID <", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdLessThanOrEqualTo(String value) {
            addCriterion("CERTIF_ID <=", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdLike(String value) {
            addCriterion("CERTIF_ID like", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdNotLike(String value) {
            addCriterion("CERTIF_ID not like", value, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdIn(List<String> values) {
            addCriterion("CERTIF_ID in", values, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdNotIn(List<String> values) {
            addCriterion("CERTIF_ID not in", values, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdBetween(String value1, String value2) {
            addCriterion("CERTIF_ID between", value1, value2, "certifId");
            return (Criteria) this;
        }

        public Criteria andCertifIdNotBetween(String value1, String value2) {
            addCriterion("CERTIF_ID not between", value1, value2, "certifId");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeIsNull() {
            addCriterion("CUR_STATE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeIsNotNull() {
            addCriterion("CUR_STATE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeEqualTo(String value) {
            addCriterion("CUR_STATE_TYPE =", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeNotEqualTo(String value) {
            addCriterion("CUR_STATE_TYPE <>", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeGreaterThan(String value) {
            addCriterion("CUR_STATE_TYPE >", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CUR_STATE_TYPE >=", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeLessThan(String value) {
            addCriterion("CUR_STATE_TYPE <", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeLessThanOrEqualTo(String value) {
            addCriterion("CUR_STATE_TYPE <=", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeLike(String value) {
            addCriterion("CUR_STATE_TYPE like", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeNotLike(String value) {
            addCriterion("CUR_STATE_TYPE not like", value, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeIn(List<String> values) {
            addCriterion("CUR_STATE_TYPE in", values, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeNotIn(List<String> values) {
            addCriterion("CUR_STATE_TYPE not in", values, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeBetween(String value1, String value2) {
            addCriterion("CUR_STATE_TYPE between", value1, value2, "curStateType");
            return (Criteria) this;
        }

        public Criteria andCurStateTypeNotBetween(String value1, String value2) {
            addCriterion("CUR_STATE_TYPE not between", value1, value2, "curStateType");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdIsNull() {
            addCriterion("STATE_CHANGE_ID is null");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdIsNotNull() {
            addCriterion("STATE_CHANGE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdEqualTo(String value) {
            addCriterion("STATE_CHANGE_ID =", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdNotEqualTo(String value) {
            addCriterion("STATE_CHANGE_ID <>", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdGreaterThan(String value) {
            addCriterion("STATE_CHANGE_ID >", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_CHANGE_ID >=", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdLessThan(String value) {
            addCriterion("STATE_CHANGE_ID <", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdLessThanOrEqualTo(String value) {
            addCriterion("STATE_CHANGE_ID <=", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdLike(String value) {
            addCriterion("STATE_CHANGE_ID like", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdNotLike(String value) {
            addCriterion("STATE_CHANGE_ID not like", value, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdIn(List<String> values) {
            addCriterion("STATE_CHANGE_ID in", values, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdNotIn(List<String> values) {
            addCriterion("STATE_CHANGE_ID not in", values, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdBetween(String value1, String value2) {
            addCriterion("STATE_CHANGE_ID between", value1, value2, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andStateChangeIdNotBetween(String value1, String value2) {
            addCriterion("STATE_CHANGE_ID not between", value1, value2, "stateChangeId");
            return (Criteria) this;
        }

        public Criteria andCfgIdIsNull() {
            addCriterion("CFG_ID is null");
            return (Criteria) this;
        }

        public Criteria andCfgIdIsNotNull() {
            addCriterion("CFG_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCfgIdEqualTo(String value) {
            addCriterion("CFG_ID =", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdNotEqualTo(String value) {
            addCriterion("CFG_ID <>", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdGreaterThan(String value) {
            addCriterion("CFG_ID >", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdGreaterThanOrEqualTo(String value) {
            addCriterion("CFG_ID >=", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdLessThan(String value) {
            addCriterion("CFG_ID <", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdLessThanOrEqualTo(String value) {
            addCriterion("CFG_ID <=", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdLike(String value) {
            addCriterion("CFG_ID like", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdNotLike(String value) {
            addCriterion("CFG_ID not like", value, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdIn(List<String> values) {
            addCriterion("CFG_ID in", values, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdNotIn(List<String> values) {
            addCriterion("CFG_ID not in", values, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdBetween(String value1, String value2) {
            addCriterion("CFG_ID between", value1, value2, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCfgIdNotBetween(String value1, String value2) {
            addCriterion("CFG_ID not between", value1, value2, "cfgId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("CUSTOMER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("CUSTOMER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(String value) {
            addCriterion("CUSTOMER_ID =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(String value) {
            addCriterion("CUSTOMER_ID <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(String value) {
            addCriterion("CUSTOMER_ID >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ID >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(String value) {
            addCriterion("CUSTOMER_ID <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_ID <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(String value) {
            addCriterion("CUSTOMER_ID like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(String value) {
            addCriterion("CUSTOMER_ID not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<String> values) {
            addCriterion("CUSTOMER_ID in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<String> values) {
            addCriterion("CUSTOMER_ID not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ID between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_ID not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andStationCodeIsNull() {
            addCriterion("STATION_CODE is null");
            return (Criteria) this;
        }

        public Criteria andStationCodeIsNotNull() {
            addCriterion("STATION_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andStationCodeEqualTo(String value) {
            addCriterion("STATION_CODE =", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeNotEqualTo(String value) {
            addCriterion("STATION_CODE <>", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeGreaterThan(String value) {
            addCriterion("STATION_CODE >", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("STATION_CODE >=", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeLessThan(String value) {
            addCriterion("STATION_CODE <", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeLessThanOrEqualTo(String value) {
            addCriterion("STATION_CODE <=", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeLike(String value) {
            addCriterion("STATION_CODE like", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeNotLike(String value) {
            addCriterion("STATION_CODE not like", value, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeIn(List<String> values) {
            addCriterion("STATION_CODE in", values, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeNotIn(List<String> values) {
            addCriterion("STATION_CODE not in", values, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeBetween(String value1, String value2) {
            addCriterion("STATION_CODE between", value1, value2, "stationCode");
            return (Criteria) this;
        }

        public Criteria andStationCodeNotBetween(String value1, String value2) {
            addCriterion("STATION_CODE not between", value1, value2, "stationCode");
            return (Criteria) this;
        }

        public Criteria andUseFlagIsNull() {
            addCriterion("USE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andUseFlagIsNotNull() {
            addCriterion("USE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andUseFlagEqualTo(String value) {
            addCriterion("USE_FLAG =", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagNotEqualTo(String value) {
            addCriterion("USE_FLAG <>", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagGreaterThan(String value) {
            addCriterion("USE_FLAG >", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagGreaterThanOrEqualTo(String value) {
            addCriterion("USE_FLAG >=", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagLessThan(String value) {
            addCriterion("USE_FLAG <", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagLessThanOrEqualTo(String value) {
            addCriterion("USE_FLAG <=", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagLike(String value) {
            addCriterion("USE_FLAG like", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagNotLike(String value) {
            addCriterion("USE_FLAG not like", value, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagIn(List<String> values) {
            addCriterion("USE_FLAG in", values, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagNotIn(List<String> values) {
            addCriterion("USE_FLAG not in", values, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagBetween(String value1, String value2) {
            addCriterion("USE_FLAG between", value1, value2, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUseFlagNotBetween(String value1, String value2) {
            addCriterion("USE_FLAG not between", value1, value2, "useFlag");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseIsNull() {
            addCriterion("UNUSED_BECAUSE is null");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseIsNotNull() {
            addCriterion("UNUSED_BECAUSE is not null");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseEqualTo(String value) {
            addCriterion("UNUSED_BECAUSE =", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseNotEqualTo(String value) {
            addCriterion("UNUSED_BECAUSE <>", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseGreaterThan(String value) {
            addCriterion("UNUSED_BECAUSE >", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseGreaterThanOrEqualTo(String value) {
            addCriterion("UNUSED_BECAUSE >=", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseLessThan(String value) {
            addCriterion("UNUSED_BECAUSE <", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseLessThanOrEqualTo(String value) {
            addCriterion("UNUSED_BECAUSE <=", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseLike(String value) {
            addCriterion("UNUSED_BECAUSE like", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseNotLike(String value) {
            addCriterion("UNUSED_BECAUSE not like", value, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseIn(List<String> values) {
            addCriterion("UNUSED_BECAUSE in", values, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseNotIn(List<String> values) {
            addCriterion("UNUSED_BECAUSE not in", values, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseBetween(String value1, String value2) {
            addCriterion("UNUSED_BECAUSE between", value1, value2, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnusedBecauseNotBetween(String value1, String value2) {
            addCriterion("UNUSED_BECAUSE not between", value1, value2, "unusedBecause");
            return (Criteria) this;
        }

        public Criteria andUnitCodeIsNull() {
            addCriterion("UNIT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andUnitCodeIsNotNull() {
            addCriterion("UNIT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andUnitCodeEqualTo(String value) {
            addCriterion("UNIT_CODE =", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeNotEqualTo(String value) {
            addCriterion("UNIT_CODE <>", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeGreaterThan(String value) {
            addCriterion("UNIT_CODE >", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeGreaterThanOrEqualTo(String value) {
            addCriterion("UNIT_CODE >=", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeLessThan(String value) {
            addCriterion("UNIT_CODE <", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeLessThanOrEqualTo(String value) {
            addCriterion("UNIT_CODE <=", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeLike(String value) {
            addCriterion("UNIT_CODE like", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeNotLike(String value) {
            addCriterion("UNIT_CODE not like", value, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeIn(List<String> values) {
            addCriterion("UNIT_CODE in", values, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeNotIn(List<String> values) {
            addCriterion("UNIT_CODE not in", values, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeBetween(String value1, String value2) {
            addCriterion("UNIT_CODE between", value1, value2, "unitCode");
            return (Criteria) this;
        }

        public Criteria andUnitCodeNotBetween(String value1, String value2) {
            addCriterion("UNIT_CODE not between", value1, value2, "unitCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeIsNull() {
            addCriterion("BAT_CODE is null");
            return (Criteria) this;
        }

        public Criteria andBatCodeIsNotNull() {
            addCriterion("BAT_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andBatCodeEqualTo(String value) {
            addCriterion("BAT_CODE =", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeNotEqualTo(String value) {
            addCriterion("BAT_CODE <>", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeGreaterThan(String value) {
            addCriterion("BAT_CODE >", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("BAT_CODE >=", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeLessThan(String value) {
            addCriterion("BAT_CODE <", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeLessThanOrEqualTo(String value) {
            addCriterion("BAT_CODE <=", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeLike(String value) {
            addCriterion("BAT_CODE like", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeNotLike(String value) {
            addCriterion("BAT_CODE not like", value, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeIn(List<String> values) {
            addCriterion("BAT_CODE in", values, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeNotIn(List<String> values) {
            addCriterion("BAT_CODE not in", values, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeBetween(String value1, String value2) {
            addCriterion("BAT_CODE between", value1, value2, "batCode");
            return (Criteria) this;
        }

        public Criteria andBatCodeNotBetween(String value1, String value2) {
            addCriterion("BAT_CODE not between", value1, value2, "batCode");
            return (Criteria) this;
        }

        public Criteria andImeiIsNull() {
            addCriterion("IMEI is null");
            return (Criteria) this;
        }

        public Criteria andImeiIsNotNull() {
            addCriterion("IMEI is not null");
            return (Criteria) this;
        }

        public Criteria andImeiEqualTo(String value) {
            addCriterion("IMEI =", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiNotEqualTo(String value) {
            addCriterion("IMEI <>", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiGreaterThan(String value) {
            addCriterion("IMEI >", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiGreaterThanOrEqualTo(String value) {
            addCriterion("IMEI >=", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiLessThan(String value) {
            addCriterion("IMEI <", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiLessThanOrEqualTo(String value) {
            addCriterion("IMEI <=", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiLike(String value) {
            addCriterion("IMEI like", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiNotLike(String value) {
            addCriterion("IMEI not like", value, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiIn(List<String> values) {
            addCriterion("IMEI in", values, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiNotIn(List<String> values) {
            addCriterion("IMEI not in", values, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiBetween(String value1, String value2) {
            addCriterion("IMEI between", value1, value2, "imei");
            return (Criteria) this;
        }

        public Criteria andImeiNotBetween(String value1, String value2) {
            addCriterion("IMEI not between", value1, value2, "imei");
            return (Criteria) this;
        }

        public Criteria andIotTypeIsNull() {
            addCriterion("IOT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andIotTypeIsNotNull() {
            addCriterion("IOT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andIotTypeEqualTo(String value) {
            addCriterion("IOT_TYPE =", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeNotEqualTo(String value) {
            addCriterion("IOT_TYPE <>", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeGreaterThan(String value) {
            addCriterion("IOT_TYPE >", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeGreaterThanOrEqualTo(String value) {
            addCriterion("IOT_TYPE >=", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeLessThan(String value) {
            addCriterion("IOT_TYPE <", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeLessThanOrEqualTo(String value) {
            addCriterion("IOT_TYPE <=", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeLike(String value) {
            addCriterion("IOT_TYPE like", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeNotLike(String value) {
            addCriterion("IOT_TYPE not like", value, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeIn(List<String> values) {
            addCriterion("IOT_TYPE in", values, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeNotIn(List<String> values) {
            addCriterion("IOT_TYPE not in", values, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeBetween(String value1, String value2) {
            addCriterion("IOT_TYPE between", value1, value2, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotTypeNotBetween(String value1, String value2) {
            addCriterion("IOT_TYPE not between", value1, value2, "iotType");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdIsNull() {
            addCriterion("IOT_DEVICE_ID is null");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdIsNotNull() {
            addCriterion("IOT_DEVICE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdEqualTo(String value) {
            addCriterion("IOT_DEVICE_ID =", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdNotEqualTo(String value) {
            addCriterion("IOT_DEVICE_ID <>", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdGreaterThan(String value) {
            addCriterion("IOT_DEVICE_ID >", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdGreaterThanOrEqualTo(String value) {
            addCriterion("IOT_DEVICE_ID >=", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdLessThan(String value) {
            addCriterion("IOT_DEVICE_ID <", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdLessThanOrEqualTo(String value) {
            addCriterion("IOT_DEVICE_ID <=", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdLike(String value) {
            addCriterion("IOT_DEVICE_ID like", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdNotLike(String value) {
            addCriterion("IOT_DEVICE_ID not like", value, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdIn(List<String> values) {
            addCriterion("IOT_DEVICE_ID in", values, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdNotIn(List<String> values) {
            addCriterion("IOT_DEVICE_ID not in", values, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdBetween(String value1, String value2) {
            addCriterion("IOT_DEVICE_ID between", value1, value2, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andIotDeviceIdNotBetween(String value1, String value2) {
            addCriterion("IOT_DEVICE_ID not between", value1, value2, "iotDeviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdIsNull() {
            addCriterion("DEVICE_SN_MANAGEMENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdIsNotNull() {
            addCriterion("DEVICE_SN_MANAGEMENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdEqualTo(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID =", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdNotEqualTo(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID <>", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdGreaterThan(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID >", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID >=", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdLessThan(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID <", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdLessThanOrEqualTo(Integer value) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID <=", value, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdIn(List<Integer> values) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID in", values, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdNotIn(List<Integer> values) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID not in", values, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdBetween(Integer value1, Integer value2) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID between", value1, value2, "deviceSnManagementId");
            return (Criteria) this;
        }

        public Criteria andDeviceSnManagementIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DEVICE_SN_MANAGEMENT_ID not between", value1, value2, "deviceSnManagementId");
            return (Criteria) this;
        }
    }

    /**
    * @Description:
    * @Author: guozhao
    * @CreateDate: 2024-11-14 19:01:09
    */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
    * @Description:
    * @Author: guozhao
    * @CreateDate: 2024-11-14 19:01:09
    */
    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);
        }
    }
}