EAS Bos 合計行代碼

/**  * 功能：添加合計行  *   * @param table  *            指定的KDTable  * @param fields  *            需要合計的列  */  public static void apendFootRow(KDTable table, String fields[]) {   int size = fields.length;   if (size == 0)    return;   Map sumValue = new HashMap();   // 利用getRowCount的到的行可能不正確    int count = table.getRowCount3();     for (int i = 0; i < fields.length; i++) {    sumValue.put(fields[i], new BigDecimal("0.00"));   }   IRow footRow = null;   KDTFootManager footManager = table.getFootManager();   if (footManager == null) {    footManager = new KDTFootManager(table);    footManager.addFootView();    table.setFootManager(footManager);   }   // 計算所有指定行的合計值    footRow = footManager.getFootRow(0);   for (int i = 0; i < count; i++) {    IRow row = table.getRow(i);    for (int j = 0; j < fields.length; j++) {     sumValueForCell(row, fields[j], sumValue);    }   }     if (footRow == null) {    footRow = footManager.addFootRow(0);   }   // 設定合計行顯示樣式    String colFormat = "%{0.00}f";     String total = EASResource.getString(FrameWorkClientUtils.strResource     + "Msg_Total");     table.getIndexColumn().setWidthAdjustMode(KDTIndexColumn.WIDTH_MANUAL);   table.getIndexColumn().setWidth(30);   footManager.addIndexText(0, total);   footRow.getStyleAttributes().setBackground(new Color(0xf6, 0xf6, 0xbf));   for (int i = 0; i < size; i++) {    String colName = fields[i];    footRow.getCell(colName).getStyleAttributes().setNumberFormat(      colFormat);    footRow.getCell(colName).getStyleAttributes().setHorizontalAlign(      HorizontalAlignment.RIGHT);    footRow.getCell(colName).getStyleAttributes().setFontColor(      Color.black);   }     // 設定合計行的值    for (int i = 0; i < fields.length; i++) {    footRow.getCell(fields[i]).setValue(sumValue.get(fields[i]));   }  }    private static void sumValueForCell(IRow row, String key, Map sumValue) {    ICell cell = row.getCell(key);      if (cell != null) {     Object obj = cell.getValue();     if (obj != null) {      BigDecimal keyValue = (BigDecimal) sumValue.get(key);      keyValue = keyValue.add(new BigDecimal(obj.toString()));      sumValue.put(key, keyValue);     }    }   }