<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>我的物品</title>
<STYLE type=text/css>
A:link {COLOR: #000000; FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:visited {	COLOR: #000000; FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:active { COLOR: #ff0000; FONT-FAMILY: 宋体; TEXT-DECORATION: none}
A:hover {COLOR: #ff0000; TEXT-DECORATION: none}
BODY {FONT-SIZE: 9pt}
TH {FONT-SIZE: 9pt}
TD {FONT-SIZE: 9pt}
</STYLE>
</head>
<body bgcolor="#396BA5">
<div align="center">
  <center>
  <table border="0" cellspacing="1" cellpadding="3" height="132">
    <tr>
      <td width="520" align="center" colspan="5" bgcolor="#BDD6FF" style="border-style: ridge; border-width: 1" height="14">我 
        的 物 品</td>
    </tr>
    <tr>
      <td width="120" align="center" bgcolor="#C6C6C6" height="17">图&nbsp; 片</td>       
      <td width="150" align="center" bgcolor="#C6C6C6" height="17">物 品 名 称</td>      
      <td width="50" align="center" bgcolor="#C6C6C6" height="17">数量</td>      
      <td width="80" align="center" bgcolor="#C6C6C6" height="17">购买价格</td>      
      <td width="120" align="center" bgcolor="#C6C6C6" height="17">操&nbsp;&nbsp;&nbsp;  
        作</td>     
    </tr>     
<% 
if session("userid")<>"" then
set rs=Server.CreateObject("ADODB.RecordSet")    
Rs.open "Select * from userbox where userid="&session("userid"),conn,1,3    
if not rs.eof then    
	while NOT rs.EOF%>    
    <tr title="<%=Rs("Memo")%>">     
      <td width="120" bgcolor="#F7F7F7" height="20">  
        <p align="center"><img border="0" src="<%=rs("Facies")%>"></p> 
      </td>   
      <td width="150" bgcolor="#F7F7F7" height="20"><%=rs("ProductName")%></td>   
      <td width="50" bgcolor="#F7F7F7" height="20"> 
        <p align="center"><%=rs("Quantity")%>　</p> 
      </td>   
      <td width="80" bgcolor="#F7F7F7" height="20"> 
        <p align="center"><%=rs("Price")%>　</p> 
      </td>   
      <td width="120" bgcolor="#F7F7F7" height="20"> 
        <p align="center"><a href="#" onclick="if(window.confirm('你确定要删除吗？')==true){window.location.href='delete.asp?wp=<%=rs("id")%>';}">删除</a> | <a href="userboxrun.asp?wp=<%=rs("id")%>">使用</a></p>
      </td>  
    </tr>  
	<%
	rs.movenext
	wend
else%> 
 
    <tr>  
      <td width="520" bgcolor="#F7F7F7" colspan="5" height="14"> 
        <p align="center">您 现 在 没 有 任 何 物 品！</td> 
    </tr> 


<%end if
else%>

    <tr>  
      <td width="520" bgcolor="#F7F7F7" colspan="5" height="14"> 
        <p align="center">您 是 谁 呀？ 不 认 识 你！</td> 
    </tr> 



<%end if%>    
  </center>  
    <tr> 
      <td width="520" bgcolor="#C6C6C6" colspan="5" height="27">
        <p align="right">　</p>  
      </td>   
    </tr>   
  </table>   
</div>   
   
</body>   
   
</html>