private void ExportHtml()
{
string tableDataDirName = "表数据示例";
string tableStructureDirName = "表结构说明";
Directory.CreateDirectory(".//tmp");
Directory.CreateDirectory(".//tmp//resources");
//定义目录DataTable 结构
Synyi.DBChmCreater.Entity.DataTableCollection dataTableStructures = new Synyi.DBChmCreater.Entity.DataTableCollection("<b>数据库表目录</b>");
//将选中项的总数 设置为进度条最大值 +1项是表目录文件
Dispatcher.Invoke(new Action(() =>
{
tpbExport.Value = 0;
tpbExport.Maximum = ckbData.SelectedItems.Count + ckbTables.SelectedItems.Count + 1;// ckbData.CheckedItems.Count + ckbTables.CheckedItems.Count + 1;
}));
//获取需要导出的表结构 选中项
List <string> selectTabStructList = new List <string>();
foreach (var item in ckbTables.SelectedItems) // CheckedItems)
{
selectTabStructList.Add(item.ToString());
}
#region 导出表结构 数据字典部分 导出为html
if (selectTabStructList.Count > 0)
{
lblMessage.Content = "准备表结构文件...";
//得到选中的表结构的字段信息
var lstDt = dal.GetTableStruct(selectTabStructList);
var pathTables = $"./tmp/{tableStructureDirName}";
Directory.CreateDirectory(pathTables);
var tables = dal.GetTables();
var allSchemas = tables.Select(p => p.Domain).Distinct();
foreach (var item in allSchemas)
{
Directory.CreateDirectory(System.IO.Path.Combine(pathTables, item));
}
var tableIndex = 1;
foreach (var dt in lstDt)
{
//得到表描述
var array = dt.TableName.Split('.');
var domain = array[0];
var tabname = array[1];
var drs = tables.Where(p => p.TableName == tabname).Where(p => p.Domain == domain).FirstOrDefault();// Select("表名='" + tabname + "' and 域='" + domain + "'");
var desp = string.Empty;
if (drs != null)
{
desp = drs.TableDescription;
}
//创建表字段信息的html
HtmlHelp.CreateHtml(dt, true, System.IO.Path.Combine(pathTables, dt[0].tableschema, $"{dt.TableName}.html"), true, desp, true);
//构建表目录
dataTableStructures.Add(new DataTableItem {
TableNo = tableIndex++, Domain = drs.Domain, TableName = $"<a href=\"{tableStructureDirName}\\{drs.Domain}\\{ dt.TableName}.html\">{ dt.TableName.Split('.').GetValue(1)}</a>", TableDescription = desp
});
//改变进度
Dispatcher.Invoke(new Action(() => { tpbExport.Value++; }));
}
//导出表目录
HtmlHelp.CreateHtml(dataTableStructures, false, "./tmp/" + defaultHtml, false, string.Empty, false); //默认页面
Dispatcher.Invoke(new Action(() => { tpbExport.Value++; }));
}
#endregion
#region 导出表数据 表中的数据示例 导出为html
//传递需要导出数据的table选中项 得到数据内容
selectTabStructList.Clear();
foreach (var item in ckbData.SelectedItems) //CheckedItems)
{
selectTabStructList.Add(item.ToString());
}
if (selectTabStructList.Count > 0)
{
Dispatcher.Invoke(new Action(() => { lblMessage.Content = "正在生成表数据数据..."; }));
//读取ini
int result = ini.GetInt32("Set", "maxrow", -1);
var lstDt = dal.GetTableData(selectTabStructList, result);
//创建常用数据的html
var pathTables = $"./tmp/{tableDataDirName}";
Directory.CreateDirectory(pathTables);
var selecttabdataschemas = selectTabStructList.Select(p => p.Split('.')[0]).Distinct();
foreach (var item in selecttabdataschemas)
{
Directory.CreateDirectory(System.IO.Path.Combine(pathTables, item));
}
foreach (var dt in lstDt)
{
HtmlHelp.CreateHtml2(dt, true, System.IO.Path.Combine(System.IO.Path.Combine(pathTables, dt.TableName.Split('.')[0]), dt.TableName + ".html"), true);
Dispatcher.Invoke(new Action(() => { tpbExport.Value++; }));
}
}
Dispatcher.Invoke(new Action(() => { lblMessage.Content = "成功生成HTML..."; }));
#endregion
}
