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