Advertisement
Guest User

Untitled

a guest
Apr 25th, 2014
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.49 KB | None | 0 0
  1. jQuery("#jqGrid01").jqGrid({
  2. // data: mydata, datatype: "local",
  3. url:'localhost/gridx/dashb_grid', mtype : "get", datatype: "json",
  4. jsonReader: { root: "rows", page: "page", total: "total", records: "records", repeatitems: true, cell: 'cell', id: 'stock1', userdata: 'userdata'},
  5. height: $gridh, rowNum: 100, rowList: [100,200,300,500,1000,2000,3000],
  6. colNames:['Stock 1','Stock 2', 'Price 1', 'Price 2','Ratio','Correlation','ST % Mean', 'ST Drift', 'LT % Mean', 'LT Drift', 'RSI', 'RSI Drift', 'Beta 1', 'Beta 2', 'Industry 1', 'Industry 2', 'Earnings 1', 'Earnings 2'],
  7. colModel:[
  8. {name:'stock1',index:'stock1', width:30, searchoptions:{sopt:['eq','ne','cn','bw','ew','lt','gt']}},
  9. {name:'stock2',index:'stock2', width:30, searchoptions:{sopt:['eq','ne','cn','bw','ew','lt','gt']}},
  10. {name:'price1',index:'price1', width:30, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  11. {name:'price2',index:'price2', width:30, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  12. {name:'ratio',index:'ratio', width:30, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  13. {name:'correlation',index:'correlation', width:42, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  14. {name:'st_mean',index:'st_mean', width:38, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  15. {name:'st_drift',index:'st_drift', width:35, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  16. {name:'lt_mean',index:'lt_mean', width:39, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  17. {name:'lt_drift',index:'lt_drift', width:35, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  18. {name:'rsi',index:'rsi', width:30, sorttype:"int", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  19. {name:'rsi_drift',index:'rsi_drift', width:35, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  20. {name:'beta1',index:'beta1', width:30, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  21. {name:'beta2',index:'beta2', width:30, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  22. {name:'industry1',index:'industry1', width:102, search:false},
  23. {name:'industry2',index:'industry2', width:102, search:false},
  24. {name:'earnings1',index:'earnings1', width:45, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}},
  25. {name:'earnings2',index:'earnings2', width:45, sorttype:"float", align:"right", searchoptions:{sopt:['eq','ne','lt','gt']}}
  26. ],
  27. pager: "#jqGridPager01",
  28. viewrecords: true, hidegrid:false,
  29. sortname: 'stock1', sortorder: 'asc',
  30. loadComplete: function() {
  31. // test
  32.  
  33. }
  34. });
  35.  
  36. [HttpPost]
  37. public JsonResult LoadPackages(int page, int rows, string sord, string sidx, string PackageNumber)
  38. {
  39.  
  40. liPackages = new List<PackageModel>();
  41. if (PackageNumber == "")
  42. {
  43. liPackages = _packageRepository.LoadPackages((page - 1) * rows, rows, sord, sidx, out strTotalRecords);
  44. long lCount = Convert.ToInt64(strTotalRecords);
  45. return Json(new
  46. {
  47. total = Math.Ceiling((Decimal)lCount / (Decimal)rows),
  48. page = page,
  49. records = lCount,
  50. rows = liPackages
  51. },
  52. JsonRequestBehavior.AllowGet);
  53. }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement