/// <summary>
/// 查询塞券记录
/// </summary>
/// <param name="batchCode"></param>
/// <param name="moileNumber"></param>
/// <param name="packagePid"></param>
/// <param name="vipUserId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public Tuple <List <VipPaintPromotionRecordViewModel>, int> SelectPromotionRecord
(string batchCode, string moileNumber, string packagePid, Guid vipUserId, int pageIndex, int pageSize)
{
var result = null as List <VipPaintPromotionRecordViewModel>;
var totalCount = 0;
try
{
result = dbScopeManagerConfigurationRead.Execute(conn => DalVipPaintPackage.SelectPromotionRecord
(conn, batchCode, moileNumber, packagePid, vipUserId, pageIndex, pageSize, out totalCount));
if (result != null && result.Any())
{
var vipUsers = new VipBaoYangPackageManager().GetAllBaoYangPackageUser();
if (vipUsers != null && vipUsers.Any())
{
result.ForEach(s =>
{
s.VipUserName = vipUsers.FirstOrDefault(v =>
string.Equals(v.VipUserId, s.VipUserId.ToString()))?.VipUserName;
});
}
}
}
catch (Exception ex)
{
Logger.Error("SelectPromotionRecord", ex);
}
return(Tuple.Create(result, totalCount));
}
/// <summary>
/// 查看短信配置
/// </summary>
/// <param name="model"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public Tuple <List <VipPaintPackageSmsConfig>, int> SelectPackageSmsConfig
(VipPaintPackageSmsConfig model, int pageIndex, int pageSize)
{
var result = null as List <VipPaintPackageSmsConfig>;
var totalCount = 0;
try
{
result = dbScopeManagerConfigurationRead.Execute(conn =>
DalVipPaintPackage.SelectPackageSmsConfig(conn, model, pageIndex, pageSize, out totalCount));
var vipUsers = new VipBaoYangPackageManager().GetAllBaoYangPackageUser();
if (result != null && result.Any() && vipUsers != null && vipUsers.Any())
{
result.ForEach(s =>
{
s.VipUserName = vipUsers.FirstOrDefault(v => string.Equals(v.VipUserId, s.VipUserId.ToString()))?.VipUserName;
});
}
}
catch (Exception ex)
{
Logger.Error("SelectVipPaintPackageSmsConfig", ex);
}
return(Tuple.Create(result, totalCount));
}
/// <summary>
/// 获取配置了套餐的喷漆大客户
/// </summary>
/// <returns></returns>
public List <VipSimpleUser> GetPaintVipUsers()
{
var result = new List <VipSimpleUser>();
try
{
var vipUserIds = dbScopeManagerConfiguration.Execute(conn => DalVipPaintPackage.GetPaintVipUsers(conn));
var allVipUsers = new VipBaoYangPackageManager().GetAllBaoYangPackageUser();
if (vipUserIds != null && vipUserIds.Any() && allVipUsers != null && allVipUsers.Any())
{
result = allVipUsers.Where(s => vipUserIds.Contains(s.VipUserId)).ToList();
}
}
catch (Exception ex)
{
Logger.Error("GetAllPaintVipUsers", ex);
result = null;
}
return(result);
}