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