package com.miniframe.model.system;

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

public class DPipeSQLBuilder {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DPipeSQLBuilder() {
        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 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 andSnidIsNull() {
            addCriterion("snid is null");
            return (Criteria) this;
        }

        public Criteria andSnidIsNotNull() {
            addCriterion("snid is not null");
            return (Criteria) this;
        }

        public Criteria andSnidEqualTo(Integer value) {
            addCriterion("snid =", value, "snid");
            return (Criteria) this;
        }

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

        public Criteria andSnidGreaterThan(Integer value) {
            addCriterion("snid >", value, "snid");
            return (Criteria) this;
        }

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

        public Criteria andSnidLessThan(Integer value) {
            addCriterion("snid <", value, "snid");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andEnidIsNull() {
            addCriterion("enid is null");
            return (Criteria) this;
        }

        public Criteria andEnidIsNotNull() {
            addCriterion("enid is not null");
            return (Criteria) this;
        }

        public Criteria andEnidEqualTo(Integer value) {
            addCriterion("enid =", value, "enid");
            return (Criteria) this;
        }

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

        public Criteria andEnidGreaterThan(Integer value) {
            addCriterion("enid >", value, "enid");
            return (Criteria) this;
        }

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

        public Criteria andEnidLessThan(Integer value) {
            addCriterion("enid <", value, "enid");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andRoughCoeIsNull() {
            addCriterion("rough_coe is null");
            return (Criteria) this;
        }

        public Criteria andRoughCoeIsNotNull() {
            addCriterion("rough_coe is not null");
            return (Criteria) this;
        }

        public Criteria andRoughCoeEqualTo(Float value) {
            addCriterion("rough_coe =", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeNotEqualTo(Float value) {
            addCriterion("rough_coe <>", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeGreaterThan(Float value) {
            addCriterion("rough_coe >", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeGreaterThanOrEqualTo(Float value) {
            addCriterion("rough_coe >=", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeLessThan(Float value) {
            addCriterion("rough_coe <", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeLessThanOrEqualTo(Float value) {
            addCriterion("rough_coe <=", value, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeIn(List<Float> values) {
            addCriterion("rough_coe in", values, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeNotIn(List<Float> values) {
            addCriterion("rough_coe not in", values, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeBetween(Float value1, Float value2) {
            addCriterion("rough_coe between", value1, value2, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andRoughCoeNotBetween(Float value1, Float value2) {
            addCriterion("rough_coe not between", value1, value2, "roughCoe");
            return (Criteria) this;
        }

        public Criteria andSectionTypeIsNull() {
            addCriterion("section_type is null");
            return (Criteria) this;
        }

        public Criteria andSectionTypeIsNotNull() {
            addCriterion("section_type is not null");
            return (Criteria) this;
        }

        public Criteria andSectionTypeEqualTo(String value) {
            addCriterion("section_type =", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeNotEqualTo(String value) {
            addCriterion("section_type <>", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeGreaterThan(String value) {
            addCriterion("section_type >", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeGreaterThanOrEqualTo(String value) {
            addCriterion("section_type >=", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeLessThan(String value) {
            addCriterion("section_type <", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeLessThanOrEqualTo(String value) {
            addCriterion("section_type <=", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeLike(String value) {
            addCriterion("section_type like", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeNotLike(String value) {
            addCriterion("section_type not like", value, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeIn(List<String> values) {
            addCriterion("section_type in", values, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeNotIn(List<String> values) {
            addCriterion("section_type not in", values, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeBetween(String value1, String value2) {
            addCriterion("section_type between", value1, value2, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionTypeNotBetween(String value1, String value2) {
            addCriterion("section_type not between", value1, value2, "sectionType");
            return (Criteria) this;
        }

        public Criteria andSectionPara1IsNull() {
            addCriterion("section_para1 is null");
            return (Criteria) this;
        }

        public Criteria andSectionPara1IsNotNull() {
            addCriterion("section_para1 is not null");
            return (Criteria) this;
        }

        public Criteria andSectionPara1EqualTo(Float value) {
            addCriterion("section_para1 =", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1NotEqualTo(Float value) {
            addCriterion("section_para1 <>", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1GreaterThan(Float value) {
            addCriterion("section_para1 >", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1GreaterThanOrEqualTo(Float value) {
            addCriterion("section_para1 >=", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1LessThan(Float value) {
            addCriterion("section_para1 <", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1LessThanOrEqualTo(Float value) {
            addCriterion("section_para1 <=", value, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1In(List<Float> values) {
            addCriterion("section_para1 in", values, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1NotIn(List<Float> values) {
            addCriterion("section_para1 not in", values, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1Between(Float value1, Float value2) {
            addCriterion("section_para1 between", value1, value2, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara1NotBetween(Float value1, Float value2) {
            addCriterion("section_para1 not between", value1, value2, "sectionPara1");
            return (Criteria) this;
        }

        public Criteria andSectionPara2IsNull() {
            addCriterion("section_para2 is null");
            return (Criteria) this;
        }

        public Criteria andSectionPara2IsNotNull() {
            addCriterion("section_para2 is not null");
            return (Criteria) this;
        }

        public Criteria andSectionPara2EqualTo(Float value) {
            addCriterion("section_para2 =", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2NotEqualTo(Float value) {
            addCriterion("section_para2 <>", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2GreaterThan(Float value) {
            addCriterion("section_para2 >", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2GreaterThanOrEqualTo(Float value) {
            addCriterion("section_para2 >=", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2LessThan(Float value) {
            addCriterion("section_para2 <", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2LessThanOrEqualTo(Float value) {
            addCriterion("section_para2 <=", value, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2In(List<Float> values) {
            addCriterion("section_para2 in", values, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2NotIn(List<Float> values) {
            addCriterion("section_para2 not in", values, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2Between(Float value1, Float value2) {
            addCriterion("section_para2 between", value1, value2, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara2NotBetween(Float value1, Float value2) {
            addCriterion("section_para2 not between", value1, value2, "sectionPara2");
            return (Criteria) this;
        }

        public Criteria andSectionPara3IsNull() {
            addCriterion("section_para3 is null");
            return (Criteria) this;
        }

        public Criteria andSectionPara3IsNotNull() {
            addCriterion("section_para3 is not null");
            return (Criteria) this;
        }

        public Criteria andSectionPara3EqualTo(Float value) {
            addCriterion("section_para3 =", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3NotEqualTo(Float value) {
            addCriterion("section_para3 <>", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3GreaterThan(Float value) {
            addCriterion("section_para3 >", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3GreaterThanOrEqualTo(Float value) {
            addCriterion("section_para3 >=", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3LessThan(Float value) {
            addCriterion("section_para3 <", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3LessThanOrEqualTo(Float value) {
            addCriterion("section_para3 <=", value, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3In(List<Float> values) {
            addCriterion("section_para3 in", values, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3NotIn(List<Float> values) {
            addCriterion("section_para3 not in", values, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3Between(Float value1, Float value2) {
            addCriterion("section_para3 between", value1, value2, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara3NotBetween(Float value1, Float value2) {
            addCriterion("section_para3 not between", value1, value2, "sectionPara3");
            return (Criteria) this;
        }

        public Criteria andSectionPara4IsNull() {
            addCriterion("section_para4 is null");
            return (Criteria) this;
        }

        public Criteria andSectionPara4IsNotNull() {
            addCriterion("section_para4 is not null");
            return (Criteria) this;
        }

        public Criteria andSectionPara4EqualTo(Float value) {
            addCriterion("section_para4 =", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4NotEqualTo(Float value) {
            addCriterion("section_para4 <>", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4GreaterThan(Float value) {
            addCriterion("section_para4 >", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4GreaterThanOrEqualTo(Float value) {
            addCriterion("section_para4 >=", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4LessThan(Float value) {
            addCriterion("section_para4 <", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4LessThanOrEqualTo(Float value) {
            addCriterion("section_para4 <=", value, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4In(List<Float> values) {
            addCriterion("section_para4 in", values, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4NotIn(List<Float> values) {
            addCriterion("section_para4 not in", values, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4Between(Float value1, Float value2) {
            addCriterion("section_para4 between", value1, value2, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara4NotBetween(Float value1, Float value2) {
            addCriterion("section_para4 not between", value1, value2, "sectionPara4");
            return (Criteria) this;
        }

        public Criteria andSectionPara5IsNull() {
            addCriterion("section_para5 is null");
            return (Criteria) this;
        }

        public Criteria andSectionPara5IsNotNull() {
            addCriterion("section_para5 is not null");
            return (Criteria) this;
        }

        public Criteria andSectionPara5EqualTo(Float value) {
            addCriterion("section_para5 =", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5NotEqualTo(Float value) {
            addCriterion("section_para5 <>", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5GreaterThan(Float value) {
            addCriterion("section_para5 >", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5GreaterThanOrEqualTo(Float value) {
            addCriterion("section_para5 >=", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5LessThan(Float value) {
            addCriterion("section_para5 <", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5LessThanOrEqualTo(Float value) {
            addCriterion("section_para5 <=", value, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5In(List<Float> values) {
            addCriterion("section_para5 in", values, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5NotIn(List<Float> values) {
            addCriterion("section_para5 not in", values, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5Between(Float value1, Float value2) {
            addCriterion("section_para5 between", value1, value2, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andSectionPara5NotBetween(Float value1, Float value2) {
            addCriterion("section_para5 not between", value1, value2, "sectionPara5");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

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

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

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

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

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

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andGfidIsNull() {
            addCriterion("gfid is null");
            return (Criteria) this;
        }

        public Criteria andGfidIsNotNull() {
            addCriterion("gfid is not null");
            return (Criteria) this;
        }

        public Criteria andGfidEqualTo(String value) {
            addCriterion("gfid =", value, "gfid");
            return (Criteria) this;
        }

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

        public Criteria andGfidGreaterThan(String value) {
            addCriterion("gfid >", value, "gfid");
            return (Criteria) this;
        }

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

        public Criteria andGfidLessThan(String value) {
            addCriterion("gfid <", value, "gfid");
            return (Criteria) this;
        }

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

        public Criteria andGfidLike(String value) {
            addCriterion("gfid like", value, "gfid");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andBfidIsNull() {
            addCriterion("bfid is null");
            return (Criteria) this;
        }

        public Criteria andBfidIsNotNull() {
            addCriterion("bfid is not null");
            return (Criteria) this;
        }

        public Criteria andBfidEqualTo(String value) {
            addCriterion("bfid =", value, "bfid");
            return (Criteria) this;
        }

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

        public Criteria andBfidGreaterThan(String value) {
            addCriterion("bfid >", value, "bfid");
            return (Criteria) this;
        }

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

        public Criteria andBfidLessThan(String value) {
            addCriterion("bfid <", value, "bfid");
            return (Criteria) this;
        }

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

        public Criteria andBfidLike(String value) {
            addCriterion("bfid like", value, "bfid");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andGfnameIsNull() {
            addCriterion("gfname is null");
            return (Criteria) this;
        }

        public Criteria andGfnameIsNotNull() {
            addCriterion("gfname is not null");
            return (Criteria) this;
        }

        public Criteria andGfnameEqualTo(String value) {
            addCriterion("gfname =", value, "gfname");
            return (Criteria) this;
        }

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

        public Criteria andGfnameGreaterThan(String value) {
            addCriterion("gfname >", value, "gfname");
            return (Criteria) this;
        }

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

        public Criteria andGfnameLessThan(String value) {
            addCriterion("gfname <", value, "gfname");
            return (Criteria) this;
        }

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

        public Criteria andGfnameLike(String value) {
            addCriterion("gfname like", value, "gfname");
            return (Criteria) this;
        }

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

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

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

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

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

        public Criteria andBfnameIsNull() {
            addCriterion("bfname is null");
            return (Criteria) this;
        }

        public Criteria andBfnameIsNotNull() {
            addCriterion("bfname is not null");
            return (Criteria) this;
        }

        public Criteria andBfnameEqualTo(String value) {
            addCriterion("bfname =", value, "bfname");
            return (Criteria) this;
        }

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

        public Criteria andBfnameGreaterThan(String value) {
            addCriterion("bfname >", value, "bfname");
            return (Criteria) this;
        }

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

        public Criteria andBfnameLessThan(String value) {
            addCriterion("bfname <", value, "bfname");
            return (Criteria) this;
        }

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

        public Criteria andBfnameLike(String value) {
            addCriterion("bfname like", value, "bfname");
            return (Criteria) this;
        }

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

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

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

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

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