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