package com.huimv.whh.dataobject;

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

public class WhhDjtjExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public WhhDjtjExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected WhhDjtjExample(WhhDjtjExample example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    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 whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public void setStart(int start) {
        this.start=start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public void setLimit(int limit) {
        this.limit=limit;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table whh_djtj
     *
     * @ibatorgenerated Mon Jul 02 15:02:33 CST 2018
     */
    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 andMcidIsNull() {
            addCriterion("MCID is null");
            return this;
        }

        public Criteria andMcidIsNotNull() {
            addCriterion("MCID is not null");
            return this;
        }

        public Criteria andMcidEqualTo(Integer value) {
            addCriterion("MCID =", value, "mcid");
            return this;
        }

        public Criteria andMcidNotEqualTo(Integer value) {
            addCriterion("MCID <>", value, "mcid");
            return this;
        }

        public Criteria andMcidGreaterThan(Integer value) {
            addCriterion("MCID >", value, "mcid");
            return this;
        }

        public Criteria andMcidGreaterThanOrEqualTo(Integer value) {
            addCriterion("MCID >=", value, "mcid");
            return this;
        }

        public Criteria andMcidLessThan(Integer value) {
            addCriterion("MCID <", value, "mcid");
            return this;
        }

        public Criteria andMcidLessThanOrEqualTo(Integer value) {
            addCriterion("MCID <=", value, "mcid");
            return this;
        }

        public Criteria andMcidIn(List<Integer> values) {
            addCriterion("MCID in", values, "mcid");
            return this;
        }

        public Criteria andMcidNotIn(List<Integer> values) {
            addCriterion("MCID not in", values, "mcid");
            return this;
        }

        public Criteria andMcidBetween(Integer value1, Integer value2) {
            addCriterion("MCID between", value1, value2, "mcid");
            return this;
        }

        public Criteria andMcidNotBetween(Integer value1, Integer value2) {
            addCriterion("MCID not between", value1, value2, "mcid");
            return this;
        }

        public Criteria andGlhIsNull() {
            addCriterion("GLH is null");
            return this;
        }

        public Criteria andGlhIsNotNull() {
            addCriterion("GLH is not null");
            return this;
        }

        public Criteria andGlhEqualTo(String value) {
            addCriterion("GLH =", value, "glh");
            return this;
        }

        public Criteria andGlhNotEqualTo(String value) {
            addCriterion("GLH <>", value, "glh");
            return this;
        }

        public Criteria andGlhGreaterThan(String value) {
            addCriterion("GLH >", value, "glh");
            return this;
        }

        public Criteria andGlhGreaterThanOrEqualTo(String value) {
            addCriterion("GLH >=", value, "glh");
            return this;
        }

        public Criteria andGlhLessThan(String value) {
            addCriterion("GLH <", value, "glh");
            return this;
        }

        public Criteria andGlhLessThanOrEqualTo(String value) {
            addCriterion("GLH <=", value, "glh");
            return this;
        }

        public Criteria andGlhLike(String value) {
            addCriterion("GLH like", value, "glh");
            return this;
        }

        public Criteria andGlhNotLike(String value) {
            addCriterion("GLH not like", value, "glh");
            return this;
        }

        public Criteria andGlhIn(List<String> values) {
            addCriterion("GLH in", values, "glh");
            return this;
        }

        public Criteria andGlhNotIn(List<String> values) {
            addCriterion("GLH not in", values, "glh");
            return this;
        }

        public Criteria andGlhBetween(String value1, String value2) {
            addCriterion("GLH between", value1, value2, "glh");
            return this;
        }

        public Criteria andGlhNotBetween(String value1, String value2) {
            addCriterion("GLH not between", value1, value2, "glh");
            return this;
        }

        public Criteria andRwdIsNull() {
            addCriterion("RWD is null");
            return this;
        }

        public Criteria andRwdIsNotNull() {
            addCriterion("RWD is not null");
            return this;
        }

        public Criteria andRwdEqualTo(String value) {
            addCriterion("RWD =", value, "rwd");
            return this;
        }

        public Criteria andRwdNotEqualTo(String value) {
            addCriterion("RWD <>", value, "rwd");
            return this;
        }

        public Criteria andRwdGreaterThan(String value) {
            addCriterion("RWD >", value, "rwd");
            return this;
        }

        public Criteria andRwdGreaterThanOrEqualTo(String value) {
            addCriterion("RWD >=", value, "rwd");
            return this;
        }

        public Criteria andRwdLessThan(String value) {
            addCriterion("RWD <", value, "rwd");
            return this;
        }

        public Criteria andRwdLessThanOrEqualTo(String value) {
            addCriterion("RWD <=", value, "rwd");
            return this;
        }

        public Criteria andRwdLike(String value) {
            addCriterion("RWD like", value, "rwd");
            return this;
        }

        public Criteria andRwdNotLike(String value) {
            addCriterion("RWD not like", value, "rwd");
            return this;
        }

        public Criteria andRwdIn(List<String> values) {
            addCriterion("RWD in", values, "rwd");
            return this;
        }

        public Criteria andRwdNotIn(List<String> values) {
            addCriterion("RWD not in", values, "rwd");
            return this;
        }

        public Criteria andRwdBetween(String value1, String value2) {
            addCriterion("RWD between", value1, value2, "rwd");
            return this;
        }

        public Criteria andRwdNotBetween(String value1, String value2) {
            addCriterion("RWD not between", value1, value2, "rwd");
            return this;
        }

        public Criteria andPcIsNull() {
            addCriterion("PC is null");
            return this;
        }

        public Criteria andPcIsNotNull() {
            addCriterion("PC is not null");
            return this;
        }

        public Criteria andPcEqualTo(String value) {
            addCriterion("PC =", value, "pc");
            return this;
        }

        public Criteria andPcNotEqualTo(String value) {
            addCriterion("PC <>", value, "pc");
            return this;
        }

        public Criteria andPcGreaterThan(String value) {
            addCriterion("PC >", value, "pc");
            return this;
        }

        public Criteria andPcGreaterThanOrEqualTo(String value) {
            addCriterion("PC >=", value, "pc");
            return this;
        }

        public Criteria andPcLessThan(String value) {
            addCriterion("PC <", value, "pc");
            return this;
        }

        public Criteria andPcLessThanOrEqualTo(String value) {
            addCriterion("PC <=", value, "pc");
            return this;
        }

        public Criteria andPcLike(String value) {
            addCriterion("PC like", value, "pc");
            return this;
        }

        public Criteria andPcNotLike(String value) {
            addCriterion("PC not like", value, "pc");
            return this;
        }

        public Criteria andPcIn(List<String> values) {
            addCriterion("PC in", values, "pc");
            return this;
        }

        public Criteria andPcNotIn(List<String> values) {
            addCriterion("PC not in", values, "pc");
            return this;
        }

        public Criteria andPcBetween(String value1, String value2) {
            addCriterion("PC between", value1, value2, "pc");
            return this;
        }

        public Criteria andPcNotBetween(String value1, String value2) {
            addCriterion("PC not between", value1, value2, "pc");
            return this;
        }

        public Criteria andSlIsNull() {
            addCriterion("SL is null");
            return this;
        }

        public Criteria andSlIsNotNull() {
            addCriterion("SL is not null");
            return this;
        }

        public Criteria andSlEqualTo(Integer value) {
            addCriterion("SL =", value, "sl");
            return this;
        }

        public Criteria andSlNotEqualTo(Integer value) {
            addCriterion("SL <>", value, "sl");
            return this;
        }

        public Criteria andSlGreaterThan(Integer value) {
            addCriterion("SL >", value, "sl");
            return this;
        }

        public Criteria andSlGreaterThanOrEqualTo(Integer value) {
            addCriterion("SL >=", value, "sl");
            return this;
        }

        public Criteria andSlLessThan(Integer value) {
            addCriterion("SL <", value, "sl");
            return this;
        }

        public Criteria andSlLessThanOrEqualTo(Integer value) {
            addCriterion("SL <=", value, "sl");
            return this;
        }

        public Criteria andSlIn(List<Integer> values) {
            addCriterion("SL in", values, "sl");
            return this;
        }

        public Criteria andSlNotIn(List<Integer> values) {
            addCriterion("SL not in", values, "sl");
            return this;
        }

        public Criteria andSlBetween(Integer value1, Integer value2) {
            addCriterion("SL between", value1, value2, "sl");
            return this;
        }

        public Criteria andSlNotBetween(Integer value1, Integer value2) {
            addCriterion("SL not between", value1, value2, "sl");
            return this;
        }

        public Criteria andSqsjIsNull() {
            addCriterion("SQSJ is null");
            return this;
        }

        public Criteria andSqsjIsNotNull() {
            addCriterion("SQSJ is not null");
            return this;
        }

        public Criteria andSqsjEqualTo(Date value) {
            addCriterion("SQSJ =", value, "sqsj");
            return this;
        }

        public Criteria andSqsjNotEqualTo(Date value) {
            addCriterion("SQSJ <>", value, "sqsj");
            return this;
        }

        public Criteria andSqsjGreaterThan(Date value) {
            addCriterion("SQSJ >", value, "sqsj");
            return this;
        }

        public Criteria andSqsjGreaterThanOrEqualTo(Date value) {
            addCriterion("SQSJ >=", value, "sqsj");
            return this;
        }

        public Criteria andSqsjLessThan(Date value) {
            addCriterion("SQSJ <", value, "sqsj");
            return this;
        }

        public Criteria andSqsjLessThanOrEqualTo(Date value) {
            addCriterion("SQSJ <=", value, "sqsj");
            return this;
        }

        public Criteria andSqsjIn(List<Date> values) {
            addCriterion("SQSJ in", values, "sqsj");
            return this;
        }

        public Criteria andSqsjNotIn(List<Date> values) {
            addCriterion("SQSJ not in", values, "sqsj");
            return this;
        }

        public Criteria andSqsjBetween(Date value1, Date value2) {
            addCriterion("SQSJ between", value1, value2, "sqsj");
            return this;
        }

        public Criteria andSqsjNotBetween(Date value1, Date value2) {
            addCriterion("SQSJ not between", value1, value2, "sqsj");
            return this;
        }

        public Criteria andSqrIsNull() {
            addCriterion("SQR is null");
            return this;
        }

        public Criteria andSqrIsNotNull() {
            addCriterion("SQR is not null");
            return this;
        }

        public Criteria andSqrEqualTo(Integer value) {
            addCriterion("SQR =", value, "sqr");
            return this;
        }

        public Criteria andSqrNotEqualTo(Integer value) {
            addCriterion("SQR <>", value, "sqr");
            return this;
        }

        public Criteria andSqrGreaterThan(Integer value) {
            addCriterion("SQR >", value, "sqr");
            return this;
        }

        public Criteria andSqrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SQR >=", value, "sqr");
            return this;
        }

        public Criteria andSqrLessThan(Integer value) {
            addCriterion("SQR <", value, "sqr");
            return this;
        }

        public Criteria andSqrLessThanOrEqualTo(Integer value) {
            addCriterion("SQR <=", value, "sqr");
            return this;
        }

        public Criteria andSqrIn(List<Integer> values) {
            addCriterion("SQR in", values, "sqr");
            return this;
        }

        public Criteria andSqrNotIn(List<Integer> values) {
            addCriterion("SQR not in", values, "sqr");
            return this;
        }

        public Criteria andSqrBetween(Integer value1, Integer value2) {
            addCriterion("SQR between", value1, value2, "sqr");
            return this;
        }

        public Criteria andSqrNotBetween(Integer value1, Integer value2) {
            addCriterion("SQR not between", value1, value2, "sqr");
            return this;
        }

        public Criteria andSqbzIsNull() {
            addCriterion("SQBZ is null");
            return this;
        }

        public Criteria andSqbzIsNotNull() {
            addCriterion("SQBZ is not null");
            return this;
        }

        public Criteria andSqbzEqualTo(String value) {
            addCriterion("SQBZ =", value, "sqbz");
            return this;
        }

        public Criteria andSqbzNotEqualTo(String value) {
            addCriterion("SQBZ <>", value, "sqbz");
            return this;
        }

        public Criteria andSqbzGreaterThan(String value) {
            addCriterion("SQBZ >", value, "sqbz");
            return this;
        }

        public Criteria andSqbzGreaterThanOrEqualTo(String value) {
            addCriterion("SQBZ >=", value, "sqbz");
            return this;
        }

        public Criteria andSqbzLessThan(String value) {
            addCriterion("SQBZ <", value, "sqbz");
            return this;
        }

        public Criteria andSqbzLessThanOrEqualTo(String value) {
            addCriterion("SQBZ <=", value, "sqbz");
            return this;
        }

        public Criteria andSqbzLike(String value) {
            addCriterion("SQBZ like", value, "sqbz");
            return this;
        }

        public Criteria andSqbzNotLike(String value) {
            addCriterion("SQBZ not like", value, "sqbz");
            return this;
        }

        public Criteria andSqbzIn(List<String> values) {
            addCriterion("SQBZ in", values, "sqbz");
            return this;
        }

        public Criteria andSqbzNotIn(List<String> values) {
            addCriterion("SQBZ not in", values, "sqbz");
            return this;
        }

        public Criteria andSqbzBetween(String value1, String value2) {
            addCriterion("SQBZ between", value1, value2, "sqbz");
            return this;
        }

        public Criteria andSqbzNotBetween(String value1, String value2) {
            addCriterion("SQBZ not between", value1, value2, "sqbz");
            return this;
        }

        public Criteria andShbzIsNull() {
            addCriterion("SHBZ is null");
            return this;
        }

        public Criteria andShbzIsNotNull() {
            addCriterion("SHBZ is not null");
            return this;
        }

        public Criteria andShbzEqualTo(String value) {
            addCriterion("SHBZ =", value, "shbz");
            return this;
        }

        public Criteria andShbzNotEqualTo(String value) {
            addCriterion("SHBZ <>", value, "shbz");
            return this;
        }

        public Criteria andShbzGreaterThan(String value) {
            addCriterion("SHBZ >", value, "shbz");
            return this;
        }

        public Criteria andShbzGreaterThanOrEqualTo(String value) {
            addCriterion("SHBZ >=", value, "shbz");
            return this;
        }

        public Criteria andShbzLessThan(String value) {
            addCriterion("SHBZ <", value, "shbz");
            return this;
        }

        public Criteria andShbzLessThanOrEqualTo(String value) {
            addCriterion("SHBZ <=", value, "shbz");
            return this;
        }

        public Criteria andShbzLike(String value) {
            addCriterion("SHBZ like", value, "shbz");
            return this;
        }

        public Criteria andShbzNotLike(String value) {
            addCriterion("SHBZ not like", value, "shbz");
            return this;
        }

        public Criteria andShbzIn(List<String> values) {
            addCriterion("SHBZ in", values, "shbz");
            return this;
        }

        public Criteria andShbzNotIn(List<String> values) {
            addCriterion("SHBZ not in", values, "shbz");
            return this;
        }

        public Criteria andShbzBetween(String value1, String value2) {
            addCriterion("SHBZ between", value1, value2, "shbz");
            return this;
        }

        public Criteria andShbzNotBetween(String value1, String value2) {
            addCriterion("SHBZ not between", value1, value2, "shbz");
            return this;
        }

        public Criteria andShryIsNull() {
            addCriterion("SHRY is null");
            return this;
        }

        public Criteria andShryIsNotNull() {
            addCriterion("SHRY is not null");
            return this;
        }

        public Criteria andShryEqualTo(Integer value) {
            addCriterion("SHRY =", value, "shry");
            return this;
        }

        public Criteria andShryNotEqualTo(Integer value) {
            addCriterion("SHRY <>", value, "shry");
            return this;
        }

        public Criteria andShryGreaterThan(Integer value) {
            addCriterion("SHRY >", value, "shry");
            return this;
        }

        public Criteria andShryGreaterThanOrEqualTo(Integer value) {
            addCriterion("SHRY >=", value, "shry");
            return this;
        }

        public Criteria andShryLessThan(Integer value) {
            addCriterion("SHRY <", value, "shry");
            return this;
        }

        public Criteria andShryLessThanOrEqualTo(Integer value) {
            addCriterion("SHRY <=", value, "shry");
            return this;
        }

        public Criteria andShryIn(List<Integer> values) {
            addCriterion("SHRY in", values, "shry");
            return this;
        }

        public Criteria andShryNotIn(List<Integer> values) {
            addCriterion("SHRY not in", values, "shry");
            return this;
        }

        public Criteria andShryBetween(Integer value1, Integer value2) {
            addCriterion("SHRY between", value1, value2, "shry");
            return this;
        }

        public Criteria andShryNotBetween(Integer value1, Integer value2) {
            addCriterion("SHRY not between", value1, value2, "shry");
            return this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andShsjIsNull() {
            addCriterion("SHSJ is null");
            return this;
        }

        public Criteria andShsjIsNotNull() {
            addCriterion("SHSJ is not null");
            return this;
        }

        public Criteria andShsjEqualTo(Date value) {
            addCriterion("SHSJ =", value, "shsj");
            return this;
        }

        public Criteria andShsjNotEqualTo(Date value) {
            addCriterion("SHSJ <>", value, "shsj");
            return this;
        }

        public Criteria andShsjGreaterThan(Date value) {
            addCriterion("SHSJ >", value, "shsj");
            return this;
        }

        public Criteria andShsjGreaterThanOrEqualTo(Date value) {
            addCriterion("SHSJ >=", value, "shsj");
            return this;
        }

        public Criteria andShsjLessThan(Date value) {
            addCriterion("SHSJ <", value, "shsj");
            return this;
        }

        public Criteria andShsjLessThanOrEqualTo(Date value) {
            addCriterion("SHSJ <=", value, "shsj");
            return this;
        }

        public Criteria andShsjIn(List<Date> values) {
            addCriterion("SHSJ in", values, "shsj");
            return this;
        }

        public Criteria andShsjNotIn(List<Date> values) {
            addCriterion("SHSJ not in", values, "shsj");
            return this;
        }

        public Criteria andShsjBetween(Date value1, Date value2) {
            addCriterion("SHSJ between", value1, value2, "shsj");
            return this;
        }

        public Criteria andShsjNotBetween(Date value1, Date value2) {
            addCriterion("SHSJ not between", value1, value2, "shsj");
            return this;
        }

        public Criteria andClsjIsNull() {
            addCriterion("CLSJ is null");
            return this;
        }

        public Criteria andClsjIsNotNull() {
            addCriterion("CLSJ is not null");
            return this;
        }

        public Criteria andClsjEqualTo(Date value) {
            addCriterion("CLSJ =", value, "clsj");
            return this;
        }

        public Criteria andClsjNotEqualTo(Date value) {
            addCriterion("CLSJ <>", value, "clsj");
            return this;
        }

        public Criteria andClsjGreaterThan(Date value) {
            addCriterion("CLSJ >", value, "clsj");
            return this;
        }

        public Criteria andClsjGreaterThanOrEqualTo(Date value) {
            addCriterion("CLSJ >=", value, "clsj");
            return this;
        }

        public Criteria andClsjLessThan(Date value) {
            addCriterion("CLSJ <", value, "clsj");
            return this;
        }

        public Criteria andClsjLessThanOrEqualTo(Date value) {
            addCriterion("CLSJ <=", value, "clsj");
            return this;
        }

        public Criteria andClsjIn(List<Date> values) {
            addCriterion("CLSJ in", values, "clsj");
            return this;
        }

        public Criteria andClsjNotIn(List<Date> values) {
            addCriterion("CLSJ not in", values, "clsj");
            return this;
        }

        public Criteria andClsjBetween(Date value1, Date value2) {
            addCriterion("CLSJ between", value1, value2, "clsj");
            return this;
        }

        public Criteria andClsjNotBetween(Date value1, Date value2) {
            addCriterion("CLSJ not between", value1, value2, "clsj");
            return this;
        }

        public Criteria andClfsIsNull() {
            addCriterion("CLFS is null");
            return this;
        }

        public Criteria andClfsIsNotNull() {
            addCriterion("CLFS is not null");
            return this;
        }

        public Criteria andClfsEqualTo(Integer value) {
            addCriterion("CLFS =", value, "clfs");
            return this;
        }

        public Criteria andClfsNotEqualTo(Integer value) {
            addCriterion("CLFS <>", value, "clfs");
            return this;
        }

        public Criteria andClfsGreaterThan(Integer value) {
            addCriterion("CLFS >", value, "clfs");
            return this;
        }

        public Criteria andClfsGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLFS >=", value, "clfs");
            return this;
        }

        public Criteria andClfsLessThan(Integer value) {
            addCriterion("CLFS <", value, "clfs");
            return this;
        }

        public Criteria andClfsLessThanOrEqualTo(Integer value) {
            addCriterion("CLFS <=", value, "clfs");
            return this;
        }

        public Criteria andClfsIn(List<Integer> values) {
            addCriterion("CLFS in", values, "clfs");
            return this;
        }

        public Criteria andClfsNotIn(List<Integer> values) {
            addCriterion("CLFS not in", values, "clfs");
            return this;
        }

        public Criteria andClfsBetween(Integer value1, Integer value2) {
            addCriterion("CLFS between", value1, value2, "clfs");
            return this;
        }

        public Criteria andClfsNotBetween(Integer value1, Integer value2) {
            addCriterion("CLFS not between", value1, value2, "clfs");
            return this;
        }

        public Criteria andClddIsNull() {
            addCriterion("CLDD is null");
            return this;
        }

        public Criteria andClddIsNotNull() {
            addCriterion("CLDD is not null");
            return this;
        }

        public Criteria andClddEqualTo(String value) {
            addCriterion("CLDD =", value, "cldd");
            return this;
        }

        public Criteria andClddNotEqualTo(String value) {
            addCriterion("CLDD <>", value, "cldd");
            return this;
        }

        public Criteria andClddGreaterThan(String value) {
            addCriterion("CLDD >", value, "cldd");
            return this;
        }

        public Criteria andClddGreaterThanOrEqualTo(String value) {
            addCriterion("CLDD >=", value, "cldd");
            return this;
        }

        public Criteria andClddLessThan(String value) {
            addCriterion("CLDD <", value, "cldd");
            return this;
        }

        public Criteria andClddLessThanOrEqualTo(String value) {
            addCriterion("CLDD <=", value, "cldd");
            return this;
        }

        public Criteria andClddLike(String value) {
            addCriterion("CLDD like", value, "cldd");
            return this;
        }

        public Criteria andClddNotLike(String value) {
            addCriterion("CLDD not like", value, "cldd");
            return this;
        }

        public Criteria andClddIn(List<String> values) {
            addCriterion("CLDD in", values, "cldd");
            return this;
        }

        public Criteria andClddNotIn(List<String> values) {
            addCriterion("CLDD not in", values, "cldd");
            return this;
        }

        public Criteria andClddBetween(String value1, String value2) {
            addCriterion("CLDD between", value1, value2, "cldd");
            return this;
        }

        public Criteria andClddNotBetween(String value1, String value2) {
            addCriterion("CLDD not between", value1, value2, "cldd");
            return this;
        }

        public Criteria andClryIsNull() {
            addCriterion("CLRY is null");
            return this;
        }

        public Criteria andClryIsNotNull() {
            addCriterion("CLRY is not null");
            return this;
        }

        public Criteria andClryEqualTo(String value) {
            addCriterion("CLRY =", value, "clry");
            return this;
        }

        public Criteria andClryNotEqualTo(String value) {
            addCriterion("CLRY <>", value, "clry");
            return this;
        }

        public Criteria andClryGreaterThan(String value) {
            addCriterion("CLRY >", value, "clry");
            return this;
        }

        public Criteria andClryGreaterThanOrEqualTo(String value) {
            addCriterion("CLRY >=", value, "clry");
            return this;
        }

        public Criteria andClryLessThan(String value) {
            addCriterion("CLRY <", value, "clry");
            return this;
        }

        public Criteria andClryLessThanOrEqualTo(String value) {
            addCriterion("CLRY <=", value, "clry");
            return this;
        }

        public Criteria andClryLike(String value) {
            addCriterion("CLRY like", value, "clry");
            return this;
        }

        public Criteria andClryNotLike(String value) {
            addCriterion("CLRY not like", value, "clry");
            return this;
        }

        public Criteria andClryIn(List<String> values) {
            addCriterion("CLRY in", values, "clry");
            return this;
        }

        public Criteria andClryNotIn(List<String> values) {
            addCriterion("CLRY not in", values, "clry");
            return this;
        }

        public Criteria andClryBetween(String value1, String value2) {
            addCriterion("CLRY between", value1, value2, "clry");
            return this;
        }

        public Criteria andClryNotBetween(String value1, String value2) {
            addCriterion("CLRY not between", value1, value2, "clry");
            return this;
        }

        public Criteria andClbzIsNull() {
            addCriterion("CLBZ is null");
            return this;
        }

        public Criteria andClbzIsNotNull() {
            addCriterion("CLBZ is not null");
            return this;
        }

        public Criteria andClbzEqualTo(Integer value) {
            addCriterion("CLBZ =", value, "clbz");
            return this;
        }

        public Criteria andClbzNotEqualTo(Integer value) {
            addCriterion("CLBZ <>", value, "clbz");
            return this;
        }

        public Criteria andClbzGreaterThan(Integer value) {
            addCriterion("CLBZ >", value, "clbz");
            return this;
        }

        public Criteria andClbzGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLBZ >=", value, "clbz");
            return this;
        }

        public Criteria andClbzLessThan(Integer value) {
            addCriterion("CLBZ <", value, "clbz");
            return this;
        }

        public Criteria andClbzLessThanOrEqualTo(Integer value) {
            addCriterion("CLBZ <=", value, "clbz");
            return this;
        }

        public Criteria andClbzIn(List<Integer> values) {
            addCriterion("CLBZ in", values, "clbz");
            return this;
        }

        public Criteria andClbzNotIn(List<Integer> values) {
            addCriterion("CLBZ not in", values, "clbz");
            return this;
        }

        public Criteria andClbzBetween(Integer value1, Integer value2) {
            addCriterion("CLBZ between", value1, value2, "clbz");
            return this;
        }

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