private void TimKiem()
{
if (svBUS.getSVTheoMaSV(this.txtMSSV.Text).Count != 0)
{
this.dgcDSHP.DataSource = dtBUS.getDiemTheoMSSV(this.txtMSSV.Text);
}
else
{
MessageBox.Show("MÃ SINH VIÊN không tồn tại.", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.btnSua.Enabled = true;
this.txtMSSV.Focus();
this.txtMSSV.SelectAll();
}
// Report Thong ke HocPhi
public frmReport(string maSV, string tb, string tbTL, string soTCTL, string xepLoai)
{
InitializeComponent();
DIemThiBUS dtBUS = new DIemThiBUS();
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "dsDiemThi_By_MSSV";
reportDataSource.Value = dtBUS.getDiemTheoMSSV(maSV);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpDSDiemThiTheoSinhVien.rdlc";
ReportParameter[] rp = new ReportParameter[4];
rp[0] = new ReportParameter("TB", tb);
rp[1] = new ReportParameter("TBTL", tbTL);
rp[2] = new ReportParameter("SoTCTL", soTCTL);
rp[3] = new ReportParameter("XepLoai", xepLoai);
reportViewer1.LocalReport.SetParameters(rp);
}
private void TimThongTin()
{
var listDiemThi = dtBUS.getDiemTheoMSSV(this.txtNhapMSSV.Text);
if (listDiemThi.Count == 0)
{
MessageBox.Show("Không tìm thấy SINH VIÊN.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtNhapMSSV.SelectAll();
}
else
{
this.btnReLoad.Enabled = true;
this.btnInBangDiem.Enabled = true;
this.dgcBangDiemSV.DataSource = listDiemThi;
this.txtMSSV.Text = listDiemThi[0].MaSV;
this.txtHoTen.Text = listDiemThi[0].HoTen;
this.txtNgaySinh.Text = listDiemThi[0].NgaySinh.ToString();
this.txtDiaChi.Text = listDiemThi[0].DiaChi;
this.txtGioiTinh.Text = listDiemThi[0].GioiTinh;
this.txtDanToc.Text = listDiemThi[0].DanToc;
this.txtQueQuan.Text = listDiemThi[0].QueQuan;
this.txtLop.Text = listDiemThi[0].MaLop;
int? soTCTL = svBUS.getDiemTBTL_SoTCTL(this.txtMSSV.Text)[0].SoTCTL;
double tbTL = Convert.ToDouble(svBUS.getDiemTBTL_SoTCTL(this.txtMSSV.Text)[0].DTBTL);
this.txtTBTichLuy.Text = Math.Round(tbTL, 2).ToString();
this.txtSoTCTichLuy.Text = soTCTL.ToString();
double tb = Convert.ToDouble(svBUS.getDiemTB_SoTC(this.txtMSSV.Text)[0].DTB);
int? soTC = svBUS.getDiemTB_SoTC(this.txtMSSV.Text)[0].SoTC;
this.txtTBToanKhoa.Text = Math.Round(tb, 2).ToString();
if (tbTL >= 8.5)
{
this.txtXLHL.Text = "Giỏi";
}
else
{
if (tbTL >= 7)
{
this.txtXLHL.Text = "Khá";
}
else
{
if (tbTL >= 5)
{
this.txtXLHL.Text = "Trung Bình";
}
else
{
if (tbTL >= 3.5)
{
this.txtXLHL.Text = "Yếu";
}
else
{
this.txtXLHL.Text = "Kém";
}
}
}
}
}
}