tasklist_createtasklist.sql

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

-- =============================================
-- TaskList_CreateTaskList
-- =============================================
-- Creates a new task list
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_CreateTaskList' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_CreateTaskList
GO

CREATE PROCEDURE TaskList_CreateTaskList
	@Username VarChar(20),
	@PasswordHash VarChar(50),
	@TaskListName VarChar(255)
AS
DECLARE @CurrentUserID BigInt, @Exists BigInt
SET @CurrentUserID = NULL

--Check to make sure this user 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

--Check to make sure a task list doesn't already exist with this name
SELECT @Exists = Count(ID) FROM TaskListNames WHERE [Name] = @TaskListName
IF (@Exists > 0) Return 1;

--Finally, add the task list
INSERT INTO TaskListNames (Name) VALUES (@TaskListName)
IF @@Error <> 0 Return 1;