package com.miniframe.model.system; import java.util.ArrayList; import java.util.List; public class DGasSQLBuilder { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public DGasSQLBuilder() { 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 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 andGfidIsNull() { addCriterion("gfid is null"); return (Criteria) this; } public Criteria andGfidIsNotNull() { addCriterion("gfid is not null"); return (Criteria) this; } public Criteria andGfidEqualTo(String value) { addCriterion("gfid =", value, "gfid"); return (Criteria) this; } public Criteria andGfidNotEqualTo(String value) { addCriterion("gfid <>", value, "gfid"); return (Criteria) this; } public Criteria andGfidGreaterThan(String value) { addCriterion("gfid >", value, "gfid"); return (Criteria) this; } public Criteria andGfidGreaterThanOrEqualTo(String value) { addCriterion("gfid >=", value, "gfid"); return (Criteria) this; } public Criteria andGfidLessThan(String value) { addCriterion("gfid <", value, "gfid"); return (Criteria) this; } public Criteria andGfidLessThanOrEqualTo(String value) { addCriterion("gfid <=", value, "gfid"); return (Criteria) this; } public Criteria andGfidLike(String value) { addCriterion("gfid like", value, "gfid"); return (Criteria) this; } public Criteria andGfidNotLike(String value) { addCriterion("gfid not like", value, "gfid"); return (Criteria) this; } public Criteria andGfidIn(List values) { addCriterion("gfid in", values, "gfid"); return (Criteria) this; } public Criteria andGfidNotIn(List values) { addCriterion("gfid not in", values, "gfid"); return (Criteria) this; } public Criteria andGfidBetween(String value1, String value2) { addCriterion("gfid between", value1, value2, "gfid"); return (Criteria) this; } public Criteria andGfidNotBetween(String value1, String value2) { addCriterion("gfid not between", value1, value2, "gfid"); return (Criteria) this; } public Criteria andGfnameIsNull() { addCriterion("gfname is null"); return (Criteria) this; } public Criteria andGfnameIsNotNull() { addCriterion("gfname is not null"); return (Criteria) this; } public Criteria andGfnameEqualTo(String value) { addCriterion("gfname =", value, "gfname"); return (Criteria) this; } public Criteria andGfnameNotEqualTo(String value) { addCriterion("gfname <>", value, "gfname"); return (Criteria) this; } public Criteria andGfnameGreaterThan(String value) { addCriterion("gfname >", value, "gfname"); return (Criteria) this; } public Criteria andGfnameGreaterThanOrEqualTo(String value) { addCriterion("gfname >=", value, "gfname"); return (Criteria) this; } public Criteria andGfnameLessThan(String value) { addCriterion("gfname <", value, "gfname"); return (Criteria) this; } public Criteria andGfnameLessThanOrEqualTo(String value) { addCriterion("gfname <=", value, "gfname"); return (Criteria) this; } public Criteria andGfnameLike(String value) { addCriterion("gfname like", value, "gfname"); return (Criteria) this; } public Criteria andGfnameNotLike(String value) { addCriterion("gfname not like", value, "gfname"); return (Criteria) this; } public Criteria andGfnameIn(List values) { addCriterion("gfname in", values, "gfname"); return (Criteria) this; } public Criteria andGfnameNotIn(List values) { addCriterion("gfname not in", values, "gfname"); return (Criteria) this; } public Criteria andGfnameBetween(String value1, String value2) { addCriterion("gfname between", value1, value2, "gfname"); return (Criteria) this; } public Criteria andGfnameNotBetween(String value1, String value2) { addCriterion("gfname not between", value1, value2, "gfname"); return (Criteria) this; } public Criteria andBfidIsNull() { addCriterion("bfid is null"); return (Criteria) this; } public Criteria andBfidIsNotNull() { addCriterion("bfid is not null"); return (Criteria) this; } public Criteria andBfidEqualTo(String value) { addCriterion("bfid =", value, "bfid"); return (Criteria) this; } public Criteria andBfidNotEqualTo(String value) { addCriterion("bfid <>", value, "bfid"); return (Criteria) this; } public Criteria andBfidGreaterThan(String value) { addCriterion("bfid >", value, "bfid"); return (Criteria) this; } public Criteria andBfidGreaterThanOrEqualTo(String value) { addCriterion("bfid >=", value, "bfid"); return (Criteria) this; } public Criteria andBfidLessThan(String value) { addCriterion("bfid <", value, "bfid"); return (Criteria) this; } public Criteria andBfidLessThanOrEqualTo(String value) { addCriterion("bfid <=", value, "bfid"); return (Criteria) this; } public Criteria andBfidLike(String value) { addCriterion("bfid like", value, "bfid"); return (Criteria) this; } public Criteria andBfidNotLike(String value) { addCriterion("bfid not like", value, "bfid"); return (Criteria) this; } public Criteria andBfidIn(List values) { addCriterion("bfid in", values, "bfid"); return (Criteria) this; } public Criteria andBfidNotIn(List values) { addCriterion("bfid not in", values, "bfid"); return (Criteria) this; } public Criteria andBfidBetween(String value1, String value2) { addCriterion("bfid between", value1, value2, "bfid"); return (Criteria) this; } public Criteria andBfidNotBetween(String value1, String value2) { addCriterion("bfid not between", value1, value2, "bfid"); return (Criteria) this; } public Criteria andBfnameIsNull() { addCriterion("bfname is null"); return (Criteria) this; } public Criteria andBfnameIsNotNull() { addCriterion("bfname is not null"); return (Criteria) this; } public Criteria andBfnameEqualTo(String value) { addCriterion("bfname =", value, "bfname"); return (Criteria) this; } public Criteria andBfnameNotEqualTo(String value) { addCriterion("bfname <>", value, "bfname"); return (Criteria) this; } public Criteria andBfnameGreaterThan(String value) { addCriterion("bfname >", value, "bfname"); return (Criteria) this; } public Criteria andBfnameGreaterThanOrEqualTo(String value) { addCriterion("bfname >=", value, "bfname"); return (Criteria) this; } public Criteria andBfnameLessThan(String value) { addCriterion("bfname <", value, "bfname"); return (Criteria) this; } public Criteria andBfnameLessThanOrEqualTo(String value) { addCriterion("bfname <=", value, "bfname"); return (Criteria) this; } public Criteria andBfnameLike(String value) { addCriterion("bfname like", value, "bfname"); return (Criteria) this; } public Criteria andBfnameNotLike(String value) { addCriterion("bfname not like", value, "bfname"); return (Criteria) this; } public Criteria andBfnameIn(List values) { addCriterion("bfname in", values, "bfname"); return (Criteria) this; } public Criteria andBfnameNotIn(List values) { addCriterion("bfname not in", values, "bfname"); return (Criteria) this; } public Criteria andBfnameBetween(String value1, String value2) { addCriterion("bfname between", value1, value2, "bfname"); return (Criteria) this; } public Criteria andBfnameNotBetween(String value1, String value2) { addCriterion("bfname not between", value1, value2, "bfname"); 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 andSsiteIsNull() { addCriterion("ssite is null"); return (Criteria) this; } public Criteria andSsiteIsNotNull() { addCriterion("ssite is not null"); return (Criteria) this; } public Criteria andSsiteEqualTo(Float value) { addCriterion("ssite =", value, "ssite"); return (Criteria) this; } public Criteria andSsiteNotEqualTo(Float value) { addCriterion("ssite <>", value, "ssite"); return (Criteria) this; } public Criteria andSsiteGreaterThan(Float value) { addCriterion("ssite >", value, "ssite"); return (Criteria) this; } public Criteria andSsiteGreaterThanOrEqualTo(Float value) { addCriterion("ssite >=", value, "ssite"); return (Criteria) this; } public Criteria andSsiteLessThan(Float value) { addCriterion("ssite <", value, "ssite"); return (Criteria) this; } public Criteria andSsiteLessThanOrEqualTo(Float value) { addCriterion("ssite <=", value, "ssite"); return (Criteria) this; } public Criteria andSsiteIn(List values) { addCriterion("ssite in", values, "ssite"); return (Criteria) this; } public Criteria andSsiteNotIn(List values) { addCriterion("ssite not in", values, "ssite"); return (Criteria) this; } public Criteria andSsiteBetween(Float value1, Float value2) { addCriterion("ssite between", value1, value2, "ssite"); return (Criteria) this; } public Criteria andSsiteNotBetween(Float value1, Float value2) { addCriterion("ssite not between", value1, value2, "ssite"); return (Criteria) this; } public Criteria andEsiteIsNull() { addCriterion("esite is null"); return (Criteria) this; } public Criteria andEsiteIsNotNull() { addCriterion("esite is not null"); return (Criteria) this; } public Criteria andEsiteEqualTo(Float value) { addCriterion("esite =", value, "esite"); return (Criteria) this; } public Criteria andEsiteNotEqualTo(Float value) { addCriterion("esite <>", value, "esite"); return (Criteria) this; } public Criteria andEsiteGreaterThan(Float value) { addCriterion("esite >", value, "esite"); return (Criteria) this; } public Criteria andEsiteGreaterThanOrEqualTo(Float value) { addCriterion("esite >=", value, "esite"); return (Criteria) this; } public Criteria andEsiteLessThan(Float value) { addCriterion("esite <", value, "esite"); return (Criteria) this; } public Criteria andEsiteLessThanOrEqualTo(Float value) { addCriterion("esite <=", value, "esite"); return (Criteria) this; } public Criteria andEsiteIn(List values) { addCriterion("esite in", values, "esite"); return (Criteria) this; } public Criteria andEsiteNotIn(List values) { addCriterion("esite not in", values, "esite"); return (Criteria) this; } public Criteria andEsiteBetween(Float value1, Float value2) { addCriterion("esite between", value1, value2, "esite"); return (Criteria) this; } public Criteria andEsiteNotBetween(Float value1, Float value2) { addCriterion("esite not between", value1, value2, "esite"); return (Criteria) this; } public Criteria andGasdensityIsNull() { addCriterion("gasdensity is null"); return (Criteria) this; } public Criteria andGasdensityIsNotNull() { addCriterion("gasdensity is not null"); return (Criteria) this; } public Criteria andGasdensityEqualTo(Float value) { addCriterion("gasdensity =", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityNotEqualTo(Float value) { addCriterion("gasdensity <>", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityGreaterThan(Float value) { addCriterion("gasdensity >", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityGreaterThanOrEqualTo(Float value) { addCriterion("gasdensity >=", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityLessThan(Float value) { addCriterion("gasdensity <", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityLessThanOrEqualTo(Float value) { addCriterion("gasdensity <=", value, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityIn(List values) { addCriterion("gasdensity in", values, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityNotIn(List values) { addCriterion("gasdensity not in", values, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityBetween(Float value1, Float value2) { addCriterion("gasdensity between", value1, value2, "gasdensity"); return (Criteria) this; } public Criteria andGasdensityNotBetween(Float value1, Float value2) { addCriterion("gasdensity not between", value1, value2, "gasdensity"); 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); } } }