From a30a15f292e24f3e93253aec6dcc41b5cc3cc420 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期二, 31 十月 2023 11:27:40 +0800
Subject: [PATCH] feat: 盘点单/进出库流水总表/库存物品详情/物品仓库保管记录 实体类

---
 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java       |   20 
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java             |  392 ++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java      |  409 +++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java              |   22 
 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java              |   22 
 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java                    |   22 
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory.java            |  480 ++++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java |  389 ++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java     |  463 ++++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java       |   20 
 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java             |   20 
 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java        |  370 ++++++++
 12 files changed, 2,623 insertions(+), 6 deletions(-)

diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java
index 97921d3..e962ffe 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java
@@ -28,6 +28,10 @@
     @JsonIgnore
     protected boolean isset_whGoodsId = false;
 
+    private Integer warehouseType = null;
+    @JsonIgnore
+    protected boolean isset_warehouseType = false;
+
     private Long warehouseId = null;
     @JsonIgnore
     protected boolean isset_warehouseId = false;
@@ -99,6 +103,20 @@
         return this.whGoodsId == null;
     }
 
+    public Integer getWarehouseType() {
+        return this.warehouseType;
+    }
+
+    public void setWarehouseType(Integer warehouseType) {
+        this.warehouseType = warehouseType;
+        this.isset_warehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseType() {
+        return this.warehouseType == null;
+    }
+
     public Long getWarehouseId() {
         return this.warehouseId;
     }
@@ -136,6 +154,7 @@
                 .append("id=").append(this.id)
                 .append("warehouseFlowId=").append(this.warehouseFlowId)
                 .append("whGoodsId=").append(this.whGoodsId)
+                .append("warehouseType=").append(this.warehouseType)
                 .append("warehouseId=").append(this.warehouseId)
                 .append("dealTime=").append(this.dealTime)
                 .toString();
@@ -161,6 +180,9 @@
         if (this.isset_whGoodsId) {
             l_goods_wh_record.setWhGoodsId(this.getWhGoodsId());
         }
+        if (this.isset_warehouseType) {
+            l_goods_wh_record.setWarehouseType(this.getWarehouseType());
+        }
         if (this.isset_warehouseId) {
             l_goods_wh_record.setWarehouseId(this.getWarehouseId());
         }
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..8ce8f90 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,6 +30,7 @@
     // 鏅�氬睘鎬�
     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";
 
@@ -50,6 +51,9 @@
         }
         if (lGoodsWhRecord.isset_whGoodsId) {
             this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId());
+        }
+        if (lGoodsWhRecord.isset_warehouseType) {
+            this.setWarehouseType(lGoodsWhRecord.getWarehouseType());
         }
         if (lGoodsWhRecord.isset_warehouseId) {
             this.setWarehouseId(lGoodsWhRecord.getWarehouseId());
@@ -102,6 +106,7 @@
         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);
         return ib.genMapSql();
@@ -115,6 +120,7 @@
         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.where(this.getPkName_(), this.getPkValue_());
@@ -129,6 +135,7 @@
         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);
         return ub.genMapSql(where, parameters);
@@ -142,6 +149,7 @@
         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);
         return ub.genArraySql(where, parameters);
