// update gridview private void updateGridview() { dataGridView1.Rows.Clear(); try { db.OpenConnection(); dt = db.ExecuteReader("select * from phieukham"); db.CloseConnection(); foreach (System.Data.DataRow r in dt.Rows) { string[] row = new string[6]; string tenbn; db.OpenConnection(); System.Data.DataTable temp = db.ExecuteReader("select ten from benhnhan where idBN=" + r["idBN"].ToString()); db.CloseConnection(); tenbn = temp.Rows[0][0].ToString(); row[0] = r["idPhieuKham"].ToString(); row[1] = r["idBN"].ToString(); row[2] = tenbn; row[3] = r["ngay_lap"].ToString(); row[4] = r["ten_BS"].ToString(); row[5] = r["chan_doan"].ToString(); dataGridView1.Rows.Add(row); } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void showinfo(string idbn) { try { db.OpenConnection(); string sql = "select * from benhnhan where idBN=" + idbn; dt_temp = db.ExecuteReader(sql); db.CloseConnection(); txt_hotenbn.Text = dt_temp.Rows[0]["ten"].ToString(); txt_idbn.Text = dt_temp.Rows[0]["idBN"].ToString(); txt_para.Text = dt_temp.Rows[0]["PARA"].ToString(); txt_sdtbn.Text = dt_temp.Rows[0]["phone_num"].ToString(); txt_tiencanbn.Text = dt_temp.Rows[0]["tiencan_bt"].ToString(); txt_tiencangd.Text = dt_temp.Rows[0]["tiencan_gd"].ToString(); txt_tuoibn.Text = dt_temp.Rows[0]["tuoi"].ToString(); txt_diachibn.Text = dt_temp.Rows[0]["address"].ToString(); txt_nghenghiep.Text = dt_temp.Rows[0]["nghe_nghiep"].ToString(); } catch (System.Exception) { return; } }
// // Update datagridview danh sách các loại thuốc // public void update_gridview_dsthuoc(string query) { dtgv_dsthuoc.Rows.Clear(); btn_edit.Enabled = false; try { db.OpenConnection(); dsthuoc = db.ExecuteReader(query); foreach (DataRow row in dsthuoc.Rows) { dtgv_dsthuoc.Rows.Add(row.ItemArray); } db.CloseConnection(); if (dtgv_dsthuoc.Rows.Count > 0) { txt_tenthuoc.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["tenthuoc"].Value.ToString(); txt_dvt.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["dvt"].Value.ToString(); txt_giamua.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["giamua"].Value.ToString(); txt_giaban.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["giaban"].Value.ToString(); txt_hsd.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["hsd"].Value.ToString(); txt_soluong.Text = dtgv_dsthuoc.Rows[dtgv_dsthuoc.SelectedRows[0].Index].Cells["soluong"].Value.ToString(); btn_edit.Enabled = true; } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } if (dtgv_dsthuoc.SelectedRows.Count > 0) { btn_xoa.Enabled = true; } else { btn_xoa.Enabled = false; } }
// // Update gridview danh sách bệnh nhân // public bool updateGridView_dscho() { dtgv_dsbn.Rows.Clear(); try { db.OpenConnection(); string sql = "select * from danhsachcho where sieuam like '.%'"; dt_dscho = db.ExecuteReader(sql); foreach (System.Data.DataRow row in dt_dscho.Rows) { string stt = row["stt"].ToString(); string id = row["idBN"].ToString(); sql = "select * from benhnhan where idBN=" + id; dt_temp = db.ExecuteReader(sql); string[] bn = new string[8]; bn[0] = stt; for (int i = 0; i < 7; i++) { bn[i + 1] = dt_temp.Rows[0][i].ToString(); } dtgv_dsbn.Rows.Add(bn); } db.CloseConnection(); try { txt_hotenbn.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["hoten"].Value.ToString(); txt_diachibn.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["diachi"].Value.ToString(); txt_idbn.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["id"].Value.ToString(); txt_nghenghiep.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["nghenghiep"].Value.ToString(); txt_para.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["para"].Value.ToString(); txt_sdtbn.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["sdt"].Value.ToString(); txt_tuoibn.Text = dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["tuoi"].Value.ToString(); db.OpenConnection(); sql = "select * from benhnhan where idBN=" + txt_idbn.Text; dt_temp = db.ExecuteReader(sql); db.CloseConnection(); txt_tiencanbn.Text = dt_temp.Rows[0]["tiencan_bt"].ToString(); txt_tiencangd.Text = dt_temp.Rows[0]["tiencan_gd"].ToString(); btn_editphieukham.Visible = true; try { chb_sa2d.Checked = false; chb_sahth.Checked = false; chb_sam.Checked = false; chb_sanad.Checked = false; db.OpenConnection(); System.Data.DataTable t = db.ExecuteReader("select sieuam from danhsachcho where stt=" + dtgv_dsbn.Rows[dtgv_dsbn.SelectedRows[0].Index].Cells["stt"].Value.ToString()); db.CloseConnection(); string d = t.Rows[0][0].ToString(); string v = d.Trim('.'); string[] r = v.Split('-'); foreach (string s in r) { if (s == "Thai 2D") { chb_sa2d.Checked = true; } if (s == "Ngã âm đạo") { chb_sanad.Checked = true; } if (s == "Hình thái học") { chb_sahth.Checked = true; } if (s == "Màu") { chb_sam.Checked = true; } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } } catch { return(false); } return(true); } catch (System.Exception ex) { MessageBox.Show(ex.Message); return(false); } }