tasklist_getnumberofitemstodisplayperpage.sql

该项目管理系统可对项目的过程进行管理和控制

-- =============================================
-- TaskList_GetNumberOfItemsToDisplayPerPage
-- =============================================
-- Retrieves the number of task list items to display per page on the task list 
-- for the user specified
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_GetNumberOfItemsToDisplayPerPage' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_GetNumberOfItemsToDisplayPerPage
GO

CREATE PROCEDURE TaskList_GetNumberOfItemsToDisplayPerPage
	@Username VarChar(20),
  @PasswordHash VarChar(50)
AS
DECLARE @CurrentUserID BigInt, @NumberOfItems VarChar(20)
SET @CurrentUserID = NULL

SELECT @CurrentUserID = ID, @NumberOfItems = ItemsToDisplay 
FROM TaskListUsers 
WHERE Username = @Username AND PasswordHash = @PasswordHash

IF (@CurrentUserID IS NULL) Return 1;

IF (@NumberOfItems IS NULL) 
  SELECT 'All' AS NumberOfItems;
ELSE
  SELECT @NumberOfItems AS NumberOfItems;