/// <summary> /// 根据银行美容记录查询服务码详情 /// </summary> /// <param name="records"></param> /// <returns></returns> public static async Task <IEnumerable <ServiceCodeDetail> > SearchBankMRActivityCodeDetailByRecords(IEnumerable <BankMRActivityCodeRecord> records) { var result = new List <ServiceCodeDetail>(); if (records != null) { records = records.Where(s => !string.IsNullOrEmpty(s.ServiceCode)); var roundIds = records.Select(t => t.ActivityRoundId).Distinct(); var rounds = new List <BankMRActivityRoundConfig>(); foreach (var item in roundIds) { var round = GetBankMRActivityRoundConfigByPKID(item); if (round != null) { rounds.Add(round); } } var activityIds = rounds.Select(t => t.ActivityId).Distinct(); var activitys = new List <BankMRActivityConfig>(); foreach (var item in activityIds) { var activity = TuhuGrouponDbScopeManagerReadOnly.Execute(conn => BankMRActivityDal.SelectBankMRActivityConfigByActivityId(conn, item)); activitys.Add(activity); } var serviceCodes = records.Select(t => t.ServiceCode).Distinct(); var serviceCodeDetails = await SearchCodeManager.GetServiceCodeDetailsByCodes(serviceCodes); var companyUsers = new List <SYS_CompanyUser>(); var bankIds = activitys.Select(t => t.BankId).Distinct(); using (var client = new UserAccountClient()) { foreach (var item in bankIds) { var serviceResult = await client.SelectCompanyUserInfoAsync(item); serviceResult.ThrowIfException(true); var company = serviceResult.Result; if (company != null) { companyUsers.Add(company); } } } var products = new List <BeautyProductModel>(); foreach (var pid in activitys.Select(t => t.ServiceId).Distinct()) { var product = BeautyProductManager.GetBeautyProductByPid(pid); if (product != null) { products.Add(product); } } foreach (var re in records) { var activityId = (rounds.FirstOrDefault(s => s.PKID == re.ActivityRoundId))?.ActivityId; if (activityId != null) { var activity = activitys.FirstOrDefault(s => s.ActivityId == activityId); if (activity != null && serviceCodeDetails != null) { var serviceCodeDetail = serviceCodeDetails.FirstOrDefault(s => string.Equals(s.Code, re.ServiceCode)); var product = products.First(p => string.Equals(p.PID, activity.ServiceId)); if (serviceCodeDetail != null) { result.Add( new ServiceCodeDetail() { //PackageDetailCodeId = packageDetailCode.PKID, ServiceCode = re.ServiceCode, Status = serviceCodeDetail?.Status.ToString(), VipCompanyName = companyUsers.FirstOrDefault(t => t.UserId == activity.BankId)?.UserName, VerifyTime = serviceCodeDetail?.VerifyTime, StartTime = re.CreateTime, EndTime = Convert.ToDateTime(serviceCodeDetail.OverdueTime), VipSettleMentPrice = activity.BankSettlementPrice, ShopCommission = 0, PID = activity.ServiceId, RestrictVehicle = BeautyProductManager.GetVehicleTypeDescription(product.RestrictVehicleType), Mobile = re.Mobile, OrderNo = !string.IsNullOrEmpty(serviceCodeDetail?.TuhuOrderId.ToString()) ? $"TH{serviceCodeDetail?.TuhuOrderId}" : null, VerifyShop = serviceCodeDetail?.InstallShopId.ToString() }); } } } } } return(result); }
/// <summary> /// 根据服务码获取服务码详情信息,没有用户信息 /// </summary> /// <param name="serviceCodes"></param> /// <returns></returns> public static async Task <IEnumerable <ServiceCodeDetail> > GetServiceCodeDetail(IEnumerable <string> serviceCodes) { IEnumerable <ServiceCodeDetail> result = null; if (serviceCodes != null && serviceCodes.Any()) { var packageDetailCodes = GetBeautyServicePackageDetailCodesByCodes(serviceCodes); var serviceCodeDetails = await GetServiceCodeDetailsByCodes(serviceCodes); if (packageDetailCodes != null && serviceCodeDetails != null && serviceCodeDetails.Any()) { var packageDetailIds = packageDetailCodes.Select(t => t.PackageDetailId).Distinct(); var packageDetails = BeautyServicePackageManager.GetBeautyServicePackageDetails(packageDetailIds); if (packageDetails != null) { var pids = packageDetails.Select(t => t.PID).Distinct(); var products = new List <BeautyProductModel>(); foreach (var pid in pids) { var product = BeautyProductManager.GetBeautyProductByPid(pid); if (product != null) { products.Add(product); } } result = serviceCodeDetails.Select(t => { var packageDetailCode = packageDetailCodes.FirstOrDefault(h => string.Equals(h.ServiceCode, t.Code)); if (packageDetailCode != null) { var packageDetailId = packageDetailCode.PackageDetailId; var packageDetail = packageDetails.FirstOrDefault(d => d.PKID == packageDetailId); if (packageDetail != null && products.Any()) { var bankManger = new BankMRManager(); var cooperateUser = bankManger.FetchMrCooperateUserConfigByPKID(packageDetail.CooperateId); var product = products.FirstOrDefault(p => string.Equals(p.PID, packageDetail.PID)); if (product != null) { return(new ServiceCodeDetail() { PackageDetailCodeId = packageDetailCode.PKID, BatchCode = string.IsNullOrEmpty(packageDetailCode.ImportBatchCode) ? packageDetailCode.PackageDetailId.ToString() : packageDetailCode.ImportBatchCode, ServiceCode = t.Code, Status = string.Equals(t.Source, "VOLRevert") ? "Reverted" : t.Status.ToString(), VipCompanyName = cooperateUser?.CooperateName, VerifyTime = t.VerifyTime, StartTime = packageDetailCode.StartTime, EndTime = packageDetailCode.EndTime, VipSettleMentPrice = packageDetail.VipSettlementPrice, ShopCommission = packageDetail.ShopCommission, PID = packageDetail.PID, RestrictVehicle = BeautyProductManager.GetVehicleTypeDescription(product.RestrictVehicleType), OrderNo = t.TuhuOrderId > 0 ? $"TH{t.TuhuOrderId}" : null, VerifyShop = t.InstallShopId?.ToString(), Type = packageDetail.IsImportUser? "ImportUser": "******" }); } else { return(new ServiceCodeDetail()); } } else { return(new ServiceCodeDetail()); } } else { return(new ServiceCodeDetail()); } }).Where(s => !string.IsNullOrWhiteSpace(s.ServiceCode)).ToList(); } } } return(result); }