修改还剩几天过期字段为字符串

杨张扬

2025-06-05 ed4d2a10702e49c669f8a64e5508223dc5d4ab77

 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 == "过期");//已过期的货品，剩余天数改为0
                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;