SqlProfiler.cs
2.77 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
using System;
namespace SqlSugar
{
/// <summary>
/// SqlSugar 打印SQL语句参数格式化帮助类
/// 【使用方式】：在需要打印SQL语句的地方，如 Startup，将
/// App.PrintToMiniProfiler("SqlSugar1", "Info", sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
/// 替换为
/// App.PrintToMiniProfiler("SqlSugar", "Info", SqlProfiler.ParameterFormat(sql, pars));
/// </summary>
public class SqlProfiler
{
/// <summary>
/// 格式化参数拼接成完整的SQL语句
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public static string ParameterFormat(string sql, SugarParameter[] pars)
{
//var aa = pars.ToDictionary(it => it.ParameterName, it => it.Value);
//应逆向替换，否则由于 SqlSugar 多个表的过滤器问题导致替换不完整 如 @TenantId1 @TenantId10
for (var i = pars.Length - 1; i >= 0; i--)
{
if (pars[i].DbType == System.Data.DbType.String
|| pars[i].DbType == System.Data.DbType.DateTime
|| pars[i].DbType == System.Data.DbType.Date
|| pars[i].DbType == System.Data.DbType.Time
|| pars[i].DbType == System.Data.DbType.DateTime2
|| pars[i].DbType == System.Data.DbType.DateTimeOffset
|| pars[i].DbType == System.Data.DbType.Guid
|| pars[i].DbType == System.Data.DbType.VarNumeric
|| pars[i].DbType == System.Data.DbType.AnsiStringFixedLength
|| pars[i].DbType == System.Data.DbType.AnsiString
|| pars[i].DbType == System.Data.DbType.StringFixedLength)
{
sql = sql.Replace(pars[i].ParameterName, "'" + pars[i].Value?.ToString() + "'");
}
else if (pars[i].DbType == System.Data.DbType.Boolean)
{
sql = sql.Replace(pars[i].ParameterName, Convert.ToBoolean(pars[i].Value) ? "1" : "0");
}
else
{
sql = sql.Replace(pars[i].ParameterName, pars[i].Value?.ToString());
}
}
return sql;
}
/// <summary>
/// 格式化参数拼接成完整的SQL语句
/// </summary>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public static string ParameterFormat(string sql, object pars)
{
var param = (SugarParameter[])pars;
return ParameterFormat(sql, param);
}
}
}