tasklist_changestartuptasklistid.sql

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

-- =============================================
-- TaskList_ChangeStartupTaskListID
-- =============================================
-- Sets the default task list to display when the user logs in
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_ChangeStartupTaskListID' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_ChangeStartupTaskListID
GO

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

--Check to make sure this is a valid user, and that they have access to this task list
SELECT @CurrentUserID = TaskListUsers.ID 
FROM TaskListUsers 
LEFT JOIN TaskListAssignments AS Ta ON Ta.UserID = TaskListUsers.ID AND Ta.TaskListID = @TaskListID
WHERE Username = @Username AND PasswordHash = @PasswordHash AND Ta.ID IS NOT NULL;
IF (@CurrentUserID IS NULL) Return 1;

UPDATE TaskListUsers SET StartupViewArgument = @TaskListID WHERE ID = @CurrentUserID