<% '************************************************************************************************** ' 程序名称: 七禧舞曲管理系统 ' 程序作者: 花心萝卜 ' 官方网站: http://www.cmsdj.com http://www.7xiwl.com ' 编写日期: 2009年8月27日 ' 版权所有: 本程序由七禧网络开发,未经同意请勿用于商业用途 '************************************************************************************************** %> 相册管理
 
<% Dim Action,page Dim arr1,arr2 Dim key,HttpUrl Dim CmsDjPic:Set CmsDjPic = New CmsDj_Com_Pic action=Request.QueryString("action") page=int(request.QueryString ("page")) key=Request.QueryString("key") Select Case Lcase(action) Case "批量删除" : Call DelAll() Case "del" : Call Del() Case Else : Call Main() End Select Call Admin_FooterB %> <%Sub Main()%>
 相册管理
  关键字(可以输入标题或会员):      
<% Dim Rs,SqlA if page<=0 or page="" then page=1'初始化分页参数 i=0 If key<>"" Then If CD_DBtype = "sql" Then SqlA="Title like '%"&key&"%' or UserName like '%"&key&"%' order by UpdateTime desc" Else SqlA="InStr(1,LCase(Title),LCase('"&key&"'),0)<>0 or InStr(1,LCase(UserName),LCase('"&key&"'),0)<>0 order by UpdateTime desc" End If Else SqlA="order by UpdateTime desc" End If Set Rs=CmsDjPic.GetRs("",0,SqlA) If Not(rs.bof And rs.EOF) Then rs.pagesize=20 '每页舞曲 rs.AbsolutePage=page m=rs.recordcount '总记录 n=rs.PageCount '总页数 z=rs.pagesize '每页数量 do while not rs.eof and i <% rs.movenext loop Else %> <% End If rs.Close Set rs=nothing %>
 编号    相册标题  状态 添加会员 更新时间 操作
" class="checkbox"/><%=Rs("id")%>、  " target="_blank">  " target="_blank"><%=replace(rs("Title"),key,""&key&"")%> <%=Hidden%> "><%=replace(rs("UserName"),key,""&key&"")%> <%If Cstr(FormatDatetime(Rs("UpdateTime"),2))=Cstr(Date()) Then Response.Write""&FormatDateTime(Rs("UpdateTime"),2)&"" Else Response.Write""&FormatDatetime(Rs("UpdateTime"),2)%> " target="_blank">查看 " onClick="return confirm('确定删除吗?不可恢复!');">删除


没有相册


  
<%=List_Page(m,z,page,"?action="&action&"&",15,7)%>
<% End Sub Sub DelAll() CD_ID = SafeRequest("ID","get") IF CD_ID="" Then Call AdminAlert("出错了,参数传输错误!",Request.ServerVariables("HTTP_REFERER"),0) Response.End End IF CD_ID = Split(CD_ID,", ") For Each ID In CD_ID Call CmsDjPic.del("ID="&ID) Conn.DB "delete from CmsDj_View where channel=1 and cid="&ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=2 and FeedB="&ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=6 and FeedB="&ID,"exe" Next Call AdminAlert("恭喜您,批量删除相册成功!",Request.ServerVariables("HTTP_REFERER"),0) Response.End End Sub Sub Del() CD_ID = SafeRequest("ID","get") IF CD_ID="" Then Call AdminAlert("出错了,参数传输错误!",Request.ServerVariables("HTTP_REFERER"),0) Response.End End IF Call CmsDjPic.del("ID="&CD_ID) Conn.DB "delete from CmsDj_View where channel=1 and cid="&CD_ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=2 and FeedB="&CD_ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=6 and FeedB="&CD_ID,"exe" Call AdminAlert("恭喜您,删除相册成功!",Request.ServerVariables("HTTP_REFERER"),0) Response.End End Sub %>