/// <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 = "修改失败"
}));
}
}
}
