ASP.NET+SQL2005电子选课系统

use park go /****** Object: Stored Procedure dbo.Check_Content_Right Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Check_Content_Right]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Check_Content_Right] GO /****** Object: Stored Procedure dbo.ClassSystem_Change_ClassStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Change_ClassStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ClassSystem_Change_ClassStatus] GO /****** Object: Stored Procedure dbo.ClassSystem_Delete_Class Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Delete_Class]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ClassSystem_Delete_Class] GO /****** Object: Stored Procedure dbo.ClassSystem_Get_ClassStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_Get_ClassStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ClassSystem_Get_ClassStatus] GO /****** Object: Stored Procedure dbo.ClassSystem_List_Classes Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClassSystem_List_Classes]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ClassSystem_List_Classes] GO /****** Object: Stored Procedure dbo.CourseSystem_Add_Course Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Add_Course]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Add_Course] GO /****** Object: Stored Procedure dbo.CourseSystem_Add_Teacher Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Add_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Add_Teacher] GO /****** Object: Stored Procedure dbo.CourseSystem_Change_CourseStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_CourseStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Change_CourseStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_Change_StudentStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_StudentStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Change_StudentStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_Change_TeacherStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Change_TeacherStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Change_TeacherStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_Delete_Course Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Delete_Course]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Delete_Course] GO /****** Object: Stored Procedure dbo.CourseSystem_Delete_Teacher Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Delete_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Delete_Teacher] GO /****** Object: Stored Procedure dbo.CourseSystem_Get_CourseStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_CourseStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Get_CourseStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_Get_StudentStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_StudentStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Get_StudentStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_Get_TeacherList Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_TeacherList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Get_TeacherList] GO /****** Object: Stored Procedure dbo.CourseSystem_Get_TeacherStatus Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_Get_TeacherStatus]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_Get_TeacherStatus] GO /****** Object: Stored Procedure dbo.CourseSystem_List_Courses Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_List_Courses]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_List_Courses] GO /****** Object: Stored Procedure dbo.CourseSystem_List_Teacher Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CourseSystem_List_Teacher]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[CourseSystem_List_Teacher] GO /****** Object: Stored Procedure dbo.Help_Get_HelpFile Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Help_Get_HelpFile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Help_Get_HelpFile] GO /****** Object: Stored Procedure dbo.Login_Get_Role Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Role]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Get_Role] GO /****** Object: Stored Procedure dbo.Login_Get_Roles Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Roles]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Get_Roles] GO /****** Object: Stored Procedure dbo.Login_Get_Task Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_Task]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Get_Task] GO /****** Object: Stored Procedure dbo.Login_Get_UserView Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Get_UserView]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Get_UserView] GO /****** Object: Stored Procedure dbo.Login_Verify_Password Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Verify_Password]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Verify_Password] GO /****** Object: Stored Procedure dbo.Login_Verify_PasswordNull Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login_Verify_PasswordNull]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login_Verify_PasswordNull] GO /****** Object: Stored Procedure dbo.Member_Add_Student Script Date: 2003-5-31 17:34:09 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_Add_Student]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Member_Add_Student] GO /****** Object: Stored Procedure