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) { } }