C# 递归生成树_TreeView

if exists (select * from sysobjects where id = OBJECT_ID('[SysFun]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [SysFun] CREATE TABLE [SysFun] ( [NodeId] [int] IDENTITY (1, 1) NOT NULL, [DisplayName] [varchar] (50) NOT NULL, [NodeURL] [varchar] (50) NOT NULL, [DisplayOrder] [int] NOT NULL, [ParentNodeId] [int] NOT NULL) ALTER TABLE [SysFun] WITH NOCHECK ADD CONSTRAINT [PK_SysFun] PRIMARY KEY NONCLUSTERED ( [NodeId] ) SET IDENTITY_INSERT [SysFun] ON INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 1,'人事管理','#',2,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 2,'文档管理','#',3,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 3,'考勤管理','#',5,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 4,'消息管理','#',4,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 5,'日程管理','#',1,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 6,'系统管理','#',6,0) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 7,'添加员工','#',1,1) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 8,'修改员工','#',2,1) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 9,'删除员工','#',3,1) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 10,'添加员工基本信息','#',1,7) INSERT [SysFun] ([NodeId],[DisplayName],[NodeURL],[DisplayOrder],[ParentNodeId]) VALUES ( 11,'添加员工基本信息','#',1,10) SET IDENTITY_INSERT [SysFun] OFF