public List<UserSimpleInfo> SearchFriend(string uname,int uid)
{
SqlDataReader dr = SqlHelper.ExecuteReader("dbo.S_SearchFriendByName", new SqlParameter("@Name",uname));
List<UserSimpleInfo> infos = new List<UserSimpleInfo>();
UserSimpleInfo Info = null;
List<temp> temps = new List<temp> ();
temp t = null;
while(dr.Read())
{
Info = new UserSimpleInfo();
Info.ID = dr.GetInt32(0);
Info.name = dr.GetString(1);
if (dr.GetInt32(2) == 0) { Info.sex = "男"; } else { Info.sex = "女"; };
Info.UserImage = dr.GetString(3);
Info.Introduce = dr.GetString(4);
Info.IsFollowed = isFollowed(uid, Info.ID);
infos.Add(Info);
}
if (dr.NextResult())
{
while(dr.Read())
{
t = new temp ();
t.count = dr.GetInt32(0);
t.id = dr.GetInt32(1);
temps.Add(t);
}
}
//取得粉丝
int foo = 0;
for (int i = 0; i < infos.Count;i++ )
{
if(temps.Count==0){
break;
}
if(foo>=temps.Count){
foo--;
}
if(temps[foo].id == infos[i].ID)
{
infos[i].following = temps[foo].count;
foo++;
}
}
dr.Close();
return infos;
}
public List<UserSimpleInfo> SearchFriend(int uid,int id)
{
SqlDataReader dr = SqlHelper.ExecuteReader("dbo.S_SearchFriendById", new SqlParameter("@id", id));
List<UserSimpleInfo> infos = new List<UserSimpleInfo>();
UserSimpleInfo Info = null;
while (dr.Read())
{
Info = new UserSimpleInfo();
Info.ID = dr.GetInt32(0);
Info.name = dr.GetString(1);
if (dr.GetInt32(2) == 0) { Info.sex = "男"; } else { Info.sex = "女"; };
Info.UserImage = dr.GetString(3);
Info.Introduce = dr.GetString(4);
Info.IsFollowed = isFollowed(uid, id);
infos.Add(Info);
}
dr.Close();
return infos;
}
public UserSimpleInfo getUserInfoById(int mid ,int uid)
{
UserSimpleInfo user = new UserSimpleInfo();
SqlDataReader dr = SqlHelper.ExecuteReader("S_Get_UserInfo", new SqlParameter("@ID", uid));
if (mid != 0)
{
user.IsFollowed = isFollowed(mid, uid);
}
else
{
user.IsFollowed = true;
}
if (dr.Read())
{
user.name = dr.GetString(0);
user.Introduce = dr.GetString(1);
if (dr.GetString(2) == null)
{
user.UserImage = "1.jpg";
}
else
{
user.UserImage = dr.GetString(2);
}
}
if (dr.NextResult())
{
if (dr.Read())
{
user.WeiboCount = dr.GetInt32(0);
}
}
if (dr.NextResult())
{
if (dr.Read())
{
user.following = dr.GetInt32(0);
}
}
if (dr.NextResult())
{
if (dr.Read())
{
user.followed = dr.GetInt32(0);
}
}
dr.Close();
return user;
}
