package com.gyee.frame.model.auto;


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

public class EquipmentSqlExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public EquipmentSqlExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

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

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        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");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

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

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

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

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

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

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

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

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

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

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

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

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

        public Criteria andEqnumIsNull() {
            addCriterion("EQNUM is null");
            return (Criteria) this;
        }

        public Criteria andEqnumIsNotNull() {
            addCriterion("EQNUM is not null");
            return (Criteria) this;
        }

        public Criteria andEqnumEqualTo(String value) {
            addCriterion("EQNUM =", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumNotEqualTo(String value) {
            addCriterion("EQNUM <>", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumGreaterThan(String value) {
            addCriterion("EQNUM >", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumGreaterThanOrEqualTo(String value) {
            addCriterion("EQNUM >=", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumLessThan(String value) {
            addCriterion("EQNUM <", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumLessThanOrEqualTo(String value) {
            addCriterion("EQNUM <=", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumLike(String value) {
            addCriterion("EQNUM like", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumNotLike(String value) {
            addCriterion("EQNUM not like", value, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumIn(List<String> values) {
            addCriterion("EQNUM in", values, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumNotIn(List<String> values) {
            addCriterion("EQNUM not in", values, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumBetween(String value1, String value2) {
            addCriterion("EQNUM between", value1, value2, "eqnum");
            return (Criteria) this;
        }

        public Criteria andEqnumNotBetween(String value1, String value2) {
            addCriterion("EQNUM not between", value1, value2, "eqnum");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("DESCRIPTION is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("DESCRIPTION is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("DESCRIPTION =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("DESCRIPTION <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("DESCRIPTION >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("DESCRIPTION <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("DESCRIPTION like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("DESCRIPTION not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("DESCRIPTION in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("DESCRIPTION not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("DESCRIPTION between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("DESCRIPTION not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andLocationIsNull() {
            addCriterion("LOCATION is null");
            return (Criteria) this;
        }

        public Criteria andLocationIsNotNull() {
            addCriterion("LOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andLocationEqualTo(String value) {
            addCriterion("LOCATION =", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotEqualTo(String value) {
            addCriterion("LOCATION <>", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThan(String value) {
            addCriterion("LOCATION >", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationGreaterThanOrEqualTo(String value) {
            addCriterion("LOCATION >=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThan(String value) {
            addCriterion("LOCATION <", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLessThanOrEqualTo(String value) {
            addCriterion("LOCATION <=", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationLike(String value) {
            addCriterion("LOCATION like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotLike(String value) {
            addCriterion("LOCATION not like", value, "location");
            return (Criteria) this;
        }

        public Criteria andLocationIn(List<String> values) {
            addCriterion("LOCATION in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotIn(List<String> values) {
            addCriterion("LOCATION not in", values, "location");
            return (Criteria) this;
        }

        public Criteria andLocationBetween(String value1, String value2) {
            addCriterion("LOCATION between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andLocationNotBetween(String value1, String value2) {
            addCriterion("LOCATION not between", value1, value2, "location");
            return (Criteria) this;
        }

        public Criteria andParentIsNull() {
            addCriterion("PARENT is null");
            return (Criteria) this;
        }

        public Criteria andParentIsNotNull() {
            addCriterion("PARENT is not null");
            return (Criteria) this;
        }

        public Criteria andParentEqualTo(String value) {
            addCriterion("PARENT =", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentNotEqualTo(String value) {
            addCriterion("PARENT <>", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentGreaterThan(String value) {
            addCriterion("PARENT >", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentGreaterThanOrEqualTo(String value) {
            addCriterion("PARENT >=", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentLessThan(String value) {
            addCriterion("PARENT <", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentLessThanOrEqualTo(String value) {
            addCriterion("PARENT <=", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentLike(String value) {
            addCriterion("PARENT like", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentNotLike(String value) {
            addCriterion("PARENT not like", value, "parent");
            return (Criteria) this;
        }

        public Criteria andParentIn(List<String> values) {
            addCriterion("PARENT in", values, "parent");
            return (Criteria) this;
        }

        public Criteria andParentNotIn(List<String> values) {
            addCriterion("PARENT not in", values, "parent");
            return (Criteria) this;
        }

        public Criteria andParentBetween(String value1, String value2) {
            addCriterion("PARENT between", value1, value2, "parent");
            return (Criteria) this;
        }

        public Criteria andParentNotBetween(String value1, String value2) {
            addCriterion("PARENT not between", value1, value2, "parent");
            return (Criteria) this;
        }

        public Criteria andSerialnumIsNull() {
            addCriterion("SERIALNUM is null");
            return (Criteria) this;
        }

        public Criteria andSerialnumIsNotNull() {
            addCriterion("SERIALNUM is not null");
            return (Criteria) this;
        }

        public Criteria andSerialnumEqualTo(String value) {
            addCriterion("SERIALNUM =", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumNotEqualTo(String value) {
            addCriterion("SERIALNUM <>", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumGreaterThan(String value) {
            addCriterion("SERIALNUM >", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumGreaterThanOrEqualTo(String value) {
            addCriterion("SERIALNUM >=", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumLessThan(String value) {
            addCriterion("SERIALNUM <", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumLessThanOrEqualTo(String value) {
            addCriterion("SERIALNUM <=", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumLike(String value) {
            addCriterion("SERIALNUM like", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumNotLike(String value) {
            addCriterion("SERIALNUM not like", value, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumIn(List<String> values) {
            addCriterion("SERIALNUM in", values, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumNotIn(List<String> values) {
            addCriterion("SERIALNUM not in", values, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumBetween(String value1, String value2) {
            addCriterion("SERIALNUM between", value1, value2, "serialnum");
            return (Criteria) this;
        }

        public Criteria andSerialnumNotBetween(String value1, String value2) {
            addCriterion("SERIALNUM not between", value1, value2, "serialnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumIsNull() {
            addCriterion("ASSETNUM is null");
            return (Criteria) this;
        }

        public Criteria andAssetnumIsNotNull() {
            addCriterion("ASSETNUM is not null");
            return (Criteria) this;
        }

        public Criteria andAssetnumEqualTo(String value) {
            addCriterion("ASSETNUM =", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumNotEqualTo(String value) {
            addCriterion("ASSETNUM <>", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumGreaterThan(String value) {
            addCriterion("ASSETNUM >", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumGreaterThanOrEqualTo(String value) {
            addCriterion("ASSETNUM >=", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumLessThan(String value) {
            addCriterion("ASSETNUM <", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumLessThanOrEqualTo(String value) {
            addCriterion("ASSETNUM <=", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumLike(String value) {
            addCriterion("ASSETNUM like", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumNotLike(String value) {
            addCriterion("ASSETNUM not like", value, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumIn(List<String> values) {
            addCriterion("ASSETNUM in", values, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumNotIn(List<String> values) {
            addCriterion("ASSETNUM not in", values, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumBetween(String value1, String value2) {
            addCriterion("ASSETNUM between", value1, value2, "assetnum");
            return (Criteria) this;
        }

        public Criteria andAssetnumNotBetween(String value1, String value2) {
            addCriterion("ASSETNUM not between", value1, value2, "assetnum");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusdateIsNull() {
            addCriterion("STATUSDATE is null");
            return (Criteria) this;
        }

        public Criteria andStatusdateIsNotNull() {
            addCriterion("STATUSDATE is not null");
            return (Criteria) this;
        }

        public Criteria andStatusdateEqualTo(Date value) {
            addCriterion("STATUSDATE =", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateNotEqualTo(Date value) {
            addCriterion("STATUSDATE <>", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateGreaterThan(Date value) {
            addCriterion("STATUSDATE >", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateGreaterThanOrEqualTo(Date value) {
            addCriterion("STATUSDATE >=", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateLessThan(Date value) {
            addCriterion("STATUSDATE <", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateLessThanOrEqualTo(Date value) {
            addCriterion("STATUSDATE <=", value, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateIn(List<Date> values) {
            addCriterion("STATUSDATE in", values, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateNotIn(List<Date> values) {
            addCriterion("STATUSDATE not in", values, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateBetween(Date value1, Date value2) {
            addCriterion("STATUSDATE between", value1, value2, "statusdate");
            return (Criteria) this;
        }

        public Criteria andStatusdateNotBetween(Date value1, Date value2) {
            addCriterion("STATUSDATE not between", value1, value2, "statusdate");
            return (Criteria) this;
        }

        public Criteria andVendorIsNull() {
            addCriterion("VENDOR is null");
            return (Criteria) this;
        }

        public Criteria andVendorIsNotNull() {
            addCriterion("VENDOR is not null");
            return (Criteria) this;
        }

        public Criteria andVendorEqualTo(String value) {
            addCriterion("VENDOR =", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotEqualTo(String value) {
            addCriterion("VENDOR <>", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorGreaterThan(String value) {
            addCriterion("VENDOR >", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorGreaterThanOrEqualTo(String value) {
            addCriterion("VENDOR >=", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLessThan(String value) {
            addCriterion("VENDOR <", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLessThanOrEqualTo(String value) {
            addCriterion("VENDOR <=", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorLike(String value) {
            addCriterion("VENDOR like", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotLike(String value) {
            addCriterion("VENDOR not like", value, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorIn(List<String> values) {
            addCriterion("VENDOR in", values, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotIn(List<String> values) {
            addCriterion("VENDOR not in", values, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorBetween(String value1, String value2) {
            addCriterion("VENDOR between", value1, value2, "vendor");
            return (Criteria) this;
        }

        public Criteria andVendorNotBetween(String value1, String value2) {
            addCriterion("VENDOR not between", value1, value2, "vendor");
            return (Criteria) this;
        }

        public Criteria andFailurecodeIsNull() {
            addCriterion("FAILURECODE is null");
            return (Criteria) this;
        }

        public Criteria andFailurecodeIsNotNull() {
            addCriterion("FAILURECODE is not null");
            return (Criteria) this;
        }

        public Criteria andFailurecodeEqualTo(String value) {
            addCriterion("FAILURECODE =", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeNotEqualTo(String value) {
            addCriterion("FAILURECODE <>", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeGreaterThan(String value) {
            addCriterion("FAILURECODE >", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeGreaterThanOrEqualTo(String value) {
            addCriterion("FAILURECODE >=", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeLessThan(String value) {
            addCriterion("FAILURECODE <", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeLessThanOrEqualTo(String value) {
            addCriterion("FAILURECODE <=", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeLike(String value) {
            addCriterion("FAILURECODE like", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeNotLike(String value) {
            addCriterion("FAILURECODE not like", value, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeIn(List<String> values) {
            addCriterion("FAILURECODE in", values, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeNotIn(List<String> values) {
            addCriterion("FAILURECODE not in", values, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeBetween(String value1, String value2) {
            addCriterion("FAILURECODE between", value1, value2, "failurecode");
            return (Criteria) this;
        }

        public Criteria andFailurecodeNotBetween(String value1, String value2) {
            addCriterion("FAILURECODE not between", value1, value2, "failurecode");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNull() {
            addCriterion("MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andManufacturerIsNotNull() {
            addCriterion("MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturerEqualTo(String value) {
            addCriterion("MANUFACTURER =", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotEqualTo(String value) {
            addCriterion("MANUFACTURER <>", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThan(String value) {
            addCriterion("MANUFACTURER >", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER >=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThan(String value) {
            addCriterion("MANUFACTURER <", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLessThanOrEqualTo(String value) {
            addCriterion("MANUFACTURER <=", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerLike(String value) {
            addCriterion("MANUFACTURER like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotLike(String value) {
            addCriterion("MANUFACTURER not like", value, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerIn(List<String> values) {
            addCriterion("MANUFACTURER in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotIn(List<String> values) {
            addCriterion("MANUFACTURER not in", values, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerBetween(String value1, String value2) {
            addCriterion("MANUFACTURER between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andManufacturerNotBetween(String value1, String value2) {
            addCriterion("MANUFACTURER not between", value1, value2, "manufacturer");
            return (Criteria) this;
        }

        public Criteria andPurpriceIsNull() {
            addCriterion("PURPRICE is null");
            return (Criteria) this;
        }

        public Criteria andPurpriceIsNotNull() {
            addCriterion("PURPRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPurpriceEqualTo(Double value) {
            addCriterion("PURPRICE =", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceNotEqualTo(Double value) {
            addCriterion("PURPRICE <>", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceGreaterThan(Double value) {
            addCriterion("PURPRICE >", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceGreaterThanOrEqualTo(Double value) {
            addCriterion("PURPRICE >=", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceLessThan(Double value) {
            addCriterion("PURPRICE <", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceLessThanOrEqualTo(Double value) {
            addCriterion("PURPRICE <=", value, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceIn(List<Double> values) {
            addCriterion("PURPRICE in", values, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceNotIn(List<Double> values) {
            addCriterion("PURPRICE not in", values, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceBetween(Double value1, Double value2) {
            addCriterion("PURPRICE between", value1, value2, "purprice");
            return (Criteria) this;
        }

        public Criteria andPurpriceNotBetween(Double value1, Double value2) {
            addCriterion("PURPRICE not between", value1, value2, "purprice");
            return (Criteria) this;
        }

        public Criteria andInstalldateIsNull() {
            addCriterion("INSTALLDATE is null");
            return (Criteria) this;
        }

        public Criteria andInstalldateIsNotNull() {
            addCriterion("INSTALLDATE is not null");
            return (Criteria) this;
        }

        public Criteria andInstalldateEqualTo(Date value) {
            addCriterion("INSTALLDATE =", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateNotEqualTo(Date value) {
            addCriterion("INSTALLDATE <>", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateGreaterThan(Date value) {
            addCriterion("INSTALLDATE >", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateGreaterThanOrEqualTo(Date value) {
            addCriterion("INSTALLDATE >=", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateLessThan(Date value) {
            addCriterion("INSTALLDATE <", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateLessThanOrEqualTo(Date value) {
            addCriterion("INSTALLDATE <=", value, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateIn(List<Date> values) {
            addCriterion("INSTALLDATE in", values, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateNotIn(List<Date> values) {
            addCriterion("INSTALLDATE not in", values, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateBetween(Date value1, Date value2) {
            addCriterion("INSTALLDATE between", value1, value2, "installdate");
            return (Criteria) this;
        }

        public Criteria andInstalldateNotBetween(Date value1, Date value2) {
            addCriterion("INSTALLDATE not between", value1, value2, "installdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateIsNull() {
            addCriterion("WARRANTYEXPDATE is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateIsNotNull() {
            addCriterion("WARRANTYEXPDATE is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateEqualTo(Date value) {
            addCriterion("WARRANTYEXPDATE =", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateNotEqualTo(Date value) {
            addCriterion("WARRANTYEXPDATE <>", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateGreaterThan(Date value) {
            addCriterion("WARRANTYEXPDATE >", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateGreaterThanOrEqualTo(Date value) {
            addCriterion("WARRANTYEXPDATE >=", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateLessThan(Date value) {
            addCriterion("WARRANTYEXPDATE <", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateLessThanOrEqualTo(Date value) {
            addCriterion("WARRANTYEXPDATE <=", value, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateIn(List<Date> values) {
            addCriterion("WARRANTYEXPDATE in", values, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateNotIn(List<Date> values) {
            addCriterion("WARRANTYEXPDATE not in", values, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateBetween(Date value1, Date value2) {
            addCriterion("WARRANTYEXPDATE between", value1, value2, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andWarrantyexpdateNotBetween(Date value1, Date value2) {
            addCriterion("WARRANTYEXPDATE not between", value1, value2, "warrantyexpdate");
            return (Criteria) this;
        }

        public Criteria andTotalcostIsNull() {
            addCriterion("TOTALCOST is null");
            return (Criteria) this;
        }

        public Criteria andTotalcostIsNotNull() {
            addCriterion("TOTALCOST is not null");
            return (Criteria) this;
        }

        public Criteria andTotalcostEqualTo(Double value) {
            addCriterion("TOTALCOST =", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostNotEqualTo(Double value) {
            addCriterion("TOTALCOST <>", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostGreaterThan(Double value) {
            addCriterion("TOTALCOST >", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostGreaterThanOrEqualTo(Double value) {
            addCriterion("TOTALCOST >=", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostLessThan(Double value) {
            addCriterion("TOTALCOST <", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostLessThanOrEqualTo(Double value) {
            addCriterion("TOTALCOST <=", value, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostIn(List<Double> values) {
            addCriterion("TOTALCOST in", values, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostNotIn(List<Double> values) {
            addCriterion("TOTALCOST not in", values, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostBetween(Double value1, Double value2) {
            addCriterion("TOTALCOST between", value1, value2, "totalcost");
            return (Criteria) this;
        }

        public Criteria andTotalcostNotBetween(Double value1, Double value2) {
            addCriterion("TOTALCOST not between", value1, value2, "totalcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostIsNull() {
            addCriterion("YTDCOST is null");
            return (Criteria) this;
        }

        public Criteria andYtdcostIsNotNull() {
            addCriterion("YTDCOST is not null");
            return (Criteria) this;
        }

        public Criteria andYtdcostEqualTo(Double value) {
            addCriterion("YTDCOST =", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostNotEqualTo(Double value) {
            addCriterion("YTDCOST <>", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostGreaterThan(Double value) {
            addCriterion("YTDCOST >", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostGreaterThanOrEqualTo(Double value) {
            addCriterion("YTDCOST >=", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostLessThan(Double value) {
            addCriterion("YTDCOST <", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostLessThanOrEqualTo(Double value) {
            addCriterion("YTDCOST <=", value, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostIn(List<Double> values) {
            addCriterion("YTDCOST in", values, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostNotIn(List<Double> values) {
            addCriterion("YTDCOST not in", values, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostBetween(Double value1, Double value2) {
            addCriterion("YTDCOST between", value1, value2, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andYtdcostNotBetween(Double value1, Double value2) {
            addCriterion("YTDCOST not between", value1, value2, "ytdcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostIsNull() {
            addCriterion("BUDGETCOST is null");
            return (Criteria) this;
        }

        public Criteria andBudgetcostIsNotNull() {
            addCriterion("BUDGETCOST is not null");
            return (Criteria) this;
        }

        public Criteria andBudgetcostEqualTo(Double value) {
            addCriterion("BUDGETCOST =", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostNotEqualTo(Double value) {
            addCriterion("BUDGETCOST <>", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostGreaterThan(Double value) {
            addCriterion("BUDGETCOST >", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostGreaterThanOrEqualTo(Double value) {
            addCriterion("BUDGETCOST >=", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostLessThan(Double value) {
            addCriterion("BUDGETCOST <", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostLessThanOrEqualTo(Double value) {
            addCriterion("BUDGETCOST <=", value, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostIn(List<Double> values) {
            addCriterion("BUDGETCOST in", values, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostNotIn(List<Double> values) {
            addCriterion("BUDGETCOST not in", values, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostBetween(Double value1, Double value2) {
            addCriterion("BUDGETCOST between", value1, value2, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andBudgetcostNotBetween(Double value1, Double value2) {
            addCriterion("BUDGETCOST not between", value1, value2, "budgetcost");
            return (Criteria) this;
        }

        public Criteria andClassidIsNull() {
            addCriterion("CLASSID is null");
            return (Criteria) this;
        }

        public Criteria andClassidIsNotNull() {
            addCriterion("CLASSID is not null");
            return (Criteria) this;
        }

        public Criteria andClassidEqualTo(String value) {
            addCriterion("CLASSID =", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotEqualTo(String value) {
            addCriterion("CLASSID <>", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidGreaterThan(String value) {
            addCriterion("CLASSID >", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidGreaterThanOrEqualTo(String value) {
            addCriterion("CLASSID >=", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidLessThan(String value) {
            addCriterion("CLASSID <", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidLessThanOrEqualTo(String value) {
            addCriterion("CLASSID <=", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidLike(String value) {
            addCriterion("CLASSID like", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotLike(String value) {
            addCriterion("CLASSID not like", value, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidIn(List<String> values) {
            addCriterion("CLASSID in", values, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotIn(List<String> values) {
            addCriterion("CLASSID not in", values, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidBetween(String value1, String value2) {
            addCriterion("CLASSID between", value1, value2, "classid");
            return (Criteria) this;
        }

        public Criteria andClassidNotBetween(String value1, String value2) {
            addCriterion("CLASSID not between", value1, value2, "classid");
            return (Criteria) this;
        }

        public Criteria andIsrunningIsNull() {
            addCriterion("ISRUNNING is null");
            return (Criteria) this;
        }

        public Criteria andIsrunningIsNotNull() {
            addCriterion("ISRUNNING is not null");
            return (Criteria) this;
        }

        public Criteria andIsrunningEqualTo(String value) {
            addCriterion("ISRUNNING =", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningNotEqualTo(String value) {
            addCriterion("ISRUNNING <>", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningGreaterThan(String value) {
            addCriterion("ISRUNNING >", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningGreaterThanOrEqualTo(String value) {
            addCriterion("ISRUNNING >=", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningLessThan(String value) {
            addCriterion("ISRUNNING <", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningLessThanOrEqualTo(String value) {
            addCriterion("ISRUNNING <=", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningLike(String value) {
            addCriterion("ISRUNNING like", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningNotLike(String value) {
            addCriterion("ISRUNNING not like", value, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningIn(List<String> values) {
            addCriterion("ISRUNNING in", values, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningNotIn(List<String> values) {
            addCriterion("ISRUNNING not in", values, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningBetween(String value1, String value2) {
            addCriterion("ISRUNNING between", value1, value2, "isrunning");
            return (Criteria) this;
        }

        public Criteria andIsrunningNotBetween(String value1, String value2) {
            addCriterion("ISRUNNING not between", value1, value2, "isrunning");
            return (Criteria) this;
        }

        public Criteria andItemnumIsNull() {
            addCriterion("ITEMNUM is null");
            return (Criteria) this;
        }

        public Criteria andItemnumIsNotNull() {
            addCriterion("ITEMNUM is not null");
            return (Criteria) this;
        }

        public Criteria andItemnumEqualTo(String value) {
            addCriterion("ITEMNUM =", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumNotEqualTo(String value) {
            addCriterion("ITEMNUM <>", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumGreaterThan(String value) {
            addCriterion("ITEMNUM >", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumGreaterThanOrEqualTo(String value) {
            addCriterion("ITEMNUM >=", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumLessThan(String value) {
            addCriterion("ITEMNUM <", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumLessThanOrEqualTo(String value) {
            addCriterion("ITEMNUM <=", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumLike(String value) {
            addCriterion("ITEMNUM like", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumNotLike(String value) {
            addCriterion("ITEMNUM not like", value, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumIn(List<String> values) {
            addCriterion("ITEMNUM in", values, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumNotIn(List<String> values) {
            addCriterion("ITEMNUM not in", values, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumBetween(String value1, String value2) {
            addCriterion("ITEMNUM between", value1, value2, "itemnum");
            return (Criteria) this;
        }

        public Criteria andItemnumNotBetween(String value1, String value2) {
            addCriterion("ITEMNUM not between", value1, value2, "itemnum");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeIsNull() {
            addCriterion("TOTDOWNTIME is null");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeIsNotNull() {
            addCriterion("TOTDOWNTIME is not null");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeEqualTo(Double value) {
            addCriterion("TOTDOWNTIME =", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeNotEqualTo(Double value) {
            addCriterion("TOTDOWNTIME <>", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeGreaterThan(Double value) {
            addCriterion("TOTDOWNTIME >", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeGreaterThanOrEqualTo(Double value) {
            addCriterion("TOTDOWNTIME >=", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeLessThan(Double value) {
            addCriterion("TOTDOWNTIME <", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeLessThanOrEqualTo(Double value) {
            addCriterion("TOTDOWNTIME <=", value, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeIn(List<Double> values) {
            addCriterion("TOTDOWNTIME in", values, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeNotIn(List<Double> values) {
            addCriterion("TOTDOWNTIME not in", values, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeBetween(Double value1, Double value2) {
            addCriterion("TOTDOWNTIME between", value1, value2, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andTotdowntimeNotBetween(Double value1, Double value2) {
            addCriterion("TOTDOWNTIME not between", value1, value2, "totdowntime");
            return (Criteria) this;
        }

        public Criteria andLfdateIsNull() {
            addCriterion("LFDATE is null");
            return (Criteria) this;
        }

        public Criteria andLfdateIsNotNull() {
            addCriterion("LFDATE is not null");
            return (Criteria) this;
        }

        public Criteria andLfdateEqualTo(Date value) {
            addCriterion("LFDATE =", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateNotEqualTo(Date value) {
            addCriterion("LFDATE <>", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateGreaterThan(Date value) {
            addCriterion("LFDATE >", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateGreaterThanOrEqualTo(Date value) {
            addCriterion("LFDATE >=", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateLessThan(Date value) {
            addCriterion("LFDATE <", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateLessThanOrEqualTo(Date value) {
            addCriterion("LFDATE <=", value, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateIn(List<Date> values) {
            addCriterion("LFDATE in", values, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateNotIn(List<Date> values) {
            addCriterion("LFDATE not in", values, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateBetween(Date value1, Date value2) {
            addCriterion("LFDATE between", value1, value2, "lfdate");
            return (Criteria) this;
        }

        public Criteria andLfdateNotBetween(Date value1, Date value2) {
            addCriterion("LFDATE not between", value1, value2, "lfdate");
            return (Criteria) this;
        }

        public Criteria andGradeIsNull() {
            addCriterion("GRADE is null");
            return (Criteria) this;
        }

        public Criteria andGradeIsNotNull() {
            addCriterion("GRADE is not null");
            return (Criteria) this;
        }

        public Criteria andGradeEqualTo(String value) {
            addCriterion("GRADE =", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotEqualTo(String value) {
            addCriterion("GRADE <>", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThan(String value) {
            addCriterion("GRADE >", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThanOrEqualTo(String value) {
            addCriterion("GRADE >=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThan(String value) {
            addCriterion("GRADE <", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThanOrEqualTo(String value) {
            addCriterion("GRADE <=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLike(String value) {
            addCriterion("GRADE like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotLike(String value) {
            addCriterion("GRADE not like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeIn(List<String> values) {
            addCriterion("GRADE in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotIn(List<String> values) {
            addCriterion("GRADE not in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeBetween(String value1, String value2) {
            addCriterion("GRADE between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotBetween(String value1, String value2) {
            addCriterion("GRADE not between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andChangedateIsNull() {
            addCriterion("CHANGEDATE is null");
            return (Criteria) this;
        }

        public Criteria andChangedateIsNotNull() {
            addCriterion("CHANGEDATE is not null");
            return (Criteria) this;
        }

        public Criteria andChangedateEqualTo(Date value) {
            addCriterion("CHANGEDATE =", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateNotEqualTo(Date value) {
            addCriterion("CHANGEDATE <>", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateGreaterThan(Date value) {
            addCriterion("CHANGEDATE >", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateGreaterThanOrEqualTo(Date value) {
            addCriterion("CHANGEDATE >=", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateLessThan(Date value) {
            addCriterion("CHANGEDATE <", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateLessThanOrEqualTo(Date value) {
            addCriterion("CHANGEDATE <=", value, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateIn(List<Date> values) {
            addCriterion("CHANGEDATE in", values, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateNotIn(List<Date> values) {
            addCriterion("CHANGEDATE not in", values, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateBetween(Date value1, Date value2) {
            addCriterion("CHANGEDATE between", value1, value2, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangedateNotBetween(Date value1, Date value2) {
            addCriterion("CHANGEDATE not between", value1, value2, "changedate");
            return (Criteria) this;
        }

        public Criteria andChangebyIsNull() {
            addCriterion("CHANGEBY is null");
            return (Criteria) this;
        }

        public Criteria andChangebyIsNotNull() {
            addCriterion("CHANGEBY is not null");
            return (Criteria) this;
        }

        public Criteria andChangebyEqualTo(String value) {
            addCriterion("CHANGEBY =", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyNotEqualTo(String value) {
            addCriterion("CHANGEBY <>", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyGreaterThan(String value) {
            addCriterion("CHANGEBY >", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyGreaterThanOrEqualTo(String value) {
            addCriterion("CHANGEBY >=", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyLessThan(String value) {
            addCriterion("CHANGEBY <", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyLessThanOrEqualTo(String value) {
            addCriterion("CHANGEBY <=", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyLike(String value) {
            addCriterion("CHANGEBY like", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyNotLike(String value) {
            addCriterion("CHANGEBY not like", value, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyIn(List<String> values) {
            addCriterion("CHANGEBY in", values, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyNotIn(List<String> values) {
            addCriterion("CHANGEBY not in", values, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyBetween(String value1, String value2) {
            addCriterion("CHANGEBY between", value1, value2, "changeby");
            return (Criteria) this;
        }

        public Criteria andChangebyNotBetween(String value1, String value2) {
            addCriterion("CHANGEBY not between", value1, value2, "changeby");
            return (Criteria) this;
        }

        public Criteria andRundateIsNull() {
            addCriterion("RUNDATE is null");
            return (Criteria) this;
        }

        public Criteria andRundateIsNotNull() {
            addCriterion("RUNDATE is not null");
            return (Criteria) this;
        }

        public Criteria andRundateEqualTo(Date value) {
            addCriterion("RUNDATE =", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateNotEqualTo(Date value) {
            addCriterion("RUNDATE <>", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateGreaterThan(Date value) {
            addCriterion("RUNDATE >", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateGreaterThanOrEqualTo(Date value) {
            addCriterion("RUNDATE >=", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateLessThan(Date value) {
            addCriterion("RUNDATE <", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateLessThanOrEqualTo(Date value) {
            addCriterion("RUNDATE <=", value, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateIn(List<Date> values) {
            addCriterion("RUNDATE in", values, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateNotIn(List<Date> values) {
            addCriterion("RUNDATE not in", values, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateBetween(Date value1, Date value2) {
            addCriterion("RUNDATE between", value1, value2, "rundate");
            return (Criteria) this;
        }

        public Criteria andRundateNotBetween(Date value1, Date value2) {
            addCriterion("RUNDATE not between", value1, value2, "rundate");
            return (Criteria) this;
        }

        public Criteria andRunnumberIsNull() {
            addCriterion("RUNNUMBER is null");
            return (Criteria) this;
        }

        public Criteria andRunnumberIsNotNull() {
            addCriterion("RUNNUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andRunnumberEqualTo(String value) {
            addCriterion("RUNNUMBER =", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberNotEqualTo(String value) {
            addCriterion("RUNNUMBER <>", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberGreaterThan(String value) {
            addCriterion("RUNNUMBER >", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberGreaterThanOrEqualTo(String value) {
            addCriterion("RUNNUMBER >=", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberLessThan(String value) {
            addCriterion("RUNNUMBER <", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberLessThanOrEqualTo(String value) {
            addCriterion("RUNNUMBER <=", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberLike(String value) {
            addCriterion("RUNNUMBER like", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberNotLike(String value) {
            addCriterion("RUNNUMBER not like", value, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberIn(List<String> values) {
            addCriterion("RUNNUMBER in", values, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberNotIn(List<String> values) {
            addCriterion("RUNNUMBER not in", values, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberBetween(String value1, String value2) {
            addCriterion("RUNNUMBER between", value1, value2, "runnumber");
            return (Criteria) this;
        }

        public Criteria andRunnumberNotBetween(String value1, String value2) {
            addCriterion("RUNNUMBER not between", value1, value2, "runnumber");
            return (Criteria) this;
        }

        public Criteria andPriorityIsNull() {
            addCriterion("PRIORITY is null");
            return (Criteria) this;
        }

        public Criteria andPriorityIsNotNull() {
            addCriterion("PRIORITY is not null");
            return (Criteria) this;
        }

        public Criteria andPriorityEqualTo(Double value) {
            addCriterion("PRIORITY =", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityNotEqualTo(Double value) {
            addCriterion("PRIORITY <>", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityGreaterThan(Double value) {
            addCriterion("PRIORITY >", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityGreaterThanOrEqualTo(Double value) {
            addCriterion("PRIORITY >=", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityLessThan(Double value) {
            addCriterion("PRIORITY <", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityLessThanOrEqualTo(Double value) {
            addCriterion("PRIORITY <=", value, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityIn(List<Double> values) {
            addCriterion("PRIORITY in", values, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityNotIn(List<Double> values) {
            addCriterion("PRIORITY not in", values, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityBetween(Double value1, Double value2) {
            addCriterion("PRIORITY between", value1, value2, "priority");
            return (Criteria) this;
        }

        public Criteria andPriorityNotBetween(Double value1, Double value2) {
            addCriterion("PRIORITY not between", value1, value2, "priority");
            return (Criteria) this;
        }

        public Criteria andInvcostIsNull() {
            addCriterion("INVCOST is null");
            return (Criteria) this;
        }

        public Criteria andInvcostIsNotNull() {
            addCriterion("INVCOST is not null");
            return (Criteria) this;
        }

        public Criteria andInvcostEqualTo(Double value) {
            addCriterion("INVCOST =", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostNotEqualTo(Double value) {
            addCriterion("INVCOST <>", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostGreaterThan(Double value) {
            addCriterion("INVCOST >", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostGreaterThanOrEqualTo(Double value) {
            addCriterion("INVCOST >=", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostLessThan(Double value) {
            addCriterion("INVCOST <", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostLessThanOrEqualTo(Double value) {
            addCriterion("INVCOST <=", value, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostIn(List<Double> values) {
            addCriterion("INVCOST in", values, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostNotIn(List<Double> values) {
            addCriterion("INVCOST not in", values, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostBetween(Double value1, Double value2) {
            addCriterion("INVCOST between", value1, value2, "invcost");
            return (Criteria) this;
        }

        public Criteria andInvcostNotBetween(Double value1, Double value2) {
            addCriterion("INVCOST not between", value1, value2, "invcost");
            return (Criteria) this;
        }

        public Criteria andConstructIsNull() {
            addCriterion("CONSTRUCT is null");
            return (Criteria) this;
        }

        public Criteria andConstructIsNotNull() {
            addCriterion("CONSTRUCT is not null");
            return (Criteria) this;
        }

        public Criteria andConstructEqualTo(String value) {
            addCriterion("CONSTRUCT =", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructNotEqualTo(String value) {
            addCriterion("CONSTRUCT <>", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructGreaterThan(String value) {
            addCriterion("CONSTRUCT >", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructGreaterThanOrEqualTo(String value) {
            addCriterion("CONSTRUCT >=", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructLessThan(String value) {
            addCriterion("CONSTRUCT <", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructLessThanOrEqualTo(String value) {
            addCriterion("CONSTRUCT <=", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructLike(String value) {
            addCriterion("CONSTRUCT like", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructNotLike(String value) {
            addCriterion("CONSTRUCT not like", value, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructIn(List<String> values) {
            addCriterion("CONSTRUCT in", values, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructNotIn(List<String> values) {
            addCriterion("CONSTRUCT not in", values, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructBetween(String value1, String value2) {
            addCriterion("CONSTRUCT between", value1, value2, "construct");
            return (Criteria) this;
        }

        public Criteria andConstructNotBetween(String value1, String value2) {
            addCriterion("CONSTRUCT not between", value1, value2, "construct");
            return (Criteria) this;
        }

        public Criteria andModelIsNull() {
            addCriterion("MODEL is null");
            return (Criteria) this;
        }

        public Criteria andModelIsNotNull() {
            addCriterion("MODEL is not null");
            return (Criteria) this;
        }

        public Criteria andModelEqualTo(String value) {
            addCriterion("MODEL =", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotEqualTo(String value) {
            addCriterion("MODEL <>", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelGreaterThan(String value) {
            addCriterion("MODEL >", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelGreaterThanOrEqualTo(String value) {
            addCriterion("MODEL >=", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLessThan(String value) {
            addCriterion("MODEL <", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLessThanOrEqualTo(String value) {
            addCriterion("MODEL <=", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelLike(String value) {
            addCriterion("MODEL like", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotLike(String value) {
            addCriterion("MODEL not like", value, "model");
            return (Criteria) this;
        }

        public Criteria andModelIn(List<String> values) {
            addCriterion("MODEL in", values, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotIn(List<String> values) {
            addCriterion("MODEL not in", values, "model");
            return (Criteria) this;
        }

        public Criteria andModelBetween(String value1, String value2) {
            addCriterion("MODEL between", value1, value2, "model");
            return (Criteria) this;
        }

        public Criteria andModelNotBetween(String value1, String value2) {
            addCriterion("MODEL not between", value1, value2, "model");
            return (Criteria) this;
        }

        public Criteria andLfnumberIsNull() {
            addCriterion("LFNUMBER is null");
            return (Criteria) this;
        }

        public Criteria andLfnumberIsNotNull() {
            addCriterion("LFNUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andLfnumberEqualTo(String value) {
            addCriterion("LFNUMBER =", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberNotEqualTo(String value) {
            addCriterion("LFNUMBER <>", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberGreaterThan(String value) {
            addCriterion("LFNUMBER >", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberGreaterThanOrEqualTo(String value) {
            addCriterion("LFNUMBER >=", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberLessThan(String value) {
            addCriterion("LFNUMBER <", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberLessThanOrEqualTo(String value) {
            addCriterion("LFNUMBER <=", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberLike(String value) {
            addCriterion("LFNUMBER like", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberNotLike(String value) {
            addCriterion("LFNUMBER not like", value, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberIn(List<String> values) {
            addCriterion("LFNUMBER in", values, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberNotIn(List<String> values) {
            addCriterion("LFNUMBER not in", values, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberBetween(String value1, String value2) {
            addCriterion("LFNUMBER between", value1, value2, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andLfnumberNotBetween(String value1, String value2) {
            addCriterion("LFNUMBER not between", value1, value2, "lfnumber");
            return (Criteria) this;
        }

        public Criteria andDeptnumIsNull() {
            addCriterion("DEPTNUM is null");
            return (Criteria) this;
        }

        public Criteria andDeptnumIsNotNull() {
            addCriterion("DEPTNUM is not null");
            return (Criteria) this;
        }

        public Criteria andDeptnumEqualTo(String value) {
            addCriterion("DEPTNUM =", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumNotEqualTo(String value) {
            addCriterion("DEPTNUM <>", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumGreaterThan(String value) {
            addCriterion("DEPTNUM >", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumGreaterThanOrEqualTo(String value) {
            addCriterion("DEPTNUM >=", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumLessThan(String value) {
            addCriterion("DEPTNUM <", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumLessThanOrEqualTo(String value) {
            addCriterion("DEPTNUM <=", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumLike(String value) {
            addCriterion("DEPTNUM like", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumNotLike(String value) {
            addCriterion("DEPTNUM not like", value, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumIn(List<String> values) {
            addCriterion("DEPTNUM in", values, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumNotIn(List<String> values) {
            addCriterion("DEPTNUM not in", values, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumBetween(String value1, String value2) {
            addCriterion("DEPTNUM between", value1, value2, "deptnum");
            return (Criteria) this;
        }

        public Criteria andDeptnumNotBetween(String value1, String value2) {
            addCriterion("DEPTNUM not between", value1, value2, "deptnum");
            return (Criteria) this;
        }

        public Criteria andBinnumIsNull() {
            addCriterion("BINNUM is null");
            return (Criteria) this;
        }

        public Criteria andBinnumIsNotNull() {
            addCriterion("BINNUM is not null");
            return (Criteria) this;
        }

        public Criteria andBinnumEqualTo(String value) {
            addCriterion("BINNUM =", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumNotEqualTo(String value) {
            addCriterion("BINNUM <>", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumGreaterThan(String value) {
            addCriterion("BINNUM >", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumGreaterThanOrEqualTo(String value) {
            addCriterion("BINNUM >=", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumLessThan(String value) {
            addCriterion("BINNUM <", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumLessThanOrEqualTo(String value) {
            addCriterion("BINNUM <=", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumLike(String value) {
            addCriterion("BINNUM like", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumNotLike(String value) {
            addCriterion("BINNUM not like", value, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumIn(List<String> values) {
            addCriterion("BINNUM in", values, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumNotIn(List<String> values) {
            addCriterion("BINNUM not in", values, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumBetween(String value1, String value2) {
            addCriterion("BINNUM between", value1, value2, "binnum");
            return (Criteria) this;
        }

        public Criteria andBinnumNotBetween(String value1, String value2) {
            addCriterion("BINNUM not between", value1, value2, "binnum");
            return (Criteria) this;
        }

        public Criteria andLfserialIsNull() {
            addCriterion("LFSERIAL is null");
            return (Criteria) this;
        }

        public Criteria andLfserialIsNotNull() {
            addCriterion("LFSERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andLfserialEqualTo(String value) {
            addCriterion("LFSERIAL =", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialNotEqualTo(String value) {
            addCriterion("LFSERIAL <>", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialGreaterThan(String value) {
            addCriterion("LFSERIAL >", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialGreaterThanOrEqualTo(String value) {
            addCriterion("LFSERIAL >=", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialLessThan(String value) {
            addCriterion("LFSERIAL <", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialLessThanOrEqualTo(String value) {
            addCriterion("LFSERIAL <=", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialLike(String value) {
            addCriterion("LFSERIAL like", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialNotLike(String value) {
            addCriterion("LFSERIAL not like", value, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialIn(List<String> values) {
            addCriterion("LFSERIAL in", values, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialNotIn(List<String> values) {
            addCriterion("LFSERIAL not in", values, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialBetween(String value1, String value2) {
            addCriterion("LFSERIAL between", value1, value2, "lfserial");
            return (Criteria) this;
        }

        public Criteria andLfserialNotBetween(String value1, String value2) {
            addCriterion("LFSERIAL not between", value1, value2, "lfserial");
            return (Criteria) this;
        }

        public Criteria andStockcostIsNull() {
            addCriterion("STOCKCOST is null");
            return (Criteria) this;
        }

        public Criteria andStockcostIsNotNull() {
            addCriterion("STOCKCOST is not null");
            return (Criteria) this;
        }

        public Criteria andStockcostEqualTo(Double value) {
            addCriterion("STOCKCOST =", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostNotEqualTo(Double value) {
            addCriterion("STOCKCOST <>", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostGreaterThan(Double value) {
            addCriterion("STOCKCOST >", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostGreaterThanOrEqualTo(Double value) {
            addCriterion("STOCKCOST >=", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostLessThan(Double value) {
            addCriterion("STOCKCOST <", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostLessThanOrEqualTo(Double value) {
            addCriterion("STOCKCOST <=", value, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostIn(List<Double> values) {
            addCriterion("STOCKCOST in", values, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostNotIn(List<Double> values) {
            addCriterion("STOCKCOST not in", values, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostBetween(Double value1, Double value2) {
            addCriterion("STOCKCOST between", value1, value2, "stockcost");
            return (Criteria) this;
        }

        public Criteria andStockcostNotBetween(Double value1, Double value2) {
            addCriterion("STOCKCOST not between", value1, value2, "stockcost");
            return (Criteria) this;
        }

        public Criteria andSerialIsNull() {
            addCriterion("SERIAL is null");
            return (Criteria) this;
        }

        public Criteria andSerialIsNotNull() {
            addCriterion("SERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andSerialEqualTo(String value) {
            addCriterion("SERIAL =", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotEqualTo(String value) {
            addCriterion("SERIAL <>", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialGreaterThan(String value) {
            addCriterion("SERIAL >", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialGreaterThanOrEqualTo(String value) {
            addCriterion("SERIAL >=", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLessThan(String value) {
            addCriterion("SERIAL <", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLessThanOrEqualTo(String value) {
            addCriterion("SERIAL <=", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialLike(String value) {
            addCriterion("SERIAL like", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotLike(String value) {
            addCriterion("SERIAL not like", value, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialIn(List<String> values) {
            addCriterion("SERIAL in", values, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotIn(List<String> values) {
            addCriterion("SERIAL not in", values, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialBetween(String value1, String value2) {
            addCriterion("SERIAL between", value1, value2, "serial");
            return (Criteria) this;
        }

        public Criteria andSerialNotBetween(String value1, String value2) {
            addCriterion("SERIAL not between", value1, value2, "serial");
            return (Criteria) this;
        }

        public Criteria andLargetypeIsNull() {
            addCriterion("LARGETYPE is null");
            return (Criteria) this;
        }

        public Criteria andLargetypeIsNotNull() {
            addCriterion("LARGETYPE is not null");
            return (Criteria) this;
        }

        public Criteria andLargetypeEqualTo(String value) {
            addCriterion("LARGETYPE =", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeNotEqualTo(String value) {
            addCriterion("LARGETYPE <>", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeGreaterThan(String value) {
            addCriterion("LARGETYPE >", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeGreaterThanOrEqualTo(String value) {
            addCriterion("LARGETYPE >=", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeLessThan(String value) {
            addCriterion("LARGETYPE <", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeLessThanOrEqualTo(String value) {
            addCriterion("LARGETYPE <=", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeLike(String value) {
            addCriterion("LARGETYPE like", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeNotLike(String value) {
            addCriterion("LARGETYPE not like", value, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeIn(List<String> values) {
            addCriterion("LARGETYPE in", values, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeNotIn(List<String> values) {
            addCriterion("LARGETYPE not in", values, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeBetween(String value1, String value2) {
            addCriterion("LARGETYPE between", value1, value2, "largetype");
            return (Criteria) this;
        }

        public Criteria andLargetypeNotBetween(String value1, String value2) {
            addCriterion("LARGETYPE not between", value1, value2, "largetype");
            return (Criteria) this;
        }

        public Criteria andLabornumIsNull() {
            addCriterion("LABORNUM is null");
            return (Criteria) this;
        }

        public Criteria andLabornumIsNotNull() {
            addCriterion("LABORNUM is not null");
            return (Criteria) this;
        }

        public Criteria andLabornumEqualTo(String value) {
            addCriterion("LABORNUM =", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumNotEqualTo(String value) {
            addCriterion("LABORNUM <>", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumGreaterThan(String value) {
            addCriterion("LABORNUM >", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumGreaterThanOrEqualTo(String value) {
            addCriterion("LABORNUM >=", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumLessThan(String value) {
            addCriterion("LABORNUM <", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumLessThanOrEqualTo(String value) {
            addCriterion("LABORNUM <=", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumLike(String value) {
            addCriterion("LABORNUM like", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumNotLike(String value) {
            addCriterion("LABORNUM not like", value, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumIn(List<String> values) {
            addCriterion("LABORNUM in", values, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumNotIn(List<String> values) {
            addCriterion("LABORNUM not in", values, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumBetween(String value1, String value2) {
            addCriterion("LABORNUM between", value1, value2, "labornum");
            return (Criteria) this;
        }

        public Criteria andLabornumNotBetween(String value1, String value2) {
            addCriterion("LABORNUM not between", value1, value2, "labornum");
            return (Criteria) this;
        }

        public Criteria andPlanyearsIsNull() {
            addCriterion("PLANYEARS is null");
            return (Criteria) this;
        }

        public Criteria andPlanyearsIsNotNull() {
            addCriterion("PLANYEARS is not null");
            return (Criteria) this;
        }

        public Criteria andPlanyearsEqualTo(Double value) {
            addCriterion("PLANYEARS =", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsNotEqualTo(Double value) {
            addCriterion("PLANYEARS <>", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsGreaterThan(Double value) {
            addCriterion("PLANYEARS >", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsGreaterThanOrEqualTo(Double value) {
            addCriterion("PLANYEARS >=", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsLessThan(Double value) {
            addCriterion("PLANYEARS <", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsLessThanOrEqualTo(Double value) {
            addCriterion("PLANYEARS <=", value, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsIn(List<Double> values) {
            addCriterion("PLANYEARS in", values, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsNotIn(List<Double> values) {
            addCriterion("PLANYEARS not in", values, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsBetween(Double value1, Double value2) {
            addCriterion("PLANYEARS between", value1, value2, "planyears");
            return (Criteria) this;
        }

        public Criteria andPlanyearsNotBetween(Double value1, Double value2) {
            addCriterion("PLANYEARS not between", value1, value2, "planyears");
            return (Criteria) this;
        }

        public Criteria andAppertainIsNull() {
            addCriterion("APPERTAIN is null");
            return (Criteria) this;
        }

        public Criteria andAppertainIsNotNull() {
            addCriterion("APPERTAIN is not null");
            return (Criteria) this;
        }

        public Criteria andAppertainEqualTo(String value) {
            addCriterion("APPERTAIN =", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainNotEqualTo(String value) {
            addCriterion("APPERTAIN <>", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainGreaterThan(String value) {
            addCriterion("APPERTAIN >", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainGreaterThanOrEqualTo(String value) {
            addCriterion("APPERTAIN >=", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainLessThan(String value) {
            addCriterion("APPERTAIN <", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainLessThanOrEqualTo(String value) {
            addCriterion("APPERTAIN <=", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainLike(String value) {
            addCriterion("APPERTAIN like", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainNotLike(String value) {
            addCriterion("APPERTAIN not like", value, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainIn(List<String> values) {
            addCriterion("APPERTAIN in", values, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainNotIn(List<String> values) {
            addCriterion("APPERTAIN not in", values, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainBetween(String value1, String value2) {
            addCriterion("APPERTAIN between", value1, value2, "appertain");
            return (Criteria) this;
        }

        public Criteria andAppertainNotBetween(String value1, String value2) {
            addCriterion("APPERTAIN not between", value1, value2, "appertain");
            return (Criteria) this;
        }

        public Criteria andCntnumIsNull() {
            addCriterion("CNTNUM is null");
            return (Criteria) this;
        }

        public Criteria andCntnumIsNotNull() {
            addCriterion("CNTNUM is not null");
            return (Criteria) this;
        }

        public Criteria andCntnumEqualTo(String value) {
            addCriterion("CNTNUM =", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumNotEqualTo(String value) {
            addCriterion("CNTNUM <>", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumGreaterThan(String value) {
            addCriterion("CNTNUM >", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumGreaterThanOrEqualTo(String value) {
            addCriterion("CNTNUM >=", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumLessThan(String value) {
            addCriterion("CNTNUM <", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumLessThanOrEqualTo(String value) {
            addCriterion("CNTNUM <=", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumLike(String value) {
            addCriterion("CNTNUM like", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumNotLike(String value) {
            addCriterion("CNTNUM not like", value, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumIn(List<String> values) {
            addCriterion("CNTNUM in", values, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumNotIn(List<String> values) {
            addCriterion("CNTNUM not in", values, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumBetween(String value1, String value2) {
            addCriterion("CNTNUM between", value1, value2, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCntnumNotBetween(String value1, String value2) {
            addCriterion("CNTNUM not between", value1, value2, "cntnum");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("CURRENCY is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("CURRENCY is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("CURRENCY =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("CURRENCY <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("CURRENCY >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENCY >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("CURRENCY <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("CURRENCY <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("CURRENCY like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("CURRENCY not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("CURRENCY in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("CURRENCY not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("CURRENCY between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("CURRENCY not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andProjectIsNull() {
            addCriterion("PROJECT is null");
            return (Criteria) this;
        }

        public Criteria andProjectIsNotNull() {
            addCriterion("PROJECT is not null");
            return (Criteria) this;
        }

        public Criteria andProjectEqualTo(String value) {
            addCriterion("PROJECT =", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotEqualTo(String value) {
            addCriterion("PROJECT <>", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThan(String value) {
            addCriterion("PROJECT >", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectGreaterThanOrEqualTo(String value) {
            addCriterion("PROJECT >=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThan(String value) {
            addCriterion("PROJECT <", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLessThanOrEqualTo(String value) {
            addCriterion("PROJECT <=", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectLike(String value) {
            addCriterion("PROJECT like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotLike(String value) {
            addCriterion("PROJECT not like", value, "project");
            return (Criteria) this;
        }

        public Criteria andProjectIn(List<String> values) {
            addCriterion("PROJECT in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotIn(List<String> values) {
            addCriterion("PROJECT not in", values, "project");
            return (Criteria) this;
        }

        public Criteria andProjectBetween(String value1, String value2) {
            addCriterion("PROJECT between", value1, value2, "project");
            return (Criteria) this;
        }

        public Criteria andProjectNotBetween(String value1, String value2) {
            addCriterion("PROJECT not between", value1, value2, "project");
            return (Criteria) this;
        }

        public Criteria andRateIsNull() {
            addCriterion("RATE is null");
            return (Criteria) this;
        }

        public Criteria andRateIsNotNull() {
            addCriterion("RATE is not null");
            return (Criteria) this;
        }

        public Criteria andRateEqualTo(Double value) {
            addCriterion("RATE =", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotEqualTo(Double value) {
            addCriterion("RATE <>", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThan(Double value) {
            addCriterion("RATE >", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateGreaterThanOrEqualTo(Double value) {
            addCriterion("RATE >=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThan(Double value) {
            addCriterion("RATE <", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateLessThanOrEqualTo(Double value) {
            addCriterion("RATE <=", value, "rate");
            return (Criteria) this;
        }

        public Criteria andRateIn(List<Double> values) {
            addCriterion("RATE in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotIn(List<Double> values) {
            addCriterion("RATE not in", values, "rate");
            return (Criteria) this;
        }

        public Criteria andRateBetween(Double value1, Double value2) {
            addCriterion("RATE between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andRateNotBetween(Double value1, Double value2) {
            addCriterion("RATE not between", value1, value2, "rate");
            return (Criteria) this;
        }

        public Criteria andLotnumIsNull() {
            addCriterion("LOTNUM is null");
            return (Criteria) this;
        }

        public Criteria andLotnumIsNotNull() {
            addCriterion("LOTNUM is not null");
            return (Criteria) this;
        }

        public Criteria andLotnumEqualTo(String value) {
            addCriterion("LOTNUM =", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumNotEqualTo(String value) {
            addCriterion("LOTNUM <>", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumGreaterThan(String value) {
            addCriterion("LOTNUM >", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumGreaterThanOrEqualTo(String value) {
            addCriterion("LOTNUM >=", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumLessThan(String value) {
            addCriterion("LOTNUM <", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumLessThanOrEqualTo(String value) {
            addCriterion("LOTNUM <=", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumLike(String value) {
            addCriterion("LOTNUM like", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumNotLike(String value) {
            addCriterion("LOTNUM not like", value, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumIn(List<String> values) {
            addCriterion("LOTNUM in", values, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumNotIn(List<String> values) {
            addCriterion("LOTNUM not in", values, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumBetween(String value1, String value2) {
            addCriterion("LOTNUM between", value1, value2, "lotnum");
            return (Criteria) this;
        }

        public Criteria andLotnumNotBetween(String value1, String value2) {
            addCriterion("LOTNUM not between", value1, value2, "lotnum");
            return (Criteria) this;
        }

        public Criteria andCalnumIsNull() {
            addCriterion("CALNUM is null");
            return (Criteria) this;
        }

        public Criteria andCalnumIsNotNull() {
            addCriterion("CALNUM is not null");
            return (Criteria) this;
        }

        public Criteria andCalnumEqualTo(String value) {
            addCriterion("CALNUM =", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumNotEqualTo(String value) {
            addCriterion("CALNUM <>", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumGreaterThan(String value) {
            addCriterion("CALNUM >", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumGreaterThanOrEqualTo(String value) {
            addCriterion("CALNUM >=", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumLessThan(String value) {
            addCriterion("CALNUM <", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumLessThanOrEqualTo(String value) {
            addCriterion("CALNUM <=", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumLike(String value) {
            addCriterion("CALNUM like", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumNotLike(String value) {
            addCriterion("CALNUM not like", value, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumIn(List<String> values) {
            addCriterion("CALNUM in", values, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumNotIn(List<String> values) {
            addCriterion("CALNUM not in", values, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumBetween(String value1, String value2) {
            addCriterion("CALNUM between", value1, value2, "calnum");
            return (Criteria) this;
        }

        public Criteria andCalnumNotBetween(String value1, String value2) {
            addCriterion("CALNUM not between", value1, value2, "calnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumIsNull() {
            addCriterion("SHIFTNUM is null");
            return (Criteria) this;
        }

        public Criteria andShiftnumIsNotNull() {
            addCriterion("SHIFTNUM is not null");
            return (Criteria) this;
        }

        public Criteria andShiftnumEqualTo(String value) {
            addCriterion("SHIFTNUM =", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumNotEqualTo(String value) {
            addCriterion("SHIFTNUM <>", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumGreaterThan(String value) {
            addCriterion("SHIFTNUM >", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumGreaterThanOrEqualTo(String value) {
            addCriterion("SHIFTNUM >=", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumLessThan(String value) {
            addCriterion("SHIFTNUM <", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumLessThanOrEqualTo(String value) {
            addCriterion("SHIFTNUM <=", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumLike(String value) {
            addCriterion("SHIFTNUM like", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumNotLike(String value) {
            addCriterion("SHIFTNUM not like", value, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumIn(List<String> values) {
            addCriterion("SHIFTNUM in", values, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumNotIn(List<String> values) {
            addCriterion("SHIFTNUM not in", values, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumBetween(String value1, String value2) {
            addCriterion("SHIFTNUM between", value1, value2, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andShiftnumNotBetween(String value1, String value2) {
            addCriterion("SHIFTNUM not between", value1, value2, "shiftnum");
            return (Criteria) this;
        }

        public Criteria andSitenumIsNull() {
            addCriterion("SITENUM is null");
            return (Criteria) this;
        }

        public Criteria andSitenumIsNotNull() {
            addCriterion("SITENUM is not null");
            return (Criteria) this;
        }

        public Criteria andSitenumEqualTo(String value) {
            addCriterion("SITENUM =", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumNotEqualTo(String value) {
            addCriterion("SITENUM <>", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumGreaterThan(String value) {
            addCriterion("SITENUM >", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumGreaterThanOrEqualTo(String value) {
            addCriterion("SITENUM >=", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumLessThan(String value) {
            addCriterion("SITENUM <", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumLessThanOrEqualTo(String value) {
            addCriterion("SITENUM <=", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumLike(String value) {
            addCriterion("SITENUM like", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumNotLike(String value) {
            addCriterion("SITENUM not like", value, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumIn(List<String> values) {
            addCriterion("SITENUM in", values, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumNotIn(List<String> values) {
            addCriterion("SITENUM not in", values, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumBetween(String value1, String value2) {
            addCriterion("SITENUM between", value1, value2, "sitenum");
            return (Criteria) this;
        }

        public Criteria andSitenumNotBetween(String value1, String value2) {
            addCriterion("SITENUM not between", value1, value2, "sitenum");
            return (Criteria) this;
        }

        public Criteria andCorpnumIsNull() {
            addCriterion("CORPNUM is null");
            return (Criteria) this;
        }

        public Criteria andCorpnumIsNotNull() {
            addCriterion("CORPNUM is not null");
            return (Criteria) this;
        }

        public Criteria andCorpnumEqualTo(String value) {
            addCriterion("CORPNUM =", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumNotEqualTo(String value) {
            addCriterion("CORPNUM <>", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumGreaterThan(String value) {
            addCriterion("CORPNUM >", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumGreaterThanOrEqualTo(String value) {
            addCriterion("CORPNUM >=", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumLessThan(String value) {
            addCriterion("CORPNUM <", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumLessThanOrEqualTo(String value) {
            addCriterion("CORPNUM <=", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumLike(String value) {
            addCriterion("CORPNUM like", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumNotLike(String value) {
            addCriterion("CORPNUM not like", value, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumIn(List<String> values) {
            addCriterion("CORPNUM in", values, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumNotIn(List<String> values) {
            addCriterion("CORPNUM not in", values, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumBetween(String value1, String value2) {
            addCriterion("CORPNUM between", value1, value2, "corpnum");
            return (Criteria) this;
        }

        public Criteria andCorpnumNotBetween(String value1, String value2) {
            addCriterion("CORPNUM not between", value1, value2, "corpnum");
            return (Criteria) this;
        }

        public Criteria andChangereasonIsNull() {
            addCriterion("CHANGEREASON is null");
            return (Criteria) this;
        }

        public Criteria andChangereasonIsNotNull() {
            addCriterion("CHANGEREASON is not null");
            return (Criteria) this;
        }

        public Criteria andChangereasonEqualTo(String value) {
            addCriterion("CHANGEREASON =", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonNotEqualTo(String value) {
            addCriterion("CHANGEREASON <>", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonGreaterThan(String value) {
            addCriterion("CHANGEREASON >", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonGreaterThanOrEqualTo(String value) {
            addCriterion("CHANGEREASON >=", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonLessThan(String value) {
            addCriterion("CHANGEREASON <", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonLessThanOrEqualTo(String value) {
            addCriterion("CHANGEREASON <=", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonLike(String value) {
            addCriterion("CHANGEREASON like", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonNotLike(String value) {
            addCriterion("CHANGEREASON not like", value, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonIn(List<String> values) {
            addCriterion("CHANGEREASON in", values, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonNotIn(List<String> values) {
            addCriterion("CHANGEREASON not in", values, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonBetween(String value1, String value2) {
            addCriterion("CHANGEREASON between", value1, value2, "changereason");
            return (Criteria) this;
        }

        public Criteria andChangereasonNotBetween(String value1, String value2) {
            addCriterion("CHANGEREASON not between", value1, value2, "changereason");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table EQUIPMENT
     *
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table EQUIPMENT
     *
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}