From b4de1386f34734fa0e4155ed9a21ea7b7163a006 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期一, 13 十一月 2023 17:36:40 +0800
Subject: [PATCH] 增加表字段
---
consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java | 37 ++++++++++++++++++++-----------------
1 files changed, 20 insertions(+), 17 deletions(-)
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java
index f66da47..cf1b78e 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java
@@ -7,11 +7,10 @@
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
-import org.springframework.jdbc.core.RowMapper;
-
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;
+import org.springframework.jdbc.core.RowMapper;
/**
* 琛ㄥ悕:L_WH_PROCURE_MODEL *
@@ -31,11 +30,11 @@
public static final String BusinessId = "business_id";
public static final String BaseGoodsModelsId = "base_goods_models_id";
public static final String BaseGoodsModelsName = "base_goods_models_name";
- public static final String Unit = "unit";
public static final String Price = "price";
public static final String Counts = "counts";
public static final String WorehouseCount = "worehouse_count";
public static final String Supplier = "supplier";
+ public static final String TotalAmount = "total_amount";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -64,9 +63,6 @@
if (lWhProcureModel.isset_baseGoodsModelsName) {
this.setBaseGoodsModelsName(lWhProcureModel.getBaseGoodsModelsName());
}
- if (lWhProcureModel.isset_unit) {
- this.setUnit(lWhProcureModel.getUnit());
- }
if (lWhProcureModel.isset_price) {
this.setPrice(lWhProcureModel.getPrice());
}
@@ -78,6 +74,9 @@
}
if (lWhProcureModel.isset_supplier) {
this.setSupplier(lWhProcureModel.getSupplier());
+ }
+ if (lWhProcureModel.isset_totalAmount) {
+ this.setTotalAmount(lWhProcureModel.getTotalAmount());
}
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(l_wh_procure_model.getDatabaseName_());
@@ -127,11 +126,11 @@
ib.set(BusinessId, this.getBusinessId(), this.isset_businessId);
ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
- ib.set(Unit, this.getUnit(), this.isset_unit);
ib.set(Price, this.getPrice(), this.isset_price);
ib.set(Counts, this.getCounts(), this.isset_counts);
ib.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
ib.set(Supplier, this.getSupplier(), this.isset_supplier);
+ ib.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount);
return ib.genMapSql();
}
@@ -146,11 +145,11 @@
ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
- ub.set(Unit, this.getUnit(), this.isset_unit);
ub.set(Price, this.getPrice(), this.isset_price);
ub.set(Counts, this.getCounts(), this.isset_counts);
ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
ub.set(Supplier, this.getSupplier(), this.isset_supplier);
+ ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -166,11 +165,11 @@
ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
- ub.set(Unit, this.getUnit(), this.isset_unit);
ub.set(Price, this.getPrice(), this.isset_price);
ub.set(Counts, this.getCounts(), this.isset_counts);
ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
ub.set(Supplier, this.getSupplier(), this.isset_supplier);
+ ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount);
return ub.genMapSql(where, parameters);
}
@@ -185,11 +184,11 @@
ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
- ub.set(Unit, this.getUnit(), this.isset_unit);
ub.set(Price, this.getPrice(), this.isset_price);
ub.set(Counts, this.getCounts(), this.isset_counts);
ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
ub.set(Supplier, this.getSupplier(), this.isset_supplier);
+ ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount);
return ub.genArraySql(where, parameters);
}
@@ -237,7 +236,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, price, counts, worehouse_count, supplier, total_amount from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -245,7 +244,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, price, counts, worehouse_count, supplier, total_amount from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -318,16 +317,12 @@
if (columnIndex > 0) {
l_wh_procure_model.setBaseGoodsModelsName(rs.getString(columnIndex));
}
- columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Unit);
- if (columnIndex > 0) {
- l_wh_procure_model.setUnit(rs.getString(columnIndex));
- }
columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Price);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
l_wh_procure_model.setPrice(null);
} else {
- l_wh_procure_model.setPrice(rs.getDouble(columnIndex));
+ l_wh_procure_model.setPrice(rs.getLong(columnIndex));
}
}
columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Counts);
@@ -350,6 +345,14 @@
if (columnIndex > 0) {
l_wh_procure_model.setSupplier(rs.getString(columnIndex));
}
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.TotalAmount);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model.setTotalAmount(null);
+ } else {
+ l_wh_procure_model.setTotalAmount(rs.getLong(columnIndex));
+ }
+ }
return l_wh_procure_model;
}
}
--
Gitblit v1.9.1