// Admin.NET 项目的版æƒã€å•†æ ‡ã€ä¸“利和其他相关æƒåˆ©å‡å—ç›¸åº”æ³•å¾‹æ³•è§„çš„ä¿æŠ¤ã€‚ä½¿ç”¨æœ¬é¡¹ç›®åº”éµå®ˆç›¸å…³æ³•律法规和许å¯è¯çš„è¦æ±‚。 // // 本项目主è¦éµå¾ª MIT 许å¯è¯å’Œ Apache 许å¯è¯ï¼ˆç‰ˆæœ¬ 2.0)进行分å‘和使用。许å¯è¯ä½äºŽæºä»£ç æ ‘æ ¹ç›®å½•ä¸çš„ LICENSE-MIT å’Œ LICENSE-APACHE 文件。 // // ä¸å¾—利用本项目从事å±å®³å›½å®¶å®‰å…¨ã€æ‰°ä¹±ç¤¾ä¼šç§©åºã€ä¾µçŠ¯ä»–äººåˆæ³•æƒç›Šç‰æ³•å¾‹æ³•è§„ç¦æ¢çš„æ´»åЍï¼ä»»ä½•基于本项目二次开å‘è€Œäº§ç”Ÿçš„ä¸€åˆ‡æ³•å¾‹çº çº·å’Œè´£ä»»ï¼Œæˆ‘ä»¬ä¸æ‰¿æ‹…ä»»ä½•è´£ä»»ï¼ 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 readonly IJsonSerializerProvider _jsonSerializer; public EnumToDictJob(IServiceScopeFactory scopeFactory, IJsonSerializerProvider jsonSerializer) { _scopeFactory = scopeFactory; _jsonSerializer = jsonSerializer; } public async Task ExecuteAsync(JobExecutingContext context, CancellationToken stoppingToken) { using var serviceScope = _scopeFactory.CreateScope(); var sysEnumService = serviceScope.ServiceProvider.GetRequiredService<SysEnumService>(); var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().CopyNew(); var enumTypeList = sysEnumService.GetEnumTypeList(); var enumCodeList = enumTypeList.Select(u => u.TypeName); var sysDictTypeCodeList = await db.Queryable<SysDictType>().Where(u => enumCodeList.Contains(u.Code)).Select(u => u.Code).ToListAsync(stoppingToken); // 更新的枚举转æ¢å—å…¸ var uEnumType = enumTypeList.Where(u => sysDictTypeCodeList.Contains(u.TypeName)).ToList(); var waitUpdateSysDictType = await db.Queryable<SysDictType>().Where(u => uEnumType.Any(a => a.TypeName == u.Code)).ToListAsync(stoppingToken); var waitUpdateSysDictTypeDict = waitUpdateSysDictType.ToDictionary(u => u.Code, u => u); var waitUpdateSysDictData = await db.Queryable<SysDictData>().Where(u => uEnumType.Any(a => a.TypeName == u.DictType.Code)).ToListAsync(stoppingToken); var uSysDictType = new List<SysDictType>(); var uSysDictData = new List<SysDictData>(); if (uEnumType.Count > 0) { uEnumType.ForEach(e => { if (waitUpdateSysDictTypeDict.TryGetValue(e.TypeName, out SysDictType value)) { var uDictType = value; uDictType.Name = e.TypeDescribe; uDictType.Remark = e.TypeRemark; var uDictData = waitUpdateSysDictData.Where(u => u.DictTypeId == uDictType.Id).ToList(); if (uDictData.Count > 0) { uDictData.ForEach(dictData => { var enumData = e.EnumEntities.Where(u => dictData.Code == u.Name).FirstOrDefault(); if (enumData != null) { dictData.Value = enumData.Value.ToString(); dictData.Code = enumData.Name; dictData.OrderNo = enumData.Value + 10; dictData.Name = enumData.Describe; dictData.TagType = enumData.Theme != "" ? enumData.Theme : dictData.TagType != "" ? dictData.TagType : "info"; uSysDictData.Add(dictData); } }); } if (!uSysDictType.Any(u => u.Id == uDictType.Id)) uSysDictType.Add(uDictType); } }); try { db.BeginTran(); if (uSysDictType.Count > 0) await db.Updateable(uSysDictType).ExecuteCommandAsync(stoppingToken); if (uSysDictData.Count > 0) await db.Updateable(uSysDictData).ExecuteCommandAsync(stoppingToken); db.CommitTran(); } catch (Exception error) { db.RollbackTran(); Log.Error($"{context.Trigger.Description}更新枚举转æ¢å—典入库错误:" + _jsonSerializer.Serialize(error)); throw new Exception($"{context.Trigger.Description}更新枚举转æ¢å—典入库错误"); } } // 新增的枚举转æ¢å—å…¸ var iEnumType = enumTypeList.Where(u => !sysDictTypeCodeList.Contains(u.TypeName)).ToList(); if (iEnumType.Count > 0) { // 新增å—典类型 var iDictType = iEnumType.Select(u => new SysDictType { Id = YitIdHelper.NextId(), Code = u.TypeName, Name = u.TypeDescribe, Remark = u.TypeRemark, Status = StatusEnum.Enable }).ToList(); // 新增å—å…¸æ•°æ® var dictData = iEnumType.Join(iDictType, t1 => t1.TypeName, t2 => t2.Code, (t1, t2) => new { data = t1.EnumEntities.Select(u => new SysDictData { Id = YitIdHelper.NextId(), // 性能优化,使用BulkCopyAsync必须手动获å–Id DictTypeId = t2.Id, Name = u.Describe, Value = u.Value.ToString(), Code = u.Name, Remark = t2.Remark, OrderNo = u.Value + 10, TagType = u.Theme != "" ? u.Theme : "info", }).ToList() }).ToList(); var iDictData = new List<SysDictData>(); dictData.ForEach(item => { iDictData.AddRange(item.data); }); try { db.BeginTran(); if (iDictType.Count > 0) await db.Insertable(iDictType).ExecuteCommandAsync(stoppingToken); if (iDictData.Count > 0) await db.Insertable(iDictData).ExecuteCommandAsync(stoppingToken); db.CommitTran(); } catch (Exception error) { db.RollbackTran(); Log.Error($"{context.Trigger.Description}新增枚举转æ¢å—典入库错误:" + _jsonSerializer.Serialize(error)); throw new Exception($"{context.Trigger.Description}新增枚举转æ¢å—典入库错误"); } } var originColor = Console.ForegroundColor; Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine($"ã€{DateTime.Now}】系统枚举转æ¢å—å…¸"); Console.ForegroundColor = originColor; } }