关闭

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

1190人阅读 评论(0) 收藏 举报
分类:

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".

 

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:55325次
    • 积分:662
    • 等级:
    • 排名:千里之外
    • 原创:7篇
    • 转载:34篇
    • 译文:0篇
    • 评论:4条
    最新评论