private void SetTDForUpdate(TestCertificate tDetail)
{
textBoxTCID.Text = tDetail.TCID.ToString();
textBoxPatientID.Text = tDetail.PatientID.ToString();
textBoxStaffID.Text = tDetail.StafID.ToString();
dateCreate.Value = tDetail.Date;
comboBoxState.SelectedIndex = tDetail.State;
DataTable dtTestType = TestType.GetListTestType();
for (int i = 0; i < dtTestType.Rows.Count; i++)
{
TestType newTestType = new TestType();
newTestType.TestTypeID = Convert.ToInt16(dtTestType.Rows[i][0]);
newTestType.TestName = dtTestType.Rows[i][1].ToString();
listTestType.Add(newTestType);
comboBoxTestType.Items.Add(newTestType.TestName);
}
comboBoxTestType.SelectedIndex = 0;
DataTable dtTestDetail = TestDetail.GetListTestDetail(tDetail.TCID);
for (int i = 0; i < dtTestDetail.Rows.Count; i++)
{
TestDetail newTD = new TestDetail();
newTD.TCID =Convert.ToInt32(dtTestDetail.Rows[i][0]);
newTD.TestTypeID = Convert.ToInt16(dtTestDetail.Rows[i][1]);
newTD.Result = dtTestDetail.Rows[i][2].ToString();
listTD.Add(newTD);
listSelectedTestType.Items.Add(dtTestDetail.Rows[i][3].ToString());
}
if (listSelectedTestType.Items.Count > 0)
listSelectedTestType.SelectedIndex = 0;
}
public static int InsertTestDetail(TestDetail newTD)
{
String sqlInsert = @"INSERT INTO TESTDETAIL(TCID, TESTTYPEID, RESULT)
VALUES (@TCID,@TESTTYPEID,@RESULT)";
SqlParameter[] sqlParameters = { new SqlParameter("@TCID", newTD.TCID),
new SqlParameter("@TESTTYPEID", newTD.TestTypeID),
new SqlParameter("@RESULT",newTD.Result)};
return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters);
}
public static int InsertTestDetail(TestDetail newTD)
{
String sqlInsert = @"INSERT INTO TESTDETAIL(TCID, TESTTYPEID, RESULT)
VALUES (@TCID,@TESTTYPEID,@RESULT)";
SqlParameter[] sqlParameters = { new SqlParameter("@TCID", newTD.TCID),
new SqlParameter("@TESTTYPEID", newTD.TestTypeID),
new SqlParameter("@RESULT", newTD.Result) };
return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters));
}
private void buttonInsert_Click(object sender, EventArgs e)
{
int selectedIndex = comboBoxTestType.SelectedIndex;
if (CheckTestType(listTestType[selectedIndex].TestTypeID))
{
MessageBox.Show("Loại xét nghiệm này đã có trong phiếu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
TestDetail newTestDetail = new TestDetail();
newTestDetail.TCID = 0;
newTestDetail.TestTypeID = listTestType[selectedIndex].TestTypeID;
newTestDetail.Result = "Chưa xét nghiệm";
listTD.Add(newTestDetail);
listSelectedTestType.Items.Add(listTestType[selectedIndex].TestName);
listSelectedTestType.SelectedIndex = listSelectedTestType.Items.Count - 1;
}
}
