private void bw_DoWork(object sender, DoWorkEventArgs e)
{
try
{
FilePath = saveFileDialog1.FileName;
ExportOptions eo = new ExportOptions();
eo.ExportDestinationType = ExportDestinationType.DiskFile;
string Extension = Path.GetExtension(FilePath);
switch (Extension.ToUpper().Trim())
{
case ".DOC":
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
case ".DOCX":
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
case ".XLS":
eo.ExportFormatType = ExportFormatType.Excel;
break;
case ".XLSX":
eo.ExportFormatType = ExportFormatType.Excel;
break;
case ".PDF":
eo.ExportFormatType = ExportFormatType.PortableDocFormat;
break;
default:
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
}
DiskFileDestinationOptions DestOption = new DiskFileDestinationOptions();
DestOption.DiskFileName = FilePath;
eo.ExportDestinationOptions = DestOption;
ma_nv = oThongTinCNVC.txt_MaNV.Text;
oCNVC.MaNV = oCNVC_CMND_HoChieu.MaNV = oCNVC_ThongTinPhu.MaNV =
oCNVC_ThongTinTuyenDung.MaNV = oCNVC_ChinhTri.MaNV = oCNVC_ChinhTriExt.Ma_NV =
oCNVC_ChuyenMonTongQuat.MaNV = oCNVC_DienBienSK.MaNV = oCNVC_DaoTaoBoiDuong.MaNV =
oCNVC_QTr_CongTac_OU.MaNV = oCNVC_LSBiBat.MaNV = oCNVC_QHGiaDinh.MaNV = oCNVC_QuanHeToChuc.MaNV = ma_nv;
Init_Table_CNVC_QTr_CongTac_OU_ChinhTri_ChucVu();
Prepare_ThongTinAll();
DataTable dt_ThongTinTuyenDung = oCNVC_ThongTinTuyenDung.GetData();
Reports.NV_BoNoiVu rpt = new Reports.NV_BoNoiVu();
rpt.Database.Tables["ThongTinChinh"].SetDataSource(dt_ThongTinChinh);
rpt.Database.Tables["CMND_HoChieu"].SetDataSource(dt_CMND);
rpt.Database.Tables["ThongTinPhu"].SetDataSource(dt_ThongTinPhu);
rpt.Database.Tables["ThongTinTuyenDung"].SetDataSource(dt_ThongTinTuyenDung);
rpt.Database.Tables["ChucDanh_ChucVu"].SetDataSource(dt_ChucDanh_ChucVu);
rpt.Database.Tables["ThongTinLuong"].SetDataSource(dt_ThongTinLuong);
rpt.Database.Tables["ChuyenMonTongQuat"].SetDataSource(dt_ChuyenMonTongQuat);
rpt.Database.Tables["ChinhTri"].SetDataSource(dt_ChinhTri);
rpt.Database.Tables["ChinhTriExt"].SetDataSource(dt_ChinhTriExt);
rpt.Database.Tables["ChinhTri_HCCB"].SetDataSource(dt_Chinh_Tri_HCCB);
rpt.Database.Tables["SucKhoe"].SetDataSource(dt_SucKhoe);
rpt.Database.Tables["DaoTaoBoiDuong"].SetDataSource(dt_DaoTaoBoiDuong);
rpt.Database.Tables["QtrCtac_ChucVuChinhTri"].SetDataSource(dt_CNVC_QTr_CongTac_OU_ChinhTri_ChucVu);
rpt.Database.Tables["QHGiaDinh"].SetDataSource(dt_CNVC_QHGiaDinh_nuoc_ngoai);
rpt.Database.Tables["QuanHeToChuc"].SetDataSource(dt_CNVC_QuanHeToChuc);
rpt.Database.Tables["tb_LSBiBat"].SetDataSource(dt_CNVC_LSBiBat);
rpt.Database.Tables["QHGiaDinh_BanThan"].SetDataSource(dt_CNVC_QHGiaDinh_BanThan);
rpt.Database.Tables["QHGiaDinh_VoHoacChong"].SetDataSource(dt_CNVC_QHGiaDinh_VoHoacChong);
rpt.Database.Tables["DienBienLuong"].SetDataSource(dt_DienBienLuong);
rpt.Export(eo);
MessageBox.Show("Xuất báo cáo hoàn tất", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Xuất báo cáo không thành công, xin vui lòng thử lại sau", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
bw.ReportProgress(100);
}
}
private void bw_DoWork(object sender, DoWorkEventArgs e)
{
try
{
FilePath = saveFileDialog1.FileName;
ExportOptions eo = new ExportOptions();
eo.ExportDestinationType = ExportDestinationType.DiskFile;
string Extension = Path.GetExtension(FilePath);
switch (Extension.ToUpper().Trim())
{
case ".DOC":
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
case ".DOCX":
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
case ".XLS":
eo.ExportFormatType = ExportFormatType.Excel;
break;
case ".XLSX":
eo.ExportFormatType = ExportFormatType.Excel;
break;
case ".PDF":
eo.ExportFormatType = ExportFormatType.PortableDocFormat;
break;
default:
eo.ExportFormatType = ExportFormatType.WordForWindows;
break;
}
DiskFileDestinationOptions DestOption = new DiskFileDestinationOptions();
DestOption.DiskFileName = FilePath;
eo.ExportDestinationOptions = DestOption;
ma_nv = oThongTinCNVC.txt_MaNV.Text;
oCNVC.MaNV = oCNVC_CMND_HoChieu.MaNV = oCNVC_ThongTinPhu.MaNV =
oCNVC_ThongTinTuyenDung.MaNV = oCNVC_ChinhTri.MaNV = oCNVC_ChinhTriExt.Ma_NV =
oCNVC_ChuyenMonTongQuat.MaNV = oCNVC_DienBienSK.MaNV = oCNVC_DaoTaoBoiDuong.MaNV =
oCNVC_QTr_CongTac_OU.MaNV = oCNVC_LSBiBat.MaNV = oCNVC_QHGiaDinh.MaNV = oCNVC_QuanHeToChuc.MaNV = ma_nv;
Init_Table_CNVC_QTr_CongTac_OU_ChinhTri_ChucVu();
Prepare_ThongTinAll();
DataTable dt_ThongTinTuyenDung = oCNVC_ThongTinTuyenDung.GetData();
Reports.NV_BoNoiVu rpt = new Reports.NV_BoNoiVu();
rpt.Database.Tables["ThongTinChinh"].SetDataSource(dt_ThongTinChinh);
rpt.Database.Tables["CMND_HoChieu"].SetDataSource(dt_CMND);
rpt.Database.Tables["ThongTinPhu"].SetDataSource(dt_ThongTinPhu);
rpt.Database.Tables["ThongTinTuyenDung"].SetDataSource(dt_ThongTinTuyenDung);
rpt.Database.Tables["ChucDanh_ChucVu"].SetDataSource(dt_ChucDanh_ChucVu);
rpt.Database.Tables["ThongTinLuong"].SetDataSource(dt_ThongTinLuong);
rpt.Database.Tables["ChuyenMonTongQuat"].SetDataSource(dt_ChuyenMonTongQuat);
rpt.Database.Tables["ChinhTri"].SetDataSource(dt_ChinhTri);
rpt.Database.Tables["ChinhTriExt"].SetDataSource(dt_ChinhTriExt);
rpt.Database.Tables["ChinhTri_HCCB"].SetDataSource(dt_Chinh_Tri_HCCB);
rpt.Database.Tables["SucKhoe"].SetDataSource(dt_SucKhoe);
rpt.Database.Tables["DaoTaoBoiDuong"].SetDataSource(dt_DaoTaoBoiDuong);
rpt.Database.Tables["QtrCtac_ChucVuChinhTri"].SetDataSource(dt_CNVC_QTr_CongTac_OU_ChinhTri_ChucVu);
rpt.Database.Tables["QHGiaDinh"].SetDataSource(dt_CNVC_QHGiaDinh_nuoc_ngoai);
rpt.Database.Tables["QuanHeToChuc"].SetDataSource(dt_CNVC_QuanHeToChuc);
rpt.Database.Tables["tb_LSBiBat"].SetDataSource(dt_CNVC_LSBiBat);
rpt.Database.Tables["QHGiaDinh_BanThan"].SetDataSource(dt_CNVC_QHGiaDinh_BanThan);
rpt.Database.Tables["QHGiaDinh_VoHoacChong"].SetDataSource(dt_CNVC_QHGiaDinh_VoHoacChong);
rpt.Database.Tables["DienBienLuong"].SetDataSource(dt_DienBienLuong);
rpt.Export(eo);
MessageBox.Show("Xuất báo cáo hoàn tất", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception)
{
MessageBox.Show("Xuất báo cáo không thành công, xin vui lòng thử lại sau", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
bw.ReportProgress(100);
}
}
