📄 admin_count.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp" -->
<%
if session("admin_id")=""then
response.write "<script language=JavaScript>{window.alert('对不起，您尚未登录或登录超时或登录超时!');window.location.href='index.asp';}</script>"
response.end
end if
%>
<html>
<head>
<STYLE type=text/css>
BODY {
SCROLLBAR-FACE-COLOR: #c6ebde;
MARGIN: 0px;
FONT: 9pt 宋体;
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
SCROLLBAR-SHADOW-COLOR: #39867b;
SCROLLBAR-3DLIGHT-COLOR: #39867b;
SCROLLBAR-ARROW-COLOR: #330000;
SCROLLBAR-TRACK-COLOR: #e2f3f1;
SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
TEXT-DECORATION: none;
background-image: url(images/bg/bg2.gif);
}
TABLE {
BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
TD {
FONT: 14px 宋体
}
IMG {
BORDER-RIGHT: 0px; BORDER-TOP: 0px; VERTICAL-ALIGN: bottom; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
A {
FONT: 14px 宋体; COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
COLOR: #cc0000; TEXT-DECORATION: underline
}
.sec_menu {
BORDER-RIGHT: white 1px solid; BACKGROUND: #c6ebde; OVERFLOW: hidden; BORDER-LEFT: white 1px solid; BORDER-BOTTOM: white 1px solid
}
.menu_title {
}
.menu_title SPAN {
FONT-WEIGHT: bold; LEFT: 8px; COLOR: #39867b; POSITION: relative; TOP: 2px
}
.menu_title2 {
}
.menu_title2 SPAN {
FONT-WEIGHT: bold; LEFT: 8px; COLOR: #cc0000; POSITION: relative; TOP: 2px
}
INPUT{BORDER-TOP-WIDTH: 1px; PADDING-RIGHT: 1px; PADDING-LEFT: 1px; BORDER-LEFT-WIDTH: 1px; FONT-SIZE: 9pt; BORDER-LEFT-COLOR: #cccccc; BORDER-BOTTOM-WIDTH: 1px; BORDER-BOTTOM-COLOR: #cccccc; PADDING-BOTTOM: 1px; BORDER-TOP-COLOR: #cccccc; PADDING-TOP: 1px; HEIGHT: 18px; BORDER-RIGHT-WIDTH: 1px; BORDER-RIGHT-COLOR: #cccccc}
select {border-width: 1; border-color: #000000; background-color: #ffffff; font-family: 宋体; font-size: 9pt; font-style: bold;}
OPTION {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
.style1 {color: #FF0000}
</STYLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {
color: #FF0000;
font-weight: bold;
}
.style2 {color: #0000FF}
.style4 {color: #FF0000}
.style5 {color: #FF3300}
body {
margin-left: 0px;
margin-top: 0px;
}
.style6 {color: #FF0000}
.style6 { color: #FF0000;
font-weight: bold;
}
.style9 {color: #009933}
-->
</style>
<%
requestid=session("admin_id")
set rsadminlogin=server.createobject("adodb.recordset")
sqladmin_login="select * from admin_login where admin_id ="&requestid&""
rsadminlogin.open sqladmin_login,conn,1,2
%>
</head>
<body>
<div align="center" class="style1">
<p> </p>
<p>您的身份：“管理员”</p>
<table width="95%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><p align="center">您已经是<span class="style4">第 <%=rsadminlogin.recordcount%> 次</span>登录
<% rsadminlogin.movelast%>
上次登录时间为
<% =rsadminlogin("logintime") %>
IP：<% =rsadminlogin("loginip") %></p> </td>
</tr>
</table>
<p class="style2">[系统统计]</p>
<table width="650" border="1" cellpadding="2" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="347"><div align="right"><span class="style2">正式教工数为(已通过审核且不在回收站的）：</span></div></td>
<% set rsjg=server.createobject("adodb.recordset")
sqljg="select * from jg where ischeck like 0 and isdeletetozhan = '否'"
rsjg.open sqljg,conn,1,2
%>
<td width="408"><span style="color: #FF3300"><%=rsjg.RecordCount%></span></td>
</tr>
<tr>
<td><div align="right"><span class="style2">尚未审核的教工数为：</span></div></td>
<% set rsnewjg=server.createobject("adodb.recordset")
sqlnewjg="select * from jg where ischeck like 1 "
rsnewjg.open sqlnewjg,conn,1,2
%>
<td width="408"><span style="color: #FF3300"><%=rsnewjg.RecordCount%></span></td>
</tr>
<tr>
<td><div align="right"><span class="style2">已经删除到回收站的教工数为：</span></div></td>
<% set rszhan=server.createobject("adodb.recordset")
sqlzhan="select * from jg where isdeletetozhan = '是' "
rszhan.open sqlzhan,conn,1,2
%>
<td width="408"><span style="color: #FF3300"><%=rszhan.RecordCount%></span></td>
</tr>
<tr>
<td><div align="right"><span class="style2">管理员访问总数为：</span></div></td>
<% set rsadminlogin=server.createobject("adodb.recordset")
sqladmin_login="select * from admin_login"
rsadminlogin.open sqladmin_login,conn,1,2
%>
<td width="408"><span style="color: #FF3300"><%=rsadminlogin.RecordCount%></span></td>
</tr>
<tr>
<td><div align="right"><span class="style2">教工登录次总数为：</span></div></td>
<% set rsjglogin=server.createobject("adodb.recordset")
sqljg_login="select * from jg_login"
rsjglogin.open sqljg_login,conn,1,2
%>
<td width="408"><span style="color: #FF3300"><%=rsjglogin.RecordCount%></span></td>
</tr>
<tr>
<td colspan="2"> <span class="style4"> 职称统计(已通过审核且不在回收站的）：</span> <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td>高级<span class="style5">（
<% set rsgj=server.createobject("adodb.recordset")
sqlgj="select * from jg where ischeck like 0 and isdeletetozhan = '否'and zhicheng='中学高级'"
rsgj.open sqlgj,conn,1,1
%>
<%=rsgj.recordcount%> <%rsgj.close
set rsgj=nothing%>
）
</span></td>
<td>中学一级<span class="style5">（
<% set rsgj=server.createobject("adodb.recordset")
sqlgj="select * from jg where ischeck like 0 and isdeletetozhan = '否'and zhicheng='中学一级'"
rsgj.open sqlgj,conn,1,1
%>
<%=rsgj.recordcount%>
<%rsgj.close
set rsgj=nothing%>
） </span></td>
<td>中学二级<span class="style5">
（
<% set rsgj=server.createobject("adodb.recordset")
sqlgj="select * from jg where ischeck like 0 and isdeletetozhan = '否'and zhicheng='中学二级'"
rsgj.open sqlgj,conn,1,1
%>
<%=rsgj.recordcount%>
<%rsgj.close
set rsgj=nothing%>
） </span></td>
<td>特级<span class="style5">
（
<% set rsgj=server.createobject("adodb.recordset")
sqlgj="select * from jg where ischeck like 0 and isdeletetozhan = '否'and zhicheng='特级'"
rsgj.open sqlgj,conn,1,1
%>
<%=rsgj.recordcount%>
<%rsgj.close
set rsgj=nothing%>
） </span></td>
<td>试用期<span class="style5">（
<% set rsgj=server.createobject("adodb.recordset")
sqlgj="select * from jg where ischeck like 0 and isdeletetozhan = '否'and zhicheng='试用期'"
rsgj.open sqlgj,conn,1,1
%>
<%=rsgj.recordcount%>
<%rsgj.close
set rsgj=nothing%>
） </span></td>
</tr>
</table></td>
</tr>
</table>
<span class="style6"><a name="jg" id="jg"></a></span><br>
<table width="600" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFCCCC">
<tr>
<td height="29"><div align="center"><span class="style9">正式教工列表(已通过审核且不在回收站的)</span></div></td>
</tr>
<tr>
<td>
<div align="left">
<%
set rsjg=server.createobject("adodb.recordset")
sqljg="select * from jg where ischeck like 0 and isdeletetozhan = '否' order by name desc"
rsjg.open sqljg,conn,1,2
if rsjg.eof and rsjg.bof then
response.write("没找到记录，或者记录被删除到回收站中，或者没有通过审核")
response.end
end if %>
<% do while not rsjg.eof %>
<a href="admin_jgdetial.asp?id=<%=rsjg("id")%>" title="<%=rsjg("sex")%> & <%=rsjg("birthday")%>生 & <%=rsjg("zhicheng")%> & <%=rsjg("xueke")%>"><%=rsjg("name")%></a>
<% rsjg.movenext
loop %>
</div></td></tr>
</table>
<br>
<br>
<table cellspacing=0 cellpadding=0 width=650 align=center>
<tbody>
<tr>
<td height=20> 版权：轻燕工作室 程序：轻燕工作室</td>
</tr>
<tr>
<td height=20> 版本：V5.0 日期：2005-10-16 主页：<a href="http://www.pc71.com">www.pc71.com</a></td>
</tr>
</tbody>
</table>
<p><br>
</p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -