📄 collect_intodatabase.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%option explicit%>
<!--#include file="../../Conn.asp"-->
<!--#include file="../../SysCls/KS_CommonCls.asp"-->
<!--#include file="../../SysCls/KS_CollectCommonCls.asp"-->
<!--#include file="../Inc/Session.asp"-->
<%
'===================================================================================================================
'软件名称：科汛网站管理系统
'当前版本：科汛网站管理系统 V2.2 0628个人Access版
'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 Collect_IntoDatabase
KSCls.Execute()
Set KSCls = Nothing
Class Collect_IntoDatabase
Private KSCMS
Private KMCObj
Private ConnItem
Private i
Private totalPut
Private CurrentPage
Private SqlStr
Private RSObj
Private MaxPerPage
Private Sub Class_Initialize()
MaxPerPage = 20
Set KSCMS=New CommonCls
Set KMCObj=New CollectCommonCls
Set ConnItem = KSCMS.ConnItem()
End Sub
Private Sub Class_Terminate()
Call KSCMS.CloseConnItem()
Call KSCMS.Closeconn
Set KSCMS=Nothing
Set KMCObj=Nothing
End Sub
Sub Execute()
On Error Resume Next
If Not KSCMS.ReturnPowerResult(0, "KMCL10004") 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
Dim Rs, Sql, SqlItem, RSObj, Action, FoundErr, ErrMsg
Dim NewsID, ItemID, ChannelID, ClassID, SpecialID, ArticleID, Title, CollecDate, NewsUrl, Result
Dim Arr_History, Arr_ArticleID, i_Arr, Del, Flag
Dim HistoryNum, i_His
FoundErr = False
Del = Trim(Request("Del"))
Action = Trim(Request("Action"))
If KSCMS.G("DelFlag") <> "" Then
Call ExecuteAction
End If
If FoundErr <> True Then
Call Main
Else
Call KMCObj.WriteErrMsg(ErrMsg)
End If
End Sub
Sub Main()
Dim SqlItem
Response.Write "<html>"
Response.Write "<head>"
Response.Write "<title>采集系统</title>"
Response.Write "<meta http-equiv=""Content-Type"" content=""text/html; charset=gb2312"">"
Response.Write "<link rel=""stylesheet"" type=""text/css"" href=""../inc/Admin_Style.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/CollectIntoDataBaseFunction.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"" cellspacing=""0"" cellpadding=""0"" class=""sortbutton"">"
Response.Write " <tr>"
Response.Write " <td height=""25"">"
Response.Write "<input class=""buttonstyle"" name=""CreateFolder"" title=""将选择的记录转移到主数据库"" type=""button"" value=""选择入库"" onclick='IntoDataBase();'>"
Response.Write "<input class=""buttonstyle"" name=""CreateFolder"" title=""将全部记录转移到主数据库"" type=""button"" value=""全部入库"" onclick='AllIntoDataBase();'>"
Response.Write "<input class=""buttonstyle"" name=""VerificFolder"" title=""审核选中的记录"" type=""button"" value=""审核选中"" onclick=""VerificRecords('');"" >"
Response.Write "<input class=""buttonstyle"" name=""VerificFolder"" title=""全部审核"" type=""button"" value=""全部审核"" onclick=""VerificAllRecords('');"" >"
Response.Write (" </td>")
Response.Write ("</tr>")
Response.Write ("</table>")
Response.Write "<table class=""border"" border=""0"" cellspacing=""1"" width=""100%"" cellpadding=""0"">"
Response.Write " <tr style=""padding: 0px 2px;"">"
Response.Write " <td width=""299"" height=""22"" align=""center"" class=sort>标题</td>"
Response.Write " <td width=""183"" align=""center"" class=sort>文章来源</td>"
Response.Write " <td width=""102"" height=""22"" align=""center"" class=sort>频道</td>"
Response.Write " <td width=""194"" height=""22"" align=""center"" class=sort>栏目</td>"
Response.Write " <td width=""211"" align=""center"" class=sort>审核结果</td>"
Response.Write " </tr>"
Set RSObj = Server.CreateObject("adodb.recordset")
SqlItem = "select * from KS_Article"
If Request("page") <> "" Then
CurrentPage = CInt(Request("Page"))
Else
CurrentPage = 1
End If
SqlItem = SqlItem & " order by ID DESC"
RSObj.Open SqlItem, ConnItem, 1, 1
If Not RSObj.EOF Then
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 "</table>"
Response.Write "</body>"
Response.Write "</html>"
End Sub
Sub ExecuteAction()
Dim DelFlag, NewsID, FoundErr, ErrMsg, SqlItem
DelFlag = Trim(KSCMS.G("DelFlag"))
NewsID = Trim(KSCMS.G("NewsID"))
If NewsID <> "" Then
NewsID = "'" & Replace(NewsID, ",", "','") & "'"
End If
If DelFlag = "verific" Then
If NewsID = "" Then
FoundErr = True
ErrMsg = ErrMsg & "<br><li>请选择要审核的记录</li>"
Else
NewsID = Replace(NewsID, " ", "")
SqlItem = "update KS_Article set Verific=1 Where NewsID in(" & NewsID & ")"
End If
ElseIf DelFlag = "verificall" Then
NewsID = 1
SqlItem = "update KS_Article set Verific=1"
ElseIf DelFlag = "del" Then
NewsID = Replace(NewsID, " ", "")
SqlItem = "Delete From KS_Article Where NewsID in(" & NewsID & ")"
ElseIf DelFlag = "delall" Then
NewsID = 1
SqlItem = "Delete From KS_Article"
End If
If FoundErr <> True And NewsID <> "" Then
ConnItem.Execute (SqlItem)
End If
End Sub
Sub showContent()
i = 0
Do While Not RSObj.EOF
Response.Write ("<tr>")
Response.Write (" <td width=""435"" height=""18""> ")
Response.Write "<span ondblclick='ViewRecords(this.NewsID);' NewsID='" & RSObj("NewsID") & "'><img src='../Images/folder/TheSmallWordNews1.gif' align='absmiddle'>"
Response.Write " <span style='cursor:default;'>" & KSCMS.GotTopic(RSObj("Title"), 42) & "</span></span>"
Response.Write ("</td> ")
Response.Write " <td width=""142"" align=""center""> " & KSCMS.GotTopic(RSObj("Origin"), 15) & " </td>"
Response.Write " <td width=""132"" align=""center"">" & KMCObj.Collect_ShowChannel_Name(1) & "</td>"
Response.Write " <td width=""110"" align=""center"">" & KMCObj.Collect_ShowClass_Name(1, RSObj("TID")) & "</td>"
Response.Write " <td align=""center""> "
If RSObj("Verific") = 1 Then
Response.Write "已审核"
Else
Response.Write "<font color=red>未审核</font>"
End If
Response.Write " </td>"
Response.Write " </tr>"
i = i + 1
If i > MaxPerPage Then
Exit Do
End If
RSObj.MoveNext
Loop
RSObj.Close
Set RSObj = Nothing
Response.Write ("<tr> ")
Response.Write (" <td height=""22"" align=""right"" colspan=""5"">")
Call KSCMS.showpage(totalPut, MaxPerPage, "Collect_IntoDataBase.asp", True, "条", CurrentPage)
Response.Write ("</td></tr>")
End Sub
End Class
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -