Guest User

Untitled

a guest
Oct 24th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. Init: function () {
  2. dt_GlobalSettings_LanguageList = $("#GlobalSettings_Language-LanguageList").DataTable({
  3. "ajax": {
  4. "url": "/Ajax/JsonProvider?Method=LanguageList&GenericObject=true",
  5. "dataSrc": ""
  6. },
  7. "columns": [
  8. {
  9. "data": "LanguageID",
  10. "sTitle": "ID"
  11. },
  12. {
  13. "data": "Language",
  14. "sTitle": "İngilizce"
  15. }
  16. ],
  17. "pageLength": 20,
  18. "lengthMenu": [
  19. [20, 50, 100, -1],
  20. [20, 50, 100, "All"]
  21. ],
  22. "info": false,
  23. bFilter: true,
  24. bInfo: false,
  25. "order": [[0, "desc"]],
  26. "dom": 'T<"clear">lfrtip',
  27. "scrollX": true
  28. });
  29. }
  30.  
  31. public LanguageList(var pageNumber,var pageLength){
  32. var startIndex = ((pageNumber-1)*pageLength)+1;
  33. var endIndex = pageNumber*pageLength;
  34. //or ı thınk datatable is already counting that directly start and end index?
  35. callList(startIndex , endIndex);
  36. }
  37.  
  38. //call index query
  39. "select * from language where LanguageID between '" + startIndex + "'AND'" + endIndex +";
Add Comment
Please, Sign In to add comment