ifm/javasrc/ibatis/com/huimv/da/dataobject/DaLqwhxxExample.java

package com.huimv.da.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 DaLqwhxxExample {
    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    protected String orderByClause;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    protected int start = -1;

    /**
     * This field was generated by Apache iBATIS ibator.
     * This field corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    protected int limit = -1;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public DaLqwhxxExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    protected DaLqwhxxExample(DaLqwhxxExample example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int getStart() {
        return start;
    }

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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 da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 CST 2014
     */
    public int getLimit() {
        return limit;
    }

    /**
     * This class was generated by Apache iBATIS ibator.
     * This class corresponds to the database table da_lqwhxx
     *
     * @ibatorgenerated Fri May 23 16:56:30 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("wh.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 andLqmcIsNull() {
            addCriterion("LQMC is null");
            return this;
        }

        public Criteria andLqmcIsNotNull() {
            addCriterion("LQMC is not null");
            return this;
        }

        public Criteria andLqmcEqualTo(String value) {
            addCriterion("LQMC =", value, "lqmc");
            return this;
        }

        public Criteria andLqmcNotEqualTo(String value) {
            addCriterion("LQMC <>", value, "lqmc");
            return this;
        }

        public Criteria andLqmcGreaterThan(String value) {
            addCriterion("LQMC >", value, "lqmc");
            return this;
        }

        public Criteria andLqmcGreaterThanOrEqualTo(String value) {
            addCriterion("LQMC >=", value, "lqmc");
            return this;
        }

        public Criteria andLqmcLessThan(String value) {
            addCriterion("LQMC <", value, "lqmc");
            return this;
        }

        public Criteria andLqmcLessThanOrEqualTo(String value) {
            addCriterion("LQMC <=", value, "lqmc");
            return this;
        }

        public Criteria andLqmcLike(String value) {
            addCriterion("LQMC like", value, "lqmc");
            return this;
        }

        public Criteria andLqmcNotLike(String value) {
            addCriterion("LQMC not like", value, "lqmc");
            return this;
        }

        public Criteria andLqmcIn(List<String> values) {
            addCriterion("LQMC in", values, "lqmc");
            return this;
        }

        public Criteria andLqmcNotIn(List<String> values) {
            addCriterion("LQMC not in", values, "lqmc");
            return this;
        }

        public Criteria andLqmcBetween(String value1, String value2) {
            addCriterion("LQMC between", value1, value2, "lqmc");
            return this;
        }

        public Criteria andLqmcNotBetween(String value1, String value2) {
            addCriterion("LQMC not between", value1, value2, "lqmc");
            return this;
        }

        public Criteria andFssjIsNull() {
            addCriterion("FSSJ is null");
            return this;
        }

        public Criteria andFssjIsNotNull() {
            addCriterion("FSSJ is not null");
            return this;
        }

        public Criteria andFssjEqualTo(Date value) {
            addCriterion("FSSJ =", value, "fssj");
            return this;
        }

        public Criteria andFssjNotEqualTo(Date value) {
            addCriterion("FSSJ <>", value, "fssj");
            return this;
        }

        public Criteria andFssjGreaterThan(Date value) {
            addCriterion("FSSJ >", value, "fssj");
            return this;
        }

        public Criteria andFssjGreaterThanOrEqualTo(Date value) {
            addCriterion("FSSJ >=", value, "fssj");
            return this;
        }

        public Criteria andFssjLessThan(Date value) {
            addCriterion("FSSJ <", value, "fssj");
            return this;
        }

        public Criteria andFssjLessThanOrEqualTo(Date value) {
            addCriterion("FSSJ <=", value, "fssj");
            return this;
        }

        public Criteria andFssjIn(List<Date> values) {
            addCriterion("FSSJ in", values, "fssj");
            return this;
        }

        public Criteria andFssjNotIn(List<Date> values) {
            addCriterion("FSSJ not in", values, "fssj");
            return this;
        }

        public Criteria andFssjBetween(Date value1, Date value2) {
            addCriterion("FSSJ between", value1, value2, "fssj");
            return this;
        }

        public Criteria andFssjNotBetween(Date value1, Date value2) {
            addCriterion("FSSJ not between", value1, value2, "fssj");
            return this;
        }

        public Criteria andZlsIsNull() {
            addCriterion("ZLS is null");
            return this;
        }

        public Criteria andZlsIsNotNull() {
            addCriterion("ZLS is not null");
            return this;
        }

        public Criteria andZlsEqualTo(Integer value) {
            addCriterion("ZLS =", value, "zls");
            return this;
        }

        public Criteria andZlsNotEqualTo(Integer value) {
            addCriterion("ZLS <>", value, "zls");
            return this;
        }

        public Criteria andZlsGreaterThan(Integer value) {
            addCriterion("ZLS >", value, "zls");
            return this;
        }

        public Criteria andZlsGreaterThanOrEqualTo(Integer value) {
            addCriterion("ZLS >=", value, "zls");
            return this;
        }

        public Criteria andZlsLessThan(Integer value) {
            addCriterion("ZLS <", value, "zls");
            return this;
        }

        public Criteria andZlsLessThanOrEqualTo(Integer value) {
            addCriterion("ZLS <=", value, "zls");
            return this;
        }

        public Criteria andZlsIn(List<Integer> values) {
            addCriterion("ZLS in", values, "zls");
            return this;
        }

        public Criteria andZlsNotIn(List<Integer> values) {
            addCriterion("ZLS not in", values, "zls");
            return this;
        }

        public Criteria andZlsBetween(Integer value1, Integer value2) {
            addCriterion("ZLS between", value1, value2, "zls");
            return this;
        }

        public Criteria andZlsNotBetween(Integer value1, Integer value2) {
            addCriterion("ZLS not between", value1, value2, "zls");
            return this;
        }

        public Criteria andRlsIsNull() {
            addCriterion("RLS is null");
            return this;
        }

        public Criteria andRlsIsNotNull() {
            addCriterion("RLS is not null");
            return this;
        }

        public Criteria andRlsEqualTo(Integer value) {
            addCriterion("RLS =", value, "rls");
            return this;
        }

        public Criteria andRlsNotEqualTo(Integer value) {
            addCriterion("RLS <>", value, "rls");
            return this;
        }

        public Criteria andRlsGreaterThan(Integer value) {
            addCriterion("RLS >", value, "rls");
            return this;
        }

        public Criteria andRlsGreaterThanOrEqualTo(Integer value) {
            addCriterion("RLS >=", value, "rls");
            return this;
        }

        public Criteria andRlsLessThan(Integer value) {
            addCriterion("RLS <", value, "rls");
            return this;
        }

        public Criteria andRlsLessThanOrEqualTo(Integer value) {
            addCriterion("RLS <=", value, "rls");
            return this;
        }

        public Criteria andRlsIn(List<Integer> values) {
            addCriterion("RLS in", values, "rls");
            return this;
        }

        public Criteria andRlsNotIn(List<Integer> values) {
            addCriterion("RLS not in", values, "rls");
            return this;
        }

        public Criteria andRlsBetween(Integer value1, Integer value2) {
            addCriterion("RLS between", value1, value2, "rls");
            return this;
        }

        public Criteria andRlsNotBetween(Integer value1, Integer value2) {
            addCriterion("RLS not between", value1, value2, "rls");
            return this;
        }

        public Criteria andRlpjtzIsNull() {
            addCriterion("RLPJTZ is null");
            return this;
        }

        public Criteria andRlpjtzIsNotNull() {
            addCriterion("RLPJTZ is not null");
            return this;
        }

        public Criteria andRlpjtzEqualTo(BigDecimal value) {
            addCriterion("RLPJTZ =", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzNotEqualTo(BigDecimal value) {
            addCriterion("RLPJTZ <>", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzGreaterThan(BigDecimal value) {
            addCriterion("RLPJTZ >", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RLPJTZ >=", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzLessThan(BigDecimal value) {
            addCriterion("RLPJTZ <", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RLPJTZ <=", value, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzIn(List<BigDecimal> values) {
            addCriterion("RLPJTZ in", values, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzNotIn(List<BigDecimal> values) {
            addCriterion("RLPJTZ not in", values, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RLPJTZ between", value1, value2, "rlpjtz");
            return this;
        }

        public Criteria andRlpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RLPJTZ not between", value1, value2, "rlpjtz");
            return this;
        }

        public Criteria andScsIsNull() {
            addCriterion("SCS is null");
            return this;
        }

        public Criteria andScsIsNotNull() {
            addCriterion("SCS is not null");
            return this;
        }

        public Criteria andScsEqualTo(Integer value) {
            addCriterion("SCS =", value, "scs");
            return this;
        }

        public Criteria andScsNotEqualTo(Integer value) {
            addCriterion("SCS <>", value, "scs");
            return this;
        }

        public Criteria andScsGreaterThan(Integer value) {
            addCriterion("SCS >", value, "scs");
            return this;
        }

        public Criteria andScsGreaterThanOrEqualTo(Integer value) {
            addCriterion("SCS >=", value, "scs");
            return this;
        }

        public Criteria andScsLessThan(Integer value) {
            addCriterion("SCS <", value, "scs");
            return this;
        }

        public Criteria andScsLessThanOrEqualTo(Integer value) {
            addCriterion("SCS <=", value, "scs");
            return this;
        }

        public Criteria andScsIn(List<Integer> values) {
            addCriterion("SCS in", values, "scs");
            return this;
        }

        public Criteria andScsNotIn(List<Integer> values) {
            addCriterion("SCS not in", values, "scs");
            return this;
        }

        public Criteria andScsBetween(Integer value1, Integer value2) {
            addCriterion("SCS between", value1, value2, "scs");
            return this;
        }

        public Criteria andScsNotBetween(Integer value1, Integer value2) {
            addCriterion("SCS not between", value1, value2, "scs");
            return this;
        }

        public Criteria andScpjtzIsNull() {
            addCriterion("SCPJTZ is null");
            return this;
        }

        public Criteria andScpjtzIsNotNull() {
            addCriterion("SCPJTZ is not null");
            return this;
        }

        public Criteria andScpjtzEqualTo(BigDecimal value) {
            addCriterion("SCPJTZ =", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzNotEqualTo(BigDecimal value) {
            addCriterion("SCPJTZ <>", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzGreaterThan(BigDecimal value) {
            addCriterion("SCPJTZ >", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SCPJTZ >=", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzLessThan(BigDecimal value) {
            addCriterion("SCPJTZ <", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SCPJTZ <=", value, "scpjtz");
            return this;
        }

        public Criteria andScpjtzIn(List<BigDecimal> values) {
            addCriterion("SCPJTZ in", values, "scpjtz");
            return this;
        }

        public Criteria andScpjtzNotIn(List<BigDecimal> values) {
            addCriterion("SCPJTZ not in", values, "scpjtz");
            return this;
        }

        public Criteria andScpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SCPJTZ between", value1, value2, "scpjtz");
            return this;
        }

        public Criteria andScpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SCPJTZ not between", value1, value2, "scpjtz");
            return this;
        }

        public Criteria andGlsIsNull() {
            addCriterion("GLS is null");
            return this;
        }

        public Criteria andGlsIsNotNull() {
            addCriterion("GLS is not null");
            return this;
        }

        public Criteria andGlsEqualTo(Integer value) {
            addCriterion("GLS =", value, "gls");
            return this;
        }

        public Criteria andGlsNotEqualTo(Integer value) {
            addCriterion("GLS <>", value, "gls");
            return this;
        }

        public Criteria andGlsGreaterThan(Integer value) {
            addCriterion("GLS >", value, "gls");
            return this;
        }

        public Criteria andGlsGreaterThanOrEqualTo(Integer value) {
            addCriterion("GLS >=", value, "gls");
            return this;
        }

        public Criteria andGlsLessThan(Integer value) {
            addCriterion("GLS <", value, "gls");
            return this;
        }

        public Criteria andGlsLessThanOrEqualTo(Integer value) {
            addCriterion("GLS <=", value, "gls");
            return this;
        }

        public Criteria andGlsIn(List<Integer> values) {
            addCriterion("GLS in", values, "gls");
            return this;
        }

        public Criteria andGlsNotIn(List<Integer> values) {
            addCriterion("GLS not in", values, "gls");
            return this;
        }

        public Criteria andGlsBetween(Integer value1, Integer value2) {
            addCriterion("GLS between", value1, value2, "gls");
            return this;
        }

        public Criteria andGlsNotBetween(Integer value1, Integer value2) {
            addCriterion("GLS not between", value1, value2, "gls");
            return this;
        }

        public Criteria andGlpjtzIsNull() {
            addCriterion("GLPJTZ is null");
            return this;
        }

        public Criteria andGlpjtzIsNotNull() {
            addCriterion("GLPJTZ is not null");
            return this;
        }

        public Criteria andGlpjtzEqualTo(BigDecimal value) {
            addCriterion("GLPJTZ =", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzNotEqualTo(BigDecimal value) {
            addCriterion("GLPJTZ <>", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzGreaterThan(BigDecimal value) {
            addCriterion("GLPJTZ >", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GLPJTZ >=", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzLessThan(BigDecimal value) {
            addCriterion("GLPJTZ <", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GLPJTZ <=", value, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzIn(List<BigDecimal> values) {
            addCriterion("GLPJTZ in", values, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzNotIn(List<BigDecimal> values) {
            addCriterion("GLPJTZ not in", values, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GLPJTZ between", value1, value2, "glpjtz");
            return this;
        }

        public Criteria andGlpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GLPJTZ not between", value1, value2, "glpjtz");
            return this;
        }

        public Criteria andSwsIsNull() {
            addCriterion("SWS is null");
            return this;
        }

        public Criteria andSwsIsNotNull() {
            addCriterion("SWS is not null");
            return this;
        }

        public Criteria andSwsEqualTo(Integer value) {
            addCriterion("SWS =", value, "sws");
            return this;
        }

        public Criteria andSwsNotEqualTo(Integer value) {
            addCriterion("SWS <>", value, "sws");
            return this;
        }

        public Criteria andSwsGreaterThan(Integer value) {
            addCriterion("SWS >", value, "sws");
            return this;
        }

        public Criteria andSwsGreaterThanOrEqualTo(Integer value) {
            addCriterion("SWS >=", value, "sws");
            return this;
        }

        public Criteria andSwsLessThan(Integer value) {
            addCriterion("SWS <", value, "sws");
            return this;
        }

        public Criteria andSwsLessThanOrEqualTo(Integer value) {
            addCriterion("SWS <=", value, "sws");
            return this;
        }

        public Criteria andSwsIn(List<Integer> values) {
            addCriterion("SWS in", values, "sws");
            return this;
        }

        public Criteria andSwsNotIn(List<Integer> values) {
            addCriterion("SWS not in", values, "sws");
            return this;
        }

        public Criteria andSwsBetween(Integer value1, Integer value2) {
            addCriterion("SWS between", value1, value2, "sws");
            return this;
        }

        public Criteria andSwsNotBetween(Integer value1, Integer value2) {
            addCriterion("SWS not between", value1, value2, "sws");
            return this;
        }

        public Criteria andSwpjtzIsNull() {
            addCriterion("SWPJTZ is null");
            return this;
        }

        public Criteria andSwpjtzIsNotNull() {
            addCriterion("SWPJTZ is not null");
            return this;
        }

        public Criteria andSwpjtzEqualTo(BigDecimal value) {
            addCriterion("SWPJTZ =", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzNotEqualTo(BigDecimal value) {
            addCriterion("SWPJTZ <>", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzGreaterThan(BigDecimal value) {
            addCriterion("SWPJTZ >", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SWPJTZ >=", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzLessThan(BigDecimal value) {
            addCriterion("SWPJTZ <", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SWPJTZ <=", value, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzIn(List<BigDecimal> values) {
            addCriterion("SWPJTZ in", values, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzNotIn(List<BigDecimal> values) {
            addCriterion("SWPJTZ not in", values, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SWPJTZ between", value1, value2, "swpjtz");
            return this;
        }

        public Criteria andSwpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SWPJTZ not between", value1, value2, "swpjtz");
            return this;
        }

        public Criteria andTtsIsNull() {
            addCriterion("TTS is null");
            return this;
        }

        public Criteria andTtsIsNotNull() {
            addCriterion("TTS is not null");
            return this;
        }

        public Criteria andTtsEqualTo(Integer value) {
            addCriterion("TTS =", value, "tts");
            return this;
        }

        public Criteria andTtsNotEqualTo(Integer value) {
            addCriterion("TTS <>", value, "tts");
            return this;
        }

        public Criteria andTtsGreaterThan(Integer value) {
            addCriterion("TTS >", value, "tts");
            return this;
        }

        public Criteria andTtsGreaterThanOrEqualTo(Integer value) {
            addCriterion("TTS >=", value, "tts");
            return this;
        }

        public Criteria andTtsLessThan(Integer value) {
            addCriterion("TTS <", value, "tts");
            return this;
        }

        public Criteria andTtsLessThanOrEqualTo(Integer value) {
            addCriterion("TTS <=", value, "tts");
            return this;
        }

        public Criteria andTtsIn(List<Integer> values) {
            addCriterion("TTS in", values, "tts");
            return this;
        }

        public Criteria andTtsNotIn(List<Integer> values) {
            addCriterion("TTS not in", values, "tts");
            return this;
        }

        public Criteria andTtsBetween(Integer value1, Integer value2) {
            addCriterion("TTS between", value1, value2, "tts");
            return this;
        }

        public Criteria andTtsNotBetween(Integer value1, Integer value2) {
            addCriterion("TTS not between", value1, value2, "tts");
            return this;
        }

        public Criteria andTtpjtzIsNull() {
            addCriterion("TTPJTZ is null");
            return this;
        }

        public Criteria andTtpjtzIsNotNull() {
            addCriterion("TTPJTZ is not null");
            return this;
        }

        public Criteria andTtpjtzEqualTo(BigDecimal value) {
            addCriterion("TTPJTZ =", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzNotEqualTo(BigDecimal value) {
            addCriterion("TTPJTZ <>", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzGreaterThan(BigDecimal value) {
            addCriterion("TTPJTZ >", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TTPJTZ >=", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzLessThan(BigDecimal value) {
            addCriterion("TTPJTZ <", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TTPJTZ <=", value, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzIn(List<BigDecimal> values) {
            addCriterion("TTPJTZ in", values, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzNotIn(List<BigDecimal> values) {
            addCriterion("TTPJTZ not in", values, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TTPJTZ between", value1, value2, "ttpjtz");
            return this;
        }

        public Criteria andTtpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TTPJTZ not between", value1, value2, "ttpjtz");
            return this;
        }

        public Criteria andClsIsNull() {
            addCriterion("CLS is null");
            return this;
        }

        public Criteria andClsIsNotNull() {
            addCriterion("CLS is not null");
            return this;
        }

        public Criteria andClsEqualTo(Integer value) {
            addCriterion("CLS =", value, "cls");
            return this;
        }

        public Criteria andClsNotEqualTo(Integer value) {
            addCriterion("CLS <>", value, "cls");
            return this;
        }

        public Criteria andClsGreaterThan(Integer value) {
            addCriterion("CLS >", value, "cls");
            return this;
        }

        public Criteria andClsGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLS >=", value, "cls");
            return this;
        }

        public Criteria andClsLessThan(Integer value) {
            addCriterion("CLS <", value, "cls");
            return this;
        }

        public Criteria andClsLessThanOrEqualTo(Integer value) {
            addCriterion("CLS <=", value, "cls");
            return this;
        }

        public Criteria andClsIn(List<Integer> values) {
            addCriterion("CLS in", values, "cls");
            return this;
        }

        public Criteria andClsNotIn(List<Integer> values) {
            addCriterion("CLS not in", values, "cls");
            return this;
        }

        public Criteria andClsBetween(Integer value1, Integer value2) {
            addCriterion("CLS between", value1, value2, "cls");
            return this;
        }

        public Criteria andClsNotBetween(Integer value1, Integer value2) {
            addCriterion("CLS not between", value1, value2, "cls");
            return this;
        }

        public Criteria andClpjtzIsNull() {
            addCriterion("CLPJTZ is null");
            return this;
        }

        public Criteria andClpjtzIsNotNull() {
            addCriterion("CLPJTZ is not null");
            return this;
        }

        public Criteria andClpjtzEqualTo(BigDecimal value) {
            addCriterion("CLPJTZ =", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzNotEqualTo(BigDecimal value) {
            addCriterion("CLPJTZ <>", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzGreaterThan(BigDecimal value) {
            addCriterion("CLPJTZ >", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CLPJTZ >=", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzLessThan(BigDecimal value) {
            addCriterion("CLPJTZ <", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CLPJTZ <=", value, "clpjtz");
            return this;
        }

        public Criteria andClpjtzIn(List<BigDecimal> values) {
            addCriterion("CLPJTZ in", values, "clpjtz");
            return this;
        }

        public Criteria andClpjtzNotIn(List<BigDecimal> values) {
            addCriterion("CLPJTZ not in", values, "clpjtz");
            return this;
        }

        public Criteria andClpjtzBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CLPJTZ between", value1, value2, "clpjtz");
            return this;
        }

        public Criteria andClpjtzNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CLPJTZ not between", value1, value2, "clpjtz");
            return this;
        }

        public Criteria andCzIsNull() {
            addCriterion("CZ is null");
            return this;
        }

        public Criteria andCzIsNotNull() {
            addCriterion("CZ is not null");
            return this;
        }

        public Criteria andCzEqualTo(String value) {
            addCriterion("CZ =", value, "cz");
            return this;
        }

        public Criteria andCzNotEqualTo(String value) {
            addCriterion("CZ <>", value, "cz");
            return this;
        }

        public Criteria andCzGreaterThan(String value) {
            addCriterion("CZ >", value, "cz");
            return this;
        }

        public Criteria andCzGreaterThanOrEqualTo(String value) {
            addCriterion("CZ >=", value, "cz");
            return this;
        }

        public Criteria andCzLessThan(String value) {
            addCriterion("CZ <", value, "cz");
            return this;
        }

        public Criteria andCzLessThanOrEqualTo(String value) {
            addCriterion("CZ <=", value, "cz");
            return this;
        }

        public Criteria andCzLike(String value) {
            addCriterion("CZ like", value, "cz");
            return this;
        }

        public Criteria andCzNotLike(String value) {
            addCriterion("CZ not like", value, "cz");
            return this;
        }

        public Criteria andCzIn(List<String> values) {
            addCriterion("CZ in", values, "cz");
            return this;
        }

        public Criteria andCzNotIn(List<String> values) {
            addCriterion("CZ not in", values, "cz");
            return this;
        }

        public Criteria andCzBetween(String value1, String value2) {
            addCriterion("CZ between", value1, value2, "cz");
            return this;
        }

        public Criteria andCzNotBetween(String value1, String value2) {
            addCriterion("CZ not between", value1, value2, "cz");
            return this;
        }

        public Criteria andGlyIsNull() {
            addCriterion("GLY is null");
            return this;
        }

        public Criteria andGlyIsNotNull() {
            addCriterion("GLY is not null");
            return this;
        }

        public Criteria andGlyEqualTo(String value) {
            addCriterion("GLY =", value, "gly");
            return this;
        }

        public Criteria andGlyNotEqualTo(String value) {
            addCriterion("GLY <>", value, "gly");
            return this;
        }

        public Criteria andGlyGreaterThan(String value) {
            addCriterion("GLY >", value, "gly");
            return this;
        }

        public Criteria andGlyGreaterThanOrEqualTo(String value) {
            addCriterion("GLY >=", value, "gly");
            return this;
        }

        public Criteria andGlyLessThan(String value) {
            addCriterion("GLY <", value, "gly");
            return this;
        }

        public Criteria andGlyLessThanOrEqualTo(String value) {
            addCriterion("GLY <=", value, "gly");
            return this;
        }

        public Criteria andGlyLike(String value) {
            addCriterion("GLY like", value, "gly");
            return this;
        }

        public Criteria andGlyNotLike(String value) {
            addCriterion("GLY not like", value, "gly");
            return this;
        }

        public Criteria andGlyIn(List<String> values) {
            addCriterion("GLY in", values, "gly");
            return this;
        }

        public Criteria andGlyNotIn(List<String> values) {
            addCriterion("GLY not in", values, "gly");
            return this;
        }

        public Criteria andGlyBetween(String value1, String value2) {
            addCriterion("GLY between", value1, value2, "gly");
            return this;
        }

        public Criteria andGlyNotBetween(String value1, String value2) {
            addCriterion("GLY not between", value1, value2, "gly");
            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 andMCZSLQLQWHZfbzEqualTo(Integer value) {
            addCriterion("wh.ZFBZ =", value, "zfbz");
            return this;
        }
        
        public Criteria andMCZSLQLQWHLqidEqualTo(Integer value) {
            addCriterion("LQID =", value, "lqid");
            return this;
        }
    }
}