public PageModel <MessageRevice> GetMessageDetialByUserId(MessageReviceQuery mrq)
{
int pageNum = 0;
IQueryable <MessageRevice> mr = from item in base.context.MessageRevice
where item.UserId == mrq.UserId && item.MessageDetial.LanguageType == mrq.Languagetype
select item;
foreach (MessageRevice mrs in mr.ToList())
{
MessageDetial md = (from item in base.context.MessageDetial
where item.Id == mrs.MsgId
select item).FirstOrDefault();
mrs.MessageDetial.LanguageType = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString());
mrs.MessageDetial.ManagerId = 2;
mrs.MessageDetial.MessageContent = md.MessageContent;
mrs.MessageDetial.MessageTitleId = md.MessageTitleId;
if (md.MessageTitleId != 20)
{
mrs.MessageDetial.MessageTitle = ((MessageSetting.MessageModuleStatus)md.MessageTitleId).ToDescription();
}
mrs.MessageDetial.MessageTitle = md.MessageTitle;
mrs.MessageDetial.MsgType = md.MsgType;
mrs.MessageDetial.SendObj = md.SendObj;
}
if (mrq.ReadFlag != 0)
{
mr = (from a in mr where a.ReadFlag == mrq.ReadFlag select a);
}
string begin = mrq.BeginTime.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
string end = mrq.EndTime.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
if (!string.IsNullOrWhiteSpace(begin) && !begin.Equals("0001/01/01") && !string.IsNullOrWhiteSpace(end) && !end.Equals("0001/01/01"))
{
mr = (from a in mr where a.SendTime >= mrq.BeginTime && a.SendTime <= mrq.EndTime select a);
}
//mr = (from a in mr where a.IsShow == 0 select a);
foreach (MessageRevice mrs in mr.ToList())
{
ManagerInfo manaInfo = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == mrs.MessageDetial.ManagerId);
mrs.MessageDetial.SendName = (manaInfo == null ? "" : manaInfo.UserName);
UserMemberInfo userInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == mrs.UserId);
mrs.UserName = userInfo.UserName;
//mrs.MessageDetial.MessageTitle = ((MessageSetting.MessageModuleStatus)mrs.MessageDetial.MessageTitleId).ToDescription();
}
mr = mr.GetPage(out pageNum, mrq.PageNo, mrq.PageSize, (IQueryable <MessageRevice> d) =>
from o in d
orderby o.SendTime descending
select o);
return(new PageModel <MessageRevice>
{
Models = mr,
Total = pageNum
});
}
public JsonResult list(int page, int rows, int ReadFlag, string BeginTime = "", string EndTime = "")
{
MessageReviceQuery opQuery = new MessageReviceQuery();
DateTime dt;
if (DateTime.TryParse(BeginTime, out dt) && DateTime.TryParse(EndTime, out dt))
{
opQuery = new MessageReviceQuery()
{
BeginTime = DateTime.Parse(BeginTime),
EndTime = DateTime.Parse(EndTime),
ReadFlag = ReadFlag,
UserId = base.CurrentUser.Id,
Languagetype = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()),
PageNo = page,
PageSize = rows
};
}
else
{
opQuery = new MessageReviceQuery()
{
UserId = base.CurrentUser.Id,
Languagetype = int.Parse(System.Configuration.ConfigurationManager.AppSettings["Language"].ToString()),
ReadFlag = ReadFlag,
PageNo = page,
PageSize = rows
};
}
PageModel <MessageRevice> opModel = ServiceHelper.Create <IMessageDetialService>().GetMessageDetialByUserId(opQuery);
var array =
from item in opModel.Models.ToArray()
select new { Id = item.Id, SendTime = item.SendTime, MsgId = item.MsgId, MsgType = item.MessageDetial.MsgType, SendObj = item.MessageDetial.SendObj, MessageContent = item.MessageDetial.MessageContent, MessageTitle = item.MessageDetial.MessageTitle, Status = item.ReadFlag };
return(Json(new { rows = array, total = opModel.Total }));
}
