public void ToInfo(ref NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo, DataRow dr)
{
pNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID = int.Parse(dr[pNS_GiaoVien_ThongTinInfo.strNS_GiaoVien_ThongTinID].ToString());
pNS_GiaoVien_ThongTinInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDNS_GiaoVien]);
pNS_GiaoVien_ThongTinInfo.NgheNghiepTuyenDung = dr[pNS_GiaoVien_ThongTinInfo.strNgheNghiepTuyenDung].ToString();
if (dr[pNS_GiaoVien_ThongTinInfo.strNgayTuyenDung].ToString() != "")
{
pNS_GiaoVien_ThongTinInfo.NgayTuyenDung = DateTime.Parse(dr[pNS_GiaoVien_ThongTinInfo.strNgayTuyenDung].ToString());
}
pNS_GiaoVien_ThongTinInfo.IDDM_ChucDanh = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_ChucDanh]);
pNS_GiaoVien_ThongTinInfo.IDDM_HocHam = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_HocHam]);
pNS_GiaoVien_ThongTinInfo.IDDM_HocVi = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_HocVi]);
pNS_GiaoVien_ThongTinInfo.TrinhDoPhoThong = dr[pNS_GiaoVien_ThongTinInfo.strTrinhDoPhoThong].ToString();
pNS_GiaoVien_ThongTinInfo.TrinhDoTinHoc = dr[pNS_GiaoVien_ThongTinInfo.strTrinhDoTinHoc].ToString();
pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoChuyenMon = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_TrinhDoChuyenMon]);
pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoLyLuan = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_TrinhDoLyLuan]);
pNS_GiaoVien_ThongTinInfo.IDDM_QuanLyHanhChinhNhaNuoc = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_QuanLyHanhChinhNhaNuoc]);
if (dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDang].ToString() != "")
{
pNS_GiaoVien_ThongTinInfo.NgayVaoDang = DateTime.Parse(dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDang].ToString());
}
if (dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDangChinhThuc].ToString() != "")
{
pNS_GiaoVien_ThongTinInfo.NgayVaoDangChinhThuc = DateTime.Parse(dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDangChinhThuc].ToString());
}
pNS_GiaoVien_ThongTinInfo.IDDM_DanhHieuDuocPhongTang = int.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strIDDM_DanhHieuDuocPhongTang]);
pNS_GiaoVien_ThongTinInfo.SoTruongCongTac = dr[pNS_GiaoVien_ThongTinInfo.strSoTruongCongTac].ToString();
pNS_GiaoVien_ThongTinInfo.TinhTrangSucKhoe = dr[pNS_GiaoVien_ThongTinInfo.strTinhTrangSucKhoe].ToString();
pNS_GiaoVien_ThongTinInfo.ChieuCao = double.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strChieuCao]);
pNS_GiaoVien_ThongTinInfo.CanNang = double.Parse("0" + dr[pNS_GiaoVien_ThongTinInfo.strCanNang]);
pNS_GiaoVien_ThongTinInfo.NhomMau = dr[pNS_GiaoVien_ThongTinInfo.strNhomMau].ToString();
pNS_GiaoVien_ThongTinInfo.SoSoBaoHiemXaHoi = dr[pNS_GiaoVien_ThongTinInfo.strSoSoBaoHiemXaHoi].ToString();
}
public void Update(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@NgheNghiepTuyenDung", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.NgheNghiepTuyenDung));
colParam.Add(CreateParam("@NgayTuyenDung", SqlDbType.DateTime, pNS_GiaoVien_ThongTinInfo.NgayTuyenDung));
colParam.Add(CreateParam("@IsGiaoVienChinhTri", SqlDbType.Bit, pNS_GiaoVien_ThongTinInfo.IsGiaoVienChinhTri));
colParam.Add(CreateParam("@IDDM_ChucDanh", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_ChucDanh));
colParam.Add(CreateParam("@IDDM_HocHam", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_HocHam));
colParam.Add(CreateParam("@IDDM_HocVi", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_HocVi));
colParam.Add(CreateParam("@TrinhDoPhoThong", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.TrinhDoPhoThong));
colParam.Add(CreateParam("@IDTrinhDoTinHoc", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.IDTrinhDoTinHoc));
colParam.Add(CreateParam("@TrinhDoTinHoc", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.TrinhDoTinHoc));
colParam.Add(CreateParam("@IDDM_TrinhDoChuyenMon", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoChuyenMon));
colParam.Add(CreateParam("@IDDM_TrinhDoLyLuan", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoLyLuan));
colParam.Add(CreateParam("@IDDM_QuanLyHanhChinhNhaNuoc", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_QuanLyHanhChinhNhaNuoc));
colParam.Add(CreateParam("@NgayVaoDang", SqlDbType.DateTime, pNS_GiaoVien_ThongTinInfo.NgayVaoDang));
colParam.Add(CreateParam("@NgayVaoDangChinhThuc", SqlDbType.DateTime, pNS_GiaoVien_ThongTinInfo.NgayVaoDangChinhThuc));
colParam.Add(CreateParam("@IDDM_DanhHieuDuocPhongTang", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.IDDM_DanhHieuDuocPhongTang));
colParam.Add(CreateParam("@SoTruongCongTac", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.SoTruongCongTac));
colParam.Add(CreateParam("@TinhTrangSucKhoe", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.TinhTrangSucKhoe));
colParam.Add(CreateParam("@ChieuCao", SqlDbType.Float, pNS_GiaoVien_ThongTinInfo.ChieuCao));
colParam.Add(CreateParam("@CanNang", SqlDbType.Float, pNS_GiaoVien_ThongTinInfo.CanNang));
colParam.Add(CreateParam("@NhomMau", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.NhomMau));
colParam.Add(CreateParam("@SoSoBaoHiemXaHoi", SqlDbType.NVarChar, pNS_GiaoVien_ThongTinInfo.SoSoBaoHiemXaHoi));
colParam.Add(CreateParam("@NS_GiaoVien_ThongTinID", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID));
RunProcedure("sp_NS_GiaoVien_ThongTin_Update", colParam);
}
public void Delete(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_GiaoVien_ThongTinID", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID));
RunProcedure("sp_NS_GiaoVien_ThongTin_Delete", colParam);
}
public DataTable Get(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_GiaoVien_ThongTinID", SqlDbType.Int, pNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID));
return(RunProcedureGet("sp_NS_GiaoVien_ThongTin_Get", colParam));
}
public int Add(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
int ID = 0;
ID = oDNS_GiaoVien_ThongTin.Add(pNS_GiaoVien_ThongTinInfo);
mErrorMessage = oDNS_GiaoVien_ThongTin.ErrorMessages;
mErrorNumber = oDNS_GiaoVien_ThongTin.ErrorNumber;
return(ID);
}
public List <NS_GiaoVien_ThongTinInfo> GetList(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
List <NS_GiaoVien_ThongTinInfo> oNS_GiaoVien_ThongTinInfoList = new List <NS_GiaoVien_ThongTinInfo>();
DataTable dtb = Get(pNS_GiaoVien_ThongTinInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_GiaoVien_ThongTinInfo = new NS_GiaoVien_ThongTinInfo();
oNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID = int.Parse(dtb.Rows[i]["NS_GiaoVien_ThongTinID"].ToString());
oNS_GiaoVien_ThongTinInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_GiaoVien_ThongTinInfo.NgheNghiepTuyenDung = dtb.Rows[i]["NgheNghiepTuyenDung"].ToString();
oNS_GiaoVien_ThongTinInfo.NgayTuyenDung = DateTime.Parse(dtb.Rows[i]["NgayTuyenDung"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_ChucDanh = int.Parse(dtb.Rows[i]["IDDM_ChucDanh"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_HocHam = int.Parse(dtb.Rows[i]["IDDM_HocHam"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_HocVi = int.Parse(dtb.Rows[i]["IDDM_HocVi"].ToString());
oNS_GiaoVien_ThongTinInfo.TrinhDoPhoThong = dtb.Rows[i]["TrinhDoPhoThong"].ToString();
oNS_GiaoVien_ThongTinInfo.TrinhDoTinHoc = dtb.Rows[i]["TrinhDoTinHoc"].ToString();
oNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoChuyenMon = int.Parse(dtb.Rows[i]["IDDM_TrinhDoChuyenMon"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoLyLuan = int.Parse(dtb.Rows[i]["IDDM_TrinhDoLyLuan"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_QuanLyHanhChinhNhaNuoc = int.Parse(dtb.Rows[i]["IDDM_QuanLyHanhChinhNhaNuoc"].ToString());
oNS_GiaoVien_ThongTinInfo.NgayVaoDang = DateTime.Parse(dtb.Rows[i]["NgayVaoDang"].ToString());
oNS_GiaoVien_ThongTinInfo.NgayVaoDangChinhThuc = DateTime.Parse(dtb.Rows[i]["NgayVaoDangChinhThuc"].ToString());
oNS_GiaoVien_ThongTinInfo.IDDM_DanhHieuDuocPhongTang = int.Parse(dtb.Rows[i]["IDDM_DanhHieuDuocPhongTang"].ToString());
oNS_GiaoVien_ThongTinInfo.SoTruongCongTac = dtb.Rows[i]["SoTruongCongTac"].ToString();
oNS_GiaoVien_ThongTinInfo.TinhTrangSucKhoe = dtb.Rows[i]["TinhTrangSucKhoe"].ToString();
oNS_GiaoVien_ThongTinInfo.ChieuCao = double.Parse(dtb.Rows[i]["ChieuCao"].ToString());
oNS_GiaoVien_ThongTinInfo.CanNang = double.Parse(dtb.Rows[i]["CanNang"].ToString());
oNS_GiaoVien_ThongTinInfo.NhomMau = dtb.Rows[i]["NhomMau"].ToString();
oNS_GiaoVien_ThongTinInfo.SoSoBaoHiemXaHoi = dtb.Rows[i]["SoSoBaoHiemXaHoi"].ToString();
oNS_GiaoVien_ThongTinInfoList.Add(oNS_GiaoVien_ThongTinInfo);
}
}
return(oNS_GiaoVien_ThongTinInfoList);
}
public void ToDataRow(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo, ref DataRow dr)
{
dr[pNS_GiaoVien_ThongTinInfo.strNS_GiaoVien_ThongTinID] = pNS_GiaoVien_ThongTinInfo.NS_GiaoVien_ThongTinID;
dr[pNS_GiaoVien_ThongTinInfo.strIDNS_GiaoVien] = pNS_GiaoVien_ThongTinInfo.IDNS_GiaoVien;
dr[pNS_GiaoVien_ThongTinInfo.strNgheNghiepTuyenDung] = pNS_GiaoVien_ThongTinInfo.NgheNghiepTuyenDung;
dr[pNS_GiaoVien_ThongTinInfo.strNgayTuyenDung] = pNS_GiaoVien_ThongTinInfo.NgayTuyenDung;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_ChucDanh] = pNS_GiaoVien_ThongTinInfo.IDDM_ChucDanh;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_HocHam] = pNS_GiaoVien_ThongTinInfo.IDDM_HocHam;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_HocVi] = pNS_GiaoVien_ThongTinInfo.IDDM_HocVi;
dr[pNS_GiaoVien_ThongTinInfo.strTrinhDoPhoThong] = pNS_GiaoVien_ThongTinInfo.TrinhDoPhoThong;
dr[pNS_GiaoVien_ThongTinInfo.strTrinhDoTinHoc] = pNS_GiaoVien_ThongTinInfo.TrinhDoTinHoc;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_TrinhDoChuyenMon] = pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoChuyenMon;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_TrinhDoLyLuan] = pNS_GiaoVien_ThongTinInfo.IDDM_TrinhDoLyLuan;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_QuanLyHanhChinhNhaNuoc] = pNS_GiaoVien_ThongTinInfo.IDDM_QuanLyHanhChinhNhaNuoc;
dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDang] = pNS_GiaoVien_ThongTinInfo.NgayVaoDang;
dr[pNS_GiaoVien_ThongTinInfo.strNgayVaoDangChinhThuc] = pNS_GiaoVien_ThongTinInfo.NgayVaoDangChinhThuc;
dr[pNS_GiaoVien_ThongTinInfo.strIDDM_DanhHieuDuocPhongTang] = pNS_GiaoVien_ThongTinInfo.IDDM_DanhHieuDuocPhongTang;
dr[pNS_GiaoVien_ThongTinInfo.strSoTruongCongTac] = pNS_GiaoVien_ThongTinInfo.SoTruongCongTac;
dr[pNS_GiaoVien_ThongTinInfo.strTinhTrangSucKhoe] = pNS_GiaoVien_ThongTinInfo.TinhTrangSucKhoe;
dr[pNS_GiaoVien_ThongTinInfo.strChieuCao] = pNS_GiaoVien_ThongTinInfo.ChieuCao;
dr[pNS_GiaoVien_ThongTinInfo.strCanNang] = pNS_GiaoVien_ThongTinInfo.CanNang;
dr[pNS_GiaoVien_ThongTinInfo.strNhomMau] = pNS_GiaoVien_ThongTinInfo.NhomMau;
dr[pNS_GiaoVien_ThongTinInfo.strSoSoBaoHiemXaHoi] = pNS_GiaoVien_ThongTinInfo.SoSoBaoHiemXaHoi;
}
public void Delete(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
oDNS_GiaoVien_ThongTin.Delete(pNS_GiaoVien_ThongTinInfo);
mErrorMessage = oDNS_GiaoVien_ThongTin.ErrorMessages;
mErrorNumber = oDNS_GiaoVien_ThongTin.ErrorNumber;
}
public DataTable Get(NS_GiaoVien_ThongTinInfo pNS_GiaoVien_ThongTinInfo)
{
return(oDNS_GiaoVien_ThongTin.Get(pNS_GiaoVien_ThongTinInfo));
}