/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode Node = new TreeNode();
Node.Text = Connection.Name;
Base.SetNodeImageFromQualifier(Node, Qualifier, IsGhost);
//----------------------------------------------------------------
Node.Nodes.Add(TableCont.toTreeNode());
Node.Nodes.Add(ViewCont.toTreeNode());
Node.Nodes.Add(ProcedureCont.toTreeNode());
Node.Nodes.Add(FunctionCont.toTreeNode());
//----------------------------------------------------------------
Node.Tag = this;
if (IsGhost)
{
Node.ForeColor = Color.Gray;
}
return(Node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode node = new TreeNode();
node.Text = Name + " " + Type;
if (Nullable == false)
{
node.Text += " NOT NULL";
}
if (Identity == true)
{
node.Text += " IDENTITY";
}
Base.SetNodeImageFromQualifier(node, Qualifier, IsGhost);
//----------------------------------------------------------------
foreach (Constraint cnst in m_Constraints)
{
node.Nodes.Add(cnst.toTreeNode());
}
//----------------------------------------------------------------
node.Tag = this;
if (IsGhost)
{
node.ForeColor = Color.Gray;
}
return(node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode node = new TreeNode();
node.Text = "Data";
Base.SetNodeImageFromQualifier(node, Qualifier, IsGhost);
return(node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode Node = new TreeNode();
Node.Text = String.Format("{0} {1} ({2})", Constraint.getFieldList(FieldNames), Name, ConstraintTypeToSQLConstraintType(Type));
Base.SetNodeImageFromQualifier(Node, Qualifier, IsGhost);
Node.Tag = this;
if (IsGhost)
{
Node.ForeColor = Color.Gray;
}
return(Node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode Node = new TreeNode();
Node.Text = Name;
Base.SetNodeImageFromQualifier(Node, Qualifier, IsGhost);
Node.Tag = this;
if (IsGhost)
{
Node.ForeColor = Color.Gray;
}
return(Node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode node = new TreeNode();
node.Text = "Columns";
Base.SetNodeImageFromQualifier(node, Qualifier, IsGhost);
foreach (Field f in Fields)
{
node.Nodes.Add(f.toTreeNode());
}
node.Tag = this;
if (IsGhost)
{
node.ForeColor = Color.Gray;
}
return(node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode node = new TreeNode();
String ProcedureFilter = Filter.Text;
node.Text = "Procedures";
node.Tag = this;
if (ProcedureFilter != String.Empty)
{
node.Text += " (Filtered)";
}
Base.SetNodeImageFromQualifier(node, Qualifier, IsGhost);
foreach (Procedure proc in Procedures)
{
if
(
(proc.Qualifier == Modification.None && Filter.HideUnmodified == false) ||
(proc.Qualifier == Modification.Modified && Filter.HideModified == false) ||
(proc.Qualifier == Modification.Created && Filter.HideCreated == false) ||
(proc.Qualifier == Modification.Deleted && Filter.HideDropped == false)
)
{
if (Filter.Text != String.Empty)
{
if (proc.Name.ToLower().Contains(Filter.Text.ToLower()))
{
node.Nodes.Add(proc.toTreeNode());
}
}
else
{
node.Nodes.Add(proc.toTreeNode());
}
}
}
return(node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode node = new TreeNode();
node.Text = "Constraints";
Base.SetNodeImageFromQualifier(node, Qualifier, IsGhost);
foreach (Constraint c in Constraints)
{
node.Nodes.Add(c.toTreeNode());
}
node.Tag = this;
if (IsGhost)
{
node.ForeColor = Color.Gray;
}
return(node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode Node = new TreeNode();
Node.Text = "Views";
Node.Tag = this;
if (Filter.Text != String.Empty)
{
Node.Text += " (Filtered)";
}
Base.SetNodeImageFromQualifier(Node, Qualifier, IsGhost);
foreach (View CurrentView in Views)
{
if
(
(CurrentView.Qualifier == Modification.None && Filter.HideUnmodified == false) ||
(CurrentView.Qualifier == Modification.Modified && Filter.HideModified == false) ||
(CurrentView.Qualifier == Modification.Created && Filter.HideCreated == false) ||
(CurrentView.Qualifier == Modification.Deleted && Filter.HideDropped == false)
)
{
if (Filter.Text != String.Empty)
{
if (CurrentView.Name.ToLower().Contains(Filter.Text.ToLower()))
{
Node.Nodes.Add(CurrentView.toTreeNode());
}
}
else
{
Node.Nodes.Add(CurrentView.toTreeNode());
}
}
}
return(Node);
}
/// <summary>
/// Makes a tree node from this object.
/// </summary>
/// <returns></returns>
public override TreeNode toTreeNode()
{
TreeNode Node = new TreeNode();
Node.Text = Name;
Base.SetNodeImageFromQualifier(Node, Qualifier, IsGhost);
Node.Nodes.Add(FieldCont.toTreeNode());
Node.Nodes.Add(ConstraintCont.toTreeNode());
if (m_DataCont != null)
{
Node.Nodes.Add(DataCont.toTreeNode());
}
Node.Tag = this;
if (IsGhost)
{
Node.ForeColor = Color.Gray;
}
return(Node);
}
