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