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