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