123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172 |
- <%@ page language="java" contentType="text/html; charset=gbk"%>
- <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
- <%@page import="java.util.List"%>
- <%@page import="java.util.Map"%>
- <%@page import="java.util.ArrayList"%>
- <%@ page import="com.kpt.common.Util" %>
- <%@page import="java.text.DecimalFormat"%>
- <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">
- <meta http-equiv="Content-Type" content="text/html; charset=GBK" />
- <%
- String str = Util.getHeaderType(request,"库存量统计");
- response.setContentType("application/vnd.ms-excel;charset=gbk");response.setHeader("Content-disposition",str);
- %>
- <head>
- <style>
- .STYLE1 {color: #FFFFFF}
- </style>
- <!--[if gte mso 9]><xml>
- <x:ExcelWorkbook>
- <x:ExcelWorksheets>
- <x:ExcelWorksheet>
- <x:Name>readers</x:Name>
- <x:WorksheetOptions>
- <x:Print>
- <x:ValidPrinterInfo />
- </x:Print>
- </x:WorksheetOptions>
- </x:ExcelWorksheet>
- </x:ExcelWorksheets>
- </x:ExcelWorkbook>
- </xml><![endif]-->
- </head>
- <body style="margin:0";>
- <div class="content">
- <table cellspacing="1" cellpadding="0" border="0" style="width:99%;">
- <tr>
- <td align="center" colspan="6">
- <h2>库存量统计[<c:out value="${beginDate}" />至<c:out value="${endDate}" />]</h2>
- </td>
- </tr>
- </table>
- <table cellspacing="1" cellpadding="0" border="1" style="width:99%;">
- <tbody>
- <tr align="center" style="height: 25px;">
- <th rowspan="2">饲料名称</th>
- <th rowspan="2">期初</th>
- <th colspan="3">出入情况</th>
- <th rowspan="2">期末</th>
- </tr>
- <tr align="center" style="height: 25px;">
- <th>入库</th>
- <th>损耗</th>
- <th>用料</th>
- </tr>
- <c:if test="${!empty list}">
- <c:forEach var="list" items="${list}">
- <tr align="center" style="height: 25px;">
- <td><c:out value="${list.FeedName}"/></td>
- <td><c:out value="${list.qc}"/></td>
- <td><c:out value="${list.rk}"/></td>
- <td><c:out value="${list.sh}"/></td>
- <td><c:out value="${list.yl}"/></td>
- <td><c:out value="${list.qm}"/></td>
- </tr>
- </c:forEach>
- </c:if>
- </tbody>
- </table>
- </div>
- </body>
- </html>
|