/*
*  Copyright 2010 The YAPULAN Software Foundation
*
*  Licensed under the YAPULAN License, Version 2.0 (the "License");
*/

package com.miniframe.system.model;

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

/**
 * 机构表 : 机构表
 * @generated
 */
public class SysDepartmentSQLBuilder {
    /**
     * 机构表 : 机构表
     * @generated
     */
    protected String orderByClause;

    /**
     * 机构表 : 机构表
     * @generated
     */
    protected boolean distinct;

    /**
     * 机构表 : 机构表
     * @generated
     */
    protected boolean NoWait;

    /**
     * 机构表 : 机构表
     * @generated
     */
    protected boolean forUpdate;

    /**
     * 机构表 : 机构表
     * @generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * 机构表 : 机构表
     * @generated
     */
    private Integer oracleStart;

    /**
     * 机构表 : 机构表
     * @generated
     */
    private Integer oracleEnd;

    /**
     * 机构表 : 机构表
     * @generated
     */
    private Integer startOffSet;

    /**
     * 机构表 : 机构表
     * @generated
     */
    private Integer pageSize;

    /**
     * @generated
     */
    public SysDepartmentSQLBuilder() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @generated
     */
    protected SysDepartmentSQLBuilder(SysDepartmentSQLBuilder example) {
        this.orderByClause = example.orderByClause;
        this.oredCriteria = example.oredCriteria;
        this.distinct = example.distinct;
        this.forUpdate = example.forUpdate;
        this.NoWait = example.NoWait;
    }

    /**
     * 设置排序
     * @generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序
     * @generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置是否过滤重复
     * @generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 获取是否过滤重复
     * @generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 设置是否上锁是否不等待
     * @generated
     */
    public void setNoWait(boolean NoWait) {
        this.NoWait = NoWait;
    }

    /**
     * 设置是否上锁是否不等待
     * @generated
     */
    public boolean isNoWait() {
        return NoWait;
    }

    /**
     * 设置是否行锁定
     * @generated
     */
    public void setForUpdate(boolean forUpdate) {
        this.forUpdate = forUpdate;
    }

    /**
     * 获取是否行锁定
     * @generated
     */
    public boolean isForUpdate() {
        return forUpdate;
    }

    /**
     * @generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * @generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * 或
     * @generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

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

    /**
     * @generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除
     * @generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        forUpdate = false;
        NoWait = false;
    }

    /**
     * 设置开始行，从1开始
     * @generated
     */
    public void setOracleStart(Integer oracleStart) {
        this.oracleStart = oracleStart;
        this.startOffSet = this.oracleStart - 1;
        if(this.oracleEnd!=null){
            this.pageSize = this.oracleEnd - this.oracleStart + 1;
        }
    }

    /**
     * 获取开始行，从1开始
     * @generated
     */
    public Integer getOracleStart() {
        return oracleStart;
    }

    /**
     * 设置结束行
     * @generated
     */
    public void setOracleEnd(Integer oracleEnd) {
        if(this.oracleStart==null){
            	this.oracleStart =1;
            	this.startOffSet =0;
        }
        this.oracleEnd = oracleEnd;
        this.pageSize = this.oracleEnd - this.oracleStart + 1;
    }

    /**
     * 获取结束行
     * @generated
     */
    public Integer getOracleEnd() {
        return oracleEnd;
    }

    /**
     * 设置偏移量，从0开始
     * @generated
     */
    public void setStartOffSet(Integer startOffSet) {
        this.startOffSet = startOffSet;
        this.oracleStart = this.startOffSet + 1;
        if(this.pageSize!=null){
             this.oracleEnd = this.oracleStart - 1 + this.pageSize;
        }
    }

    /**
     * 获取偏移量，从0开始
     * @generated
     */
    public Integer getStartOffSet() {
        return startOffSet;
    }

    /**
     * 设置页尺寸
     * @generated
     */
    public void setPageSize(Integer pageSize) {
        if(this.oracleStart==null){
            	this.oracleStart =1;
            	this.startOffSet =0;
        }
        this.pageSize = pageSize;
        this.oracleEnd = this.pageSize + this.oracleStart - 1;
    }

    /**
     * 获取页尺寸
     * @generated
     */
    public Integer getPageSize() {
        return pageSize;
    }

    /**
     * 机构表 : 机构表
     * @generated
     */
    protected abstract static class GeneratedCriteria {
        /**
         * 机构表 : 机构表
         * @generated
         */
        protected List<String> criteriaWithoutValue;

        /**
         * 机构表 : 机构表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithSingleValue;

        /**
         * 机构表 : 机构表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithListValue;

        /**
         * 机构表 : 机构表
         * @generated
         */
        protected List<Map<String, Object>> criteriaWithBetweenValue;

