📄 user3.asp

📁 这是一个很漂亮的网站购物系统
💻 ASP
字号:
<!--#include file="../include/buyok_shop_30_conn.asp"-->
<!--#include file="checkadmin.asp"-->
<script language=javascript src=../include/mouse_on_title.js></script>
<%call checkmanage("05")%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="manage.css" type="text/css">
<script language=javascript>
<!--
function CheckAll(form){
for (var i=0;i<form.elements.length;i++){
var e = form.elements[i];
if (e.name != 'chkall') e.checked = form.chkall.checked; 
}
}
-->
</script>
</head>
<BODY background="../images/admin/back.gif">

<%
action=request("action")
if action="sendmail" then
call sendmail()
else
%>
<form action=user3.asp method=post name=usermail>
<table width="98%" border="1"  style="border-collapse: collapse; border-style: dotted; border-width: 0px"  bordercolor="#333333" cellspacing="0" cellpadding="2">
<tr>
<td colspan=3 class=td height=18>会员邮件列表</td></tr>

<%  
pages = 20
sql="select * from buyok_user where UserNum is not null "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if rs.eof and rs.bof then 
response.write "<tr><td colspan=3 align=center height=50>没有注册会员，未生成邮件列表</td></tr>"
response.end 
rs.close
set rs=nothing
end if

totaluser=RS.RecordCount
rs.pageSize = pages
allPages = rs.pageCount
page = Request("page")
If not isNumeric(page) then page=1
if isEmpty(page) or clng(page) < 1 then
page = 1
elseif clng(page) >= allPages then
page = allPages 
end if
rs.AbsolutePage = page

response.write "<tr><td align=center width='5%'>选</td><td width=30% align=center>会员ID</td><td align=center>会员Email</td></tr>"

Do While Not rs.eof and pages>0 
response.write "<tr><td height=25><input type='checkbox' value='"&rs("UserMail")&"' name=usermail></td><td>"&rs("userid")&"</td><td>"&rs("usermail")&"</td></tr>"

pages = pages - 1
rs.movenext
if rs.eof then exit do
loop
%>

<tr><td colspan=3>
<input type='checkbox' name=chkall onclick='CheckAll(this.form)'>全选 
<input type=hidden name=action value=sendmail>
<input type=submit value="群发邮件">
</td></tr>
<table>
</form>
<%
call listPages()
end if

sub listPages() 
'分页
'if allpages<=1 then exit sub
response.write "<br>总记录数<font color=red>"&totaluser&"</font> &nbsp; 每页<font color=red>20</font>&nbsp; "
if page = 1 then
response.write "<font color=darkgray>首页 前页</font>"
else
response.write "<a href=user3.asp?keywords="&keywords&"&page=1>首页</a> <a href=user3.asp?keywords="&keywords&"&page="&page-1&">前页</a>"
end if
if page = allpages then
response.write "<font color=darkgray> 下页 末页</font>"
else
response.write " <a href=user3.asp?keywords="&keywords&"&page="&page+1&">下页</a> <a href=user3.asp?keywords="&keywords&"&page="&allpages&">末页</a>"
end if
end sub


sub sendmail()

usermail=request("usermail")
if usermail="" or isnull(usermail) then
response.write "<script language='javascript'>"
response.write "alert('出错了，您什么也没有选择！');"
response.write "location.href='javascript:history.go(-1)';"
response.write "</script>"
response.end
end if
usermail=replace(usermail,", ",";")
response.redirect "sendmail.asp?"&usermail
end sub
%>

</body>
</html>
<%
conn.close
set conn=nothing
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -