public string MailToSupplier(string supplierID, string userName) { string result = "false"; try { DataSet ds = new DataSet(); ds = DbHelperSQL.Query("exec sp_Auctus_MailToSupplier N'" + supplierID + "'"); if (ds.Tables[1].Rows.Count == 0) { return("false"); } TheadPar par = new TheadPar(); par.ds = ds; par.UserName = userName; Thread th = new Thread(new ParameterizedThreadStart(MailToSupplier)); th.Start(par); result = "true"; } catch (Exception ex) { result = "false"; } return(result); }
/// <summary> /// 8周欠料结果邮件发送功能 /// </summary> /// <param name="obj"></param> public void MailToSupplier(object obj) { TheadPar par = (TheadPar)obj; string userName = par.UserName; //邮箱信息设置 MailSender mailSender = new MailSender(); mailSender.Email = "*****@*****.**"; mailSender.Password = "******"; mailSender.Host = "192.168.1.1"; mailSender.Port = 25; mailSender.IsBodyHtml = "true"; mailSender.From = new MailAddress("*****@*****.**", "深圳力同芯科技发展有限公司"); mailSender.To = new ArrayList(); mailSender.CC = new ArrayList(); mailSender.Bcc = new ArrayList(); //数据源 DataSet ds = par.ds; //Table0为无邮箱供应商 if (ds.Tables[0].Rows.Count > 0) { GetNoneEmaiContent(ds.Tables[0], ref mailSender, userName); } //Table1为有邮箱供应商 if (ds.Tables[1].Rows.Count > 0) { GetEmaiContent(ds.Tables[1], ref mailSender, userName); } }
public void MailTest() { try { DataSet ds = new DataSet(); ds = DbHelperSQL.Query("exec sp_Auctus_MailToSupplier N''"); if (ds.Tables[1].Rows.Count == 0) { return; } TheadPar par = new TheadPar(); par.ds = ds; par.UserName = "******"; Thread th = new Thread(new ParameterizedThreadStart(MailToSupplier)); th.Start(par); } catch (Exception ex) { return; } return; ////邮箱信息设置 //MailSender mailSender = new MailSender(); //mailSender.Email = "*****@*****.**"; //mailSender.Password = "******"; //mailSender.Host = "192.168.1.1"; //mailSender.Port = 25; //mailSender.IsBodyHtml = "true"; //mailSender.From = new MailAddress("*****@*****.**", "深圳力同芯科技发展有限公司"); //mailSender.To = new ArrayList(); //mailSender.CC = new ArrayList(); //mailSender.Bcc = new ArrayList(); //mailSender.Subject = "邮件测试"+DateTime.Now.ToString("yyyyMMddHHmmss"); //mailSender.Body = "<H1>Hello</H2>"; //mailSender.To.Add("*****@*****.**"); //try //{ // mailSender.SendMail(); //} //catch (Exception ex) //{ //} }