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

📄 book.asp

📁 ASP程序实现的酒店预定系统
💻 ASP
字号:
<!--#include file="../../Include/adoconn.asp"-->
<%
if session("UID")="" then response.redirect "error.asp"
if request("room_type_id") ="" then  response.redirect "error.asp"

sqlrs="Insert Into xt_td_bookup (卡号,酒店编码,房型序号,房间数量,入住时间,离开时间,特殊要求,入住人名称,入店时间) Values (" 
sqlrs=sqlrs & "'" & session("UID") & "'," 
sqlrs=sqlrs & "'" & session("hotel_id") & "'," 
sqlrs=sqlrs & "'" & request("room_type_id") & "'," 
sqlrs=sqlrs & request("txtQuantity") & "," 
sqlrs=sqlrs & "#" & request("txtInDate") & "#," 
sqlrs=sqlrs & "#" & request("txtOutDate") & "#," 
sqlrs=sqlrs & "'" & request("txtSpec") & "',"
sqlrs=sqlrs & "'" & request("txtname") & "',"
sqlrs=sqlrs & "#" & request("txttime") & "#)" 

conn.execute sqlrs 
set rs=conn.execute("select top 1 订单编码 From xt_td_bookup order by 订单编码 desc")
sNum=rs(0)

set rs=conn.execute("select 姓名 From xt_td_user where 会员卡号='" & session("UID") & "'")
sName=rs(0)

set rs=conn.execute("select 房型_cn From xt_td_room where 房型序号='" & request("room_type_id") & "' and 酒店编码='" & request("hotel_id") & "'" )
sRoom=rs(0)


%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>预定酒店信息</title>
</head>

<body bgcolor="#D9E7EB">
<center>
          <table cellSpacing="0" cellPadding="0" width="368" border="0">  
		  	<form name="formbook" type="submit" action="hotel_intr.asp">                   
              <tr>                     
                <td class="bk" width="366">
                  <p align="center"><font color="#00567b" size="2"><b>房间预订成功!</b></font></p>
                </td>                     
              </tr>                     
              <tr bgColor="#d9e7eb">                     
                <td class="bk" align="middle" height="30" width="366">                     
                  <table cellSpacing="1" width="100%" border="2" bordercolorlight="#00567B" bordercolordark="#D9E7EB" bgcolor="#99CCFF">                     
                    <tbody>                     
                      <tr> 
                        <td width="10%">定单编号:</td>                           
                        <td width="30%"><%=sNum%></td>                           
                      </tr> 
                      <tr> 
                        <td width="10%">卡号:</td>                           
                        <td width="30%"><%=Session("UID")%></td>                           
                      </tr> 
                      <tr> 
                        <td width="10%">姓名:</td>                           
                        <td width="30%"><%=sName%> </td>                           
                      </tr> 
                      <tr> 
                        <td width="10%">预定房型:</td>                           
                        <td width="30%"><%=sRoom%> </td>                           
                      </tr> 
                      <tr height="25">                     
                        <td width="10%">预定数量:</td>                           
                        <td width="30%"><%=request("txtQuantity")%> </td>                           
                      </tr>                           
                      <tr height="25">                     
                        <td width="10%">入住日期:</td>                                            
                        <td width="30%"><%=request("txtInDate")%></td>                                            
                      </tr>                                            
                      <tr height="25">                                      
                        <td width="10%">离开日期:</td>                                            
                        <td width="30%"><%=request("txtOutDate")%></td>                                            
                      </tr>   
					   <tr height="25">                                      
                        <td width="10%">入住人名称:</td>                                            
                        <td width="30%"><%=request("txtname")%></td>                                            
                      </tr> 
					   <tr height="25">                                      
                        <td width="10%">入店时间:</td>                                            
                        <td width="30%"><%=request("txttime")%></td>                                            
                      </tr>                                          
              <tr>                                            
                <td width="10%">其他要求:</td>                                           
                <td><%=trim(request("txtSpec"))%></td>                                           
              </tr>                                           
              <tr>                                            
                
          <td colspan="2"> 
            <p align="center"> &nbsp;&nbsp;&nbsp; 
              <input type="button" value="确定" name="B1" class="botton" onclick="window.close(-1)">
              <input type="submit" name="Submit" value="修改">
            </p>  
                </td>                                             
              </tr>                                             
                    </tbody> 
					                                            
                  </table>                                              
                </td>                                              
              </tr> 
			   </form>                                            
          </table>                                             
   </center>      
</body>         
         
</html>         

⌨️ 快捷键说明

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