会议室预定系统（MROS v1.2）ASP.NET 源代码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MROS_ADMIN]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MROS_ADMIN] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MROS_ROOM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MROS_ROOM] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MROS_ROOM_ORDER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MROS_ROOM_ORDER] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MROS_ROOM_ORDER_ARCHIVE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[MROS_ROOM_ORDER_ARCHIVE] GO CREATE TABLE [dbo].[MROS_ADMIN] ( [Admin] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [pass] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MROS_ROOM] ( [room_id] [int] IDENTITY (1, 1) NOT NULL , [room_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [room_desc] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [room_state] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MROS_ROOM_ORDER] ( [order_date] [datetime] NOT NULL , [room_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [holder_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [met_title] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [start_time] [datetime] NOT NULL , [end_time] [datetime] NOT NULL , [share_modify] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[MROS_ROOM_ORDER_ARCHIVE] ( [order_date] [datetime] NOT NULL , [room_id] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [holder_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [met_title] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [start_time] [datetime] NOT NULL , [end_time] [datetime] NOT NULL , [share_modify] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[MROS_ROOM] WITH NOCHECK ADD CONSTRAINT [PK_MROS_ROOM] PRIMARY KEY CLUSTERED ( [room_id] ) ON [PRIMARY] GO ALTER TABLE [dbo].[MROS_ROOM] ADD CONSTRAINT [DF_MROS_ROOM_room_state] DEFAULT (1) FOR [room_state] GO ALTER TABLE [dbo].[MROS_ROOM_ORDER] ADD CONSTRAINT [DF_MROS_ROOM_ORDER_order_date] DEFAULT (getdate()) FOR [order_date], CONSTRAINT [DF_MROS_ROOM_ORDER_share_modify] DEFAULT (0) FOR [share_modify] GO