using System; using System.Collections.Generic; using System.Linq; using System.Text.RegularExpressions; using System.Threading.Tasks; using Mapster; using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json; using NCC.Common.Configuration; using NCC.Common.Core.Manager; using NCC.Common.Enum; using NCC.Common.Extension; using NCC.Common.Filter; using NCC.Common.Helper; using NCC.Common.Model.NPOI; using NCC.DataEncryption; using NCC.Dependency; using NCC.DynamicApiController; using NCC.Extend.Entitys.Dto.LqMdTarget; using NCC.Extend.Entitys.Enum; using NCC.Extend.Entitys.lq_md_target; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Interfaces.BusinessOperationLog; using NCC.Extend.Interfaces.LqMdTarget; using NCC.FriendlyException; using NCC.System.Entitys.Permission; using SqlSugar; using Yitter.IdGenerator; namespace NCC.Extend.LqMdTarget { /// /// 门店目标服务 /// [ApiDescriptionSettings(Tag = "绿纤门店目标服务", Name = "LqMdTarget", Order = 200)] [Route("api/Extend/[controller]")] public class LqMdTargetService : ILqMdTargetService, IDynamicApiController, ITransient { private const int InvalidStatus = (int)StatusEnum.无效; private readonly ISqlSugarRepository _lqMdTargetRepository; private readonly SqlSugarScope _db; private readonly IUserManager _userManager; private readonly IBusinessOperationLogService _businessOperationLogService; /// /// 初始化一个类型的新实例 /// public LqMdTargetService( ISqlSugarRepository lqMdTargetRepository, IUserManager userManager, IBusinessOperationLogService businessOperationLogService) { _lqMdTargetRepository = lqMdTargetRepository; _db = _lqMdTargetRepository.Context; _userManager = userManager; _businessOperationLogService = businessOperationLogService; } #region 获取门店目标信息 /// /// 获取门店目标信息 /// /// 主键ID /// [HttpGet("{id}")] public async Task GetInfo(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); var output = entity.Adapt(); return output; } #endregion #region 获取门店目标列表 /// /// 获取门店目标列表 /// /// 请求参数 /// [HttpGet("")] public async Task GetList([FromQuery] LqMdTargetListQueryInput input) { var sidx = input.sidx == null ? "id" : input.sidx; var sort = string.IsNullOrEmpty(input.sort) ? "DESC" : input.sort; var data = await BuildListOutputQuery(input) .MergeTable() .OrderBy($"{sidx} {sort}") .ToPagedListAsync(input.currentPage, input.pageSize); if (data.list != null) { var list = data.list.ToList(); await EnrichStoreDisplayAsync(list); data.list = list; } return PageResult.SqlSugarPageResult(data); } #endregion #region 导出门店目标 /// /// 导出门店目标设置 /// /// /// 按与列表接口相同的筛选条件导出全部匹配数据(不分页)。 /// /// 示例请求: /// GET /api/Extend/LqMdTarget/Actions/Export?month=202507&storeId=门店ID /// /// 参数说明: /// - storeId: 门店ID,可选 /// - month: 月份(YYYYMM),可选 /// - businessUnit: 归属事业部,可选 /// - techDepartment: 归属科技部,可选 /// - educationDepartment: 归属教育部,可选 /// - majorProjectDepartment: 归属大项目部,可选 /// /// 查询参数(与列表接口一致) /// Excel 下载信息 /// 导出成功 [HttpGet("Actions/Export")] public async Task Export([FromQuery] LqMdTargetListQueryInput input) { _ = await _userManager.GetUserInfo(); var sidx = input.sidx == null ? "id" : input.sidx; var sort = string.IsNullOrEmpty(input.sort) ? "DESC" : input.sort; var exportData = await BuildListOutputQuery(input) .MergeTable() .OrderBy($"{sidx} {sort}") .ToListAsync(); await EnrichExportNamesAsync(exportData); List paramList = "[{\"value\":\"门店名称\",\"field\":\"storeName\"},{\"value\":\"月份\",\"field\":\"month\"},{\"value\":\"事业部\",\"field\":\"businessUnit\"},{\"value\":\"科技部\",\"field\":\"techDepartment\"},{\"value\":\"教育部\",\"field\":\"educationDepartment\"},{\"value\":\"大项目部\",\"field\":\"majorProjectDepartment\"},{\"value\":\"事业部目标\",\"field\":\"businessUnitTarget\"},{\"value\":\"科技部目标\",\"field\":\"techDepartmentTarget\"},{\"value\":\"教育部目标\",\"field\":\"educationDepartmentTarget\"},{\"value\":\"大项目部目标\",\"field\":\"majorProjectDepartmentTarget\"},{\"value\":\"门店目标\",\"field\":\"storeTarget\"},{\"value\":\"门店生命线\",\"field\":\"storeLifeline\"},{\"value\":\"门店耗卡目标\",\"field\":\"storeConsumeTarget\"},{\"value\":\"门店项目目标\",\"field\":\"storeProjectTarget\"},{\"value\":\"门店人员目标\",\"field\":\"storeHeadcountTarget\"},{\"value\":\"助理人员目标阶段1\",\"field\":\"assistantHeadcountTargetStage1\"},{\"value\":\"助理人员目标阶段2\",\"field\":\"assistantHeadcountTargetStage2\"}]".ToList(); ExcelConfig excelconfig = new ExcelConfig(); excelconfig.FileName = "门店目标设置.xls"; excelconfig.HeadFont = "微软雅黑"; excelconfig.HeadPoint = 10; excelconfig.IsAllSizeColumn = true; excelconfig.ColumnModel = new List(); foreach (var param in paramList) { excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = param.field, ExcelColumn = param.value }); } var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName; ExcelExportHelper.Export(exportData, excelconfig, addPath); var summaryParts = new List(); if (!string.IsNullOrEmpty(input.month)) summaryParts.Add($"月份={input.month}"); if (!string.IsNullOrEmpty(input.storeId)) { var storeLabel = exportData.FirstOrDefault(x => x.storeId == input.storeId)?.storeName; summaryParts.Add($"门店={storeLabel ?? input.storeId}"); } var summary = summaryParts.Count > 0 ? $"导出门店目标 {string.Join(",", summaryParts)},共 {exportData.Count} 条" : $"导出门店目标,共 {exportData.Count} 条"; try { var detailJson = JsonConvert.SerializeObject(new { filters = new { storeId = input.storeId, month = input.month, businessUnit = input.businessUnit, techDepartment = input.techDepartment, educationDepartment = input.educationDepartment, majorProjectDepartment = input.majorProjectDepartment }, rowCount = exportData.Count, fileName = excelconfig.FileName }); await _businessOperationLogService.WriteAsync( "门店目标", "导出门店目标", "lq_md_target", null, summary, detailJson); } catch { // 写日志失败不影响导出结果 } var fileName = _userManager.UserId + "|" + addPath + "|xls"; return new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; } #endregion #region 新建门店目标 /// /// 新建门店目标 /// /// 参数 /// [HttpPost("")] public async Task Create([FromBody] LqMdTargetCrInput input) { var userInfo = await _userManager.GetUserInfo(); // 验证门店ID和月份的唯一性 var exists = await _db.Queryable().Where(p => p.StoreId == input.storeId && p.Month == input.month).AnyAsync(); if (exists) { throw NCCException.Oh(ErrorCode.COM1000, "该门店在该月份已存在目标记录"); } // 验证月份格式 if (input.month.Length != 6 || !Regex.IsMatch(input.month, @"^\d{6}$")) { throw NCCException.Oh(ErrorCode.COM1000, "月份格式必须为YYYYMM(如:202501)"); } var entity = input.Adapt(); entity.Id = YitIdHelper.NextId().ToString(); await NormalizeOrganizeFieldsAsync(entity); entity.CreateTime = DateTime.Now; entity.CreateUser = userInfo.userId; var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000); await TryWriteBusinessLogAsync( "门店目标", "新增门店目标", "lq_md_target", entity.Id, $"新增门店目标:门店={input.storeId},月份={input.month}", JsonConvert.SerializeObject(new { after = new { entity.Id, entity.StoreId, entity.Month } })); } #endregion #region 根据门店批量创建数据 /// /// 根据门店批量创建数据 /// 会删除设置月份的所有门店数据(谨用!!!) /// /// 月份(YYYYMM格式) /// [HttpPost("BatchCreateByStores")] public async Task BatchCreateByStores([FromQuery] string month) { var userInfo = await _userManager.GetUserInfo(); if (userInfo == null || string.IsNullOrEmpty(userInfo.userId)) { throw NCCException.Oh("用户信息获取失败,请重新登录"); } // 验证月份格式 if (string.IsNullOrEmpty(month) || month.Length != 6 || !Regex.IsMatch(month, @"^\d{6}$")) { throw NCCException.Oh("月份格式必须为YYYYMM(如:202501)"); } //查询门店列表 var storeList = await _db.Queryable().Select(p => p.Id).ToListAsync(); if (storeList == null || storeList.Count == 0) { return new { success = true, message = "没有有效的门店数据", createdCount = 0 }; } // 删除设置月份的所有门店数据 await _db.Deleteable().Where(p => p.Month == month).ExecuteCommandAsync(); // 批量创建 var entities = new List(); foreach (var storeId in storeList) { if (string.IsNullOrEmpty(storeId)) continue; entities.Add(new LqMdTargetEntity { Id = YitIdHelper.NextId().ToString(), StoreId = storeId, Month = month, BusinessUnit = "", TechDepartment = "", EducationDepartment = "", MajorProjectDepartment = "", BusinessUnitTarget = 0, TechDepartmentTarget = 0, EducationDepartmentTarget = 0, BusinessUnitGeneralManager = "", BusinessUnitManager = "", StoreTarget = 0, StoreLifeline = 0, StoreConsumeTarget = 0, StoreProjectTarget = 0, StoreHeadcountTarget = 0, AssistantHeadcountTargetStage1 = 0, AssistantHeadcountTargetStage2 = 0, CreateTime = DateTime.Now, CreateUser = userInfo.userId, }); } if (entities.Count == 0) { return new { success = true, message = "没有有效的门店数据可创建", createdCount = 0 }; } var isOk = await _db.Insertable(entities).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000, "批量创建失败"); await TryWriteBusinessLogAsync( "门店目标", "批量创建门店目标", "lq_md_target", null, $"批量创建门店目标:月份={month},共 {isOk} 条", JsonConvert.SerializeObject(new { month, createdCount = isOk })); return new { success = true, message = $"成功创建{isOk}条记录", createdCount = isOk }; } #endregion #region 更新门店目标 /// /// 更新门店目标 /// /// 主键ID /// 参数 /// [HttpPut("{id}")] public async Task Update(string id, [FromBody] LqMdTargetUpInput input) { var userInfo = await _userManager.GetUserInfo(); // 验证记录是否存在 var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); var beforeSnapshot = new { entity.StoreId, entity.Month, entity.StoreTarget, entity.StoreLifeline }; // 验证月份格式 if (input.month.Length != 6 || !Regex.IsMatch(input.month, @"^\d{6}$")) { throw NCCException.Oh("月份格式必须为YYYYMM(如:202501)"); } // 如果门店ID或月份发生变化,需要验证唯一性 if (entity.StoreId != input.storeId || entity.Month != input.month) { var exists = await _db.Queryable().Where(p => p.StoreId == input.storeId && p.Month == input.month && p.Id != id).AnyAsync(); if (exists) { throw NCCException.Oh("该门店在该月份已存在目标记录"); } } var updateEntity = input.Adapt(); updateEntity.Id = id; await NormalizeOrganizeFieldsAsync(updateEntity); updateEntity.UpdateTime = DateTime.Now; updateEntity.UpdateUser = userInfo.userId; var isOk = await _db.Updateable(updateEntity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); await TryWriteBusinessLogAsync( "门店目标", "修改门店目标", "lq_md_target", id, $"修改门店目标:门店={input.storeId},月份={input.month}", JsonConvert.SerializeObject(new { before = beforeSnapshot, after = new { input.storeId, input.month, input.storeTarget, input.storeLifeline } })); } #endregion #region 删除门店目标 /// /// 删除门店目标 /// /// 主键ID /// [HttpDelete("{id}")] public async Task Delete(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); var isOk = await _db.Deleteable().Where(d => d.Id == id).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1002); await TryWriteBusinessLogAsync( "门店目标", "删除门店目标", "lq_md_target", id, $"删除门店目标:门店={entity.StoreId},月份={entity.Month}", JsonConvert.SerializeObject(new { before = new { entity.Id, entity.StoreId, entity.Month } })); } #endregion #region 同步上月数据 /// /// 同步上月数据 /// /// 目标月份(YYYYMM格式),如果为空则同步到当前月份 /// [HttpPost("SyncLastMonthData")] public async Task SyncLastMonthData([FromQuery] string targetMonth = null) { var userInfo = await _userManager.GetUserInfo(); // 确定目标月份 string targetMonthStr; if (string.IsNullOrEmpty(targetMonth)) { // 如果未指定,使用当前月份 var now = DateTime.Now; targetMonthStr = now.ToString("yyyyMM"); } else { // 验证月份格式 if (targetMonth.Length != 6 || !Regex.IsMatch(targetMonth, @"^\d{6}$")) { throw NCCException.Oh(ErrorCode.COM1000, "月份格式必须为YYYYMM(如:202501)"); } targetMonthStr = targetMonth; } // 计算上个月份 var targetDate = DateTime.ParseExact(targetMonthStr, "yyyyMM", null); var lastMonthDate = targetDate.AddMonths(-1); var lastMonthStr = lastMonthDate.ToString("yyyyMM"); // 查询上个月的所有门店目标数据 var lastMonthData = await _db.Queryable() .Where(p => p.Month == lastMonthStr) .ToListAsync(); if (lastMonthData == null || lastMonthData.Count == 0) { return new { success = true, message = $"上个月({lastMonthStr})没有数据可同步", syncedCount = 0, skippedCount = 0 }; } // 查询目标月份已存在的记录 var existingStoreIds = await _db.Queryable() .Where(p => p.Month == targetMonthStr) .Select(p => p.StoreId) .ToListAsync(); // 过滤掉已存在的门店,只同步新门店 var newEntities = lastMonthData .Where(p => !existingStoreIds.Contains(p.StoreId)) .Select(p => new LqMdTargetEntity { Id = YitIdHelper.NextId().ToString(), StoreId = p.StoreId, Month = targetMonthStr, BusinessUnit = p.BusinessUnit, TechDepartment = p.TechDepartment, EducationDepartment = p.EducationDepartment, MajorProjectDepartment = p.MajorProjectDepartment, BusinessUnitTarget = p.BusinessUnitTarget, TechDepartmentTarget = p.TechDepartmentTarget, EducationDepartmentTarget = p.EducationDepartmentTarget, BusinessUnitGeneralManager = p.BusinessUnitGeneralManager, BusinessUnitManager = p.BusinessUnitManager, StoreTarget = p.StoreTarget, StoreLifeline = p.StoreLifeline, StoreConsumeTarget = p.StoreConsumeTarget, StoreProjectTarget = p.StoreProjectTarget, StoreHeadcountTarget = p.StoreHeadcountTarget, AssistantHeadcountTargetStage1 = p.AssistantHeadcountTargetStage1, AssistantHeadcountTargetStage2 = p.AssistantHeadcountTargetStage2, CreateTime = DateTime.Now, CreateUser = userInfo.userId, }) .ToList(); int syncedCount = 0; int skippedCount = lastMonthData.Count - newEntities.Count; if (newEntities.Count > 0) { var orgAliasMap = await BuildOrganizeAliasToIdMapAsync(); foreach (var entity in newEntities) { NormalizeOrganizeFields(entity, orgAliasMap); } syncedCount = await _db.Insertable(newEntities).ExecuteCommandAsync(); } if (syncedCount > 0) { await TryWriteBusinessLogAsync( "门店目标", "同步上月门店目标", "lq_md_target", null, $"同步上月门店目标:{lastMonthStr} → {targetMonthStr},共 {syncedCount} 条", JsonConvert.SerializeObject(new { lastMonth = lastMonthStr, targetMonth = targetMonthStr, syncedCount, skippedCount })); } return new { success = true, message = $"同步完成:成功同步{syncedCount}条记录,跳过{skippedCount}条已存在的记录", syncedCount = syncedCount, skippedCount = skippedCount, lastMonth = lastMonthStr, targetMonth = targetMonthStr }; } #endregion #region 获取部门管理的门店列表 /// /// 获取部门管理的门店列表 /// /// /// 根据年月、组织类型、部门ID查询该部门在该月份管理的门店列表 /// /// 示例请求: /// ```json /// { /// "month": "202511", /// "organizationType": "事业部", /// "departmentId": "部门ID" /// } /// ``` /// /// 参数说明: /// - month: 年月,格式为YYYYMM(如:202511表示2025年11月) /// - organizationType: 组织类型,可选值:事业部、科技部、教育部、大项目部 /// - departmentId: 部门ID /// /// 查询参数 /// 门店列表(包含门店ID和门店名称) /// 成功返回门店列表 /// 参数错误 [HttpPost("GetManagedStores")] public async Task GetManagedStores([FromBody] GetManagedStoresInput input) { try { // 验证参数 if (input == null) { throw NCCException.Oh("参数不能为空"); } if (string.IsNullOrEmpty(input.Month)) { throw NCCException.Oh("年月不能为空"); } if (input.Month.Length != 6 || !Regex.IsMatch(input.Month, @"^\d{6}$")) { throw NCCException.Oh("年月格式必须为YYYYMM(如:202511)"); } if (string.IsNullOrEmpty(input.OrganizationType)) { throw NCCException.Oh("组织类型不能为空"); } if (string.IsNullOrEmpty(input.DepartmentId)) { throw NCCException.Oh("部门ID不能为空"); } // 构建查询条件(使用多表关联方式) var query = _db.Queryable( (t, s) => t.StoreId == s.Id) .Where((t, s) => t.Month == input.Month); var orgAliasMap = await BuildOrganizeAliasToIdMapAsync(); var departmentId = ResolveOrganizeId(input.DepartmentId, orgAliasMap); if (string.IsNullOrEmpty(departmentId)) { throw NCCException.Oh("部门ID无效"); } // 根据组织类型添加部门过滤条件(兼容历史名称脏数据) switch (input.OrganizationType) { case "事业部": query = query.Where((t, s) => t.BusinessUnit == departmentId || t.BusinessUnit == input.DepartmentId); break; case "科技部": query = query.Where((t, s) => t.TechDepartment == departmentId || t.TechDepartment == input.DepartmentId); break; case "教育部": query = query.Where((t, s) => t.EducationDepartment == departmentId || t.EducationDepartment == input.DepartmentId); break; case "大项目部": query = query.Where((t, s) => t.MajorProjectDepartment == departmentId || t.MajorProjectDepartment == input.DepartmentId); break; default: throw NCCException.Oh($"不支持的组织类型:{input.OrganizationType},支持的类型:事业部、科技部、教育部、大项目部"); } // 关联门店表获取门店名称 var result = await query .Select((t, s) => new ManagedStoreOutput { StoreId = t.StoreId, StoreName = s.Dm ?? "未知门店" }) .ToListAsync(); return result; } catch (Exception ex) { throw NCCException.Oh($"查询失败:{ex.Message}"); } } #endregion #region 私有方法 /// /// 构建与列表一致的筛选查询 /// private ISugarQueryable BuildFilteredQuery(LqMdTargetListQueryInput input) { return _db.Queryable() .WhereIF(!string.IsNullOrEmpty(input.storeId), p => p.StoreId.Contains(input.storeId)) .WhereIF(!string.IsNullOrEmpty(input.month), p => p.Month == input.month) .WhereIF(!string.IsNullOrEmpty(input.businessUnit), p => p.BusinessUnit.Contains(input.businessUnit)) .WhereIF(!string.IsNullOrEmpty(input.techDepartment), p => p.TechDepartment.Contains(input.techDepartment)) .WhereIF(!string.IsNullOrEmpty(input.educationDepartment), p => p.EducationDepartment.Contains(input.educationDepartment)) .WhereIF(!string.IsNullOrEmpty(input.majorProjectDepartment), p => p.MajorProjectDepartment.Contains(input.majorProjectDepartment)); } /// /// 构建列表/导出共用的输出投影 /// private ISugarQueryable BuildListOutputQuery(LqMdTargetListQueryInput input) { return BuildFilteredQuery(input) .Select(it => new LqMdTargetListOutput { id = it.Id, storeId = it.StoreId, month = it.Month, businessUnit = it.BusinessUnit, techDepartment = it.TechDepartment, educationDepartment = it.EducationDepartment, majorProjectDepartment = it.MajorProjectDepartment, businessUnitTarget = it.BusinessUnitTarget, techDepartmentTarget = it.TechDepartmentTarget, educationDepartmentTarget = it.EducationDepartmentTarget, majorProjectDepartmentTarget = it.MajorProjectDepartmentTarget, businessUnitGeneralManager = it.BusinessUnitGeneralManager, businessUnitManager = it.BusinessUnitManager, storeTarget = it.StoreTarget, storeLifeline = it.StoreLifeline, storeConsumeTarget = it.StoreConsumeTarget, storeProjectTarget = it.StoreProjectTarget, storeHeadcountTarget = it.StoreHeadcountTarget, assistantHeadcountTargetStage1 = it.AssistantHeadcountTargetStage1, assistantHeadcountTargetStage2 = it.AssistantHeadcountTargetStage2, createTime = it.CreateTime, createUser = it.CreateUser, updateTime = it.UpdateTime, updateUser = it.UpdateUser, }); } /// /// 列表展示:仅补门店名称,归属字段保持组织ID(避免编辑保存时把名称写回库) /// private async Task EnrichStoreDisplayAsync(List rows) { if (rows == null || rows.Count == 0) return; var storeIds = rows .Where(x => !string.IsNullOrEmpty(x.storeId)) .Select(x => x.storeId) .Distinct() .ToList(); if (storeIds.Count == 0) return; var storeDict = (await _db.Queryable() .Where(x => storeIds.Contains(x.Id)) .Select(x => new { x.Id, x.Dm, x.Status }) .ToListAsync()) .ToDictionary( x => x.Id, x => new StoreDisplayInfo { Name = x.Dm ?? string.Empty, Deleted = x.Status == InvalidStatus }); foreach (var item in rows) { if (!string.IsNullOrEmpty(item.storeId) && storeDict.TryGetValue(item.storeId, out var storeInfo)) { item.storeName = storeInfo.Name; item.storeDeleted = storeInfo.Deleted; } } } /// /// 解析门店与组织名称,供导出展示(含已软删门店) /// private async Task EnrichExportNamesAsync(List exportData) { if (exportData == null || exportData.Count == 0) return; await EnrichStoreDisplayAsync(exportData); var orgValues = exportData .SelectMany(x => new[] { x.businessUnit, x.techDepartment, x.educationDepartment, x.majorProjectDepartment }) .Where(x => !string.IsNullOrEmpty(x)) .Distinct() .ToList(); var orgDict = new Dictionary(); var orgNameDict = new Dictionary(StringComparer.Ordinal); if (orgValues.Count > 0) { var orgs = await _db.Queryable() .Where(x => (orgValues.Contains(x.Id) || orgValues.Contains(x.FullName)) && x.DeleteMark == null && x.Category == "department") .Select(x => new { x.Id, x.FullName }) .ToListAsync(); orgDict = orgs.ToDictionary(x => x.Id, x => x.FullName ?? string.Empty); foreach (var org in orgs.Where(x => !string.IsNullOrEmpty(x.FullName))) { orgNameDict[org.FullName] = org.FullName; } } foreach (var item in exportData) { item.businessUnit = ResolveOrganizeDisplayName(item.businessUnit, orgDict, orgNameDict); item.techDepartment = ResolveOrganizeDisplayName(item.techDepartment, orgDict, orgNameDict); item.educationDepartment = ResolveOrganizeDisplayName(item.educationDepartment, orgDict, orgNameDict); item.majorProjectDepartment = ResolveOrganizeDisplayName(item.majorProjectDepartment, orgDict, orgNameDict); } } /// /// 保存前将归属字段统一归一化为 base_organize.F_Id /// private async Task NormalizeOrganizeFieldsAsync(LqMdTargetEntity entity) { if (entity == null) return; var orgAliasMap = await BuildOrganizeAliasToIdMapAsync(); NormalizeOrganizeFields(entity, orgAliasMap); } /// /// 使用组织映射将归属字段归一化为组织ID /// private static void NormalizeOrganizeFields(LqMdTargetEntity entity, Dictionary orgAliasMap) { if (entity == null) return; entity.BusinessUnit = ResolveOrganizeId(entity.BusinessUnit, orgAliasMap, "事业部"); entity.TechDepartment = ResolveOrganizeId(entity.TechDepartment, orgAliasMap, "科技部"); entity.EducationDepartment = ResolveOrganizeId(entity.EducationDepartment, orgAliasMap, "教育部"); entity.MajorProjectDepartment = ResolveOrganizeId(entity.MajorProjectDepartment, orgAliasMap, "大项目部"); } /// /// 构建组织别名(ID/名称)到组织ID的映射 /// private async Task> BuildOrganizeAliasToIdMapAsync() { var orgs = await _db.Queryable() .Where(x => x.Category == "department" && x.DeleteMark == null) .Select(x => new { x.Id, x.FullName }) .ToListAsync(); var map = new Dictionary(StringComparer.Ordinal); foreach (var org in orgs) { if (!string.IsNullOrEmpty(org.Id)) map[org.Id] = org.Id; if (!string.IsNullOrEmpty(org.FullName) && !map.ContainsKey(org.FullName)) map[org.FullName] = org.Id; } return map; } /// /// 组织归属值(ID 或名称)解析为标准组织ID;无法解析时抛出友好错误 /// private static string ResolveOrganizeId(string rawValue, Dictionary orgAliasMap, string fieldLabel = null) { if (string.IsNullOrWhiteSpace(rawValue)) return rawValue; if (orgAliasMap != null && orgAliasMap.TryGetValue(rawValue, out var mappedId) && !string.IsNullOrEmpty(mappedId)) return mappedId; if (Regex.IsMatch(rawValue, @"^\d{15,}$")) return rawValue; var label = string.IsNullOrEmpty(fieldLabel) ? "组织归属" : fieldLabel; throw NCCException.Oh($"{label}「{rawValue}」无效,请重新选择部门"); } /// /// 门店展示信息(含软删标记) /// private sealed class StoreDisplayInfo { public string Name { get; set; } public bool Deleted { get; set; } } /// /// 组织ID解析为名称,解析不到则保留原值 /// private static string ResolveOrganizeDisplayName( string organizeValue, Dictionary orgIdDict, Dictionary orgNameDict) { if (string.IsNullOrEmpty(organizeValue)) return organizeValue; if (orgIdDict.TryGetValue(organizeValue, out var name) && !string.IsNullOrEmpty(name)) return name; if (orgNameDict.TryGetValue(organizeValue, out var existingName) && !string.IsNullOrEmpty(existingName)) return existingName; return organizeValue; } private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null) { try { await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson); } catch (Exception) { // 写日志失败不拖垮主业务 } } #endregion } }