package com.jsh.erp.datasource.entities; import java.math.BigDecimal; import java.util.ArrayList; import java.util.List; public class MaterialCurrentStockExample { protected String orderByClause; protected boolean distinct; protected List oredCriteria; public MaterialCurrentStockExample() { 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(Long value) { addCriterion("id =", value, "id"); return (Criteria) this; } public Criteria andIdNotEqualTo(Long value) { addCriterion("id <>", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThan(Long value) { addCriterion("id >", value, "id"); return (Criteria) this; } public Criteria andIdGreaterThanOrEqualTo(Long value) { addCriterion("id >=", value, "id"); return (Criteria) this; } public Criteria andIdLessThan(Long value) { addCriterion("id <", value, "id"); return (Criteria) this; } public Criteria andIdLessThanOrEqualTo(Long 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(Long value1, Long value2) { addCriterion("id between", value1, value2, "id"); return (Criteria) this; } public Criteria andIdNotBetween(Long value1, Long value2) { addCriterion("id not between", value1, value2, "id"); return (Criteria) this; } public Criteria andMaterialIdIsNull() { addCriterion("material_id is null"); return (Criteria) this; } public Criteria andMaterialIdIsNotNull() { addCriterion("material_id is not null"); return (Criteria) this; } public Criteria andMaterialIdEqualTo(Long value) { addCriterion("material_id =", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdNotEqualTo(Long value) { addCriterion("material_id <>", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdGreaterThan(Long value) { addCriterion("material_id >", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdGreaterThanOrEqualTo(Long value) { addCriterion("material_id >=", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdLessThan(Long value) { addCriterion("material_id <", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdLessThanOrEqualTo(Long value) { addCriterion("material_id <=", value, "materialId"); return (Criteria) this; } public Criteria andMaterialIdIn(List values) { addCriterion("material_id in", values, "materialId"); return (Criteria) this; } public Criteria andMaterialIdNotIn(List values) { addCriterion("material_id not in", values, "materialId"); return (Criteria) this; } public Criteria andMaterialIdBetween(Long value1, Long value2) { addCriterion("material_id between", value1, value2, "materialId"); return (Criteria) this; } public Criteria andMaterialIdNotBetween(Long value1, Long value2) { addCriterion("material_id not between", value1, value2, "materialId"); return (Criteria) this; } public Criteria andDepotIdIsNull() { addCriterion("depot_id is null"); return (Criteria) this; } public Criteria andDepotIdIsNotNull() { addCriterion("depot_id is not null"); return (Criteria) this; } public Criteria andDepotIdEqualTo(Long value) { addCriterion("depot_id =", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdNotEqualTo(Long value) { addCriterion("depot_id <>", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdGreaterThan(Long value) { addCriterion("depot_id >", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdGreaterThanOrEqualTo(Long value) { addCriterion("depot_id >=", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdLessThan(Long value) { addCriterion("depot_id <", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdLessThanOrEqualTo(Long value) { addCriterion("depot_id <=", value, "depotId"); return (Criteria) this; } public Criteria andDepotIdIn(List values) { addCriterion("depot_id in", values, "depotId"); return (Criteria) this; } public Criteria andDepotIdNotIn(List values) { addCriterion("depot_id not in", values, "depotId"); return (Criteria) this; } public Criteria andDepotIdBetween(Long value1, Long value2) { addCriterion("depot_id between", value1, value2, "depotId"); return (Criteria) this; } public Criteria andDepotIdNotBetween(Long value1, Long value2) { addCriterion("depot_id not between", value1, value2, "depotId"); return (Criteria) this; } public Criteria andCurrentNumberIsNull() { addCriterion("current_number is null"); return (Criteria) this; } public Criteria andCurrentNumberIsNotNull() { addCriterion("current_number is not null"); return (Criteria) this; } public Criteria andCurrentNumberEqualTo(BigDecimal value) { addCriterion("current_number =", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberNotEqualTo(BigDecimal value) { addCriterion("current_number <>", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberGreaterThan(BigDecimal value) { addCriterion("current_number >", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberGreaterThanOrEqualTo(BigDecimal value) { addCriterion("current_number >=", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberLessThan(BigDecimal value) { addCriterion("current_number <", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberLessThanOrEqualTo(BigDecimal value) { addCriterion("current_number <=", value, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberIn(List values) { addCriterion("current_number in", values, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberNotIn(List values) { addCriterion("current_number not in", values, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberBetween(BigDecimal value1, BigDecimal value2) { addCriterion("current_number between", value1, value2, "currentNumber"); return (Criteria) this; } public Criteria andCurrentNumberNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("current_number not between", value1, value2, "currentNumber"); return (Criteria) this; } public Criteria andCurrentUnitPriceIsNull() { addCriterion("current_unit_price is null"); return (Criteria) this; } public Criteria andCurrentUnitPriceIsNotNull() { addCriterion("current_unit_price is not null"); return (Criteria) this; } public Criteria andCurrentUnitPriceEqualTo(BigDecimal value) { addCriterion("current_unit_price =", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceNotEqualTo(BigDecimal value) { addCriterion("current_unit_price <>", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceGreaterThan(BigDecimal value) { addCriterion("current_unit_price >", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceGreaterThanOrEqualTo(BigDecimal value) { addCriterion("current_unit_price >=", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceLessThan(BigDecimal value) { addCriterion("current_unit_price <", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceLessThanOrEqualTo(BigDecimal value) { addCriterion("current_unit_price <=", value, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceIn(List values) { addCriterion("current_unit_price in", values, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceNotIn(List values) { addCriterion("current_unit_price not in", values, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceBetween(BigDecimal value1, BigDecimal value2) { addCriterion("current_unit_price between", value1, value2, "currentUnitPrice"); return (Criteria) this; } public Criteria andCurrentUnitPriceNotBetween(BigDecimal value1, BigDecimal value2) { addCriterion("current_unit_price not between", value1, value2, "currentUnitPrice"); return (Criteria) this; } public Criteria andTenantIdIsNull() { addCriterion("tenant_id is null"); return (Criteria) this; } public Criteria andTenantIdIsNotNull() { addCriterion("tenant_id is not null"); return (Criteria) this; } public Criteria andTenantIdEqualTo(Long value) { addCriterion("tenant_id =", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdNotEqualTo(Long value) { addCriterion("tenant_id <>", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdGreaterThan(Long value) { addCriterion("tenant_id >", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdGreaterThanOrEqualTo(Long value) { addCriterion("tenant_id >=", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdLessThan(Long value) { addCriterion("tenant_id <", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdLessThanOrEqualTo(Long value) { addCriterion("tenant_id <=", value, "tenantId"); return (Criteria) this; } public Criteria andTenantIdIn(List values) { addCriterion("tenant_id in", values, "tenantId"); return (Criteria) this; } public Criteria andTenantIdNotIn(List values) { addCriterion("tenant_id not in", values, "tenantId"); return (Criteria) this; } public Criteria andTenantIdBetween(Long value1, Long value2) { addCriterion("tenant_id between", value1, value2, "tenantId"); return (Criteria) this; } public Criteria andTenantIdNotBetween(Long value1, Long value2) { addCriterion("tenant_id not between", value1, value2, "tenantId"); return (Criteria) this; } public Criteria andDeleteFlagIsNull() { addCriterion("delete_flag is null"); return (Criteria) this; } public Criteria andDeleteFlagIsNotNull() { addCriterion("delete_flag is not null"); return (Criteria) this; } public Criteria andDeleteFlagEqualTo(String value) { addCriterion("delete_flag =", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagNotEqualTo(String value) { addCriterion("delete_flag <>", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagGreaterThan(String value) { addCriterion("delete_flag >", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagGreaterThanOrEqualTo(String value) { addCriterion("delete_flag >=", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagLessThan(String value) { addCriterion("delete_flag <", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagLessThanOrEqualTo(String value) { addCriterion("delete_flag <=", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagLike(String value) { addCriterion("delete_flag like", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagNotLike(String value) { addCriterion("delete_flag not like", value, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagIn(List values) { addCriterion("delete_flag in", values, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagNotIn(List values) { addCriterion("delete_flag not in", values, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagBetween(String value1, String value2) { addCriterion("delete_flag between", value1, value2, "deleteFlag"); return (Criteria) this; } public Criteria andDeleteFlagNotBetween(String value1, String value2) { addCriterion("delete_flag not between", value1, value2, "deleteFlag"); 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); } } }