/// <summary> /// 配置审核 /// </summary> /// <param name="configId"></param> /// <param name="auditStatus"></param> /// <returns></returns> public bool AuditRedemptionCodeConfig(Guid configId, string auditStatus, string auditor) { bool result = false; try { result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.AuditRedemptionCodeConfig(conn, configId, auditStatus, auditor)); if (result) { InsertBeautyOprLog(new { LogType = RedemptionCodeConfigType, IdentityID = configId, NewValue = string.Empty, OldValue = string.Empty, OperateUser = auditor, Remarks = $"审核配置{configId},审核结果:{auditStatus}", }); } } catch (Exception ex) { Logger.Error(nameof(AuditRedemptionCodeConfig), ex); result = false; } return(result); }
/// <summary> /// 添加配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public bool AddRedemptionCodeConfig(RedemptionConfig config) { bool result = false; try { config.ConfigId = Guid.NewGuid(); config.Auditor = string.Empty; config.AuditStatus = "Pending"; result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.AddRedemptionCodeConfig(conn, config)); if (result) { InsertBeautyOprLog(new { LogType = RedemptionCodeConfigType, IdentityID = config.ConfigId, OldValue = string.Empty, NewValue = JsonConvert.SerializeObject(config), OperateUser = config.CreateUser, Remarks = "add", }); } } catch (Exception ex) { Logger.Error(nameof(AddRedemptionCodeConfig), ex); result = false; } return(result); }
public bool DeleteRedeemMrCodeLimitConfig(int mrCodeConfigId, string userName) { var result = false; try { var config = GetRedeemMrCodeLimitConfig(mrCodeConfigId); if (config != null) { result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.DeleteRedeemMrCodeLimitConfig(conn, mrCodeConfigId)); } if (result) { InsertBeautyOprLog(new { LogType = RedeemMrCodeLimitConfigType, IdentityID = config.MrCodeConfigId, OldValue = JsonConvert.SerializeObject(config), NewValue = string.Empty, OperateUser = userName, Remarks = "删除美容服务码限购配置", }); } } catch (Exception ex) { Logger.Error(nameof(DeleteRedeemMrCodeLimitConfig), ex); } return(result); }
/// <summary> /// 更新配置 /// </summary> /// <param name="config"></param> /// <returns></returns> public bool UpdateRedemptionCodeConfig(RedemptionConfig config) { bool result = false; try { var oldConfig = GetRedemptionCodeConfig(config.ConfigId); if (oldConfig != null) { result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.UpdateRedemptionCodeConfig(conn, config)); } if (result) { InsertBeautyOprLog(new { LogType = RedemptionCodeConfigType, IdentityID = config.ConfigId, OldValue = JsonConvert.SerializeObject(oldConfig), NewValue = JsonConvert.SerializeObject(config), OperateUser = config.CreateUser, Remarks = "update", }); } } catch (Exception ex) { Logger.Error(nameof(UpdateRedemptionCodeConfig), ex); result = false; } return(result); }
public bool RemoveCouponBusinessConfig(int id, string userName) { var success = false; try { var config = GetCouponBusinessConfig(id); if (config != null) { success = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.RemoveCouponBusinessConfig(conn, config.PKID)); if (success) { InsertBeautyOprLog(new { LogType = CouponBusinessType, IdentityID = id, OldValue = JsonConvert.SerializeObject(config), NewValue = string.Empty, OperateUser = userName, Remarks = "删除", }); } } } catch (Exception ex) { Logger.Error(nameof(RemoveCouponBusinessConfig), ex); } return(success); }
public object AddRedeemPromotionConfig(RedeemPromotionConfig config, string userName) { var result = false; try { config.PKID = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.AddRedeemPromotionConfig(conn, config)); result = config.PKID > 0; if (result) { InsertBeautyOprLog(new { LogType = RedeemPromotionConfigType, IdentityID = config.PKID, NewValue = JsonConvert.SerializeObject(config), OldValue = string.Empty, OperateUser = userName, Remarks = "添加", }); } } catch (Exception ex) { Logger.Error(nameof(AddRedeemPromotionConfig), ex); } return(result); }
public List <PromotionBusinessTypeConfig> GetCouponBusinessConfigs(string businessType) { List <PromotionBusinessTypeConfig> result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.GetCouponBusinessConfigs(conn, businessType))?.ToList(); var coupons = GetCouponRules(result?.Select(x => x.GetRuleGuid).Distinct()); result?.ForEach(x => { var coupon = coupons.FirstOrDefault(item => item.GetRuleGUID == x.GetRuleGuid); if (coupon != null) { x.Description = $"{coupon.PKID}-{coupon.PromotionName}-{coupon.Description}"; } else { x.Description = string.Empty; } }); } catch (Exception ex) { Logger.Error(nameof(GetCouponBusinessConfigs), ex); } return(result ?? new List <PromotionBusinessTypeConfig>()); }
public object UpdateRedeemPromotionConfig(RedeemPromotionConfig config, string userName) { var result = false; try { var oldConfig = GetRedeemPromotionConfig(config.PKID); if (config != null) { result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.UpdateRedeemPromotionConfig(conn, config)); } if (result) { InsertBeautyOprLog(new { LogType = RedeemPromotionConfigType, IdentityID = config.PKID, OldValue = JsonConvert.SerializeObject(oldConfig), NewValue = JsonConvert.SerializeObject(config), OperateUser = userName, Remarks = "更新", }); } } catch (Exception ex) { Logger.Error(nameof(UpdateRedeemPromotionConfig), ex); } return(result); }
public Tuple <int, List <RedemptionCodeRecordResult> > GetRedemptionCodeRecords(SearchRedemptionConfigRequest request) { int total = 0; List <RedemptionCodeRecordResult> list = null; try { var result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionCodeRecords(conn, request)); var batchCodes = result.Item2?.Select(t => t.BatchCode); if (batchCodes != null && batchCodes.Any()) { var batchCodeStatus = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionBatchStatus(conn, batchCodes, new { BatchCode = "", Status = "" })); if (batchCodeStatus != null && batchCodeStatus.Any()) { result.Item2.ForEach(b => { b.Status = batchCodeStatus.FirstOrDefault(s => s.BatchCode == b.BatchCode)?.Status; }); } } total = result.Item1; list = result.Item2?.ToList(); } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(Tuple.Create(total, list ?? new List <RedemptionCodeRecordResult>())); }
public bool DeleteRedemptionCodeConfig(Guid configId, string userName) { var success = false; try { var oldData = GetRedemptionCodeConfig(configId); if (oldData != null) { success = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.DeleteRedemptionCodeConfig(conn, configId)); } if (success) { InsertBeautyOprLog(new { LogType = RedemptionCodeConfigType, IdentityID = configId, NewValue = string.Empty, OldValue = JsonConvert.SerializeObject(oldData), OperateUser = userName, Remarks = "delete", }); } } catch (Exception ex) { Logger.Error(nameof(DeleteRedemptionCodeConfig), ex); } return(success); }
public bool UpdateRedeemMrCodeLimitConfig(RedeemMrCodeLimitConfig config, string userName) { var result = false; try { var oldValue = GetRedeemMrCodeLimitConfig(config.MrCodeConfigId); result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.UpdateRedeemMrCodeLimitConfig(conn, config)); if (result) { InsertBeautyOprLog(new { LogType = RedeemMrCodeLimitConfigType, IdentityID = config.MrCodeConfigId, OldValue = oldValue == null ? string.Empty : JsonConvert.SerializeObject(oldValue), NewValue = JsonConvert.SerializeObject(config), OperateUser = userName, Remarks = "更新美容服务码限购", }); } } catch (Exception ex) { Logger.Error(nameof(UpdateRedeemMrCodeLimitConfig), ex); } return(result); }
public Tuple <bool, string> SaveRedeemGroupSetting(RedeemGroupSetting model, string userName) { var result = false; if (model == null) { return(Tuple.Create(result, "")); } try { if (model.GroupId == null || model.GroupId == Guid.Empty) { model.GroupId = Guid.NewGuid(); result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.InsertRedeemGroupSetting(conn, model)); if (result) { InsertBeautyOprLog(new { LogType = "InsertRedeemGroupSetting", IdentityID = model.GroupId, NewValue = JsonConvert.SerializeObject(model), OldValue = string.Empty, OperateUser = userName, }); } } else { var oldmodel = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.GetRedeemGroupSetting(conn, model.GroupId)); if (model.SendCodeType == 1)//自动发码,群组下只能有一个套餐 { if (DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.GetRedemptionConfigCountByGroupId(conn, model.GroupId)) > 1) { return(Tuple.Create(result, "自动发码时,群组下只能有一个套餐")); } } result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.UpdateRedeemGroupSetting(conn, model)); if (result) { InsertBeautyOprLog(new { LogType = "UpdateRedeemGroupSetting", IdentityID = model.GroupId, NewValue = JsonConvert.SerializeObject(model), OldValue = JsonConvert.SerializeObject(oldmodel), OperateUser = userName, }); } } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(Tuple.Create(result, "")); }
/// <summary> /// 根据兑换码,手机号查询通用兑换码信息 /// </summary> /// <param name="redemptionCode"></param> /// <param name="mobile"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Tuple <IEnumerable <UnivBeautyRedemptionCodeResult>, int> GetRedemptionCodeRecordsByCondition(string redemptionCode, string mobile, int pageIndex, int pageSize) { var result = new List <UnivBeautyRedemptionCodeResult>(); var total = 0; try { if (!string.IsNullOrWhiteSpace(redemptionCode)) { var univRedemptionCode = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.FetchRedemptionCodeRecordByRedemptionCode(conn, redemptionCode)); if (univRedemptionCode != null) { if (univRedemptionCode.UserId != null) { var user = UserAccountService.GetUserById(univRedemptionCode.UserId.Value); univRedemptionCode.Mobile = user?.MobileNumber; } if (!string.IsNullOrWhiteSpace(mobile)) { if (univRedemptionCode.Mobile == mobile) { result.Add(univRedemptionCode); } } else { result.Add(univRedemptionCode); } total = result.Count; } } else if (!string.IsNullOrWhiteSpace(mobile)) { var user = UserAccountService.GetUserByMobile(mobile); if (user != null && user.UserId != Guid.Empty) { var redemptionCodes = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionCodeRecordsByUserId(conn, user.UserId, pageIndex, pageSize)); redemptionCodes.Item1.ForEach(i => { i.Mobile = user.MobileNumber; }); result.AddRange(redemptionCodes.Item1); total = redemptionCodes.Item2; } } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(new Tuple <IEnumerable <UnivBeautyRedemptionCodeResult>, int>(GetRedemptionCarNumber(result), total)); }
public bool IsExistsRedeemPromotionConfig(RedeemPromotionConfig config) { bool result = true; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.IsExistsRedeemPromotionConfig(conn, config)); } catch (Exception ex) { Logger.Error(nameof(IsExistsRedeemPromotionConfig), ex); } return(result); }
public OpenAppModel GetThirdAppSettingsDetailByGroupId(string appId) { OpenAppModel result = null; try { result = DbTuhuGunginrScopeReadManager.Execute(conn => DALUnivRedemptionCode.GetThirdAppSettingsDetailByAppId(conn, appId)); } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(result); }
public PromotionBusinessTypeConfig GetCouponBusinessConfig(int id) { PromotionBusinessTypeConfig result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectCouponBusinessConfig(conn, id)); } catch (Exception ex) { Logger.Error(nameof(GetCouponBusinessConfig), ex); } return(result); }
public RedeemMrCodeLimitConfig GetRedeemMrCodeLimitConfig(int mrCodeConfigId) { RedeemMrCodeLimitConfig result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedeemMrCodeLimitConfig(conn, mrCodeConfigId)); } catch (Exception ex) { Logger.Error(nameof(GetRedeemMrCodeLimitConfig), ex); } return(result); }
/// <summary> /// 更加groupID获取配置 /// </summary>GetRedemptionConfigsGroupId /// <param name="configId"></param> /// <returns></returns> public IEnumerable <RedemptionConfig> GetRedemptionConfigsGroupId(Guid groupId) { IEnumerable <RedemptionConfig> result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.GetRedemptionConfigsGroupId(conn, groupId)); } catch (Exception ex) { Logger.Error(nameof(GetRedemptionCodeConfig), ex); } return(result); }
public List <RedeemMrCodeConfig> GetRedeemMrCodeConfigs(Guid configId) { List <RedeemMrCodeConfig> result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedeemMrCodeConfigs(conn, configId)); } catch (Exception ex) { Logger.Error(nameof(GetRedeemMrCodeConfigs), ex); } return(result); }
public List <RedeemPromotionConfig> GetRedeemPromotionConfigs(Guid id) { List <RedeemPromotionConfig> result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedeemPromotionConfigs(conn, id)); //var coupons = GetCouponRules(result.Select(x => x.GetRuleGuid)); } catch (Exception ex) { Logger.Error(nameof(GetRedeemPromotionConfigs), ex); } return(result); }
public List <RedemptionConfig> GetRedemptionCodeConfigsByGenerateType(string generateType) { List <RedemptionConfig> list = null; int total = 0; try { list = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionCodeConfigsByGenerateType(conn, generateType)); } catch (Exception ex) { Logger.Error(nameof(GetRedemptionCodeConfigsByGenerateType), ex); } return(list); }
public bool GenerateRedemptionCodeRecords(Guid configId, int days, int num, string userName) { var success = false; var now = DateTime.Now; var startTime = new DateTime(now.Year, now.Month, now.Day); var endTime = startTime.AddDays(days); try { var result = GenerateRedemptionCode(num, startTime, endTime, userName); if (result.Success && result.Codes != null && result.Codes.Any()) { var createTime = DateTime.Parse(now.ToString("yyyy-MM-dd HH:mm:ss.fff")); var records = result.Codes.Select(x => new RedemptionCodeRecord { BatchCode = result.BatchCode, CreateTime = createTime, CreateUser = userName, MobileNum = null, OrderId = null, RedemptionCode = x, RedemptionConfigId = configId, UpdateTime = null, UserId = null, }).ToList(); success = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.AddRedeemCodeRecords(conn, records)); if (success) { InsertBeautyOprLog(new { LogType = RedemptionCodeRecordType, IdentityID = result.BatchCode, NewValue = string.Empty, OldValue = string.Empty, OperateUser = userName, Remarks = $"{userName}生成了批次{result.BatchCode}的兑换码", }); } } } catch (Exception ex) { Logger.Error(nameof(GenerateRedemptionCodeRecords), ex); } return(success); }
public List <OpenAppModel> GetThirdAppSettings(out int count, int pageIndex, int pageSize, string keyWord) { List <OpenAppModel> list = null; count = 0; try { var result = DbTuhuGunginrScopeReadManager.Execute(conn => DALUnivRedemptionCode.GetThirdAppSettings(conn, pageIndex, pageSize, keyWord)); list = result.Item1; count = result.Item2; } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(list); }
/// <summary> /// 分页获取兑换码配置 /// </summary> /// <param name="request"></param> /// <returns></returns> public Tuple <int, List <RedemptionConfig> > GetRedemptionCodeConfigs(SearchRedemptionConfigRequest request) { List <RedemptionConfig> list = null; int total = 0; try { var result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionCodeConfigs(conn, request)); total = result.Item1; list = result.Item2; } catch (Exception ex) { Logger.Error(nameof(GetRedemptionCodeConfigs), ex); } return(Tuple.Create(total, list ?? new List <RedemptionConfig>())); }
public bool DelThirdAppSetting(int id, string userName) { var result = DbTuhuGunginrScopeManager.Execute(conn => DALUnivRedemptionCode.DeleteThirdAppSetting(conn, id)); if (result) { InsertBeautyOprLog(new { LogType = "DeleteThirdAppSetting", IdentityID = id, NewValue = string.Empty, OldValue = string.Empty, OperateUser = userName, }); } return(result); }
public List <RedeemGroupSetting> SelectRedeemGroupSetting(out int count, int pageIndex, int pageSize, string keyWord) { List <RedeemGroupSetting> list = null; count = 0; try { var result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.SelectRedeemGroupSetting(conn, pageIndex, pageSize, keyWord)); list = result.Item1; count = result.Item2; } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(list); }
public bool SaveThirdAppSetting(OpenAppModel model, string userName) { bool result = false; try { if (model.Id > 0) { var oldModel = GetThirdAppSettingDetail(model.Id); result = DbTuhuGunginrScopeReadManager.Execute(conn => DALUnivRedemptionCode.UpdateThirdAppSetting(conn, model)); if (result) { InsertBeautyOprLog(new { LogType = "UpdateThirdAppSetting", IdentityID = model.AppId, NewValue = JsonConvert.SerializeObject(model), OldValue = JsonConvert.SerializeObject(oldModel), OperateUser = userName, }); } } else { result = DbTuhuGunginrScopeReadManager.Execute(conn => DALUnivRedemptionCode.InsertThirdAppSetting(conn, model)); if (result) { InsertBeautyOprLog(new { LogType = "InsertThirdAppSetting", IdentityID = model.AppId, NewValue = JsonConvert.SerializeObject(model), OldValue = string.Empty, OperateUser = userName, }); } } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(result); }
public Tuple <bool, string> DeleteRedeemGroupSetting(RedeemGroupSetting model, string userName) { var result = false; if (model == null) { return(Tuple.Create(result, "")); } try { if (model.GroupId != null && model.GroupId != Guid.Empty) { var oldmodel = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.GetRedeemGroupSetting(conn, model.GroupId)); if (DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.GetRedemptionConfigCountByGroupId(conn, model.GroupId)) <= 0) { result = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.DeleteRedeemGroupSetting(conn, model)); if (result) { InsertBeautyOprLog(new { LogType = "UpdateRedeemGroupSetting", IdentityID = model.GroupId, NewValue = JsonConvert.SerializeObject(model), OldValue = JsonConvert.SerializeObject(oldmodel), OperateUser = userName, }); } } else { return(Tuple.Create(result, "该分组下存在套餐无法删除!")); } } } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(Tuple.Create(result, "")); }
public RedeemPromotionConfig GetRedeemPromotionConfig(int id) { RedeemPromotionConfig result = null; try { result = DbTuhuGrouponScopeReadManager.Execute(conn => DALUnivRedemptionCode.SelectRedeemPromotionConfig(conn, id)); if (result != null) { var coupon = GetCouponRules(new[] { result.GetRuleGuid })?.FirstOrDefault(); if (coupon != null) { result.CouponDescription = $"{coupon.PKID}-{coupon.PromotionName}-{coupon.Description}"; } } } catch (Exception ex) { Logger.Error(nameof(GetRedeemPromotionConfig), ex); } return(result); }
public List <RedemptionCodeRecord> GetRedemptionCodeRecords(string batchCode, string userName) { List <RedemptionCodeRecord> list = null; try { list = DbTuhuGrouponScopeManager.Execute(conn => DALUnivRedemptionCode.SelectRedemptionCodeRecords(conn, batchCode)); InsertBeautyOprLog(new { LogType = "DownloadRedemptionCodeRecords", IdentityID = batchCode, NewValue = string.Empty, OldValue = string.Empty, OperateUser = userName, Remarks = $"{userName}下载了批次{batchCode}的兑换码", }); } catch (Exception ex) { Logger.Error(ex.Message, ex); } return(list); }