private void guna2GradientButton1_Click(object sender, EventArgs e) { var dh = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); dh.Fill(yakkumdb.fa_rx_resep_d); var sc = dh.ScalarQueryNoRacikan(lblKodeRtx.Text).ToString(); var cs = Int32.Parse(sc) + 1; var _koderacikan = "RC" + _noreg + _kdokter + cs.ToString("00000"); var _namaracikan = "Racikan " + cs.ToString("00"); var nu = dh.ScalarQueryMaxNoUrutResep(lblKodeRtx.Text).ToString(); var nurs = int.Parse(nu) + 1; var temp = 0; // MessageBox.Show(nurs.ToString()); Racikan rc = new Racikan(0, _kodefornas, _namaracikan, _koderacikan, lblKodeRtx.Text, cs.ToString(), _kdokter, nurs, temp); var result = rc.ShowDialog(); if (result == DialogResult.OK) { this.view_resepTableAdapter.Fill(this.yakkumdb.view_resep, lblKodeRtx.Text); bs_view_resep.Filter = "vc_kode_rx = '" + lblKodeRtx.Text + "'"; dgvResep.Update(); dgvResep.Refresh(); } }
private void txtCariObat_KeyDown(object sender, KeyEventArgs e) { // TODO : Cek Retensi dari Sini if (e.KeyCode == Keys.Enter) { List <string> daftarobat = new List <string>(); var dh = new dataset.yakkumdbTableAdapters.view_rse_fa_obatTableAdapter(); var _resepdetail = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); dh.Fill(yakkumdb.view_rse_fa_obat); DataTable dt = dh.GetData(); foreach (DataRow r in dt.Rows) { daftarobat.Add(r.Field <string>(4)); } _listobat = daftarobat.ToArray(); _resepdetail.FillByNoRx(yakkumdb.fa_rx_resep_d, lblKodeRtx.Text); DataTable dta = _resepdetail.GetDataByNoRx(lblKodeRtx.Text); List <string> obatdiresep = new List <string>(); foreach (DataRow rs in dta.Rows) { obatdiresep.Add(rs.Field <string>(1)); } _listobatdetil = obatdiresep.ToArray(); if (_listobat.Contains(txtCariObat.Text.ToUpper()) == false) { MessageBox.Show("Pastikan Nama Obat Sesuai !!", "Important Message"); } //else if (_listobatdetil.Contains(txtCariObat.Text.ToUpper()) == false) //{ MessageBox.Show("Obat Sudah Berada di Resep, Edit untuk melakukan perubahan."); } else { var _maxno = (int)_resepdetail.ScalarQueryMaxNoUrutResep(lblKodeRtx.Text) + 1; //MessageBox.Show(_maxno.ToString()); _kodeobat = txtCariObat.Text; dosis ds = new dosis(_kodeobat, lblKodeRtx.Text, _kdokter, _maxno, _kodefornas, "", false); var result = ds.ShowDialog(); if (result == DialogResult.OK) { this.view_resepTableAdapter.Fill(this.yakkumdb.view_resep, lblKodeRtx.Text); bs_view_resep.Filter = "vc_kode_rx = '" + lblKodeRtx.Text + "'"; dgvResep.Update(); dgvResep.Refresh(); } } } }
private void button_MouseCliked(object sender, EventArgs e) { Guna.UI2.WinForms.Guna2Button us = (Guna.UI2.WinForms.Guna2Button)sender; var _filter = us.Tag.ToString(); var dh = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); dh.Fill(yakkumdb.fa_rx_resep_d); var sc = dh.ScalarQueryNoRacikan(lblKodeRtx.Text).ToString(); var cs = Int32.Parse(sc) + 1; var _koderacikan = "RC" + _noreg + _kdokter + cs.ToString("00000"); var _namaracikan = _filter.ToString().Substring(4) + " " + cs.ToString("00"); var nu = dh.ScalarQueryMaxNoUrutResep(lblKodeRtx.Text).ToString(); var nurs = int.Parse(nu) + 1; int temp = 1; var kdtemplateracikan = 0; if (_kdpng == "323") { kdtemplateracikan = 3; } else { kdtemplateracikan = 1; } //Racikan rc = new Racikan(_kodefornas, _namaracikan, _koderacikan, lblKodeRtx.Text, cs.ToString(), _kdokter, nurs,temp); Racikan rc = new Racikan(kdtemplateracikan, _kodefornas, _namaracikan, _koderacikan, lblKodeRtx.Text, cs.ToString(), _kdokter, nurs, temp); var result = rc.ShowDialog(); if (result == DialogResult.OK) { this.view_resepTableAdapter.Fill(this.yakkumdb.view_resep, lblKodeRtx.Text); bs_view_resep.Filter = "vc_kode_rx = '" + lblKodeRtx.Text + "'"; dgvResep.Update(); dgvResep.Refresh(); } }
private void uc_cpyResepClik(object sender, EventArgs e) { Guna.UI2.WinForms.Guna2Button us = (Guna.UI2.WinForms.Guna2Button)sender; var _cpyNoResep = us.Tag.ToString(); //MessageBox.Show(_cpyNoResep); var dh = new dataset.yakkumdbTableAdapters.fa_rx_resep_dTableAdapter(); var dt = new dataset.yakkumdbTableAdapters.fa_rx_racikanTableAdapter(); DataTable ds = dh.GetDataByKodeRXonlyRX(_cpyNoResep); foreach (DataRow r in ds.Rows) { var nu = (int)dh.ScalarQueryMaxNoUrutResep(lblKodeRtx.Text) + 1; var sc = (int)dh.ScalarQueryNoRacikan(lblKodeRtx.Text) + 1; var _koderacikan = "RC" + _noreg + _kdokter + sc.ToString("00000"); //MessageBox.Show(_koderacikan); if ((Boolean)r["bt_racikan"] == true) { dh.InsertQuery (lblKodeRtx.Text, _koderacikan, "999999", sc.ToString(), true, r["vc_signalain"].ToString(), (Boolean)r["bt_iter"], (Decimal)r["num_jmliter"], (Boolean)r["bt_fav"], (Decimal)r["num_jml"], _kdokter, nu, r["nvc_dd1"].ToString(), r["nvc_dd2"].ToString(), r["vc_satuan"].ToString(), r["vc_nama_obat"].ToString(), r["vc_satuan_dosis"].ToString() ); DataTable tt = dt.GetDataByKodeRD(r["vc_kode_rx_d"].ToString()); foreach (DataRow t in tt.Rows) { dt.InsertQuery( _koderacikan, (int)t["in_no_urut"], t["vc_k_obat"].ToString(), t["vc_nama_obat"].ToString(), t["vc_dosis"].ToString(), t["vc_satuan"].ToString() ); } } else { dh.InsertQuery (lblKodeRtx.Text, lblKodeRtx.Text + r["vc_kode_obat"].ToString(), r["vc_kode_obat"].ToString(), "", false, r["vc_signalain"].ToString(), (Boolean)r["bt_iter"], (Decimal)r["num_jmliter"], (Boolean)r["bt_fav"], (Decimal)r["num_jml"], _kdokter, nu, r["nvc_dd1"].ToString(), r["nvc_dd2"].ToString(), r["vc_satuan"].ToString(), r["vc_nama_obat"].ToString(), r["vc_satuan_dosis"].ToString() ); } } this.view_resepTableAdapter.Fill(this.yakkumdb.view_resep, lblKodeRtx.Text); bs_view_resep.Filter = "vc_kode_rx = '" + lblKodeRtx.Text + "'"; dgvResep.Update(); dgvResep.Refresh(); hrclose(); //AddData ef = new AddData(_filter, _kodeKlinik, _kodeDokter) { Dock = DockStyle.Fill, TopLevel = false, TopMost = true }; //this.Controls.Clear(); //this.Controls.Add(ef); //ef.Show(); }