剑道网格数据取决于另一个剑道网格结果UI为Asp.净MVC



我有两个剑道网格(UI为Asp。Net MVC)在我的页面上。第一个网格使用控制器的动作方法从数据库获得结果,该控制器在网格初始化时绑定(我猜)。第二个网格应该从第一个网格中获取列的结果,并作为参数传递给第二个网格,第二个网格应该将这些参数传递给绑定到第二个网格的另一个控制器的操作方法。我尝试使用autobind(false),但是没有用。请建议。

请尝试使用下面的代码片段。

<<p> 视图/strong>
@(Html.Kendo().Grid<MvcApplication1.Models.TestModel>()
    .Name("Grid")
    .Columns(columns =>
    {
        columns.Bound(e => e.ID);
        columns.Bound(e => e.Name);
    })
    .DataSource(dataSource => dataSource
        .Ajax()
        .Read(read => read.Action("GetData", "Home"))
     )
     .Events(events => events.Change("onChange"))
      .Selectable(selectable => selectable
            .Mode(GridSelectionMode.Single))
)
@(Html.Kendo().Grid<MvcApplication1.Models.ChildModel>()
    .Name("ChildGrid")
    .Columns(columns =>
    {
        columns.Bound(e => e.ChildID);
        columns.Bound(e => e.ChildName);
    })
    .DataSource(dataSource => dataSource
        .Ajax()
        .Read(read => read.Action("GetChildData", "Home").Data("GetData"))
     )
)
<script>
    var ID = 0;
    var Name = "";
    function onChange(arg) {
        ID = this.dataItem(this.select()).ID;
        Name = this.dataItem(this.select()).Name;
        $('#ChildGrid').data('kendoGrid').dataSource.read();
        $('#ChildGrid').data('kendoGrid').refresh();
    }
    function GetData() {
        return {
            ID: ID,
            Name: Name
        };
    }
</script>
控制器

public ActionResult GetChildData([DataSourceRequest] DataSourceRequest request, int ID, string Name)
{
    List<ChildModel> lst = new List<ChildModel>();
    if (ID == 0)
    {
        return Json(lst.ToDataSourceResult(request));
    }
    string str = ":" + ID + "_" + Name;

    lst.Add(new ChildModel() { ChildID = 1, ChildName = "Name1" + str });
    lst.Add(new ChildModel() { ChildID = 2, ChildName = "Name2" + str });
    lst.Add(new ChildModel() { ChildID = 3, ChildName = "Name3" + str });
    return Json(lst.ToDataSourceResult(request));
}
public ActionResult GetData([DataSourceRequest] DataSourceRequest request)
{
    List<TestModel> lst = new List<TestModel>();
    lst.Add(new TestModel() { ID = 1, Name = "Name1", MyDate = DateTime.Now });
    lst.Add(new TestModel() { ID = 2, Name = "Name2", MyDate = DateTime.Now });
    lst.Add(new TestModel() { ID = 3, Name = "Name3", MyDate = DateTime.Now });
    return Json(lst.ToDataSourceResult(request));
}

namespace MvcApplication1.Models
{
    public class TestModel
    {
        public int ID { get; set; }
        public string Name { get; set; }
        [DataType(DataType.DateTime)]
        public DateTime? MyDate { get; set; }
    }
    public class ChildModel
    {
        public int ChildID { get; set; }
        public string ChildName { get; set; }
    }
}

我在我的项目中做过类似的事情。我搜索了很多,我终于意识到解决方案是创建主网格和细节网格,第一个网格将是主网格,第二个网格从第一个网格中获取信息,在我的例子中有两个网格,一个用于Sport Branch,另一个用于Federation。联合会从体育分会获得信息。

Sport Branch:

