99ditui/src/platform/ZhonTai.Admin/Core/Db/FreeSqlCloudExtesions.cs

using Microsoft.Extensions.DependencyInjection;
using System;
using StackExchange.Profiling;
using FreeSql;
using ZhonTai.Admin.Core.Auth;
using ZhonTai.Admin.Core.Configs;
using ZhonTai.Admin.Core.Dto;
using ZhonTai.Admin.Core.Entities;
using ZhonTai.Admin.Domain.Tenant;
using ZhonTai.Admin.Core.Consts;

namespace ZhonTai.Admin.Core.Db;

public static class FreeSqlCloudExtesions
{
    /// <summary>
    /// 创建FreeSql实例
    /// </summary>
    /// <param name="user"></param>
    /// <param name="appConfig"></param>
    /// <param name="dbConfig"></param>
    /// <param name="tenant"></param>
    /// <returns></returns>
    private static IFreeSql CreateFreeSql(IUser user, AppConfig appConfig, DbConfig dbConfig, CreateFreeSqlTenantDto tenant)
    {
        if(tenant == null)
        {
            tenant = new CreateFreeSqlTenantDto
            {
                DbType = dbConfig.Type,
                ConnectionString = dbConfig.ConnectionString
            };
        }
        var freeSqlBuilder = new FreeSqlBuilder()
        .UseConnectionString(tenant.DbType.Value, tenant.ConnectionString)
        .UseAutoSyncStructure(false)
        .UseLazyLoading(false)
        .UseNoneCommandParameter(true);

        #region 监听所有命令

        if (dbConfig.MonitorCommand)
        {
            freeSqlBuilder.UseMonitorCommand(cmd => { }, (cmd, traceLog) =>
            {
                Console.WriteLine($"{cmd.CommandText}\r\n");
            });
        }

        #endregion 监听所有命令

        var fsql = freeSqlBuilder.Build();

        //软删除过滤器
        fsql.GlobalFilter.ApplyOnly<IDelete>(FilterNames.Delete, a => a.IsDeleted == false);

        //租户过滤器
        if (appConfig.Tenant)
        {
            fsql.GlobalFilter.ApplyOnlyIf<ITenant>(FilterNames.Tenant, () => user?.Id > 0, a => a.TenantId == user.TenantId);
        }

        //配置实体
        DbHelper.ConfigEntity(fsql, appConfig);

        #region 监听Curd操作

        if (dbConfig.Curd)
        {
            fsql.Aop.CurdBefore += (s, e) =>
            {
                if (appConfig.MiniProfiler)
                {
                    MiniProfiler.Current.CustomTiming("CurdBefore", e.Sql);
                }
                Console.WriteLine($"{e.Sql}\r\n");
            };
            fsql.Aop.CurdAfter += (s, e) =>
            {
                if (appConfig.MiniProfiler)
                {
                    MiniProfiler.Current.CustomTiming("CurdAfter", $"{e.ElapsedMilliseconds}");
                }
                Console.WriteLine($"{e.Sql}\r\n");
            };
        }

        #endregion 监听Curd操作

        #region 审计数据

        //计算服务器时间
        var serverTime = fsql.Ado.QuerySingle(() => DateTime.UtcNow);
        var timeOffset = DateTime.UtcNow.Subtract(serverTime);
        fsql.Aop.AuditValue += (s, e) =>
        {
            DbHelper.AuditValue(e, timeOffset, user);
        };

        #endregion 审计数据

        return fsql;
    }

    public static string GetDbKey(this FreeSqlCloud _, IServiceProvider serviceProvider)
    {
        var user = serviceProvider.GetRequiredService<IUser>();
        var appConfig = serviceProvider.GetRequiredService<AppConfig>();
        var tenantId = user.TenantId;
        if (appConfig.Tenant && tenantId.HasValue)
        {
            return user.DbKey.NotNull() ? user.DbKey : (DbKeys.TenantDb + tenantId);
        }
        else
        {
            return DbKeys.MasterDb;
        }
    }

    /// <summary>
    /// 获得当前登录用户数据库
    /// </summary>
    /// <param name="cloud"></param>
    /// <param name="serviceProvider"></param>
    /// <returns></returns>
    public static IFreeSql GetCurrentDb(this FreeSqlCloud cloud, IServiceProvider serviceProvider)
    {
        var user = serviceProvider.GetRequiredService<IUser>();
        var appConfig = serviceProvider.GetRequiredService<AppConfig>();

        var tenantId = user.TenantId;
        var dbKey = GetDbKey(cloud, serviceProvider);
        var exists = cloud.ExistsRegister(dbKey);

        if (!exists)
        {
            var dbConfig = serviceProvider.GetRequiredService<DbConfig>();
            var tenantRepository = serviceProvider.GetRequiredService<ITenantRepository>();
            var tenant = tenantRepository.Select.DisableGlobalFilter(FilterNames.Tenant).WhereDynamic(tenantId).ToOne<CreateFreeSqlTenantDto>();
            cloud.Register(dbKey, () => CreateFreeSql(user, appConfig, dbConfig, tenant));
        }

        return cloud.Use(dbKey);
    }

    /// <summary>
    /// 获得租户数据库
    /// </summary>
    /// <param name="cloud"></param>
    /// <param name="serviceProvider"></param>
    /// <param name="tenantId"></param>
    /// <returns></returns>
    public static IFreeSql GetTenantDb(this FreeSqlCloud cloud, IServiceProvider serviceProvider, long? tenantId = null)
    {
        if (!tenantId.HasValue)
        {
            return null;
        }

        var tenantRepository = serviceProvider.GetRequiredService<ITenantRepository>();
        var tenant = tenantRepository.Select.DisableGlobalFilter(FilterNames.Tenant).WhereDynamic(tenantId).ToOne<CreateFreeSqlTenantDto>();
        var dbKey = tenant.DbKey.NotNull() ? tenant.DbKey : (DbKeys.TenantDb + tenantId);
        var exists = cloud.ExistsRegister(dbKey);
        
        if (!exists)
        {
            var user = serviceProvider.GetRequiredService<IUser>();
            var dbConfig = serviceProvider.GetRequiredService<DbConfig>();
            var appConfig = serviceProvider.GetRequiredService<AppConfig>();
            cloud.Register(dbKey, () => CreateFreeSql(user, appConfig, dbConfig, tenant));
        }

        return cloud.Use(dbKey);
    }
}