ad_photomanage.asp

该软件是帮助大学生更好的生活

		case "PhotoName"
			sql=sql & " and P.PhotoName like '%" & keyword & "%' "
		case "PhotoIntro"
			sql=sql & " and P.PhotoIntro like '%" & keyword & "%' "
		case "Author"
			sql=sql & " and P.Author like '%" & keyword & "%' "
		case "Editor"
			sql=sql & " and P.Editor like '%" & keyword & "%' "
		case else
			sql=sql & " and P.PhotoName like '%" & keyword & "%' "
		end select
	end if
end if
sql=sql & " order by P.PhotoID desc"
'response.write sql
'response.end

Set rsPhotoList= Server.CreateObject("ADODB.Recordset")
rsPhotoList.open sql,conn,1,1
if rsPhotoList.eof and rsPhotoList.bof then
	totalPut=0
	if Child=0 then
		response.write "<p align='center'><br>没有任何图片！<br></p>"
	else
		response.write "<p align='center'><br>此栏目的下一级子栏目中没有任何图片！<br></p>"
	end if
else
   	totalPut=rsPhotoList.recordcount
	if currentpage<1 then
   		currentpage=1
   	end if
   	if (currentpage-1)*MaxPerPage>totalput then
   		if (totalPut mod MaxPerPage)=0 then
     		currentpage= totalPut \ MaxPerPage
	  	else
	      	currentpage= totalPut \ MaxPerPage + 1
   		end if
   	end if
    if currentPage=1 then
       	showContent
       	showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
 	else
     	if (currentPage-1)*MaxPerPage<totalPut then
       	   	rsPhotoList.move  (currentPage-1)*MaxPerPage
       		dim bookmark
           	bookmark=rsPhotoList.bookmark
            showContent
            showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
       	else
	        currentPage=1
           	showContent
          	showpage strFileName,totalput,MaxPerPage,true,true,"张图片"
	    end if
	end if
end if
rsPhotoList.close
set rsPhotoList=nothing  


sub showContent
   	dim PhotoNum
    PhotoNum=0
