www.gusucode.com > 运动用品商城网站系统源代码程序 > caigoudan.asp

    <!--#include file="conn.asp"-->
<!--#include file="IncAsp/venshop_top.asp"-->
<div align="center">
<table cellpadding="0" cellspacing="0" class="all_t1">
<tr><td class="all_l_td" valign="top">
<!--#include file="IncAsp/venshop_log.asp"--><div class="d5"></div>
</td>
<td valign="top" class="all_c_td">
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<tr><td class="sort">&nbsp;<IMG src="Skin/<%=venshop_skin%>/home.gif" border=0 align="absmiddle"> 您的位置： <a href="index.asp">首页</a> >>&nbsp;您登记的缺货商品信息</td></tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" class="useri">
<tr><td height="150">
<%if Request.Cookies("venshop")("user_name")="" then
response.redirect "login.asp?comurl=caigoudan.asp"
response.end
else
user_name=Request.Cookies("venshop")("user_name")
chklogin(user_name)
zt=request("zt")%>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td  class="cartshowa" align="center">商品</td>
<td class="cartshowa">数量</td>
<td class="cartshowa">登记人</td>
<td class="cartshowa">电话</td>
<td class="cartshowa">日期</td>
<td class="cartshowa">处理结果</td></tr>
<%page=request("page")
if page="" then page=1
if not(isnumeric(page)) then page=1
if page<1 then page=1
page=int(page)

if request("order")="" then
odr="id"
else
odr=request("order")
end if
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_gou where username='"&user_name&"' order by "&odr&" DESC"
rs.open sql,conn,1,1
if rs.eof then
    response.write "<tr><td align=center height=150 colspan=6>暂无信息!</td></tr>"
else
rs.pagesize=20
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
i=0
do while not rs.eof and (i<rs.pagesize)
i=i+1
%>
<tr>
<td class="cartshow<%=(i mod 2)%>" align="center"><a href="#" onclick="javascript:window.open('daninfo.asp?id=<%=rs("id")%>','newwindow','toolbar=no,scrollbars=yes,resizable=no,top=0,left=0,width=650,height=600');"><%=rs("hw")%></a></td>
<td class="cartshow<%=(i mod 2)%>"><%=rs("count")%></td>
<td class="cartshow<%=(i mod 2)%>"><%=rs("name")%></td>
<td class="cartshow<%=(i mod 2)%>"><%=rs("tel")%></td>
<td class="cartshow<%=(i mod 2)%>"><%=rs("gdate")%></td>
<td class="cartshow<%=(i mod 2)%>"><%if rs("acheck")=0 then%>尚未处理<%else%><%=rs("are")%><%end if%></td>
</tr>
<%rs.movenext
loop
end if
rs.close
set rs=nothing%><tr><td align="center" colspan="6" height="30" class="sortb">第<%=page%>页/共<%=totalpage%>页&nbsp;&nbsp;
<%if page-1>0 then%><a href="<%=filename%>?page=<%=page-1%>">上一页</a><%else%>上一页<%end if%>&nbsp;&nbsp;
<%if page+1<=totalpage then%><a href="<%=filename%>?page=<%=page+1%>">下一页</a><%else%>下一页 <%end if%></td></tr></table>
<%end if%>
</td></tr></table>
</td></tr></table></div><!--#include file="IncAsp/venshop_copy.asp"-->