tasklist_getstartuptasklistid.sql

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

-- =============================================
-- TaskList_GetStartupTaskListID
-- =============================================
-- Retrieves the TaskListID of the task list this user should first see when logging in.
-- If none exists, then it shows the alphabetical first task list.
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_GetStartupTaskListID' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_GetStartupTaskListID
GO

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

SELECT @CurrentUserID = ID, @TaskListID = StartupViewArgument
FROM TaskListUsers WHERE Username = @Username AND PasswordHash = @PasswordHash

IF (@CurrentUserID IS NULL) Return 1;

SELECT @TaskListID = ID FROM TaskListNames WHERE ID = @TaskListID
IF (@TaskListID IS NULL) --This task list no longer exists
BEGIN
  SELECT Max(TaskListNames.ID) AS TaskListID 
  FROM TaskListNames 
  LEFT JOIN TaskListAssignments ON TaskListAssignments.TaskListID = TaskListNames.ID
  WHERE TaskListAssignments.UserID = @CurrentUserID
END
ELSE
BEGIN
  SELECT @TaskListID AS TaskListID
END