获取当前在线用户 [英] get the Currently live user

问题描述

如何获得当前正在使用我的asp.net Web应用程序的实时用户.感谢Advance

谢谢
Touqeer hameed
[e-mail]

how can i get the live user that are currently using my asp.net web application.Thanks in Advance

Thanks
Touqeer hameed
[e-mail]

推荐答案

使用ASP.NET会员系统来管理用户帐户.您可以使用以下SP来获取在线用户. br/>
设置ANSI_NULLS ON
设置QUOTED_IDENTIFIER ON
去

-========================================= <<> -作者:< author ,, name>
-创建日期:<创建日期,, =">
-说明:< description ,,>
-========================================= <<> 更改程序

[dbo].[usp_GetCurrentActivityForOnlineUsers]
(
@MinutesSinceLastInactive int
)
AS
DECLARE @CurrentTimeUtc日期时间
SET @CurrentTimeUtc = getutcdate()
DECLARE @DateActive日期时间
SELECT @DateActive = DATEADD(分钟，-(@ MinutesSinceLastInactive)，@CurrentTimeUtc)
SELECT act.UserId，
u.UserName，
act.Activity，
act.PageUrl，
act.ActivityDate，
@CurrentTimeUtc作为CurrentDate
来自dbo.aspnet_Users u(NOLOCK)
内联接dbo.ActivityLog act(NOLOCK)ON
act.UserId = u.UserId
u.LastActivityDate> @DateActive AND
act.ActivityDate = u.LastActivityDate
ORDER BY act.ActivityDate DESC

use ASP.NET member ship system to manage the user accounts.You can use the below SP to fetch who are online.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author: <author,,name>
-- Create date: <create date,,="">
-- Description: <description,,>
-- =============================================
ALTER PROCEDURE

[dbo].[usp_GetCurrentActivityForOnlineUsers]
(
@MinutesSinceLastInactive int
)
AS
DECLARE @CurrentTimeUtc datetime
SET @CurrentTimeUtc = getutcdate()
DECLARE @DateActive datetime
SELECT @DateActive = DATEADD(minute, -(@MinutesSinceLastInactive), @CurrentTimeUtc)
SELECT act.UserId,
u.UserName,
act.Activity,
act.PageUrl,
act.ActivityDate,
@CurrentTimeUtc as CurrentDate
FROM dbo.aspnet_Users u(NOLOCK)
INNER JOIN dbo.ActivityLog act(NOLOCK) ON
act.UserId = u.UserId
WHERE u.LastActivityDate > @DateActive AND
act.ActivityDate = u.LastActivityDate
ORDER BY act.ActivityDate DESC

这篇关于获取当前在线用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！