private void MailSend(long siteId, FormMailModel mail, string mailSubject, string mailBody, System.Collections.ArrayList fileList, string recipientIds)
{
string SitesTitle = SitesDAO.GetInfo(siteId).Title;//網站名稱
IEnumerable <long> recipientIdList = recipientIds.Split(',').Select(id => long.Parse(id));
IEnumerable <FormItem> formItems = FormItemDAO.GetItems(recipientIdList);
string rootUrl = Utility.GetRootUrl() + "/";
foreach (FormItem item in formItems)
{
if (string.IsNullOrWhiteSpace(item.Email))
{
continue;
}
FormCheckStatus status = (FormCheckStatus)item.CheckStatus;
string result = status == FormCheckStatus.正取 ? "報名成功" : status.ToString();
string subject = mailSubject.Replace("[RegTime]", item.CreateDate.ToString(WebInfo.DateFmt))
.Replace("[RegName]", item.Name)
.Replace("[RegGender]", item.Sex)
.Replace("[RegResult]", result);
string receiveUrl = $"{ rootUrl }Form/MailRead/{ mail.ID }?itemId={ item.ID }";
string body = mailBody.Replace("[RegTime]", item.CreateDate.ToString(WebInfo.DateFmt))
.Replace("[RegName]", item.Name)
.Replace("[RegGender]", item.Sex)
.Replace("[Receive]", receiveUrl)
.Replace("[RegPhone]", item.Mobile)
.Replace("[RegTel]", item.Phone)
.Replace("[RegEmail]", item.Email)
.Replace("[RegResult]", result);
emailService.SendMailWithFiles(siteId, item.Email, item.Name, subject, body, fileList, mail.SenderEmail, SitesTitle);
FormMailDAO.WriteLog(mail.ID, item.ID);
}
}
public static void Complete(long id, FormCheckStatus status)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
string sql = $"Update FormItem Set IsTemp = 0, CheckStatus = { (int)status } Where ID = { id }";
db.ExecuteNonQuery(sql);
}
public static void SetCheckStatus(IEnumerable <long> ids, FormCheckStatus status)
{
if (ids == null || ids.Count() == 0)
{
return;
}
string sql = $"Update FormItem Set CheckStatus = { (int)status }, CheckDate = GetDate() Where ID IN ({ string.Join(", ", ids) })";
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
db.ExecuteNonQuery(sql);
}
