//report public static IList <NguoiDanInfo> LayDsNguoiDan() { NguoiDanData m_NDData = new NguoiDanData(); DataTable m_DT = m_NDData.LayDsNguoiDanForReport(); IList <NguoiDanInfo> dS = new List <NguoiDanInfo>(); foreach (DataRow Row in m_DT.Rows) { NguoiDanInfo nd = new NguoiDanInfo(); NgheNghiepInfo nn = new NgheNghiepInfo(); nn.MaNgheNghiep = Convert.ToString(Row["MaNgheNghiep"]); nn.TenNgheNghiep = Convert.ToString(Row["TenNgheNghiep"]); 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"]); nd.MaNguoiDan = Convert.ToString(Row["MaNguoiDan"]); nd.TenNguoiDan = Convert.ToString(Row["TenNguoiDan"]); nd.GioiTinh = Convert.ToBoolean(Row["GioiTinh"]); nd.NgaySinh = Convert.ToDateTime(Row["NgaySinh"]); nd.MaDanToc = dt; nd.MaTonGiao = tg; nd.MaNgheNghiep = nn; dS.Add(nd); } return(dS); }
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); }
private void btnThem_Click(object sender, EventArgs e) { //Kiem Tra tai day if (SVCtrl.KiemTra(txtHoTen, dateNgaySinh, txtDiaChi, txtMSSV, txtCMND, txtDienThoai, cmbQuocTich, cmbDanToc, cmbTonGiao)) { SinhVienInfo SV = new SinhVienInfo(); SV.CamTinhDang = chkCamTinhDang.Checked; SV.SoCMDN = txtCMND.Text; SV.DangVien = chkDangVien.Checked; DanTocInfo dantoc = new DanTocInfo(); dantoc.MaDanToc = (int)cmbDanToc.SelectedValue; dantoc.TenDanToc = cmbDanToc.Text; SV.DanToc = dantoc; SV.DiaChi = txtDiaChi.Text; SV.DienThoai = txtDienThoai.Text; SV.DoanVien = chkDoanVien.Checked; SV.GioiTinh = chkGioiTinh.Checked; SV.HoTen = txtHoTen.Text; SV.MaKTX = txtMaKTX.Text; SV.MSSV = txtMSSV.Text; SV.Namsinh = dateNgaySinh.Value; QuocTichInfo quoctich = new QuocTichInfo(); quoctich.MaQuocTich = (int)cmbQuocTich.SelectedValue; quoctich.TenQuocTich = cmbQuocTich.Text; SV.QuocTich = quoctich; TonGiaoInfo tongiao = new TonGiaoInfo(); tongiao.MaTonGiao = (int)cmbTonGiao.SelectedValue; tongiao.TenTonGiao = cmbTonGiao.Text; SV.TonGiao = tongiao; if (picHinh.ImageLocation == null) { SV.HinhAnh = ""; } else { SV.HinhAnh = picHinh.ImageLocation.ToString(); } IEnumerator ds = listDSThanNhan.Items.GetEnumerator(); while (ds.MoveNext()) { ListViewItem item = (ListViewItem)ds.Current; ThanNhanInfo tn = (ThanNhanInfo)item.Tag;// (ThanhNhanInfo)item.Tag; tn.SinhVien = SV; SV.DSThanNhan.Add(tn); } ListViewItem row = new ListViewItem(); row.Text = SV.HoTen; row.SubItems.Add(SV.GioiTinh == true?"Nam":"Nữ"); row.Tag = SV; listSinhVien.Items.Add(row); //Xoa Du Lieu tren Form txtCMND.Text = ""; txtDiaChi.Text = ""; txtDienThoai.Text = ""; txtHoTen.Text = ""; txtHoTen.Text = ""; txtMaKTX.Text = ""; txtMSSV.Text = ""; chkCamTinhDang.Checked = false; chkDangVien.Checked = false; chkDoanVien.Checked = false; chkGioiTinh.Checked = false; listDSThanNhan.Items.Clear();//Xóa ListView DS Thân nhân ///Lay MSSV tu dong txtMaKTX.Text = SVCtrl.LayMaKTXTuDanhSach(listSinhVien); picHinh.Image = null; } }