user3.asp
资源名称:shop2.rar [点击查看]
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:4k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
DOS
- <!--#include file="conn.asp"-->
- <%
- dim cls
- if session("admin")="" then
- Response.Redirect("admin.asp")
- else
- if session("flag")<>"0" then
- cls = Instr(session("flag"), "qunfa")
- if cls <= 0 then
- %>
- <script language="javascript">
- if (confirm("您的操作权限不够,系统拒绝你的访问,请点确定返回,或者点取消退出重新登录"))
- location.href="login.asp";
- else
- location.href="index.asp";
- </script>
- <%
- end if
- end if
- end if
- %>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
- <link rel="stylesheet" href="css.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=4 background="../images/admin_bg_1.gif" height=25><div align=center>会员邮件列表</div></td></tr>
- <%
- pages = 20
- sql="select * from yx_user where password 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 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 width=30% align=center>会员注册日期</td><td align=center>会员Email</td></tr>"
- Do While Not rs.eof and pages>0
- response.write "<tr><td height=25 bgcolor='#fbf4f4'><input type='checkbox' value='"&rs("mail")&"' name=usermail></td><td bgcolor='#fbf4f4'>"&rs("ID")&" </td><td bgcolor='#fbf4f4'>"&rs("AddDate")&"</td><td bgcolor='#fbf4f4'>"&rs("mail")&"</td></tr>"
- pages = pages - 1
- rs.movenext
- if rs.eof then exit do
- loop
- %>
- <tr><td colspan=4>
- <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>条记录,每页<font color=red>20</font> "
- 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
- %>
English
