using System
using System.Collections.Generic
using System.Linq
using System.Web
using System.Web.UI
using System.Web.UI.WebControls
using System.Net.Mail
using System.Text
using System.IO
using sentmail
namespace gene.glo
{
public partial class yujian : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
public string ReplaceText(String userName, string ma)
{
string path = string.Empty
path = HttpContext.Current.Server.MapPath("a.html")
if (path == string.Empty)
{
return string.Empty
}
System.IO.StreamReader sr = new System.IO.StreamReader(path)
string str = string.Empty
str = sr.ReadToEnd()
str = str.Replace("$Binghe$", binghe)
str = str.Replace("$House$", house)
return str
}
protected void btn_Click1(object sender, EventArgs e)
{
string sql = "select * from basicinfo"
System.Data.DataTable dt = DB.getDataTable(sql)
string sqlad = "select * from addurl"
System.Data.DataTable da = DB.getDataTable(sqlad)
int insend = 0
int nosend = 0
try
{
for (int i = 0
{
//string a = dt.Rows[0]["num"].ToString()
string sql2 = "select * from chkitem where infoid ='" + dt.Rows[i]["num"].ToString() + "'"
System.Data.DataTable ds = DB.getDataTable(sql2)
if (ds.Rows[0]["baifen"].ToString() != "")
{
//string sqlsd = "update basicinfo set send =1"
//DB.ExecuteSql(sqlsd)
Email email = new Email()
email.mailFrom = "***@163.com"
email.mailPwd = "**123"
email.mailSubject = "结果"
email.mailBody = ReplaceText(dt.Rows[i]["name"].ToString(), dt.Rows[i]["md5"].ToString())
// email.mailBody = "检测人:" + dt.Rows[i]["name"].ToString() + "    查询码:" + dt.Rows[i]["md5"].ToString() + "    页面地址:" + da.Rows[0]["gene"].ToString() + "    对照表:" + da.Rows[0]["biao"].ToString()
email.isbodyHtml = true
//email.host = "smtp.163.com"
email.host = "smtp.sina.com.cn"
email.mailToArray = new string[] { dt.Rows[i]["email"].ToString() }
if (email.Send())
{
insend++
}
else
{
nosend++
}
}
else
{
return
}
}
Response.Write(insend + "<script type='text/javascript'>alert('条邮件发送成功!');history.go(-1)</script>")
}
catch(Exception ex)
{
throw ex
}
}
}
}