数组数据转换成json形式，用于jqgrid初始化表格

今天药忘吃喽~ 2022-07-12 09:47 142阅读 0赞

contents为已知的数组数据格式为：

![Center][]

str为第一步转换完的形式：

![Center 1][]

test为适用于jqgrid插件的json数据形式：

![Center 2][]

用于jqgrid插件中：

$(document).ready(function () {
                $("#PowerTable").jqGrid({      
                    datatype: "local",
    data: test,             //数据
     height: 'auto',
                    colModel: [
    {name:"ID",index:"ID",width: 50,align:'center',key:true,hidedlg:true},
    {name:"姓名",index:"姓名",width: 75,align:'center',editable:true},
    {name:"性别",index:"性别",width: 50,align:'center'},
    {name:"出生日期",index:"出生日期",width: 100,align:'center'},
    {name:"身份证号",index:"身份证号",width: 200,align:'center'},
    {name:"学历",index:"学历",width: 150,align:'center'},
    {name:"职称",index:"职称",width: 75,align:'center'},
    {name:"所属单位",index:"所属单位",width: 150,align:'center'},
    {name:"工资代号",index:"工资代号",width: 100,align:'center'},
    {name:"学位",index:"学位",width: 75,align:'center'}
    
                    ],
                    altRows:true,
                    altclass:'projects',
                    pager: 'pager', //分页工具栏 
                    rowNum:25, //每页显示记录数 
                    viewrecords: true, //是否显示行数 
                    sortname: 'id',
                    viewrecords: true,
                    sortorder: "desc"
                  
                });
                
             });

[Center]: /images/20220710/367e6c19c2f1422b98455cbd48a38c14.png
[Center 1]: /images/20220710/ec23e480fcb649b4904f992b6352fb81.png
[Center 2]: /images/20220710/7f46713c53ae4b4dbf57ea1f19a0a00f.png