选择器在表格组件编辑对话框不能级联选择

[njroyin]

Is there an existing issue for this?

• I have searched the existing issues

Describe the bug

如图在表格组件编辑对话框能，不能实现选择所属系统,级联选择的上级菜单选项不能及时刷新数据，导致不能选择

Expected Behavior

在表格组件编辑对话框里能实现选择器级联选择的功能

Interactive render mode

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

Steps To Reproduce

`@using System.ComponentModel
@using System.ComponentModel.DataAnnotations
@using Masuit.Tools.Systems

@page "/Platform/Menu"

<Textarea @bind-Value="@context.Remark" ShowLabel="true" rows="6"></Textarea>

@code {

[Inject]
private IFreeSql<PlatformDB>? FreeSql { get; set; }
[Inject]
[NotNull]
private ILogger<MenuPage>? Logger { get; set; } 

private static IEnumerable<int> PageItemsSource => new int[] { 10, 50, 100 };

private List<SelectedItem> SystemSearchItems { get; set; } = new List<SelectedItem>() { };

private List<SelectedItem> MenuSearchItems { get; set; } = new List<SelectedItem>() { };

private MenuVm MenuSearchModel { get; set; }= new MenuVm();
  
protected override async Task OnInitializedAsync()
{
    await base.OnInitializedAsync();

    if (FreeSql == null)
    {
        throw new Exception("访问数据初始化失败");
    }

    SystemSearchItems.Clear();
    //SystemSearchItems.Add(new SelectedItem("","选择所属系统"));
    SystemSearchItems.AddRange( await FreeSql.Select<Modules.System>()
        .OrderBy(o => o.DisplaySortNo)
        .OrderBy(o=>o.Code)
        .ToListAsync<SelectedItem>(s => new SelectedItem(s.Id, s.Name)));
     

}


private async Task<bool> OnSaveAsync(MenuVm vm, ItemChangedType changedType)
{ 
    try
    {
        if (FreeSql == null)
        {
            throw new Exception("访问数据初始化失败");
        }
        var affrows = 0;
        switch (changedType)
        {
            case ItemChangedType.Add:
                affrows = await FreeSql
                    .Insert<Modules.Menu>(new Modules.Menu() { Id = SnowFlake.NewId, Code = vm.Code, Name = vm.Name, Remark = vm.Remark, DisplaySortNo = vm.DisplaySortNo,ParentId = vm.ParentId,Icon = vm.Icon,SystemId =  vm.SystemId ,Url = vm.Url})
                    .IgnoreColumns(c=>c.Rowversion)
                    .ExecuteAffrowsAsync();
                if (affrows == 0)
                {
                    throw new Exception("写入数据失败:写入记录0条");
                } 
                break;
            case ItemChangedType.Update:
                affrows = await FreeSql.Select<Modules.Menu>()
                    .Where(w => w.Id == vm.Id && w.Rowversion == vm.Rowversion)
                    .ToUpdate().Set(s => new  Modules.Menu() { Code = vm.Code, Name = vm.Name, Remark = vm.Remark, DisplaySortNo = vm.DisplaySortNo,ParentId = vm.ParentId,Icon = vm.Icon,SystemId = vm.SystemId,Url = vm.Url })
                    .ExecuteAffrowsAsync();
                if (affrows == 0)
                {
                    throw new Exception("更新数据失败:更新记录0条");
                }
                break;
            default:
                break;
        }

        return true;
    }
    catch (Exception ex)
    {
        Logger?.LogError(ex, "菜单管理保存错误"); 
        return false;
    }
}

private async Task<bool> OnDeleteAsync(IEnumerable<MenuVm> vms) 
{ 
    using (var uow = FreeSql.CreateUnitOfWork())
    { 
        try
        {
            if (FreeSql == null)
            {
                throw new Exception("访问数据初始化失败");
            }
            var affrows = await FreeSql.Select<Modules.Menu>()
                .Where(w => vms.Select(s => s.Id).Contains(w.Id) && vms.Select(s => s.Rowversion).Contains(w.Rowversion))
                .ToDelete()
                .ExecuteAffrowsAsync();
            if (affrows != vms.Count())
            {
                throw new Exception("删除数据失败:删除记录不一致");
            }
            uow.Commit();
            return true;
        }
        catch (Exception ex)
        {
            uow.Rollback();
            Logger?.LogError(ex, "菜单管理删除错误");
           return false;
        }
    }
}

private async Task<QueryData<MenuVm>> OnQueryAsync(QueryPageOptions options)
{
    if (FreeSql == null)
    {
        throw new Exception("访问数据初始化失败");
    }

    var data = await FreeSql.Select<Modules.Menu, Modules.System>()
        .InnerJoin((t1,t2)=>t1.SystemId==t2.Id)
        .WhereIf(!string.IsNullOrWhiteSpace(MenuSearchModel.SystemId), w => w.t1.SystemId == MenuSearchModel.SystemId)
        .WhereIf(!string.IsNullOrWhiteSpace(MenuSearchModel.Code), w => w.t1.Code.Contains(MenuSearchModel.Code))
        .WhereIf(!string.IsNullOrWhiteSpace(MenuSearchModel.Name), w => w.t1.Name.Contains(MenuSearchModel.Name))
        .Take(options.PageItems).Skip(options.PageIndex - 1 * options.PageItems)
        .OrderBy(o => o.t2.DisplaySortNo)
        .OrderBy(o => o.t1.DisplaySortNo)
        .OrderBy(o=>o.t1.Code)
        .ToListAsync<MenuVm>(l => new MenuVm() { Code = l.t1.Code, DisplaySortNo = l.t1.DisplaySortNo, Icon = l.t1.Icon, Id = l.t1.Id, Name = l.t1.Name, ParentId = l.t1.ParentId, Remark = l.t1.Remark, Rowversion = l.t1.Rowversion, SystemId = l.t1.SystemId, SystemName = l.t2.Name ,Url = l.t1.Url});
    return new QueryData<MenuVm>()
    {
        Items = data ?? new List<MenuVm>(),
        TotalCount = data?.Count ?? 0
    };
}


private Task OnResetSearchAsync(MenuVm vm)
{
    vm.Code = string.Empty;
    vm.Name = string.Empty;
    vm.SystemId = string.Empty;
    return Task.CompletedTask; 
}

private static Task<IEnumerable<TableTreeNode<MenuVm>>> TreeNodeConverter(IEnumerable<MenuVm> items)
{
    // 构造树状数据结构
    var ret = BuildTreeNodes(items, null);
    return Task.FromResult(ret);

    IEnumerable<TableTreeNode<MenuVm>> BuildTreeNodes(IEnumerable<MenuVm> items, string? parentId)
    {
        var ret = new List<TableTreeNode<MenuVm>>();
        ret.AddRange(items.Where(i => i.ParentId == parentId).Select((foo, index) => new TableTreeNode<MenuVm>(foo)
        {
            // 此处为示例，假设偶行数据都有子数据
            HasChildren = items.Any(a=>a.ParentId == foo.Id),
            // 如果子项集合有值 则默认展开此节点
            IsExpand = items.Any(i => i.ParentId == foo.Id),
            // 获得子项集合
            Items = BuildTreeNodes(items.Where(i => i.ParentId == foo.Id), foo.Id)
        }));
        return ret;
    }
}

class MenuVm
{ 
    [AutoGenerateColumn(Visible = false,IsVisibleWhenAdd = false,IsVisibleWhenEdit = false)]
    public string Id { get; set; }
    
    [DisplayName("菜单编码")]
    [Required(ErrorMessage = "请输入菜单编码")]
    [AutoGenerateColumn(Searchable = true)]
    public string Code { get; set; }
    
    [DisplayName("菜单名称")]
    [Required(ErrorMessage = "请输入菜单名称")]
    [AutoGenerateColumn(Searchable = true)] 
    public string Name { get; set; }
     
    [DisplayName("备注")]
    public string Remark { get; set; }
    
    [DisplayName("显示序号")] 
    public decimal DisplaySortNo { get; set; }
    
    [AutoGenerateColumn(Visible = false,IsVisibleWhenAdd = false,IsVisibleWhenEdit = false)]
    public  byte[] Rowversion { get; set; }
    
     
    [AutoGenerateColumn(Visible = false)]
    public string ParentId { get; set; }

  
    [AutoGenerateColumn(Visible = false)]
    public string SystemId { get; set; }

    [DisplayName("隶属系统")]
    public string SystemName { get; set; }

    [DisplayName("菜单图标")]
    public string Icon { get; set; }
     
    [DisplayName("菜单路径")]
    [Required(ErrorMessage = "请输入菜单路径")]
    public string Url { get; set; }
}

private  async Task OnSelectedItemChanged(SelectedItem arg)
{
    if (FreeSql == null)
    {
        return;
    }

    MenuSearchItems.Clear();
    MenuSearchItems.Add(new SelectedItem("", "选择上级菜单"));
    MenuSearchItems.AddRange(await FreeSql.Select<Modules.Menu>()
        .WhereIf(!string.IsNullOrWhiteSpace(arg.Value), w => w.SystemId == arg.Value)
        .OrderBy(o => o.DisplaySortNo)
        .OrderBy(o => o.Code)
        .ToListAsync<SelectedItem>(s => new(s.Id, s.Name)));
     
}


private Task<MenuVm> OnAddAsync()
{
    return Task.FromResult(new MenuVm() { SystemId = MenuSearchModel.SystemId });
}

}
`

Exceptions (if any)

No response

.NET Version

NET9.0

Anything else?

No response

[bb-auto[bot]]

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

[njroyin]

代码文件
MenuPage.razor.zip

[ArgoZhang]

@njroyin

• 请遵守 Issue 要求
• 请认真读相关文档的注意事项

[cqths]

他的意思我懂，就是想少写点代码，除了 级联 的内容，其余想自动生成。封装成独立组件时，现在是写了代码的属性才会有，没写的就没有。大佬，有没有可能，没有写代码的属性，也自动生成 ？

[cqths]

哈哈，这个我也碰到过

[ArgoZhang]

@cqths 他的意思我也明白的。我只是想强调一下态度，给个 razor 文件的压缩包。根本不认真，大片代码直接贴上来，也不规范。总之一句话就是方便自己难为他人。我个人非常不理解这种行为。

[njroyin]

谢谢，我按你说的文档说明实现了。