3 then
response.write "您的操作权限不够！"
response.end
end if
%>
订单管理页
function winopen(url)
{
window.open(url,"search","toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=yes,width=540,height=380,top=1,left=1");
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
function emailopen(url)
{
window.open(url,"search","toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=yes,width=500,height=350,top=1,left=1");
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
MaxPerPage=20
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim money
money=0
dim typename
typename=""
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
dim sql
dim rs
dim rstype
dim typesql
dim typeid,typename1
if not isEmpty(Replace(request("typeid"), "'", "''")) then
typeid=Replace(request("typeid"), "'", "''")
else
typeid=0
end if
%>
if request("name23")="" and request("date01")="" and request("date02")="" then
sql="select * from buy where baoyue=0 and pay=0 order by id desc"
else if request("name23")"" and request("date01")="" and request("date02")="" then
sql="select * from buy where baoyue=0 and userid like '%"&request("name23")&"%'"
else if request("date01")"" and request("date02")"" then
sql="select * from buy where baoyue=0 and datetime>='"&request("date01")&"' and datetime end if
end if
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write " 还 没 有 任 何 购 买 会 员"
else
totalPut=rs.recordcount
totalPut=rs.recordcount
if currentpage currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,"buyuser01ji.asp"
showContent
showpage totalput,MaxPerPage,"buyuser01ji.asp"
else
if (currentPage-1)*MaxPerPage rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,"buyuser01ji.asp"
showContent
showpage totalput,MaxPerPage,"buyuser01ji.asp"
else
currentPage=1
showpage totalput,MaxPerPage,"buyuser01ji.asp"
showContent
showpage totalput,MaxPerPage,"buyuser01ji.asp"
end if
end if
end if
sub showContent
dim i
i=0
%>
计点会员订单管理
查看全部订单
查看已处理订单
用户名
姓
名
点
数
应收金额
付款方式
代理会员
购买时间
回复会员
处理
操作
¥
元
没有
月日时
回复
response.write"已处理"
end if
end if
%>
response.write"已付款"
end if
end if
%>
if i>=MaxPerPage then exit do
rs.movenext
loop
%>
end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
response.write ""
if CurrentPage response.write "首页 上一页 "
else
response.write "首页 "
response.write "上一页 "
end if
if n-currentpage response.write "下一页 尾页"
else
response.write ""
response.write "下一页 尾页"
end if
response.write " 页次："&CurrentPage&"/"&n&"页 "
response.write " 共"&totalnumber&"个订单 "&maxperpage&"个订单/页 "
response.write " 转到："
response.write " "
end function
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
按用户名查询
用户名：
按日期查询（输入格式：年-月-日）
起始日期：
终止日期：
当前页面金额：
元
删除3天未处理的定单
按日期删除未处理的定单（输入格式：年-月-日）
起始日期：
终止日期：
