|
<div class="col-lg-12 control-section">
<SfQueryBuilder
@ref="querybuilder" TValue="Order"
DataSource="@Orders">
<QueryBuilderEvents TValue="Order"
RuleChanged="updateRule"></QueryBuilderEvents>
</SfQueryBuilder>
</div>
<div class="col-lg-12 control-section">
<div
class="content-wrapper">
<div
class="row">
<SfGrid
DataSource="@gridData" AllowPaging="true">
<GridEvents TValue="Order"></GridEvents>
<GridColumns>
<GridColumn Field=@nameof(Order.OrderID) HeaderText="Order
ID" TextAlign="TextAlign.Right"
Width="120"></GridColumn>
<GridColumn Field=@nameof(Order.CustomerID)
HeaderText="Customer Name"
Width="150"></GridColumn>
<GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order
Date" Format="d"
Type="Syncfusion.Blazor.Grids.ColumnType.Date"
TextAlign="TextAlign.Right"
Width="130"></GridColumn>
<GridColumn Field=@nameof(Order.Freight)
HeaderText="Freight" Format="C2"
TextAlign="TextAlign.Right"
Width="120"></GridColumn>
</GridColumns>
</SfGrid>
</div>
</div>
</div>
@code{
private
SfQueryBuilder<Order> querybuilder;
public
List<Order> gridData;
public class Order
{
public int?
OrderID { get; set; }
public string
CustomerID { get; set; }
public DateTime?
OrderDate { get; set; }
public double?
Freight { get; set; }
}
private
List<Order> Orders { get; set; }
protected override
void OnInitialized()
{
Orders =
Enumerable.Range(1, 75).Select(x => new Order()
{
OrderID =
1000 + x,
CustomerID
= (new string[] { "ALFKI", "ANANTR", "ANTON",
"BLONP", "BOLID" })[new Random().Next(5)],
Freight =
2.1 * x,
OrderDate
= DateTime.Now.AddDays(-x),
}).ToList();
gridData = Orders;
}
private
List<RuleModel> importRules = new List<RuleModel>()
{
new RuleModel {
Label="CustomerID", Field="CustomerID",
Type="String", Operator="equal", Value="BOLID"
}
};
private async Task
updateRule(Syncfusion.Blazor.QueryBuilder.RuleChangeEventArgs args)
{
if
(querybuilder.GetValidRules().Rules.Count > 0)
{
gridData =
querybuilder.GetFilteredRecords().ToList();
} else
{
gridData = Orders;
}
StateHasChanged();
}
private async Task
click()
{
querybuilder.Reset();
await updateRule(null!);
}
}
|
