blocks|key|1223045|text|您可能需要刷新网格的数据源。所以在更新之后，你可以像这样刷新它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1223046|+var+grid+=+$("#ProposalGrid").data("kendoGrid");
+++++++++++++grid.dataSource.page(1)+//+or
+++++++++++++grid.dataSource.read()+//if+dataSource+Read+expects+a+paramater
+++++++++++++grid.dataSource.read(+{paramNameAsDefinedInController+:+value+});|code-block|syntax|javascript|1223047|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You will probably need to do a refresh on the grid's data source.
So after the update you can refresh it like this...

<pre><code> var grid = $("#ProposalGrid").data("kendoGrid");
 grid.dataSource.page(1) // or
 grid.dataSource.read() //if dataSource Read expects a paramater
 grid.dataSource.read( {paramNameAsDefinedInController : value });
</code></pre>

blocks|key|1230067|text|您需要更新datasource并再次获取，如果您在网格页脚中使用聚合sum，下面的JavaScript将在您每次创建/更新任何行时更新您的页脚sum。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1230068|.DataSource(dataSource+=>+dataSource
++.Ajax()
++.Aggregates(aggregates+=>
++{
++++aggregates.Add(p+=>+p.WorkOrderDetailsQuantity).Sum();
++++aggregates.Add(p+=>+p.Total).Sum();+++++++++++++++++++++++++
++})
.Events(e=>e.Edit("onEdit").Save("onSave"))

function+onSave(e)
{
++//update+the+aggregate+columns
++var+dataSource+=+this.dataSource;
++e.model.one("change",+function+()+{
++++dataSource.one("change",+function+()+{
++++++dataSource.aggregates().Total.sum;
++++});
++++dataSource.fetch();
++});
}|code-block|syntax|javascript|1230069|entityMap^0|5|A|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

you need to update the <code>datasource</code> and fetch again if you using aggregates sum in you gird footer the following JavaScript will update your footer sum every time you create/update any row.

<pre><code>.DataSource(dataSource =&gt; dataSource
 .Ajax()
 .Aggregates(aggregates =&gt;
 {
 aggregates.Add(p =&gt; p.WorkOrderDetailsQuantity).Sum();
 aggregates.Add(p =&gt; p.Total).Sum(); 
 })
.Events(e=&gt;e.Edit("onEdit").Save("onSave"))

function onSave(e)
{
 //update the aggregate columns
 var dataSource = this.dataSource;
 e.model.one("change", function () {
 dataSource.one("change", function () {
 dataSource.aggregates().Total.sum;
 });
 dataSource.fetch();
 });
}
</code></pre>

blocks|key|1034043|text|如果你不想重新加载你的数据，你总是可以这样做(有点老生常谈...)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1034044|首先，对Save事件和SaveChanges事件使用不同的函数，例如：|1034045|.Events(events+=>+{
++++events.Save("Save");
++++events.SaveChanges("SaveChanges");
++++events.Remove("Remove")
})|code-block|syntax|javascript|1034046|第二，定义JavaScript方法，例如：|1034047|function+Save(e)+{
++++if+(e.value.Gewgaw)+{+//+replace+'Gewgaw'+with+your+column+name
++++++++var+footer+=+$('tr.k-footer-template'),
++++++++++++idx+=+3,+//+replace+3+with+the+column+index+you+want+to+aggregate
++++++++++++aggregate+=+$(footer).children('td')[idx];+

++++++++//+I+had+to+delay+the+stuff+in+this+function+to+get+it+to+load+properly
++++++++setTimeout(function+()+{+
++++++++++++var+sum+=+0;

++++++++++++$('tr[role=row][data-uid]').each(function(i,+e)+{
++++++++++++++++var+$cell+=+$($(e).children()[idx]);

++++++++++++++++/*+do+any+necessary+manipulations+before+this+
+++++++++++++++++++if+your+cell+is+formatted+*/
++++++++++++++++var+cellAmount+=+parseFloat($cell.text());+

++++++++++++++++sum+%2B=+cellAmount;
++++++++++++});

++++++++++++/*+do+any+necessary+formatting+to+sum+before+this+
+++++++++++++++if+your+cell+is+formatted+*/
++++++++++++$(aggregate).text(sum);+
++++++++},+50);+
++++}
}|1034048|如果您这样做，并删除/添加适当的格式，那么每次编辑相应的单元格时，它都应该更新聚合。|1034049|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

If you don't want to reload your data, you can always do something like this (a little hacky...):

First, use a different function for the Save event vs. the SaveChanges event, e.g.:

<pre><code>.Events(events =&gt; {
 events.Save("Save");
 events.SaveChanges("SaveChanges");
 events.Remove("Remove")
})
</code></pre>

Second, define the JavaScript method, e.g.:

<pre><code>function Save(e) {
 if (e.value.Gewgaw) { // replace 'Gewgaw' with your column name
 var footer = $('tr.k-footer-template'),
 idx = 3, // replace 3 with the column index you want to aggregate
 aggregate = $(footer).children('td')[idx]; 

 // I had to delay the stuff in this function to get it to load properly
 setTimeout(function () { 
 var sum = 0;

 $('tr[role=row][data-uid]').each(function(i, e) {
 var $cell = $($(e).children()[idx]);

 /* do any necessary manipulations before this 
 if your cell is formatted */
 var cellAmount = parseFloat($cell.text()); 

 sum += cellAmount;
 });

 /* do any necessary formatting to sum before this 
 if your cell is formatted */
 $(aggregate).text(sum); 
 }, 50); 
 }
}
</code></pre>

If you do that stuff and remove/add the appropriate formatting, it should update the aggregate each time the respective cell is edited.

I use the Kendo UI grid in ajax mode and have a ClientFooterTemplate with a sum of the total for a column. This all works well, but if I create/update or remove a record the ClientFooterTemplate is not updated and the sum value stays the same. 

How can I update the ClientFooterTemplate so that the sum value is up to date after create/update or delete?

This is what I tried so far:

<pre><code>.Events(events =&gt;
{
 events.SaveChanges("SaveChanges");
 events.Remove("Remove");
 events.Save("SaveChanges");
})
&lt;script&gt;
 function SaveChanges(e) {
 Reload(e.sender);
 }
 function Remove(e) {
 Reload(e.sender);
 }
 function Reload(obj) {
 obj.dataSource.read();
 }
&lt;/script&gt;
</code></pre>

The obj.dataSource.read() is executed before the actual request to update.

Refresh the ClientFooterTemplate of Kendo UI MVC grid on edit

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在ajax模式中使用了Kendo UI网格，并有一个包含列总和的ClientFooterTemplate。这一切都工作得很好，但是如果我创建/更新或删除一条记录，ClientFooterTemplate不会更新，并且sum值保持不变。如何更新ClientFooterTemplate，使sum值在创建/更新或删除后是最...

问在编辑时刷新Kendo UI MVC网格的ClientFooterTemplate
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在编辑时刷新Kendo UI MVC网格的ClientFooterTemplateEN