package com.huimv.sjlr.dataobject;

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

public class SjlrGzdaExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    public SjlrGzdaExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    protected SjlrGzdaExample(SjlrGzdaExample 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    public String getOrderByClause() {
        return orderByClause;
    }

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

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 CST 2017
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sjlr_gzda
     *
     * @ibatorgenerated Mon Jul 17 14:02:14 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);
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        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 andEphIsNull() {
            addCriterion("EPH is null");
            return this;
        }

        public Criteria andEphIsNotNull() {
            addCriterion("EPH is not null");
            return this;
        }

        public Criteria andEphEqualTo(String value) {
            addCriterion("EPH =", value, "eph");
            return this;
        }

        public Criteria andEphNotEqualTo(String value) {
            addCriterion("EPH <>", value, "eph");
            return this;
        }

        public Criteria andEphGreaterThan(String value) {
            addCriterion("EPH >", value, "eph");
            return this;
        }

        public Criteria andEphGreaterThanOrEqualTo(String value) {
            addCriterion("EPH >=", value, "eph");
            return this;
        }

        public Criteria andEphLessThan(String value) {
            addCriterion("EPH <", value, "eph");
            return this;
        }

        public Criteria andEphLessThanOrEqualTo(String value) {
            addCriterion("EPH <=", value, "eph");
            return this;
        }

        public Criteria andEphLike(String value) {
            addCriterion("EPH like", value, "eph");
            return this;
        }

        public Criteria andEphNotLike(String value) {
            addCriterion("EPH not like", value, "eph");
            return this;
        }

        public Criteria andEphIn(List<String> values) {
            addCriterion("EPH in", values, "eph");
            return this;
        }

        public Criteria andEphNotIn(List<String> values) {
            addCriterion("EPH not in", values, "eph");
            return this;
        }

        public Criteria andEphBetween(String value1, String value2) {
            addCriterion("EPH between", value1, value2, "eph");
            return this;
        }

        public Criteria andEphNotBetween(String value1, String value2) {
            addCriterion("EPH not between", value1, value2, "eph");
            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 andSlIsNull() {
            addCriterion("SL is null");
            return this;
        }

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

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

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

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

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

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

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

        public Criteria andSlLike(String value) {
            addCriterion("SL like", value, "sl");
            return this;
        }

        public Criteria andSlNotLike(String value) {
            addCriterion("SL not like", value, "sl");
            return this;
        }

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

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

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

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

        public Criteria andPzIsNull() {
            addCriterion("PZ is null");
            return this;
        }

        public Criteria andPzIsNotNull() {
            addCriterion("PZ is not null");
            return this;
        }

        public Criteria andPzEqualTo(String value) {
            addCriterion("PZ =", value, "pz");
            return this;
        }

        public Criteria andPzNotEqualTo(String value) {
            addCriterion("PZ <>", value, "pz");
            return this;
        }

        public Criteria andPzGreaterThan(String value) {
            addCriterion("PZ >", value, "pz");
            return this;
        }

        public Criteria andPzGreaterThanOrEqualTo(String value) {
            addCriterion("PZ >=", value, "pz");
            return this;
        }

        public Criteria andPzLessThan(String value) {
            addCriterion("PZ <", value, "pz");
            return this;
        }

        public Criteria andPzLessThanOrEqualTo(String value) {
            addCriterion("PZ <=", value, "pz");
            return this;
        }

        public Criteria andPzLike(String value) {
            addCriterion("PZ like", value, "pz");
            return this;
        }

        public Criteria andPzNotLike(String value) {
            addCriterion("PZ not like", value, "pz");
            return this;
        }

        public Criteria andPzIn(List<String> values) {
            addCriterion("PZ in", values, "pz");
            return this;
        }

        public Criteria andPzNotIn(List<String> values) {
            addCriterion("PZ not in", values, "pz");
            return this;
        }

        public Criteria andPzBetween(String value1, String value2) {
            addCriterion("PZ between", value1, value2, "pz");
            return this;
        }

        public Criteria andPzNotBetween(String value1, String value2) {
            addCriterion("PZ not between", value1, value2, "pz");
            return this;
        }

        public Criteria andQtIsNull() {
            addCriterion("QT is null");
            return this;
        }

        public Criteria andQtIsNotNull() {
            addCriterion("QT is not null");
            return this;
        }

        public Criteria andQtEqualTo(String value) {
            addCriterion("QT =", value, "qt");
            return this;
        }

        public Criteria andQtNotEqualTo(String value) {
            addCriterion("QT <>", value, "qt");
            return this;
        }

        public Criteria andQtGreaterThan(String value) {
            addCriterion("QT >", value, "qt");
            return this;
        }

        public Criteria andQtGreaterThanOrEqualTo(String value) {
            addCriterion("QT >=", value, "qt");
            return this;
        }

        public Criteria andQtLessThan(String value) {
            addCriterion("QT <", value, "qt");
            return this;
        }

        public Criteria andQtLessThanOrEqualTo(String value) {
            addCriterion("QT <=", value, "qt");
            return this;
        }

        public Criteria andQtLike(String value) {
            addCriterion("QT like", value, "qt");
            return this;
        }

        public Criteria andQtNotLike(String value) {
            addCriterion("QT not like", value, "qt");
            return this;
        }

        public Criteria andQtIn(List<String> values) {
            addCriterion("QT in", values, "qt");
            return this;
        }

        public Criteria andQtNotIn(List<String> values) {
            addCriterion("QT not in", values, "qt");
            return this;
        }

        public Criteria andQtBetween(String value1, String value2) {
            addCriterion("QT between", value1, value2, "qt");
            return this;
        }

        public Criteria andQtNotBetween(String value1, String value2) {
            addCriterion("QT not between", value1, value2, "qt");
            return this;
        }

        public Criteria andLyIsNull() {
            addCriterion("LY is null");
            return this;
        }

        public Criteria andLyIsNotNull() {
            addCriterion("LY is not null");
            return this;
        }

        public Criteria andLyEqualTo(String value) {
            addCriterion("LY =", value, "ly");
            return this;
        }

        public Criteria andLyNotEqualTo(String value) {
            addCriterion("LY <>", value, "ly");
            return this;
        }

        public Criteria andLyGreaterThan(String value) {
            addCriterion("LY >", value, "ly");
            return this;
        }

        public Criteria andLyGreaterThanOrEqualTo(String value) {
            addCriterion("LY >=", value, "ly");
            return this;
        }

        public Criteria andLyLessThan(String value) {
            addCriterion("LY <", value, "ly");
            return this;
        }

        public Criteria andLyLessThanOrEqualTo(String value) {
            addCriterion("LY <=", value, "ly");
            return this;
        }

        public Criteria andLyLike(String value) {
            addCriterion("LY like", value, "ly");
            return this;
        }

        public Criteria andLyNotLike(String value) {
            addCriterion("LY not like", value, "ly");
            return this;
        }

        public Criteria andLyIn(List<String> values) {
            addCriterion("LY in", values, "ly");
            return this;
        }

        public Criteria andLyNotIn(List<String> values) {
            addCriterion("LY not in", values, "ly");
            return this;
        }

        public Criteria andLyBetween(String value1, String value2) {
            addCriterion("LY between", value1, value2, "ly");
            return this;
        }

        public Criteria andLyNotBetween(String value1, String value2) {
            addCriterion("LY not between", value1, value2, "ly");
            return this;
        }

        public Criteria andRlrqIsNull() {
            addCriterion("RLRQ is null");
            return this;
        }

        public Criteria andRlrqIsNotNull() {
            addCriterion("RLRQ is not null");
            return this;
        }

        public Criteria andRlrqEqualTo(Date value) {
            addCriterionForJDBCDate("RLRQ =", value, "rlrq");
            return this;
        }

        public Criteria andRlrqNotEqualTo(Date value) {
            addCriterionForJDBCDate("RLRQ <>", value, "rlrq");
            return this;
        }

        public Criteria andRlrqGreaterThan(Date value) {
            addCriterionForJDBCDate("RLRQ >", value, "rlrq");
            return this;
        }

        public Criteria andRlrqGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("RLRQ >=", value, "rlrq");
            return this;
        }

        public Criteria andRlrqLessThan(Date value) {
            addCriterionForJDBCDate("RLRQ <", value, "rlrq");
            return this;
        }

        public Criteria andRlrqLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("RLRQ <=", value, "rlrq");
            return this;
        }

        public Criteria andRlrqIn(List<Date> values) {
            addCriterionForJDBCDate("RLRQ in", values, "rlrq");
            return this;
        }

        public Criteria andRlrqNotIn(List<Date> values) {
            addCriterionForJDBCDate("RLRQ not in", values, "rlrq");
            return this;
        }

        public Criteria andRlrqBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("RLRQ between", value1, value2, "rlrq");
            return this;
        }

        public Criteria andRlrqNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("RLRQ not between", value1, value2, "rlrq");
            return this;
        }

        public Criteria andCsrqIsNull() {
            addCriterion("CSRQ is null");
            return this;
        }

        public Criteria andCsrqIsNotNull() {
            addCriterion("CSRQ is not null");
            return this;
        }

        public Criteria andCsrqEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ =", value, "csrq");
            return this;
        }

        public Criteria andCsrqNotEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ <>", value, "csrq");
            return this;
        }

        public Criteria andCsrqGreaterThan(Date value) {
            addCriterionForJDBCDate("CSRQ >", value, "csrq");
            return this;
        }

        public Criteria andCsrqGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ >=", value, "csrq");
            return this;
        }

        public Criteria andCsrqLessThan(Date value) {
            addCriterionForJDBCDate("CSRQ <", value, "csrq");
            return this;
        }

        public Criteria andCsrqLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ <=", value, "csrq");
            return this;
        }

        public Criteria andCsrqIn(List<Date> values) {
            addCriterionForJDBCDate("CSRQ in", values, "csrq");
            return this;
        }

        public Criteria andCsrqNotIn(List<Date> values) {
            addCriterionForJDBCDate("CSRQ not in", values, "csrq");
            return this;
        }

        public Criteria andCsrqBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CSRQ between", value1, value2, "csrq");
            return this;
        }

        public Criteria andCsrqNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CSRQ not between", value1, value2, "csrq");
            return this;
        }

        public Criteria andLcrqIsNull() {
            addCriterion("LCRQ is null");
            return this;
        }

        public Criteria andLcrqIsNotNull() {
            addCriterion("LCRQ is not null");
            return this;
        }

        public Criteria andLcrqEqualTo(Date value) {
            addCriterionForJDBCDate("LCRQ =", value, "lcrq");
            return this;
        }

        public Criteria andLcrqNotEqualTo(Date value) {
            addCriterionForJDBCDate("LCRQ <>", value, "lcrq");
            return this;
        }

        public Criteria andLcrqGreaterThan(Date value) {
            addCriterionForJDBCDate("LCRQ >", value, "lcrq");
            return this;
        }

        public Criteria andLcrqGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LCRQ >=", value, "lcrq");
            return this;
        }

        public Criteria andLcrqLessThan(Date value) {
            addCriterionForJDBCDate("LCRQ <", value, "lcrq");
            return this;
        }

        public Criteria andLcrqLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LCRQ <=", value, "lcrq");
            return this;
        }

        public Criteria andLcrqIn(List<Date> values) {
            addCriterionForJDBCDate("LCRQ in", values, "lcrq");
            return this;
        }

        public Criteria andLcrqNotIn(List<Date> values) {
            addCriterionForJDBCDate("LCRQ not in", values, "lcrq");
            return this;
        }

        public Criteria andLcrqBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LCRQ between", value1, value2, "lcrq");
            return this;
        }

        public Criteria andLcrqNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LCRQ not between", value1, value2, "lcrq");
            return this;
        }

        public Criteria andScztIsNull() {
            addCriterion("SCZT is null");
            return this;
        }

        public Criteria andScztIsNotNull() {
            addCriterion("SCZT is not null");
            return this;
        }

        public Criteria andScztEqualTo(String value) {
            addCriterion("SCZT =", value, "sczt");
            return this;
        }

        public Criteria andScztNotEqualTo(String value) {
            addCriterion("SCZT <>", value, "sczt");
            return this;
        }

        public Criteria andScztGreaterThan(String value) {
            addCriterion("SCZT >", value, "sczt");
            return this;
        }

        public Criteria andScztGreaterThanOrEqualTo(String value) {
            addCriterion("SCZT >=", value, "sczt");
            return this;
        }

        public Criteria andScztLessThan(String value) {
            addCriterion("SCZT <", value, "sczt");
            return this;
        }

        public Criteria andScztLessThanOrEqualTo(String value) {
            addCriterion("SCZT <=", value, "sczt");
            return this;
        }

        public Criteria andScztLike(String value) {
            addCriterion("SCZT like", value, "sczt");
            return this;
        }

        public Criteria andScztNotLike(String value) {
            addCriterion("SCZT not like", value, "sczt");
            return this;
        }

        public Criteria andScztIn(List<String> values) {
            addCriterion("SCZT in", values, "sczt");
            return this;
        }

        public Criteria andScztNotIn(List<String> values) {
            addCriterion("SCZT not in", values, "sczt");
            return this;
        }

        public Criteria andScztBetween(String value1, String value2) {
            addCriterion("SCZT between", value1, value2, "sczt");
            return this;
        }

        public Criteria andScztNotBetween(String value1, String value2) {
            addCriterion("SCZT not between", value1, value2, "sczt");
            return this;
        }

        public Criteria andDqztIsNull() {
            addCriterion("DQZT is null");
            return this;
        }

        public Criteria andDqztIsNotNull() {
            addCriterion("DQZT is not null");
            return this;
        }

        public Criteria andDqztEqualTo(String value) {
            addCriterion("DQZT =", value, "dqzt");
            return this;
        }

        public Criteria andDqztNotEqualTo(String value) {
            addCriterion("DQZT <>", value, "dqzt");
            return this;
        }

        public Criteria andDqztGreaterThan(String value) {
            addCriterion("DQZT >", value, "dqzt");
            return this;
        }

        public Criteria andDqztGreaterThanOrEqualTo(String value) {
            addCriterion("DQZT >=", value, "dqzt");
            return this;
        }

        public Criteria andDqztLessThan(String value) {
            addCriterion("DQZT <", value, "dqzt");
            return this;
        }

        public Criteria andDqztLessThanOrEqualTo(String value) {
            addCriterion("DQZT <=", value, "dqzt");
            return this;
        }

        public Criteria andDqztLike(String value) {
            addCriterion("DQZT like", value, "dqzt");
            return this;
        }

        public Criteria andDqztNotLike(String value) {
            addCriterion("DQZT not like", value, "dqzt");
            return this;
        }

        public Criteria andDqztIn(List<String> values) {
            addCriterion("DQZT in", values, "dqzt");
            return this;
        }

        public Criteria andDqztNotIn(List<String> values) {
            addCriterion("DQZT not in", values, "dqzt");
            return this;
        }

        public Criteria andDqztBetween(String value1, String value2) {
            addCriterion("DQZT between", value1, value2, "dqzt");
            return this;
        }

        public Criteria andDqztNotBetween(String value1, String value2) {
            addCriterion("DQZT not between", value1, value2, "dqzt");
            return this;
        }

        public Criteria andFxidIsNull() {
            addCriterion("FXID is null");
            return this;
        }

        public Criteria andFxidIsNotNull() {
            addCriterion("FXID is not null");
            return this;
        }

        public Criteria andFxidEqualTo(String value) {
            addCriterion("FXID =", value, "fxid");
            return this;
        }

        public Criteria andFxidNotEqualTo(String value) {
            addCriterion("FXID <>", value, "fxid");
            return this;
        }

        public Criteria andFxidGreaterThan(String value) {
            addCriterion("FXID >", value, "fxid");
            return this;
        }

        public Criteria andFxidGreaterThanOrEqualTo(String value) {
            addCriterion("FXID >=", value, "fxid");
            return this;
        }

        public Criteria andFxidLessThan(String value) {
            addCriterion("FXID <", value, "fxid");
            return this;
        }

        public Criteria andFxidLessThanOrEqualTo(String value) {
            addCriterion("FXID <=", value, "fxid");
            return this;
        }

        public Criteria andFxidLike(String value) {
            addCriterion("FXID like", value, "fxid");
            return this;
        }

        public Criteria andFxidNotLike(String value) {
            addCriterion("FXID not like", value, "fxid");
            return this;
        }

        public Criteria andFxidIn(List<String> values) {
            addCriterion("FXID in", values, "fxid");
            return this;
        }

        public Criteria andFxidNotIn(List<String> values) {
            addCriterion("FXID not in", values, "fxid");
            return this;
        }

        public Criteria andFxidBetween(String value1, String value2) {
            addCriterion("FXID between", value1, value2, "fxid");
            return this;
        }

        public Criteria andFxidNotBetween(String value1, String value2) {
            addCriterion("FXID not between", value1, value2, "fxid");
            return this;
        }

        public Criteria andMxidIsNull() {
            addCriterion("MXID is null");
            return this;
        }

        public Criteria andMxidIsNotNull() {
            addCriterion("MXID is not null");
            return this;
        }

        public Criteria andMxidEqualTo(String value) {
            addCriterion("MXID =", value, "mxid");
            return this;
        }

        public Criteria andMxidNotEqualTo(String value) {
            addCriterion("MXID <>", value, "mxid");
            return this;
        }

        public Criteria andMxidGreaterThan(String value) {
            addCriterion("MXID >", value, "mxid");
            return this;
        }

        public Criteria andMxidGreaterThanOrEqualTo(String value) {
            addCriterion("MXID >=", value, "mxid");
            return this;
        }

        public Criteria andMxidLessThan(String value) {
            addCriterion("MXID <", value, "mxid");
            return this;
        }

        public Criteria andMxidLessThanOrEqualTo(String value) {
            addCriterion("MXID <=", value, "mxid");
            return this;
        }

        public Criteria andMxidLike(String value) {
            addCriterion("MXID like", value, "mxid");
            return this;
        }

        public Criteria andMxidNotLike(String value) {
            addCriterion("MXID not like", value, "mxid");
            return this;
        }

        public Criteria andMxidIn(List<String> values) {
            addCriterion("MXID in", values, "mxid");
            return this;
        }

        public Criteria andMxidNotIn(List<String> values) {
            addCriterion("MXID not in", values, "mxid");
            return this;
        }

        public Criteria andMxidBetween(String value1, String value2) {
            addCriterion("MXID between", value1, value2, "mxid");
            return this;
        }

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