EXT分页,导出当页数据

根据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);
       }
      }
  

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值