Initial Backup

admin

2024-09-20 8b7b39172ee548ff303dbd73816cb7c1071f7887

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
using System.Linq;
using RiskControl.NewService.Entity;
using SqlSugar;
using System.Configuration;
 
namespace RiskControl.NewService.Service
{
    public class DbContext
    {
        public DbContext()
        {
            Db = new SqlSugarClient(new ConnectionConfig()
            {
                ConnectionString = ConfigurationManager.ConnectionStrings["connStrQcc"].ConnectionString,
                DbType = DbType.SqlServer,
                IsAutoCloseConnection = true,
                ConfigureExternalServices = new ConfigureExternalServices()
                {
 
                }
            });
 
            CreditRatingDb = new SqlSugarClient(new ConnectionConfig()
            {
                //ConnectionString = ConfigurationManager.ConnectionStrings["connStrCreditRating"].ConnectionString,
                //DbType = DbType.SqlServer,
                //IsAutoCloseConnection = true,
                //ConfigureExternalServices = new ConfigureExternalServices()
                //{
 
                //}
            });
 
            //调式代码 用来打印SQL 
            Db.Aop.OnLogExecuting = (sql, pars) =>
            {
                string s = sql;
                System.Diagnostics.Debug.WriteLine(sql + "\r\n" +
                                                   Db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
 
            };
        }
        public SqlSugarClient Db;//用来处理事务多表查询和复杂的操作
        public SqlSugarClient CreditRatingDb;
 
        public SimpleClient<T> GetClient<T>() where T : BaseEntity, new()
        {
            return new SimpleClient<T>(Db);
        }
 
    }
}