private void OnExportExcel() { Cursor.Current = Cursors.WaitCursor; List <DataRow> checkedRows = GetCheckedRows(); if (checkedRows.Count > 0) { foreach (DataRow row in checkedRows) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Title = "Export Excel"; dlg.Filter = "Excel Files(*.xls,*.xlsx)|*.xls;*.xlsx"; if (dlg.ShowDialog() == DialogResult.OK) { LoaiNoiSoi type = (LoaiNoiSoi)Convert.ToByte(row["LoaiNoiSoi"]); switch (type) { case LoaiNoiSoi.Tai: if (!ExportExcel.ExportKetQuaNoiSoiTaiToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.Mui: if (!ExportExcel.ExportKetQuaNoiSoiMuiToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.Hong_ThanhQuan: if (!ExportExcel.ExportKetQuaNoiSoiHongThanhQuanToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.TaiMuiHong: if (!ExportExcel.ExportKetQuaNoiSoiTaiMuiHongToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.TongQuat: if (!ExportExcel.ExportKetQuaNoiSoiTongQuatToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.DaDay: if (!ExportExcel.ExportKetQuaNoiSoiDaDayToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } case LoaiNoiSoi.TrucTrang: if (!ExportExcel.ExportKetQuaNoiSoiTrucTrangToExcel(dlg.FileName, _patientRow, row)) { return; } else { break; } } } } } else { MsgBox.Show(Application.ProductName, "Vui lòng đánh dấu những kết quả nội soi cần xuất excel.", IconType.Information); } }
private void OnPrint(bool isPreview) { Cursor.Current = Cursors.WaitCursor; List <DataRow> checkedRows = GetCheckedRows(); if (checkedRows.Count > 0) { string exportFileName = string.Format("{0}\\Temp\\KetQuaNoiSoi.xls", Application.StartupPath); if (isPreview) { foreach (DataRow row in checkedRows) { LoaiNoiSoi type = (LoaiNoiSoi)Convert.ToByte(row["LoaiNoiSoi"]); switch (type) { case LoaiNoiSoi.Tai: if (!ExportExcel.ExportKetQuaNoiSoiTaiToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Mui: if (!ExportExcel.ExportKetQuaNoiSoiMuiToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiMuiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Hong_ThanhQuan: if (!ExportExcel.ExportKetQuaNoiSoiHongThanhQuanToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiHongThanhQuanTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TaiMuiHong: if (!ExportExcel.ExportKetQuaNoiSoiTaiMuiHongToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiMuiHongTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TongQuat: if (!ExportExcel.ExportKetQuaNoiSoiTongQuatToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTongQuatTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.DaDay: if (!ExportExcel.ExportKetQuaNoiSoiDaDayToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiDaDayTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TrucTrang: if (!ExportExcel.ExportKetQuaNoiSoiTrucTrangToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.PrintPreview(exportFileName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTrucTrangTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } } } } else { if (_printDialog.ShowDialog() == DialogResult.OK) { foreach (DataRow row in checkedRows) { LoaiNoiSoi type = (LoaiNoiSoi)Convert.ToByte(row["LoaiNoiSoi"]); switch (type) { case LoaiNoiSoi.Tai: if (!ExportExcel.ExportKetQuaNoiSoiTaiToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Mui: if (!ExportExcel.ExportKetQuaNoiSoiMuiToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiMuiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Hong_ThanhQuan: if (!ExportExcel.ExportKetQuaNoiSoiHongThanhQuanToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiHongThanhQuanTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TaiMuiHong: if (!ExportExcel.ExportKetQuaNoiSoiTaiMuiHongToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiMuiHongTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TongQuat: if (!ExportExcel.ExportKetQuaNoiSoiTongQuatToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTongQuatTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.DaDay: if (!ExportExcel.ExportKetQuaNoiSoiDaDayToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiDaDayTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TrucTrang: if (!ExportExcel.ExportKetQuaNoiSoiTrucTrangToExcel(exportFileName, _patientRow, row)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTrucTrangTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } } } } } } else { MsgBox.Show(Application.ProductName, "Vui lòng đánh dấu những kết quả nội soi cần in.", IconType.Information); } }
private void OnPrint(DataRow drKetQuaNoiSoi) { Cursor.Current = Cursors.WaitCursor; if (_printDialog.ShowDialog() == DialogResult.OK) { string exportFileName = string.Format("{0}\\Temp\\KetQuaNoiSoi.xls", Application.StartupPath); LoaiNoiSoi type = (LoaiNoiSoi)Convert.ToByte(drKetQuaNoiSoi["LoaiNoiSoi"]); switch (type) { case LoaiNoiSoi.Tai: if (!ExportExcel.ExportKetQuaNoiSoiTaiToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Mui: if (!ExportExcel.ExportKetQuaNoiSoiMuiToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiMuiTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.Hong_ThanhQuan: if (!ExportExcel.ExportKetQuaNoiSoiHongThanhQuanToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiHongThanhQuanTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TaiMuiHong: if (!ExportExcel.ExportKetQuaNoiSoiTaiMuiHongToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTaiMuiHongTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TongQuat: if (!ExportExcel.ExportKetQuaNoiSoiTongQuatToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTongQuatTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.DaDay: if (!ExportExcel.ExportKetQuaNoiSoiDaDayToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiDaDayTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } case LoaiNoiSoi.TrucTrang: if (!ExportExcel.ExportKetQuaNoiSoiTrucTrangToExcel(exportFileName, _patientRow, drKetQuaNoiSoi)) { return; } else { try { ExcelPrintPreview.Print(exportFileName, _printDialog.PrinterSettings.PrinterName, Global.PageSetupConfig.GetPageSetup(Const.KetQuaNoiSoiTrucTrangTemplate)); } catch (Exception ex) { MsgBox.Show(Application.ProductName, "Vui lòng kiểm tra lại máy in.", IconType.Error); return; } break; } } } }
private bool OnTaoHoSo(DataRow row) { string patientGUID = row["PatientGUID"].ToString(); Result result = ReportBus.GetNgayKhamCuoiCung(patientGUID); if (!result.IsOK) { MsgBox.Show(Application.ProductName, result.GetErrorAsString("ReportBus.GetNgayKhamCuoiCung"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("ReportBus.GetNgayKhamCuoiCung")); return(false); } List <DateTime> ngayKhamCuoiCungList = (List <DateTime>)result.QueryResult; string maBenhNhan = row["FileNum"].ToString(); string tenBenhNhan = Utility.ConvertToUnSign(row["FullName"].ToString()); string path = string.Format("{0}\\{1}@{2}", Global.HoSoPath, maBenhNhan, tenBenhNhan); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string ketQuaKhamTongQuatFileName = string.Format("{0}\\Temp\\KetQuaKhamSucKhoeTongQuat.xls", Application.StartupPath);//string.Format("{0}\\KetQuaKhamSucKhoeTongQuat_{1}.xls", path, DateTime.Now.ToString("ddMMyyyyHHmmssms")); if (!Exports.ExportExcel.ExportKetQuaKhamTongQuatToExcel(ketQuaKhamTongQuatFileName, row, ngayKhamCuoiCungList)) { return(false); } string pdfFileName = string.Format("{0}\\KetQuaKhamSucKhoeTongQuat_{1}.pdf", path, DateTime.Now.ToString("ddMMyyyyHHmmssms")); if (!Exports.ConvertExcelToPDF.Convert(ketQuaKhamTongQuatFileName, pdfFileName, Utility.GetPageSetup(Const.KhamSucKhoeTongQuatTemplate))) { return(false); } //Kết quả nội soi if (ngayKhamCuoiCungList[5] != Global.MinDateTime) { DateTime fromDate = new DateTime(ngayKhamCuoiCungList[5].Year, ngayKhamCuoiCungList[5].Month, ngayKhamCuoiCungList[5].Day, 0, 0, 0); DateTime toDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day, 23, 59, 59); result = KetQuaNoiSoiBus.GetKetQuaNoiSoiList2(patientGUID, fromDate, toDate); if (!result.IsOK) { MsgBox.Show(Application.ProductName, result.GetErrorAsString("KetQuaNoiSoiBus.GetKetQuaNoiSoiList2"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("KetQuaNoiSoiBus.GetKetQuaNoiSoiList2")); return(false); } DataTable dt = result.QueryResult as DataTable; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { LoaiNoiSoi loaiNoiSoi = (LoaiNoiSoi)Convert.ToInt32(dr["LoaiNoiSoi"]); string ketQuaNoiSoiFileName = string.Format("{0}\\Temp\\KetQuaNoiSoi.xls", Application.StartupPath); //string.Format("{0}\\KetQuaNoiSoi_{1}_{2}.xls", path, loaiNoiSoi.ToString(), DateTime.Now.ToString("ddMMyyyyHHmmssms")); PageSetup p = null; switch (loaiNoiSoi) { case LoaiNoiSoi.Tai: if (!Exports.ExportExcel.ExportKetQuaNoiSoiTaiToExcel(ketQuaNoiSoiFileName, row, dr)) { return(false); } p = Utility.GetPageSetup(Const.KetQuaNoiSoiTaiTemplate); break; case LoaiNoiSoi.Mui: if (!Exports.ExportExcel.ExportKetQuaNoiSoiMuiToExcel(ketQuaNoiSoiFileName, row, dr)) { return(false); } p = Utility.GetPageSetup(Const.KetQuaNoiSoiMuiTemplate); break; case LoaiNoiSoi.Hong_ThanhQuan: if (!Exports.ExportExcel.ExportKetQuaNoiSoiHongThanhQuanToExcel(ketQuaNoiSoiFileName, row, dr)) { return(false); } p = Utility.GetPageSetup(Const.KetQuaNoiSoiHongThanhQuanTemplate); break; case LoaiNoiSoi.TaiMuiHong: if (!Exports.ExportExcel.ExportKetQuaNoiSoiTaiMuiHongToExcel(ketQuaNoiSoiFileName, row, dr)) { return(false); } p = Utility.GetPageSetup(Const.KetQuaNoiSoiTaiMuiHongTemplate); break; case LoaiNoiSoi.TongQuat: if (!Exports.ExportExcel.ExportKetQuaNoiSoiTongQuatToExcel(ketQuaNoiSoiFileName, row, dr)) { return(false); } p = Utility.GetPageSetup(Const.KetQuaNoiSoiTongQuatTemplate); break; } pdfFileName = string.Format("{0}\\KetQuaNoiSoi_{1}_{2}.xls", path, loaiNoiSoi.ToString(), DateTime.Now.ToString("ddMMyyyyHHmmssms")); if (!Exports.ConvertExcelToPDF.Convert(ketQuaNoiSoiFileName, pdfFileName, p)) { return(false); } } } } //Kết quả soi CTC if (ngayKhamCuoiCungList[6] != Global.MinDateTime) { DateTime fromDate = new DateTime(ngayKhamCuoiCungList[6].Year, ngayKhamCuoiCungList[6].Month, ngayKhamCuoiCungList[6].Day, 0, 0, 0); DateTime toDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day, 23, 59, 59); result = KetQuaSoiCTCBus.GetKetQuaSoiCTCList2(patientGUID, fromDate, toDate); if (!result.IsOK) { MsgBox.Show(Application.ProductName, result.GetErrorAsString("KetQuaSoiCTCBus.GetKetQuaSoiCTCList2"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("KetQuaSoiCTCBus.GetKetQuaSoiCTCList2")); return(false); } DataTable dt = result.QueryResult as DataTable; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string ketQuaSoiCTCFileName = string.Format("{0}\\Temp\\KetQuaSoiCTC.xls", Application.StartupPath); //string.Format("{0}\\KetQuaSoiCTC_{1}.xls", path, DateTime.Now.ToString("ddMMyyyyHHmmssms")); if (!Exports.ExportExcel.ExportKetQuaSoiCTCToExcel(ketQuaSoiCTCFileName, row, dr)) { return(false); } pdfFileName = string.Format("{0}\\KetQuaSoiCTC_{1}.xls", path, DateTime.Now.ToString("ddMMyyyyHHmmssms")); if (!Exports.ConvertExcelToPDF.Convert(ketQuaSoiCTCFileName, pdfFileName, Utility.GetPageSetup(Const.KetQuaSoiCTCTemplate))) { return(false); } } } } //Kết quả siêu âm if (ngayKhamCuoiCungList[7] != Global.MinDateTime) { DateTime fromDate = new DateTime(ngayKhamCuoiCungList[7].Year, ngayKhamCuoiCungList[7].Month, ngayKhamCuoiCungList[7].Day, 0, 0, 0); DateTime toDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day, 23, 59, 59); result = SieuAmBus.GetKetQuaSieuAmList2(patientGUID, fromDate, toDate); if (!result.IsOK) { MsgBox.Show(Application.ProductName, result.GetErrorAsString("SieuAmBus.GetKetQuaSieuAmList2"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("SieuAmBus.GetKetQuaSieuAmList2")); return(false); } DataTable dt = result.QueryResult as DataTable; if (dt != null && dt.Rows.Count > 0) { MethodInvoker method = delegate { foreach (DataRow dr in dt.Rows) { string tenSieuAm = Utility.ConvertToUnSign(dr["TenSieuAm"].ToString()); string ketQuaSieuAmFileName = string.Format("{0}\\KetQuaSieuAm_{1}_{2}.pdf", path, tenSieuAm, DateTime.Now.ToString("ddMMyyyyHHmmssms")); _uPrintKetQuaSieuAm.PatientRow = row; _uPrintKetQuaSieuAm.ExportToPDF(dr, ketQuaSieuAmFileName); } }; if (InvokeRequired) { BeginInvoke(method); } else { method.Invoke(); } } } return(true); }