/// <summary>
/// 根据列数组导出
/// </summary>
/// <param name="path"></param>
/// <param name="exportColumns"></param>
public void Export(string path, string[] exportColumns)
{
if (string.IsNullOrEmpty(path))
{
SaveFileDialog save = new SaveFileDialog();
save.Filter = "Excel文件|*.xls|Pdf文件|*.pdf|文本文件|*.txt";
save.FileName = this.FileName;
save.AddExtension = true;
if (save.ShowDialog() != DialogResult.OK)
{
return;
}
path = save.FileName;
}
IExport export = ExportFactory.CreateInstance(path, this, exportColumns);
export.Export(path);
}
public void Export(int exportType, string path, string fileName, dynamic datatList, dynamic fieldsList)
{
Export export = ExportFactory.Create(exportType);
export.InitializeConnection();
export.OpenConnection();
export.CreateTable(fieldsList);
// iterate through each page
foreach (var pageItems in datatList)
{
export.PopulateTable(pageItems, fieldsList);
}
export.CloseConnection(path);
}
