www.gusucode.com > 盐城分类信息网asp源码程序 > com.asp
<!--#include file="inc/conn.asp"-->
<!--#include file="cte.asp"-->
<%
dim com,rs,sql,k
com=CheckStr(trim(request("m")))
set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from [com] where username='"&com&"'"
rs.open sql,conn,1,3
if rs.bof or rs.eof then
response.redirect "/"
end if
rs("tong")=rs("tong")+1
rs.update
%>
<%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">
<title><%=rs("com")%>-首页-<%=title%></title>
</head>
<body bgcolor=#629FBB>
<%call ct()%>
<table width="782" height="562" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#E3F3FF">
<tr>
<td width="193" height="35" valign="top">
<table width="100%" height="682" border="0" cellpadding="0" cellspacing="0" background="image/t_02.jpg">
<tr>
<td height="14" colspan="2">
<img border="0" src="image/t_01.jpg" width="223" height="35"></td>
</tr>
<tr>
<td height="91" colspan="2" background="image/t_02.jpg"><table width="166" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <font color="#396A82">商家模式：</font>特约商家<br>
<font color="#396A82">店主：</font><%=rs("name")%>(<%=rs("username")%>)<br> <font color="#396A82">积分：</font><%=rs("jf")%><br> <font color="#396A82"> 物品数：</font><%=n%><br>
<font color="#396A82">创店时间：</font><%=formatdatetime(rs("zcdata"),1)%><br> <font color="#396A82">商家地址：</font><%=left(rs("dizhi"),8)%><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>
</table></td>
</tr>
<tr>
<td height="329" colspan="2"> </td>
</tr>
<tr>
<td width="10%" height="159" valign="top"><br></td>
<td width="90%" valign="top"><font color="#396A82">地址：<%=rs("dizhi")%><br>
电话：<%=rs("dianhua")%><br>
传真：<%=rs("fax")%><br>
E-mail：<%=rs("email")%></font></td>
</tr>
</table></td>
<td valign="top">
<table border="0" cellspacing="0" cellpadding="0" id="table3" width="100%">
<tr>
<td height="35" background="image/centertopbg.jpg">
<marquee onMouseOver="this.stop()" onMouseOut="this.start()" scrollamount="3" scrolldelay="121" behavior="scroll" height="14" style="font-size: 10pt; " width="513">最新公告：<%=rs("comgg")%></marquee></td>
</tr>
<tr>
<td height="51" background="image/rightt12.jpg"> <span class="sortbiaoti2"> 关于我们 </span> </td>
</tr>
<tr>
<td>
<TABLE width="100%" border=0 cellPadding=0 cellSpacing=0 bgcolor="#EBF8FE">
<TBODY>
<TR>
<TD width="319" valign="top"> <u><b><a href="comabout.asp?com=<%=rs("username")%>"><font color="#396A82"><%=rs("com")%>简介</font></a></b></u><font color="#396A82"><br> <%=HTMLDecode(left(rs("comabout"),220))%></font>
</TD>
<TD align=middle>
<TABLE style="BORDER-COLLAPSE: collapse"
borderColor=#999999 cellSpacing=0 cellPadding=4
align=right border=1>
<TBODY>
<TR>
<TD align=middle width="200"><p align="center"><%if rs("logo")<>"" then %><a href="comabout.asp?com=<%=rs("username")%>"><img onload="javascript:DrawImage(this);" border="0" src="<%=rs("logo")%>" title="点击放大" height="250" width="250"></a><%else%><%end if%><br>
<a href="javascript:window.external.AddFavorite('<%=web%>/com.asp?com=<%=rs("username")%>', '<%=rs("com")%>-<%=title%>')"><img border="0" src="image/bookmark.gif"><font color="#835E07">收藏此店铺</font></a><br></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top width=7 bgColor=#dadada
rowSpan=2><IMG height=6
src="image/t_05.jpg"
width=7></TD></TR></TBODY></TABLE></div></td>
</tr>
</table>
<table width="558" border="0" cellpadding="0" cellspacing="0" bgcolor="#E3F3FF">
<tr>
<td height="51" background="image/rightt12.jpg" > <span class="sortbiaoti2"> 产品展示</span></td>
</tr>
<tr>
<td bgcolor="#E3F3FF">
<TABLE border=0>
<tr>
<%
dim j
set rstj_a=server.createobject("adodb.recordset")
sqltj_a="select top 12 * 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:#F9F9F9" 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="118" 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)%>...</a><%else%><u><b><%=left(rstj_a("biaoti"),12)%></b></u><br><%=left(rstj_a("memo"),40)%>...<%end if%></td>
<%
rstj_a.movenext
next
%> </tr>
<%
wend
rstj_a.close
%>
</TABLE></td>
</tr>
<script type="text/javascript"><!--
google_ad_client = "pub-6284420932188878";
/* 468x60, 创建于 08-4-10 */
google_ad_slot = "6199419321";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
</table>
</td>
</tr>
</table>
</div>
<%call ce()%>
</body>
</html>
<%
rs.close
set rs=nothing
closedb
%>