📄 member_query.asp
字号:
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</form>
</table>
<tr>
<td height="32" valign="middle" bgcolor="#f1f1f1" width="162"><img src="../../Images/userlogin1.gif" width="158" height="22"></td>
<td width="1"></td>
</tr>
<tr>
<td valign="top" height="278">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#f1f1f1">
<form name="loginform" method="post" action="../login.asp">
<tr>
<td height="9" width="49"></td>
<td width="46"></td>
<td width="64"></td>
</tr>
<tr>
<td valign="middle" height="25" align="center"><font size="2" color="#000000">用
户:</font></td>
<td colspan="2" valign="middle" align="center">
<input type="text" name="username" size="10" maxlength="10">
</td>
</tr>
<tr>
<td height="25" valign="middle" align="center"><font size="2" color="#000000">密
码:</font></td>
<td colspan="2" valign="middle" align="center">
<input type="password" name="password" size="10" maxlength="10">
</td>
</tr>
<tr>
<td height="29"></td>
<td valign="middle" align="center">
<input style=" BACKGROUND-COLOR: #e6f4ff;
BORDER-BOTTOM: #0099ff 1px solid;
BORDER-LEFT: #0099ff 1px solid;
BORDER-RIGHT: #0099ff 1px solid;
BORDER-TOP: #0099ff 1px solid;
COLOR: #336699;
HEIGHT: 18px;
width:30px:
TEXT-ALIGN: center" name="Submit" value="登录" class="botton" onclick="return check()" type="submit">
</td>
<td valign="middle"><img src="../../Images/zhuce.gif" width="39" height="17" usemap="#Map5" border="0"></td>
</tr>
<tr>
<td height="190"></td>
<td></td>
<td></td>
</tr>
</form>
</table>
</td>
<td></td>
</tr>
</table>
</td>
<td width="575" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#d9e7eb">
<tr>
<td width="5" valign="top" rowspan="2">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#cacaca">
<tr>
<td width="5" height="463"></td>
</tr>
</table>
</td>
<td height="463">
<td width="570" rowspan="3" valign="top">
<table width="548" border="0" cellpadding="0" cellspacing="0" height="425" bgcolor="#d9e7eb">
<tr>
<td valign="top" width="352" height="146" align="center" bgcolor="#d9e7eb">
<p align="left"><font size="1"><b><font size="3" color="#000000">会员积分奖励计划</font></b></font><font color="#000000" size="3">： </font></p>
</td>
<td valign="top" colspan="3" bgcolor="#d9e7eb">
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" bgcolor="#92C9C9" height="20">*<font size="2">投诉电话</font>*</td>
</tr>
</table>
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="7" width="25%" align="center"><font size=2 color="#000000">Tel</font></td>
<td height="7" width="25%"><font size=2><font color="#000000">024-23490656</font></font></td>
</tr>
<tr bgcolor="#326B94">
<td height="7" width="25%" align="center" bgcolor="#fff1dd"><font size=2>Email</font></td>
<td height="7" width="25%" bgcolor="#fff1dd"><font size=2 ></font></td>
</tr>
</table>
</tr>
<tr>
<td height="16" colspan="2" valign="top" align="center">
<p align="left"><b>会员积分显示</b><b>:</b>
</td>
<td width="6"></td>
<td width="4"></td>
</tr>
<tr>
<td height="41" colspan="2" valign="top" align="center" bgcolor="#d9e7eb">
<table border="0" width="100%" bgcolor="#FFFFFF">
<tr>
<td width="132" align="center" bgcolor="#d9e7eb" height="15"><font size="2">卡号</font> </td>
<td width="133" align="center" bgcolor="#d9e7eb"><font size="2">姓名</font></td>
<td width="133" align="center" bgcolor="#d9e7eb"><font size="2">当前积分</font></td>
<td width="132" align="center" bgcolor="#d9e7eb"><font size="2">优惠政策</font></td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
strsql="select 会员卡号,姓名,积分 from xt_td_User where 会员卡号='" & Session("UID") & "'"
set rs=conn.execute(strsql)
%>
<tr>
<td height="20" bgcolor="#d9e7eb" valign="middle" align="center"><font size=2><%=rs(0)%></font></td>
<td bgcolor="#d9e7eb" valign="middle" align="center"><font size=2><%=rs(1)%></font></td>
<td bgcolor="#d9e7eb" align="center" valign="middle"><font size=2><%=rs(2)%></font></td>
<td bgcolor="#d9e7eb"> </td>
</tr>
</table>
</td>
<td></td>
<td></td>
</tr>
<tr>
<td height="18"></td>
<td width="190"></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="168" colspan="3" valign="top">
<table width="548" border="0" cellpadding="0" cellspacing="0" bgcolor="#d9e7eb">
<tr>
<td valign="top" height="5" colspan="3" width="310"><b>历史记录</b>：</td>
<td valign="top" height="5" width="234" colspan="4"></td>
</tr>
<tr>
<td width="71" valign="middle" align="center" bgcolor="#ffcc00">
<p align="center"><font color="#FFFFFF" size="2">入住日期</font></p>
</td>
<td valign="middle" width="134" align="center" bgcolor="#ffcc00">
<p align="center"><font size="2" color="#FFFFFF">酒店名称</font></p>
</td>
<td valign="middle" width="101" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">房型</font></td>
<td valign="middle" width="53" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">会员价</font></td>
<td valign="middle" width="56" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">入住状态</font></td>
<td valign="middle" width="63" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">获得积分</font></td>
<td valign="middle" width="62" align="center" bgcolor="#ffcc00"><font size="2" color="#FFFFFF">取消预订</font></td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sqlrs="select a.入住时间,酒店名_cn,房型_cn,会员价,iif(入住,'是','否'),入住加分,订单编码 from xt_td_bookup a,xt_td_hotel b,xt_td_room c"
sqlrs=sqlrs & " where a.卡号='" & Session("UID") & "' and a.酒店编码=b.酒店编码 and b.酒店编码=c.酒店编码 and a.房型序号=c.房型序号"
sqlrs=sqlrs & " order by 订单编码 desc"
%>
<!-- #include file="../../Include/AdoDBOpen.asp" -->
<%
do while (not rs.eof) and rowcount>0
if (rowcount mod 2)=0 then
%>
<tr>
<%else%>
<tr bgcolor="#fff1dd">
<%end if%>
<td height="20" valign="middle" width="71" ><font size="2"><%=rs(0)%></font></td>
<td valign="middle" align="center" width="134"><font size=2 color="#326A94"><%=rs(1)%></font></td>
<td valign="middle" align="center" width="101"><font size="2"><%=rs(2)%></font></td>
<td valign="middle" align="center" width="53" ><font size="2"><%=rs(3)%></font></td>
<td valign="middle" align="center" width="56" ><font size="2"><%=rs(4)%></font></td>
<td valign="middle" align="center" width="63" ><font size="2"><%=rs(5)%></font></td>
<td valign="middle" align="center" width="62" >
<%if rs(4)="否" then %>
<a href="javascript:del(<%=rs(6)%>)"><img src="../../Images/del1.gif" width="19" height="17" border="0"></a>
<%End if%>
</td>
</tr>
<%
rs.movenext '纪录指针下移
rowcount=rowcount-1
loop
%>
<tr>
<td height="20" colspan="7" valign="top" width="546"> </td>
</tr>
<tr>
<td height="20" colspan="7" valign="top" align="right" bgcolor="#ffcc00" width="546">
<%sLinkFile="member_query.asp?query="
sBookMark="ddd"%>
<!-- #include file="../../Include/pageend.asp" -->
</td>
</tr>
</table>
</td>
<td></td>
</tr>
<tr>
<td height="71"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="2"></td>
</tr>
<tr>
<td height="8"></td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<map name="Map2">
<area shape="rect" coords="7,-1,53,21" href="../User/user_login.asp">
</map>
<map name="Map3">
<area shape="rect" coords="0,-1,52,23" href="#">
</map>
<map name="Map4">
<area shape="rect" coords="-4,1,32,20" href="../../korea/index.asp">
</map>
<map name="Map5">
<area shape="rect" coords="1,0,44,15" href="../User/user_login.asp">
</map>
</body>
</html>
<script language=javascript>
function open1(code,code1)
{
window.open("cityview_detail.asp?code="+code+"&code1="+code1,"城市风景详细","height=300,width=340,toolbar=no,menubar=no,scrollbars=yes,resizable=no,status=no,location=no")
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -