//public void XetRaTruong(int IDSV_SinhVien, string SoBang, int TrangThaiSinhVien) //{ // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_XetRaTruong(GlobalVar.MaXacThuc, IDSV_SinhVien, SoBang, TrangThaiSinhVien); // client.Close(); //} public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_SV_SinhVien_TimKiemResult>(client.cDSV_SinhVien_TimKiem(GlobalVar.MaXacThuc, pSV_SinhVienInfo))); } }
public frmThongKeSVTheoLop() { InitializeComponent(); oBDM_Lop = new cBDM_Lop(); pDM_LopInfo = new DM_LopInfo(); pSV_SinhVienInfo = new SV_SinhVienInfo(); oBSV_SinhVien = new cBSV_SinhVien(); oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc(); //repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinhSV(); //cboDanhSachHienThi. _grCols = new Dictionary <int, GridColumn>() { { 0, tl }, { 1, g1 }, { 2, g2 }, { 3, g3 }, { 4, g4 }, { 5, g5 }, { 6, g6 }, { 7, g7 }, { 8, g8 }, { 9, g9 }, { 10, g10 }, { 11, g11 }, { 12, g12 } }; }
//public int Add(SV_SinhVienInfo pSV_SinhVienInfo) //{ // int ID = 0; // var client = new UnimOsServiceClient(); // ID = client.cDSV_SinhVien_Add(GlobalVar.MaXacThuc, pSV_SinhVienInfo); // client.Close(); // mErrorMessage = oDSV_SinhVien.ErrorMessages; // mErrorNumber = oDSV_SinhVien.ErrorNumber; // return ID; //} //public int AddByPhanLop(int IDSV_SinhVienNhapTruong, int IDDM_Lop) //{ // int ID = 0; // var client = new UnimOsServiceClient(); // ID = client.cDSV_SinhVien_AddByPhanLop(GlobalVar.MaXacThuc, IDSV_SinhVienNhapTruong, IDDM_Lop); // client.Close(); // mErrorMessage = oDSV_SinhVien.ErrorMessages; // mErrorNumber = oDSV_SinhVien.ErrorNumber; // return ID; //} //public void Update(SV_SinhVienInfo pSV_SinhVienInfo) //{ // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_Update(GlobalVar.MaXacThuc, pSV_SinhVienInfo); // client.Close(); // mErrorMessage = oDSV_SinhVien.ErrorMessages; // mErrorNumber = oDSV_SinhVien.ErrorNumber; //} //public int UpdateMaSinhVien(string MaSinhVien, int SV_SinhVienID) //{ // using (var client = new UnimOsServiceClient()) // { // return client.cDSV_SinhVien_UpdateMaSinhVien(GlobalVar.MaXacThuc, MaSinhVien, SV_SinhVienID); // } //} //public void UpdateMaSinhVien(ref DataTable dtSinhVien) //{ // if (!dtSinhVien.Columns.Contains("GhiChu")) // dtSinhVien.Columns.Add("GhiChu", typeof(string)); // foreach (DataRow dr in dtSinhVien.Rows) // { // if (UpdateMaSinhVien(dr["MaSinhVien"].ToString(), int.Parse(dr["SV_SinhVienID"].ToString())) > 0) // dr["GhiChu"] = "Mã này đã được sử dụng cho sinh viên khác"; // } //} //public void UpdateTaiKhoan(DataTable dtSinhVien) //{ // foreach (DataRow dr in dtSinhVien.Rows) // { // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_UpdateTaiKhoan(GlobalVar.MaXacThuc, dr["TenDangNhap"].ToString(), dr["MatKhau"].ToString(), int.Parse(dr["SV_SinhVienID"].ToString())); // client.Close(); // } //} //public void UpdateAnhSinhVien(byte[] Anh, int SV_SinhVienID) //{ // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_UpdateAnhSinhVien(GlobalVar.MaXacThuc, Anh, SV_SinhVienID); // client.Close(); //} //public void UpdateAnhSinhVien(DataTable dtSinhVien, string ThuMucAnh) //{ // Image img; // byte[] Anh; // foreach (DataRow dr in dtSinhVien.Rows) // { // if ("" + dr["FileAnh"] != "") // { // MemoryStream ms = new MemoryStream(); // img = Image.FromFile(ThuMucAnh + dr["FileAnh"].ToString()); // img.Save(ms, img.RawFormat); // Anh = ms.GetBuffer(); // UpdateAnhSinhVien(Anh, int.Parse(dr["SV_SinhVienID"].ToString())); // } // } //} //public void ChuyenLop(int IDSV_SinhVien, int IDDM_Lop_Cu, int IDDM_Lop_Moi, int TrangThaiSinhVien_Chuyen) //{ // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_ChuyenLop(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_Lop_Cu, IDDM_Lop_Moi, TrangThaiSinhVien_Chuyen); // client.Close(); //} //public DataTable GetBangDiemLanCuoi(int IDSV_SinhVien, int IDDM_NamHoc, string TenNamHoc) //{ // using (var client = new UnimOsServiceClient()) // { // return ConvertList.ToDataTable<SV_SinhVienInfo>(client.cDSV_SinhVien_GetBangDiemLanCuoi(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_NamHoc, TenNamHoc)); // } //} //public void Delete(SV_SinhVienInfo pSV_SinhVienInfo) //{ // var client = new UnimOsServiceClient(); // client.cDSV_SinhVien_Delete(GlobalVar.MaXacThuc, pSV_SinhVienInfo); // client.Close(); // mErrorMessage = oDSV_SinhVien.ErrorMessages; // mErrorNumber = oDSV_SinhVien.ErrorNumber; //} //public List<SV_SinhVienInfo> GetList(SV_SinhVienInfo pSV_SinhVienInfo) //{ // List<SV_SinhVienInfo> oSV_SinhVienInfoList = new List<SV_SinhVienInfo>(); // DataTable dtb = Get(pSV_SinhVienInfo); // if (dtb != null) // { // for (int i = 0; i < dtb.Rows.Count; i++) // { // oSV_SinhVienInfo = new SV_SinhVienInfo(); // oSV_SinhVienInfo.SV_SinhVienID = int.Parse(dtb.Rows[i]["SV_SinhVienID"].ToString()); // oSV_SinhVienInfo.MaSinhVien = dtb.Rows[i]["MaSinhVien"].ToString(); // oSV_SinhVienInfo.HoVaTen = dtb.Rows[i]["HoVaTen"].ToString(); // oSV_SinhVienInfo.Ten = dtb.Rows[i]["Ten"].ToString(); // oSV_SinhVienInfo.NgaySinh = DateTime.Parse(dtb.Rows[i]["NgaySinh"].ToString()); // oSV_SinhVienInfo.SoCMND = "" + dtb.Rows[i]["SoCMND"]; // oSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dtb.Rows[i]["NgayCapCMND"].ToString()); // oSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dtb.Rows[i]["IDTinhNoiCapCMND"].ToString()); // oSV_SinhVienInfo.Anh = (byte[])(dtb.Rows[i]["Anh"]); // oSV_SinhVienInfo.GioiTinh = bool.Parse(dtb.Rows[i]["GioiTinh"].ToString()); // oSV_SinhVienInfo.IDDM_DanToc = int.Parse(dtb.Rows[i]["IDDM_DanToc"].ToString()); // oSV_SinhVienInfo.IDDM_TonGiao = int.Parse(dtb.Rows[i]["IDDM_TonGiao"].ToString()); // oSV_SinhVienInfo.IDDM_QuocTich = int.Parse(dtb.Rows[i]["IDDM_QuocTich"].ToString()); // oSV_SinhVienInfo.NoiSinh = dtb.Rows[i]["NoiSinh"].ToString(); // oSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaNoiSinh"].ToString()); // oSV_SinhVienInfo.QueQuan = dtb.Rows[i]["QueQuan"].ToString(); // oSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaQueQuan"].ToString()); // oSV_SinhVienInfo.ThuongTru = dtb.Rows[i]["ThuongTru"].ToString(); // oSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaThuongTru"].ToString()); // oSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dtb.Rows[i]["NgayVaoDoan"].ToString()); // oSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dtb.Rows[i]["NgayVaoDang"].ToString()); // oSV_SinhVienInfo.DienThoaiNhaRieng = dtb.Rows[i]["DienThoaiNhaRieng"].ToString(); // oSV_SinhVienInfo.DienThoaiDiDong = dtb.Rows[i]["DienThoaiDiDong"].ToString(); // oSV_SinhVienInfo.Email = dtb.Rows[i]["Email"].ToString(); // oSV_SinhVienInfo.Active = int.Parse(dtb.Rows[i]["Active"].ToString()); // oSV_SinhVienInfo.Xoa = bool.Parse(dtb.Rows[i]["Xoa"].ToString()); // oSV_SinhVienInfoList.Add(oSV_SinhVienInfo); // } // } // return oSV_SinhVienInfoList; //} public void ToDataRow(SV_SinhVienInfo pSV_SinhVienInfo, ref DataRow dr) { dr[pSV_SinhVienInfo.strSV_SinhVienID] = pSV_SinhVienInfo.SV_SinhVienID; dr[pSV_SinhVienInfo.strMaSinhVien] = pSV_SinhVienInfo.MaSinhVien; dr[pSV_SinhVienInfo.strHoVaTen] = pSV_SinhVienInfo.HoVaTen; dr[pSV_SinhVienInfo.strTen] = pSV_SinhVienInfo.Ten; dr[pSV_SinhVienInfo.strNgaySinh] = pSV_SinhVienInfo.NgaySinh; dr[pSV_SinhVienInfo.strSoCMND] = pSV_SinhVienInfo.SoCMND; dr[pSV_SinhVienInfo.strNgayCapCMND] = pSV_SinhVienInfo.NgayCapCMND; dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND] = pSV_SinhVienInfo.IDTinhNoiCapCMND; // dr[pSV_SinhVienInfo.strAnh] = pSV_SinhVienInfo.Anh; dr[pSV_SinhVienInfo.strGioiTinh] = pSV_SinhVienInfo.GioiTinh; dr[pSV_SinhVienInfo.strIDDM_DanToc] = pSV_SinhVienInfo.IDDM_DanToc; dr[pSV_SinhVienInfo.strIDDM_TonGiao] = pSV_SinhVienInfo.IDDM_TonGiao; dr[pSV_SinhVienInfo.strIDDM_QuocTich] = pSV_SinhVienInfo.IDDM_QuocTich; dr[pSV_SinhVienInfo.strNoiSinh] = pSV_SinhVienInfo.NoiSinh; dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaNoiSinh] = pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh; dr[pSV_SinhVienInfo.strQueQuan] = pSV_SinhVienInfo.QueQuan; dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaQueQuan] = pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan; dr[pSV_SinhVienInfo.strThuongTru] = pSV_SinhVienInfo.ThuongTru; dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaThuongTru] = pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru; dr[pSV_SinhVienInfo.strNgayVaoDoan] = pSV_SinhVienInfo.NgayVaoDoan; dr[pSV_SinhVienInfo.strNgayVaoDang] = pSV_SinhVienInfo.NgayVaoDang; dr[pSV_SinhVienInfo.strDienThoaiNhaRieng] = pSV_SinhVienInfo.DienThoaiNhaRieng; dr[pSV_SinhVienInfo.strDienThoaiDiDong] = pSV_SinhVienInfo.DienThoaiDiDong; dr[pSV_SinhVienInfo.strEmail] = pSV_SinhVienInfo.Email; dr[pSV_SinhVienInfo.strActive] = pSV_SinhVienInfo.Active; dr[pSV_SinhVienInfo.strXoa] = pSV_SinhVienInfo.Xoa; }
public void Delete(SV_SinhVienInfo pSV_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID)); RunProcedure("sp_SV_SinhVien_Delete", colParam); }
public DataTable Get(SV_SinhVienInfo pSV_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID)); return(RunProcedureGet("sp_SV_SinhVien_Get", colParam)); }
public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, pSV_SinhVienInfo.MaSinhVien)); colParam.Add(CreateParam("@HoTen", SqlDbType.NVarChar, pSV_SinhVienInfo.HoVaTen)); return(RunProcedureGet("sp_SV_SinhVien_TimKiem", colParam)); }
public int Add(SV_SinhVienInfo pSV_SinhVienInfo) { int ID = 0; ID = oDSV_SinhVien.Add(pSV_SinhVienInfo); mErrorMessage = oDSV_SinhVien.ErrorMessages; mErrorNumber = oDSV_SinhVien.ErrorNumber; return(ID); }
public dlgTimKiemSinhVien(DataTable mdtSinhVien, int mIDDM_Lop) { InitializeComponent(); pSV_SinhVienInfo = new SV_SinhVienInfo(); oBSV_SinhVien = new cBSV_SinhVien(); IDDM_Lop = mIDDM_Lop; dtSinhVien = mdtSinhVien; btnChon.Enabled = false; this.Tag = ""; }
public frmDanhSachSinhVienLop() { InitializeComponent(); oBDM_Lop = new cBDM_Lop(); pDM_LopInfo = new DM_LopInfo(); pSV_SinhVienInfo = new SV_SinhVienInfo(); oBSV_SinhVien = new cBSV_SinhVien(); repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinhSV(); //cboDanhSachHienThi. }
private void dlgLocSinhVien_Load(object sender, EventArgs e) { LoadTreeLop(uctrlLop); uctrlLop.trlLop.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(trlLop_FocusedNodeChanged); if (MaSinhVien != "") { pSV_SinhVienInfo = new SV_SinhVienInfo(); pSV_SinhVienInfo.MaSinhVien = MaSinhVien; pSV_SinhVienInfo.HoVaTen = ""; dtSinhVien = oBSV_SinhVien.TimKiem(pSV_SinhVienInfo); grdSinhVien.DataSource = dtSinhVien; } }
public void ToInfo(ref SV_SinhVienInfo pSV_SinhVienInfo, DataRow dr, DataTable dt) { if (dt.Columns.Contains(pSV_SinhVienInfo.strMaSinhVien)) { pSV_SinhVienInfo.MaSinhVien = dr[pSV_SinhVienInfo.strMaSinhVien].ToString(); } if (dt.Columns.Contains(pSV_SinhVienInfo.strHoVaTen)) { pSV_SinhVienInfo.HoVaTen = dr[pSV_SinhVienInfo.strHoVaTen].ToString(); pSV_SinhVienInfo.Ten = GetTen(dr[pSV_SinhVienInfo.strHoVaTen].ToString()); } if (dt.Columns.Contains(pSV_SinhVienInfo.strNgaySinh)) { if ("" + dr[pSV_SinhVienInfo.strNgaySinh] != "") { pSV_SinhVienInfo.NgaySinh = DateTime.Parse(dr[pSV_SinhVienInfo.strNgaySinh].ToString()); } else { pSV_SinhVienInfo.NgaySinh = DateTime.Parse("1/1/1900"); } } else { pSV_SinhVienInfo.NgaySinh = DateTime.Parse("1/1/1900"); } if (dt.Columns.Contains(pSV_SinhVienInfo.strGioiTinh)) { pSV_SinhVienInfo.GioiTinh = "" + dr[pSV_SinhVienInfo.strGioiTinh] == "NAM" ? false : true; } if (dt.Columns.Contains(pSV_SinhVienInfo.strIDDM_DanToc)) { pSV_SinhVienInfo.IDDM_DanToc = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_DanToc]); } if (dt.Columns.Contains(pSV_SinhVienInfo.strNoiSinh)) { pSV_SinhVienInfo.NoiSinh = dr[pSV_SinhVienInfo.strNoiSinh].ToString(); } if (dt.Columns.Contains(pSV_SinhVienInfo.strQueQuan)) { pSV_SinhVienInfo.QueQuan = dr[pSV_SinhVienInfo.strQueQuan].ToString(); } if (dt.Columns.Contains(pSV_SinhVienInfo.strThuongTru)) { pSV_SinhVienInfo.ThuongTru = dr[pSV_SinhVienInfo.strThuongTru].ToString(); } pSV_SinhVienInfo.NgayCapCMND = DateTime.Parse("1/1/1900"); pSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse("1/1/1900"); pSV_SinhVienInfo.NgayVaoDang = DateTime.Parse("1/1/1900"); pSV_SinhVienInfo.Active = 1; }
public dlgToChucThi_ThiSinhTuDo(DataTable mdtSinhVien, DataRow mdrSinhVien, int mIDDM_Lop, EDIT_MODE mEditMode) { InitializeComponent(); this.Tag = ""; IDDM_Lop = mIDDM_Lop; dtSinhVien = mdtSinhVien; edit = mEditMode; drSinhVien = mdrSinhVien; pDM_LopInfo = new DM_LopInfo(); oBDM_Lop = new cBDM_Lop(); pSV_SinhVienInfo = new SV_SinhVienInfo(); oBSV_SinhVien = new cBSV_SinhVien(); pSV_SinhVien_LopInfo = new SV_SinhVien_LopInfo(); oBSV_SinhVien_Lop = new cBSV_SinhVien_Lop(); cls = new clsStringHelper(); }
public dlgBienLaiThuTienChiTiet(int _IDTC_BienLaiThuTien, bool mSua, string _MaSinhVien) { InitializeComponent(); oBSV_SinhVien = new cBSV_SinhVien(); pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo(); oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien(); pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo(); oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet(); oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien(); pSV_SinhVienInfo = new SV_SinhVienInfo(); dtpNgay.EditValue = DateTime.Now; Sua = mSua; IDTC_BienLaiThuTien = _IDTC_BienLaiThuTien; MaSinhVien = _MaSinhVien; chkInKhiLuu.Checked = Properties.Settings.Default.TC_InKhiLuu; }
public void ToInfo(ref SV_SinhVienInfo pSV_SinhVienInfo, DataRow dr) { pSV_SinhVienInfo.SV_SinhVienID = int.Parse(dr[pSV_SinhVienInfo.strSV_SinhVienID].ToString()); pSV_SinhVienInfo.MaSinhVien = dr[pSV_SinhVienInfo.strMaSinhVien].ToString(); pSV_SinhVienInfo.HoVaTen = dr[pSV_SinhVienInfo.strHoVaTen].ToString(); pSV_SinhVienInfo.Ten = dr[pSV_SinhVienInfo.strTen].ToString(); if (dr[pSV_SinhVienInfo.strNgaySinh].ToString() != "") { pSV_SinhVienInfo.NgaySinh = DateTime.Parse(dr[pSV_SinhVienInfo.strNgaySinh].ToString()); } pSV_SinhVienInfo.SoCMND = "" + dr[pSV_SinhVienInfo.strSoCMND]; if (dr[pSV_SinhVienInfo.strNgayCapCMND].ToString() != "") { pSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayCapCMND].ToString()); } if ("" + dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND] != "") { pSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND].ToString()); } // if (dr[pSV_SinhVienInfo.strAnh] != null) // pSV_SinhVienInfo.Anh = (byte[])(dr[pSV_SinhVienInfo.strAnh]); pSV_SinhVienInfo.GioiTinh = bool.Parse(dr[pSV_SinhVienInfo.strGioiTinh].ToString()); pSV_SinhVienInfo.IDDM_DanToc = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_DanToc]); pSV_SinhVienInfo.IDDM_TonGiao = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TonGiao]); pSV_SinhVienInfo.IDDM_QuocTich = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_QuocTich]); pSV_SinhVienInfo.NoiSinh = dr[pSV_SinhVienInfo.strNoiSinh].ToString(); pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaNoiSinh]); pSV_SinhVienInfo.QueQuan = "" + dr[pSV_SinhVienInfo.strQueQuan]; pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaQueQuan]); pSV_SinhVienInfo.ThuongTru = "" + dr[pSV_SinhVienInfo.strThuongTru]; pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaThuongTru]); if (dr[pSV_SinhVienInfo.strNgayVaoDoan].ToString() != "") { pSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayVaoDoan].ToString()); } if (dr[pSV_SinhVienInfo.strNgayVaoDang].ToString() != "") { pSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayVaoDang].ToString()); } pSV_SinhVienInfo.DienThoaiNhaRieng = dr[pSV_SinhVienInfo.strDienThoaiNhaRieng].ToString(); pSV_SinhVienInfo.DienThoaiDiDong = dr[pSV_SinhVienInfo.strDienThoaiDiDong].ToString(); pSV_SinhVienInfo.Email = dr[pSV_SinhVienInfo.strEmail].ToString(); pSV_SinhVienInfo.Active = int.Parse(dr[pSV_SinhVienInfo.strActive].ToString()); pSV_SinhVienInfo.Xoa = bool.Parse(dr[pSV_SinhVienInfo.strXoa].ToString()); }
public List <SV_SinhVienInfo> GetList(SV_SinhVienInfo pSV_SinhVienInfo) { List <SV_SinhVienInfo> oSV_SinhVienInfoList = new List <SV_SinhVienInfo>(); DataTable dtb = Get(pSV_SinhVienInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oSV_SinhVienInfo = new SV_SinhVienInfo(); oSV_SinhVienInfo.SV_SinhVienID = int.Parse(dtb.Rows[i]["SV_SinhVienID"].ToString()); oSV_SinhVienInfo.MaSinhVien = dtb.Rows[i]["MaSinhVien"].ToString(); oSV_SinhVienInfo.HoVaTen = dtb.Rows[i]["HoVaTen"].ToString(); oSV_SinhVienInfo.Ten = dtb.Rows[i]["Ten"].ToString(); oSV_SinhVienInfo.NgaySinh = DateTime.Parse(dtb.Rows[i]["NgaySinh"].ToString()); oSV_SinhVienInfo.SoCMND = "" + dtb.Rows[i]["SoCMND"]; oSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dtb.Rows[i]["NgayCapCMND"].ToString()); oSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dtb.Rows[i]["IDTinhNoiCapCMND"].ToString()); oSV_SinhVienInfo.Anh = (byte[])(dtb.Rows[i]["Anh"]); oSV_SinhVienInfo.GioiTinh = bool.Parse(dtb.Rows[i]["GioiTinh"].ToString()); oSV_SinhVienInfo.IDDM_DanToc = int.Parse(dtb.Rows[i]["IDDM_DanToc"].ToString()); oSV_SinhVienInfo.IDDM_TonGiao = int.Parse(dtb.Rows[i]["IDDM_TonGiao"].ToString()); oSV_SinhVienInfo.IDDM_QuocTich = int.Parse(dtb.Rows[i]["IDDM_QuocTich"].ToString()); oSV_SinhVienInfo.NoiSinh = dtb.Rows[i]["NoiSinh"].ToString(); oSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaNoiSinh"].ToString()); oSV_SinhVienInfo.QueQuan = dtb.Rows[i]["QueQuan"].ToString(); oSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaQueQuan"].ToString()); oSV_SinhVienInfo.ThuongTru = dtb.Rows[i]["ThuongTru"].ToString(); oSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaThuongTru"].ToString()); oSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dtb.Rows[i]["NgayVaoDoan"].ToString()); oSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dtb.Rows[i]["NgayVaoDang"].ToString()); oSV_SinhVienInfo.DienThoaiNhaRieng = dtb.Rows[i]["DienThoaiNhaRieng"].ToString(); oSV_SinhVienInfo.DienThoaiDiDong = dtb.Rows[i]["DienThoaiDiDong"].ToString(); oSV_SinhVienInfo.Email = dtb.Rows[i]["Email"].ToString(); oSV_SinhVienInfo.Active = int.Parse(dtb.Rows[i]["Active"].ToString()); oSV_SinhVienInfo.Xoa = bool.Parse(dtb.Rows[i]["Xoa"].ToString()); oSV_SinhVienInfoList.Add(oSV_SinhVienInfo); } } return(oSV_SinhVienInfoList); }
public frmHoSoSinhVien(DataTable _dtSinhVien, ref DataRow _drSinhVien) { InitializeComponent(); oBSV_SinhVien = new cBSV_SinhVien(); pSV_SinhVienInfo = new SV_SinhVienInfo(); oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong(); pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); oBSV_SinhVien_ThongTinKhac = new cBSV_SinhVien_ThongTinKhac(); pSV_SinhVien_ThongTinKhacInfo = new SV_SinhVien_ThongTinKhacInfo(); oBSV_SinhVien_QuanHeGiaDinh = new cBSV_SinhVien_QuanHeGiaDinh(); pSV_SinhVien_QuanHeGiaDinhInfo = new SV_SinhVien_QuanHeGiaDinhInfo(); drSinhVien = _drSinhVien; dtSinhVien = _dtSinhVien; LoadDiaChi(ucNoiSinh); LoadDiaChi(ucThuongTru); SetControl(false); SetControlReadOnly(true); btnLuu.Enabled = false; }
public dlgQuyetDinh(string mSinhVienIDs, string mTrangThai, string mKQHT_DanhSachNgungHocIDs, DataRow mdr) { InitializeComponent(); oBSinhVien = new cBSV_SinhVien(); oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc(); pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo(); pSV_SinhVienInfo = new SV_SinhVienInfo(); pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo(); oBKQHT_DanhSachHocTiep = new cBKQHT_DanhSachHocTiep(); pKQHT_DanhSachHocTiepInfo = new KQHT_DanhSachHocTiepInfo(); SinhVienIDs = mSinhVienIDs; dtNgayQD.EditValue = DateTime.Now; dr = mdr; TrangThai = mTrangThai; KQHT_DanhSachNgungHocIDs = mKQHT_DanhSachNgungHocIDs; //load combobox cmbTrangThai.Properties.DataSource = oBSinhVien.CreateTableTrangThai(); cmbLop.Properties.DataSource = LoadLopTheoKhoa(0); // Sửa quyết định if (TrangThai == "1") { txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString(); txtNoiDung.Text = dr["GhiChu"].ToString(); } else if (TrangThai == "2") { // xet hoc tiep txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString(); txtNoiDung.Text = dr["GhiChu"].ToString(); cmbLop.Enabled = true; cmbLop.EditValue = dr["IDDM_Lop"]; } }
public void Update(SV_SinhVienInfo pSV_SinhVienInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, pSV_SinhVienInfo.MaSinhVien)); colParam.Add(CreateParam("@HoVaTen", SqlDbType.NVarChar, pSV_SinhVienInfo.HoVaTen)); colParam.Add(CreateParam("@Ten", SqlDbType.NVarChar, pSV_SinhVienInfo.Ten)); colParam.Add(CreateParam("@NgaySinh", SqlDbType.DateTime, pSV_SinhVienInfo.NgaySinh)); colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.NVarChar, pSV_SinhVienInfo.SoBaoDanh)); colParam.Add(CreateParam("@SoCMND", SqlDbType.VarChar, pSV_SinhVienInfo.SoCMND)); colParam.Add(CreateParam("@NgayCapCMND", SqlDbType.DateTime, pSV_SinhVienInfo.NgayCapCMND)); colParam.Add(CreateParam("@IDTinhNoiCapCMND", SqlDbType.Int, pSV_SinhVienInfo.IDTinhNoiCapCMND)); colParam.Add(CreateParam("@Anh", SqlDbType.Image, pSV_SinhVienInfo.Anh)); colParam.Add(CreateParam("@GioiTinh", SqlDbType.Bit, pSV_SinhVienInfo.GioiTinh)); colParam.Add(CreateParam("@ThanhPhanXuatThan", SqlDbType.Int, pSV_SinhVienInfo.ThanhPhanXuatThan)); colParam.Add(CreateParam("@IDDM_DanToc", SqlDbType.Int, pSV_SinhVienInfo.IDDM_DanToc)); colParam.Add(CreateParam("@IDDM_TonGiao", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TonGiao)); colParam.Add(CreateParam("@IDDM_QuocTich", SqlDbType.Int, pSV_SinhVienInfo.IDDM_QuocTich)); colParam.Add(CreateParam("@NoiSinh", SqlDbType.NVarChar, pSV_SinhVienInfo.NoiSinh)); colParam.Add(CreateParam("@IDDM_TinhHuyenXaNoiSinh", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh)); colParam.Add(CreateParam("@QueQuan", SqlDbType.NVarChar, pSV_SinhVienInfo.QueQuan)); colParam.Add(CreateParam("@IDDM_TinhHuyenXaQueQuan", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan)); colParam.Add(CreateParam("@ThuongTru", SqlDbType.NVarChar, pSV_SinhVienInfo.ThuongTru)); colParam.Add(CreateParam("@IDDM_TinhHuyenXaThuongTru", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru)); colParam.Add(CreateParam("@NgayVaoDoan", SqlDbType.DateTime, pSV_SinhVienInfo.NgayVaoDoan)); colParam.Add(CreateParam("@NgayVaoDang", SqlDbType.DateTime, pSV_SinhVienInfo.NgayVaoDang)); colParam.Add(CreateParam("@DienThoaiNhaRieng", SqlDbType.VarChar, pSV_SinhVienInfo.DienThoaiNhaRieng)); colParam.Add(CreateParam("@DienThoaiDiDong", SqlDbType.VarChar, pSV_SinhVienInfo.DienThoaiDiDong)); colParam.Add(CreateParam("@BaoTinCho", SqlDbType.NVarChar, pSV_SinhVienInfo.BaoTinCho)); colParam.Add(CreateParam("@DiaChiBaoTin", SqlDbType.NVarChar, pSV_SinhVienInfo.DiaChiBaoTin)); colParam.Add(CreateParam("@Email", SqlDbType.NVarChar, pSV_SinhVienInfo.Email)); colParam.Add(CreateParam("@Active", SqlDbType.Int, pSV_SinhVienInfo.Active)); colParam.Add(CreateParam("@Xoa", SqlDbType.Bit, pSV_SinhVienInfo.Xoa)); colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID)); RunProcedure("sp_SV_SinhVien_Update", colParam); }
public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo) { return(oDSV_SinhVien.TimKiem(pSV_SinhVienInfo)); }
public void Delete(SV_SinhVienInfo pSV_SinhVienInfo) { oDSV_SinhVien.Delete(pSV_SinhVienInfo); mErrorMessage = oDSV_SinhVien.ErrorMessages; mErrorNumber = oDSV_SinhVien.ErrorNumber; }
public DataTable Get(SV_SinhVienInfo pSV_SinhVienInfo) { return(oDSV_SinhVien.Get(pSV_SinhVienInfo)); }