網(wǎng)站自動(dòng)發(fā)送驗(yàn)證碼

xuxueli 發(fā)布于2019-08-16 17:52 / 1683人閱讀

摘要：一觸發(fā)器發(fā)送二程序后用任務(wù)計(jì)劃發(fā)送頁面引用要發(fā)送的郵件收件人主題內(nèi)容優(yōu)先級(jí)內(nèi)容類型再把狀態(tài)改一下參數(shù)頁面配置配置程序開始程序附件系統(tǒng)工具任務(wù)計(jì)劃，雙擊添加任務(wù)，選擇程序文件程序生成的，管理員輸入密碼為登錄密碼，一直

一、sql觸發(fā)器發(fā)送
二、winform程序后用任務(wù)計(jì)劃發(fā)送

頁面 //引用 using System.Data.Common; using System.Data.SqlClient; using
System.Configuration; using System.Data; using System.Net.Mail;
//要發(fā)送的郵件 public static DataSet SendEmailList() { DataSet ds = new
DataSet(); try { string str =
ConfigurationSettings.AppSettings[“ConnectionString”]; SqlConnection
conn = new SqlConnection(str); conn.Open(); SqlCommand comm = new
SqlCommand(“SendEmailList”, conn); comm.CommandType =
CommandType.StoredProcedure; comm.ExecuteNonQuery(); SqlDataAdapter da
= new SqlDataAdapter(); da.SelectCommand = comm; da.Fill(ds); conn.Close(); } catch (Exception ex) { } return ds; } public static
bool SendMail(string form, string toMail, string title, string body,
string SendEmailID) { bool result = false; try { MailMessage email =
new MailMessage(); email.From = new MailAddress(form); //收件人
email.To.Add(toMail); //主題 email.Subject = title; //內(nèi)容 email.Body =
body; //優(yōu)先級(jí) email.Priority = MailPriority.Normal; //內(nèi)容類型
email.IsBodyHtml = true; SmtpClient client = new SmtpClient();
client.Send(email); //再把狀態(tài)改一下 string str =
ConfigurationSettings.AppSettings[“ConnectionString”].ToString();
SqlConnection conn = new SqlConnection(str); conn.Open(); SqlCommand
comm = new SqlCommand(“SendEmailDelete”, conn); //參數(shù)SendEmailID
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@SendEmailID",
SqlDbType.NVarChar, 50)); comm.Parameters["@SendEmailID"].Value =
SendEmailID.ToString(); comm.ExecuteNonQuery(); result = true; } catch
(Exception ex) { result = false; } return result; } webconfig頁面配置 配置程序
開始----程序----附件—系統(tǒng)工具—任務(wù)計(jì)劃，雙擊添加任務(wù)，選擇程序文件-----（程序生成的*.exe)，管理員輸入密碼為登錄密碼，一直點(diǎn)下一步就行了

三、global
缺點(diǎn)，有人訪問頁面時(shí)，global才會(huì)運(yùn)行
webconfig頁面配置
global頁面

void Application_Start(object sender, EventArgs e) { // 在應(yīng)用程序啟動(dòng)時(shí)運(yùn)行的代碼
Timer t = new Timer(60000);//設(shè)計(jì)時(shí)間間隔，如果一個(gè)小時(shí)執(zhí)行一次就改為3600000 ，這里一分鐘調(diào)用一次
t.Elapsed += new ElapsedEventHandler(t_Elapsed); t.AutoReset = true;
t.Enabled = true; } private void t_Elapsed(object sender,
ElapsedEventArgs e) { Response.Write(“執(zhí)行成功”); //查詢數(shù)據(jù)庫 DataSet ds =
Common.SendEmailList(); string FormEmail =
ConfigurationManager.AppSettings[“UserEmail”]; string title =
“會(huì)員申請(qǐng)網(wǎng)上注冊(cè)失敗”; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) {
string ToEmail = ds.Tables[0].Rowsi.ToString();
string body = “你的網(wǎng)上注冊(cè)失敗，錯(cuò)誤原因：”; body +=
ds.Tables[0].Rowsi.ToString() + “ ”; body += “請(qǐng)查看資料修正”;
string SendEmailID = ds.Tables[0].Rowsi.ToString();
Common.SendMail(FormEmail, ToEmail, title, body, SendEmailID); } }
winform頁面 //引用 using System.Data.Common; using System.Data.SqlClient;
using System.Configuration; using System.Data; using System.Net.Mail;
//要發(fā)送的郵件 public static DataSet SendEmailList() { DataSet ds = new
DataSet(); try { string str =
ConfigurationManager.ConnectionStrings[“ConnectionString”].ConnectionString;
SqlConnection conn = new SqlConnection(str); conn.Open(); SqlCommand
comm = new SqlCommand(“SendEmailList”, conn); comm.CommandType =
CommandType.StoredProcedure; comm.ExecuteNonQuery(); SqlDataAdapter da
= new SqlDataAdapter(); da.SelectCommand = comm; da.Fill(ds); conn.Close(); } catch (Exception ex) { } return ds; } public static
bool SendMail(string form, string toMail, string title, string
body,string SendEmailID) { bool result = false; try { MailMessage
email = new MailMessage(); email.From = new MailAddress(form); //收件人
email.To.Add(toMail); //主題 email.Subject = title; //內(nèi)容 email.Body =
body; //優(yōu)先級(jí) email.Priority = MailPriority.Normal; //內(nèi)容類型
email.IsBodyHtml = true; SmtpClient client = new SmtpClient();
client.Send(email); //再把狀態(tài)改一下 string str =
ConfigurationManager.ConnectionStrings[“ConnectionString”].ConnectionString;
SqlConnection conn = new SqlConnection(str); conn.Open(); SqlCommand
comm = new SqlCommand(“SendEmailDelete”, conn); //參數(shù)SendEmailID
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@SendEmailID",
SqlDbType.NVarChar, 50)); comm.Parameters["@SendEmailID"].Value =
SendEmailID.ToString(); comm.ExecuteNonQuery(); result = true; } catch
(Exception ex) { result = false; } return result; }