package com.miniframe.model.system;

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

public class DSensorValSQLBuilder {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

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

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

    public String getOrderByClause() {
        return orderByClause;
    }

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

    public boolean isDistinct() {
        return distinct;
    }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andIdEqualTo(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 andMineCodeIsNull() {
            addCriterion("mine_code is null");
            return (Criteria) this;
        }

        public Criteria andMineCodeIsNotNull() {
            addCriterion("mine_code is not null");
            return (Criteria) this;
        }

        public Criteria andMineCodeEqualTo(String value) {
            addCriterion("mine_code =", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeNotEqualTo(String value) {
            addCriterion("mine_code <>", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeGreaterThan(String value) {
            addCriterion("mine_code >", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeGreaterThanOrEqualTo(String value) {
            addCriterion("mine_code >=", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeLessThan(String value) {
            addCriterion("mine_code <", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeLessThanOrEqualTo(String value) {
            addCriterion("mine_code <=", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeLike(String value) {
            addCriterion("mine_code like", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeNotLike(String value) {
            addCriterion("mine_code not like", value, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeIn(List<String> values) {
            addCriterion("mine_code in", values, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeNotIn(List<String> values) {
            addCriterion("mine_code not in", values, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeBetween(String value1, String value2) {
            addCriterion("mine_code between", value1, value2, "mineCode");
            return (Criteria) this;
        }

        public Criteria andMineCodeNotBetween(String value1, String value2) {
            addCriterion("mine_code not between", value1, value2, "mineCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeIsNull() {
            addCriterion("point_code is null");
            return (Criteria) this;
        }

        public Criteria andPointCodeIsNotNull() {
            addCriterion("point_code is not null");
            return (Criteria) this;
        }

        public Criteria andPointCodeEqualTo(String value) {
            addCriterion("point_code =", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeNotEqualTo(String value) {
            addCriterion("point_code <>", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeGreaterThan(String value) {
            addCriterion("point_code >", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeGreaterThanOrEqualTo(String value) {
            addCriterion("point_code >=", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeLessThan(String value) {
            addCriterion("point_code <", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeLessThanOrEqualTo(String value) {
            addCriterion("point_code <=", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeLike(String value) {
            addCriterion("point_code like", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeNotLike(String value) {
            addCriterion("point_code not like", value, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeIn(List<String> values) {
            addCriterion("point_code in", values, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeNotIn(List<String> values) {
            addCriterion("point_code not in", values, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeBetween(String value1, String value2) {
            addCriterion("point_code between", value1, value2, "pointCode");
            return (Criteria) this;
        }

        public Criteria andPointCodeNotBetween(String value1, String value2) {
            addCriterion("point_code not between", value1, value2, "pointCode");
            return (Criteria) this;
        }

        public Criteria andDataTimeIsNull() {
            addCriterion("data_time is null");
            return (Criteria) this;
        }

        public Criteria andDataTimeIsNotNull() {
            addCriterion("data_time is not null");
            return (Criteria) this;
        }

        public Criteria andDataTimeEqualTo(String value) {
            addCriterion("data_time =", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeNotEqualTo(String value) {
            addCriterion("data_time <>", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeGreaterThan(String value) {
            addCriterion("data_time >", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeGreaterThanOrEqualTo(String value) {
            addCriterion("data_time >=", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeLessThan(String value) {
            addCriterion("data_time <", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeLessThanOrEqualTo(String value) {
            addCriterion("data_time <=", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeLike(String value) {
            addCriterion("data_time like", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeNotLike(String value) {
            addCriterion("data_time not like", value, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeIn(List<String> values) {
            addCriterion("data_time in", values, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeNotIn(List<String> values) {
            addCriterion("data_time not in", values, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeBetween(String value1, String value2) {
            addCriterion("data_time between", value1, value2, "dataTime");
            return (Criteria) this;
        }

        public Criteria andDataTimeNotBetween(String value1, String value2) {
            addCriterion("data_time not between", value1, value2, "dataTime");
            return (Criteria) this;
        }

        public Criteria andSensorTypeIsNull() {
            addCriterion("sensor_type is null");
            return (Criteria) this;
        }

        public Criteria andSensorTypeIsNotNull() {
            addCriterion("sensor_type is not null");
            return (Criteria) this;
        }

        public Criteria andSensorTypeEqualTo(String value) {
            addCriterion("sensor_type =", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNotEqualTo(String value) {
            addCriterion("sensor_type <>", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeGreaterThan(String value) {
            addCriterion("sensor_type >", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeGreaterThanOrEqualTo(String value) {
            addCriterion("sensor_type >=", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeLessThan(String value) {
            addCriterion("sensor_type <", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeLessThanOrEqualTo(String value) {
            addCriterion("sensor_type <=", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeLike(String value) {
            addCriterion("sensor_type like", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNotLike(String value) {
            addCriterion("sensor_type not like", value, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeIn(List<String> values) {
            addCriterion("sensor_type in", values, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNotIn(List<String> values) {
            addCriterion("sensor_type not in", values, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeBetween(String value1, String value2) {
            addCriterion("sensor_type between", value1, value2, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNotBetween(String value1, String value2) {
            addCriterion("sensor_type not between", value1, value2, "sensorType");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameIsNull() {
            addCriterion("sensor_type_name is null");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameIsNotNull() {
            addCriterion("sensor_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameEqualTo(String value) {
            addCriterion("sensor_type_name =", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameNotEqualTo(String value) {
            addCriterion("sensor_type_name <>", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameGreaterThan(String value) {
            addCriterion("sensor_type_name >", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("sensor_type_name >=", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameLessThan(String value) {
            addCriterion("sensor_type_name <", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameLessThanOrEqualTo(String value) {
            addCriterion("sensor_type_name <=", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameLike(String value) {
            addCriterion("sensor_type_name like", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameNotLike(String value) {
            addCriterion("sensor_type_name not like", value, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameIn(List<String> values) {
            addCriterion("sensor_type_name in", values, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameNotIn(List<String> values) {
            addCriterion("sensor_type_name not in", values, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameBetween(String value1, String value2) {
            addCriterion("sensor_type_name between", value1, value2, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andSensorTypeNameNotBetween(String value1, String value2) {
            addCriterion("sensor_type_name not between", value1, value2, "sensorTypeName");
            return (Criteria) this;
        }

        public Criteria andPointLocationIsNull() {
            addCriterion("point_location is null");
            return (Criteria) this;
        }

        public Criteria andPointLocationIsNotNull() {
            addCriterion("point_location is not null");
            return (Criteria) this;
        }

        public Criteria andPointLocationEqualTo(String value) {
            addCriterion("point_location =", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationNotEqualTo(String value) {
            addCriterion("point_location <>", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationGreaterThan(String value) {
            addCriterion("point_location >", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationGreaterThanOrEqualTo(String value) {
            addCriterion("point_location >=", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationLessThan(String value) {
            addCriterion("point_location <", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationLessThanOrEqualTo(String value) {
            addCriterion("point_location <=", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationLike(String value) {
            addCriterion("point_location like", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationNotLike(String value) {
            addCriterion("point_location not like", value, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationIn(List<String> values) {
            addCriterion("point_location in", values, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationNotIn(List<String> values) {
            addCriterion("point_location not in", values, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationBetween(String value1, String value2) {
            addCriterion("point_location between", value1, value2, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointLocationNotBetween(String value1, String value2) {
            addCriterion("point_location not between", value1, value2, "pointLocation");
            return (Criteria) this;
        }

        public Criteria andPointValueIsNull() {
            addCriterion("point_value is null");
            return (Criteria) this;
        }

        public Criteria andPointValueIsNotNull() {
            addCriterion("point_value is not null");
            return (Criteria) this;
        }

        public Criteria andPointValueEqualTo(String value) {
            addCriterion("point_value =", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueNotEqualTo(String value) {
            addCriterion("point_value <>", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueGreaterThan(String value) {
            addCriterion("point_value >", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueGreaterThanOrEqualTo(String value) {
            addCriterion("point_value >=", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueLessThan(String value) {
            addCriterion("point_value <", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueLessThanOrEqualTo(String value) {
            addCriterion("point_value <=", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueLike(String value) {
            addCriterion("point_value like", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueNotLike(String value) {
            addCriterion("point_value not like", value, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueIn(List<String> values) {
            addCriterion("point_value in", values, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueNotIn(List<String> values) {
            addCriterion("point_value not in", values, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueBetween(String value1, String value2) {
            addCriterion("point_value between", value1, value2, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointValueNotBetween(String value1, String value2) {
            addCriterion("point_value not between", value1, value2, "pointValue");
            return (Criteria) this;
        }

        public Criteria andPointStatusIsNull() {
            addCriterion("point_status is null");
            return (Criteria) this;
        }

        public Criteria andPointStatusIsNotNull() {
            addCriterion("point_status is not null");
            return (Criteria) this;
        }

        public Criteria andPointStatusEqualTo(String value) {
            addCriterion("point_status =", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusNotEqualTo(String value) {
            addCriterion("point_status <>", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusGreaterThan(String value) {
            addCriterion("point_status >", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusGreaterThanOrEqualTo(String value) {
            addCriterion("point_status >=", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusLessThan(String value) {
            addCriterion("point_status <", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusLessThanOrEqualTo(String value) {
            addCriterion("point_status <=", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusLike(String value) {
            addCriterion("point_status like", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusNotLike(String value) {
            addCriterion("point_status not like", value, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusIn(List<String> values) {
            addCriterion("point_status in", values, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusNotIn(List<String> values) {
            addCriterion("point_status not in", values, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusBetween(String value1, String value2) {
            addCriterion("point_status between", value1, value2, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andPointStatusNotBetween(String value1, String value2) {
            addCriterion("point_status not between", value1, value2, "pointStatus");
            return (Criteria) this;
        }

        public Criteria andValueUnitIsNull() {
            addCriterion("value_unit is null");
            return (Criteria) this;
        }

        public Criteria andValueUnitIsNotNull() {
            addCriterion("value_unit is not null");
            return (Criteria) this;
        }

        public Criteria andValueUnitEqualTo(String value) {
            addCriterion("value_unit =", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitNotEqualTo(String value) {
            addCriterion("value_unit <>", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitGreaterThan(String value) {
            addCriterion("value_unit >", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitGreaterThanOrEqualTo(String value) {
            addCriterion("value_unit >=", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitLessThan(String value) {
            addCriterion("value_unit <", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitLessThanOrEqualTo(String value) {
            addCriterion("value_unit <=", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitLike(String value) {
            addCriterion("value_unit like", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitNotLike(String value) {
            addCriterion("value_unit not like", value, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitIn(List<String> values) {
            addCriterion("value_unit in", values, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitNotIn(List<String> values) {
            addCriterion("value_unit not in", values, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitBetween(String value1, String value2) {
            addCriterion("value_unit between", value1, value2, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andValueUnitNotBetween(String value1, String value2) {
            addCriterion("value_unit not between", value1, value2, "valueUnit");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(String value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(String value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(String value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(String value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(String value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLike(String value) {
            addCriterion("create_time like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotLike(String value) {
            addCriterion("create_time not like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<String> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<String> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(String value1, String value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(String value1, String value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andXCoordinateIsNull() {
            addCriterion("x_coordinate is null");
            return (Criteria) this;
        }

        public Criteria andXCoordinateIsNotNull() {
            addCriterion("x_coordinate is not null");
            return (Criteria) this;
        }

        public Criteria andXCoordinateEqualTo(String value) {
            addCriterion("x_coordinate =", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateNotEqualTo(String value) {
            addCriterion("x_coordinate <>", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateGreaterThan(String value) {
            addCriterion("x_coordinate >", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateGreaterThanOrEqualTo(String value) {
            addCriterion("x_coordinate >=", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateLessThan(String value) {
            addCriterion("x_coordinate <", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateLessThanOrEqualTo(String value) {
            addCriterion("x_coordinate <=", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateLike(String value) {
            addCriterion("x_coordinate like", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateNotLike(String value) {
            addCriterion("x_coordinate not like", value, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateIn(List<String> values) {
            addCriterion("x_coordinate in", values, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateNotIn(List<String> values) {
            addCriterion("x_coordinate not in", values, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateBetween(String value1, String value2) {
            addCriterion("x_coordinate between", value1, value2, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andXCoordinateNotBetween(String value1, String value2) {
            addCriterion("x_coordinate not between", value1, value2, "xCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateIsNull() {
            addCriterion("y_coordinate is null");
            return (Criteria) this;
        }

        public Criteria andYCoordinateIsNotNull() {
            addCriterion("y_coordinate is not null");
            return (Criteria) this;
        }

        public Criteria andYCoordinateEqualTo(String value) {
            addCriterion("y_coordinate =", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateNotEqualTo(String value) {
            addCriterion("y_coordinate <>", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateGreaterThan(String value) {
            addCriterion("y_coordinate >", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateGreaterThanOrEqualTo(String value) {
            addCriterion("y_coordinate >=", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateLessThan(String value) {
            addCriterion("y_coordinate <", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateLessThanOrEqualTo(String value) {
            addCriterion("y_coordinate <=", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateLike(String value) {
            addCriterion("y_coordinate like", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateNotLike(String value) {
            addCriterion("y_coordinate not like", value, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateIn(List<String> values) {
            addCriterion("y_coordinate in", values, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateNotIn(List<String> values) {
            addCriterion("y_coordinate not in", values, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateBetween(String value1, String value2) {
            addCriterion("y_coordinate between", value1, value2, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andYCoordinateNotBetween(String value1, String value2) {
            addCriterion("y_coordinate not between", value1, value2, "yCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateIsNull() {
            addCriterion("z_coordinate is null");
            return (Criteria) this;
        }

        public Criteria andZCoordinateIsNotNull() {
            addCriterion("z_coordinate is not null");
            return (Criteria) this;
        }

        public Criteria andZCoordinateEqualTo(String value) {
            addCriterion("z_coordinate =", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateNotEqualTo(String value) {
            addCriterion("z_coordinate <>", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateGreaterThan(String value) {
            addCriterion("z_coordinate >", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateGreaterThanOrEqualTo(String value) {
            addCriterion("z_coordinate >=", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateLessThan(String value) {
            addCriterion("z_coordinate <", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateLessThanOrEqualTo(String value) {
            addCriterion("z_coordinate <=", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateLike(String value) {
            addCriterion("z_coordinate like", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateNotLike(String value) {
            addCriterion("z_coordinate not like", value, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateIn(List<String> values) {
            addCriterion("z_coordinate in", values, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateNotIn(List<String> values) {
            addCriterion("z_coordinate not in", values, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateBetween(String value1, String value2) {
            addCriterion("z_coordinate between", value1, value2, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andZCoordinateNotBetween(String value1, String value2) {
            addCriterion("z_coordinate not between", value1, value2, "zCoordinate");
            return (Criteria) this;
        }

        public Criteria andPipesIsNull() {
            addCriterion("pipes is null");
            return (Criteria) this;
        }

        public Criteria andPipesIsNotNull() {
            addCriterion("pipes is not null");
            return (Criteria) this;
        }

        public Criteria andPipesEqualTo(String value) {
            addCriterion("pipes =", value, "pipes");
            return (Criteria) this;
        }

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

        public Criteria andPipesGreaterThan(String value) {
            addCriterion("pipes >", value, "pipes");
            return (Criteria) this;
        }

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

        public Criteria andPipesLessThan(String value) {
            addCriterion("pipes <", value, "pipes");
            return (Criteria) this;
        }

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

        public Criteria andPipesLike(String value) {
            addCriterion("pipes like", value, "pipes");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andSiteIsNull() {
            addCriterion("site is null");
            return (Criteria) this;
        }

        public Criteria andSiteIsNotNull() {
            addCriterion("site is not null");
            return (Criteria) this;
        }

        public Criteria andSiteEqualTo(String value) {
            addCriterion("site =", value, "site");
            return (Criteria) this;
        }

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

        public Criteria andSiteGreaterThan(String value) {
            addCriterion("site >", value, "site");
            return (Criteria) this;
        }

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

        public Criteria andSiteLessThan(String value) {
            addCriterion("site <", value, "site");
            return (Criteria) this;
        }

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

        public Criteria andSiteLike(String value) {
            addCriterion("site like", value, "site");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andAidIsNull() {
            addCriterion("aid is null");
            return (Criteria) this;
        }

        public Criteria andAidIsNotNull() {
            addCriterion("aid is not null");
            return (Criteria) this;
        }

        public Criteria andAidEqualTo(Integer value) {
            addCriterion("aid =", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotEqualTo(Integer value) {
            addCriterion("aid <>", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidGreaterThan(Integer value) {
            addCriterion("aid >", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidGreaterThanOrEqualTo(Integer value) {
            addCriterion("aid >=", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidLessThan(Integer value) {
            addCriterion("aid <", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidLessThanOrEqualTo(Integer value) {
            addCriterion("aid <=", value, "aid");
            return (Criteria) this;
        }

        public Criteria andAidIn(List<Integer> values) {
            addCriterion("aid in", values, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotIn(List<Integer> values) {
            addCriterion("aid not in", values, "aid");
            return (Criteria) this;
        }

        public Criteria andAidBetween(Integer value1, Integer value2) {
            addCriterion("aid between", value1, value2, "aid");
            return (Criteria) this;
        }

        public Criteria andAidNotBetween(Integer value1, Integer value2) {
            addCriterion("aid not between", value1, value2, "aid");
            return (Criteria) this;
        }

        public Criteria andJidIsNull() {
            addCriterion("jid is null");
            return (Criteria) this;
        }

        public Criteria andJidIsNotNull() {
            addCriterion("jid is not null");
            return (Criteria) this;
        }

        public Criteria andJidEqualTo(Integer value) {
            addCriterion("jid =", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidNotEqualTo(Integer value) {
            addCriterion("jid <>", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidGreaterThan(Integer value) {
            addCriterion("jid >", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidGreaterThanOrEqualTo(Integer value) {
            addCriterion("jid >=", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidLessThan(Integer value) {
            addCriterion("jid <", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidLessThanOrEqualTo(Integer value) {
            addCriterion("jid <=", value, "jid");
            return (Criteria) this;
        }

        public Criteria andJidIn(List<Integer> values) {
            addCriterion("jid in", values, "jid");
            return (Criteria) this;
        }

        public Criteria andJidNotIn(List<Integer> values) {
            addCriterion("jid not in", values, "jid");
            return (Criteria) this;
        }

        public Criteria andJidBetween(Integer value1, Integer value2) {
            addCriterion("jid between", value1, value2, "jid");
            return (Criteria) this;
        }

        public Criteria andJidNotBetween(Integer value1, Integer value2) {
            addCriterion("jid not between", value1, value2, "jid");
            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);
        }
    }
}