⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 sendmail_lest.asp

📁 在线邮件列表抓取与发送系统SQL版
💻 ASP
字号:

<!--#include file="./Conn_Mail.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim makking,del,GroupID
			makking=request.QueryString("makking")
			ID     = TRIM(Request.QueryString("ID"))
			MailID = TRIM(Request.Form("MailID"))
			del    = Request.Form("del")
	if makking="Make" then

    select case del
	case "" 
		call no()
	case "0" 
		call no()
	case "1"
		conn_m.execute("update Mail set Ending=0,MailPicture='' where ID in ("& MailID &")")
	case "2"
		conn_m.execute("update Mail set Ending=2,MailPicture='' where ID in ("& MailID &")")
	case "3"
		conn_m.execute("update Mail set Ending=1,MailPicture='' where ID in ("& MailID &")")
	case "4"
		conn_m.execute("delete from Mail where ID in ("& MailID &")")
    end select
	
	Save_Title = "·成功"
	Call Save_ok
	
	end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ELIGHT.CC</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="100%"  border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
        <tr>
          <td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%"  border="0" cellpadding="3" cellspacing="0">
              <tr bgcolor="eeeeee">
                <td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
                <td width="78%"><span City="style2">管理中心 &gt;&gt;&gt; </span><span class="style2"> 
                  邮件列表</span>详情</td>
                <td width="17%" align="right">&nbsp; </td>
              </tr>
          </table></td>
        </tr>
    </table></td>
  </tr>
</table>
<table width="98%" height="90%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
  <tr>
    <td valign="top" bgcolor="ffffff"><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td align="center" bgcolor="ffffff"> <table width=100% border=0 align='center' cellpadding=3 cellspacing=1 bordercolordark=#ffffff bgcolor="eaeaea"><form name="form1" method="post" action="SendMail_Lest.asp?Makking=Make">
              <tr align="left" bgcolor="ffffff" background="Images/box_bg.gif"> 
                <td width="3%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">&nbsp;</td>
                <td width="19%" height="20" background="Images/box_bg.gif" bgcolor="ffffff">邮件名称</td>
                <td width="15%" height="20" background="Images/box_bg.gif">状态</td>
                <td width="23%" height="20" background="Images/box_bg.gif">记录时间</td>
                <td width="40%" height="20" background="Images/box_bg.gif">说明</td>
              </tr>
    <%
	if ID="" or Not IsNumeric(ID) then
	Response.Write "调用出错"
	Response.end
	End IF
	
	sql="select * from Mail Where GroupID="& ID &" order by datetime desc" 
	set rs=server.createobject("adodb.recordset") 
	rs.open sql,conn_m,1,1
	if not(rs.bof and rs.eof) then
	'==============================page
	rs.PageSize =20
	%>
              <!--#include file="page.asp"-->
              <tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'"> 
                <td height="24" bgcolor="ffffff"> <input type="checkbox" name="MailID" value="<%=rs("ID")%>"> 
                </td>
                <td bgcolor="ffffff"> <%=trim(rs("Mail"))%></td>
                <td height="24">
				<%
				IF rs("Ending")=0 Then
				Response.write "未发"
				END if
				IF rs("Ending")=1 Then
				Response.write "成功"
				END if
				IF rs("Ending")=2 Then
				Response.write "失败"
				END if
				%> </td>
                <td height="24"><%=rs("Datetime")%></td>
                <td><%=Rs("MailPicture")%></td>
              </tr>
              <%   
			rs.movenext
			next
			end if
           %>
            </table></td>
        </tr>
      </table>
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="4%" height="24" align="center" valign="middle" background="Images/box_bg_1.gif"> 
            <input type="checkbox" name="checkbox2" value="Check All" onClick="mm()"> 
          </td>
          <td width="12%" height="24" align="left" valign="middle" background="Images/box_bg_1.gif"> 
            <select name="del" class="all_box1">
              <option value="0">选择操作……</option>
              <option value="1">改为未发</option>
              <option value="2">改为失败</option>
              <option value="3">改为成功</option>
              <option value="4">删除</option>
            </select> </td>
          <td align="left" valign="middle" background="Images/box_bg_1.gif"> <input name="imageField2" type="image" src="Images/refer.gif" width="36" height="21" border="0"> 
          </td>
		   </form>
          <td width="51%" height="24" align="right" valign="top" background="Images/box_bg_1.gif"> 
            <%Page_links="ID="& ID &"&"
			call PageControl(iCount,maxpage,page)
			rs.close
			set rs=nothing
			
Conn_m.Close
Set Conn_m = Nothing
			%>
          </td>
        </tr>
      </table>
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="1" bgcolor="#E2E1E1"></td>
        </tr>
      </table>
      
    </td>
  </tr>
</table>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="6"></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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