public void UpdateHoSo(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@HoVaTenTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.HoVaTenTS)); colParam.Add(CreateParam("@TenTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.TenTS)); colParam.Add(CreateParam("@SoBaoDanhTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.SoBaoDanhTS)); colParam.Add(CreateParam("@KhoiThi", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KhoiThi)); colParam.Add(CreateParam("@NganhThi", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.NganhThi)); colParam.Add(CreateParam("@KyHieuTruong", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KyHieuTruong)); colParam.Add(CreateParam("@DanToc", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.DanToc)); colParam.Add(CreateParam("@DoiTuongTuyenSinh", SqlDbType.NChar, pSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh)); colParam.Add(CreateParam("@XLHocLuc", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLHocLuc)); colParam.Add(CreateParam("@XLHanhKiem", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLHanhKiem)); colParam.Add(CreateParam("@XLTotNghiep", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLTotNghiep)); colParam.Add(CreateParam("@NamTotNghiep", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.NamTotNghiep)); colParam.Add(CreateParam("@KhuVucTuyenSinh", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh)); colParam.Add(CreateParam("@DiemMon1", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon1)); colParam.Add(CreateParam("@DiemMon2", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon2)); colParam.Add(CreateParam("@DiemMon3", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon3)); colParam.Add(CreateParam("@DiemMon4", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon4)); colParam.Add(CreateParam("@DiemThuong", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemThuong)); colParam.Add(CreateParam("@TongDiemLamTron", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.TongDiemLamTron)); colParam.Add(CreateParam("@TuyenThang", SqlDbType.Bit, pSV_SinhVienNhapTruongInfo.TuyenThang)); colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.LyDo)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.IDSV_SinhVien)); RunProcedure("sp_SV_SinhVienNhapTruong_UpdateHoSo", colParam); }
public void ToInfo(ref SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo, DataRow dr) { pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID = int.Parse(dr[pSV_SinhVienNhapTruongInfo.strSV_SinhVienNhapTruongID].ToString()); pSV_SinhVienNhapTruongInfo.HoVaTenTS = dr[pSV_SinhVienNhapTruongInfo.strHoVaTenTS].ToString(); pSV_SinhVienNhapTruongInfo.TenTS = dr[pSV_SinhVienNhapTruongInfo.strTenTS].ToString(); pSV_SinhVienNhapTruongInfo.NgaySinhTS = DateTime.Parse(dr[pSV_SinhVienNhapTruongInfo.strNgaySinhTS].ToString()); pSV_SinhVienNhapTruongInfo.SoBaoDanhTS = dr[pSV_SinhVienNhapTruongInfo.strSoBaoDanhTS].ToString(); pSV_SinhVienNhapTruongInfo.NoiSinhTS = dr[pSV_SinhVienNhapTruongInfo.strNoiSinhTS].ToString(); pSV_SinhVienNhapTruongInfo.ThuongTruTS = dr[pSV_SinhVienNhapTruongInfo.strThuongTruTS].ToString(); pSV_SinhVienNhapTruongInfo.GioiTinhTS = int.Parse(dr[pSV_SinhVienNhapTruongInfo.strGioiTinhTS].ToString()); pSV_SinhVienNhapTruongInfo.KhoiThi = dr[pSV_SinhVienNhapTruongInfo.strKhoiThi].ToString(); pSV_SinhVienNhapTruongInfo.NganhThi = dr[pSV_SinhVienNhapTruongInfo.strNganhThi].ToString(); pSV_SinhVienNhapTruongInfo.KyHieuTruong = dr[pSV_SinhVienNhapTruongInfo.strKyHieuTruong].ToString(); pSV_SinhVienNhapTruongInfo.DanToc = dr[pSV_SinhVienNhapTruongInfo.strDanToc].ToString(); pSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh = dr[pSV_SinhVienNhapTruongInfo.strDoiTuongTuyenSinh].ToString(); pSV_SinhVienNhapTruongInfo.XLHocLuc = dr[pSV_SinhVienNhapTruongInfo.strXLHocLuc].ToString(); pSV_SinhVienNhapTruongInfo.XLHanhKiem = dr[pSV_SinhVienNhapTruongInfo.strXLHanhKiem].ToString(); pSV_SinhVienNhapTruongInfo.XLTotNghiep = dr[pSV_SinhVienNhapTruongInfo.strXLTotNghiep].ToString(); pSV_SinhVienNhapTruongInfo.NamTotNghiep = dr[pSV_SinhVienNhapTruongInfo.strNamTotNghiep].ToString(); pSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh = dr[pSV_SinhVienNhapTruongInfo.strKhuVucTuyenSinh].ToString(); pSV_SinhVienNhapTruongInfo.DiemMon1 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon1].ToString()); pSV_SinhVienNhapTruongInfo.DiemMon2 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon2].ToString()); pSV_SinhVienNhapTruongInfo.DiemMon3 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon3].ToString()); pSV_SinhVienNhapTruongInfo.DiemMon4 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon4].ToString()); pSV_SinhVienNhapTruongInfo.DiemThuong = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemThuong].ToString()); pSV_SinhVienNhapTruongInfo.TongDiemLamTron = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strTongDiemLamTron].ToString()); pSV_SinhVienNhapTruongInfo.TuyenThang = bool.Parse(dr[pSV_SinhVienNhapTruongInfo.strTuyenThang].ToString()); pSV_SinhVienNhapTruongInfo.LyDo = dr[pSV_SinhVienNhapTruongInfo.strLyDo].ToString(); pSV_SinhVienNhapTruongInfo.NgayNhapTruong = DateTime.Parse(dr[pSV_SinhVienNhapTruongInfo.strNgayNhapTruong].ToString()); pSV_SinhVienNhapTruongInfo.IDDM_NamHoc = int.Parse(dr[pSV_SinhVienNhapTruongInfo.strIDDM_NamHoc].ToString()); pSV_SinhVienNhapTruongInfo.IDNguoiTiepNhan = int.Parse(dr[pSV_SinhVienNhapTruongInfo.strIDNguoiTiepNhan].ToString()); pSV_SinhVienNhapTruongInfo.IDSV_SinhVien = int.Parse(dr[pSV_SinhVienNhapTruongInfo.strIDSV_SinhVien].ToString()); }
public void ToDataRow(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo, ref DataRow dr) { dr[pSV_SinhVienNhapTruongInfo.strSV_SinhVienNhapTruongID] = pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID; dr[pSV_SinhVienNhapTruongInfo.strHoVaTenTS] = pSV_SinhVienNhapTruongInfo.HoVaTenTS; dr[pSV_SinhVienNhapTruongInfo.strTenTS] = pSV_SinhVienNhapTruongInfo.TenTS; dr[pSV_SinhVienNhapTruongInfo.strNgaySinhTS] = pSV_SinhVienNhapTruongInfo.NgaySinhTS; dr[pSV_SinhVienNhapTruongInfo.strSoBaoDanhTS] = pSV_SinhVienNhapTruongInfo.SoBaoDanhTS; dr[pSV_SinhVienNhapTruongInfo.strNoiSinhTS] = pSV_SinhVienNhapTruongInfo.NoiSinhTS; dr[pSV_SinhVienNhapTruongInfo.strThuongTruTS] = pSV_SinhVienNhapTruongInfo.ThuongTruTS; dr[pSV_SinhVienNhapTruongInfo.strGioiTinhTS] = pSV_SinhVienNhapTruongInfo.GioiTinhTS; dr[pSV_SinhVienNhapTruongInfo.strKhoiThi] = pSV_SinhVienNhapTruongInfo.KhoiThi; dr[pSV_SinhVienNhapTruongInfo.strNganhThi] = pSV_SinhVienNhapTruongInfo.NganhThi; dr[pSV_SinhVienNhapTruongInfo.strKyHieuTruong] = pSV_SinhVienNhapTruongInfo.KyHieuTruong; dr[pSV_SinhVienNhapTruongInfo.strDanToc] = pSV_SinhVienNhapTruongInfo.DanToc; dr[pSV_SinhVienNhapTruongInfo.strDoiTuongTuyenSinh] = pSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh; dr[pSV_SinhVienNhapTruongInfo.strXLHocLuc] = pSV_SinhVienNhapTruongInfo.XLHocLuc; dr[pSV_SinhVienNhapTruongInfo.strXLHanhKiem] = pSV_SinhVienNhapTruongInfo.XLHanhKiem; dr[pSV_SinhVienNhapTruongInfo.strXLTotNghiep] = pSV_SinhVienNhapTruongInfo.XLTotNghiep; dr[pSV_SinhVienNhapTruongInfo.strNamTotNghiep] = pSV_SinhVienNhapTruongInfo.NamTotNghiep; dr[pSV_SinhVienNhapTruongInfo.strKhuVucTuyenSinh] = pSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh; dr[pSV_SinhVienNhapTruongInfo.strDiemMon1] = pSV_SinhVienNhapTruongInfo.DiemMon1; dr[pSV_SinhVienNhapTruongInfo.strDiemMon2] = pSV_SinhVienNhapTruongInfo.DiemMon2; dr[pSV_SinhVienNhapTruongInfo.strDiemMon3] = pSV_SinhVienNhapTruongInfo.DiemMon3; dr[pSV_SinhVienNhapTruongInfo.strDiemMon4] = pSV_SinhVienNhapTruongInfo.DiemMon4; dr[pSV_SinhVienNhapTruongInfo.strDiemThuong] = pSV_SinhVienNhapTruongInfo.DiemThuong; dr[pSV_SinhVienNhapTruongInfo.strTongDiemLamTron] = pSV_SinhVienNhapTruongInfo.TongDiemLamTron; dr[pSV_SinhVienNhapTruongInfo.strTuyenThang] = pSV_SinhVienNhapTruongInfo.TuyenThang; dr[pSV_SinhVienNhapTruongInfo.strLyDo] = pSV_SinhVienNhapTruongInfo.LyDo; dr[pSV_SinhVienNhapTruongInfo.strNgayNhapTruong] = pSV_SinhVienNhapTruongInfo.NgayNhapTruong; dr[pSV_SinhVienNhapTruongInfo.strIDDM_NamHoc] = pSV_SinhVienNhapTruongInfo.IDDM_NamHoc; dr[pSV_SinhVienNhapTruongInfo.strIDNguoiTiepNhan] = pSV_SinhVienNhapTruongInfo.IDNguoiTiepNhan; dr[pSV_SinhVienNhapTruongInfo.strIDSV_SinhVien] = pSV_SinhVienNhapTruongInfo.IDSV_SinhVien; }
public dlgThemSinhVienNhapHoc() { InitializeComponent(); pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong(); this.DialogResult = DialogResult.Cancel; }
public DataTable Get(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SV_SinhVienNhapTruongID", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID)); return(RunProcedureGet("sp_SV_SinhVienNhapTruong_Get", colParam)); }
public void Delete(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@SV_SinhVienNhapTruongID", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID)); RunProcedure("sp_SV_SinhVienNhapTruong_Delete", colParam); }
public int Add(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { int ID = 0; ID = oDSV_SinhVienNhapTruong.Add(pSV_SinhVienNhapTruongInfo); mErrorMessage = oDSV_SinhVienNhapTruong.ErrorMessages; mErrorNumber = oDSV_SinhVienNhapTruong.ErrorNumber; return(ID); }
public void UpdateNhapTruong(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@NgayNhapTruong", SqlDbType.DateTime, pSV_SinhVienNhapTruongInfo.NgayNhapTruong)); colParam.Add(CreateParam("@IDNguoiTiepNhan", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.IDNguoiTiepNhan)); colParam.Add(CreateParam("@SV_SinhVienNhapTruongID", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID)); RunProcedure("sp_SV_SinhVienNhapTruong_UpdateNhapTruong", colParam); }
public frmGoiNhapHoc() { InitializeComponent(); this.Text += " - NAM HOC: " + Program.NamHoc; oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong(); pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); oBSV_SinhVien_GiayToNhapTruong = new cBSV_SinhVien_GiayToNhapTruong(); pSV_SinhVien_GiayToNhapTruongInfo = new SV_SinhVien_GiayToNhapTruongInfo(); repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinh(); dtpNgayNhapHoc.EditValue = DateTime.Now; cmbTrinhDo.Properties.DataSource = LoadTrinhDo(); cmbKhoaHoc.Properties.DataSource = LoadKhoaHoc(); }
public dlgBienLaiThuTienNhapHoc(DataRow mdr, bool mSua) { InitializeComponent(); oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong(); 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_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); dtpNgay.EditValue = DateTime.Now; Sua = mSua; dr = mdr; }
public List <SV_SinhVienNhapTruongInfo> GetList(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { List <SV_SinhVienNhapTruongInfo> oSV_SinhVienNhapTruongInfoList = new List <SV_SinhVienNhapTruongInfo>(); DataTable dtb = Get(pSV_SinhVienNhapTruongInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); oSV_SinhVienNhapTruongInfo.SV_SinhVienNhapTruongID = int.Parse(dtb.Rows[i]["SV_SinhVienNhapTruongID"].ToString()); oSV_SinhVienNhapTruongInfo.HoVaTenTS = dtb.Rows[i]["HoVaTenTS"].ToString(); oSV_SinhVienNhapTruongInfo.TenTS = dtb.Rows[i]["TenTS"].ToString(); oSV_SinhVienNhapTruongInfo.NgaySinhTS = DateTime.Parse(dtb.Rows[i]["NgaySinhTS"].ToString()); oSV_SinhVienNhapTruongInfo.SoBaoDanhTS = dtb.Rows[i]["SoBaoDanhTS"].ToString(); oSV_SinhVienNhapTruongInfo.NoiSinhTS = dtb.Rows[i]["NoiSinhTS"].ToString(); oSV_SinhVienNhapTruongInfo.ThuongTruTS = dtb.Rows[i]["ThuongTruTS"].ToString(); oSV_SinhVienNhapTruongInfo.GioiTinhTS = int.Parse(dtb.Rows[i]["GioiTinhTS"].ToString()); oSV_SinhVienNhapTruongInfo.KhoiThi = dtb.Rows[i]["KhoiThi"].ToString(); oSV_SinhVienNhapTruongInfo.NganhThi = dtb.Rows[i]["NganhThi"].ToString(); oSV_SinhVienNhapTruongInfo.KyHieuTruong = dtb.Rows[i]["KyHieuTruong"].ToString(); oSV_SinhVienNhapTruongInfo.DanToc = dtb.Rows[i]["DanToc"].ToString(); oSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh = dtb.Rows[i]["DoiTuongTuyenSinh"].ToString(); oSV_SinhVienNhapTruongInfo.XLHocLuc = dtb.Rows[i]["XLHocLuc"].ToString(); oSV_SinhVienNhapTruongInfo.XLHanhKiem = dtb.Rows[i]["XLHanhKiem"].ToString(); oSV_SinhVienNhapTruongInfo.XLTotNghiep = dtb.Rows[i]["XLTotNghiep"].ToString(); oSV_SinhVienNhapTruongInfo.NamTotNghiep = dtb.Rows[i]["NamTotNghiep"].ToString(); oSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh = dtb.Rows[i]["KhuVucTuyenSinh"].ToString(); oSV_SinhVienNhapTruongInfo.DiemMon1 = double.Parse(dtb.Rows[i]["DiemMon1"].ToString()); oSV_SinhVienNhapTruongInfo.DiemMon2 = double.Parse(dtb.Rows[i]["DiemMon2"].ToString()); oSV_SinhVienNhapTruongInfo.DiemMon3 = double.Parse(dtb.Rows[i]["DiemMon3"].ToString()); oSV_SinhVienNhapTruongInfo.DiemMon4 = double.Parse(dtb.Rows[i]["DiemMon4"].ToString()); oSV_SinhVienNhapTruongInfo.DiemThuong = double.Parse(dtb.Rows[i]["DiemThuong"].ToString()); oSV_SinhVienNhapTruongInfo.TongDiemLamTron = double.Parse(dtb.Rows[i]["TongDiemLamTron"].ToString()); oSV_SinhVienNhapTruongInfo.TuyenThang = bool.Parse(dtb.Rows[i]["TuyenThang"].ToString()); oSV_SinhVienNhapTruongInfo.LyDo = dtb.Rows[i]["LyDo"].ToString(); oSV_SinhVienNhapTruongInfo.NgayNhapTruong = DateTime.Parse(dtb.Rows[i]["NgayNhapTruong"].ToString()); oSV_SinhVienNhapTruongInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString()); oSV_SinhVienNhapTruongInfo.IDNguoiTiepNhan = int.Parse(dtb.Rows[i]["IDNguoiTiepNhan"].ToString()); oSV_SinhVienNhapTruongInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oSV_SinhVienNhapTruongInfoList.Add(oSV_SinhVienNhapTruongInfo); } } return(oSV_SinhVienNhapTruongInfoList); }
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 int Add(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@HoVaTenTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.HoVaTenTS)); colParam.Add(CreateParam("@TenTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.TenTS)); colParam.Add(CreateParam("@NgaySinhTS", SqlDbType.DateTime, pSV_SinhVienNhapTruongInfo.NgaySinhTS)); colParam.Add(CreateParam("@SoBaoDanhTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.SoBaoDanhTS)); colParam.Add(CreateParam("@NoiSinhTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.NoiSinhTS)); colParam.Add(CreateParam("@ThuongTruTS", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.ThuongTruTS)); colParam.Add(CreateParam("@GioiTinhTS", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.GioiTinhTS)); colParam.Add(CreateParam("@KhoiThi", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KhoiThi)); colParam.Add(CreateParam("@NganhThi", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.NganhThi)); colParam.Add(CreateParam("@KyHieuTruong", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KyHieuTruong)); colParam.Add(CreateParam("@DanToc", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.DanToc)); colParam.Add(CreateParam("@DoiTuongTuyenSinh", SqlDbType.NChar, pSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh)); colParam.Add(CreateParam("@XLHocLuc", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLHocLuc)); colParam.Add(CreateParam("@XLHanhKiem", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLHanhKiem)); colParam.Add(CreateParam("@XLTotNghiep", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.XLTotNghiep)); colParam.Add(CreateParam("@NamTotNghiep", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.NamTotNghiep)); colParam.Add(CreateParam("@KhuVucTuyenSinh", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh)); colParam.Add(CreateParam("@DiemMon1", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon1)); colParam.Add(CreateParam("@DiemMon2", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon2)); colParam.Add(CreateParam("@DiemMon3", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon3)); colParam.Add(CreateParam("@DiemMon4", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemMon4)); colParam.Add(CreateParam("@DiemThuong", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.DiemThuong)); colParam.Add(CreateParam("@TongDiemLamTron", SqlDbType.Float, pSV_SinhVienNhapTruongInfo.TongDiemLamTron)); colParam.Add(CreateParam("@TuyenThang", SqlDbType.Bit, pSV_SinhVienNhapTruongInfo.TuyenThang)); colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pSV_SinhVienNhapTruongInfo.LyDo)); colParam.Add(CreateParam("@NgayNhapTruong", SqlDbType.DateTime, pSV_SinhVienNhapTruongInfo.NgayNhapTruong)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@IDNguoiTiepNhan", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.IDNguoiTiepNhan)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_SinhVienNhapTruongInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@DaXetDuyet", SqlDbType.Bit, pSV_SinhVienNhapTruongInfo.DaXetDuyet)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_SV_SinhVienNhapTruong_Add", colParam)); }
public void UpdateHoSo(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { oDSV_SinhVienNhapTruong.UpdateHoSo(pSV_SinhVienNhapTruongInfo); mErrorMessage = oDSV_SinhVienNhapTruong.ErrorMessages; mErrorNumber = oDSV_SinhVienNhapTruong.ErrorNumber; }
public void ToInfo(ref SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo, DataRow dr, DataTable dt) { pSV_SinhVienNhapTruongInfo.HoVaTenTS = dr["HoVaTen"].ToString(); pSV_SinhVienNhapTruongInfo.TenTS = GetTen(dr["HoVaTen"].ToString()); if (dt.Columns.Contains("NgaySinh") && "" + dr["NgaySinh"] != "") { pSV_SinhVienNhapTruongInfo.NgaySinhTS = DateTime.Parse(dr["NgaySinh"].ToString()); } else { pSV_SinhVienNhapTruongInfo.NgaySinhTS = DateTime.Parse("1/1/1900"); } if (dt.Columns.Contains("SoBaoDanh")) { pSV_SinhVienNhapTruongInfo.SoBaoDanhTS = "" + dr["SoBaoDanh"].ToString(); } if (dt.Columns.Contains("NoiSinh")) { pSV_SinhVienNhapTruongInfo.NoiSinhTS = "" + dr["NoiSinh"].ToString(); } if (dt.Columns.Contains("ThuongTru")) { pSV_SinhVienNhapTruongInfo.ThuongTruTS = "" + dr["ThuongTru"].ToString(); } if (dt.Columns.Contains("GioiTinh")) { pSV_SinhVienNhapTruongInfo.GioiTinhTS = int.Parse("0" + dr["GioiTinh"].ToString()); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strKhoiThi)) { pSV_SinhVienNhapTruongInfo.KhoiThi = "" + dr[pSV_SinhVienNhapTruongInfo.strKhoiThi].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strNganhThi)) { pSV_SinhVienNhapTruongInfo.NganhThi = "" + dr[pSV_SinhVienNhapTruongInfo.strNganhThi].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDanToc)) { pSV_SinhVienNhapTruongInfo.DanToc = "" + dr[pSV_SinhVienNhapTruongInfo.strDanToc].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDoiTuongTuyenSinh)) { pSV_SinhVienNhapTruongInfo.DoiTuongTuyenSinh = "" + dr[pSV_SinhVienNhapTruongInfo.strDoiTuongTuyenSinh].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strNamTotNghiep)) { pSV_SinhVienNhapTruongInfo.NamTotNghiep = "" + dr[pSV_SinhVienNhapTruongInfo.strNamTotNghiep].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strKhuVucTuyenSinh)) { pSV_SinhVienNhapTruongInfo.KhuVucTuyenSinh = "" + dr[pSV_SinhVienNhapTruongInfo.strKhuVucTuyenSinh].ToString(); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDiemMon1) && "" + dr[pSV_SinhVienNhapTruongInfo.strDiemMon1] != "") { pSV_SinhVienNhapTruongInfo.DiemMon1 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon1].ToString()); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDiemMon2) && "" + dr[pSV_SinhVienNhapTruongInfo.strDiemMon2] != "") { pSV_SinhVienNhapTruongInfo.DiemMon2 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon2].ToString()); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDiemMon3) && "" + dr[pSV_SinhVienNhapTruongInfo.strDiemMon3] != "") { pSV_SinhVienNhapTruongInfo.DiemMon3 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon3].ToString()); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strDiemMon4) && "" + dr[pSV_SinhVienNhapTruongInfo.strDiemMon4] != "") { pSV_SinhVienNhapTruongInfo.DiemMon4 = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strDiemMon4].ToString()); } if (dt.Columns.Contains(pSV_SinhVienNhapTruongInfo.strTongDiemLamTron) && "" + dr[pSV_SinhVienNhapTruongInfo.strTongDiemLamTron] != "") { pSV_SinhVienNhapTruongInfo.TongDiemLamTron = double.Parse(dr[pSV_SinhVienNhapTruongInfo.strTongDiemLamTron].ToString()); } pSV_SinhVienNhapTruongInfo.NgayNhapTruong = DateTime.Parse("1/1/1900"); }
public DataTable Get(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { return(oDSV_SinhVienNhapTruong.Get(pSV_SinhVienNhapTruongInfo)); }
public frmThuTienNhapHoc() { InitializeComponent(); oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong(); pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo(); }
public void Delete(SV_SinhVienNhapTruongInfo pSV_SinhVienNhapTruongInfo) { oDSV_SinhVienNhapTruong.Delete(pSV_SinhVienNhapTruongInfo); mErrorMessage = oDSV_SinhVienNhapTruong.ErrorMessages; mErrorNumber = oDSV_SinhVienNhapTruong.ErrorNumber; }