package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class SysDepartmentSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public SysDepartmentSQLBuilder() { oredCriteria = new ArrayList(); } 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 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; } protected abstract static class GeneratedCriteria { protected List criteria; protected GeneratedCriteria() { super(); criteria = new ArrayList(); } public boolean isValid() { return criteria.size() > 0; } public List getAllCriteria() { return criteria; } public List 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 andDeptcodeIsNull() { addCriterion("deptcode is null"); return (Criteria) this; } public Criteria andDeptcodeIsNotNull() { addCriterion("deptcode is not null"); return (Criteria) this; } public Criteria andDeptcodeEqualTo(String value) { addCriterion("deptcode =", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeNotEqualTo(String value) { addCriterion("deptcode <>", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeGreaterThan(String value) { addCriterion("deptcode >", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeGreaterThanOrEqualTo(String value) { addCriterion("deptcode >=", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeLessThan(String value) { addCriterion("deptcode <", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeLessThanOrEqualTo(String value) { addCriterion("deptcode <=", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeLike(String value) { addCriterion("deptcode like", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeNotLike(String value) { addCriterion("deptcode not like", value, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeIn(List values) { addCriterion("deptcode in", values, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeNotIn(List values) { addCriterion("deptcode not in", values, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeBetween(String value1, String value2) { addCriterion("deptcode between", value1, value2, "deptcode"); return (Criteria) this; } public Criteria andDeptcodeNotBetween(String value1, String value2) { addCriterion("deptcode not between", value1, value2, "deptcode"); return (Criteria) this; } public Criteria andDeptnameIsNull() { addCriterion("deptname is null"); return (Criteria) this; } public Criteria andDeptnameIsNotNull() { addCriterion("deptname is not null"); return (Criteria) this; } public Criteria andDeptnameEqualTo(String value) { addCriterion("deptname =", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameNotEqualTo(String value) { addCriterion("deptname <>", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameGreaterThan(String value) { addCriterion("deptname >", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameGreaterThanOrEqualTo(String value) { addCriterion("deptname >=", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameLessThan(String value) { addCriterion("deptname <", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameLessThanOrEqualTo(String value) { addCriterion("deptname <=", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameLike(String value) { addCriterion("deptname like", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameNotLike(String value) { addCriterion("deptname not like", value, "deptname"); return (Criteria) this; } public Criteria andDeptnameIn(List values) { addCriterion("deptname in", values, "deptname"); return (Criteria) this; } public Criteria andDeptnameNotIn(List values) { addCriterion("deptname not in", values, "deptname"); return (Criteria) this; } public Criteria andDeptnameBetween(String value1, String value2) { addCriterion("deptname between", value1, value2, "deptname"); return (Criteria) this; } public Criteria andDeptnameNotBetween(String value1, String value2) { addCriterion("deptname not between", value1, value2, "deptname"); return (Criteria) this; } public Criteria andParentIsNull() { addCriterion("parent is null"); return (Criteria) this; } public Criteria andParentIsNotNull() { addCriterion("parent is not null"); return (Criteria) this; } public Criteria andParentEqualTo(String value) { addCriterion("parent =", value, "parent"); return (Criteria) this; } public Criteria andParentNotEqualTo(String value) { addCriterion("parent <>", value, "parent"); return (Criteria) this; } public Criteria andParentGreaterThan(String value) { addCriterion("parent >", value, "parent"); return (Criteria) this; } public Criteria andParentGreaterThanOrEqualTo(String value) { addCriterion("parent >=", value, "parent"); return (Criteria) this; } public Criteria andParentLessThan(String value) { addCriterion("parent <", value, "parent"); return (Criteria) this; } public Criteria andParentLessThanOrEqualTo(String value) { addCriterion("parent <=", value, "parent"); return (Criteria) this; } public Criteria andParentLike(String value) { addCriterion("parent like", value, "parent"); return (Criteria) this; } public Criteria andParentNotLike(String value) { addCriterion("parent not like", value, "parent"); return (Criteria) this; } public Criteria andParentIn(List values) { addCriterion("parent in", values, "parent"); return (Criteria) this; } public Criteria andParentNotIn(List values) { addCriterion("parent not in", values, "parent"); return (Criteria) this; } public Criteria andParentBetween(String value1, String value2) { addCriterion("parent between", value1, value2, "parent"); return (Criteria) this; } public Criteria andParentNotBetween(String value1, String value2) { addCriterion("parent not between", value1, value2, "parent"); return (Criteria) this; } public Criteria andDepttypeIsNull() { addCriterion("depttype is null"); return (Criteria) this; } public Criteria andDepttypeIsNotNull() { addCriterion("depttype is not null"); return (Criteria) this; } public Criteria andDepttypeEqualTo(String value) { addCriterion("depttype =", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeNotEqualTo(String value) { addCriterion("depttype <>", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeGreaterThan(String value) { addCriterion("depttype >", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeGreaterThanOrEqualTo(String value) { addCriterion("depttype >=", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeLessThan(String value) { addCriterion("depttype <", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeLessThanOrEqualTo(String value) { addCriterion("depttype <=", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeLike(String value) { addCriterion("depttype like", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeNotLike(String value) { addCriterion("depttype not like", value, "depttype"); return (Criteria) this; } public Criteria andDepttypeIn(List values) { addCriterion("depttype in", values, "depttype"); return (Criteria) this; } public Criteria andDepttypeNotIn(List values) { addCriterion("depttype not in", values, "depttype"); return (Criteria) this; } public Criteria andDepttypeBetween(String value1, String value2) { addCriterion("depttype between", value1, value2, "depttype"); return (Criteria) this; } public Criteria andDepttypeNotBetween(String value1, String value2) { addCriterion("depttype not between", value1, value2, "depttype"); return (Criteria) this; } public Criteria andDeptconnIsNull() { addCriterion("deptconn is null"); return (Criteria) this; } public Criteria andDeptconnIsNotNull() { addCriterion("deptconn is not null"); return (Criteria) this; } public Criteria andDeptconnEqualTo(String value) { addCriterion("deptconn =", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnNotEqualTo(String value) { addCriterion("deptconn <>", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnGreaterThan(String value) { addCriterion("deptconn >", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnGreaterThanOrEqualTo(String value) { addCriterion("deptconn >=", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnLessThan(String value) { addCriterion("deptconn <", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnLessThanOrEqualTo(String value) { addCriterion("deptconn <=", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnLike(String value) { addCriterion("deptconn like", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnNotLike(String value) { addCriterion("deptconn not like", value, "deptconn"); return (Criteria) this; } public Criteria andDeptconnIn(List values) { addCriterion("deptconn in", values, "deptconn"); return (Criteria) this; } public Criteria andDeptconnNotIn(List values) { addCriterion("deptconn not in", values, "deptconn"); return (Criteria) this; } public Criteria andDeptconnBetween(String value1, String value2) { addCriterion("deptconn between", value1, value2, "deptconn"); return (Criteria) this; } public Criteria andDeptconnNotBetween(String value1, String value2) { addCriterion("deptconn not between", value1, value2, "deptconn"); return (Criteria) this; } public Criteria andDeptaddrIsNull() { addCriterion("deptaddr is null"); return (Criteria) this; } public Criteria andDeptaddrIsNotNull() { addCriterion("deptaddr is not null"); return (Criteria) this; } public Criteria andDeptaddrEqualTo(String value) { addCriterion("deptaddr =", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrNotEqualTo(String value) { addCriterion("deptaddr <>", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrGreaterThan(String value) { addCriterion("deptaddr >", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrGreaterThanOrEqualTo(String value) { addCriterion("deptaddr >=", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrLessThan(String value) { addCriterion("deptaddr <", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrLessThanOrEqualTo(String value) { addCriterion("deptaddr <=", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrLike(String value) { addCriterion("deptaddr like", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrNotLike(String value) { addCriterion("deptaddr not like", value, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrIn(List values) { addCriterion("deptaddr in", values, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrNotIn(List values) { addCriterion("deptaddr not in", values, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrBetween(String value1, String value2) { addCriterion("deptaddr between", value1, value2, "deptaddr"); return (Criteria) this; } public Criteria andDeptaddrNotBetween(String value1, String value2) { addCriterion("deptaddr not between", value1, value2, "deptaddr"); return (Criteria) this; } public Criteria andDepttellIsNull() { addCriterion("depttell is null"); return (Criteria) this; } public Criteria andDepttellIsNotNull() { addCriterion("depttell is not null"); return (Criteria) this; } public Criteria andDepttellEqualTo(String value) { addCriterion("depttell =", value, "depttell"); return (Criteria) this; } public Criteria andDepttellNotEqualTo(String value) { addCriterion("depttell <>", value, "depttell"); return (Criteria) this; } public Criteria andDepttellGreaterThan(String value) { addCriterion("depttell >", value, "depttell"); return (Criteria) this; } public Criteria andDepttellGreaterThanOrEqualTo(String value) { addCriterion("depttell >=", value, "depttell"); return (Criteria) this; } public Criteria andDepttellLessThan(String value) { addCriterion("depttell <", value, "depttell"); return (Criteria) this; } public Criteria andDepttellLessThanOrEqualTo(String value) { addCriterion("depttell <=", value, "depttell"); return (Criteria) this; } public Criteria andDepttellLike(String value) { addCriterion("depttell like", value, "depttell"); return (Criteria) this; } public Criteria andDepttellNotLike(String value) { addCriterion("depttell not like", value, "depttell"); return (Criteria) this; } public Criteria andDepttellIn(List values) { addCriterion("depttell in", values, "depttell"); return (Criteria) this; } public Criteria andDepttellNotIn(List values) { addCriterion("depttell not in", values, "depttell"); return (Criteria) this; } public Criteria andDepttellBetween(String value1, String value2) { addCriterion("depttell between", value1, value2, "depttell"); return (Criteria) this; } public Criteria andDepttellNotBetween(String value1, String value2) { addCriterion("depttell not between", value1, value2, "depttell"); return (Criteria) this; } public Criteria andRemarksIsNull() { addCriterion("remarks is null"); return (Criteria) this; } public Criteria andRemarksIsNotNull() { addCriterion("remarks is not null"); return (Criteria) this; } public Criteria andRemarksEqualTo(String value) { addCriterion("remarks =", value, "remarks"); return (Criteria) this; } public Criteria andRemarksNotEqualTo(String value) { addCriterion("remarks <>", value, "remarks"); return (Criteria) this; } public Criteria andRemarksGreaterThan(String value) { addCriterion("remarks >", value, "remarks"); return (Criteria) this; } public Criteria andRemarksGreaterThanOrEqualTo(String value) { addCriterion("remarks >=", value, "remarks"); return (Criteria) this; } public Criteria andRemarksLessThan(String value) { addCriterion("remarks <", value, "remarks"); return (Criteria) this; } public Criteria andRemarksLessThanOrEqualTo(String value) { addCriterion("remarks <=", value, "remarks"); return (Criteria) this; } public Criteria andRemarksLike(String value) { addCriterion("remarks like", value, "remarks"); return (Criteria) this; } public Criteria andRemarksNotLike(String value) { addCriterion("remarks not like", value, "remarks"); return (Criteria) this; } public Criteria andRemarksIn(List values) { addCriterion("remarks in", values, "remarks"); return (Criteria) this; } public Criteria andRemarksNotIn(List values) { addCriterion("remarks not in", values, "remarks"); return (Criteria) this; } public Criteria andRemarksBetween(String value1, String value2) { addCriterion("remarks between", value1, value2, "remarks"); return (Criteria) this; } public Criteria andRemarksNotBetween(String value1, String value2) { addCriterion("remarks not between", value1, value2, "remarks"); return (Criteria) this; } public Criteria andEnabledelIsNull() { addCriterion("enabledel is null"); return (Criteria) this; } public Criteria andEnabledelIsNotNull() { addCriterion("enabledel is not null"); return (Criteria) this; } public Criteria andEnabledelEqualTo(String value) { addCriterion("enabledel =", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelNotEqualTo(String value) { addCriterion("enabledel <>", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelGreaterThan(String value) { addCriterion("enabledel >", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelGreaterThanOrEqualTo(String value) { addCriterion("enabledel >=", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelLessThan(String value) { addCriterion("enabledel <", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelLessThanOrEqualTo(String value) { addCriterion("enabledel <=", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelLike(String value) { addCriterion("enabledel like", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelNotLike(String value) { addCriterion("enabledel not like", value, "enabledel"); return (Criteria) this; } public Criteria andEnabledelIn(List values) { addCriterion("enabledel in", values, "enabledel"); return (Criteria) this; } public Criteria andEnabledelNotIn(List values) { addCriterion("enabledel not in", values, "enabledel"); return (Criteria) this; } public Criteria andEnabledelBetween(String value1, String value2) { addCriterion("enabledel between", value1, value2, "enabledel"); return (Criteria) this; } public Criteria andEnabledelNotBetween(String value1, String value2) { addCriterion("enabledel not between", value1, value2, "enabledel"); return (Criteria) this; } public Criteria andDeptfuncIsNull() { addCriterion("deptfunc is null"); return (Criteria) this; } public Criteria andDeptfuncIsNotNull() { addCriterion("deptfunc is not null"); return (Criteria) this; } public Criteria andDeptfuncEqualTo(String value) { addCriterion("deptfunc =", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncNotEqualTo(String value) { addCriterion("deptfunc <>", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncGreaterThan(String value) { addCriterion("deptfunc >", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncGreaterThanOrEqualTo(String value) { addCriterion("deptfunc >=", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncLessThan(String value) { addCriterion("deptfunc <", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncLessThanOrEqualTo(String value) { addCriterion("deptfunc <=", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncLike(String value) { addCriterion("deptfunc like", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncNotLike(String value) { addCriterion("deptfunc not like", value, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncIn(List values) { addCriterion("deptfunc in", values, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncNotIn(List values) { addCriterion("deptfunc not in", values, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncBetween(String value1, String value2) { addCriterion("deptfunc between", value1, value2, "deptfunc"); return (Criteria) this; } public Criteria andDeptfuncNotBetween(String value1, String value2) { addCriterion("deptfunc not between", value1, value2, "deptfunc"); 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); } } }