public static List <Dto.SysMessage.PrivateMyMessageList> GetPrivateMyMessageList(int userId)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.SysMessage.PrivateMyMessageList();
var tb = from p in db.Table <Sys.Entity.tbSysMessage>()
join m in db.Table <Sys.Entity.tbSysMessageUser>() on p.Id equals m.tbSysMessage.Id
where m.tbSysUser.Id == userId && m.IsRead == false && p.IsPermit == true
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.MessageTitle.Contains(vm.SearchText));
}
var PrivateMessageMyList = (from p in tb
orderby p.InputDate descending
select new Dto.SysMessage.PrivateMyMessageList
{
Id = p.Id,
InputDate = p.InputDate,
IsEmail = p.IsEmail,
IsSms = p.IsSms,
MessageContent = p.MessageContent,
MessageTitle = p.MessageTitle,
SysUserName = p.tbSysUser.UserName,
Url = p.Url
}).ToList();
return(PrivateMessageMyList);
}
}
public ActionResult PrivateMyMessageList()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.SysMessage.PrivateMyMessageList();
var tb = from p in db.Table <Sys.Entity.tbSysMessageUser>()
join m in db.Table <Sys.Entity.tbSysMessage>() on p.tbSysMessage.Id equals m.Id
where p.tbSysUser.Id == Code.Common.UserId && m.IsPermit == true
select new Dto.SysMessage.PrivateMyMessageList
{
Id = p.Id,
InputDate = m.InputDate,
IsEmail = m.IsEmail,
IsSms = m.IsSms,
MessageContent = m.MessageContent,
MessageTitle = m.MessageTitle,
SysUserName = m.tbSysUser.UserName,
MessageId = p.tbSysMessage.Id,
Url = m.Url,
IsRead = p.IsRead,
ReadDate = p.ReadDate
};
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.MessageTitle.Contains(vm.SearchText));
}
vm.PrivateMessageMyList = (from p in tb
orderby p.InputDate descending
select p).ToPageList(vm.Page);
return(View(vm));
}
}
public ActionResult PrivateMyMessageList(Models.SysMessage.PrivateMyMessageList vm)
{
return(Code.MvcHelper.Post(null, Url.Action("PrivateMyMessageList",
new
{
searchText = vm.SearchText,
pageSize = vm.Page.PageSize,
pageCount = vm.Page.PageCount,
pageIndex = vm.Page.PageIndex
})));
}
