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