internal static void FillParameters(TreeNode pTreeNodePadre, Fwk.DataBase.DataEntities.StoreProcedure pStoreProcedure) { if (pStoreProcedure.IsParametersLoaded) { return; } Fwk_DataBase.Metadata wMetadata = new Metadata(); wMetadata.StoreProcedures_FillParameters(pStoreProcedure); LoadParameteresNodes(pTreeNodePadre, pStoreProcedure); }
/// <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); } }