orderformview.jsp

JavaWeb标签应用开发（随书光盘）为方便读者阅读本书和调试程序

<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ page isELIgnored="false"%>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<jsp:include page="../adminmoduleup.jsp"/>
<table border="1" cellpadding="0" cellspacing="0" width="610">
	<form action="orderformview.jsp" method="post">
	<tr><td colspan="4">
		<font size="2" color="#000080">订单处理</font>	
		<hr><font size="2" color="#000080">
		订单号：<input type="text" name="order_form_id" size="10"/>&nbsp;
		订单状态：<select name="status">
					<option value="">===所有===</option>
					<option value="0">0--新订单</option>
					<option value="1">1--客户已确认</option>
					<option value="2">2--正在配货</option>
					<option value="3">3--已发货</option>
					<option value="4">4--缺货</option>
				</html:select>
		<input type="submit" value="提交"/>
	</font></td></tr>
	</form>
</table><br>
<table border="1" cellpadding="0" cellspacing="0" width="610">
	<tr><td colspan="4" align="right"><font size="2" color="#000080">
		 订单状态:0（0--新订单 1--客户已确认  2--正在配货 3--已发货 4--缺货）
	</td></tr>
<c:if test="${(not empty param.order_form_id) or (not empty param.status)}">
	<c:set var="selectSQL" value="select order_form_id,user_id,
		status from order_form"/>
	<c:if test="${(not empty param.order_form_id) and (not empty param.status)}">
		<c:set var="selectSQL" value="${selectSQL} where order_form_id=
			${param.order_form_id} and status=${param.status}"/>
	</c:if>
	<c:if test="${(not empty param.order_form_id) and (empty param.status)}">
		<c:set var="selectSQL" value="${selectSQL} where order_form_id=
			${param.order_form_id}"/>
	</c:if>
	<c:if test="${(empty param.order_form_id) and (not empty param.status)}">
		<c:set var="selectSQL" value="${selectSQL} where status=${param.status}"/>
	</c:if>
	<sql:query dataSource="${sqlDS}" sql="${selectSQL}" var="orderFormRS"/>
	<c:forEach items="${orderFormRS.rowsByIndex}" var="orderForm">
		<tr><td align="center"><font size="2" color="#000080">订单号</font></td>
			<td align="center"><font size="2" color="#000080">客户ID号</font></td>
			<td align="center"><font size="2" color="#000080">订单状态</font></td>
			<td align="center"><font size="2" color="#000080">修改状态</font></td>
		</tr>
		<tr bgcolor="#C0C0C0"><td align="center"><font size="2" color="#000080">
			<c:out value="${orderForm[0]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:out value="${orderForm[1]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			${orderForm[2]}</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:if test="${orderForm[2]==0}">&nbsp;
			</c:if>
			<c:if test="${orderForm[2]==1}">
			<a href="../../buy/modiOrderStatus.jsp?order_form_id=${orderForm[0]}&status=2&redirect_page=../admin/orderform/orderformview.jsp">
			修改为正在配货</a>
			</c:if>
			<c:if test="${orderForm[2]==2}">
			<a href="../../buy/modiOrderStatus.jsp?order_form_id=${orderForm[0]}&status=4&redirect_page=../admin/orderform/orderformview.jsp">
			修改为缺货</a>
			<a href="../../buy/modiOrderStatus.jsp?order_form_id=${orderForm[0]}&status=3&redirect_page=../admin/orderform/orderformview.jsp">
			修改为已发货</a>
			</c:if>&nbsp;
			</font></td>
		</tr>
		<tr><td colspan=4>
			<table border="1" cellpadding="0" cellspacing="0" width="607">
      		<tr><td align="center"><font size="2" color="#000080">序号</font></td>
      			<td align="center"><font size="2" color="#000080">书名</font></td>
      			<td align="center"><font size="2" color="#000080">出版社</font></td>
      			<td align="center"><font size="2" color="#000080">数量</font></td>
      			<td align="center"><font size="2" color="#000080">单价</font></td>
      			<td align="center"><font size="2" color="#000080">总价</font></td></tr>
      		<c:set var="book_no" value="${0}"/>
      		<c:set var="allbookcount" value="${0}"/>
      		<c:set var="allbookprice" value="${0}"/>
      		<c:set var="selectSQL" value="
      			select book.book_id,book.book_name,book.publisher,order_form_book.book_count,
      			book.price,book.price_rebate from book,order_form_book where 
      			order_form_book.order_form_id=${orderForm[0]} and 
      			order_form_book.book_id=book.book_id"/>
        	<sql:query sql="${selectSQL}" var="bookRS" dataSource="${sqlDS}"/>     	
        	<c:forEach items="${bookRS.rowsByIndex}" var="book"> 
        	<tr><c:set var="book_no" value="${book_no+1}"/>
          		<td><font size="2" color="#000080">${book_no}</font></td>
          		<td><font size="2" color="#000080">
          		<a href="../../viewBook.jsp?bookId=${book[0]}">${book[1]}</a></a></font></td>
          		<td><font size="2" color="#000080">${book[2]}</font></td>
          		<c:set var="allbookcount" value="${allbookcount+book[3]}"/>
          		<td><font size="2" color="#000080">${book[3]}</font></td>
          		<td><font size="2" color="#000080">
          		<fmt:formatNumber value="${book[4]*book[5]/10}"  maxFractionDigits="2"/>
          		</font></td>
          		<td><font size="2" color="#000080">
          		<fmt:formatNumber value="${book[3]*book[4]*book[5]/10}"  maxFractionDigits="2"/>
          		<c:set var="allbookprice" value="${allbookprice+book[3]*book[4]*book[5]/10}"/>
          		</font></td>
        	</tr>
        	</c:forEach>
        	<tr><td><font size="2" color="#000080">总计</font></td>
        		<td><font size="2" color="#000080">&nbsp;</font></td>
        		<td><font size="2" color="#000080">&nbsp;</font></td>
      			<td><font size="2" color="#000080">${allbookcount}</font></td>
      			<td><font size="2" color="#000080">&nbsp;</font></td>
      			<td><font size="2" color="#000080">
      			<fmt:formatNumber value="${allbookprice}"  maxFractionDigits="2"/>
      			</font></td></tr>
      		</table><br>
		</td></tr>
	</c:forEach>
</c:if>
</table>
<jsp:include page="../adminmoduledown.jsp"/>