📄 studentqingjia.asp

📁 职业培训学校学生档案成绩费用管理系统V1.0免费版.rar

💻 ASP

字号:

<%
if session("sNumber")="" then
	response.write "<script>alert('对不起，您没有登陆，请先登陆后在访问。');document.location.href='index.asp';</script>"
	response.end
end if
%>
<!--#include file="conn.asp"-->
<%

dim sNumber
sNumber=trim(session("sNumber"))

set rs=server.createobject("adodb.recordset")
sql="select * from qingjia where user_number='"&sNumber&"'"
rs.open sql,conn,1,1
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>请假记录</title>
<link rel="stylesheet" href="admin/style.css">
</head>

<body>
<!--#include file="top.asp"--><P>
<div align="center">
<table border="1" width="700" bordercolorlight="#000000" cellspacing="0" cellpadding="4" bordercolordark="#FFFFFF">
     <tr>
	  <td width="50" align="center">学号</td>
      <td width="50" align="center">姓名</td>
      <td width="100" align="center">请假时间</td>
	  <td width="350" align="center">请假原因</td>
	  <td width="50" align="center">天数</td>
	  <td width="50" align="center">老师</td>
    </tr>
  <%if not rs.eof then%>
   <%do while not rs.eof
   %>   
    <tr>
	  <td width="50" align="center"><%=rs("user_number")%></td>
	  <td width="50" align="center"><%=rs("user_name")%></td>
	  <td width="100" align="center"><%=rs("user_time")%></td>
	  <%
	  yuanying=len(rs("yuanying"))
	  if yuanying>45 then
	     yuanying=left(rs("yuanying"),45)
	  %>
	  <td width="350" align="center"><%=yuanying%>&nbsp;<a href="query_qingjia.asp?id=<%=rs("id")%>">[详情]</a></td> 
	  <%else%> 
	  <td width="350" align="center"><%=rs("yuanying")%></td>
	  <%end if%>
	  <td width="50" align="center"><%=rs("daynumber")%></td>
	  <td width="50" align="center"><%=rs("teacher")%></td>
    </tr>
    <%
	rs.movenext
	loop
	else%>
    <tr>
      <td width="100%" colspan="7">对不起，没有您的请假记录。<font color=red>如与您的实际情况不符，请务必到办公室说明！</fort></td>
    </tr>

  </table><br>说明：系统会跟据你的请假日期自动延长你的学习或生活费。
<%
end if
rs.close
set rs=nothing

%>
</div>
<p><p> <!--#include file="down.asp"-->

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -