对于OATableBean&OAAdvancedTableBean中NUMBER数据按指定格式显示

来源：互联网发布：linux 退出gdb调试编辑：程序博客网时间：2024/06/05 05:23

OATableBean&OAAdvancedTableBean中Number列的数据在默认情况下会自动根据数据是否有小数在表中展示，但是如果业务要求表内的所有Number列，特别是金额列按照固定格式展示就需要在co中进行代码控制：

方法一：根据币种显示数据（代码）

OAMessageStyledTextBean stextBean=(OAMessageStyledTextBean)webBean.findChildRecursive(“列的ID”);//OAMessageStyledTextBean可以根据情况修改

      if(stextBean!=null){
              stextBean.setAttributeValue(CURRENCY_CODE, "CNY");
       }

方法二：根据自定义的样式展现（代码）

Formatter formatter = new OADecimalValidater("#,###,###,##0.00;(#,###,###,##0.00)", "#,###,###,##0.##;(#,###,###,##0.##)");

OAMessageStyledTextBean stextBean=(OAMessageStyledTextBean)webBean.findChildRecursive(“列的ID”);//OAMessageStyledTextBean可以根据情况修改

if(stextBean!=null){
stextBean.setAttributeValue(ON_SUBMIT_VALIDATER_ATTR, formatter);

}

SymbolLocationLocalized?Meaning0NumberYesDigit#NumberYesDigit, zero shows as absent.NumberYesDecimal separator or monetary decimal separator-NumberYesMinus sign,NumberYesGrouping separatorENumberYesSeparates mantissa and exponent in scientific notation. Need not be quoted in prefix or suffix.;Subpattern boundaryYesSeparates positive and negative subpatterns%Prefix or suffixYesMultiply by 100 and show as percentage\u2030Prefix or suffixYesMultiply by 1000 and show as per mille value¤ (\u00A4)Prefix or suffixNoCurrency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator.'Prefix or suffixNoUsed to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to"#123". To create a single quote itself, use two in a row: "# o''clock".