ERP库存状态

kyy

2025-07-28 8d61d737d019d79e123c4d1da3cce11da6e87c45

 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
                            {