<div >
    @(Html.Kendo().Grid<SportBranchViewModel>()
              .Name("grid")
              .Columns(columns =>
              {
                  columns.Bound(p => p.SportBranchTitle).Title("Title").Width(120);
                  columns.Command(command =>  {  command.Edit().Text("Edit").UpdateText("OK").CancelText("Cancel");
                      command.Destroy().Text("Delete");
                  })
                      .Width(172);
              })
              .ToolBar(toolbar => toolbar.Create().Text("Create"))
              .Editable(editable =>
              {
                  editable.Mode(GridEditMode.InLine);
                  editable.DisplayDeleteConfirmation("Are you sure you want to delete");
              })
              .Scrollable()
              .Sortable(sortable => sortable.AllowUnsort(true))
              .ClientDetailTemplateId("federationtemplate")
              .DataSource(dataSource => dataSource
                  .Ajax()
                  .Events(events => events.Error("onError"))
                  .Model(model => model.Id(p => p.SportBranchID))
                  .Read(read => read.Action("SportBranch_Read", "BaseData"))
                  .Update(update => update.Action("SportBranch_Update", "BaseData"))
                  .Create(create => create.Action("SportBranch_Create", "BaseData"))
                  .Destroy(destroy => destroy.Action("DeleteSportBranch", "BaseData"))
                      )
                .Events(events => events.DataBound("collapseGrid"))
                .HtmlAttributes(new { style = "height:400px;" }))

</div>

the Federation grid:

<script id="federationtemplate" type="text/kendo-tmpl">
        @(Html.Kendo().Grid<SportBranchFederationViewModel>()
                                          .Name("grid_#=SportBranchID#")
                          .Columns(columns =>
                          {                   
                              columns.Bound(p => p.FederationName).Title("Title").Width(200);
                              columns.Command(command =>
                              {
                                  command.Edit().Text("Edit").UpdateText("OK").CancelText("Cancel");
                                      command.Destroy().Text("Delete");
                              })
                                  ;
                          })
                          .ToolBar(toolbar =>
                                {
                                        toolbar.Create().Text("Create");
                                }
                            )
                          .Editable(editable =>
                          {
                              editable.Mode(GridEditMode.InLine);
                              editable.DisplayDeleteConfirmation("Are you sure you want to delete?");
                          })
                          .Scrollable()
                          .Sortable(sortable => sortable.AllowUnsort(true))
                          .Pageable()
                          .Events( e=> e.DataBound("onDataBoundFederation"))
                          .DataSource(dataSource => dataSource
                              .Ajax()
                              .Events(events => events.Error("onError"))
                                      .Model(model => model.Id(p => p.FederationID))
                                      .Read(read => read.Action("SportBranchFederation_Read", "BaseData", new { sportBranchID = "#=SportBranchID#" }))
                                      .Create(create => create.Action("SportBranchFederation_Add", "BaseData", new { sportBranchID  = "#=SportBranchID#" }))
                                      .Update(update => update.Action("SportBranchFederation_Update", "BaseData", new { sportBranchID = "#=SportBranchID#" }))
                                      .Destroy(destroy => destroy.Action("SportBranchFederation_Destroy", "BaseData", new { sportBranchID = "#=SportBranchID#" }))
                            .PageSize(7)
                          )
                          .HtmlAttributes(new { style = "height:250px;" })
                          .ToClientTemplate()
                )
       </script>

在控制器:

public ActionResult SportBranchFederation_Read(int sportBranchID , [DataSourceRequest] DataSourceRequest request)
            {
                var data = _bvaDataService.GetFederations(sportBranchID);
                return Json(CreateSportBranchFederationsFromFederations(data.ToList()).ToDataSourceResult(request));
            }
以下是步骤:
  1. 将第二个网格放在脚本标签中,并指定脚本标签的id。

  2. 在第一个网格中使用ClientDetailTemplateId()并传递包含第二个网格的脚本标签的id。

  3. 在第二个网格的动作中,你想传递第一个网格的列的值,使用表达式"#=[第一个网格的列的名称]#"(这里是"#=SportBranchID#")。注意,可以在网格中使用"#= #"来使用当前网格或其他网格中的字段值。我将这个字段发送给我的read动作以获得相应的结果(查看我的控制器)

  4. 添加ToClientTemplate()到第二个网格

阅读这些示例:
http://demos.telerik.com/kendo-ui/grid/detailtemplate,http://demos.telerik.com/aspnet-mvc/grid/detailtemplate

最新更新