/// <summary>
/// 新版获取用户 余额+优惠券 刘佳
/// </summary>
/// <param name="userId"></param>
/// <param name="sltd"></param>
/// <returns></returns>
public ActivityBonusEntity SelectActivity(int userId, string sltd)
{
ActivityBonusEntity result = null;
result = _dal.SelectActivity(userId, sltd);
ActBase actBase = new ActBase();
string temp = string.Empty;
if (result.bonus != null && result.bonus.Count > 0)
{
foreach (var item in result.bonus)
{ //默认无限制
if (string.IsNullOrWhiteSpace(item.UseLifeLoan) || item.UseLifeLoan == "0")
{
item.UseLifeLoan = "0-0"; item.UseLifeLoanMessage = string.Empty;
}
actBase.GetCanUseLimit(item.UseLifeLoan, out temp);
if (!string.IsNullOrWhiteSpace(temp))
{
item.UseLifeLoanMessage = temp;
}
temp = string.Empty;
}
}
if (result.addRate != null && result.addRate.Count > 0)
{
foreach (var item in result.addRate)
{
if (string.IsNullOrWhiteSpace(item.UseLifeLoan) || item.UseLifeLoan == "0")
{
item.UseLifeLoan = "0-0"; item.UseLifeLoanMessage = string.Empty;
}
actBase.GetCanUseLimit(item.UseLifeLoan, out temp);
if (!string.IsNullOrWhiteSpace(temp))
{
item.UseLifeLoanMessage = temp;
}
temp = string.Empty;
}
}
return(result);
}
/// <summary>
/// 获取用户 余额+优惠券
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns>MemberInvestEntity.</returns>
public ActivityBonusEntity SelectBonus(int userId, string sltd)
{
ActivityBonusEntity ent = new ActivityBonusEntity();
#region 获取用户余额
var sql = string.Format("" +
"SELECT bonus_account_id,activity_schedule_name,amount_of_reward,use_lower_limit from bonus_account where membertable_registerid={0} and reward_state=0;" + "SELECT LogId, ActivityName, AddRate FROM[dbo].[ActivityLogs] WHERE UserId = {0} AND UseStatus = 0", userId);
var ds = DbHelper.Query(sql);
if (DataSetIsNotNull(ds))
{
ent.bonus = InitBonusList(ds.Tables[0], sltd);
ent.addRate = InitActivityLogs(ds.Tables[1], sltd);
return(ent);
}
return(null);
#endregion
}
/// <summary>
/// 新版获取用户代金券+加息券 刘佳
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <returns>MemberInvestEntity.</returns>
public ActivityBonusEntity SelectActivity(int userId, string sltd)
{
ActivityBonusEntity ent = new ActivityBonusEntity();
#region 获取用户代金券+加息券
//按照加息券的过期时间显示--贾磊同意修改
//var sql = string.Format("SELECT ua.UserAct as bonus_account_id,ta.ActName as activity_schedule_name,ua.Amt as amount_of_reward,ua.Uselower as use_lower_limit,UseLifeLoan FROM dbo.hx_UserAct as ua inner join dbo.hx_RewardType as at on ua.RewTypeID = at.RewTypeID inner join dbo.hx_ActivityTable as ta on ua.ActID = ta.ActID WHERE ua.registerid = {0} AND ta.ActStarttime <= GETDATE() AND ta.ActEndtime >= GETDATE() AND ua.UseState = 0 AND ua.RewTypeID = 2 ; " + "SELECT ua.UserAct as LogId,ta.ActName as ActivityName,ua.Amt as AddRate,UseLifeLoan FROM dbo.hx_UserAct as ua inner join dbo.hx_RewardType as at on ua.RewTypeID = at.RewTypeID inner join dbo.hx_ActivityTable as ta on ua.ActID = ta.ActID WHERE ua.registerid = {0} AND ta.ActStarttime <= GETDATE() AND ta.ActEndtime >= GETDATE() AND ua.UseState = 0 AND ua.RewTypeID =3", userId); //使用状态 UseState: 0未使用 1已使用 2已过期 3锁定中; 奖励类型RewTypeID:1现金 2抵扣券 3加息券
var sql = string.Format("SELECT ua.UserAct as bonus_account_id,ta.ActName as activity_schedule_name,ua.Amt as amount_of_reward,ua.Uselower as use_lower_limit,isnull(UseLifeLoan,'') as UseLifeLoan FROM dbo.hx_UserAct as ua inner join dbo.hx_RewardType as at on ua.RewTypeID = at.RewTypeID inner join dbo.hx_ActivityTable as ta on ua.ActID = ta.ActID WHERE ua.registerid = {0} AND ua.AmtEndtime>= '{1}' AND ua.UseState = 0 AND ua.RewTypeID = 2 ; " + "SELECT ua.UserAct as LogId,ta.ActName as ActivityName,ua.Amt as AddRate,isnull(UseLifeLoan,'') as UseLifeLoan FROM dbo.hx_UserAct as ua inner join dbo.hx_RewardType as at on ua.RewTypeID = at.RewTypeID inner join dbo.hx_ActivityTable as ta on ua.ActID = ta.ActID WHERE ua.registerid = {0} AND ua.AmtEndtime>= '{1}' AND ua.UseState = 0 AND ua.RewTypeID =3", userId, DateTime.Now.ToString("yyyy-MM-dd")); //使用状态 UseState: 0未使用 1已使用 2已过期 3锁定中; 奖励类型RewTypeID:1现金 2抵扣券 3加息券
var ds = DbHelper.Query(sql);
if (DataSetIsNotNull(ds))
{
ent.bonus = InitBonusList(ds.Tables[0], sltd); //代金券（红包）
ent.addRate = InitActivityLogs(ds.Tables[1], sltd); //加息券
return(ent);
}
return(null);
#endregion
}
