tasklist_clearstatusshowpreferences.sql

来自「一个采用VS2008+Sql2000开发的任务管理系统」· SQL 代码 · 共 26 行

-- =============================================
-- TaskList_ClearStatusShowPreferences
-- =============================================
-- Clears the list of status id's to show for this user
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_ClearStatusShowPreferences' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_ClearStatusShowPreferences
GO

CREATE PROCEDURE TaskList_ClearStatusShowPreferences
	@Username VarChar(50),
  @PasswordHash VarChar(50)
AS
DECLARE @CurrentUserID BigInt
SET @CurrentUserID = null

SELECT @CurrentUserID = ID FROM TaskListUsers WHERE Username = @Username AND PasswordHash = @PasswordHash
IF (@CurrentUserID IS NULL) Return 1;

-- Clear out the status show preferences table.  This will make it so that effectively,
-- tasks of ALL status types will be filtered OUT.  Call TaskList_AddStatusShowPreference to add
-- entries to show task types.
DELETE FROM TaskListStatusShowPreferences WHERE UserID = @CurrentUserID