📄 list_user.asp
字号:
<%
'************************************************************************************************
' 文件名: list_user.asp
' Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'
' 创建人 :weilin
' 日 期 : 2002-11-11
' 修改历史 :
' ****年**月**日 ****** 修改内容:**************************************************
' 功能描述 : 列出用户信息，供查询和维护（修改用户角色，重置用户密码）
' 版 本 :
'************************************************************************************************
option explicit
'Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
%>
<!-- #include file="../include/common.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/commonpage.inc" -->
<!-- #include file="list_user.inc" -->
<%
call CheckSecurity()
if IsAdministrator then
else
Response.Clear
Response.Redirect "../include/error.asp?error=对不起，你不是系统管理员&"
Response.End
end if
dim conn:set conn=DBConnection
'********************************************************************************************************
' 服务器端代码
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 分页相关的变量定义
'-------------------------------------------------------------------------------------------------------------------------------------------------
Dim sSQL, sWhere, sOrderby
Dim sFileName : sFileName = "list_user.asp"
Dim sEmpId : sEmpId = GetEmpid
Dim iTotalRecords : iTotalRecords = 0 ' 分页
Dim iRecordsPerPage : iRecordsPerPage = 15
Dim iTotalPages : iTotalPages = 0
Dim iCols : iCols = 4
Dim iCurrentPage : iCurrentPage = GetParam("Page")
Dim sSorting : sSorting = GetParam("Sorting")
Dim sSorted : sSorted = GetParam("Sorted")
Dim sSortParams : sSortParams = ""
Dim sFormParams : sFormParams = ""
Dim sDirection : sDirection = ""
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 查询参数，开始时间，结束时间，查询种类
'-------------------------------------------------------------------------------------------------------------------------------------------------
Dim sAccountid : sAccountid = GetParam("accountid")
Dim iRoleid : iRoleid = GetParam("roleid")
Dim iStatus : iStatus = GetParam("status")
if IsEmpty(sAccountid) then sAccountid = ""
if IsEmpty(iRoleid) then iRoleid = 0 '如果为空，选出所有角色
if IsEmpty(iStatus) then iStatus = -1 '如果为空，选出所有用户
dim sqlstatus
if iStatus="-1" then
sqlstatus=""
else
sqlstatus=" and status="&iStatus
end if
''sFormParams = "accountid=" & sAccountid & "&roleid=" & iRoleid & "&status=" & iStatus & "&"
'********************************************************************************************************
' 根据查询种类的不同，构造不同的分页的SQL语句
'********************************************************************************************************
if iRoleid = 0 then
sSQL = " SELECT * FROM T_account where account_id like '"&"%"&sAccountid&"%"&"'"&sqlstatus &" and account_id <> 'admin'"
else
sSQL = " SELECT * FROM T_account where account_id like '"&"%"&sAccountid&"%"&"' and role_id ="&iRoleid&sqlstatus&" and account_id<> 'admin'"
end if
'********************************************************************************************************
' 分页SQL语句构造完毕，调用PrepareListData进行分页前的准备
'-------------------------------------------------------------------------------------------------------------------------------------------------
dim arrayFields(2), sDelimiter
sDelimiter = "*"
arrayFields(0) = "account_id"
arrayFields(1) = "role_id"
arrayFields(2) = "status"
call PrepareListData(conn,sSQL, Join(arrayFields, sDelimiter), sDelimiter)
'********************************************************************************************************
%>
<html>
<head>
<title>系统管理——用户管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../include/common.css" type="text/css">
<script language="VBScript">
Sub btnSearch_OnClick()
document.all.frmSearchUser.submit()
End Sub
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="../images/bg/bg0.jpg">
<br>
<%
Response.Write OuterTableHeader
Response.Write HeaderWithMenu
Response.Write InnerTableHeader
'********************************************************************************************************
' 主体从这里开始
'-------------------------------------------------------------------------------------------------------------------------------------------------
Response.Write TableSearch
Response.Write TableHeader
Response.Write TableRecords(sSQL & sWhere & sOrderby, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams )
Response.Write TableLink
'-------------------------------------------------------------------------------------------------------------------------------------------------
' 主体到这里结束
'********************************************************************************************************
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
Disconnect(conn)
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -