public static IList <KQCaNamTongHopInfo> LayDsKQCaNamTongHop(String maLop, String maNamHoc)
{
KQCaNamTongHopData m_KQCNTHData = new KQCaNamTongHopData();
DataTable m_DT = m_KQCNTHData.LayDsKQCaNamTongHopForReport(maLop, maNamHoc);
IList <KQCaNamTongHopInfo> dS = new List <KQCaNamTongHopInfo>();
foreach (DataRow Row in m_DT.Rows)
{
KQCaNamTongHopInfo ketqua = new KQCaNamTongHopInfo();
HocSinhInfo hs = new HocSinhInfo();
hs.MaHocSinh = Convert.ToString(Row["MaHocSinh"]);
hs.HoTen = Convert.ToString(Row["HoTen"]);
hs.GioiTinh = Convert.ToBoolean(Row["GioiTinh"]);
hs.NgaySinh = Convert.ToDateTime(Row["NgaySinh"]);
LopInfo l = new LopInfo();
l.MaLop = Convert.ToString(Row["MaLop"]);
l.TenLop = Convert.ToString(Row["TenLop"]);
NamHocInfo nh = new NamHocInfo();
nh.MaNamHoc = Convert.ToString(Row["MaNamHoc"]);
nh.TenNamHoc = Convert.ToString(Row["TenNamHoc"]);
HocLucInfo hl = new HocLucInfo();
hl.MaHocLuc = Convert.ToString(Row["MaHocLuc"]);
hl.TenHocLuc = Convert.ToString(Row["TenHocLuc"]);
HanhKiemInfo hkiem = new HanhKiemInfo();
hkiem.MaHanhKiem = Convert.ToString(Row["MaHanhKiem"]);
hkiem.TenHanhKiem = Convert.ToString(Row["TenHanhKiem"]);
KetQuaInfo kq = new KetQuaInfo();
kq.MaKetQua = Convert.ToString(Row["MaKetQua"]);
kq.TenKetQua = Convert.ToString(Row["TenKetQua"]);
ketqua.HocSinh = hs;
ketqua.Lop = l;
ketqua.NamHoc = nh;
ketqua.HocLuc = hl;
ketqua.HanhKiem = hkiem;
ketqua.KetQua = kq;
ketqua.DTBCaNam = Convert.ToSingle(Row["DTBCaNam"]);
dS.Add(ketqua);
}
return(dS);
}
public static IList <KQHocKyTongHopInfo> LayDsKQHocKyTongHop(String maLop, String maHocKy, String maNamHoc)
{
KQHocKyTongHopData m_KQHKTHData = new KQHocKyTongHopData();
DataTable m_DT = m_KQHKTHData.LayDsKQHocKyTongHopForReport(maLop, maHocKy, maNamHoc);
IList <KQHocKyTongHopInfo> dS = new List <KQHocKyTongHopInfo>();
foreach (DataRow Row in m_DT.Rows)
{
KQHocKyTongHopInfo ketqua = new KQHocKyTongHopInfo();
HocSinhInfo hs = new HocSinhInfo();
hs.MaHocSinh = Convert.ToString(Row["MaHocSinh"]);
hs.HoTen = Convert.ToString(Row["HoTen"]);
LopInfo l = new LopInfo();
l.MaLop = Convert.ToString(Row["MaLop"]);
l.TenLop = Convert.ToString(Row["TenLop"]);
HocKyInfo hk = new HocKyInfo();
hk.MaHocKy = Convert.ToString(Row["MaHocKy"]);
hk.TenHocKy = Convert.ToString(Row["TenHocKy"]);
NamHocInfo nh = new NamHocInfo();
nh.MaNamHoc = Convert.ToString(Row["MaNamHoc"]);
nh.TenNamHoc = Convert.ToString(Row["TenNamHoc"]);
HocLucInfo hl = new HocLucInfo();
hl.MaHocLuc = Convert.ToString(Row["MaHocLuc"]);
hl.TenHocLuc = Convert.ToString(Row["TenHocLuc"]);
HanhKiemInfo hkiem = new HanhKiemInfo();
hkiem.MaHanhKiem = Convert.ToString(Row["MaHanhKiem"]);
hkiem.TenHanhKiem = Convert.ToString(Row["TenHanhKiem"]);
ketqua.HocSinh = hs;
ketqua.Lop = l;
ketqua.HocKy = hk;
ketqua.NamHoc = nh;
ketqua.HocLuc = hl;
ketqua.HanhKiem = hkiem;
ketqua.DTBMonHocKy = Convert.ToSingle(Row["DTBMonHocKy"]);
dS.Add(ketqua);
}
return(dS);
}