public static DataTable Treedata(string noreg)
{
var dt = new DataTable();
dt.Columns.Add("EQUID", typeof(int));
dt.Columns.Add("DESEQU", typeof(string));
var parentColumn = dt.Columns.Add("PEQUID", typeof(int));
//Data Diagnosa
var dh = new dataset.yakkumdbTableAdapters.fa_rx_diagnosaTableAdapter();
var th = new dataset.yakkumdbTableAdapters.fa_rx_prosedurTableAdapter();
dt.Rows.Add(1, "Diagnosis");
DataTable ds = dh.GetDataByNoReg(noreg);
foreach (DataRow r in ds.Rows)
{
dt.Rows.Add(r["id"], r["no_urut"].ToString() + ". " + r["icd_code"].ToString() + " | " + r["icd_desc"].ToString(), 1);
}
dt.Rows.Add(2, "Procedure");
DataTable ds2 = th.GetDataByNoReg(noreg);
foreach (DataRow r in ds2.Rows)
{
dt.Rows.Add(r["id"], r["no_urut"].ToString() + ". " + r["icd_code"].ToString() + " | " + r["icd_desc"].ToString(), 2);
}
return(dt);
}
private void uc_cpyDiagClik(object sender, EventArgs e)
{
Guna.UI2.WinForms.Guna2Button usx = (Guna.UI2.WinForms.Guna2Button)sender;
//MessageBox.Show ("TAG = " + usx.Tag.ToString());
var _cpyNoReg = usx.Tag.ToString();
var dh = new dataset.yakkumdbTableAdapters.fa_rx_diagnosaTableAdapter();
var dh2 = new fa_rx_prosedurTableAdapter();
DataTable dt = dh.GetDataByNoReg(_cpyNoReg);
foreach (DataRow r in dt.Rows)
{
dh.InsertQuery(_noreg, r["icd_code"].ToString(), r["icd_desc"].ToString(), null, false, DateTime.Now);
this.view_diagnosaTableAdapter.FillbyNoReg(yakkumdb.view_diagnosa, _noreg);
this.dgvDiagnosa.Update();
this.dgvDiagnosa.Refresh();
//DataGridViewRow row = (DataGridViewRow)dgvDiagnosa.Rows[0].Clone();
//row.Cells[1].Value = r["icd_code"].ToString();
//row.Cells[2].Value = r["icd_desc"].ToString();
//dgvDiagnosa.Rows.Add(row);
}
DataTable dt2 = dh2.GetDataByNoReg(_cpyNoReg);
foreach (DataRow r in dt2.Rows)
{
dh2.InsertQuery(_noreg, r["icd_code"].ToString(), r["icd_desc"].ToString(), null, DateTime.Now);
this.view_ProcedureTableAdapter.FillNoReg(yakkumdb.view_Procedure, _noreg);
this.dgvProcedure.Update();
//DataGridViewRow row2 = (DataGridViewRow)dgvProcedure.Rows[0].Clone();
//row2.Cells[1].Value = r["icd_code"].ToString();
//row2.Cells[2].Value = r["icd_desc"].ToString();
//dgvProcedure.Rows.Add(row2);
}
}
private void insertDiagnosa()
{
var dt = new dataset.rmdbTableAdapters.diagnosa_utamaTableAdapter();
var ds = new dataset.rmdbTableAdapters.RMIcdSekunderRalanTableAdapter();
var dy = new dataset.yakkumdbTableAdapters.fa_rx_diagnosaTableAdapter();
for (int i = 0; i < dgvDiagnosa.RowCount - 1; i++)
{
if (dgvDiagnosa.Rows[i].Cells[1].Value.Equals(null))
{
}
if (i == 0)
{
dt.InsertQuery(
_noreg,
txtNoRM.Text,
dgvDiagnosa.Rows[i].Cells[2].Value.ToString(),
_kodedokter,
dgvDiagnosa.Rows[i].Cells[1].Value.ToString()
);
//insert ke database Yakkum RSE
//MessageBox.Show(dgvDiagnosa.Rows[i].Cells["idDataGridViewTextBoxColumn1"].Value.ToString());
dy.UpdateQueryNoUrut(1, true, (int)dgvDiagnosa.Rows[i].Cells["idDataGridViewTextBoxColumn1"].Value);
//dy.InsertQuery(
// _noreg,
// dgvDiagnosa.Rows[i].Cells[1].Value.ToString(),
// dgvDiagnosa.Rows[i].Cells[2].Value.ToString(),
// 1,
// true,
// DateTime.Now
// );
}
if (i > 0)
{
//insert ke database RM
ds.InsertQuery(
_noreg,
txtNoRM.Text,
dgvDiagnosa.Rows[i].Cells[1].Value.ToString(),
dgvDiagnosa.Rows[i].Cells[2].Value.ToString(),
_kodedokter,
"E-Presc"
);
//insert ke database Yakkum RSE
//MessageBox.Show(dgvDiagnosa.Rows[i].Cells[4].Value.ToString());
dy.UpdateQueryNoUrut(i + 1, false, (int)dgvDiagnosa.Rows[i].Cells["idDataGridViewTextBoxColumn1"].Value);
//dy.InsertQuery(
// _noreg,
// dgvDiagnosa.Rows[i].Cells[1].Value.ToString(),
// dgvDiagnosa.Rows[i].Cells[2].Value.ToString(),
// i+1,
// false,
// DateTime.Now
// );
}
}
}
