⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 type.asp

📁 壹加壹图文管理系统
💻 ASP
字号:
<%@ ENABLESESSIONSTATE = FALSE %>
<!--#include file="config.asp" -->
<!--#include file="mdb/conn.asp" -->
<HTML><HEAD>
<%
dim typename,classid,classname
if IsNumeric(Request.QueryString("typeid"))=False then
Response.Redirect"info.asp?info=错误的参数"
else
typeid=cint(Request.QueryString("typeid"))
end if
set temprs=conn.execute("select name,classid from type where id="&typeid)
typename=temprs(0)
classid=temprs(1)
set temprs=nothing
set temprs=conn.execute("select name from class where id="&classid)
classname=temprs(0)
set temprs=nothing
%>
<title><%=title%> - <%=desktoptitle%> - <%=classname%> - <%=typename%></title>
<!--#include file="intop.asp" -->

<TABLE border=0 cellPadding=0 cellSpacing=0 width=750 align=center>
  <TBODY>
    <TR> 
      <TD align=middle bgColor=#f2f2f2 vAlign=top width=701> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
          <TBODY>
            <tr> 
              <td width="100%" height="5"> <table border="0" cellpadding="0" cellspacing="0" width="750" height="1">
                  <tr> 
                    <td height="35" width="750"><b><font color="#FF0000">&nbsp;&nbsp;<a href="index.asp">返回首页</a></font>:</b> 
                      <%
sql = "SELECT * FROM class ORDER BY id DESC" 
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,0,1
if rs.eof and rs.bof then
Response.Write"还没有分类"
else
do while not rs.eof
Response.Write"| <a href='class.asp?classid="&rs("id")&"'>"&rs("name")&"</a>"
rs.movenext
loop
end if
rs.close
Set rs=Nothing
%>
                    </td>
                  </tr>
                  <TR> 
                    <form name="form1" method="get" action="search.asp">
                      <tr> 
                          <td width="100%" height="35" colspan="2" class="s">&nbsp;&nbsp;图片搜索<b>:</b> 
                            <input type="text" name="key" size="29" class="an"> 
                          <input type="submit" name="Submit" value="确定" class="an" height="20"> 
                          <input type="reset" name="reset" value="重填" class="an" height="20">
                          </td>
                      </tr>
                    </form>
                </table></td>
            </tr>
            <tr> 
              <td width="100%" background="../img/dotlineh.gif" height="1"></td>
            </tr>
            <tr> 
              <td width="100%" height="14">
                <%
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='3' class='x'><tr><td>&nbsp;您当前的位置: <a href='"&homeurl&"'>"&title&"<a> → <a href='index.asp'>"&desktoptitle&"</a> → <a href='class.asp?classid="&classid&"'>"&classname&"</a> → "&typename&"</td></tr></table>"
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='5'>"

Dim ipagecount
Dim ipagecurrent
Dim strorderBy
Dim irecordsshown  
if request.querystring("page")="" then
ipagecurrent=1
else
ipagecurrent=cint(request.querystring("page"))
end if

sql = "SELECT minipic,ck,name,id FROM desktop where typeid="&typeid&" ORDER BY id DESC" 
Set rs = Server.CreateObject("ADODB.Recordset")
rs.pagesize = 25
rs.cachesize = 25
rs.open sql,conn,1,1
ipagecount = rs.pagecount
If ipagecurrent > ipagecount Then ipagecurrent = ipagecount
If ipagecurrent < 1 Then ipagecurrent = 1
if ipagecount=0 then
response.write "<tr><td align='center'>没有任何文件</tr></td>" 
else
rs.absolutepage = ipagecurrent
irecordsshown = 0
do while irecordsshown<25 and NOT rs.EOF
Response.Write"<tr align='center'>"
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150 class='bk'></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 浏览:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150 class='bk'></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 浏览:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150 class='bk'></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 浏览:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150 class='bk'></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 浏览:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150 class='bk'></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 浏览:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"</tr>"
loop
end if
rs.Close
set rs=nothing
Response.Write"</table>"

Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='5' class='s'><tr><td height='35'>每页显示 25 个文件 共有 "&ipagecount&" 页 当前为第 "&ipagecurrent&" 页 "
if ipagecurrent=1 then
Response.Write"首页 | "
else
Response.Write"<a href='type.asp?typeid="&typeid&"&page=1'>首页</a> | "
end if
if ipagecurrent=1 then
Response.Write"上一页 | "
else
Response.Write"<a href='type.asp?typeid="&typeid&"&page="&ipagecurrent-1&"'>上一页</a> | "
end if
if ipagecount>ipagecurrent then
Response.Write"<a href='type.asp?typeid="&typeid&"&page="&ipagecurrent+1&"'>下一页</a> "
else
Response.Write"下一页" 
end if
if ipagecount>ipagecurrent then
Response.Write"| <a href='type.asp?typeid="&typeid&"&page="&ipagecount&"'>末页</a> "
else
Response.Write"| 末页 "
end if
Response.Write"</td></tr></table>"
%>
              </td>
            </tr>
            <TR> 
              <TD></TD>
            </TR>
          </TBODY>
        </TABLE>
        <SCRIPT language=JavaScript>
<!--

if (window.Event) 
document.captureEvents(Event.MOUSEUP); 

function nocontextmenu() 
{
event.cancelBubble = true
event.returnValue = false;

return false;
}

function norightclick(e) 
{
if (window.Event) 
{
if (e.which == 2 || e.which == 3)
return false;
}
else
if (event.button == 2 || event.button == 3)
{
event.cancelBubble = true
event.returnValue = false;
return false;
}

}

document.oncontextmenu = nocontextmenu; // for IE5+
document.onmousedown = norightclick; // for all others
//-->
</SCRIPT>
        <BR></TD>
    </TR>
  </TBODY>
</TABLE>
<!--#include file="infoot.asp" -->  
</BODY></HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -