tasklist_getstatuslist.sql

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

-- =============================================
-- TaskList_GetStatusList
-- =============================================
-- Retrieves a list of status items
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_GetStatusList' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_GetStatusList
GO

CREATE PROCEDURE TaskList_GetStatusList
	@Username VarChar(20),
	@PasswordHash VarChar(50)
AS
DECLARE @CurrentUserID BigInt
SET @CurrentUserID = NULL
--Check to see if this is a valid user
SELECT @CurrentUserID = ID FROM TaskListUsers WHERE Username = @Username AND PasswordHash = @PasswordHash
IF (@CurrentUserID IS NULL) Return 1;

SELECT ID AS StatusID,
       StatusDescription AS Description,
			 StatusValue AS Value,
       StatusFontFlags AS FontFlags
FROM TaskListStatus
ORDER BY StatusValue ASC