public HocSinhInfo LayTuMa(string maHocSinh)
{
if (this.Data == null)
{
this.Data = new HocSinhData();
}
DataTable table = this.Data.LayTuMa(maHocSinh);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
HocSinhInfo info = new HocSinhInfo();
info.MaHocSinh = row["MaHocSinh"].ToString();
info.HoTen = row["HoTen"].ToString();
info.GioiTinh = bool.Parse(row["GioiTinh"].ToString());
info.NgaySinh = DateTime.Parse(row["NgaySinh"].ToString());
info.NoiSinh = row["NoiSinh"].ToString();
info.DiaChi = row["DiaChi"].ToString();
info.DanToc = new DanTocInfo();
info.TonGiao = new TonGiaoInfo();
info.HoTenCha = row["HoTenMe"].ToString();
info.NgheNghiepCha = new NgheNghiepInfo();
info.HoTenMe = row["HoTenMe"].ToString();
info.NgheNghiepMe = new NgheNghiepInfo();
return(info);
}
return(null);
}
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();
NgheNghiepInfo nn = new NgheNghiepInfo();
nn.MaNghe = Convert.ToString(Row["MaNghe"]);
nn.TenNghe = Convert.ToString(Row["TenNghe"]);
DanTocInfo dt = new DanTocInfo();
dt.MaDanToc = Convert.ToString(Row["MaDanToc"]);
dt.TenDanToc = Convert.ToString(Row["TenDanToc"]);
TonGiaoInfo tg = new TonGiaoInfo();
tg.MaTonGiao = Convert.ToString(Row["MaTonGiao"]);
tg.TenTonGiao = Convert.ToString(Row["TenTonGiao"]);
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 = dt;
hs.TonGiao = tg;
hs.HoTenCha = Convert.ToString(Row["HoTenCha"]);
hs.NNghiepCha = nn;
hs.HoTenMe = Convert.ToString(Row["HoTenMe"]);
hs.NNghiepMe = nn;
dS.Add(hs);
}
return(dS);
}
public List <HocSinhInfo> LayDSHocSinhTheoLop(String namHoc, String lop)
{
var lst = new List <HocSinhInfo>();
DataTable db = LayDsHocSinhTheoLop(namHoc, lop);
foreach (DataRow r in db.Rows)
{
HocSinhInfo hs = new HocSinhInfo();
hs.MaHocSinh = r["MaHocSinh"].ToString();
hs.HoTen = r["HoTen"].ToString();
lst.Add(hs);
}
return(lst);
}
/// <summary>
///
/// </summary>
/// <param name="lvDS"></param>
public void HienThiDS(ListView lvDS)
{
if (this.Data == null)
{
this.Data = new HocSinhData();
}
DataTable table = this.Data.LayDS();
IEnumerator ie = table.Rows.GetEnumerator();
lvDS.Items.Clear();
while (ie.MoveNext())
{
DataRow row = (DataRow)ie.Current;
HocSinhInfo info = new HocSinhInfo();
info.MaHocSinh = row["MaHocSinh"].ToString();
info.HoTen = row["HoTen"].ToString();
info.GioiTinh = bool.Parse(row["GioiTinh"].ToString());
info.NgaySinh = DateTime.Parse(row["NgaySinh"].ToString());
info.NoiSinh = row["NoiSinh"].ToString();
info.DiaChi = row["DiaChi"].ToString();
info.DanToc = new DanTocInfo();
info.TonGiao = new TonGiaoInfo();
info.HoTenCha = row["HoTenMe"].ToString();
info.NgheNghiepCha = new NgheNghiepInfo();
info.HoTenMe = row["HoTenMe"].ToString();
info.NgheNghiepMe = new NgheNghiepInfo();
ListViewItem item = new ListViewItem();
item.Text = info.MaHocSinh;
item.SubItems.Add(info.HoTen);
if (info.GioiTinh == true)
{
item.SubItems.Add("Nam");
}
else
{
item.SubItems.Add("Nữ");
}
item.SubItems.Add(info.NgaySinh.ToShortDateString());
item.SubItems.Add(info.NoiSinh);
item.SubItems.Add(info.DiaChi);
item.Tag = info;
lvDS.Items.Add(item);
}
}
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);
}
public static IList <KQHocKyMonHocInfo> LayDsKQHocKyMonHoc(String maLop, String maMonHoc, String maHocKy, String maNamHoc)
{
KQHocKyMonHocData m_KQHKMHData = new KQHocKyMonHocData();
DataTable m_DT = m_KQHKMHData.LayDsKQHocKyMonHocForReport(maLop, maMonHoc, maHocKy, maNamHoc);
IList <KQHocKyMonHocInfo> dS = new List <KQHocKyMonHocInfo>();
foreach (DataRow Row in m_DT.Rows)
{
KQHocKyMonHocInfo ketqua = new KQHocKyMonHocInfo();
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.DTBKiemTra = Convert.ToSingle(Row["DTBKiemTra"]);
ketqua.DTBMonHocKy = Convert.ToSingle(Row["DTBMonHocKy"]);
dS.Add(ketqua);
}
return(dS);
}
//Lay danh sach hoc sinh do vao 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.ToString(Row["GioiTinh"]).Trim();
hs.NgaySinh = Convert.ToDateTime(Row["NgaySinh"]);
hs.NoiSinh = Convert.ToString(Row["NoiSinh"]);
dS.Add(hs);
}
return(dS);
}
/// <summary>
/// Hien thi danh sach phan lop trong ListView theo ma lop
/// </summary>
/// <param name="lvDS"></param>
/// <param name="maLop"></param>
public void HienThiDS(ListView lvDS, string maLop)
{
if (this.Data == null)
{
this.Data = new PhanLopData();
}
DataTable table = this.Data.LayDSTuMaLop(maLop);
int n = table.Rows.Count;
lvDS.Items.Clear();
for (int i = 0; i < n; i++)
{
String maHocSinh = table.Rows[i]["MaHocSinh"].ToString();
HocSinhController HSController = new HocSinhController();
HocSinhInfo info = HSController.LayTuMa(maHocSinh);
// v10.1
ListViewItem item = new ListViewItem();
//item.Text = info.MaHocSinh;
item.Text = table.Rows[i]["MaHocSinhLop"].ToString();
item.SubItems.Add(info.HoTen);
if (info.GioiTinh == true)
{
item.SubItems.Add("Nam");
}
else
{
item.SubItems.Add("Nữ");
}
item.SubItems.Add(info.NgaySinh.ToShortDateString());
item.SubItems.Add(info.NoiSinh);
item.SubItems.Add(info.DiaChi);
object[] tag = new object[2];
tag[0] = info;
tag[1] = table.Rows[i];
item.Tag = tag;
lvDS.Items.Add(item);
}
}
//Mới
public static IList <HocSinhInfo> LayDsHocSinh(String namHoc, String khoiLop, String lop)
{
HocSinhData m_HSData = new HocSinhData();
DataTable m_DT = m_HSData.LayDsHocSinhForReport(namHoc, khoiLop, lop);
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.Email = Convert.ToString(Row["Email"]);
hs.DiaChi = Convert.ToString(Row["DiaChi"]);
dS.Add(hs);
}
return(dS);
}
