/*
 * MIT License
 *
 * Copyright (c) [2023]
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 */
package com.alipay.altershield.defender.changewindow.dal.dataobject;

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

/**
 * This class was generated by Ali-Generator
 *
 * @author shengzhang
 */
public class MetaReleaseChangeParam {
    /**
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     *
     * @mbg.generated
     */
    @Deprecated
    protected boolean distinct;

    /**
     *
     * @mbg.generated
     */
    protected boolean page;

    /**
     *
     * @mbg.generated
     */
    protected int pageIndex;

    /**
     *
     * @mbg.generated
     */
    protected int pageSize;

    /**
     *
     * @mbg.generated
     */
    protected int pageStart;

    /**
     *
     * @mbg.generated
     */
    protected String distinctSql;

    /**
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @param orderCondition
     * @param sortType
     * @return
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam appendOrderByClause(OrderCondition orderCondition,
                                                      SortType sortType) {
        if (null != orderByClause) {
            orderByClause = orderByClause + ", " + orderCondition.getColumnName() + " "
                    + sortType.getValue();
        } else {
            orderByClause = orderCondition.getColumnName() + " " + sortType.getValue();
        }
        return this;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * @param distinct
     *
     * @mbg.generated
     */
    @Deprecated
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    @Deprecated
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * @param page
     * @return
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam setPage(boolean page) {
        this.page = page;
        return this;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public boolean isPage() {
        return page;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public int getPageIndex() {
        return pageIndex;
    }

    /**
     * @param pageSize
     * @return
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam setPageSize(int pageSize) {
        this.pageSize = pageSize < 1 ? 10 : pageSize;
        this.pageIndex = pageStart < 1 ? 0 : (pageStart - 1) * this.pageSize;
        return this;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public int getPageSize() {
        return pageSize;
    }

    /**
     * @param pageStart
     * @return
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam setPageStart(int pageStart) {
        this.pageStart = pageStart < 1 ? 1 : pageStart;
        this.pageIndex = (this.pageStart - 1) * this.pageSize;
        return this;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public int getPageStart() {
        return pageStart;
    }

    /**
     * @param pageStart
     * @param pageSize
     *
     * @mbg.generated
     */
    public void setPagination(int pageStart, int pageSize) {
        this.page = true;
        this.pageSize = pageSize < 1 ? 10 : pageSize;
        this.pageIndex = pageStart < 1 ? 0 : (pageStart - 1) * this.pageSize;
    }

    /**
     * @param condition
     * @return
     *
     * @mbg.generated
     */
    public MetaReleaseChangeParam appendDistinct(OrderCondition condition) {
        if (null != distinctSql) {
            distinctSql = distinctSql + ", " + condition.getColumnName();
        } else {
            distinctSql = condition.getColumnName();
        }
        return this;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * @param criteria
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * @return
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *
     * @mbg.generated
     */
    protected abstract static class AbstractGeneratedCriteria {
        protected List<Criterion> criteria;

        protected AbstractGeneratedCriteria() {
            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(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(Date value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(Date value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(Date value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(Date value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<Date> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<Date> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(Date value1, Date value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(String value) {
            addCriterion("operator =", value, "operator");
            return (Criteria) this;
        }

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

        public Criteria andOperatorGreaterThan(String value) {
            addCriterion("operator >", value, "operator");
            return (Criteria) this;
        }

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

        public Criteria andOperatorLessThan(String value) {
            addCriterion("operator <", value, "operator");
            return (Criteria) this;
        }

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

        public Criteria andOperatorLike(String value) {
            addCriterion("operator like", value, "operator");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

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

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

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

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

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

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andBlockchangeIdIsNull() {
            addCriterion("blockchange_id is null");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdIsNotNull() {
            addCriterion("blockchange_id is not null");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdEqualTo(String value) {
            addCriterion("blockchange_id =", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdNotEqualTo(String value) {
            addCriterion("blockchange_id <>", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdGreaterThan(String value) {
            addCriterion("blockchange_id >", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdGreaterThanOrEqualTo(String value) {
            addCriterion("blockchange_id >=", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdLessThan(String value) {
            addCriterion("blockchange_id <", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdLessThanOrEqualTo(String value) {
            addCriterion("blockchange_id <=", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdLike(String value) {
            addCriterion("blockchange_id like", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdNotLike(String value) {
            addCriterion("blockchange_id not like", value, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdIn(List<String> values) {
            addCriterion("blockchange_id in", values, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdNotIn(List<String> values) {
            addCriterion("blockchange_id not in", values, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdBetween(String value1, String value2) {
            addCriterion("blockchange_id between", value1, value2, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeIdNotBetween(String value1, String value2) {
            addCriterion("blockchange_id not between", value1, value2, "blockchangeId");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameIsNull() {
            addCriterion("blockchange_name is null");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameIsNotNull() {
            addCriterion("blockchange_name is not null");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameEqualTo(String value) {
            addCriterion("blockchange_name =", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameNotEqualTo(String value) {
            addCriterion("blockchange_name <>", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameGreaterThan(String value) {
            addCriterion("blockchange_name >", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameGreaterThanOrEqualTo(String value) {
            addCriterion("blockchange_name >=", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameLessThan(String value) {
            addCriterion("blockchange_name <", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameLessThanOrEqualTo(String value) {
            addCriterion("blockchange_name <=", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameLike(String value) {
            addCriterion("blockchange_name like", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameNotLike(String value) {
            addCriterion("blockchange_name not like", value, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameIn(List<String> values) {
            addCriterion("blockchange_name in", values, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameNotIn(List<String> values) {
            addCriterion("blockchange_name not in", values, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameBetween(String value1, String value2) {
            addCriterion("blockchange_name between", value1, value2, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andBlockchangeNameNotBetween(String value1, String value2) {
            addCriterion("blockchange_name not between", value1, value2, "blockchangeName");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("start_time is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("start_time is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("start_time =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("start_time <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("start_time >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("start_time >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("start_time <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("start_time <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("start_time in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("start_time not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("start_time between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("start_time not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("end_time is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("end_time is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("end_time =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("end_time <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("end_time >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("end_time >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("end_time <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("end_time <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("end_time in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("end_time not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("end_time between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("end_time not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentIsNull() {
            addCriterion("effect_environment is null");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentIsNotNull() {
            addCriterion("effect_environment is not null");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentEqualTo(String value) {
            addCriterion("effect_environment =", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentNotEqualTo(String value) {
            addCriterion("effect_environment <>", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentGreaterThan(String value) {
            addCriterion("effect_environment >", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentGreaterThanOrEqualTo(String value) {
            addCriterion("effect_environment >=", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentLessThan(String value) {
            addCriterion("effect_environment <", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentLessThanOrEqualTo(String value) {
            addCriterion("effect_environment <=", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentLike(String value) {
            addCriterion("effect_environment like", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentNotLike(String value) {
            addCriterion("effect_environment not like", value, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentIn(List<String> values) {
            addCriterion("effect_environment in", values, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentNotIn(List<String> values) {
            addCriterion("effect_environment not in", values, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentBetween(String value1, String value2) {
            addCriterion("effect_environment between", value1, value2, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andEffectEnvironmentNotBetween(String value1, String value2) {
            addCriterion("effect_environment not between", value1, value2, "effectEnvironment");
            return (Criteria) this;
        }

        public Criteria andReasonRefIsNull() {
            addCriterion("reason_ref is null");
            return (Criteria) this;
        }

        public Criteria andReasonRefIsNotNull() {
            addCriterion("reason_ref is not null");
            return (Criteria) this;
        }

        public Criteria andReasonRefEqualTo(String value) {
            addCriterion("reason_ref =", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefNotEqualTo(String value) {
            addCriterion("reason_ref <>", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefGreaterThan(String value) {
            addCriterion("reason_ref >", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefGreaterThanOrEqualTo(String value) {
            addCriterion("reason_ref >=", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefLessThan(String value) {
            addCriterion("reason_ref <", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefLessThanOrEqualTo(String value) {
            addCriterion("reason_ref <=", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefLike(String value) {
            addCriterion("reason_ref like", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefNotLike(String value) {
            addCriterion("reason_ref not like", value, "reasonRef");
            return (Criteria) this;
        }

        public Criteria andReasonRefIn(List<String> values) {
            addCriterion("reason_ref in", values, "reasonRef");
            return (Criteria) this;
        }

