📄 info.asp
字号:
<!--#include file="conn.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style2 {color: #FF0000}
.style4 {color: #009900}
.style5 {color: #CC0066}
.style7 {color: #CC0033}
-->
</style>
</head>
<body>
<div align="left">
<!--#include file=top.asp-->
</div>
<table width="946" border="1">
<tr>
<th width="184" height="107" bgcolor="#FFCC66" scope="col"><!--#include file=login.asp--> </th>
<th width="222" bgcolor="#FFCC66" scope="col"><!--#include file=searchgoods.asp--> </th>
<th width="205" bgcolor="#FFCC66"> <!--#include file=searchinfo.asp--></th>
<th width="307" bgcolor="#FFCC66"><div align="left">
<table width="100%" border="0" height="100%" >
<tr >
<th scope="col"><!--#include file=announce.asp--></th>
</tr>
<tr>
<th height="83" scope="col"> </th>
</tr>
</table>
</div></th>
</tr>
</table>
<table width="945" height="136" border="1" bordercolor="#3366FF" bgcolor="#99FFCC">
<tr>
<th width="183" height="73" scope="col"><!--#include file=newgoodsinfo.asp--></th>
<th width="617" scope="col"><div align="center">
<table width="100%" height="72" border="1" bordercolor="#FFFFFF" bgcolor="#CCCCCC" >
<tr>
<th width="123" height="24" bgcolor="#FF9900" scope="col"><span class="style7"> 方式 </span></th>
<th width="287" bgcolor="#FF9900" scope="col"><span class="style7"> 标 题 </span></th>
<th width="85" bgcolor="#FF9900" scope="col"><span class="style7"> 姓名 </span></th>
<th width="88" bgcolor="#FF9900" scope="col"><span class="style7"> 日期 </span></th>
</tr>
<%
Set rs=Server.CreateObject("ADODB.Recordset")
class1=request.QueryString("class1")
class2=request.QueryString("class2")
key2=request.QueryString("key2")
if key2="" then
if class1="" then
sql="select * from info where isdiposal=yes order by toolc_num desc,date desc"
else if class2="" then
sql="select * from info where class1="& class1 &" and isdiposal=yes order by toolc_num desc,date desc"
else
sql="select * from info where isdiposal=yes and class1="& class1 &" and class2="& class2 &" order by toolc_num desc,date desc"
end if
end if
else
if class1="" then
sql="select * from info where isdiposal=yes and (title like '%"& key2 &"%'"& "or info like '%"& key2 &"%') order by toolc_num desc, date desc"
else
sql="select * from info where isdiposal=yes and class1="& class1 & " and (title like '%"& key2 &"%'"& " or info like '%"& key2 &"%') order by toolc_num desc,date desc"
end if
end if
rs.open sql,conn,1,1
if Not rs.EOF and Not rs.BOF then
if Request.QueryString("page_no")="" then
page_no=1
else
page_no=cint(Request.QueryString("page_no"))
end if
rs.PageSize=20
rs.AbsolutePage=page_no
I=rs.PageSize
do while Not rs.EOF and I>0
I=I-1
%>
<tr>
<th height="30" scope="col">
<%
if rs(5)=0 then
%>
<span class="style4">求购</span><%else%>
<span class="style5">出售</span><%end if%> </th>
<th scope="col"><a href="showinfo.asp?info_id=<%=rs(0)%>" class="style7"><%=rs(4)%></a></th>
<th scope="col"><%=rs(1)%></th>
<th scope="col"><%=rs("date")%></th>
</tr>
<%
rs.MoveNext
loop
%>
</table>
</div>
<div align="center">
<table width="590" border="1" bordercolor="#66FF66" bgcolor="#3366CC">
<tr>
<th width="580" scope="col">请选择页面：
<%
for I=1 to rs.PageCount
if I=page_no then
Response.Write I & " "
else
Response.Write ("<a href='goods.asp?key="& key &"&class1="& class1 &"&class2="& class2 &"&page_no=" & I & "'>" & I & "</a>")
end if
next
else
Response.Write "没有信息!"
end if
%></th>
</tr>
</table>
</div>
<div align="center">
<%rs.close%>
</div></th>
<th width="123" scope="col"> </th>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -