[C#] 纯文本查看 复制代码
foreach (Members member in memberList)
{
List<int> nlist = new List<int>();
Dictionary<int,int> dic=new Dictionary<int, int>();
double num=0;
//GetSubId(member.UserId, ref nlist); 久
GetSubIdNew(member.UserId, ref nlist,ref dic);
if (nlist != null) num = nlist.Count;
//将得到的子表数据直接添加的主表。完美解决子查询和链表问题
member.AddExData("downmembernum", num);//下级会员数量
}
[C#] 纯文本查看 复制代码
/// <summary>
/// 查询会员id 速度更快 过滤
/// </summary>
/// <param name="userIdlist">Id列表</param>
/// <returns></returns>
public Dictionary<int, int> FindListDic(int subUserId)
{
var sql = "SELECT userid,typelevel FROM [aspnet_Members] WHERE subUserId=@subUserId ";
return FindListDic(sql, CommandType.Text, UtilDAL.CreateParameter("subUserId", subUserId));
}