/// <summary>
/// 修改邮件
/// </summary>
/// <param name="emailInfo">邮件实体</param>
public int UpdateEmail(EmailInfo emailInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable<EmailInfo>().Attach(emailInfo, true);
DB.SubmitChanges();
return 1;
}
catch (Exception e)
{
string error = e.Message;
return -1;
}
}
}
/// <summary>
/// 添加邮件
/// </summary>
/// <param name="emailInfo">邮件实体</param>
public int InsertEmail(EmailInfo emailInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable<EmailInfo>().InsertOnSubmit(emailInfo);
DB.SubmitChanges();
return 1;
}
catch (Exception e)
{
string error = e.Message;
return -1;
}
}
}
/// <summary>
/// 获取邮件
/// </summary>
/// <param name="emailInfo">邮件实体</param>
/// <param name="pageInfo">分页实体</param>
/// <returns></returns>
public IList<EmailInfo> GetEmail(EmailInfo emailInfo, PageInfo pageInfo)
{
using (DataContextDB DB = new DataContextDB())
{
IQueryable<EmailInfo> emailInfos =
(
from item in DB.GetTable<EmailInfo>()
orderby item.ID descending
select item
);
if (emailInfo != null && emailInfo.ID != 0)
emailInfos = emailInfos.Where<EmailInfo>(m => m.ID == emailInfo.ID);
if (emailInfo != null && emailInfo.UserID != 0)
emailInfos = emailInfos.Where<EmailInfo>(m => m.UserID == emailInfo.UserID);
if (pageInfo != null)
{
pageInfo.TotalRecord = emailInfos.Count();
return emailInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList<EmailInfo>();
}
else
return emailInfos.ToList<EmailInfo>();
}
}
public ActionResult Email(EmailInfo emailInfo)
{
if (emailInfo == null) return Json(new FeedbackInfo { Success = -1, Message = "获取实体出错" });
if (emailInfo.UserID == 0) return Json(new FeedbackInfo { Success = -1, Message = "请输入用户编号" });
if (string.IsNullOrWhiteSpace(emailInfo.Subject)) return Json(new FeedbackInfo { Success = -1, Message = "请输入主题" });
if (string.IsNullOrWhiteSpace(emailInfo.Memo)) return Json(new FeedbackInfo { Success = -1, Message = "请输入内容" });
//新建
int result = 0;
if (emailInfo.ID == 0)
{
result = Start.DatabaseProvider.Instance().InsertEmail(emailInfo);
if (result == 1)
return Json(new FeedbackInfo { Success = 1, Message = "添加成功" });
else
return Json(new FeedbackInfo { Success = -1, Message = "添加失败" });
}
else //编辑
{
result = Start.DatabaseProvider.Instance().UpdateEmail(emailInfo);
if (result == 1)
return Json(new FeedbackInfo { Success = 1, Message = "修改成功" });
else
return Json(new FeedbackInfo { Success = -1, Message = "修改失败" });
}
}
public ActionResult Email(int? id)
{
EmailInfo emailInfo = null;
if (id != null && id.Value != 0) emailInfo = Start.DatabaseProvider.Instance().GetEmailByID(id.Value);
if (emailInfo == null) emailInfo = new EmailInfo();
return View(emailInfo);
}
public ActionResult EmailList(int userID = 0, int pageIndex = 1)
{
PageInfo pageInfo = new PageInfo { PageIndex = pageIndex };
EmailInfo emailInfo = new EmailInfo { UserID = userID };
IList<EmailInfo> emailInfos = Start.DatabaseProvider.Instance().GetEmail(emailInfo, pageInfo);
PagedList<EmailInfo> pagedList = new PagedList<EmailInfo>(emailInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord);
ViewBag.EmailInfo = emailInfo;
return View(pagedList);
}