jquery - 更新数据后刷新 Grid.Mvc

Question

我有这样的 Grid Mvc:

    @helper CustomRendering(int id)
{
    @*<button class="btn btn-primary" onclick="location.href='@Url.Action("AcceptRequest", "TableRequest", new { id = id })'"> Accept</button>*@
    <button class="btn btn-primary" onclick="postAccept(@id)" id="@id"> Accept</button>
    <button class="btn btn-danger" onclick="setWindowId(@id)" id="@id">Decline</button>
}
@Html.Grid(Model).Columns(columns =>
                    {                                                
                        columns.Add(c => c.UserName).Titled("Name").Filterable(true);
                        columns.Add(c => c.DateStart).Titled("DateStart");
                        columns.Add(c => c.DateEnd).Titled("DateEnd");
                        columns.Add(c => c.Approved).Titled("Approved");
                        columns.Add(o => o.Id).Encoded(false).Sanitized(false)
                                    .Titled("Action")
                                    .RenderValueAs(o => CustomRendering(o.Id).ToHtmlString());                                           
                    }).WithPaging(10).Sortable(true)

我有这样的js脚本:

var tempId;        
        function setWindowId(id) {
            $("#dialog").dialog();
            tempId = id;
        }       
        function postMessage() {        
            var message = $('textarea#commentForDecline').val();
            var obj = {};
            obj.mes = $('textarea#commentForDecline').val();
            obj.mes = message;
            obj.id = tempId;

            $.ajax({
                type: "POST",
                url: "/TableRequest/DeclineRequest",            
                data: {'message': obj.mes, 'id': obj.id},
                success: function (msg) {                    
                }
            });       
            $("#dialog").dialog('close');
            $('textarea#commentForDecline').val('');
        }

        function postAccept(id){
            $.ajax({
                type: "POST",
                url: "/TableRequest/AcceptRequest",
                data: {'id': id },
                success: function (msg) {
                }
            });
        }

正如您所看到的我用于按钮的 js 函数，您可能会在 block @helper 上看到。我只是将两个后 ajax 调用发送到 MVC 操作中。我遇到了一个问题:必须刷新页面才能看到任何更新。有什么方法可以在数据库更新后刷新 Grid MVC？

public virtual ActionResult AcceptRequest(int id)
        {           
            using(var _db = new ApplicationDbContext())
            {
                Shedule shedule = _db.Shedules.SingleOrDefault(x => x.Id == id);
                shedule.IsDirectorApproved = true;
                _db.SaveChanges();
            }
            return RedirectToAction("Index");
        }

        [HttpPost]
        public virtual ActionResult DeclineRequest(string message, int id)
        {
            using (var _db = new ApplicationDbContext())
            {
                Shedule shedule = _db.Shedules.SingleOrDefault(x => x.Id == id);
                shedule.IsDirectorApproved = false;
                shedule.Message = message;
                _db.SaveChanges();
            }
            return RedirectToAction(MVC.TableRequest.ActionNames.Index);
        }

Answer 1

好的，所以我设法通过以下方法实现了这一点:

HTML:

将您的网格放在一个 div 容器和一个 PartialView 中，如下所示:

<div class="form-group" >
    @if (Model.myDataList != null)
    {
        <div id="myDataGrid">
            @Html.Partial("DisplayGridData", Model.myDataList);
        </div>                                                       
    }
</div>

您的 DisplayGridData 部分 View 将如下所示:

@using GridMvc.Html

@model List<myProject.Models.MyGridData>

@Html.Grid(Model).Columns(column =>
 {
    column.Add(x => x.id).Titled("ID").Filterable(false);
    column.Add(x => x.name).Titled("Name").Filterable(false);
    column.Add(x => x.uniqueid).Titled("").Sanitized(false).Encoded(false).
    RenderValueAs(model => Html.Label("", "Delete", new { id = "btndelete",@class="btn btn-sm btn-success", onclick = "deleteContentFromDB(" + Convert.ToInt32(model.uniqueid) + ");" })
    .ToHtmlString()).Filterable(false). Sortable(false);
}).EmptyText("No data found").WithPaging(50).Sortable(false).Selectable(false)

对应的AJAX调用:

function refreshGrid() {
    var selectedID = $('#mySelector').find(":selected").val();
    var param = { 'selectedID': selectedID };
    var url = "~/Home/GetSelectedIDDataGridRender?main_id=1";
    $.get(url, param, function (data) {
        $('#myDataGrid').html(data);
    });
}

您的Controller 方法将如下所示:

public ActionResult GetSelectedIDDataGridRender(int selectedID)
{
    List<MyGridData> myGridData = new List<MyGridData>();
    string AjaxCall = Convert.ToString(Request.QueryString["main_id"]);
    if (!string.IsNullOrEmpty(AjaxCall))
    {
        PropertyInfo isreadonly = typeof(System.Collections.Specialized.NameValueCollection).GetProperty("IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);
        isreadonly.SetValue(this.Request.QueryString, false, null);
        this.Request.QueryString.Remove("main_id");

        dataaccess da= new dataaccess();
        myGridData = da.GetMyIDDataFromDB(selectedID);      
    }
    return PartialView("DisplayGridData", myGridData);
}

希望这对某人有所帮助。