ifm/javasrc/ibatis/com/huimv/sjlr/dataobject/SjlrCjjlExample.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 SjlrCjjlExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public SjlrCjjlExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    protected SjlrCjjlExample(SjlrCjjlExample 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 CST 2017
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sjlr_cjjl
     *
     * @ibatorgenerated Wed Mar 08 10:36:51 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 andCjsjIsNull() {
            addCriterion("CJSJ is null");
            return this;
        }

        public Criteria andCjsjIsNotNull() {
            addCriterion("CJSJ is not null");
            return this;
        }

        public Criteria andCjsjEqualTo(Date value) {
            addCriterion("CJSJ =", value, "cjsj");
            return this;
        }

        public Criteria andCjsjNotEqualTo(Date value) {
            addCriterion("CJSJ <>", value, "cjsj");
            return this;
        }

        public Criteria andCjsjGreaterThan(Date value) {
            addCriterion("CJSJ >", value, "cjsj");
            return this;
        }

        public Criteria andCjsjGreaterThanOrEqualTo(Date value) {
            addCriterion("CJSJ >=", value, "cjsj");
            return this;
        }

        public Criteria andCjsjLessThan(Date value) {
            addCriterion("CJSJ <", value, "cjsj");
            return this;
        }

        public Criteria andCjsjLessThanOrEqualTo(Date value) {
            addCriterion("CJSJ <=", value, "cjsj");
            return this;
        }

        public Criteria andCjsjIn(List<Date> values) {
            addCriterion("CJSJ in", values, "cjsj");
            return this;
        }

        public Criteria andCjsjNotIn(List<Date> values) {
            addCriterion("CJSJ not in", values, "cjsj");
            return this;
        }

        public Criteria andCjsjBetween(Date value1, Date value2) {
            addCriterion("CJSJ between", value1, value2, "cjsj");
            return this;
        }

        public Criteria andCjsjNotBetween(Date value1, Date value2) {
            addCriterion("CJSJ not between", value1, value2, "cjsj");
            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 andCjslIsNull() {
            addCriterion("CJSL is null");
            return this;
        }

        public Criteria andCjslIsNotNull() {
            addCriterion("CJSL is not null");
            return this;
        }

        public Criteria andCjslEqualTo(String value) {
            addCriterion("CJSL =", value, "cjsl");
            return this;
        }

        public Criteria andCjslNotEqualTo(String value) {
            addCriterion("CJSL <>", value, "cjsl");
            return this;
        }

        public Criteria andCjslGreaterThan(String value) {
            addCriterion("CJSL >", value, "cjsl");
            return this;
        }

        public Criteria andCjslGreaterThanOrEqualTo(String value) {
            addCriterion("CJSL >=", value, "cjsl");
            return this;
        }

        public Criteria andCjslLessThan(String value) {
            addCriterion("CJSL <", value, "cjsl");
            return this;
        }

        public Criteria andCjslLessThanOrEqualTo(String value) {
            addCriterion("CJSL <=", value, "cjsl");
            return this;
        }

        public Criteria andCjslLike(String value) {
            addCriterion("CJSL like", value, "cjsl");
            return this;
        }

        public Criteria andCjslNotLike(String value) {
            addCriterion("CJSL not like", value, "cjsl");
            return this;
        }

        public Criteria andCjslIn(List<String> values) {
            addCriterion("CJSL in", values, "cjsl");
            return this;
        }

        public Criteria andCjslNotIn(List<String> values) {
            addCriterion("CJSL not in", values, "cjsl");
            return this;
        }

        public Criteria andCjslBetween(String value1, String value2) {
            addCriterion("CJSL between", value1, value2, "cjsl");
            return this;
        }

        public Criteria andCjslNotBetween(String value1, String value2) {
            addCriterion("CJSL not between", value1, value2, "cjsl");
            return this;
        }

        public Criteria andCjlIsNull() {
            addCriterion("CJL is null");
            return this;
        }

        public Criteria andCjlIsNotNull() {
            addCriterion("CJL is not null");
            return this;
        }

        public Criteria andCjlEqualTo(String value) {
            addCriterion("CJL =", value, "cjl");
            return this;
        }

        public Criteria andCjlNotEqualTo(String value) {
            addCriterion("CJL <>", value, "cjl");
            return this;
        }

        public Criteria andCjlGreaterThan(String value) {
            addCriterion("CJL >", value, "cjl");
            return this;
        }

        public Criteria andCjlGreaterThanOrEqualTo(String value) {
            addCriterion("CJL >=", value, "cjl");
            return this;
        }

        public Criteria andCjlLessThan(String value) {
            addCriterion("CJL <", value, "cjl");
            return this;
        }

        public Criteria andCjlLessThanOrEqualTo(String value) {
            addCriterion("CJL <=", value, "cjl");
            return this;
        }

        public Criteria andCjlLike(String value) {
            addCriterion("CJL like", value, "cjl");
            return this;
        }

        public Criteria andCjlNotLike(String value) {
            addCriterion("CJL not like", value, "cjl");
            return this;
        }

        public Criteria andCjlIn(List<String> values) {
            addCriterion("CJL in", values, "cjl");
            return this;
        }

        public Criteria andCjlNotIn(List<String> values) {
            addCriterion("CJL not in", values, "cjl");
            return this;
        }

        public Criteria andCjlBetween(String value1, String value2) {
            addCriterion("CJL between", value1, value2, "cjl");
            return this;
        }

        public Criteria andCjlNotBetween(String value1, String value2) {
            addCriterion("CJL not between", value1, value2, "cjl");
            return this;
        }

        public Criteria andXsyIsNull() {
            addCriterion("XSY is null");
            return this;
        }

        public Criteria andXsyIsNotNull() {
            addCriterion("XSY is not null");
            return this;
        }

        public Criteria andXsyEqualTo(String value) {
            addCriterion("XSY =", value, "xsy");
            return this;
        }

        public Criteria andXsyNotEqualTo(String value) {
            addCriterion("XSY <>", value, "xsy");
            return this;
        }

        public Criteria andXsyGreaterThan(String value) {
            addCriterion("XSY >", value, "xsy");
            return this;
        }

        public Criteria andXsyGreaterThanOrEqualTo(String value) {
            addCriterion("XSY >=", value, "xsy");
            return this;
        }

        public Criteria andXsyLessThan(String value) {
            addCriterion("XSY <", value, "xsy");
            return this;
        }

        public Criteria andXsyLessThanOrEqualTo(String value) {
            addCriterion("XSY <=", value, "xsy");
            return this;
        }

        public Criteria andXsyLike(String value) {
            addCriterion("XSY like", value, "xsy");
            return this;
        }

        public Criteria andXsyNotLike(String value) {
            addCriterion("XSY not like", value, "xsy");
            return this;
        }

        public Criteria andXsyIn(List<String> values) {
            addCriterion("XSY in", values, "xsy");
            return this;
        }

        public Criteria andXsyNotIn(List<String> values) {
            addCriterion("XSY not in", values, "xsy");
            return this;
        }

        public Criteria andXsyBetween(String value1, String value2) {
            addCriterion("XSY between", value1, value2, "xsy");
            return this;
        }

        public Criteria andXsyNotBetween(String value1, String value2) {
            addCriterion("XSY not between", value1, value2, "xsy");
            return this;
        }

        public Criteria andMdIsNull() {
            addCriterion("MD is null");
            return this;
        }

        public Criteria andMdIsNotNull() {
            addCriterion("MD is not null");
            return this;
        }

        public Criteria andMdEqualTo(String value) {
            addCriterion("MD =", value, "md");
            return this;
        }

        public Criteria andMdNotEqualTo(String value) {
            addCriterion("MD <>", value, "md");
            return this;
        }

        public Criteria andMdGreaterThan(String value) {
            addCriterion("MD >", value, "md");
            return this;
        }

        public Criteria andMdGreaterThanOrEqualTo(String value) {
            addCriterion("MD >=", value, "md");
            return this;
        }

        public Criteria andMdLessThan(String value) {
            addCriterion("MD <", value, "md");
            return this;
        }

        public Criteria andMdLessThanOrEqualTo(String value) {
            addCriterion("MD <=", value, "md");
            return this;
        }

        public Criteria andMdLike(String value) {
            addCriterion("MD like", value, "md");
            return this;
        }

        public Criteria andMdNotLike(String value) {
            addCriterion("MD not like", value, "md");
            return this;
        }

        public Criteria andMdIn(List<String> values) {
            addCriterion("MD in", values, "md");
            return this;
        }

        public Criteria andMdNotIn(List<String> values) {
            addCriterion("MD not in", values, "md");
            return this;
        }

        public Criteria andMdBetween(String value1, String value2) {
            addCriterion("MD between", value1, value2, "md");
            return this;
        }

        public Criteria andMdNotBetween(String value1, String value2) {
            addCriterion("MD not between", value1, value2, "md");
            return this;
        }

        public Criteria andJzhlIsNull() {
            addCriterion("JZHL is null");
            return this;
        }

        public Criteria andJzhlIsNotNull() {
            addCriterion("JZHL is not null");
            return this;
        }

        public Criteria andJzhlEqualTo(String value) {
            addCriterion("JZHL =", value, "jzhl");
            return this;
        }

        public Criteria andJzhlNotEqualTo(String value) {
            addCriterion("JZHL <>", value, "jzhl");
            return this;
        }

        public Criteria andJzhlGreaterThan(String value) {
            addCriterion("JZHL >", value, "jzhl");
            return this;
        }

        public Criteria andJzhlGreaterThanOrEqualTo(String value) {
            addCriterion("JZHL >=", value, "jzhl");
            return this;
        }

        public Criteria andJzhlLessThan(String value) {
            addCriterion("JZHL <", value, "jzhl");
            return this;
        }

        public Criteria andJzhlLessThanOrEqualTo(String value) {
            addCriterion("JZHL <=", value, "jzhl");
            return this;
        }

        public Criteria andJzhlLike(String value) {
            addCriterion("JZHL like", value, "jzhl");
            return this;
        }

        public Criteria andJzhlNotLike(String value) {
            addCriterion("JZHL not like", value, "jzhl");
            return this;
        }

        public Criteria andJzhlIn(List<String> values) {
            addCriterion("JZHL in", values, "jzhl");
            return this;
        }

        public Criteria andJzhlNotIn(List<String> values) {
            addCriterion("JZHL not in", values, "jzhl");
            return this;
        }

        public Criteria andJzhlBetween(String value1, String value2) {
            addCriterion("JZHL between", value1, value2, "jzhl");
            return this;
        }

        public Criteria andJzhlNotBetween(String value1, String value2) {
            addCriterion("JZHL not between", value1, value2, "jzhl");
            return this;
        }

        public Criteria andZbfsIsNull() {
            addCriterion("ZBFS is null");
            return this;
        }

        public Criteria andZbfsIsNotNull() {
            addCriterion("ZBFS is not null");
            return this;
        }

        public Criteria andZbfsEqualTo(String value) {
            addCriterion("ZBFS =", value, "zbfs");
            return this;
        }

        public Criteria andZbfsNotEqualTo(String value) {
            addCriterion("ZBFS <>", value, "zbfs");
            return this;
        }

        public Criteria andZbfsGreaterThan(String value) {
            addCriterion("ZBFS >", value, "zbfs");
            return this;
        }

        public Criteria andZbfsGreaterThanOrEqualTo(String value) {
            addCriterion("ZBFS >=", value, "zbfs");
            return this;
        }

        public Criteria andZbfsLessThan(String value) {
            addCriterion("ZBFS <", value, "zbfs");
            return this;
        }

        public Criteria andZbfsLessThanOrEqualTo(String value) {
            addCriterion("ZBFS <=", value, "zbfs");
            return this;
        }

        public Criteria andZbfsLike(String value) {
            addCriterion("ZBFS like", value, "zbfs");
            return this;
        }

        public Criteria andZbfsNotLike(String value) {
            addCriterion("ZBFS not like", value, "zbfs");
            return this;
        }

        public Criteria andZbfsIn(List<String> values) {
            addCriterion("ZBFS in", values, "zbfs");
            return this;
        }

        public Criteria andZbfsNotIn(List<String> values) {
            addCriterion("ZBFS not in", values, "zbfs");
            return this;
        }

        public Criteria andZbfsBetween(String value1, String value2) {
            addCriterion("ZBFS between", value1, value2, "zbfs");
            return this;
        }

        public Criteria andZbfsNotBetween(String value1, String value2) {
            addCriterion("ZBFS not between", value1, value2, "zbfs");
            return this;
        }

        public Criteria andQwIsNull() {
            addCriterion("QW is null");
            return this;
        }

        public Criteria andQwIsNotNull() {
            addCriterion("QW is not null");
            return this;
        }

        public Criteria andQwEqualTo(Integer value) {
            addCriterion("QW =", value, "qw");
            return this;
        }

        public Criteria andQwNotEqualTo(Integer value) {
            addCriterion("QW <>", value, "qw");
            return this;
        }

        public Criteria andQwGreaterThan(Integer value) {
            addCriterion("QW >", value, "qw");
            return this;
        }

        public Criteria andQwGreaterThanOrEqualTo(Integer value) {
            addCriterion("QW >=", value, "qw");
            return this;
        }

        public Criteria andQwLessThan(Integer value) {
            addCriterion("QW <", value, "qw");
            return this;
        }

        public Criteria andQwLessThanOrEqualTo(Integer value) {
            addCriterion("QW <=", value, "qw");
            return this;
        }

        public Criteria andQwIn(List<Integer> values) {
            addCriterion("QW in", values, "qw");
            return this;
        }

        public Criteria andQwNotIn(List<Integer> values) {
            addCriterion("QW not in", values, "qw");
            return this;
        }

        public Criteria andQwBetween(Integer value1, Integer value2) {
            addCriterion("QW between", value1, value2, "qw");
            return this;
        }

        public Criteria andQwNotBetween(Integer value1, Integer value2) {
            addCriterion("QW not between", value1, value2, "qw");
            return this;
        }

        public Criteria andYsIsNull() {
            addCriterion("YS is null");
            return this;
        }

        public Criteria andYsIsNotNull() {
            addCriterion("YS is not null");
            return this;
        }

        public Criteria andYsEqualTo(Integer value) {
            addCriterion("YS =", value, "ys");
            return this;
        }

        public Criteria andYsNotEqualTo(Integer value) {
            addCriterion("YS <>", value, "ys");
            return this;
        }

        public Criteria andYsGreaterThan(Integer value) {
            addCriterion("YS >", value, "ys");
            return this;
        }

        public Criteria andYsGreaterThanOrEqualTo(Integer value) {
            addCriterion("YS >=", value, "ys");
            return this;
        }

        public Criteria andYsLessThan(Integer value) {
            addCriterion("YS <", value, "ys");
            return this;
        }

        public Criteria andYsLessThanOrEqualTo(Integer value) {
            addCriterion("YS <=", value, "ys");
            return this;
        }

        public Criteria andYsIn(List<Integer> values) {
            addCriterion("YS in", values, "ys");
            return this;
        }

        public Criteria andYsNotIn(List<Integer> values) {
            addCriterion("YS not in", values, "ys");
            return this;
        }

        public Criteria andYsBetween(Integer value1, Integer value2) {
            addCriterion("YS between", value1, value2, "ys");
            return this;
        }

        public Criteria andYsNotBetween(Integer value1, Integer value2) {
            addCriterion("YS not between", value1, value2, "ys");
            return this;
        }

        public Criteria andBzIsNull() {
            addCriterion("BZ is null");
            return this;
        }

        public Criteria andBzIsNotNull() {
            addCriterion("BZ is not null");
            return this;
        }

        public Criteria andBzEqualTo(String value) {
            addCriterion("BZ =", value, "bz");
            return this;
        }

        public Criteria andBzNotEqualTo(String value) {
            addCriterion("BZ <>", value, "bz");
            return this;
        }

        public Criteria andBzGreaterThan(String value) {
            addCriterion("BZ >", value, "bz");
            return this;
        }

        public Criteria andBzGreaterThanOrEqualTo(String value) {
            addCriterion("BZ >=", value, "bz");
            return this;
        }

        public Criteria andBzLessThan(String value) {
            addCriterion("BZ <", value, "bz");
            return this;
        }

        public Criteria andBzLessThanOrEqualTo(String value) {
            addCriterion("BZ <=", value, "bz");
            return this;
        }

        public Criteria andBzLike(String value) {
            addCriterion("BZ like", value, "bz");
            return this;
        }

        public Criteria andBzNotLike(String value) {
            addCriterion("BZ not like", value, "bz");
            return this;
        }

        public Criteria andBzIn(List<String> values) {
            addCriterion("BZ in", values, "bz");
            return this;
        }

        public Criteria andBzNotIn(List<String> values) {
            addCriterion("BZ not in", values, "bz");
            return this;
        }

        public Criteria andBzBetween(String value1, String value2) {
            addCriterion("BZ between", value1, value2, "bz");
            return this;
        }

        public Criteria andBzNotBetween(String value1, String value2) {
            addCriterion("BZ not between", value1, value2, "bz");
            return this;
        }

        public Criteria andSfhgIsNull() {
            addCriterion("SFHG is null");
            return this;
        }

        public Criteria andSfhgIsNotNull() {
            addCriterion("SFHG is not null");
            return this;
        }

        public Criteria andSfhgEqualTo(Integer value) {
            addCriterion("SFHG =", value, "sfhg");
            return this;
        }

        public Criteria andSfhgNotEqualTo(Integer value) {
            addCriterion("SFHG <>", value, "sfhg");
            return this;
        }

        public Criteria andSfhgGreaterThan(Integer value) {
            addCriterion("SFHG >", value, "sfhg");
            return this;
        }

        public Criteria andSfhgGreaterThanOrEqualTo(Integer value) {
            addCriterion("SFHG >=", value, "sfhg");
            return this;
        }

        public Criteria andSfhgLessThan(Integer value) {
            addCriterion("SFHG <", value, "sfhg");
            return this;
        }

        public Criteria andSfhgLessThanOrEqualTo(Integer value) {
            addCriterion("SFHG <=", value, "sfhg");
            return this;
        }

        public Criteria andSfhgIn(List<Integer> values) {
            addCriterion("SFHG in", values, "sfhg");
            return this;
        }

        public Criteria andSfhgNotIn(List<Integer> values) {
            addCriterion("SFHG not in", values, "sfhg");
            return this;
        }

        public Criteria andSfhgBetween(Integer value1, Integer value2) {
            addCriterion("SFHG between", value1, value2, "sfhg");
            return this;
        }

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