private void LoadTemplateRacikan() { // MessageBox.Show(_kodefornas.ToString()); var _kodetmpracikan = 0; if (_kdpng == "323") { _kodetmpracikan = 3; } else { _kodetmpracikan = 1; } var dh = new dataset.yakkumdbTableAdapters.fa_rx_template_racikanTableAdapter(); dh.FillByDist(yakkumdb.fa_rx_template_racikan, _kdokter, _kodetmpracikan); DataTable dt = dh.GetDataByDist(_kdokter, _kodetmpracikan); foreach (DataRow r in dt.Rows) { //MessageBox.Show(r["nama_template"].ToString()); Guna.UI2.WinForms.Guna2Button button = new Guna.UI2.WinForms.Guna2Button(); button.Tag = r["nid_dokter"].ToString() + r["nama_template"].ToString(); button.Text = r["nama_template"].ToString(); button.AutoRoundedCorners = true; //button.AutoSize = true; flptemRacikan.Controls.Add(button); button.Click += button_MouseCliked; } }
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"); } }