📄 picture_keywordlist.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%option explicit%>
<!--#include file="../../Conn.asp"-->
<!--#include file="../../SysCls/KS_CommonCls.asp"-->
<!--#include file="../../SysCls/KS_RefreshFunctionCls.asp"-->
<!--#include file="../Inc/Session.asp"-->
<%
'===================================================================================================================
'软件名称：科汛网站管理系统
'当前版本：科汛网站管理系统 V2.2 SP2 Free
'Copyright (C) 2006-2008 Kesion.Com All rights reserved.
'产品咨询QQ：9537636,41904294
'技术支持QQ：111394,54004407
'程序版权：科汛网络
'程序开发：科汛网络开发组（总策划：林文仲）
'E-Mail :kesioncms@hotmail.com webmaster@kesion.com
'官方网站：http://www.kesion.com
'演示站点：http://test.kesion.com
'郑重声明:
' ①、免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接,商业版本无此要求;
' ②、任何个人或组织不得在授权允许的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息；
' ③、科汛网络保留此软件的法律追究权利
'===================================================================================================================
Dim KSCls
Set KSCls = New Picture_KeyWordList
KSCls.Execute()
Set KSCls = Nothing
Class Picture_KeyWordList
Private KSCMS
Private I, totalPut, CurrentPage, KeySql, KeyRS
Private MaxPerPage
Private Sub Class_Initialize()
MaxPerPage = 20
Set KSCMS=New CommonCls
End Sub
Private Sub Class_Terminate()
Call KSCMS.CloseConn()
Set KSCMS=Nothing
End Sub
Public Sub Execute()
If Not KSCMS.ReturnPowerResult(2, "KMP20001") Then Call KSCMS.ReturnErr(1, "")
If Request("page") <> "" Then
CurrentPage = CInt(KSCMS.G("page"))
Else
CurrentPage = 1
End If
Response.Write "<html>"
Response.Write "<head>"
Response.Write "<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>"
Response.Write "<title>关键字管理</title>"
Response.Write "<link href='../Inc/Admin_Style.CSS' rel='stylesheet' type='text/css'>"
Response.Write "<script language='JavaScript'>"
Response.Write "var Page='" & CurrentPage & "';"
Response.Write "</script>"
Response.Write "<script language='JavaScript' src='../JS/Common.js'></script>"
Response.Write "<script language='JavaScript' src='../JS/ContextMenu.js'></script>"
Response.Write "<script language='JavaScript' src='../JS/SelectElement.js'></script>"
Response.Write "<script language='JavaScript' src='../Common/PictureKeyWordFunction.JS'></script>"
Response.Write "</head>"
Response.Write "<body scroll=no topmargin='0' leftmargin='0' onclick='SelectElement();' onkeydown='GetKeyDown();' onselectstart='return false;'>"
Response.Write "<table width='100%' height='52' border='0' cellpadding='0' cellspacing='1'>"
Response.Write " <tr>"
Response.Write " <td height='3' colspan='4' valign='top'> <table width='100%' border='0' cellspacing='0' cellpadding='0'>"
Response.Write " <tr>"
Response.Write " <td width='32%' height='25' class='sort'>"
Response.Write " <div align='center'>关键字</div></td>"
Response.Write " <td width='19%' class='sort'><div align='center'>使用频率(次)</div></td>"
Response.Write " <td width='23%' align='center' class='sort'>最后使用时间</td>"
Response.Write " <td width='26%' class='sort'><div align='center'>添加时间</div></td>"
Response.Write " </tr>"
Response.Write " </table></td>"
Response.Write " </tr>"
Set KeyRS = Server.CreateObject("ADODB.RecordSet")
KeySql = "SELECT * FROM [KS_KeyWords] Where ChannelID=2 order by AddDate desc"
KeyRS.Open KeySql, conn, 1, 1
If KeyRS.EOF And KeyRS.BOF Then
Else
totalPut = KeyRS.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
Call showContent
Call KSCMS.showpage(totalPut, MaxPerPage, "Article_KeyWordList.asp", True, "个关键字", CurrentPage)
Else
If (CurrentPage - 1) * MaxPerPage < totalPut Then
KeyRS.Move (CurrentPage - 1) * MaxPerPage
Call showContent
Call KSCMS.showpage(totalPut, MaxPerPage, "Article_KeyWordList.asp", True, "个关键字", CurrentPage)
Else
CurrentPage = 1
Call showContent
Call KSCMS.showpage(totalPut, MaxPerPage, "Article_KeyWordList.asp", True, "个关键字", CurrentPage)
End If
End If
End If
Response.Write " </td>"
Response.Write " </tr>"
Response.Write "</table>"
Response.Write "</body>"
Response.Write "</html>"
End Sub
Sub showContent()
Do While Not KeyRS.EOF
Response.Write "<tr>"
Response.Write " <td width='32%' height='20'> <span KeyWordID='" & KeyRS("ID") & "' ondblclick=""EditKeyWord('',this.KeyWordID)""><img src='../Images/key.gif' align='absmiddle'>"
Response.Write " <span style='cursor:default;'>" & KeyRS("KeyText") & "</span></span> "
Response.Write " </td>"
Response.Write " <td width='19%' align='center'>" & GetHits(KeyRS("KeyText")) & " </td>"
Response.Write " <td width='23%' align='center'><FONT Color=red>" & GetKeyWordLastUseTime(KeyRS("KeyText")) & "</font> </td>"
Response.Write " <td width='26%' align='center'>" & KeyRS("AddDate") & " </td>"
Response.Write "</tr>"
I = I + 1
If I >= MaxPerPage Then Exit Do
KeyRS.MoveNext
Loop
KeyRS.Close
conn.Close
Response.Write "<tr><td height='26' colspan='4' align='right'>"
End Sub
'取得关键字使用频率
Function GetHits(KeyText)
Dim RS
Set RS = Server.CreateObject("Adodb.RecordSet")
RS.Open "Select count(*) as Total From KS_Photo Where KeyWords like '%" & Trim(KeyText) & "%'", conn, 1, 1
If Not RS.EOF Then
GetHits = RS(0)
Else
GetHits = 0
End If
RS.Close
Set RS = Nothing
End Function
'取得关键字最后使用时间
Function GetKeyWordLastUseTime(KeyText)
Dim RS
Set RS = Server.CreateObject("Adodb.RecordSet")
RS.Open "Select AddDate From KS_Photo Where KeyWords like '%" & Trim(KeyText) & "%' Order BY AddDate Desc", conn, 1, 1
If Not RS.EOF Then
GetKeyWordLastUseTime = RS(0)
Else
GetKeyWordLastUseTime = "---"
End If
RS.Close
Set RS = Nothing
End Function
End Class
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -