//查询SideBar好友
public static void SearchFriends(SideBar sbFriends)
{
try
{
conn.Open();
string selectSql = string.Format("select userInfo.LoginID,FaceImageID,SpeciallyWord,NickName,FriendState from userInfo inner join Friends on UserInfo.Loginid=Friends.LoginID where Friends.FriendLoginID='{0}' ", UserHelper.LoginID);
SqlCommand command = new SqlCommand(selectSql, conn);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
if (Convert.ToInt32(reader["friendState"]) == 0)
{
SbItem item = new SbItem(reader["NickName"].ToString(), Convert.ToInt32(reader["FaceImageID"]));
item.Tag=reader["LoginID"].ToString();
for (int i = 0; i < sbFriends.Groups[0].Items.Count; i++)
{
if (sbFriends.Groups[0].Items[i].Tag.ToString() == item.Tag.ToString())
{
break;
}
else
{
sbFriends.Groups[0].Items.Add(item);
}
}
}
else if (Convert.ToInt32(reader["FriendState"]) == 1)
{
SbItem item = new SbItem(reader["NickName"].ToString(), Convert.ToInt32(reader["FaceImageID"]));
item.Tag = reader["LoginID"].ToString();
for (int i = 0; i < sbFriends.Groups[1].Items.Count; i++)
{
if (sbFriends.Groups[1].Items[i].Tag.ToString() == item.Tag.ToString())
{
break;
}
else
{
sbFriends.Groups[1].Items.Add(item);
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
public static void SearchFriends(SideBar sbFriends)
{
try
{
conn.Open();
string selectSql = string.Format("select userInfo.LoginID,FaceImageID,SpeciallyWord,NickName,FriendState from userInfo inner join Friends on UserInfo.Loginid=Friends.LoginID where Friends.FriendLoginID='{0}' ", UserHelper.LoginID);
SqlCommand command = new SqlCommand(selectSql, conn);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
if (Convert.ToInt32(reader["friendState"]) == 0)
{
SbItem item = new SbItem(reader["NickName"].ToString(), Convert.ToInt32(reader["FaceImageID"]));
item.Tag=reader["LoginID"].ToString();
for (int i = 0; i < sbFriends.Groups[0].Items.Count; i++)
{
if (sbFriends.Groups[0].Items[i].Tag.ToString() == item.Tag.ToString())
{
break;
}
else
{
sbFriends.Groups[0].Items.Add(item);
}
}
}
else if (Convert.ToInt32(reader["FriendState"]) == 1)
{
SbItem item = new SbItem(reader["NickName"].ToString(), Convert.ToInt32(reader["FaceImageID"]));
item.Tag = reader["LoginID"].ToString();
for (int i = 0; i < sbFriends.Groups[1].Items.Count; i++)
{
if (sbFriends.Groups[1].Items[i].Tag.ToString() == item.Tag.ToString())
{
break;
}
else
{
sbFriends.Groups[1].Items.Add(item);
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
conn.Close();
}
}
我也在做...
!一看就知道北大禽鸟的!
顶个贴!