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