paiming.asp

通用考勤系统

   end if
  
 end if
end if


 '''''''''''''''''排名到数据库''''''''''''''
if request("way")="db" then

 if request.form("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=request("ptype")
 ltype= request("ltype")
 


   
  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,3,3

  do while (not rs.eof and n<num+1)  
 
rs("monthfenpaiming")=n
rs("monthfenpmtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('本月考勤排名完成');history.back();</script>"
 
   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,3,3

  do while (not rs.eof and n<num+1)  
 
rs("allfenpaiming")=n
rs("allfenpmtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('所有考勤排名完成');history.back();</script>"
 
   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,3,3

  do while (not rs.eof and n<num+1)  
 
rs("monthqdpaiming")=n
rs("monthqdpmtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('本月签到排名完成');history.back();</script>"
 
   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,3,3
  do while (not rs.eof and n<num+1)  
 
rs("allqdpaiming")=n
rs("allqdpaimingtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('所有签到次数排名完成');history.back();</script>"
 
   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,3,3

  do while (not rs.eof and n<num+1)  
 
rs("monthlatterpaiming")=n
rs("monthlatterpmtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('本月迟到排名完成');history.back();</script>"
 
   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,3,3
%>
 <%   do while (not rs.eof and n<num+1)  
 
rs("alllatterpaiming")=n
rs("alllatterpmtime")=now()
rs.update
rs.movenext
n=n+1
loop
response.write "<script>alert('所有迟到排名完成');history.back();</script>"
 
   end if


end if
end if
end if
if act="look" then
   num=int(request.form("nnum")-1)  
if num=empty or num<1 then
num=9
end if
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''查看'''''''''''''''''''''''''''''''''
 if request("ptype")=0 then
response.write "<script>alert('请选择工作组');history.back();</script>"
else
 
 ptype=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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  monthfenpaiming  "
rs.open sql,cn,1,1
monthfenpmtime=rs("monthfenpmtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=monthfenpmtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
monthfenpaiming=rs("monthfenpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=monthfenpaiming%></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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  allfenpaiming  "
rs.open sql,cn,1,1
allfenpmtime=rs("allfenpmtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=allfenpmtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
allfenpaiming=rs("allfenpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=allfenpaiming%></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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  monthqdpaiming "
rs.open sql,cn,1,1
monthqdpmtime=rs("monthqdpmtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=monthqdpmtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
monthqdpaiming=rs("monthqdpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=monthqdpaiming%></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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  allqdpaiming"
rs.open sql,cn,1,1
allqdpaimingtime=rs("allqdpaimingtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=allqdpaimingtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
allqdpaiming=rs("allqdpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=allqdpaiming%></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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  monthlatterpaiming"
rs.open sql,cn,1,1
monthlatterpmtime=rs("monthlatterpmtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=monthlatterpmtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
monthlatterpaiming=rs("monthlatterpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=monthlatterpaiming%></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
sql="select  *  from ct_sql   where type="&ptype&"  order  by  alllatterpaiming"
rs.open sql,cn,1,1
alllatterpmtime=rs("alllatterpmtime")
%>
<center><p align=center><font color=#000000 size=5><br> <font color=#00ffcc><%=gamename%></font><font color=#ff6600><%=ltype%></font>排名<font color=yellow> </font></font><br>
<font color=#77777>排名时间::<%=alllatterpmtime%></font><input type=button class=ebox onclick="history.back()" value=返回></p>

<TABLE border=1 bordercolor=#3399ff  bgcolor=#000099><tr><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")
alllatterpaiming=rs("alllatterpaiming")
%>
<tr><td   align=center  bgcolor=#0055aa><font color=#00ffcc><%=alllatterpaiming%></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>"
   end if


end if

    
 end if
 
%>