Esempio n. 1
0
        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");
            }
        }
Esempio n. 2
0
 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();
     }
 }