//建表脚本-Tables
public static string CreateTablesScript(string projectID)
{
Information.Clear();
StringBuilder sb = new StringBuilder();
try
{
CodeBuilderService service = ServiceHelper.GetCodeBuilderService();
ProjectEntity project = service.GetProjectById(projectID);
TableEntity[] tables = service.GetTableList(projectID);
for (int i = 0; i < tables.Length; i++)
{
if (i == 0)
{
sb.Append(CreateTableScript(project, tables[i], true));
}
else
{
sb.Append(CreateTableScript(project, tables[i], false));
}
sb.AppendLine("");
}
}
catch (Exception ex) {
Information.AddFmt("创建表脚本出错，错误信息：{0}", ex.Message);
}
return(sb.ToString());
}
public void BindTablesNode(TreeNode tablesNode, string projectid)
{
tablesNode.Nodes.Clear();
TableEntity[] tables = service.GetTableList(projectid);
tablesNode.Text = "Tables(" + tables.Length + ")";
foreach (TableEntity table in tables)
{
tablesNode.Nodes.Add(GetTableNode(table));
}
}
private void btnExport_Click(object sender, EventArgs e)
{
string path = this.selectPath.Text;
if (string.IsNullOrEmpty(path))
{
MsgBox.Alert("请选择导出地址"); return;
}
//if (this.cboType.Text.ToLower()=="word")
//{
// MsgBox.Alert("暂不支持word文档导出");
// return;
//}
bool checkRequired = this.checkRequired.Checked;
ProjectEntity project = Global.GetCurrentProject();
List <TableEntity> tables = service.GetTableList(Global.GetCurrentProjectID()).ToList();
if (tables.Count <= 1)
{
MsgBox.Alert("当前项目没有表"); return;
}
DbDocumentManager doc = new DbDocumentManager()
{
AllowRequired = checkRequired,
Project = project,
Tables = tables,
ExportPath = path,
Type = StringHelper.ToEnum <DbDocumentType>(this.cboType.Text)
};
this.progress.Value = 0;
this.progress.Maximum = tables.Count;
doc.OnProgress += new Options.Common.ProgressHandler(doc_OnProgress);
doc.Export();
if (MsgBox.Confirm("导出完毕，是否打开文件？"))
{
FileHelper.OpenFile(doc.FileName);
}
}
