ifm/javasrc/ibatis/com/huimv/xt/dataobject/XtXzqhExample.java

package com.huimv.xt.dataobject;

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

public class XtXzqhExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public XtXzqhExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected XtXzqhExample(XtXzqhExample example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    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 xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public void setStart(int start) {
        this.start=start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public void setLimit(int limit) {
        this.limit=limit;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table xt_xzqh
     *
     * @ibatorgenerated Wed May 21 10:29:31 CST 2014
     */
    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 andQhbmIsNull() {
            addCriterion("QHBM is null");
            return this;
        }

        public Criteria andQhbmIsNotNull() {
            addCriterion("QHBM is not null");
            return this;
        }

        public Criteria andQhbmEqualTo(String value) {
            addCriterion("QHBM =", value, "qhbm");
            return this;
        }

        public Criteria andQhbmNotEqualTo(String value) {
            addCriterion("QHBM <>", value, "qhbm");
            return this;
        }

        public Criteria andQhbmGreaterThan(String value) {
            addCriterion("QHBM >", value, "qhbm");
            return this;
        }

        public Criteria andQhbmGreaterThanOrEqualTo(String value) {
            addCriterion("QHBM >=", value, "qhbm");
            return this;
        }

        public Criteria andQhbmLessThan(String value) {
            addCriterion("QHBM <", value, "qhbm");
            return this;
        }

        public Criteria andQhbmLessThanOrEqualTo(String value) {
            addCriterion("QHBM <=", value, "qhbm");
            return this;
        }

        public Criteria andQhbmLike(String value) {
            addCriterion("QHBM like", value, "qhbm");
            return this;
        }

        public Criteria andQhbmNotLike(String value) {
            addCriterion("QHBM not like", value, "qhbm");
            return this;
        }

        public Criteria andQhbmIn(List<String> values) {
            addCriterion("QHBM in", values, "qhbm");
            return this;
        }

        public Criteria andQhbmNotIn(List<String> values) {
            addCriterion("QHBM not in", values, "qhbm");
            return this;
        }

        public Criteria andQhbmBetween(String value1, String value2) {
            addCriterion("QHBM between", value1, value2, "qhbm");
            return this;
        }

        public Criteria andQhbmNotBetween(String value1, String value2) {
            addCriterion("QHBM not between", value1, value2, "qhbm");
            return this;
        }

        public Criteria andQhmcIsNull() {
            addCriterion("QHMC is null");
            return this;
        }

        public Criteria andQhmcIsNotNull() {
            addCriterion("QHMC is not null");
            return this;
        }

        public Criteria andQhmcEqualTo(String value) {
            addCriterion("QHMC =", value, "qhmc");
            return this;
        }

        public Criteria andQhmcNotEqualTo(String value) {
            addCriterion("QHMC <>", value, "qhmc");
            return this;
        }

        public Criteria andQhmcGreaterThan(String value) {
            addCriterion("QHMC >", value, "qhmc");
            return this;
        }

        public Criteria andQhmcGreaterThanOrEqualTo(String value) {
            addCriterion("QHMC >=", value, "qhmc");
            return this;
        }

        public Criteria andQhmcLessThan(String value) {
            addCriterion("QHMC <", value, "qhmc");
            return this;
        }

        public Criteria andQhmcLessThanOrEqualTo(String value) {
            addCriterion("QHMC <=", value, "qhmc");
            return this;
        }

        public Criteria andQhmcLike(String value) {
            addCriterion("QHMC like", value, "qhmc");
            return this;
        }

        public Criteria andQhmcNotLike(String value) {
            addCriterion("QHMC not like", value, "qhmc");
            return this;
        }

        public Criteria andQhmcIn(List<String> values) {
            addCriterion("QHMC in", values, "qhmc");
            return this;
        }

        public Criteria andQhmcNotIn(List<String> values) {
            addCriterion("QHMC not in", values, "qhmc");
            return this;
        }

        public Criteria andQhmcBetween(String value1, String value2) {
            addCriterion("QHMC between", value1, value2, "qhmc");
            return this;
        }

        public Criteria andQhmcNotBetween(String value1, String value2) {
            addCriterion("QHMC not between", value1, value2, "qhmc");
            return this;
        }

        public Criteria andQhlxIsNull() {
            addCriterion("QHLX is null");
            return this;
        }

        public Criteria andQhlxIsNotNull() {
            addCriterion("QHLX is not null");
            return this;
        }

        public Criteria andQhlxEqualTo(String value) {
            addCriterion("QHLX =", value, "qhlx");
            return this;
        }

        public Criteria andQhlxNotEqualTo(String value) {
            addCriterion("QHLX <>", value, "qhlx");
            return this;
        }

        public Criteria andQhlxGreaterThan(String value) {
            addCriterion("QHLX >", value, "qhlx");
            return this;
        }

        public Criteria andQhlxGreaterThanOrEqualTo(String value) {
            addCriterion("QHLX >=", value, "qhlx");
            return this;
        }

        public Criteria andQhlxLessThan(String value) {
            addCriterion("QHLX <", value, "qhlx");
            return this;
        }

        public Criteria andQhlxLessThanOrEqualTo(String value) {
            addCriterion("QHLX <=", value, "qhlx");
            return this;
        }

        public Criteria andQhlxLike(String value) {
            addCriterion("QHLX like", value, "qhlx");
            return this;
        }

        public Criteria andQhlxNotLike(String value) {
            addCriterion("QHLX not like", value, "qhlx");
            return this;
        }

        public Criteria andQhlxIn(List<String> values) {
            addCriterion("QHLX in", values, "qhlx");
            return this;
        }

        public Criteria andQhlxNotIn(List<String> values) {
            addCriterion("QHLX not in", values, "qhlx");
            return this;
        }

        public Criteria andQhlxBetween(String value1, String value2) {
            addCriterion("QHLX between", value1, value2, "qhlx");
            return this;
        }

        public Criteria andQhlxNotBetween(String value1, String value2) {
            addCriterion("QHLX not between", value1, value2, "qhlx");
            return this;
        }

        public Criteria andSjqhIsNull() {
            addCriterion("SJQH is null");
            return this;
        }

        public Criteria andSjqhIsNotNull() {
            addCriterion("SJQH is not null");
            return this;
        }

        public Criteria andSjqhEqualTo(String value) {
            addCriterion("SJQH =", value, "sjqh");
            return this;
        }

        public Criteria andSjqhNotEqualTo(String value) {
            addCriterion("SJQH <>", value, "sjqh");
            return this;
        }

        public Criteria andSjqhGreaterThan(String value) {
            addCriterion("SJQH >", value, "sjqh");
            return this;
        }

        public Criteria andSjqhGreaterThanOrEqualTo(String value) {
            addCriterion("SJQH >=", value, "sjqh");
            return this;
        }

        public Criteria andSjqhLessThan(String value) {
            addCriterion("SJQH <", value, "sjqh");
            return this;
        }

        public Criteria andSjqhLessThanOrEqualTo(String value) {
            addCriterion("SJQH <=", value, "sjqh");
            return this;
        }

        public Criteria andSjqhLike(String value) {
            addCriterion("SJQH like", value, "sjqh");
            return this;
        }

        public Criteria andSjqhNotLike(String value) {
            addCriterion("SJQH not like", value, "sjqh");
            return this;
        }

        public Criteria andSjqhIn(List<String> values) {
            addCriterion("SJQH in", values, "sjqh");
            return this;
        }

        public Criteria andSjqhNotIn(List<String> values) {
            addCriterion("SJQH not in", values, "sjqh");
            return this;
        }

        public Criteria andSjqhBetween(String value1, String value2) {
            addCriterion("SJQH between", value1, value2, "sjqh");
            return this;
        }

        public Criteria andSjqhNotBetween(String value1, String value2) {
            addCriterion("SJQH not between", value1, value2, "sjqh");
            return this;
        }

        public Criteria andPymIsNull() {
            addCriterion("PYM is null");
            return this;
        }

        public Criteria andPymIsNotNull() {
            addCriterion("PYM is not null");
            return this;
        }

        public Criteria andPymEqualTo(String value) {
            addCriterion("PYM =", value, "pym");
            return this;
        }

        public Criteria andPymNotEqualTo(String value) {
            addCriterion("PYM <>", value, "pym");
            return this;
        }

        public Criteria andPymGreaterThan(String value) {
            addCriterion("PYM >", value, "pym");
            return this;
        }

        public Criteria andPymGreaterThanOrEqualTo(String value) {
            addCriterion("PYM >=", value, "pym");
            return this;
        }

        public Criteria andPymLessThan(String value) {
            addCriterion("PYM <", value, "pym");
            return this;
        }

        public Criteria andPymLessThanOrEqualTo(String value) {
            addCriterion("PYM <=", value, "pym");
            return this;
        }

        public Criteria andPymLike(String value) {
            addCriterion("PYM like", value, "pym");
            return this;
        }

        public Criteria andPymNotLike(String value) {
            addCriterion("PYM not like", value, "pym");
            return this;
        }

        public Criteria andPymIn(List<String> values) {
            addCriterion("PYM in", values, "pym");
            return this;
        }

        public Criteria andPymNotIn(List<String> values) {
            addCriterion("PYM not in", values, "pym");
            return this;
        }

        public Criteria andPymBetween(String value1, String value2) {
            addCriterion("PYM between", value1, value2, "pym");
            return this;
        }

        public Criteria andPymNotBetween(String value1, String value2) {
            addCriterion("PYM not between", value1, value2, "pym");
            return this;
        }

        public Criteria andWbmIsNull() {
            addCriterion("WBM is null");
            return this;
        }

        public Criteria andWbmIsNotNull() {
            addCriterion("WBM is not null");
            return this;
        }

        public Criteria andWbmEqualTo(String value) {
            addCriterion("WBM =", value, "wbm");
            return this;
        }

        public Criteria andWbmNotEqualTo(String value) {
            addCriterion("WBM <>", value, "wbm");
            return this;
        }

        public Criteria andWbmGreaterThan(String value) {
            addCriterion("WBM >", value, "wbm");
            return this;
        }

        public Criteria andWbmGreaterThanOrEqualTo(String value) {
            addCriterion("WBM >=", value, "wbm");
            return this;
        }

        public Criteria andWbmLessThan(String value) {
            addCriterion("WBM <", value, "wbm");
            return this;
        }

        public Criteria andWbmLessThanOrEqualTo(String value) {
            addCriterion("WBM <=", value, "wbm");
            return this;
        }

        public Criteria andWbmLike(String value) {
            addCriterion("WBM like", value, "wbm");
            return this;
        }

        public Criteria andWbmNotLike(String value) {
            addCriterion("WBM not like", value, "wbm");
            return this;
        }

        public Criteria andWbmIn(List<String> values) {
            addCriterion("WBM in", values, "wbm");
            return this;
        }

        public Criteria andWbmNotIn(List<String> values) {
            addCriterion("WBM not in", values, "wbm");
            return this;
        }

        public Criteria andWbmBetween(String value1, String value2) {
            addCriterion("WBM between", value1, value2, "wbm");
            return this;
        }

        public Criteria andWbmNotBetween(String value1, String value2) {
            addCriterion("WBM not between", value1, value2, "wbm");
            return this;
        }

        public Criteria andCoordsIsNull() {
            addCriterion("COORDS is null");
            return this;
        }
        public Criteria andCoordsIsNotNull() {
            addCriterion("COORDS is not null");
            return this;
        }
        public Criteria andCoordsEqualTo(String value) {
            addCriterion("COORDS =", value, "coords");
            return this;
        }
        public Criteria andCoordsNotEqualTo(String value) {
            addCriterion("COORDS <>", value, "coords");
            return this;
        }
        public Criteria andCoordsGreaterThan(String value) {
            addCriterion("COORDS >", value, "coords");
            return this;
        }
        public Criteria andCoordsGreaterThanOrEqualTo(String value) {
            addCriterion("COORDS >=", value, "coords");
            return this;
        }
        public Criteria andCoordsLessThan(String value) {
            addCriterion("COORDS <", value, "coords");
            return this;
        }
        public Criteria andCoordsLessThanOrEqualTo(String value) {
            addCriterion("COORDS <=", value, "coords");
            return this;
        }
        public Criteria andCoordsLike(String value) {
            addCriterion("COORDS like", value, "coords");
            return this;
        }
        public Criteria andCoordsNotLike(String value) {
            addCriterion("COORDS not like", value, "coords");
            return this;
        }
        public Criteria andCoordsIn(List<String> values) {
            addCriterion("COORDS in", values, "coords");
            return this;
        }
        public Criteria andCoordsNotIn(List<String> values) {
            addCriterion("COORDS not in", values, "coords");
            return this;
        }
        public Criteria andCoordsBetween(String value1, String value2) {
            addCriterion("COORDS between", value1, value2, "coords");
            return this;
        }
        public Criteria andCoordsNotBetween(String value1, String value2) {
            addCriterion("COORDS not between", value1, value2, "coords");
            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;
        }

        public Criteria andCitycodeIsNull() {
            addCriterion("CityCode is null");
            return this;
        }

        public Criteria andCitycodeIsNotNull() {
            addCriterion("CityCode is not null");
            return this;
        }

        public Criteria andCitycodeEqualTo(Integer value) {
            addCriterion("CityCode =", value, "citycode");
            return this;
        }

        public Criteria andCitycodeNotEqualTo(Integer value) {
            addCriterion("CityCode <>", value, "citycode");
            return this;
        }

        public Criteria andCitycodeGreaterThan(Integer value) {
            addCriterion("CityCode >", value, "citycode");
            return this;
        }

        public Criteria andCitycodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("CityCode >=", value, "citycode");
            return this;
        }

        public Criteria andCitycodeLessThan(Integer value) {
            addCriterion("CityCode <", value, "citycode");
            return this;
        }

        public Criteria andCitycodeLessThanOrEqualTo(Integer value) {
            addCriterion("CityCode <=", value, "citycode");
            return this;
        }

        public Criteria andCitycodeIn(List<Integer> values) {
            addCriterion("CityCode in", values, "citycode");
            return this;
        }

        public Criteria andCitycodeNotIn(List<Integer> values) {
            addCriterion("CityCode not in", values, "citycode");
            return this;
        }

        public Criteria andCitycodeBetween(Integer value1, Integer value2) {
            addCriterion("CityCode between", value1, value2, "citycode");
            return this;
        }

        public Criteria andCitycodeNotBetween(Integer value1, Integer value2) {
            addCriterion("CityCode not between", value1, value2, "citycode");
            return this;
        }
    }
}