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