前台:
$(document).ready(function(){
$('#test').datagrid({
title:'My DataGrid',
iconCls:'icon-save',
width:800,
height:450,
nowrap: false,
striped: true,
collapsible:true,
,
onLoadSuccess:function(data){
//alert(data)
},
frozenColumns:[[
{field:'ck',checkbox:true}
]],
columns:[[
{field:'Name',title:'线路名称',width:300},
{field:'days',title:'天数',width:50},
{field:'lowPrice',title:'起价',width:75},
{field:'lowPriceI',title:'代理价',width:75},
{field:'createEnterpName',title:'提供',width:150}
]],
pagination:true,
rownumbers:true,
singleSelect:true,
toolbar:[{
id:'btnadd',
text:'Add',
iconCls:'icon-add',
handler:function(){
$('#btnsave').linkbutton('enable');
alert('add')
}
},{
id:'btncut',
text:'Cut',
iconCls:'icon-cut',
handler:function(){
$('#btnsave').linkbutton('enable');
alert('cut')
}
},'-',{
id:'btnsave',
text:'Save',
disabled:true,
iconCls:'icon-save',
handler:function(){
$('#btnsave').linkbutton('disable');
alert('save')
}
}]
});
loadData();
});
function displayMsg(){
//设置分页控件
var p = $('#test').datagrid('getPager');
$(p).pagination({
pageSize:10,
showPageList:false,
beforePageText: '第',//页数文本框前显示的汉字
afterPageText: '页 共 {pages} 页',
displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录'
});
}
//查询数据
function loadData()
{
$("#test").datagrid({
,
queryParams:{
}
});
$("#test").datagrid('load');
displayMsg();
}
后台:
//显示线路
sbJson.Append("{");
sbJson.Append("\"total\":\"" + rowCount.ToString() + "\"");
sbJson.Append(",\"rows\":[");
for (int i = 0; dvRoute != null && i < dvRoute.Count; i++)
{
int.TryParse(Null.IsNull(dvRoute[i]["SID"], "0"), out routeId);
if (i != 0) sbJson.Append(",");
//注意字符中含单引号或双引号转换
sbJson.Append("{");
sbJson.Append("\"SID\":\"" + routeId + "\"");
sbJson.Append(",\"Name\":\"" + Null.IsNull(dvRoute[i]["days"], "") + "\"");
sbJson.Append(",\"days\":\"" + Null.IsNull(dvRoute[i]["days"], "") + "\"");
sbJson.Append(",\"lowPrice\":\"" + Null.IsNull(dvRoute[i]["days"], "") + "\"");
sbJson.Append(",\"lowPriceI\":\"" + Null.IsNull(dvRoute[i]["days"], "") + "\"");
sbJson.Append(",\"createEnterpName\":\"" + Null.IsNull(dvRoute[i]["days"], "") + "\"");
sbJson.Append("}");
}
sbJson.Append("]");
sbJson.Append("}");