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

来源:互联网 发布:空姐老了知乎 编辑:程序博客网 时间:2024/05/11 21:23
var head=['ID',' 姓名', '性别',' 出生日期',' 身份证号', '学历', '职称', '所属单位',' 工资代号',' 学位' ];var str="[{";//str是转换后的数据function switchData(){for(i=0;i<contents.length;i+=head.length){for(j=0;j<head.length;j++){str=str+head[j]+":'"+contents[j+i]+"',";}str=str.substring(0,str.length-1);str+="},{";}str=str.substring(0,str.length-4);str+="'}]"; test = eval(str);}


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


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



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



用于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"                          });                     });



0 0