namespace IStation.DAL
|
{
|
internal class ConfigHelper
|
{
|
public static string ConnectionString
|
{
|
get
|
{
|
if (string.IsNullOrEmpty(_connectionString))
|
{
|
var dbName = "Db4Schedule.db";
|
var directory = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Data");
|
var filePath = directory + "\\" + dbName;
|
if (!System.IO.File.Exists(filePath))
|
{
|
try
|
{
|
SQLiteConnection.CreateFile(filePath);
|
}
|
catch (Exception ex)
|
{
|
var errMsg = $".db 文件不存在!Path:{filePath}\r\n{ex.Message}";
|
throw new Exception(errMsg);
|
}
|
}
|
_connectionString = $"DataSource={filePath}";
|
}
|
return _connectionString;
|
}
|
}
|
|
private static string _connectionString;
|
|
static SqlSugarClient _client = null;
|
public static SqlSugarClient GetSqlSugarClient()
|
{
|
if (_client != null)
|
return _client;
|
|
|
var config = new ConnectionConfig();
|
config.ConnectionString = ConnectionString;
|
config.IsAutoCloseConnection = true;
|
config.DbType = SqlSugar.DbType.Sqlite;
|
config.ConfigureExternalServices = new ConfigureExternalServices()
|
{
|
EntityService = (property, column) =>
|
{
|
//除主键外都可空
|
if (!column.IsPrimarykey)
|
{
|
column.IsNullable = true;
|
}
|
}
|
};
|
var db = new SqlSugarClient(config);
|
db.Aop.OnLogExecuting = (sql, pars) =>
|
{
|
Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject
|
(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
|
Console.WriteLine();
|
};
|
|
return db;
|
}
|
|
|
|
|
}
|
}
|
