首页 > 作文

.NET 6开发TodoList应用之实现数据塑形

更新时间:2023-04-04 10:06:39 阅读：评论：0

需求

在查询的场景中，还有一类需a的伴随矩阵求不是很常见，就是在前端请求中指定返回的字段，所以关于搜索的最后一个主题我们就来演示一下关于数据塑形（data shaping）。

目标

实现数据塑形搜索请求。

原理与思路

对于数据塑形来说，我们需要定义一些接口和泛型类实现来完成通用的功能，然后修改对应的查询请求，实现具体的功能。

实现

定义通用接口和泛型类实现

idatashaper.cs

using system.dynamic;namespace todolist.application.common.interfaces;public interface idatashaper<t>{    ienumerable<expandoobject> shapedata(ienumerable<t> entities, string fieldstring);    expandoobject shapedata(t entity, string fieldstring);}

并实现通用的功能：

datashaper.cs

using system.dynamic;using system.reflection;using todolist.application.common.interfaces;namespace todolist.application.common;public class datashaper<t> : idatashaper<t> where t : class{    public propertyinfo[] properties { get; t; }    public datashaper()    {        properties = typeof(t).getproperties(bindingflags.public | bindingflags.instance);    }    public ienumerable<expandoobject> shapedata(ienumerable<t> entities, string? fieldstring)    {        var requiredproperties = getrequiredproperties(fieldstring);        return getdata(entities, requiredproperties);    }    public expandoobject shapedata(t entity, string? fieldstring)    {        var requiredproperties = getrequiredproperties(fieldstring);        return getdataforentity(entity, requiredproperties);    }    private ienumerable<propertyinfo> getrequiredproperties(string? fieldstring)    {        var requiredproperties = new list<propertyinfo>();        if (!string.isnullorempty(fieldstring))        {            var fields = fieldstring.split(',', stringsplitoptions.removeemptyentries);            foreach (var field in fields)            {                var property = properties.firstordefault(pi => pi.name.equals(field.trim(), stringcomparison.invariantcultureignoreca));                if (property == null)                {                    continue;                }                requiredproperties.add(property);            }        }        el        {            requiredproperties = properties.tolist();        }        return requiredproperties;    }    private ienumerable<expandoobject> getdata(ienumerable<t> entities, ienumerable<propertyinfo> requiredproperties)    {        return entities.lect(entity => getdataforentity(entity, requiredproperties)).tolist();    }    private expandoobject getdataforentity(t entity, ienumerable<propertyinfo> requiredproperties)    {        var shapedobject =人体元素含量排名 new expandoobject();        foreach (var property in requiredproperties)        {            var objectpropertyvalue = property.getvalue(entity);            shapedobject.tryadd(property.name, objectpropertyvalue);        }        return shapedobject;    }}

定义扩展方法

为了使我们的handle方法调用链能够直接应用，我们在application/extensions中新增一个datashaperextensions：

datashaperextensions.cs

using system.dynamic;using todolist.application.common.interfaces;namespace todolist.application.common.extensions;public static class datashaperextensions{    public static ienumerable<expandoobject> shapedata<t>(this ienumerable<t> entities, idatashaper<t> shaper, string? fieldstring)    {        return shaper.shapedata(entities, fieldstring);    }}

然后再对我们之前写的mappingextensions静态类中添加一个方法：

mappingextensions.cs

// 省略其他...public static paginatedlist<tdestination> paginatedlistfromenumerable<tdestination>(this ienumerable<tdestination> entities, int pagenumber, int pagesize){    return paginatedlist<tdestination>.create(entities, pagenumber, pagesize);   }

添加依赖注入

在application的dependencyinjection.cs中添加依赖注入：

dependencyinjection.cs

// 省略其他rvices.addscoped(typeof(idatashaper<>), typeof(datashaper<>));

修改查询请求和controller接口

我们在实现排序的基础上增加一个字段用于指明数据塑形字段并对应修改handle方法：

gettodoitemswithconditionquery.cs

using system.dynamic;using automapper;using automapper.queryableextensions;using mediatr;using todolist.application.common.extensions;using todolist.application.common.interfaces;using todolist.application.common.mappings;using todolist.application.common.models;using todolist.application.todoitems.specs;using todolist.domain.entities;using todolist.domain.enums;namespace todolist.application.todoitems.queries.gettodoitems;public class gettodoitemswithconditionquery : irequest<paginatedlist<expandoobject>>{    public guid listid { get; t; }    public bool? done { get; t; }    public string? title { get; t; }    // 前端指明需要返回的字段    public string? fields { get; t; }    public prioritylevel? prioritylevel { get; t; }    public string? sortorder { get; t; } = "title_asc";    public int pagenumber { get; t; } = 1;    public int pagesize { get; t; } = 10;}public class gettodoitems变上限积分求导withconditionqueryhandler : irequesthandler<gettodoitemswithconditionquery, paginatedlist<expandoobject>>{    private readonly irepository<todoitem> _repository;    private readonly imapper _mapper;    private readonly idatashaper<todoitemdto> _shaper;    public gettodoitemswithconditionqueryhandler(irepository<todoitem> repository, imapper mapper, idatashaper<todoitemdto> shaper)    {        _repository = repository;        _mapper = mapper;        _shaper = shaper;    }    public task<paginatedlist<expandoobject>> handle(gettodoitemswithconditionquery request, cancellationtoken cancellationtoken)    {        var spec = new todoitemspec(request);        return task.fromresult(            _repository                .getasqueryable(spec)   学校里的新鲜事             .projectto<todoitemdto>(_mapper.configurationprovider)                .anumerable()                // 进行数据塑形和分页返回                .shapedata(_shaper, request.fields)                .paginatedlistfromenumerable(request.pagenumber, request.pagesize)            );    }}

对应修改controller：

todoitemcontroller.cs

[httpget]public async task<apirespon<paginatedlist<expandoobject>>> gettodoitemswithcondition([fromquery] gettodoitemswithconditionquery query){    return apirespon<paginatedlist<expandoobject>>.success(await _mediator.nd(query));}