using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using NCC.ClayObject; using NCC.Code; 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.Common.Util; using NCC.DataEncryption; using NCC.JsonSerialization; using NCC.Dependency; using NCC.DynamicApiController; using NCC.Extend.Entitys.Dto.LqMemberArrival; using NCC.Extend.Entitys.Enum; using NCC.Extend.Entitys.lq_khxx; using NCC.Extend.Entitys.lq_md_target; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Entitys.lq_member_arrival_record; using NCC.Extend.Helpers; using NCC.Extend.Interfaces.BusinessOperationLog; using NCC.Extend.Interfaces.LqMemberArrival; using NCC.FriendlyException; using NCC.System.Entitys.Model.Permission.User; using NCC.System.Entitys.Permission; using Newtonsoft.Json; using SqlSugar; using Yitter.IdGenerator; namespace NCC.Extend { /// /// 员工到院转化(独立模块,只读会员/组织/门店) /// [ApiDescriptionSettings(Tag = "员工到院转化", Name = "LqMemberArrival", Order = 213)] [Route("api/Extend/LqMemberArrival")] public class LqMemberArrivalService : ILqMemberArrivalService, IDynamicApiController, ITransient { private const string BizLogModule = "员工到院信息"; private const string BizType = "lq_member_arrival_record"; private const int EffectiveYes = 1; private const int EffectiveNo = 0; private const string BusinessUnitOrgName = "事业部"; private const string MajorProjectOrgName = "大项目部"; private static readonly string[] BusinessUnitDeptNames = { "事业一部", "事业二部", "事业三部", "事业四部", "事业五部", "事业六部" }; private static readonly string[] MajorProjectDeptNames = { "大项目一部", "大项目二部" }; private readonly ISqlSugarClient _db; private readonly IUserManager _userManager; private readonly IBusinessOperationLogService _businessOperationLogService; /// /// 初始化员工到院转化服务 /// public LqMemberArrivalService( ISqlSugarClient db, IUserManager userManager, IBusinessOperationLogService businessOperationLogService) { _db = db; _userManager = userManager; _businessOperationLogService = businessOperationLogService; } /// /// 会员分页搜索(默认本店,可跨店) /// /// /// 手机端登记页搜索会员。默认仅返回当前登录人门店有效会员;crossStore=1 时不按门店过滤。 /// 支持姓名/手机/档案号模糊匹配。 /// /// 示例请求: /// ```json /// { /// "keyword": "138", /// "crossStore": 0, /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 参数说明: /// - keyword: 姓名/手机/档案号,可选 /// - crossStore: 0 或不传仅本店;1 跨店搜索 /// - currentPage/pageSize: 分页参数 /// /// 搜索条件 /// 会员分页列表(memberId/memberName/mobile/archiveNo/gsmdName) /// 已登录时返回分页结果;未登录或登录过期时 HTTP 仍为 200,统一响应体 code=600 /// 当前用户未绑定门店等业务校验失败 /// 服务器错误 [HttpGet("SearchMembers")] public async Task SearchMembersAsync([FromQuery] LqMemberArrivalSearchMembersQueryInput input) { input ??= new LqMemberArrivalSearchMembersQueryInput(); var recorder = await GetRecorderSnapshotAsync(); if (string.IsNullOrWhiteSpace(recorder.sourceMdid)) { throw NCCException.Bah("当前用户未绑定门店,无法搜索会员"); } var crossStore = input.crossStore == 1; var kw = string.IsNullOrWhiteSpace(input.keyword) ? null : input.keyword.Trim(); var data = await _db.Queryable() .Where(x => x.IsEffective == (int)StatusEnum.有效) .WhereIF(!crossStore, x => x.Gsmd == recorder.sourceMdid) .WhereIF(kw != null, x => x.Khmc.Contains(kw) || x.Sjh.Contains(kw) || x.Dah.Contains(kw)) .OrderBy(x => x.Khmc) .Select(x => new LqMemberArrivalSearchMemberItemOutput { memberId = x.Id, memberName = x.Khmc, mobile = x.Sjh, archiveNo = x.Dah, gsmdName = SqlFunc.Subqueryable().Where(u => u.Id == x.Gsmd).Select(u => u.Dm) }) .ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } /// /// 提交到院登记 /// /// /// 登记人、来源组织/门店由服务端从当前登录用户快照写入(来源门店为登记人门店,非会员归属店)。 /// 会员仅需存在且有效,可跨店登记。同一门店+会员+自然日仅允许一条有效记录(F_RecordKey 唯一)。 /// 成交=是时见诊必须=是;见诊=否时成交规范化为待确认。 /// 不更新会员主档、FirstVisitTime、预约、沟通、开单、耗卡、工资及人头自动统计表。 /// /// 示例请求: /// ```json /// { /// "memberId": "会员ID", /// "arrivalType": 1, /// "arrivalTime": "2026-07-20T14:30:00", /// "consultationStatus": 0, /// "dealStatus": 0, /// "remark": "自然到院" /// } /// ``` /// /// 参数说明: /// - memberId: 会员ID /// - arrivalType: 1售前 2售后 /// - arrivalTime: 到院时间 /// - consultationStatus/dealStatus: 0待确认 1是 2否 /// - remark: 备注,可选 /// /// 登记内容 /// 主键、编号、版本号 /// 提交成功 /// 参数或重复登记校验失败 /// 服务器错误 [HttpPost("SubmitArrival")] public async Task SubmitArrivalAsync([FromBody] LqMemberArrivalSubmitInput input) { if (input == null) { throw NCCException.Bah("请求体不能为空"); } if (string.IsNullOrWhiteSpace(input.memberId)) { throw NCCException.Bah("memberId 不能为空"); } ValidateArrivalType(input.arrivalType); ValidateOutcomeStatus(input.consultationStatus, "consultationStatus"); ValidateOutcomeStatus(input.dealStatus, "dealStatus"); var recorder = await GetRecorderSnapshotAsync(); if (string.IsNullOrWhiteSpace(recorder.sourceMdid)) { throw NCCException.Bah("当前用户未绑定门店,无法提交到院登记"); } var member = await ValidateMemberAsync(input.memberId.Trim()); var arrivalTime = input.arrivalTime; if (arrivalTime == default) { throw NCCException.Bah("arrivalTime 不能为空"); } var consultationStatus = input.consultationStatus; var dealStatus = input.dealStatus; NormalizeOutcomeStatuses(ref consultationStatus, ref dealStatus); var recordKey = BuildRecordKey(recorder.sourceMdid, member.Id, arrivalTime); var exists = await _db.Queryable() .Where(x => x.RecordKey == recordKey) .AnyAsync(); if (exists) { throw NCCException.Bah("该会员今日在本门店已有有效到院登记,请勿重复提交"); } var now = DateTime.Now; var entity = new LqMemberArrivalRecordEntity { Id = YitIdHelper.NextId().ToString(), RecordNo = GenerateRecordNo(), RecordKey = recordKey, MemberId = member.Id, MemberName = member.Khmc, MemberMobile = member.Sjh, SourceOrganizeId = recorder.sourceOrganizeId, SourceOrganizeName = recorder.sourceOrganizeName, SourceMdid = recorder.sourceMdid, SourceMdName = recorder.sourceMdName, ArrivalType = input.arrivalType, ArrivalTime = arrivalTime, ConsultationStatus = consultationStatus, ConsultationTime = ResolveOutcomeTime(consultationStatus, now), DealStatus = dealStatus, DealTime = ResolveOutcomeTime(dealStatus, now), RecorderUserId = recorder.recorderUserId, RecorderUserName = recorder.recorderUserName, LastModifyUserId = recorder.recorderUserId, LastModifyUserName = recorder.recorderUserName, Remark = string.IsNullOrWhiteSpace(input.remark) ? null : input.remark.Trim(), IsEffective = EffectiveYes, Version = 1, CreateTime = now, UpdateTime = now }; try { await _db.Insertable(entity).ExecuteCommandAsync(); } catch (Exception ex) when (IsDuplicateKeyException(ex)) { throw NCCException.Bah("该会员今日在本门店已有有效到院登记,请勿重复提交"); } var detailJson = JsonConvert.SerializeObject(new { recordNo = entity.RecordNo, memberId = entity.MemberId, memberName = entity.MemberName, sourceMdid = entity.SourceMdid, arrivalType = entity.ArrivalType, arrivalTime = entity.ArrivalTime, consultationStatus = entity.ConsultationStatus, dealStatus = entity.DealStatus, remark = entity.Remark }); await _businessOperationLogService.WriteAsync( BizLogModule, "提交到院登记", BizType, entity.Id, $"提交到院登记 {entity.RecordNo},会员:{entity.MemberName},类型:{EnumHelper.GetEnumDesc(entity.ArrivalType)}", detailJson); return new LqMemberArrivalSubmitOutput { id = entity.Id, recordNo = entity.RecordNo, version = entity.Version }; } /// /// 手机端本人登记分页列表 /// /// /// 仅返回当前登录人登记的记录,可按到院日期、类型、见诊/成交状态筛选。 /// /// 示例请求: /// ```json /// { /// "arrivalDateStart": "2026-07-01", /// "arrivalDateEnd": "2026-07-31", /// "arrivalType": 1, /// "consultationStatus": 1, /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 查询条件 /// 分页列表 /// 返回分页结果 /// 服务器错误 [HttpGet("MyList")] public async Task MyListAsync([FromQuery] LqMemberArrivalMyListQueryInput input) { input ??= new LqMemberArrivalMyListQueryInput(); var userId = _userManager.UserId; if (string.IsNullOrWhiteSpace(userId)) { throw NCCException.Oh("未登录或登录已失效"); } var endExclusive = input.arrivalDateEnd?.Date.AddDays(1); var data = await BuildListQuery(null) .Where(x => x.RecorderUserId == userId) .WhereIF(input.arrivalDateStart.HasValue, x => x.ArrivalTime >= input.arrivalDateStart.Value) .WhereIF(endExclusive.HasValue, x => x.ArrivalTime < endExclusive.Value) .WhereIF(input.arrivalType.HasValue, x => x.ArrivalType == input.arrivalType.Value) .WhereIF(input.consultationStatus.HasValue, x => x.ConsultationStatus == input.consultationStatus.Value) .WhereIF(input.dealStatus.HasValue, x => x.DealStatus == input.dealStatus.Value) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToPagedListAsync(input.currentPage, input.pageSize); FillListEnumNames(data.list); return PageResult.SqlSugarPageResult(data); } /// /// 获取到院登记详情 /// /// /// 能进入管理端本页即可查看任意登记详情。mobile 返回完整手机号。 /// /// 示例请求: /// ```json /// { "id": "登记主键ID" } /// ``` /// /// 登记主键 /// 详情 /// 返回详情 /// 记录不存在 /// 服务器错误 [HttpGet("GetInfo")] public async Task GetInfoAsync([FromQuery] string id) { var entity = await GetRecordOrThrowAsync(id); return MapInfoOutput(entity); } /// /// 更新见诊/成交状态 /// /// /// 乐观锁更新。允许登记本人或对来源组织具备 Edit 权限者操作。 /// 成交=是时见诊必须=是;见诊改否时成交规范化为待确认;状态时间按变更设置/清空。 /// 可选传入 arrivalTime 修改到院时间:须在 arrivalEditableDays 窗口内(跨月受 arrivalAllowCrossMonthEdit 约束);变更自然日时会重建 RecordKey 并校验唯一。 /// /// 示例请求: /// ```json /// { /// "id": "登记主键ID", /// "consultationStatus": 1, /// "dealStatus": 0, /// "arrivalTime": "2026-07-20T14:30:00", /// "remark": "已见诊", /// "version": 1 /// } /// ``` /// /// 更新参数 /// 新版本号 /// 更新成功 /// 参数或版本冲突 /// 无编辑权限 /// 服务器错误 [HttpPost("UpdateOutcome")] public async Task UpdateOutcomeAsync([FromBody] LqMemberArrivalUpdateOutcomeInput input) { if (input == null || string.IsNullOrWhiteSpace(input.id)) { throw NCCException.Oh("id 不能为空"); } ValidateOutcomeStatus(input.consultationStatus, "consultationStatus"); ValidateOutcomeStatus(input.dealStatus, "dealStatus"); var entity = await GetRecordOrThrowAsync(input.id); if (entity.IsEffective != EffectiveYes) { throw NCCException.Bah("该登记已作废,无法修改"); } await EnsureCanUpdateRecordAsync(entity); var consultationStatus = input.consultationStatus; var dealStatus = input.dealStatus; NormalizeOutcomeStatuses(ref consultationStatus, ref dealStatus); var arrivalTimeChanged = false; var oldArrivalTime = entity.ArrivalTime; var before = new { entity.ArrivalTime, entity.RecordKey, entity.ConsultationStatus, entity.ConsultationTime, entity.DealStatus, entity.DealTime, entity.Remark, entity.Version }; var now = DateTime.Now; ApplyOutcomeChange(entity, consultationStatus, dealStatus, now); if (input.remark != null) { entity.Remark = string.IsNullOrWhiteSpace(input.remark) ? null : input.remark.Trim(); } if (input.arrivalTime.HasValue) { var newArrivalTime = input.arrivalTime.Value; arrivalTimeChanged = newArrivalTime.Date != oldArrivalTime.Date || newArrivalTime != oldArrivalTime; if (arrivalTimeChanged) { if (newArrivalTime == default) { throw NCCException.Bah("arrivalTime 不能为空"); } await MemberArrivalMpConfigHelper.EnsureEditWithinWindowAsync(_db, oldArrivalTime); var newRecordKey = BuildRecordKey(entity.SourceMdid, entity.MemberId, newArrivalTime); if (!string.Equals(newRecordKey, entity.RecordKey, StringComparison.Ordinal)) { var conflict = await _db.Queryable() .Where(x => x.RecordKey == newRecordKey && x.Id != entity.Id && x.IsEffective == EffectiveYes) .AnyAsync(); if (conflict) { throw NCCException.Bah("该会员在所选到院日期已有有效到院登记,无法修改到院时间"); } } entity.ArrivalTime = newArrivalTime; entity.RecordKey = newRecordKey; } } entity.LastModifyUserId = _userManager.UserId; entity.LastModifyUserName = _userManager.RealName ?? _userManager.Account; entity.UpdateTime = now; var newVersion = entity.Version + 1; entity.Version = newVersion; var rows = await _db.Updateable(entity) .UpdateColumns(x => new { x.ArrivalTime, x.RecordKey, x.ConsultationStatus, x.ConsultationTime, x.DealStatus, x.DealTime, x.Remark, x.LastModifyUserId, x.LastModifyUserName, x.UpdateTime, x.Version }) .Where(x => x.Id == entity.Id && x.Version == input.version) .ExecuteCommandAsync(); if (rows <= 0) { throw NCCException.Bah("数据已被他人修改,请刷新后重试"); } var detailJson = JsonConvert.SerializeObject(new { before, after = new { entity.ArrivalTime, entity.RecordKey, entity.ConsultationStatus, entity.ConsultationTime, entity.DealStatus, entity.DealTime, entity.Remark, entity.Version } }); var consultationDesc = EnumHelper.GetEnumDesc(entity.ConsultationStatus); var dealDesc = EnumHelper.GetEnumDesc(entity.DealStatus); var actionCode = arrivalTimeChanged ? "修改到院时间" : "更新见诊成交"; var summary = arrivalTimeChanged ? $"修改到院时间 {entity.RecordNo},{oldArrivalTime:yyyy-MM-dd HH:mm:ss} → {entity.ArrivalTime:yyyy-MM-dd HH:mm:ss},见诊:{consultationDesc},成交:{dealDesc}" : $"更新见诊成交 {entity.RecordNo},见诊:{consultationDesc},成交:{dealDesc}"; await _businessOperationLogService.WriteAsync( BizLogModule, actionCode, BizType, entity.Id, summary, detailJson); return new { message = "更新成功", version = newVersion }; } /// /// 大项目部到院转换统计-大项目部与老师筛选选项 /// /// /// 大项目部下拉为「大项目一部」「大项目二部」;列表/统计筛选按到院当月来源门店在 lq_md_target 的 F_MajorProjectDepartment 归属,非登记人组织。 /// 老师下拉取「事业部」及下级在职用户(登记人实际在事业部)。 /// /// 示例请求:无参数 /// /// 大项目部与老师选项 /// 返回筛选选项 /// 服务器错误 [HttpGet("GetFilterOptions")] public async Task GetFilterOptionsAsync() { var output = new LqMemberArrivalFilterOptionsOutput(); var allOrgs = await _db.Queryable() .Where(x => x.DeleteMark == null) .ToListAsync(); var majorParent = allOrgs.FirstOrDefault(x => x.FullName == MajorProjectOrgName); if (majorParent != null) { output.parentOrganizeId = majorParent.Id; output.parentOrganizeName = majorParent.FullName; output.departments = allOrgs .Where(x => MajorProjectDeptNames.Contains(x.FullName)) .OrderBy(x => x.FullName) .Select(x => new LqMemberArrivalFilterDeptOutput { id = x.Id, fullName = x.FullName }) .ToList(); } var businessParent = allOrgs.FirstOrDefault(x => x.FullName == BusinessUnitOrgName); if (businessParent == null) { return output; } var orgIds = allOrgs .TreeChildNode(businessParent.Id, t => t.Id, t => t.ParentId) .Select(x => x.Id) .Distinct() .ToList(); if (orgIds.Count == 0) { orgIds.Add(businessParent.Id); } var orgNameMap = allOrgs .Where(x => orgIds.Contains(x.Id)) .ToDictionary(x => x.Id, x => x.FullName); var users = await _db.Queryable() .Where(x => x.DeleteMark == null) .Where(x => x.EnabledMark == null || x.EnabledMark == 1) .Where(x => orgIds.Contains(x.OrganizeId)) .OrderBy(x => x.OrganizeId) .OrderBy(x => x.RealName) .Select(x => new { x.Id, x.RealName, x.OrganizeId, x.Gw }) .ToListAsync(); output.teachers = users.Select(x => new LqMemberArrivalFilterTeacherOutput { id = x.Id, realName = x.RealName, organizeId = x.OrganizeId, organizeName = !string.IsNullOrWhiteSpace(x.OrganizeId) && orgNameMap.ContainsKey(x.OrganizeId) ? orgNameMap[x.OrganizeId] : BusinessUnitOrgName, gw = x.Gw }).ToList(); return output; } /// /// 后台分页查询到院登记列表 /// /// /// 管理端列表。能进入本页即可查看全部到院登记。 /// 大项目部筛选按到院记录来源门店在到院当月 lq_md_target.F_MajorProjectDepartment 归属,非登记人组织;禁止使用已弃用 lq_mdxx.dxmb。 /// startTime/endTime 必填且须同一自然月,否则拒绝跨月查询。 /// memberMobile 返回完整手机号。 /// /// 示例请求: /// ```json /// { /// "startTime": "2026-07-01", /// "endTime": "2026-07-31", /// "sourceOrganizeId": "大项目部或一部/二部组织ID", /// "sourceMdid": "门店ID", /// "recorderUserId": "登记人ID", /// "memberKeyword": "张三", /// "arrivalType": 1, /// "consultationStatus": 1, /// "dealStatus": 0, /// "isEffective": 1, /// "currentPage": 1, /// "pageSize": 20 /// } /// ``` /// /// 参数说明: /// - startTime/endTime: 到院时间范围,必填且须同一自然月 /// - sourceOrganizeId: 大项目部/大项目一部/大项目二部组织ID,空或父级则含一部+二部 /// /// 查询条件 /// 标准分页列表 /// 返回分页结果 /// 到院时间跨月或未填等校验失败 /// 服务器错误 [HttpGet("GetList")] public async Task GetListAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); var (month, storeIds) = await PrepareAdminListStoreFilterAsync(input); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var data = await ApplyAdminListFilters(BuildListQuery(storeIds), input, endExclusive, memberKw) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToPagedListAsync(input.currentPage, input.pageSize); FillListEnumNames(data.list); await FillMajorProjectDepartmentNamesAsync(data.list, month); return PageResult.SqlSugarPageResult(data); } /// /// 到院转化统计 /// /// /// 筛选条件与 GetList 一致(含能进页即可看全部数据)。统计仅含有效记录(作废不进统计)。 /// 大项目部按到院当月来源门店 lq_md_target 归属筛选;startTime/endTime 必填且须同一自然月。 /// 人头按会员ID去重;同会员周期内多记录以最后一次到院记录决定售前/售后及见诊/成交分类。 /// 人次按有效登记记录数统计(不去重):到院人次 / 见诊人次 / 成交人次。 /// 所有统计按到院时间过滤;售前+售后=合计。 /// /// 示例请求:与 GetList 相同(无需分页参数) /// /// 查询条件(与 GetList 一致) /// arrival/consultation/deal 人头桶与 arrivalVisit/consultationVisit/dealVisit 人次桶及转化率 /// 返回统计数据 /// 到院时间跨月或未填等校验失败 /// 服务器错误 [HttpGet("GetStatistics")] public async Task GetStatisticsAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); var (_, storeIds) = await PrepareAdminListStoreFilterAsync(input); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var records = await ApplyAdminListFilters(BuildListQuery(storeIds), input, endExclusive, memberKw) .Where(x => x.IsEffective == EffectiveYes) .Select(x => new { x.MemberId, x.ArrivalType, x.ArrivalTime, x.ConsultationStatus, x.DealStatus, x.CreateTime }) .ToListAsync(); return BuildStatistics(records.Select(r => ( r.MemberId, r.ArrivalType, r.ArrivalTime, r.ConsultationStatus, r.DealStatus, r.CreateTime)).ToList(), records.Count); } /// /// 作废到院登记 /// /// /// 管理员或对来源组织具备 Edit 权限者可作废(不依赖小程序开关)。 /// 登记本人可在 arrivalVoidableDays 窗口内于小程序作废(跨月受 arrivalAllowCrossMonthVoid 约束)。 /// 软作废、RecordKey 置空、版本+1,不进统计。 /// /// 示例请求: /// ```json /// { /// "id": "登记主键ID", /// "reason": "重复登记", /// "version": 1 /// } /// ``` /// /// 作废参数 /// 操作结果 /// 作废成功 /// 参数或版本冲突 /// 无编辑权限 /// 服务器错误 [HttpPost("Void")] public async Task VoidAsync([FromBody] LqMemberArrivalVoidInput input) { if (input == null || string.IsNullOrWhiteSpace(input.id)) { throw NCCException.Oh("id 不能为空"); } if (string.IsNullOrWhiteSpace(input.reason)) { throw NCCException.Bah("作废原因不能为空"); } var entity = await GetRecordOrThrowAsync(input.id); if (entity.IsEffective != EffectiveYes) { return new { message = "该登记已作废", idempotent = true }; } var canOrg = await CanEditOrganizeAsync(entity.SourceOrganizeId); var isSelf = string.Equals(entity.RecorderUserId, _userManager.UserId, StringComparison.OrdinalIgnoreCase); if (!canOrg && !isSelf) { throw NCCException.Oh(ErrorCode.D1013).StatusCode(StatusCodes.Status403Forbidden); } if (!canOrg && isSelf) { await MemberArrivalMpConfigHelper.EnsureVoidWithinWindowAsync(_db, entity.ArrivalTime); } var before = new { entity.IsEffective, entity.RecordKey, entity.Version, entity.VoidReason }; var now = DateTime.Now; var newVersion = entity.Version + 1; entity.IsEffective = EffectiveNo; entity.RecordKey = null; entity.VoidReason = input.reason.Trim(); entity.VoidUserId = _userManager.UserId; entity.VoidUserName = _userManager.RealName ?? _userManager.Account; entity.VoidTime = now; entity.UpdateTime = now; entity.Version = newVersion; var rows = await _db.Updateable(entity) .UpdateColumns(x => new { x.IsEffective, x.RecordKey, x.VoidReason, x.VoidUserId, x.VoidUserName, x.VoidTime, x.UpdateTime, x.Version }) .Where(x => x.Id == entity.Id && x.Version == input.version) .ExecuteCommandAsync(); if (rows <= 0) { throw NCCException.Bah("数据已被他人修改,请刷新后重试"); } var detailJson = JsonConvert.SerializeObject(new { before, after = new { entity.IsEffective, entity.RecordKey, entity.Version, entity.VoidReason, entity.VoidTime }, remark = entity.VoidReason }); await _businessOperationLogService.WriteAsync( BizLogModule, "作废到院登记", BizType, entity.Id, $"作废到院登记 {entity.RecordNo},原因:{entity.VoidReason}", detailJson); return new { message = "作废成功", version = newVersion }; } /// /// 导出到院登记列表 /// /// /// 筛选条件与 GetList 完全一致(大项目部按门店当月归属、到院时间禁止跨月);导出成功后写入业务操作日志(不含手机号)。 /// /// 示例请求:与 GetList 相同,另加 dataType(0当前页/1全部)、selectKey(导出列) /// /// 查询与导出参数 /// Excel 下载信息 /// 返回下载链接 /// 到院时间跨月或未填等校验失败 /// 服务器错误 [HttpGet("Actions/Export")] public async Task ExportAsync([FromQuery] LqMemberArrivalListQueryInput input) { input ??= new LqMemberArrivalListQueryInput(); List exportData; if (input.dataType == 0) { var page = Clay.Object(await GetListAsync(input)); exportData = page.Solidify>().list; } else { exportData = await GetNoPagingListAsync(input); } var paramList = "[{\"value\":\"登记编号\",\"field\":\"recordNo\"},{\"value\":\"会员姓名\",\"field\":\"memberName\"},{\"value\":\"手机号\",\"field\":\"memberMobile\"},{\"value\":\"大项目部\",\"field\":\"majorProjectDepartmentName\"},{\"value\":\"来源门店\",\"field\":\"sourceMdName\"},{\"value\":\"到院类型\",\"field\":\"arrivalTypeName\"},{\"value\":\"到院时间\",\"field\":\"arrivalTime\"},{\"value\":\"见诊状态\",\"field\":\"consultationStatusName\"},{\"value\":\"见诊时间\",\"field\":\"consultationTime\"},{\"value\":\"成交状态\",\"field\":\"dealStatusName\"},{\"value\":\"成交时间\",\"field\":\"dealTime\"},{\"value\":\"老师\",\"field\":\"recorderUserName\"},{\"value\":\"备注\",\"field\":\"remark\"},{\"value\":\"是否有效\",\"field\":\"isEffective\"}]" .ToList(); var excelconfig = new ExcelConfig { FileName = "大项目部到院转换统计.xls", HeadFont = "微软雅黑", HeadPoint = 10, IsAllSizeColumn = true, ColumnModel = new List() }; var selectKeyList = string.IsNullOrWhiteSpace(input.selectKey) ? paramList.Select(p => p.field).ToList() : input.selectKey.Split(',').ToList(); foreach (var item in selectKeyList) { var isExist = paramList.Find(p => p.field == item); if (isExist != null) { excelconfig.ColumnModel.Add(new ExcelColumnModel { Column = isExist.field, ExcelColumn = isExist.value }); } } var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName; ExcelExportHelper.Export(exportData, excelconfig, addPath); // Download 约定:userId|文件名|temporary(与拓客等导出一致) var fileName = _userManager.UserId + "|" + excelconfig.FileName + "|temporary"; var startTimeStr = input.startTime?.ToString("yyyy-MM-dd") ?? ""; var endTimeStr = input.endTime?.ToString("yyyy-MM-dd") ?? ""; var detailJson = JsonConvert.SerializeObject(new { filters = new { startTime = input.startTime, endTime = input.endTime, sourceOrganizeId = input.sourceOrganizeId, sourceMdid = input.sourceMdid, recorderUserId = input.recorderUserId, memberKeyword = input.memberKeyword, arrivalType = input.arrivalType, consultationStatus = input.consultationStatus, dealStatus = input.dealStatus, isEffective = input.isEffective }, rowCount = exportData.Count, fileName = excelconfig.FileName }); await _businessOperationLogService.WriteAsync( BizLogModule, "导出到院登记", BizType, null, $"导出到院登记 {startTimeStr} 至 {endTimeStr},共 {exportData.Count} 条", detailJson); return new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; } #region 私有方法 private async Task> GetNoPagingListAsync(LqMemberArrivalListQueryInput input) { var (month, storeIds) = await PrepareAdminListStoreFilterAsync(input); var endExclusive = input.endTime?.Date.AddDays(1); var memberKw = string.IsNullOrWhiteSpace(input.memberKeyword) ? null : input.memberKeyword.Trim(); var list = await ApplyAdminListFilters(BuildListQuery(storeIds), input, endExclusive, memberKw) .OrderBy(x => x.ArrivalTime, OrderByType.Desc) .Select(x => new LqMemberArrivalListOutput { id = x.Id, recordNo = x.RecordNo, memberId = x.MemberId, memberName = x.MemberName, memberMobile = x.MemberMobile, sourceOrganizeId = x.SourceOrganizeId, sourceOrganizeName = x.SourceOrganizeName, sourceMdid = x.SourceMdid, sourceMdName = x.SourceMdName, arrivalType = x.ArrivalType, arrivalTime = x.ArrivalTime, consultationStatus = x.ConsultationStatus, consultationTime = x.ConsultationTime, dealStatus = x.DealStatus, dealTime = x.DealTime, recorderUserId = x.RecorderUserId, recorderUserName = x.RecorderUserName, lastModifyUserId = x.LastModifyUserId, lastModifyUserName = x.LastModifyUserName, remark = x.Remark, isEffective = x.IsEffective, voidReason = x.VoidReason, voidUserId = x.VoidUserId, voidUserName = x.VoidUserName, voidTime = x.VoidTime, version = x.Version, createTime = x.CreateTime, updateTime = x.UpdateTime }) .ToListAsync(); FillListEnumNames(list); await FillMajorProjectDepartmentNamesAsync(list, month); return list; } /// /// 手机端列表传 null 表示不按门店过滤;管理端传门店ID列表,空列表则返回空结果。 /// private ISugarQueryable BuildListQuery(List storeIds) { if (storeIds == null) { return _db.Queryable(); } if (storeIds.Count == 0) { return _db.Queryable().Where(x => false); } return _db.Queryable() .Where(x => storeIds.Contains(x.SourceMdid)); } private static ISugarQueryable ApplyAdminListFilters( ISugarQueryable query, LqMemberArrivalListQueryInput input, DateTime? endExclusive, string memberKw) { return query .WhereIF(input.startTime.HasValue, x => x.ArrivalTime >= input.startTime.Value) .WhereIF(endExclusive.HasValue, x => x.ArrivalTime < endExclusive.Value) .WhereIF(!string.IsNullOrWhiteSpace(input.sourceMdid), x => x.SourceMdid == input.sourceMdid.Trim()) .WhereIF(!string.IsNullOrWhiteSpace(input.recorderUserId), x => x.RecorderUserId == input.recorderUserId.Trim()) .WhereIF(memberKw != null, x => x.MemberName.Contains(memberKw) || x.MemberMobile.Contains(memberKw) || x.RecordNo.Contains(memberKw) || SqlFunc.Subqueryable() .Where(k => k.Id == x.MemberId && k.Dah.Contains(memberKw)) .Any()) .WhereIF(input.arrivalType.HasValue, x => x.ArrivalType == input.arrivalType.Value) .WhereIF(input.consultationStatus.HasValue, x => x.ConsultationStatus == input.consultationStatus.Value) .WhereIF(input.dealStatus.HasValue, x => x.DealStatus == input.dealStatus.Value) .WhereIF(input.isEffective.HasValue, x => x.IsEffective == input.isEffective.Value); } private static LqMemberArrivalStatisticsOutput BuildStatistics( List<(string MemberId, int ArrivalType, DateTime ArrivalTime, int ConsultationStatus, int DealStatus, DateTime? CreateTime)> records, int recordCount) { var yes = (int)MemberArrivalOutcomeStatusEnum.是; var preSalesType = (int)MemberArrivalTypeEnum.售前; var afterSalesType = (int)MemberArrivalTypeEnum.售后; var lastByMember = records .GroupBy(x => x.MemberId) .Select(g => g .OrderByDescending(x => x.ArrivalTime) .ThenByDescending(x => x.CreateTime ?? DateTime.MinValue) .First()) .ToList(); var arrivalBucket = new LqMemberArrivalStatBucketOutput { total = lastByMember.Count, preSales = lastByMember.Count(x => x.ArrivalType == preSalesType), afterSales = lastByMember.Count(x => x.ArrivalType == afterSalesType) }; var consultationMembers = lastByMember.Where(x => x.ConsultationStatus == yes).ToList(); var dealMembers = lastByMember.Where(x => x.DealStatus == yes).ToList(); var consultationBucket = new LqMemberArrivalStatBucketOutput { total = consultationMembers.Count, preSales = consultationMembers.Count(x => x.ArrivalType == preSalesType), afterSales = consultationMembers.Count(x => x.ArrivalType == afterSalesType) }; var dealBucket = new LqMemberArrivalStatBucketOutput { total = dealMembers.Count, preSales = dealMembers.Count(x => x.ArrivalType == preSalesType), afterSales = dealMembers.Count(x => x.ArrivalType == afterSalesType) }; var consultationVisitRecords = records.Where(x => x.ConsultationStatus == yes).ToList(); var dealVisitRecords = records.Where(x => x.DealStatus == yes).ToList(); var arrivalVisitBucket = new LqMemberArrivalStatBucketOutput { total = records.Count, preSales = records.Count(x => x.ArrivalType == preSalesType), afterSales = records.Count(x => x.ArrivalType == afterSalesType) }; var consultationVisitBucket = new LqMemberArrivalStatBucketOutput { total = consultationVisitRecords.Count, preSales = consultationVisitRecords.Count(x => x.ArrivalType == preSalesType), afterSales = consultationVisitRecords.Count(x => x.ArrivalType == afterSalesType) }; var dealVisitBucket = new LqMemberArrivalStatBucketOutput { total = dealVisitRecords.Count, preSales = dealVisitRecords.Count(x => x.ArrivalType == preSalesType), afterSales = dealVisitRecords.Count(x => x.ArrivalType == afterSalesType) }; return new LqMemberArrivalStatisticsOutput { arrival = arrivalBucket, consultation = consultationBucket, deal = dealBucket, arrivalVisit = arrivalVisitBucket, consultationVisit = consultationVisitBucket, dealVisit = dealVisitBucket, arrivalToConsultationRate = SafeRate(consultationBucket.total, arrivalBucket.total), consultationToDealRate = SafeRate(dealBucket.total, consultationBucket.total), arrivalToDealRate = SafeRate(dealBucket.total, arrivalBucket.total), recordCount = recordCount }; } private static decimal? SafeRate(int numerator, int denominator) { if (denominator <= 0) { return null; } return Math.Round((decimal)numerator / denominator, 4, MidpointRounding.AwayFromZero); } private async Task<(string recorderUserId, string recorderUserName, string sourceOrganizeId, string sourceOrganizeName, string sourceMdid, string sourceMdName)> GetRecorderSnapshotAsync() { var userId = _userManager.UserId; if (string.IsNullOrWhiteSpace(userId)) { throw NCCException.Oh("未登录或登录已失效"); } var user = _userManager.User ?? await _db.Queryable() .Where(x => x.Id == userId && x.DeleteMark == null) .FirstAsync(); if (user == null) { throw NCCException.Oh("当前用户不存在或已删除"); } var organizeName = string.Empty; if (!string.IsNullOrWhiteSpace(user.OrganizeId)) { organizeName = await _db.Queryable() .Where(x => x.Id == user.OrganizeId && x.DeleteMark == null) .Select(x => x.FullName) .FirstAsync() ?? string.Empty; } var mdName = string.Empty; if (!string.IsNullOrWhiteSpace(user.Mdid)) { mdName = await _db.Queryable() .Where(x => x.Id == user.Mdid) .Select(x => x.Dm) .FirstAsync() ?? string.Empty; } return ( userId, user.RealName ?? user.Account ?? userId, user.OrganizeId?.Trim(), organizeName, user.Mdid?.Trim(), mdName); } private async Task ValidateMemberAsync(string memberId) { var member = await _db.Queryable() .Where(x => x.Id == memberId && x.IsEffective == (int)StatusEnum.有效) .FirstAsync(); if (member == null) { throw NCCException.Bah("会员不存在或已失效"); } return member; } private async Task GetRecordOrThrowAsync(string id) { if (string.IsNullOrWhiteSpace(id)) { throw NCCException.Oh("id 不能为空"); } var entity = await _db.Queryable() .Where(x => x.Id == id.Trim()) .FirstAsync(); if (entity == null) { throw NCCException.Oh("到院登记不存在"); } return entity; } private async Task EnsureCanUpdateRecordAsync(LqMemberArrivalRecordEntity entity) { if (string.Equals(entity.RecorderUserId, _userManager.UserId, StringComparison.OrdinalIgnoreCase)) { return; } await EnsureCanEditOrganizeAsync(entity.SourceOrganizeId); } private async Task CanEditOrganizeAsync(string organizeId) { var userInfo = await _userManager.GetUserInfo(); return userInfo.isAdministrator || (userInfo.dataScope?.Any(x => x.organizeId == organizeId && x.Edit) ?? false); } private async Task EnsureCanEditOrganizeAsync(string organizeId) { if (!await CanEditOrganizeAsync(organizeId)) { // D1013 是项目统一的“无权限”业务码;显式设置 403,避免默认异常状态被包装成 500。 throw NCCException.Oh(ErrorCode.D1013).StatusCode(StatusCodes.Status403Forbidden); } } /// /// 管理端列表/统计/导出:校验到院时间并解析当月大项目部归属门店。 /// private async Task<(string month, List storeIds)> PrepareAdminListStoreFilterAsync(LqMemberArrivalListQueryInput input) { ValidateAdminListTimeRange(input); return await ResolveAdminListStoreFilterAsync(input.sourceOrganizeId, input.startTime.Value); } private static void ValidateAdminListTimeRange(LqMemberArrivalListQueryInput input) { if (!input.startTime.HasValue || !input.endTime.HasValue) { throw NCCException.Bah("到院开始时间和结束时间不能为空"); } var start = input.startTime.Value; var end = input.endTime.Value; if (start.Year != end.Year || start.Month != end.Month) { throw NCCException.Bah("到院时间不能跨月,请选择同一自然月"); } } /// /// 按到院当月 lq_md_target.F_MajorProjectDepartment 解析来源门店ID列表。 /// private async Task<(string month, List storeIds)> ResolveAdminListStoreFilterAsync( string sourceOrganizeId, DateTime startTime) { var month = startTime.ToString("yyyyMM"); var allOrgs = await _db.Queryable() .Where(x => x.DeleteMark == null) .ToListAsync(); var majorParent = allOrgs.FirstOrDefault(x => x.FullName == MajorProjectOrgName); var deptOne = allOrgs.FirstOrDefault(x => x.FullName == "大项目一部"); var deptTwo = allOrgs.FirstOrDefault(x => x.FullName == "大项目二部"); var sel = string.IsNullOrWhiteSpace(sourceOrganizeId) ? null : sourceOrganizeId.Trim(); List targetDepts; if (string.IsNullOrWhiteSpace(sel) || (majorParent != null && sel == majorParent.Id)) { targetDepts = new List(); if (deptOne != null) { targetDepts.Add(deptOne); } if (deptTwo != null) { targetDepts.Add(deptTwo); } } else if (deptOne != null && sel == deptOne.Id) { targetDepts = new List { deptOne }; } else if (deptTwo != null && sel == deptTwo.Id) { targetDepts = new List { deptTwo }; } else { var org = allOrgs.FirstOrDefault(x => x.Id == sel); if (org == null) { throw NCCException.Bah("无法识别所选大项目部,请重新选择"); } if (org.FullName == MajorProjectOrgName) { targetDepts = new List(); if (deptOne != null) { targetDepts.Add(deptOne); } if (deptTwo != null) { targetDepts.Add(deptTwo); } } else if (MajorProjectDeptNames.Contains(org.FullName)) { targetDepts = new List { org }; } else { throw NCCException.Bah("无法识别所选大项目部,请重新选择"); } } if (targetDepts.Count == 0) { return (month, new List()); } var matchValues = new HashSet(StringComparer.OrdinalIgnoreCase); foreach (var dept in targetDepts) { matchValues.Add(dept.Id); if (!string.IsNullOrWhiteSpace(dept.FullName)) { matchValues.Add(dept.FullName); } } var storeIds = await _db.Queryable() .Where(x => x.Month == month) .Where(x => matchValues.Contains(x.MajorProjectDepartment)) .Select(x => x.StoreId) .Distinct() .ToListAsync(); return (month, storeIds ?? new List()); } private async Task FillMajorProjectDepartmentNamesAsync(IEnumerable list, string month) { if (list == null || string.IsNullOrWhiteSpace(month)) { return; } var rows = list as IList ?? list.ToList(); if (rows.Count == 0) { return; } var storeIds = rows .Select(x => x.sourceMdid) .Where(x => !string.IsNullOrWhiteSpace(x)) .Distinct() .ToList(); if (storeIds.Count == 0) { return; } var targets = await _db.Queryable() .Where(x => x.Month == month && storeIds.Contains(x.StoreId)) .Select(x => new { x.StoreId, x.MajorProjectDepartment }) .ToListAsync(); if (targets.Count == 0) { foreach (var row in rows) { row.majorProjectDepartmentName = "无"; } return; } var deptValues = targets .Select(x => x.MajorProjectDepartment) .Where(x => !string.IsNullOrWhiteSpace(x)) .Distinct() .ToList(); var orgNameMap = await _db.Queryable() .Where(x => x.DeleteMark == null && deptValues.Contains(x.Id)) .Select(x => new { x.Id, x.FullName }) .ToListAsync(); var idToName = orgNameMap.ToDictionary(x => x.Id, x => x.FullName, StringComparer.OrdinalIgnoreCase); var storeToDeptName = targets.ToDictionary( x => x.StoreId, x => ResolveMajorProjectDepartmentDisplayName(x.MajorProjectDepartment, idToName), StringComparer.OrdinalIgnoreCase); foreach (var row in rows) { if (!string.IsNullOrWhiteSpace(row.sourceMdid) && storeToDeptName.TryGetValue(row.sourceMdid, out var deptName)) { row.majorProjectDepartmentName = deptName; } else { row.majorProjectDepartmentName = "无"; } } } private static string ResolveMajorProjectDepartmentDisplayName( string majorProjectDepartment, Dictionary idToName) { if (string.IsNullOrWhiteSpace(majorProjectDepartment)) { return "无"; } if (idToName.TryGetValue(majorProjectDepartment, out var name)) { return name; } return majorProjectDepartment; } private static void FillListEnumNames(IEnumerable list) { foreach (var row in list) { row.arrivalTypeName = EnumHelper.GetEnumDesc(row.arrivalType); row.consultationStatusName = EnumHelper.GetEnumDesc(row.consultationStatus); row.dealStatusName = EnumHelper.GetEnumDesc(row.dealStatus); } } private static LqMemberArrivalInfoOutput MapInfoOutput(LqMemberArrivalRecordEntity entity) { return new LqMemberArrivalInfoOutput { id = entity.Id, recordNo = entity.RecordNo, memberId = entity.MemberId, memberName = entity.MemberName, memberMobile = entity.MemberMobile, sourceOrganizeId = entity.SourceOrganizeId, sourceOrganizeName = entity.SourceOrganizeName, sourceMdid = entity.SourceMdid, sourceMdName = entity.SourceMdName, arrivalType = entity.ArrivalType, arrivalTypeName = EnumHelper.GetEnumDesc(entity.ArrivalType), arrivalTime = entity.ArrivalTime, consultationStatus = entity.ConsultationStatus, consultationStatusName = EnumHelper.GetEnumDesc(entity.ConsultationStatus), consultationTime = entity.ConsultationTime, dealStatus = entity.DealStatus, dealStatusName = EnumHelper.GetEnumDesc(entity.DealStatus), dealTime = entity.DealTime, recorderUserId = entity.RecorderUserId, recorderUserName = entity.RecorderUserName, lastModifyUserId = entity.LastModifyUserId, lastModifyUserName = entity.LastModifyUserName, remark = entity.Remark, isEffective = entity.IsEffective, voidReason = entity.VoidReason, voidUserName = entity.VoidUserName, voidTime = entity.VoidTime, version = entity.Version, createTime = entity.CreateTime, updateTime = entity.UpdateTime }; } private static void ValidateArrivalType(int arrivalType) { if (!Enum.IsDefined(typeof(MemberArrivalTypeEnum), arrivalType)) { throw NCCException.Bah("arrivalType 无效,仅支持 1售前 2售后"); } } private static void ValidateOutcomeStatus(int status, string fieldName) { if (!Enum.IsDefined(typeof(MemberArrivalOutcomeStatusEnum), status)) { throw NCCException.Bah($"{fieldName} 无效,仅支持 0待确认 1是 2否"); } } private static void NormalizeOutcomeStatuses(ref int consultationStatus, ref int dealStatus) { var yes = (int)MemberArrivalOutcomeStatusEnum.是; var no = (int)MemberArrivalOutcomeStatusEnum.否; var pending = (int)MemberArrivalOutcomeStatusEnum.待确认; // “见诊=否”是更明确的人工结论,优先于“成交=是”,必须保留见诊否并将成交回待确认。 if (consultationStatus == no) { if (dealStatus == yes) { dealStatus = pending; } } else if (dealStatus == yes) { consultationStatus = yes; } } private static DateTime? ResolveOutcomeTime(int status, DateTime now) { if (status == (int)MemberArrivalOutcomeStatusEnum.待确认) { return null; } return now; } private static void ApplyOutcomeChange(LqMemberArrivalRecordEntity entity, int consultationStatus, int dealStatus, DateTime now) { if (entity.ConsultationStatus != consultationStatus) { entity.ConsultationStatus = consultationStatus; entity.ConsultationTime = ResolveOutcomeTime(consultationStatus, now); } if (entity.DealStatus != dealStatus) { entity.DealStatus = dealStatus; entity.DealTime = ResolveOutcomeTime(dealStatus, now); } } private static string BuildRecordKey(string sourceMdid, string memberId, DateTime arrivalTime) { return $"{sourceMdid}_{memberId}_{arrivalTime:yyyyMMdd}"; } private static string GenerateRecordNo() { var rnd = new Random(Guid.NewGuid().GetHashCode()).Next(1000, 9999); return "MA" + DateTime.Now.ToString("yyyyMMddHHmmss") + rnd; } private static bool IsDuplicateKeyException(Exception ex) { var msg = ex.Message ?? string.Empty; return msg.Contains("Duplicate", StringComparison.OrdinalIgnoreCase) || msg.Contains("duplicate", StringComparison.OrdinalIgnoreCase) || msg.Contains("1062"); } #endregion } }