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