¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace HStation.Assets |
| | | { |
| | | internal class ConfigHelper |
| | | { |
| | | /// <summary> |
| | | /// é»è®¤è¿æ¥é
ç½® |
| | | /// </summary> |
| | | internal static ConnectionConfig DefaultConnectionConfig |
| | | { |
| | | get |
| | | { |
| | | ConnectionConfig connectConfig = null; |
| | | switch (XhsParasHelper.Xhs.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 = XhsParasHelper.Xhs.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> |
| | | internal static ConnectionConfig SQLiteConnectionConfig |
| | | { |
| | | get |
| | | { |
| | | //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; ä¸åæºå¨é
ç½®çå¯ä¸æ°å; // åæå¡å¨ä¸éè¦æå® |
| | | return new ConnectionConfig() |
| | | { |
| | | DbType = SqlSugar.DbType.Sqlite,//æ°æ®åºç±»å |
| | | ConnectionString = XhsParasHelper.Xhs.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); |
| | | } |
| | | } |
| | | }; |
| | | } |
| | | } |
| | | } |
| | | } |