コード例 #1
0
        /// <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
            });
        }
コード例 #2
0
        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));
        }
コード例 #3
0
        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));
        }