easyui datagrid js赋值（自定义json）+table中使用字典表

1
2
data-options="url:'datagrid_data.json',fitColumns:true,singleSelect:true">

1
2
3
4
5
6
7
8
9
$('#dg').datagrid({
url:'datagrid_data.json',
columns:[[
{field:'code',title:'Code',width:100},
{field:'name',title:'Name',width:100},
{field:'price',title:'Price',width:100,align:'right'}
]]
});

1
2
3
4
5
6
7
8
9
10
11
12
13
14

这是html
<table id="shTable" class="easyui-datagrid" title="孵化场地费待审核列表" style="width:98%;height:250px;align:center;border:1px solid red;"
data-options="singleSelect:true,collapsible:true,method:'get'">
<thead>
<tr>
<th data-options="field:'tyshxym',width:180,align:'center'">统一社会信用码</th>
<th data-options="field:'dwmc',width:300,align:'center'">公司名称</th>
<th data-options="field:'sqrq',width:160,align:'center'">申请日期</th>
<th data-options="field:'jdmc',width:300,align:'center'">孵化基地名称</th>
</tr>
</thead>
</table>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
这是js
var list = [];
for(var i = 0; i < data.result.length; i++) {
var arr = {};
arr.tyshxym = data.result[i].tyshxym;
arr.dwmc = data.result[i].dwmc;
arr.sqrq = data.result[i].sqrq;
arr.jdmc = data.result[i].jdmc;
list.push(arr);
}
$('#shTable').datagrid({
data:list
});

1
2
3
4
$('#cxTable').datagrid({
data:data.result
});

1
2
3
4
5
	html代码
<table id="shTable" class="easyui-datagrid" title="孵化场地费退款列表(双击操作)" style="width:98%;height:250px;align:center;border:1px solid red;"
data-options="singleSelect:true,collapsible:true,method:'get'">
</table>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
js代码
$('#shTable').datagrid({
//定位到Table标签，Table标签的ID是cxTable
data:data.result,
//Json格式的数据
striped: true,
//斑马线效果
pagination: true,
//分页工具栏
columns: [[
{ field:'tyshxym',width:230,align:'center',title:'统一社会信用码'},
{ field:'dwmc',width:330,align:'center',title:'公司名称'},
{ field:'btje',width:140,align:'center',title:'补贴金额'},
{ field:'sqrqStr',width:200,align:'center',title:'申请日期'},
{ field:'tkbz',width:160,align:'center',title:'退款情况',
formatter:function(value,row){
for(var item in tkbz){
if(value == tkbz[item].id)
return tkbz[item].text;
else continue;
}
}
}
]]
});

1
2
3
4
5
6
7
var tkbz = [
{"id":null,"text":"未退款"},
{"id":"","text":"未退款"},
{"id":"0","text":"已申请退款"},
{"id":"1","text":"在退款中"},
];