Dlh21数据库备份

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_selWhereFatherID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_selWhereFatherID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_selWhereOrderID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_selWhereOrderID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_updWhereID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_updWhereID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category_updWhereOrderID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Category_updWhereOrderID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Images_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Images_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Images_del]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Images_del]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Images_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Images_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_sea]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_sea]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_seaWhereCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_seaWhereCategory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_selWhereCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_selWhereCategory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_selWhereID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_selWhereID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_upd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_upd]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info_updTitleCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Info_updTitleCategory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_del]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_del]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_mod]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_mod]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_selTop4]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_selTop4]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_selWhereFlag]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_selWhereFlag]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member_selWhereMember]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Member_selWhereMember]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Members_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Members_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Members_selWhereRegName]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Members_selWhereRegName]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Members_selWhereRegNamePassword]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Members_selWhereRegNamePassword]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Products_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Products_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Products_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Products_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_del]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_del]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_mod]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_mod]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_selWhereYesOrNo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_selWhereYesOrNo]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_updQuestionWhereID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_updQuestionWhereID]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_updWhereQuestion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_updWhereQuestion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_updYesOrNoWhereQuestion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_updYesOrNoWhereQuestion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question_updYesOrNo_0]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Question_updYesOrNo_0]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject_add]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Subject_add]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject_del]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Subject_del]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject_mod]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Subject_mod]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject_sel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Subject_sel]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject_selTop8]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Subject_selTop8]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Category]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Images]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Images]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Member]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Member]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Members]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Members]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Products]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Question]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Question]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subject]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Subject]
GO

