Extjs - 获取网格上的所有数据

Extjs - Get all data on the grid

本文关键字:数据 获取 网格 Extjs      更新时间:2023-09-26

我有一个网格,当我将数据加载到网格时,我用pageSize: 10分页,我想从该网格获取数据存储以检查其他网格中的冗余数据,但我只得到 10 个数据,因为我已经将 pageSize 设置为 10,实际上数据超过 10。

如何获取网格中已分页的所有数据?

我已经使用代理类型"分页内存"但不起作用这是我的商店:

var store = Ext.create('Ext.data.Store', {
  //extend: 'Ext.data.Store',
  model: settings.namespace + 'model.FormRequestDetailModel',
  remoteSort: true,
  remoteFilter: true,
  autoLoad: false,
  pageSize: 10,
  //proxy: {
  //    type: 'pagingmemory'
  //},
  sorters: [{
    property: 'FormRequestNo',
    direction: 'ASC'
  }]
});
var filters = [];
var filter = {
  property: 'FormRequestID',
  value: data.ID
};
filters.push(filter);
store.filters.clear();
if (filters.length == 0) {
  store.load();
} else {
  store.filter(filters);
}

这是模型:

//-----------Structure for PurchaseOrder -----------------------//
Ext.define(settings.namespace + 'model.FormRequestDetailModel', {
  extend: 'Ext.data.Model',
  fields: [{
    name: 'ID',
    mapping: 'ID'
  }, {
    name: 'FormRequestID',
    mapping: 'FormRequestID'
  }, {
    name: 'MaterialStockID',
    mapping: 'MaterialStockID'
  }, {
    name: 'MaterialID',
    mapping: 'MaterialID'
  }, {
    name: 'Item',
    mapping: 'Item'
  }, {
    name: 'MaterialNo',
    mapping: 'MaterialNo'
  }, {
    name: 'MaterialDescription',
    mapping: 'MaterialDescription'
  }, {
    name: 'Quantity',
    mapping: 'Quantity'
  }, {
    name: 'UOMID',
    mapping: 'UOMID'
  }, {
    name: 'UOMDescription',
    mapping: 'UOMDescription'
  }, {
    name: 'GLAccountID',
    mapping: 'GLAccountID'
  }, {
    name: 'GLAccountNo',
    mapping: 'GLAccountNo'
  }, {
    name: 'GLAccountDescription',
    mapping: 'GLAccountDescription'
  }, {
    name: 'InternalAgreement',
    mapping: 'InternalAgreement'
  }, {
    name: 'FundReservationNo',
    mapping: 'FundReservationNo'
  }, {
    name: 'AssetNo',
    mapping: 'AssetNo'
  }, {
    name: 'DeliveryDate',
    mapping: 'DeliveryDate'
  }, {
    name: 'Background',
    mapping: 'Background'
  }, {
    name: 'Purpose',
    mapping: 'Purpose'
  }, {
    name: 'UrgencyID',
    mapping: 'UrgencyID'
  }, {
    name: 'UrgencyDescription',
    mapping: 'UrgencyDescription'
  }, {
    name: 'LineStopPotentialID',
    mapping: 'LineStopPotentialID'
  }, {
    name: 'LineStopPotentialDescription',
    mapping: 'LineStopPotentialDescription'
  }, {
    name: 'BackupListID',
    mapping: 'BackupListID'
  }, {
    name: 'BackupListDescription',
    mapping: 'BackupListDescription'
  }, {
    name: 'ReplaceID',
    mapping: 'ReplaceID'
  }, {
    name: 'ReplaceDescription',
    mapping: 'ReplaceDescription'
  }, {
    name: 'FormRequestStatusID',
    mapping: 'FormRequestStatusID'
  }, {
    name: 'IsDrop',
    mapping: 'IsDrop'
  }, {
    name: 'RejectionReasonID',
    mapping: 'RejectionReasonID'
  }, {
    name: 'RejectionReason',
    mapping: 'RejectionReason'
  }, {
    name: 'CreatedTime',
    mapping: 'CreatedTime'
  }, {
    name: 'CreatedBy',
    mapping: 'CreatedBy'
  }, {
    name: 'LastModifiedTime',
    mapping: 'LastModifiedTime'
  }, {
    name: 'LastModifiedBy',
    mapping: 'LastModifiedBy'
  }, {
    name: 'RowStatus',
    mapping: 'RowStatus'
  }, {
    name: 'RejectionReason',
    mapping: 'RejectionReason'
  }, {
    name: 'Approved',
    type: 'boolean',
    defaultValue: false
  }],
  idProperty: 'ID',
  proxy: {
    type: 'ajax',
    url: settings.apiUrl + 'FormRequest/GetDetail',
    actionMethods: {
      read: 'POST'
    },
    reader: {
      type: 'json',
      root: 'data.rows',
      totalProperty: 'totalCount'
    }
  },
  sorters: [{
    property: 'ID',
    direction: 'DESC'
  }]
});

网格视图绑定到存储区。这意味着,如果网格可见,并且将其他数据集加载到存储中,则视图将立即反映更改。

这就是我解决这个问题的方式:使用相同的数据源创建第二个存储,但没有分页。然后,在加载未分页的数据集之前,将网格上的筛选器应用于第二个存储。

关于模型的注意事项:如果它与name相同,则无需声明mapping。而是声明type,这对于格式化或网格是否可编辑很重要。

您可以创建一个循环,以便在完成后更改页面,直到检索到所有值。

我认为这可能会解决您的问题。https://stackoverflow.com/a/33785646/5577577