tasklist_updatesortorderpreferences.sql

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

-- =============================================
-- TaskList_UpdateSortOrderPreferences
-- =============================================
-- Changes sort order preferences for a user
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_UpdateSortOrderPreferences' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_UpdateSortOrderPreferences
GO

CREATE PROCEDURE TaskList_UpdateSortOrderPreferences
 	@Username VarChar(50), 
  @PasswordHash VarChar(50),
  @StatusID BigInt, 
  @SortOrder Int
AS
DECLARE @CurrentUserID BigInt
SET @CurrentUserID = null

SELECT @CurrentUserID = ID FROM TaskListUsers WHERE Username = @Username AND PasswordHash = @PasswordHash

IF (@CurrentUserID IS NULL) Return 1;

--Okay now update their sort order
UPDATE TaskListSortOrderPreferences SET SortOrder = @SortOrder
WHERE UserID = @CurrentUserID AND StatusID = @StatusID