【已解决】Grid在数据库分页时树形显示问题 - FineUI 官方论坛

<body>
<form id="form1" runat="server">
<x:PageManager ID="PageManager1" runat="server" AutoSizePanelID="panel1" />
<x:Panel ID="panel1" runat="server" Layout="VBox" ShowBorder="true" ShowHeader="false">
<Items>
<x:SimpleForm ID="simpleForm1" runat="server" ShowBorder="false" ShowHeader="false">
<Items>
<x:TriggerBox ID="tbSearch" runat="server" ShowTrigger="true" OnTriggerClick="tbSearch_Click" BoxFlex="1"
Label="请输入条件：" Width="200px">
</x:TriggerBox>
</Items>
</x:SimpleForm>
<x:Grid ID="Grid1" runat="server" EnableCheckBoxSelect="true" EnableRowNumber="true"
IsDatabasePaging="true" PageSize="5" AllowPaging="true" AllowSorting="false"
ShowBorder="true" ShowHeader="true" Title="表格" BoxFlex="1" DataKeyNames="ID" OnPageIndexChange="Grid1_PageIndexChange">
<Columns>
<x:BoundField DataField="ID" HeaderText="ID" DataSimulateTreeLevelField="Level" />
<x:BoundField DataField="Name" HeaderText="Name" />
<x:BoundField DataField="ParentId" HeaderText="ParentId" />
<x:BoundField DataField="Level" HeaderText="Level" />
</Columns>
</x:Grid>
</Items>
</x:Panel>
</form>
</body>

复制代码

/// <summary>
/// 分页
/// </summary>
private int Pagination
{
get
{
if (ViewState["Pagination"] == null)
{
ViewState["Pagination"] = 0;
}
return Convert.ToInt32(ViewState["Pagination"]);
}
set
{
ViewState["Pagination"] = value;
}
}
/// <summary>
/// 查询类
/// </summary>
private QueryExample QueryE
{
get
{
if (ViewState["QueryE"] == null)
{
ViewState["QueryE"] = new QueryExample() { Name = "" };
}
return ViewState["QueryE"] as QueryExample;
}
set
{
ViewState["QueryE"] = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindExampleList();
}
}
private void BindExampleList()
{
var list = ChangePage();
Grid1.DataSource = list;
Grid1.DataBind();
}
/// <summary>
/// 获取查询分页数据
/// </summary>
private List<ExampleClass> ChangePage()
{
var list = GetExampleList();
var pageSize = this.Grid1.PageSize;//分页大小
var roots = list.FindAll(example => (this.QueryE.Name == "" && example.ParentId == 0) || (example.ParentId == 0 && example.Name.Contains(this.QueryE.Name)));//找到根节点
var pageCount = (int)(roots.Count / pageSize) + ((roots.Count % pageSize) == 0 ? 0 : 1);//总页数
var exampleList = new List<ExampleClass>();
if (roots.Count > 0)
{
var childrenList = new List<ExampleClass>();
var firstNum = pageSize * this.Pagination;
var endNum = (firstNum + pageSize) > roots.Count ? roots.Count : (firstNum + pageSize);
for (int i = firstNum; i < endNum; i++)
{
exampleList.Add(roots[i]);
childrenList = list.FindAll(example => example.ParentId == roots[i].ID);
foreach (var item in childrenList)
{//设定最多只有两层
exampleList.Add(item);
}
}
}
this.Grid1.RecordCount = roots.Count;
return exampleList;
}
protected void Grid1_PageIndexChange(object sender, FineUI.GridPageEventArgs e)
{
this.Grid1.PageIndex = e.NewPageIndex;
this.Pagination = e.NewPageIndex;
this.BindExampleList();
}
protected void tbSearch_Click(object sender, EventArgs e)
{
var keyWord = this.tbSearch.Text.Trim();
this.QueryE.Name = keyWord == null ? "" : keyWord;
this.BindExampleList();
}

复制代码