public List <DataSummary> GetDbSummarise()
{
List <DataSummary> summarise = new List <DataSummary>();
DbConnection conn = db.GetConnection();
DataTable dt = conn.GetSchema("Tables");
DataView dv = dt.DefaultView;
dv.Sort = "TABLE_NAME";
conn.Close();
SchemaContainer <XTableSchema> xtc = XTableSchemaContainer.Instance();
foreach (DataRowView dr in dv)
{
DataSummary tbSummary = new DataSummary();
tbSummary.Name = dr["TABLE_NAME"].ToString();
tbSummary.Description = dr["TABLE_NAME"].ToString();
tbSummary.Caption = dr["TABLE_NAME"].ToString();
tbSummary.Type = dr["TABLE_TYPE"].ToString();
XTableSchema ts = xtc.GetItem(tbSummary.Name);
if (xtc.Contains(tbSummary.Name))
{
tbSummary.Caption = ts.Title;
tbSummary.Description = ts.Description;
}
summarise.Add(tbSummary);
}
return(summarise);
}
private static void loadSubNodes(List <TreeNode> subNodes, string path, ref int id)
{
string[] folders = container.GetSchemaFolders(path);
for (int i = 0; i < folders.Length; i++)
{
string subFolder = folders[i];
TreeNode node = new TreeNode();
node.label = subFolder;
node.path = path;
node.nodeType = (int)DsExploreNodeType.folder;
node.id = id + "";
node.text = subFolder;
subNodes.Add(node);
id++;
loadSubNodes(node.children, path + "\\" + subFolder, ref id);
}
string[] dataSources = container.GetIDsByFolder(path);
for (int i = 0; i < dataSources.Count(); i++)
{
string dsId = dataSources[i];
DataSourceSchema ts = container.GetItem(path + "\\" + dsId);
TreeNode node = new TreeNode();
node.text = ts.Title + "(" + dsId + ")";
node.label = node.text;
node.title = node.text;
if (string.IsNullOrEmpty(node.label))
{
node.label = dsId;
}
node.name = node.text;
node.id = dsId;
node.path = path;
node.nodeType = (int)DsExploreNodeType.dataSource;
//node.id = id + "";
subNodes.Add(node);
id++;
}
}
