www.gusucode.com > 盐城分类信息网asp源码程序 > comall.asp
<% '*********************************** '本站由吉林信息网团队制作 '*********************************** '--------版权说明------------------ '吉林信息网官方网站:http://www.jl-e.com 'QQ:304133183 '*********************************** %><!--#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 [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 [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"> <LINK href="images/at_news.css" type=text/css rel=stylesheet> <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"> </td> <td width="90%"> <font color="#808080">商家模式:</font>特约商家<br> <font color="#808080">店主:</font><%=rs("name")%>(<%=rs("username")%>)<br> <font color="#808080">积分:</font><%=rs("jf")%><br> <font color="#808080"> 物品数:</font><%=n%><br> <font color="#808080">创店时间:</font><%=formatdatetime(rs("zcdata"),1)%><br> <font color="#808080">商家地址:</font><%=left(rs("dizhi"),10)%><br> <a target="_blank" href="com_mail.asp?com=<%=rs("username")%>">给店家发信息</a> <%if rs("qq")<>"" then %> <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"> </td> </tr> <tr> <td height="329" colspan="2"> </td> </tr> <tr> <td height="64" valign="top"> </td> <td height="64" valign="top"> <font color="#808080">地址:<%=rs("dizhi")%><br> 电话:<%=rs("dianhua")%><br> 传真:<%=rs("fax")%><br> 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> </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 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=tmpstr 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 %> <% '*********************************** '本站由吉林信息网团队制作 '*********************************** '--------版权说明------------------ '吉林信息网官方网站:http://www.jl-e.com 'QQ:304133183 '*********************************** %>