dhtmlx表格求合计



function getshowValue()
  {
      var nextrownum= listGrid.getRowsNum()+1;
       var totalarray = new Array();
    for (var i = 0; i < listGrid.getColumnsNum(); i++) {
     totalarray[i] = 0;
    }
    for ( var i = 0; i < listGrid.getRowsNum(); i++) {
     for (var j = 0; j < listGrid.getColumnsNum(); j++) {
          var cellvalue=0;
         if(listGrid.cells2(i, j).getValue()!="")
         {
           cellvalue=listGrid.cells2(i, j).getValue();
         }
      totalarray[j] += parseFloat(cellvalue);
     }  
    }
    var totalrow = '';
    var pse = $("#plan").val().split("-");
    var smonth = parseInt(pse[1]);
       var emonth = parseInt(pse[2]);
       var energy;
       var canenergy;
       var lock;
       var rate;
       for ( var j = smonth; j <= emonth; j++) {
     if (j == smonth) {
       energy = totalarray[3];
       canenergy = totalarray[6];
       rate=(energy/canenergy)*100;
       lock = "0";
       energy = parseFloat(energy) + "";
     if (energy.indexOf(".") >= 0) {
      var ener = energy.split(".");
      if (ener[1].length > 2) {
       energy = ener[0] + "." + ener[1].substring(0, 2);
      }
     }
      canenergy = parseFloat(canenergy) + "";
     if (canenergy.indexOf(".") >= 0) {
      var ener = canenergy.split(".");
      if (ener[1].length > 2) {
       canenergy = ener[0] + "." + ener[1].substring(0, 2);
      }
     }
     rate = (parseFloat(rate)) / 100 + "";
     if (rate.indexOf(".") >= 0) {
      var rat = rate.split(".");
      if (rat[1].length > 4) {
       rate = rat[0] + "." + rat[1].substring(0, 4);
      }
     }
       totalrow += energy + ","+rate*100+",<input id='lock' name='lock'  type='checkbox'/>,"+canenergy+",";
     } else {
      var energyIndex = 4 + (j - smonth) * 3;
      var canenergyIndex = 6 + (j - smonth) * 3;
      energy = totalarray[energyIndex];
      canenergy = totalarray[canenergyIndex];
      rate=(energy/canenergy)*100;
        energy = parseFloat(energy) + "";
     if (energy.indexOf(".") >= 0) {
      var ener = energy.split(".");
      if (ener[1].length > 2) {
       energy = ener[0] + "." + ener[1].substring(0, 2);
      }
     }
      canenergy = parseFloat(canenergy) + "";
     if (canenergy.indexOf(".") >= 0) {
      var ener = canenergy.split(".");
      if (ener[1].length > 2) {
       canenergy = ener[0] + "." + ener[1].substring(0, 2);
      }
     }
     rate = (parseFloat(rate)) / 100 + "";
     if (rate.indexOf(".") >= 0) {
      var rat = rate.split(".");
      if (rat[1].length > 4) {
       rate = rat[0] + "." + rat[1].substring(0, 4);
      }
     }
      totalrow += energy + ","+rate*100+","+canenergy+",";
     }
    }
       listGrid.addRow(nextrownum,""+nextrownum+","+nextrownum+",合计,"+ totalrow,nextrownum-1);
  }