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