<% '************************************************************************************************** ' 程序名称: 七禧舞曲管理系统 ' 程序作者: 花心萝卜 ' 官方网站: http://www.cmsdj.com http://www.7xiwl.com ' 编写日期: 2009年8月27日 ' 版权所有: 本程序由七禧网络开发,未经同意请勿用于商业用途 '************************************************************************************************** %> 日志管理
 
<% Dim Action,page Dim arr1,arr2 Dim key,HttpUrl Dim CmsDjArt:Set CmsDjArt = New CmsDj_Com_Art 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&"%' and Hidden=0 order by UpdateTime desc" Else SqlA="InStr(1,LCase(Title),LCase('"&key&"'),0)<>0 or InStr(1,LCase(UserName),LCase('"&key&"'),0)<>0 and Hidden=0 order by UpdateTime desc" End If Else SqlA="Hidden=0 order by UpdateTime desc" End If Set Rs=CmsDjArt.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"><%=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 CmsDjArt.del("ID="&ID) Conn.DB "delete from CmsDj_View where channel=2 and cid="&ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=1 and FeedB="&ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=5 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 CmsDjArt.del("ID="&CD_ID) Conn.DB "delete from CmsDj_View where channel=2 and cid="&CD_ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=1 and FeedB="&CD_ID,"exe" Conn.DB "delete from CmsDj_Feed where FeedA=5 and FeedB="&CD_ID,"exe" Call AdminAlert("恭喜您,删除日志成功!",Request.ServerVariables("HTTP_REFERER"),0) Response.End End Sub %>