private void txtCariProsedur_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
DataGridViewRow row = (DataGridViewRow)dgvProcedure.Rows[0].Clone();
var dh = new dataset.yakkumdbTableAdapters.ICD9_CM_2011_Procedure_CodesTableAdapter();
var dh2 = new fa_rx_prosedurTableAdapter();
dh.Fill(yakkumdb.ICD9_CM_2011_Procedure_Codes, txtCariProsedur.Text);
DataTable dt = dh.GetData(txtCariProsedur.Text);
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
dh2.InsertQuery(_noreg, r["vc_code_sp"].ToString(), r["vc_long_description"].ToString(), null, DateTime.Now);
//row.Cells[1].Value = r["vc_code_sp"].ToString();
//row.Cells[2].Value = r["vc_long_description"].ToString();
}
}
else
{
dh2.InsertQuery(_noreg, "-", txtCariProsedur.Text.ToString(), null, DateTime.Now);
//row.Cells[1].Value = "-";
//row.Cells[2].Value = txtCariProsedur.Text.ToString();
}
this.view_ProcedureTableAdapter.FillNoReg(yakkumdb.view_Procedure, _noreg);
this.dgvProcedure.Update();
//dgvProcedure.Rows.Add(row);
txtCariProsedur.Clear();
}
}
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);
}
}