bug(table): 虚拟滚动模式, 搜索后会卡在骨架屏界面

[densen2014]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

虚拟滚动模式, 搜索后会卡在骨架屏界面

复现步骤

1. 搜索输入 0035 回车, (搜索一个不在第一页的数据)
2. 按Esc

另一种复现步骤

1. 搜索0035

2. 搜索一个不存在的记录
   搜索这和个关键字,其实没有结果,他还是渲染了骨架屏
   

3. 再次搜索关键字00
   会有很多条结果, 但是搜索后, 会卡住在骨架屏界面, 也可能只显示一条, 也有几率显示全部, 如果卡在这里,要再次点击搜索按钮才能刷新出来真正的结果
   

Expected Behavior

<DemoBlock Title="@Localizer["VirtualizationDynamicTitle"]"
           Introduction="@Localizer["VirtualizationDynamicIntro"]"
           Name="Dynamic">
    <section ignore>@Localizer["VirtualizationDynamicDescription"]</section>
    <Table TItem="Foo" class="table-virtualize-demo"
           IsBordered="true" IsStriped="true"
           ShowToolbar
           ShowSearch
           ShowAdvancedSearch="false"
           ScrollMode="ScrollMode.Virtual" OnQueryAsync="OnQueryAsync">
        <TableColumns>
            <TableColumn @bind-Field="@context.DateTime" Width="180" />
            <TableColumn @bind-Field="@context.Name" />
            <TableColumn @bind-Field="@context.Address" Readonly="true" />
            <TableColumn @bind-Field="@context.Education" />
            <TableColumn @bind-Field="@context.Count" />
            <TableColumn @bind-Field="@context.Complete" />
        </TableColumns>
    </Table>
</DemoBlock>
    
    private async Task<QueryData<Foo>> OnQueryAsync(QueryPageOptions options)
    {
        await Task.Delay(200);
        // 搜索
        var items = options.SearchText!=null? Items.Where(a=>a.Name!.Contains(options.SearchText)) : Items;
        // 获得搜索后的记录总数
        var count = items.Count();
        // 内存分页
        if (options.IsPage)
        {
            items = items.Skip((options.PageIndex - 1) * options.PageItems).Take(options.PageItems);
        }
        else if (options.IsVirtualScroll)
        {
            items = items.Skip(options.StartIndex).Take(options.PageItems);
        }

        return new QueryData<Foo>()
        {
            Items = items,
            TotalCount = count
        };
    }

Interactive render mode

Interactive Server (Interactive server-side rendering (interactive SSR) using Blazor Server)

Steps To Reproduce

解压替换文档文件 \BootstrapBlazor\src\BootstrapBlazor.Server\Components\Samples\Table

Table.zip

Exceptions (if any)

No response

.NET Version

NET9.0

Anything else?

No response

[bb-auto]

@densen2014 Thank you for filing this issue. In order for us to investigate this issue, please provide a minimalistic repro project that illustrates the problem.

[densen2014]

复现代码有问题 TotalCount = Items.Count 应该为 TotalCount = items.Count() . 改正后未能复现问题

先关闭

[densen2014]

复现代码已更新.

[densen2014]

应该是这里缓存计算的 _pageItems 还是上次的记录导致

查询第一次,缓存记录数是1
第二次查询,会使用缓存的记录数送到查询过程

    private async ValueTask<ItemsProviderResult<TItem>> LoadItems(ItemsProviderRequest request)
    {
        StartIndex = _isFilterTrigger ? 0 : request.StartIndex;
        _pageItems = TotalCount > 0 ? Math.Min(request.Count, TotalCount - request.StartIndex) : request.Count;
        System.Console.WriteLine($"缓存记录总数{TotalCount}");

        await QueryData();
        System.Console.WriteLine($"QueryData后记录总数{TotalCount}/ QueryItems {QueryItems.Count()}\r\n\r\n");

        return new ItemsProviderResult<TItem>(QueryItems, TotalCount);
    }

数据服务查询这里,就用了1作为take的依据,

    private async Task<QueryData<Foo>> OnQueryAsync(QueryPageOptions options)
    {
        await Task.Delay(200);
        // 搜索
        var items = options.SearchText!=null? Items.Where(a=>a.Name!.Contains(options.SearchText)) : Items;
        // 获得搜索后的记录总数
        var count = items.Count();
        System.Console.WriteLine(options.SearchText != null?$"搜索{options.SearchText},记录总数{count}":$"记录总数{count}");
        // 内存分页
        if (options.IsPage)
        {
            items = items.Skip((options.PageIndex - 1) * options.PageItems).Take(options.PageItems);
        }
        else if (options.IsVirtualScroll)
        {
            items = items.Skip(options.StartIndex).Take(options.PageItems);
        }

        return new QueryData<Foo>()
        {
            Items = items,
            TotalCount = count
        };
    }

[densen2014]

改为这样可以达到预期

    private async ValueTask<ItemsProviderResult<TItem>> LoadItems(ItemsProviderRequest request)
    {
        StartIndex = _isFilterTrigger ? 0 : request.StartIndex;
        //有搜索条件使用原始分页数
        _pageItems = (!string.IsNullOrEmpty(SearchText) && TotalCount > 0) ? Math.Min(request.Count, TotalCount - request.StartIndex) : request.Count;
        await QueryData();
        return new ItemsProviderResult<TItem>(QueryItems, TotalCount);
    }