CeramicProjectTool/Util/DBHelper.cs

45 lines
1.2 KiB
C#
Raw Permalink Normal View History

2024-05-22 17:19:22 +08:00
using CeramicProjectTool.Model;
using System;
2024-05-20 08:35:32 +08:00
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace CeramicProjectTool.Util
{
public static partial class DBHelper
2024-05-20 08:35:32 +08:00
{
2024-05-23 16:41:06 +08:00
private static SqlSugar.SqlSugarClient? _db;
2024-05-22 17:19:22 +08:00
public static SqlSugar.SqlSugarClient Db
{
get
{
2024-05-23 16:41:06 +08:00
NewDB();
2024-05-22 17:19:22 +08:00
return _db;
2024-05-23 16:41:06 +08:00
2024-05-22 17:19:22 +08:00
}
}
2024-05-20 08:35:32 +08:00
public static bool isInit = false;
2024-05-23 16:41:06 +08:00
public static void NewDB()
2024-05-20 08:35:32 +08:00
{
2024-05-23 16:41:06 +08:00
_db = new SqlSugar.SqlSugarClient(new SqlSugar.ConnectionConfig()
2024-05-20 08:35:32 +08:00
{
2024-05-23 16:41:06 +08:00
ConnectionString = connStr,
DbType = SqlSugar.DbType.SqlServer,
IsAutoCloseConnection = true,
InitKeyType = SqlSugar.InitKeyType.Attribute
});
isInit = true;
2024-05-20 08:35:32 +08:00
}
public static void SetConnStr(Dictionary<string, string> dbConfig)
{
DBHelper.connStr = $"Data Source={dbConfig["dbSource"]};Initial Catalog={dbConfig["dbName"]};User ID={dbConfig["dbUserName"]};Password={dbConfig["dbUserPwd"]}";
}
2024-05-22 17:19:22 +08:00
2024-05-23 16:41:06 +08:00
private static string connStr = "";
2024-05-20 08:35:32 +08:00
}
}