?? manager_xiangce.asp
字號:
<!--#include file="conn.asp" -->
<%
jumpPage=request.Form("jumpPage")
currentPage = TRIM( request.QueryString("page"))
if currentPage ="" and jumpPage="" then
currentPage = 1
end if
if jumpPage<>"" then
jumpPage=CINT(jumpPage)
currentPage = jumpPage
end if
if currentPage<1 then
currentPage=1
end if
set photo=Server.CreateObject("ADODB.Recordset")
photo.CursorType=adOpenStatic
photo.PageSize =5
'==================打開photo數據庫====================
sql_liuyan="select * from class_photo order by photoid desc"
photo.Open sql_liuyan,conn,1,1
'===============================================
while not photo.eof
totalcount=totalcount+1
photo.movenext
wend
photo.AbsolutePage=currentPage
rowCount = 0
'==========打開用戶信息數據表========
sql_user="select * from user where userid='"&session("user")&"'"
set user_set=conn.execute(sql_user)
%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name=keywords content="计算机技术">
<title><%=sitename%> 歡迎您</title>
<link href="style02.css" rel="StyleSheet" type="text/css">
<SCRIPT language=JavaScript>
var currentpos,timer;
function initialize()
{
timer=setInterval("scrollwindow()",10);
}
function sc(){
clearInterval(timer);
}
function scrollwindow()
{
currentpos=document.body.scrollTop;
window.scroll(0,++currentpos);
if (currentpos != document.body.scrollTop)
sc();
}
document.onmousedown=sc
document.ondblclick=initialize
</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
</head>
<body leftmargin="0" topmargin="0">
<center>
<table width="750" border="0" cellspacing="3" cellpadding="1" align="center">
<tr>
<td width="194" height="29">
<table width="100%" align="right" cellspacing=0 cellpadding=0 border=0><tr>
<td width="55%">
<img border="0" src="<%=toplog%>"></td>
<td width="45%" valign=top> </td>
</table></td>
<td width="375" height="29" align="center">
<marquee width=300 direction="up" height="40" scrolldelay="200" scrollamount="1"><%=topmarque%></marquee><span style="position: absolute; left: 219; top: 4; z-index: -1"><img src="images/news.jpg" width="342" height="60"></span>
</td>
<td width="100" height="60">
<span style="position: absolute; left: 572; top: 5; z-index: -1">
<img border="0" src="images/WALKGUY.GIF" width="115" height="59"></span></td>
<td width="81" height="60">
<img border="0" src="images/SP_OT.GIF" width="109" height="60"></td>
</tr>
</table>
<div align="center" style="width: 750; height: 32">
<center>
<table cellspacing=0 cellpadding=3 class=tableBorder1 height="21" style="width: 750; border-collapse: collapse" bordercolor="#111111">
<tr><td height=7 width="243">
<span lang="zh-cn">>>歡迎 <font color="#FF0000"><%=user_set("nikename")%></font> 回家看看</span></td>
<td height=7 valign=middle width="110"><a style="border:1px solid #C0C0C0; line-height:16px; FONT-FAMILY: 宋體; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 100px; color:#000000;" title="查看班級相冊" href="xiangce.asp"><center>班級影集</center></a></td>
<td height=7 valign=middle width="110">
<p align="center">
<a style="border:1px solid #C0C0C0; line-height:16px; FONT-FAMILY: 宋體; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 100px; color:#000000;" title="查看班級成員檔案" href="dangan.asp">班級檔案</a></td>
<td height=7 valign=middle width="110">
<p align="center"><a href="main.asp" style="border:1px solid #C0C0C0; line-height:16px; FONT-FAMILY: 宋體; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH:100px; color:#000000;" title="進入班級留言板">留言板</a></td>
<td height=7 valign=middle width="110">
<p align="center"><a href="liaotian.asp" style="border:1px solid #C0C0C0; line-height:16px; FONT-FAMILY: 宋體; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH:100px; color:#000000;" title="進入聊天室">聊天室</a></td>
<td height=7 valign=middle width="110">
<p align="center"><a href="manage.asp" style="border:1px solid #C0C0C0; line-height:16px; FONT-FAMILY: 宋體; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 100px; color:#000000;" title="進入管理系統">系統管理</a></td>
<tr></td>
</table>
</center>
</div>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750" id="AutoNumber5">
<tr>
<td width="562" rowspan="3" align="center" valign="top"><span lang="zh-cn">
<table>
<tr>
<td valign="top">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750" id="AutoNumber2" height="91" bordercolorlight="#76AEF0" bordercolordark="#BFD3EE">
<tr>
<th width="529" height="25" colspan="6"><span lang="zh-cn"><font size="5">班 級 相
冊</font></span></tr>
</tr>
<tr>
<td width="100" class=tablebody1 height="17" align="center"><b>照 片</b></td>
<td width="131" class=tablebody1 height="17" align="center"><b>照片說明</b></td>
<td width="56" class=tablebody1 height="17" align="center"><b>上傳人</b></td>
<td width="115" class=tablebody1 height="17" align="center"><b>上傳時間</b></td>
<td width="52" class=tablebody1 height="17" align="center"><b>操作種類</b></td>
<td width="44" class=tablebody1 height="17" align="center"><b>提交</b></td>
</tr>
<% do while not photo.eof and rowCount <photo.pagesize %>
<form action="gphoto.asp" method=post>
<tr>
<input type=hidden name=photoid value=<%=photo("photoid")%>>
<td width="100" class=tablebody1 height="17">
<a href="showcp.asp?photoid=<%=photo("photoid")%>" target="_blank" title="放大觀看">
<img src="showcp.asp?photoid=<%=photo("photoid")%>" height=100 border=1 width="100"></a></td>
<td width="131" class=tablebody1 height="17" align="left" valign="bottom">
<input name=memo size="20" value=<%=photo("memo")%>>
</td>
<td width="56" class=tablebody1 height="17" align="left" valign="bottom">
<input name=owner size="20" value=<%=photo("owner")%> ></td>
<td width="115" class=tablebody1 height="17" align="left" valign="bottom"><%=photo("data")%></td>
<td width="52" class=tablebody1 height="17" align="left" valign="bottom">
<select size="1" name="caozuo">
<option value="0">修改</option>
<option value="1">刪除</option>
</select>
</td>
<td width="44" class=tablebody1 height="17" align="left" valign="bottom"><input type="submit" value="確定">
</td>
</tr></form>
<% photo.movenext
rowcount=rowcount+1%>
<%loop%>
</table>
</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="750" id="AutoNumber2" height="20">
<tr>
<th width="139" height="1"><span lang="zh-cn">共</span><%=totalcount%>條 ；<%=photo.PageCount%>頁
；第<%=currentpage%>頁
</th>
<th width="290" align="left" height="1">|
<a href="main.asp?Page=1" style="border:1px solid #C0C0C0; line-height:16px;backgroud-color: #ffffff; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 45px; color:#0000ff; background-color:#FFFFFF">第一頁</a>|
<%
if currentPage<>1 then
%>
<a href=" main.asp?Page=<%=currentPage-1%>" style="border:1px solid #C0C0C0; line-height:16px;backgroud-color: #ffffff; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 45px; color:#0000ff; background-color:#FFFFFF">上一頁</a>
<% else
response.Write("上一頁")
end if%>|
<%if currentPage<>photo.Pagecount then%>
<a href="main.asp?Page=<%=currentPage+1%>" style="border:1px solid #C0C0C0; line-height:16px;backgroud-color: #ffffff; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH: 45px; color:#0000ff; background-color:#FFFFFF">下一頁</a>
<%else
response.Write("下一頁")
end if%>
|<a href="main.asp?Page=<%=photo.PageCount%>" style="border:1px solid #C0C0C0; line-height:16px;backgroud-color: #ffffff; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; HEIGHT: 18px; WIDTH:45px; color:#0000ff; background-color:#FFFFFF">末頁</a>| </th>
<form action="main.asp" method="post">
<th width="100" height="1" valign="bottom">轉<input type="text" name="jumpPage" size="3" >
<input type="submit" size="3" value="GO" > </td>
</form>
</tr>
</table>
</td>
</tr>
</table>
</span></td>
</tr>
</table>
<table class="bgclr" width="750" border="0" cellspacing="0" cellpadding="0" align="center" height="1">
<tr>
<td height="1"></td>
</tr>
</table>
<table width="500" border="0" cellspacing="3" cellpadding="1" align="center">
<tr>
<td align="center">技術支持 清峰居</td>
</tr>
<tr>
<td align="center">| <a href="mailto:<%=masteremail%>">意見建議</a> <a href="mailto:<%=masteremail%>">商業合作</a>
|</td>
</tr>
</table>
</center>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -