📄 student_show.asp
字号:
<!--#include file="../global/inc/global.inc.asp"-->
<%
InterId = Request.QueryString("InterId")
on error resume next
oConn_Start
strSql = strSql + "Select C.ClassName,(Select ClassName From Sm_Class Where ClassId=I.ToClassId) as ToClassName,"&_
"(Select BasicName From Sm_BasicParam Where BasicId=I.FlyId) as FlyName,"&_
"(Select BasicName From Sm_BasicParam Where BasicId=I.CompanyId) as CompanyName,"&_
"I.* From Sm_Class c Inner Join Sm_InterFly I on c.ClassId=i.FromClassId Where I.FlyFlag=2 And InterId="&InterId
Set oRs = oConn.Execute(strSql)
if ORs.Eof Then
Response.Write("没有该机票的相关信息")
Response.End()
oConn_Close
End If
FromClassName = oRs("ClassName")
ToClassName = oRs("ToClassName")
FlyName = oRs("FlyName")
CompanyName = oRs("CompanyName")
FromTime = GetFlyTime(oRs("FromTime"))
ToTime = GetFlyTime(oRs("ToTime"))
FlyPrice = oRs("FlyPrice")
FlyDoublePrice = oRs("FlyDoublePrice")
FlyNo = oRs("FlyNo")
FlyType = oRs("FlyType")
FlyWeekNo = oRs("FlyWeekNo")
FlyMemo = ReplaceContent(oRs("FlyMemo"))
oRs.Close
Set oRs = Nothing
oConn_Close
%>
<!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>学生机票-上海神马航空特价打折飞国际机票票价查询票务中心021-51099919</title>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="../include/top.asp"-->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="orgborder"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><table width="100%" cellpadding="5" cellspacing="0">
<tr>
<td width="13%">航程:</td>
<td width="87%"><%=FromClassName%>－<%=ToClassName%> </td>
</tr>
<tr bgcolor="f7f7f7">
<td>始发地:</td>
<td><%=FromClassName%> </td>
</tr>
<tr>
<td>目的地:</td>
<td><%=ToClassName%> </td>
</tr>
<tr bgcolor="f7f7f7">
<td>航空公司: </td>
<td><%=CompanyName%> </td>
</tr>
<tr>
<td>出发时间 : </td>
<td><%=FromTime%> </td>
</tr>
<tr bgcolor="f7f7f7">
<td>到达时间:</td>
<td><%=ToTime%> </td>
</tr>
<tr>
<td>单程:</td>
<td><%=FlyPrice%> </td>
</tr>
<tr bgcolor="f7f7f7">
<td>往返: </td>
<td><%=FlyDoublePrice%> </td>
</tr>
<tr>
<td>备注: </td>
<td><%=FlyMemo%> </td>
</tr>
<tr>
<td> </td>
<td><a href="studentorder1.asp?InterId=<%=InterId%>"><img src="../images/but_order.gif" width="65" height="22" border="0"></a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"> </td>
</tr>
</table>
<div align=center>
<!--#include file="../include/bottom.asp"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -