public FormHCDetail(HospitalizationCertificate hcDetail, String userAction) { InitializeComponent(); this.HCDetail = hcDetail; this.UserAction = userAction; SetHCDetail(hcDetail); }
public static int InsertHC(HospitalizationCertificate newHC) { String sqlInsert = @"INSERT INTO HOSPITALIZATIONCERTIFICATE(PATIENTID, STAFFID, REASON, DATE, STATE) VALUES (@PATIENTID,@STAFFID,@REASON,@DATE,@STATE)"; SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHC.PatientID), new SqlParameter("@STAFFID", newHC.StaffID), new SqlParameter("@REASON", newHC.Reason), new SqlParameter("@DATE", newHC.Date), new SqlParameter("@STATE", newHC.State)}; return SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters); }
private void SetHCDetail(HospitalizationCertificate hcDetail) { textBoxHCID.Text = hcDetail.HCID.ToString(); textBoxStaffID.Text = hcDetail.StaffID.ToString(); textBoxPatientID.Text = hcDetail.PatientID.ToString(); textBoxReason.Text = hcDetail.Reason; dateHospitalizate.Value = hcDetail.Date; comboBoxState.SelectedIndex = hcDetail.State; comboBoxState.Enabled = false; }
public static int InsertHC(HospitalizationCertificate newHC) { String sqlInsert = @"INSERT INTO HOSPITALIZATIONCERTIFICATE(PATIENTID, STAFFID, REASON, DATE, STATE) VALUES (@PATIENTID,@STAFFID,@REASON,@DATE,@STATE)"; SqlParameter[] sqlParameters = { new SqlParameter("@PATIENTID", newHC.PatientID), new SqlParameter("@STAFFID", newHC.StaffID), new SqlParameter("@REASON", newHC.Reason), new SqlParameter("@DATE", newHC.Date), new SqlParameter("@STATE", newHC.State) }; return(SqlResult.ExecuteNonQuery(sqlInsert, sqlParameters)); }
public static int UpdateHC(HospitalizationCertificate updateHC) { string sqlUpdate = @"UPDATE HOSPITALIZATIONCERTIFICATE SET PATIENTID =@PATIENTID, STAFFID =@STAFFID, REASON =@REASON, DATE =@DATE, STATE =@STATE WHERE HCID=@HCID "; SqlParameter[] sqlParameters = { new SqlParameter("@HCID", updateHC.HCID ), new SqlParameter("@PATIENTID", updateHC.PatientID), new SqlParameter("@STAFFID", updateHC.StaffID), new SqlParameter("@REASON", updateHC.Reason), new SqlParameter("@DATE", updateHC.Date), new SqlParameter("@STATE", updateHC.State)}; return SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters); }
public static int UpdateHC(HospitalizationCertificate updateHC) { string sqlUpdate = @"UPDATE HOSPITALIZATIONCERTIFICATE SET PATIENTID =@PATIENTID, STAFFID =@STAFFID, REASON =@REASON, DATE =@DATE, STATE =@STATE WHERE HCID=@HCID "; SqlParameter[] sqlParameters = { new SqlParameter("@HCID", updateHC.HCID), new SqlParameter("@PATIENTID", updateHC.PatientID), new SqlParameter("@STAFFID", updateHC.StaffID), new SqlParameter("@REASON", updateHC.Reason), new SqlParameter("@DATE", updateHC.Date), new SqlParameter("@STATE", updateHC.State) }; return(SqlResult.ExecuteNonQuery(sqlUpdate, sqlParameters)); }
public static HospitalizationCertificate GetHC(int hCID) { HospitalizationCertificate hC = new HospitalizationCertificate(); string sqlSelect = @"SELECT HCID, PATIENTID, STAFFID, REASON, DATE, STATE FROM HOSPITALIZATIONCERTIFICATE WHERE HCID=@HCID"; SqlParameter[] sqlParameters = { new SqlParameter("@HCID", hCID) }; DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters); if (dataTable.Rows.Count > 0) { hC.HCID = Convert.ToInt32(dataTable.Rows[0][0]); hC.PatientID = Convert.ToInt32(dataTable.Rows[0][1]); hC.StaffID = Convert.ToInt32(dataTable.Rows[0][2]); hC.Reason = (String)dataTable.Rows[0][3]; hC.Date = (DateTime)dataTable.Rows[0][4]; hC.State = (int)dataTable.Rows[0][5]; } return hC; }
public static HospitalizationCertificate GetHC(int hCID) { HospitalizationCertificate hC = new HospitalizationCertificate(); string sqlSelect = @"SELECT HCID, PATIENTID, STAFFID, REASON, DATE, STATE FROM HOSPITALIZATIONCERTIFICATE WHERE HCID=@HCID"; SqlParameter[] sqlParameters = { new SqlParameter("@HCID", hCID) }; DataTable dataTable = SqlResult.ExecuteQuery(sqlSelect, sqlParameters); if (dataTable.Rows.Count > 0) { hC.HCID = Convert.ToInt32(dataTable.Rows[0][0]); hC.PatientID = Convert.ToInt32(dataTable.Rows[0][1]); hC.StaffID = Convert.ToInt32(dataTable.Rows[0][2]); hC.Reason = (String)dataTable.Rows[0][3]; hC.Date = (DateTime)dataTable.Rows[0][4]; hC.State = (int)dataTable.Rows[0][5]; } return(hC); }
private void buttonOk_Click(object sender, EventArgs e) { if (!superValidator1.Validate()) return; try { if (UserAction == "edit") { HospitalizationCertificate newHC = new HospitalizationCertificate(); newHC.HCID = int.Parse(textBoxHCID.Text); newHC.PatientID = int.Parse(textBoxPatientID.Text); newHC.StaffID = int.Parse(textBoxStaffID.Text); newHC.Reason = textBoxReason.Text; newHC.State = (int)comboBoxState.SelectedIndex; newHC.Date = dateHospitalizate.Value; DialogResult dialogResult = MessageBox.Show("Xác nhận cập nhập thông tin giấy nhập viện", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dialogResult==DialogResult.Yes) { if (HospitalizationCertificate.UpdateHC(newHC) > 0) MessageBox.Show("Cập nhập thông tin giấy nhập viện thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { if (HospitalizationCertificate.IsPatientHadHC(int.Parse(textBoxPatientID.Text))) { MessageBox.Show("Bệnh nhân đã có giấy nhập viện", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { HospitalizationCertificate newHC = new HospitalizationCertificate(); newHC.HCID = 0; newHC.PatientID = int.Parse(textBoxPatientID.Text); newHC.StaffID = int.Parse(textBoxStaffID.Text); newHC.Reason = textBoxReason.Text; newHC.State = 0; newHC.Date = dateHospitalizate.Value; if (HospitalizationCertificate.InsertHC(newHC) > 0) MessageBox.Show("Thêm giấy nhập viện thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch { MessageBox.Show("Lỗi dữ liệu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Close(); }