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

📄 ne.asp

📁 酒店管理
💻 ASP
字号:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF">
<%list=Trim(request.querystring("list"))
cardid=Trim(request.querystring("cardid"))
set conn=server.createobject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
set rs1=server.createobject("ADODB.Recordset")
conn.open Application("file_jingan1")
sql="select * from f_dingfang where list=" &list
rs.open sql,conn,1,1
sql1="select * from f_client where cardid=" &cardid
rs1.open sql1,conn,1,1
%> 本定单
<%
if trim(rs("cutting"))="是" then response.write "已" else response.write "未" end if
%>
撤消 
<table width="89%" border="0">
  <tr> 
    <td width="24%">标准房</td>
    <td width="26%"><%=rs("room1")%></td>
    <td height="30" width="24%">入住时间</td>
    <td height="30" width="26%"><%=rs("in_time")%></td>
  </tr>
  <tr> 
    <td width="24%">豪华双人房</td>
    <td width="26%"><%=rs("room2")%></td>
    <td width="24%">入住期限</td>
    <td width="26%"><%=rs("in_days")%></td>
  </tr>
  <tr> 
    <td width="24%">豪华标准房</td>
    <td width="26%"><%=rs("room3")%></td>
    <td width="30%">订房时间</td>
    <td width="20%"><%=rs("now_time")%></td>
  </tr>
  <tr> 
    <td width="24%">标准套房</td>
    <td width="26%"><%=rs("room4")%></td>
    <td height="29" width="24%">入住人数</td>
    <td height="29" width="26%"><%=rs("persons")%></td>
  </tr>
  <tr> 
    <td width="24%">豪华行政房</td>
    <td width="26%"><%=rs("room5")%></td>
    <td width="30%">证件号码</td>
    <td width="20%"><%=rs("cardid")%></td>
  </tr>
  <tr> 
    <td height="27" width="30%">豪华大套间</td>
    <td height="27" width="20%"><%=rs("room6")%></td>
    <td width="30%">入住人姓名</td>
    <td width="20%"><%=rs1("name1")%></td>
  </tr>
  <tr> 
    <td height="34" width="24%">付款方式</td>
    <td height="34" width="26%"><%=rs("pays")%></td>
    <td height="29" width="30%">联系电话</td>
    <td height="29" width="20%"><%=rs1("tel")%></td>
  </tr>
  <tr> 
    <td height="24" width="24%">信用卡类别</td>
    <td height="24" width="26%"><%=rs("iden")%></td>
    <td height="34" width="30%">国籍</td>
    <td height="34" width="20%"><%=rs1("nation")%></td>
  </tr>
  <tr> 
    <td height="26" width="24%">信用卡号码</td>
    <td height="26" width="26%"><%=rs("idennub")%></td>
    <td height="24" width="30%">城市</td>
    <td height="24" width="20%"><%=rs1("city")%></td>
  </tr>
  <tr> 
    <td height="25" width="24%">持卡人姓名</td>
    <td height="25" width="26%"><%=rs("idenname")%></td>
    <td height="26" width="30%">证件类型</td>
    <td height="26" width="20%"><%=rs1("leibie")%></td>
  </tr>
  <tr> 
    <td height="27" width="24%">有效期</td>
    <td height="27" width="26%"><%=rs("idendate")%></td>
    <td height="25" width="30%">证件号</td>
    <td height="25" width="20%"><%=rs1("cardid")%></td>
  </tr>
</table>
<%rs.close()
rs1.close()
%>
<form method="post" action="delete1.asp?list=<%=list%>&amp;cardid=<%=cardid%>">
  <input type="submit" name="Submit" value="删除">
</form>
<p>&nbsp;</p>
</body>
</html>

⌨️ 快捷键说明

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