From c53a461aef16902ca78cdb7bd0c62305e2fee809 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 29 七月 2025 19:23:04 +0800
Subject: [PATCH] Update OQC search API functionality
---
MESApplication/Controllers/RealTimeInventory/RealTimeInventoryController.cs | 21 ++++++++-------------
1 files changed, 8 insertions(+), 13 deletions(-)
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
{
--
Gitblit v1.9.3