47 lines
1.6 KiB
C#
47 lines
1.6 KiB
C#
using Furion;
|
|
using Microsoft.Extensions.DependencyInjection;
|
|
using SqlSugar;
|
|
|
|
namespace YB.DeviceStand.Core
|
|
{
|
|
public class Startup : AppStartup
|
|
{
|
|
public void ConfigureServices(IServiceCollection services)
|
|
{
|
|
// 数据库配置
|
|
services.AddSqlSugar(new ConnectionConfig
|
|
{
|
|
ConnectionString = App.Configuration["ConnectionStrings:DefaultDbString"],//连接字符串
|
|
DbType = DbType.SqlServer,
|
|
IsAutoCloseConnection = true,
|
|
InitKeyType = InitKeyType.Attribute //从特性读取主键自增信息
|
|
},
|
|
db =>
|
|
{
|
|
//处理日志事务
|
|
#if DEBUG
|
|
db.Aop.OnLogExecuting = (sql, pars) =>
|
|
{
|
|
if (sql.StartsWith("SELECT"))
|
|
{
|
|
Console.ForegroundColor = ConsoleColor.Green;
|
|
}
|
|
if (sql.StartsWith("UPDATE") || sql.StartsWith("INSERT"))
|
|
{
|
|
Console.ForegroundColor = ConsoleColor.White;
|
|
}
|
|
if (sql.StartsWith("DELETE"))
|
|
{
|
|
Console.ForegroundColor = ConsoleColor.Blue;
|
|
}
|
|
App.PrintToMiniProfiler("SqlSugar", "Info", SqlProfiler.ParameterFormat(sql, pars));
|
|
Console.WriteLine(sql);
|
|
Console.WriteLine(string.Join(",", pars?.Select(it => it.ParameterName + ":" + it.Value)));
|
|
Console.WriteLine();
|
|
};
|
|
#endif
|
|
});
|
|
}
|
|
}
|
|
}
|