tasklist_gettasklistlist.sql

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

-- =============================================
-- TaskList_GetTaskListList
-- =============================================
-- Retrieves a list task lists from the database
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_GetTaskListList' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_GetTaskListList
GO

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

--Make sure that this is a valid user, and that they have manager priviledges
SELECT @CurrentUserID=ID 
FROM TaskListUsers 
WHERE Username = @Username AND PasswordHash = @PasswordHash AND IsManager = 1;

IF (@CurrentUserID IS NULL) RETURN 1; --Invalid user

--Now get the list of task lists
SELECT ID as TaskListID, Name as TaskListName FROM TaskListNames ORDER BY TaskListNames.[Name]