From 02f362e1db42f4315cf923f7643b09150585c52c Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期四, 12 九月 2024 13:13:42 +0800
Subject: [PATCH] 引用升级
---
Yw.Service.Unit.Core/00-core/ConfigHelper.cs | 66 +++++++++++++++++++++++++-------
1 files changed, 51 insertions(+), 15 deletions(-)
diff --git a/Yw.Service.Unit.Core/00-core/ConfigHelper.cs b/Yw.Service.Unit.Core/00-core/ConfigHelper.cs
index 98c926e..1d397a2 100644
--- a/Yw.Service.Unit.Core/00-core/ConfigHelper.cs
+++ b/Yw.Service.Unit.Core/00-core/ConfigHelper.cs
@@ -10,11 +10,37 @@
{
get
{
+ ConnectionConfig connectConfig = null;
+ switch (UnitParasHelper.Unit.DataBase.DbType)
+ {
+ case DbType.PostgreSql:
+ {
+ connectConfig = PostgreSqlConnectionConfig;
+ }
+ break;
+ case DbType.SQLite:
+ {
+ connectConfig = SQLiteConnectionConfig;
+ }
+ break;
+ default: break;
+ }
+ return connectConfig;
+ }
+ }
+
+ /// <summary>
+ /// PostgreSql杩炴帴閰嶇疆
+ /// </summary>
+ internal static ConnectionConfig PostgreSqlConnectionConfig
+ {
+ get
+ {
//SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
return new ConnectionConfig()
{
DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
- ConnectionString = UnitParasHelper.Unit.DataBase.ConnectString,
+ ConnectionString = UnitParasHelper.Unit.DataBase.PostgreSql.ConnectString,
IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
MoreSettings = new ConnMoreSettings()
{
@@ -24,6 +50,8 @@
{
OnLogExecuting = (sql, p) =>
{
+ // var sqlString = UtilMethods.GetNativeSql(sql, p);
+ //LogHelper.Debug(sqlString);
// Console.WriteLine(sql);
}
}
@@ -31,28 +59,36 @@
}
}
-
/// <summary>
- /// 缂撳瓨淇濇寔鏃堕棿 锛堝垎閽燂級
+ /// SQLite杩炴帴閰嶇疆
/// </summary>
- public static int CacheKeepTime
+ internal static ConnectionConfig SQLiteConnectionConfig
{
get
{
- return MemoryCacheParasHelper.MemoryCache.KeepTime;
+ //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+ return new ConnectionConfig()
+ {
+ DbType = SqlSugar.DbType.Sqlite,//鏁版嵁搴撶被鍨�
+ ConnectionString = UnitParasHelper.Unit.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);
+ }
+ }
+ };
}
}
- /// <summary>
- /// 缂撳瓨闅忔満鏃堕棿 锛堢锛�
- /// </summary>
- public static int CacheRandomTime
- {
- get
- {
- return RandomHelper.Random(0, MemoryCacheParasHelper.MemoryCache.RandomTime);
- }
- }
--
Gitblit v1.9.3