Microsoft.Web.UI.WebControls生成Treeview的简单方法

最新推荐文章于 2024-05-05 20:09:01 发布

xgl1999

最新推荐文章于 2024-05-05 20:09:01 发布

阅读量1.7k

点赞数

分类专栏： ASP.NET开发文章标签： dataset application string null session object

本文链接：https://blog.csdn.net/xgl1999/article/details/799517

版权

ASP.NET开发专栏收录该内容

3 篇文章 0 订阅

订阅专栏

private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面

if (!IsPostBack)
{

    int strUserCode = int.Parse(Session["UserCode"].ToString());
    DataSet ds1 = new DataSet();
    string strSQL = "select * from tsys_user where admin_flag=1 and UserCode = "+strUserCode+" and IsDelete! = '1' ";
    DBOperation.executeQuery(ds1,strSQL);
    if (ds1.Tables[0].Rows.Count == 0 )
    {
     Response.Write("<br>您不是管理员,不允许对此操作!<br>");
     return;
    }

    ViewState["Text"] = "";
    //string strSql = "select AppCode,AppName,AppLink,AppStatus,AppCodeUP from TSYS_Application";
    string strSql = "select AppCode,AppName,AppLink,AppStatus,AppCodeUP from TSYS_Application where AppCodeUP='0' or AppCode in (select distinct AppCode from TSYS_UserRight where UserCode ="+strUserCode+")";
    DataSet ds = new DataSet();
    ds = DBOperation.executeQuery(ds,strSql);
    this.ViewState["ds"] = ds;
    AddTree(0, (TreeNode)null);
   }

}

  /// <summary>
  ///递归添加树的节点
  /// </summary>
  /// <param name="ParentID">上级树节点</param>
  /// <param name="pNode">在需要添加树的节点</param>
  private void AddTree(int ParentID,TreeNode pNode)
  {
   DataSet ds = (DataSet) this.ViewState["ds"];
   DataView dvTree = new DataView(ds.Tables[0]);
   //过滤ParentID,得到当前的所有子节点
   dvTree.RowFilter = "[AppCodeUP] = " + ParentID;
   foreach(DataRowView Row in dvTree)
   {
    TreeNode Node=new TreeNode() ;
    if(pNode == null)
    {    //添加根节点
     Node.ID     = Row["AppCode"].ToString();
     Node.Text    = Row["AppName"].ToString();
     Node.ImageUrl   ="../images/home.gif";
     Node.Target    = "mainFrame";
     Node.NavigateUrl  = "AppList.aspx?AppCode="+Row["AppCode"].ToString();

     TreeView1.Nodes.Add(Node);
     Node.Expanded=true;
     AddTree(Int32.Parse(Row["AppCode"].ToString()), Node);    //再次递归
    }
    else
    {   //添加当前节点的子节点
     Node.ID     = Row["AppCode"].ToString();
     Node.Text    = Row["AppName"].ToString();
     Node.Target    = "mainFrame";
     Node.NavigateUrl  = "AppList.aspx?AppCode="+Row["AppCode"].ToString();

     if (Row["AppStatus"].ToString() == "1")
     {
      Node.ImageUrl = "../images/ao1.gif";
     }
     else
     {
      Node.ImageUrl = "../images/ao41.gif";
     }

     pNode.Nodes.Add(Node);
     Node.Expanded = false;
     AddTree(Int32.Parse(Row["AppCode"].ToString()),Node);     //再次递归
    }
   }
  }