From b82ed8cbcc9e262f2bce2a662f8ce0d8c59b5d70 Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期一, 30 十月 2023 17:35:13 +0800
Subject: [PATCH] 调拨管理、物品管理、物品分类 相关代码

---
 consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java |   16 ++++++++++++++--
 1 files changed, 14 insertions(+), 2 deletions(-)

diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java
index 108c247..1394af4 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseGoodsTemplate_mapper.java
@@ -33,6 +33,7 @@
     public static final String Classification = "classification";
     public static final String States = "states";
     public static final String CategoryId = "category_id";
+    public static final String CategoryName = "category_name";
     public static final String FAgencyId = "f_agency_id";
     public static final String SAgencyId = "s_agency_id";
     public static final String TAgencyId = "t_agency_id";
@@ -71,6 +72,9 @@
         }
         if (baseGoodsTemplate.isset_categoryId) {
             this.setCategoryId(baseGoodsTemplate.getCategoryId());
+        }
+        if (baseGoodsTemplate.isset_categoryName) {
+            this.setCategoryName(baseGoodsTemplate.getCategoryName());
         }
         if (baseGoodsTemplate.isset_fAgencyId) {
             this.setFAgencyId(baseGoodsTemplate.getFAgencyId());
@@ -153,6 +157,7 @@
         ib.set(Classification, this.getClassification(), this.isset_classification);
         ib.set(States, this.getStates(), this.isset_states);
         ib.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+        ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
         ib.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
         ib.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
         ib.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
@@ -178,6 +183,7 @@
         ub.set(Classification, this.getClassification(), this.isset_classification);
         ub.set(States, this.getStates(), this.isset_states);
         ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
         ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
         ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
         ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
@@ -204,6 +210,7 @@
         ub.set(Classification, this.getClassification(), this.isset_classification);
         ub.set(States, this.getStates(), this.isset_states);
         ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
         ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
         ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
         ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
@@ -229,6 +236,7 @@
         ub.set(Classification, this.getClassification(), this.isset_classification);
         ub.set(States, this.getStates(), this.isset_states);
         ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
         ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId);
         ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId);
         ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId);
@@ -287,7 +295,7 @@
      */
     @Override
     public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
-        return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, category_name, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -295,7 +303,7 @@
      */
     @Override
     public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
-        return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters);
+        return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, category_name, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters);
     }
 
     /**
@@ -360,6 +368,10 @@
                 base_goods_template.setCategoryId(rs.getLong(columnIndex));
             }
         }
+        columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.CategoryName);
+        if (columnIndex > 0) {
+            base_goods_template.setCategoryName(rs.getString(columnIndex));
+        }
         columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.FAgencyId);
         if (columnIndex > 0) {
             if (rs.getBigDecimal(columnIndex) == null) {

--
Gitblit v1.9.1