📄 pc_ns_detail.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">
<title>班级管理</title>
<link href="img/Style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style2 {color: #FFFFFF}
-->
</style>
</head>
<body>
<p>
<%
user_no = safeChar(trim(Request("user_no")))
t_month = safeChar(trim(Request("t_month")))
if user_no="" or t_month="" or t_month="fir" or t_month="sed" then
Response.Write("<li>参数非法</li>")
response.End()
end if
sql="select user_no,user_name,m"&t_month&"_apmark,m"&t_month&"_reason,m"&t_month&"_finmark,m"&t_month&"_deptmark,m"&t_month&"_deptreason from pc_user where user_no='"&user_no&"'"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = dbconn
rs.Source = sql
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 1
rs.Open()
if not err.number="0" or rs.eof then
response.Write("<li>参数非法</li>")
else
%>
</p>
<p> </p>
<table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" class="atable1">
<tr bgcolor="#333">
<td colspan="2" class="style2">学号：[ <%=rs(0)%> ] => 姓名：[ <%=rs(1)%> ] => 月份:[<%=t_month%>]</td>
</tr>
<tr class="tdmenu">
<td width="93" align="center" valign="middle" class="jushe">得分项目</td>
<td width="496" align="left" valign="middle" class="jushe"><div align="center">理由</div></td>
</tr>
<tr class="tdmenu">
<td width="93" align="center" valign="middle">基本分<br />
[<span class="hei"> <%=init_score%></span> ]</td>
<td width="496" align="left" valign="middle"> 系统分配的基本分</td>
</tr>
<tr >
<td width="93" align="center" valign="middle" class="tdmenu">个人申请分<br />
[<span class="hei"> <%=rs(2)%></span> ] </td>
<td width="496" align="left" valign="middle" class="tdmenu"><%=tolist(rs(3))%></td>
</tr>
<tr >
<td width="93" align="center" valign="middle" class="tdmenu">部门加减分<br />
[<span class="hei"> <%=rs(5)%></span><span class="red"> </span>] </td>
<td align="left" valign="middle" class="tdmenu"><%=tolist(rs(6))%></td>
</tr>
<tr class="tdmenu">
<td width="93" align="center" valign="middle"><span class="jushe">总分</span><br /> <span class="hei"><strong><%=rs(4)%></strong></span></td>
<td width="496" align="left" valign="middle"> 基本分 + 个人申请分 + 部门加减分</td>
</tr>
</table>
<%end if
rs.close
set rs=nothing
%>
</body>
</html>
<%dbconn.close%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -