📄 email_list.asp

📁 购物系统时尚版.强大的后台文章编辑器的功能
💻 ASP
字号:
<!--#include file="chk.asp"-->
<!--#include file="db_conn.asp"-->
<!--#include file="../my_lib/my_request.asp"-->
<!--#include file="../my_lib/pages.asp"-->
<html>
<head>
<title>邮件列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="style.css" rel=stylesheet type=text/css>
</head>
<body>
<!--#include file="TopManu.asp"-->
<div align="center">
<table border="0" width="100%" id="table1" cellspacing="0" style="border-collapse: collapse" cellpadding="0">
	<tr>
		<td background="image/admintoptdbg.gif">
		<p align="left">
		<img border="0" src="image/title_arrow.bmp" width="17" height="27" align="absmiddle"><b><font color="#808080"><a href="email_list.asp?flag=1"><font color="#808080">全部会员邮件列表</font></a>&nbsp;&nbsp;&nbsp; 
			<a href="email_list.asp?flag=2"><font color="#808080">全部非会员邮件列表</font></a></font></b></td>
	</tr>
</table>
<table width="100%" cellpadding="0" style="border-collapse: collapse">
  <tr> 
    <td> 
      <div align="center">
      <table width="100%" style="border-right:1px solid #C0C0C0; border-bottom:1px solid #C0C0C0; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; border-collapse:collapse; border-left-style:solid; border-left-width:1px; border-top-style:solid; border-top-width:1px" cellpadding="4">
        <tr valign="middle"> 
          <td align="center" bgcolor="#EFEFEF" height="14" width="56">ID</td>
          <td align="center" bgcolor="#EFEFEF" height="14" width="219">E-mail</td>
          <td align="center" bgcolor="#EFEFEF" height="14" width="118">是否是会员</td>
          <td align="center" bgcolor="#EFEFEF" height="14" width="152">IP地址</td>
          <td align="center" bgcolor="#EFEFEF" height="14" width="162">申请日期</td>
          <td align="center" bgcolor="#EFEFEF" height="14" width="35">选择</td>
        </tr>
        <%
flag=my_request("flag",1)
if isnull(flag) or flag="" then
flag=1
end if
select case flag
case 1
sqltext="select txt_email as email,dat_regtime as mtime,last_login_ip as vip from user_info_list order by dat_regtime desc"
hy="会员"
case 2
sqltext="select addtime as email,yqj_email as mtime,ip as vip from buyer where ishy=1 order by addtime desc" 
hy="非会员"
case else
sqltext="select txt_email as email,dat_regtime as mtime,last_login_ip as vip from user_info_list order by dat_regtime desc"
hy="会员"
end select
        
set rs=server.createobject("adodb.recordset")
rs.open sqltext,conn,1,1
if (rs.eof and rs.bof) then
	response.write "<tr>"
    response.write "<td width=500 colspan=4><font color=#FF0000>没有相应的数据</font></td>"
    response.write "</tr>"
    else
    rs.PageSize =20 '每页记录条数
			iCount=rs.RecordCount '记录总数
			iPageSize=rs.PageSize
    		maxpage=rs.PageCount 
    		page=request("page")
    
    if Not IsNumeric(page) or page="" then
        page=1
    else
        page=cint(page)
    end if
    
    if page<1 then
        page=1
    elseif  page>maxpage then
        page=maxpage
    end if
    
    rs.AbsolutePage=Page

	if page=maxpage then
		x=iCount-(maxpage-1)*iPageSize
	else
		x=iPageSize
	end if

end if
						  ii=1
						  while not rs.eof and ii<=rs.pagesize
set email=rs("email")
set mtime=rs("mtime")
set vip=rs("vip")
%><form action="send_email.asp" method="post">
        <tr valign="middle"> 
          <td bgcolor="#FFFFFF" height="20" width="56" align="center"><%=(page-1)*19+ii%></td>
          <td bgcolor="#FFFFFF" height="20" width="219"><a href="mailto:<%=email%>"><%=email%></a></td>
          <td bgcolor="#FFFFFF" height="20" width="118"><%=hy%></td>
          <td align="lelft" bgcolor="#FFFFFF" height="20" width="152"><%=vip%></td>
          <td align="left" bgcolor="#FFFFFF" height="20" width="162"><%=mtime%></td>
          <td align="center" bgcolor="#FFFFFF" height="20" width="35">
			<input type="checkbox" name="ischeck" value="<%=email%>"></td>
        </tr>
<%
rs.movenext
ii=ii+1
wend
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
        <tr valign="middle"> 
          <td colspan="6" align="center" height="20"> 
            <p align="right"><input type="submit" value="选择发送邮件" name="B1"></td>
        </tr>
        </form>
        <tr valign="middle"> 
          <td colspan="6" align="center" height="20"><%call PageControl(iCount,maxpage,page,"border=0 align=left","<p align=center>")%></td>
        </tr>
      </table> 
      </div>
      <div align="center"></div></td>
  </tr>
</table>
</div>
<table border="0" width="760" id="table3" cellspacing="0" cellpadding="0" align=center>
	<tr>
		<td align=right><input TYPE="button" VALUE="刷新本页" ONCLICK="location.reload()"> </td>
	</tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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