public DiemInfo()
{
m_HocSinh = new HocSinhInfo();
m_MonHoc = new MonHocInfo();
m_HocKy = new HocKyInfo();
m_NamHoc = new NamHocInfo();
m_Lop = new LopInfo();
m_LoaiDiem = new LoaiDiemInfo();
m_Diem = 0;
}
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<KQHKMonHocInfo> LayDsKQHocKyMonHoc(String maLop, String maMonHoc, String maHocKy, String maNamHoc)
{
KQHKMonHocData m_KQHKMHData = new KQHKMonHocData();
DataTable m_DT = m_KQHKMHData.LayDsKQHocKyMonHocForReport(maLop, maMonHoc, maHocKy, maNamHoc);
IList<KQHKMonHocInfo> dS = new List<KQHKMonHocInfo>();
foreach (DataRow Row in m_DT.Rows)
{
KQHKMonHocInfo ketqua = new KQHKMonHocInfo();
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"]);
MonHocInfo mh = new MonHocInfo();
mh.MaMonHoc = Convert.ToString(Row["MaMonHoc"]);
mh.TenMonHoc = Convert.ToString(Row["TenMonHoc"]);
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"]);
ketqua.HocSinh = hs;
ketqua.Lop = l;
ketqua.MonHoc = mh;
ketqua.HocKy = hk;
ketqua.NamHoc = nh;
ketqua.DTBMonHocKy = Convert.ToSingle(Row["DTBMonHocKy"]);
dS.Add(ketqua);
}
return dS;
}