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