/// <summary> /// 获取多个消息 /// </summary> /// <param name="messageQueryModel"></param> /// <returns></returns> public PageModel <SiteMessages> GetMessages(SiteMessagesQuery messageQueryModel) { IQueryable <SiteMessages> sitemessagelist = from item in base.context.SiteMessages select item; if (messageQueryModel.MemberId.HasValue) { sitemessagelist = from item in sitemessagelist where item.MemberId == messageQueryModel.MemberId select item; } if ((messageQueryModel.Status.HasValue) && (messageQueryModel.Status.Value != 0)) { sitemessagelist = from item in sitemessagelist where item.ReadStatus == messageQueryModel.Status select item; } if ((messageQueryModel.ReceStatus.HasValue) && (messageQueryModel.ReceStatus.Value != 0)) { sitemessagelist = from item in sitemessagelist where (int)item.ReceType == (int)messageQueryModel.ReceStatus select item; } if ((messageQueryModel.MessageModule.HasValue) && (messageQueryModel.MessageModule.Value != 0)) { sitemessagelist = from item in sitemessagelist where (int)item.MessageModule == (int)messageQueryModel.MessageModule select item; } int num = sitemessagelist.Count(); sitemessagelist = sitemessagelist.GetPage(out num, messageQueryModel.PageNo, messageQueryModel.PageSize); foreach (SiteMessages list in sitemessagelist.ToList()) { if (list.ReceType.ToDescription().Equals("采购商")) { UserMemberInfo memberInfo = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == list.MemberId && m.UserType == 3); list.ReceiveName = (memberInfo == null ? "" : memberInfo.UserName); } else if (list.ReceType.ToDescription().Equals("供应商")) { UserMemberInfo Info = context.UserMemberInfo.FirstOrDefault((UserMemberInfo m) => m.Id == list.MemberId && m.UserType == 2); list.ReceiveName = (Info == null ? "" : Info.UserName); } else if (list.ReceType.ToDescription().Equals("平台运营")) { ManagerInfo Info = context.ManagerInfo.FirstOrDefault((ManagerInfo m) => m.Id == list.MemberId && m.ShopId == 0); list.ReceiveName = (Info == null ? "" : Info.UserName); } } return(new PageModel <SiteMessages>() { Models = sitemessagelist, Total = num }); }
public JsonResult List(string Status, int page, int rows) { SiteMessagesQuery siteMessagesQuery = new SiteMessagesQuery() { PageSize = rows, PageNo = page, MemberId = base.CurrentUser.Id, }; SiteMessagesQuery siteMessagesQuery1 = siteMessagesQuery; switch (Status) { case "0": siteMessagesQuery1.Status = null; break; case "1": siteMessagesQuery1.Status = SiteMessages.Status.UnRead; break; case "2": siteMessagesQuery1.Status = SiteMessages.Status.Readed; break; } PageModel <SiteMessages> messageSetting = ServiceHelper.Create <ISiteMessagesService>().GetMessages(siteMessagesQuery1); IEnumerable <SiteMessagesModel> array = from item in messageSetting.Models.ToArray() select new SiteMessagesModel() { Status = item.ReadStatus.ToDescription(), ReceType = item.ReceType.ToDescription(), MessageModule = item.MessageModule.ToDescription(), MemberId = item.MemberId, Id = item.Id, SendTime = item.SendTime, ReadTime = item.ReadTime, MessageContent = item.MessageContent, SendName = item.SendName }; DataGridModel <SiteMessagesModel> dataGridModel = new DataGridModel <SiteMessagesModel>() { rows = array, total = messageSetting.Total }; return(Json(dataGridModel)); }
public JsonResult List(long?Id, long?MemberId, int?Status, int?ReceStatus, int?MessageModule, int page, int rows) { SiteMessages.Status? readStatus; SiteMessages.ReceiveType? receStatus; MessageSetting.MessageModuleStatus?messageModule; SiteMessagesQuery siteMessagesQuery = new SiteMessagesQuery() { PageSize = rows, PageNo = page, Id = Id, MemberId = base.CurrentUser.Id }; SiteMessagesQuery siteMessagesQuery1 = siteMessagesQuery; int?readStatus1 = Status; if (readStatus1.HasValue && readStatus1 != 0) { readStatus = new SiteMessages.Status?((SiteMessages.Status)readStatus1.GetValueOrDefault()); } else { readStatus = null; } siteMessagesQuery1.Status = readStatus; //int? receStatus1 = 2; //if (receStatus1.HasValue) //{ // receStatus = new SiteMessages.ReceiveType?((SiteMessages.ReceiveType)receStatus1.GetValueOrDefault()); //} //else //{ // receStatus = null; //} //siteMessagesQuery.ReceStatus = receStatus; int?messageModule1 = MessageModule; if (messageModule1.HasValue && messageModule1 != 0) { messageModule = new MessageSetting.MessageModuleStatus?((MessageSetting.MessageModuleStatus)MessageModule.GetValueOrDefault()); } else { messageModule = null; } siteMessagesQuery1.MessageModule = messageModule; PageModel <SiteMessages> messageSetting = ServiceHelper.Create <ISiteMessagesService>().GetMessages(siteMessagesQuery1); IEnumerable <SiteMessagesModel> array = from item in messageSetting.Models.ToArray() select new SiteMessagesModel() { Status = item.ReadStatus.ToDescription(), ReceType = item.ReceType.ToDescription(), MessageModule = item.MessageModule.ToDescription(), MemberId = item.MemberId, Id = item.Id, ReceiveName = item.ReceiveName, SendTime = item.SendTime, ReadTime = item.ReadTime, MessageContent = item.MessageContent, SendName = item.SendName }; DataGridModel <SiteMessagesModel> dataGridModel = new DataGridModel <SiteMessagesModel>() { rows = array, total = messageSetting.Total }; return(Json(dataGridModel)); }