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 |   36 ++++++++++++++++++++++++++++++++++--
 1 files changed, 34 insertions(+), 2 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 60801e6..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
@@ -30,8 +30,10 @@
     // 鏅�氬睘鎬�
     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 DealTime = "deal_time";
+    public static final String LastRecord = "last_record";
 
     /**
      * 榛樿鏋勯�犲嚱鏁�
@@ -51,11 +53,17 @@
         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_dealTime) {
             this.setDealTime(lGoodsWhRecord.getDealTime());
+        }
+        if (lGoodsWhRecord.isset_lastRecord) {
+            this.setLastRecord(lGoodsWhRecord.getLastRecord());
         }
         // 鍘绘帀锛�2022-09-07
         // this.setDatabaseName_(l_goods_wh_record.getDatabaseName_());
@@ -102,8 +110,10 @@
         ib.set(Id, this.getId());
         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(DealTime, this.getDealTime(), this.isset_dealTime);
+        ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
         return ib.genMapSql();
     }
 
@@ -115,8 +125,10 @@
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
         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(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
         ub.where(this.getPkName_(), this.getPkValue_());
         return ub.genMapSql();
     }
@@ -129,8 +141,10 @@
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
         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(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
         return ub.genMapSql(where, parameters);
     }
 
@@ -142,8 +156,10 @@
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
         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(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
         return ub.genArraySql(where, parameters);
     }
 
@@ -191,7 +207,7 @@
      */
     @Override
     public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
-        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_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);
     }
 
     /**
@@ -199,7 +215,7 @@
      */
     @Override
     public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
-        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_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);
     }
 
     /**
@@ -252,6 +268,14 @@
                 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);
         if (columnIndex > 0) {
             if (rs.getBigDecimal(columnIndex) == null) {
@@ -268,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