/// <summary>
/// 获取短信发送
/// </summary>
/// <param name="messageSendInfo">短信发送实体</param>
/// <param name="pageInfo">分页实体</param>
/// <returns></returns>
public IList <MessageSendInfo> GetMessageSend(MessageSendInfo messageSendInfo, PageInfo pageInfo)
{
using (DataContextDB DB = new DataContextDB())
{
IQueryable <MessageSendInfo> messageSendInfos =
(
from item in DB.GetTable <MessageSendInfo>()
orderby item.ID descending
select item
);
if (messageSendInfo != null && messageSendInfo.ID != 0)
{
messageSendInfos = messageSendInfos.Where <MessageSendInfo>(m => m.ID == messageSendInfo.ID);
}
if (messageSendInfo != null && messageSendInfo.UserID != 0)
{
messageSendInfos = messageSendInfos.Where <MessageSendInfo>(m => m.UserID == messageSendInfo.UserID);
}
if (pageInfo != null)
{
pageInfo.TotalRecord = messageSendInfos.Count();
return(messageSendInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList <MessageSendInfo>());
}
else
{
return(messageSendInfos.ToList <MessageSendInfo>());
}
}
}
public ActionResult MessageSendList(int userID = 0, int pageIndex = 1)
{
PageInfo pageInfo = new PageInfo {
PageIndex = pageIndex
};
MessageSendInfo messageSendInfo = new MessageSendInfo {
UserID = userID
};
IList <MessageSendInfo> messageSendInfos = Start.DatabaseProvider.Instance().GetMessageSend(messageSendInfo, pageInfo);
PagedList <MessageSendInfo> pagedList = new PagedList <MessageSendInfo>(messageSendInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord);
ViewBag.MessageSendInfo = messageSendInfo;
return(View(pagedList));
}
/// <summary>
/// 修改短信发送
/// </summary>
/// <param name="messageSendInfo">短信发送实体</param>
public int UpdateMessageSend(MessageSendInfo messageSendInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <MessageSendInfo>().Attach(messageSendInfo, true);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
/// <summary>
/// 添加短信发送
/// </summary>
/// <param name="messageSendInfo">短信发送实体</param>
public int InsertMessageSend(MessageSendInfo messageSendInfo)
{
using (DataContextDB DB = new DataContextDB())
{
try
{
DB.GetTable <MessageSendInfo>().InsertOnSubmit(messageSendInfo);
DB.SubmitChanges();
return(1);
}
catch (Exception e)
{
string error = e.Message;
return(-1);
}
}
}
