package com.huimv.sj.dataobject;

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

public class SjSscssjExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public SjSscssjExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    protected SjSscssjExample(SjSscssjExample example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 CST 2014
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table sj_sscssj
     *
     * @ibatorgenerated Thu Jun 19 15:59:45 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 andLqidIsNull() {
            addCriterion("LQID is null");
            return this;
        }

        public Criteria andLqidIsNotNull() {
            addCriterion("LQID is not null");
            return this;
        }

        public Criteria andLqidEqualTo(Integer value) {
            addCriterion("sl.LQID =", value, "lqid");
            return this;
        }

        public Criteria andLqidNotEqualTo(Integer value) {
            addCriterion("LQID <>", value, "lqid");
            return this;
        }

        public Criteria andLqidGreaterThan(Integer value) {
            addCriterion("LQID >", value, "lqid");
            return this;
        }

        public Criteria andLqidGreaterThanOrEqualTo(Integer value) {
            addCriterion("LQID >=", value, "lqid");
            return this;
        }

        public Criteria andLqidLessThan(Integer value) {
            addCriterion("LQID <", value, "lqid");
            return this;
        }

        public Criteria andLqidLessThanOrEqualTo(Integer value) {
            addCriterion("LQID <=", value, "lqid");
            return this;
        }

        public Criteria andLqidIn(List<Integer> values) {
            addCriterion("LQID in", values, "lqid");
            return this;
        }

        public Criteria andLqidNotIn(List<Integer> values) {
            addCriterion("LQID not in", values, "lqid");
            return this;
        }

        public Criteria andLqidBetween(Integer value1, Integer value2) {
            addCriterion("LQID between", value1, value2, "lqid");
            return this;
        }

        public Criteria andLqidNotBetween(Integer value1, Integer value2) {
            addCriterion("LQID not between", value1, value2, "lqid");
            return this;
        }

        public Criteria andCslIsNull() {
            addCriterion("CSL is null");
            return this;
        }

        public Criteria andCslIsNotNull() {
            addCriterion("CSL is not null");
            return this;
        }

        public Criteria andCslEqualTo(BigDecimal value) {
            addCriterion("CSL =", value, "csl");
            return this;
        }

        public Criteria andCslNotEqualTo(BigDecimal value) {
            addCriterion("CSL <>", value, "csl");
            return this;
        }

        public Criteria andCslGreaterThan(BigDecimal value) {
            addCriterion("CSL >", value, "csl");
            return this;
        }

        public Criteria andCslGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CSL >=", value, "csl");
            return this;
        }

        public Criteria andCslLessThan(BigDecimal value) {
            addCriterion("CSL <", value, "csl");
            return this;
        }

        public Criteria andCslLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CSL <=", value, "csl");
            return this;
        }

        public Criteria andCslIn(List<BigDecimal> values) {
            addCriterion("CSL in", values, "csl");
            return this;
        }

        public Criteria andCslNotIn(List<BigDecimal> values) {
            addCriterion("CSL not in", values, "csl");
            return this;
        }

        public Criteria andCslBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CSL between", value1, value2, "csl");
            return this;
        }

        public Criteria andCslNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CSL not between", value1, value2, "csl");
            return this;
        }

        public Criteria andCsqIsNull() {
            addCriterion("CSQ is null");
            return this;
        }

        public Criteria andCsqIsNotNull() {
            addCriterion("CSQ is not null");
            return this;
        }

        public Criteria andCsqEqualTo(String value) {
            addCriterion("CSQ =", value, "csq");
            return this;
        }

        public Criteria andCsqNotEqualTo(String value) {
            addCriterion("CSQ <>", value, "csq");
            return this;
        }

        public Criteria andCsqGreaterThan(String value) {
            addCriterion("CSQ >", value, "csq");
            return this;
        }

        public Criteria andCsqGreaterThanOrEqualTo(String value) {
            addCriterion("CSQ >=", value, "csq");
            return this;
        }

        public Criteria andCsqLessThan(String value) {
            addCriterion("CSQ <", value, "csq");
            return this;
        }

        public Criteria andCsqLessThanOrEqualTo(String value) {
            addCriterion("CSQ <=", value, "csq");
            return this;
        }

        public Criteria andCsqLike(String value) {
            addCriterion("CSQ like", value, "csq");
            return this;
        }

        public Criteria andCsqNotLike(String value) {
            addCriterion("CSQ not like", value, "csq");
            return this;
        }

        public Criteria andCsqIn(List<String> values) {
            addCriterion("CSQ in", values, "csq");
            return this;
        }

        public Criteria andCsqNotIn(List<String> values) {
            addCriterion("CSQ not in", values, "csq");
            return this;
        }

        public Criteria andCsqBetween(String value1, String value2) {
            addCriterion("CSQ between", value1, value2, "csq");
            return this;
        }

        public Criteria andCsqNotBetween(String value1, String value2) {
            addCriterion("CSQ not between", value1, value2, "csq");
            return this;
        }

        public Criteria andCssjIsNull() {
            addCriterion("CSSJ is null");
            return this;
        }

        public Criteria andCssjIsNotNull() {
            addCriterion("CSSJ is not null");
            return this;
        }

        public Criteria andCssjEqualTo(Date value) {
            addCriterion("CSSJ =", value, "cssj");
            return this;
        }

        public Criteria andCssjNotEqualTo(Date value) {
            addCriterion("CSSJ <>", value, "cssj");
            return this;
        }

        public Criteria andCssjGreaterThan(Date value) {
            addCriterion("CSSJ >", value, "cssj");
            return this;
        }

        public Criteria andCssjGreaterThanOrEqualTo(Date value) {
            addCriterion("CSSJ >=", value, "cssj");
            return this;
        }

        public Criteria andCssjLessThan(Date value) {
            addCriterion("CSSJ <", value, "cssj");
            return this;
        }

        public Criteria andCssjLessThanOrEqualTo(Date value) {
            addCriterion("CSSJ <=", value, "cssj");
            return this;
        }

        public Criteria andCssjIn(List<Date> values) {
            addCriterion("CSSJ in", values, "cssj");
            return this;
        }

        public Criteria andCssjNotIn(List<Date> values) {
            addCriterion("CSSJ not in", values, "cssj");
            return this;
        }

        public Criteria andCssjBetween(Date value1, Date value2) {
            addCriterion("CSSJ between", value1, value2, "cssj");
            return this;
        }

        public Criteria andCssjNotBetween(Date value1, Date value2) {
            addCriterion("CSSJ not between", value1, value2, "cssj");
            return this;
        }

        public Criteria andSlbzIsNull() {
            addCriterion("SLBZ is null");
            return this;
        }

        public Criteria andSlbzIsNotNull() {
            addCriterion("SLBZ is not null");
            return this;
        }

        public Criteria andSlbzEqualTo(String value) {
            addCriterion("SLBZ =", value, "slbz");
            return this;
        }

        public Criteria andSlbzNotEqualTo(String value) {
            addCriterion("SLBZ <>", value, "slbz");
            return this;
        }

        public Criteria andSlbzGreaterThan(String value) {
            addCriterion("SLBZ >", value, "slbz");
            return this;
        }

        public Criteria andSlbzGreaterThanOrEqualTo(String value) {
            addCriterion("SLBZ >=", value, "slbz");
            return this;
        }

        public Criteria andSlbzLessThan(String value) {
            addCriterion("SLBZ <", value, "slbz");
            return this;
        }

        public Criteria andSlbzLessThanOrEqualTo(String value) {
            addCriterion("SLBZ <=", value, "slbz");
            return this;
        }

        public Criteria andSlbzLike(String value) {
            addCriterion("SLBZ like", value, "slbz");
            return this;
        }

        public Criteria andSlbzNotLike(String value) {
            addCriterion("SLBZ not like", value, "slbz");
            return this;
        }

        public Criteria andSlbzIn(List<String> values) {
            addCriterion("SLBZ in", values, "slbz");
            return this;
        }

        public Criteria andSlbzNotIn(List<String> values) {
            addCriterion("SLBZ not in", values, "slbz");
            return this;
        }

        public Criteria andSlbzBetween(String value1, String value2) {
            addCriterion("SLBZ between", value1, value2, "slbz");
            return this;
        }

        public Criteria andSlbzNotBetween(String value1, String value2) {
            addCriterion("SLBZ not between", value1, value2, "slbz");
            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("sl.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;
        }
		
        /**
         * 上料维护
         * @param value
         * @return
         */
        public Criteria andSlwhLqidEqualTo(Integer value) {
            addCriterion("sl.LQID =", value, "lqid");
            return this;
        }
    }
}