ExcelExportForm.js 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. /*
  2. * 描 述:excel 数据导出
  3. */
  4. var mainGridId = request('mainGridId');
  5. var gridId = request('gridId');
  6. var filename = decodeURI(request('filename'));
  7. var acceptClick;
  8. var bootstrap = function ($, learun) {
  9. "use strict";
  10. var page = {
  11. init: function () {
  12. var columnModel = learun.frameTab.currentIframe().$('#' + gridId).jfGridGet('settingInfo').headData;
  13. var $ul = $('.sys_spec_text');
  14. $.each(columnModel, function (i, item) {
  15. var label = item.label;
  16. var name = item.name;
  17. if (!!label) {
  18. $(".sys_spec_text").append("<li data-value='" + name + "' title='" + label + "'><a>" + label + "</a><i></i></li>");
  19. }
  20. });
  21. $(".sys_spec_text li").addClass("active");
  22. $(".sys_spec_text li").click(function () {
  23. if (!!$(this).hasClass("active")) {
  24. $(this).removeClass("active");
  25. } else {
  26. $(this).addClass("active").siblings("li");
  27. }
  28. });
  29. }
  30. };
  31. // 保存数据
  32. acceptClick = function (callBack) {
  33. var exportField = [];
  34. $('.sys_spec_text ').find('li.active').each(function () {
  35. var value = $(this).attr('data-value');
  36. exportField.push(value);
  37. });
  38. if (exportField.length <= 0) {
  39. learun.alert.warning("请选择要导出的信息!");
  40. return;
  41. }
  42. var columnJson = JSON.stringify(learun.frameTab.currentIframe().$('#' + gridId).jfGridGet('settingInfo').headData);
  43. var rowJson = JSON.stringify(learun.frameTab.currentIframe().$('#' + gridId).jfGridGet('showData'));
  44. // 保存当前页面的单据信息
  45. var OrderJson = "";
  46. if (gridId == "gridtable")
  47. {
  48. OrderJson = "";
  49. }
  50. else {
  51. OrderJson = JSON.stringify(learun.frameTab.currentIframe().$('#' + mainGridId).jfGridGet('showData'));
  52. }
  53. learun.download({
  54. method: "POST",
  55. url: '/Utility/ExportExcel',
  56. param: {
  57. fileName: filename,
  58. columnJson: columnJson,
  59. dataJson: rowJson,
  60. orderJson: OrderJson,
  61. exportField: String(exportField)
  62. }
  63. }, function () {
  64. //关闭窗口
  65. learun.layerClose(window.name);
  66. });
  67. };
  68. page.init();
  69. }