forked from anjoy8/Blog.Core
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathUnitOfWork.cs
More file actions
79 lines (64 loc) · 1.94 KB
/
UnitOfWork.cs
File metadata and controls
79 lines (64 loc) · 1.94 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
using Blog.Core.Common;
using Blog.Core.Common.LogHelper;
using Blog.Core.IRepository.UnitOfWork;
using SqlSugar;
using StackExchange.Profiling;
using System;
using System.Collections.Generic;
using System.Text;
using System.Threading.Tasks;
namespace Blog.Core.Repository.UnitOfWork
{
public class UnitOfWork : IUnitOfWork
{
private readonly ISqlSugarClient _sqlSugarClient;
public UnitOfWork(ISqlSugarClient sqlSugarClient)
{
_sqlSugarClient = sqlSugarClient;
if (Appsettings.app(new string[] { "AppSettings", "SqlAOP", "Enabled" }).ObjToBool())
{
sqlSugarClient.Aop.OnLogExecuting = (sql, pars) => //SQL执行中事件
{
Parallel.For(0, 1, e =>
{
MiniProfiler.Current.CustomTiming("SQL：", GetParas(pars) + "【SQL语句】：" + sql);
LogLock.OutSql2Log("SqlLog", new string[] { GetParas(pars), "【SQL语句】：" + sql });
});
};
}
}
private string GetParas(SugarParameter[] pars)
{
string key = "【SQL参数】：";
foreach (var param in pars)
{
key += $"{param.ParameterName}:{param.Value}\n";
}
return key;
}
public ISqlSugarClient GetDbClient()
{
return _sqlSugarClient;
}
public void BeginTran()
{
GetDbClient().Ado.BeginTran();
}
public void CommitTran()
{
try
{
GetDbClient().Ado.CommitTran(); //
}
catch (Exception ex)
{
GetDbClient().Ado.RollbackTran();
throw ex;
}
}
public void RollbackTran()
{
GetDbClient().Ado.RollbackTran();
}
}
}