📄 pc_sh.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="const.asp" -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {color: #FFFFFF; }
.STYLE3 {
font-size: 18;
font-weight: bold;
color:#00FF00;
}
-->
</style>
</head>
<%
dim t_month,dept_socre,sql
t_month=dept_allow_month
dept_score="dept_score"&dept_allow_month
dept_id=session("dept_id")
sql="SELECT u_d,dept_name,score,bz from "&dept_score&" where u_d like '%#"&dept_id&"' ORDER BY u_d ASC"
if dept_id="" then
response.Write("<li>登录超时</li>")
response.End()
end if
Set myclass=new xdownpage
myclass.getconn=dbconn
myclass.getsql =sql
myclass.pagesize=20
set rs=myclass.getrs()
%>
<%
action=safeChar(Request.form("action"))
if action="sh_apply" then
set c = Server.CreateObject("ADODB.Command")
c.ActiveConnection = dbconn
c.CommandText = "update dept set power=1 where dept_id="&dept_id&""
c.CommandType = 1
c.CommandTimeout = 0
c.Prepared = true
c.Execute()
if err.number="0" then
Response.Write("<li>审核已经提交</li>")
else
Response.Write("<li>审核提交失败</li>")
end if
else
%>
<body>
<table width="94%" border="0" align="center" cellpadding="2" cellspacing="1" class="atable1">
<tr>
<td width="10%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">学号</div>
</div></td>
<td width="14%" bgcolor="#333333"><div align="center" class="STYLE2">
<div align="center">部门</div>
</div></td>
<td width="14%" bgcolor="#333333"><div align="center" class="STYLE2">[<span class="red" ><%=t_month%></span>]月得分</div></td>
<td width="50%" bgcolor="#333333"><div align="center" class="STYLE2">理由</div></td>
<td width="12%" bgcolor="#333333"><div align="center"><a href="pc_add.asp" style="font-family:Arial, Helvetica, sans-serif; font-weight:bolder; color:#FFFFFF" title="添加成员"><strong>添加部门评分</strong></a></div></td>
</tr>
<%if rs.eof then%>
<tr>
<td colspan="5" class="tdmenu"><div align="center"><br />
还没有部门评分记录，<a href="pc_add.asp">请添加</a><br />
<br />
</div></td>
</tr>
<%else%>
<%for i=1 to myclass.pagesize
if not rs.eof then
y=split(rs(0),"#")%>
<tr>
<td class="tdmenu"><div align="center"><%=(y(0))%></div></td>
<td class="tdmenu"><div align="center"><%=(rs(1))%></div></td>
<td class="tdmenu"><div align="center" class="red"><%=(rs(2))%></div></td>
<td class="tdmenu"><div align="left"><%=(rs(3))%></div></td>
<td class="tdmenu"><div align="center"><a href="pc_update.asp?u_d=<%=y(0)%>">修改</a></div></td>
</tr>
<% rs.movenext()
else
exit for
end if
next %>
<tr>
<td height="40" colspan="5" align="right" valign="bottom" class="tdmenu"><% myclass.showpage()%><br />
</td>
</tr>
<%end if%>
</table>
<tr>
<td height="40" colspan="4" align="right" valign="bottom" class="tdmenu"><br />
<br />
<%if pow_class=1 then%><center><form method="post" name="form" id="form" ><input name="sh" type="submit" class="tdmenu" id="sh" value="如果批阅完所有学生的申请分，请提交审核" />
<input name="action" type="hidden" value="sh_apply" />
</form></center><%end if%></td>
</tr>
<%end if%>
</table>
</body>
</html>
<%
rs.Close()
Set rs = Nothing
%>
<%dbconn.close%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -