/// <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);
}
