嵌套计算网格内的文本框的总和 [英] Calculate sum of textboxes inside nested grid
本文介绍了嵌套计算网格内的文本框的总和的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个 GridView控件两个嵌套网格。这两个嵌套网格都有不同数量的控件（文本框）。我想计算网格嵌套文本框的总和，并把相关的行父电网的相关文本框。
我想这样做，使用jQuery。
以下是网格的源代码：
＆LT;表CELLSPACING =0规则=所有边界=1ID =gvSPActivities的风格=宽度：100％;边境崩溃：崩溃; ＆GT;
＆LT; TR类=donorh1align =left的风格=高度：35px;＆GT;
百分位范围=山口的风格=宽度：40像素;＆GT;＃＆LT; /第i个百分位范围=山口＆GT;活动＆LT; /第i个百分位范围=山口＆GT;单位和LT ; /第i个百分位范围=山口＆GT;目标＆LT; /第i个百分位范围=山口＆GT;提供有益＆LT; /第i个百分位范围=山口＆GT;成本＆LT; /第i
＆所述; / TR＆GT;＆下; TR类=gridrow2＆GT;
＆所述; TD＆GT;
1
＆所述; / TD＆GT;＆下; TD＆gt;一种与所述; / TD＆GT;＆下; TD＆GT; U1＆下; / TD＆GT;＆下; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 txtTarget类型=文本VALUE =100ID =gvSPActivities_txtTarget_0级=数字的风格=宽度：150像素; /＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;一类=showDetails的href =JavaScript的：switchViews（'DIV1'，'一'）;＆GT;
展会详情及LT; / A＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 txtTotalBenefic类型=文本ID =gvSPActivities_txtTotalBenefic_0/＆GT;
＆LT; DIV CLASS =详细信息ID =DIV1的风格=显示：无;
左：30像素;＆GT;
＆LT; DIV＆GT;
＆LT;表CELLSPACING =0规则=所有边界=1ID =gvSPActivities_gvBenefic_0的风格=边界崩溃：崩溃;＆GT;
＆所述; TR＆GT;
百分位范围=山口＆GT;男＆LT; /第i个百分位范围=山口＆GT;女＆LT; /第i个百分位范围=山口＆GT;的子＆lt; /第i个百分位范围= 山坳＆GT;家庭与LT; /第i
＆所述; / TR＆GT;＆下; TR＆GT;
＆所述; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvBenefic $ ctl02 txtMaleBenefic类型=文本ID =gvSPActivities_gvBenefic_0_txtMaleBenefic_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvBenefic $ ctl02 txtFemaleBenefic类型=文本ID =gvSPActivities_gvBenefic_0_txtFemaleBenefic_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvBenefic $ ctl02 txtChildren类型=文本ID =gvSPActivities_gvBenefic_0_txtChildren_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvBenefic $ ctl02 txtFamilyBenefic类型=文本ID =gvSPActivities_gvBenefic_0_txtFamilyBenefic_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;
＆LT; / TR＆GT;
＆LT; /表＆gt;
＆LT; / DIV＆GT;
＆LT; / DIV＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;一类=showDetails的href =JavaScript的：switchViews（'DIV1'，'一'）;＆GT;
展会详情及LT; / A＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 txtTotalCost类型=文本ID =gvSPActivities_txtTotalCost_0/＆GT;
＆LT; DIV CLASS =详细信息ID =DIV1的风格=显示：无;
左：30像素;＆GT;
＆LT; DIV＆GT;
＆LT;表CELLSPACING =0规则=所有边界=1ID =gvSPActivities_gvCost_0的风格=边界崩溃：崩溃;＆GT;
＆所述; TR＆GT;
百分位范围=山口＆GT;主营成本与LT; /第i个百分位范围=山口＆gt;其他成本与LT; /第i
＆所述; / TR＆GT;＆下; TR＆GT;
＆所述; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvCost $ ctl02 txtMainCost类型=文本ID =gvSPActivities_gvCost_0_txtMainCost_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;＆LT; TD＆GT;
＆LT;输入名称=$ gvSPActivities $ ctl02 $ gvCost $ ctl02 txtOthercost类型=文本ID =gvSPActivities_gvCost_0_txtOthercost_0级=数字的风格=宽度：100像素; /＆GT;
＆LT; / TD＆GT;
＆LT; / TR＆GT;
＆LT; /表＆gt;
＆LT; / DIV＆GT;
＆LT; / DIV＆GT;
＆LT; / TD＆GT;
＆LT; / TR＆GT;
＆LT; /表＆gt;
感谢。
解决方案
VAR总= 0;$（输入[ID ^ ='gvSPActivities']，#gvSPActivities）。每个（函数（）{
总=总+ THIS.VALUE;
}）;$（someInputElement）.VAL（总）;
I have two nested grids in a GridView. Both nested grids have different number of controls (TextBoxes). I want to calculate sum of nested grid textboxes and put in a relevant textbox of relevant row parent grid.
I want to do this using jQuery.
Following is the source of grids:
<table cellspacing="0" rules="all" border="1" id="gvSPActivities" style="width:100%;border-collapse:collapse;">
<tr class="donorh1" align="left" style="height:35px;">
<th scope="col" style="width:40px;">#</th><th scope="col">Activity</th><th scope="col">Unit</th><th scope="col">Target</th><th scope="col">Benefic</th><th scope="col">Cost</th>
</tr><tr class="gridrow2">
<td>
1
</td><td>a</td><td>u1</td><td>
<input name="gvSPActivities$ctl02$txtTarget" type="text" value="100" id="gvSPActivities_txtTarget_0" class="numeric" style="width:150px;" />
</td><td>
<a class="showDetails" href="javascript:switchViews('div1', 'one');">
Show Details</a>
<input name="gvSPActivities$ctl02$txtTotalBenefic" type="text" id="gvSPActivities_txtTotalBenefic_0" />
<div class="details" id="div1" style="display: none;
left: 30px;">
<div>
<table cellspacing="0" rules="all" border="1" id="gvSPActivities_gvBenefic_0" style="border-collapse:collapse;">
<tr>
<th scope="col">Male</th><th scope="col">Female</th><th scope="col">Children</th><th scope="col">Family</th>
</tr><tr>
<td>
<input name="gvSPActivities$ctl02$gvBenefic$ctl02$txtMaleBenefic" type="text" id="gvSPActivities_gvBenefic_0_txtMaleBenefic_0" class="numeric" style="width:100px;" />
</td><td>
<input name="gvSPActivities$ctl02$gvBenefic$ctl02$txtFemaleBenefic" type="text" id="gvSPActivities_gvBenefic_0_txtFemaleBenefic_0" class="numeric" style="width:100px;" />
</td><td>
<input name="gvSPActivities$ctl02$gvBenefic$ctl02$txtChildren" type="text" id="gvSPActivities_gvBenefic_0_txtChildren_0" class="numeric" style="width:100px;" />
</td><td>
<input name="gvSPActivities$ctl02$gvBenefic$ctl02$txtFamilyBenefic" type="text" id="gvSPActivities_gvBenefic_0_txtFamilyBenefic_0" class="numeric" style="width:100px;" />
</td>
</tr>
</table>
</div>
</div>
</td><td>
<a class="showDetails" href="javascript:switchViews('div1', 'one');">
Show Details</a>
<input name="gvSPActivities$ctl02$txtTotalCost" type="text" id="gvSPActivities_txtTotalCost_0" />
<div class="details" id="div1" style="display: none;
left: 30px;">
<div>
<table cellspacing="0" rules="all" border="1" id="gvSPActivities_gvCost_0" style="border-collapse:collapse;">
<tr>
<th scope="col">Main Cost</th><th scope="col">Other Cost</th>
</tr><tr>
<td>
<input name="gvSPActivities$ctl02$gvCost$ctl02$txtMainCost" type="text" id="gvSPActivities_gvCost_0_txtMainCost_0" class="numeric" style="width:100px;" />
</td><td>
<input name="gvSPActivities$ctl02$gvCost$ctl02$txtOthercost" type="text" id="gvSPActivities_gvCost_0_txtOthercost_0" class="numeric" style="width:100px;" />
</td>
</tr>
</table>
</div>
</div>
</td>
</tr>
</table>
Thanks.
解决方案
var total = 0;
$("input[id^='gvSPActivities']", "#gvSPActivities").each(function() {
total = total+this.value;
});
$(someInputElement).val(total);
这篇关于嵌套计算网格内的文本框的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
