feedpExportExcel.jsp 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081
  1. <%@ page language="java" contentType="text/html; charset=gbk"%>
  2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  3. <%@page import="java.util.List"%>
  4. <%@page import="java.util.Map"%>
  5. <%@page import="java.util.ArrayList"%>
  6. <%@ page import="com.kpt.common.Util" %>
  7. <%@page import="java.text.DecimalFormat"%>
  8. <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
  9. <meta http-equiv="Content-Type" content="text/html; charset=GBK" />
  10. <%
  11. String str = Util.getHeaderType(request,"栏舍配方");
  12. response.setContentType("application/vnd.ms-excel;charset=gbk");response.setHeader("Content-disposition",str);
  13. %>
  14. <head>
  15. <style>
  16. .STYLE1 {color: #FFFFFF}
  17. </style>
  18. <!--[if gte mso 9]><xml>
  19. <x:ExcelWorkbook>
  20. <x:ExcelWorksheets>
  21. <x:ExcelWorksheet>
  22. <x:Name>readers</x:Name>
  23. <x:WorksheetOptions>
  24. <x:Print>
  25. <x:ValidPrinterInfo />
  26. </x:Print>
  27. </x:WorksheetOptions>
  28. </x:ExcelWorksheet>
  29. </x:ExcelWorksheets>
  30. </x:ExcelWorkbook>
  31. </xml><![endif]-->
  32. </head>
  33. <body style="margin:0";>
  34. <div class="content">
  35. <table cellspacing="1" cellpadding="0" border="0" style="width:99%;">
  36. <tr>
  37. <td align="center" colspan="12">
  38. <h1>栏舍配方备份[<c:out value="${nDate}" />]</h1>
  39. </td>
  40. </tr>
  41. </table>
  42. <table cellspacing="1" cellpadding="0" border="0" style="width:99%;">
  43. <tbody>
  44. <tr align="center" style="height: 25px;">
  45. <th width="8%">栏舍名称</th>
  46. <th width="8%">实际头数</th>
  47. <th width="8%">系数</th>
  48. <th width="8%">系数头数</th>
  49. <th width="8%">配方模版</th>
  50. <th width="8%">补料模版</th>
  51. <th width="8%">早班1比例(%)</th>
  52. <th width="8%">早班2比例(%)</th>
  53. <th width="8%">中班1比例(%)</th>
  54. <th width="8%">中班2比例(%)</th>
  55. <th width="8%">晚班1比例(%)</th>
  56. <th width="8%">晚班2比例(%)</th>
  57. </tr>
  58. <c:if test="${!empty list}">
  59. <c:forEach var="list" items="${list}">
  60. <tr align="center">
  61. <td>[<c:out value="${list.BNAME}"/>]</td>
  62. <td><c:out value="${list.CCOUNT}"/></td>
  63. <td><c:out value="${list.CCountRatio}"/></td>
  64. <td><c:out value="${list.CCountRatioCCOUNT}"/></td>
  65. <td><c:out value="${list.PFMB}"/></td>
  66. <td><c:out value="${list.BLMB}"/></td>
  67. <td><c:out value="${list.Rtime1}"/></td>
  68. <td><c:out value="${list.Rtime2}"/></td>
  69. <td><c:out value="${list.Rtime3}"/></td>
  70. <td><c:out value="${list.Rtime4}"/></td>
  71. <td><c:out value="${list.Rtime5}"/></td>
  72. <td><c:out value="${list.Rtime6}"/></td>
  73. </tr>
  74. </c:forEach>
  75. </c:if>
  76. </tbody>
  77. </table>
  78. </div>
  79. </body>
  80. </html>