From fc6dd85a865c4cadae0b9a07d56e2988d2262f10 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期二, 22 七月 2025 17:28:52 +0800
Subject: [PATCH] 优化数据库事务帮助类 , 查询/日志生成类

---
 wms/SYSHelper.cs |   35 ++++++++++++++++++++---------------
 1 files changed, 20 insertions(+), 15 deletions(-)

diff --git a/wms/SYSHelper.cs b/wms/SYSHelper.cs
index b48f3fd..fd6c4a8 100644
--- a/wms/SYSHelper.cs
+++ b/wms/SYSHelper.cs
@@ -2,13 +2,17 @@
 
 using SqlSugar;
 
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
 namespace HH.WCS.Mobox3.DSZSH.wms {
     /// <summary>
-    /// 鐢ㄤ簬鐢熸垚搴忓垪鍙凤紝骞剁鐞嗗簭鍒楀彿鍓嶇紑鐨勫伐鍏风被
+    /// 搴忓垪鍙风敓鎴愬府鍔╃被 (鍚嶇О/鍛藉悕绌洪棿涓哄巻鍙查仐鐣欓棶棰�
     /// </summary>
-    internal class SYSHelper
-    {
-        //浣跨敤闈欐� locker 瀵硅薄瀹炵幇绾跨▼鍚屾
+    internal class SYSHelper {
         private static object locker = new object();
         internal static int GetSerialNumber(string snType, string prefix) {
             int result = 0;
@@ -16,22 +20,23 @@
                 var db = new SqlHelper<object>().GetInstance();
                 var sId = db.Queryable<OI_SYS_MAXID>().Where(a => a.CN_S_TYPE.Trim() == snType && a.CN_S_PRE.Trim() == prefix).First();
                 if (sId != null) {
-                    sId.CN_N_MAX++;
-                    //if (db.Ado.ExecuteCommand($"update OI_SYS_MAXID set CN_N_MAX={sId.CN_N_MAX} where CN_S_TYPE='{snType}' and CN_S_PRE='{prefix}' ") > 0) {
-                    //    result = sId.CN_N_MAX;
-                    //}
 
-                    // 鍙傛暟鍖栨煡璇紝閬垮厤SQL娉ㄥ叆
-                    if (db.Updateable<OI_SYS_MAXID>().SetColumns(it => it.CN_N_MAX == sId.CN_N_MAX).Where(it => it.CN_S_TYPE == snType
-                        && it.CN_S_PRE == prefix).ExecuteCommand() > 0) {
-                        result = sId.CN_N_MAX;
+                    if (sId.CN_T_LAST < DateTime.Today) {
+                        sId.CN_N_MAX = 1;
+                    }
+                    else {
+                        sId.CN_N_MAX++;
                     }
 
+                    sId.CN_T_LAST = DateTime.Now;
+                    if (db.Ado.ExecuteCommand($"update OI_SYS_MAXID set CN_N_MAX={sId.CN_N_MAX}, CN_T_LAST='{sId.CN_T_LAST}' where CN_S_TYPE='{snType}' and CN_S_PRE='{prefix}' ") > 0) {
+                        result = sId.CN_N_MAX;
+                    }
                 }
                 else {
                     //鎻掑叆琛�                     sId = new OI_SYS_MAXID { CN_S_TYPE = snType, CN_S_PRE = prefix, CN_N_MAX = 1 };
-                    result = db.Insertable<OI_SYS_MAXID>(sId).ExecuteCommand() > 0 ? 1 : 0;
+                    result = db.Insertable(sId).ExecuteCommand() > 0 ? 1 : 0;
 
                 }
             }
@@ -39,11 +44,11 @@
         }
 
         [SugarTable("dbo.OI_SYS_MAXID")]
-        public class OI_SYS_MAXID
-        {
+        public class OI_SYS_MAXID {
             public string CN_S_TYPE { get; set; }
             public string CN_S_PRE { get; set; }
             public int CN_N_MAX { get; set; }
+            public DateTime CN_T_LAST { get; set; }
         }
     }
 }

--
Gitblit v1.9.1