jEasyUI 創(chuàng)建子網(wǎng)格

使用數(shù)據(jù)網(wǎng)格（datagrid）的詳細(xì)視圖，用戶可以展開(kāi)一行來(lái)顯示附加的詳細(xì)信息。任何內(nèi)容都可以加載作為行詳細(xì)，子網(wǎng)格也可以動(dòng)態(tài)加載。本教程將向您展示如何在主網(wǎng)格上創(chuàng)建一個(gè)子網(wǎng)格。

步驟 1：創(chuàng)建主網(wǎng)格

<table id="dg" style="width:700px;height:250px"
????????url="datagrid22_getdata.php" 
????????title="DataGrid - SubGrid"
????????singleSelect="true" fitColumns="true">
????<thead>
????????<tr>
????????????<th field="itemid" width="80">Item ID</th>
????????????<th field="productid" width="100">Product ID</th>
????????????<th field="listprice" align="right" width="80">List Price</th>
????????????<th field="unitcost" align="right" width="80">Unit Cost</th>
????????????<th field="attr1" width="220">Attribute</th>
????????????<th field="status" width="60" align="center">Status</th>
????????</tr>
????</thead>
</table>

步驟 2：設(shè)置詳細(xì)視圖來(lái)顯示子網(wǎng)格

為了使用詳細(xì)視圖，請(qǐng)記得在頁(yè)面頭部引用視圖腳本文件。

<script type="text/javascript" src="http:///try/jeasyui/datagrid-detailview.js"></script>

$('#dg').datagrid({
????view: detailview,
????detailFormatter:function(index,row){
????????return '<div style="padding:2px"><table class="ddv"></table></div>';
????},
????onExpandRow: function(index,row){
????????var ddv = $(this).datagrid('getRowDetail',index).find('table.ddv');
????????ddv.datagrid({
????????????url:'datagrid22_getdetail.php?itemid='+row.itemid,
????????????fitColumns:true,
????????????singleSelect:true,
????????????rownumbers:true,
????????????loadMsg:'',
????????????height:'auto',
????????????columns:[[
????????????????{field:'orderid',title:'Order ID',width:100},
????????????????{field:'quantity',title:'Quantity',width:100},
????????????????{field:'unitprice',title:'Unit Price',width:100}
????????????]],
????????????onResize:function(){
????????????????$('#dg').datagrid('fixDetailRowHeight',index);
????????????},
????????????onLoadSuccess:function(){
????????????????setTimeout(function(){
????????????????????$('#dg').datagrid('fixDetailRowHeight',index);
????????????????},0);
????????????}
????????});
????????$('#dg').datagrid('fixDetailRowHeight',index);
????}
});

當(dāng)用戶點(diǎn)擊展開(kāi)按鈕（'+'）時(shí)，'onExpandRow' 事件將被觸發(fā)。我們創(chuàng)建一個(gè)新的帶有三列的子網(wǎng)格。當(dāng)子網(wǎng)格數(shù)據(jù)加載成功時(shí)或者改變尺寸大小時(shí)，請(qǐng)記得對(duì)主網(wǎng)格調(diào)用 'fixDetailRowHeight' 方法。

步驟 3：服務(wù)器端代碼

datagrid22_getdata.php

$result = array();

include 'conn.php';

$rs = mysql_query("select * from item where itemid in (select itemid from lineitem)");

$items = array();
while($row = mysql_fetch_object($rs)){
????array_push($items, $row);
}

echo json_encode($items);

datagrid22_getdetail.php

include 'conn.php';

$itemid = mysql_real_escape_string($_REQUEST['itemid']);

$rs = mysql_query("select * from lineitem where itemid='$itemid'");
$items = array();
while($row = mysql_fetch_object($rs)){
????array_push($items, $row);
}
echo json_encode($items);

上一篇：jEasyUI 擴(kuò)展行顯示細(xì)節(jié) 下一篇：jEasyUI 顯示海量數(shù)據(jù)