// Report Thong Ke RenLuyen public frmReport(string maSV, string hoTen, string maLop, string namHoc, int hocKy, string tongDiem, string xepLoai) { InitializeComponent(); RenLuyenBUS rlBUS = new RenLuyenBUS(); ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "dsRenLuyen_By_MSSV"; reportDataSource.Value = rlBUS.getHDRLByMaSV_NamHoc_HocKy(maSV, namHoc, hocKy); reportViewer1.LocalReport.DataSources.Add(reportDataSource); this.reportViewer1.LocalReport.ReportEmbeddedResource = "GUI.ReportViews.rpRenLuyen_By_MSSV.rdlc"; ReportParameter[] rp = new ReportParameter[7]; rp[0] = new ReportParameter("MaSV", maSV); rp[1] = new ReportParameter("HoTen", hoTen); rp[2] = new ReportParameter("NamHoc", namHoc); rp[3] = new ReportParameter("HocKy", hocKy.ToString()); rp[4] = new ReportParameter("TongDiem", tongDiem); rp[5] = new ReportParameter("XepLoai", xepLoai); rp[6] = new ReportParameter("MaLop", maLop); reportViewer1.LocalReport.SetParameters(rp); }
private void TimThongTin() { var sv = svBUS.getSVTheoMaSV(this.txtNhapMSSV.Text); if (sv.Count == 0) { MessageBox.Show("Không tìm thấy SINH VIÊN.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { // Can use btnReload btnReport this.btnReLoad.Enabled = true; this.btnIn.Enabled = true; this.txtMSSV.Text = sv[0].MaSV; this.txtHoTen.Text = sv[0].HoTen; this.txtNgaySinh.Text = sv[0].NgaySinh.ToString(); this.txtDiaChi.Text = sv[0].DiaChi; this.txtGioiTinh.Text = sv[0].GioiTinh; this.txtDanToc.Text = sv[0].DanToc; this.txtQueQuan.Text = sv[0].QueQuan; this.txtLop.Text = sv[0].MaLop; if (ktButton == 7) { this.dgcTK_HoatDong.DataSource = ctxhBUS.getHDCTXHByMaSV(this.txtNhapMSSV.Text); int?tong = dsCTXHBUS.getTongDiemHDCTXHByMaSV(this.txtMSSV.Text)[0]; this.txtTong.Text = tong == null ? "0" : tong.ToString(); } else { if (ktButton == 8) { this.dgcTK_HoatDong.DataSource = rlBUS.getHDRLByMaSV_NamHoc_HocKy(this.txtNhapMSSV.Text, this.cbbNamHoc.SelectedValue.ToString(), Convert.ToInt32(this.cbbHocKy.SelectedValue.ToString())); int?tongDRL = 0; int?diemCong = dsRLBUS.getTongDiemCongRLByMaSV_NamHoc_HocKy(this.txtMSSV.Text, this.cbbNamHoc.SelectedValue.ToString(), Convert.ToInt32(this.cbbHocKy.SelectedValue.ToString()))[0]; if (diemCong != null) { tongDRL += diemCong; } int?diemTru = dsRLBUS.getTongDiemTruRLByMaSV_NamHoc_HocKy(this.txtMSSV.Text, this.cbbNamHoc.SelectedValue.ToString(), Convert.ToInt32(this.cbbHocKy.SelectedValue.ToString()))[0]; if (diemTru != null) { tongDRL -= diemTru; } this.txtTong.Text = tongDRL.ToString(); if (tongDRL >= 90) { this.txtXLRL.Text = "Xuất sắc"; } else { if (tongDRL >= 80) { this.txtXLRL.Text = "Tốt"; } else { if (tongDRL >= 70) { this.txtXLRL.Text = "Khá"; } else { if (tongDRL >= 50) { this.txtXLRL.Text = "Trung Bình"; } else { this.txtXLRL.Text = "Yếu"; } } } } } else { if (ktButton == 12) { this.dgcTK_HoatDong.DataSource = hpBUS.getHPByMaSV(this.txtNhapMSSV.Text); this.txtTong.Text = hpBUS.getTongNoHPByMaSV(this.txtNhapMSSV.Text)[0].ToString() == "" ? "0" : hpBUS.getTongNoHPByMaSV(this.txtNhapMSSV.Text)[0].ToString(); } else { this.dgcTK_HoatDong.DataSource = vpBUS.getVPByMaSV(this.txtNhapMSSV.Text); } } } } this.txtNhapMSSV.SelectAll(); }