//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; }