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<Criteria> 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<Criteria> 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<Criterion> criteria;
|
|
protected GeneratedCriteria() {
|
super();
|
criteria = new ArrayList<>();
|
}
|
|
public boolean isValid() {
|
return criteria.size() > 0;
|
}
|
|
public List<Criterion> getAllCriteria() {
|
return criteria;
|
}
|
|
public List<Criterion> 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<Long> values) {
|
addCriterion("id in", values, "id");
|
return (Criteria) this;
|
}
|
|
public Criteria andIdNotIn(List<Long> 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<Long> values) {
|
addCriterion("material_id in", values, "materialId");
|
return (Criteria) this;
|
}
|
|
public Criteria andMaterialIdNotIn(List<Long> 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<Long> values) {
|
addCriterion("depot_id in", values, "depotId");
|
return (Criteria) this;
|
}
|
|
public Criteria andDepotIdNotIn(List<Long> 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<BigDecimal> values) {
|
addCriterion("current_number in", values, "currentNumber");
|
return (Criteria) this;
|
}
|
|
public Criteria andCurrentNumberNotIn(List<BigDecimal> 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<BigDecimal> values) {
|
addCriterion("current_unit_price in", values, "currentUnitPrice");
|
return (Criteria) this;
|
}
|
|
public Criteria andCurrentUnitPriceNotIn(List<BigDecimal> 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<Long> values) {
|
addCriterion("tenant_id in", values, "tenantId");
|
return (Criteria) this;
|
}
|
|
public Criteria andTenantIdNotIn(List<Long> 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<String> values) {
|
addCriterion("delete_flag in", values, "deleteFlag");
|
return (Criteria) this;
|
}
|
|
public Criteria andDeleteFlagNotIn(List<String> 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);
|
}
|
}
|
}
|
