EAS Bos 合計行代碼(主要針對報表類的table)

/** * 功能：添加合計行 *  * @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);}}}