Example #1
0
        public async Task <BaseResponse> FindByType(int typeId, TypeConfigPageRequestViewModel req)
        {
            var query = _tc.Find(a => a.TypeId == typeId);

            if (!string.IsNullOrWhiteSpace(req.Search))
            {
                query = query.Where(a => a.DataName.Contains(req.Search) || a.DataType.Contains(req.Search) || a.DataValue.Contains(req.Search));
            }
            int    Count           = query.Count();
            string OrderExpression = "";

            if (string.IsNullOrEmpty(req.OrderBy))
            {
                OrderExpression = "Id Asc";
                //UserQuery = UserQuery.OrderBy(a => a.Id);
            }
            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 <TypeConfigData> >(data);

            return(new BasePageResponse <List <TypeConfigData> >
            {
                Success = true,
                Message = "获取数据成功",
                Count = Count,
                CurrentPage = req.PageNo,
                PageSize = req.PageSize,
                TotalPage = (int)Math.Ceiling((decimal)Count / req.PageSize),
                Data = dtos
            });
        }
Example #2
0
        public async Task <ActionResult <BaseResponse> > GetByType(int typeId, [FromQuery] TypeConfigPageRequestViewModel req)
        {
            var rm = await _tc.FindByType(typeId, req);

            return(rm);
        }