📄 ordersave.asp
字号:
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from orderb "
rs.open sqltext,conn,3,3
'添加一条记录到数据库
rs.addnew
rs("c_id")=request.form("hotelid")
rs("userid")=session("user")
rs("roomtype")=request.form("roomid")
rs("jointime")=session("starttime")
rs("leavetime")=session("deptime")
rs("paytype")=request.form("paytype")
rs("roomnum")=request.form("Roomcount")
rs("totalnum")=request.form("roomcount")*request.form("price")
rs("username")=request.form("contactname")
rs("mobiletel")=request.form("Phone")
if request.form("fax")="" then
rs("fax")="无"
else
rs("fax")=request.form("fax")
end if
rs("email")=request.form("email")
rs("affirmtype")=request.form("ConfirmType")
if request.form("info")="" then
rs("explain")="无"
else
rs("explain")=request.form("info")
end if
rs("number")=request.form("personcount")
rs("degree")=request.form("ClientComeFrom")
if request("clientname1")="" then
rs("man1")="无"
else
rs("man1")=request.form("clientname1")
end if
if request("clientname2")="" then
rs("man2")="无"
else
rs("man2")=request.form("clientname2")
end if
if request("clientname3")="" then
rs("man3")="无"
else
rs("man3")=request.form("clientname3")
end if
if request("clientname4")="" then
rs("man4")="无"
else
rs("man4")=request.form("clientname4")
end if
if request("clientname5")="" then
rs("man5")="无"
else
rs("man5")=request.form("clientname5")
end if
if request("clientname6")="" then
rs("man6")="无"
else
rs("man6")=request.form("clientname6")
end if
if request("clientname7")="" then
rs("man7")="无"
else
rs("man7")=request.form("clientname7")
end if
if request("clientname8")="" then
rs("man8")="无"
else
rs("man8")=request.form("clientname8")
end if
if request("ArrivalWay")="" then
rs("cometype")="无"
else
rs("cometype")=request.form("ArrivalWay")
end if
rs("earlytime")=request.form("EarlyArrivalTime")
rs("latetime")=request.form("arrivalTime")
rs.update
set rsorder=server.createobject("adodb.recordset")
sqltext="select * from orderb order by id desc"
rsorder.open sqltext,conn,1,1
%>
<html>
<head>
<title>预定成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../style.css" type="text/css">
</head>
<body text="#000000">
<div align="center">
<center>
<TABLE cellSpacing=1 cellPadding=4 width=445 bgColor=#416327 height="144">
<TBODY>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="10" bgcolor="#1f60a0"></TD></TR>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="32"><font class="medium">
<p align="center"><font color="#FF0000">恭喜</font>,您的预定信息已经成功提交,我们将尽快通过电话或E-mail与您联系。</p>
<p align="center">如果本订单经确认最终成交，您将在成交后的一周内得到<b><font face="Times New Roman" size="3" color="#CF6000">500</font></b>点积分!如果您没有在预订入住日入住,也没有提前通知我们取消或更改,您将被扣除<font size="3" color="#CF6000"><b>250</b></font>积分</p>
</center>
<p align="left"><font color="#0000FF">预定信息如下----</font></font></TD></TR>
<tr>
<TD class=main1 width=419 bgColor=#1f60a0 height=25 align="right" colspan="2">
<p align="left"><font color="#FFFFFF">订单资料</font></TD>
</tr>
<center>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right">
<span class="main1"><font color="#FFFFFF">入住日期:</font></span></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=session("starttime")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right">
<span class="main1"><font color="#FFFFFF">离店日期:</font></span></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=session("deptime")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">订单号：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rsorder("id")%></TD>
</tr>
<tr>
<TD class=main1 width=419 bgColor=#1f60a0 height=25 align="right" colspan="2">
</center>
<p align="left"><font color="#FFFFFF">预定信息</font></TD>
</tr>
<center>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right">
<span class="main1"><font color="#FFFFFF">预定宾馆：</font></span></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=request("hotelname")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right">
<span class="main1"><font color="#FFFFFF">房间类型：</font></span></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=request("roomtype")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">预定间数：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("roomnum")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right">
<span class="main1"><font color="#FFFFFF">支付方式:</font></span></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("paytype")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">总金额：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("totalnum")%></TD>
</tr>
</center>
<center>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="15"></TD></TR>
<TR bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="27">
<p align="center">
<INPUT class=main type=button size=3 value='返回' name=Submit2 onclick="javascript:window.location.href='../default.htm'">
</TD></TR>
<TR bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="4" bgcolor="#1f60a0"></TD></TR></TBODY></TABLE>
</center>
</div>
<p align="center">
</body>
</html>
<%
rs.close
conn.close
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -