cleanonline.asp

来自「功能齐全的oa系统」· ASP 代码 · 共 8 行

<%
	Function CleanOnline(ObjDB)
		Dim StrSQL
		StrSQL = "Update t_OA_MSN_Account Set State = 0 Where LastUpdateTime < '" & DateAdd("n",-10,Now()) & "';"
		StrSQL = StrSQL & "Update t_OA_MSN_Account Set State = 1,LastUpdateTime=getdate() Where AccountID = " & Session("AccountID")
		ObjDB.Execute StrSQL
	End Function
%>