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