From 77b654d928c34d32462e212a4ec212f7cc48b50f Mon Sep 17 00:00:00 2001 From: 杨张扬 <634643841@qq.com> Date: 星期三, 16 七月 2025 17:35:49 +0800 Subject: [PATCH] 库存信息添加起点货位信息 --- wms/SpecHelper.cs | 7 +------ core/Monitor.cs | 3 +++ api/ApiHelper.cs | 6 ++++++ models/TN_InventoryM.cs | 5 +++++ 4 files changed, 15 insertions(+), 6 deletions(-) diff --git a/api/ApiHelper.cs b/api/ApiHelper.cs index b5da79d..b28f30d 100644 --- a/api/ApiHelper.cs +++ b/api/ApiHelper.cs @@ -298,6 +298,7 @@ ITEMCODE = cG_Detail.S_ITEM_CODE, LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = startLoc.S_CODE, }; SpecHelper.InsertInventoryM(target); } @@ -1033,6 +1034,7 @@ ITEMSTATE = "寰呮", LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = startLoc.S_CODE, }; SpecHelper.InsertInventoryM(target); }); @@ -1536,6 +1538,7 @@ ITEMCODE = cG_Detail.S_ITEM_CODE, LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = startLoc_New.S_CODE, }; SpecHelper.InsertInventoryM(target); }); @@ -1962,6 +1965,7 @@ ITEMCODE = cG_old_Detail.S_ITEM_CODE, LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = startLoc_Old.S_CODE, }; SpecHelper.InsertInventoryM(target); } @@ -1977,6 +1981,7 @@ ITEMCODE = cG_new_Detail_Ins.S_ITEM_CODE, LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = startLoc_New.S_CODE, }; SpecHelper.InsertInventoryM(target); } @@ -2115,6 +2120,7 @@ ITEMCODE = cginfo.S_ITEM_CODE, LOGINNAME = model.staff, SHIFT = model.shift, + STARTLOC = model.startLoc, }; SpecHelper.InsertInventoryM(target); } diff --git a/core/Monitor.cs b/core/Monitor.cs index e81d5fd..2d85a2e 100644 --- a/core/Monitor.cs +++ b/core/Monitor.cs @@ -226,6 +226,7 @@ ITEMCODE = woInfo.S_ITEM_CODE, LOGINNAME = woInfo.S_LINE_NO, SHIFT = "None", + STARTLOC = startLoc.S_CODE, }; SpecHelper.InsertInventoryM(target); }); @@ -426,6 +427,7 @@ ITEMCODE = cginfo.S_ITEM_CODE, LOGINNAME = "鑷姩杞", SHIFT = "鏃�, + STARTLOC = startLoc.S_CODE, }; SpecHelper.InsertInventoryM(target); }); @@ -520,6 +522,7 @@ ITEMCODE = outTimeCg.S_ITEM_CODE, LOGINNAME = "杩囨湡鍚堟牸鍥炲簱杞", SHIFT = "None", + STARTLOC = startLoc_2.S_CODE, }; SpecHelper.InsertInventoryM(target); }); diff --git a/models/TN_InventoryM.cs b/models/TN_InventoryM.cs index 4a5df52..29cbdde 100644 --- a/models/TN_InventoryM.cs +++ b/models/TN_InventoryM.cs @@ -58,5 +58,10 @@ /// 璺濈杩囨湡杩樻湁鍑犲皬鏃� /// </summary> public string EXPIRATION_DAY { get; set; } = "0"; + + /// <summary> + /// 鍒涘缓鏃剁殑璧风偣璐т綅 + /// </summary> + public string STARTLOC { get; set; } } } diff --git a/wms/SpecHelper.cs b/wms/SpecHelper.cs index 539ffa8..6658c78 100644 --- a/wms/SpecHelper.cs +++ b/wms/SpecHelper.cs @@ -409,13 +409,8 @@ if (model != null) { - var target = db.Queryable<TN_InventoryM>().First(o => o.RFID == model.RFID); - if (target != null) - { - db.Deleteable<TN_InventoryM>(target).ExecuteCommand(); - } model.EXPIRATION = System.DateTime.Now.AddHours(GetExportTime(model.SPEC)); - if (db.Insertable<TN_InventoryM>(model).ExecuteCommand() > 0) + if (db.Storageable<TN_InventoryM>(model).ExecuteCommand() > 0) { LogHelper.Info($"鎻掑叆WMS搴撳瓨鏄庣粏鎴愬姛锛寋log}"); } -- Gitblit v1.9.1