static QuyDinhInfo LayThongTinTruong()
{
QuyDinhInfo m_Truong = new QuyDinhInfo();
DataService dS = new DataService();
dS.Load(new SqlCommand("SELECT TenTruong, DiaChiTruong FROM QUYDINH"));
if (dS.Rows.Count > 0)
{
m_Truong.TenTruong = dS.Rows[0]["TenTruong"].ToString();
m_Truong.DiaChiTruong = dS.Rows[0]["DiaChiTruong"].ToString();
}
return(m_Truong);
}
private void btnXemTatCa_Click(object sender, EventArgs e)
{
IList <LopInfo> lop = LopCtrl.LayDsLop();
IList <ReportParameter> param = new List <ReportParameter>();
QuyDinhInfo m_ThongTinTruong = QuyDinh.LayThongTinTruong();
param.Add(new ReportParameter("TenTruong", m_ThongTinTruong.TenTruong));
param.Add(new ReportParameter("DiaChiTruong", m_ThongTinTruong.DiaChiTruong));
param.Add(new ReportParameter("NgayLap", DateTime.Today.Day + "/" + DateTime.Today.Month + "/" + DateTime.Today.Year));
param.Add(new ReportParameter("NamHoc", "Tất cả"));
this.reportViewerDSLop.LocalReport.SetParameters(param);
this.bSDSLop.DataSource = lop;
this.reportViewerDSLop.RefreshReport();
}
private void frptDanhSachGiaoVien_Load(object sender, EventArgs e)
{
IList <ReportParameter> param = new List <ReportParameter>();
QuyDinhInfo m_ThongTinTruong = QuyDinh.LayThongTinTruong();
param.Add(new ReportParameter("TenTruong", m_ThongTinTruong.TenTruong));
param.Add(new ReportParameter("DiaChiTruong", m_ThongTinTruong.DiaChiTruong));
param.Add(new ReportParameter("NgayLap", DateTime.Today.Day + "/" + DateTime.Today.Month + "/" + DateTime.Today.Year));
this.reportViewerDSGV.LocalReport.SetParameters(param);
IList <GiaoVienInfo> giaovien = GiaoVienCtrl.LayDsGiaoVien();
this.bSDSGiaoVien.DataSource = giaovien;
this.reportViewerDSGV.RefreshReport();
}
private void frptDanhSachHocSinh_Load(object sender, EventArgs e)
{
IList <ReportParameter> param = new List <ReportParameter>();
QuyDinhInfo m_ThongTinTruong = QuyDinh.LayThongTinTruong();
param.Add(new ReportParameter("TenTruong", m_ThongTinTruong.TenTruong));
param.Add(new ReportParameter("DiaChiTruong", m_ThongTinTruong.DiaChiTruong));
param.Add(new ReportParameter("NgayLap", DateTime.Today.Day + "/" + DateTime.Today.Month + "/" + DateTime.Today.Year));
this.reportViewerDSHS.LocalReport.SetParameters(param);
IList <HocSinhInfo> hocsinh = HocSinhCtrl.LayDsHocSinh();
this.bSDSHocSinh.DataSource = hocsinh;
this.reportViewerDSHS.RefreshReport();
}
//Click event
private void btnXem_Click(object sender, EventArgs e)
{
IList <KQHocKyMonHocInfo> KQHKMH = KQHocKyMonHocCtrl.LayDsKQHocKyMonHoc(cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbHocKy.SelectedValue.ToString(), cmbNamHoc.SelectedValue.ToString());
IList <ReportParameter> param = new List <ReportParameter>();
QuyDinhInfo m_ThongTinTruong = QuyDinh.LayThongTinTruong();
param.Add(new ReportParameter("TenTruong", m_ThongTinTruong.TenTruong));
param.Add(new ReportParameter("DiaChiTruong", m_ThongTinTruong.DiaChiTruong));
param.Add(new ReportParameter("NamHoc", cmbNamHoc.SelectedValue.ToString()));
param.Add(new ReportParameter("Lop", cmbLop.SelectedValue.ToString()));
param.Add(new ReportParameter("MonHoc", cmbMonHoc.SelectedValue.ToString()));
param.Add(new ReportParameter("HocKy", cmbHocKy.SelectedValue.ToString()));
param.Add(new ReportParameter("NgayLap", DateTime.Today.Day + "/" + DateTime.Today.Month + "/" + DateTime.Today.Year));
this.reportViewerKQHKMH.LocalReport.SetParameters(param);
this.bSKQHKMH.DataSource = KQHKMH;
this.reportViewerKQHKMH.RefreshReport();
}
