获取后台数据的JSP,导出的单号为科学计数法2.22426E+17时,只需样式<td style="mso-number-format:'@';">222426115447789982</td>就可改为222426115447789982
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/wcm/other/template/export/wcm/top.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title><spring:message code="订单管理"/></title>
<jsp:include page="/wcm/other/template/export/wcm/style.jsp"></jsp:include>
</head>
<body >
<table class="common1" cellpadding="5" cellspacing="1" align="center" border="1">
<tr>
<td class="formtitle" colspan="19"><CENTER>
<spring:message code="订单信息"/>
</CENTER></td>
<td class="formtitle" colspan="7"><CENTER>
<spring:message code="购买人信息"/>
</CENTER></td>
<td class="formtitle" colspan="6"><CENTER>
<spring:message code="收货人信息"/>
</CENTER></td>
<td class="formtitle" colspan="5"><CENTER>
<spring:message code="商品信息"/>
</CENTER></td>
</tr>
<tr>
<td class="formtitle" align="center" ><spring:message code="订单号"/></td>
<td class="formtitle" align="center" ><spring:message code="下单日期"/></td>
<td class="formtitle" align="center" ><spring:message code="配送方式"/></td>
<td class="formtitle" align="center" ><spring:message code="支付方式"/></td>
<td class="formtitle" align="center" ><spring:message code="支付类型"/></td>
<td class="formtitle" align="center" ><spring:message code="购买商品总数量"/></td>
<td class="formtitle" align="center" ><spring:message code="商品总花费"/></td>
<td class="formtitle" align="center" ><spring:message code="是否开发票"/></td>
<td class="formtitle" align="center" ><spring:message code="发票类型"/></td>
<td class="formtitle" align="center" ><spring:message code="发票头"/></td>
<td class="formtitle" align="center" ><spring:message code="发票内容"/></td>
<td class="formtitle" align="center" ><spring:message code="税金"/></td>
<td class="formtitle" align="center" ><spring:message code="重量"/></td>
<td class="formtitle" align="center" ><spring:message code="物流费用"/></td>
<td class="formtitle" align="center" ><spring:message code="是否保价"/></td>
<td class="formtitle" align="center" ><spring:message code="保价费用"/></td>
<td class="formtitle" align="center" ><spring:message code="单据最终金额"/></td>
<td class="formtitle" align="center" ><spring:message code="减免金额"/></td>
<td class="formtitle" align="center" ><spring:message code="备注"/></td>
<td class="formtitle" align="center" ><spring:message code="会员"/></td>
<td class="formtitle" align="center" ><spring:message code="姓名"/></td>
<td class="formtitle" align="center" ><spring:message code="手机号码"/></td>
<td class="formtitle" align="center" ><spring:message code="座机号码"/></td>
<td class="formtitle" align="center" ><spring:message code="联系邮箱"/></td>
<td class="formtitle" align="center" ><spring:message code="详细地址"/></td>
<td class="formtitle" align="center" ><spring:message code="邮编"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人地址"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人详细地址"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人邮编"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人手机"/></td>
<td class="formtitle" align="center" ><spring:message code="收货人座机"/></td>
<td class="formtitle" align="center" ><spring:message code="货号"/></td>
<td class="formtitle" align="center" ><spring:message code="货品名称"/></td>
<td class="formtitle" align="center" ><spring:message code="单价"/></td>
<td class="formtitle" align="center" ><spring:message code="数量"/></td>
<td class="formtitle" align="center" ><spring:message code="小计"/></td>
</tr>
<c:forEach var="data" items="${datas }">
<c:set value="${data.details }" var="details"></c:set>
<c:set value="${fn:length(details) }" var="rows"></c:set>
<tr>
<td align="left" rowspan="${rows}" style="mso-number-format:'@';">${(data.no!=null && data.no!='')?"":""}${data.no}</td>
<td align="left" rowspan="${rows}"><fmt:formatDate value="${data.addDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
<td align="left" rowspan="${rows}">${data.deliveryType.name}</td>
<td align="left" rowspan="${rows}">${data.paymentType.name}</td>
<td align="left" rowspan="${rows}">${data.isGuarantee==1?"担保交易":"即时到账"}</td>
<td align="right" rowspan="${rows}">${data.itemNum}</td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.costItem}" pattern="#0.00"/></td>
<td align="center" rowspan="${rows}">${data.isTax==1?"是":"否"}</td>
<td align="left" rowspan="${rows}">${data.taxType.name}</td>
<td align="left" rowspan="${rows}">${data.taxTitle}</td>
<td align="left" rowspan="${rows}">${data.taxContent.name}</td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.costTax}" pattern="#0.00"/></td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.weight}" pattern="#0.000"/></td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.costShip}" pattern="#0.00"/></td>
<td align="center" rowspan="${rows}">${data.isProtect==1?"是":"否"}</td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.costPayment}" pattern="#0.00"/></td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.finalAmount}" pattern="#0.00"/></td>
<td align="right" rowspan="${rows}"><fmt:formatNumber value="${data.pmtAmount}" pattern="#0.00"/></td>
<td align="right" rowspan="${rows}">${data.remark}</td>
<td align="left" rowspan="${rows}">${data.member.usern}</td>
<td align="left" rowspan="${rows}">${data.member.realName}</td>
<td align="center" rowspan="${rows}">${data.member.mobile}</td>
<td align="left" rowspan="${rows}">${data.member.telephone}</td>
<td align="left" rowspan="${rows}">${data.member.email}</td>
<td align="left" rowspan="${rows}">${data.member.province.areaName }-${data.member.city.areaName }-${data.member.area.areaName }</td>
<td align="left" rowspan="${rows}">${data.member.zip}</td>
<td align="left" rowspan="${rows}">${data.shipName}</td>
<td align="left" rowspan="${rows}">${data.province.areaName}-${data.city.areaName}-${data.area.areaName}</td>
<td align="left" rowspan="${rows}">${data.shipAddr}</td>
<td align="left" rowspan="${rows}">${data.shipZip}</td>
<td align="left" rowspan="${rows}">${data.shipMobile}</td>
<td align="left" rowspan="${rows}">${data.shipTelephone}</td>
<c:forEach var="detail" items="${details }" varStatus="var">
<c:if test="${var.index==0 }">
<td align="left" >${detail.productNo}</td>
<td align="left" ><a href="${website.domain }/product/${detail.goods.no }.htm">${detail.name}</a></td>
<td align="right" ><fmt:formatNumber value="${detail.price}" pattern="#0.00"/></td>
<td align="right" ><fmt:formatNumber value="${detail.amount}" pattern="#0.00"/></td>
<td align="right" ><fmt:formatNumber value="${detail.cost}" pattern="#0.00"/></td>
</c:if>
</c:forEach>
</tr>
<c:forEach var="detail" items="${details }" varStatus="var">
<c:if test="${var.index>0 }">
<tr>
<td align="left" >${detail.productNo}</td>
<td align="left" ><a href="${website.domain }/product/${detail.goods.no }.htm">${detail.name}</a></td>
<td align="right" ><fmt:formatNumber value="${detail.price}" pattern="#0.00"/></td>
<td align="right" ><fmt:formatNumber value="${detail.amount}" pattern="#0.00"/></td>
<td align="right" ><fmt:formatNumber value="${detail.cost}" pattern="#0.00"/></td>
</tr>
</c:if>
</c:forEach>
</c:forEach>
</table>
</body>
</html>