⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 bookview.asp

📁 ASP+SQL Server网络应用系统开发与实例
💻 ASP
字号:
<!--#include file="../conndb.asp"-->
<!--#include file="isAdmin.asp"-->
<html>
<head>
<title>旅游在线报名</title>
<link href=../style.css rel=STYLESHEET type=text/css>
</head>
<%
  Dim Bid
  Bid = Request.QueryString("bid")
  Set Rs = Server.CreateObject("ADODB.RecordSet")
  sql = "SELECT b.*, l.LineName FROM Book b, Line l WHERE BookId=" & Bid & " And b.LineId=l.LineId"
  Rs.Open sql,Conn,1,3
%>
<body topmargin="0" leftmargin="0">
<form name="form1" method="post" action="BookSave.asp?lid=<%=LineId%>">
<p align="center"><img src="../pic/BookLine.gif" border=0 height="100"></p>
<table border="1" cellspacing="0" width="580" align=center bordercolor="#FFFFFF" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0">
  <tr>
    <td width="12%" bgcolor="#CAD8EE">状态</td>
    <td width="88%"><%If Rs("Flag") Then%><font color=blue size=3><b>已处理
    <%Else%><font color=red size=3><b>未处理<%End If%></b></font></td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">线路名称</td>
    <td width="88%"><font color=red size=3><b><%=Rs("LineName")%></b></font></td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">人数</td>
    <td width="88%"><%=Rs("TraNum")%></td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">出游日期</td>
    <td width="88%"><%=Rs("StartDate")%></td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">姓名</td>
    <td width="88%"><%=Rs("BookPerson")%></td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">E-mail</td>
    <td width="88%"><%=Rs("Email")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">单位</td>
    <td width="88%"><%=Rs("WorkPlace")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">地址</td>
    <td width="88%"><%=Rs("Address")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">邮政编码</td>
    <td width="88%"><%=Rs("Zip")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">电话</td>
    <td width="88%"><%=Rs("Telephone")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">移动电话</td>
    <td width="88%"><%=Rs("Mobile")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">传真</td>
    <td width="88%"><%=Rs("Fax")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">身份证号</td>
    <td width="88%"><%=Rs("IDCard")%>&nbsp;</td>
  </tr>
  <tr>
    <td width="12%" bgcolor="#CAD8EE">留言</td>
    <td width="88%"><%=Rs("Comment")%>&nbsp;</td>
  </tr>
</table>
<p align="center"><a href="javascript:window.close()">[关 闭]</a></p>
</form>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -