private void GetRecemmendCode(int userId)
{
litRecemmendCode.Text = MemberHelper.GetRecemmendCode(userId);
ErrorLog.Write("recemmendcode:" + litRecemmendCode.Text);
//
MemberRecommendCodeInfo recomendCodeInfo = MemberHelper.GetRecommendCodeInfo(userId);
if (recomendCodeInfo != null)
{
if (litTotals != null)
{
litTotals.Text = recomendCodeInfo.TotalNum.ToString();
}
if (litWeekLevel != null)
{
litWeekLevel.Text = recomendCodeInfo.WeekLevel.ToString();
}
if (recomendCodeInfo.NextRecommendCode != null && recomendCodeInfo.NextRecommendCode.Count > 0)
{
var str = "";
for (int i = 0; i < recomendCodeInfo.NextRecommendCode.Count; i++)
{
var item = recomendCodeInfo.NextRecommendCode[i];
if (i % 2 == 0)
{
str += "<tr>";
str += "<td width='50%'>" + item.CellPhone + "</td>";
}
else if (i % 2 == 1)
{
str += "<td width='50%'>" + item.CellPhone + "</td>";
str += "</tr>";
}
}
litRecommendList.Text = str;
}
}
}
/// <summary>
/// 获取邀请码相关信息
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public MemberRecommendCodeInfo GetRecommendCodeInfo(int userId)
{
MemberRecommendCodeInfo recommendCodeInfo = new MemberRecommendCodeInfo();
string sql = @"select count(*) as TotalNum from Ecshop_RecommendCodeRecord where UseredId = @userId;
select COUNT(*) WeekLevel from Ecshop_RecommendCodeRecord
where addtime between dateadd(wk,datediff(wk,0,getdate()), 0) and dateadd(wk,datediff(wk,0,getdate()), 6)
and UseredId = @userId group by UseredId;
select top 10 SUBSTRING(b.CellPhone,1,LEN(b.CellPhone) - 8) +'****' + right(b.CellPhone,4) CellPhone
from Ecshop_RecommendCodeRecord a
left join aspnet_Members b on a.UseredId = b.UserId
where b.CellPhone <> '' and b.CellPhone is not null and UseredId = @userId
order by AddTime desc;";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(sql);
this.database.AddInParameter(sqlStringCommand, "userId", DbType.Int32, userId);
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
if (dataReader["TotalNum"] != System.DBNull.Value)
{
recommendCodeInfo.TotalNum = (int)dataReader["TotalNum"];
}
else
{
recommendCodeInfo.TotalNum = 0;
}
}
dataReader.NextResult();
if (dataReader.Read())
{
if (dataReader["WeekLevel"] != System.DBNull.Value)
{
recommendCodeInfo.WeekLevel = (int)dataReader["WeekLevel"];
}
else
{
recommendCodeInfo.WeekLevel = 0;
}
}
dataReader.NextResult();
NextRecommendCode item;
List <NextRecommendCode> nextitems = new List <NextRecommendCode>();
while (dataReader.Read())
{
item = new NextRecommendCode();
if (dataReader["CellPhone"] != System.DBNull.Value)
{
item.CellPhone = dataReader["CellPhone"].ToString();
}
nextitems.Add(item);
}
if (nextitems != null && nextitems.Count > 0)
{
recommendCodeInfo.NextRecommendCode.AddRange(nextitems);
}
}
return(recommendCodeInfo);
}
