📄 admin_index_first.asp
字号:
<!--#include file="Check_Sql123.asp" -->
<!--#include file="admin_qx.asp" -->
<%call islogin()
%>
<!--#include file="inc/Config_zd.asp"-->
<!--#include file="conn_db123.asp" -->
<html>
<head>
<style type="text/css">
<!--
table {
word-break:break-all;
}
.style1 {color: #0000FF}
.STYLE2 {color: #FF0000}
body {
margin-left: 0px;
margin-right: 0px;
margin-bottom: 2px;
background-color: #39867b;
margin-top: 0px;
SCROLLBAR-FACE-COLOR: #c6ebde;
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
SCROLLBAR-SHADOW-COLOR: #39867b;
SCROLLBAR-3DLIGHT-COLOR: #39867b;
SCROLLBAR-ARROW-COLOR: #330000;
SCROLLBAR-TRACK-COLOR: #e2f3f1;
SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
}
body,td,th {
font-size: 12px;
}
a:link {
color: #006600;
text-decoration: none;
}
a:visited {
color: #0000FF;
text-decoration: none;
}
a:hover {
color: #FF0000;
text-decoration: underline;
}
a:active {
color: #99FF66;
text-decoration: none;
}
-->
</style>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/Style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE3 {font-size: 14px}
.STYLE13 {font-size: 12px; color: #000000; }
-->
</style>
</head>
<BODY bgcolor="D6DFF7" leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<br>
<table class=tableBorder width="97%" border=0 align="center" cellpadding=5 cellspacing=1>
<tbody>
<tr>
<th height=21 sytle="line-height:150%">【系统数据统计】</th>
</tr>
<tr>
<td height="49" class=forumRow>本系统录入人员总数:
<a href="helpfiles/htongji.asp" title="查看详细人员" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where id is not null"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
<%=rsgg("allren")%>
<%
set rsgg=nothing
%>
</a>(其中,正式记录有<a href="helpfiles/htongji.asp" title="查看详细人员" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
<%=rsgg("allren")%>
<%
set rsgg=nothing
%>
条
</a>,未审核记录<a href="helpfiles/htongji.asp" title="查看详细人员" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck<>'passcheck'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
<%=rsgg("allren")%>
<%
set rsgg=nothing
%>
条
</a>) <br>
<br>
以下列出的是正式记录的统计数据,<span class="STYLE2">点击相应的 数字 即可查看具体人员</span></td>
</tr>
<tr>
<td height="20" class=forumRow>【第一学历】
<%
if xueli_setconst<>"" then
xueli_setconst=split(xueli_setconst,",")
num_all=ubound(xueli_setconst)
for i_num=0 to num_all
'---------------
%>
<%=xueli_setconst(i_num)%> <a href="helpfiles/htongji.asp" title="查看<%=xueli_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and xueli1='"&xueli_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%>
</a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【最高学历】
<%
if xueli_setconst<>"" then
xueli_setconst=split(xueli_setconst,",")
num_all=ubound(xueli_setconst)
for i_num=0 to num_all
'---------------
%>
<%=xueli_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=xueli_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and xueli2='"&xueli_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【政治面貌】
<%
if zhengzhimianmao_setconst<>"" then
zhengzhimianmao_setconst=split(zhengzhimianmao_setconst,",")
num_all=ubound(zhengzhimianmao_setconst)
for i_num=0 to num_all
'---------------
%>
<%=zhengzhimianmao_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=zhengzhimianmao_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and zhengzhimianmao='"&zhengzhimianmao_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【任教学科】
<%
if xueke_setconst<>"" then
xueke_setconst=split(xueke_setconst,",")
num_all=ubound(xueke_setconst)
for i_num=0 to num_all
'---------------
%>
<%=xueke_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=xueke_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and xueke='"&xueke_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【所在部门】
<%
if bumen_setconst<>"" then
bumen_setconst=split(bumen_setconst,",")
num_all=ubound(bumen_setconst)
for i_num=0 to num_all
'---------------
%>
<%=bumen_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=bumen_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and bumen='"&bumen_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【在职状态】
<%
if zaizhizhuangtai_setconst<>"" then
zaizhizhuangtai_setconst=split(zaizhizhuangtai_setconst,",")
num_all=ubound(zaizhizhuangtai_setconst)
for i_num=0 to num_all
'---------------
%>
<%=zaizhizhuangtai_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=zaizhizhuangtai_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and zaizhizhuangtai='"&zaizhizhuangtai_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【编制情况】
<%
if bianzhi_setconst<>"" then
bianzhi_setconst=split(bianzhi_setconst,",")
num_all=ubound(bianzhi_setconst)
for i_num=0 to num_all
'---------------
%>
<%=bianzhi_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=bianzhi_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and bianzhi='"&bianzhi_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【编制类别】
<%
if bianzhileibie_setconst<>"" then
bianzhileibie_setconst=split(bianzhileibie_setconst,",")
num_all=ubound(bianzhileibie_setconst)
for i_num=0 to num_all
'---------------
%>
<%=bianzhileibie_setconst(i_num)%> <a href="helpfiles/htongji.asp" title="查看<%=bianzhileibie_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and bianzhileibie='"&bianzhileibie_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)
<%
set rsgg=nothing
%>
</a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【婚姻状况】
<%
if hunyinzhuangkuang_setconst<>"" then
hunyinzhuangkuang_setconst=split(hunyinzhuangkuang_setconst,",")
num_all=ubound(hunyinzhuangkuang_setconst)
for i_num=0 to num_all
'---------------
%>
<%=hunyinzhuangkuang_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=hunyinzhuangkuang_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and hunyinzhuangkuang='"&hunyinzhuangkuang_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【最高职称】
<%
if zhicheng_setconst<>"" then
zhicheng_setconst=split(zhicheng_setconst,",")
num_all=ubound(zhicheng_setconst)
for i_num=0 to num_all
'---------------
%>
<%=zhicheng_setconst(i_num)%> <a href="helpfiles/htongji.asp" title="查看<%=zhicheng_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and zhicheng='"&zhicheng_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)
<%
set rsgg=nothing
%>
</a>
<%next
end if
%></td>
</tr>
<tr>
<td height="20" class=forumRow>【现聘职称】
<%
if zhicheng_setconst<>"" then
zhicheng_setconst=split(zhicheng_setconst,",")
num_all=ubound(zhicheng_setconst)
for i_num=0 to num_all
'---------------
%>
<%=zhicheng_setconst(i_num)%>
<a href="helpfiles/htongji.asp" title="查看<%=zhicheng_setconst(i_num)%>详细" target="_self">
<%
sqlgg="select count(*) as allren from mainjg where ischeck='passcheck' and zhicheng_xianpin='"&zhicheng_setconst(i_num)&"'"
set rsgg=server.CreateObject("adodb.recordset")
rsgg.open sqlgg,conn,1,1
%>
(<%=rsgg("allren")%>)<%
set rsgg=nothing
%></a>
<%next
end if
%></td>
</tr>
</tbody>
</table>
<br>
<br>
<table class=tableBorder width="97%" border=0 align="center" cellpadding=5 cellspacing=1>
<tbody>
<tr>
<th height=21 colspan="2" sytle="line-height:150%">【其他信息】</th>
</tr>
<tr>
<td width="47%" class=forumRow><span class="forumRowHighlight">轻燕工作室 版权所有,侵权必究</span></td>
<td width="53%" class=forumRowHighlight><span class="forumRow">Tel:13507959978 0795-3997919 传真:0795-3997919</span></td>
</tr>
<tr>
<td class=forumRow>主页:<a href="http://www.qingyan.net.cn" target="_blank">http://www.qingyan.net.cn</a></td>
<td class=forumRowHighlight><span class="forumRow">QQ:782552550 16731175</span></td>
</tr>
<tr>
<td class=STYLE13 colspan="2" style="background-color: #D4DEF9">演示地址: <a href="http://www.qingyan.net.cn/yanshi/rs" target="_blank">http://www.qingyan.net.cn/yanshi/rs</a> (可在线演示系统的全部功能)<br>
如果您满意,可直接购买;如您不满意,可联系我们修改或定制一个让您完全满意的系统</td>
</tr>
<tr>
<td class=forumRow colspan="2" style="background-color: #D4DEF9">
<p align="center" class="STYLE3"><span class="forumRowHighlight">轻燕工作室</span>,专业程序开发,提供高质量的软件产品技术和服务,欢迎前来<span class="STYLE2"><a href="http://www.qingyan.net.cn" target="_blank"><font color="#FF0000">购买或定制</font></a></span>软件任何软件</td>
</tr>
</tbody>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -