private void loadListMesssMem()
{
string sqlquery = "select ThanhVien.IDThanhVien,(HoThanhVien +' ' +TenThanhVien+' - '+ right(MSSV,4)) as HoTen from ThanhVien right join TaiKhoan on TaiKhoan.IDThanhVien = ThanhVien.IDThanhVien";
DataTable dt = dalmessange.getMess(sqlquery);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (caseData.DataTam.DuLieu.ID != dt.Rows[i]["IDThanhVien"].ToString())
{
ucmessange = new GUI.uc_Messange();
ucmessange.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
ucmessange.Cursor = System.Windows.Forms.Cursors.Hand;
ucmessange.Dock = System.Windows.Forms.DockStyle.Top;
ucmessange.Location = new System.Drawing.Point(0, 0);
ucmessange.Name = "uc_Messange1" + i;
ucmessange.Size = new System.Drawing.Size(310, 61);
ucmessange.TabIndex = i;
ucmessange.lb_ChatName.Text = dt.Rows[i]["HoTen"].ToString();
string noidung = loadtitleMessMem(dt.Rows[i]["IDThanhVien"].ToString());
if (mha.IsBase64String(noidung) && noidung.Length > 200)
{
noidung = "Đã gửi 1 ảnh";
}
ucmessange.lb_NewMessage.Text = noidung;
ucmessange.Tag = dt.Rows[i]["IDThanhVien"].ToString();
ucmessange.Click += new EventHandler(ucmessangeMem_Click);
frmmessange.pn_MessList.Controls.Add(ucmessange);
}
}
}
private void loadListMesssTeam()
{
/*--------------Load nhóm---------------------*/
string sqlquery = "select * from NhomChat";
DataTable dt = dalmessange.getMess(sqlquery);
for (int i = 0; i < dt.Rows.Count; i++)
{
sqlquery = "select NoiDung,(TenThanhVien + '-' + right(MSSV,4) + ': ') as HoTen from NhomChat_TinNhan,ThanhVien where IDThanhVien = IDNguoiGui and IDTinNhan = (select Max(IDTinNhan) from NhomChat_TinNhan where NhomChat_TinNhan.IDNhomChat =" + dt.Rows[i]["IDNhom"].ToString() + ")";
ucmessange = new GUI.uc_Messange();
ucmessange.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
ucmessange.Cursor = System.Windows.Forms.Cursors.Hand;
ucmessange.Dock = System.Windows.Forms.DockStyle.Top;
ucmessange.Location = new System.Drawing.Point(0, 0);
ucmessange.Name = "uc_Messange1" + i;
ucmessange.Size = new System.Drawing.Size(310, 61);
ucmessange.TabIndex = i;
DataTable dtsend = dalmessange.getMess(sqlquery);
string noidung = dtsend.Rows[0]["NoiDung"].ToString();
noidung = noidung.Substring(noidung.Split(':')[0].Length, noidung.Length - noidung.Split(':')[0].Length);
if (mha.IsBase64String(noidung) && noidung.Length > 200)
{
noidung = "Đã gửi 1 ảnh";
}
ucmessange.lb_ChatName.Text = dt.Rows[i]["TenNhom"].ToString();
ucmessange.lb_NewMessage.Text = dtsend.Rows[0]["HoTen"].ToString() + noidung;
ucmessange.Tag = dt.Rows[i]["IDNhom"].ToString();
ucmessange.Click += new EventHandler(ucmessange_Click);
frmmessange.pn_MessList.Controls.Add(ucmessange);
}
}
