public object GetMessages( int pageNo = 1, /*页码*/ int pageSize = 10 /*每页显示数据量*/) { CheckUserLogin(); long sbid = CurrentUser.ShopBranchId; AppMessageQuery query = new AppMessageQuery(); query.ShopBranchId = sbid; query.PageNo = pageNo; query.PageSize = pageSize; query.StartTime = DateTime.Now.AddDays(-30).Date; var data = AppMessageApplication.GetMessages(query); var list = data.Models.ToList().Select(item => new { Id = item.Id, Content = item.Content, IsRead = item.IsRead, OrderPayDate = item.OrderPayDate, sendtime = item.sendtime, ShopId = item.ShopId, SourceId = item.SourceId, Title = item.Title, TypeId = item.TypeId, ShopBranchId = item.ShopBranchId, HasShopbranch = item.TypeId == 1 ? GetShopbranch(item.SourceId) : 0 }); return(new { success = true, rows = list, total = data.Total }); }
/// <summary> /// 获取消息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public QueryPageModel <AppMessagesInfo> GetMessages(AppMessageQuery query) { var sql = Context.AppMessagesInfo.AsQueryable(); if (query.ShopId.HasValue) { sql = sql.Where(d => d.ShopId == query.ShopId.Value); } if (query.ShopBranchId.HasValue) { sql = sql.Where(d => d.ShopBranchId == query.ShopBranchId.Value); } if (query.StartTime.HasValue) { sql = sql.Where(d => d.sendtime >= query.StartTime.Value); } if (query.EndTime.HasValue) { sql = sql.Where(d => d.sendtime <= query.EndTime.Value); } if (query.IsRead.HasValue) { sql = sql.Where(d => d.IsRead == query.IsRead.Value); } QueryPageModel <AppMessagesInfo> result = new QueryPageModel <AppMessagesInfo>(); int total = 0; result.Models = sql.GetPage(out total, query.PageNo, query.PageSize, (o => o.OrderByDescending(d => d.sendtime))).ToList(); result.Total = total; return(result); }
/// <summary> /// 获取消息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public QueryPageModel <AppMessageInfo> GetMessages(AppMessageQuery query) { //var sql = Context.AppMessagesInfo.AsQueryable(); var sql = DbFactory.Default.Get <AppMessageInfo>(); if (query.ShopId.HasValue) { sql.Where(d => d.ShopId == query.ShopId.Value); } if (query.ShopBranchId.HasValue) { sql.Where(d => d.ShopBranchId == query.ShopBranchId.Value); } if (query.StartTime.HasValue) { sql.Where(d => d.sendtime >= query.StartTime.Value); } if (query.EndTime.HasValue) { sql.Where(d => d.sendtime <= query.EndTime.Value); } if (query.IsRead.HasValue) { sql.Where(d => d.IsRead == query.IsRead.Value); } QueryPageModel <AppMessageInfo> result = new QueryPageModel <AppMessageInfo>(); //int total = 0; //result.Models = sql.GetPage(o => o.OrderByDescending(d => d.sendtime), out total, query.PageNo, query.PageSize).ToList(); var models = sql.OrderByDescending(d => d.sendtime).ToPagedList(query.PageNo, query.PageSize); result.Models = models; result.Total = models.TotalRecordCount; return(result); }
/// <summary> /// 获取未读消息数 /// </summary> /// <returns></returns> public object GetMessages( int pageNo = 1, /*页码*/ int pageSize = 10 /*每页显示数据量*/) { CheckUserLogin(); long shopid = CurrentUser.ShopId; AppMessageQuery query = new AppMessageQuery(); query.ShopId = shopid; query.PageNo = pageNo; query.PageSize = pageSize; query.StartTime = DateTime.Now.AddDays(-30).Date; var data = AppMessageApplication.GetMessages(query); return(new { success = true, rows = data.Models, total = data.Total }); }
/// <summary> /// 获取消息列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public static QueryPageModel <AppMessagesInfo> GetMessages(AppMessageQuery query) { return(_appMessageService.GetMessages(query)); }