数据库（数据库名为test）中表的内容：
if exists (select * from sysobjects where id = OBJECT_ID('[ItemTree]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [ItemTree]
CREATE TABLE [ItemTree] (
[id] [bigint] IDENTITY (1, 1) NOT NULL,
[title] [nvarchar] (50) NOT NULL,
[pageName] [nvarchar] (50) NULL,
[parentID] [bigint] NOT NULL)
ALTER TABLE [ItemTree] WITH NOCHECK ADD CONSTRAINT [PK_ItemTree] PRIMARY KEY NONCLUSTERED ( [id] )
SET IDENTITY_INSERT [ItemTree] ON
INSERT [ItemTree] ([id],[title],[parentID]) VALUES ( 1,N'会员管理',0)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 2,N'添加会员',N'addmember',1)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 3,N'编辑会员',N'editmember',1)
INSERT [ItemTree] ([id],[title],[parentID]) VALUES ( 4,N'公告管理',0)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 5,N'添加公告',N'addnotice',4)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 6,N'编辑公告',N'editnotice',4)
INSERT [ItemTree] ([id],[title],[parentID]) VALUES ( 7,N'产品管理',0)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 8,N'产品入库',N'inproduct',7)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 9,N'产品出库',N'outproduct',7)
INSERT [ItemTree] ([id],[title],[parentID]) VALUES ( 10,N'产品清单',7)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 12,N'出库清单',N'outproductmenu',10)
INSERT [ItemTree] ([id],[title],[pageName],[parentID]) VALUES ( 13,N'入库清单',N'inproductmenu',10)
SET IDENTITY_INSERT [ItemTree] OFF
if exists (select * from sysobjects where id = OBJECT_ID('[ItemTreeToUsers]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [ItemTreeToUsers]
CREATE TABLE [ItemTreeToUsers] (
[id] [bigint] IDENTITY (1, 1) NOT NULL,
[ItemTreeID] [bigint] NOT NULL,
[UserID] [bigint] NOT NULL)
ALTER TABLE [ItemTreeToUsers] WITH NOCHECK ADD CONSTRAINT [PK_ItemTreeToUsers] PRIMARY KEY NONCLUSTERED ( [id] )
SET IDENTITY_INSERT [ItemTreeToUsers] ON
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 1,1,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 4,7,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 8,12,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 9,4,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 10,2,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 11,10,1)
INSERT [ItemTreeToUsers] ([id],[ItemTreeID],[UserID]) VALUES ( 12,5,1)
SET IDENTITY_INSERT [ItemTreeToUsers] OFF数据模型：
界面设计：
操作类：
public class CommonFuncs
{
#region 加载树结构
/// <summary>
/// 加载树结构，没有加载权限
/// </summary>
/// <param name="tv"></param>
/// <returns></returns>
public static TreeView GetTree(TreeView tv)
{
DataTable dt = null;
dt = new Tools.Common.DbHelper().ExecuteDataTable("select * from ItemTree");//获取全部数据到dt中
var roots = from node in dt.AsEnumerable()
where node.Field<long>("parentID") == 0
select node;
tv.Nodes.Clear();
TreeNode tnode;
foreach (var node in roots)
{
tnode = new TreeNode();
tnode.Tag = node.Field<long>("parentID");
tnode.Text = node.Field<string>("title");
tnode.ToolTipText = node.Field<string>("pageName");
tnode.Name = node.Field<long>("id").ToString();//Name可用来存放ID，它是唯一的
tv.Nodes.Add(tnode);
GetChildNodes(tnode, dt);
}
return tv;
}
/// <summary>
/// 加载子节点
/// </summary>
/// <param name="parentNode">父节点</param>
/// <param name="dt">整个结构的dt</param>
private static void GetChildNodes(TreeNode parentNode, DataTable dt)
{
long ID = Convert.ToInt64(parentNode.Name);
var ChildNodes = from node in dt.AsEnumerable()
where node.Field<long>("parentID") == ID
select node;
TreeNode tnode;
foreach (var node in ChildNodes)
{
tnode = new TreeNode();
tnode.Tag = node.Field<long>("parentID");
tnode.Text = node.Field<string>("title");
tnode.ToolTipText = node.Field<string>("pageName");
tnode.Name = node.Field<long>("id").ToString();
parentNode.Nodes.Add(tnode);
if (dt.AsEnumerable().Count(item => item.Field<long>("parentID") == node.Field<long>("id")) > 0)
{
GetChildNodes(tnode, dt);
}
}
}
#endregion
#region 加载初始权限到TreeView
/// <summary>
/// 加载初始权限到TreeView
/// </summary>
/// <param name="tv">TreeView</param>
/// <param name="userid">用户id号</param>
public static void GetPermis(TreeView tv, long userid)
{
//查询此用户的所有权限
DataTable dtuserpermission = new Tools.Common.DbHelper().ExecuteDataTable("select * from ItemTreeToUsers where userid=" + userid);
GetPermission(tv.Nodes, dtuserpermission, userid);
}
/// <summary>
/// 为节点集合初始化选择状态
/// </summary>
/// <param name="tns">节点集合</param>
/// <param name="dt">权限DataTable</param>
/// <param name="userid">用户id</param>
private static void GetPermission(TreeNodeCollection tns, DataTable dt, long userid)
{
for (int i = 0; i < tns.Count; i++)
{
TreeNode tn = tns[i];
var count = dt.AsEnumerable().Count(item => item.Field<long>("userid") == userid && item.Field<long>("itemtreeID") == Convert.ToInt64(tn.Name));
if (count == 0)
{
tn.Checked = false;
}
else tn.Checked = true;
if (tn.Nodes.Count > 0)//加载子节点权限
{
GetPermission(tn.Nodes, dt, userid);