ifm/javasrc/ibatis/com/huimv/sjlr/dataobject/SjlrDnjlExample.java

package com.huimv.sjlr.dataobject;

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

public class SjlrDnjlExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public SjlrDnjlExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected SjlrDnjlExample(SjlrDnjlExample example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public void setStart(int start) {
        this.start=start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public void setLimit(int limit) {
        this.limit=limit;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sjlr_dnjl
     *
     * @ibatorgenerated Thu Feb 23 13:43:48 CST 2017
     */
    public static class Criteria {
        protected List<String> criteriaWithoutValue;

        protected List<Map<String, Object>> criteriaWithSingleValue;

        protected List<Map<String, Object>> criteriaWithListValue;

        protected List<Map<String, Object>> criteriaWithBetweenValue;

        protected Criteria() {
            super();
            criteriaWithoutValue = new ArrayList<String>();
            criteriaWithSingleValue = new ArrayList<Map<String, Object>>();
            criteriaWithListValue = new ArrayList<Map<String, Object>>();
            criteriaWithBetweenValue = new ArrayList<Map<String, Object>>();
        }

        public boolean isValid() {
            return criteriaWithoutValue.size() > 0
                || criteriaWithSingleValue.size() > 0
                || criteriaWithListValue.size() > 0
                || criteriaWithBetweenValue.size() > 0;
        }

        public List<String> getCriteriaWithoutValue() {
            return criteriaWithoutValue;
        }

        public List<Map<String, Object>> getCriteriaWithSingleValue() {
            return criteriaWithSingleValue;
        }

        public List<Map<String, Object>> getCriteriaWithListValue() {
            return criteriaWithListValue;
        }

        public List<Map<String, Object>> getCriteriaWithBetweenValue() {
            return criteriaWithBetweenValue;
        }

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

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("value", value);
            criteriaWithSingleValue.add(map);
        }

        protected void addCriterion(String condition, List<? extends Object> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", values);
            criteriaWithListValue.add(map);
        }

        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");
            }
            List<Object> list = new ArrayList<Object>();
            list.add(value1);
            list.add(value2);
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", list);
            criteriaWithBetweenValue.add(map);
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andDnsjIsNull() {
            addCriterion("DNSJ is null");
            return this;
        }

        public Criteria andDnsjIsNotNull() {
            addCriterion("DNSJ is not null");
            return this;
        }

        public Criteria andDnsjEqualTo(Date value) {
            addCriterion("DNSJ =", value, "dnsj");
            return this;
        }

        public Criteria andDnsjNotEqualTo(Date value) {
            addCriterion("DNSJ <>", value, "dnsj");
            return this;
        }

        public Criteria andDnsjGreaterThan(Date value) {
            addCriterion("DNSJ >", value, "dnsj");
            return this;
        }

        public Criteria andDnsjGreaterThanOrEqualTo(Date value) {
            addCriterion("DNSJ >=", value, "dnsj");
            return this;
        }

        public Criteria andDnsjLessThan(Date value) {
            addCriterion("DNSJ <", value, "dnsj");
            return this;
        }

        public Criteria andDnsjLessThanOrEqualTo(Date value) {
            addCriterion("DNSJ <=", value, "dnsj");
            return this;
        }

        public Criteria andDnsjIn(List<Date> values) {
            addCriterion("DNSJ in", values, "dnsj");
            return this;
        }

        public Criteria andDnsjNotIn(List<Date> values) {
            addCriterion("DNSJ not in", values, "dnsj");
            return this;
        }

        public Criteria andDnsjBetween(Date value1, Date value2) {
            addCriterion("DNSJ between", value1, value2, "dnsj");
            return this;
        }

        public Criteria andDnsjNotBetween(Date value1, Date value2) {
            addCriterion("DNSJ not between", value1, value2, "dnsj");
            return this;
        }

        public Criteria andDwebIsNull() {
            addCriterion("DWEB is null");
            return this;
        }

        public Criteria andDwebIsNotNull() {
            addCriterion("DWEB is not null");
            return this;
        }

        public Criteria andDwebEqualTo(String value) {
            addCriterion("DWEB =", value, "dweb");
            return this;
        }

        public Criteria andDwebNotEqualTo(String value) {
            addCriterion("DWEB <>", value, "dweb");
            return this;
        }

        public Criteria andDwebGreaterThan(String value) {
            addCriterion("DWEB >", value, "dweb");
            return this;
        }

        public Criteria andDwebGreaterThanOrEqualTo(String value) {
            addCriterion("DWEB >=", value, "dweb");
            return this;
        }

        public Criteria andDwebLessThan(String value) {
            addCriterion("DWEB <", value, "dweb");
            return this;
        }

        public Criteria andDwebLessThanOrEqualTo(String value) {
            addCriterion("DWEB <=", value, "dweb");
            return this;
        }

        public Criteria andDwebLike(String value) {
            addCriterion("DWEB like", value, "dweb");
            return this;
        }

        public Criteria andDwebNotLike(String value) {
            addCriterion("DWEB not like", value, "dweb");
            return this;
        }

        public Criteria andDwebIn(List<String> values) {
            addCriterion("DWEB in", values, "dweb");
            return this;
        }

        public Criteria andDwebNotIn(List<String> values) {
            addCriterion("DWEB not in", values, "dweb");
            return this;
        }

        public Criteria andDwebBetween(String value1, String value2) {
            addCriterion("DWEB between", value1, value2, "dweb");
            return this;
        }

        public Criteria andDwebNotBetween(String value1, String value2) {
            addCriterion("DWEB not between", value1, value2, "dweb");
            return this;
        }

        public Criteria andDnslIsNull() {
            addCriterion("DNSL is null");
            return this;
        }

        public Criteria andDnslIsNotNull() {
            addCriterion("DNSL is not null");
            return this;
        }

        public Criteria andDnslEqualTo(String value) {
            addCriterion("DNSL =", value, "dnsl");
            return this;
        }

        public Criteria andDnslNotEqualTo(String value) {
            addCriterion("DNSL <>", value, "dnsl");
            return this;
        }

        public Criteria andDnslGreaterThan(String value) {
            addCriterion("DNSL >", value, "dnsl");
            return this;
        }

        public Criteria andDnslGreaterThanOrEqualTo(String value) {
            addCriterion("DNSL >=", value, "dnsl");
            return this;
        }

        public Criteria andDnslLessThan(String value) {
            addCriterion("DNSL <", value, "dnsl");
            return this;
        }

        public Criteria andDnslLessThanOrEqualTo(String value) {
            addCriterion("DNSL <=", value, "dnsl");
            return this;
        }

        public Criteria andDnslLike(String value) {
            addCriterion("DNSL like", value, "dnsl");
            return this;
        }

        public Criteria andDnslNotLike(String value) {
            addCriterion("DNSL not like", value, "dnsl");
            return this;
        }

        public Criteria andDnslIn(List<String> values) {
            addCriterion("DNSL in", values, "dnsl");
            return this;
        }

        public Criteria andDnslNotIn(List<String> values) {
            addCriterion("DNSL not in", values, "dnsl");
            return this;
        }

        public Criteria andDnslBetween(String value1, String value2) {
            addCriterion("DNSL between", value1, value2, "dnsl");
            return this;
        }

        public Criteria andDnslNotBetween(String value1, String value2) {
            addCriterion("DNSL not between", value1, value2, "dnsl");
            return this;
        }

        public Criteria andZrslIsNull() {
            addCriterion("ZRSL is null");
            return this;
        }

        public Criteria andZrslIsNotNull() {
            addCriterion("ZRSL is not null");
            return this;
        }

        public Criteria andZrslEqualTo(String value) {
            addCriterion("ZRSL =", value, "zrsl");
            return this;
        }

        public Criteria andZrslNotEqualTo(String value) {
            addCriterion("ZRSL <>", value, "zrsl");
            return this;
        }

        public Criteria andZrslGreaterThan(String value) {
            addCriterion("ZRSL >", value, "zrsl");
            return this;
        }

        public Criteria andZrslGreaterThanOrEqualTo(String value) {
            addCriterion("ZRSL >=", value, "zrsl");
            return this;
        }

        public Criteria andZrslLessThan(String value) {
            addCriterion("ZRSL <", value, "zrsl");
            return this;
        }

        public Criteria andZrslLessThanOrEqualTo(String value) {
            addCriterion("ZRSL <=", value, "zrsl");
            return this;
        }

        public Criteria andZrslLike(String value) {
            addCriterion("ZRSL like", value, "zrsl");
            return this;
        }

        public Criteria andZrslNotLike(String value) {
            addCriterion("ZRSL not like", value, "zrsl");
            return this;
        }

        public Criteria andZrslIn(List<String> values) {
            addCriterion("ZRSL in", values, "zrsl");
            return this;
        }

        public Criteria andZrslNotIn(List<String> values) {
            addCriterion("ZRSL not in", values, "zrsl");
            return this;
        }

        public Criteria andZrslBetween(String value1, String value2) {
            addCriterion("ZRSL between", value1, value2, "zrsl");
            return this;
        }

        public Criteria andZrslNotBetween(String value1, String value2) {
            addCriterion("ZRSL not between", value1, value2, "zrsl");
            return this;
        }

        public Criteria andZzzsIsNull() {
            addCriterion("ZZZS is null");
            return this;
        }

        public Criteria andZzzsIsNotNull() {
            addCriterion("ZZZS is not null");
            return this;
        }

        public Criteria andZzzsEqualTo(Integer value) {
            addCriterion("ZZZS =", value, "zzzs");
            return this;
        }

        public Criteria andZzzsNotEqualTo(Integer value) {
            addCriterion("ZZZS <>", value, "zzzs");
            return this;
        }

        public Criteria andZzzsGreaterThan(Integer value) {
            addCriterion("ZZZS >", value, "zzzs");
            return this;
        }

        public Criteria andZzzsGreaterThanOrEqualTo(Integer value) {
            addCriterion("ZZZS >=", value, "zzzs");
            return this;
        }

        public Criteria andZzzsLessThan(Integer value) {
            addCriterion("ZZZS <", value, "zzzs");
            return this;
        }

        public Criteria andZzzsLessThanOrEqualTo(Integer value) {
            addCriterion("ZZZS <=", value, "zzzs");
            return this;
        }

        public Criteria andZzzsIn(List<Integer> values) {
            addCriterion("ZZZS in", values, "zzzs");
            return this;
        }

        public Criteria andZzzsNotIn(List<Integer> values) {
            addCriterion("ZZZS not in", values, "zzzs");
            return this;
        }

        public Criteria andZzzsBetween(Integer value1, Integer value2) {
            addCriterion("ZZZS between", value1, value2, "zzzs");
            return this;
        }

        public Criteria andZzzsNotBetween(Integer value1, Integer value2) {
            addCriterion("ZZZS not between", value1, value2, "zzzs");
            return this;
        }

        public Criteria andDnwzIsNull() {
            addCriterion("DNWZ is null");
            return this;
        }

        public Criteria andDnwzIsNotNull() {
            addCriterion("DNWZ is not null");
            return this;
        }

        public Criteria andDnwzEqualTo(String value) {
            addCriterion("DNWZ =", value, "dnwz");
            return this;
        }

        public Criteria andDnwzNotEqualTo(String value) {
            addCriterion("DNWZ <>", value, "dnwz");
            return this;
        }

        public Criteria andDnwzGreaterThan(String value) {
            addCriterion("DNWZ >", value, "dnwz");
            return this;
        }

        public Criteria andDnwzGreaterThanOrEqualTo(String value) {
            addCriterion("DNWZ >=", value, "dnwz");
            return this;
        }

        public Criteria andDnwzLessThan(String value) {
            addCriterion("DNWZ <", value, "dnwz");
            return this;
        }

        public Criteria andDnwzLessThanOrEqualTo(String value) {
            addCriterion("DNWZ <=", value, "dnwz");
            return this;
        }

        public Criteria andDnwzLike(String value) {
            addCriterion("DNWZ like", value, "dnwz");
            return this;
        }

        public Criteria andDnwzNotLike(String value) {
            addCriterion("DNWZ not like", value, "dnwz");
            return this;
        }

        public Criteria andDnwzIn(List<String> values) {
            addCriterion("DNWZ in", values, "dnwz");
            return this;
        }

        public Criteria andDnwzNotIn(List<String> values) {
            addCriterion("DNWZ not in", values, "dnwz");
            return this;
        }

        public Criteria andDnwzBetween(String value1, String value2) {
            addCriterion("DNWZ between", value1, value2, "dnwz");
            return this;
        }

        public Criteria andDnwzNotBetween(String value1, String value2) {
            addCriterion("DNWZ not between", value1, value2, "dnwz");
            return this;
        }

        public Criteria andJrsIsNull() {
            addCriterion("JRS is null");
            return this;
        }

        public Criteria andJrsIsNotNull() {
            addCriterion("JRS is not null");
            return this;
        }

        public Criteria andJrsEqualTo(Integer value) {
            addCriterion("JRS =", value, "jrs");
            return this;
        }

        public Criteria andJrsNotEqualTo(Integer value) {
            addCriterion("JRS <>", value, "jrs");
            return this;
        }

        public Criteria andJrsGreaterThan(Integer value) {
            addCriterion("JRS >", value, "jrs");
            return this;
        }

        public Criteria andJrsGreaterThanOrEqualTo(Integer value) {
            addCriterion("JRS >=", value, "jrs");
            return this;
        }

        public Criteria andJrsLessThan(Integer value) {
            addCriterion("JRS <", value, "jrs");
            return this;
        }

        public Criteria andJrsLessThanOrEqualTo(Integer value) {
            addCriterion("JRS <=", value, "jrs");
            return this;
        }

        public Criteria andJrsIn(List<Integer> values) {
            addCriterion("JRS in", values, "jrs");
            return this;
        }

        public Criteria andJrsNotIn(List<Integer> values) {
            addCriterion("JRS not in", values, "jrs");
            return this;
        }

        public Criteria andJrsBetween(Integer value1, Integer value2) {
            addCriterion("JRS between", value1, value2, "jrs");
            return this;
        }

        public Criteria andJrsNotBetween(Integer value1, Integer value2) {
            addCriterion("JRS not between", value1, value2, "jrs");
            return this;
        }

        public Criteria andJcsIsNull() {
            addCriterion("JCS is null");
            return this;
        }

        public Criteria andJcsIsNotNull() {
            addCriterion("JCS is not null");
            return this;
        }

        public Criteria andJcsEqualTo(Integer value) {
            addCriterion("JCS =", value, "jcs");
            return this;
        }

        public Criteria andJcsNotEqualTo(Integer value) {
            addCriterion("JCS <>", value, "jcs");
            return this;
        }

        public Criteria andJcsGreaterThan(Integer value) {
            addCriterion("JCS >", value, "jcs");
            return this;
        }

        public Criteria andJcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("JCS >=", value, "jcs");
            return this;
        }

        public Criteria andJcsLessThan(Integer value) {
            addCriterion("JCS <", value, "jcs");
            return this;
        }

        public Criteria andJcsLessThanOrEqualTo(Integer value) {
            addCriterion("JCS <=", value, "jcs");
            return this;
        }

        public Criteria andJcsIn(List<Integer> values) {
            addCriterion("JCS in", values, "jcs");
            return this;
        }

        public Criteria andJcsNotIn(List<Integer> values) {
            addCriterion("JCS not in", values, "jcs");
            return this;
        }

        public Criteria andJcsBetween(Integer value1, Integer value2) {
            addCriterion("JCS between", value1, value2, "jcs");
            return this;
        }

        public Criteria andJcsNotBetween(Integer value1, Integer value2) {
            addCriterion("JCS not between", value1, value2, "jcs");
            return this;
        }

        public Criteria andBbIsNull() {
            addCriterion("BB is null");
            return this;
        }

        public Criteria andBbIsNotNull() {
            addCriterion("BB is not null");
            return this;
        }

        public Criteria andBbEqualTo(String value) {
            addCriterion("BB =", value, "bb");
            return this;
        }

        public Criteria andBbNotEqualTo(String value) {
            addCriterion("BB <>", value, "bb");
            return this;
        }

        public Criteria andBbGreaterThan(String value) {
            addCriterion("BB >", value, "bb");
            return this;
        }

        public Criteria andBbGreaterThanOrEqualTo(String value) {
            addCriterion("BB >=", value, "bb");
            return this;
        }

        public Criteria andBbLessThan(String value) {
            addCriterion("BB <", value, "bb");
            return this;
        }

        public Criteria andBbLessThanOrEqualTo(String value) {
            addCriterion("BB <=", value, "bb");
            return this;
        }

        public Criteria andBbLike(String value) {
            addCriterion("BB like", value, "bb");
            return this;
        }

        public Criteria andBbNotLike(String value) {
            addCriterion("BB not like", value, "bb");
            return this;
        }

        public Criteria andBbIn(List<String> values) {
            addCriterion("BB in", values, "bb");
            return this;
        }

        public Criteria andBbNotIn(List<String> values) {
            addCriterion("BB not in", values, "bb");
            return this;
        }

        public Criteria andBbBetween(String value1, String value2) {
            addCriterion("BB between", value1, value2, "bb");
            return this;
        }

        public Criteria andBbNotBetween(String value1, String value2) {
            addCriterion("BB not between", value1, value2, "bb");
            return this;
        }

        public Criteria andFmidIsNull() {
            addCriterion("FMID is null");
            return this;
        }

        public Criteria andFmidIsNotNull() {
            addCriterion("FMID is not null");
            return this;
        }

        public Criteria andFmidEqualTo(Integer value) {
            addCriterion("FMID =", value, "fmid");
            return this;
        }

        public Criteria andFmidNotEqualTo(Integer value) {
            addCriterion("FMID <>", value, "fmid");
            return this;
        }

        public Criteria andFmidGreaterThan(Integer value) {
            addCriterion("FMID >", value, "fmid");
            return this;
        }

        public Criteria andFmidGreaterThanOrEqualTo(Integer value) {
            addCriterion("FMID >=", value, "fmid");
            return this;
        }

        public Criteria andFmidLessThan(Integer value) {
            addCriterion("FMID <", value, "fmid");
            return this;
        }

        public Criteria andFmidLessThanOrEqualTo(Integer value) {
            addCriterion("FMID <=", value, "fmid");
            return this;
        }

        public Criteria andFmidIn(List<Integer> values) {
            addCriterion("FMID in", values, "fmid");
            return this;
        }

        public Criteria andFmidNotIn(List<Integer> values) {
            addCriterion("FMID not in", values, "fmid");
            return this;
        }

        public Criteria andFmidBetween(Integer value1, Integer value2) {
            addCriterion("FMID between", value1, value2, "fmid");
            return this;
        }

        public Criteria andFmidNotBetween(Integer value1, Integer value2) {
            addCriterion("FMID not between", value1, value2, "fmid");
            return this;
        }

        public Criteria andXgrIsNull() {
            addCriterion("XGR is null");
            return this;
        }

        public Criteria andXgrIsNotNull() {
            addCriterion("XGR is not null");
            return this;
        }

        public Criteria andXgrEqualTo(String value) {
            addCriterion("XGR =", value, "xgr");
            return this;
        }

        public Criteria andXgrNotEqualTo(String value) {
            addCriterion("XGR <>", value, "xgr");
            return this;
        }

        public Criteria andXgrGreaterThan(String value) {
            addCriterion("XGR >", value, "xgr");
            return this;
        }

        public Criteria andXgrGreaterThanOrEqualTo(String value) {
            addCriterion("XGR >=", value, "xgr");
            return this;
        }

        public Criteria andXgrLessThan(String value) {
            addCriterion("XGR <", value, "xgr");
            return this;
        }

        public Criteria andXgrLessThanOrEqualTo(String value) {
            addCriterion("XGR <=", value, "xgr");
            return this;
        }

        public Criteria andXgrLike(String value) {
            addCriterion("XGR like", value, "xgr");
            return this;
        }

        public Criteria andXgrNotLike(String value) {
            addCriterion("XGR not like", value, "xgr");
            return this;
        }

        public Criteria andXgrIn(List<String> values) {
            addCriterion("XGR in", values, "xgr");
            return this;
        }

        public Criteria andXgrNotIn(List<String> values) {
            addCriterion("XGR not in", values, "xgr");
            return this;
        }

        public Criteria andXgrBetween(String value1, String value2) {
            addCriterion("XGR between", value1, value2, "xgr");
            return this;
        }

        public Criteria andXgrNotBetween(String value1, String value2) {
            addCriterion("XGR not between", value1, value2, "xgr");
            return this;
        }

        public Criteria andXgsjIsNull() {
            addCriterion("XGSJ is null");
            return this;
        }

        public Criteria andXgsjIsNotNull() {
            addCriterion("XGSJ is not null");
            return this;
        }

        public Criteria andXgsjEqualTo(Date value) {
            addCriterion("XGSJ =", value, "xgsj");
            return this;
        }

        public Criteria andXgsjNotEqualTo(Date value) {
            addCriterion("XGSJ <>", value, "xgsj");
            return this;
        }

        public Criteria andXgsjGreaterThan(Date value) {
            addCriterion("XGSJ >", value, "xgsj");
            return this;
        }

        public Criteria andXgsjGreaterThanOrEqualTo(Date value) {
            addCriterion("XGSJ >=", value, "xgsj");
            return this;
        }

        public Criteria andXgsjLessThan(Date value) {
            addCriterion("XGSJ <", value, "xgsj");
            return this;
        }

        public Criteria andXgsjLessThanOrEqualTo(Date value) {
            addCriterion("XGSJ <=", value, "xgsj");
            return this;
        }

        public Criteria andXgsjIn(List<Date> values) {
            addCriterion("XGSJ in", values, "xgsj");
            return this;
        }

        public Criteria andXgsjNotIn(List<Date> values) {
            addCriterion("XGSJ not in", values, "xgsj");
            return this;
        }

        public Criteria andXgsjBetween(Date value1, Date value2) {
            addCriterion("XGSJ between", value1, value2, "xgsj");
            return this;
        }

        public Criteria andXgsjNotBetween(Date value1, Date value2) {
            addCriterion("XGSJ not between", value1, value2, "xgsj");
            return this;
        }

        public Criteria andZfbzIsNull() {
            addCriterion("ZFBZ is null");
            return this;
        }

        public Criteria andZfbzIsNotNull() {
            addCriterion("ZFBZ is not null");
            return this;
        }

        public Criteria andZfbzEqualTo(Integer value) {
            addCriterion("ZFBZ =", value, "zfbz");
            return this;
        }

        public Criteria andZfbzNotEqualTo(Integer value) {
            addCriterion("ZFBZ <>", value, "zfbz");
            return this;
        }

        public Criteria andZfbzGreaterThan(Integer value) {
            addCriterion("ZFBZ >", value, "zfbz");
            return this;
        }

        public Criteria andZfbzGreaterThanOrEqualTo(Integer value) {
            addCriterion("ZFBZ >=", value, "zfbz");
            return this;
        }

        public Criteria andZfbzLessThan(Integer value) {
            addCriterion("ZFBZ <", value, "zfbz");
            return this;
        }

        public Criteria andZfbzLessThanOrEqualTo(Integer value) {
            addCriterion("ZFBZ <=", value, "zfbz");
            return this;
        }

        public Criteria andZfbzIn(List<Integer> values) {
            addCriterion("ZFBZ in", values, "zfbz");
            return this;
        }

        public Criteria andZfbzNotIn(List<Integer> values) {
            addCriterion("ZFBZ not in", values, "zfbz");
            return this;
        }

        public Criteria andZfbzBetween(Integer value1, Integer value2) {
            addCriterion("ZFBZ between", value1, value2, "zfbz");
            return this;
        }

        public Criteria andZfbzNotBetween(Integer value1, Integer value2) {
            addCriterion("ZFBZ not between", value1, value2, "zfbz");
            return this;
        }
    }
}