📄 yp_vlist.asp
字号:
<!--#include file="main.asp"-->
<%id=request("id")
if id="" then
response.write"<script>alert('操作出错,下面是产生错误的可能原因:\n\n·请选择相关参数');history.go(-1);</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from SMT_ypxxone where SMT_ypxxone_id="&id&" order by SMT_date desc"
rs.open sql,conn,1,1
ypxxone=rs("SMT_ypxxone")
rs.close%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=citytitle%></title>
</head>
<body topmargin="0">
<%SMT_TOP%>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height=30 colspan="2">当前位置:<a href=index.asp>首页</a> >> <a href=yp.asp>企业会员</a> >> <a href=yp_vlist.asp?id=<%=id%>><%=ypxxone%></a></td>
</tr>
<tr>
<td width="180" bgcolor="#efefef" style="border-right:1px #999999 solid" valign="top">
<!--==================-->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td height=25 background="img/bgtitle.gif" class=f14> <strong><font color=#ffffff><%=ypxxone%></font></strong></td></tr>
<%set rs=server.createobject("adodb.recordset")
sql="select * from SMT_ypxxtwo where SMT_ypxxone_id="&id&" order by SMT_date desc"
rs.open sql,conn,1,1%>
<tr>
<%n=0
do while not rs.eof
n=n+1
set rs1=server.createobject("adodb.recordset")
sql1="select * from SMT_yp where SMT_ypxxtwo_id="&rs("SMT_ypxxtwo_id")&" and SMT_key<>0 and SMT_key<>2 and SMT_key1=1"
rs1.open sql1,conn,1,1
twocount=rs1.recordcount
rs1.close%>
<tr><td height=25> <a href=yp_list.asp?id=<%=rs("SMT_ypxxtwo_id")%>><%=rs("SMT_ypxxtwo")%></a> <font color=red>(<%=twocount%>)</font></td></tr>
<tr><td background="img/list_line_1.gif"></td></tr>
<%rs.movenext
loop
rs.close%>
</table>
<!--==================-->
</td>
<td width="580" valign="top">
<!--==================-->
<%Call SMT_User_View(0,20,0,0,0,0,0,0,id,0,100,1,2,1,1,"yp_vlist.asp")%>
<!--==================-->
</td>
</tr>
</table>
<!--====== bottom ========-->
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor=#ffffff>
<tr><td height=2 bgcolor=#4795EC></td></tr>
<tr>
<td align="center" height=80><%=citybottom%></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -