www.gusucode.com > 运动用品商城网站系统源代码程序 > feyok/ad_dan.asp
<!--#include file="conn.asp"-->
<!--#include file="ad_chk.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=inc/css.css rel=STYLESHEET type=text/css>
<body topmargin="5" leftmargin="5" rightmargin="5" bottommargin="5">
<%
if Request.Cookies("venshop")("admin_class")<>0 and Request.Cookies("venshop")("admin_class")<>2 then
response.write "你没有这个权限!"
response.end
end if
%>
<table border="0" cellpadding="5" cellspacing="0" class="st">
<tr><td class="sa">商品</td>
<td class="sa">需求数量</td>
<td class="sa">联系人</td>
<td class="sa">电话</td>
<td class="sa">日期</td>
<td class="sa">处理</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)
acheck=request("acheck")
if request("order")="" then
odr="id"
else
odr=request("order")
end if
set rs=server.createobject("adodb.recordset")
sql="select * from venshop_gou where acheck='"&acheck&"' order by "&odr&" DESC"
rs.open sql,conn,1,1
if rs.eof then
response.write "<tr><td align=center height=26 colspan=6 bgcolor=#FFFFFF>暂无信息！</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="s<%=i mod 2%>"><a href="ad_daninfo.asp?id=<%=rs("id")%>"><%=rs("hw")%></a></td>
<td class="s<%=i mod 2%>"><%=rs("count")%></td>
<td class="s<%=i mod 2%>"><%=rs("name")%></td>
<td class="s<%=i mod 2%>"><%=rs("tel")%></td>
<td class="s<%=i mod 2%>"><%=rs("gdate")%></td>
<td class="s<%=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
i=i+1%>
<tr><td align="center" colspan="6" class="s<%=i mod 2%>">第<%=page%>页/共<%=totalpage%>页
<%if page-1>0 then%><a href="<%=filename%>?page=<%=page-1%>&acheck=<%=request("acheck")%>">上一页</a><%else%>上一页<%end if%>
<%if page+1<=totalpage then%><a href="<%=filename%>?page=<%=page+1%>&acheck=<%=request("acheck")%>">下一页</a> <%else%>下一页 <%end if%></td></tr></table>
<br>
<div class="help">
备注：<br>缺货登记指的是网站没有的商品，而客户有这方面需要所提交的登记需求，商家可以根据客户需求进行补货！</div>
<!--#include file="ad_bottom.asp"-->