//显示推荐人数
private int getNumOfRecommend()
{
ReferencesBiz referencesBiz = new ReferencesBiz();
DataSet result = referencesBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_NumberOfRecommend] '" + GetUData.OpenId + "'");
int num = 0;
return(num = (int)result.Tables[0].Rows[0][0]);
}
////获取用户头像
//private string getUserImg()
//{
// string imgUrl = GetUData.Head_Img_Url;
// if (imgUrl != null)
// {
// return imgUrl;
// }
// else
// {
// AppUserInfoBiz userInfoBiz = new AppUserInfoBiz();
// DataSet result = userInfoBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetUserInfoByWeiXinId] '" + GetUData.OpenId + "'");
// if (result.Tables[0].Rows.Count > 0)
// {
// imgUrl = result.Tables[0].Rows[0]["ImgeUrl"].ToString();
// }
// }
// return imgUrl;
//}
//添加用户到推荐表
private void addUserReferences(Guid userId, Guid toUserId)
{
ReferencesBiz referencesBiz = new ReferencesBiz();
DataSet result = referencesBiz.ExecuteSqlToDataSet("EXEC [TireTreasureDB].[dbo].[proc_GetIdByUserId] '" + userId + "'");
string recommendId = result.Tables[0].Rows[0]["Id"].ToString();
References references = new References();
references.UserId = userId;
references.ToUserId = toUserId;
references.InvitationCode = FilterTools.FilterSpecial(recommendId);
references.States = ConstantList.INVITE_SUCCESS;
references.CategoryId = ConstantList.NORMAL_USER;
references.AddTime = DateTime.Now;
references.isDeleted = false;
referencesBiz.Add(references);
}
