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);
}
Symbol | Location | Localized? | Meaning |
---|---|---|---|
0 | Number | Yes | Digit |
# | Number | Yes | Digit, zero shows as absent |
. | Number | Yes | Decimal separator or monetary decimal separator |
- | Number | Yes | Minus sign |
, | Number | Yes | Grouping separator |
E | Number | Yes | Separates mantissa and exponent in scientific notation. Need not be quoted in prefix or suffix. |
; | Subpattern boundary | Yes | Separates positive and negative subpatterns |
% | Prefix or suffix | Yes | Multiply by 100 and show as percentage |
\u2030 | Prefix or suffix | Yes | Multiply by 1000 and show as per mille value |
¤ (\u00A4 ) | Prefix or suffix | No | Currency 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 suffix | No | Used 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" . |