//report
public static IList<HocSinhInfo> LayDsHocSinh()
{
HocSinhData m_HSData = new HocSinhData();
DataTable m_DT = m_HSData.LayDsHocSinhForReport();
IList<HocSinhInfo> dS = new List<HocSinhInfo>();
foreach (DataRow Row in m_DT.Rows)
{
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"]);
// hs.NoiSinh = Convert.ToString(Row["NoiSinh"]);
hs.DanToc = Convert.ToString(Row["DanToc"]); ;
hs.TonGiao = Convert.ToString(Row["TonGiao"]);
// hs.HoTenCha = Convert.ToString(Row["HoTenCha"]);
// hs.NgheNghiepCha = Convert.ToString(Row["NgheNghiepCha"]);
// hs.HoTenMe = Convert.ToString(Row["HoTenMe"]);
// hs.NgheNghiepMe = Convert.ToString(Row["NgheNghiepMe"]);
dS.Add(hs);
}
return dS;
}
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<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;
}
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;
}
