//查询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();
            }
        }