From 4a3a2c6ec04cb9680915d29b1a3c9cec6957bf60 Mon Sep 17 00:00:00 2001
From: 杨张扬 <634643841@qq.com>
Date: 星期一, 16 六月 2025 17:40:15 +0800
Subject: [PATCH] 双钱-复检区合格物料自动回库

---
 wms/SpecHelper.cs |   49 ++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 44 insertions(+), 5 deletions(-)

diff --git a/wms/SpecHelper.cs b/wms/SpecHelper.cs
index cc88f6b..257bb58 100644
--- a/wms/SpecHelper.cs
+++ b/wms/SpecHelper.cs
@@ -77,7 +77,7 @@
                 var log = JsonConvert.SerializeObject(model);
                 if (model != null)
                 {
-                    model.EXPIRATION = System.DateTime.Now.AddMinutes(GetExportTime(model.SPEC));
+                    model.EXPIRATION = System.DateTime.Now.AddHours(GetExportTime(model.SPEC));
 
                     if (db.Insertable<TN_EquipProDetail>(model).ExecuteCommand() > 0)
                     {
@@ -326,7 +326,7 @@
                     {
                         db.Deleteable<TN_InventoryM>(target).ExecuteCommand();
                     }
-                    model.EXPIRATION = System.DateTime.Now.AddMinutes(GetExportTime(model.SPEC));
+                    model.EXPIRATION = System.DateTime.Now.AddHours(GetExportTime(model.SPEC));
                     if (db.Insertable<TN_InventoryM>(model).ExecuteCommand() > 0)
                     {
                         LogHelper.Info($"鎻掑叆WMS搴撳瓨鏄庣粏鎴愬姛锛寋log}");
@@ -354,7 +354,7 @@
                 var target = db.Queryable<TN_CG_Detail>().First(a => a.S_CNTR_CODE == cntId);
                 if (target != null)
                 {
-                    var targetM = db.Queryable<TN_InventoryM>().First(a => a.S_ID == target.S_ID);
+                    var targetM = db.Queryable<TN_InventoryM>().First(a => a.S_ID == target.S_ID || a.RFID == cntId);
 
                     if (targetM != null)
                     {
@@ -368,7 +368,14 @@
                             LogHelper.Info($"鏇存柊WMS搴撳瓨鏄庣粏鐨勫叆搴撴椂闂达紝澶辫触锛屽鍣ㄥ彿锛歿cntId}");
                         }
                     }
-                
+                    else
+                    {
+                        LogHelper.Info($"鏇存柊WMS搴撳瓨鏄庣粏鐨勫叆搴撴椂闂达紝澶辫触锛屽鍣ㄥ彿锛歿cntId}锛孴N_InventoryM涓虹┖");
+                    }
+                }
+                else
+                {
+                    LogHelper.Info($"鏇存柊WMS搴撳瓨鏄庣粏鐨勫叆搴撴椂闂达紝澶辫触锛屽鍣ㄥ彿锛歿cntId}锛孴N_CG_Detail涓虹┖");
                 }
             }
             catch (Exception ex)
@@ -396,7 +403,39 @@
             }
             catch (Exception ex)
             {
-                LogHelper.Error("鏇存柊WMS搴撳瓨鏄庣粏鐨勮繃鏈熸椂闂村け璐�, ex);
+                LogHelper.Error("鍒犻櫎WMS搴撳瓨鏄庣粏", ex);
+            }
+        }
+
+        /// <summary>
+        /// 璁$畻鏃堕棿宸�+        /// </summary>
+        /// <param name="start"></param>
+        /// <param name="end"></param>
+        /// <returns></returns>
+        public static int CalculateDaysDifference(DateTime start, DateTime end)
+        {
+            try
+            {
+                // 璁$畻鎬绘椂闂村樊
+                TimeSpan difference = end - start;
+
+                // 濡傛灉宸�涓鸿礋锛坋nd鏃╀簬start锛夛紝杩斿洖0
+                if (difference.TotalDays < 0)
+                {
+                    return 0;
+                }
+
+
+                // 鑾峰彇鎬诲皬鏃舵暟锛堝寘鎷皬鏁伴儴鍒嗭級
+                double totalHours = difference.TotalHours;
+
+                // 鍚戜笂鍙栨暣
+                return (int)Math.Ceiling(totalHours);
+            }
+            catch (Exception ex)
+            {
+                return 0;
             }
         }
     }

--
Gitblit v1.9.1