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