%>
<table width='100%' border="0" cellpadding="0" cellspacing="0"><tr>
    <form name="myform" method="Post" action="ad_PhotoDel.asp" onsubmit="return ConfirmDel();">
     <td><table class="border" border="0" cellspacing="1" width="100%" cellpadding="0">
          <tr class="title" height="22"> 
            <td height="22" width="30" align="center"><strong>选中</strong></td>
            <td width="25" align="center"  height="22"><strong>ID</strong></td>
            <td width="120" align="center"><strong>缩略图</strong></td>
            <td align="center" ><strong>图片名称</strong></td>
            <td width="60" align="center" ><strong>图片大小</strong></td>
            <td width="60" align="center" ><strong>查看次数</strong></td>
            <td width="60" align="center" ><strong>图片属性</strong></td>
            <td width="40" align="center" ><strong>已审核</strong></td>
            <td width="180" align="center" ><strong>操作</strong></td>
          </tr>
          <%do while not rsPhotoList.eof%>
          <tr class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#BFDFFF'"> 
            <td width="30" align="center"><input name='PhotoID' type='checkbox' onclick="unselectall()" id="PhotoID" value='<%=cstr(rsPhotoList("PhotoID"))%>'></td>
            <td width="25" align="center"><%=rsPhotoList("Photoid")%></td>
            <td width="120" align="center"><%response.write "<a href='ad_PhotoShow.asp?PhotoID=" & rsPhotoList("PhotoID") & "'><img src='" & rsPhotoList("PhotoUrl_Thumb") & "' width='120' border='0'></a>"%></td>
            <td> <%
			if rsPhotoList("ClassID")<>ClassID then
				response.write "<a href='" & FileName & "?ClassID=" & rsPhotoList("ClassID") & "'>[" & rsPhotoList("ClassName") & "]</a>&nbsp;"
			end if
			response.write "<a href='ad_PhotoShow.asp?PhotoID=" & rsPhotoList("PhotoID") & "'"
			response.write " title='图片名称：" & rsPhotoList("PhotoName") & vbcrlf & "图片作者：" & rsPhotoList("Author") & vbcrlf & "更新时间：" & rsPhotoList("UpdateTime") & vbcrlf
			response.write "查看次数：" & rsPhotoList("Hits") & vbcrlf & "关 键 字：" & mid(rsPhotoList("Keyword"),2,len(rsPhotoList("Keyword"))-2) & vbcrlf & "推荐等级："
			if rsPhotoList("Stars")=0 then
				response.write "无"
			else
				response.write string(rsPhotoList("Stars"),"★")
			end if			
			response.write vbcrlf & "下载等级："	
			if rsPhotoList("PhotoLevel")=9999 then
				response.write "游客"
			elseif  rsPhotoList("PhotoLevel")=999 then
				response.write "注册用户"
			elseif  rsPhotoList("PhotoLevel")=99 then
				response.write "收费用户"
			elseif  rsPhotoList("PhotoLevel")=9 then
				response.write "VIP用户"
			elseif  rsPhotoList("PhotoLevel")=5 then
				response.write "管理员"
			end if
			response.write vbcrlf & "查看点数：" & rsPhotoList("PhotoPoint")
			response.write "'>" & rsPhotoList("PhotoName") & "</a>"
			%></td>
            <td width="60" align="center"><%=rsPhotoList("PhotoSize") & " K"%></td>
            <td width="60" align="center"><%= rsPhotoList("Hits") %></td>
            <td width="60" align="center"> <%
			if rsPhotoList("OnTop")=true then
				response.Write "<font color=blue>顶</font> "
			else
				response.write "&nbsp;&nbsp;&nbsp;"
			end if
			if rsPhotoList("Hits")>=HitsOfHot then
				response.write "<font color=red>热</a> "
			else
				response.write "&nbsp;&nbsp;&nbsp;"
			end if
			if rsPhotoList("Elite")=true then
				response.write "<font color=green>荐</a>"
			else
				response.write "&nbsp;&nbsp;"
			end if
			%> </td>
            <td width="40" align="center"> <%
			if rsPhotoList("Passed")=true then
				response.write "是"
			else
				response.write "否"
			end if%></td>
            <td width="180" align="center"> <%
			if AdminPurview=1 or AdminPurview_Photo<=2 or PurviewChecked=true or AdminName=rsPhotoList("Editor") then
            	response.write "<a href='ad_PhotoModify.asp?PhotoID=" & rsPhotoList("Photoid") &"'>修改</a>&nbsp;"
            	response.write "<a href='ad_PhotoDel.asp?PhotoID=" & rsPhotoList("PhotoID") & "&Action=Del' onclick='return ConfirmDel();'>删除</a>&nbsp;"
			end if
			if AdminPurview=1 or AdminPurview_Photo<=2 then
				response.write "<a href='ad_PhotoMove.asp?PhotoID=" & rsPhotoList("PhotoID") & "'>移动</a>&nbsp;"
            end if
			if AdminPurview=1 or AdminPurview_Photo<=2 or PurviewChecked=true then
				if rsPhotoList("OnTop")=False then	
					response.write "<a href='ad_PhotoProperty.asp?PhotoID=" & rsPhotoList("PhotoID") & "&Action=SetOnTop'>固顶</a>&nbsp;"
				else
					response.write "<a href='ad_PhotoProperty.asp?PhotoID=" & rsPhotoList("PhotoID") & "&Action=CancelOnTop'>解固</a>&nbsp;"
				end if
            	if rsPhotoList("Elite")=False then	
					response.write "<a href='ad_PhotoProperty.asp?PhotoID=" & rsPhotoList("PhotoID") & "&Action=SetElite'>设为推荐</a>"
				else
					response.write "<a href='ad_PhotoProperty.asp?PhotoID=" & rsPhotoList("PhotoID") & "&Action=CancelElite'>取消推荐</a>"
				end if
            end if
            %></td>
          </tr>
          <%
		PhotoNum=PhotoNum+1
	   	if PhotoNum>=MaxPerPage then exit do
	   	rsPhotoList.movenext
	loop
%>
        </table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="250" height="30"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
              选中本页显示的所有图片 </td>
    <td><input name="submit" type='submit' value='删除选定的图片' onClick="document.myform.Action.value='Del'" <%if PurviewChecked=False and AdminPurview=2 and AdminPurview_Photo>=3 then response.write "disabled"%>>
              <input name="Action" type="hidden" id="Action" value="Del">
               <%
			   if AdminPurview=1 or AdminPurview_Photo<=2 then
			   %>&nbsp;&nbsp;&nbsp;&nbsp; 
              <input type="submit" name="Submit" value="将选定的图片移动到" onClick="document.myform.Action.value='MoveToClass'">
              <select name="TargetClassID"><%call Admin_ShowClass_Option(3,ClassID)%></select>
			  <%end if%>
            </td>
  </tr>
</table>
</td>
</form></tr></table>
<%
end sub

if ClassID>0 and Child>0 then
%>
<br>
<table width="100%" height="5" border="0" cellpadding="0" cellspacing="0"><tr><td></td></tr></table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class='border'>
  <tr height="20" class='tdbg'>
    <td width='150' align="right">【<%response.write "<a href='" & strFileName & "'>" & ClassName & "</a>"%>】子栏目导航：</td>
	<td><%call Admin_ShowChild()%></td></tr>
</table>
<%
end if
%>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="border">
  <tr class="tdbg">
    <td width="80" align="right"><strong>图片搜索：</strong></td>
    <td>
      <%call Admin_ShowSearchForm(FileName,2)%>
    </td>
  </tr>
</table>
</body>
</html>
<%
call CloseConn()
%>