@@ -191,7 +199,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 from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -199,7 +207,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 from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -252,6 +260,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) {
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java
index 886443a..21eee37 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java
@@ -20,6 +20,10 @@
     protected boolean isset_id = false;
 
     // 灞炴�у垪琛�
+    private Integer warehouseType = null;
+    @JsonIgnore
+    protected boolean isset_warehouseType = false;
+
     private Long warehouseId = null;
     @JsonIgnore
     protected boolean isset_warehouseId = false;
@@ -85,6 +89,20 @@
     @JsonIgnore
     public boolean isEmptyId() {
         return this.id == null;
+    }
+
+    public Integer getWarehouseType() {
+        return this.warehouseType;
+    }
+
+    public void setWarehouseType(Integer warehouseType) {
+        this.warehouseType = warehouseType;
+        this.isset_warehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseType() {
+        return this.warehouseType == null;
     }
 
     public Long getWarehouseId() {
@@ -206,6 +224,7 @@
     public String toString() {
         return new StringBuilder()
                 .append("id=").append(this.id)
+                .append("warehouseType=").append(this.warehouseType)
                 .append("warehouseId=").append(this.warehouseId)
                 .append("warehouseName=").append(this.warehouseName)
                 .append("thisType=").append(this.thisType)
@@ -231,6 +250,9 @@
             l_warehouse_flow.setId(this.getId());
         }
         // 鏅�氬睘鎬�
+        if (this.isset_warehouseType) {
+            l_warehouse_flow.setWarehouseType(this.getWarehouseType());
+        }
         if (this.isset_warehouseId) {
             l_warehouse_flow.setWarehouseId(this.getWarehouseId());
         }
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java
index 140478d..d56e971 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java
@@ -28,6 +28,7 @@
     // 涓婚敭
     public static final String Id = "id";
     // 鏅�氬睘鎬�
+    public static final String WarehouseType = "warehouse_type";
     public static final String WarehouseId = "warehouse_id";
     public static final String WarehouseName = "warehouse_name";
     public static final String ThisType = "this_type";
@@ -49,6 +50,9 @@
             this.setId(lWarehouseFlow.getId());
         }
         //鏅�氬睘鎬�
+        if (lWarehouseFlow.isset_warehouseType) {
+            this.setWarehouseType(lWarehouseFlow.getWarehouseType());
+        }
         if (lWarehouseFlow.isset_warehouseId) {
             this.setWarehouseId(lWarehouseFlow.getWarehouseId());
         }
@@ -116,6 +120,7 @@
     public SqlAndParameters<Map<String, Object>> getInsertSql_() {
         InsertBuilder ib = new InsertBuilder(this.getTableName_());
         ib.set(Id, this.getId());
+        ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ib.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -133,6 +138,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -151,6 +157,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -168,6 +175,7 @@
     @Override
     public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(ThisType, this.getThisType(), this.isset_thisType);
@@ -223,7 +231,7 @@
      */
     @Override
     public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
-        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -231,7 +239,7 @@
      */
     @Override
     public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
-        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -268,6 +276,14 @@
             l_warehouse_flow.setId(rs.getLong(columnIndex));
         }
         //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_warehouse_flow.setWarehouseType(null);
+            } else {
+                l_warehouse_flow.setWarehouseType(rs.getInt(columnIndex));
+            }
+        }
         columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseId);
         if (columnIndex > 0) {
             if (rs.getBigDecimal(columnIndex) == null) {
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory.java
new file mode 100644
index 0000000..c28bd11
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory.java
@@ -0,0 +1,480 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_INVENTORY *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class LWhFormInventory extends BasePo<LWhFormInventory> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private String businessFormCode = null;
+    @JsonIgnore
+    protected boolean isset_businessFormCode = false;
+
+    private String businessFormName = null;
+    @JsonIgnore
+    protected boolean isset_businessFormName = false;
+
+    private Integer warehouseType = null;
+    @JsonIgnore
+    protected boolean isset_warehouseType = false;
+
+    private Long warehouseId = null;
+    @JsonIgnore
+    protected boolean isset_warehouseId = false;
+
+    private String warehouseName = null;
+    @JsonIgnore
+    protected boolean isset_warehouseName = false;
+
+    private Long operatorId = null;
+    @JsonIgnore
+    protected boolean isset_operatorId = false;
+
+    private String operatorName = null;
+    @JsonIgnore
+    protected boolean isset_operatorName = false;
+
+    private Integer states = null;
+    @JsonIgnore
+    protected boolean isset_states = false;
+
+    private Long operatorId2 = null;
+    @JsonIgnore
+    protected boolean isset_operatorId2 = false;
+
+    private String operatorName2 = null;
+    @JsonIgnore
+    protected boolean isset_operatorName2 = false;
+
+    private String beiz1 = null;
+    @JsonIgnore
+    protected boolean isset_beiz1 = false;
+
+    private Long agencyId = null;
+    @JsonIgnore
+    protected boolean isset_agencyId = false;
+
+    private String agencyName = null;
+    @JsonIgnore
+    protected boolean isset_agencyName = false;
+
+    private Long creatorId = null;
+    @JsonIgnore
+    protected boolean isset_creatorId = false;
+
+    private String creatorName = null;
+    @JsonIgnore
+    protected boolean isset_creatorName = false;
+
+    private Long inventoryDate = null;
+    @JsonIgnore
+    protected boolean isset_inventoryDate = false;
+
+    private Long createTime = null;
+    @JsonIgnore
+    protected boolean isset_createTime = false;
+
+    private Long stopTime = null;
+    @JsonIgnore
+    protected boolean isset_stopTime = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormInventory() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public LWhFormInventory(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public String getBusinessFormCode() {
+        return this.businessFormCode;
+    }
+
+    public void setBusinessFormCode(String businessFormCode) {
+        this.businessFormCode = businessFormCode;
+        this.isset_businessFormCode = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBusinessFormCode() {
+        return this.businessFormCode == null || this.businessFormCode.length() == 0;
+    }
+
+    public String getBusinessFormName() {
+        return this.businessFormName;
+    }
+
+    public void setBusinessFormName(String businessFormName) {
+        this.businessFormName = businessFormName;
+        this.isset_businessFormName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBusinessFormName() {
+        return this.businessFormName == null || this.businessFormName.length() == 0;
+    }
+
+    public Integer getWarehouseType() {
+        return this.warehouseType;
+    }
+
+    public void setWarehouseType(Integer warehouseType) {
+        this.warehouseType = warehouseType;
+        this.isset_warehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseType() {
+        return this.warehouseType == null;
+    }
+
+    public Long getWarehouseId() {
+        return this.warehouseId;
+    }
+
+    public void setWarehouseId(Long warehouseId) {
+        this.warehouseId = warehouseId;
+        this.isset_warehouseId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseId() {
+        return this.warehouseId == null;
+    }
+
+    public String getWarehouseName() {
+        return this.warehouseName;
+    }
+
+    public void setWarehouseName(String warehouseName) {
+        this.warehouseName = warehouseName;
+        this.isset_warehouseName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseName() {
+        return this.warehouseName == null || this.warehouseName.length() == 0;
+    }
+
+    public Long getOperatorId() {
+        return this.operatorId;
+    }
+
+    public void setOperatorId(Long operatorId) {
+        this.operatorId = operatorId;
+        this.isset_operatorId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorId() {
+        return this.operatorId == null;
+    }
+
+    public String getOperatorName() {
+        return this.operatorName;
+    }
+
+    public void setOperatorName(String operatorName) {
+        this.operatorName = operatorName;
+        this.isset_operatorName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorName() {
+        return this.operatorName == null || this.operatorName.length() == 0;
+    }
+
+    public Integer getStates() {
+        return this.states;
+    }
+
+    public void setStates(Integer states) {
+        this.states = states;
+        this.isset_states = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyStates() {
+        return this.states == null;
+    }
+
+    public Long getOperatorId2() {
+        return this.operatorId2;
+    }
+
+    public void setOperatorId2(Long operatorId2) {
+        this.operatorId2 = operatorId2;
+        this.isset_operatorId2 = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorId2() {
+        return this.operatorId2 == null;
+    }
+
+    public String getOperatorName2() {
+        return this.operatorName2;
+    }
+
+    public void setOperatorName2(String operatorName2) {
+        this.operatorName2 = operatorName2;
+        this.isset_operatorName2 = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorName2() {
+        return this.operatorName2 == null || this.operatorName2.length() == 0;
+    }
+
+    public String getBeiz1() {
+        return this.beiz1;
+    }
+
+    public void setBeiz1(String beiz1) {
+        this.beiz1 = beiz1;
+        this.isset_beiz1 = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBeiz1() {
+        return this.beiz1 == null || this.beiz1.length() == 0;
+    }
+
+    public Long getAgencyId() {
+        return this.agencyId;
+    }
+
+    public void setAgencyId(Long agencyId) {
+        this.agencyId = agencyId;
+        this.isset_agencyId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyId() {
+        return this.agencyId == null;
+    }
+
+    public String getAgencyName() {
+        return this.agencyName;
+    }
+
+    public void setAgencyName(String agencyName) {
+        this.agencyName = agencyName;
+        this.isset_agencyName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyName() {
+        return this.agencyName == null || this.agencyName.length() == 0;
+    }
+
+    public Long getCreatorId() {
+        return this.creatorId;
+    }
+
+    public void setCreatorId(Long creatorId) {
+        this.creatorId = creatorId;
+        this.isset_creatorId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCreatorId() {
+        return this.creatorId == null;
+    }
+
+    public String getCreatorName() {
+        return this.creatorName;
+    }
+
+    public void setCreatorName(String creatorName) {
+        this.creatorName = creatorName;
+        this.isset_creatorName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCreatorName() {
+        return this.creatorName == null || this.creatorName.length() == 0;
+    }
+
+    public Long getInventoryDate() {
+        return this.inventoryDate;
+    }
+
+    public void setInventoryDate(Long inventoryDate) {
+        this.inventoryDate = inventoryDate;
+        this.isset_inventoryDate = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyInventoryDate() {
+        return this.inventoryDate == null;
+    }
+
+    public Long getCreateTime() {
+        return this.createTime;
+    }
+
+    public void setCreateTime(Long createTime) {
+        this.createTime = createTime;
+        this.isset_createTime = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCreateTime() {
+        return this.createTime == null;
+    }
+
+    public Long getStopTime() {
+        return this.stopTime;
+    }
+
+    public void setStopTime(Long stopTime) {
+        this.stopTime = stopTime;
+        this.isset_stopTime = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyStopTime() {
+        return this.stopTime == null;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+                .append("id=").append(this.id)
+                .append("businessFormCode=").append(this.businessFormCode)
+                .append("businessFormName=").append(this.businessFormName)
+                .append("warehouseType=").append(this.warehouseType)
+                .append("warehouseId=").append(this.warehouseId)
+                .append("warehouseName=").append(this.warehouseName)
+                .append("operatorId=").append(this.operatorId)
+                .append("operatorName=").append(this.operatorName)
+                .append("states=").append(this.states)
+                .append("operatorId2=").append(this.operatorId2)
+                .append("operatorName2=").append(this.operatorName2)
+                .append("beiz1=").append(this.beiz1)
+                .append("agencyId=").append(this.agencyId)
+                .append("agencyName=").append(this.agencyName)
+                .append("creatorId=").append(this.creatorId)
+                .append("creatorName=").append(this.creatorName)
+                .append("inventoryDate=").append(this.inventoryDate)
+                .append("createTime=").append(this.createTime)
+                .append("stopTime=").append(this.stopTime)
+                .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormInventory $clone() {
+        LWhFormInventory l_wh_form_inventory = new LWhFormInventory();
+
+        // 鏁版嵁搴撳悕绉�
+        //l_wh_form_inventory.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            l_wh_form_inventory.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_businessFormCode) {
+            l_wh_form_inventory.setBusinessFormCode(this.getBusinessFormCode());
+        }
+        if (this.isset_businessFormName) {
+            l_wh_form_inventory.setBusinessFormName(this.getBusinessFormName());
+        }
+        if (this.isset_warehouseType) {
+            l_wh_form_inventory.setWarehouseType(this.getWarehouseType());
+        }
+        if (this.isset_warehouseId) {
+            l_wh_form_inventory.setWarehouseId(this.getWarehouseId());
+        }
+        if (this.isset_warehouseName) {
+            l_wh_form_inventory.setWarehouseName(this.getWarehouseName());
+        }
+        if (this.isset_operatorId) {
+            l_wh_form_inventory.setOperatorId(this.getOperatorId());
+        }
+        if (this.isset_operatorName) {
+            l_wh_form_inventory.setOperatorName(this.getOperatorName());
+        }
+        if (this.isset_states) {
+            l_wh_form_inventory.setStates(this.getStates());
+        }
+        if (this.isset_operatorId2) {
+            l_wh_form_inventory.setOperatorId2(this.getOperatorId2());
+        }
+        if (this.isset_operatorName2) {
+            l_wh_form_inventory.setOperatorName2(this.getOperatorName2());
+        }
+        if (this.isset_beiz1) {
+            l_wh_form_inventory.setBeiz1(this.getBeiz1());
+        }
+        if (this.isset_agencyId) {
+            l_wh_form_inventory.setAgencyId(this.getAgencyId());
+        }
+        if (this.isset_agencyName) {
+            l_wh_form_inventory.setAgencyName(this.getAgencyName());
+        }
+        if (this.isset_creatorId) {
+            l_wh_form_inventory.setCreatorId(this.getCreatorId());
+        }
+        if (this.isset_creatorName) {
+            l_wh_form_inventory.setCreatorName(this.getCreatorName());
+        }
+        if (this.isset_inventoryDate) {
+            l_wh_form_inventory.setInventoryDate(this.getInventoryDate());
+        }
+        if (this.isset_createTime) {
+            l_wh_form_inventory.setCreateTime(this.getCreateTime());
+        }
+        if (this.isset_stopTime) {
+            l_wh_form_inventory.setStopTime(this.getStopTime());
+        }
+        return l_wh_form_inventory;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java
new file mode 100644
index 0000000..fb5146d
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java
@@ -0,0 +1,463 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+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;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_INVENTORY *
+ * @author genrator
+ */
+public class LWhFormInventory_mapper extends LWhFormInventory implements BaseMapper<LWhFormInventory> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<LWhFormInventory> ROW_MAPPER = new LWhFormInventoryRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String BusinessFormCode = "business_form_code";
+    public static final String BusinessFormName = "business_form_name";
+    public static final String WarehouseType = "warehouse_type";
+    public static final String WarehouseId = "warehouse_id";
+    public static final String WarehouseName = "warehouse_name";
+    public static final String OperatorId = "operator_id";
+    public static final String OperatorName = "operator_name";
+    public static final String States = "states";
+    public static final String OperatorId2 = "operator_id2";
+    public static final String OperatorName2 = "operator_name2";
+    public static final String Beiz1 = "beiz1";
+    public static final String AgencyId = "agency_id";
+    public static final String AgencyName = "agency_name";
+    public static final String CreatorId = "creator_id";
+    public static final String CreatorName = "creator_name";
+    public static final String InventoryDate = "inventory_date";
+    public static final String CreateTime = "create_time";
+    public static final String StopTime = "stop_time";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormInventory_mapper(LWhFormInventory lWhFormInventory) {
+        if (lWhFormInventory == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (lWhFormInventory.isset_id) {
+            this.setId(lWhFormInventory.getId());
+        }
+        //鏅�氬睘鎬�
+        if (lWhFormInventory.isset_businessFormCode) {
+            this.setBusinessFormCode(lWhFormInventory.getBusinessFormCode());
+        }
+        if (lWhFormInventory.isset_businessFormName) {
+            this.setBusinessFormName(lWhFormInventory.getBusinessFormName());
+        }
+        if (lWhFormInventory.isset_warehouseType) {
+            this.setWarehouseType(lWhFormInventory.getWarehouseType());
+        }
+        if (lWhFormInventory.isset_warehouseId) {
+            this.setWarehouseId(lWhFormInventory.getWarehouseId());
+        }
+        if (lWhFormInventory.isset_warehouseName) {
+            this.setWarehouseName(lWhFormInventory.getWarehouseName());
+        }
+        if (lWhFormInventory.isset_operatorId) {
+            this.setOperatorId(lWhFormInventory.getOperatorId());
+        }
+        if (lWhFormInventory.isset_operatorName) {
+            this.setOperatorName(lWhFormInventory.getOperatorName());
+        }
+        if (lWhFormInventory.isset_states) {
+            this.setStates(lWhFormInventory.getStates());
+        }
+        if (lWhFormInventory.isset_operatorId2) {
+            this.setOperatorId2(lWhFormInventory.getOperatorId2());
+        }
+        if (lWhFormInventory.isset_operatorName2) {
+            this.setOperatorName2(lWhFormInventory.getOperatorName2());
+        }
+        if (lWhFormInventory.isset_beiz1) {
+            this.setBeiz1(lWhFormInventory.getBeiz1());
+        }
+        if (lWhFormInventory.isset_agencyId) {
+            this.setAgencyId(lWhFormInventory.getAgencyId());
+        }
+        if (lWhFormInventory.isset_agencyName) {
+            this.setAgencyName(lWhFormInventory.getAgencyName());
+        }
+        if (lWhFormInventory.isset_creatorId) {
+            this.setCreatorId(lWhFormInventory.getCreatorId());
+        }
+        if (lWhFormInventory.isset_creatorName) {
+            this.setCreatorName(lWhFormInventory.getCreatorName());
+        }
+        if (lWhFormInventory.isset_inventoryDate) {
+            this.setInventoryDate(lWhFormInventory.getInventoryDate());
+        }
+        if (lWhFormInventory.isset_createTime) {
+            this.setCreateTime(lWhFormInventory.getCreateTime());
+        }
+        if (lWhFormInventory.isset_stopTime) {
+            this.setStopTime(lWhFormInventory.getStopTime());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(l_wh_form_inventory.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "l_wh_form_inventory";
+        /**
+        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+            return this.getDatabaseName_() + "." + tableName;
+        } else {
+            return tableName;
+        }
+        */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+        InsertBuilder ib = new InsertBuilder(this.getTableName_());
+        ib.set(Id, this.getId());
+        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ib.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+        ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ib.set(States, this.getStates(), this.isset_states);
+        ib.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
+        ib.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
+        ib.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
+        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ib.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
+        ib.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
+        ib.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
+        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ib.set(StopTime, this.getStopTime(), this.isset_stopTime);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
+        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
+        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
+        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
+        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
+        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
+        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
+        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
+        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
+        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
+        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
+        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
+        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormInventory toLWhFormInventory() {
+        return super.$clone();
+    }
+}
+
+/**
+ * l_wh_form_inventory RowMapper
+ *
+ * @author genrator
+ */
+class LWhFormInventoryRowMapper implements RowMapper<LWhFormInventory> {
+
+    @Override
+    public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        LWhFormInventory l_wh_form_inventory = new LWhFormInventory();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Id);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormCode);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setBusinessFormCode(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormName);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setBusinessFormName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setWarehouseType(null);
+            } else {
+                l_wh_form_inventory.setWarehouseType(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setWarehouseId(null);
+            } else {
+                l_wh_form_inventory.setWarehouseId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseName);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setWarehouseName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setOperatorId(null);
+            } else {
+                l_wh_form_inventory.setOperatorId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setOperatorName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.States);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setStates(null);
+            } else {
+                l_wh_form_inventory.setStates(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId2);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setOperatorId2(null);
+            } else {
+                l_wh_form_inventory.setOperatorId2(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName2);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setOperatorName2(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Beiz1);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setBeiz1(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setAgencyId(null);
+            } else {
+                l_wh_form_inventory.setAgencyId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyName);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setAgencyName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setCreatorId(null);
+            } else {
+                l_wh_form_inventory.setCreatorId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorName);
+        if (columnIndex > 0) {
+            l_wh_form_inventory.setCreatorName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InventoryDate);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setInventoryDate(null);
+            } else {
+                l_wh_form_inventory.setInventoryDate(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreateTime);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setCreateTime(null);
+            } else {
+                l_wh_form_inventory.setCreateTime(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.StopTime);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_inventory.setStopTime(null);
+            } else {
+                l_wh_form_inventory.setStopTime(rs.getLong(columnIndex));
+            }
+        }
+        return l_wh_form_inventory;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java
new file mode 100644
index 0000000..eb4ffd8
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java
@@ -0,0 +1,392 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_SCRAPPED *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class LWhFormScrapped extends BasePo<LWhFormScrapped> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private Long lWarehouseFlowId = null;
+    @JsonIgnore
+    protected boolean isset_lWarehouseFlowId = false;
+
+    private String businessFormCode = null;
+    @JsonIgnore
+    protected boolean isset_businessFormCode = false;
+
+    private Long warehouseId = null;
+    @JsonIgnore
+    protected boolean isset_warehouseId = false;
+
+    private String warehouseName = null;
+    @JsonIgnore
+    protected boolean isset_warehouseName = false;
+
+    private Integer scrappedType = null;
+    @JsonIgnore
+    protected boolean isset_scrappedType = false;
+
+    private Long agencyId = null;
+    @JsonIgnore
+    protected boolean isset_agencyId = false;
+
+    private String agencyName = null;
+    @JsonIgnore
+    protected boolean isset_agencyName = false;
+
+    private Long operatorId = null;
+    @JsonIgnore
+    protected boolean isset_operatorId = false;
+
+    private String operatorName = null;
+    @JsonIgnore
+    protected boolean isset_operatorName = false;
+
+    private Long dealTime = null;
+    @JsonIgnore
+    protected boolean isset_dealTime = false;
+
+    private String departmentId = null;
+    @JsonIgnore
+    protected boolean isset_departmentId = false;
+
+    private Long departmentName = null;
+    @JsonIgnore
+    protected boolean isset_departmentName = false;
+
+    private String uploadFiles = null;
+    @JsonIgnore
+    protected boolean isset_uploadFiles = false;
+
+    private Integer states = null;
+    @JsonIgnore
+    protected boolean isset_states = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormScrapped() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public LWhFormScrapped(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public Long getLWarehouseFlowId() {
+        return this.lWarehouseFlowId;
+    }
+
+    public void setLWarehouseFlowId(Long lWarehouseFlowId) {
+        this.lWarehouseFlowId = lWarehouseFlowId;
+        this.isset_lWarehouseFlowId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyLWarehouseFlowId() {
+        return this.lWarehouseFlowId == null;
+    }
+
+    public String getBusinessFormCode() {
+        return this.businessFormCode;
+    }
+
+    public void setBusinessFormCode(String businessFormCode) {
+        this.businessFormCode = businessFormCode;
+        this.isset_businessFormCode = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBusinessFormCode() {
+        return this.businessFormCode == null || this.businessFormCode.length() == 0;
+    }
+
+    public Long getWarehouseId() {
+        return this.warehouseId;
+    }
+
+    public void setWarehouseId(Long warehouseId) {
+        this.warehouseId = warehouseId;
+        this.isset_warehouseId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseId() {
+        return this.warehouseId == null;
+    }
+
+    public String getWarehouseName() {
+        return this.warehouseName;
+    }
+
+    public void setWarehouseName(String warehouseName) {
+        this.warehouseName = warehouseName;
+        this.isset_warehouseName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseName() {
+        return this.warehouseName == null || this.warehouseName.length() == 0;
+    }
+
+    public Integer getScrappedType() {
+        return this.scrappedType;
+    }
+
+    public void setScrappedType(Integer scrappedType) {
+        this.scrappedType = scrappedType;
+        this.isset_scrappedType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyScrappedType() {
+        return this.scrappedType == null;
+    }
+
+    public Long getAgencyId() {
+        return this.agencyId;
+    }
+
+    public void setAgencyId(Long agencyId) {
+        this.agencyId = agencyId;
+        this.isset_agencyId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyId() {
+        return this.agencyId == null;
+    }
+
+    public String getAgencyName() {
+        return this.agencyName;
+    }
+
+    public void setAgencyName(String agencyName) {
+        this.agencyName = agencyName;
+        this.isset_agencyName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyName() {
+        return this.agencyName == null || this.agencyName.length() == 0;
+    }
+
+    public Long getOperatorId() {
+        return this.operatorId;
+    }
+
+    public void setOperatorId(Long operatorId) {
+        this.operatorId = operatorId;
+        this.isset_operatorId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorId() {
+        return this.operatorId == null;
+    }
+
+    public String getOperatorName() {
+        return this.operatorName;
+    }
+
+    public void setOperatorName(String operatorName) {
+        this.operatorName = operatorName;
+        this.isset_operatorName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorName() {
+        return this.operatorName == null || this.operatorName.length() == 0;
+    }
+
+    public Long getDealTime() {
+        return this.dealTime;
+    }
+
+    public void setDealTime(Long dealTime) {
+        this.dealTime = dealTime;
+        this.isset_dealTime = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDealTime() {
+        return this.dealTime == null;
+    }
+
+    public String getDepartmentId() {
+        return this.departmentId;
+    }
+
+    public void setDepartmentId(String departmentId) {
+        this.departmentId = departmentId;
+        this.isset_departmentId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDepartmentId() {
+        return this.departmentId == null || this.departmentId.length() == 0;
+    }
+
+    public Long getDepartmentName() {
+        return this.departmentName;
+    }
+
+    public void setDepartmentName(Long departmentName) {
+        this.departmentName = departmentName;
+        this.isset_departmentName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDepartmentName() {
+        return this.departmentName == null;
+    }
+
+    public String getUploadFiles() {
+        return this.uploadFiles;
+    }
+
+    public void setUploadFiles(String uploadFiles) {
+        this.uploadFiles = uploadFiles;
+        this.isset_uploadFiles = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUploadFiles() {
+        return this.uploadFiles == null || this.uploadFiles.length() == 0;
+    }
+
+    public Integer getStates() {
+        return this.states;
+    }
+
+    public void setStates(Integer states) {
+        this.states = states;
+        this.isset_states = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyStates() {
+        return this.states == null;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+                .append("id=").append(this.id)
+                .append("lWarehouseFlowId=").append(this.lWarehouseFlowId)
+                .append("businessFormCode=").append(this.businessFormCode)
+                .append("warehouseId=").append(this.warehouseId)
+                .append("warehouseName=").append(this.warehouseName)
+                .append("scrappedType=").append(this.scrappedType)
+                .append("agencyId=").append(this.agencyId)
+                .append("agencyName=").append(this.agencyName)
+                .append("operatorId=").append(this.operatorId)
+                .append("operatorName=").append(this.operatorName)
+                .append("dealTime=").append(this.dealTime)
+                .append("departmentId=").append(this.departmentId)
+                .append("departmentName=").append(this.departmentName)
+                .append("uploadFiles=").append(this.uploadFiles)
+                .append("states=").append(this.states)
+                .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormScrapped $clone() {
+        LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped();
+
+        // 鏁版嵁搴撳悕绉�
+        //l_wh_form_scrapped.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            l_wh_form_scrapped.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_lWarehouseFlowId) {
+            l_wh_form_scrapped.setLWarehouseFlowId(this.getLWarehouseFlowId());
+        }
+        if (this.isset_businessFormCode) {
+            l_wh_form_scrapped.setBusinessFormCode(this.getBusinessFormCode());
+        }
+        if (this.isset_warehouseId) {
+            l_wh_form_scrapped.setWarehouseId(this.getWarehouseId());
+        }
+        if (this.isset_warehouseName) {
+            l_wh_form_scrapped.setWarehouseName(this.getWarehouseName());
+        }
+        if (this.isset_scrappedType) {
+            l_wh_form_scrapped.setScrappedType(this.getScrappedType());
+        }
+        if (this.isset_agencyId) {
+            l_wh_form_scrapped.setAgencyId(this.getAgencyId());
+        }
+        if (this.isset_agencyName) {
+            l_wh_form_scrapped.setAgencyName(this.getAgencyName());
+        }
+        if (this.isset_operatorId) {
+            l_wh_form_scrapped.setOperatorId(this.getOperatorId());
+        }
+        if (this.isset_operatorName) {
+            l_wh_form_scrapped.setOperatorName(this.getOperatorName());
+        }
+        if (this.isset_dealTime) {
+            l_wh_form_scrapped.setDealTime(this.getDealTime());
+        }
+        if (this.isset_departmentId) {
+            l_wh_form_scrapped.setDepartmentId(this.getDepartmentId());
+        }
+        if (this.isset_departmentName) {
+            l_wh_form_scrapped.setDepartmentName(this.getDepartmentName());
+        }
+        if (this.isset_uploadFiles) {
+            l_wh_form_scrapped.setUploadFiles(this.getUploadFiles());
+        }
+        if (this.isset_states) {
+            l_wh_form_scrapped.setStates(this.getStates());
+        }
+        return l_wh_form_scrapped;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java
new file mode 100644
index 0000000..66b1fd6
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java
@@ -0,0 +1,370 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_SCRAPPED_GOODS *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class LWhFormScrappedGoods extends BasePo<LWhFormScrappedGoods> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private Integer counts = null;
+    @JsonIgnore
+    protected boolean isset_counts = false;
+
+    private String scrappedCode = null;
+    @JsonIgnore
+    protected boolean isset_scrappedCode = false;
+
+    private String scrappedName = null;
+    @JsonIgnore
+    protected boolean isset_scrappedName = false;
+
+    private String beiz = null;
+    @JsonIgnore
+    protected boolean isset_beiz = false;
+
+    private Long formScrappedId = null;
+    @JsonIgnore
+    protected boolean isset_formScrappedId = false;
+
+    private Long baseGoodsTemplateId = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsTemplateId = false;
+
+    private String goodsTemplateName = null;
+    @JsonIgnore
+    protected boolean isset_goodsTemplateName = false;
+
+    private String unit = null;
+    @JsonIgnore
+    protected boolean isset_unit = false;
+
+    private Long baseGoodsModelsId = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsModelsId = false;
+
+    private String baseGoodsModelsName = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsModelsName = false;
+
+    private Long transBusinessId = null;
+    @JsonIgnore
+    protected boolean isset_transBusinessId = false;
+
+    private String userName = null;
+    @JsonIgnore
+    protected boolean isset_userName = false;
+
+    private Long sort = null;
+    @JsonIgnore
+    protected boolean isset_sort = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormScrappedGoods() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public LWhFormScrappedGoods(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public Integer getCounts() {
+        return this.counts;
+    }
+
+    public void setCounts(Integer counts) {
+        this.counts = counts;
+        this.isset_counts = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCounts() {
+        return this.counts == null;
+    }
+
+    public String getScrappedCode() {
+        return this.scrappedCode;
+    }
+
+    public void setScrappedCode(String scrappedCode) {
+        this.scrappedCode = scrappedCode;
+        this.isset_scrappedCode = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyScrappedCode() {
+        return this.scrappedCode == null || this.scrappedCode.length() == 0;
+    }
+
+    public String getScrappedName() {
+        return this.scrappedName;
+    }
+
+    public void setScrappedName(String scrappedName) {
+        this.scrappedName = scrappedName;
+        this.isset_scrappedName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyScrappedName() {
+        return this.scrappedName == null || this.scrappedName.length() == 0;
+    }
+
+    public String getBeiz() {
+        return this.beiz;
+    }
+
+    public void setBeiz(String beiz) {
+        this.beiz = beiz;
+        this.isset_beiz = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBeiz() {
+        return this.beiz == null || this.beiz.length() == 0;
+    }
+
+    public Long getFormScrappedId() {
+        return this.formScrappedId;
+    }
+
+    public void setFormScrappedId(Long formScrappedId) {
+        this.formScrappedId = formScrappedId;
+        this.isset_formScrappedId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyFormScrappedId() {
+        return this.formScrappedId == null;
+    }
+
+    public Long getBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId;
+    }
+
+    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
+        this.baseGoodsTemplateId = baseGoodsTemplateId;
+        this.isset_baseGoodsTemplateId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId == null;
+    }
+
+    public String getGoodsTemplateName() {
+        return this.goodsTemplateName;
+    }
+
+    public void setGoodsTemplateName(String goodsTemplateName) {
+        this.goodsTemplateName = goodsTemplateName;
+        this.isset_goodsTemplateName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyGoodsTemplateName() {
+        return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
+    }
+
+    public String getUnit() {
+        return this.unit;
+    }
+
+    public void setUnit(String unit) {
+        this.unit = unit;
+        this.isset_unit = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUnit() {
+        return this.unit == null || this.unit.length() == 0;
+    }
+
+    public Long getBaseGoodsModelsId() {
+        return this.baseGoodsModelsId;
+    }
+
+    public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
+        this.baseGoodsModelsId = baseGoodsModelsId;
+        this.isset_baseGoodsModelsId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsModelsId() {
+        return this.baseGoodsModelsId == null;
+    }
+
+    public String getBaseGoodsModelsName() {
+        return this.baseGoodsModelsName;
+    }
+
+    public void setBaseGoodsModelsName(String baseGoodsModelsName) {
+        this.baseGoodsModelsName = baseGoodsModelsName;
+        this.isset_baseGoodsModelsName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsModelsName() {
+        return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
+    }
+
+    public Long getTransBusinessId() {
+        return this.transBusinessId;
+    }
+
+    public void setTransBusinessId(Long transBusinessId) {
+        this.transBusinessId = transBusinessId;
+        this.isset_transBusinessId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyTransBusinessId() {
+        return this.transBusinessId == null;
+    }
+
+    public String getUserName() {
+        return this.userName;
+    }
+
+    public void setUserName(String userName) {
+        this.userName = userName;
+        this.isset_userName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUserName() {
+        return this.userName == null || this.userName.length() == 0;
+    }
+
+    public Long getSort() {
+        return this.sort;
+    }
+
+    public void setSort(Long sort) {
+        this.sort = sort;
+        this.isset_sort = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptySort() {
+        return this.sort == null;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+                .append("id=").append(this.id)
+                .append("counts=").append(this.counts)
+                .append("scrappedCode=").append(this.scrappedCode)
+                .append("scrappedName=").append(this.scrappedName)
+                .append("beiz=").append(this.beiz)
+                .append("formScrappedId=").append(this.formScrappedId)
+                .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
+                .append("goodsTemplateName=").append(this.goodsTemplateName)
+                .append("unit=").append(this.unit)
+                .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
+                .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
+                .append("transBusinessId=").append(this.transBusinessId)
+                .append("userName=").append(this.userName)
+                .append("sort=").append(this.sort)
+                .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormScrappedGoods $clone() {
+        LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods();
+
+        // 鏁版嵁搴撳悕绉�
+        //l_wh_form_scrapped_goods.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            l_wh_form_scrapped_goods.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_counts) {
+            l_wh_form_scrapped_goods.setCounts(this.getCounts());
+        }
+        if (this.isset_scrappedCode) {
+            l_wh_form_scrapped_goods.setScrappedCode(this.getScrappedCode());
+        }
+        if (this.isset_scrappedName) {
+            l_wh_form_scrapped_goods.setScrappedName(this.getScrappedName());
+        }
+        if (this.isset_beiz) {
+            l_wh_form_scrapped_goods.setBeiz(this.getBeiz());
+        }
+        if (this.isset_formScrappedId) {
+            l_wh_form_scrapped_goods.setFormScrappedId(this.getFormScrappedId());
+        }
+        if (this.isset_baseGoodsTemplateId) {
+            l_wh_form_scrapped_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
+        }
+        if (this.isset_goodsTemplateName) {
+            l_wh_form_scrapped_goods.setGoodsTemplateName(this.getGoodsTemplateName());
+        }
+        if (this.isset_unit) {
+            l_wh_form_scrapped_goods.setUnit(this.getUnit());
+        }
+        if (this.isset_baseGoodsModelsId) {
+            l_wh_form_scrapped_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
+        }
+        if (this.isset_baseGoodsModelsName) {
+            l_wh_form_scrapped_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
+        }
+        if (this.isset_transBusinessId) {
+            l_wh_form_scrapped_goods.setTransBusinessId(this.getTransBusinessId());
+        }
+        if (this.isset_userName) {
+            l_wh_form_scrapped_goods.setUserName(this.getUserName());
+        }
+        if (this.isset_sort) {
+            l_wh_form_scrapped_goods.setSort(this.getSort());
+        }
+        return l_wh_form_scrapped_goods;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java
new file mode 100644
index 0000000..e877fcc
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java
@@ -0,0 +1,389 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+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;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_SCRAPPED_GOODS *
+ * @author genrator
+ */
+public class LWhFormScrappedGoods_mapper extends LWhFormScrappedGoods implements BaseMapper<LWhFormScrappedGoods> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<LWhFormScrappedGoods> ROW_MAPPER = new LWhFormScrappedGoodsRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String Counts = "counts";
+    public static final String ScrappedCode = "scrapped_code";
+    public static final String ScrappedName = "scrapped_name";
+    public static final String Beiz = "beiz";
+    public static final String FormScrappedId = "form_scrapped_id";
+    public static final String BaseGoodsTemplateId = "base_goods_template_id";
+    public static final String GoodsTemplateName = "goods_template_name";
+    public static final String Unit = "unit";
+    public static final String BaseGoodsModelsId = "base_goods_models_id";
+    public static final String BaseGoodsModelsName = "base_goods_models_name";
+    public static final String TransBusinessId = "trans_business_id";
+    public static final String UserName = "user_name";
+    public static final String Sort = "sort";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormScrappedGoods_mapper(LWhFormScrappedGoods lWhFormScrappedGoods) {
+        if (lWhFormScrappedGoods == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (lWhFormScrappedGoods.isset_id) {
+            this.setId(lWhFormScrappedGoods.getId());
+        }
+        //鏅�氬睘鎬�
+        if (lWhFormScrappedGoods.isset_counts) {
+            this.setCounts(lWhFormScrappedGoods.getCounts());
+        }
+        if (lWhFormScrappedGoods.isset_scrappedCode) {
+            this.setScrappedCode(lWhFormScrappedGoods.getScrappedCode());
+        }
+        if (lWhFormScrappedGoods.isset_scrappedName) {
+            this.setScrappedName(lWhFormScrappedGoods.getScrappedName());
+        }
+        if (lWhFormScrappedGoods.isset_beiz) {
+            this.setBeiz(lWhFormScrappedGoods.getBeiz());
+        }
+        if (lWhFormScrappedGoods.isset_formScrappedId) {
+            this.setFormScrappedId(lWhFormScrappedGoods.getFormScrappedId());
+        }
+        if (lWhFormScrappedGoods.isset_baseGoodsTemplateId) {
+            this.setBaseGoodsTemplateId(lWhFormScrappedGoods.getBaseGoodsTemplateId());
+        }
+        if (lWhFormScrappedGoods.isset_goodsTemplateName) {
+            this.setGoodsTemplateName(lWhFormScrappedGoods.getGoodsTemplateName());
+        }
+        if (lWhFormScrappedGoods.isset_unit) {
+            this.setUnit(lWhFormScrappedGoods.getUnit());
+        }
+        if (lWhFormScrappedGoods.isset_baseGoodsModelsId) {
+            this.setBaseGoodsModelsId(lWhFormScrappedGoods.getBaseGoodsModelsId());
+        }
+        if (lWhFormScrappedGoods.isset_baseGoodsModelsName) {
+            this.setBaseGoodsModelsName(lWhFormScrappedGoods.getBaseGoodsModelsName());
+        }
+        if (lWhFormScrappedGoods.isset_transBusinessId) {
+            this.setTransBusinessId(lWhFormScrappedGoods.getTransBusinessId());
+        }
+        if (lWhFormScrappedGoods.isset_userName) {
+            this.setUserName(lWhFormScrappedGoods.getUserName());
+        }
+        if (lWhFormScrappedGoods.isset_sort) {
+            this.setSort(lWhFormScrappedGoods.getSort());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(l_wh_form_scrapped_goods.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "l_wh_form_scrapped_goods";
+        /**
+        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+            return this.getDatabaseName_() + "." + tableName;
+        } else {
+            return tableName;
+        }
+        */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+        InsertBuilder ib = new InsertBuilder(this.getTableName_());
+        ib.set(Id, this.getId());
+        ib.set(Counts, this.getCounts(), this.isset_counts);
+        ib.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
+        ib.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
+        ib.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ib.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
+        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
+        ib.set(Unit, this.getUnit(), this.isset_unit);
+        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ib.set(UserName, this.getUserName(), this.isset_userName);
+        ib.set(Sort, this.getSort(), this.isset_sort);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
+        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(UserName, this.getUserName(), this.isset_userName);
+        ub.set(Sort, this.getSort(), this.isset_sort);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
+        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(UserName, this.getUserName(), this.isset_userName);
+        ub.set(Sort, this.getSort(), this.isset_sort);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
+        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(UserName, this.getUserName(), this.isset_userName);
+        ub.set(Sort, this.getSort(), this.isset_sort);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>("select id, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>("select id, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormScrappedGoods toLWhFormScrappedGoods() {
+        return super.$clone();
+    }
+}
+
+/**
+ * l_wh_form_scrapped_goods RowMapper
+ *
+ * @author genrator
+ */
+class LWhFormScrappedGoodsRowMapper implements RowMapper<LWhFormScrappedGoods> {
+
+    @Override
+    public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Id);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Counts);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setCounts(null);
+            } else {
+                l_wh_form_scrapped_goods.setCounts(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedCode);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setScrappedCode(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setScrappedName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Beiz);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setBeiz(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.FormScrappedId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setFormScrappedId(null);
+            } else {
+                l_wh_form_scrapped_goods.setFormScrappedId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsTemplateId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setBaseGoodsTemplateId(null);
+            } else {
+                l_wh_form_scrapped_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.GoodsTemplateName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setGoodsTemplateName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Unit);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setUnit(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setBaseGoodsModelsId(null);
+            } else {
+                l_wh_form_scrapped_goods.setBaseGoodsModelsId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setBaseGoodsModelsName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.TransBusinessId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setTransBusinessId(null);
+            } else {
+                l_wh_form_scrapped_goods.setTransBusinessId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.UserName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped_goods.setUserName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Sort);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped_goods.setSort(null);
+            } else {
+                l_wh_form_scrapped_goods.setSort(rs.getLong(columnIndex));
+            }
+        }
+        return l_wh_form_scrapped_goods;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java
new file mode 100644
index 0000000..30a7746
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java
@@ -0,0 +1,409 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+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;
+import java.sql.SQLException;
+import java.util.Map;
+
+/**
+ * 琛ㄥ悕:L_WH_FORM_SCRAPPED *
+ * @author genrator
+ */
+public class LWhFormScrapped_mapper extends LWhFormScrapped implements BaseMapper<LWhFormScrapped> {
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<LWhFormScrapped> ROW_MAPPER = new LWhFormScrappedRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String LWarehouseFlowId = "l_warehouse_flow_id";
+    public static final String BusinessFormCode = "business_form_code";
+    public static final String WarehouseId = "warehouse_id";
+    public static final String WarehouseName = "warehouse_name";
+    public static final String ScrappedType = "scrapped_type";
+    public static final String AgencyId = "agency_id";
+    public static final String AgencyName = "agency_name";
+    public static final String OperatorId = "operator_id";
+    public static final String OperatorName = "operator_name";
+    public static final String DealTime = "deal_time";
+    public static final String DepartmentId = "department_id";
+    public static final String DepartmentName = "department_name";
+    public static final String UploadFiles = "upload_files";
+    public static final String States = "states";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public LWhFormScrapped_mapper(LWhFormScrapped lWhFormScrapped) {
+        if (lWhFormScrapped == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (lWhFormScrapped.isset_id) {
+            this.setId(lWhFormScrapped.getId());
+        }
+        //鏅�氬睘鎬�
+        if (lWhFormScrapped.isset_lWarehouseFlowId) {
+            this.setLWarehouseFlowId(lWhFormScrapped.getLWarehouseFlowId());
+        }
+        if (lWhFormScrapped.isset_businessFormCode) {
+            this.setBusinessFormCode(lWhFormScrapped.getBusinessFormCode());
+        }
+        if (lWhFormScrapped.isset_warehouseId) {
+            this.setWarehouseId(lWhFormScrapped.getWarehouseId());
+        }
+        if (lWhFormScrapped.isset_warehouseName) {
+            this.setWarehouseName(lWhFormScrapped.getWarehouseName());
+        }
+        if (lWhFormScrapped.isset_scrappedType) {
+            this.setScrappedType(lWhFormScrapped.getScrappedType());
+        }
+        if (lWhFormScrapped.isset_agencyId) {
+            this.setAgencyId(lWhFormScrapped.getAgencyId());
+        }
+        if (lWhFormScrapped.isset_agencyName) {
+            this.setAgencyName(lWhFormScrapped.getAgencyName());
+        }
+        if (lWhFormScrapped.isset_operatorId) {
+            this.setOperatorId(lWhFormScrapped.getOperatorId());
+        }
+        if (lWhFormScrapped.isset_operatorName) {
+            this.setOperatorName(lWhFormScrapped.getOperatorName());
+        }
+        if (lWhFormScrapped.isset_dealTime) {
+            this.setDealTime(lWhFormScrapped.getDealTime());
+        }
+        if (lWhFormScrapped.isset_departmentId) {
+            this.setDepartmentId(lWhFormScrapped.getDepartmentId());
+        }
+        if (lWhFormScrapped.isset_departmentName) {
+            this.setDepartmentName(lWhFormScrapped.getDepartmentName());
+        }
+        if (lWhFormScrapped.isset_uploadFiles) {
+            this.setUploadFiles(lWhFormScrapped.getUploadFiles());
+        }
+        if (lWhFormScrapped.isset_states) {
+            this.setStates(lWhFormScrapped.getStates());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(l_wh_form_scrapped.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "l_wh_form_scrapped";
+        /**
+        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+            return this.getDatabaseName_() + "." + tableName;
+        } else {
+            return tableName;
+        }
+        */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    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(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ib.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
+        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ib.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
+        ib.set(States, this.getStates(), this.isset_states);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @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(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
+        ub.set(States, this.getStates(), this.isset_states);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @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(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
+        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
+        ub.set(States, this.getStates(), this.isset_states);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public LWhFormScrapped toLWhFormScrapped() {
+        return super.$clone();
+    }
+}
+
+/**
+ * l_wh_form_scrapped RowMapper
+ *
+ * @author genrator
+ */
+class LWhFormScrappedRowMapper implements RowMapper<LWhFormScrapped> {
+
+    @Override
+    public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.Id);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.LWarehouseFlowId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setLWarehouseFlowId(null);
+            } else {
+                l_wh_form_scrapped.setLWarehouseFlowId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.BusinessFormCode);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setBusinessFormCode(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setWarehouseId(null);
+            } else {
+                l_wh_form_scrapped.setWarehouseId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setWarehouseName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.ScrappedType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setScrappedType(null);
+            } else {
+                l_wh_form_scrapped.setScrappedType(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setAgencyId(null);
+            } else {
+                l_wh_form_scrapped.setAgencyId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setAgencyName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setOperatorId(null);
+            } else {
+                l_wh_form_scrapped.setOperatorId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorName);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setOperatorName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DealTime);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setDealTime(null);
+            } else {
+                l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setDepartmentId(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentName);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setDepartmentName(null);
+            } else {
+                l_wh_form_scrapped.setDepartmentName(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.UploadFiles);
+        if (columnIndex > 0) {
+            l_wh_form_scrapped.setUploadFiles(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.States);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_form_scrapped.setStates(null);
+            } else {
+                l_wh_form_scrapped.setStates(rs.getInt(columnIndex));
+            }
+        }
+        return l_wh_form_scrapped;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java
index 5bb2173..e33e012 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java
@@ -20,6 +20,10 @@
     protected boolean isset_id = false;
 
     // 灞炴�у垪琛�
+    private Integer warehouseType = null;
+    @JsonIgnore
+    protected boolean isset_warehouseType = false;
+
     private Long warehouseId = null;
     @JsonIgnore
     protected boolean isset_warehouseId = false;
@@ -105,6 +109,20 @@
     @JsonIgnore
     public boolean isEmptyId() {
         return this.id == null;
+    }
+
+    public Integer getWarehouseType() {
+        return this.warehouseType;
+    }
+
+    public void setWarehouseType(Integer warehouseType) {
+        this.warehouseType = warehouseType;
+        this.isset_warehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyWarehouseType() {
+        return this.warehouseType == null;
     }
 
     public Long getWarehouseId() {
@@ -296,6 +314,7 @@
     public String toString() {
         return new StringBuilder()
                 .append("id=").append(this.id)
+                .append("warehouseType=").append(this.warehouseType)
                 .append("warehouseId=").append(this.warehouseId)
                 .append("warehouseName=").append(this.warehouseName)
                 .append("costType=").append(this.costType)
@@ -326,6 +345,9 @@
             l_wh_goods.setId(this.getId());
         }
         // 鏅�氬睘鎬�
+        if (this.isset_warehouseType) {
+            l_wh_goods.setWarehouseType(this.getWarehouseType());
+        }
         if (this.isset_warehouseId) {
             l_wh_goods.setWarehouseId(this.getWarehouseId());
         }
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
index 0c08812..d923b0c 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
@@ -28,6 +28,7 @@
     // 涓婚敭
     public static final String Id = "id";
     // 鏅�氬睘鎬�
+    public static final String WarehouseType = "warehouse_type";
     public static final String WarehouseId = "warehouse_id";
     public static final String WarehouseName = "warehouse_name";
     public static final String CostType = "cost_type";
@@ -54,6 +55,9 @@
             this.setId(lWhGoods.getId());
         }
         //鏅�氬睘鎬�
+        if (lWhGoods.isset_warehouseType) {
+            this.setWarehouseType(lWhGoods.getWarehouseType());
+        }
         if (lWhGoods.isset_warehouseId) {
             this.setWarehouseId(lWhGoods.getWarehouseId());
         }
@@ -136,6 +140,7 @@
     public SqlAndParameters<Map<String, Object>> getInsertSql_() {
         InsertBuilder ib = new InsertBuilder(this.getTableName_());
         ib.set(Id, this.getId());
+        ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ib.set(CostType, this.getCostType(), this.isset_costType);
@@ -158,6 +163,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -181,6 +187,7 @@
     @Override
     public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -203,6 +210,7 @@
     @Override
     public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
         UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
         ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
         ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
         ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -263,7 +271,7 @@
      */
     @Override
     public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
-        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -271,7 +279,7 @@
      */
     @Override
     public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
-        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -308,6 +316,14 @@
             l_wh_goods.setId(rs.getLong(columnIndex));
         }
         //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                l_wh_goods.setWarehouseType(null);
+            } else {
+                l_wh_goods.setWarehouseType(rs.getInt(columnIndex));
+            }
+        }
         columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId);
         if (columnIndex > 0) {
             if (rs.getBigDecimal(columnIndex) == null) {

--
Gitblit v1.9.1