<!--#include file="inc/conn.asp"-->
<!--#include file="cte.asp"-->
<%
dim com,rs,sql,k
com=CheckStr(trim(request("com")))
set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from [jle_com] where username='"&com&"'" 
rs.open sql,conn,1,1
if rs.bof or rs.eof then
response.redirect "/"
end if
%>
<%dim n,rs0
set rs0=server.createobject("adodb.recordset")
set rs0=conn.execute("select count(id) from [jle_xinxi] where username='"&com&"'")
n=rs0(0)
rs0.close
%><html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=rs("com")%>-全部物品信息展示-<%=title%></title>
</head>
<body bgcolor=#629FBB>
<%call ct()%>
<div align="center">
<table width="782" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#EAF7FF" >
<tr>
<td width="193" valign="top" >
<table width="100%" height="550" border="0" cellpadding="0" cellspacing="0" background="image/t_02.jpg" id="table2">
<tr>
<td height="14" colspan="2"><img src="image/t_01.jpg" width="223" height="35"></td>
</tr>
<tr>
<td width="10%" height="91">&nbsp;</td>
<td width="90%">&nbsp;<font color="#808080">商家模式：</font>特约商家<br>
  &nbsp;&nbsp;&nbsp;&nbsp; <font color="#808080">店主：</font><%=rs("name")%>(<%=rs("username")%>)<br>
  &nbsp;&nbsp;&nbsp;&nbsp; <font color="#808080">积分：</font><%=rs("jf")%><br>
  &nbsp;&nbsp;<font color="#808080"> 物品数：</font><%=n%><br>
  &nbsp;<font color="#808080">创店时间：</font><%=formatdatetime(rs("zcdata"),1)%><br>
  &nbsp;<font color="#808080">商家地址：</font><%=left(rs("dizhi"),10)%><br>
  &nbsp;<a target="_blank" href="com_mail.asp?com=<%=rs("username")%>">给店家发信息</a>
  <%if rs("qq")<>"" then %>
  &nbsp; <a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin=<%=rs("qq")%>&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:<%=rs("qq")%>:7 alt="用QQ给他发信息"></a>
  <%end if%></td>
</tr>
<tr>
<td height="17" colspan="2">&nbsp;</td>
</tr>

<tr>
<td height="329" colspan="2">&nbsp;</td>
</tr>
<tr>
<td height="64" valign="top">&nbsp;</td>
<td height="64" valign="top">&nbsp; <font color="#808080">地址：<%=rs("dizhi")%><br>
  &nbsp; 电话：<%=rs("dianhua")%><br>
  &nbsp; 传真：<%=rs("fax")%><br>
  &nbsp; E-mail：<%=rs("email")%></font><br></td>
</tr>
</table></td>
<td valign="top">
<div align="center">
<div align="center">
<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table4">
<tr>
<td height="35" background="image/centertopbg.jpg">　</td>
</tr>
<tr>
<td height="51" background="image/rightt12.jpg" 
><span class=font1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span class="sortbiaoti2">全部物品信息</span>
　</td>
</tr>
<tr>
<td>
<div align="center">
	<TABLE border=0 height="68" width="100%">
<tr>
<% 
dim j
set rstj_a=server.createobject("adodb.recordset")
sqltj_a="select top 40 * from jle_xinxi where yz=1  and username='"&com&"' order by fbsj desc,ID desc" 	      
rstj_a.open sqltj_a,conn,1,1        
while not rstj_a.eof      
%>
<%for j=0 to 3                                      
  if rstj_a.eof then                                      
  exit for                                      
  end if                                      
  %> 
<td align="center" class= valign="top" style="; border:1px solid #CCCCCC; background-color:#F6F6F6" width="25%">
<a title="<%=rstj_a("biaoti")%>" target="_blank" href="x.asp?cnmai=<%=rstj_a("id")%>"><%if rstj_a("tupian")<>"0" and rstj_a("tupian")<>"" then%><IMG src="<%=rstj_a("tupian")%>" width="120" height="100" border=1 style="border: 1px solid #FFFFFF; ; padding-left:2px; padding-right:2px" hspace="0" ><br><u><b><%=left(rstj_a("biaoti"),7)%></b></u><br><%=left(rstj_a("memo"),20)%><font size="1">></font></a><%else%><u><b><%=left(rstj_a("biaoti"),12)%></b></u><br><%=left(rstj_a("memo"),40)%><font size="1">></font><%end if%></td>
<%     
rstj_a.movenext                          
next  
%> </tr>
<%     
wend          
rstj_a.close      
%> 
</TABLE></div></td>
</tr>
<tr>
<td width="3%">　</td>
</tr>
<tr>
<td width="3%">　</td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
</div>
<%call ce()%>
</body>

</html>
<%
rs.close
set rs=nothing
closedb
%>