        /**
         * @generated
         */
        protected GeneratedCriteria() {
            super();
            criteriaWithoutValue = new ArrayList<String>();
            criteriaWithSingleValue = new ArrayList<Map<String, Object>>();
            criteriaWithListValue = new ArrayList<Map<String, Object>>();
            criteriaWithBetweenValue = new ArrayList<Map<String, Object>>();
        }

        /**
         * 验证
         * @generated
         */
        public boolean isValid() {
            return criteriaWithoutValue.size() > 0
                || criteriaWithSingleValue.size() > 0
                || criteriaWithListValue.size() > 0
                || criteriaWithBetweenValue.size() > 0;
        }

        /**
         * @generated
         */
        public List<String> getCriteriaWithoutValue() {
            return criteriaWithoutValue;
        }

        /**
         * @generated
         */
        public void setCriteriaWithoutValue(List<String> criteriaWithoutValue) {
            this.criteriaWithoutValue = criteriaWithoutValue;
        }

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

        /**
         * @generated
         */
        public void setCriteriaWithSingleValue(List<Map<String, Object>> criteriaWithSingleValue) {
            this.criteriaWithSingleValue = criteriaWithSingleValue;
        }

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

        /**
         * @generated
         */
        public void setCriteriaWithListValue(List<Map<String, Object>> criteriaWithListValue) {
            this.criteriaWithListValue = criteriaWithListValue;
        }

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

        /**
         * @generated
         */
        public void setCriteriaWithBetweenValue(List<Map<String, Object>> criteriaWithBetweenValue) {
            this.criteriaWithBetweenValue = criteriaWithBetweenValue;
        }

        /**
         * @generated
         */
        public void whereSQL(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteriaWithoutValue.add(condition);
        }

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

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

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

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

