用DataTable 递归生成目录树代码,C#代码库,德仔网

代码语言

代码分类

【C#】用DataTable 递归生成目录树

作者:明华 / 发布于2016/4/26/ 345

static DataColumn column = new DataColumn();  
  static DataTable table = new DataTable();  
  
    static DataRow MyRow;  
ublic static DataTable GetCategoryTree(WebInfoBase info)  
  {  
     DataTable dt = info.List(_DefaultDB, "", "[ID],[Title],[ParentID],[ChildNum],[Depth],[OrderNo]", "&version=", "[ID] ASC");  
      
     if (table.Rows.Count > 0)  
     {  
         table.Columns.Clear();  
         table.Rows.Clear();  
     }  
     CreateDataTable();  
     GetTree(dt, "0", 0);  
     return table;  
  }  
    public static void GetTree(DataTable dt, string pid, int blank)  
    {  
        string str = " ";  
        DataView dv = new DataView(dt);  
        dv.RowFilter = "ParentID = " + pid;  
        if (blank > 0)  
        {  
            string s = "";  
            if (blank == 1)  
            {  
                str = "├";  
            }  
            for (int i = 2; i <= blank; i++)  
            {  
                s = s + "  |  "+" "+" - ";  
            }  
            str = s + "├";  
        }  
          
        foreach (DataRowView drv in dv)  
        {  
            string id = drv["ID"].ToString();  
            string Title = drv["Title"].ToString();  
            string OrderNo = drv["OrderNo"].ToString();  
            string ParentID = drv["ParentID"].ToString();  
            string Depth = drv["Depth"].ToString();  
            string ChildNum = drv["ChildNum"].ToString();  
              
            MyRow = table.NewRow();  
            MyRow["ID"] = int.Parse(id);  
            MyRow["Title"] = str + Title;  
            MyRow["OrderNo"] = int.Parse(OrderNo);  
            MyRow["ParentID"] = int.Parse(ParentID);  
            MyRow["Depth"] = int.Parse(Depth);  
            MyRow["ChildNum"] = int.Parse(ChildNum);  
            table.Rows.Add(MyRow);  
  
            int n = int.Parse(Depth);  
            //if (n <= 1)  
            //{  
                n++;  
            //}  
            GetTree(dt, id, n);  
        }  
    }  
       public static void CreateDataTable()  
    {  
        table.Columns.Clear();  
        column = new DataColumn();  
        column.DataType = System.Type.GetType("System.Int32");  
        column.ColumnName = "ID";  
        table.Columns.Add(column);  
  
        column = new DataColumn();  
        column.DataType = System.Type.GetType("System.Int32");  
        column.ColumnName = "ParentID";  
        table.Columns.Add(column);  
  
        column = new DataColumn();  
        column.DataType = Type.GetType("System.String");  
        column.ColumnName = "Title";  
        table.Columns.Add(column);  
  
        column = new DataColumn();  
        column.DataType = Type.GetType("System.Int32");  
        column.ColumnName = "ChildNum";  
        table.Columns.Add(column);  
  
        column = new DataColumn();  
        column.DataType = Type.GetType("System.Int32");  
        column.ColumnName = "Depth";  
        table.Columns.Add(column);  
  
        column = new DataColumn();  
        column.DataType = Type.GetType("System.Int32");  
        column.ColumnName = "OrderNo";  
        table.Columns.Add(column);  
        //table.Columns.Clear();  
  
    }

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

同语言下

可能有用的

明华贡献的其它代码(21)