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)
//{
//}
}
