spUser_UpdateNetAccountOnlineStatus
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientUsersID | int | IN | |
| @OnlineStatus | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spUser_UpdateNetAccountOnlineStatus]
(
@ClientUsersID int,
@OnlineStatus int
)
AS
BEGIN
if @OnlineStatus = 0
begin
UPDATE NetAccount
SET OnlineStatus = @OnlineStatus , OnlineStatusUpdateDate = NULL, UpdateDate = getUTCDate()
WHERE ClientUsersID = @ClientUsersID
end
if @OnlineStatus > 0
begin
UPDATE NetAccount
SET OnlineStatus = @OnlineStatus , OnlineStatusUpdateDate = getUTCDate(), UpdateDate = getUTCDate()
WHERE ClientUsersID = @ClientUsersID
end
END