package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DVentdoorSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DVentdoorSQLBuilder() { 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 andIdIsNull() { addCriterion("id is null"); return (Criteria) this; } public Criteria andIdIsNotNull() { addCriterion("id is not null"); return (Criteria) this; } public Criteria andIdEqualTo(Integer value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Integer value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Integer value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Integer value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Integer value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Integer value) { addCriterion("id <=", value, "id"); return (Criteria) this; } public Criteria andIdIn(List values) { addCriterion("id in", values, "id"); return (Criteria) this; } public Criteria andIdNotIn(List values) { addCriterion("id not in", values, "id"); return (Criteria) this; } public Criteria andIdBetween(Integer value1, Integer value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Integer value1, Integer value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andPidIsNull() { addCriterion("pid is null"); return (Criteria) this; } public Criteria andPidIsNotNull() { addCriterion("pid is not null"); return (Criteria) this; } public Criteria andPidEqualTo(Integer value) { addCriterion("pid =", value, "pid"); return (Criteria) this; } public Criteria andPidNotEqualTo(Integer value) { addCriterion("pid <>", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThan(Integer value) { addCriterion("pid >", value, "pid"); return (Criteria) this; } public Criteria andPidGreaterThanOrEqualTo(Integer value) { addCriterion("pid >=", value, "pid"); return (Criteria) this; } public Criteria andPidLessThan(Integer value) { addCriterion("pid <", value, "pid"); return (Criteria) this; } public Criteria andPidLessThanOrEqualTo(Integer value) { addCriterion("pid <=", value, "pid"); return (Criteria) this; } public Criteria andPidIn(List values) { addCriterion("pid in", values, "pid"); return (Criteria) this; } public Criteria andPidNotIn(List values) { addCriterion("pid not in", values, "pid"); return (Criteria) this; } public Criteria andPidBetween(Integer value1, Integer value2) { addCriterion("pid between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPidNotBetween(Integer value1, Integer value2) { addCriterion("pid not between", value1, value2, "pid"); return (Criteria) this; } public Criteria andPnameIsNull() { addCriterion("pname is null"); return (Criteria) this; } public Criteria andPnameIsNotNull() { addCriterion("pname is not null"); return (Criteria) this; } public Criteria andPnameEqualTo(String value) { addCriterion("pname =", value, "pname"); return (Criteria) this; } public Criteria andPnameNotEqualTo(String value) { addCriterion("pname <>", value, "pname"); return (Criteria) this; } public Criteria andPnameGreaterThan(String value) { addCriterion("pname >", value, "pname"); return (Criteria) this; } public Criteria andPnameGreaterThanOrEqualTo(String value) { addCriterion("pname >=", value, "pname"); return (Criteria) this; } public Criteria andPnameLessThan(String value) { addCriterion("pname <", value, "pname"); return (Criteria) this; } public Criteria andPnameLessThanOrEqualTo(String value) { addCriterion("pname <=", value, "pname"); return (Criteria) this; } public Criteria andPnameLike(String value) { addCriterion("pname like", value, "pname"); return (Criteria) this; } public Criteria andPnameNotLike(String value) { addCriterion("pname not like", value, "pname"); return (Criteria) this; } public Criteria andPnameIn(List values) { addCriterion("pname in", values, "pname"); return (Criteria) this; } public Criteria andPnameNotIn(List values) { addCriterion("pname not in", values, "pname"); return (Criteria) this; } public Criteria andPnameBetween(String value1, String value2) { addCriterion("pname between", value1, value2, "pname"); return (Criteria) this; } public Criteria andPnameNotBetween(String value1, String value2) { addCriterion("pname not between", value1, value2, "pname"); return (Criteria) this; } public Criteria andPcodeIsNull() { addCriterion("pcode is null"); return (Criteria) this; } public Criteria andPcodeIsNotNull() { addCriterion("pcode is not null"); return (Criteria) this; } public Criteria andPcodeEqualTo(String value) { addCriterion("pcode =", value, "pcode"); return (Criteria) this; } public Criteria andPcodeNotEqualTo(String value) { addCriterion("pcode <>", value, "pcode"); return (Criteria) this; } public Criteria andPcodeGreaterThan(String value) { addCriterion("pcode >", value, "pcode"); return (Criteria) this; } public Criteria andPcodeGreaterThanOrEqualTo(String value) { addCriterion("pcode >=", value, "pcode"); return (Criteria) this; } public Criteria andPcodeLessThan(String value) { addCriterion("pcode <", value, "pcode"); return (Criteria) this; } public Criteria andPcodeLessThanOrEqualTo(String value) { addCriterion("pcode <=", value, "pcode"); return (Criteria) this; } public Criteria andPcodeLike(String value) { addCriterion("pcode like", value, "pcode"); return (Criteria) this; } public Criteria andPcodeNotLike(String value) { addCriterion("pcode not like", value, "pcode"); return (Criteria) this; } public Criteria andPcodeIn(List values) { addCriterion("pcode in", values, "pcode"); return (Criteria) this; } public Criteria andPcodeNotIn(List values) { addCriterion("pcode not in", values, "pcode"); return (Criteria) this; } public Criteria andPcodeBetween(String value1, String value2) { addCriterion("pcode between", value1, value2, "pcode"); return (Criteria) this; } public Criteria andPcodeNotBetween(String value1, String value2) { addCriterion("pcode not between", value1, value2, "pcode"); return (Criteria) this; } public Criteria andAidIsNull() { addCriterion("aid is null"); return (Criteria) this; } public Criteria andAidIsNotNull() { addCriterion("aid is not null"); return (Criteria) this; } public Criteria andAidEqualTo(Integer value) { addCriterion("aid =", value, "aid"); return (Criteria) this; } public Criteria andAidNotEqualTo(Integer value) { addCriterion("aid <>", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThan(Integer value) { addCriterion("aid >", value, "aid"); return (Criteria) this; } public Criteria andAidGreaterThanOrEqualTo(Integer value) { addCriterion("aid >=", value, "aid"); return (Criteria) this; } public Criteria andAidLessThan(Integer value) { addCriterion("aid <", value, "aid"); return (Criteria) this; } public Criteria andAidLessThanOrEqualTo(Integer value) { addCriterion("aid <=", value, "aid"); return (Criteria) this; } public Criteria andAidIn(List values) { addCriterion("aid in", values, "aid"); return (Criteria) this; } public Criteria andAidNotIn(List values) { addCriterion("aid not in", values, "aid"); return (Criteria) this; } public Criteria andAidBetween(Integer value1, Integer value2) { addCriterion("aid between", value1, value2, "aid"); return (Criteria) this; } public Criteria andAidNotBetween(Integer value1, Integer value2) { addCriterion("aid not between", value1, value2, "aid"); return (Criteria) this; } public Criteria andDragcoeIsNull() { addCriterion("dragcoe is null"); return (Criteria) this; } public Criteria andDragcoeIsNotNull() { addCriterion("dragcoe is not null"); return (Criteria) this; } public Criteria andDragcoeEqualTo(Float value) { addCriterion("dragcoe =", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeNotEqualTo(Float value) { addCriterion("dragcoe <>", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeGreaterThan(Float value) { addCriterion("dragcoe >", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeGreaterThanOrEqualTo(Float value) { addCriterion("dragcoe >=", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeLessThan(Float value) { addCriterion("dragcoe <", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeLessThanOrEqualTo(Float value) { addCriterion("dragcoe <=", value, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeIn(List values) { addCriterion("dragcoe in", values, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeNotIn(List values) { addCriterion("dragcoe not in", values, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeBetween(Float value1, Float value2) { addCriterion("dragcoe between", value1, value2, "dragcoe"); return (Criteria) this; } public Criteria andDragcoeNotBetween(Float value1, Float value2) { addCriterion("dragcoe not between", value1, value2, "dragcoe"); return (Criteria) this; } public Criteria andOnoffIsNull() { addCriterion("onoff is null"); return (Criteria) this; } public Criteria andOnoffIsNotNull() { addCriterion("onoff is not null"); return (Criteria) this; } public Criteria andOnoffEqualTo(Integer value) { addCriterion("onoff =", value, "onoff"); return (Criteria) this; } public Criteria andOnoffNotEqualTo(Integer value) { addCriterion("onoff <>", value, "onoff"); return (Criteria) this; } public Criteria andOnoffGreaterThan(Integer value) { addCriterion("onoff >", value, "onoff"); return (Criteria) this; } public Criteria andOnoffGreaterThanOrEqualTo(Integer value) { addCriterion("onoff >=", value, "onoff"); return (Criteria) this; } public Criteria andOnoffLessThan(Integer value) { addCriterion("onoff <", value, "onoff"); return (Criteria) this; } public Criteria andOnoffLessThanOrEqualTo(Integer value) { addCriterion("onoff <=", value, "onoff"); return (Criteria) this; } public Criteria andOnoffIn(List values) { addCriterion("onoff in", values, "onoff"); return (Criteria) this; } public Criteria andOnoffNotIn(List values) { addCriterion("onoff not in", values, "onoff"); return (Criteria) this; } public Criteria andOnoffBetween(Integer value1, Integer value2) { addCriterion("onoff between", value1, value2, "onoff"); return (Criteria) this; } public Criteria andOnoffNotBetween(Integer value1, Integer value2) { addCriterion("onoff not between", value1, value2, "onoff"); return (Criteria) this; } public Criteria andNameIsNull() { addCriterion("name is null"); return (Criteria) this; } public Criteria andNameIsNotNull() { addCriterion("name is not null"); return (Criteria) this; } public Criteria andNameEqualTo(String value) { addCriterion("name =", value, "name"); return (Criteria) this; } public Criteria andNameNotEqualTo(String value) { addCriterion("name <>", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThan(String value) { addCriterion("name >", value, "name"); return (Criteria) this; } public Criteria andNameGreaterThanOrEqualTo(String value) { addCriterion("name >=", value, "name"); return (Criteria) this; } public Criteria andNameLessThan(String value) { addCriterion("name <", value, "name"); return (Criteria) this; } public Criteria andNameLessThanOrEqualTo(String value) { addCriterion("name <=", value, "name"); return (Criteria) this; } public Criteria andNameLike(String value) { addCriterion("name like", value, "name"); return (Criteria) this; } public Criteria andNameNotLike(String value) { addCriterion("name not like", value, "name"); return (Criteria) this; } public Criteria andNameIn(List values) { addCriterion("name in", values, "name"); return (Criteria) this; } public Criteria andNameNotIn(List values) { addCriterion("name not in", values, "name"); return (Criteria) this; } public Criteria andNameBetween(String value1, String value2) { addCriterion("name between", value1, value2, "name"); return (Criteria) this; } public Criteria andNameNotBetween(String value1, String value2) { addCriterion("name not between", value1, value2, "name"); return (Criteria) this; } public Criteria andSiteIsNull() { addCriterion("site is null"); return (Criteria) this; } public Criteria andSiteIsNotNull() { addCriterion("site is not null"); return (Criteria) this; } public Criteria andSiteEqualTo(Float value) { addCriterion("site =", value, "site"); return (Criteria) this; } public Criteria andSiteNotEqualTo(Float value) { addCriterion("site <>", value, "site"); return (Criteria) this; } public Criteria andSiteGreaterThan(Float value) { addCriterion("site >", value, "site"); return (Criteria) this; } public Criteria andSiteGreaterThanOrEqualTo(Float value) { addCriterion("site >=", value, "site"); return (Criteria) this; } public Criteria andSiteLessThan(Float value) { addCriterion("site <", value, "site"); return (Criteria) this; } public Criteria andSiteLessThanOrEqualTo(Float value) { addCriterion("site <=", value, "site"); return (Criteria) this; } public Criteria andSiteIn(List values) { addCriterion("site in", values, "site"); return (Criteria) this; } public Criteria andSiteNotIn(List values) { addCriterion("site not in", values, "site"); return (Criteria) this; } public Criteria andSiteBetween(Float value1, Float value2) { addCriterion("site between", value1, value2, "site"); return (Criteria) this; } public Criteria andSiteNotBetween(Float value1, Float value2) { addCriterion("site not between", value1, value2, "site"); return (Criteria) this; } public Criteria andCodeIsNull() { addCriterion("code is null"); return (Criteria) this; } public Criteria andCodeIsNotNull() { addCriterion("code is not null"); return (Criteria) this; } public Criteria andCodeEqualTo(String value) { addCriterion("code =", value, "code"); return (Criteria) this; } public Criteria andCodeNotEqualTo(String value) { addCriterion("code <>", value, "code"); return (Criteria) this; } public Criteria andCodeGreaterThan(String value) { addCriterion("code >", value, "code"); return (Criteria) this; } public Criteria andCodeGreaterThanOrEqualTo(String value) { addCriterion("code >=", value, "code"); return (Criteria) this; } public Criteria andCodeLessThan(String value) { addCriterion("code <", value, "code"); return (Criteria) this; } public Criteria andCodeLessThanOrEqualTo(String value) { addCriterion("code <=", value, "code"); return (Criteria) this; } public Criteria andCodeLike(String value) { addCriterion("code like", value, "code"); return (Criteria) this; } public Criteria andCodeNotLike(String value) { addCriterion("code not like", value, "code"); return (Criteria) this; } public Criteria andCodeIn(List values) { addCriterion("code in", values, "code"); return (Criteria) this; } public Criteria andCodeNotIn(List values) { addCriterion("code not in", values, "code"); return (Criteria) this; } public Criteria andCodeBetween(String value1, String value2) { addCriterion("code between", value1, value2, "code"); return (Criteria) this; } public Criteria andCodeNotBetween(String value1, String value2) { addCriterion("code not between", value1, value2, "code"); return (Criteria) this; } public Criteria andDoorbaseidIsNull() { addCriterion("doorbaseid is null"); return (Criteria) this; } public Criteria andDoorbaseidIsNotNull() { addCriterion("doorbaseid is not null"); return (Criteria) this; } public Criteria andDoorbaseidEqualTo(Integer value) { addCriterion("doorbaseid =", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidNotEqualTo(Integer value) { addCriterion("doorbaseid <>", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidGreaterThan(Integer value) { addCriterion("doorbaseid >", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidGreaterThanOrEqualTo(Integer value) { addCriterion("doorbaseid >=", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidLessThan(Integer value) { addCriterion("doorbaseid <", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidLessThanOrEqualTo(Integer value) { addCriterion("doorbaseid <=", value, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidIn(List values) { addCriterion("doorbaseid in", values, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidNotIn(List values) { addCriterion("doorbaseid not in", values, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidBetween(Integer value1, Integer value2) { addCriterion("doorbaseid between", value1, value2, "doorbaseid"); return (Criteria) this; } public Criteria andDoorbaseidNotBetween(Integer value1, Integer value2) { addCriterion("doorbaseid not between", value1, value2, "doorbaseid"); return (Criteria) this; } public Criteria andSiteremarkIsNull() { addCriterion("siteremark is null"); return (Criteria) this; } public Criteria andSiteremarkIsNotNull() { addCriterion("siteremark is not null"); return (Criteria) this; } public Criteria andSiteremarkEqualTo(String value) { addCriterion("siteremark =", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkNotEqualTo(String value) { addCriterion("siteremark <>", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkGreaterThan(String value) { addCriterion("siteremark >", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkGreaterThanOrEqualTo(String value) { addCriterion("siteremark >=", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkLessThan(String value) { addCriterion("siteremark <", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkLessThanOrEqualTo(String value) { addCriterion("siteremark <=", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkLike(String value) { addCriterion("siteremark like", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkNotLike(String value) { addCriterion("siteremark not like", value, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkIn(List values) { addCriterion("siteremark in", values, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkNotIn(List values) { addCriterion("siteremark not in", values, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkBetween(String value1, String value2) { addCriterion("siteremark between", value1, value2, "siteremark"); return (Criteria) this; } public Criteria andSiteremarkNotBetween(String value1, String value2) { addCriterion("siteremark not between", value1, value2, "siteremark"); 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); } } }