public void FileDelete(DataReport.geReportKbn rptKbn, string pgId, string _deleteFileName, string _deleteFilePath) { try { string deleteFileName = ""; string deleteFilePath = ""; deleteFileName = System.Windows.Browser.HttpUtility.UrlEncode(_deleteFileName); deleteFilePath = _deleteFilePath.Replace(_deleteFileName, System.Windows.Browser.HttpUtility.UrlEncode(_deleteFileName)).Replace(@"\", "@AAB@").Replace("/", "@AAD@");; var requestUri = string.Format("{0}?rptKbn={1}&pgId={2}&random={3}&deleteFileName={4}&deleteFilePath={5}", Common.gstrReportDeleteUrl, ((int)rptKbn).ToString(), pgId, Common.gstrSessionString, deleteFileName, deleteFilePath); var client = new WebClient(); client.UploadStringCompleted += OnFileDeleteCompleted; client.UploadStringAsync(new Uri(requestUri), "delete"); } catch (Exception ex) { //ExMessageBox.Show("ファイルダウンロード処理で予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); return; } }
// F2ボタン(ダウンロード) クリック public override void btnF2_Click(object sender, RoutedEventArgs e) { this.utlParentFKey.IsEnabled = false; // ボタン押下時非同期入力チェックON Common.gblnBtnDesynchronizeLock = true; this.rptKbn = DataReport.geReportKbn.Download; // 入力確定の為、BackgroundWorker経由で入力チェックを呼出 ExBackgroundInputCheckWk bk = new ExBackgroundInputCheckWk(); bk.utl = this; this.txtDummy.IsTabStop = true; bk.focusCtl = this.txtDummy; bk.bw.RunWorkerAsync(); }
public void FileDownLoad(DataReport.geReportKbn rptKbn, string pgId, string[] prm) { try { this.saveDialog = new SaveFileDialog(); switch (rptKbn) { case DataReport.geReportKbn.Download: this.saveDialog.DefaultExt = ".pdf"; this.saveDialog.Filter = "All Files|*.*|Pdf Files|*.pdf"; break; case DataReport.geReportKbn.Csv: this.saveDialog.DefaultExt = ".csv"; this.saveDialog.Filter = "All Files|*.*|Csv Files|*.csv"; break; case DataReport.geReportKbn.None: this.saveDialog.Filter = "All Files|*.*"; break; default: break; } this.saveDialog.FilterIndex = 2; } catch (Exception ex) { ExMessageBox.Show("ファイル保存処理(ダイアログ表示)で予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); if (this.utlParentFKey != null) { this.utlParentFKey.IsEnabled = true; } return; } bool?dialogResult = this.saveDialog.ShowDialog(); if (dialogResult == true) { try { string downLoadFileName = ""; string downLoadFilePath = ""; downLoadFileName = System.Windows.Browser.HttpUtility.UrlEncode(prm[0]); downLoadFilePath = prm[1].Replace(prm[0], System.Windows.Browser.HttpUtility.UrlEncode(prm[0])).Replace(@"\", "@AAB@").Replace("/", "@AAD@");; var requestUri = string.Format("{0}?rptKbn={1}&pgId={2}&random={3}&downLoadFileName={4}&downLoadFilePath={5}", Common.gstrReportDownloadUrl, ((int)rptKbn).ToString(), pgId, Common.gstrSessionString, downLoadFileName, downLoadFilePath); var client = new WebClient(); client.OpenReadCompleted += OnFileDownloadCompleted; client.OpenReadAsync(new Uri(requestUri), null); switch (rptKbn) { case DataReport.geReportKbn.OutPut: case DataReport.geReportKbn.Download: Common.gstrProgressDialogTitle = "PDFファイルダウンロード中"; break; case DataReport.geReportKbn.Csv: Common.gstrProgressDialogTitle = "CSVファイルダウンロード中"; break; } if (dlgWin == null) { dlgWin = new Dlg_Progress(); } dlgWin.Show(); } catch (Exception ex) { ExMessageBox.Show("ファイルダウンロード処理で予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message); if (this.utlParentFKey != null) { this.utlParentFKey.IsEnabled = true; } return; } } else { this.saveDialog = null; if (this.utlParentFKey != null) { this.utlParentFKey.IsEnabled = true; } GC.Collect(); } }
// F3ボタン(CSV) クリック public override void btnF3_Click(object sender, RoutedEventArgs e) { this.utlParentFKey.IsEnabled = false; // ボタン押下時非同期入力チェックON Common.gblnBtnDesynchronizeLock = true; this.rptKbn = DataReport.geReportKbn.Csv; // 入力確定の為、BackgroundWorker経由で入力チェックを呼出 ExBackgroundInputCheckWk bk = new ExBackgroundInputCheckWk(); bk.utl = this; bk.waitTime = 500; this.txtDummy.IsTabStop = true; bk.focusCtl = this.txtDummy; bk.bw.RunWorkerAsync(); }
public EntityReport ReportOut(string random, string rptKbn, string pgId, string parameters) { EntityReport entity; EntityReportSetting entitySetting; #region 認証処理 string companyId = ""; string groupId = ""; string userId = ""; string ipAdress = ""; string sessionString = ""; int reportSizeUser = 0; int idFigureCommodity = 0; int idFigureCustomer = 0; int idFigurePurchase = 0; int idFigureSlipNo = 0; int rpTotalAuthorityKbn = 0; try { companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]); groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]); userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]); ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]); sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]); reportSizeUser = ExCast.zCInt(HttpContext.Current.Session[ExSession.REPORT_SAVE_SIZE_USER]); idFigureCommodity = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_GOODS]); idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]); idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]); idFigureSlipNo = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_SLIP_NO]); rpTotalAuthorityKbn = ExCast.zCInt(HttpContext.Current.Session[ExSession.REPORT_TOTAL_AUTHORITY_KBN]); string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID])); if (_message != "") { entity = new EntityReport(); entity.MESSAGE = _message; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ReportOut(認証処理)", ex); entity = new EntityReport(); entity.MESSAGE = CLASS_NM + ".ReportOut : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString(); return(entity); } #endregion ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString); try { #region Get Report Setting entitySetting = GetReportSetting(random, pgId); if (entitySetting == null) { entitySetting = new EntityReportSetting(); entitySetting.user_id = ExCast.zCInt(userId); entitySetting.pg_id = pgId; entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } else if (entitySetting != null) { if (!string.IsNullOrEmpty(entitySetting.MESSAGE)) { entitySetting = new EntityReportSetting(); entitySetting.user_id = ExCast.zCInt(userId); entitySetting.pg_id = pgId; entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } else { if (ExCast.zCInt(entitySetting.group_id_from) == 0 && ExCast.zCInt(entitySetting.group_id_to) == 0) { entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } } } if (rpTotalAuthorityKbn < 2) { entitySetting.group_id_from = ExCast.zCInt(groupId).ToString(); entitySetting.group_id_to = ExCast.zCInt(groupId).ToString(); } #endregion entity = new EntityReport(); DataReport.geReportKbn kbn = (DataReport.geReportKbn)ExCast.zCInt(rptKbn); ExReportManeger rptMgr = new ExReportManeger(); rptMgr.idFigureCommodity = idFigureCommodity; rptMgr.idFigureCustomer = idFigureCustomer; rptMgr.idFigurePurchase = idFigurePurchase; rptMgr.idFigureSlipNo = idFigureSlipNo; rptMgr.entitySetting = entitySetting; rptMgr.rptKbn = kbn; #region Report FilePath Setting bool _ret = rptMgr.GetReportFilePath(pgId, companyId, userId); if (_ret == false) { entity.MESSAGE = CommonUtl.gstrErrMsg; return(entity); } entity.downLoadFilePath = rptMgr.reportFilePath; entity.downLoadFileName = rptMgr.reportFileName; entity.downLoadFileSize = rptMgr.reportFileSize.ToString(); entity.downLoadUrl = CommonUtl.gstrMainUrl + rptMgr.reportDir; #endregion DataSet ds = db.GetDataSet(rptMgr.ReportSQL(pgId, companyId, groupId, parameters), rptMgr.GetPGIDXsd(pgId)); #region Export xsd System.IO.StreamWriter xmlSW = null; try { xmlSW = new System.IO.StreamWriter(CommonUtl.gstrReportTemp + rptMgr.GetPGIDXsd(pgId) + ".xsd"); ds.WriteXmlSchema(xmlSW); xmlSW.Close(); } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".WriteXmlSchema", ex); } finally { if (xmlSW != null) { xmlSW.Dispose(); xmlSW = null; } } #endregion if (ds.Tables[0].Rows.Count == 0) { entity.MESSAGE = "データが存在しません。"; entity.ret = false; return(entity); } string _fileType = ""; string _DownloadType = ""; switch (kbn) { case DataReport.geReportKbn.OutPut: _fileType = "PDF"; _DownloadType = "出力"; if (rptMgr.ReportToPdf(ds, pgId) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; case DataReport.geReportKbn.Download: _fileType = "PDF"; _DownloadType = "ダウンロード"; if (rptMgr.ReportToPdf(ds, pgId) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; case DataReport.geReportKbn.Csv: _fileType = "CSV"; _DownloadType = "ダウンロード"; if (rptMgr.DataTableToCsv(ds.Tables[0]) == true) { entity.ret = true; } else { entity.MESSAGE = CommonUtl.gstrErrMsg; entity.ret = false; } break; default: break; } //entity.downLoadFilePath = @"d:\HostingSpaces\Users\EW20121725\Sales.system-innovation.net\wwwroot\temp\顧客マスタ一覧.csv"; //System.IO.FileInfo fi = new System.IO.FileInfo(entity.downLoadFilePath); //entity.downLoadFileSize = fi.Length.ToString(); if (reportSizeUser < ExCast.zCDbl(entity.downLoadFileSize) / 1000000) { entity.MESSAGE = _fileType + "ファイルのサイズが" + reportSizeUser.ToString() + "Mバイトを超える為、" + _DownloadType + "できません。"; return(entity); } } catch (Exception ex) { CommonUtl.ExLogger.Error(CLASS_NM + ".ReportOut", ex); entity = new EntityReport(); entity.MESSAGE = CLASS_NM + ".ReportOut : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString(); return(entity); } return(entity); }