package com.tianbo.model;

import com.tianbo.util.dao.Page;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TKpiCargoWaybillExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Page page;

    public TKpiCargoWaybillExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPage(Page page) {
        this.page=page;
    }

    public Page getPage() {
        return page;
    }

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

        public Criteria andFidIsNotNull() {
            addCriterion("FID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(BigDecimal value) {
            addCriterion("FID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(BigDecimal value) {
            addCriterion("FID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(BigDecimal value) {
            addCriterion("FID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(BigDecimal value) {
            addCriterion("FID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<BigDecimal> values) {
            addCriterion("FID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<BigDecimal> values) {
            addCriterion("FID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andWaybillidIsNull() {
            addCriterion("WAYBILLID is null");
            return (Criteria) this;
        }

        public Criteria andWaybillidIsNotNull() {
            addCriterion("WAYBILLID is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillidEqualTo(String value) {
            addCriterion("WAYBILLID =", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidNotEqualTo(String value) {
            addCriterion("WAYBILLID <>", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidGreaterThan(String value) {
            addCriterion("WAYBILLID >", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidGreaterThanOrEqualTo(String value) {
            addCriterion("WAYBILLID >=", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidLessThan(String value) {
            addCriterion("WAYBILLID <", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidLessThanOrEqualTo(String value) {
            addCriterion("WAYBILLID <=", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidLike(String value) {
            addCriterion("WAYBILLID like", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidNotLike(String value) {
            addCriterion("WAYBILLID not like", value, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidIn(List<String> values) {
            addCriterion("WAYBILLID in", values, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidNotIn(List<String> values) {
            addCriterion("WAYBILLID not in", values, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidBetween(String value1, String value2) {
            addCriterion("WAYBILLID between", value1, value2, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybillidNotBetween(String value1, String value2) {
            addCriterion("WAYBILLID not between", value1, value2, "waybillid");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeIsNull() {
            addCriterion("WAYBILLTYPE is null");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeIsNotNull() {
            addCriterion("WAYBILLTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeEqualTo(String value) {
            addCriterion("WAYBILLTYPE =", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeNotEqualTo(String value) {
            addCriterion("WAYBILLTYPE <>", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeGreaterThan(String value) {
            addCriterion("WAYBILLTYPE >", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeGreaterThanOrEqualTo(String value) {
            addCriterion("WAYBILLTYPE >=", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeLessThan(String value) {
            addCriterion("WAYBILLTYPE <", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeLessThanOrEqualTo(String value) {
            addCriterion("WAYBILLTYPE <=", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeLike(String value) {
            addCriterion("WAYBILLTYPE like", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeNotLike(String value) {
            addCriterion("WAYBILLTYPE not like", value, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeIn(List<String> values) {
            addCriterion("WAYBILLTYPE in", values, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeNotIn(List<String> values) {
            addCriterion("WAYBILLTYPE not in", values, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeBetween(String value1, String value2) {
            addCriterion("WAYBILLTYPE between", value1, value2, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybilltypeNotBetween(String value1, String value2) {
            addCriterion("WAYBILLTYPE not between", value1, value2, "waybilltype");
            return (Criteria) this;
        }

        public Criteria andWaybillpreIsNull() {
            addCriterion("WAYBILLPRE is null");
            return (Criteria) this;
        }

        public Criteria andWaybillpreIsNotNull() {
            addCriterion("WAYBILLPRE is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillpreEqualTo(String value) {
            addCriterion("WAYBILLPRE =", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreNotEqualTo(String value) {
            addCriterion("WAYBILLPRE <>", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreGreaterThan(String value) {
            addCriterion("WAYBILLPRE >", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreGreaterThanOrEqualTo(String value) {
            addCriterion("WAYBILLPRE >=", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreLessThan(String value) {
            addCriterion("WAYBILLPRE <", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreLessThanOrEqualTo(String value) {
            addCriterion("WAYBILLPRE <=", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreLike(String value) {
            addCriterion("WAYBILLPRE like", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreNotLike(String value) {
            addCriterion("WAYBILLPRE not like", value, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreIn(List<String> values) {
            addCriterion("WAYBILLPRE in", values, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreNotIn(List<String> values) {
            addCriterion("WAYBILLPRE not in", values, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreBetween(String value1, String value2) {
            addCriterion("WAYBILLPRE between", value1, value2, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillpreNotBetween(String value1, String value2) {
            addCriterion("WAYBILLPRE not between", value1, value2, "waybillpre");
            return (Criteria) this;
        }

        public Criteria andWaybillnoIsNull() {
            addCriterion("WAYBILLNO is null");
            return (Criteria) this;
        }

        public Criteria andWaybillnoIsNotNull() {
            addCriterion("WAYBILLNO is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillnoEqualTo(String value) {
            addCriterion("WAYBILLNO =", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoNotEqualTo(String value) {
            addCriterion("WAYBILLNO <>", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoGreaterThan(String value) {
            addCriterion("WAYBILLNO >", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoGreaterThanOrEqualTo(String value) {
            addCriterion("WAYBILLNO >=", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoLessThan(String value) {
            addCriterion("WAYBILLNO <", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoLessThanOrEqualTo(String value) {
            addCriterion("WAYBILLNO <=", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoLike(String value) {
            addCriterion("WAYBILLNO like", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoNotLike(String value) {
            addCriterion("WAYBILLNO not like", value, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoIn(List<String> values) {
            addCriterion("WAYBILLNO in", values, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoNotIn(List<String> values) {
            addCriterion("WAYBILLNO not in", values, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoBetween(String value1, String value2) {
            addCriterion("WAYBILLNO between", value1, value2, "waybillno");
            return (Criteria) this;
        }

        public Criteria andWaybillnoNotBetween(String value1, String value2) {
            addCriterion("WAYBILLNO not between", value1, value2, "waybillno");
            return (Criteria) this;
        }

        public Criteria andDomintIsNull() {
            addCriterion("DOMINT is null");
            return (Criteria) this;
        }

        public Criteria andDomintIsNotNull() {
            addCriterion("DOMINT is not null");
            return (Criteria) this;
        }

        public Criteria andDomintEqualTo(String value) {
            addCriterion("DOMINT =", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintNotEqualTo(String value) {
            addCriterion("DOMINT <>", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintGreaterThan(String value) {
            addCriterion("DOMINT >", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintGreaterThanOrEqualTo(String value) {
            addCriterion("DOMINT >=", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintLessThan(String value) {
            addCriterion("DOMINT <", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintLessThanOrEqualTo(String value) {
            addCriterion("DOMINT <=", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintLike(String value) {
            addCriterion("DOMINT like", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintNotLike(String value) {
            addCriterion("DOMINT not like", value, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintIn(List<String> values) {
            addCriterion("DOMINT in", values, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintNotIn(List<String> values) {
            addCriterion("DOMINT not in", values, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintBetween(String value1, String value2) {
            addCriterion("DOMINT between", value1, value2, "domint");
            return (Criteria) this;
        }

        public Criteria andDomintNotBetween(String value1, String value2) {
            addCriterion("DOMINT not between", value1, value2, "domint");
            return (Criteria) this;
        }

        public Criteria andSairportidIsNull() {
            addCriterion("SAIRPORTID is null");
            return (Criteria) this;
        }

        public Criteria andSairportidIsNotNull() {
            addCriterion("SAIRPORTID is not null");
            return (Criteria) this;
        }

        public Criteria andSairportidEqualTo(String value) {
            addCriterion("SAIRPORTID =", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidNotEqualTo(String value) {
            addCriterion("SAIRPORTID <>", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidGreaterThan(String value) {
            addCriterion("SAIRPORTID >", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidGreaterThanOrEqualTo(String value) {
            addCriterion("SAIRPORTID >=", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidLessThan(String value) {
            addCriterion("SAIRPORTID <", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidLessThanOrEqualTo(String value) {
            addCriterion("SAIRPORTID <=", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidLike(String value) {
            addCriterion("SAIRPORTID like", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidNotLike(String value) {
            addCriterion("SAIRPORTID not like", value, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidIn(List<String> values) {
            addCriterion("SAIRPORTID in", values, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidNotIn(List<String> values) {
            addCriterion("SAIRPORTID not in", values, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidBetween(String value1, String value2) {
            addCriterion("SAIRPORTID between", value1, value2, "sairportid");
            return (Criteria) this;
        }

        public Criteria andSairportidNotBetween(String value1, String value2) {
            addCriterion("SAIRPORTID not between", value1, value2, "sairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidIsNull() {
            addCriterion("EAIRPORTID is null");
            return (Criteria) this;
        }

        public Criteria andEairportidIsNotNull() {
            addCriterion("EAIRPORTID is not null");
            return (Criteria) this;
        }

        public Criteria andEairportidEqualTo(String value) {
            addCriterion("EAIRPORTID =", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidNotEqualTo(String value) {
            addCriterion("EAIRPORTID <>", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidGreaterThan(String value) {
            addCriterion("EAIRPORTID >", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidGreaterThanOrEqualTo(String value) {
            addCriterion("EAIRPORTID >=", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidLessThan(String value) {
            addCriterion("EAIRPORTID <", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidLessThanOrEqualTo(String value) {
            addCriterion("EAIRPORTID <=", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidLike(String value) {
            addCriterion("EAIRPORTID like", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidNotLike(String value) {
            addCriterion("EAIRPORTID not like", value, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidIn(List<String> values) {
            addCriterion("EAIRPORTID in", values, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidNotIn(List<String> values) {
            addCriterion("EAIRPORTID not in", values, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidBetween(String value1, String value2) {
            addCriterion("EAIRPORTID between", value1, value2, "eairportid");
            return (Criteria) this;
        }

        public Criteria andEairportidNotBetween(String value1, String value2) {
            addCriterion("EAIRPORTID not between", value1, value2, "eairportid");
            return (Criteria) this;
        }

        public Criteria andScityidIsNull() {
            addCriterion("SCITYID is null");
            return (Criteria) this;
        }

        public Criteria andScityidIsNotNull() {
            addCriterion("SCITYID is not null");
            return (Criteria) this;
        }

        public Criteria andScityidEqualTo(String value) {
            addCriterion("SCITYID =", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidNotEqualTo(String value) {
            addCriterion("SCITYID <>", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidGreaterThan(String value) {
            addCriterion("SCITYID >", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidGreaterThanOrEqualTo(String value) {
            addCriterion("SCITYID >=", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidLessThan(String value) {
            addCriterion("SCITYID <", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidLessThanOrEqualTo(String value) {
            addCriterion("SCITYID <=", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidLike(String value) {
            addCriterion("SCITYID like", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidNotLike(String value) {
            addCriterion("SCITYID not like", value, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidIn(List<String> values) {
            addCriterion("SCITYID in", values, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidNotIn(List<String> values) {
            addCriterion("SCITYID not in", values, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidBetween(String value1, String value2) {
            addCriterion("SCITYID between", value1, value2, "scityid");
            return (Criteria) this;
        }

        public Criteria andScityidNotBetween(String value1, String value2) {
            addCriterion("SCITYID not between", value1, value2, "scityid");
            return (Criteria) this;
        }

        public Criteria andEcityidIsNull() {
            addCriterion("ECITYID is null");
            return (Criteria) this;
        }

        public Criteria andEcityidIsNotNull() {
            addCriterion("ECITYID is not null");
            return (Criteria) this;
        }

        public Criteria andEcityidEqualTo(String value) {
            addCriterion("ECITYID =", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidNotEqualTo(String value) {
            addCriterion("ECITYID <>", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidGreaterThan(String value) {
            addCriterion("ECITYID >", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidGreaterThanOrEqualTo(String value) {
            addCriterion("ECITYID >=", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidLessThan(String value) {
            addCriterion("ECITYID <", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidLessThanOrEqualTo(String value) {
            addCriterion("ECITYID <=", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidLike(String value) {
            addCriterion("ECITYID like", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidNotLike(String value) {
            addCriterion("ECITYID not like", value, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidIn(List<String> values) {
            addCriterion("ECITYID in", values, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidNotIn(List<String> values) {
            addCriterion("ECITYID not in", values, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidBetween(String value1, String value2) {
            addCriterion("ECITYID between", value1, value2, "ecityid");
            return (Criteria) this;
        }

        public Criteria andEcityidNotBetween(String value1, String value2) {
            addCriterion("ECITYID not between", value1, value2, "ecityid");
            return (Criteria) this;
        }

        public Criteria andIstransIsNull() {
            addCriterion("ISTRANS is null");
            return (Criteria) this;
        }

        public Criteria andIstransIsNotNull() {
            addCriterion("ISTRANS is not null");
            return (Criteria) this;
        }

        public Criteria andIstransEqualTo(String value) {
            addCriterion("ISTRANS =", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransNotEqualTo(String value) {
            addCriterion("ISTRANS <>", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransGreaterThan(String value) {
            addCriterion("ISTRANS >", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransGreaterThanOrEqualTo(String value) {
            addCriterion("ISTRANS >=", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransLessThan(String value) {
            addCriterion("ISTRANS <", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransLessThanOrEqualTo(String value) {
            addCriterion("ISTRANS <=", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransLike(String value) {
            addCriterion("ISTRANS like", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransNotLike(String value) {
            addCriterion("ISTRANS not like", value, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransIn(List<String> values) {
            addCriterion("ISTRANS in", values, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransNotIn(List<String> values) {
            addCriterion("ISTRANS not in", values, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransBetween(String value1, String value2) {
            addCriterion("ISTRANS between", value1, value2, "istrans");
            return (Criteria) this;
        }

        public Criteria andIstransNotBetween(String value1, String value2) {
            addCriterion("ISTRANS not between", value1, value2, "istrans");
            return (Criteria) this;
        }

        public Criteria andCustomscodeIsNull() {
            addCriterion("CUSTOMSCODE is null");
            return (Criteria) this;
        }

        public Criteria andCustomscodeIsNotNull() {
            addCriterion("CUSTOMSCODE is not null");
            return (Criteria) this;
        }

        public Criteria andCustomscodeEqualTo(String value) {
            addCriterion("CUSTOMSCODE =", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeNotEqualTo(String value) {
            addCriterion("CUSTOMSCODE <>", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeGreaterThan(String value) {
            addCriterion("CUSTOMSCODE >", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMSCODE >=", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeLessThan(String value) {
            addCriterion("CUSTOMSCODE <", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMSCODE <=", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeLike(String value) {
            addCriterion("CUSTOMSCODE like", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeNotLike(String value) {
            addCriterion("CUSTOMSCODE not like", value, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeIn(List<String> values) {
            addCriterion("CUSTOMSCODE in", values, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeNotIn(List<String> values) {
            addCriterion("CUSTOMSCODE not in", values, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeBetween(String value1, String value2) {
            addCriterion("CUSTOMSCODE between", value1, value2, "customscode");
            return (Criteria) this;
        }

        public Criteria andCustomscodeNotBetween(String value1, String value2) {
            addCriterion("CUSTOMSCODE not between", value1, value2, "customscode");
            return (Criteria) this;
        }

        public Criteria andSpecoperidIsNull() {
            addCriterion("SPECOPERID is null");
            return (Criteria) this;
        }

        public Criteria andSpecoperidIsNotNull() {
            addCriterion("SPECOPERID is not null");
            return (Criteria) this;
        }

        public Criteria andSpecoperidEqualTo(String value) {
            addCriterion("SPECOPERID =", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidNotEqualTo(String value) {
            addCriterion("SPECOPERID <>", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidGreaterThan(String value) {
            addCriterion("SPECOPERID >", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidGreaterThanOrEqualTo(String value) {
            addCriterion("SPECOPERID >=", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidLessThan(String value) {
            addCriterion("SPECOPERID <", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidLessThanOrEqualTo(String value) {
            addCriterion("SPECOPERID <=", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidLike(String value) {
            addCriterion("SPECOPERID like", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidNotLike(String value) {
            addCriterion("SPECOPERID not like", value, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidIn(List<String> values) {
            addCriterion("SPECOPERID in", values, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidNotIn(List<String> values) {
            addCriterion("SPECOPERID not in", values, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidBetween(String value1, String value2) {
            addCriterion("SPECOPERID between", value1, value2, "specoperid");
            return (Criteria) this;
        }

        public Criteria andSpecoperidNotBetween(String value1, String value2) {
            addCriterion("SPECOPERID not between", value1, value2, "specoperid");
            return (Criteria) this;
        }

        public Criteria andAirline1IsNull() {
            addCriterion("AIRLINE1 is null");
            return (Criteria) this;
        }

        public Criteria andAirline1IsNotNull() {
            addCriterion("AIRLINE1 is not null");
            return (Criteria) this;
        }

        public Criteria andAirline1EqualTo(String value) {
            addCriterion("AIRLINE1 =", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1NotEqualTo(String value) {
            addCriterion("AIRLINE1 <>", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1GreaterThan(String value) {
            addCriterion("AIRLINE1 >", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1GreaterThanOrEqualTo(String value) {
            addCriterion("AIRLINE1 >=", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1LessThan(String value) {
            addCriterion("AIRLINE1 <", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1LessThanOrEqualTo(String value) {
            addCriterion("AIRLINE1 <=", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1Like(String value) {
            addCriterion("AIRLINE1 like", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1NotLike(String value) {
            addCriterion("AIRLINE1 not like", value, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1In(List<String> values) {
            addCriterion("AIRLINE1 in", values, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1NotIn(List<String> values) {
            addCriterion("AIRLINE1 not in", values, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1Between(String value1, String value2) {
            addCriterion("AIRLINE1 between", value1, value2, "airline1");
            return (Criteria) this;
        }

        public Criteria andAirline1NotBetween(String value1, String value2) {
            addCriterion("AIRLINE1 not between", value1, value2, "airline1");
            return (Criteria) this;
        }

        public Criteria andDeststation1IsNull() {
            addCriterion("DESTSTATION1 is null");
            return (Criteria) this;
        }

        public Criteria andDeststation1IsNotNull() {
            addCriterion("DESTSTATION1 is not null");
            return (Criteria) this;
        }

        public Criteria andDeststation1EqualTo(String value) {
            addCriterion("DESTSTATION1 =", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1NotEqualTo(String value) {
            addCriterion("DESTSTATION1 <>", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1GreaterThan(String value) {
            addCriterion("DESTSTATION1 >", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1GreaterThanOrEqualTo(String value) {
            addCriterion("DESTSTATION1 >=", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1LessThan(String value) {
            addCriterion("DESTSTATION1 <", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1LessThanOrEqualTo(String value) {
            addCriterion("DESTSTATION1 <=", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1Like(String value) {
            addCriterion("DESTSTATION1 like", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1NotLike(String value) {
            addCriterion("DESTSTATION1 not like", value, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1In(List<String> values) {
            addCriterion("DESTSTATION1 in", values, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1NotIn(List<String> values) {
            addCriterion("DESTSTATION1 not in", values, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1Between(String value1, String value2) {
            addCriterion("DESTSTATION1 between", value1, value2, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDeststation1NotBetween(String value1, String value2) {
            addCriterion("DESTSTATION1 not between", value1, value2, "deststation1");
            return (Criteria) this;
        }

        public Criteria andDestcity1IsNull() {
            addCriterion("DESTCITY1 is null");
            return (Criteria) this;
        }

        public Criteria andDestcity1IsNotNull() {
            addCriterion("DESTCITY1 is not null");
            return (Criteria) this;
        }

        public Criteria andDestcity1EqualTo(String value) {
            addCriterion("DESTCITY1 =", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1NotEqualTo(String value) {
            addCriterion("DESTCITY1 <>", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1GreaterThan(String value) {
            addCriterion("DESTCITY1 >", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1GreaterThanOrEqualTo(String value) {
            addCriterion("DESTCITY1 >=", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1LessThan(String value) {
            addCriterion("DESTCITY1 <", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1LessThanOrEqualTo(String value) {
            addCriterion("DESTCITY1 <=", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1Like(String value) {
            addCriterion("DESTCITY1 like", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1NotLike(String value) {
            addCriterion("DESTCITY1 not like", value, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1In(List<String> values) {
            addCriterion("DESTCITY1 in", values, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1NotIn(List<String> values) {
            addCriterion("DESTCITY1 not in", values, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1Between(String value1, String value2) {
            addCriterion("DESTCITY1 between", value1, value2, "destcity1");
            return (Criteria) this;
        }

        public Criteria andDestcity1NotBetween(String value1, String value2) {
            addCriterion("DESTCITY1 not between", value1, value2, "destcity1");
            return (Criteria) this;
        }

        public Criteria andAirline2IsNull() {
            addCriterion("AIRLINE2 is null");
            return (Criteria) this;
        }

        public Criteria andAirline2IsNotNull() {
            addCriterion("AIRLINE2 is not null");
            return (Criteria) this;
        }

        public Criteria andAirline2EqualTo(String value) {
            addCriterion("AIRLINE2 =", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2NotEqualTo(String value) {
            addCriterion("AIRLINE2 <>", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2GreaterThan(String value) {
            addCriterion("AIRLINE2 >", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2GreaterThanOrEqualTo(String value) {
            addCriterion("AIRLINE2 >=", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2LessThan(String value) {
            addCriterion("AIRLINE2 <", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2LessThanOrEqualTo(String value) {
            addCriterion("AIRLINE2 <=", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2Like(String value) {
            addCriterion("AIRLINE2 like", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2NotLike(String value) {
            addCriterion("AIRLINE2 not like", value, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2In(List<String> values) {
            addCriterion("AIRLINE2 in", values, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2NotIn(List<String> values) {
            addCriterion("AIRLINE2 not in", values, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2Between(String value1, String value2) {
            addCriterion("AIRLINE2 between", value1, value2, "airline2");
            return (Criteria) this;
        }

        public Criteria andAirline2NotBetween(String value1, String value2) {
            addCriterion("AIRLINE2 not between", value1, value2, "airline2");
            return (Criteria) this;
        }

        public Criteria andDeststation2IsNull() {
            addCriterion("DESTSTATION2 is null");
            return (Criteria) this;
        }

        public Criteria andDeststation2IsNotNull() {
            addCriterion("DESTSTATION2 is not null");
            return (Criteria) this;
        }

        public Criteria andDeststation2EqualTo(String value) {
            addCriterion("DESTSTATION2 =", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2NotEqualTo(String value) {
            addCriterion("DESTSTATION2 <>", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2GreaterThan(String value) {
            addCriterion("DESTSTATION2 >", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2GreaterThanOrEqualTo(String value) {
            addCriterion("DESTSTATION2 >=", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2LessThan(String value) {
            addCriterion("DESTSTATION2 <", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2LessThanOrEqualTo(String value) {
            addCriterion("DESTSTATION2 <=", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2Like(String value) {
            addCriterion("DESTSTATION2 like", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2NotLike(String value) {
            addCriterion("DESTSTATION2 not like", value, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2In(List<String> values) {
            addCriterion("DESTSTATION2 in", values, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2NotIn(List<String> values) {
            addCriterion("DESTSTATION2 not in", values, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2Between(String value1, String value2) {
            addCriterion("DESTSTATION2 between", value1, value2, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDeststation2NotBetween(String value1, String value2) {
            addCriterion("DESTSTATION2 not between", value1, value2, "deststation2");
            return (Criteria) this;
        }

        public Criteria andDestcity2IsNull() {
            addCriterion("DESTCITY2 is null");
            return (Criteria) this;
        }

        public Criteria andDestcity2IsNotNull() {
            addCriterion("DESTCITY2 is not null");
            return (Criteria) this;
        }

        public Criteria andDestcity2EqualTo(String value) {
            addCriterion("DESTCITY2 =", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2NotEqualTo(String value) {
            addCriterion("DESTCITY2 <>", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2GreaterThan(String value) {
            addCriterion("DESTCITY2 >", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2GreaterThanOrEqualTo(String value) {
            addCriterion("DESTCITY2 >=", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2LessThan(String value) {
            addCriterion("DESTCITY2 <", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2LessThanOrEqualTo(String value) {
            addCriterion("DESTCITY2 <=", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2Like(String value) {
            addCriterion("DESTCITY2 like", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2NotLike(String value) {
            addCriterion("DESTCITY2 not like", value, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2In(List<String> values) {
            addCriterion("DESTCITY2 in", values, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2NotIn(List<String> values) {
            addCriterion("DESTCITY2 not in", values, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2Between(String value1, String value2) {
            addCriterion("DESTCITY2 between", value1, value2, "destcity2");
            return (Criteria) this;
        }

        public Criteria andDestcity2NotBetween(String value1, String value2) {
            addCriterion("DESTCITY2 not between", value1, value2, "destcity2");
            return (Criteria) this;
        }

        public Criteria andAirline3IsNull() {
            addCriterion("AIRLINE3 is null");
            return (Criteria) this;
        }

        public Criteria andAirline3IsNotNull() {
            addCriterion("AIRLINE3 is not null");
            return (Criteria) this;
        }

        public Criteria andAirline3EqualTo(String value) {
            addCriterion("AIRLINE3 =", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3NotEqualTo(String value) {
            addCriterion("AIRLINE3 <>", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3GreaterThan(String value) {
            addCriterion("AIRLINE3 >", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3GreaterThanOrEqualTo(String value) {
            addCriterion("AIRLINE3 >=", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3LessThan(String value) {
            addCriterion("AIRLINE3 <", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3LessThanOrEqualTo(String value) {
            addCriterion("AIRLINE3 <=", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3Like(String value) {
            addCriterion("AIRLINE3 like", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3NotLike(String value) {
            addCriterion("AIRLINE3 not like", value, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3In(List<String> values) {
            addCriterion("AIRLINE3 in", values, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3NotIn(List<String> values) {
            addCriterion("AIRLINE3 not in", values, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3Between(String value1, String value2) {
            addCriterion("AIRLINE3 between", value1, value2, "airline3");
            return (Criteria) this;
        }

        public Criteria andAirline3NotBetween(String value1, String value2) {
            addCriterion("AIRLINE3 not between", value1, value2, "airline3");
            return (Criteria) this;
        }

        public Criteria andDeststation3IsNull() {
            addCriterion("DESTSTATION3 is null");
            return (Criteria) this;
        }

        public Criteria andDeststation3IsNotNull() {
            addCriterion("DESTSTATION3 is not null");
            return (Criteria) this;
        }

        public Criteria andDeststation3EqualTo(String value) {
            addCriterion("DESTSTATION3 =", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3NotEqualTo(String value) {
            addCriterion("DESTSTATION3 <>", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3GreaterThan(String value) {
            addCriterion("DESTSTATION3 >", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3GreaterThanOrEqualTo(String value) {
            addCriterion("DESTSTATION3 >=", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3LessThan(String value) {
            addCriterion("DESTSTATION3 <", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3LessThanOrEqualTo(String value) {
            addCriterion("DESTSTATION3 <=", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3Like(String value) {
            addCriterion("DESTSTATION3 like", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3NotLike(String value) {
            addCriterion("DESTSTATION3 not like", value, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3In(List<String> values) {
            addCriterion("DESTSTATION3 in", values, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3NotIn(List<String> values) {
            addCriterion("DESTSTATION3 not in", values, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3Between(String value1, String value2) {
            addCriterion("DESTSTATION3 between", value1, value2, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDeststation3NotBetween(String value1, String value2) {
            addCriterion("DESTSTATION3 not between", value1, value2, "deststation3");
            return (Criteria) this;
        }

        public Criteria andDestcity3IsNull() {
            addCriterion("DESTCITY3 is null");
            return (Criteria) this;
        }

        public Criteria andDestcity3IsNotNull() {
            addCriterion("DESTCITY3 is not null");
            return (Criteria) this;
        }

        public Criteria andDestcity3EqualTo(String value) {
            addCriterion("DESTCITY3 =", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3NotEqualTo(String value) {
            addCriterion("DESTCITY3 <>", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3GreaterThan(String value) {
            addCriterion("DESTCITY3 >", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3GreaterThanOrEqualTo(String value) {
            addCriterion("DESTCITY3 >=", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3LessThan(String value) {
            addCriterion("DESTCITY3 <", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3LessThanOrEqualTo(String value) {
            addCriterion("DESTCITY3 <=", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3Like(String value) {
            addCriterion("DESTCITY3 like", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3NotLike(String value) {
            addCriterion("DESTCITY3 not like", value, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3In(List<String> values) {
            addCriterion("DESTCITY3 in", values, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3NotIn(List<String> values) {
            addCriterion("DESTCITY3 not in", values, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3Between(String value1, String value2) {
            addCriterion("DESTCITY3 between", value1, value2, "destcity3");
            return (Criteria) this;
        }

        public Criteria andDestcity3NotBetween(String value1, String value2) {
            addCriterion("DESTCITY3 not between", value1, value2, "destcity3");
            return (Criteria) this;
        }

        public Criteria andAirline4IsNull() {
            addCriterion("AIRLINE4 is null");
            return (Criteria) this;
        }

        public Criteria andAirline4IsNotNull() {
            addCriterion("AIRLINE4 is not null");
            return (Criteria) this;
        }

        public Criteria andAirline4EqualTo(String value) {
            addCriterion("AIRLINE4 =", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4NotEqualTo(String value) {
            addCriterion("AIRLINE4 <>", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4GreaterThan(String value) {
            addCriterion("AIRLINE4 >", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4GreaterThanOrEqualTo(String value) {
            addCriterion("AIRLINE4 >=", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4LessThan(String value) {
            addCriterion("AIRLINE4 <", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4LessThanOrEqualTo(String value) {
            addCriterion("AIRLINE4 <=", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4Like(String value) {
            addCriterion("AIRLINE4 like", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4NotLike(String value) {
            addCriterion("AIRLINE4 not like", value, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4In(List<String> values) {
            addCriterion("AIRLINE4 in", values, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4NotIn(List<String> values) {
            addCriterion("AIRLINE4 not in", values, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4Between(String value1, String value2) {
            addCriterion("AIRLINE4 between", value1, value2, "airline4");
            return (Criteria) this;
        }

        public Criteria andAirline4NotBetween(String value1, String value2) {
            addCriterion("AIRLINE4 not between", value1, value2, "airline4");
            return (Criteria) this;
        }

        public Criteria andDeststation4IsNull() {
            addCriterion("DESTSTATION4 is null");
            return (Criteria) this;
        }

        public Criteria andDeststation4IsNotNull() {
            addCriterion("DESTSTATION4 is not null");
            return (Criteria) this;
        }

        public Criteria andDeststation4EqualTo(String value) {
            addCriterion("DESTSTATION4 =", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4NotEqualTo(String value) {
            addCriterion("DESTSTATION4 <>", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4GreaterThan(String value) {
            addCriterion("DESTSTATION4 >", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4GreaterThanOrEqualTo(String value) {
            addCriterion("DESTSTATION4 >=", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4LessThan(String value) {
            addCriterion("DESTSTATION4 <", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4LessThanOrEqualTo(String value) {
            addCriterion("DESTSTATION4 <=", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4Like(String value) {
            addCriterion("DESTSTATION4 like", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4NotLike(String value) {
            addCriterion("DESTSTATION4 not like", value, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4In(List<String> values) {
            addCriterion("DESTSTATION4 in", values, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4NotIn(List<String> values) {
            addCriterion("DESTSTATION4 not in", values, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4Between(String value1, String value2) {
            addCriterion("DESTSTATION4 between", value1, value2, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDeststation4NotBetween(String value1, String value2) {
            addCriterion("DESTSTATION4 not between", value1, value2, "deststation4");
            return (Criteria) this;
        }

        public Criteria andDestcity4IsNull() {
            addCriterion("DESTCITY4 is null");
            return (Criteria) this;
        }

        public Criteria andDestcity4IsNotNull() {
            addCriterion("DESTCITY4 is not null");
            return (Criteria) this;
        }

        public Criteria andDestcity4EqualTo(String value) {
            addCriterion("DESTCITY4 =", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4NotEqualTo(String value) {
            addCriterion("DESTCITY4 <>", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4GreaterThan(String value) {
            addCriterion("DESTCITY4 >", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4GreaterThanOrEqualTo(String value) {
            addCriterion("DESTCITY4 >=", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4LessThan(String value) {
            addCriterion("DESTCITY4 <", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4LessThanOrEqualTo(String value) {
            addCriterion("DESTCITY4 <=", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4Like(String value) {
            addCriterion("DESTCITY4 like", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4NotLike(String value) {
            addCriterion("DESTCITY4 not like", value, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4In(List<String> values) {
            addCriterion("DESTCITY4 in", values, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4NotIn(List<String> values) {
            addCriterion("DESTCITY4 not in", values, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4Between(String value1, String value2) {
            addCriterion("DESTCITY4 between", value1, value2, "destcity4");
            return (Criteria) this;
        }

        public Criteria andDestcity4NotBetween(String value1, String value2) {
            addCriterion("DESTCITY4 not between", value1, value2, "destcity4");
            return (Criteria) this;
        }

        public Criteria andProductidIsNull() {
            addCriterion("PRODUCTID is null");
            return (Criteria) this;
        }

        public Criteria andProductidIsNotNull() {
            addCriterion("PRODUCTID is not null");
            return (Criteria) this;
        }

        public Criteria andProductidEqualTo(String value) {
            addCriterion("PRODUCTID =", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotEqualTo(String value) {
            addCriterion("PRODUCTID <>", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThan(String value) {
            addCriterion("PRODUCTID >", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTID >=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThan(String value) {
            addCriterion("PRODUCTID <", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTID <=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLike(String value) {
            addCriterion("PRODUCTID like", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotLike(String value) {
            addCriterion("PRODUCTID not like", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidIn(List<String> values) {
            addCriterion("PRODUCTID in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotIn(List<String> values) {
            addCriterion("PRODUCTID not in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidBetween(String value1, String value2) {
            addCriterion("PRODUCTID between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotBetween(String value1, String value2) {
            addCriterion("PRODUCTID not between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNull() {
            addCriterion("PRODUCTNAME is null");
            return (Criteria) this;
        }

        public Criteria andProductnameIsNotNull() {
            addCriterion("PRODUCTNAME is not null");
            return (Criteria) this;
        }

        public Criteria andProductnameEqualTo(String value) {
            addCriterion("PRODUCTNAME =", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotEqualTo(String value) {
            addCriterion("PRODUCTNAME <>", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThan(String value) {
            addCriterion("PRODUCTNAME >", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameGreaterThanOrEqualTo(String value) {
            addCriterion("PRODUCTNAME >=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThan(String value) {
            addCriterion("PRODUCTNAME <", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLessThanOrEqualTo(String value) {
            addCriterion("PRODUCTNAME <=", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameLike(String value) {
            addCriterion("PRODUCTNAME like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotLike(String value) {
            addCriterion("PRODUCTNAME not like", value, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameIn(List<String> values) {
            addCriterion("PRODUCTNAME in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotIn(List<String> values) {
            addCriterion("PRODUCTNAME not in", values, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameBetween(String value1, String value2) {
            addCriterion("PRODUCTNAME between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andProductnameNotBetween(String value1, String value2) {
            addCriterion("PRODUCTNAME not between", value1, value2, "productname");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNull() {
            addCriterion("AGENTID is null");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNotNull() {
            addCriterion("AGENTID is not null");
            return (Criteria) this;
        }

        public Criteria andAgentidEqualTo(String value) {
            addCriterion("AGENTID =", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotEqualTo(String value) {
            addCriterion("AGENTID <>", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThan(String value) {
            addCriterion("AGENTID >", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThanOrEqualTo(String value) {
            addCriterion("AGENTID >=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThan(String value) {
            addCriterion("AGENTID <", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThanOrEqualTo(String value) {
            addCriterion("AGENTID <=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLike(String value) {
            addCriterion("AGENTID like", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotLike(String value) {
            addCriterion("AGENTID not like", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidIn(List<String> values) {
            addCriterion("AGENTID in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotIn(List<String> values) {
            addCriterion("AGENTID not in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidBetween(String value1, String value2) {
            addCriterion("AGENTID between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotBetween(String value1, String value2) {
            addCriterion("AGENTID not between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNull() {
            addCriterion("AGENTNAME is null");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNotNull() {
            addCriterion("AGENTNAME is not null");
            return (Criteria) this;
        }

        public Criteria andAgentnameEqualTo(String value) {
            addCriterion("AGENTNAME =", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotEqualTo(String value) {
            addCriterion("AGENTNAME <>", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThan(String value) {
            addCriterion("AGENTNAME >", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThanOrEqualTo(String value) {
            addCriterion("AGENTNAME >=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThan(String value) {
            addCriterion("AGENTNAME <", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThanOrEqualTo(String value) {
            addCriterion("AGENTNAME <=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLike(String value) {
            addCriterion("AGENTNAME like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotLike(String value) {
            addCriterion("AGENTNAME not like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameIn(List<String> values) {
            addCriterion("AGENTNAME in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotIn(List<String> values) {
            addCriterion("AGENTNAME not in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameBetween(String value1, String value2) {
            addCriterion("AGENTNAME between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotBetween(String value1, String value2) {
            addCriterion("AGENTNAME not between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andShprnameIsNull() {
            addCriterion("SHPRNAME is null");
            return (Criteria) this;
        }

        public Criteria andShprnameIsNotNull() {
            addCriterion("SHPRNAME is not null");
            return (Criteria) this;
        }

        public Criteria andShprnameEqualTo(String value) {
            addCriterion("SHPRNAME =", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameNotEqualTo(String value) {
            addCriterion("SHPRNAME <>", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameGreaterThan(String value) {
            addCriterion("SHPRNAME >", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameGreaterThanOrEqualTo(String value) {
            addCriterion("SHPRNAME >=", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameLessThan(String value) {
            addCriterion("SHPRNAME <", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameLessThanOrEqualTo(String value) {
            addCriterion("SHPRNAME <=", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameLike(String value) {
            addCriterion("SHPRNAME like", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameNotLike(String value) {
            addCriterion("SHPRNAME not like", value, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameIn(List<String> values) {
            addCriterion("SHPRNAME in", values, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameNotIn(List<String> values) {
            addCriterion("SHPRNAME not in", values, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameBetween(String value1, String value2) {
            addCriterion("SHPRNAME between", value1, value2, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprnameNotBetween(String value1, String value2) {
            addCriterion("SHPRNAME not between", value1, value2, "shprname");
            return (Criteria) this;
        }

        public Criteria andShprtelIsNull() {
            addCriterion("SHPRTEL is null");
            return (Criteria) this;
        }

        public Criteria andShprtelIsNotNull() {
            addCriterion("SHPRTEL is not null");
            return (Criteria) this;
        }

        public Criteria andShprtelEqualTo(String value) {
            addCriterion("SHPRTEL =", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelNotEqualTo(String value) {
            addCriterion("SHPRTEL <>", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelGreaterThan(String value) {
            addCriterion("SHPRTEL >", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelGreaterThanOrEqualTo(String value) {
            addCriterion("SHPRTEL >=", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelLessThan(String value) {
            addCriterion("SHPRTEL <", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelLessThanOrEqualTo(String value) {
            addCriterion("SHPRTEL <=", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelLike(String value) {
            addCriterion("SHPRTEL like", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelNotLike(String value) {
            addCriterion("SHPRTEL not like", value, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelIn(List<String> values) {
            addCriterion("SHPRTEL in", values, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelNotIn(List<String> values) {
            addCriterion("SHPRTEL not in", values, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelBetween(String value1, String value2) {
            addCriterion("SHPRTEL between", value1, value2, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShprtelNotBetween(String value1, String value2) {
            addCriterion("SHPRTEL not between", value1, value2, "shprtel");
            return (Criteria) this;
        }

        public Criteria andShpraddressIsNull() {
            addCriterion("SHPRADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andShpraddressIsNotNull() {
            addCriterion("SHPRADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andShpraddressEqualTo(String value) {
            addCriterion("SHPRADDRESS =", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressNotEqualTo(String value) {
            addCriterion("SHPRADDRESS <>", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressGreaterThan(String value) {
            addCriterion("SHPRADDRESS >", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressGreaterThanOrEqualTo(String value) {
            addCriterion("SHPRADDRESS >=", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressLessThan(String value) {
            addCriterion("SHPRADDRESS <", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressLessThanOrEqualTo(String value) {
            addCriterion("SHPRADDRESS <=", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressLike(String value) {
            addCriterion("SHPRADDRESS like", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressNotLike(String value) {
            addCriterion("SHPRADDRESS not like", value, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressIn(List<String> values) {
            addCriterion("SHPRADDRESS in", values, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressNotIn(List<String> values) {
            addCriterion("SHPRADDRESS not in", values, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressBetween(String value1, String value2) {
            addCriterion("SHPRADDRESS between", value1, value2, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpraddressNotBetween(String value1, String value2) {
            addCriterion("SHPRADDRESS not between", value1, value2, "shpraddress");
            return (Criteria) this;
        }

        public Criteria andShpragentIsNull() {
            addCriterion("SHPRAGENT is null");
            return (Criteria) this;
        }

        public Criteria andShpragentIsNotNull() {
            addCriterion("SHPRAGENT is not null");
            return (Criteria) this;
        }

        public Criteria andShpragentEqualTo(String value) {
            addCriterion("SHPRAGENT =", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentNotEqualTo(String value) {
            addCriterion("SHPRAGENT <>", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentGreaterThan(String value) {
            addCriterion("SHPRAGENT >", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentGreaterThanOrEqualTo(String value) {
            addCriterion("SHPRAGENT >=", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentLessThan(String value) {
            addCriterion("SHPRAGENT <", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentLessThanOrEqualTo(String value) {
            addCriterion("SHPRAGENT <=", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentLike(String value) {
            addCriterion("SHPRAGENT like", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentNotLike(String value) {
            addCriterion("SHPRAGENT not like", value, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentIn(List<String> values) {
            addCriterion("SHPRAGENT in", values, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentNotIn(List<String> values) {
            addCriterion("SHPRAGENT not in", values, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentBetween(String value1, String value2) {
            addCriterion("SHPRAGENT between", value1, value2, "shpragent");
            return (Criteria) this;
        }

        public Criteria andShpragentNotBetween(String value1, String value2) {
            addCriterion("SHPRAGENT not between", value1, value2, "shpragent");
            return (Criteria) this;
        }

        public Criteria andCnsnnameIsNull() {
            addCriterion("CNSNNAME is null");
            return (Criteria) this;
        }

        public Criteria andCnsnnameIsNotNull() {
            addCriterion("CNSNNAME is not null");
            return (Criteria) this;
        }

        public Criteria andCnsnnameEqualTo(String value) {
            addCriterion("CNSNNAME =", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameNotEqualTo(String value) {
            addCriterion("CNSNNAME <>", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameGreaterThan(String value) {
            addCriterion("CNSNNAME >", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameGreaterThanOrEqualTo(String value) {
            addCriterion("CNSNNAME >=", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameLessThan(String value) {
            addCriterion("CNSNNAME <", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameLessThanOrEqualTo(String value) {
            addCriterion("CNSNNAME <=", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameLike(String value) {
            addCriterion("CNSNNAME like", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameNotLike(String value) {
            addCriterion("CNSNNAME not like", value, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameIn(List<String> values) {
            addCriterion("CNSNNAME in", values, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameNotIn(List<String> values) {
            addCriterion("CNSNNAME not in", values, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameBetween(String value1, String value2) {
            addCriterion("CNSNNAME between", value1, value2, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsnnameNotBetween(String value1, String value2) {
            addCriterion("CNSNNAME not between", value1, value2, "cnsnname");
            return (Criteria) this;
        }

        public Criteria andCnsntelIsNull() {
            addCriterion("CNSNTEL is null");
            return (Criteria) this;
        }

        public Criteria andCnsntelIsNotNull() {
            addCriterion("CNSNTEL is not null");
            return (Criteria) this;
        }

        public Criteria andCnsntelEqualTo(String value) {
            addCriterion("CNSNTEL =", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelNotEqualTo(String value) {
            addCriterion("CNSNTEL <>", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelGreaterThan(String value) {
            addCriterion("CNSNTEL >", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelGreaterThanOrEqualTo(String value) {
            addCriterion("CNSNTEL >=", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelLessThan(String value) {
            addCriterion("CNSNTEL <", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelLessThanOrEqualTo(String value) {
            addCriterion("CNSNTEL <=", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelLike(String value) {
            addCriterion("CNSNTEL like", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelNotLike(String value) {
            addCriterion("CNSNTEL not like", value, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelIn(List<String> values) {
            addCriterion("CNSNTEL in", values, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelNotIn(List<String> values) {
            addCriterion("CNSNTEL not in", values, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelBetween(String value1, String value2) {
            addCriterion("CNSNTEL between", value1, value2, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsntelNotBetween(String value1, String value2) {
            addCriterion("CNSNTEL not between", value1, value2, "cnsntel");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressIsNull() {
            addCriterion("CNSNADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressIsNotNull() {
            addCriterion("CNSNADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressEqualTo(String value) {
            addCriterion("CNSNADDRESS =", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressNotEqualTo(String value) {
            addCriterion("CNSNADDRESS <>", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressGreaterThan(String value) {
            addCriterion("CNSNADDRESS >", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressGreaterThanOrEqualTo(String value) {
            addCriterion("CNSNADDRESS >=", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressLessThan(String value) {
            addCriterion("CNSNADDRESS <", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressLessThanOrEqualTo(String value) {
            addCriterion("CNSNADDRESS <=", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressLike(String value) {
            addCriterion("CNSNADDRESS like", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressNotLike(String value) {
            addCriterion("CNSNADDRESS not like", value, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressIn(List<String> values) {
            addCriterion("CNSNADDRESS in", values, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressNotIn(List<String> values) {
            addCriterion("CNSNADDRESS not in", values, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressBetween(String value1, String value2) {
            addCriterion("CNSNADDRESS between", value1, value2, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnaddressNotBetween(String value1, String value2) {
            addCriterion("CNSNADDRESS not between", value1, value2, "cnsnaddress");
            return (Criteria) this;
        }

        public Criteria andCnsnagentIsNull() {
            addCriterion("CNSNAGENT is null");
            return (Criteria) this;
        }

        public Criteria andCnsnagentIsNotNull() {
            addCriterion("CNSNAGENT is not null");
            return (Criteria) this;
        }

        public Criteria andCnsnagentEqualTo(String value) {
            addCriterion("CNSNAGENT =", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentNotEqualTo(String value) {
            addCriterion("CNSNAGENT <>", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentGreaterThan(String value) {
            addCriterion("CNSNAGENT >", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentGreaterThanOrEqualTo(String value) {
            addCriterion("CNSNAGENT >=", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentLessThan(String value) {
            addCriterion("CNSNAGENT <", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentLessThanOrEqualTo(String value) {
            addCriterion("CNSNAGENT <=", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentLike(String value) {
            addCriterion("CNSNAGENT like", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentNotLike(String value) {
            addCriterion("CNSNAGENT not like", value, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentIn(List<String> values) {
            addCriterion("CNSNAGENT in", values, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentNotIn(List<String> values) {
            addCriterion("CNSNAGENT not in", values, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentBetween(String value1, String value2) {
            addCriterion("CNSNAGENT between", value1, value2, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCnsnagentNotBetween(String value1, String value2) {
            addCriterion("CNSNAGENT not between", value1, value2, "cnsnagent");
            return (Criteria) this;
        }

        public Criteria andCarrycostIsNull() {
            addCriterion("CARRYCOST is null");
            return (Criteria) this;
        }

        public Criteria andCarrycostIsNotNull() {
            addCriterion("CARRYCOST is not null");
            return (Criteria) this;
        }

        public Criteria andCarrycostEqualTo(BigDecimal value) {
            addCriterion("CARRYCOST =", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostNotEqualTo(BigDecimal value) {
            addCriterion("CARRYCOST <>", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostGreaterThan(BigDecimal value) {
            addCriterion("CARRYCOST >", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYCOST >=", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostLessThan(BigDecimal value) {
            addCriterion("CARRYCOST <", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYCOST <=", value, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostIn(List<BigDecimal> values) {
            addCriterion("CARRYCOST in", values, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostNotIn(List<BigDecimal> values) {
            addCriterion("CARRYCOST not in", values, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYCOST between", value1, value2, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarrycostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYCOST not between", value1, value2, "carrycost");
            return (Criteria) this;
        }

        public Criteria andCarryrateIsNull() {
            addCriterion("CARRYRATE is null");
            return (Criteria) this;
        }

        public Criteria andCarryrateIsNotNull() {
            addCriterion("CARRYRATE is not null");
            return (Criteria) this;
        }

        public Criteria andCarryrateEqualTo(BigDecimal value) {
            addCriterion("CARRYRATE =", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateNotEqualTo(BigDecimal value) {
            addCriterion("CARRYRATE <>", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateGreaterThan(BigDecimal value) {
            addCriterion("CARRYRATE >", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYRATE >=", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateLessThan(BigDecimal value) {
            addCriterion("CARRYRATE <", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CARRYRATE <=", value, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateIn(List<BigDecimal> values) {
            addCriterion("CARRYRATE in", values, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateNotIn(List<BigDecimal> values) {
            addCriterion("CARRYRATE not in", values, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYRATE between", value1, value2, "carryrate");
            return (Criteria) this;
        }

        public Criteria andCarryrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CARRYRATE not between", value1, value2, "carryrate");
            return (Criteria) this;
        }

        public Criteria andAgentcostIsNull() {
            addCriterion("AGENTCOST is null");
            return (Criteria) this;
        }

        public Criteria andAgentcostIsNotNull() {
            addCriterion("AGENTCOST is not null");
            return (Criteria) this;
        }

        public Criteria andAgentcostEqualTo(BigDecimal value) {
            addCriterion("AGENTCOST =", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostNotEqualTo(BigDecimal value) {
            addCriterion("AGENTCOST <>", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostGreaterThan(BigDecimal value) {
            addCriterion("AGENTCOST >", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AGENTCOST >=", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostLessThan(BigDecimal value) {
            addCriterion("AGENTCOST <", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AGENTCOST <=", value, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostIn(List<BigDecimal> values) {
            addCriterion("AGENTCOST in", values, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostNotIn(List<BigDecimal> values) {
            addCriterion("AGENTCOST not in", values, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AGENTCOST between", value1, value2, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentcostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AGENTCOST not between", value1, value2, "agentcost");
            return (Criteria) this;
        }

        public Criteria andAgentrateIsNull() {
            addCriterion("AGENTRATE is null");
            return (Criteria) this;
        }

        public Criteria andAgentrateIsNotNull() {
            addCriterion("AGENTRATE is not null");
            return (Criteria) this;
        }

        public Criteria andAgentrateEqualTo(BigDecimal value) {
            addCriterion("AGENTRATE =", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateNotEqualTo(BigDecimal value) {
            addCriterion("AGENTRATE <>", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateGreaterThan(BigDecimal value) {
            addCriterion("AGENTRATE >", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AGENTRATE >=", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateLessThan(BigDecimal value) {
            addCriterion("AGENTRATE <", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AGENTRATE <=", value, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateIn(List<BigDecimal> values) {
            addCriterion("AGENTRATE in", values, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateNotIn(List<BigDecimal> values) {
            addCriterion("AGENTRATE not in", values, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AGENTRATE between", value1, value2, "agentrate");
            return (Criteria) this;
        }

        public Criteria andAgentrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AGENTRATE not between", value1, value2, "agentrate");
            return (Criteria) this;
        }

        public Criteria andShippervalueIsNull() {
            addCriterion("SHIPPERVALUE is null");
            return (Criteria) this;
        }

        public Criteria andShippervalueIsNotNull() {
            addCriterion("SHIPPERVALUE is not null");
            return (Criteria) this;
        }

        public Criteria andShippervalueEqualTo(BigDecimal value) {
            addCriterion("SHIPPERVALUE =", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueNotEqualTo(BigDecimal value) {
            addCriterion("SHIPPERVALUE <>", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueGreaterThan(BigDecimal value) {
            addCriterion("SHIPPERVALUE >", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SHIPPERVALUE >=", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueLessThan(BigDecimal value) {
            addCriterion("SHIPPERVALUE <", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SHIPPERVALUE <=", value, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueIn(List<BigDecimal> values) {
            addCriterion("SHIPPERVALUE in", values, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueNotIn(List<BigDecimal> values) {
            addCriterion("SHIPPERVALUE not in", values, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SHIPPERVALUE between", value1, value2, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andShippervalueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SHIPPERVALUE not between", value1, value2, "shippervalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueIsNull() {
            addCriterion("INSUREVALUE is null");
            return (Criteria) this;
        }

        public Criteria andInsurevalueIsNotNull() {
            addCriterion("INSUREVALUE is not null");
            return (Criteria) this;
        }

        public Criteria andInsurevalueEqualTo(BigDecimal value) {
            addCriterion("INSUREVALUE =", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueNotEqualTo(BigDecimal value) {
            addCriterion("INSUREVALUE <>", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueGreaterThan(BigDecimal value) {
            addCriterion("INSUREVALUE >", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("INSUREVALUE >=", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueLessThan(BigDecimal value) {
            addCriterion("INSUREVALUE <", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("INSUREVALUE <=", value, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueIn(List<BigDecimal> values) {
            addCriterion("INSUREVALUE in", values, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueNotIn(List<BigDecimal> values) {
            addCriterion("INSUREVALUE not in", values, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INSUREVALUE between", value1, value2, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andInsurevalueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("INSUREVALUE not between", value1, value2, "insurevalue");
            return (Criteria) this;
        }

        public Criteria andHbillqtyIsNull() {
            addCriterion("HBILLQTY is null");
            return (Criteria) this;
        }

        public Criteria andHbillqtyIsNotNull() {
            addCriterion("HBILLQTY is not null");
            return (Criteria) this;
        }

        public Criteria andHbillqtyEqualTo(BigDecimal value) {
            addCriterion("HBILLQTY =", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyNotEqualTo(BigDecimal value) {
            addCriterion("HBILLQTY <>", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyGreaterThan(BigDecimal value) {
            addCriterion("HBILLQTY >", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HBILLQTY >=", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyLessThan(BigDecimal value) {
            addCriterion("HBILLQTY <", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HBILLQTY <=", value, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyIn(List<BigDecimal> values) {
            addCriterion("HBILLQTY in", values, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyNotIn(List<BigDecimal> values) {
            addCriterion("HBILLQTY not in", values, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HBILLQTY between", value1, value2, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andHbillqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HBILLQTY not between", value1, value2, "hbillqty");
            return (Criteria) this;
        }

        public Criteria andPcsIsNull() {
            addCriterion("PCS is null");
            return (Criteria) this;
        }

        public Criteria andPcsIsNotNull() {
            addCriterion("PCS is not null");
            return (Criteria) this;
        }

        public Criteria andPcsEqualTo(BigDecimal value) {
            addCriterion("PCS =", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotEqualTo(BigDecimal value) {
            addCriterion("PCS <>", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThan(BigDecimal value) {
            addCriterion("PCS >", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PCS >=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThan(BigDecimal value) {
            addCriterion("PCS <", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PCS <=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsIn(List<BigDecimal> values) {
            addCriterion("PCS in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotIn(List<BigDecimal> values) {
            addCriterion("PCS not in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PCS between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PCS not between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("WEIGHT is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("WEIGHT is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("WEIGHT =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("WEIGHT <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("WEIGHT >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WEIGHT >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("WEIGHT <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WEIGHT <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("WEIGHT in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("WEIGHT not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WEIGHT between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WEIGHT not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andVolIsNull() {
            addCriterion("VOL is null");
            return (Criteria) this;
        }

        public Criteria andVolIsNotNull() {
            addCriterion("VOL is not null");
            return (Criteria) this;
        }

        public Criteria andVolEqualTo(BigDecimal value) {
            addCriterion("VOL =", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolNotEqualTo(BigDecimal value) {
            addCriterion("VOL <>", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolGreaterThan(BigDecimal value) {
            addCriterion("VOL >", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("VOL >=", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolLessThan(BigDecimal value) {
            addCriterion("VOL <", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolLessThanOrEqualTo(BigDecimal value) {
            addCriterion("VOL <=", value, "vol");
            return (Criteria) this;
        }

        public Criteria andVolIn(List<BigDecimal> values) {
            addCriterion("VOL in", values, "vol");
            return (Criteria) this;
        }

        public Criteria andVolNotIn(List<BigDecimal> values) {
            addCriterion("VOL not in", values, "vol");
            return (Criteria) this;
        }

        public Criteria andVolBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VOL between", value1, value2, "vol");
            return (Criteria) this;
        }

        public Criteria andVolNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("VOL not between", value1, value2, "vol");
            return (Criteria) this;
        }

        public Criteria andCurweekIsNull() {
            addCriterion("CURWEEK is null");
            return (Criteria) this;
        }

        public Criteria andCurweekIsNotNull() {
            addCriterion("CURWEEK is not null");
            return (Criteria) this;
        }

        public Criteria andCurweekEqualTo(BigDecimal value) {
            addCriterion("CURWEEK =", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekNotEqualTo(BigDecimal value) {
            addCriterion("CURWEEK <>", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekGreaterThan(BigDecimal value) {
            addCriterion("CURWEEK >", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CURWEEK >=", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekLessThan(BigDecimal value) {
            addCriterion("CURWEEK <", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CURWEEK <=", value, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekIn(List<BigDecimal> values) {
            addCriterion("CURWEEK in", values, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekNotIn(List<BigDecimal> values) {
            addCriterion("CURWEEK not in", values, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURWEEK between", value1, value2, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurweekNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURWEEK not between", value1, value2, "curweek");
            return (Criteria) this;
        }

        public Criteria andCurmonthIsNull() {
            addCriterion("CURMONTH is null");
            return (Criteria) this;
        }

        public Criteria andCurmonthIsNotNull() {
            addCriterion("CURMONTH is not null");
            return (Criteria) this;
        }

        public Criteria andCurmonthEqualTo(BigDecimal value) {
            addCriterion("CURMONTH =", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthNotEqualTo(BigDecimal value) {
            addCriterion("CURMONTH <>", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthGreaterThan(BigDecimal value) {
            addCriterion("CURMONTH >", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CURMONTH >=", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthLessThan(BigDecimal value) {
            addCriterion("CURMONTH <", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CURMONTH <=", value, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthIn(List<BigDecimal> values) {
            addCriterion("CURMONTH in", values, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthNotIn(List<BigDecimal> values) {
            addCriterion("CURMONTH not in", values, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURMONTH between", value1, value2, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCurmonthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURMONTH not between", value1, value2, "curmonth");
            return (Criteria) this;
        }

        public Criteria andCuryearIsNull() {
            addCriterion("CURYEAR is null");
            return (Criteria) this;
        }

        public Criteria andCuryearIsNotNull() {
            addCriterion("CURYEAR is not null");
            return (Criteria) this;
        }

        public Criteria andCuryearEqualTo(BigDecimal value) {
            addCriterion("CURYEAR =", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearNotEqualTo(BigDecimal value) {
            addCriterion("CURYEAR <>", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearGreaterThan(BigDecimal value) {
            addCriterion("CURYEAR >", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CURYEAR >=", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearLessThan(BigDecimal value) {
            addCriterion("CURYEAR <", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CURYEAR <=", value, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearIn(List<BigDecimal> values) {
            addCriterion("CURYEAR in", values, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearNotIn(List<BigDecimal> values) {
            addCriterion("CURYEAR not in", values, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURYEAR between", value1, value2, "curyear");
            return (Criteria) this;
        }

        public Criteria andCuryearNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CURYEAR not between", value1, value2, "curyear");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CREATETIME is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CREATETIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CREATETIME =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CREATETIME <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CREATETIME >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATETIME >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CREATETIME <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATETIME <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CREATETIME in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CREATETIME not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CREATETIME between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATETIME not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UPDATETIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UPDATETIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("UPDATETIME =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("UPDATETIME <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("UPDATETIME >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATETIME >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("UPDATETIME <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATETIME <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("UPDATETIME in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("UPDATETIME not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("UPDATETIME between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATETIME not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentIsNull() {
            addCriterion("CTRLOPEDEPARTMENT is null");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentIsNotNull() {
            addCriterion("CTRLOPEDEPARTMENT is not null");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentEqualTo(String value) {
            addCriterion("CTRLOPEDEPARTMENT =", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentNotEqualTo(String value) {
            addCriterion("CTRLOPEDEPARTMENT <>", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentGreaterThan(String value) {
            addCriterion("CTRLOPEDEPARTMENT >", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("CTRLOPEDEPARTMENT >=", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentLessThan(String value) {
            addCriterion("CTRLOPEDEPARTMENT <", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentLessThanOrEqualTo(String value) {
            addCriterion("CTRLOPEDEPARTMENT <=", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentLike(String value) {
            addCriterion("CTRLOPEDEPARTMENT like", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentNotLike(String value) {
            addCriterion("CTRLOPEDEPARTMENT not like", value, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentIn(List<String> values) {
            addCriterion("CTRLOPEDEPARTMENT in", values, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentNotIn(List<String> values) {
            addCriterion("CTRLOPEDEPARTMENT not in", values, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentBetween(String value1, String value2) {
            addCriterion("CTRLOPEDEPARTMENT between", value1, value2, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andCtrlopedepartmentNotBetween(String value1, String value2) {
            addCriterion("CTRLOPEDEPARTMENT not between", value1, value2, "ctrlopedepartment");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumIsNull() {
            addCriterion("WAYBILLFULLNUM is null");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumIsNotNull() {
            addCriterion("WAYBILLFULLNUM is not null");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumEqualTo(String value) {
            addCriterion("WAYBILLFULLNUM =", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumNotEqualTo(String value) {
            addCriterion("WAYBILLFULLNUM <>", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumGreaterThan(String value) {
            addCriterion("WAYBILLFULLNUM >", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumGreaterThanOrEqualTo(String value) {
            addCriterion("WAYBILLFULLNUM >=", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumLessThan(String value) {
            addCriterion("WAYBILLFULLNUM <", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumLessThanOrEqualTo(String value) {
            addCriterion("WAYBILLFULLNUM <=", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumLike(String value) {
            addCriterion("WAYBILLFULLNUM like", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumNotLike(String value) {
            addCriterion("WAYBILLFULLNUM not like", value, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumIn(List<String> values) {
            addCriterion("WAYBILLFULLNUM in", values, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumNotIn(List<String> values) {
            addCriterion("WAYBILLFULLNUM not in", values, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumBetween(String value1, String value2) {
            addCriterion("WAYBILLFULLNUM between", value1, value2, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andWaybillfullnumNotBetween(String value1, String value2) {
            addCriterion("WAYBILLFULLNUM not between", value1, value2, "waybillfullnum");
            return (Criteria) this;
        }

        public Criteria andImpIsNull() {
            addCriterion("IMP is null");
            return (Criteria) this;
        }

        public Criteria andImpIsNotNull() {
            addCriterion("IMP is not null");
            return (Criteria) this;
        }

        public Criteria andImpEqualTo(String value) {
            addCriterion("IMP =", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpNotEqualTo(String value) {
            addCriterion("IMP <>", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpGreaterThan(String value) {
            addCriterion("IMP >", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpGreaterThanOrEqualTo(String value) {
            addCriterion("IMP >=", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpLessThan(String value) {
            addCriterion("IMP <", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpLessThanOrEqualTo(String value) {
            addCriterion("IMP <=", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpLike(String value) {
            addCriterion("IMP like", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpNotLike(String value) {
            addCriterion("IMP not like", value, "imp");
            return (Criteria) this;
        }

        public Criteria andImpIn(List<String> values) {
            addCriterion("IMP in", values, "imp");
            return (Criteria) this;
        }

        public Criteria andImpNotIn(List<String> values) {
            addCriterion("IMP not in", values, "imp");
            return (Criteria) this;
        }

        public Criteria andImpBetween(String value1, String value2) {
            addCriterion("IMP between", value1, value2, "imp");
            return (Criteria) this;
        }

        public Criteria andImpNotBetween(String value1, String value2) {
            addCriterion("IMP not between", value1, value2, "imp");
            return (Criteria) this;
        }

        public Criteria andExpIsNull() {
            addCriterion("EXP is null");
            return (Criteria) this;
        }

        public Criteria andExpIsNotNull() {
            addCriterion("EXP is not null");
            return (Criteria) this;
        }

        public Criteria andExpEqualTo(String value) {
            addCriterion("EXP =", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpNotEqualTo(String value) {
            addCriterion("EXP <>", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpGreaterThan(String value) {
            addCriterion("EXP >", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpGreaterThanOrEqualTo(String value) {
            addCriterion("EXP >=", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpLessThan(String value) {
            addCriterion("EXP <", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpLessThanOrEqualTo(String value) {
            addCriterion("EXP <=", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpLike(String value) {
            addCriterion("EXP like", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpNotLike(String value) {
            addCriterion("EXP not like", value, "exp");
            return (Criteria) this;
        }

        public Criteria andExpIn(List<String> values) {
            addCriterion("EXP in", values, "exp");
            return (Criteria) this;
        }

        public Criteria andExpNotIn(List<String> values) {
            addCriterion("EXP not in", values, "exp");
            return (Criteria) this;
        }

        public Criteria andExpBetween(String value1, String value2) {
            addCriterion("EXP between", value1, value2, "exp");
            return (Criteria) this;
        }

        public Criteria andExpNotBetween(String value1, String value2) {
            addCriterion("EXP not between", value1, value2, "exp");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    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);
        }
    }
}