private void m_cmd_xoa_Click(object sender, EventArgs e) { try { for (int i = 0; i < m_grv_ket_qua.RowCount; i++) { US_KET_QUA_HOC_TAP v_us = new US_KET_QUA_HOC_TAP(CIPConvert.ToDecimal(m_grv_ket_qua.GetDataRow(i)["ID"].ToString())); v_us.Delete(); load_data_2_grid(CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString())); MessageBox.Show("Xóa thành công!"); } } catch { MessageBox.Show("Đã xảy ra lỗi trong hệ thống!"); } }
private void m_cbo_ky_hoc_SelectedIndexChanged_1(object sender, EventArgs e) { try { m_txt_gpa.Text = ""; m_txt_cpa.Text = ""; if (tim_kiem_diem_sinh_vien() && tim_kiem_sinh_vien()) { US_KET_QUA_HOC_TAP v_us_kq_hoc_tap = new US_KET_QUA_HOC_TAP(m_dc_id_ket_qua_hoc_tap); m_txt_gpa.Text = v_us_kq_hoc_tap.dcGPA.ToString(); m_txt_cpa.Text = v_us_kq_hoc_tap.dcCPA.ToString(); load_data_2_grid(); } } catch (Exception) { MessageBox.Show("Đã xảy ra lỗi trong hệ thống!"); } }
private void m_cmd_tim_kiem_Click(object sender, EventArgs e) { try { if (tim_kiem_sinh_vien()) { US_V_DM_SINH_VIEN v_us_sinh_vien = new US_V_DM_SINH_VIEN(m_dc_id_sinh_vien); m_txt_lop_sinh_vien.Text = v_us_sinh_vien.strLOP_SINH_VIEN; m_txt_ho_ten_sinh_vien.Text = v_us_sinh_vien.strTEN_SINH_VIEN; m_txt_khoa_hoc.Text = v_us_sinh_vien.strKHOA; m_txt_khoa_vien.Text = v_us_sinh_vien.strTEN_KHOA_VIEN; m_dat_ngay_sinh.Value = v_us_sinh_vien.datNGAY_SINH; m_txt_que_quan.Text = v_us_sinh_vien.strQUE_QUAN; m_txt_trang_thai.Text = v_us_sinh_vien.strTEN_TRANG_THAI; m_txt_so_dien_thoai.Text = v_us_sinh_vien.strSDT; if (v_us_sinh_vien.strGIOI_TINH == "N") { m_rdb_nam.Checked = true; } else { m_rdb_nu.Checked = false; } if (tim_kiem_diem_sinh_vien()) { m_txt_gpa.Text = ""; m_txt_cpa.Text = ""; US_KET_QUA_HOC_TAP v_us_kq_hoc_tap = new US_KET_QUA_HOC_TAP(m_dc_id_ket_qua_hoc_tap); m_txt_gpa.Text = v_us_kq_hoc_tap.dcGPA.ToString(); m_txt_cpa.Text = v_us_kq_hoc_tap.dcCPA.ToString(); } load_data_2_grid(); } } catch { MessageBox.Show("Đã xảy ra lỗi trong hệ thống!"); } }
private void m_cmd_ket_qua_Click(object sender, EventArgs e) { try { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); string v_str_query; if (CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString()) > -1) { v_str_query = "SELECT DISTINCT ID_SINH_VIEN FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_LOP_SINH_VIEN =" + m_cbo_lop_sinh_vien.SelectedValue.ToString(); } else { if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) > -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) > -1) { v_str_query = "SELECT DISTINCT ID_SINH_VIEN FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + " AND ID_KHOA = " + m_cbo_khoa.SelectedValue.ToString() + "AND ID_KHOA_VIEN = " + m_cbo_khoa_vien.SelectedValue.ToString(); } else if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) == -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) > -1) { v_str_query = "SELECT DISTINCT ID_SINH_VIEN FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_KHOA_VIEN = " + m_cbo_khoa_vien.SelectedValue.ToString(); } else if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) > -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) == -1) { v_str_query = "SELECT DISTINCT ID_SINH_VIEN FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_KHOA = " + m_cbo_khoa.SelectedValue.ToString(); } else { v_str_query = "SELECT DISTINCT ID_SINH_VIEN FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString(); } } v_us.FillDatasetWithQuery(v_ds, v_str_query); for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++) { //kiểm tra xem có hay không để trọn insert hoặc update US_DUNG_CHUNG v_us_check = new US_DUNG_CHUNG(); DataSet v_ds_check = new DataSet(); v_ds_check.Tables.Add(new DataTable()); string v_str_query_test = "SELECT ID FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_SINH_VIEN = " + v_ds.Tables[0].Rows[i]["ID_SINH_VIEN"].ToString(); v_us_check.FillDatasetWithQuery(v_ds_check, v_str_query_test); if (v_ds_check.Tables[0].Rows.Count == 0) { US_KET_QUA_HOC_TAP v_us_ket_qua_hoc_tap = new US_KET_QUA_HOC_TAP(); v_us_ket_qua_hoc_tap.dcID_HOC_KY = CIPConvert.ToDecimal(m_cbo_hoc_ky.SelectedValue.ToString()); v_us_ket_qua_hoc_tap.dcID_SINH_VIEN = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID_SINH_VIEN"].ToString()); v_us_ket_qua_hoc_tap.dcGPA = User.GetGPA(v_us_ket_qua_hoc_tap.dcID_SINH_VIEN, v_us_ket_qua_hoc_tap.dcID_HOC_KY); v_us_ket_qua_hoc_tap.dcCPA = User.GetCPA(v_us_ket_qua_hoc_tap.dcID_SINH_VIEN, v_us_ket_qua_hoc_tap.dcID_HOC_KY); v_us_ket_qua_hoc_tap.Insert(); } else { US_KET_QUA_HOC_TAP v_us_ket_qua_hoc_tap = new US_KET_QUA_HOC_TAP(CIPConvert.ToDecimal(v_ds_check.Tables[0].Rows[0]["ID"].ToString())); v_us_ket_qua_hoc_tap.dcID_HOC_KY = CIPConvert.ToDecimal(m_cbo_hoc_ky.SelectedValue.ToString()); v_us_ket_qua_hoc_tap.dcID_SINH_VIEN = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID_SINH_VIEN"].ToString()); v_us_ket_qua_hoc_tap.dcGPA = User.GetGPA(v_us_ket_qua_hoc_tap.dcID_SINH_VIEN, v_us_ket_qua_hoc_tap.dcID_HOC_KY); v_us_ket_qua_hoc_tap.dcCPA = User.GetCPA(v_us_ket_qua_hoc_tap.dcID_SINH_VIEN, v_us_ket_qua_hoc_tap.dcID_HOC_KY); v_us_ket_qua_hoc_tap.Update(); } } MessageBox.Show("Thành công!"); load_data_2_grid(CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString())); } catch { MessageBox.Show("Đã xảy ra lỗi trong hệ thống!"); } }