showuserorder.asp

闲置物品免费交易的平台

<table width="100%" 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 width="17%"><div align="center">定单号</div></td>
                <td width="16%"><div align="center">销售者</div></td>
                <td width="15%"><div align="center">购买日期</div></td>
                <td width="29%"><div align="center">数量/总费用</div></td>
                <td width="13%"><div align="center">类型</div></td>
                <td width="10%"><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 [bookjia] where username='"&request.Cookies("days6")("username")&"'  and deal=1 and  zhuangtai<6",conn,1,1
	            else
				rs_m.open "select * from [bookjia] where username='"&request.Cookies("days6")("username")&"'  and deal=1 and  zhuangtai="&zhuangtai,conn,1,1
				end if				
					
				do while not rs_m.eof
				%>
              <tr bgcolor="#FFFFFF"> 
                <td><div align="center"><a href="#" ONCLICK="window.open('viewdingdan.asp?id=<%=rs_m("id")%>&order=<%=rs_m("order")%>','Sample','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no,copyhistory=no,width=800,height=570')"><%=rs_m("order")%></a></div></td>
                <td><div align="center"> <%=rs_m("username")%> </div></td>
                <td><div align="center"><%=datevalue(rs_m("dealdate"))%></div></td>
                <td><div align="center"><%=rs_m("shuliang")%>/共<%=rs_m("zongjia")%>元</div></td>
                <td><div align="center"> 
                    <%if rs_m("leixing")=1 then response.write "竞价所得" else response.Write"一口价商品" end if%>
                  </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>