private void OnChuyenKetQuaKham() { if (!_isChuyenBenhAn) { return; } List <DataRow> deletedRows = new List <DataRow>(); DataTable dt = dgKhamNoiSoi.DataSource as DataTable; foreach (DataRow row in dt.Rows) { if (Boolean.Parse(row["Checked"].ToString())) { deletedRows.Add(row); } } if (dgKhamNoiSoi.RowCount <= 0 || deletedRows == null || deletedRows.Count <= 0) { MsgBox.Show(Application.ProductName, "Vui lòng đánh dấu ít nhất 1 kết quả nội soi cần chuyển.", IconType.Information); return; } if (_patientRow2 == null) { MsgBox.Show(Application.ProductName, "Vui lòng chọn bệnh nhân nhận kết quả nội soi chuyển đến.", IconType.Information); return; } string fileNum = _patientRow2["FileNum"].ToString(); if (MsgBox.Question(Application.ProductName, string.Format("Bạn có muốn chuyển những kết quả nội soi đã chọn đến bệnh nhân: '{0}'?", fileNum)) == DialogResult.No) { return; } Result result = KetQuaNoiSoiBus.ChuyenBenhAn(_patientRow2["PatientGUID"].ToString(), deletedRows); if (result.IsOK) { DisplayAsThread(); } else { MsgBox.Show(Application.ProductName, result.GetErrorAsString("KetQuaNoiSoiBus.ChuyenBenhAn"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("KetQuaNoiSoiBus.ChuyenBenhAn")); } }
private void OnDelete() { List <string> deletedKQNSList = new List <string>(); List <DataRow> deletedRows = new List <DataRow>(); DataTable dt = dgKhamNoiSoi.DataSource as DataTable; foreach (DataRow row in dt.Rows) { if (Boolean.Parse(row["Checked"].ToString())) { deletedKQNSList.Add(row["KetQuaNoiSoiGUID"].ToString()); deletedRows.Add(row); } } if (deletedKQNSList.Count > 0) { if (MsgBox.Question(Application.ProductName, "Bạn có muốn xóa những kết quả nội soi mà bạn đã đánh dấu ?") == DialogResult.Yes) { Result result = KetQuaNoiSoiBus.DeleteKetQuaNoiSoi(deletedKQNSList); if (result.IsOK) { foreach (DataRow row in deletedRows) { dt.Rows.Remove(row); } } else { MsgBox.Show(Application.ProductName, result.GetErrorAsString("KetQuaNoiSoiBus.DeleteKetQuaNoiSoi"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("KetQuaNoiSoiBus.DeleteKetQuaNoiSoi")); } } } else { MsgBox.Show(Application.ProductName, "Vui lòng đánh dấu những kết quả nội soi.", IconType.Information); } }
private void OnDisplayKetQuaNoiSoiList() { Result result = KetQuaNoiSoiBus.GetKetQuaNoiSoiList(_patientGUID, _fromDate, _toDate); if (result.IsOK) { MethodInvoker method = delegate { ClearData(); DataTable dt = result.QueryResult as DataTable; dgKhamNoiSoi.DataSource = dt; if (_isPrint) { DataRow[] rows = dt.Select(string.Format("KetQuaNoiSoiGUID='{0}'", _ketQuaNoiSoi.KetQuaNoiSoiGUID.ToString())); if (rows != null && rows.Length > 0) { OnPrint(rows[0]); } } }; if (InvokeRequired) { BeginInvoke(method); } else { method.Invoke(); } } else { MsgBox.Show(Application.ProductName, result.GetErrorAsString("KetQuaNoiSoiBus.GetKetQuaNoiSoiList"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("KetQuaNoiSoiBus.GetKetQuaNoiSoiList")); } }
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); }