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));
}
