/// <summary>
/// 获取邮件发送
/// </summary>
/// <param name="emailSendInfo">邮件发送实体</param>
/// <param name="pageInfo">分页实体</param>
/// <returns></returns>
public IList <EmailSendInfo> GetEmailSend(EmailSendInfo emailSendInfo, PageInfo pageInfo)
{
using (DataContextDB DB = new DataContextDB())
{
IQueryable <EmailSendInfo> emailSendInfos =
(
from item in DB.GetTable <EmailSendInfo>()
orderby item.ID descending
select item
);
if (emailSendInfo != null && emailSendInfo.ID != 0)
{
emailSendInfos = emailSendInfos.Where <EmailSendInfo>(m => m.ID == emailSendInfo.ID);
}
if (emailSendInfo != null && emailSendInfo.UserID != 0)
{
emailSendInfos = emailSendInfos.Where <EmailSendInfo>(m => m.UserID == emailSendInfo.UserID);
}
if (pageInfo != null)
{
pageInfo.TotalRecord = emailSendInfos.Count();
return(emailSendInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <EmailSendInfo>());
}
else
{
return(emailSendInfos.ToList <EmailSendInfo>());
}
}
}
public ActionResult EmailSendList(int userID = 0, int pageIndex = 1)
{
PageInfo pageInfo = new PageInfo {
PageIndex = pageIndex
};
EmailSendInfo emailSendInfo = new EmailSendInfo {
UserID = userID
};
IList <EmailSendInfo> emailSendInfos = Start.DatabaseProvider.Instance().GetEmailSend(emailSendInfo, pageInfo);
PagedList <EmailSendInfo> pagedList = new PagedList <EmailSendInfo>(emailSendInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord);
ViewBag.EmailSendInfo = emailSendInfo;
return(View(pagedList));
}
/// <summary>
/// 修改邮件发送
/// </summary>
/// <param name="emailSendInfo">邮件发送实体</param>
public int UpdateEmailSend(EmailSendInfo emailSendInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <EmailSendInfo>().Attach(emailSendInfo, true);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
/// <summary>
/// 添加邮件发送
/// </summary>
/// <param name="emailSendInfo">邮件发送实体</param>
public int InsertEmailSend(EmailSendInfo emailSendInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <EmailSendInfo>().InsertOnSubmit(emailSendInfo);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
