private void ExportActivity_Click(object sender, EventArgs eventArgs) { _worker.ReportProgress(0, "Generate file! Please wait...."); _exportProvider = new ExcelExportProvider(); _exportProvider.ExportShouldBeOnStock(InitialDirectiveArray.OfType <StockComponentInfo>().ToList()); }
private void ExportActivityWork(object sender, DoWorkEventArgs e) { _worker.ReportProgress(0, "load Activity"); _worker.ReportProgress(0, "Generate file! Please wait...."); _exportProvider = new ExcelExportProvider(); _exportProvider.ExportActivity(_result.ToList()); }
private void ExportDirectiveWork(object sender, DoWorkEventArgs e) { _worker.ReportProgress(0, "load Directive"); _worker.ReportProgress(0, "Generate file! Please wait...."); _exportProvider = new ExcelExportProvider(); _exportProvider.ExportDirective(_resultDirectiveArray.ToList()); }
public ExcelExportArgs(string fileName, DataSet container, ExcelMessageCollection excelMessages, ExcelExportProvider provider) { _filename = fileName; Container = container; Canceled = false; ExcelMessages = excelMessages; excelProvider = provider; }
private void ExportATLBWork(object sender, DoWorkEventArgs e) { AnimatedThreadWorker.ReportProgress(0, "load ATLB"); _worker.ReportProgress(0, "Generate file! Please wait...."); _exportProvider = new ExcelExportProvider(); _exportProvider.ExportATLB(); }
/// <summary> /// 初始化一个<see cref="BugFixesTest"/>类型的实例 /// </summary> public BugFixesTest(ITestOutputHelper output) { Output = output; ImportProvider = new ExcelImportProvider(); ImportService = new ExcelImportService(ImportProvider); ExportProvider = new ExcelExportProvider(); ExportService = new ExcelExportService(ExportProvider); CurrentDir = Environment.CurrentDirectory; }
public void ProcessExport(string portal, string columns) { IList <string> columnNames; IDataExportProvider provider; string extension; //获取导出提供者 switch (this.Request["exportFormat"] ?? "excel") { default: case "excel": provider = new ExcelExportProvider(); extension = "xls"; break; case "csv": provider = new CsvExportProvider(); extension = "csv"; break; case "txt": provider = new TextExportProvider(); extension = "txt"; break; } //获取列名 Regex reg = new Regex("^columnNames\\[\\d+\\]$", RegexOptions.IgnoreCase); columnNames = new List <string>(); foreach (string key in this.Request.QueryString.Keys) { if (reg.IsMatch(key)) { columnNames.Add(this.Request.QueryString[key]); } } IDataExportPortal _portal = ExportHelper.GetPortal(portal, this.Request["params"], columnNames.ToArray()); byte[] bytes = DataExportDirector.Export(_portal, provider); this.Response.BinaryWrite(bytes); this.Response.ContentType = "application/octet-stream"; this.Response.AppendHeader("Content-Disposition", String.Format("attachment;filename=\"{0:yyyyMMdd-hhssfff}.{1}\"", DateTime.Now, extension)); }
public void ProcessExport(string portal, string columns) { IList<string> columnNames; IDataExportProvider provider; string extension; //获取导出提供者 switch (this.Request["exportFormat"] ?? "excel") { default: case "excel": provider = new ExcelExportProvider(); extension = "xls"; break; case "csv": provider = new CsvExportProvider(); extension = "csv"; break; case "txt": provider = new TextExportProvider(); extension = "txt"; break; } //获取列名 Regex reg = new Regex("^columnNames\\[\\d+\\]$", RegexOptions.IgnoreCase); columnNames = new List<string>(); foreach (string key in this.Request.QueryString.Keys) { if (reg.IsMatch(key)) { columnNames.Add(this.Request.QueryString[key]); } } IDataExportPortal _portal = ExportHelper.GetPortal(portal, this.Request["params"], columnNames.ToArray()); byte[] bytes = DataExportDirector.Export(_portal, provider); this.Response.BinaryWrite(bytes); this.Response.ContentType = "application/octet-stream"; this.Response.AppendHeader("Content-Disposition", String.Format("attachment;filename=\"{0:yyyyMMdd-hhssfff}.{1}\"", DateTime.Now, extension)); }
private void btnExport_Click(object sender, EventArgs e) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.Filter = "文本文件|*.*|xls文件|*.xls|所有文件|*.*"; saveFileDialog.FilterIndex = 2; saveFileDialog.FileName = @"Export.xls"; saveFileDialog.RestoreDirectory = true; saveFileDialog.InitialDirectory = (new Config()).FolderData; if (saveFileDialog.ShowDialog() == DialogResult.OK) { string fName = saveFileDialog.FileName.ToString(); this.btnExport.Enabled = false; this.lblBusy.Text = "正在导出..."; Action a = () => { if (!ExcelExportProvider.ExportToExcel(this._tbs, fName)) { MessageBox.Show("导出失败"); } if (this.toolStrip1.InvokeRequired) { ThreadStart s = () => { this.btnExport.Enabled = true; }; this.toolStrip1.Invoke(s); } else { this.btnExport.Enabled = true; } if (this.toolStrip1.InvokeRequired) { ThreadStart s = () => { this.lblBusy.Text = ""; }; this.toolStrip1.Invoke(s); } else { this.lblBusy.Text = ""; } }; a.BeginInvoke(null, null); } }
private void Worker_DoWork(object sender, DoWorkEventArgs e) { var t = new TimeSpan(); for (int i = 0; i < 5; i++) { t += new TimeSpan(25, 40, 0); } AnimatedThreadWorker.ReportProgress(0, "load directives"); _worker.ReportProgress(0, "Generate file! Please wait...."); _exportProvider = new ExcelExportProvider(); _exportProvider.ReportProgress += (o, args) => { _worker.ReportProgress(0, $"Generate page for {o}"); }; _worker.ReportProgress(0, "Finish"); _exportProvider.ExportFlights(); }