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 | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/core/Monitor.cs b/core/Monitor.cs
index 4926007..43287a4 100644
--- a/core/Monitor.cs
+++ b/core/Monitor.cs
@@ -467,7 +467,8 @@
SPEC = outTimeCg.S_SPE,
CARCODE = outTimeCg.S_CAR_CODE,
WEIGHT = outTimeCg.F_QTY,
- REMELTTIME = DateTime.Now
+ REMELTTIME = DateTime.Now,
+ SHIFT = "None",
};
SpecHelper.InsertRemeltDetail(target);
});
@@ -533,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);
@@ -547,10 +548,16 @@
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 => Convert.ToInt32(a.EXPIRATION_DAY) > 0 && a.ITEMSTATE == "杩囨湡");//宸茶繃鏈熺殑璐у搧锛屽墿浣欏ぉ鏁版敼涓�
+ if (targetInM != null)
+ {
+ targetInM.EXPIRATION_DAY = "0";
+ db.Updateable<TN_InventoryM>(targetInM).UpdateColumns(it => new { it.EXPIRATION_DAY }).ExecuteCommand();
+ }
// 鍚屾 TN_DayProDetail
var curDay = System.DateTime.Now.Date;
--
Gitblit v1.9.1