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