原帖地址:http://community.csdn.net/Expert/topic/3663/3663934.xml?temp=.9100458
--测试数据create table PROJECT(id int,name nvarchar(20),parent_id int)insert PROJECT select 1,'所有项目',nullunion all select 2,'项目1',1union all select 3,'项目2',1
create table task(id int,name nvarchar(20),outline varchar(10))insert task select 1 ,'任务1' ,'1'union all select 2 ,'任务1.1' ,'1.1'union all select 3 ,'任务1.1.1' ,'1.1.1'union all select 4 ,'任务1.1.2' ,'1.1.2'union al......
阅读全文