public FormECDetail(ExaminationCertificate ecDetail, String userAction, int staffID) { InitializeComponent(); this.ECDetail = ecDetail; this.UserAction = userAction; SetECDetail(ecDetail, staffID); }
public static int UpdateEC(ExaminationCertificate updateEC) { string sqlUpdate = @"UPDATE EXAMINATIONCERTIFICATE SET DATE =@DATE, RESULT =@RESULT, STATE =@STATE WHERE ECID=@ECID "; SqlParameter[] sqlParameters = { new SqlParameter("@ECID", updateEC.ECID ), new SqlParameter("@DATE",updateEC.Date), new SqlParameter("@RESULT", updateEC.Result), new SqlParameter("STATE", updateEC.State)}; return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters); }
public static int InsertEC(ExaminationCertificate newEC) { String sqlInsert = @"INSERT INTO EXAMINATIONCERTIFICATE(PATIENTID, STAFFID, DATE, RESULT, STATE) VALUES (@PATIENTID,@STAFFID,@DATE,@RESULT,@STATE)"; SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newEC.PatientID), new SqlParameter("@STAFFID", newEC.StaffID), new SqlParameter("@DATE", newEC.Date), new SqlParameter("@RESULT", newEC.Result), new SqlParameter("@STATE",newEC.State)}; return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters); }
//This method is for update private void SetECDetail(ExaminationCertificate ecDetail) { textBoxECID.Text = ecDetail.ECID.ToString(); ; textBoxPatientID.Text = ecDetail.PatientID.ToString(); textBoxStaffID.Text = ecDetail.StaffID.ToString(); dateCreate.Value = ecDetail.Date; textBoxResult.Text = ecDetail.Result; textBoxResult.Enabled = false; comboBoxState.Enabled = false; comboBoxState.SelectedIndex = ecDetail.State; }
public static int UpdateEC(ExaminationCertificate updateEC) { string sqlUpdate = @"UPDATE EXAMINATIONCERTIFICATE SET DATE =@DATE, RESULT =@RESULT, STATE =@STATE WHERE ECID=@ECID "; SqlParameter[] sqlParameters = { new SqlParameter("@ECID", updateEC.ECID), new SqlParameter("@DATE", updateEC.Date), new SqlParameter("@RESULT", updateEC.Result), new SqlParameter("STATE", updateEC.State) }; return(SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters)); }
public static int InsertEC(ExaminationCertificate newEC) { String sqlInsert = @"INSERT INTO EXAMINATIONCERTIFICATE(PATIENTID, STAFFID, DATE, RESULT, STATE) VALUES (@PATIENTID,@STAFFID,@DATE,@RESULT,@STATE)"; SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newEC.PatientID), new SqlParameter("@STAFFID", newEC.StaffID), new SqlParameter("@DATE", newEC.Date), new SqlParameter("@RESULT", newEC.Result), new SqlParameter("@STATE", newEC.State) }; return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters)); }
public static ExaminationCertificate GetEC(int eCID) { ExaminationCertificate newEC = new ExaminationCertificate(); string sqlSelect = @"SELECT ECID, PATIENTID, STAFFID, DATE, RESULT, STATE FROM EXAMINATIONCERTIFICATE WHERE ECID=@ECID"; SqlParameter[] sqlParameters = { new SqlParameter("@ECID", eCID) }; DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters); if (dataTable.Rows.Count > 0) { newEC.ECID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.PatientID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.StaffID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.Date = (DateTime)dataTable.Rows[0][3]; newEC.Result = (String)dataTable.Rows[0][4]; newEC.State = (int)dataTable.Rows[0][5]; } return newEC; }
public static ExaminationCertificate GetEC(int eCID) { ExaminationCertificate newEC = new ExaminationCertificate(); string sqlSelect = @"SELECT ECID, PATIENTID, STAFFID, DATE, RESULT, STATE FROM EXAMINATIONCERTIFICATE WHERE ECID=@ECID"; SqlParameter[] sqlParameters = { new SqlParameter("@ECID", eCID) }; DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters); if (dataTable.Rows.Count > 0) { newEC.ECID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.PatientID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.StaffID = Convert.ToInt32(dataTable.Rows[0][0]); newEC.Date = (DateTime)dataTable.Rows[0][3]; newEC.Result = (String)dataTable.Rows[0][4]; newEC.State = (int)dataTable.Rows[0][5]; } return(newEC); }
private void buttonOk_Click(object sender, System.EventArgs e) { try { if (!superValidator1.Validate()) { return; } if (this.UserAction.Equals("edit")) { ExaminationCertificate newEC = new ExaminationCertificate(); newEC = this.ECDetail; newEC.Result = textBoxResult.Text; newEC.State = comboBoxState.SelectedIndex; newEC.Date = dateCreate.Value; DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin phiếu khám bệnh", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogResult == DialogResult.Yes) { if (ExaminationCertificate.UpdateEC(newEC) > 0) MessageBox.Show("Cập nhập thông tin phiếu khám bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (this.UserAction == "updateResult") { ExaminationCertificate newEC = new ExaminationCertificate(); newEC.ECID = Convert.ToInt32(textBoxECID.Text); newEC.PatientID = Convert.ToInt32(textBoxPatientID.Text); newEC.StaffID = Convert.ToInt32(textBoxStaffID.Text); newEC.State = 1; newEC.Date = dateCreate.Value; newEC.Result = textBoxResult.Text; if (ExaminationCertificate.UpdateEC(newEC) > 0) MessageBox.Show("Cập nhập kết quả khám bệnh thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { ExaminationCertificate newEC = new ExaminationCertificate(); newEC.ECID = 0; newEC.PatientID = Convert.ToInt32(textBoxPatientID.Text); newEC.StaffID = Convert.ToInt32(textBoxStaffID.Text); newEC.State = comboBoxState.SelectedIndex; newEC.Date = dateCreate.Value; newEC.Result = textBoxResult.Text; if (ExaminationCertificate.InsertEC(newEC) > 0) { FormReport reportForm = new FormReport(); reportForm.ReportType = "EC"; reportForm.ObjectID = ExaminationCertificate.GetCurrentECID(); reportForm.ShowDialog(); int patientID = newEC.PatientID; //Current user int staffID = LoginStaff.StaffID; Bill newBill = new Bill(Bill.SERVICEBILL, patientID, staffID); FormBillDetail billDetailForm = new FormBillDetail("insertExamination", newBill); billDetailForm.ShowDialog(); } } } catch { MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Close(); }