📄 showalljingjia.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="webconfig.asp"-->
<html>
<head>
<title><%=webname%>--商品销售情况</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="770" height="38" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" class="table-zuoyou">
<tr>
<td width="100%" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<table width=100% align=center class=table-shang border=0 cellpadding=0 cellspacing=0 bgcolor=#f1f1f1>
<TR>
<TD bgColor=#ffffff colSpan=8 height=1></TD>
<tr>
<td align=center width=14% height=30><div align="center"><font color="#0099CC">购买人</font></div></td>
<td align=center width=16% height=30><div align="center"><font color="#0099CC">购买价格</font></div></td>
<td align=center width=10% height=30><div align="center"><font color="#0099CC">库存数量</font></div></td>
<td width=13% align=center><div align="center"></div>
<div align="center"><font color="#0099CC">购买数量</font></div></td>
<td align=center width=17%><div align="center"><font color="#0099CC">购买结果</font></div></td>
<td align=center width=17%><font color="#0099CC">定单号</font></td>
<%
dim username,jianame
username=request.cookies("days6")("username")
jianame=rs_jia("username")%>
<td align=center width=13%><font color="#0099CC">购买处理</font></td>
</tr>
<TR>
<TD bgColor=#cccccc colSpan=8 height=1></TD>
</TR>
<TR>
<TD bgColor=#f1f1f1 colSpan=8 height=3></TD>
</TR>
</table>
<%set rs_jia=server.createobject("adodb.recordset")
rs_jia.open "select * from [bookjia] where bookid="&request("id")&" order by jiage desc",conn,1,1
do while not rs_jia.eof
%>
<table width="100%" height="11" border="0" align="center" cellpadding="2" cellspacing="0" class="table-xia">
<tr>
<td width="14%" height="11" rowspan="3" align="center" class="table-you">
<%set rs_user=server.createobject("adodb.recordset")
rs_user.open "select userzhenshiname,username from [user] where userid="&rs_jia("userid"),conn,1,1
%> <%=rs_user("userzhenshiname")%> </td>
<td width="16%"> <div align="center">
<%
response.write trim(rs_jia("jiage"))
%>
<%
set rs_books=server.createobject("adodb.recordset")
rs_books.open "select kucun,bookchuban,name,bookname,bookid from [shop_books] where bookid="&request("id"),conn,1,1
%>
<font color="#0099CC">元/<%=rs_books("bookchuban")%></font></div></td>
<td width="10%" rowspan="3" class="table-zuo"> <div align="center"><%=rs_books("kucun")%><%=rs_books("bookchuban")%></div></td>
<td width="13%" rowspan="3" class="table-zuo"><div align="center"> </div>
<div align="center"><%=rs_jia("shuliang")%><%=rs_books("bookchuban")%></div></td>
<td width="17%" rowspan="3" class="table-zuo"> <div align="center">
<% if rs_jia("deal")<>1 then%>
请等待卖家处理
<%else%>
<font color="#0033FF">[此价可以交易<%=rs_jia("dealshuliang")%><%=rs_books("bookchuban")%>]</font>
<%end if%>
</div></td>
<td width="17%" rowspan="3" class="table-zuo"><div align="center">
<%
if rs_jia("deal")<>1 then%>
还没有定单
<%else%>
<a href="#" ONCLICK="window.open('xiaosdingdan.asp?id=<%=rs_jia("id")%>&order=<%=rs_jia("order")%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=800,height=570')"><%=rs_jia("order")%></a>
<%end if%>
</div></td>
<td width="13%" rowspan="3" class="table-zuo"><div align="center">
<%if rs_jia("username")=request.cookies("days6")("username") and DateDiff("s",now(),closedate)>=1 then%>
<a href="del_jingjia.asp?id=<%=rs_jia("id")%>" >删除</a>
<%elseif rs_books("name")=request.cookies("days6")("userzhenshiname") and DateDiff("s",closedate,now())>=1 then%>
<a href="answerjingjia.asp?id=<%=rs_jia("id")%>" >联系交易</a>
<%else%>
购买中
<%end if%>
</div></td>
</tr>
</table>
<% x=x+1
if x>=rs_books("kucun") then exit do
rs_jia.movenext
loop
%>
</td>
<td height="15"></tr>
</table>
<table width="770" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<%if rs_jia.recordcount>=1 then%>
<tr>
<td width="476"><div align="right"><font color="#0099CC">此商品已购买<%=rs_jia.recordcount%>次</font></div></td>
<td width="124"> </td>
</tr><%else%><tr>
<td width="476"><div align="left"><font color="#0099CC"> 暂无购买记录！</font></div></td>
<td width="124"> </td>
</tr><%end if%>
</table>
<%rs_jia.close
set rsjia=nothing%>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td><div align="center"><font color="#0099CC">【关闭窗口】</font></div></td>
<td> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -