export1.js 4.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. function expt(grid){
  2. var tableString = '<table border="1" cellspacing="0" cellspacing="0" class="pb">';
  3. var frozenColumns = grid.datagrid("options").frozenColumns; // 得到frozenColumns对象
  4. var columns = grid.datagrid("options").columns; // 得到columns对象
  5. var nameList = new Array();
  6. // 载入title
  7. if (typeof columns != 'undefined' && columns != '') {
  8. $(columns).each(function (index) {
  9. tableString += ' <tr>';
  10. if (typeof frozenColumns != 'undefined' && typeof frozenColumns[index] != 'undefined') {
  11. for (var i = 0; i < frozenColumns[index].length; ++i) {
  12. if (!frozenColumns[index][i].hidden) {
  13. tableString += ' <th width="' + frozenColumns[index][i].width + '"';
  14. if (typeof frozenColumns[index][i].rowspan != 'undefined' && frozenColumns[index][i].rowspan > 1) {
  15. tableString += ' rowspan="' + frozenColumns[index][i].rowspan + '"';
  16. }
  17. if (typeof frozenColumns[index][i].colspan != 'undefined' && frozenColumns[index][i].colspan > 1) {
  18. tableString += ' colspan="' + frozenColumns[index][i].colspan + '"';
  19. }
  20. if (typeof frozenColumns[index][i].field != 'undefined' && frozenColumns[index][i].field != '') {
  21. nameList.push(frozenColumns[index][i]);
  22. }
  23. tableString += '>' + frozenColumns[0][i].title + '</th>';
  24. }
  25. }
  26. }
  27. for (var i = 0; i < columns[index].length; ++i) {
  28. if (!columns[index][i].hidden) {
  29. tableString += ' <th width="' + columns[index][i].width + '"';
  30. if (typeof columns[index][i].rowspan != 'undefined' && columns[index][i].rowspan > 1) {
  31. tableString += ' rowspan="' + columns[index][i].rowspan + '"';
  32. }
  33. if (typeof columns[index][i].colspan != 'undefined' && columns[index][i].colspan > 1) {
  34. tableString += ' colspan="' + columns[index][i].colspan + '"';
  35. }
  36. if (typeof columns[index][i].field != 'undefined' && columns[index][i].field != '') {
  37. nameList.push(columns[index][i]);
  38. }
  39. tableString += '>' + columns[index][i].title + '</th>';
  40. }
  41. }
  42. tableString += ' </tr>';
  43. });
  44. }
  45. // 载入内容
  46. var rows = grid.datagrid("getRows"); // 这段代码是获取当前页的所有行
  47. for (var i = 0; i < rows.length; ++i) {
  48. tableString += ' <tr>';
  49. for (var j = 0; j < nameList.length; ++j) {
  50. var e = nameList[j].field.lastIndexOf('_0');
  51. tableString += ' <td';
  52. if (nameList[j].align != 'undefined' && nameList[j].align != '') {
  53. tableString += ' style="text-align:' + nameList[j].align + ';"';
  54. }
  55. tableString += '>';
  56. if (e + 2 == nameList[j].field.length) {
  57. tableString += rows[i][nameList[j].field.substring(0, e)];
  58. }
  59. else {
  60. tableString += rows[i][nameList[j].field];
  61. }
  62. tableString += '</td>';
  63. }
  64. tableString += ' </tr>';
  65. }
  66. tableString += ' </table>';
  67. $('#hlf').val(tableString);
  68. exportString=tableString;
  69. if(exportString.length>1117005){
  70. alert("数据过大,建议分批导出!");
  71. return false;
  72. }
  73. var url="jsp/rzx/dataQuery/export.jsp";
  74. var param2={
  75. doSize:false,
  76. shadow:false,
  77. content:'<iframe scrolling="no" frameborder="0" src='+url+' style="width:100%;height:95%;"></iframe>',
  78. title:'Export',
  79. width:300,
  80. height:170,
  81. modal:true
  82. };
  83. mpgdialog(param2);
  84. }
  85. function mpgdialog(param){
  86. $('#dialog2').dialog(param);
  87. $('#dialog2').window('center');
  88. }