private void btnXemBaiThi_Click(object sender, EventArgs e) { int viTri = bANGDIEMBindingSource.Position; if (viTri == -1) { MessageBox.Show("Chọn 1 bảng điểm để xem nhé :)"); return; } int id_bangdiem = int.Parse(((DataRowView)bANGDIEMBindingSource[viTri])["MA_BAI_THI"].ToString()); rpXemBaiThi rp = new rpXemBaiThi(id_bangdiem); if (Program.mNhom == "SINHVIEN") { rp.lbHoTen.Text = "HỌ TÊN: " + Program.mHoTen; rp.lbLop.Text = "LỚP: " + Program.tenlop; } else { String maSV = ((DataRowView)bANGDIEMBindingSource[viTri])["MASV"].ToString(); Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIM_SV '" + maSV + "'"); Program.myReader.Read(); String name = Program.myReader.GetString(1)+" "+ Program.myReader.GetString(2); String maLop = Program.myReader.GetString(5); Program.myReader.Close(); Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIMKIEM_LOP '" + maLop + "'"); Program.myReader.Read(); String lop = Program.myReader.GetString(1); Program.myReader.Close(); rp.lbHoTen.Text = "HỌ TÊN: " + name; rp.lbLop.Text = "LỚP: " + lop; } String maMonThi = ((DataRowView)bANGDIEMBindingSource[viTri])["MAMH"].ToString(); Program.myReader = Program.ExecSqlDataReader("EXEC SP_TIMKIEMMH '" + maMonThi + "'"); Program.myReader.Read(); String tenMonThi = Program.myReader.GetString(1); Program.myReader.Close(); rp.lbMonHoc.Text = "MÔN THI: " + tenMonThi; String ngayThi = ((DataRowView)bANGDIEMBindingSource[viTri])["NGAYTHI"].ToString(); rp.lbNgayThi.Text = "NGÀY THI: " + ngayThi.Substring(0, 10); String lan = ((DataRowView)bANGDIEMBindingSource[viTri])["LAN"].ToString(); rp.lbLanThi.Text = "LẦN: " + lan; ReportPrintTool print = new ReportPrintTool(rp); print.ShowPreviewDialog(); }
private void ghiBangDiemVaBaiThi() { GiaoVienDK g = GiaoVienDK.gv_dk; BangDiem bd = new BangDiem(Program.mUserId, g.MaMH, g.Lan, g.NgayThi.ToString(), tongDiem); bd.ghiDiem(); String strlenh = "EXEC SP_TIMBANGDIEM_THI '" + Program.mUserId + "', '" + g.MaMH + "', " + g.Lan; Program.myReader.Close(); Program.myReader = Program.ExecSqlDataReader(strlenh); Program.myReader.Read(); int idBangDiem = Program.myReader.GetInt32(5); Program.myReader.Close(); foreach (CT_BaiThi ct in CT_BaiThi.ct_baiThi) { bdsCT_BAITHI.AddNew(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["THUTU"] = ct.getThuTu(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["NOIDUNG"] = ct.getNoiDung(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["A"] = ct.getA().Trim(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["B"] = ct.getB().Trim(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["C"] = ct.getC().Trim(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["D"] = ct.getD().Trim(); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["DAPANDUNG"] = ct.getDapAnDung().Trim().ElementAt(0); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["DAPANDACHON"] = ct.getDapAnDaChon().Length == 0 ? ' ': ct.getDapAnDaChon().ElementAt(0); ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["MA_BAI_THI"] = idBangDiem; ((DataRowView)bdsCT_BAITHI[bdsCT_BAITHI.Position])["CAU_HOI"] = ct.getCauHoi(); bdsCT_BAITHI.EndEdit(); } try { cT_BAITHITableAdapter.Update(this.dS.CHITIETBAITHI); } catch (Exception ex) { MessageBox.Show(ex.Message); } DialogResult dialogResult = MessageBox.Show("Số câu đúng: " + soCauDung + "/" + soCauThi + "\nTổng điểm: " + tongDiem + "\nBạn có muốn xem lại bài thi?", "KẾT QUẢ", MessageBoxButtons.YesNoCancel); if (dialogResult == DialogResult.Yes) { rpXemBaiThi rp = new rpXemBaiThi(idBangDiem); rp.lbHoTen.Text = "HỌ TÊN: " + Program.mHoTen; rp.lbLop.Text = "LỚP: " + Program.tenlop; rp.lbMonHoc.Text = "MÔN THI" + this.lblMONHOC.Text; rp.lbNgayThi.Text = "NGÀY THI: " + lblNGAYTHI.Text; rp.lbLanThi.Text = "LẦN: " + g.Lan; ReportPrintTool print = new ReportPrintTool(rp); print.ShowPreviewDialog(); } else if (dialogResult == DialogResult.No) { } else if (dialogResult == DialogResult.Cancel) { } GiaoVienDK.gv_dk = null; CT_BaiThi.ct_baiThi.Clear(); BoDe.boDe.Clear(); }