1 В избранное 0 Ответвления 0

OSCHINA-MIRROR/zuohuaijun-Admin.NET

Присоединиться к Gitlife
Откройте для себя и примите участие в публичных проектах с открытым исходным кодом с участием более 10 миллионов разработчиков. Приватные репозитории также полностью бесплатны :)
Присоединиться бесплатно
Клонировать/Скачать
EnumToDictJob.cs 6.1 КБ
Копировать Редактировать Web IDE Исходные данные Просмотреть построчно История
喵你个旺呀 Отправлено 5 месяцев назад 5f5a16c
// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
//
// 本项目主要遵循 MIT 许可证和 Apache 许可证(版本 2.0)进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
//
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动!任何基于本项目二次开发而产生的一切法律纠纷和责任,我们不承担任何责任!
using System.Security.Cryptography;
namespace Admin.NET.Core;
/// <summary>
/// 枚举转字典
/// </summary>
[JobDetail("job_EnumToDictJob", Description = "枚举转字典", GroupName = "default", Concurrent = false)]
[PeriodSeconds(1, TriggerId = "trigger_EnumToDictJob", Description = "枚举转字典", MaxNumberOfRuns = 1, RunOnStart = true)]
public class EnumToDictJob : IJob
{
private readonly IServiceScopeFactory _scopeFactory;
private const string DefaultTagType = null;
private const int OrderOffset = 10;
public EnumToDictJob(IServiceScopeFactory scopeFactory)
{
_scopeFactory = scopeFactory;
}
public async Task ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken)
{
var originColor = Console.ForegroundColor;
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine($"【{DateTime.Now}】系统枚举转换字典");
using var serviceScope = _scopeFactory.CreateScope();
var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().CopyNew();
var sysEnumService = serviceScope.ServiceProvider.GetRequiredService<SysEnumService>();
var sysDictTypeList = GetDictByEnumType(sysEnumService.GetEnumTypeList());
// 校验枚举类命名规范,字典相关功能中需要通过后缀判断是否为枚举类型
Console.ForegroundColor = ConsoleColor.Red;
foreach (var dictType in sysDictTypeList.Where(x => !x.Code.EndsWith("Enum")))
Console.WriteLine($"【{DateTime.Now}】系统枚举转换字典的枚举类名称必须以Enum结尾: {dictType.Code} ({dictType.Name})");
sysDictTypeList = sysDictTypeList.Where(x => x.Code.EndsWith("Enum")).ToList();
await SyncEnumToDictInfoAsync(db, sysDictTypeList);
Console.ForegroundColor = ConsoleColor.Yellow;
try
{
await db.BeginTranAsync();
var storageable1 = await db.Storageable(sysDictTypeList)
.SplitUpdate(it => it.Any())
.SplitInsert(_ => true)
.ToStorageAsync();
await storageable1.BulkCopyAsync();
await storageable1.BulkUpdateAsync();
Console.WriteLine($"【{DateTime.Now}】系统枚举类转字典类型数据: 插入{storageable1.InsertList.Count}条, 更新{storageable1.UpdateList.Count}条, 共{storageable1.TotalList.Count}条。");
var storageable2 = await db.Storageable(sysDictTypeList.SelectMany(x => x.Children).ToList())
.WhereColumns(it => new { it.DictTypeId, it.Code })
.SplitUpdate(it => it.Any())
.SplitInsert(_ => true)
.ToStorageAsync();
await storageable2.BulkCopyAsync();
await storageable2.BulkUpdateAsync(nameof(SysDictData.Value), nameof(SysDictData.Code), nameof(SysDictData.Name));
Console.WriteLine($"【{DateTime.Now}】系统枚举项转字典值数据: 插入{storageable2.InsertList.Count}条, 更新{storageable2.UpdateList.Count}条, 共{storageable2.TotalList.Count}条。");
await db.CommitTranAsync();
}
catch (Exception error)
{
await db.RollbackTranAsync();
Log.Error($"系统枚举转换字典操作错误:{error.Message}\n堆栈跟踪:{error.StackTrace}", error);
throw;
}
finally
{
Console.ForegroundColor = originColor;
}
}
/// <summary>
/// 用于同步枚举转字典旧数据, 后期可删除
/// </summary>
/// <param name="db"></param>
/// <param name="list"></param>
[Obsolete]
private async Task SyncEnumToDictInfoAsync(SqlSugarClient db, List<SysDictType> list)
{
var codeList = list.Select(x => x.Code).ToList();
foreach (var dbDictType in await db.Queryable<SysDictType>().Where(x => codeList.Contains(x.Code)).ToListAsync() ?? new())
{
var enumDictType = list.First(x => x.Code == dbDictType.Code);
if (enumDictType.Id == dbDictType.Id) continue;
// 数据不一致则删除
await db.Deleteable<SysDictData>().Where(x => x.DictTypeId == dbDictType.Id).ExecuteCommandAsync();
await db.Deleteable<SysDictType>().Where(x => x.Id == dbDictType.Id).ExecuteCommandAsync();
Console.WriteLine($"【{DateTime.Now}】删除字典数据: {dbDictType.Name}-{dbDictType.Code}");
}
}
/// <summary>
/// 枚举信息转字典
/// </summary>
/// <param name="enumTypeList"></param>
/// <returns></returns>
private List<SysDictType> GetDictByEnumType(List<EnumTypeOutput> enumTypeList)
{
var orderNo = 1;
var list = new List<SysDictType>();
foreach (var type in enumTypeList)
{
var dictType = new SysDictType
{
Id = 900000000000 + CommonUtil.GetFixedHashCode(type.TypeName),
Code = type.TypeName,
Name = type.TypeDescribe,
Remark = type.TypeRemark
};
dictType.Children = type.EnumEntities.Select(x => new SysDictData
{
Id = dictType.Id + orderNo++,
DictTypeId = dictType.Id,
Name = x.Name,
Value = x.Describe,
Code = x.Value.ToString(),
OrderNo = x.Value + OrderOffset,
TagType = x.Theme != "" ? x.Theme : DefaultTagType,
}).ToList();
list.Add(dictType);
}
return list;
}
}

Опубликовать ( 0 )

Вы можете оставить комментарий после Вход в систему

1
https://gitlife.ru/oschina-mirror/zuohuaijun-Admin.NET.git
git@gitlife.ru:oschina-mirror/zuohuaijun-Admin.NET.git
oschina-mirror
zuohuaijun-Admin.NET
zuohuaijun-Admin.NET
next