private void Data_Loading(string username, string friendname) { conn.Open(); SqlCommand cmd = new SqlCommand("select * from user_info, user_friends where user_friends.username=@Username and user_friends.friend_name=@FN and user_info.username=user_friends.friend_name", conn); cmd.Parameters.Add("@Username", SqlDbType.VarChar, 50).Value = username; cmd.Parameters.Add("@FN", SqlDbType.VarChar, 50).Value = friendname; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); cmd.Dispose(); conn.Close(); l_name.Text = friendname; l_gender.Text = ds.Tables[0].Rows[0][5].ToString(); l_birthday.Text = ds.Tables[0].Rows[0][7].ToString(); l_nick.Text = ds.Tables[0].Rows[0][16].ToString(); l_sign.Text = ds.Tables[0].Rows[0][9].ToString(); bg_img.Image = CommonHandler.LoadImage(friendname, "user_background"); portrait_img.Image = CommonHandler.ChangeShape(CommonHandler.LoadImage(friendname, "user_avatar"), new Rectangle(0, 0, 75, 75), new Size(75, 75)); }
public Homepage(string name) { InitializeComponent(); username = name; conn = DatabaseHandler.conn; image = CommonHandler.ChangeShape(CommonHandler.LoadImage(username, "user_avatar"), new Rectangle(0, 0, 75, 75), new Size(75, 75)); signature = DatabaseHandler.SelectSignature(username); pictureBox1.Image = image; label1.Text = username; textBox2.Text = signature; friends = DatabaseHandler.SelectFriend(username).Copy(); UpdateTalkingList(); }
private void LoadNews() { GetReleventUser(username); Random random = new Random(); int i = random.Next(releventUsers.Count); DataTable newsTable = DatabaseHandler.SelectNews(releventUsers[i].ToString()); if (newsTable.Rows.Count > 0) { i = random.Next(newsTable.Rows.Count); DataRow news = newsTable.Rows[i]; pictureBox5.Image = CommonHandler.ChangeShape(CommonHandler.LoadImage(news[1].ToString(), "user_avatar"), new Rectangle(0, 0, 75, 75), new Size(75, 75)); label3.Text = news[1].ToString(); label4.Text = news[3].ToString(); label5.Text = news[2].ToString(); pictureBox6.Image = CommonHandler.Base64StringToImg(news[4].ToString()); } }
/// <summary> /// 更新交谈队列 /// </summary> public void UpdateTalkingList() { ArrayList contentList = new ArrayList(); imageList1.Images.Clear(); foreach (DataRow row in friends.Rows) { Image img = CommonHandler.ChangeShape(CommonHandler.ResizeImage(CommonHandler.LoadImage(row[0].ToString(), "user_avatar"), new Size(45, 45)), new Rectangle(0, 0, 45, 45), new Size(45, 45)); imageList1.Images.Add(img); string latestMsg = row[0].ToString() + " says: " + DatabaseHandler.SelectLatestMessage(row[0].ToString(), username); if (latestMsg.Length > 30) { latestMsg = latestMsg.Substring(0, 30); } contentList.Add(latestMsg); } UpdateListView(imageList1, contentList); }
/// <summary> /// 更新交谈队列 /// </summary> public void UpdateTalkingList() { ArrayList contentList = new ArrayList(); imageList1.Images.Clear(); foreach (string key in Contact.chatKey.Keys) { Image img = CommonHandler.ChangeShape(CommonHandler.ResizeImage(CommonHandler.LoadImage(key, "user_avatar"), new Size(50, 50)), new Rectangle(0, 0, 50, 50), new Size(50, 50)); imageList1.Images.Add(img); string latestMsg = key + ":\n" + DatabaseHandler.SelectLatestMessage(key, localUser); if (latestMsg.Length > 30) { latestMsg = latestMsg.Substring(0, 30) + "..."; } contentList.Add(latestMsg); } UpdateListView(imageList1, contentList); }
private void Load_imgs() { pictureBox1.Image = CommonHandler.LoadImage(username, "user_background"); pictureBox2.Image = CommonHandler.LoadImage(username, "user_avatar"); pictureBox2.Image = CommonHandler.ChangeShape(CommonHandler.ResizeImage(pictureBox2.Image, new Size(75, 75)), new Rectangle(0, 0, 75, 75), new Size(75, 75)); }