USE [XiaoBo]
GO
/****** 对象: StoredProcedure [dbo].[Products_DS] 脚本日期: 07/06/2007 09:51:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Products_DS]
(
@Pid int ,
@status int ,
@ActType INT ,
@RetValue INT output
)
AS
DECLARE @ID INT
DECLARE @ERROR INT
DECLARE @ROWCOUNT INT
IF( @ActType = 2 )
BEGIN
-- DELETE
DELETE
FROM [Products]
WHERE
[Pid] = @Pid
SELECT @ERROR = @@ERROR, @ID = @@IDENTITY, @ROWCOUNT = @@ROWCOUNT
IF( @ROWCOUNT = 1 )
Set @RetValue=-1
ELSE
Set @RetValue=1
END
ELSE IF( @ActType = 3 )
BEGIN
-- DELETE
Update [Products]
SET [status] = @status
WHERE
[Pid] = @Pid
SELECT @ERROR = @@ERROR, @ID = @@IDENTITY, @ROWCOUNT = @@ROWCOUNT
IF( @ROWCOUNT = 1 )
Set @RetValue=-1
ELSE
Set @RetValue=1
END
ELSE IF (@ActType = 4)
BEGIN
-- SELECT
SELECT *
FROM [Products] (NOLOCK)
WHERE
[Pid] = @Pid
END
ELSE
BEGIN
RAISERROR( 'The ActionType value should be between 2 and 4. The value of %d was not within this range', 16, 1, @ActType )
Set @RetValue=-1
END