From ed4d2a10702e49c669f8a64e5508223dc5d4ab77 Mon Sep 17 00:00:00 2001 From: 杨张扬 <634643841@qq.com> Date: 星期四, 05 六月 2025 17:39:45 +0800 Subject: [PATCH] 修改还剩几天过期字段为字符串 --- core/Monitor.cs | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/core/Monitor.cs b/core/Monitor.cs index af58528..43287a4 100644 --- a/core/Monitor.cs +++ b/core/Monitor.cs @@ -534,7 +534,7 @@ if (targetInM != null)//妫�祴鍑哄凡杩囨湡鐨勮揣鍝� { targetInM.ITEMSTATE = "杩囨湡"; - targetInM.EXPIRATION_DAY = 0; + targetInM.EXPIRATION_DAY = "0"; db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.ITEMSTATE }).ExecuteCommand(); var cginfo = db.Queryable<TN_CG_Detail>().First(a => a.S_ID == targetInM.S_ID); @@ -548,14 +548,14 @@ if (targetInM != null)//妫�祴鍑哄揩杩囨湡鐨勮揣鍝� { - targetInM.EXPIRATION_DAY = SpecHelper.CalculateDaysDifference(System.DateTime.Now,targetInM.EXPIRATION); + targetInM.EXPIRATION_DAY = SpecHelper.CalculateDaysDifference(System.DateTime.Now,targetInM.EXPIRATION).ToString(); db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand(); } - targetInM = db.Queryable<TN_InventoryM>().First(a => a.EXPIRATION_DAY > 0 && a.ITEMSTATE == "杩囨湡");//宸茶繃鏈熺殑璐у搧锛屽墿浣欏ぉ鏁版敼涓� + targetInM = db.Queryable<TN_InventoryM>().First(a => Convert.ToInt32(a.EXPIRATION_DAY) > 0 && a.ITEMSTATE == "杩囨湡");//宸茶繃鏈熺殑璐у搧锛屽墿浣欏ぉ鏁版敼涓� if (targetInM != null) { - targetInM.EXPIRATION_DAY = 0; + targetInM.EXPIRATION_DAY = "0"; db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand(); } -- Gitblit v1.9.1