摘要：
创建：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Class]GOCreate TABLE [dbo].[Class] ([Class_Id] [int] NOT NULL ,[Class_Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[Parent_ID] [int] 阅读全文
摘要：
--生成测试数据createtable BOM(ID int,parentID int,sClassName varchar(10))insertinto BOM values(1,0,'1111' )insertinto BOM values(2,1,'1111_1' )insertinto BOM values(3,2,'1111-1-1' )insertinto BOM values(4,3,'1111-1-1-1') insertinto BOM values(5,1,'1111-2' )go--创建用户定 阅读全文
摘要：
using System; using System.Web; u... 阅读全文