private bool TypeFileData(TreeNode<IDataPath> pt, Command cmd)
{
if (!(pt.Item is TableName))
return false;
TableName tname = (TableName)pt.Item;
tout = new TableOut(tname);
return tout.Display(cmd);
}
private bool TypeLocatorColumnData(TreeNode<IDataPath> pt, Command cmd)
{
if (!(pt.Item is ColumnPath))
return false;
ColumnPath column = (ColumnPath)pt.Item;
Locator locator = null;
TableName tname = null;
if (pt.Parent.Item is Locator)
{
locator = (Locator)pt.Parent.Item;
tname = (TableName)pt.Parent.Parent.Item;
}
else
tname = (TableName)pt.Parent.Item;
tout = new TableOut(tname);
return tout.Display(cmd, column.Columns, locator);
}
private bool TypeLocatorData(TreeNode <IDataPath> pt, ApplicationCommand cmd)
{
if (!(pt.Item is Locator))
{
return(false);
}
TableName tname = this.GetCurrentPath <TableName>();
Locator locator = GetCombinedLocator(pt);
var xnode = pt;
while (xnode.Parent.Item is Locator)
{
xnode = xnode.Parent;
locator.And((Locator)xnode.Item);
}
tout = new TableOut(tname);
return(tout.Display(cmd, "*", locator));
}
private bool TypeLocatorColumnData(TreeNode <IDataPath> pt, ApplicationCommand cmd)
{
if (!(pt.Item is ColumnPath))
{
return(false);
}
ColumnPath column = (ColumnPath)pt.Item;
Locator locator = null;
TableName tname = null;
if (pt.Parent.Item is Locator)
{
locator = (Locator)pt.Parent.Item;
tname = (TableName)pt.Parent.Parent.Item;
}
else
{
tname = (TableName)pt.Parent.Item;
}
tout = new TableOut(tname);
return(tout.Display(cmd, column.Columns, locator));
}
private bool TypeLocatorData(TreeNode<IDataPath> pt, Command cmd)
{
if (!(pt.Item is Locator))
return false;
TableName tname = this.GetCurrentPath<TableName>();
Locator locator = GetCombinedLocator(pt);
var xnode = pt;
while (xnode.Parent.Item is Locator)
{
xnode = xnode.Parent;
locator.And((Locator)xnode.Item);
}
tout = new TableOut(tname);
return tout.Display(cmd, "*", locator);
}
private bool TypeFileData(TreeNode <IDataPath> pt, ApplicationCommand cmd)
{
if (pt.Item is ServerName)
{
ServerName sname = (ServerName)pt.Item;
//display all tables in the database server, when type of server is DbFile
if (sname.Provider.Type == ConnectionProviderType.DbFile)
{
int index = 1;
foreach (DatabaseName dname in sname.GetDatabaseNames())
{
cout.WriteLine();
cout.WriteLine($"({index++}) {dname.Name}");
foreach (TableName tname in dname.GetTableNames())
{
cout.WriteLine($"[{tname.ShortName}]");
tout = new TableOut(tname);
tout.Display(cmd);
}
}
return(true);
}
}
if (pt.Item is DatabaseName)
{
DatabaseName dname = (DatabaseName)pt.Item;
foreach (TableName tname in dname.GetTableNames())
{
cout.WriteLine();
cout.WriteLine($"[{tname.ShortName}]");
tout = new TableOut(tname);
tout.Display(cmd);
}
return(true);
}
if (pt.Item is TableName)
{
TableName tname = (TableName)pt.Item;
if (tname.Type == TableNameType.Table || tname.Type == TableNameType.View)
{
tout = new TableOut(tname);
return(tout.Display(cmd));
}
else
{
string code = tname.DatabaseName.GetProcedure(tname);
if (!string.IsNullOrEmpty(code))
{
cout.WriteLine(code);
return(true);
}
}
}
return(false);
}
