tasklist_changestartupviewoption.sql

来自「该项目管理系统可对项目的过程进行管理和控制」· SQL 代码 · 共 28 行

-- =============================================
-- TaskList_ChangeStartupViewOption
-- =============================================
-- Changes the method the application uses to decide what
-- task list to show the user when they first log in
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_ChangeStartupViewOption' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_ChangeStartupViewOption
GO

CREATE PROCEDURE TaskList_ChangeStartupViewOption
	@Username VarChar(20),
  @PasswordHash VarChar(50),
  @StartupViewOption 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;

IF @StartupViewOption = 'LastTaskList'
  UPDATE TaskListUsers SET StartupViewOption = 'LastTaskList' WHERE ID = @CurrentUserID
ELSE
  UPDATE TaskListUsers SET StartupViewOption = 'SpecificTaskList' WHERE ID = @CurrentUserID