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