public int SendMailLog_Insert(SendMailLog obj)
{
using (VideosAccess access = new VideosAccess())
{
return(access.SendMailLog_Insert(obj));
}
}
public int SendMailLog_UpdateById(SendMailLog obj)
{
using (VideosAccess access = new VideosAccess())
{
return(access.SendMailLog_UpdateById(obj));
}
}
public List <SendMailLog> SendMailLog_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SendMailLog_SelectPage");
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy);
db.AddInParameter(dbCmd, "@where", DbType.String, where);
List <SendMailLog> list = new List <SendMailLog>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
SendMailLog obj = Obj2Model <SendMailLog>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static int SendMailLog_UpdateById(SendMailLog obj)
{
IVideosService channel = Entity.CreateChannel <IVideosService>(SiteEnum.SiteService.VideoService);
var result = channel.SendMailLog_UpdateById(obj);
(channel as IDisposable).Dispose();
return(result);
}
public int SendMailLog_UpdateById(SendMailLog obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SendMailLog_UpdateById");
db.AddInParameter(dbCmd, "@Id", DbType.Int32, obj.Id);
db.AddInParameter(dbCmd, "@Email", DbType.String, obj.Email);
db.AddInParameter(dbCmd, "@Title", DbType.String, obj.Title);
db.AddInParameter(dbCmd, "@SendTime", DbType.String, obj.SendTime);
db.AddInParameter(dbCmd, "@SendContent", DbType.String, obj.SendContent);
db.AddInParameter(dbCmd, "@IsSuccess", DbType.Boolean, obj.IsSuccess);
db.AddInParameter(dbCmd, "@Remark", DbType.String, obj.Remark);
db.AddInParameter(dbCmd, "@CreateTime", DbType.String, obj.CreateTime);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult ReSendMail(int id)
{
SendMailLog sInfo = VideoServiceClass.SendMailLog_SelectById(id);
SentMail.SentMail sm = new SentMail.SentMail();
sm.Init("*****@*****.**", "账号激活", sInfo.Email, sInfo.SendContent, true);
string error;
sm.SentNetMail(out error);
sInfo.Remark = error;
sInfo.SendTime = DateTime.Now;
int result = VideoServiceClass.SendMailLog_UpdateById(sInfo);
if (result > 0)
{
return Json(new { success = true, errors = new { text = "删除成功" } });
}
else
{
return Json(new { success = false, errors = new { text = "删除失败" } });
}
}
public SendMailLog SendMailLog_SelectById(int Id)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SendMailLog_SelectById");
db.AddInParameter(dbCmd, "@Id", DbType.Int32, Id);
SendMailLog obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
obj = Obj2Model <SendMailLog>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// Sends the mail.
/// </summary>
/// <param name="engine">The engine.</param>
/// <param name="workItems">The work items.</param>
public void SendMail(EPiMailEngine engine, JobWorkItems workItems, bool isTestSend)
{
if (_log.IsDebugEnabled())
{
_log.Debug("Starting send process. Testmode: " + isTestSend.ToString());
}
// First we verify the environment
if (VerifyEnvironment(engine) == false)
{
return;
}
// Collection of recipients from job
if (workItems == null)
{
throw new NullReferenceException("workItems cannot be null when sending newsletter");
}
if (workItems.Items.Count == 0)
{
ShowError("No recipients defined. Please add email addresses to textbox above Test Send button.");
return;
}
// Need default values
// 1. Use MailSender property
// 2. Use EPsSendMailFromAddress from web.config
// 3. Construct newsletter@<sitename>
string fromAddress = MailFrom;
// 1. Use MailSubject property
// 2. Use EPsSendMailSubject from web.config
// 3. Use "Newsletter" as default
string subject = MailSubject;
if (isTestSend)
{
subject += TEST_SUBJECT_POSTFIX;
}
if (_log.IsDebugEnabled())
{
_log.Debug(string.Format("Start sending newsletter based on WorkItems. Subject: '{0}', From: '{1}', Count '{2}', Test Mode: '{3}'",
subject, fromAddress, workItems.Items.Count.ToString(), isTestSend.ToString()));
}
// Send the message
string sendStatus;
// We set testsend as false in the method below, as the test sending UI has changed, but the
// logic in the engine interpret this as not sending anything. Test here means change the
// email subject
SendMailLog log = engine.SendNewsletter(subject, fromAddress, CurrentPage.ContentLink, workItems, false);
sendStatus = log.GetClearTextLogString(true);
lblSendResult.Text = sendStatus;
pnlSendResult.Visible = true;
if (_log.IsDebugEnabled())
{
_log.Debug("Send process finished. Testmode: " + isTestSend.ToString());
}
}
