public async Task <BaseResponse> FindByTypeAsync(int typeId, TypeStatisticsPageRequestViewModel req) { var query = _tsr.Find(a => a.TypeId == typeId); if (!string.IsNullOrWhiteSpace(req.Search)) { query = query.Where(a => a.Name.Contains(req.Search) || a.DataKey.Contains(req.Search)); } int Count = query.Count(); string OrderExpression = ""; if (string.IsNullOrEmpty(req.OrderBy)) { OrderExpression = "Id Asc"; } else { OrderExpression = string.Format("{0} {1}", req.OrderBy, req.OrderType); } var data = await query.OrderBy(OrderExpression).Skip((req.PageNo - 1) * req.PageSize).Take(req.PageSize).ToListAsync(); var dtos = _mapper.Map <List <TypeStatisticsData> >(data); return(new BasePageResponse <List <TypeStatisticsData> > { Success = true, Message = "获取数据成功", Count = Count, CurrentPage = req.PageNo, PageSize = req.PageSize, TotalPage = (int)Math.Ceiling((decimal)Count / req.PageSize), Data = dtos }); }
public async Task <ActionResult <BaseResponse> > GetTypeStatistics(int typeId, [FromQuery] TypeStatisticsPageRequestViewModel req) { //string user = User.Identity.Name; //if (string.IsNullOrWhiteSpace(user)) //{ // return Unauthorized("用户凭证缺失"); //} //UserMessage um = JsonConvert.DeserializeObject<UserMessage>(user); ////检查是否存在此类型配置数据 //string GroupId; //var bRet = _ts.IsExist(a => a.Id == typeId, out GroupId); //if (!bRet) //{ // return new BaseResponse { Success = false, Message = "输入的类型编号不存在" }; //} ////用户所在的组和超级管理员可以查看 //if (um.GroupId != GroupId || (!um.IsAdmin && um.Code != _config["Group"])) //{ // return Unauthorized("用户没有权限"); //} var rm = await _tss.FindByTypeAsync(typeId, req); return(rm); }