Javascript grid汇总值

1.miniui 页面加载完成后立即发生汇总 （οnlοad="onloadSUM"）

function onloadSUM() { 

            var grid = mini.get("RSummaryDetails");

            var rows = grid.getData()

            for (var i = 0; i < rows.length; i++) {

                var Price = (parseFloat(rows[i].ExchangeRate)) * (parseFloat(rows[i].SumAmountMoney));

                grid.updateRow(rows[i], { SumStandardMoney: Price.toFixed(2) });

            }

            mini.get("RSummaryDetails").accept();

        }

2.miniui 监听汇总事件（oncellendedit="EditAppSUM"）

function EditAppSUM(e) {

             var record = e.record;

             var grid = mini.get("ReceivablesContractDetailedList")

             if (e.field == "ExchangeRate" || e.field == "ActualCollectionMoney") {

                 if (record.ExchangeRate == undefined)

                     record.ExchangeRate = 0.0000;

                 if (record.ActualCollectionMoney == undefined)

                     record.ActualCollectionMoney = 0.0000;

                 var ActualRstandardMoney = record.ExchangeRate * record.ActualCollectionMoney;

                 grid.updateRow(record, { ActualStandardMoney: ActualRstandardMoney.toFixed(2) });

             }

         }

3.循环行获取grid列表的和：(οnclick="LoopSumGrid")

function LoopSumGrid(e)

            var total = 0

            var CompleteTurnoverTotal=0;

            var grid = mini.get("DepartmentPlanning");

            var rows=grid.getData()

            for(var i=0;i<rows.length;i++)

            {

                total =parseFloat(total) +parseFloat(rows[i].NewContractAmount);

                CompleteTurnoverTotal =parseFloat(CompleteTurnoverTotal) +parseFloat(rows[i].CompleteTurnover);

            }

4.循环行获取grid的和（根据类型不同，进行不同的汇总)

function changeTabs(e) {

            var grid = mini.get("PaymentPlanList");

            var rows = grid.getData()

            //debugger;

            var a = 0;

            var b = 0;

            for (var i = 0; i < rows.length; i++) {

                var Combo = rows[i].Contracttype;

                if (Combo == "收入合同") {

                    a = parseFloat(a) + parseFloat(rows[i].AmountonthAmount);

                    mini.get("PaymentPlan.IssueCollection").setValue(a);

                }

                if (Combo == "支出合同") {

                    b = parseFloat(b) + parseFloat(rows[i].AmountonthAmount);

                    mini.get("PaymentPlan.IssuePay").setValue(b);

                }

            }

        }