/// <summary>
/// 插入银行活动组配置
/// </summary>
/// <param name="config"></param>
/// <param name="operateUser"></param>
/// <returns></returns>
public bool InsertBankActivityGroupConfig(BankActivityGroupConfig config, string operateUser)
{
bool result = false;
try
{
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.InsertBankActivityGroupConfig(conn, config));
var log = new BeautyOprLog
{
LogType = "InsertBankActivityGroupConfig",
IdentityID = config.ActivityId.ToString(),
OldValue = null,
NewValue = JsonConvert.SerializeObject(config),
Remarks = $"插入银行活动组配置,活动ID：{config.ActivityId}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
public Tuple <bool, string> DeleteImportBankMRActivityByBatchCode(string batchCode, string operateUser)
{
try
{
var result = TuhuGrouponDbScopeManager.Execute(conn => BankMRActivityDal.DeleteImportBankMRActivityByBatchCode(conn, batchCode));
if (result)
{
var log = new BeautyOprLog
{
LogType = "DeleteImportBankMRActivityUsers",
IdentityID = $"{batchCode}",
OldValue = null,
NewValue = null,
Remarks = $"活动场次删除用户规则，batchCode:{batchCode},",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
return(Tuple.Create(result, ""));
}
catch (Exception ex)
{
Logger.Warn(ex.Message, ex);
return(Tuple.Create(false, ex.Message));
}
}
/// <summary>
/// 更新银行活动组配置
/// </summary>
/// <param name="config"></param>
/// <param name="operateUser"></param>
/// <returns></returns>
public bool UpdateBankActivityGroupConfigByPKID(BankActivityGroupConfig config, string operateUser)
{
bool result = false;
try
{
var oldValue = TuhuGrouponDbScopeManagerReadOnly.Execute(conn => BankMRActivityDal.SelectBankActivityGroupConfigByPKID(conn, config.PKID));
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateBankActivityGroupConfigByPKID(conn, config));
var log = new BeautyOprLog
{
LogType = "UpdateBankActivityGroupConfigByPKID",
IdentityID = config.PKID.ToString(),
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(config),
Remarks = $"更新银行活动组配置,PKID:{config.PKID}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 更新银行活动组名
/// </summary>
/// <param name="conn"></param>
/// <param name="groupId"></param>
/// <param name="groupName"></param>
/// <returns></returns>
public bool UpdateBankActivityGroupNameByGroupId(Guid groupId, string groupName, string operateUser)
{
bool result = false;
try
{
var oldValue = SelectBankActivityGroupConfigByGroupId(groupId, 1, 10).Item1.FirstOrDefault()?.GroupName;
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateBankActivityGroupNameByGroupId(conn, groupId, groupName));
var log = new BeautyOprLog
{
LogType = "UpdateBankActivityGroupNameByGroupId",
IdentityID = groupId.ToString(),
OldValue = oldValue,
NewValue = groupName,
Remarks = $"更新银行活动组名,GroupId:{groupId}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 根据ID删除银行活动组配置
/// </summary>
/// <param name="id"></param>
/// <param name="operateUser"></param>
/// <returns></returns>
public bool DeleteBankActivityGroupConfigByPKID(int pkid, string operateUser)
{
bool result = false;
try
{
var oldValue = TuhuGrouponDbScopeManager.Execute(conn => BankMRActivityDal.SelectBankActivityGroupConfigByPKID(conn, pkid));
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.DeleteBankActivityGroupConfigByPKID(conn, pkid));
var log = new BeautyOprLog
{
LogType = "DeleteBankActivityGroupConfigByPKID",
IdentityID = pkid.ToString(),
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = null,
Remarks = $"删除银行活动组配置,{pkid}:{pkid}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 更新限购配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public bool UpdateBankMRActivityLimitConfig(BankMRActivityLimitConfig config, string operateUser)
{
bool result = false;
try
{
var oldValue = FetchBankMRActivityLimitConfig(config.ActivityId);
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateBankMRActivityLimitConfig(conn, config));
UpdateBankMRActivityRoundLimitCount(config.ActivityId, config.RoundLimit);
var log = new BeautyOprLog
{
LogType = "UpdateBankMRActivityLimitConfig",
IdentityID = config.ActivityId.ToString(),
OldValue = JsonConvert.SerializeObject(oldValue),
NewValue = JsonConvert.SerializeObject(config),
Remarks = $"更新银行美容限购配置,活动ID:{config.ActivityId}",
OperateUser = operateUser,
};
LoggerManager.InsertLog("BeautyOprLog", log);
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 批量导入银行美容活动用户规则
/// </summary>
/// <param name="conn"></param>
/// <param name="table"></param>
/// <returns></returns>
internal bool BatchImportBankMRActivityUsers(SqlConnection conn, IEnumerable <BankMRActivityUser> list)
{
var dt = new DataTable {
TableName = "Tuhu_groupon.dbo.BankMRActivityUsers"
};
dt.Columns.Add(new DataColumn("ActivityRoundId", typeof(int)));
dt.Columns.Add(new DataColumn("BankCardNum", typeof(string)));
dt.Columns.Add(new DataColumn("Mobile", typeof(string)));
dt.Columns.Add(new DataColumn("OtherNum", typeof(string)));
dt.Columns.Add(new DataColumn("LimitCount", typeof(int)));
dt.Columns.Add(new DataColumn("DayLimit", typeof(int)));
dt.Columns.Add(new DataColumn("BatchCode", typeof(string)));
list?.ToList().ForEach(item =>
{
var row = dt.NewRow();
row["ActivityRoundId"] = item.ActivityRoundId;
row["BankCardNum"] = item.BankCardNum;
row["Mobile"] = item.Mobile;
row["OtherNum"] = item.OtherNum;
row["LimitCount"] = item.LimitCount;
row["DayLimit"] = item.DayLimit;
row["BatchCode"] = item.BatchCode;
dt.Rows.Add(row);
});
return(BankMRActivityDal.BatchImportBankMRActivityUsers(conn, dt));
}
/// <summary>
/// 获取限购上传记录
/// </summary>
/// <param name="batchCode"></param>
/// <returns></returns>
public IEnumerable <ImportBankMRActivityRecordModel> GetImportBankMRActivityUsersRecords(Guid activityId, out int count)
{
count = 0;
var result = TuhuGroupon_GungnirManagerReadOnly.Execute(conn => BankMRActivityDal.GetImportBankMRActivityRecords(conn, activityId));
count = result.Item1;
return(result.Item2);
}
/// <summary>
/// 根据组配置Id获取导入的银行活动白名单
/// </summary>
/// <param name="groupConfigId"></param>
/// <returns></returns>
public IEnumerable <BankActivityWhiteUsers> SelectImportBankActivityWhiteUsersByGroupConfigId(int groupConfigId)
{
IEnumerable <BankActivityWhiteUsers> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectImportBankActivityWhiteUsersByGroupConfigId(conn, groupConfigId));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 根据PKID获取银行活动组配置
/// </summary>
/// <param name="pkid"></param>
/// <returns></returns>
public BankActivityGroupConfig SelectBankActivityGroupConfigByPKID(int pkid)
{
BankActivityGroupConfig result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankActivityGroupConfigByPKID(conn, pkid));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 根据组Id分页获取银行活动组配置
/// </summary>
/// <returns></returns>
public Tuple <IEnumerable <BankActivityGroupConfig>, int> SelectBankActivityGroupConfigByGroupId(Guid groupId, int pageIndex, int pageSize)
{
Tuple <IEnumerable <BankActivityGroupConfig>, int> result = null;
try
{
TuhuGroupon_GungnirManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankActivityGroupConfigsByGroupId(conn, groupId, pageIndex, pageSize));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 根据活动Id查询银行美容活动
/// </summary>
/// <param name="activityId"></param>
/// <returns></returns>
public BankMRActivityConfig FetchBankMRActivityConfigByActivityId(Guid activityId)
{
try
{
var result = TuhuGrouponDbScopeManagerReadOnly.Execute(conn =>
BankMRActivityDal.FetchBankMRActivityConfigByActivityId(conn, activityId));
return(result);
}
catch (Exception ex)
{
Logger.Warn(ex.Message, ex);
return(null);
}
}
/// <summary>
/// 根据组名获取银行活动组配置
/// </summary>
/// <param name="conn"></param>
/// <param name="groupName"></param>
/// <returns></returns>
public IEnumerable <BankActivityGroupConfig> SelectBankActivityGroupConfigsByGroupName(string groupName)
{
IEnumerable <BankActivityGroupConfig> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankActivityGroupConfigsByGroupName(conn, groupName));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
public SignleBankMRActivityUserModel GetSignleBankMRActivityUser(Guid activityId, string mobile, string card, string otherNo)
{
try
{
var result = TuhuGroupon_GungnirManagerReadOnly.Execute(conn => BankMRActivityDal.GetSignleBankMRActivityUser(conn, activityId, mobile, card, otherNo));
return(result);
}
catch (Exception ex)
{
Logger.Warn(ex.Message, ex);
return(null);
}
}
/// <summary>
/// 根据活动id查询美容活动场次
/// </summary>
/// <param name="activityId">活动ID</param>
/// <returns></returns>
public IEnumerable <BankMRActivityRoundConfig> GetBankMRActivityRoundConfigsByActivityId(Guid activityId)
{
IEnumerable <BankMRActivityRoundConfig> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankMRActivityRoundConfigsByActivityId(conn, activityId));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 更新银行美容活动场次配置
/// </summary>
/// <param name="roundConfig">活动场次配置</param>
/// <returns></returns>
public bool UpdateBankMRActivityRoundConfig(BankMRActivityRoundConfig roundConfig)
{
var result = false;
try
{
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateBankMRActivityRoundConfig(conn, roundConfig));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
public bool UpdateBankMRActivityRoundLimitCount(Guid activityId, int limitCount)
{
var result = false;
try
{
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateBankMRActivityRoundLimitCount(conn, activityId, limitCount));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 根据活动ID获取银行活动配置
/// </summary>
/// <param name="activityId">活动ID</param>
/// <returns></returns>
public BankMRActivityConfig GetBankMRActivityConfigByActivityId(Guid activityId)
{
BankMRActivityConfig result = null;
try
{
result = TuhuGrouponDbScopeManagerReadOnly.Execute(conn => BankMRActivityDal.SelectBankMRActivityConfigByActivityId(conn, activityId));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 分页查询合作用户配置
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public Tuple <IEnumerable <MrCooperateUserConfig>, int> GetMrCooperateUserConfigs(int pageIndex, int pageSize)
{
Tuple <IEnumerable <MrCooperateUserConfig>, int> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectMrCooperateUserConfigs(conn, pageIndex, pageSize));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 根据userId查询用户服务码
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static IEnumerable <BankMRActivityCodeRecord> GetBankMRActivityCodeRecordByUserId(Guid userId)
{
IEnumerable <BankMRActivityCodeRecord> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectBankMRActivityCodeRecordByUserId(conn, userId));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
public bool IsExistBankMRActivityUsersByRoundIds(IEnumerable <int> roundIds)
{
var isExist = false;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => isExist = BankMRActivityDal.IsExistBankMRActivityUsersByRoundIds(conn, roundIds));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(isExist);
}
/// <summary>
/// 更新合作用户配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public bool UpdateMrCooperateUserConfig(MrCooperateUserConfig config)
{
bool result = false;
try
{
TuhuGrouponDbScopeManager.Execute(conn => result = BankMRActivityDal.UpdateMrCooperateUserConfig(conn, config));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 根据PKID获取合作用户配置
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public MrCooperateUserConfig FetchMrCooperateUserConfigByPKID(int pkid)
{
MrCooperateUserConfig result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.FetchMrCooperateUserConfigByPKID(conn, pkid));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 获取所有合作用户配置
/// </summary>
/// <returns></returns>
public IEnumerable <MrCooperateUserConfig> GetAllMrCooperateUserConfigs()
{
IEnumerable <MrCooperateUserConfig> result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.SelectAllMrCooperateUserConfigs(conn));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 插入或更新银行活动广告位配置
/// </summary>
/// <param name="config"></param>
/// <returns></returns>
public bool UpsertBankMRActivityAdConfig(BankMRActivityAdConfig config)
{
var result = false;
try
{
result = TuhuGrouponDbScopeManagerReadOnly.Execute(conn =>
BankMRActivityDal.UpsertBankMRActivityAdConfig(conn, config));
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
}
return(result);
}
/// <summary>
/// 分页查询银行美容活动配置
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public IEnumerable <BankMRActivityConfig> GetBankMRActivityConfigs(int pageIndex, int pageSize, int cooperateId,
string activityName, string serviceId, string settleMentMethod, out int count)
{
IEnumerable <BankMRActivityConfig> result = null;
count = 0;
try
{
var temp = TuhuGrouponDbScopeManagerReadOnly.Execute(conn => BankMRActivityDal.SelectBankMRActivityConfigs(conn, pageIndex, pageSize, cooperateId, activityName, serviceId, settleMentMethod));
result = temp.Item1;
count = temp.Item2;
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <summary>
/// 批量导入银行活动白名单
/// </summary>
/// <param name="conn"></param>
/// <param name="list"></param>
/// <returns></returns>
internal bool BatchImportBankActivityWhiteUsers(SqlConnection conn, IEnumerable <BankActivityWhiteUsers> list)
{
var dt = new DataTable {
TableName = "Tuhu_groupon.dbo.BankActivityWhiteUsers"
};
dt.Columns.Add(new DataColumn("GroupConfigId", typeof(int)));
dt.Columns.Add(new DataColumn("CardNum", typeof(string)));
dt.Columns.Add(new DataColumn("Mobile", typeof(string)));
list?.ToList().ForEach(item =>
{
var row = dt.NewRow();
row["GroupConfigId"] = item.GroupConfigId;
row["CardNum"] = item.CardNum;
row["Mobile"] = item.Mobile;
dt.Rows.Add(row);
});
return(BankMRActivityDal.BatchImportBankMRActivityUsers(conn, dt));
}
/// <summary>
/// 获取限购配置
/// </summary>
/// <param name="activityId"></param>
/// <returns></returns>
public BankMRActivityLimitConfig FetchBankMRActivityLimitConfig(Guid activityId)
{
BankMRActivityLimitConfig result = null;
try
{
TuhuGrouponDbScopeManagerReadOnly.Execute(conn => result = BankMRActivityDal.FetchBankMRActivityLimitConfig(conn, activityId));
var roundConfig = GetBankMRActivityRoundConfigsByActivityId(activityId);
if (roundConfig != null)
{
if (result == null)
{
result = new BankMRActivityLimitConfig();
}
result.RoundLimit = roundConfig.FirstOrDefault()?.LimitCount ?? 0;
}
}
catch (Exception ex)
{
Logger.Error(ex.Message, ex);
};
return(result);
}
/// <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="batchCode"></param>
/// <returns></returns>
public IEnumerable <ImportBankMRActivityRecordModel> GetImportBankMRActivityUsers(string batchCode)
{
return(TuhuGroupon_GungnirManagerReadOnly.Execute(conn => BankMRActivityDal.GetImportBankMRActivityUsers(conn, batchCode)));
}
