/// <summary> /// 获取邮箱配置 /// </summary> /// <param name="emailProfile">邮箱配置实体</param> /// <param name="pageInfo">分页实体</param> /// <returns></returns> public IList <EmailProfileInfo> GetEmailProfile(EmailProfileInfo emailProfile, PageInfo pageInfo) { using (DataContextDB DB = new DataContextDB()) { IQueryable <EmailProfileInfo> emailProfiles = ( from item in DB.GetTable <EmailProfileInfo>() orderby item.ID descending select item ); if (emailProfile != null && emailProfile.ID != 0) { emailProfiles = emailProfiles.Where <EmailProfileInfo>(m => m.ID == emailProfile.ID); } if (emailProfile != null && emailProfile.UserID != 0) { emailProfiles = emailProfiles.Where <EmailProfileInfo>(m => m.UserID == emailProfile.UserID); } if (pageInfo != null) { pageInfo.TotalRecord = emailProfiles.Count(); return(emailProfiles.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <EmailProfileInfo>()); } else { return(emailProfiles.ToList <EmailProfileInfo>()); } } }
public ActionResult EmailProfile(int?id) { EmailProfileInfo emailProfileInfo = null; if (id != null && id.Value != 0) { emailProfileInfo = Start.DatabaseProvider.Instance().GetEmailProfileByID(id.Value); } if (emailProfileInfo == null) { emailProfileInfo = new EmailProfileInfo(); } return(View(emailProfileInfo)); }
public ActionResult EmailProfileList(int userID = 0, int pageIndex = 1) { PageInfo pageInfo = new PageInfo { PageIndex = pageIndex }; EmailProfileInfo emailProfileInfo = new EmailProfileInfo { UserID = userID }; IList <EmailProfileInfo> emailProfileInfos = Start.DatabaseProvider.Instance().GetEmailProfile(emailProfileInfo, pageInfo); PagedList <EmailProfileInfo> pagedList = new PagedList <EmailProfileInfo>(emailProfileInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord); ViewBag.EmailProfileInfo = emailProfileInfo; return(View(pagedList)); }
/// <summary> /// 修改邮箱配置 /// </summary> /// <param name="emailProfile">邮箱配置实体</param> public int UpdateEmailProfile(EmailProfileInfo emailProfile) { using (DataContextDB DB = new DataContextDB()) { try { DB.GetTable <EmailProfileInfo>().Attach(emailProfile, true); DB.SubmitChanges(); return(1); } catch (Exception e) { string error = e.Message; return(-1); } } }
public ActionResult EmailProfile(EmailProfileInfo emailProfileInfo) { if (emailProfileInfo == null) { return(Json(new FeedbackInfo { Success = -1, Message = "获取实体出错" })); } if (emailProfileInfo.UserID == 0) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入用户编号" })); } if (string.IsNullOrWhiteSpace(emailProfileInfo.SMTP)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入发送邮箱服务器" })); } if (string.IsNullOrWhiteSpace(emailProfileInfo.SMTPPort)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入发送邮箱服务器端口" })); } if (string.IsNullOrWhiteSpace(emailProfileInfo.Name)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入邮箱登陆名" })); } if (string.IsNullOrWhiteSpace(emailProfileInfo.Password)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入邮箱登陆密码" })); } //新建 int result = 0; if (emailProfileInfo.ID == 0) { result = Start.DatabaseProvider.Instance().InsertEmailProfile(emailProfileInfo); if (result == 1) { return(Json(new FeedbackInfo { Success = 1, Message = "添加成功" })); } else { return(Json(new FeedbackInfo { Success = -1, Message = "添加失败" })); } } else //编辑 { result = Start.DatabaseProvider.Instance().UpdateEmailProfile(emailProfileInfo); if (result == 1) { return(Json(new FeedbackInfo { Success = 1, Message = "修改成功" })); } else { return(Json(new FeedbackInfo { Success = -1, Message = "修改失败" })); } } }