From 38b6c0f70c646d247e50083c4a09abce055e363a Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期二, 26 三月 2024 15:12:39 +0800
Subject: [PATCH] 版本大更新

---
 Yw.Service.DMA.Core/00-core/ConfigHelper.cs |   55 +++++++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 45 insertions(+), 10 deletions(-)

diff --git a/Yw.Service.DMA.Core/00-core/ConfigHelper.cs b/Yw.Service.DMA.Core/00-core/ConfigHelper.cs
index 5b02019..29ffb2d 100644
--- a/Yw.Service.DMA.Core/00-core/ConfigHelper.cs
+++ b/Yw.Service.DMA.Core/00-core/ConfigHelper.cs
@@ -3,7 +3,6 @@
     internal class ConfigHelper
     {
 
-
         /// <summary>
         /// 榛樿杩炴帴閰嶇疆
         /// </summary>
@@ -15,7 +14,7 @@
                 return new ConnectionConfig()
                 {
                     DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
-                    ConnectionString = DMAParasHelper.DMA.DataBase.ConnectString,
+                    ConnectionString = DMAParasHelper.DMA.DataBase.PostgreSql.ConnectString,
                     IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
                     MoreSettings = new ConnMoreSettings()
                     {
@@ -34,29 +33,65 @@
             }
         }
 
-
         /// <summary>
-        /// 缂撳瓨淇濇寔鏃堕棿 锛堝垎閽燂級
+        /// PostgreSql杩炴帴閰嶇疆
         /// </summary>
-        public static int CacheKeepTime
+        internal static ConnectionConfig PostgreSqlConnectionConfig
         {
             get
             {
-                return MemoryCacheParasHelper.MemoryCache.KeepTime;
+                //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+                return new ConnectionConfig()
+                {
+                    DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
+                    ConnectionString = DMAParasHelper.DMA.DataBase.PostgreSql.ConnectString,
+                    IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
+                    MoreSettings = new ConnMoreSettings()
+                    {
+                        //PgSqlIsAutoToLower = false //鏁版嵁搴撳瓨鍦ㄥぇ鍐欏瓧娈电殑 锛岄渶瑕佹妸杩欎釜璁句负false 锛屽苟涓斿疄浣撳拰瀛楁鍚嶇О瑕佷竴鏍�
+                    },
+                    AopEvents = new AopEvents
+                    {
+                        OnLogExecuting = (sql, p) =>
+                        {
+                            // var sqlString = UtilMethods.GetNativeSql(sql, p);
+                            //LogHelper.Debug(sqlString);
+                            // Console.WriteLine(sql);
+                        }
+                    }
+                };
             }
         }
 
         /// <summary>
-        /// 缂撳瓨闅忔満鏃堕棿 锛堢锛�
+        /// SQLite杩炴帴閰嶇疆
         /// </summary>
-        public static int CacheRandomTime
+        internal static ConnectionConfig SQLiteConnectionConfig
         {
             get
             {
-                return RandomHelper.Random(0, MemoryCacheParasHelper.MemoryCache.RandomTime);
+                //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+                return new ConnectionConfig()
+                {
+                    DbType = SqlSugar.DbType.Sqlite,//鏁版嵁搴撶被鍨�
+                    ConnectionString = DMAParasHelper.DMA.DataBase.SQLite.ConnectString,
+                    IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
+                    MoreSettings = new ConnMoreSettings()
+                    {
+                        //PgSqlIsAutoToLower = false //鏁版嵁搴撳瓨鍦ㄥぇ鍐欏瓧娈电殑 锛岄渶瑕佹妸杩欎釜璁句负false 锛屽苟涓斿疄浣撳拰瀛楁鍚嶇О瑕佷竴鏍�
+                    },
+                    AopEvents = new AopEvents
+                    {
+                        OnLogExecuting = (sql, p) =>
+                        {
+                            // var sqlString = UtilMethods.GetNativeSql(sql, p);
+                            //LogHelper.Debug(sqlString);
+                            // Console.WriteLine(sql);
+                        }
+                    }
+                };
             }
         }
-
 
 
 

--
Gitblit v1.9.3