<%@ 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"%> <% String str = Util.getHeaderType(request,"日计划"); response.setContentType("application/vnd.ms-excel;charset=gbk");response.setHeader("Content-disposition",str); %>

日计划打印表(按每次投料量)

日计划打印表(按投料累加量)

日计划打印表(按发料量)

牧场日粮配合表()

牧场日粮累加配合表()

日计划打印表(包装量)

牧场日粮实发表((单位:公斤))

<% Boolean tmrFlag = (Boolean) request.getAttribute("tmrFlag"); String btnType = (String) request.getAttribute("btnType"); List colList = (List) request.getAttribute("colList"); List rsList = (List) request.getAttribute("rsList"); Float lsVale = 0F; DecimalFormat fnum = new DecimalFormat("##0.0"); if("1".equals(btnType)){ for (int i = 0; i < rsList.size(); i++){ lsVale = 0F; Map rsMap = (Map) rsList.get(i); %> <% for (int j = 0; j < colList.size(); j++){ Map colMap = (Map) colList.get(j); String colName = (String)colMap.get("name"); if("没有数据!".equals(colName)){ %> <% }else{ if("车次".equals(colName)||"时间".equals(colName)||"配方模板".equals(colName)||"日系数比例".equals(colName)||"驾驶员".equals(colName)||"班组".equals(colName)){ String colValueOld = (String)rsMap.get(colName); %> <% }else if("TMR".equals(colName)){ if(tmrFlag){ String colValueOld = (String)rsMap.get(colName); %> <% } }else{ String colValueOld = (String)rsMap.get(colName); if(!colValueOld.isEmpty()){ Float colValue = Float.valueOf(colValueOld); if(lsVale == 0){ lsVale = colValue; }else{ lsVale += colValue; } String colValueNew = fnum.format(lsVale); %> <% }else{ %> <% } } } } %> <% } }else{ for (int i = 0; i < rsList.size(); i++){ Map rsMap = (Map) rsList.get(i); %> <% for (int j = 0; j < colList.size(); j++){ Map colMap = (Map) colList.get(j); String colName = (String)colMap.get("name"); if("没有数据!".equals(colName)){ %> <% }else{ Object colValueOld = (Object)rsMap.get(colName); if(!"TMR".equals(colName)){ %> <% }else{ if(tmrFlag){ %> <% } } } } %> <% } } %>
没有数据!
没有数据!