From 33032d320cb75854def7391026b0401f1bfb8360 Mon Sep 17 00:00:00 2001
From: 黎星凯 <13949086503@163.com>
Date: 星期六, 11 五月 2024 17:26:02 +0800
Subject: [PATCH] 20240511修改: 分发单优化， 分类，物品，分发单明细，采购单明细数据导入
---
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java | 74 ++++++++++++++++++++++++++++++-------
1 files changed, 60 insertions(+), 14 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 1a2769a..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
@@ -7,8 +7,6 @@
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
-import com.walker.jdbc.util.StringUtils;
-
import org.springframework.jdbc.core.RowMapper;
import java.sql.ResultSet;
@@ -28,7 +26,8 @@
// 涓婚敭
public static final String Id = "id";
// 鏅�氬睘鎬�
- public static final String LWarehouseFlowId = "l_warehouse_flow_id";
+ public static final String WarehouseType = "warehouse_type";
+ public static final String WarehouseId = "warehouse_id";
public static final String WarehouseFlowId = "warehouse_flow_id";
public static final String InitialCount = "initial_count";
public static final String ThisType = "this_type";
@@ -38,6 +37,8 @@
public static final String GoodsTemplateName = "goods_template_name";
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";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -51,8 +52,11 @@
this.setId(lWhGoodsRecord.getId());
}
//鏅�氬睘鎬�
- if (lWhGoodsRecord.isset_lWarehouseFlowId) {
- this.setLWarehouseFlowId(lWhGoodsRecord.getLWarehouseFlowId());
+ if (lWhGoodsRecord.isset_warehouseType) {
+ this.setWarehouseType(lWhGoodsRecord.getWarehouseType());
+ }
+ if (lWhGoodsRecord.isset_warehouseId) {
+ this.setWarehouseId(lWhGoodsRecord.getWarehouseId());
}
if (lWhGoodsRecord.isset_warehouseFlowId) {
this.setWarehouseFlowId(lWhGoodsRecord.getWarehouseFlowId());
@@ -80,6 +84,12 @@
}
if (lWhGoodsRecord.isset_baseGoodsModelsName) {
this.setBaseGoodsModelsName(lWhGoodsRecord.getBaseGoodsModelsName());
+ }
+ 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_());
@@ -124,7 +134,8 @@
public SqlAndParameters<Map<String, Object>> getInsertSql_() {
InsertBuilder ib = new InsertBuilder(this.getTableName_());
ib.set(Id, this.getId());
- ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
+ ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+ ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
ib.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -134,6 +145,8 @@
ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
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();
}
@@ -143,7 +156,8 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -153,6 +167,8 @@
ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
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();
}
@@ -163,7 +179,8 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -173,6 +190,8 @@
ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
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);
}
@@ -182,7 +201,8 @@
@Override
public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+ ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -192,6 +212,8 @@
ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
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);
}
@@ -239,7 +261,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, l_warehouse_flow_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 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);
}
/**
@@ -247,7 +269,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, l_warehouse_flow_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 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);
}
/**
@@ -284,12 +306,20 @@
l_wh_goods_record.setId(rs.getLong(columnIndex));
}
//鏅�氬睘鎬�
- columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.LWarehouseFlowId);
+ columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.WarehouseType);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- l_wh_goods_record.setLWarehouseFlowId(null);
+ l_wh_goods_record.setWarehouseType(null);
} else {
- l_wh_goods_record.setLWarehouseFlowId(rs.getLong(columnIndex));
+ l_wh_goods_record.setWarehouseType(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.WarehouseId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_goods_record.setWarehouseId(null);
+ } else {
+ l_wh_goods_record.setWarehouseId(rs.getLong(columnIndex));
}
}
columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.WarehouseFlowId);
@@ -356,6 +386,22 @@
if (columnIndex > 0) {
l_wh_goods_record.setBaseGoodsModelsName(rs.getString(columnIndex));
}
+ columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.DealTime);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_goods_record.setDealTime(null);
+ } else {
+ 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