ERP库存状态

kyy

2025-07-28 8d61d737d019d79e123c4d1da3cce11da6e87c45

ERP库存状态

 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; }
}

 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
                            {

 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"
  }
}