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

package com.huimv.sjlr.dataobject;

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

public class SjlrZzttExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public SjlrZzttExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    protected SjlrZzttExample(SjlrZzttExample 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public String getOrderByClause() {
        return orderByClause;
    }

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

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 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_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sjlr_zztt
     *
     * @ibatorgenerated Fri Jul 21 14:07:28 CST 2017
     */
    public static class Criteria {
        protected List<String> criteriaWithoutValue;

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

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

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

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

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

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

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

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

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

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

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

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

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            List<Object> list = new ArrayList<Object>();
            list.add(value1);
            list.add(value2);
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("condition", condition);
            map.put("values", list);
            criteriaWithBetweenValue.add(map);
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria 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 andTtslIsNull() {
            addCriterion("TTSL is null");
            return this;
        }

        public Criteria andTtslIsNotNull() {
            addCriterion("TTSL is not null");
            return this;
        }

        public Criteria andTtslEqualTo(String value) {
            addCriterion("TTSL =", value, "ttsl");
            return this;
        }

        public Criteria andTtslNotEqualTo(String value) {
            addCriterion("TTSL <>", value, "ttsl");
            return this;
        }

        public Criteria andTtslGreaterThan(String value) {
            addCriterion("TTSL >", value, "ttsl");
            return this;
        }

        public Criteria andTtslGreaterThanOrEqualTo(String value) {
            addCriterion("TTSL >=", value, "ttsl");
            return this;
        }

        public Criteria andTtslLessThan(String value) {
            addCriterion("TTSL <", value, "ttsl");
            return this;
        }

        public Criteria andTtslLessThanOrEqualTo(String value) {
            addCriterion("TTSL <=", value, "ttsl");
            return this;
        }

        public Criteria andTtslLike(String value) {
            addCriterion("TTSL like", value, "ttsl");
            return this;
        }

        public Criteria andTtslNotLike(String value) {
            addCriterion("TTSL not like", value, "ttsl");
            return this;
        }

        public Criteria andTtslIn(List<String> values) {
            addCriterion("TTSL in", values, "ttsl");
            return this;
        }

        public Criteria andTtslNotIn(List<String> values) {
            addCriterion("TTSL not in", values, "ttsl");
            return this;
        }

        public Criteria andTtslBetween(String value1, String value2) {
            addCriterion("TTSL between", value1, value2, "ttsl");
            return this;
        }

        public Criteria andTtslNotBetween(String value1, String value2) {
            addCriterion("TTSL not between", value1, value2, "ttsl");
            return this;
        }

        public Criteria andTtsjIsNull() {
            addCriterion("TTSJ is null");
            return this;
        }

        public Criteria andTtsjIsNotNull() {
            addCriterion("TTSJ is not null");
            return this;
        }

        public Criteria andTtsjEqualTo(Date value) {
            addCriterion("TTSJ =", value, "ttsj");
            return this;
        }

        public Criteria andTtsjNotEqualTo(Date value) {
            addCriterion("TTSJ <>", value, "ttsj");
            return this;
        }

        public Criteria andTtsjGreaterThan(Date value) {
            addCriterion("TTSJ >", value, "ttsj");
            return this;
        }

        public Criteria andTtsjGreaterThanOrEqualTo(Date value) {
            addCriterion("TTSJ >=", value, "ttsj");
            return this;
        }

        public Criteria andTtsjLessThan(Date value) {
            addCriterion("TTSJ <", value, "ttsj");
            return this;
        }

        public Criteria andTtsjLessThanOrEqualTo(Date value) {
            addCriterion("TTSJ <=", value, "ttsj");
            return this;
        }

        public Criteria andTtsjIn(List<Date> values) {
            addCriterion("TTSJ in", values, "ttsj");
            return this;
        }

        public Criteria andTtsjNotIn(List<Date> values) {
            addCriterion("TTSJ not in", values, "ttsj");
            return this;
        }

        public Criteria andTtsjBetween(Date value1, Date value2) {
            addCriterion("TTSJ between", value1, value2, "ttsj");
            return this;
        }

        public Criteria andTtsjNotBetween(Date value1, Date value2) {
            addCriterion("TTSJ not between", value1, value2, "ttsj");
            return this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andTtlxIsNull() {
            addCriterion("TTLX is null");
            return this;
        }

        public Criteria andTtlxIsNotNull() {
            addCriterion("TTLX is not null");
            return this;
        }

        public Criteria andTtlxEqualTo(String value) {
            addCriterion("TTLX =", value, "ttlx");
            return this;
        }

        public Criteria andTtlxNotEqualTo(String value) {
            addCriterion("TTLX <>", value, "ttlx");
            return this;
        }

        public Criteria andTtlxGreaterThan(String value) {
            addCriterion("TTLX >", value, "ttlx");
            return this;
        }

        public Criteria andTtlxGreaterThanOrEqualTo(String value) {
            addCriterion("TTLX >=", value, "ttlx");
            return this;
        }

        public Criteria andTtlxLessThan(String value) {
            addCriterion("TTLX <", value, "ttlx");
            return this;
        }

        public Criteria andTtlxLessThanOrEqualTo(String value) {
            addCriterion("TTLX <=", value, "ttlx");
            return this;
        }

        public Criteria andTtlxLike(String value) {
            addCriterion("TTLX like", value, "ttlx");
            return this;
        }

        public Criteria andTtlxNotLike(String value) {
            addCriterion("TTLX not like", value, "ttlx");
            return this;
        }

        public Criteria andTtlxIn(List<String> values) {
            addCriterion("TTLX in", values, "ttlx");
            return this;
        }

        public Criteria andTtlxNotIn(List<String> values) {
            addCriterion("TTLX not in", values, "ttlx");
            return this;
        }

        public Criteria andTtlxBetween(String value1, String value2) {
            addCriterion("TTLX between", value1, value2, "ttlx");
            return this;
        }

        public Criteria andTtlxNotBetween(String value1, String value2) {
            addCriterion("TTLX not between", value1, value2, "ttlx");
            return this;
        }

        public Criteria andBzsmIsNull() {
            addCriterion("BZSM is null");
            return this;
        }

        public Criteria andBzsmIsNotNull() {
            addCriterion("BZSM is not null");
            return this;
        }

        public Criteria andBzsmEqualTo(String value) {
            addCriterion("BZSM =", value, "bzsm");
            return this;
        }

        public Criteria andBzsmNotEqualTo(String value) {
            addCriterion("BZSM <>", value, "bzsm");
            return this;
        }

        public Criteria andBzsmGreaterThan(String value) {
            addCriterion("BZSM >", value, "bzsm");
            return this;
        }

        public Criteria andBzsmGreaterThanOrEqualTo(String value) {
            addCriterion("BZSM >=", value, "bzsm");
            return this;
        }

        public Criteria andBzsmLessThan(String value) {
            addCriterion("BZSM <", value, "bzsm");
            return this;
        }

        public Criteria andBzsmLessThanOrEqualTo(String value) {
            addCriterion("BZSM <=", value, "bzsm");
            return this;
        }

        public Criteria andBzsmLike(String value) {
            addCriterion("BZSM like", value, "bzsm");
            return this;
        }

        public Criteria andBzsmNotLike(String value) {
            addCriterion("BZSM not like", value, "bzsm");
            return this;
        }

        public Criteria andBzsmIn(List<String> values) {
            addCriterion("BZSM in", values, "bzsm");
            return this;
        }

        public Criteria andBzsmNotIn(List<String> values) {
            addCriterion("BZSM not in", values, "bzsm");
            return this;
        }

        public Criteria andBzsmBetween(String value1, String value2) {
            addCriterion("BZSM between", value1, value2, "bzsm");
            return this;
        }

        public Criteria andBzsmNotBetween(String value1, String value2) {
            addCriterion("BZSM not between", value1, value2, "bzsm");
            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 andShIsNull() {
            addCriterion("SH is null");
            return this;
        }

        public Criteria andShIsNotNull() {
            addCriterion("SH is not null");
            return this;
        }

        public Criteria andShEqualTo(String value) {
            addCriterion("SH =", value, "sh");
            return this;
        }

        public Criteria andShNotEqualTo(String value) {
            addCriterion("SH <>", value, "sh");
            return this;
        }

        public Criteria andShGreaterThan(String value) {
            addCriterion("SH >", value, "sh");
            return this;
        }

        public Criteria andShGreaterThanOrEqualTo(String value) {
            addCriterion("SH >=", value, "sh");
            return this;
        }

        public Criteria andShLessThan(String value) {
            addCriterion("SH <", value, "sh");
            return this;
        }

        public Criteria andShLessThanOrEqualTo(String value) {
            addCriterion("SH <=", value, "sh");
            return this;
        }

        public Criteria andShLike(String value) {
            addCriterion("SH like", value, "sh");
            return this;
        }

        public Criteria andShNotLike(String value) {
            addCriterion("SH not like", value, "sh");
            return this;
        }

        public Criteria andShIn(List<String> values) {
            addCriterion("SH in", values, "sh");
            return this;
        }

        public Criteria andShNotIn(List<String> values) {
            addCriterion("SH not in", values, "sh");
            return this;
        }

        public Criteria andShBetween(String value1, String value2) {
            addCriterion("SH between", value1, value2, "sh");
            return this;
        }

        public Criteria andShNotBetween(String value1, String value2) {
            addCriterion("SH not between", value1, value2, "sh");
            return this;
        }
    }
}