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
}
}