📄 orders.asp
字号:
<!--#include file="../manager/function/conn.asp"-->
<!--#include file="../../config.asp"-->
<!--#include file="../safe_mem.asp"-->
<%
'on error resume next
dim myTotalMoney,myOrderStr
myTotalMoney=0
mem_id=trim(request.cookies("mem_login"))
oRderStatus=request("oRderStatus")
set rs=server.CreateObject("adodb.recordset")
sql="select * from tmember where mem_loginname ='"&mem_id&"'"
rs.open sql,conn,3,1
if rs.eof or rs.bof then
'response.Redirect "../register/login_windows.asp"
%>
<script language="javascript">
window.alert("超时或非法进入！请登陆再进！");
window.top.location="../register/login.asp";
</script>
<%
else
mem_name=rs("mem_name")
mem_sex=rs("mem_sex")
mem_money=rs("mem_money")
if mem_sex="F" THEN
mem_call="女士"
else
mem_call="先生"
END IF
end if
rs.close
%>
<%
If Request.QueryString("Page") = "" or Request.QueryString("Page") = 0 then
Page = 1
Else
Page = CINT(Request.QueryString("Page"))
End If
maxCount=12
set rss=Server.CreateObject("AdoDb.recordset")
'sql2="SELECT DISTINCT a.city_to,a.OrderFm_ID,a.city_from,a.TotalPrice,b.FlightSchedule,a.oddatetime,a.OrderState FROM INetOrderForm a LEFT OUTER JOIN INetOrderRecorder b ON a.OrderFm_ID = b.OrderFm_ID where a.userid = '"&mem_id&"' and a.OrderState<>4"
if oRderStatus="" then
sql2="select distinct a.[接收时间],a.[网上订单状态],a.[订单编号],a.[网上结算金额],a.[网上扣款标志],a.[支付方式],b.[航班号],b.[TakeOffTime],b.[FromCityCode],b.[客票类型],b.[ToCityCode] from ticket_m as a left join ticket_d b on a.[订单编号]=b.[订单编号] where a.[客户编号]='"&mem_id&"' and b.id = (select top 1 id from ticket_d where a.[网上订单状态]<>'5' and [订单编号]=a.[订单编号]) order by a.[订单编号] desc"
else
sql2="select distinct a.[接收时间],a.[网上订单状态],a.[订单编号],a.[网上结算金额],a.[网上扣款标志],a.[支付方式],b.[航班号],b.[TakeOffTime],b.[FromCityCode],b.[客票类型],b.[ToCityCode] from ticket_m as a left join ticket_d b on a.[订单编号]=b.[订单编号] where a.[客户编号]='"&mem_id&"' and b.id = (select top 1 id from ticket_d where a.[网上订单状态]='"&oRderStatus&"' and [订单编号]=a.[订单编号]) order by a.[订单编号] desc"
end if
rss.open sql2,conn,3,1
if not(rss.bof or rss.eof) then
rss.pageSize=maxCount
maxPageCount=rss.pageCount
rss.AbsolutePage=page
if page>maxPageCount then page=maxPageCount
end if
%>
<%
set rsj=Server.CreateObject("AdoDb.recordset")
if oRderStatus="" then
sqlj="select * from prize where username = '"&mem_id&"' and OrderState<>5"
else
sqlj="select * from prize where username = '"&mem_id&"' and OrderState="&oRderStatus&""
end if
rsj.open sqlj,conn,1,1
%>
<html>
<HEAD>
<TITLE><%=ZXLCompanyStr&"-- 我的行程"%></TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<LINK href="../smallPic/newdef.css" rel=stylesheet>
<link href="RLimages/user.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="../../system_manage/style/comm.css" />
<link rel="stylesheet" type="text/css" href="../../system_manage/style/skin0.css" />
<script language="javascript">
function openOrderMailList(forderid,uid){//打开电子票邮件订单
//window.showModalDialog('orderMailList.asp?forderid='+forderid,'','');
window.open('orderMailList.asp?forderid='+forderid +"&uid="+uid,'','width=450,height=450,resizable=yes,scrollbars');
//<a href='orderMailList.asp?forderid="++"&uid="++"'></a>
}
</script>
<script language=javascript>
function goUrl()
{
var iPage;
iPage=txtPage.value;
if(isNaN(iPage))
{
iPage=1;
}
var theUrl;
theUrl="orders.asp?page=<%=Page%>";
/*if(theUrl=="default.asp?page=")
{
theUrl="gljp_01.asp?oRderStatus=<%=oRderStatus%>&SearchFiled=<%=SearchFiled%>&SearchKey=<%=SearchKey%>&page=1";
}*/
//alert(theUrl)
window.location.href=theUrl;
}
function SureDel(id1,id2)
{
var aurl
aurl="/trip/myAacount_xingcheng.asp?uid=";
aurl+=id2;
aurl+="&myid=";
aurl+=id1;
if ( confirm("您确定要取消该行程吗？"))
{
//alert(aurl)
window.location.href = aurl;
}
}
function SureDelH(id1,id2)
{
var aurl
aurl="/trip/myAacount_xingcheng.asp?uid=";
aurl+=id2;
aurl+="&myid=";
aurl+=id1;
if ( confirm("您确定要取消该行程吗？"))
{
//alert(aurl)
window.location.href = aurl;
}
}
function openwin(page,size){
window.open(page,"newuser","toolbar=no,location=no,directories=no,status=no,scrollbars=yes,menubar=no,resizable=yes,"+size);
}
</script>
<style type="text/css">
<!--
-->
.un {
font-size: 13px;
font-style: normal;
line-height: 20px;
color: #FFFFFF;
text-decoration: none;
font-weight: bold;
}
.unnamed1 {font-size: 13px;
font-style: normal;
line-height: 20px;
color: #000000;
text-decoration: none;
}
</style>
</HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 >
<!-- onload="getpop(7)" -->
<table width="580" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="588" height=88 valign="top" bgcolor="#FFFFFF">
<table width="580" border="0" cellspacing="3" cellpadding="5">
<tr>
<td width="331" valign="bottom" ><div class="pageHeading"><b>我的行程 </b></div></td>
<td width="220" align="right">
</td>
</tr>
</table>
<table width="100%" height="31" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="24" align="center" valign="middle" class="anniu"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="2">
<tr>
<td class="unnamed1">你好，<%=mem_name%>，欢迎登陆“用户中心” 以下是您的机票订单情况：</td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td width="78" align="center" bgcolor="#709DDE" class="un"><div align="center">订单号</div></td>
<td width="120" align="center" bgcolor="#709DDE" class="un"><div align="center">行程</div></td>
<td width="93" align="center" bgcolor="#709DDE" class="un"><div align="center">预订日期</div></td>
<td width="76" align="center" bgcolor="#709DDE" class="un"><div align="center">支付状态</div></td>
<td width="74" align="center" bgcolor="#709DDE" class="un"><div align="center">订单状态</div></td>
<!--<td width="8%" align="center" bgcolor="#709DDE" class="un"><div align="center">改期</div></td>
<td width="8%" align="center" bgcolor="#709DDE" class="un"><div align="center">退票</div></td>-->
<td width="63" align="center" bgcolor="#709DDE" class="un"><div align="center">支付方式</div></td>
<td width="51" align="center" bgcolor="#709DDE" class="un">总额</td>
</tr>
<!-- -->
<%if rss.eof and rss.bof then%>
<tr bgcolor="#eff3f7">
<td align="center" colspan="8"><div align="center">您暂时没有预订记录</div></td></tr>
<%else
redim payArr(5),payStauts(4),OrderTypeName(6)
payArr(1)="票到付款"
payArr(2)="网上支付"
payArr(3)="电话银行"
payArr(4)="银行汇款"
payStauts(1)="未支付"
payStauts(2)="已支付"
payStauts(3)="未支付"
OrderTypeName(1)="收到的订单"
OrderTypeName(2)="订单已确定"
OrderTypeName(3)="订单已生效"
OrderTypeName(4)="订单已成交"
OrderTypeName(5)="订单已取消"
i=1
%>
<%do while not rss.eof
payStatusNum=rss("网上扣款标志")
if isnull(payStatusNum) or payStatusNum="" then payStatusNum=1
payStatusShow=payStauts(payStatusNum)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -