📄 vote_main.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%option explicit%>
<!--#include file="../../Conn.asp"-->
<!--#include file="../../SysCls/KS_CommonCls.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 Vote_Main
KSCls.Execute()
Set KSCls = Nothing
Class Vote_Main
Private KSCMS
Private I, totalPut, CurrentPage, SqlStr, RSObj
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(0, "KMCT10006") Then
Response.Write ("<script>parent.frames['BottomFrame'].location.href='javascript:history.back();';</script>")
Call KSCMS.ReturnErr(1, "")
End If
If Request("page") <> "" Then
CurrentPage = CInt(Request("page"))
Else
CurrentPage = 1
End If
if KSCMS.G("Action")="Del" Then
Conn.Execute("delete from KS_Vote where ID="&Clng(KSCMS.G("VoteID")))
elseif KSCMS.G("Action")="Set" and KSCMS.G("VoteID")<>"" then
conn.execute "Update KS_Vote set NewestTF=0 where NewestTF=1"
conn.execute "Update KS_Vote set NewestTF=1 Where ID=" & Clng(KSCMS.G("VoteID"))
Response.Write "<script language='JavaScript' type='text/JavaScript'>alert('设置成功！');</script>"
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"">" & vbCrLf
Response.Write "var Page='" & CurrentPage & "';" & vbCrLf
Response.Write "</script>" & vbCrLf
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/VoteFunction.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%"" 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=""44%"" height=""25"" class=""sort"">"
Response.Write " <div align=""center"">调查主题</div></td>"
Response.Write " <td width=""17%"" class=""sort""><div align=""center"">发起人</div></td>"
Response.Write " <td width=""20%"" align=""center"" class=""sort"">时间</td>"
Response.Write " <td width=""19%"" class=""sort""><div align=""center"">是否最新</div></td>"
Response.Write " </tr>"
Response.Write " </table></td>"
Response.Write " </tr>"
Set RSObj = Server.CreateObject("ADODB.RecordSet")
SqlStr = "SELECT * FROM KS_Vote order by NewestTF desc,AddDate desc"
RSObj.Open SqlStr, Conn, 1, 1
If RSObj.EOF And RSObj.BOF Then
Else
totalPut = RSObj.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
Else
If (CurrentPage - 1) * MaxPerPage < totalPut Then
RSObj.Move (CurrentPage - 1) * MaxPerPage
Call showContent
Else
CurrentPage = 1
Call showContent
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 RSObj.EOF
Response.Write "<tr>"
Response.Write " <td width='44%' height='20'> <span VoteID='" & RSObj("ID") & "' ondblclick=""EditVote('',this.VoteID)""><img src='../Images/Vote.gif' align='absmiddle'>"
Response.Write " <span style='cursor:default;'>" & KSCMS.GotTopic(RSObj("Title"), 50) & "</span></span> "
Response.Write " </td>"
Response.Write " <td width='17%' align='center'>" & RSObj("UserName") & " </td>"
Response.Write " <td width='20%' align='center'><FONT Color=red>" & RSObj("AddDate") & "</font> </td>"
If RSObj("NewestTF") = 1 Then
Response.Write " <td width='19%' align='center'><font color=red>是</font></td>"
Else
Response.Write " <td width='19%' align='center'>否</td>"
End If
Response.Write "</tr>"
I = I + 1
If I >= MaxPerPage Then Exit Do
RSObj.MoveNext
Loop
RSObj.Close
Conn.Close
Response.Write "<tr><td height='26' colspan='4' align='right'>"
Call KSCMS.ShowPage(totalPut, MaxPerPage, "Vote_Main.asp", True, "个", CurrentPage)
End Sub
End Class
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -