private void Load_portrait()
{
var bytes = DatabaseHandler.SelectPicture(l_name.Text, "user_avatar");
Image img = Image.FromStream(new MemoryStream(bytes));
portrait.Image = CommonHandler.ChangeShape(img, new Rectangle(0, 0, 75, 75), new Size(75, 75));
}
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));
}
private void PictureBox2_DoubleClick(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Image|*.jpg;*.png";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
pictureBox2.Image = CommonHandler.ResizeImage(Image.FromFile(openFileDialog.FileName), new Size(75, 75));
DatabaseHandler.UpdatePicture(username, CommonHandler.ImgToBase64String(pictureBox2.Image), "user_avatar");
pictureBox2.Image = CommonHandler.ChangeShape(pictureBox2.Image, 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));
}
