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);
}
}
