📄 shopcart_admin.asp
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=true
Response.Expires=0
if Session("userqx")>="1" and Session("userqx")<="9" then
else
Response.Redirect "warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
pageno=Request.QueryString("pageno")
ordername=Request.QueryString("ordername")
byasc=Request.QueryString("byasc")
dept=Request.QueryString("dept")
set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")
set rs2=server.CreateObject("ADODB.Recordset")
tablename="shopcart"
if sortby="" then sortby="desc" else sortby="asc"
if ordername="" then ordername="keyno"
if byasc="" then byasc=sortby
ordertxt=" order by "+ordername+" "+byasc
htmltitle="购物车管理"
htmlname="shopcart_admin.asp?dept="+dept+"&ordername="+ordername+"&byasc="+byasc
htmlname2="shopcart_admin.asp?dept="+dept
addhtml="shopcart_edit.asp?dept="+dept+"&ordername="+ordername+"&byasc="+byasc
wheretxt=""
if Request.ServerVariables("REQUEST_METHOD")="POST" then
rectot=Request.Form("rectot")
for i=1 to rectot
checksele=Request.Form("checksele"&i)
if checksele<>"" then
seleitem=Request.Form("seleitem"&i)
cn.BeginTrans
sqltext="delete from shopdetail where cartno="&seleitem
cn.Execute(sqltext)
sqltext="delete from "+tablename+" where keyno="&seleitem
cn.Execute sqltext
cn.CommitTrans
end if
next
end if
%>
<HTML>
<HEAD>
<meta HTTP-EQUIV="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;}
.t1 {font:12px 宋体;color=000000}
.t2 {font:12px 宋体;color:ffffff}
.bt1 {font:14px 宋体;color=000000}
.bt2 {font:14px 宋体;color:ffffff}
A:link {color: #000066}
A:visited {color: #000066}
A:hover {color: #ff0000}
A.r1:link {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:visited {font-size:12px;text-decoration:underline;color:#000000;}
A.r1:hover {font-size:12px;text-decoration:underline;color:#ff6600;}
A.r2:link {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:visited {font-size:12px;text-decoration:underline;color:#ffffff;}
A.r2:hover {font-size:12px;text-decoration:underline;color:#ff6600;}
-->
</style>
</HEAD>
<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="2">
<tr><td align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height=24>
<form name=form1 method="post" action="<%=htmlname%>">
<tr valign=bottom>
<td style="font-size:12px;">
<font color="DarkSlateGray" style="font-size:14px"><b><%=htmltitle%></b></font>
<font color=ff6600><%=mytitle%></font>
<a href="<%=htmlname%>&pageno=<%=pageno%>">[刷新列表]</a>
</td>
<td align="right">
<input type="button" name="mydele" value="删除" style="width:60px;height:20px" onclick="delmsg(this.form)">
<input type="checkbox" name="seleall" onclick="checkall(this.form)" >全选
</td>
</tr>
</table>
</td></tr>
<%
if dept<>"" then
wheretxt=" where dept='"+dept+"'"
end if
sqltext="select * from "+tablename+wheretxt&ordertxt
'Response.Write sqltext
'Response.End
rs.Open sqltext,cn,1,1
listcount=30
rs.PageSize=listcount
if pageno="" then pageno=1 else pageno=cint(pageno)
if rs.PageCount>0 then rs.AbsolutePage=pageno
%>
<tr><td valign=top height=360>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="527c72" style="color:#ffffff" align="center">
<td width=10 height=20 align=center></td>
<td class=t2><a class=r2 href="<%=htmlname2%>&ordername=username&byasc=<%=selectxh("username",ordername,byasc,"asc")%>">用户名</a></td>
<td class=t2><a class=r2 href="<%=htmlname2%>&ordername=phone&byasc=<%=selectxh("phone",ordername,byasc,"asc")%>">电话</a></td>
<td class=t2><a class=r2 href="<%=htmlname2%>&ordername=email&byasc=<%=selectxh("email",ordername,byasc,"asc")%>">电子邮件</a></td>
<td class=t2><a class=r2 href="<%=htmlname2%>&ordername=state&byasc=<%=selectxh("state",ordername,byasc,"asc")%>">状态</a></td>
<td class=t2 width=120><a class=r2 href="<%=htmlname2%>&ordername=creadate&byasc=<%=selectxh("creadate",ordername,byasc,"desc")%>">定购日期</a></td>
</tr>
<%
i=1
do while not rs.EOF and i<=listcount
if (i mod 2)=0 then
Response.Write("<tr bgcolor=fefefe>")
else
Response.Write("<tr bgcolor=efefef>")
end if
%>
<td width=10 height=20 align=center>
<input type=hidden name="seleitem<%=i%>" value="<%=rs("keyno")%>">
<input type=checkbox name="checksele<%=i%>" value="0">
</td>
<td align=left> <a href="<%=addhtml%>&keyno=<%=rs("keyno")%>&pageno=<%=pageno%>"><%Response.Write Server.HTMLEncode(trim(rs("username")))%></a>
</td>
<td align=left><%=trim(rs("phone"))%></td>
<td align=left><%=trim(rs("email"))%></td>
<td width="60" align="center">
<%Select Case trim(rs("state"))
case "0"
Response.Write("<font color=ff0000>未处理</font>")
case "1"
Response.Write("<font color=000000>已处理</font>")
end select
%>
</td>
<td align=left width=120><%=rs("creadate")%></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
%>
<input type=hidden value="<%=i-1%>" name=rectot>
</form>
</table>
</td></tr>
<tr><td valign=top height=30>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td colspan=2 bgcolor="696969" height=1></td></tr>
<tr><td>
</td><td align=right height=30>
[第<font color=ff6600><b><%=pageno%></font></b>页, 共<b><font color=ff6600><%=rs.PageCount%></font></b>页<b><font color=ff6600><%=rs.RecordCount%></font></b>条记录]
<%if pageno>1 then%>
<a class=r1 href="<%=htmlname%>&pageno=1">[首页]</a>
<a class=r1 href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>
<%end if
if pageno<rs.PageCount then%>
<a class=r1 href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>
<a class=r1 href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>
<%end if%>
</td></tr>
</table>
<%
rs.Close
%>
</td></tr>
</table>
</body>
</html>
<!-- #include file="../admin/sysfunc.inc.asp" -->
<script language="Javascript">
function checkall(form)
{
for (var i=0;i<form.elements.length;i++)
{
var obj = form.elements[i];
var objname=obj.name;
if(objname.substring(0,9)=="checksele")
{
obj.checked=form.seleall.checked
}
}
}
function delmsg(form)
{
var flag=false;
var i,rectot,obj1
rectot=form.rectot.value;
for(i=1;i<=rectot;i++)
{
obj1=eval("form.checksele"+i);
if (obj1.checked) flag=true;
}
if (flag){
if (confirm('确认删除选择的记录吗？')==true) form.submit();
}else alert("请先选择要删除的记录!");
}
function editimage(keyno)
{
var str
str="../admin/pic_upload.asp?keyno="+keyno+"&tablename=product&keyword=prono&strflag=0"
window.open(str,"mywin","toolbar=no,location=no,directories=no,status=no,resizable=no,menubar=no,scrollbars=yes,width=550,height=400,left=120,top=70")
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -