jQuery Grid Plugin - jqGrid

Hello!

    JQuery jqGrid with ASP.NET API ?

   ASP.NET API GET result JSON Data

  URLPath ='http://192.168.101.52:8086/api.....gisterId=2;..gisterId=2'

  Get result JSON Data:

{"PageSize":10,"PageIndex":2,"RecordCount":54,"PageCount":6,

"RowsData":[

{"AppCode":"DYHSQ000043","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000052",

"BusinessCategoryName":"(1) 对讲机","DevCount":0.0,"SampleStatCount":0.0,

"BespokeFlagName":0.0,"CheckStatCount":null},

{"AppCode":"DYHSQ000044","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000051",

"BusinessCategoryName":"(1) 对讲机","DevCount":15.0,"SampleStatCount":12.0,

"BespokeFlagName":0.0,"CheckStatCount":"通过:15台"},{"AppCode":"DYHSQ000045",

"Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0",

"ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000050",

"BusinessCategoryName":"(1) 对讲机","DevCount":50.0,"SampleStatCount":15.0,

"BespokeFlagName":0.0,"CheckStatCount":"通过:50台"},

{"AppCode":"DYHSQ000046","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000049",

"BusinessCategoryName":"(1) 对讲机","DevCount":0.0,"SampleStatCount":0.0,

"BespokeFlagName":0.0,"CheckStatCount":null},{"AppCode":"DYHSQ000047","Ver":1.0,

"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0","ApproveFlag":"1",

"LicenseFlag":"1","LicenceNO":"DYHXK000048","BusinessCategoryName":"(1) 对讲机",

"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null},

{"AppCode":"DYHSQ000048","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000046",

"BusinessCategoryName":"(1) 对讲机","DevCount":0.0,"SampleStatCount":0.0,

"BespokeFlagName":0.0,"CheckStatCount":null},{"AppCode":"DYHSQ000049","Ver":1.0,

"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0","ApproveFlag":"1",

"LicenseFlag":"1","LicenceNO":"DYHXK000045","BusinessCategoryName":"(1) 对讲机",

"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null},

{"AppCode":"DYHSQ000050","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"1","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000044",

"BusinessCategoryName":"(1) 对讲机","DevCount":28.0,"SampleStatCount":14.0,

"BespokeFlagName":0.0,"CheckStatCount":"未检测:28台"},

{"AppCode":"DYHSQ000051","Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0",

"ISAffirm_FLAG":"0","ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000043",

"BusinessCategoryName":"(1) 对讲机","DevCount":900.0,"SampleStatCount":19.0,

"BespokeFlagName":0.0,"CheckStatCount":"通过:900台"},{"AppCode":"DYHSQ000052",

"Ver":1.0,"BusinessId":"1","RegisterId":"2","ISBespoke_Flag":"0","ISAffirm_FLAG":"0",

"ApproveFlag":"1","LicenseFlag":"1","LicenceNO":"DYHXK000042","BusinessCategoryName":"(1) 对讲机",

"DevCount":0.0,"SampleStatCount":0.0,"BespokeFlagName":0.0,"CheckStatCount":null}]}

//

 grGrid with API

jQuery("#Datalist").jqGrid({

    url: URLPath,

    datatype: "json",

    height: 250,

    colModel: [

         { name: 'AppCode', index: 'AppCode', label: '申请表编号', width: 120, sorttype: "int" },

         { name: 'BusinessId', index: 'BusinessId', label: '业务ID', hidden: true },

         { name: 'Ver', index: 'Ver', label: '版本号', hidden: true },

         { name: 'RegisterId', index: 'RegisterId', label: '注册Id', hidden: true },

         { name: 'ISBespoke_Flag', index: 'ISBespoke_Flag', label: '预约标志', hidden: true },

        { name: 'ApproveFlag', index: 'ApproveFlag', label: 'APPROVEFLAG', hidden: true }

  ],

rownumbers: true, //添加左侧行号 

rowNum: 10,

rowList: [5, 10, 20, 30],

recordpos: 'left',

pager: '#gridPager',

jsonReader: {

   root: "RowsData",

   records: "RecordCount",       

   total: "PageCount", 

   page: "PageIndex",

   repeatitems: false                                               

},                   

... ...

});