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/LGoodsWhRecord_mapper.java | 92 +++++++++++++++++++++++++++-------------------
1 files changed, 54 insertions(+), 38 deletions(-)
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java
index ae734c1..82a5613 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java
@@ -28,11 +28,12 @@
// 涓婚敭
public static final String Id = "id";
// 鏅�氬睘鎬�
- public static final String LWarehouseFlowId = "l_warehouse_flow_id";
- public static final String LWhGoodsId = "l_wh_goods_id";
+ public static final String WarehouseFlowId = "warehouse_flow_id";
+ public static final String WhGoodsId = "wh_goods_id";
+ public static final String WarehouseType = "warehouse_type";
public static final String WarehouseId = "warehouse_id";
- public static final String ParentId = "parent_id";
public static final String DealTime = "deal_time";
+ public static final String LastRecord = "last_record";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -46,20 +47,23 @@
this.setId(lGoodsWhRecord.getId());
}
//鏅�氬睘鎬�
- if (lGoodsWhRecord.isset_lWarehouseFlowId) {
- this.setLWarehouseFlowId(lGoodsWhRecord.getLWarehouseFlowId());
+ if (lGoodsWhRecord.isset_warehouseFlowId) {
+ this.setWarehouseFlowId(lGoodsWhRecord.getWarehouseFlowId());
}
- if (lGoodsWhRecord.isset_lWhGoodsId) {
- this.setLWhGoodsId(lGoodsWhRecord.getLWhGoodsId());
+ if (lGoodsWhRecord.isset_whGoodsId) {
+ this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId());
+ }
+ if (lGoodsWhRecord.isset_warehouseType) {
+ this.setWarehouseType(lGoodsWhRecord.getWarehouseType());
}
if (lGoodsWhRecord.isset_warehouseId) {
this.setWarehouseId(lGoodsWhRecord.getWarehouseId());
}
- if (lGoodsWhRecord.isset_parentId) {
- this.setParentId(lGoodsWhRecord.getParentId());
- }
if (lGoodsWhRecord.isset_dealTime) {
this.setDealTime(lGoodsWhRecord.getDealTime());
+ }
+ if (lGoodsWhRecord.isset_lastRecord) {
+ this.setLastRecord(lGoodsWhRecord.getLastRecord());
}
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(l_goods_wh_record.getDatabaseName_());
@@ -104,11 +108,12 @@
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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
+ ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
+ ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
- ib.set(ParentId, this.getParentId(), this.isset_parentId);
ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ib.genMapSql();
}
@@ -118,11 +123,12 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
- ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
+ ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
- ub.set(ParentId, this.getParentId(), this.isset_parentId);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -133,11 +139,12 @@
@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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
+ ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
- ub.set(ParentId, this.getParentId(), this.isset_parentId);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ub.genMapSql(where, parameters);
}
@@ -147,11 +154,12 @@
@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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
+ ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
+ ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
- ub.set(ParentId, this.getParentId(), this.isset_parentId);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ub.genArraySql(where, parameters);
}
@@ -199,7 +207,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -207,7 +215,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -244,20 +252,28 @@
l_goods_wh_record.setId(rs.getLong(columnIndex));
}
//鏅�氬睘鎬�
- columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWarehouseFlowId);
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseFlowId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- l_goods_wh_record.setLWarehouseFlowId(null);
+ l_goods_wh_record.setWarehouseFlowId(null);
} else {
- l_goods_wh_record.setLWarehouseFlowId(rs.getLong(columnIndex));
+ l_goods_wh_record.setWarehouseFlowId(rs.getLong(columnIndex));
}
}
- columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWhGoodsId);
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WhGoodsId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- l_goods_wh_record.setLWhGoodsId(null);
+ l_goods_wh_record.setWhGoodsId(null);
} else {
- l_goods_wh_record.setLWhGoodsId(rs.getLong(columnIndex));
+ l_goods_wh_record.setWhGoodsId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseType);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_goods_wh_record.setWarehouseType(null);
+ } else {
+ l_goods_wh_record.setWarehouseType(rs.getInt(columnIndex));
}
}
columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId);
@@ -268,14 +284,6 @@
l_goods_wh_record.setWarehouseId(rs.getLong(columnIndex));
}
}
- columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.ParentId);
- if (columnIndex > 0) {
- if (rs.getBigDecimal(columnIndex) == null) {
- l_goods_wh_record.setParentId(null);
- } else {
- l_goods_wh_record.setParentId(rs.getInt(columnIndex));
- }
- }
columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.DealTime);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
@@ -284,6 +292,14 @@
l_goods_wh_record.setDealTime(rs.getLong(columnIndex));
}
}
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LastRecord);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_goods_wh_record.setLastRecord(null);
+ } else {
+ l_goods_wh_record.setLastRecord(rs.getInt(columnIndex));
+ }
+ }
return l_goods_wh_record;
}
}
--
Gitblit v1.9.1