From b7a353e571a503a3dfb970af069efc0a65208839 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期六, 02 十二月 2023 18:08:53 +0800 Subject: [PATCH] feat: 部门物品报废 --- consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java | 20 ++++++++++++++++++-- 1 files changed, 18 insertions(+), 2 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java index f1dd9c7..e00bfe2 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java @@ -45,6 +45,7 @@ public static final String Counts = "counts"; public static final String GoodsUserName = "goods_user_name"; public static final String Beiz = "beiz"; + public static final String TotalAmount = "total_amount"; /** * 榛樿鏋勯�犲嚱鏁� @@ -106,6 +107,9 @@ if (depFormScrappedModel.isset_beiz) { this.setBeiz(depFormScrappedModel.getBeiz()); } + if (depFormScrappedModel.isset_totalAmount) { + this.setTotalAmount(depFormScrappedModel.getTotalAmount()); + } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(dep_form_scrapped_model.getDatabaseName_()); } @@ -165,6 +169,7 @@ ib.set(Counts, this.getCounts(), this.isset_counts); ib.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); ib.set(Beiz, this.getBeiz(), this.isset_beiz); + ib.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ib.genMapSql(); } @@ -190,6 +195,7 @@ ub.set(Counts, this.getCounts(), this.isset_counts); ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -216,6 +222,7 @@ ub.set(Counts, this.getCounts(), this.isset_counts); ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ub.genMapSql(where, parameters); } @@ -241,6 +248,7 @@ ub.set(Counts, this.getCounts(), this.isset_counts); ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ub.genArraySql(where, parameters); } @@ -288,7 +296,7 @@ */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); } /** @@ -296,7 +304,7 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); } /** @@ -433,6 +441,14 @@ if (columnIndex > 0) { dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); } + columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.TotalAmount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { +dep_form_scrapped_model.setTotalAmount(null); + } else { +dep_form_scrapped_model.setTotalAmount(rs.getInt(columnIndex)); + } + } return dep_form_scrapped_model; } } -- Gitblit v1.9.1