private void LoadTableList()
{
DatatableEx defaultTable = _dataTablesList
.FirstOrDefault(x => x.Root.ConfigTable.name == SelectedDataset.defaultTable);
if (defaultTable != null)
{
SelectedDataTable = defaultTable;
}
else
{
Common.Extensions.TraceLog.Information("Loading Data Tables @ LoadTableList");
IsBusy = true;
var action = new Action(async() =>
{
var table = await SelectedDataset.Table.First(x => x.name == SelectedDataset.defaultTable)
.Query("".ToArray(""),
"".ToArray(""),
true);
_dataTablesList.Add(table);
IsBusy = false;
SelectedDataTable = _dataTablesList.First(x => x.Root.ConfigTable.name == SelectedDataset.defaultTable);
});
action.Invoke();
}
}
private void exportTables(DatatableEx root, ExportToFormat format)
{
TraceLog.Information("Exporting tables to {format}", format.ToString());
var fileExtension = ".xlsx";
switch (format)
{
case ExportToFormat.Word2007:
fileExtension = ".docx";
break;
case ExportToFormat.HTML:
fileExtension = ".html";
break;
case ExportToFormat.PDFtextSharpXML:
fileExtension = ".pdf";
break;
}
var fileName = Path.Combine(ExportPath, root.Root.Table.TableName + fileExtension);
root.Root.Table.ExportTo(format, fileName);
foreach (var t in root.Children)
{
exportTables(t, format);
}
}
private void fillHtml(DatatableEx t, ref StringBuilder tables, ref int level)
{
string[] levels = new string[] {
"first", "second", "third", "fourth", "fifth", "sixth", "seventh", "eighth", "nineth", "tenth"
};
tables.Append(t.Root.Table.ExportAsHtmlFragment()
.Replace("className", string.Format("{0}LevelTable", levels[level]))
.Replace("tableName", t.Root.Table.TableName.ToUpper())
.Replace("columnCount", t.Root.Table.Columns.Count.ToString()));
++level;
foreach (var child in t.Children)
{
fillHtml(child, ref tables, ref level);
}
--level;
}
