From b8dc4ccc6ee580b084aa860e64af2d90d1cb5979 Mon Sep 17 00:00:00 2001
From: 石广澎 <shiguangpeng@163.com>
Date: 星期三, 29 十一月 2023 10:11:52 +0800
Subject: [PATCH] feat: 1、首页接口对接 2、部门物品分发
---
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java | 62 ++++++++++++++++++++++++++++++-
1 files changed, 60 insertions(+), 2 deletions(-)
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
index fb5146d..edd95c8 100644
--- 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
@@ -7,6 +7,8 @@
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;
@@ -44,6 +46,10 @@
public static final String InventoryDate = "inventory_date";
public static final String CreateTime = "create_time";
public static final String StopTime = "stop_time";
+ public static final String InWarehouseFormId = "in_warehouse_form_id";
+ public static final String InBusinessFormCode = "in_business_form_code";
+ public static final String OutWarehouseFormId = "out_warehouse_form_id";
+ public static final String OutBusinessFormCode = "out_business_form_code";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -111,6 +117,18 @@
if (lWhFormInventory.isset_stopTime) {
this.setStopTime(lWhFormInventory.getStopTime());
}
+ if (lWhFormInventory.isset_inWarehouseFormId) {
+ this.setInWarehouseFormId(lWhFormInventory.getInWarehouseFormId());
+ }
+ if (lWhFormInventory.isset_inBusinessFormCode) {
+ this.setInBusinessFormCode(lWhFormInventory.getInBusinessFormCode());
+ }
+ if (lWhFormInventory.isset_outWarehouseFormId) {
+ this.setOutWarehouseFormId(lWhFormInventory.getOutWarehouseFormId());
+ }
+ if (lWhFormInventory.isset_outBusinessFormCode) {
+ this.setOutBusinessFormCode(lWhFormInventory.getOutBusinessFormCode());
+ }
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(l_wh_form_inventory.getDatabaseName_());
}
@@ -172,6 +190,10 @@
ib.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
ib.set(StopTime, this.getStopTime(), this.isset_stopTime);
+ ib.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
+ ib.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode);
+ ib.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
+ ib.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode);
return ib.genMapSql();
}
@@ -199,6 +221,10 @@
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.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
+ ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode);
+ ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
+ ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -227,6 +253,10 @@
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.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
+ ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode);
+ ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
+ ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode);
return ub.genMapSql(where, parameters);
}
@@ -254,6 +284,10 @@
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.set(InWarehouseFormId, this.getInWarehouseFormId(), this.isset_inWarehouseFormId);
+ ub.set(InBusinessFormCode, this.getInBusinessFormCode(), this.isset_inBusinessFormCode);
+ ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
+ ub.set(OutBusinessFormCode, this.getOutBusinessFormCode(), this.isset_outBusinessFormCode);
return ub.genArraySql(where, parameters);
}
@@ -301,7 +335,7 @@
*/
@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);
+ 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, in_warehouse_form_id, in_business_form_code, out_warehouse_form_id, out_business_form_code from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -309,7 +343,7 @@
*/
@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);
+ 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, in_warehouse_form_id, in_business_form_code, out_warehouse_form_id, out_business_form_code from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -458,6 +492,30 @@
l_wh_form_inventory.setStopTime(rs.getLong(columnIndex));
}
}
+ columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InWarehouseFormId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_form_inventory.setInWarehouseFormId(null);
+ } else {
+ l_wh_form_inventory.setInWarehouseFormId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InBusinessFormCode);
+ if (columnIndex > 0) {
+ l_wh_form_inventory.setInBusinessFormCode(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OutWarehouseFormId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_form_inventory.setOutWarehouseFormId(null);
+ } else {
+ l_wh_form_inventory.setOutWarehouseFormId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OutBusinessFormCode);
+ if (columnIndex > 0) {
+ l_wh_form_inventory.setOutBusinessFormCode(rs.getString(columnIndex));
+ }
return l_wh_form_inventory;
}
}
--
Gitblit v1.9.1