From 8d61d737d019d79e123c4d1da3cce11da6e87c45 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期一, 28 七月 2025 22:28:05 +0800
Subject: [PATCH] ERP库存状态
---
MES.Service/Dto/webApi/RealTimeInventory/InventoryItem.cs | 4 ++++
MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs | 21 ++++++++-------------
MESApplication/appsettings.json | 2 +-
3 files changed, 13 insertions(+), 14 deletions(-)
diff --git a/MES.Service/Dto/webApi/RealTimeInventory/InventoryItem.cs b/MES.Service/Dto/webApi/RealTimeInventory/InventoryItem.cs
index c706521..4a1524e 100644
--- a/MES.Service/Dto/webApi/RealTimeInventory/InventoryItem.cs
+++ b/MES.Service/Dto/webApi/RealTimeInventory/InventoryItem.cs
@@ -8,4 +8,8 @@
public string FstockNumber { get; set; }
public decimal FmaterialId { get; set; }
public decimal FstockorgId { get; set; }
+
+ public string Fstockstatusnumber{ get; set; }
+
+ public string Fstockstatusname{ get; set; }
}
\ No newline at end of file
diff --git a/MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs b/MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs
index 50af833..7993a32 100644
--- a/MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs
+++ b/MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs
@@ -146,21 +146,16 @@
foreach (var item in inventoryData.Data)
{
var query =
- "INSERT INTO ERPKCPC (ITEM_ID, DEPOT_CODE, FQTY, ITEM_NO, ORGID) VALUES (:ITEM_ID, :DEPOT_CODE, :FQTY, :ITEM_NO, :ORGID)";
+ "INSERT INTO ERPKCPC (ITEM_ID, DEPOT_CODE, FQTY, ITEM_NO, ORGID,Fstockstatusnumber,Fstockstatusname) VALUES (:ITEM_ID, :DEPOT_CODE, :FQTY, :ITEM_NO, :ORGID,:Fstockstatusnumber,:Fstockstatusname)";
using (var cmd = new OracleCommand(query, connection))
{
- cmd.Parameters.Add(new OracleParameter(":ITEM_ID",
- item.FmaterialId));
- cmd.Parameters.Add(
- new OracleParameter(":DEPOT_CODE",
- item.FstockNumber));
- cmd.Parameters.Add(
- new OracleParameter(":FQTY", item.Fqty));
- cmd.Parameters.Add(new OracleParameter(":ITEM_NO",
- item.FmaterialNumber));
- cmd.Parameters.Add(
- new OracleParameter(":ORGID",
- item.FstockorgId));
+ cmd.Parameters.Add(new OracleParameter(":ITEM_ID", item.FmaterialId));
+ cmd.Parameters.Add( new OracleParameter(":DEPOT_CODE", item.FstockNumber));
+ cmd.Parameters.Add( new OracleParameter(":FQTY", item.Fqty));
+ cmd.Parameters.Add(new OracleParameter(":ITEM_NO", item.FmaterialNumber));
+ cmd.Parameters.Add(new OracleParameter(":ORGID",item.FstockorgId));
+ cmd.Parameters.Add(new OracleParameter(":Fstockstatusnumber",item.Fstockstatusnumber));
+ cmd.Parameters.Add(new OracleParameter(":Fstockstatusname",item.Fstockstatusname));
try
{
diff --git a/MESApplication/appsettings.json b/MESApplication/appsettings.json
index 65d928e..29d6c8f 100644
--- a/MESApplication/appsettings.json
+++ b/MESApplication/appsettings.json
@@ -10,6 +10,6 @@
"AppSettings": {
"TestErpUrl": "http://192.168.0.208:8066/WebService1.asmx/MesToErpinfoTest",
"ProductionErpUrl": "http://192.168.0.208:8066/WebService1.asmx/MesToErpinfoTest",
- "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = test_dev; Password=ltsdev"
+ "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.92)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = lts_dev; Password=ltsdev"
}
}
--
Gitblit v1.9.3