Our API needs to consider all the parameters and sort our results accordingly. In our case, this means sorting results by their name; then, if there are employees with the same name, sorting them by the age property.
\n\u6211\u4eec\u7684 API \u9700\u8981\u8003\u8651\u6240\u6709\u53c2\u6570\u5e76\u76f8\u5e94\u5730\u5bf9\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002\u5728\u6211\u4eec\u7684\u4f8b\u5b50\u4e2d\uff0c\u8fd9\u610f\u5473\u7740\u6309\u540d\u79f0\u5bf9\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f;\u7136\u540e\uff0c\u5982\u679c\u5b58\u5728\u540c\u540d\u7684\u5458\u5de5\uff0c\u5219\u6309 age \u5c5e\u6027\u5bf9\u4ed6\u4eec\u8fdb\u884c\u6392\u5e8f\u3002<\/p>\n
So, these are our employees for the IT_Solutions Ltd company:
\n\u90a3\u4e48\uff0c\u8fd9\u4e9b\u662f\u6211\u4eec IT_Solutions Ltd \u516c\u53f8\u7684\u5458\u5de5\uff1a<\/p>\n
![\"alt](\"\/images\/ultimateaspnetcorewebapi6\/1901.jpg\")
<\/p>\n
For the sake of demonstrating this example (sorting by name and then by age), we are going to add one more Jana McLeaf to our database with the age of 27. You can add whatever you want to test the results:
\n\u4e3a\u4e86\u6f14\u793a\u6b64\u793a\u4f8b\uff08\u5148\u6309\u59d3\u540d\u6392\u5e8f\uff0c\u7136\u540e\u6309\u5e74\u9f84\u6392\u5e8f\uff09\uff0c\u6211\u4eec\u5c06\u5411\u6570\u636e\u5e93\u4e2d\u518d\u6dfb\u52a0\u4e00\u4e2a\u5e74\u9f84\u4e3a 27 \u7684 Jana McLeaf\u3002\u60a8\u53ef\u4ee5\u6dfb\u52a0\u4efb\u4f55\u60a8\u60f3\u8981\u6d4b\u8bd5\u7ed3\u679c\u7684\u5185\u5bb9\uff1a<\/p>\n
https:\/\/localhost:5001\/api\/companies\/C9D4C053-49B6-410C-BC78-2D54A9991870\/employees<\/a><\/p>\n Great, now we have the required data to test our functionality properly. And of course, like with all other functionalities we have implemented so far (paging, filtering, and searching), we need to implement this to work well with everything else. We should be able to get the paginated, filtered, and sorted data, for example. Let\u2019s see one way to go around implementing this. 19.2 \u5982\u4f55\u5728 ASP.NET Core Web API \u4e2d\u5b9e\u73b0\u6392\u5e8f<\/p>\n As with everything else so far, first, we need to extend our RequestParameters class to be able to send requests with the orderBy clause in them:\u200c As you can see, the only thing we\u2019ve added is the OrderBy property and we added it to the RequestParameters class because we can reuse it for other entities. We want to sort our results by name, even if it hasn\u2019t been stated explicitly in the request. That said, let\u2019s modify the EmployeeParameters class to enable the default sorting condition for Employee if none was stated: Next, we\u2019re going to dive right into the implementation of our sorting mechanism, or rather, our ordering mechanism. One thing to note is that we\u2019ll be using the System.Linq.Dynamic.Core NuGet package to dynamically create our OrderBy query on the fly. So, feel free to install it in the Repository project and add a using directive in the RepositoryEmployeeExtensions class: Now, we can add the new extension method Sort in our RepositoryEmployeeExtensions class: Okay, there are a lot of things going on here, so let\u2019s take it step by step and see what exactly we've done. 19.3 \u5b9e\u65bd \u2013 \u5206\u6b65<\/p>\n![\"alt](\"\/images\/ultimateaspnetcorewebapi6\/1902.jpg\")
<\/p>\n
\n\u592a\u597d\u4e86\uff0c\u73b0\u5728\u6211\u4eec\u6709\u4e86\u6b63\u786e\u6d4b\u8bd5\u6211\u4eec\u7684\u529f\u80fd\u6240\u9700\u7684\u6570\u636e\u3002<\/p>\n
\n\u5f53\u7136\uff0c\u5c31\u50cf\u6211\u4eec\u5230\u76ee\u524d\u4e3a\u6b62\u5b9e\u73b0\u7684\u6240\u6709\u5176\u4ed6\u529f\u80fd\uff08\u5206\u9875\u3001\u8fc7\u6ee4\u548c\u641c\u7d22\uff09\u4e00\u6837\uff0c\u6211\u4eec\u9700\u8981\u5b9e\u73b0\u5b83\u624d\u80fd\u4e0e\u5176\u4ed6\u6240\u6709\u529f\u80fd\u5f88\u597d\u5730\u534f\u540c\u5de5\u4f5c\u3002\u4f8b\u5982\uff0c\u6211\u4eec\u5e94\u8be5\u80fd\u591f\u83b7\u53d6\u5206\u9875\u3001\u8fc7\u6ee4\u548c\u6392\u5e8f\u7684\u6570\u636e\u3002<\/p>\n
\n\u8ba9\u6211\u4eec\u770b\u770b\u5b9e\u73b0\u5b83\u7684\u65b9\u6cd5\u3002<\/p>\n19.2 How to Implement Sorting in ASP.NET Core Web API<\/h2>\n
\n\u4e0e\u5230\u76ee\u524d\u4e3a\u6b62\u7684\u5176\u4ed6\u6240\u6709\u5185\u5bb9\u4e00\u6837\uff0c\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u6269\u5c55 RequestParameters \u7c7b\uff0c\u4ee5\u4fbf\u80fd\u591f\u53d1\u9001\u5305\u542b orderBy \u5b50\u53e5\u7684\u8bf7\u6c42\uff1a<\/p>\npublic class RequestParameters { const int maxPageSize = 50; public int PageNumber { get; set; } = 1; private int _pageSize = 10; public int PageSize { get { return _pageSize; } set { _pageSize = (value > maxPageSize) ? maxPageSize : value; } } public string? OrderBy { get; set; } }<\/code><\/pre>\n
\n\u5982\u60a8\u6240\u89c1\uff0c\u6211\u4eec\u6dfb\u52a0\u7684\u552f\u4e00\u5185\u5bb9\u662f OrderBy \u5c5e\u6027\uff0c\u5e76\u5c06\u5176\u6dfb\u52a0\u5230 RequestParameters \u7c7b\u4e2d\uff0c\u56e0\u4e3a\u6211\u4eec\u53ef\u4ee5\u5c06\u5176\u91cd\u65b0\u7528\u4e8e\u5176\u4ed6\u5b9e\u4f53\u3002\u6211\u4eec\u5e0c\u671b\u6309\u540d\u79f0\u5bf9\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\uff0c\u5373\u4f7f\u8bf7\u6c42\u4e2d\u6ca1\u6709\u660e\u786e\u8bf4\u660e\u3002<\/p>\n
\n\u4e5f\u5c31\u662f\u8bf4\uff0c\u8ba9\u6211\u4eec\u4fee\u6539 EmployeeParameters \u7c7b\uff0c\u4ee5\u542f\u7528 Employee \u7684\u9ed8\u8ba4\u6392\u5e8f\u6761\u4ef6\uff08\u5982\u679c\u672a\u8bf4\u660e\uff09\uff1a<\/p>\npublic class EmployeeParameters : RequestParameters { public EmployeeParameters() => OrderBy = "name"; public uint MinAge { get; set; } public uint MaxAge { get; set; } = int.MaxValue; public bool ValidAgeRange => MaxAge > MinAge; public string? SearchTerm { get; set; } }<\/code><\/pre>\n
\n\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u6df1\u5165\u7814\u7a76\u6392\u5e8f\u673a\u5236\u7684\u5b9e\u73b0\uff0c\u6216\u8005\u66f4\u786e\u5207\u5730\u8bf4\uff0c\u6211\u4eec\u7684\u6392\u5e8f\u673a\u5236\u3002<\/p>\n
\n\u9700\u8981\u6ce8\u610f\u7684\u4e00\u70b9\u662f\uff0c\u6211\u4eec\u5c06\u4f7f\u7528 System.Linq.Dynamic.Core NuGet \u5305\u52a8\u6001\u521b\u5efa\u52a8\u6001 OrderBy \u67e5\u8be2\u3002\u56e0\u6b64\uff0c\u8bf7\u968f\u610f\u5c06\u5176\u5b89\u88c5\u5728 Repository \u9879\u76ee\u4e2d\uff0c\u5e76\u5728 RepositoryEmployeeExtensions \u7c7b\u4e2d\u6dfb\u52a0 using \u6307\u4ee4\uff1a<\/p>\nusing System.Linq.Dynamic.Core;<\/code><\/pre>\n
\n\u73b0\u5728\uff0c\u6211\u4eec\u53ef\u4ee5\u5728 RepositoryEmployeeExtensions \u7c7b\u4e2d\u6dfb\u52a0\u65b0\u7684\u6269\u5c55\u65b9\u6cd5 Sort\uff1a<\/p>\npublic static IQueryable<Employee> Sort(this IQueryable<Employee> employees, string orderByQueryString) { if (string.IsNullOrWhiteSpace(orderByQueryString)) return employees.OrderBy(e => e.Name); var orderParams = orderByQueryString.Trim().Split(','); var propertyInfos = typeof(Employee).GetProperties(BindingFlags.Public | BindingFlags.Instance); var orderQueryBuilder = new StringBuilder(); foreach (var param in orderParams) { if (string.IsNullOrWhiteSpace(param)) continue; var propertyFromQueryName = param.Split(" ")[0]; var objectProperty = propertyInfos.FirstOrDefault(pi => pi.Name.Equals(propertyFromQueryName, StringComparison.InvariantCultureIgnoreCase)); if (objectProperty == null) continue; var direction = param.EndsWith(" desc") ? "descending" : "ascending"; orderQueryBuilder.Append($"{objectProperty.Name.ToString()} {direction}, "); } var orderQuery = orderQueryBuilder.ToString().TrimEnd(',', ' '); if (string.IsNullOrWhiteSpace(orderQuery)) return employees.OrderBy(e => e.Name); return employees.OrderBy(orderQuery); }<\/code><\/pre>\n
\n\u597d\u4e86\uff0c\u8fd9\u91cc\u53d1\u751f\u4e86\u5f88\u591a\u4e8b\u60c5\uff0c\u6240\u4ee5\u8ba9\u6211\u4eec\u4e00\u6b65\u4e00\u6b65\u6765\uff0c\u770b\u770b\u6211\u4eec\u5230\u5e95\u505a\u4e86\u4ec0\u4e48\u3002<\/p>\n19.3 Implementation \u2013 Step by Step<\/h2>\n
![\"alt](\"\/images\/ultimateaspnetcorewebapi6\/1903.jpg\")
<\/p>\n![\"alt](\"\/images\/ultimateaspnetcorewebapi6\/1904.jpg\")
<\/p>\n![\"alt](\"\/images\/ultimateaspnetcorewebapi6\/1905.jpg\")
<\/p>\n