/// <summary> /// 根据批次号更新服务码起始时间 /// </summary> /// <param name="user"></param> /// <param name="batchCode"></param> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public static async Task <Tuple <bool, string> > UpdateBeautyServiceCodeTimeByBatchCode(string user, string batchCode, DateTime startTime, DateTime endTime) { var result = false; var msg = string.Empty; try { var writeStr = BeautyServicePackageDal.GetTuhuGrouponWriteConnstr(); using (var dbhelper = new SqlDbHelper(writeStr)) { dbhelper.BeginTransaction(); var updateCodeResult = BeautyServicePackageDal.UpdateBeautyServicePackageDetailCodeTimeByBatchCode(dbhelper, batchCode, startTime, endTime); if (!updateCodeResult) { throw new Exception("根据批次号更新服务码时间失败,方法UpdateBeautyServicePackageDetailCodeTimeByBatchCode"); } var serviceCodes = BeautyServicePackageDal.SelectServiceCodesByBatchCode(batchCode); if (serviceCodes != null && serviceCodes.Any()) { if (serviceCodes.Count() > 10000) { throw new Exception("暂时不支持服务码数量大于10000的修改操作"); } using (var client = new ServiceCodeClient()) { var batchSize = 1000; var index = 0; while (index < serviceCodes.Count()) { var batchCodes = serviceCodes.Skip(index).Take(batchSize).ToList(); var kxChangeCodeTimeModel = new ChangeCodeTimeRequest { ServiceCodes = batchCodes, OverdueTime = endTime }; var kxChangeResult = client.ChangeOverdueTime(kxChangeCodeTimeModel); if (!kxChangeResult.Success) { throw kxChangeResult.Exception; } if (kxChangeResult.Result != null && kxChangeResult.Result.FailServiceCode != null && kxChangeResult.Result.FailServiceCode.Any()) { var serviceCodeFailedLog = new BeautyOprLog { LogType = "ChangeOverdueTimeFailedCodes", IdentityID = $"{batchCode}", OldValue = null, NewValue = JsonConvert.SerializeObject(kxChangeResult.Result.FailServiceCode), Remarks = $"根据批次号修改服务码过期时间失败,批次:{batchCode},OverdueTime应该改为:{endTime}", OperateUser = user, }; LoggerManager.InsertLog("BeautyOprLog", serviceCodeFailedLog); } index += batchSize; } dbhelper.Commit(); result = true; } } } } catch (Exception ex) { msg = ex.Message; Logger.Error(ex.Message, ex); } return(new Tuple <bool, string>(result, msg)); }
public async Task <ResultModel <string> > RevertServiceCode(string batchCode, string channel, string source, string user) { var result = new ResultModel <string> { IsSuccess = false }; try { var kuaiXiuService = new KuaiXiuService.KuaiXiuService(); if (!string.IsNullOrEmpty(batchCode)) { var serviceCodes = BeautyServicePackageDal.SelectServiceCodesByBatchCode(batchCode); if (serviceCodes != null && serviceCodes.Any()) { var beautyCodeManager = new BeautyCodeManager(); var taskDetail = beautyCodeManager.GetBeautyCodeStatistics(new List <string>() { batchCode }); var codeTask = taskDetail.FirstOrDefault(); var buyOutOrderId = codeTask?.BuyoutOrderId; var serviceCodeDetails = new List <ServiceCode>(); for (var index = 0; index < (serviceCodes.Count() + 127) / 128; index++) { var codeItems = serviceCodes.Skip(index * 128).Take(128); var item = await SearchCodeManager.GetServiceCodeDetailsByCodes(codeItems); serviceCodeDetails.AddRange(item); } var avaiableServiceCodes = serviceCodeDetails.Where(s => (s.Status == ServiceCodeStatusType.Created || s.Status == ServiceCodeStatusType.SmsSent) && !string.Equals(s.Source, "VOLRevert")).Select(t => t.Code); var avaiableCount = avaiableServiceCodes.Count(); if (buyOutOrderId > 0 && avaiableCount < serviceCodeDetails.Count())//如果是买断,并且有部分核销,则不能作废服务码 { result.IsSuccess = false; result.Msg += "当前批次服务码中已经有部分核销,不能作废当前批次"; } else { for (var index = 0; index < (avaiableCount + 127) / 128; index++) { var codeItems = avaiableServiceCodes.Skip(index * 128).Take(128); var revertResult = await kuaiXiuService.RevertServiceCodes(codeItems, channel, source); if (!revertResult) { throw new Exception($"作废失败,部分服务码已使用或已作废"); } } beautyCodeManager.UpdateBeautyCodeTaskStatus(batchCode, "Reverted"); if (buyOutOrderId > 0) { result.IsSuccess = false; result.Msg += "未核销服务码作废完成,订单作废请联系业务系统研发手动处理"; //var serviceCodeConfig = BeautyServicePackageManager.GetBeautyServicePackageDetail(codeTask.MappingId); //var cooperateUser = new BankMRManager().FetchMrCooperateUserConfigByPKID(serviceCodeConfig?.CooperateId ?? -1); //if (cooperateUser != null) //{ // var revertOrderResult = await OrderServiceProxy.OrderServiceProxy.CancelOrder(new Service.Order.Request.CancelOrderRequest() // { // OrderId = Convert.ToInt32(buyOutOrderId), // UserID = cooperateUser.VipUserId, // Remark = $"运营回滚服务码,服务码批次号:{batchCode}", // FirstMenu = "运营", // SecondMenu = "服务码取消" // }); // if (!revertOrderResult.IsSuccess) // { // throw new Exception($"服务码作废成功,2B订单:{buyOutOrderId},取消订单失败,请联系业务系统研发手动作废"); // } //} //else //{ // throw new Exception($"查不到合作用户,MappingId:{codeTask.MappingId}"); //} } else { result.IsSuccess = true; result.Msg = "未核销服务码作废完成"; } if (avaiableCount > 0) { var log = new DataAccess.Entity.BeautyOprLog { LogType = "RevertServiceCode", IdentityID = $"{batchCode}", OldValue = null, NewValue = null, Remarks = $"根据批次号作废服务码", OperateUser = user, }; LoggerManager.InsertLog("BeautyOprLog", log); } } } else { throw new Exception("当前批次没有服务码"); } } } catch (Exception ex) { result.Msg = ex.Message; } return(result); }