miniui动态增加列

最新推荐文章于 2021-08-05 16:25:40 发布

原创最新推荐文章于 2021-08-05 16:25:40 发布 · 6.1k 阅读

2 ·

CC 4.0 BY-SA版权

这篇博客介绍了如何使用miniui库动态地在表格中添加数据列。通过`PowerForm.EventAfterLoadData`和`Revision`两个函数，实现了根据数据源自动增加文本列和日期列，并设置了列的对齐方式、编辑器类型等属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

PowerForm.EventAfterLoadData  = function (e) {                 
                    
                    var grid = mini.get("Sy_Blueprintcatalogue");
                    var data = mini.get("Sy_Blueprintcatalogue").data;
                    var list = mini.get("Sy_Blueprintcatalogue").getList();
                    var columns = grid.getColumns();
                    var revisition=columns[8].columns;
                    var arr = ["E","Date5", "F", "Date6", "G", "Date7", "H", "Date8", "I", "Date9", "J", "Date10", "K", "Date11", "L", "Date12","M", "Date13", "N", "Date14", "O", "Date15", "P", "Date16", "Q", "Date17", "R", "Date18", "S", "Date19", "T","Date20",];
                    var index= revisition.length;
                    var dist;
                    for(var i=0;i<arr.length;i++){
                            var item=arr[i];
                        for(var j=0;j<list.length;j++){
                            if(list[j][item] && list[j][item] !=0){
                                if(i%2 == 0){
                                    dist=i+1;
                                }
                            }
                        }                       
                    }

                    
                        for (var i = 0; i < arr.length; i++) {
                            
                                if(i <= dist){
                                    if(i%2 == 0){
                                        columns[8].columns.push({ header: arr[i], field: arr[i], headerAlign: "center", align: "center", editor: { cls: "mini-textbox", type: "textbox", style: "width:100%" } });
                                    }else{
                                        columns[8].columns.push({ header: arr[i], field: arr[i], headerAlign: "center", align: "center", dateFormat: "yyyy-MM-dd", editor: { cls: "mini-datepicker", type: "datepicker", style: "width:100%" } });
                                    }
                                    
                                    
                                     grid.setColumns(columns)
                                }                                              
                        } 
                                
                }

function Revision() {
                    var grid = mini.get("Sy_Blueprintcatalogue");
                    var arr = ["E", "Date5", "F", "Date6", "G", "Date7", "H", "Date8", "I", "Date9", "J", "Date10", "K", "Date11", "L", "Date12", "M", "Date13", "N", "Date14", "O", "Date15", "P", "Date16", "Q", "Date17", "R", "Date18", "S", "Date19", "T", "Date20",];                    
                    var columns = grid.getColumns();
                    var revisition = columns[8].columns;
                    var index = revisition.length;
                    for (var i = 0; i < arr.length; i++) {
                        if (index == i + 8) {
                            columns[8].columns.push({ header: arr[i], field: arr[i], headerAlign: "center", align: "center", editor: { cls: "mini-textbox", type: "textbox", style: "width:100%" } }, { header: "DATE", field: arr[i + 1], headerAlign: "center", dateFormat: "yyyy-MM-dd", editor: { cls: "mini-datepicker", type: "datepicker", style: "width:100%" } });
                        }
                        grid.setColumns(columns)
                    } 
                }