showuserjingjiabooks.asp

闲置物品免费交易的平台

<table width="90%" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
  <tr> 
    <td width="100%" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
      <table width=100% align=center class=table-shang border=0 cellpadding=0 cellspacing=0 bgcolor=#f1f1f1>
        <TR> 
          <TD bgColor=#ffffff height=1></TD>
        <tr> 
          <td height=30 align=center><div align="center"> <a href="user.asp?action=dingdan&zhuangtai=0">全部订单</a> 
              <a href="user.asp?action=dingdan&zhuangtai=1">未作任何处理</a> <a href="user.asp?action=dingdan&zhuangtai=2">用户已经划出款</a> 
              <a href="user.asp?action=dingdan&zhuangtai=3">服务商已经收到款</a> <a href="user.asp?action=dingdan&zhuangtai=4">服务商已经发货</a> 
              <a href="user.asp?action=dingdan&zhuangtai=5">用户已经收到货</a></div>
            </td>
        </tr>
        <TR> 
          <TD bgColor=#cccccc height=1><table width="100%" height="42" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td><div align="center">定单号</div></td>
                <td><div align="center">商品名称</div></td>
                <td><div align="center">数量/总费用</div></td>
                <td><div align="center">处理</div></td>
              </tr>
			    <%
				dim zhuangtai
				zhuangtai=request("zhuangtai")	
				set rs_m=server.CreateObject("adodb.recordset")
				if zhuangtai=0 or zhuangtai="" then
				rs_m.open "select * from [bookorder] where username='"&request.Cookies("days6")("username")&"' and  zhuangtai<6",conn,1,1
	            else
				rs_m.open "select * from [bookorder] where username='"&request.Cookies("days6")("username")&"' and  zhuangtai="&zhuangtai,conn,1,1
				end if
				
				do while not rs_m.eof
				%>
              
			  <tr bgcolor="#FFFFFF"> 
                <td><div align="center"><%=rs_m("order")%></div></td>
                <td><div align="center"><%response.Write ""&zhuangtai&""%></div></td>
                <td><div align="center"></div></td>
                <td><div align="center"></div></td>
              </tr>
			  <%
   rs_m.movenext
  loop
  rs_m.close
  set rs_m=nothing%>
			  
            </table></TD>
        </TR>
      </table>
        
    </td>
</tr>
</table>