DataExchange

Loading Data

This section defines json format when grid is loading data from server side.

Json format of data from grid to server side.

Here is a sample of Json string grid posts to server.
{ "action":"load", "pageInfo":{ "pageSize":10, "pageNum":2, "totalRowNum":31, "totalPageNum":4, "startRowNum":11, "endRowNum":20 }, "sortInfo":[{ "columnId":"country", "fieldName":"country", "sortstate":"asc" }], "filterInfo":[{ "columnId":"order_no", "fieldName":"order_no", "logic":"equal", "value":"12345" }], "parameters":{} }

Notes

action: String. Alway be "load".
pageInfo: See Sigma.Grid.PageInfo object.
sortInfo: See Sigma.Grid.SortInfo object.
filterInfo: See Sigma.Grid.FilterInfo object.
parameters: Parameters user adds. See Sigma.Grid.addParameters

Json format of data from server side to grid.

Sample
{ data:[ ["24","CA","Le","Caspar","62","94","53","88","2008-03-18 00:00:00"], ["25","SP","Ju","Joe","38","97","35","74","2008-07-31 00:00:00"], ["26","UK","Co","Thomas","55","58","62","46","2008-07-19 00:00:00"] ], pageInfo:{totalRowNum:31}, recordType : 'array' }

Notes

data: Data content.
pageInfo: See Sigma.Grid.PageInfo object.
recordType: Type of data. Could be "array" or "object".

Saving Data

This section defines json format when grid is saveing data to server side.

Json format of data from grid to server side.

Sample
{ action : 'save', fieldsName : [..], insertedRecords : [..], updatedRecords : [..], deletedRecords : [..], recordType : "object"/"array", parameters : {} }

Notes

action: String. Alway be "save".
fieldsName: Array. Fields name.
insertedRecords : Array of array/object. Records inserted by user.
updatedRecords : Array of array/object. Records updated by user.
deletedRecords : Array of array/object. Records deleted by user.
recordType: Type of insertedRecords, updatedRecords, deletedRecords. Could be "array" or "object".
parameters: Parameters user adds. See Sigma.Grid.addParameters

Json format of data from server side to grid.

Sample
{ success : true/false, exception : "..." }

Notes

success: Bool. To specify whether CRUD operation is successful.
exception: Exception/error message.