CREATE TABLE [dbo].[Category] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [OrderID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [DeepID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Category] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [FatherID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Images] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Path] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [Width] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Height] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [AddDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Category] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Subject] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Info] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Info] [text] COLLATE Chinese_PRC_CI_AS NULL ,
 [AddDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Category] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Subject] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [IndexView] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Member] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Member] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Flag] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Members] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Member] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [RegName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [TruName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Sex] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [PasQuestion] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [PasKey] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [RegDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Products] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [ProName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [ProSize] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [ProID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Category] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Img] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [Pic] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
 [RetailPrice] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Vouch] [int] NULL ,
 [Info] [text] COLLATE Chinese_PRC_CI_AS NULL ,
 [AddDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Question] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [A] [int] NULL ,
 [B] [int] NULL ,
 [C] [int] NULL ,
 [D] [int] NULL ,
 [AA] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [BB] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [CC] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [DD] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Question] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [YesOrNo] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Subject] (
 [ID] [int] IDENTITY (1, 1) NOT NULL ,
 [Subject] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [AddDate] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
 [Img] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_add
/*
 添加类别
*/
@OrderID varchar(50),
@DeepID varchar(50),
@Category varchar(50),
@FatherID varchar(50)
AS
 INSERT INTO Category
       (OrderID, DeepID, Category, FatherID)
 VALUES (@OrderID, @DeepID, @Category, @FatherID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_sel
/*
 选择全部类别
*/
AS
 SELECT Category.*
 FROM Category
 ORDER BY OrderID
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_selWhereFatherID
/*
 选择父类
*/
@FatherID varchar(50)
AS
 SELECT Category.*
 FROM Category
 WHERE (FatherID = @FatherID)
 ORDER BY OrderID DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_selWhereOrderID
/*
 选择某类
*/
@OrderID varchar(50)
AS
 SELECT Category.*
 FROM Category
 WHERE (OrderID = @OrderID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_updWhereID
/*
 修改类别
*/
@OrderID varchar(50),
@DeepID varchar(50),
@Category varchar(50),
@FatherID varchar(50),
@ID int
AS
 UPDATE Category
 SET OrderID =  @OrderID, DeepID = @DeepID, Category = @Category, FatherID = @FatherID
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Category_updWhereOrderID
/*
 修改类别
*/
@OrderID varchar(50),
@DeepID varchar(50),
@Category varchar(50),
@FatherID varchar(50)
AS
 UPDATE Category
 SET DeepID = @DeepID, Category = @Category, FatherID = @FatherID
 WHERE (OrderID = @OrderID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Images_add
/*
 添加图片
*/
@Path varchar(200),
@Width varchar(50),
@Height varchar(50),
@AddDate varchar(50),
@Category varchar(50),
@Subject varchar(50)
AS
 INSERT INTO Images
       (Path, Width, Height, AddDate, Category, Subject)
 VALUES (@Path, @Width, @Height, @AddDate, @Category, @Subject)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Images_del
/*
 删除图片
*/
@ID int
AS
 DELETE FROM Images
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Images_sel
/*
 遍历图片
*/
AS
 SELECT Images.*
 FROM Images
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_add
/*
 添加信息
*/
@Title varchar(50),
@Info text,
@AddDate varchar(50),
@Category varchar(50),
@Subject varchar(50),
@IndexView int
AS
 INSERT INTO Info
       (Title, Info, AddDate, Category, Subject, IndexView)
 VALUES (@Title, @Info, @AddDate, @Category, @Subject, @IndexView)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_sea
/*
 搜索
*/
@Title varchar(50),
@Info text
AS
 SELECT Info.*
 FROM Info
 WHERE (Title LIKE @Title) OR
       (Info LIKE @Info)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_seaWhereCategory
/*
 搜索某类新闻关键字
*/
@Title varchar(50),
@Info text,
@Category varchar(50)
AS
 SELECT Info.*
 FROM Info
 WHERE ((Category = @Category) AND
       (Title LIKE @Title)) OR ((Category = @Category) AND (Info LIKE @Info))
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_sel
/*
 信息列表
*/
AS
 SELECT Info.*
 FROM Info
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_selWhereCategory
/*
 某类列表
*/
@Category varchar(50)
AS
 SELECT Info.*
 FROM Info
 WHERE (Category = @Category)
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_selWhereID
/*
 显示某条新闻
*/
@ID int
AS
 SELECT Info.*
 FROM Info
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_upd
/*
 更新
*/
@Title varchar(50),
@Info text,
@AddDate varchar(50),
@Category varchar(50),
@Subject varchar(50),
@IndexView int,
@ID int
AS
 UPDATE Info
 SET Title = @Title, Info = @Info, AddDate = @AddDate, Category = @Category,
       Subject = @Subject, IndexView = @IndexView
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Info_updTitleCategory
/*
 更新
*/
@Title varchar(50),
@Category varchar(50),
@ID int
AS
 UPDATE Info
 SET Title = @Title, Category = @Category
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_add
/*
 添加会员类别
*/
@Member varchar(50),
@Flag int
AS
 INSERT INTO Member
       (Member, Flag)
 VALUES (@Member, @Flag)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_del
/*
 删除会员类别
*/
@ID int
AS
 DELETE FROM Member
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_mod
/*
 修改会员类别
*/
@Member varchar(50),
@Flag int,
@ID int
AS
 UPDATE Member
 SET Member = @Member, Flag = @Flag
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_sel
/*
 选择会员所有类别
*/
AS
 SELECT Member.*
 FROM Member
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_selTop4
/*
 会员列表
*/
AS
 SELECT TOP 4 Member.*
 FROM Member
 WHERE (Flag > 0)
 ORDER BY Flag
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_selWhereFlag
/*
 验证会员类型编号
*/
@Flag int
AS
 SELECT Member.*
 FROM Member
 WHERE (Flag = @Flag)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Member_selWhereMember
/*
 验证会员名称
*/
@Member varchar(50)
AS
 SELECT Member.*
 FROM Member
 WHERE (Member = @Member)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Members_add
/*
 注册
*/
@Member varchar(50),
@RegName varchar(50),
@TruName varchar(50),
@Sex varchar(50),
@Password varchar(50),
@PasQuestion varchar(50),
@PasKey varchar(50),
@Email varchar(50),
@RegDate varchar(50)
AS
 INSERT INTO Members
       (Member, RegName, TruName, Sex, Password, PasQuestion, PasKey, Email,
       RegDate)
 VALUES (@Member, @RegName, @TruName, @Sex, @Password, @PasQuestion,
       @PasKey, @Email, @RegDate)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Members_selWhereRegName
/*
 判断有没有该用户
*/
@RegName varchar(50)
AS
 SELECT Members.*
 FROM Members
 WHERE (RegName = @RegName)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Members_selWhereRegNamePassword
/*
 判断用户名和密码是否正确
*/
@RegName varchar(50),
@Password varchar(50)
AS
 SELECT Members.*
 FROM Members
 WHERE (RegName = @RegName) AND (Password = @Password)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Products_add
/*
 添加产品
*/
@ProName varchar(50),
@ProSize varchar(50),
@ProID varchar(50),
@Category varchar(50),
@Img varchar(200),
@Pic varchar(200),
@RetailPrice varchar(50),
@Vouch int,
@Info text,
@AddDate varchar(50)
AS
 INSERT INTO Products
       (ProName, ProSize, ProID, Category, Img, Pic, RetailPrice, Vouch, Info, AddDate)
 VALUES (@ProName, @ProSize, @ProID, @Category, @Img, @Pic, @RetailPrice, @Vouch,
       @Info, @AddDate)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Products_sel
/*
 遍历产品
*/
AS
 SELECT Products.*
 FROM Products
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_add
/*
 添加问题
*/
@Question varchar(50),
@A int,
@B int,
@C int,
@D int,
@AA varchar(50),
@BB varchar(50),
@CC varchar(50),
@DD varchar(50),
@YesOrNo int
AS
 INSERT INTO Question
       (AA, BB, CC, DD, Question, A, B, C, D, YesOrNo)
 VALUES (@AA, @BB, @CC, @DD, @Question, @A, @B, @C, @D, @YesOrNo)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_del
/*
 删除问题
*/
@ID int
AS
 DELETE FROM Question
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_mod
/*
 修改问题
*/
@Question varchar(50),
@A int,
@B int,
@C int,
@D int,
@AA varchar(50),
@BB varchar(50),
@CC varchar(50),
@DD varchar(50),
@ID int
AS
 UPDATE Question
 SET A = @A, B = @B, C = @C, D = @D, AA = @AA, BB = @BB, CC = @CC, DD = @DD,
       Question = @Question
 WHERE (ID = @Question)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_sel
/*
 遍历调查表
*/
AS
 SELECT Question.*
 FROM Question
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_selWhereYesOrNo
/*
 遍历调查表
*/
@YesOrNo int
AS
 SELECT Question.*
 FROM Question
 WHERE (YesOrNo = @YesOrNo)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_updQuestionWhereID
/*
 更新问题字段
*/
@Question varchar(50),
@ID int
AS
 UPDATE Question
 SET Question = @Question
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_updWhereQuestion
/*
 更新问题数据
*/
@A int,
@B int,
@C int,
@D int,
@AA varchar(50),
@BB varchar(50),
@CC varchar(50),
@DD varchar(50),
@Question varchar(50)
AS
 UPDATE Question
 SET A = @A, B = @B, C = @C, D = @D, AA = @AA, BB = @BB, CC = @CC, DD = @DD
 WHERE (Question = @Question)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_updYesOrNoWhereQuestion
/*
 更新显示问题
*/
@Question varchar(50),
@YesOrNo int
AS
 UPDATE Question
 SET YesOrNo = @YesOrNo
 WHERE (Question = @Question)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Question_updYesOrNo_0
/*
 把所有的问题隐藏
*/
@YesOrNo int
AS
 UPDATE Question
 SET YesOrNo = @YesOrNo
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Subject_add
/*
 添加专题
*/
@Subject varchar(50),
@AddDate varchar(50),
@Img varchar(200)
AS
 INSERT INTO Subject
       (Subject, AddDate, Img)
 VALUES (@Subject, @AddDate, @Img)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Subject_del
/*
 删除专题
*/
@ID int
AS
 DELETE FROM Subject
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Subject_mod
/*
 修改专题
*/
@Subject varchar(50),
@AddDate varchar(50),
@ID int,
@Img varchar(200)
AS
 UPDATE Subject
 SET Subject = @Subject, AddDate = @AddDate, Img = @Img
 WHERE (ID = @ID)
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Subject_sel
/*
 选择所有专题
*/
AS
 SELECT Subject.*
 FROM Subject
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE Subject_selTop8
/*
 专题列表
*/
AS
 SELECT TOP 8 Subject.*
 FROM Subject
 ORDER BY AddDate DESC
 RETURN

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO