📄 paiming.asp
字号:
<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''版权：野马原创 ''''
''''联系：ctplr@163.com ''''
''''说明：需要新功能联系我 ''''
''''QQ:2643148 ''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
%>
<!--#include file="check.asp"-->
<!--#include file="conn.asp"-->
<link href=left.css rel=stylesheet>
<body onkeydown="if(event.keyCode==122){event.keyCode=0;return false}" background="../images/index_bj.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
act=request("act")
if act="" then
act="dft"
end if
if act="dft" then
%>
<center>
<form action="?act=paiming" method=post name=frm>
<table border=1 bgcolor=#000099 bordercolor=#3399ff><br>
<tr align="center" >
<td height="23" colspan="4" background="../images/TitleTop.gif"> <img src="../images/User.gif" width="19" height="20"><font color=#00ffcc>选定排名条件</font></td>
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" > </td>
</tr>
<tr> <td colspan="2" align="center" >工 作 组
<select name="ptype" >
<option value=0>选择工作组</option>
<%
sql="select * from type"
rs1.open sql,cn,1,1
do while not rs1.eof
tname=rs1("typename")
%>
<option value=<%=rs1("type")%> ><%=tname%>
<%
rs1.movenext
loop
rs1.close
%>
</select>
</td> <td rowspan=2 bgcolor=#0055aa><b>排名<Br>项目<Br></b></td><td rowspan=2 valign=center>
<input type=radio name=ltype value=考勤 checked><font color=#00ffcc>月考勤分
<input type=radio name=ltype value=所有考勤 >总考勤分</font><br>
<input type=radio name=ltype value=签到><font color=yellow>月签到数
<input type=radio name=ltype value=所有签到>总签到数</font><br>
<input type=radio name=ltype value=迟到><font color=#ff6600>月迟到数
<input type=radio name=ltype value=所有迟到>总迟到数</font><br>
</td></tr>
<tr><td>排名数目<input type=text name=nnum size=6 value=10></td></tr>
<tr > <td colspan=4 align=center bgcolor=#0055aa>
<font color=#ffaa00>校长是否参加排名 <input type=radio value=是 name=xz <%if session("qx")>2 then%> disabled<%end if%> >是 <input type=radio value=否 name=xz <%if session("qx")>2 then%> disabled<%end if%> checked>否
</font> </td>
</tr>
<tr > <td colspan=4 align=center>
<input type=radio value=page name=way checked>排名到页面预览<input type=radio value=db name=way <%if session("qx")>2 then%> disabled<%end if%>>排名并记录到数据库
</td>
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" > </td>
</tr>
<tr><td colspan=4 align=center bgcolor=#0055aa> <input type=submit value=开始排名 class=ibox onclick="{if(confirm('确认提交?')){return true;}return false;}"> </td></tr>
</table>
</form>
</center>
<p></p><p></p>
<center>
<form action="?act=look" method=post name=frm>
<table border=1 bgcolor=#000099 bordercolor=#3399ff><br>
<tr align="center" >
<td height="23" colspan="4" background="../images/TitleTop.gif"> <img src="../images/User.gif" width="19" height="20"><font color=yellow>查看数据库排名记录</font></td>
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" > </td>
</tr>
<tr> <td colspan="2" align="center" >察看前<input type=text name=nnum value=50 size=4 class=ebox>名<br>
<select name="ptype" >
<option value=0>选择工作组</option>
<%
sql="select * from type"
rs1.open sql,cn,1,1
do while not rs1.eof
tname=rs1("typename")
%>
<option value=<%=rs1("type")%> ><%=tname%>
<%
rs1.movenext
loop
rs1.close
%>
</select>
</td> <td rowspan=2 bgcolor=#0055aa>排名<br>项目<Br></td><td rowspan=2 valign=center>
<input type=radio name=ltype value="考勤" checked><font color=#00ffcc>月考勤分
<input type=radio name=ltype value="所有考勤" >总考勤分</font><br>
<input type=radio name=ltype value="签到"><font color=yellow>月签到数
<input type=radio name=ltype value="所有签到">总签到数</font><br>
<input type=radio name=ltype value="迟到"><font color=#ff6600>月迟到数
<input type=radio name=ltype value="所有迟到">总迟到数</font><br>
</td></tr>
<tr >
</tr>
<tr >
<td height="5" colspan="4" align="center" bordercolor="#FF9900" background="../images/loginLine.gif" > </td>
</tr>
<tr><td colspan=4 align=center> <input type=submit value=查看排名 class=ibox > </td></tr>
</table>
</form>
</center>
<%end if
if act="paiming" then
if request("way")="page" then
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''排名到页面'''''''''''''''''''''''''''''''''
if request("ptype")=0 then
response.write "<script>alert('请选择工作组');history.back();</script>"
else
num=request.form("nnum")
if num=empty or num<1 then
num=10
end if
n=1
ptype=int(request("ptype"))
ltype=request("ltype")
sql="select * from type where type="&ptype
rs1.open sql,cn,1,1
gamename=rs1("typename")
rs1.close
if ltype="考勤" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthfen desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthfen desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%> <%=ltype%> 排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>本月考勤分</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthfen=rs("monthfen")
%>
<tr><td align=center bgcolor=#0055aa><font color=#00ffcc><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=monthfen%> </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有考勤" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by allfen desc"
else
sql="select * from ct_sql where type="&ptype&" order by allfen desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>所有考勤分</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
allfen=rs("allfen")
%>
<tr><td align=center><font color=#00ffcc bgcolor=#0055aa><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=allfen%> </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="签到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthqdnum desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthqdnum desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>本月签到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthqdnum=rs("monthqdnum")
%>
<tr><td align=center bgcolor=#0055aa><font color=#00ffcc><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=monthqdnum%> 次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有签到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by allqdnum desc"
else
sql="select * from ct_sql where type="&ptype&" order by allqdnum desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>所有签到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
allqdnum=rs("allqdnum")
%>
<tr><td align=center bgcolor=#0055aa><font color=#00ffcc><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=allqdnum%>次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="迟到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by monthlattertime desc"
else
sql="select * from ct_sql where type="&ptype&" order by monthlattertime desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>本月迟到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
monthlattertime=rs("monthlattertime")
%>
<tr><td align=center bgcolor=#0055aa><font color=#00ffcc><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=monthlattertime%> 次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
end if
if ltype="所有迟到" then
if request.form("xz")="否" then
sql="select * from ct_sql where type="&ptype&" and qx=5 order by alllattertime desc"
else
sql="select * from ct_sql where type="&ptype&" order by alllattertime desc"
end if
rs.open sql,cn,1,1
%>
<center><p align=center><font color=#ff6600 size=5><br> <%=gamename%><%=ltype%>排名</font><input type=button class=ebox onclick="history.back()" value=返回></p>
<TABLE border=1 bordercolor=#3399ff bgcolor=#000099>
<tr><td background="../images/TitleTop.gif" align=center><b>排名</b></td>
<td background="../images/TitleTop.gif" align=center><b>登陆帐号</b></td><td background="../images/TitleTop.gif" align=center><b>真实姓名</b></td>
<td background="../images/TitleTop.gif" align=center><b>所有迟到</b></td></tr>
<% do while (not rs.eof and n<num+1)
pname=rs("username")
realname=rs("realname")
alllattertime=rs("alllattertime")
%>
<tr><td align=center bgcolor=#0055aa><font color=#00ffcc><%=n%></td>
<td align=center><%=pname%></td><td align=center><%=realname%></td>
<td align=center><font color=#ff6600> <%=alllattertime%>次 </td></tr>
<%
rs.movenext
n=n+1
loop
response.write "</TABLE>"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -