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