根据ID显示列表分页,单击查看可以进行分页,导出当页数据
function selectwd(id,tag){
var address = 'http://'+ document.location.host;
var sid=Ext.getCmp(tag).getStore().getAt(id).get("arid");
var proxy = new Ext.data.HttpProxy({url:""+address+"/hatct/wdinfo/queryWd!querytotal.action?id="+sid});
//Record
var UiQueryBeans = new Ext.data.Record.create([
{name:"tbAreaName",type:"string",mapping:"tbAreaName"},
{name:"wdid",type:"string",mapping:"wdid"},
{name:"wdname",type:"string",mapping:"wdname"},
{name:"admin",type:"string",mapping:"admin"},
{name:"vAddress",type:"string",mapping:"vAddress"},
]);
//Reader
var reader = new Ext.data.JsonReader(
{totalProperty:"totalProperty",root:"wdlist"},
UiQueryBeans
);
//store
var store = new Ext.data.Store({
proxy:proxy,
reader:reader
});
var cm = new Ext.grid.ColumnModel([
new Ext.grid.RowNumberer(),
{header:"区域",width:100,dataIndex:"tbAreaName",align:"center"},
{header:"网点编号",width:100,dataIndex:"wdid",align:"center"},
{header:"网点名称",width:100,dataIndex:"wdname",align:"center"},
{header:"负责人",width:150,dataIndex:"admin",align:"center"},
{header:"地址",width:150,dataIndex:"vAddress",align:"vAddress"}
]);
var newWin2=new Ext.Window({
id:'win22',
width:600,
autoHeight:true,
maximizable:true,
closable:true,
constrain:true,
tbar:[
'-',
{
text:'导出Excel',
handler:function(){
doExcel();
}
}
],
closeAction:'close',
layout:'fit',
items:new Ext.grid.GridPanel({
id:'test88',
autoHeight:true,
store:store,
cm:cm,
viewConfig:{
forceFit:true,
columnsText:'显示列名',
sortAscText:'升序',
sortDescText:'降序',
scrollOffset:20
},
stripeRows:true,
deferEmpty:true,
emptyText:'<div>暂时没有数据</div>',
loadMask:new Ext.LoadMask(window.document.body,{
msg:'数据正在加载之中......',
removeMask:true
}),
renderTo:"queryResut",
bbar:new Ext.PagingToolbar({
store:store,
pageSize:5,
displayInfo:true,
displayMsg:"本页显示第{0}条到第{1}条的记录,一共{2}条记录",
emptyMsg:"没有记录",
items:[
"-",
new Ext.Toolbar({
})
]
})
})
})
newWin2.show();
//stores.load();
Ext.getCmp("test88").store.load({params:{start:0,limit:5}});
}
//导出excel
function doExcel(){
var vExportContent = Ext.getCmp('test88').getExcelXml();
if (Ext.isIE8 || Ext.isIE6 || Ext.isIE7 || Ext.isSafari || Ext.isSafari2 || Ext.isSafari3) {
var fd=Ext.get('frmDummy');
if (!fd) {
fd=Ext.DomHelper.append(Ext.getBody(),{tag:'form',method:'post',id:'frmDummy',action:'exportexcel.jsp', target:'_blank',name:'frmDummy',cls:'x-hidden',cn:[
{tag:'input',name:'exportContent',id:'exportContent',type:'hidden'}
]},true);
}
fd.child('#exportContent').set({value:vExportContent});
fd.dom.submit();
} else {
document.location = 'data:application/vnd.ms-excel;base64,'+Base64.encode(vExportContent);
}
}