budgetspreadjsdemo--.jsp 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2. pageEncoding="UTF-8"%>
  3. <%@include file="/context/mytags.jsp"%>
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  5. <t:base type="jquery,easyui,tools,DatePicker"></t:base>
  6. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  7. <head>
  8. <!--
  9. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  10. <title></title>
  11. <link rel="stylesheet" type="text/css" media="screen" href="plug-in/jqgrid/css/css/cupertino/jquery-ui-1.8.16.custom.css" />
  12. <link rel="stylesheet" type="text/css" media="screen" href="plug-in/ace/css/ui.jqgrid.css" />
  13. <link rel="stylesheet" type="text/css" media="screen" href="plug-in/jqgrid/js/src/css/jquery.searchFilter.css" />
  14. <script type="text/javascript" src="plug-in/jquery/jquery-1.11.3.min.js"></script>
  15. <script type="text/javascript" src="plug-in/jquery/jquery.jqprint.js"></script>
  16. <script type="text/javascript" src="plug-in/jqgrid/js/jquery.jqGrid.src.js"></script>
  17. <script type="text/javascript" src="plug-in/jqgrid/js/i18n/grid.locale-cn.js"></script>
  18. <script type="text/javascript" src="plug-in/tools/curdtools_zh-cn.js"></script>
  19. <script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js?skin=metrole"></script>
  20. <script src = "webpage/cn/com/lzt/report/purchaseRptCommon.js"></script>
  21. <script type="text/javascript" src="plug-in/tableExport/libs/FileSaver/FileSaver.min.js"></script>
  22. <script type="text/javascript" src="plug-in/tableExport/libs/js-xlsx/xlsx.core.min.js"></script>
  23. <script type="text/javascript" src="plug-in/tableExport/tableExport.min.js"></script>
  24. -->
  25. <meta name="spreadjs culture" content="zh-cn" />
  26. <meta charset="utf-8" />
  27. <meta name="viewport" content="width=device-width, initial-scale=1.0" />
  28. <link href='gc.spread.sheets.x.x.x.css' rel='stylesheet' type='text/css'/>
  29. <script src='gc.spread.sheets.all.x.x.x.min.js' type='text/javascript'></script>
  30. <link rel="stylesheet" type="text/css" href="plug-in/SpreadJS/css/gc.spread.sheets.excel2016colorful.13.1.0.css">
  31. <script src="plug-in/SpreadJS/scripts/gc.spread.sheets.all.13.1.0.min.js" type="text/javascript"></script>
  32. <script src="plug-in/SpreadJS/scripts/resources/zh/gc.spread.sheets.resources.zh.13.1.0.min.js" type="text/javascript"></script>
  33. <script src = "webpage/cn/com/lzt/budget/tempsheet/data.js" type="text/javascript"></script>
  34. <link rel="stylesheet" type="text/css" href="styles.css"/>
  35. <style>
  36. .sample-tutorial {
  37. position: relative;
  38. height: 100%;
  39. overflow: hidden;
  40. }
  41. body {
  42. position: absolute;
  43. top: 0;
  44. bottom: 0;
  45. left: 0;
  46. right: 0;
  47. }
  48. </style>
  49. </head>
  50. <body style="background:#FFFFFF">
  51. <!-- <form id="form1" runat="server"> -->
  52. <div>
  53. <div id="div2">
  54. <%--查询框begin --%>
  55. <table cellpadding="0" cellspacing="1" class="formtable" style="position:fixed;top:5px;"> <!-- bottom -->
  56. <tr >
  57. <td align="right" width="600px" style="text-align: left;">
  58. <label class="Validform_label">预算主体: </label>
  59. <!-- </td>
  60. <td class="value" nowrap> -->
  61. <input id="warehouseId" name="warehouseId" type="hidden" >
  62. <input name="warehouseName" type="text" class="inputxt" style="width: 150px" id="warehouseName" readonly="readonly" />
  63. <span class="Validform_checktip"></span>
  64. <label class="Validform_label" style="display: none;">领料点</label>
  65. <t:choose hiddenName="warehouseId" hiddenid="id" url="pOrdersController.do?selectReferWareHouse&classname=cn.com.lzt.warehouse.entity.WarehouseEntity&codefield=warehouseCode&namefield=warehouseName" name="list"
  66. left="40%" width="450px" height="700px" icon="icon-search" title="领料点" textname="warehouseName" isclear="true" isInit="true" ></t:choose>
  67. </td>
  68. </tr>
  69. <tr>
  70. <td class="value">
  71. <span class="spancon" title="attType">预算年度:</span>
  72. <!-- <select name="attType" id="attType" width="100" onchange="tyepChange()" style="width: 134px">
  73. <option value="0" selected="selected">月度</option>
  74. <option value="1">季度</option>
  75. <option value="2">年度</option>
  76. </select> -->
  77. </span>
  78. <input type="text" id="attYear" name="attYear" style="width: 94px;" class="Wdate" onclick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,lang:'zh-cn',dateFmt:'yyyy'})">
  79. <span style="display:-moz-inline-box;display:inline-block;width: 20px;text-align:center;">年</span>
  80. <input type="text" id="attMonth" name="period" style="width: 94px;" class="Wdate" onclick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,lang:'zh-cn',dateFmt:'MM'})">
  81. <span style="display:-moz-inline-box;display:inline-block;width: 20px;text-align:center;">月</span>
  82. <!-- <select style="width: 104px;background: #f0f0f0;" id="attQuarters" disabled="disabled" name="attQuarters">
  83. <option value="1">1</option>
  84. <option value="2">2</option>
  85. <option value="3">3</option>
  86. <option value="4">4</option>
  87. </select> -->
  88. <!-- <span style="display:-moz-inline-box;display:inline-block;width: 40px;text-align:center;">季度</span> -->
  89. </td>
  90. <%-- <td align="right">
  91. <label class="Validform_label"> 月度: </label>
  92. </td>
  93. <td class="value">
  94. <input id="period" name="period" type="text" style="width: 150px" class="Wdate" readonly="readonly" value="${period}"
  95. onClick='WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: "yyyyMM"})' datatype="*" ignore="ignore" />
  96. <label class="Validform_label" style="display: none;"> 采购期间: </label>
  97. </td> --%>
  98. <span style="float: left;padding-left: 750px;padding-top: 34px;" >
  99. <td height="50px" align="right" colspan="8" valign="top">
  100. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-search" onclick="btn_query()">保存</a>
  101. <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-putout" onclick="btn_output()">导出excel</a>
  102. </td>
  103. <!-- <td height="50px" align="left" colspan="8"> -->
  104. <!-- <a href="#" class="easyui-linkbutton l-btn" iconcls="icon-search" style="width: 100px;" onclick="btn_query()">&nbsp; &nbsp; 查 询&nbsp; &nbsp;&nbsp; </a> -->
  105. <!-- </td> -->
  106. </span>
  107. </tr>
  108. </table>
  109. <%--查询框end --%>
  110. </div>
  111. <br/><br/><br/>
  112. <div class="sample-tutorial" style="top: 20px;height: 500px;">
  113. <div id="ss" style="width:100%;height:100%"></div>
  114. </div>
  115. <!-- <div id="div1">
  116. <table id="jqGrid"></table>
  117. <div id="pager2"></div>
  118. </div>
  119. </div> -->
  120. <!-- </form>
  121. -->
  122. <script>
  123. window.onload = function() {
  124. var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {
  125. sheetCount: 1
  126. });
  127. /*
  128. * get spread object
  129. * var spread = GC.Spread.Sheets.findControl(document.getElementById('ss'));
  130. */
  131. initSpread(spread);
  132. };
  133. function initSpread(spread) {
  134. var sd = dataSource;
  135. var sheet = spread.getActiveSheet();
  136. if (sd.length > 0) {
  137. sheet.setDataSource(sd);
  138. }
  139. sheet.setColumnWidth(0, 160);
  140. sheet.setColumnWidth(1, 160);
  141. sheet.setColumnWidth(2, 160);
  142. sheet.setColumnWidth(3, 160);
  143. }
  144. </script>
  145. </body>
  146. </html>