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 GetHopDongTuyenDung(string p_ma_nv) { oTTTuyenDung.MaNV = p_ma_nv; dtTTTuyenDung = oTTTuyenDung.GetData(); }