//建表脚本-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 static void SetCurrentProject(string projectId) { ProjectEntity entity = new ProjectEntity(); if (!string.IsNullOrEmpty(projectId)) { CodeBuilderService service = ServiceHelper.GetCodeBuilderService(); entity = service.GetProjectById(projectId); } SetCurrentProject(entity); }
private void BindModelTree(string projectid) { if (!IsReloadTree) { return; } if (!string.IsNullOrEmpty(projectid)) { this.treeModel.Nodes.Clear(); WSH.CodeBuilder.DispatchServers.ProjectEntity project = service.GetProjectById(projectid); Global.SetCurrentProject(project); TreeNode root = new TreeNode(); root.Text = "项目集合"; root.Tag = "root"; root.ContextMenuStrip = this.menuRoot; SetNodeImage(root, "root"); //绑定项目 TreeNode projectNode = new TreeNode(); projectNode.Text = project.ProjectName; projectNode.Tag = project.ID; projectNode.ContextMenuStrip = this.menuProject; SetNodeImage(projectNode, "project"); //绑定表集合 TreeNode tablesNode = new TreeNode(); tablesNode.Tag = "tables"; tablesNode.ContextMenuStrip = this.menuTables; SetNodeImage(tablesNode, "folder"); //绑定表 BindTablesNode(tablesNode, projectid); projectNode.Nodes.Add(tablesNode); ////绑定视图集合 //TreeNode viewsNode = new TreeNode(); //viewsNode.Text = "Views"; //viewsNode.Tag = "views"; //SetNodeImage(viewsNode, "folder"); //projectNode.Nodes.Add(viewsNode); ////绑定存储过程集合 //TreeNode procsNode = new TreeNode(); //procsNode.Text = "Procs"; //procsNode.Tag = "procs"; //SetNodeImage(procsNode, "folder"); //projectNode.Nodes.Add(procsNode); root.Nodes.Add(projectNode); this.treeModel.Nodes.Add(root); //展开树 this.treeModel.ExpandAll(); } }
public override void BindData() { ProjectEntity entity = service.GetProjectById(this.RecordID); this.txtProjectName.Text = entity.ProjectName; this.txtNameSpace.Text = entity.NameSpace; this.txtAttr.Text = entity.Attr; this.txtRemark.Text = entity.Remark; if (entity.TemplateID > -1) { this.cboTemplate.SelectedValue = entity.TemplateID; } if (entity.ConnectionID > -1) { ConnectionEntity conn = service.GetConnectionById(entity.ConnectionID.ToString()); this.selectConnection.Text = conn.ConnectionName; this.selectConnection.Value = conn.ID.ToString(); } }