单元格格式化显示

最新推荐文章于 2021-01-14 12:57:59 发布

eternal_hope

最新推荐文章于 2021-01-14 12:57:59 发布

阅读量386

点赞数 1

分类专栏： GUI

本文链接：https://blog.csdn.net/weixin_44529420/article/details/88317845

版权

GUI 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

     //格式化数值
     //数据类型
    public static final String ColType_data = "data";
    public static final String ColType_date = "date";
    public static final String ColType_time = "time";
    public static final String ColType_string = "string";

    // 设置合计行显示样式
    public static final String dataColFormat = "#,##0.00";
    public static final String dateColFormat = "yyyy-MM-dd";
    public static final String timeColFormat = "yyyy-MM-dd HH:mm:ss";
        //数值千分位和小数位数显示
        RptUtil.setColumnNHStyle(tblMain,new String[]{"entrys.actualPutAmount","totalPriBlnc","paidInPri","paidInInt","lastPayPric","monthlyPrincipal"},LoanConstant.ColType_data,null);
        //时间格式显示
        RptUtil.setColumnNHStyle(tblMain,new String[]{"createTime","lastUpdateTime"},LoanConstant.ColType_time,null);

/**
     * 设置列格式化和对齐方式
     * table:数据表格
     * fields:列集合
     * colType:数据类型
     * widths:列宽集合
     */
    public static void setColumnNHStyle(KDTable table, String fields[],String colType,int widths[]){
        HorizontalAlignment horAlig = HorizontalAlignment.LEFT;
        String colForMat = null;
        if(colType.equals(LoanConstant.ColType_date)){
            horAlig = HorizontalAlignment.CENTER;
            colForMat = LoanConstant.dateColFormat;
        }
        else if(colType.equals(LoanConstant.ColType_time)){
            horAlig = HorizontalAlignment.CENTER;
            colForMat = LoanConstant.timeColFormat;
        }
        else if(colType.equals(LoanConstant.ColType_data)){
            horAlig = HorizontalAlignment.RIGHT;
            colForMat = LoanConstant.dataColFormat;
        }
        for(int i = 0; i < fields.length; i++){            
            if(!CommonHelper.isEmpty(colForMat)){
                table.getColumn(fields[i]).getStyleAttributes().setNumberFormat(colForMat);
            }
            if(!CommonHelper.isEmpty(widths)){
                table.getColumn(fields[i]).setWidth(widths[i]);
            }
            table.getColumn(fields[i]).getStyleAttributes().setHorizontalAlign(horAlig);
        }
    }