processexcel.jsp 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133
  1. <%@ page language="java" contentType="text/html; charset=gbk"%>
  2. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  3. <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
  4. <%@ page import="com.kpt.common.Util" %>
  5. <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">
  6. <meta http-equiv="Content-Type" content="text/html; charset=GBK" />
  7. <%
  8. String str = Util.getHeaderType(request,"过程分析");
  9. response.setContentType("application/vnd.ms-excel;charset=gbk");response.setHeader("Content-disposition",str);
  10. %>
  11. <head>
  12. <style>
  13. .STYLE1 {color: #FFFFFF}
  14. </style>
  15. <!--[if gte mso 9]><xml>
  16. <x:ExcelWorkbook>
  17. <x:ExcelWorksheets>
  18. <x:ExcelWorksheet>
  19. <x:Name>readers</x:Name>
  20. <x:WorksheetOptions>
  21. <x:Print>
  22. <x:ValidPrinterInfo />
  23. </x:Print>
  24. </x:WorksheetOptions>
  25. </x:ExcelWorksheet>
  26. </x:ExcelWorksheets>
  27. </x:ExcelWorkbook>
  28. </xml><![endif]-->
  29. </head>
  30. <body style="margin:0";>
  31. <div class="content">
  32. <table cellspacing="1" cellpadding="0" border="0" style="width:99%;">
  33. <tr>
  34. <td align="center" colspan="8">
  35. <h1>TMR计划执行情况明细</h1>
  36. </td>
  37. </tr>
  38. </table>
  39. <c:if test="${empty list}"><tr align="center" class="greb" style="height: 25px;"><td colspan="8">没有对应的结果</td></tr></c:if>
  40. <c:if test="${!empty list}">
  41. <c:forEach var="list" items="${list}">
  42. <table cellspacing="1" cellpadding="0" border="1" style="width:100%" class="tabsty">
  43. <tbody>
  44. <tr align="center" class="greb" style="height: 25px;">
  45. <td>TMR</td>
  46. <td>计划名称</td>
  47. <td align="left" colspan="2">制定日期</td>
  48. <td align="left" colspan="4">开始日期</td>
  49. </tr>
  50. <tr align="center" class="greb" style="height: 25px;">
  51. <td><c:out value="${list.TNAME}" /></td>
  52. <td><c:out value="${list.ProjName}" /></td>
  53. <td align="left" colspan="2"><c:out value="${list.Mydate}" /></td>
  54. <td align="left" colspan="4">[<c:out value="${list.InTime}" />]</td>
  55. </tr>
  56. <tr align="center" class="greb" style="height: 25px;">
  57. <td></td>
  58. <td>操作编号</td>
  59. <td>计划重量</td>
  60. <td>实际重量</td>
  61. <td>代表成分</td>
  62. <td>完成时间</td>
  63. <td>起始读数重量</td>
  64. <td>完成读数重量</td>
  65. </tr>
  66. <c:forEach var="p1list" items="${list.p1list}">
  67. <tr align="center" class="greb" style="height: 25px;">
  68. <td></td>
  69. <c:if test="${p1list.isWc == 1}">
  70. <td><font color="red"><b><c:out value="${p1list.SORT}" /></b></font></td>
  71. <td><font color="red"><b><c:out value="${p1list.LWEIGHT}" /></b></font></td>
  72. <td><font color="red"><b><c:out value="${p1list.ActualWeightMinus}" /></b></font></td>
  73. <td><font color="red"><b><c:out value="${p1list.FNAME}" /></b></font></td>
  74. </c:if>
  75. <c:if test="${p1list.isWc == 0}">
  76. <td><c:out value="${p1list.SORT}" /></td>
  77. <td><c:out value="${p1list.LWEIGHT}" /></td>
  78. <td><c:out value="${p1list.ActualWeightMinus}" /></td>
  79. <td><c:out value="${p1list.FNAME}" /></td>
  80. </c:if>
  81. <td><c:out value="${p1list.InTime}" /></td>
  82. <td><c:out value="${p1list.LastActualWeight}" /></td>
  83. <td><c:out value="${p1list.ActualWeight}" /></td>
  84. </tr>
  85. </c:forEach>
  86. <tr align="center" class="greb" style="height: 25px;">
  87. <td></td>
  88. <td>操作编号</td>
  89. <td>投料位置</td>
  90. <td>计划重量</td>
  91. <td>实际重量</td>
  92. <td>完成时间</td>
  93. <td>起始读数重量</td>
  94. <td>完成读数重量</td>
  95. </tr>
  96. <c:forEach var="p2list" items="${list.p2list}">
  97. <tr align="center" class="greb" style="height: 25px;">
  98. <td></td>
  99. <c:if test="${p2list.isWc == 1}">
  100. <td><font color="red"><b><c:out value="${p2list.SORT}" /></b></font></td>
  101. <td><font color="red"><b>[<c:out value="${p2list.BNAME}" />]</b></font></td>
  102. <td><font color="red"><b><c:out value="${p2list.LWEIGHT}" /></b></font></td>
  103. <td><font color="red"><b><c:out value="${p2list.ActualWeightMinus}" /></b></font></td>
  104. </c:if>
  105. <c:if test="${p2list.isWc == 0}">
  106. <td><c:out value="${p2list.SORT}" /></td>
  107. <td>[<c:out value="${p2list.BNAME}" />]</td>
  108. <td><c:out value="${p2list.LWEIGHT}" /></td>
  109. <td><c:out value="${p2list.ActualWeightMinus}" /></td>
  110. </c:if>
  111. <td><c:out value="${p2list.InTime}" /></td>
  112. <td><c:out value="${p2list.LastActualWeight}" /></td>
  113. <td><c:out value="${p2list.ActualWeight}" /></td>
  114. </tr>
  115. </c:forEach>
  116. </tbody>
  117. </table>
  118. <table cellspacing="1" cellpadding="0" border="0" style="width:100%" class="tabsty">
  119. <tbody>
  120. <tr align="center" class="greb" style="height: 25px;">
  121. <td></td>
  122. <td></td>
  123. <td></td>
  124. <td></td>
  125. </tr>
  126. </tbody>
  127. </table>
  128. </c:forEach>
  129. </c:if>
  130. </div>
  131. </body>
  132. </html>