public static void InitSheetCatlog(TreeView View)
{
View.Nodes.Clear();
TreeNode TopNode = new TreeNode();
TopNode.Name = "";
TopNode.Text = "表单列表";
TopNode.SelectedImageIndex = 1;
TopNode.ImageIndex = 0;
View.Nodes.Add(TopNode);
DataSet ds = ModuleHelperClient.GetSheetCategoryAndSheet();
DataTable dt = ds.Tables["dbo.sys_biz_SheetCatlog"];
DataTable sheetDT = ds.Tables["dbo.sys_sheet"];
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
TreeNode node = new TreeNode();
node.Name = row["ID"].ToString();
node.Text = row["CatlogName"].ToString();
node.SelectedImageIndex = 1;
node.ImageIndex = 0;
node.Tag = false;
TopNode.Nodes.Add(node);
DataRow[] sheetRows = sheetDT.Select("CatlogCode like '" + row["CatlogCode"] + "%' ", "Name asc");
if (sheetRows != null && sheetRows.Length > 0)
{
foreach (DataRow r1 in sheetRows)
{
TreeNode n = new TreeNode();
n.Name = r1["ID"].ToString();
n.Text = r1["Name"].ToString();
n.SelectedImageIndex = 2;
n.ImageIndex = 2;
n.Tag = true;
node.Nodes.Add(n);
}
}
}
}
View.ExpandAll();
}
