From 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期五, 01 十二月 2023 09:38:56 +0800
Subject: [PATCH] feat: 部门退回/报废公用接口
---
consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedGoods_mapper.java | 207 +++++++++++++++++++++++++--------------------------
1 files changed, 101 insertions(+), 106 deletions(-)
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedGoods_mapper.java
index 20cfde6..4b5c405 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedGoods_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedGoods_mapper.java
@@ -7,8 +7,6 @@
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;
@@ -16,7 +14,8 @@
import java.util.Map;
/**
- * 琛ㄥ悕:DEP_FORM_SCRAPPED_GOODS *
+ * 琛ㄥ悕:DEP_FORM_SCRAPPED_GOODS
+ *
* @author genrator
*/
public class DepFormScrappedGoods_mapper extends DepFormScrappedGoods implements BaseMapper<DepFormScrappedGoods> {
@@ -28,15 +27,15 @@
// 涓婚敭
public static final String Id = "id";
// 鏅�氬睘鎬�
- public static final String ScrappedCounts = "scrapped_counts";
- public static final String InitCount = "init_count";
public static final String DepFormScrappedId = "dep_form_scrapped_id";
- public static final String Beiz = "beiz";
- public static final String ScrappedCode = "scrapped_code";
- public static final String ScrappedName = "scrapped_name";
- public static final String DepFormLendingGoodsId = "dep_form_lending_goods_id";
- public static final String DepFormLendingId = "dep_form_lending_id";
- public static final String WarehouseId = "warehouse_id";
+ public static final String BaseGoodsTemplateId = "base_goods_template_id";
+ public static final String BaseGoodsTemplateName = "base_goods_template_name";
+ public static final String CategoryName = "category_name";
+ public static final String Classification = "classification";
+ public static final String TransBusinessId = "trans_business_id";
+ public static final String BusinessFormCode = "business_form_code";
+ public static final String TransOutWarehouseType = "trans_out_warehouse_type";
+ public static final String TransOutWarehouseId = "trans_out_warehouse_id";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -50,32 +49,32 @@
this.setId(depFormScrappedGoods.getId());
}
//鏅�氬睘鎬�
- if (depFormScrappedGoods.isset_scrappedCounts) {
- this.setScrappedCounts(depFormScrappedGoods.getScrappedCounts());
- }
- if (depFormScrappedGoods.isset_initCount) {
- this.setInitCount(depFormScrappedGoods.getInitCount());
- }
if (depFormScrappedGoods.isset_depFormScrappedId) {
this.setDepFormScrappedId(depFormScrappedGoods.getDepFormScrappedId());
}
- if (depFormScrappedGoods.isset_beiz) {
- this.setBeiz(depFormScrappedGoods.getBeiz());
+ if (depFormScrappedGoods.isset_baseGoodsTemplateId) {
+ this.setBaseGoodsTemplateId(depFormScrappedGoods.getBaseGoodsTemplateId());
}
- if (depFormScrappedGoods.isset_scrappedCode) {
- this.setScrappedCode(depFormScrappedGoods.getScrappedCode());
+ if (depFormScrappedGoods.isset_baseGoodsTemplateName) {
+ this.setBaseGoodsTemplateName(depFormScrappedGoods.getBaseGoodsTemplateName());
}
- if (depFormScrappedGoods.isset_scrappedName) {
- this.setScrappedName(depFormScrappedGoods.getScrappedName());
+ if (depFormScrappedGoods.isset_categoryName) {
+ this.setCategoryName(depFormScrappedGoods.getCategoryName());
}
- if (depFormScrappedGoods.isset_depFormLendingGoodsId) {
- this.setDepFormLendingGoodsId(depFormScrappedGoods.getDepFormLendingGoodsId());
+ if (depFormScrappedGoods.isset_classification) {
+ this.setClassification(depFormScrappedGoods.getClassification());
}
- if (depFormScrappedGoods.isset_depFormLendingId) {
- this.setDepFormLendingId(depFormScrappedGoods.getDepFormLendingId());
+ if (depFormScrappedGoods.isset_transBusinessId) {
+ this.setTransBusinessId(depFormScrappedGoods.getTransBusinessId());
}
- if (depFormScrappedGoods.isset_warehouseId) {
- this.setWarehouseId(depFormScrappedGoods.getWarehouseId());
+ if (depFormScrappedGoods.isset_businessFormCode) {
+ this.setBusinessFormCode(depFormScrappedGoods.getBusinessFormCode());
+ }
+ if (depFormScrappedGoods.isset_transOutWarehouseType) {
+ this.setTransOutWarehouseType(depFormScrappedGoods.getTransOutWarehouseType());
+ }
+ if (depFormScrappedGoods.isset_transOutWarehouseId) {
+ this.setTransOutWarehouseId(depFormScrappedGoods.getTransOutWarehouseId());
}
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(dep_form_scrapped_goods.getDatabaseName_());
@@ -88,12 +87,12 @@
public String getTableName_() {
String tableName = "dep_form_scrapped_goods";
/**
- if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
- return this.getDatabaseName_() + "." + tableName;
- } else {
- return tableName;
- }
- */
+ if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+ return this.getDatabaseName_() + "." + tableName;
+ } else {
+ return tableName;
+ }
+ */
return tableName;
}
@@ -120,15 +119,15 @@
public SqlAndParameters<Map<String, Object>> getInsertSql_() {
InsertBuilder ib = new InsertBuilder(this.getTableName_());
ib.set(Id, this.getId());
- ib.set(ScrappedCounts, this.getScrappedCounts(), this.isset_scrappedCounts);
- ib.set(InitCount, this.getInitCount(), this.isset_initCount);
ib.set(DepFormScrappedId, this.getDepFormScrappedId(), this.isset_depFormScrappedId);
- ib.set(Beiz, this.getBeiz(), this.isset_beiz);
- ib.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
- ib.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
- ib.set(DepFormLendingGoodsId, this.getDepFormLendingGoodsId(), this.isset_depFormLendingGoodsId);
- ib.set(DepFormLendingId, this.getDepFormLendingId(), this.isset_depFormLendingId);
- ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+ ib.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+ ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ib.set(Classification, this.getClassification(), this.isset_classification);
+ ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ib.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+ ib.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
return ib.genMapSql();
}
@@ -138,15 +137,15 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(ScrappedCounts, this.getScrappedCounts(), this.isset_scrappedCounts);
- ub.set(InitCount, this.getInitCount(), this.isset_initCount);
ub.set(DepFormScrappedId, this.getDepFormScrappedId(), this.isset_depFormScrappedId);
- ub.set(Beiz, this.getBeiz(), this.isset_beiz);
- ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
- ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
- ub.set(DepFormLendingGoodsId, this.getDepFormLendingGoodsId(), this.isset_depFormLendingGoodsId);
- ub.set(DepFormLendingId, this.getDepFormLendingId(), this.isset_depFormLendingId);
- ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+ ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+ ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -157,15 +156,15 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(ScrappedCounts, this.getScrappedCounts(), this.isset_scrappedCounts);
- ub.set(InitCount, this.getInitCount(), this.isset_initCount);
ub.set(DepFormScrappedId, this.getDepFormScrappedId(), this.isset_depFormScrappedId);
- ub.set(Beiz, this.getBeiz(), this.isset_beiz);
- ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
- ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
- ub.set(DepFormLendingGoodsId, this.getDepFormLendingGoodsId(), this.isset_depFormLendingGoodsId);
- ub.set(DepFormLendingId, this.getDepFormLendingId(), this.isset_depFormLendingId);
- ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+ ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+ ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
return ub.genMapSql(where, parameters);
}
@@ -175,15 +174,15 @@
@Override
public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
- ub.set(ScrappedCounts, this.getScrappedCounts(), this.isset_scrappedCounts);
- ub.set(InitCount, this.getInitCount(), this.isset_initCount);
ub.set(DepFormScrappedId, this.getDepFormScrappedId(), this.isset_depFormScrappedId);
- ub.set(Beiz, this.getBeiz(), this.isset_beiz);
- ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
- ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
- ub.set(DepFormLendingGoodsId, this.getDepFormLendingGoodsId(), this.isset_depFormLendingGoodsId);
- ub.set(DepFormLendingId, this.getDepFormLendingId(), this.isset_depFormLendingId);
- ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
+ ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+ ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+ ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+ ub.set(Classification, this.getClassification(), this.isset_classification);
+ ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+ ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+ ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
return ub.genArraySql(where, parameters);
}
@@ -231,7 +230,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, scrapped_counts, init_count, dep_form_scrapped_id, beiz, scrapped_code, scrapped_name, dep_form_lending_goods_id, dep_form_lending_id, warehouse_id from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, dep_form_scrapped_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -239,7 +238,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, scrapped_counts, init_count, dep_form_scrapped_id, beiz, scrapped_code, scrapped_name, dep_form_lending_goods_id, dep_form_lending_id, warehouse_id from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, dep_form_scrapped_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -276,22 +275,6 @@
dep_form_scrapped_goods.setId(rs.getLong(columnIndex));
}
//鏅�氬睘鎬�
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.ScrappedCounts);
- if (columnIndex > 0) {
- if (rs.getBigDecimal(columnIndex) == null) {
- dep_form_scrapped_goods.setScrappedCounts(null);
- } else {
- dep_form_scrapped_goods.setScrappedCounts(rs.getInt(columnIndex));
- }
- }
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.InitCount);
- if (columnIndex > 0) {
- if (rs.getBigDecimal(columnIndex) == null) {
- dep_form_scrapped_goods.setInitCount(null);
- } else {
- dep_form_scrapped_goods.setInitCount(rs.getInt(columnIndex));
- }
- }
columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.DepFormScrappedId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
@@ -300,40 +283,52 @@
dep_form_scrapped_goods.setDepFormScrappedId(rs.getLong(columnIndex));
}
}
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.Beiz);
- if (columnIndex > 0) {
- dep_form_scrapped_goods.setBeiz(rs.getString(columnIndex));
- }
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.ScrappedCode);
- if (columnIndex > 0) {
- dep_form_scrapped_goods.setScrappedCode(rs.getString(columnIndex));
- }
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.ScrappedName);
- if (columnIndex > 0) {
- dep_form_scrapped_goods.setScrappedName(rs.getString(columnIndex));
- }
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.DepFormLendingGoodsId);
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.BaseGoodsTemplateId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- dep_form_scrapped_goods.setDepFormLendingGoodsId(null);
+ dep_form_scrapped_goods.setBaseGoodsTemplateId(null);
} else {
- dep_form_scrapped_goods.setDepFormLendingGoodsId(rs.getLong(columnIndex));
+ dep_form_scrapped_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
}
}
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.DepFormLendingId);
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.BaseGoodsTemplateName);
+ if (columnIndex > 0) {
+ dep_form_scrapped_goods.setBaseGoodsTemplateName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.CategoryName);
+ if (columnIndex > 0) {
+ dep_form_scrapped_goods.setCategoryName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.Classification);
+ if (columnIndex > 0) {
+ dep_form_scrapped_goods.setClassification(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.TransBusinessId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- dep_form_scrapped_goods.setDepFormLendingId(null);
+ dep_form_scrapped_goods.setTransBusinessId(null);
} else {
- dep_form_scrapped_goods.setDepFormLendingId(rs.getLong(columnIndex));
+ dep_form_scrapped_goods.setTransBusinessId(rs.getLong(columnIndex));
}
}
- columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.WarehouseId);
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.BusinessFormCode);
+ if (columnIndex > 0) {
+ dep_form_scrapped_goods.setBusinessFormCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.TransOutWarehouseType);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
- dep_form_scrapped_goods.setWarehouseId(null);
+ dep_form_scrapped_goods.setTransOutWarehouseType(null);
} else {
- dep_form_scrapped_goods.setWarehouseId(rs.getLong(columnIndex));
+ dep_form_scrapped_goods.setTransOutWarehouseType(rs.getInt(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedGoods_mapper.TransOutWarehouseId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ dep_form_scrapped_goods.setTransOutWarehouseId(null);
+ } else {
+ dep_form_scrapped_goods.setTransOutWarehouseId(rs.getLong(columnIndex));
}
}
return dep_form_scrapped_goods;
--
Gitblit v1.9.1