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

📄 viewxf.asp

📁 以前企业建网站
💻 ASP
字号:
<!--#include file="top.asp"-->
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>消费记录</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="style2.css" type="text/css">
</head>
<body topmargin="0">
<div align="center">
	<table border="0" width="780" cellspacing="0" cellpadding="0" id="table1" height="591" bgcolor="#FFFFFF">
		<tr>
			<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>> </td>
			<td valign="top" width="146"><!--#include file="left.asp"--></td>
			<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>> </td>
			<td width="613" valign="top">
			<table border="0" width="613" cellspacing="0" cellpadding="0" height="379">
				<tr>
					<td height="39" width="160">&nbsp;
					<img border="0" src="images/jt.gif" width="14" height="14"> 
					<a href="vip.asp">会员修改资料</a></td>
					<td height="39" width="453">
					<img border="0" src="images/jt.gif" width="14" height="14"> 
					<a href="viewxf.asp">查看消费记录</a></td>
				</tr>
				<tr>
					<td height="100%" width="613" colspan="2" valign="top">
	<%sql="select * from basket where user_name='"&session("user_name")&"' and basket_check=true"
	  rs.open sql,conn,3,3  
       if rs.eof then %> 
       暂时没有购买过任何产品!
             <%else%>
             <div align="center">
             <table border="1" width="95%" cellspacing="0" cellpadding="0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" height="91">
		<tr>
			<td align="center" height="38">订单号</td>
			<td align="center" height="38">订购产品</td>
			<td align="center" height="38">订购数量</td>
			<td align="center" height="38">产品价格</td>
			<td align="center" height="38">订购日期</td>
		</tr>
			<% do while not rs.eof
			   
			%>
			
		<tr>
			<td align="center" height="25"><%=rs("sub_number")%></td>
			<td align="center" height="25"><%=rs("hw_name")%></td>
			<td align="center" height="25"><%=rs("basket_count")%></td>
			<td align="center" height="25"><%=rs("hw_cash")%></td>
			<td align="center" height="25"><%=rs("basket_date")%>
		</td>
		</tr>
		<%rs.movenext
		loop%>
</table>
      </div>
      <%end if%>
			<%rs.close%>

	 </p>
 </td>
				</tr>
			</table>
			</td>
			<td width="1" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color2")%>
<%rs.close%>></td>
		</tr>
		</table>
</div>

</body>

</html>
<!--#include file="copy.asp"-->

⌨️ 快捷键说明

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