private void load_Template() { // TODO : _template: 0 = reguler, 1 = template, 2 = edit //MessageBox.Show("Show"); if (_template == 1) { // MessageBox.Show(_namaracikan.Substring(0, _namaracikan.Length - 3) + "0106"); var dh = new dataset.yakkumdbTableAdapters.fa_rx_template_racikanTableAdapter(); dh.FillByTempDokter(yakkumdb.fa_rx_template_racikan, _namaracikan.Substring(0, _namaracikan.Length - 3).TrimStart(), _kdokter, _kodefornas); DataTable dt = dh.GetDataByTempDokter(_namaracikan.Substring(0, _namaracikan.Length - 3).TrimStart(), _kdokter, _kdtemplateracikan); foreach (DataRow r in dt.Rows) { //MessageBox.Show(r["nama_obat"].ToString()); DataGridViewRow row = (DataGridViewRow)dgvRacik.Rows[0].Clone(); row.Cells[1].Value = r["nama_obat"].ToString(); row.Cells[2].Value = r["dosis"].ToString(); row.Cells[3].Value = r["satuan"].ToString(); row.Cells[5].Value = r["kode_obat"].ToString(); dgvRacik.Rows.Add(row); } } if (_template == 2) { var dt = new dataset.yakkumdbTableAdapters.fa_rx_racikanTableAdapter(); var dh = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); DataRow dr = dh.GetDataByRXD(_koderxd).Rows[0]; //Obat.Text = dr["vc_namaobat"].ToString(); //lblkodeobat.Text = dr["vc_kode_obat"].ToString(); txtdd1.Text = dr["nvc_dd1"].ToString(); txtdd2.Text = dr["nvc_dd2"].ToString(); txtJumlah.Text = dr["num_jml"].ToString(); txtSignalain.Text = dr["vc_signalain"].ToString(); cmbSatuanDosis.Text = dr["vc_satuan_dosis"].ToString(); cmbSatuan.Text = dr["vc_satuan"].ToString(); DataTable t = dt.GetDataByKodeRD(_koderxd); foreach (DataRow r in t.Rows) { DataGridViewRow row = (DataGridViewRow)dgvRacik.Rows[0].Clone(); row.Cells[1].Value = r["vc_nama_obat"].ToString(); row.Cells[2].Value = r["vc_dosis"].ToString(); row.Cells[3].Value = r["vc_satuan"].ToString(); row.Cells[5].Value = r["vc_k_obat"].ToString(); dgvRacik.Rows.Add(row); } } else { // MessageBox.Show("TEst"); } }
private void loaddataedit() { if (_edit == true) { var dh = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); DataRow dr = dh.GetDataByRXD(_norxd).Rows[0]; Obat.Text = dr["vc_namaobat"].ToString(); lblkodeobat.Text = dr["vc_kode_obat"].ToString(); txtdd1.Text = dr["nvc_dd1"].ToString(); txtdd2.Text = dr["nvc_dd2"].ToString(); txtJumlah.Text = dr["num_jml"].ToString(); txtSignalain.Text = dr["vc_signalain"].ToString(); cmbSatuanDosis.Text = dr["vc_satuan_dosis"].ToString(); } }