        /**
         * @generated
         */
        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdIsNotNull() {
            addCriterion("id <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeIsNull() {
            addCriterion("deptcode is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeIsNotNull() {
            addCriterion("deptcode <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeEqualTo(String value) {
            addCriterion("deptcode =", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeNotEqualTo(String value) {
            addCriterion("deptcode <>", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeGreaterThan(String value) {
            addCriterion("deptcode >", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeGreaterThanOrEqualTo(String value) {
            addCriterion("deptcode >=", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeLessThan(String value) {
            addCriterion("deptcode <", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeLessThanOrEqualTo(String value) {
            addCriterion("deptcode <=", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeLike(String value) {
            addCriterion("deptcode like", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeNotLike(String value) {
            addCriterion("deptcode not like", value, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeIn(List<String> values) {
            addCriterion("deptcode in", values, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeNotIn(List<String> values) {
            addCriterion("deptcode not in", values, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeBetween(String value1, String value2) {
            addCriterion("deptcode between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptcodeNotBetween(String value1, String value2) {
            addCriterion("deptcode not between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameIsNull() {
            addCriterion("deptname is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameIsNotNull() {
            addCriterion("deptname <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameEqualTo(String value) {
            addCriterion("deptname =", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameNotEqualTo(String value) {
            addCriterion("deptname <>", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameGreaterThan(String value) {
            addCriterion("deptname >", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameGreaterThanOrEqualTo(String value) {
            addCriterion("deptname >=", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameLessThan(String value) {
            addCriterion("deptname <", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameLessThanOrEqualTo(String value) {
            addCriterion("deptname <=", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameLike(String value) {
            addCriterion("deptname like", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameNotLike(String value) {
            addCriterion("deptname not like", value, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameIn(List<String> values) {
            addCriterion("deptname in", values, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameNotIn(List<String> values) {
            addCriterion("deptname not in", values, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameBetween(String value1, String value2) {
            addCriterion("deptname between", value1, value2, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptnameNotBetween(String value1, String value2) {
            addCriterion("deptname not between", value1, value2, "deptname");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentIsNull() {
            addCriterion("parent is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentIsNotNull() {
            addCriterion("parent <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentEqualTo(String value) {
            addCriterion("parent =", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentNotEqualTo(String value) {
            addCriterion("parent <>", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentGreaterThan(String value) {
            addCriterion("parent >", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentGreaterThanOrEqualTo(String value) {
            addCriterion("parent >=", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentLessThan(String value) {
            addCriterion("parent <", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentLessThanOrEqualTo(String value) {
            addCriterion("parent <=", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentLike(String value) {
            addCriterion("parent like", value, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentNotLike(String value) {
            addCriterion("parent not like", value, "parent");
            return (Criteria) this;
        }

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

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

        /**
         * @generated
         */
        public Criteria andParentBetween(String value1, String value2) {
            addCriterion("parent between", value1, value2, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andParentNotBetween(String value1, String value2) {
            addCriterion("parent not between", value1, value2, "parent");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeIsNull() {
            addCriterion("depttype is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeIsNotNull() {
            addCriterion("depttype <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeEqualTo(String value) {
            addCriterion("depttype =", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeNotEqualTo(String value) {
            addCriterion("depttype <>", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeGreaterThan(String value) {
            addCriterion("depttype >", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeGreaterThanOrEqualTo(String value) {
            addCriterion("depttype >=", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeLessThan(String value) {
            addCriterion("depttype <", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeLessThanOrEqualTo(String value) {
            addCriterion("depttype <=", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeLike(String value) {
            addCriterion("depttype like", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeNotLike(String value) {
            addCriterion("depttype not like", value, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeIn(List<String> values) {
            addCriterion("depttype in", values, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeNotIn(List<String> values) {
            addCriterion("depttype not in", values, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeBetween(String value1, String value2) {
            addCriterion("depttype between", value1, value2, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttypeNotBetween(String value1, String value2) {
            addCriterion("depttype not between", value1, value2, "depttype");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnIsNull() {
            addCriterion("deptconn is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnIsNotNull() {
            addCriterion("deptconn <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnEqualTo(String value) {
            addCriterion("deptconn =", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnNotEqualTo(String value) {
            addCriterion("deptconn <>", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnGreaterThan(String value) {
            addCriterion("deptconn >", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnGreaterThanOrEqualTo(String value) {
            addCriterion("deptconn >=", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnLessThan(String value) {
            addCriterion("deptconn <", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnLessThanOrEqualTo(String value) {
            addCriterion("deptconn <=", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnLike(String value) {
            addCriterion("deptconn like", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnNotLike(String value) {
            addCriterion("deptconn not like", value, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnIn(List<String> values) {
            addCriterion("deptconn in", values, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnNotIn(List<String> values) {
            addCriterion("deptconn not in", values, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnBetween(String value1, String value2) {
            addCriterion("deptconn between", value1, value2, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptconnNotBetween(String value1, String value2) {
            addCriterion("deptconn not between", value1, value2, "deptconn");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrIsNull() {
            addCriterion("deptaddr is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrIsNotNull() {
            addCriterion("deptaddr <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrEqualTo(String value) {
            addCriterion("deptaddr =", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrNotEqualTo(String value) {
            addCriterion("deptaddr <>", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrGreaterThan(String value) {
            addCriterion("deptaddr >", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrGreaterThanOrEqualTo(String value) {
            addCriterion("deptaddr >=", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrLessThan(String value) {
            addCriterion("deptaddr <", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrLessThanOrEqualTo(String value) {
            addCriterion("deptaddr <=", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrLike(String value) {
            addCriterion("deptaddr like", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrNotLike(String value) {
            addCriterion("deptaddr not like", value, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrIn(List<String> values) {
            addCriterion("deptaddr in", values, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrNotIn(List<String> values) {
            addCriterion("deptaddr not in", values, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrBetween(String value1, String value2) {
            addCriterion("deptaddr between", value1, value2, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDeptaddrNotBetween(String value1, String value2) {
            addCriterion("deptaddr not between", value1, value2, "deptaddr");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellIsNull() {
            addCriterion("depttell is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellIsNotNull() {
            addCriterion("depttell <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellEqualTo(String value) {
            addCriterion("depttell =", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellNotEqualTo(String value) {
            addCriterion("depttell <>", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellGreaterThan(String value) {
            addCriterion("depttell >", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellGreaterThanOrEqualTo(String value) {
            addCriterion("depttell >=", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellLessThan(String value) {
            addCriterion("depttell <", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellLessThanOrEqualTo(String value) {
            addCriterion("depttell <=", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellLike(String value) {
            addCriterion("depttell like", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellNotLike(String value) {
            addCriterion("depttell not like", value, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellIn(List<String> values) {
            addCriterion("depttell in", values, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellNotIn(List<String> values) {
            addCriterion("depttell not in", values, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellBetween(String value1, String value2) {
            addCriterion("depttell between", value1, value2, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andDepttellNotBetween(String value1, String value2) {
            addCriterion("depttell not between", value1, value2, "depttell");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksIsNull() {
            addCriterion("remarks is null");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksIsNotNull() {
            addCriterion("remarks <> ''");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksEqualTo(String value) {
            addCriterion("remarks =", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("remarks <>", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("remarks >", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("remarks >=", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksLessThan(String value) {
            addCriterion("remarks <", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("remarks <=", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksLike(String value) {
            addCriterion("remarks like", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksNotLike(String value) {
            addCriterion("remarks not like", value, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksIn(List<String> values) {
            addCriterion("remarks in", values, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("remarks not in", values, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("remarks between", value1, value2, "remarks");
            return (Criteria) this;
        }

        /**
         * @generated
         */
        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("remarks not between", value1, value2, "remarks");
            return (Criteria) this;
        }
    }

    /**
     * 机构表 : 机构表
     * @generated
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }
}