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

📄 matrix3_uploadfiles.asp

📁 这是ASP的OA
💻 ASP
📖 第 1 页 / 共 2 页
字号:
<!-- #include file="const.asp" -->
<%
call opendb()
checkadmin()
dim page,sql,rs,keyword,type1
dim totalcount,totalpages,psize,i,id,px,totalsize,total
total=request.QueryString("total")
if total<>"" then 
	psize=10000
else
	psize=20
end if
page=trim(request("page"))
px=trim(request("px"))
keyword=trim(request("keyword"))
type1=trim(request("type"))
if type1="" then type1="1"
if page="" then
	page=1
else page=cint(page)
	if page<=0 then
	page=1
	end if
end if
sql="select * from m3_uploadfiles "
if keyword<>"" then
	select case type1
		case "1"
			sql=sql&"where filename like '%"&keyword&"%' "
		case "2"
			sql=sql&"where username like '%"&keyword&"%' "
		case "3"
			sql=sql&"where uploadtime like '%"&keyword&"%' "
		case "4"
			sql=sql&"where filetype like '%"&keyword&"%' "
		case "5"
			sql=sql&"where filesize >"&keyword&" "
		case else
			sql=sql&"where filename like '%"&keyword&"%' "
	end select
end if
select case px
	case "1"
		sql=sql&"order by filename asc"
	case "2"
		sql=sql&"order by filename desc"
	case "3"
		sql=sql&"order by filetype asc"
	case "4"
		sql=sql&"order by filetype asc"
	case "5"
		sql=sql&"order by filesize asc"
	case "6"
		sql=sql&"order by filesize desc"
	case "7"
		sql=sql&"order by username asc"
	case "8"
		sql=sql&"order by username desc"
	case "9"
		sql=sql&"order by downloadtimes asc"
	case "10"
		sql=sql&"order by downloadtimes desc"
	case "11"
		sql=sql&"order by uploadtime asc"
	case else
		sql=sql&"order by uploadtime desc"
		px="12"
end select
%>
<html>
<head>
<title><%=sitename%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/css.css" rel="stylesheet" type="text/css">
<script language="JavaScript">
function alertwin(url)
{
	if(confirm("确定删除文件?"))
	{
		location.href = url;
	}
}
</script>
<script language="JavaScript" src="images/effect.js"></script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="10" align="center" valign="top"> <!-- #include file="topbar.asp" --> </td>
  </tr>
  <tr> 
    <td align="center" valign="top"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="12" bgcolor="#ECE9D9">&nbsp;</td>
          <td width="1" bgcolor="#E8BC3C"></td>
          <td width="10">&nbsp;</td>
          <td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="3">
              <tr> 
                <td width="100%" height="26"><span class="v8"><img src="images/btn_face.gif" width="10" height="7"> 
                  <a href="index.asp"><%=sitename%></a> <FONT face=Webdings color="#660000">8</FONT> 
                  <a href="matrix3_admin.asp">BBS管理</a> <FONT face=Webdings color="#660000">8</FONT> 
                  文件管理</span></td>
              </tr>
              <tr> 
                <td height="1" bgcolor="#ECE9D9"></td>
              </tr>
            </table>
            <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="12"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td width="130" height="16" bgcolor="#A0AB6D">&nbsp;<span class="v8b">&nbsp;<img src="images/fang-1.gif" align="absmiddle"> 
                        </span><span class="v7"><font color="#FFFFFF">文件搜索</font></span></td>
                      <td height="16" nowrap bgcolor="#CCCCCC" class="v8b">&nbsp;</td>
                    </tr>
                  </table>
                  <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#CCCCCC">
                    <tr bgcolor="#FFFFFF"> 
                      <td valign="top" class="v7"><table border="0" cellspacing="0" cellpadding="0" width=400>
                          <form name="schform" method="post" action="search.asp">
                            <tr> 
                              <td nowrap> 搜索: 
                                <input name="keyword" type="text" class=input1 id="keyword" value="<%=keyword%>" size="10" maxlength="30">
                                &nbsp;&nbsp;选项: 
                                <select name="type" id="select" class="input1">
                                  <option value="1" <%if type1="1" then response.Write("selected")%>>文件名</option>
                                  <option value="2" <%if type1="2" then response.Write("selected")%>>上传人</option>
                                  <option value="3" <%if type1="3" then response.Write("selected")%>>上传时间</option>
                                  <option value="4" <%if type1="4" then response.Write("selected")%>>文件类型</option>
                                  <option value="5" <%if type1="5" then response.Write("selected")%>>文件大小</option>
                                </select>
                                &nbsp; 
                                <input name="imageField" type="image" src="images/sch1.gif" align="middle" width="16" height="14" border="0"> 
                                &nbsp; </td>
                            </tr>
                          </form>
                        </table></td>
                    </tr>
                  </table></td>
              </tr>
              <tr> 
                <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td height="2" bgcolor="#ECE9D9"></td>
                    </tr>
                  </table></td>
              </tr>
            </table>
            <br> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="12"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td width="130" height="12" bgcolor="#990000">&nbsp;<span class="v8b">&nbsp;<img src="images/fang-1.gif" align="absmiddle"></span><span class="v7b"><font color="#FFFFFF"> 
                        文件列表</font></span></td>
                      <td height="12" nowrap bgcolor="#CCCCCC" class="v8b">&nbsp;</td>
                    </tr>
                  </table>
                  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
                    <tr bgcolor="#FFFFFF"> 
                      <td valign="top" class="v7"><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#DCD6BA">
                          <tr> 
                            <td width="31" height="18" align="center" nowrap background="images/bg4.gif" bgcolor="#ECE9D9">*</td>
                            <td width="245" height="18" align="center" background="images/bg4.gif" bgcolor="#ECE9D9"><a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=1&page=<%=page%>">↑</a>文件名<a href="matrix3_uploadfiles.asp?keyword=<%=keyword%>&type=<%=type1%>&px=2&page=<%=page%>">↓</a></td>

⌨️ 快捷键说明

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