wistudy.sql

开发环境:viual studio 2008 开发语言:C# 开源程度:100 在精心研究PetShop4.0 有几个月了,终于明白了三层的含义,将自己的项目改成三层架构开发,现在将此源程序

@UserSort_Level int,
@UserSort_Audit bit

 AS 
	INSERT INTO Ws_UserSort(
	[UserSort_ID],[UserSort_Name],[UserSort_Level],[UserSort_Audit]
	)VALUES(
	@UserSort_ID,@UserSort_Name,@UserSort_Level,@UserSort_Audit
	)

GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_UserSort_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_UserSort_Update]
GO
------------------------------------
--用途：修改一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-4 8:27:37
------------------------------------
CREATE PROCEDURE UP_Ws_UserSort_Update
@UserSort_ID int,
@UserSort_Name varchar(32),
@UserSort_Level int,
@UserSort_Audit bit
 AS 
	UPDATE Ws_UserSort SET 
	[UserSort_Name] = @UserSort_Name,[UserSort_Level] = @UserSort_Level,[UserSort_Audit] = @UserSort_Audit
	WHERE UserSort_ID=@UserSort_ID 

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_UserSort_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_UserSort_Delete]
GO
------------------------------------
--用途：删除一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-4 8:27:37
------------------------------------
CREATE PROCEDURE UP_Ws_UserSort_Delete
@UserSort_ID int
 AS 
	DELETE Ws_UserSort
	 WHERE UserSort_ID=@UserSort_ID 

GO
/******************************************************************
* 表名：Ws_User
* 时间：2008-5-5 8:08:44
******************************************************************/

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_GetMaxId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_GetMaxId]
GO
------------------------------------
--用途：得到主键字段最大值 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_GetMaxId
AS
	DECLARE @TempID int
	SELECT @TempID = max([User_ID])+1 FROM Ws_User
	IF @TempID IS NULL
		RETURN 1
	ELSE
		RETURN @TempID

GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_Exists]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_Exists]
GO
------------------------------------
--用途：是否已经存在 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_Exists
@User_Name varchar(32)
AS
	DECLARE @TempName int
	SELECT @TempName = count(1) FROM Ws_User WHERE User_Name=@User_Name 
	IF @TempName = 0
		RETURN 0
	ELSE
		RETURN 1

GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_ADD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_ADD]
GO
------------------------------------
--用途：增加一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_ADD
@UserSort_ID int,
@User_ID int,
@User_Name varchar(32),
@User_Password varchar(32)

 AS 
	INSERT INTO Ws_User(
	[UserSort_ID],[User_ID],[User_Name],[User_Password]
	)VALUES(
	@UserSort_ID,@User_ID,@User_Name,@User_Password
	)

GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_Update]
GO
------------------------------------
--用途：修改一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_Update
@UserSort_ID int,
@User_ID int,
@User_Name varchar(32),
@User_Password varchar(32),
@User_Business varchar(32),
@User_Message int,
@User_Audit bit,
@User_Lock bit
 AS 
	UPDATE Ws_User SET 
	[UserSort_ID] = @UserSort_ID,[User_Name] = @User_Name,[User_Password] = @User_Password,[User_Business] = @User_Business,[User_Message] = @User_Message,[User_Audit] = @User_Audit,[User_Lock] = @User_Lock
	WHERE User_ID=@User_ID 

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_Delete]
GO
------------------------------------
--用途：删除一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_Delete
@User_ID int
 AS 
	DELETE Ws_User
	 WHERE User_ID=@User_ID 

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_User_GetModel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_User_GetModel]
GO
------------------------------------
--用途：得到实体对象的详细信息 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:08:44
------------------------------------
CREATE PROCEDURE UP_Ws_User_GetModel
@User_ID int
 AS 
	SELECT 
	UserSort_ID,User_ID,User_Name,User_Password,User_Business,User_Message,User_Audit,User_Lock,User_OnLine,User_JoinDate
	 FROM Ws_User
	 WHERE User_ID=@User_ID 

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_UserSafety_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_UserSafety_Update]
GO
------------------------------------
--用途：修改一条记录 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:51:14
------------------------------------
CREATE PROCEDURE UP_Ws_UserSafety_Update
@User_ID int,
@UserSafety_LastName varchar(8),
@UserSafety_FirstName varchar(16),
@UserSafety_Sex bit,
@UserSafety_Birthday datetime,
@UserSafety_Dwell varchar(64),
@UserSafety_IdCard varchar(32),
@UserSafety_Question varchar(64),
@UserSafety_Answer varchar(64),
@UserSafety_Phone varchar(16),
@UserSafety_Mobile varchar(16),
@UserSafety_Email varchar(64)
 AS 
	UPDATE Ws_UserSafety SET 
	[UserSafety_LastName] = @UserSafety_LastName,[UserSafety_FirstName] = @UserSafety_FirstName,[UserSafety_Sex] = @UserSafety_Sex,[UserSafety_Birthday] = @UserSafety_Birthday,[UserSafety_Dwell] = @UserSafety_Dwell,[UserSafety_IdCard] = @UserSafety_IdCard,[UserSafety_Question] = @UserSafety_Question,[UserSafety_Answer] = @UserSafety_Answer,[UserSafety_Phone] = @UserSafety_Phone,[UserSafety_Mobile] = @UserSafety_Mobile,[UserSafety_Email] = @UserSafety_Email
	WHERE User_ID=@User_ID 

GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UP_Ws_UserSafety_GetModel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UP_Ws_UserSafety_GetModel]
GO
------------------------------------
--用途：得到实体对象的详细信息 
--项目名称：WiStudy
--说明：
--时间：2008-5-5 8:51:14
------------------------------------
CREATE PROCEDURE UP_Ws_UserSafety_GetModel
@User_ID int
 AS 
	SELECT 
	User_ID,UserSafety_LastName,UserSafety_FirstName,UserSafety_Sex,UserSafety_Birthday,UserSafety_Dwell,UserSafety_IdCard,UserSafety_Question,UserSafety_Answer,UserSafety_Phone,UserSafety_Mobile,UserSafety_Email
	 FROM Ws_UserSafety
	 WHERE User_ID=@User_ID 

GO