guoji_show.asp

航空订票系统基于asp.net和sql2005包含数据库和图片

<!--#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=1 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

%>

<%=GetWebTop(3)%>
<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>&nbsp;</td>
                    <td><a href="order1.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">&nbsp;</td>
  </tr>
</table>
<%=GetWebBottom()%>
</body>
</html>