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);
			}
		}
	}