From 0ff4be6c9cb9bc215acd4b4c78122da7e0d7140f Mon Sep 17 00:00:00 2001
From: 石广澎 <shiguangpeng@163.com>
Date: 星期五, 01 十二月 2023 13:55:50 +0800
Subject: [PATCH] feat: 部门物品退回
---
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 deletions(-)
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java
index 834f0d2..be3829b 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java
@@ -38,6 +38,7 @@
public static final String BaseGoodsModelsId = "base_goods_models_id";
public static final String BaseGoodsModelsName = "base_goods_models_name";
public static final String DealTime = "deal_time";
+ public static final String TotalPrice = "total_price";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -86,6 +87,9 @@
}
if (lWhGoodsRecord.isset_dealTime) {
this.setDealTime(lWhGoodsRecord.getDealTime());
+ }
+ if (lWhGoodsRecord.isset_totalPrice) {
+ this.setTotalPrice(lWhGoodsRecord.getTotalPrice());
}
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(l_wh_goods_record.getDatabaseName_());
@@ -142,6 +146,7 @@
ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ib.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
return ib.genMapSql();
}
@@ -163,6 +168,7 @@
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -185,6 +191,7 @@
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
return ub.genMapSql(where, parameters);
}
@@ -206,6 +213,7 @@
ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
return ub.genArraySql(where, parameters);
}
@@ -253,7 +261,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time, total_price from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -261,7 +269,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time, total_price from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -386,6 +394,14 @@
l_wh_goods_record.setDealTime(rs.getLong(columnIndex));
}
}
+ columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.TotalPrice);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_goods_record.setTotalPrice(null);
+ } else {
+ l_wh_goods_record.setTotalPrice(rs.getLong(columnIndex));
+ }
+ }
return l_wh_goods_record;
}
}
--
Gitblit v1.9.1