private void gridDSBN_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
try
{
string ID = gridDanhsachbenhnhan.GetRowCellValue(e.RowHandle, "MABENHNHAN").ToString();
cBenhNhanDO infor = BUS.cBenhanBUS.GetThongtinbenhan(ID);
lblMaBenhNhan.Text = gridDanhsachbenhnhan.GetRowCellValue(e.RowHandle, "MABENHAN").ToString();
lblHoTen.Text = infor.HOTEN;
lblGioiTinh.Text = infor.GIOITINH;
lblDiaChi.Text = infor.DIACHI;
lblNgaySinh.Text = (String)(infor.NTNSBN).ToString();
lblTuoi.Text = gridDanhsachbenhnhan.GetRowCellValue(e.RowHandle, "TUOI").ToString();
EnableEditing(false);
}
catch (Exception ex)
{
}
}
public static cBenhNhanDO GetThongtinbenhan(string MABENHNHAN)
{
cBenhNhanDO ma = new cBenhNhanDO();
using (DB_HMS_Entities lst = new DB_HMS_Entities())
{
var query = (from u in lst.tbBENHNHANs
join u2 in lst.tbQUANHUYENs on u.IDQH equals u2.IDQH
join u3 in lst.tbTINHTPs on u2.IDTP equals u3.IDTP
where u.MABENHNHAN == MABENHNHAN
select new { u, u2, u3 }).First();
ma.MABENHNHAN = query.u.MABENHNHAN;
ma.HOTEN = query.u.HO + " " + query.u.TEN;
ma.DIACHI = query.u.DIACHI + " , " + query.u2.TENQH + " , " + query.u3.TENTP;
ma.GIOITINH = query.u.GIOITINH;
ma.NTNSBN = query.u.NTNSBN;
return(ma);
}
}
private void gridDSBNDKCTBS_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
try
{
lblSTT.Text = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "MABENHAN").ToString();
lblMabenhnhan.Text = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "MABENHNHAN").ToString();
lblHoTen.Text = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "HOTEN").ToString();
lblTuoi.Text = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "TUOI").ToString();
lblGioitinh.Text = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "GIOITINH").ToString();
string MABENHNHAN = gridDSBNDKCTBS.GetRowCellValue(e.RowHandle, "MABENHNHAN").ToString();
cBenhNhanDO infor = BUS.cBenhanBUS.GetThongtinbenhan(MABENHNHAN);
lblDiachi.Text = infor.DIACHI;
List <cBenhanDO> hosobenhan = BUS.cBenhanBUS.Getdsbenhan2(MABACSY, lblSTT.Text, 4);
grdHSNLTK.DataSource = hosobenhan;
}
catch (System.Exception ex)
{
}
}
