订单管理
<% flag="尚未处理" set rs=server.createobject("adodb.recordset") sqltext="select * from OrderList order by OrderTime desc" rs.open sqltext,conn,1,1 dim MaxPerPage MaxPerPage=20 '取得页数,并判断用户输入的是否数字类型的数据,如不是将以第一页显示 dim text,checkpage text="0123456789" Rs.PageSize=MaxPerPage for i=1 to len(request("page")) checkpage=instr(1,text,mid(request("page"),i,1)) if checkpage=0 then exit for end if next If checkpage<>0 then If NOT IsEmpty(request("page")) Then CurrentPage=Cint(request("page")) If CurrentPage < 1 Then CurrentPage = 1 If CurrentPage > Rs.PageCount Then CurrentPage = Rs.PageCount Else CurrentPage= 1 End If If not Rs.eof Then Rs.AbsolutePage = CurrentPage end if Else CurrentPage=1 End if call list '显示帖子的子程序 Sub list()%> <% if not rs.eof then i=0 do while not rs.eof %> <% i=i+1 if i >= MaxPerpage then exit do rs.movenext loop end if %>
订单编号
客户姓名
联系电话
处理情况
订单详情
操作
<%=rs("OrderNum")%>
<%=rs("UserId")%>
<%=rs("RecPhone")%>
<%If rs("Flag")="尚未处理" Then%> 尚未处理 <%else%> 已经发货 <%End If%>
<%response.write "详细资料"%>
<%response.write "删除" %>
   <% Response.write "-> 全部-" Response.write "共" & "" & Cstr(Rs.RecordCount) & "" & "件商品          " Response.write "" & "" & Cstr(CurrentPage) & "" & "/" & Cstr(rs.pagecount) & " " If currentpage > 1 Then response.write "首页 " Response.write "上一页 " Else Response.write "上一页 " End if If currentpage < Rs.PageCount Then Response.write "下一页 " Response.write "尾页  " Else Response.write "" Response.write "下一页  " End if 'response.write "" 'response.write "转到: " 'response.write "  " %>
<% End sub rs.close conn.close %>