/*
*  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 SysRoleSQLBuilder {
    /**
     * 角色信息表 : 角色信息表
     * @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 SysRoleSQLBuilder() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @generated
     */
    protected SysRoleSQLBuilder(SysRoleSQLBuilder 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 andRoleidIsNull() {
            addCriterion("roleid is null");
            return (Criteria) this;
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /**
     * 角色信息表 : 角色信息表
     * @generated
     */
    public static class Criteria extends GeneratedCriteria {

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