private void LoadData(string title, PhieuKhamGUI phieuKham, BenhNhan benhNhan) { //set title cho form Text = title; btnAddEdit.Text = "Cập nhật"; // load data cho các textbox txtHoTen.Text = phieuKham.HoTen; txtSDT.Text = benhNhan.SoDT; txtDanToc.Text = phieuKham.DanToc; txtDiaChi.Text = phieuKham.DiaChi; txtNgaySinh.Text = phieuKham.NgaySinh.ToString("dd-MM-yyyy"); txtTienSuBenh.Text = benhNhan.TienSu; txtCMND.Text = benhNhan.SoCMND; rtbChuanDoan.Text = phieuKham.ChuanDoan; //load cbbBacSi cbbBacSi.SelectedIndex = cbbBacSi.Items.IndexOf(phieuKham.BacSi); //load cbbHinhThucKham if (benhNhan.GioiTinh.Equals("Nam")) { rdoNam.Checked = true; } else { rdoNu.Checked = true; } }
public fAddEditPhieuKham(string title, PhieuKhamGUI phieuKham, BenhNhan benhNhan) { InitializeComponent(); isNew = false; this.phieuKham = phieuKham; this.benhNhan = benhNhan; libraryService = ServiceFactory.GetLibraryService(LibraryParameter.persistancestrategy); //load data cho các textbox LoadData(title, this.phieuKham, benhNhan); LoadDanhSachBacSi(phieuKham.BacSi); LoadHinhThucKham(phieuKham.HinhThucKham); }
public List <PhieuKhamGUI> TimKiemLichSuTiepNhan(int maNV, string column, string value) { DataTable table = DataProvider.Instane.ExecuteReader("EXEC dbo.TimKiemLichSuTiepNhan @MaNV , @TruongDuLieu , @ThongTin ", new object[] { maNV, column, value }); List <PhieuKhamGUI> list = new List <PhieuKhamGUI>(); foreach (DataRow item in table.Rows) { PhieuKhamGUI phieuKhamGUI = new PhieuKhamGUI(item); list.Add(phieuKhamGUI); } return(list); }
public List <PhieuKhamGUI> LichSuTiepNhanByID(int id) { DataTable table = DataProvider.Instane.ExecuteReader("EXEC dbo.SP_LoadLichSuTiepNhanByID @MANV", new object[] { id }); List <PhieuKhamGUI> list = new List <PhieuKhamGUI>(); foreach (DataRow item in table.Rows) { PhieuKhamGUI phieuKhamGUI = new PhieuKhamGUI(item); list.Add(phieuKhamGUI); } return(list); }
/// <summary> /// hàm load danh sách phiếu khám cho fTiepNhanBenhNhan /// </summary> /// <param name="dateTime"></param> /// <returns></returns> public List <PhieuKhamGUI> DanhSachPhieuKhamGUI(DateTime dateTime) { List <PhieuKhamGUI> list = new List <PhieuKhamGUI>(); DataTable table = DataProvider.Instane.ExecuteReader("EXEC dbo.SP_DanhSachKham_fKhamBenNhan @NgayKham ", new object[] { dateTime }); foreach (DataRow row in table.Rows) { PhieuKhamGUI phieuKhamGUI = new PhieuKhamGUI(row); list.Add(phieuKhamGUI); } return(list); }
private void btnCapNhatPhieuKham_Click(object sender, EventArgs e) { if (dgvDanhSachKham.SelectedRows.Count != 0) { DataGridViewRow row = dgvDanhSachKham.SelectedRows[0]; //MessageBox.Show(row.Cells[2].Value.ToString()); PhieuKhamGUI phieuKham = listPhieuKham.Single(p => p.MaPhieuKham == (int)row.Cells[2].Value); BenhNhan benhNhan = listBenhNhan.Single(p => p.MaBN == (int)row.Cells[1].Value); fAddEditPhieuKham f = new fAddEditPhieuKham("Cập nhật phiếu khám", phieuKham, benhNhan); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { listPhieuKham = libraryService.DanhSachPhieuKhamGUI(DateTime.Now); LoadPhieuKham(listPhieuKham); } } }