/// <summary> /// Carga el arbol con todas las tablas .- /// </summary> /// <param name="pTreeView">Nodo</param> /// <param name="pTables">Tablas</param> public static void LoadTreeView(TreeView pTreeView, Fwk_DataEntities.Tables pTables) { pTreeView.Nodes.Clear(); foreach (Fwk_DataEntities.Table wTable in pTables) { TreeNode wTreeNode = new TreeNode(); wTreeNode.Checked = false; wTreeNode.Text = wTable.Name; pTreeView.Nodes.Add(wTreeNode); LoadColumnsNodes(wTreeNode, wTable); OnAddElementEvent(); } }
/// <summary> /// Carga las coluimnas al nodo pParentNode.- /// </summary> /// <param name="pParentNode">Nodo padre </param> /// <param name="pTable"></param> private static void LoadColumnsNodes(TreeNode pParentNode, Fwk_DataEntities.Table pTable) { foreach (Fwk_DataEntities.Column wColumn in pTable.Columns) { String nullable = wColumn.Nullable ? "NULL" : String.Empty; TreeNode wTreeNode = new TreeNode(); wTreeNode.Checked = false; wTreeNode.Text = wColumn.Name + " " + wColumn.Type + " " + nullable; wTreeNode.Tag = wColumn.Name; wTreeNode.ImageIndex = 5; wTreeNode.SelectedImageIndex = 5; pParentNode.Nodes.Add(wTreeNode); } }
/// <summary> /// Carga los parametros al nodo pParentNode (StoreProcedure).- /// </summary> /// <param name="pParentNode">Nodo padre </param> /// <param name="pStoreProcedure">Store Procedure</param> private static void LoadParameteresNodes(TreeNode pParentNode, Fwk_DataEntities.StoreProcedure pStoreProcedure) { foreach (Fwk_DataEntities.SPParameter wParameter in pStoreProcedure.Parameters) { TreeNode wTreeNode = new TreeNode(); wTreeNode.Checked = false; wTreeNode.Text = wParameter.Type + " " + wParameter.Name; wTreeNode.Tag = wParameter.Name; wTreeNode.ImageIndex = 5; wTreeNode.SelectedImageIndex = 5; pParentNode.Nodes.Add(wTreeNode); } }
/// <summary> /// Carga el arbol con todas los Store Procedures .- /// </summary> /// <param name="pTreeView">Nodo</param> /// <param name="pStoreProcedures">StoreProcedures</param> public static void LoadTreeView(TreeView pTreeView, Fwk_DataEntities.StoreProcedures pStoreProcedures) { pTreeView.Nodes.Clear(); foreach (Fwk_DataEntities.StoreProcedure wStoreProcedure in pStoreProcedures) { TreeNode wTreeNode = new TreeNode(); wTreeNode.Checked = false; wTreeNode.Text = wStoreProcedure.Name; pTreeView.Nodes.Add(wTreeNode); LoadParameteresNodes(wTreeNode, wStoreProcedure); OnAddElementEvent(); } }