📄 trnview.asp
字号:
<!--#include file="../../conndb.asp"-->
<html>
<head>
<title>查看培训信息</title>
<link rel="stylesheet" href="../../style.css">
</head>
<%
Dim Id,Subject,tTypeId,sTypeId,CreateDate,Detail,Status,Place,Teacher,sTypeName
Dim StartDate,EndDate,SignSDate,SignEDate,Attendant,Cost
Dim File1,FileName1,File2,FileName2,AttList
Dim Action,rs
'读取参数tid
Id = Request.QueryString("tid")
Set rs = Server.CreateObject("ADODB.RecordSet")
'设置SELECT语句，读取记录数据
sql = "SELECT t.*,s.TypeName FROM Training t,Types s WHERE t.sTypeId=s.TypeId And t.Id=" & Id
rs.Open sql,conn,1,3
If Not rs.EOF Then
Subject = rs("Subject")
tTypeId = rs("tTypeId")
sTypeName = rs("TypeName")
CreateDate = rs("CreateDate")
Detail = rs("Detail")
Status = rs("Status")
Place = rs("Place")
Teacher = rs("Teacher")
StartDate = rs("StartDate")
EndDate = rs("EndDate")
SignSDate = rs("SignSDate")
SignEDate = rs("SignEDate")
Attendant = rs("Attendant")
Cost = rs("Cost")
File1 = rs("File1")
FileName1 = rs("FileName1")
File2 = rs("File2")
FileName2 = rs("FileName2")
End If
rs.Close()
%>
<body leftmargin="1" topmargin="0">
<form name="form1" method="POST">
<table align="center" border="1" cellspacing="0" width="99%" bordercolor="#64B9E1" bordercolorlight="#64B9E1" bordercolordark="#FFFFFF">
<tr>
<td bgcolor="#FFFFFF" colspan="4" background="../pic/training.jpg" height="80" width="100%">
<p align="center"><b><font face="华文彩云" color="#000080" size="6">培训信息</font></b></p>
</td>
</tr>
<tr>
<td bgcolor="#CEE7FF">培训主题</td>
<td colspan="3"><%=Subject%></td>
</tr>
<tr>
<td bgcolor="#CEE7FF">培训类型</td>
<td><%If tTypeId=0 Then%>内部培训<%Else%>外部培训<%End If%></td>
<td bgcolor="#CEE7FF">课程类别</td>
<td><%=sTypeName%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF" >培训地点</td>
<td colspan="3"><%=Place%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">培训教师</td>
<td><%=Teacher%> </td>
<td bgcolor="#CEE7FF" >培训费用</td>
<td><%=Cost%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">培训开始日期</td>
<td><%=StartDate%> </td>
<td bgcolor="#CEE7FF">培训结束日期</td>
<td><%=EndDate%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">报名开始日期</td>
<td><%=SignSDate%> </td>
<td bgcolor="#CEE7FF">报名结束日期</td>
<td><%=SignEDate%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF" >参加人员</td>
<td colspan="3"><%=Attendant%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF" >描述</td>
<td colspan="3"><%=Detail%> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">附件1</td>
<td colspan="3"><a href="files/<%=File1%>" target="_blank"><%=FileName1%></a> </td>
</tr>
<tr>
<td bgcolor="#CEE7FF">附件2</td>
<td colspan="3"><a href="files/<%=File2%>" target="_blank"><%=FileName2%></a> </td>
</tr>
</table>
<br><center>创建日期:<%=CreateDate%></center>
<p align=center><input type="button" value=" 关 闭 " name="B1" Onclick="JavaScript:window.close();"></p>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -