187713732 asp.net 交流群,希望有更多的人可以加入,大家可以互相学习,帮助需要帮助的人,帮助刚入门的同行或即将入门的同行解决问题。
DAL方法,BLL省略
public static List<SysFun> GetSysFunByParentNodeId(int parentNodeid)
{
List<SysFun> listSysFun = new List<SysFun>();
string sql = " SELECT * FROM [MYBOOKSHOP].[dbo].[SysFun] WHERE ParentNodeId =@parentNodeid ";
SqlParameter[] par =
{
new SqlParameter("@parentNodeid",parentNodeid)
};
using (SqlDataReader sqlReader =DBHelper.GetReader(sql,CommandType.Text,par))
{
while (sqlReader.Read())
{
SysFun sysFun = new SysFun();
sysFun.NodeId = (int)sqlReader["NodeId"];
sysFun.DisplayName = sqlReader["DisplayName"].ToString();
sysFun.ParentNodeId = (int)sqlReader["ParentNodeid"];
listSysFun.Add(sysFun);
}
}
return listSysFun;
}
public static List<SysFun> GetSysFun(int parentNodeid)
{
List<SysFun> listSysFun = new List<SysFun>();
string sql = " SELECT * FROM [MYBOOKSHOP].[dbo].[SysFun] WHERE ParentNodeid =@parentNodeid ";
SqlParameter[] par =
{
new SqlParameter("@parentNodeid",parentNodeid)
};
using (SqlDataReader sqlReader = DBHelper.GetReader(sql, CommandType.Text, par))
{
while (sqlReader.Read())
{
SysFun sysFun = new SysFun();
sysFun.NodeId = (int)sqlReader["NodeId"];
sysFun.DisplayName = sqlReader["DisplayName"].ToString();
sysFun.ParentNodeId = (int)sqlReader["ParentNodeid"];
listSysFun.Add(sysFun);
}
}
return listSysFun;
}
页面后台代码:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
TVSysFun.ExpandDepth = 0;
BindTreeView();
}
}
private void BindTreeView()
{
List<SysFun> list = BookManager.GetSysFun(0);
//遍历父节点
foreach (SysFun parentNode in list)
{
TreeNode pNode = new TreeNode();
pNode.Value = parentNode.NodeId.ToString();
pNode.Text = parentNode.DisplayName.ToString();
//遍历父节点下的子节点
List<SysFun> childNode = BookManager.GetSysFunByParentNodeId(Convert.ToInt32( parentNode.NodeId));
foreach (SysFun cNode in childNode)
{
TreeNode node = new TreeNode();
node.Value = cNode.NodeId.ToString();
node.Text = cNode.DisplayName.ToString();
pNode.ChildNodes.Add(node);
}
TVSysFun.Nodes.Add(pNode);
}
}