public static IList<KQHKTongHopInfo> LayDsKQHocKyTongHop(String maLop, String maHocKy, String maNamHoc) { KQHKTongHopData m_KQHKTHData = new KQHKTongHopData(); DataTable m_DT = m_KQHKTHData.LayDsKQHocKyTongHopForReport(maLop, maHocKy, maNamHoc); IList<KQHKTongHopInfo> dS = new List<KQHKTongHopInfo>(); foreach (DataRow Row in m_DT.Rows) { KQHKTongHopInfo ketqua = new KQHKTongHopInfo(); 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"]); ketqua.DanhHieuHS = Convert.ToString(Row["DanhHieuHS"]); dS.Add(ketqua); } return dS; }
public static IList<KQCNTongHopInfo> LayDsKQCaNamTongHop(String maLop, String maNamHoc) { KQCNTongHopData m_KQCNTHData = new KQCNTongHopData(); DataTable m_DT = m_KQCNTHData.LayDsKQCaNamTongHopForReport(maLop, maNamHoc); IList<KQCNTongHopInfo> dS = new List<KQCNTongHopInfo>(); foreach (DataRow Row in m_DT.Rows) { KQCNTongHopInfo ketqua = new KQCNTongHopInfo(); 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"]); 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; }