/// <summary> /// 获取邮箱地址 /// </summary> /// <param name="emailAddressInfo">邮箱地址实体</param> /// <param name="pageInfo">分页实体</param> /// <returns></returns> public IList <EmailAddressInfo> GetEmailAddress(EmailAddressInfo emailAddressInfo, PageInfo pageInfo) { using (DataContextDB DB = new DataContextDB()) { IQueryable <EmailAddressInfo> emailAddressInfos = ( from item in DB.GetTable <EmailAddressInfo>() orderby item.ID descending select item ); if (emailAddressInfo != null && emailAddressInfo.ID != 0) { emailAddressInfos = emailAddressInfos.Where <EmailAddressInfo>(m => m.ID == emailAddressInfo.ID); } if (emailAddressInfo != null && emailAddressInfo.UserID != 0) { emailAddressInfos = emailAddressInfos.Where <EmailAddressInfo>(m => m.UserID == emailAddressInfo.UserID); } if (pageInfo != null) { pageInfo.TotalRecord = emailAddressInfos.Count(); return(emailAddressInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <EmailAddressInfo>()); } else { return(emailAddressInfos.ToList <EmailAddressInfo>()); } } }
public ActionResult EmailAddress(int?id) { EmailAddressInfo emailAddressInfo = null; if (id != null && id.Value != 0) { emailAddressInfo = Start.DatabaseProvider.Instance().GetEmailAddressByID(id.Value); } if (emailAddressInfo == null) { emailAddressInfo = new EmailAddressInfo(); } return(View(emailAddressInfo)); }
public ActionResult EmailAddressList(int userID = 0, int pageIndex = 1) { PageInfo pageInfo = new PageInfo { PageIndex = pageIndex }; EmailAddressInfo emailAddressInfo = new EmailAddressInfo { UserID = userID }; IList <EmailAddressInfo> emailAddressInfos = Start.DatabaseProvider.Instance().GetEmailAddress(emailAddressInfo, pageInfo); PagedList <EmailAddressInfo> pagedList = new PagedList <EmailAddressInfo>(emailAddressInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord); ViewBag.EmailAddressInfo = emailAddressInfo; return(View(pagedList)); }
/// <summary> /// 修改邮箱地址 /// </summary> /// <param name="emailAddressInfo">邮箱地址实体</param> public int UpdateEmailAddress(EmailAddressInfo emailAddressInfo) { using (DataContextDB DB = new DataContextDB()) { try { DB.GetTable <EmailAddressInfo>().Attach(emailAddressInfo, true); DB.SubmitChanges(); return(1); } catch (Exception e) { string error = e.Message; return(-1); } } }
/// <summary> /// 添加邮箱地址 /// </summary> /// <param name="emailAddressInfo">邮箱地址实体</param> public int InsertEmailAddress(EmailAddressInfo emailAddressInfo) { using (DataContextDB DB = new DataContextDB()) { try { DB.GetTable <EmailAddressInfo>().InsertOnSubmit(emailAddressInfo); DB.SubmitChanges(); return(1); } catch (Exception e) { string error = e.Message; return(-1); } } }
/// <summary> /// 전자우편주소 정보를 SendGrid EmailAddress 객체로 변환합니다. /// </summary> /// <param name="email"></param> /// <returns></returns> public static EmailAddress ToEmailAddress(this EmailAddressInfo email) { return(new EmailAddress(email.Address, email.DisplayName)); }
public ActionResult EmailAddress(EmailAddressInfo emailAddressInfo) { if (emailAddressInfo == null) { return(Json(new FeedbackInfo { Success = -1, Message = "获取实体出错" })); } if (emailAddressInfo.UserID == 0) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入用户编号" })); } if (string.IsNullOrWhiteSpace(emailAddressInfo.Name)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入名称" })); } if (string.IsNullOrWhiteSpace(emailAddressInfo.Email)) { return(Json(new FeedbackInfo { Success = -1, Message = "请输入邮箱" })); } //新建 int result = 0; if (emailAddressInfo.ID == 0) { result = Start.DatabaseProvider.Instance().InsertEmailAddress(emailAddressInfo); if (result == 1) { return(Json(new FeedbackInfo { Success = 1, Message = "添加成功" })); } else { return(Json(new FeedbackInfo { Success = -1, Message = "添加失败" })); } } else //编辑 { result = Start.DatabaseProvider.Instance().UpdateEmailAddress(emailAddressInfo); if (result == 1) { return(Json(new FeedbackInfo { Success = 1, Message = "修改成功" })); } else { return(Json(new FeedbackInfo { Success = -1, Message = "修改失败" })); } } }