【正文】 ] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_StockTemp] ([StockTempID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,[UserID] [int] NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[FDepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[LDepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CGoodsTime] [datetime] NULL ,[StockNum] [int] NULL ,[CGoodsNum] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Unit] ([UnitID] [int] IDENTITY (1, 1) NOT NULL ,[UnitName] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_User] ([UserID] [int] IDENTITY (1, 1) NOT NULL ,[Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[SysLoginName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Pwd] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[Sex] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Birthday] [datetime] NULL ,[Department] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Post] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PhoneH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PhoneM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[PopedomID] [int] NULL ) ON [PRIMARY]GO《數(shù)據(jù)庫(kù)語(yǔ)言》課程設(shè)計(jì)說(shuō)明書(shū) 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Unit]GO《數(shù)據(jù)庫(kù)語(yǔ)言》課程設(shè)計(jì)說(shuō)明書(shū) 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院if exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_StockTemp]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Stock]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Sell]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_ReGoods]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Post]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Popedom]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Goods]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Depot]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Department]GO《數(shù)據(jù)庫(kù)語(yǔ)言》課程設(shè)計(jì)說(shuō)明書(shū) 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院if exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Customer]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。) = 1)drop table [dbo].[tb_Company]GOif exists (select * from where id = object_id(N39。) and OBJECTPROPERTY(id, N39。 } } } endregion }}數(shù)據(jù)庫(kù)腳本如下：if exists (select * from where id = object_id(N39。 } finally { if (GetCon().State == ) { GetCon().Close()。 } catch (Exception ex) { (錯(cuò)誤： + , 錯(cuò)誤提示, , )。 try { P_Dr = ()。 } } } endregion region 返回 SqlDaraReader 類型數(shù)據(jù) /// summary /// 返回 SqlDataReader 類型數(shù)據(jù) /// /summary《數(shù)據(jù)庫(kù)語(yǔ)言》課程設(shè)計(jì)說(shuō)明書(shū) 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院 /// param name=cmdtxt要執(zhí)行的 SQL 語(yǔ)句/param /// returns/returns public SqlDataReader GetReader(string cmdtxt) { G_Com = new SqlCommand(cmdtxt, GetCon())。 } finally { if (GetCon().State == ) { GetCon().Close()。 } catch (Exception ex) { (錯(cuò)誤： + , 錯(cuò)誤提示, , )。 (P_tbl)。 //聲明一個(gè) DataTable 對(duì)象 try { G_Da = new SqlDataAdapter(cmdtxt, tablename)。 GetCon().Dispose()。 return null。 return G_Ds。 G_Ds = new DataSet()。 GetCon().Dispose()。 return false。 return true。 } endregion region 執(zhí)行 SQL 語(yǔ)句 /// summary /// 執(zhí)行 SQL 語(yǔ)句 /// /summary /// param name=cmdtxt要執(zhí)行的 SQL 語(yǔ)句/param /// returns/returns public bool GetExecute(string cmdtxt) {《數(shù)據(jù)庫(kù)語(yǔ)言》課程設(shè)計(jì)說(shuō)明書(shū) 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院 G_Com = new SqlCommand(cmdtxt, GetCon())。 ()。 SqlConnection G_Con。DATABASE=db_GoodsManage。 //聲明數(shù)據(jù)集對(duì)象 SqlCommand G_Com。 namespace { class SqlBaseClass { regio