我已经整理好了,如果有人需要的话,就在这里。
无限行模型需要我在 onGridReady 事件中定义的数据源,如下所示:
const dataSource = {
rowCount: null,
getRows: (params) => {
this.svc.GetDrivingData(params.startRow, params.endRow, params.sortModel, params.filterModel)
.subscribe((d) => {
// console.log(JSON.stringify(d, null, 4));
params.successCallback(d, null);
});
}
};
然后 GetDrivingData 调用 Web Api:
GetDrivingData(startRow: number, endRow: number,
sortModel: any, filterModel: any): Observable<DrivingData[]>
{
const body = {
startRow,
endRow,
sortModel,
filterModel
};
return this.httpClient.post<DrivingData[]>(`${this.baseUrl}/api/carfleet/DrivingDataPocoLo/GetDrivingData`, body);
}
最后,在服务器端需要对filterModel和sortModel进行一些处理。
以下代码根本没有优化,它是filterModel不同值的演示。
例如,如果您在 ag-grid 中选择第二个逻辑运算符,JSON 会发生更改并包含带有logicOperator 参数的条件1 和条件2 对象。
该代码可能包含错误,因为我没有测试所有可能的组合。
此外,该代码使用 System.DynamicLinq。
[HttpPost("[action]")]
public IActionResult GetDrivingData([FromBody] GridOperationsModel gom)
{
var query = ctx.DrivingData.AsQueryable();
Func<string, FilterModel, List<object>, string> getConditionFromModel =
(string colName, FilterModel model, List<object> values) =>
{
string modelResult = "";
switch (model.filterType)
{
case "text":
switch (model.type)
{
case "equals":
modelResult = $"{colName} = \"{model.filter}\"";
break;
case "notEqual":
modelResult = $"{colName} = \"{model.filter}\"";
break;
case "contains":
modelResult = $"{colName}.Contains(@{values.Count})";
values.Add(model.filter);
break;
case "notContains":
modelResult = $"!{colName}.Contains(@{values.Count})";
values.Add(model.filter);
break;
case "startsWith":
modelResult = $"{colName}.StartsWith(@{values.Count})";
values.Add(model.filter);
break;
case "endsWith":
modelResult = $"!{colName}.StartsWith(@{values.Count})";
values.Add(model.filter);
break;
}
break;
case "number":
switch (model.type)
{
case "equals":
modelResult = $"{colName} = {model.filter}";
break;
case "notEqual":
modelResult = $"{colName} <> {model.filter}";
break;
case "lessThan":
modelResult = $"{colName} < {model.filter}";
break;
case "lessThanOrEqual":
modelResult = $"{colName} <= {model.filter}";
break;
case "greaterThan":
modelResult = $"{colName} > {model.filter}";
break;
case "greaterThanOrEqual":
modelResult = $"{colName} >= {model.filter}";
break;
case "inRange":
modelResult = $"({colName} >= {model.filter} AND {colName} <= {model.filterTo})";
break;
}
break;
case "date":
values.Add(model.dateFrom);
switch (model.type)
{
case "equals":
modelResult = $"{colName} = @{values.Count - 1}";
break;
case "notEqual":
modelResult = $"{colName} <> @{values.Count - 1}";
break;
case "lessThan":
modelResult = $"{colName} < @{values.Count - 1}";
break;
case "lessThanOrEqual":
modelResult = $"{colName} <= @{values.Count - 1}";
break;
case "greaterThan":
modelResult = $"{colName} > @{values.Count - 1}";
break;
case "greaterThanOrEqual":
modelResult = $"{colName} >= @{values.Count - 1}";
break;
case "inRange":
values.Add(model.dateTo);
modelResult = $"({colName} >= @{values.Count - 2} AND {colName} <= @{values.Count - 1})";
break;
}
break;
}
return modelResult;
};
foreach (var f in gom.filterModel)
{
string condition, tmp;
List<object> conditionValues = new List<object>();
if (!string.IsNullOrWhiteSpace(f.Value.logicOperator))
{
tmp = getConditionFromModel(f.Key, f.Value.condition1, conditionValues);
condition = tmp;
tmp = getConditionFromModel(f.Key, f.Value.condition2, conditionValues);
condition = $"{condition} {f.Value.logicOperator} {tmp}";
}
else
{
tmp = getConditionFromModel(f.Key, f.Value, conditionValues);
condition = tmp;
}
if (conditionValues.Count == 0) query = query.Where(condition);
else query = query.Where(condition, conditionValues.ToArray());
}
foreach (var s in gom.sortModel)
{
switch (s.sort)
{
case "asc":
query = query.OrderBy(s.colId);
break;
case "desc":
query = query.OrderBy($"{s.colId} descending");
break;
};
};
if (gom.sortModel.Count() == 0)
{
query = query.OrderBy(x => x.Oid);
}
query = query
.Include(dd => dd.CarNavigation)
.Include(dd => dd.DriverNavigation)
.Skip(gom.startRow)
.Take(gom.endRow - gom.startRow);
var result = query
.AsNoTracking()
.ToArray();
return Ok(result);
}