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 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(); }