<% '************************************************************** ' Software name: PowerEasy SiteWeaver ' Web: http://www.powereasy.net ' Copyright (C) 2005-2009 佛山市动易网络科技有限公司 版权所有 '************************************************************** Const NeedCheckComeUrl = True '是否需要检查外部访问 Const PurviewLevel = 2 '0--不检查,1--超级管理员,2--普通管理员 Const PurviewLevel_Channel = 3 '0--不检查,1--频道管理员,2--栏目总编,3--栏目管理员 Const PurviewLevel_Others = "" '其他权限 Dim HtmlDir, PurviewChecked Dim ManageType, Status, MyStatus, arrStatus Dim ClassID, SpecialID, OnTop, IsElite, IsHot, Created Dim tClass, ClassName, RootID, ParentID, Depth, ParentPath, Child, arrChildID, ParentDir, ClassDir, ClassPurview Dim ArticleID Dim PayStatus Dim IncludePic, UploadFiles, DefaultPicUrl, IsThumb Dim ArticlePro1, ArticlePro2, ArticlePro3, ArticlePro4 Dim VoteID If ChannelID = 0 Then Response.Write "频道参数丢失!" Call CloseConn Response.End End If If ModuleType <> 1 Then Response.Write "
  • 指定的频道ID不对!
  • " Call CloseConn Response.End End If ModuleName = "Article" SheetName = "PE_Article" If AdminPurview = 1 Then MyStatus = 3 Else Select Case CheckLevel Case 0, 1 MyStatus = 3 Case 2 If AdminPurview_Channel <= 2 Then MyStatus = 3 Else MyStatus = 2 End If Case 3 MyStatus = 4 - AdminPurview_Channel End Select End If arrStatus = Array("待审核", "一审通过", "二审通过", "终审通过") HtmlDir = InstallDir & ChannelDir ManageType = Trim(Request("ManageType")) Status = Trim(Request("Status")) Created = Trim(Request("Created")) OnTop = Trim(Request("OnTop")) IsElite = Trim(Request("IsElite")) IsHot = Trim(Request("IsHot")) ClassID = PE_CLng(Trim(Request("ClassID"))) SpecialID = PE_CLng(Trim(Request("SpecialID"))) ArticleID = Trim(Request("ArticleID")) PayStatus = Trim(Request("PayStatus")) '文章支付状态 If Action = "" Then Action = "Manage" End If If Status = "" Then Status = 9 Else Status = PE_CLng(Status) '文章状态 9--所有文章,-1--草稿,0--待审核,1--已审核,-2--退稿 End If If IsValidID(ArticleID) = False Then ArticleID = "" End If If PayStatus = "" Then PayStatus = "False" End If FileName = "Admin_Article.asp?ChannelID=" & ChannelID & "&Action=" & Action & "&ManageType=" & ManageType strFileName = FileName & "&ClassID=" & ClassID & "&SpecialID=" & SpecialID & "&Field=" & strField & "&keyword=" & Keyword If XmlDoc.Load(Server.MapPath(InstallDir & "Language/Gb2312_Channel_" & ChannelID & ".xml")) = False Then XmlDoc.Load (Server.MapPath(InstallDir & "Language/Gb2312.xml")) ArticlePro1 = XmlText("Article", "ArticlePro1", "[图文]") ArticlePro2 = XmlText("Article", "ArticlePro2", "[组图]") ArticlePro3 = XmlText("Article", "ArticlePro3", "[推荐]") ArticlePro4 = XmlText("Article", "ArticlePro4", "[注意]") If Action = "ExportExcel" Then Call ExportExcel If FoundErr = True Then Call WriteErrMsg(ErrMsg, ComeUrl) End If Response.End End If Response.Write "" & ChannelShortName & "管理" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf If Action = "Add" Or Action = "Modify" Then Response.Write "" & vbCrLf Response.Write "" & vbCrLf End If Response.Write "" & vbCrLf Response.Write "" & vbCrLf If Action = "Preview" Then Call Preview Call CloseConn Response.End End If Response.Write "" Dim strTitle strTitle = ChannelName & "管理----" Select Case Action Case "Add" strTitle = strTitle & "添加" & ChannelShortName Case "Modify" strTitle = strTitle & "修改" & ChannelShortName Case "Check" strTitle = strTitle & "审核" & ChannelShortName Case "SaveAdd", "SaveModify", "SaveModifyAsAdd" strTitle = strTitle & "保存" & ChannelShortName Case "Move" strTitle = strTitle & "移动" & ChannelShortName Case "Preview", "Show" strTitle = strTitle & "预览" & ChannelShortName Case "Batch", "DoBatch" strTitle = strTitle & "批量修改" & ChannelShortName & "属性" Case "MoveToClass" strTitle = strTitle & "批量移动" & ChannelShortName Case "BatchReplace" strTitle = strTitle & "批量替换" & ChannelShortName Case "AddToSpecial" strTitle = strTitle & "添加" & ChannelShortName & "到专题" Case "MoveToSpecial" strTitle = strTitle & "移动" & ChannelShortName & "到专题" Case "Manage" Select Case ManageType Case "Check" strTitle = strTitle & ChannelShortName & "审核" Case "PayMoney" strTitle = strTitle & ChannelShortName & "稿费管理" Case "HTML" strTitle = strTitle & ChannelShortName & "生成" Case "Recyclebin" strTitle = strTitle & ChannelShortName & "回收站管理" Case "Special" strTitle = strTitle & "专题" & ChannelShortName & "管理" Case Else strTitle = strTitle & ChannelShortName & "管理首页" End Select End Select Call ShowPageTitle(strTitle, 10111) Response.Write " " Response.Write " " & vbCrLf If Action = "Manage" Then Response.Write "" Response.Write " " & vbCrLf End If Response.Write "
    管理导航:" Response.Write "" & ChannelShortName & "管理首页 | " Response.Write "添加" & ChannelShortName & " | " Response.Write "审核" & ChannelShortName & "" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write " | 专题" & ChannelShortName & "管理" End If If AdminPurview = 1 Or AdminPurview_Channel = 1 Then Response.Write " | " & ChannelShortName & "回收站管理" End If If FoundInArr(arrEnabledTabs, "Copyfee", ",") = True Then Response.Write " | 稿费管理" End If If UseCreateHTML > 0 And ObjInstalled_FSO = True Then Response.Write " | 生成HTML管理" End If Response.Write "
    " & ChannelShortName & "选项:" If ManageType = "PayMoney" Then Response.Write "未支付稿费的" & ChannelShortName & "   " Response.Write "已支付稿费的" & ChannelShortName ElseIf ManageType = "HTML" Then Response.Write "所有" & ChannelShortName & "    " Response.Write "未生成的" & ChannelShortName & "   " Response.Write "已生成的" & ChannelShortName Else Response.Write "所有" & ChannelShortName & "    " Response.Write "草稿    " Response.Write "待审核    " Response.Write "已审核    " Response.Write "退稿" Response.Write "" Response.Write " 固顶" & ChannelShortName & "    " Response.Write " 推荐" & ChannelShortName & "    " Response.Write " 热门" & ChannelShortName End If Response.Write "
    " & vbCrLf strFileName = strFileName & "&Status=" & Status & "&Created=" & Created & "&PayStatus=" & PayStatus & "&OnTop=" & OnTop & "&IsElite=" & IsElite & "&IsHot=" & IsHot Select Case Action Case "Add" Call Add Case "Modify", "Check" Call Modify Case "SaveAdd", "SaveModify", "SaveModifyAsAdd" Call SaveArticle Case "SetOnTop", "CancelOnTop", "SetElite", "CancelElite", "SetPassed", "CancelPassed", "Reject" Call SetProperty Case "Show" Call Show Case "Del" Call Del Case "ConfirmDel" Call ConfirmDel Case "ClearRecyclebin" Call ClearRecyclebin Case "Restore" Call Restore Case "RestoreAll" Call RestoreAll Case "DelFile" Call DelFile Case "Batch" Call Batch Case "DoBatch" Call DoBatch Case "MoveToClass" Call ShowForm_MoveToClass Case "MoveToSpecial" Call ShowForm_MoveToSpecial Case "AddToSpecial" Call ShowForm_AddToSpecial Case "DoMoveToClass" Call DoMoveToClass Case "DoMoveToSpecial" Call DoMoveToSpecial Case "DoAddToSpecial" Call DoAddToSpecial Case "DelFromSpecial" Call DelFromSpecial Case "BatchReplace" Call BatchReplace Case "DoBatchReplace" Call DoBatchReplace Case "Manage" Call main Case "ConfirmPay" Call ConfirmPay End Select If FoundErr = True Then Call WriteErrMsg(ErrMsg, ComeUrl) End If Response.Write "" Call CloseConn Sub main() If ManageType = "HTML" And UseCreateHTML = 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 本频道设置了不生成HTML,所以不用进行生成管理!
  • " Exit Sub End If Dim arrUser, i, NotReceiveUser Dim rsArticleList, sql, Querysql PurviewChecked = False If ClassID = 0 Then If strField = "" And AdminPurview = 2 And AdminPurview_Channel = 3 And ManageType <> "My" Then If ManageType = "Check" Or ManageType = "PayMoney" Then If arrClass_Check = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,您没有在此频道审核" & ChannelShortName & "的权限!
  • " Exit Sub End If Set tClass = Conn.Execute("select top 1 ClassID,ClassName,RootID,ParentID,Depth,ParentPath,Child,arrChildID,ClassPurview,ParentDir,ClassDir from PE_Class where ChannelID=" & ChannelID & " and ClassID In (" & DelRightComma(arrClass_Check) & ")") Else If arrClass_Manage = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,您没有在此频道管理" & ChannelShortName & "的权限!
  • " Exit Sub End If Set tClass = Conn.Execute("select top 1 ClassID,ClassName,RootID,ParentID,Depth,ParentPath,Child,arrChildID,ClassPurview,ParentDir,ClassDir from PE_Class where ChannelID=" & ChannelID & " and ClassID In (" & DelRightComma(arrClass_Manage) & ")") End If If tClass.BOF And tClass.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,您没有在此频道的管理权限!
  • " Else ClassID = tClass(0) ClassName = tClass(1) RootID = tClass(2) ParentID = tClass(3) Depth = tClass(4) ParentPath = tClass(5) Child = tClass(6) arrChildID = tClass(7) PurviewChecked = True ClassPurview = tClass(8) ParentDir = tClass(9) ClassDir = tClass(10) End If End If ElseIf ClassID = -1 Then If AdminPurview = 1 Or (AdminPurview = 2 And AdminPurview_Channel < 3) Then PurviewChecked = True ElseIf ClassID > 0 Then Set tClass = Conn.Execute("select ClassName,RootID,ParentID,Depth,ParentPath,Child,arrChildID,ClassPurview,ParentDir,ClassDir from PE_Class where ClassID=" & ClassID) If tClass.BOF And tClass.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到指定的栏目
  • " Else ClassName = tClass(0) RootID = tClass(1) ParentID = tClass(2) Depth = tClass(3) ParentPath = tClass(4) Child = tClass(5) arrChildID = tClass(6) ClassPurview = tClass(7) ParentDir = tClass(8) ClassDir = tClass(9) End If Set tClass = Nothing End If If FoundErr = True Then Exit Sub If PurviewChecked = False Then If ManageType = "Check" Or ManageType = "PayMoney" Then If ParentID > 0 Then PurviewChecked = CheckPurview_Class(arrClass_Check, ParentPath & "," & ClassID) Else PurviewChecked = CheckPurview_Class(arrClass_Check, ClassID) End If Else If ParentID > 0 Then PurviewChecked = CheckPurview_Class(arrClass_Manage, ParentPath & "," & ClassID) Else PurviewChecked = CheckPurview_Class(arrClass_Manage, ClassID) End If End If End If Call ShowJS_Manage(ChannelShortName) Response.Write "
    " If ManageType = "Special" Then Response.Write "" Response.Write " " & vbCrLf Else Response.Write " " Response.Write " " Response.Write " " & GetChild_Root() & "" End If Response.Write "
    " & GetSpecialList() & "
    " & GetRootClass() & "

    " Select Case ManageType Case "Check" Call ShowContentManagePath(ChannelShortName & "审核") Case "PayMoney" Call ShowContentManagePath("稿费管理") Case "Receive" Call ShowContentManagePath(ChannelShortName & "签收管理") Case "HTML" Call ShowContentManagePath(ChannelShortName & "生成") Case "Recyclebin" Call ShowContentManagePath(ChannelShortName & "回收站管理") Case "Special" Call ShowContentManagePath("专题" & ChannelShortName & "管理") Case Else Call ShowContentManagePath(ChannelShortName & "管理") End Select Response.Write "" Response.Write " " Response.Write " " Response.Write "
    " Response.Write " " Response.Write " " Response.Write " " If ManageType = "Special" Then Response.Write " " End If Response.Write " " Response.Write " " '添加稿费管理界面 If ManageType = "PayMoney" Then Response.Write " " Response.Write " " Response.Write " " Response.Write " " If PayStatus = "True" Then Response.Write " " Else Response.Write " " End If Else Response.Write " " Response.Write " " Response.Write " " End If If UseCreateHTML > 0 And ObjInstalled_FSO = True And ManageType <> "Special" Then Response.Write " " End If If ManageType = "Check" Then Response.Write " " ElseIf ManageType = "PayMoney" Then If PayStatus = "False" Then Response.Write " " End If ElseIf ManageType = "HTML" Then Response.Write " " ElseIf ManageType = "Recyclebin" Then Response.Write " " ElseIf ManageType = "Special" Then Response.Write " " Else Response.Write " " End If Response.Write " " If ManageType = "Special" Then sql = "select top " & MaxPerPage & " I.InfoID,I.SpecialID,A.ArticleID,SP.SpecialName,A.Title,A.Keyword,A.Author,A.UpdateTime,A.Inputer," sql = sql & "A.CopyFrom,A.DefaultPicUrl,A.IncludePic,A.PaginationType,A.Receive,A.ReceiveUser,A.Received," sql = sql & "A.Hits,A.OnTop,A.Elite,A.Status,A.Stars,A.InfoPoint,A.VoteID" sql = sql & " from PE_Article A right join (PE_InfoS I left join PE_Special SP on I.SpecialID=SP.SpecialID) on A.ArticleID=I.ItemID " Else If ClassID = -1 Or (ClassID > 0 And Child = 0) Then sql = "select top " & MaxPerPage & " A.ClassID,A.ArticleID,A.Title,A.Keyword,A.Author,A.UpdateTime,A.Inputer," sql = sql & "A.CopyFrom,A.IncludePic,A.DefaultPicUrl,A.PaginationType,A.Receive,A.ReceiveUser,A.Received," sql = sql & "A.Hits,A.OnTop,A.Elite,A.Status,A.Stars,A.InfoPoint,A.Beneficiary,A.IsPayed,A.CopyMoney,A.PayDate,A.VoteID" sql = sql & " from PE_Article A " Else sql = "select top " & MaxPerPage & " A.ClassID,A.ArticleID,C.ClassName,C.ParentDir,C.ClassDir,C.ClassPurview,A.Title,A.Keyword,A.Author,A.UpdateTime,A.Inputer," sql = sql & "A.CopyFrom,A.IncludePic,A.DefaultPicUrl,A.PaginationType,A.Receive,A.ReceiveUser,A.Received," sql = sql & "A.Hits,A.OnTop,A.Elite,A.Status,A.Stars,A.InfoPoint,A.Beneficiary,A.IsPayed,A.CopyMoney,A.PayDate,A.VoteID" sql = sql & " from PE_Article A left join PE_Class C on A.ClassID=C.ClassID " End If End If Querysql = " where A.ChannelID=" & ChannelID If ManageType = "Special" Then Querysql = Querysql & " and I.ModuleType=" & ModuleType End If If ManageType = "Receive" Then Querysql = Querysql & " and A.Receive=" & PE_True & "" End If If ManageType = "Recyclebin" Then Querysql = Querysql & " and A.Deleted=" & PE_True & "" Else Querysql = Querysql & " and A.Deleted=" & PE_False & "" End If If ManageType = "HTML" Then If Created = "False" Then Querysql = Querysql & " and (A.CreateTime<=A.UpdateTime or A.CreateTime is Null)" ElseIf Created = "True" Then Querysql = Querysql & " and A.CreateTime>A.UpdateTime" End If Querysql = Querysql & " and A.Status=3" '当文章为已审核时,才在生成管理中出现 ElseIf ManageType = "PayMoney" Then '如果是稿费管理,则查出所有的以通过审查但是却没有被删除和计算稿费的文章 If PayStatus = "False" Then Querysql = Querysql & " and A.Status=3 and A.CopyMoney>0 and A.IsPayed=" & PE_False & "" '查询出计算过,但是没有被支付的文章 ElseIf PayStatus = "True" Then Querysql = Querysql & " and A.Status=3 and A.CopyMoney>0 and A.IsPayed=" & PE_True & "" '查询出被计算了,并且支付过的文章 End If Else Select Case Status Case -2 '退稿 Querysql = Querysql & " and A.Status=-2" Case -1 '草稿 Querysql = Querysql & " and A.Status=-1" Case 0 '待审核 Querysql = Querysql & " and A.Status>=0 and A.Status<" & MyStatus Case 1 '已审核 Querysql = Querysql & " and A.Status>=" & MyStatus Case Else Querysql = Querysql & " and A.Status>-1" End Select If OnTop = "True" Then Querysql = Querysql & " and A.OnTop=" & PE_True & "" End If If IsElite = "True" Then Querysql = Querysql & " and A.Elite=" & PE_True & "" End If If IsHot = "True" Then Querysql = Querysql & " and A.Hits>=" & HitsOfHot & "" End If End If If ClassID <> 0 Then If Child > 0 Then Querysql = Querysql & " and A.ClassID in (" & arrChildID & ")" Else Querysql = Querysql & " and A.ClassID=" & ClassID End If End If If SpecialID > 0 Then Querysql = Querysql & " and I.SpecialID=" & SpecialID End If If ManageType = "My" Then Querysql = Querysql & " and A.Inputer='" & UserName & "' " End If If Keyword <> "" Then Select Case strField Case "Title" Querysql = Querysql & " and A.Title like '%" & Keyword & "%' " Case "Content" Querysql = Querysql & " and A.Content like '%" & Keyword & "%' " Case "Author" Querysql = Querysql & " and A.Author like '%" & Keyword & "%' " Case "Inputer" Querysql = Querysql & " and A.Inputer='" & Keyword & "' " Case "Editor" Querysql = Querysql & " and A.Editor='" & Keyword & "' " Case "UpdateTime" Querysql = Querysql & " and DateDiff(" & PE_DatePart_D & ",A.UpdateTime,'" & Keyword & "')=0 " Case "Keyword" Querysql = Querysql & " and A.Keyword like '%|" & Keyword & "|%' " Case "ID" Querysql = Querysql & " and A.ArticleID=" & PE_Clng(Keyword) & " " Case Else Querysql = Querysql & " and A.Title like '%" & Keyword & "%' " End Select End If If ManageType = "Special" Then totalPut = PE_CLng(Conn.Execute("select Count(*) from PE_InfoS I inner join PE_Article A on I.ItemID=A.ArticleID " & Querysql)(0)) Else totalPut = PE_CLng(Conn.Execute("select Count(*) from PE_Article A " & Querysql)(0)) End If 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 If ManageType = "Special" Then Querysql = Querysql & " and I.InfoID < (select min(InfoID) from (select top " & ((CurrentPage - 1) * MaxPerPage) & " I.InfoID from PE_InfoS I inner join PE_Article A on I.ItemID=A.ArticleID " & Querysql & " order by I.InfoID desc) as QueryArticle)" Else Querysql = Querysql & " and A.ArticleID < (select min(ArticleID) from (select top " & ((CurrentPage - 1) * MaxPerPage) & " A.ArticleID from PE_Article A " & Querysql & " order by A.ArticleID desc) as QueryArticle)" End If End If If ManageType = "Special" Then sql = sql & Querysql & " order by I.InfoID desc" Else sql = sql & Querysql & " order by A.ArticleID desc" End If Set rsArticleList = Server.CreateObject("ADODB.Recordset") rsArticleList.Open sql, Conn, 1, 1 If rsArticleList.BOF And rsArticleList.EOF Then totalPut = 0 Response.Write "" Else Dim ArticleNum, ArticlePath ArticleNum = 0 Do While Not rsArticleList.EOF Response.Write " " If ManageType = "Special" Then Response.Write " " Response.Write " " Response.Write " " Else Response.Write " " Response.Write " " End If Response.Write " " Response.Write " " '修改审核管理界面 If ManageType = "PayMoney" Then Response.Write " " Response.Write " " Response.Write " " If rsArticleList("Ispayed") = True Then Response.Write " " Else Response.Write " " End If If PayStatus Then Response.Write " " Else Response.Write " " End If Else Response.Write " " Response.Write " " Response.Write " " End If Dim iClassPurview If UseCreateHTML > 0 And ObjInstalled_FSO = True And ManageType <> "Special" Then Response.Write " " End If Select Case ManageType Case "Check" Response.Write "" Case "PayMoney" If rsArticleList("IsPayed") = False And PayStatus = "False" Then Response.Write "" End If Case "HTML" Response.Write " " Case "Recyclebin" Response.Write "" Case "Special" Response.Write "" Case Else Response.Write " " End Select Response.Write "" ArticleNum = ArticleNum + 1 If ArticleNum >= MaxPerPage Then Exit Do rsArticleList.MoveNext Loop End If rsArticleList.Close Set rsArticleList = Nothing Response.Write "
    选中ID所属专题" & ChannelShortName & "标题录入者作者稿费受益者稿费已支付支付日期录入日期点击数" & ChannelShortName & "属性审核状态已生成审核操作稿费操作生成HTML操作回收站操作专题管理操作常规管理操作

    " If ClassID > 0 Then Response.Write "此栏目及其子栏目中没有任何" Else Response.Write "没有任何" End If If ManageType = "PayMoney" Then Select Case PayStatus Case "True" Response.Write "已付稿费的" & ChannelShortName & "!" Case "False" Response.Write "未支付稿费" & ChannelShortName & "!" 'Case Else ' Response.Write "需要支付稿费的" & ChannelShortName & "!" End Select Else Select Case Status Case -2 Response.Write "退稿" Case -1 Response.Write "草稿" Case 0 Response.Write "待审核的" & ChannelShortName & "!" Case 1 Response.Write "已审核的" & ChannelShortName & "!" Case Else Response.Write ChannelShortName & "!" End Select End If Response.Write "

    " & rsArticleList("InfoID") & "" If rsArticleList("SpecialID") > 0 Then Response.Write "" & rsArticleList("SpecialName") & "" Else Response.Write " " End If Response.Write "" & rsArticleList("ArticleID") & "" If ManageType <> "Special" Then If rsArticleList("ClassID") <> ClassID And ClassID <> -1 Then Response.Write "[" If rsArticleList("ClassName") <> "" Then Response.Write rsArticleList("ClassName") Else Response.Write "不属于任何栏目" End If Response.Write "] " End If End If Select Case rsArticleList("IncludePic") Case 1 Response.Write "" & ArticlePro1 & "" Case 2 Response.Write "" & ArticlePro2 & "" Case 3 Response.Write "" & ArticlePro3 & "" Case 4 Response.Write "" & ArticlePro4 & "" End Select Response.Write "" & rsArticleList("title") & "" If ManageType = "Receive" And rsArticleList("Receive") = True Then Response.Write " " If rsArticleList("Received") = "" Then NotReceiveUser = rsArticleList("ReceiveUser") Else NotReceiveUser = "" arrUser = Split(rsArticleList("ReceiveUser"), ",") For i = 0 To UBound(arrUser) If FoundInArr(rsArticleList("Received"), arrUser(i), "|") = False Then If NotReceiveUser = "" Then NotReceiveUser = arrUser(i) Else NotReceiveUser = NotReceiveUser & "," & arrUser(i) End If End If Next End If Response.Write "[签收中]" Else Response.Write "'>[已签收]" End If End If Response.Write "" & rsArticleList("Inputer") & "" & rsArticleList("Author") & "" & rsArticleList("Beneficiary") & "" & FormatNumber(rsArticleList("CopyMoney"), 2, vbTrue, vbFalse, vbTrue) & "√×" & rsArticleList("payDate") & "" & rsArticleList("UpdateTime") & "" & rsArticleList("Hits") & "" If rsArticleList("OnTop") = True Then Response.Write "顶 " Else Response.Write "   " End If If rsArticleList("Hits") >= HitsOfHot Then Response.Write "热 " Else Response.Write "   " End If If rsArticleList("Elite") = True Then Response.Write "荐 " Else Response.Write "   " End If If Trim(rsArticleList("DefaultPicUrl")) <> "" Then Response.Write "图" Else Response.Write "  " End If If rsArticleList("VoteID") > 0 Then Response.Write "调" Else Response.Write "  " End If Response.Write " " Select Case rsArticleList("Status") Case -2 Response.Write "退稿" Case -1 Response.Write "草稿" Case 0 Response.Write "待审核" Case 1 Response.Write "一审通过" Case 2 Response.Write "二审通过" Case 3 Response.Write "终审通过" End Select Response.Write "" If ClassID = -1 Or (ClassID > 0 And Child = 0) Then iClassPurview = ClassPurview ArticlePath = HtmlDir & GetItemPath(StructureType, ParentDir, ClassDir, rsArticleList("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsArticleList("UpdateTime"), rsArticleList("ArticleID")) & FileExt_Item Else iClassPurview = PE_CLng(rsArticleList("ClassPurview")) ArticlePath = HtmlDir & GetItemPath(StructureType, rsArticleList("ParentDir"), rsArticleList("ClassDir"), rsArticleList("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsArticleList("UpdateTime"), rsArticleList("ArticleID")) & FileExt_Item End If If iClassPurview > 0 Or rsArticleList("InfoPoint") > 0 Then Response.Write "¤" Else If fso.FileExists(Server.MapPath(ArticlePath)) Then Response.Write "√" Else Response.Write "×" End If End If Response.Write "" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Then If rsArticleList("Status") <= MyStatus Then If rsArticleList("Status") > -1 Then Response.Write "直接退稿  " End If If rsArticleList("Status") < MyStatus Then Response.Write "审核  " Response.Write "通过  " Else Response.Write "取消审核" End If End If End If Response.Write "支付稿费 " If iClassPurview = 0 And rsArticleList("InfoPoint") = 0 And rsArticleList("Status") = 3 And (AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True) Then Response.Write "生成文件 " If fso.FileExists(Server.MapPath(ArticlePath)) Then Response.Write "查看文件 " Response.Write "删除文件 " End If End If Response.Write "" Response.Write "彻底删除 " Response.Write "还原" Response.Write "" If rsArticleList("SpecialID") > 0 Then Response.Write "从所属专题中删除 " End If Response.Write " " If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or CheckPurview_Class(arrClass_Input, ParentPath & "," & ClassID) Or UserName = rsArticleList("Inputer") Then Response.Write "修改 " Else Response.Write "修改 " End If If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Or UserName = rsArticleList("Inputer") Then Response.Write "删除 " Else Response.Write "删除 " End If If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Then If rsArticleList("OnTop") = False Then Response.Write "固顶 " Else Response.Write "解固 " End If If rsArticleList("Elite") = False Then Response.Write "设为推荐" Else Response.Write "取消推荐" End If End If Response.Write "
    " Response.Write "" Response.Write " " Response.Write " " Response.Write "
    选中本页显示的所有" & ChannelShortName & "" Select Case ManageType Case "Check" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Then Response.Write "  " Response.Write "  " If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write "" End If End If Case "HTML" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Then Response.Write "" Response.Write "" If ClassID > 0 Then If UseCreateHTML = 1 Or UseCreateHTML = 3 And ClassPurview < 2 Then Response.Write "  " End If If ClassPurview = 0 Then Response.Write "  " End If Else Response.Write "  " If UseCreateHTML = 1 Or UseCreateHTML = 3 Then Response.Write "  " End If Response.Write "  " End If Response.Write "    " Response.Write "" End If Case "Recyclebin" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write " " Response.Write "    " Response.Write " " Response.Write "" End If Case "Special" If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write " " Response.Write " " Response.Write "" End If Case "PayMoney" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" If PayStatus = "False" Then Response.Write "" End If Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "
    " Call PopCalendarInit Response.Write "按ID范围选择:" Response.Write "起始ID" Response.Write "    " Response.Write "终止ID" Response.Write "   
    " Response.Write "按日期范围选择:" Response.Write "起始日期 结束日期" If PayStatus = "False" Then Response.Write "" Else Response.Write "" End If Response.Write "
    " Case Else If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or PurviewChecked = True Then Response.Write " " If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " End If End If End Select Response.Write "" Response.Write "" Response.Write "
    " Response.Write "
    " ' If SystemDatabaseType = "SQL" Then ' totalPut = Cmd.Parameters("RETURN_VALUE").Value ' CurrentPage = Cmd.Parameters("@ActualPage").Value ' End If If totalPut > 0 Then Response.Write ShowPage(strFileName, totalPut, MaxPerPage, CurrentPage, True, True, ChannelItemUnit & ChannelShortName & "", True) End If Response.Write "
    " Response.Write "" Response.Write "" Response.Write " " Response.Write " " Response.Write "
    " & ChannelShortName & "搜索:" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "
    " Response.Write "
    说明:
        " & ChannelShortName & "属性中的各项含义:顶----固顶" & ChannelShortName & ",热----热门" & ChannelShortName & ",荐----推荐" & ChannelShortName & ",图----首页图片" & ChannelShortName & ",调----有调查

    " End Sub Sub ShowJS_Article() Response.Write "" & vbCrLf End Sub Function ReplaceJSImage(ByVal Content) If Content = "" Then ReplaceJSImage = Content Exit Function End If Dim strTemp '图片替换JS regEx.Pattern = "(\)" Set Matches = regEx.Execute(Content) For Each Match In Matches strTemp = Replace(Match.value, "<", "[!") strTemp = Replace(strTemp, ">", "!]") strTemp = Replace(strTemp, "'", """") strTemp = "#" & strTemp & "#" Content = Replace(Content, Match.value, strTemp) Next ReplaceJSImage = Content End Function Sub ShowTabs_Title() Response.Write "" & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    基本信息所属专题属性设置自定义选项 
    " & vbCrLf End Sub Sub ShowTabs_Bottom() Response.Write "" & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    基本信息所属专题属性设置自定义选项 
    " & vbCrLf End Sub Sub Add() Call ShowJS_Article Response.Write "
    您现在的位置:" & ChannelName & "管理 >> 添加" & ChannelShortName & "
    " Response.Write "
    " Call ShowTabs_Title Response.Write "" Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write " " Response.Write " " & vbCrLf Call ShowTr_Class Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Call ShowTabs_Status_Add Response.Write " " & vbCrLf Call ShowTabs_Special(SpecialID, "") Call ShowTabs_Property_Add Call ShowTabs_Purview_Add("阅读") Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Call ShowTabs_Vote_Add Call ShowTabs_MyField_Add Response.Write "
    " & ChannelShortName & "标题:" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    简短标题:" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write "
    完整标题:
    副 标 题:
    显示" & ChannelShortName & "列表时在标题旁显示评论链接    
    " Response.Write "
    关键字:" Response.Write "
    * " & GetKeywordList("Admin", ChannelID) Response.Write "
    用来查找相关" & ChannelShortName & ",可输入多个关键字,中间用“|”隔开。不能出现"'&?;:()等字符。" Response.Write "
    " & ChannelShortName & "作者:" Response.Write "
    " & GetAuthorList("Admin", ChannelID, UserName) Response.Write "
    " Response.Write "
    " & ChannelShortName & "来源:" Response.Write "
    " & GetCopyFromList("Admin", ChannelID) Response.Write "
    " Response.Write "
    转向链接:" Response.Write " " Response.Write " 使用转向链接" Response.Write "
    " & ChannelShortName & "简介:

    " & ChannelShortName & "内容:

    " If EnableSaveRemote = True And IsObjInstalled("Microsoft.XMLHTTP") = True Then Response.Write "" If PhotoObject = 1 Then Response.Write "" Response.Write "" End If Response.Write "
    自动下载" & ChannelShortName & "内容里的图片
    是否给" & ChannelShortName & "内容里远程获得的图片加水印
    是否给" & ChannelShortName & "内容里远程获得的第一张图片加缩略图
    " Response.Write "
        启用此功能后,如果从其它网站上复制内容到右边的编辑器中,并且内容中包含有图片,本系统会在保存" & ChannelShortName & "时自动把相关图片复制到本站服务器上。" Response.Write "
        系统会因所下载图片的大小而影响速度,建议图片较多时不要使用此功能。
    " End If Response.Write "

    换行请按Shift+Enter

    另起一段请按Enter




    " Response.Write "
    " Response.Write " " Response.Write " " Response.Write "
    首页图片:" Response.Write " " Response.Write " 用于在首页的图片" & ChannelShortName & "处显示
    直接从上传图片中选择:" Response.Write " " Response.Write " " Response.Write "
    内容分页方式:" Response.Write " " Response.Write "     注:手动分页符标记为“[NextPage]”,注意大小写" Response.Write "
     自动分页时的每页大约字符数(包含HTML标记且必须大于100):
    " Response.Write "
    " Call ShowTabs_Bottom Response.Write "

    " Response.Write " " Response.Write " " Response.Write "   " Response.Write " " Response.Write " " Response.Write "


    " Response.Write "
    " End Sub Sub Modify() Dim rsArticle, sql, tmpAuthor, tmpCopyFrom If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要修改的" & ChannelShortName & "ID
  • " Exit Sub Else ArticleID = PE_CLng(ArticleID) End If sql = "select * from PE_Article where ArticleID=" & ArticleID & "" Set rsArticle = Conn.Execute(sql) If rsArticle.BOF And rsArticle.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到" & ChannelShortName & "
  • " rsArticle.Close Set rsArticle = Nothing Exit Sub End If ClassID = rsArticle("ClassID") Dim arrSpecialID arrSpecialID = GetSpecialIDArr(ModuleType, ArticleID) If rsArticle("Inputer") <> UserName Then Call CheckClassPurview(Action, ClassID) End If If FoundErr = True Then rsArticle.Close Set rsArticle = Nothing Exit Sub End If tmpAuthor = rsArticle("Author") tmpCopyFrom = rsArticle("CopyFrom") EmailOfReject = Replace(EmailOfReject, "{$Title}", rsArticle("Title")) EmailOfPassed = Replace(EmailOfPassed, "{$Title}", rsArticle("Title")) Call ShowJS_Article Response.Write "
    您现在的位置:" & ChannelName & "管理 >> 修改" & ChannelShortName & "
    " Response.Write "
    " Call ShowTabs_Title Response.Write "" Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write " " Response.Write " " & vbCrLf Call ShowTr_Class Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " "" And rsArticle("LinkUrl") <> "http://" Then Response.Write "none" Response.Write "'"">" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " "" And rsArticle("LinkUrl") <> "http://" Then Response.Write "none" Response.Write "'"">" Response.Write " " Response.Write " " Response.Write " " Response.Write " "" And rsArticle("LinkUrl") <> "http://" Then Response.Write "none" Response.Write "'"">" Response.Write " " Response.Write " " Response.Write " " Call ShowTabs_Status_Modify(rsArticle) Response.Write " " & vbCrLf Call ShowTabs_Special(arrSpecialID, "") Call ShowTabs_Property_Modify(rsArticle) Call ShowTabs_Purview_Modify("阅读", rsArticle, "") Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Dim WordNum, strArticle, strSql, rsChannel, payNum '过滤空格,HTML字符,计算字数 WordNum = getWordNumber(rsArticle("Content")) If MoneyPerKw <= 0 Then payNum = 0 Else payNum = MoneyPerKw / 1000 * WordNum End If Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Call ShowTabs_Vote_Modify(rsArticle) Call ShowTabs_MyField_Modify(rsArticle) Response.Write "
    " & ChannelShortName & "标题:" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    简短标题:" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write "
    完整标题:
    副 标 题:
     " Response.Write " 显示" & ChannelShortName & "列表时在标题旁显示评论链接
    " Response.Write "
    关键字:" Response.Write "
    * " & GetKeywordList("Admin", ChannelID) Response.Write "
    " Response.Write " 用来查找相关" & ChannelShortName & ",可输入多个关键字,中间用“|”隔开。不能出现"'&?;:()等字符。" Response.Write "
    " & ChannelShortName & "作者:" Response.Write "
    " & GetAuthorList("Admin", ChannelID, UserName) Response.Write "
    " Response.Write "
    " & ChannelShortName & "来源:" Response.Write "
    " & GetCopyFromList("Admin", ChannelID) Response.Write "
    " Response.Write "
    转向链接:" Response.Write " "" And rsArticle("LinkUrl") <> "http://" Then Response.Write " checked" Response.Write ">使用转向链接
    " & ChannelShortName & "简介:

    " & ChannelShortName & "内容:

    " If EnableSaveRemote = True And IsObjInstalled("Microsoft.XMLHTTP") = True Then Response.Write "" If PhotoObject = 1 Then Response.Write "" Response.Write "" End If Response.Write "
    自动下载" & ChannelShortName & "内容里的图片
    是否给" & ChannelShortName & "内容里远程获得的图片加水印
    是否给" & ChannelShortName & "内容里远程获得的第一张图片加缩略图
    " Response.Write "
        启用此功能后,如果从其它网站上复制内容到右边的编辑器中,并且内容中包含有图片,本系统会在保存" & ChannelShortName & "时自动把相关图片复制到本站服务器上。" Response.Write "
        系统会因所下载图片的大小而影响速度,建议图片较多时不要使用此功能。
    " End If Response.Write "

    换行请按Shift+Enter

    另起一段请按Enter




    " Response.Write "
    " Response.Write " " Response.Write " " Response.Write "
    首页图片:" Response.Write " 用于在首页的图片" & ChannelShortName & "处显示
    直接从上传图片中选择:" Response.Write " " Response.Write " " Response.Write "
    内容分页方式:" Response.Write " " Response.Write "     注:手动分页符标记为“[NextPage]”,注意大小写" Response.Write "
     自动分页时的每页大约字符数(包含HTML标记且必须大于100):
    " Response.Write "
    " & vbCrLf Call ShowTabs_Bottom Response.Write "

    " Response.Write " " Response.Write " " Response.Write " " Response.Write "  " Response.Write "  " Response.Write " " Response.Write "
    " Response.Write "


    " & vbCrLf Response.Write "
    " & vbCrLf Response.Write "" rsArticle.Close Set rsArticle = Nothing End Sub Sub SaveArticle() Dim rsArticle, sql, trs, i Dim ArticleID, ClassID, SpecialID, Title, Content Dim Keyword, Author, tAuthor, CopyFrom, Inputer, Editor, UpdateTime Dim arrUploadFiles, LinkUrl, UseLinkUrl Dim ReceiveUser Dim arrSpecialID ArticleID = Trim(Request.Form("ArticleID")) ClassID = Trim(Request.Form("ClassID")) SpecialID = Trim(Request.Form("SpecialID")) Title = Trim(Request.Form("Title")) Keyword = Trim(Request.Form("Keyword")) UseLinkUrl = Trim(Request.Form("UseLinkUrl")) LinkUrl = Trim(Request.Form("LinkUrl")) For i = 1 To Request.Form("Content").Count Content = Content & Request.Form("Content")(i) Next Author = Trim(Request.Form("Author")) CopyFrom = Trim(Request.Form("CopyFrom")) DefaultPicUrl = Trim(Request.Form("DefaultPicUrl")) UploadFiles = Trim(Request.Form("UploadFiles")) UpdateTime = PE_CDate(Trim(Request.Form("UpdateTime"))) '注意检验这里的值 Status = PE_CLng(Trim(Request.Form("Status"))) ReceiveUser = ReplaceBadChar(Trim(Request("InceptUser"))) IncludePic = PE_CLng(Trim(Request.Form("IncludePic"))) Inputer = UserName Editor = AdminName Call CheckClassPurview(Action, ClassID) If FoundErr = True Then Exit Sub If Title = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • " & ChannelShortName & "标题不能为空
  • " Else Title = ReplaceText(Title, 2) End If Keyword = ReplaceBadChar(Keyword) If Keyword = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请输入" & ChannelShortName & "关键字
  • " Else Call SaveKeyword(Keyword) End If If UseLinkUrl = "Yes" Then If LinkUrl = "" Or LCase(LinkUrl) = "http://" Then FoundErr = True ErrMsg = ErrMsg & "
  • 链接地址不能为空
  • " Else If InStr(LinkUrl, "://") <= 0 And Left(LinkUrl, 1) <> "/" Then FoundErr = True ErrMsg = ErrMsg & "
  • 本站地址请以 / 开头。
  • " End If End If Else If Content = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • " & ChannelShortName & "内容不能为空
  • " End If End If Dim rsField Set rsField = Conn.Execute("select * from PE_Field where ChannelID=-1 or ChannelID=" & ChannelID & "") Do While Not rsField.EOF If rsField("EnableNull") = False Then If Trim(Request(rsField("FieldName"))) = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请输入" & rsField("Title") & "!
  • " End If End If rsField.MoveNext Loop If FoundErr = True Then Exit Sub End If '处理图片JS标签代码 Dim strTemp, strTemp2 regEx.Pattern = "\" Set Matches = regEx.Execute(Content) For Each Match In Matches regEx.Pattern = "\#(.*)\#" Set strTemp = regEx.Execute(Match.value) For Each Match2 In strTemp strTemp2 = Replace(Match2.value, "&", "&") strTemp2 = Replace(strTemp2, "#", "") strTemp2 = Replace(strTemp2, "&13;&10;", vbCrLf) strTemp2 = Replace(strTemp2, "&9;", "vbTab") strTemp2 = Replace(strTemp2, "[!", "<") strTemp2 = Replace(strTemp2, "!]", ">") Content = Replace(Content, Match.value, strTemp2) Next Next Title = PE_HTMLEncode(Title) Keyword = Replace("|" & Keyword & "|","||","|") '将绝对地址转化为相对地址 Dim strSiteUrl strSiteUrl = Request.ServerVariables("HTTP_REFERER") strSiteUrl = LCase(Left(strSiteUrl, InStrRev(strSiteUrl, "/") - 1)) strSiteUrl = Left(strSiteUrl, InStrRev(strSiteUrl, "/")) & ChannelDir & "/" Content = Replace(Content, strSiteUrl, "[InstallDir_ChannelDir]") Content = Replace(Content, UploadDir, "{$UploadDir}") If Trim(Request.Form("SaveRemotePic")) = "Yes" And EnableSaveRemote = True Then Content = ReplaceRemoteUrl(Content) End If '以下这段代码是为了解决内容中有如下情况下的频道目录的替换问题。就是说,只替换以频道目录开头的地址,如果是外部地址中含有频道目录,就不替换 ' ' ' ' '" Exit Sub Else Session("Title") = Title Session("AddTime") = Now() ArticleID = GetNewID("PE_Article", "ArticleID") For i = 0 To UBound(arrSpecialID) Conn.Execute ("insert into PE_InfoS (ModuleType,ItemID,SpecialID) values (" & ModuleType & "," & ArticleID & "," & PE_CLng(arrSpecialID(i)) & ")") Next sql = "select top 1 * from PE_Article" rsArticle.Open sql, Conn, 1, 3 rsArticle.addnew rsArticle("ArticleID") = ArticleID rsArticle("ChannelID") = ChannelID rsArticle("Inputer") = Inputer If UserID <> "" And UserID > 0 Then Dim blogid Set blogid = Conn.Execute("select top 1 ID from PE_Space where Type=1 and UserID=" & UserID) If blogid.BOF And blogid.EOF Then rsArticle("BlogID") = 0 Else rsArticle("BlogID") = blogid("ID") End If Set blogid = Nothing End If If ReceiveUser <> "" And Status = 3 Then rsArticle("Receive") = True Call Add_User_UnsignedItems(ArticleID, ReceiveUser) Else rsArticle("Receive") = False End If If Status = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp+" & PresentExp & " where UserName='" & Inputer & "'") End If End If ElseIf Action = "SaveModify" Then If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 不能确定ArticleID的值
  • " Else ArticleID = PE_CLng(ArticleID) sql = "select * from PE_Article where ArticleID=" & ArticleID rsArticle.Open sql, Conn, 1, 3 If rsArticle.BOF And rsArticle.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到此" & ChannelShortName & ",可能已经被其他人删除。
  • " Else '删除生成的文件,因为生成的文件可能会随着更新时间,游览权限等发生变化而产生多余的文件 If UseCreateHTML > 0 And ObjInstalled_FSO = True Then Dim tClass, ArticlePath Set tClass = Conn.Execute("select ParentDir,ClassDir from PE_Class where ClassID=" & rsArticle("ClassID") & "") If tClass.BOF And tClass.EOF Then ParentDir = "/" ClassDir = "" Else ParentDir = tClass("ParentDir") ClassDir = tClass("ClassDir") End If ArticlePath = HtmlDir & GetItemPath(StructureType, ParentDir, ClassDir, rsArticle("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsArticle("UpdateTime"), rsArticle("ArticleID")) If fso.FileExists(Server.MapPath(ArticlePath & FileExt_Item)) Then DelSerialFiles Server.MapPath(ArticlePath & FileExt_Item) End If If rsArticle("PaginationType") > 0 Then DelSerialFiles Server.MapPath(ArticlePath) & "_*.*" End If End If If rsArticle("Inputer") <> UserName And rsArticle("Status") <> Status And (Status = -2 Or Status = 3) Then Call SendEmailOfCheck(rsArticle("Inputer"), rsArticle) End If Call UpdateUserData(0, rsArticle("Inputer"), 0, 0) If rsArticle("Status") < 3 And Status = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp+" & rsArticle("PresentExp") & " where UserName='" & rsArticle("Inputer") & "'") End If If rsArticle("Status") = 3 And Status < 3 Then Conn.Execute ("update PE_User set UserExp=UserExp-" & rsArticle("PresentExp") & " where UserName='" & rsArticle("Inputer") & "'") End If Dim rsInfo, sqlInfo, j i = 0 sqlInfo = "select * from PE_InfoS where ModuleType=" & ModuleType & " and ItemID=" & ArticleID & " order by InfoID" Set rsInfo = Server.CreateObject("adodb.recordset") rsInfo.Open sqlInfo, Conn, 1, 3 Do While Not rsInfo.EOF If i > UBound(arrSpecialID) Then rsInfo.Delete Else rsInfo("SpecialID") = arrSpecialID(i) End If rsInfo.Update rsInfo.MoveNext i = i + 1 Loop rsInfo.Close Set rsInfo = Nothing If (i - 1) < UBound(arrSpecialID) Then For j = i To UBound(arrSpecialID) If PE_CLng(arrSpecialID(j)) <> 0 Then Conn.Execute ("insert into PE_InfoS (ModuleType,ItemID,SpecialID) values (" & ModuleType & "," & ArticleID & "," & PE_CLng(arrSpecialID(j)) & ")") End If Next End If If ReceiveUser = "" Or Status <> 3 Then rsArticle("Receive") = False If rsArticle("ReceiveUser") <> "" Then Call Del_User_UnsignedItems(ArticleID, rsArticle("ReceiveUser")) End If Else rsArticle("Receive") = True If rsArticle("ReceiveUser") <> "" Then Call Del_User_UnsignedItems(ArticleID, rsArticle("ReceiveUser")) End If Call Add_User_UnsignedItems(ArticleID, ReceiveUser) End If End If End If End If rsArticle("ClassID") = ClassID rsArticle("Title") = Title rsArticle("TitleIntact") = Trim(Request.Form("TitleIntact")) rsArticle("Subheading") = Trim(Request.Form("Subheading")) rsArticle("TitleFontColor") = Trim(Request.Form("TitleFontColor")) rsArticle("TitleFontType") = PE_CLng(Trim(Request.Form("TitleFontType"))) rsArticle("Intro") = Trim(Request.Form("Intro")) rsArticle("Content") = Content rsArticle("Keyword") = Keyword rsArticle("Author") = Author rsArticle("CopyFrom") = CopyFrom rsArticle("LinkUrl") = LinkUrl rsArticle("Editor") = Editor rsArticle("IncludePic") = IncludePic rsArticle("ShowCommentLink") = PE_CBool(Trim(Request.Form("ShowCommentLink"))) rsArticle("Status") = Status rsArticle("OnTop") = PE_CBool(Trim(Request.Form("OnTop"))) rsArticle("Elite") = PE_CBool(Trim(Request.Form("Elite"))) If Action = "SaveModifyAsAdd" Then rsArticle("Hits") = 0 Else rsArticle("Hits") = PE_CLng(Trim(Request.Form("Hits"))) End IF rsArticle("Stars") = PE_CLng(Trim(Request.Form("Stars"))) rsArticle("UpdateTime") = UpdateTime rsArticle("CreateTime") = UpdateTime rsArticle("PaginationType") = PE_CLng(Trim(Request.Form("PaginationType"))) rsArticle("MaxCharPerPage") = PE_CLng(Trim(Request.Form("MaxCharPerPage"))) rsArticle("SkinID") = PE_CLng(Trim(Request.Form("SkinID"))) rsArticle("TemplateID") = PE_CLng(Trim(Request.Form("TemplateID"))) rsArticle("DefaultPicUrl") = DefaultPicUrl rsArticle("UploadFiles") = UploadFiles rsArticle("Deleted") = False rsArticle("PresentExp") = PresentExp rsArticle("Copymoney") = PE_CDbl(Trim(Request.Form("CopyMoney"))) '稿费 rsArticle("IsPayed") = False rsArticle("Beneficiary") = Trim(Request.Form("Beneficiary")) '稿费受益者 多个受益者之间用“,”隔开 rsArticle("InfoPurview") = PE_CLng(Trim(Request.Form("InfoPurview"))) rsArticle("arrGroupID") = ReplaceBadChar(Trim(Request.Form("GroupID"))) rsArticle("InfoPoint") = PE_CLng(Trim(Request.Form("InfoPoint"))) rsArticle("ChargeType") = PE_CLng(Trim(Request.Form("ChargeType"))) rsArticle("PitchTime") = PE_CLng(Trim(Request.Form("PitchTime"))) rsArticle("ReadTimes") = PE_CLng(Trim(Request.Form("ReadTimes"))) rsArticle("DividePercent") = PE_CLng(Trim(Request.Form("DividePercent"))) rsArticle("ReceiveUser") = ReceiveUser rsArticle("Received") = "" rsArticle("AutoReceiveTime") = PE_CLng(Request("AutoReceiveTime")) rsArticle("ReceiveType") = PE_CLng(Request("ReceiveType")) '获得签收文章的类型,0 为公有,1为私有 rsArticle("VoteID") = VoteID If Not (rsField.BOF And rsField.EOF) Then rsField.MoveFirst Do While Not rsField.EOF If Trim(Request(rsField("FieldName"))) <> "" Or rsField("EnableNull") = True Then rsArticle(Trim(rsField("FieldName"))) = Trim(Request(rsField("FieldName"))) End If rsField.MoveNext Loop End If Set rsField = Nothing rsArticle.Update rsArticle.Close Set rsArticle = Nothing Call UpdateChannelData(ChannelID) If Action = "SaveAdd" Or Action = "SaveModifyAsAdd" Then Call UpdateUserData(0, Inputer, 0, 0) End If Response.Write "

    " Response.Write "" Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " If Action = "SaveAdd" Or Action = "SaveModifyAsAdd" Then Response.Write "添加" & ChannelShortName & "成功" Else Response.Write "修改" & ChannelShortName & "成功" End If Response.Write "
    所属栏目:" & ShowClassPath() & "
    " & ChannelShortName & "标题:" & Title & "
    作    者:" & Author & "
    " & ChannelShortName & "来源:" & CopyFrom & "
    关 键 字:" & Mid(Keyword, 2, Len(Keyword) - 2) & "
    " & ChannelShortName & "状态:" If Status = -1 Then Response.Write "草稿" ElseIf Status = -2 Then Response.Write "退稿" Else Response.Write arrStatus(Status) End If Response.Write "
    " Response.Write "【修改本文】 " Response.Write "【继续添加" & ChannelShortName & "】 " Response.Write "【" & ChannelShortName & "管理】 " Response.Write "【查看" & ChannelShortName & "内容】" Response.Write "
    " & vbCrLf Session("Keyword") = Trim(Request("Keyword")) Session("Author") = Author Session("CopyFrom") = CopyFrom Session("PaginationType") = PE_CLng(Trim(Request("PaginationType"))) Session("SkinID") = PE_CLng(Trim(Request("SkinID"))) Session("TemplateID") = PE_CLng(Trim(Request("TemplateID"))) Call ClearSiteCache(0) Call CreateAllJS If Status = 3 And PE_CLng(Trim(Request("ReceiveType"))) = 0 And UseCreateHTML > 0 And ObjInstalled_FSO = True And Trim(Request.Form("CreateImmediate")) = "Yes" Then Response.Write "
    " End If End Sub Sub Show() If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定" & ChannelShortName & "ID!
  • " Exit Sub End If Dim rsArticle, PurviewChecked, PurviewChecked2 PurviewChecked = False PurviewChecked2 = False Set rsArticle = Conn.Execute("select * from PE_Article where ArticleID=" & ArticleID & "") If rsArticle.BOF And rsArticle.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到" & ChannelShortName & "!
  • " rsArticle.Close Set rsArticle = Nothing Exit Sub End If ClassID = rsArticle("ClassID") Call CheckClassPurview(Action, ClassID) If FoundErr = True Then rsArticle.Close Set rsArticle = Nothing Exit Sub End If Dim arrSpecialID arrSpecialID = GetSpecialIDArr(ModuleType, ArticleID) Call WriteJS_Show Response.Write "
    您现在的位置: 
    " & ChannelShortName & "管理 >> " If ParentID > 0 Then Dim sqlPath, rsPath sqlPath = "select ClassID,ClassName from PE_Class where ClassID in (" & ParentPath & ") order by Depth" Set rsPath = Conn.Execute(sqlPath) Do While Not rsPath.EOF Response.Write "" & rsPath(1) & " >> " rsPath.MoveNext Loop rsPath.Close Set rsPath = Nothing End If Response.Write "" & ClassName & " >> 查看" & ChannelShortName & "内容:" Select Case rsArticle("IncludePic") Case 1 Response.Write "" & ArticlePro1 & "" Case 2 Response.Write "" & ArticlePro2 & "" Case 3 Response.Write "" & ArticlePro3 & "" Case 4 Response.Write "" & ArticlePro4 & "" End Select Response.Write rsArticle("Title") & "

    " Response.Write "" & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    文章信息所属专题收费信息签收信息稿费信息自定义选项 
    " & vbCrLf Response.Write "" Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write " " Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Call ShowTabs_Special(arrSpecialID, " disabled") Call ShowTabs_Purview_Modify("阅读", rsArticle, " disabled") Dim NotReceiveUser, arrUser, i If rsArticle("Receive") = True Then If rsArticle("Received") = "" Then NotReceiveUser = rsArticle("ReceiveUser") Else NotReceiveUser = "" arrUser = Split(rsArticle("ReceiveUser"), ",") For i = 0 To UBound(arrUser) If FoundInArr(rsArticle("Received"), arrUser(i), "|") = False Then If NotReceiveUser = "" Then NotReceiveUser = arrUser(i) Else NotReceiveUser = NotReceiveUser & "," & arrUser(i) End If End If Next End If End If Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Response.Write " " & vbCrLf Dim WordNum, strArticle, strSql, rsChannel, payNum '过滤空格,HTML字符,计算字数 WordNum = getWordNumber(rsArticle("Content")) If MoneyPerKw <= 0 Then payNum = 0 Else payNum = MoneyPerKw / 1000 * WordNum End If Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Call ShowTabs_MyField_View(rsArticle) Response.Write "
    " If Trim(rsArticle("TitleIntact")) <> "" Then Response.Write "" & rsArticle("TitleIntact") & "" Else Response.Write "" & rsArticle("Title") & "" End If If Trim(rsArticle("Subheading")) <> "" Then Response.Write "
    " & rsArticle("Subheading") End If Response.Write "
    " Dim Author, CopyFrom Author = rsArticle("Author") CopyFrom = rsArticle("CopyFrom") Response.Write "作者:" & Author & "    " & ChannelShortName & "来源:" & CopyFrom Response.Write "    点击数:" & rsArticle("Hits") & "    更新时间:" & FormatDateTime(rsArticle("UpdateTime"), 2) & "    " & ChannelShortName & "属性:" If rsArticle("OnTop") = True Then Response.Write "顶 " Else Response.Write "   " End If If rsArticle("Hits") >= HitsOfHot Then Response.Write "热 " Else Response.Write "   " End If If rsArticle("Elite") = True Then Response.Write "荐" Else Response.Write "  " End If Response.Write "  " & String(rsArticle("Stars"), "★") & "" Response.Write "
    " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " If Trim(rsArticle("LinkUrl")) <> "" Then Response.Write "




    本" & ChannelShortName & "是链接外部" & ChannelShortName & "内容。链接地址为:" & rsArticle("LinkUrl") & "

    " Else Response.Write "

    " & Replace(Replace(FilterBadTag(rsArticle("Content"), rsArticle("Inputer")), "[InstallDir_ChannelDir]", InstallDir & ChannelDir & "/"), "{$UploadDir}", UploadDir) & "

    " End If Response.Write "
    " Response.Write "
    " Response.Write ChannelShortName & "录入:" & rsArticle("Inputer") & "    责任编辑:" If rsArticle("Status") = 3 Then Response.Write rsArticle("Editor") Else Response.Write "无" End If Response.Write "
    " Response.Write "
    " & vbCrLf Response.Write "

    " Response.Write "" Response.Write "" Response.Write "" & vbCrLf If rsArticle("Deleted") = False Then PurviewChecked = CheckClassPurview("Manage", ClassID) PurviewChecked2 = CheckClassPurview("Check", ClassID) If (rsArticle("Inputer") = UserName And rsArticle("Status") = 0) Or PurviewChecked = True Then Response.Write "  " Response.Write "  " End If If AdminPurview = 1 Or AdminPurview_Channel <= 2 Then Response.Write "  " End If If PurviewChecked2 = True Then If rsArticle("Status") > -1 Then Response.Write "  " End If If rsArticle("Status") < MyStatus Then Response.Write "  " End If If rsArticle("Status") >= MyStatus Then Response.Write "  " End If End If If PurviewChecked = True Then If rsArticle("OnTop") = False Then Response.Write "  " Else Response.Write "  " End If If rsArticle("Elite") = False Then Response.Write "" Else Response.Write "" End If End If Else If AdminPurview = 1 Or AdminPurview_Channel = 1 Then Response.Write "  " Response.Write "" End If End If Response.Write "

    " rsArticle.Close Set rsArticle = Nothing Response.Write "
    " Response.Write "
  • 上一" & ChannelItemUnit & ChannelShortName & ":" Dim rsPrev Set rsPrev = Conn.Execute("Select Top 1 A.ArticleID,A.Title,C.ClassID,C.ClassName from PE_Article A left join PE_Class C On A.ClassID=C.ClassID Where A.ChannelID=" & ChannelID & " and A.Deleted=" & PE_False & " and A.ArticleID<" & ArticleID & " order by A.ArticleID desc") If rsPrev.EOF Then Response.Write "没有了" Else Response.Write "[" & rsPrev("ClassName") & "] " & rsPrev("Title") & "" End If rsPrev.Close Set rsPrev = Nothing Response.Write "
  • 下一" & ChannelItemUnit & ChannelShortName & ":" Dim rsNext Set rsNext = Conn.Execute("Select Top 1 A.ArticleID,A.Title,C.ClassID,C.ClassName from PE_Article A left join PE_Class C On A.ClassID=C.ClassID Where A.ChannelID=" & ChannelID & " and A.Deleted=" & PE_False & " and A.ArticleID>" & ArticleID & " order by A.ArticleID asc") If rsNext.EOF Then Response.Write "没有了" Else Response.Write "[" & rsNext("ClassName") & "] " & rsNext("Title") & "" End If rsNext.Close Set rsNext = Nothing Response.Write "

  • " & vbCrLf Dim InfoType InfoType = PE_CLng(Trim(Request("InfoType"))) Response.Write "相关评论相关收费" Response.Write "
     
    " strFileName = "Admin_Article.asp?Action=Show&ChannelID=" & ChannelID & "&ArticleID=" & ArticleID & "&InfoType=" & InfoType Select Case InfoType Case 0 Call ShowComment(ArticleID) Case 1 Call ShowConsumeLog(ArticleID) End Select End Sub Sub WriteJS_Show() Response.Write "" & vbCrLf End Sub Sub Preview() Call WriteJS_Show Response.Write "
    " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " If ClassID = 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定所属栏目
  • " Exit Sub ElseIf ClassID > 0 Then Set tClass = Conn.Execute("select ClassName,ParentID,ParentPath from PE_Class where ClassID=" & ClassID) If tClass.BOF And tClass.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到指定的栏目
  • " Set tClass = Nothing Exit Sub Else ClassName = tClass(0) ParentID = tClass(1) ParentPath = tClass(2) End If Set tClass = Nothing If ParentID > 0 Then Dim sqlPath, rsPath sqlPath = "select ClassID,ClassName from PE_Class where ClassID in (" & ParentPath & ") order by Depth" Set rsPath = Conn.Execute(sqlPath) Do While Not rsPath.EOF Response.Write rsPath(1) & " >> " rsPath.MoveNext Loop rsPath.Close Set rsPath = Nothing End If Response.Write ClassName & " >> " End If Select Case Trim(Request("IncludePic")) Case 1 Response.Write "" & ArticlePro1 & "" Case 2 Response.Write "" & ArticlePro2 & "" Case 3 Response.Write "" & ArticlePro3 & "" Case 4 Response.Write "" & ArticlePro4 & "" End Select Response.Write PE_HTMLEncode(Request("Title")) Response.Write "
    " If LCase(Request("OnTop")) = "yes" Then Response.Write "顶 " Else Response.Write "   " End If If LCase(Request("Hot")) = "yes" Then Response.Write "热 " Else Response.Write "   " End If If LCase(Request("Elite")) = "yes" Then Response.Write "荐" Else Response.Write "  " End If Response.Write "
    " If Trim(Request("TitleIntact")) <> "" Then Response.Write "" & PE_HTMLEncode(Request("TitleIntact")) & "" Else Response.Write "" & PE_HTMLEncode(Request("Title")) & "" End If If Trim(Request("Subheading")) <> "" Then Response.Write "
    " & PE_HTMLEncode(Request("Subheading")) End If Response.Write "
    作者:" & PE_HTMLEncode(Request("Author")) & "    转贴自:" & PE_HTMLEncode(Request("CopyFrom")) & "    点击数:0    " & ChannelShortName & "录入:" & UserName & "

    " & Request("Content") & "

    " Response.Write "

    【关闭窗口】

    " End Sub '****************************************************************************************** '以下为批量设置属性使用的函数,各模块实现过程类似,修改时注意同时修改各模块内容。 '****************************************************************************************** Sub Batch() If AdminPurview = 2 And AdminPurview_Channel > 2 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Response.Write "" & vbCrLf ArticleID = Replace(ArticleID, " ", "") Response.Write "
    " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    批量修改" & ChannelShortName & "属性
    " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " & ChannelShortName & "范围
    " Response.Write " 指定" & ChannelShortName & "ID:
    " Response.Write "
    " Response.Write " 指定栏目的" & ChannelShortName & ":
    " Response.Write "
    " Response.Write "
    " Response.Write "
    " Response.Write "

    " Response.Write "" & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    属性设置收费选项自定义选项 
    " & vbCrLf Response.Write "" Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " Response.Write " " Response.Write " " & vbCrLf Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Call ShowBatchCommon Response.Write " " & vbCrLf Call ShowTabs_Purview_Batch("阅读") Call ShowTabs_MyField_Batch Response.Write "
    " & ChannelShortName & "标题: 列表显示时在标题旁显示“评论”链接" Response.Write "
    " & ChannelShortName & "作者: " & GetAuthorList("Admin", ChannelID, UserName) Response.Write "
    " & ChannelShortName & "来源: " & GetCopyFromList("Admin", ChannelID) Response.Write "
    内容分页方式:" Response.Write " 自动分页时的每页大约字符数(包含HTML标记且必须大于100):" Response.Write "
    " Response.Write "
    " Response.Write "
    说明:
    1、若要批量修改某个属性的值,请先选中其左侧的复选框,然后再设定属性值。
    2、这里显示的属性值都是系统默认值,与所选" & ChannelShortName & "的已有属性无关
    " Response.Write "
    " Response.Write "

    " Response.Write " " Response.Write " " Response.Write "   " Response.Write " " Response.Write "

    " Response.Write "
    " Response.Write "
    " End Sub Sub DoBatch() If AdminPurview = 2 And AdminPurview_Channel > 2 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Dim rs, sql, BatchType, BatchArticleID, BatchClassID, rsField Dim Author, ShowCommentLink, CopyFrom, PaginationType, MaxCharPerPage Dim Keyword, OnTop, Elite, Stars, Hits, UpdateTime, SkinID, TemplateID Dim InfoPurview, arrGroupID, InfoPoint, ChargeType, PitchTime, ReadTimes, DividePercent BatchType = PE_CLng(Trim(Request("BatchType"))) BatchArticleID = Trim(Request.Form("BatchArticleID")) BatchClassID = FilterArrNull(Trim(Request.Form("BatchClassID")), ",") Author = Trim(Request.Form("Author")) ShowCommentLink = Trim(Request.Form("ShowCommentLink")) CopyFrom = Trim(Request.Form("CopyFrom")) PaginationType = PE_CLng(Trim(Request.Form("PaginationType"))) MaxCharPerPage = PE_CLng(Trim(Request.Form("MaxCharPerPage"))) Keyword = Trim(Request.Form("Keyword")) OnTop = Trim(Request.Form("OnTop")) Elite = Trim(Request.Form("Elite")) Stars = PE_CLng(Trim(Request.Form("Stars"))) Hits = PE_CLng(Trim(Request.Form("Hits"))) UpdateTime = PE_CDate(Trim(Request.Form("UpdateTime"))) SkinID = PE_CLng(Trim(Request.Form("SkinID"))) TemplateID = PE_CLng(Trim(Request.Form("TemplateID"))) InfoPurview = PE_CLng(Trim(Request.Form("InfoPurview"))) arrGroupID = ReplaceBadChar(Trim(Request.Form("GroupID"))) InfoPoint = PE_CLng(Trim(Request.Form("InfoPoint"))) ChargeType = PE_CLng(Trim(Request.Form("ChargeType"))) PitchTime = PE_CLng(Trim(Request.Form("PitchTime"))) ReadTimes = PE_CLng(Trim(Request.Form("ReadTimes"))) DividePercent = PE_CLng(Trim(Request.Form("DividePercent"))) If BatchType = 1 Then If IsValidID(BatchArticleID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量修改的" & ChannelShortName & "的ID
  • " End If Else If IsValidID(BatchClassID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量修改的" & ChannelShortName & "的栏目
  • " End If End If If Trim(Request("ModifyKeyword")) = "Yes" And Keyword = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请输入" & ChannelShortName & "关键字
  • " End If If Trim(Request("ModifyPaginationType")) = "Yes" And PaginationType = 1 And MaxCharPerPage = 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定自动分页时的每页大约字符数,必须大于0
  • " End If If FoundErr = True Then Exit Sub End If If Author = "" Then Author = XmlText("BaseText", "DefAuthor", "佚名") If CopyFrom = "" Then CopyFrom = XmlText("BaseText", "DefCopyFrom", "本站原创") If ShowCommentLink = "Yes" Then ShowCommentLink = True Else ShowCommentLink = False End If Keyword = "|" & ReplaceBadChar(Keyword) & "|" If OnTop = "Yes" Then OnTop = True Else OnTop = False End If If Elite = "Yes" Then Elite = True Else Elite = False End If Set rs = Server.CreateObject("adodb.recordset") If BatchType = 1 Then sql = "select * from PE_Article where ChannelID=" & ChannelID & " and ArticleID in (" & BatchArticleID & ")" Else sql = "select * from PE_Article where ChannelID=" & ChannelID & " and ClassID in (" & BatchClassID & ")" End If rs.Open sql, Conn, 1, 3 Set rsField = Conn.Execute("select * from PE_Field where ChannelID=-1 or ChannelID=" & ChannelID & "") Do While Not rs.EOF If Trim(Request("ModifyAuthor")) = "Yes" Then rs("Author") = Author If Trim(Request("ModifyCopyFrom")) = "Yes" Then rs("CopyFrom") = CopyFrom If Trim(Request("ModifyCommentLink")) = "Yes" Then rs("ShowCommentLink") = ShowCommentLink If Trim(Request("ModifyPaginationType")) = "Yes" Then rs("PaginationType") = PaginationType rs("MaxCharPerPage") = MaxCharPerPage End If If Trim(Request("ModifyKeyword")) = "Yes" Then rs("Keyword") = Keyword If Trim(Request("ModifyOnTop")) = "Yes" Then rs("OnTop") = OnTop If Trim(Request("ModifyElite")) = "Yes" Then rs("Elite") = Elite If Trim(Request("ModifyStars")) = "Yes" Then rs("Stars") = Stars If Trim(Request("ModifyHits")) = "Yes" Then rs("Hits") = Hits If Trim(Request("ModifyUpdateTime")) = "Yes" Then rs("UpdateTime") = DateAdd("d", DateDiff("d", rs("UpdateTime"), UpdateTime), rs("UpdateTime")) If Trim(Request("ModifySkin")) = "Yes" Then rs("SkinID") = SkinID If Trim(Request("ModifyTemplate")) = "Yes" Then rs("TemplateID") = TemplateID If Trim(Request("ModifyInfoPurview")) = "Yes" Then rs("InfoPurview") = InfoPurview rs("arrGroupID") = arrGroupID End If If Trim(Request("ModifyInfoPoint")) = "Yes" Then rs("InfoPoint") = InfoPoint If Trim(Request("ModifyChargeType")) = "Yes" Then rs("ChargeType") = ChargeType rs("PitchTime") = PitchTime rs("ReadTimes") = ReadTimes End If If Trim(Request("ModifyDividePercent")) = "Yes" Then rs("DividePercent") = DividePercent If Not (rsField.BOF And rsField.EOF) Then rsField.MoveFirst Do While Not rsField.EOF If Trim(Request("Modify" & Trim(rsField("FieldName")))) = "Yes" Then If Trim(Request(rsField("FieldName"))) <> "" Or rsField("EnableNull") = True Then rs(Trim(rsField("FieldName"))) = Trim(Request(rsField("FieldName"))) End If End If rsField.MoveNext Loop End If rs("CreateTime") = rs("UpdateTime") rs.Update rs.MoveNext Loop rs.Close Set rs = Nothing rsField.Close Set rsField = Nothing Call ClearSiteCache(0) Call WriteSuccessMsg("批量修改" & ChannelShortName & "属性成功!", "Admin_Article.asp?ChannelID=" & ChannelID) Call CreateAllJS End Sub '================================================= '过程名:BatchReplace '作 用:批量替换 '================================================= Sub BatchReplace() If AdminPurview = 2 And AdminPurview_Channel > 2 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Response.Write "" & vbCrLf ArticleID = Replace(ArticleID, " ", "") Response.Write "
    " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    批量替换" & ChannelShortName & "内容
    " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write " " Response.Write "
    " & ChannelShortName & "范围
    " Response.Write " 指定" & ChannelShortName & "ID:
    " Response.Write "
    " Response.Write " 指定栏目的" & ChannelShortName & ":
    " Response.Write "
    " Response.Write "
    " Response.Write "
    " Response.Write "
    " & vbCrLf Response.Write " " Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    替换内容: " & vbCrLf Response.Write " " & ChannelShortName & "标题  " Response.Write " " & ChannelShortName & "内容
    替换类型: " & vbCrLf Response.Write " 简单替换  " Response.Write " 高级替换
    要替换的字符: 
    要替换后的字符: 
    是否标题加前缀: " & vbCrLf Response.Write " 是  " Response.Write " 否
    是否内容加前缀: " & vbCrLf Response.Write " 是  " Response.Write " 否
    " & vbCrLf Response.Write " " & vbCrLf Response.Write " " & vbCrLf Response.Write "   " & vbCrLf Response.Write " " & vbCrLf Response.Write "
    " & vbCrLf Response.Write "
    " & vbCrLf Response.Write "
    " & vbCrLf End Sub '================================================= '过程名:DoBatchReplace '作 用:批量替换处理 '================================================= Sub DoBatchReplace() Dim rs, sql, BatchType, BatchArticleID, BatchClassID, ChannelID Dim ItemBatchType, ItemReplace, ItemReplaceStart, ItemReplaceEnd, ItemReplaceResult Dim ItemBatchTitle, ItemBatchContent, IsTitlePrefix, ItemTitlePrefix, IsContentPrefix, ItemContentPrefix Dim FoundErr, ErrMsg BatchType = PE_CLng(Trim(Request("BatchType"))) BatchArticleID = Trim(Request.Form("BatchArticleID")) BatchClassID = FilterArrNull(Trim(Request.Form("BatchClassID")), ",") ChannelID = PE_CLng(Trim(Request.Form("ChannelID"))) ItemBatchType = PE_CLng(Trim(Request.Form("ItemBatchType"))) ItemBatchTitle = Trim(Request.Form("ItemBatchTitle")) ItemBatchContent = Trim(Request.Form("ItemBatchContent")) ItemReplace = Trim(Request.Form("ItemReplace")) ItemReplaceStart = Trim(Request.Form("ItemReplaceStart")) ItemReplaceEnd = Trim(Request.Form("ItemReplaceEnd")) ItemReplaceResult = Trim(Request.Form("ItemReplaceResult")) IsTitlePrefix = PE_CLng(Trim(Request.Form("IsTitlePrefix"))) ItemTitlePrefix = Trim(Request.Form("ItemTitlePrefix")) IsContentPrefix = PE_CLng(Trim(Request.Form("IsContentPrefix"))) ItemContentPrefix = Trim(Request.Form("ItemContentPrefix")) If IsTitlePrefix = 0 Then ItemTitlePrefix = "" Else If Len(ItemTitlePrefix) > 100 Then FoundErr = True ErrMsg = ErrMsg & "
  • 标题前缀,不能过长
  • " End If End If If IsContentPrefix = 0 Then ItemContentPrefix = "" End If If BatchType = 1 Then If IsValidID(BatchArticleID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量修改的" & ChannelShortName & "的ID
  • " End If Else If IsValidID(BatchClassID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量修改的" & ChannelShortName & "的栏目
  • " End If End If If ItemBatchTitle = "yes" Then ItemBatchTitle = True End If If ItemBatchContent = "yes" Then ItemBatchContent = True End If If ItemBatchTitle = False And ItemBatchContent = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 至少要选择一个要替换的类型" & ChannelShortName & "标题或" & ChannelShortName & "内容
  • " End If If ItemBatchType = 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 没有选择" & ChannelShortName & "替换字符类型
  • " End If If FoundErr = True Then Call WriteErrMsg(ErrMsg, ComeUrl) Exit Sub End If If ItemBatchType = 1 Then If ItemReplace = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 输入要替换的代码不能为空
  • " End If ElseIf ItemBatchType = 2 Then If ItemReplaceStart = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 输入要替换的开始代码不能为空
  • " End If If ItemReplaceEnd = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 输入要替换后的结束代码不能为空
  • " End If Else FoundErr = True ErrMsg = ErrMsg & "
  • 选择" & ChannelShortName & "替换字符类型不对
  • " End If If ItemReplaceResult = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 输入要替换后的代码不能为空
  • " End If If FoundErr = True Then Call WriteErrMsg(ErrMsg, ComeUrl) Exit Sub End If If ItemBatchTitle = True Then If PE_CLng(Conn.Execute("Select count(*) From PE_Article Where Title='" & ReplaceBadChar(ItemReplaceResult) & "'")(0)) > 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 要替换的标题与数据库已有的标题重复
  • " End If If FoundErr = True Then Call WriteErrMsg(ErrMsg, ComeUrl) Exit Sub End If End If Response.Write "
  • 正在替换数据请稍后..
  •   
    " Set rs = Server.CreateObject("ADODB.Recordset") If BatchType = 1 Then sql = "select * from PE_Article where ChannelID=" & ChannelID & " and ArticleID in (" & BatchArticleID & ")" Else sql = "select * from PE_Article where ChannelID=" & ChannelID & " and ClassID in (" & BatchClassID & ")" End If rs.Open sql, Conn, 1, 3 If rs.BOF And rs.EOF Then Response.Write "没有可替换的标题或正文!" Else Do While Not rs.EOF If ItemBatchType = 1 Then If ItemBatchTitle = True Then If InStr(rs("title"), ItemReplace) <> 0 Then rs("title") = ItemTitlePrefix & Replace(rs("title"), ItemReplace, ItemReplaceResult) Response.Write "
      " & ChannelShortName & "ID:" & rs("ArticleID") & "  " & rs("title") & "..标题替换成功!" End If End If If ItemBatchContent = True Then If InStr(rs("Content"), ItemReplace) <> 0 Then rs("Content") = ItemContentPrefix & Replace(rs("Content"), ItemReplace, ItemReplaceResult) Response.Write "
      " & ChannelShortName & "ID:" & rs("ArticleID") & "  " & rs("title") & "..内容替换成功!" End If End If ElseIf ItemBatchType = 2 Then If ItemBatchTitle = True Then rs("title") = ItemTitlePrefix & BatchReplaceString(rs("title"), ItemReplaceStart, ItemReplaceEnd, ItemReplaceResult, "标题", rs("ArticleID"), rs("title")) End If If ItemBatchContent = True Then rs("Content") = ItemContentPrefix & BatchReplaceString(rs("Content"), ItemReplaceStart, ItemReplaceEnd, ItemReplaceResult, "内容", rs("ArticleID"), rs("title")) End If End If rs("CreateTime") = rs("UpdateTime") rs.Update rs.MoveNext Loop End If rs.Close Set rs = Nothing Call ClearSiteCache(0) Response.Write "
      " & ChannelShortName & "替换操作完成" Response.Write "
      返回" & ChannelShortName & "管理
    " End Sub '************************************************** '函数名:BatchReplaceString '作 用:批量替换处理函数 '参 数:ItemContent ----数据 '参 数:ItemReplaceStart ----获得要替换的开头代码 '参 数:ItemReplaceEnd ----获得要替换的结束代码 '参 数:ItemReplaceResult ----要替换的代码 '参 数:ItemName ----类型名称 '返回值:True ----已创建 '************************************************** Function BatchReplaceString(ItemContent, ItemReplaceStart, ItemReplaceEnd, ItemReplaceResult, ItemName, ArticleID, Title) If InStr(ItemContent, ItemReplaceStart) = 0 Or InStr(ItemContent, ItemReplaceEnd) = 0 Then BatchReplaceString = ItemContent Exit Function End If If GetBody(ItemContent, ItemReplaceStart, ItemReplaceEnd, True, True) = "" Then BatchReplaceString = ItemContent Exit Function End If BatchReplaceString = Replace(ItemContent, GetBody(ItemContent, ItemReplaceStart, ItemReplaceEnd, True, True), ItemReplaceResult) Response.Write "
      " & ChannelShortName & "ID:" & ArticleID & "  " & Title & ".." & ItemName & "替换成功!" End Function '****************************************************************************************** '以下为设置固顶、推荐等属性使用的函数,各模块实现过程类似,修改时注意同时修改各模块内容。 '****************************************************************************************** Sub SetProperty() If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If If Action = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 参数不足!
  • " Exit Sub End If Dim sqlProperty, rsProperty, arrUser arrUser = "" If InStr(ArticleID, ",") > 0 Then sqlProperty = "select * from PE_Article where ArticleID in (" & ArticleID & ")" Else sqlProperty = "select * from PE_Article where ArticleID=" & ArticleID End If Set rsProperty = Server.CreateObject("ADODB.Recordset") rsProperty.Open sqlProperty, Conn, 1, 3 Do While Not rsProperty.EOF If CheckClassPurview(Action, rsProperty("ClassID")) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 对 " & rsProperty("Title") & " 没有操作权限!
  • " Else If FoundInArr(arrUser, rsProperty("Inputer"), ",") = False Then If arrUser = "" Then arrUser = rsProperty("Inputer") Else arrUser = arrUser & "," & rsProperty("Inputer") End If End If Select Case Action Case "SetOnTop" rsProperty("OnTop") = True Case "CancelOnTop" rsProperty("OnTop") = False Case "SetElite" rsProperty("Elite") = True Case "CancelElite" rsProperty("Elite") = False Case "SetPassed" If rsProperty("Status") < MyStatus And MyStatus = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp+" & rsProperty("PresentExp") & " where UserName='" & rsProperty("Inputer") & "'") End If rsProperty("Status") = MyStatus If MyStatus < 3 Or CheckLevel = 1 Then rsProperty("Editor") = AdminName End If Case "CancelPassed", "Reject" If rsProperty("Status") = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp-" & rsProperty("PresentExp") & " where UserName='" & rsProperty("Inputer") & "'") End If If Action = "CancelPassed" Then rsProperty("Status") = 0 Else rsProperty("Status") = -2 End If End Select rsProperty("CreateTime") = rsProperty("UpdateTime") rsProperty.Update End If rsProperty.MoveNext Loop rsProperty.Close Set rsProperty = Nothing Call UpdateChannelData(ChannelID) Call UpdateUserData(0, arrUser, 0, 0) Call ClearSiteCache(0) Call WriteSuccessMsg("操作成功!", "Admin_Article.asp?ChannelID=" & ChannelID) Call CreateAllJS End Sub '****************************************************************************************** '以下为移动至栏目、专题等操作使用的函数,各模块实现过程类似,修改时注意同时修改各模块内容。 '****************************************************************************************** Sub DoMoveToClass() If AdminPurview = 2 And AdminPurview_Channel > 2 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Dim ArticleType, BatchArticleID, BatchClassID Dim tChannelID, tClassID, tChannelDir, tUploadDir ArticleType = PE_CLng(Trim(Request("ArticleType"))) BatchArticleID = Trim(Request.Form("BatchArticleID")) BatchClassID = FilterArrNull(Trim(Request.Form("BatchClassID")), ",") tChannelID = Trim(Request("tChannelID")) tClassID = Trim(Request("tClassID")) If ArticleType = 1 Then If IsValidID(BatchArticleID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量移动的" & ChannelShortName & "的ID
  • " End If Else If IsValidID(BatchClassID) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定要批量移动的" & ChannelShortName & "的栏目
  • " End If End If If tChannelID = "" Then tChannelID = ChannelID Else tChannelID = PE_CLng(tChannelID) If tChannelID <> ChannelID Then If AdminPurview > 1 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Else Dim rsChannel Set rsChannel = Conn.Execute("select ChannelDir,UploadDir from PE_Channel where ChannelID=" & tChannelID & "") If rsChannel.BOF And rsChannel.EOF Then FoundErr = True ErrMsg = ErrMsg & "
  • 找不到目标频道!
  • " Else tChannelDir = rsChannel("ChannelDir") tUploadDir = rsChannel("UploadDir") End If Set rsChannel = Nothing End If End If End If If tClassID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请指定目标栏目!不能指定为外部栏目。
  • " Else tClassID = PE_CLng(tClassID) If tClassID = 0 Then FoundErr = True ErrMsg = ErrMsg & "
  • 目标栏目不允许添加" & ChannelShortName & "
  • " End If End If If FoundErr = True Then Exit Sub Dim rsBatchMove, sqlBatchMove, ArticlePath sqlBatchMove = "select A.ArticleID,A.UploadFiles,A.UpdateTime,A.PaginationType,C.ParentDir,C.ClassDir from PE_Article A left join PE_Class C on A.ClassID=C.ClassID" If ArticleType = 1 Then sqlBatchMove = sqlBatchMove & " where A.ChannelID=" & ChannelID & " and A.ArticleID in (" & BatchArticleID & ")" Else sqlBatchMove = sqlBatchMove & " where A.ChannelID=" & ChannelID & " and A.ClassID in (" & BatchClassID & ")" End If BatchArticleID = "" Set rsBatchMove = Conn.Execute(sqlBatchMove) Do While Not rsBatchMove.EOF ArticlePath = HtmlDir & GetItemPath(StructureType, rsBatchMove("ParentDir"), rsBatchMove("ClassDir"), rsBatchMove("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsBatchMove("UpdateTime"), rsBatchMove("ArticleID")) If fso.FileExists(Server.MapPath(ArticlePath & FileExt_Item)) Then DelSerialFiles Server.MapPath(ArticlePath & FileExt_Item) End If If rsBatchMove("PaginationType") > 0 Then DelSerialFiles Server.MapPath(ArticlePath) & "_*" & FileExt_Item End If If tChannelID <> ChannelID Then Call MoveUpFiles(rsBatchMove("UploadFiles") & "", tChannelDir & "/" & tUploadDir) '移动上传文件 End If If BatchArticleID = "" Then BatchArticleID = rsBatchMove("ArticleID") Else BatchArticleID = BatchArticleID & "," & rsBatchMove("ArticleID") End If rsBatchMove.MoveNext Loop rsBatchMove.Close Set rsBatchMove = Nothing If BatchArticleID <> "" Then Conn.Execute ("update PE_Article set ChannelID=" & tChannelID & ",ClassID=" & tClassID & ",TemplateID=0,CreateTime=UpdateTime where ArticleID in (" & BatchArticleID & ")") End If Call WriteSuccessMsg("成功将选定的" & ChannelShortName & "移动到目标频道的目标栏目中!", "Admin_Article.asp?ChannelID=" & ChannelID & "") Call ClearSiteCache(0) End Sub Sub MoveUpFiles(strFiles, strTargetDir) On Error Resume Next Dim strTrueFile, arrFiles, strTrueDir, i If IsNull(strFiles) Or strFiles = "" Or strTargetDir = "" Then Exit Sub If Not fso.FolderExists(Server.MapPath(InstallDir & strTargetDir)) Then fso.CreateFolder Server.MapPath(InstallDir & strTargetDir) arrFiles = Split(strFiles, "|") For i = 0 To UBound(arrFiles) strTrueDir = Server.MapPath(InstallDir & strTargetDir & "/" & Left(arrFiles(i), InStr(arrFiles(i), "/"))) If Not fso.FolderExists(strTrueDir) Then fso.CreateFolder strTrueDir strTrueFile = Server.MapPath(InstallDir & ChannelDir & "/" & UploadDir & "/" & arrFiles(i)) If fso.FileExists(strTrueFile) Then fso.MoveFile strTrueFile, Server.MapPath(InstallDir & strTargetDir & "/" & arrFiles(i)) End If Next End Sub '****************************************************************************************** '以下为删除、清空、还原等操作使用的函数,各模块实现过程类似,修改时注意同时修改各模块内容。 '****************************************************************************************** Sub Del() If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If Dim sqlDel, rsDel, ArticlePath, arrUser arrUser = "" sqlDel = "select A.ArticleID,A.Title,A.UpdateTime,A.CreateTime,A.Inputer,A.Status,A.Deleted,A.PaginationType,A.PresentExp,A.ReceiveUser,A.ClassID,C.ParentDir,C.ClassDir from PE_Article A left join PE_Class C on A.ClassID=C.ClassID" If InStr(ArticleID, ",") > 0 Then sqlDel = sqlDel & " where A.ArticleID in (" & ArticleID & ") order by A.ArticleID" Else sqlDel = sqlDel & " where A.ArticleID=" & ArticleID End If Set rsDel = Server.CreateObject("ADODB.Recordset") rsDel.Open sqlDel, Conn, 1, 3 Do While Not rsDel.EOF PurviewChecked = False ClassID = rsDel("ClassID") If AdminPurview = 1 Or AdminPurview_Channel <= 2 Or (rsDel("Inputer") = UserName And rsDel("Status") = 0) Then PurviewChecked = True Else PurviewChecked = CheckClassPurview(Action, ClassID) End If If PurviewChecked = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 删除 " & rsDel("Title") & " 失败!原因:没有操作权限!
  • " Else If FoundInArr(arrUser, rsDel("Inputer"), ",") = True Then If arrUser = "" Then arrUser = rsDel("Inputer") Else arrUser = arrUser & "," & rsDel("Inputer") End If End If ArticlePath = HtmlDir & GetItemPath(StructureType, rsDel("ParentDir"), rsDel("ClassDir"), rsDel("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsDel("UpdateTime"), rsDel("ArticleID")) If fso.FileExists(Server.MapPath(ArticlePath & FileExt_Item)) Then DelSerialFiles Server.MapPath(ArticlePath & FileExt_Item) End If If rsDel("PaginationType") > 0 Then DelSerialFiles Server.MapPath(ArticlePath) & "_*" & FileExt_Item End If If rsDel("Status") = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp-" & rsDel("PresentExp") & " where UserName='" & rsDel("Inputer") & "'") End If rsDel("Deleted") = True rsDel("CreateTime") = rsDel("UpdateTime") Call Del_User_UnsignedItems(rsDel("ArticleID"), rsDel("ReceiveUser")) rsDel.Update End If rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing Call UpdateChannelData(ChannelID) Call UpdateUserData(0, arrUser, 0, 0) Call ClearSiteCache(0) Call WriteSuccessMsg("操作成功!", "Admin_Article.asp?ChannelID=" & ChannelID) Call CreateAllJS End Sub Sub DelFile() If AdminPurview = 2 And AdminPurview_Channel > 2 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If Dim sqlDel, rsDel, ArticlePath sqlDel = "select A.ArticleID,A.UpdateTime,A.PaginationType,C.ParentDir,C.ClassDir from PE_Article A left join PE_Class C on A.ClassID=C.ClassID where A.ArticleID in (" & ArticleID & ") order by A.ArticleID" Set rsDel = Conn.Execute(sqlDel) Do While Not rsDel.EOF ArticlePath = HtmlDir & GetItemPath(StructureType, rsDel("ParentDir"), rsDel("ClassDir"), rsDel("UpdateTime")) & GetItemFileName(FileNameType, ChannelDir, rsDel("UpdateTime"), rsDel("ArticleID")) If fso.FileExists(Server.MapPath(ArticlePath & FileExt_Item)) Then DelSerialFiles Server.MapPath(ArticlePath & FileExt_Item) End If If rsDel("PaginationType") > 0 Then DelSerialFiles Server.MapPath(ArticlePath) & "_*" & FileExt_Item End If rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing Conn.Execute ("update PE_Article set CreateTime=UpdateTime where ArticleID in (" & ArticleID & ")") Call CloseConn Response.Redirect ComeUrl End Sub Sub ConfirmDel() If AdminPurview = 2 And AdminPurview_Channel > 1 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If Dim sqlDel, rsDel sqlDel = "select UploadFiles,VoteID from PE_Article where ArticleID in (" & ArticleID & ")" Set rsDel = Conn.Execute(sqlDel) Do While Not rsDel.EOF Call DelUploadFiles(rsDel("UploadFiles")) Conn.Execute ("delete from PE_Vote where ID=" & rsDel("VoteID") & "") rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing Conn.Execute ("delete from PE_Article where ArticleID in (" & ArticleID & ")") Conn.Execute ("delete from PE_Comment where ModuleType=" & ModuleType & " and InfoID in (" & ArticleID & ")") Conn.Execute ("delete from PE_ConsumeLog where ModuleType=" & ModuleType & " and InfoID in (" & ArticleID & ")") Call CloseConn Response.Redirect ComeUrl End Sub Sub ClearRecyclebin() If AdminPurview = 2 And AdminPurview_Channel > 1 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Dim sqlDel, rsDel ArticleID = "" sqlDel = "select ArticleID,UploadFiles,VoteID from PE_Article where Deleted=" & PE_True & " and ChannelID=" & ChannelID Set rsDel = Conn.Execute(sqlDel) Do While Not rsDel.EOF If ArticleID = "" Then ArticleID = rsDel(0) Else ArticleID = ArticleID & "," & rsDel(0) End If Call DelUploadFiles(rsDel("UploadFiles")) Conn.Execute ("delete from PE_Vote where ID=" & rsDel("VoteID") & "") rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing If ArticleID <> "" Then Conn.Execute ("delete from PE_Article where Deleted=" & PE_True & " and ChannelID=" & ChannelID & "") Conn.Execute ("delete from PE_Comment where ModuleType=" & ModuleType & " and InfoID in (" & ArticleID & ")") Conn.Execute ("delete from PE_ConsumeLog where ModuleType=" & ModuleType & " and InfoID in (" & ArticleID & ")") End If Call CloseConn Response.Redirect ComeUrl End Sub Sub Restore() If AdminPurview = 2 And AdminPurview_Channel > 1 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If If ArticleID = "" Then FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If Dim sqlDel, rsDel, arrUser arrUser = "" If InStr(ArticleID, ",") > 0 Then sqlDel = "select * from PE_Article where ArticleID in (" & ArticleID & ")" Else sqlDel = "select * from PE_Article where ArticleID=" & ArticleID End If Set rsDel = Server.CreateObject("ADODB.Recordset") rsDel.Open sqlDel, Conn, 1, 3 Do While Not rsDel.EOF If FoundInArr(arrUser, rsDel("Inputer"), ",") = True Then If arrUser = "" Then arrUser = rsDel("Inputer") Else arrUser = arrUser & "," & rsDel("Inputer") End If End If If rsDel("Status") = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp+" & rsDel("PresentExp") & " where UserName='" & rsDel("Inputer") & "'") End If rsDel("Deleted") = False rsDel.Update rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing Call UpdateChannelData(ChannelID) Call UpdateUserData(0, arrUser, 0, 0) Call ClearSiteCache(0) Call WriteSuccessMsg("操作成功!", "Admin_Article.asp?ChannelID=" & ChannelID) Call CreateAllJS End Sub Sub RestoreAll() If AdminPurview = 2 And AdminPurview_Channel > 1 Then FoundErr = True ErrMsg = ErrMsg & "
  • 对不起,你的权限不够!
  • " Exit Sub End If Dim sqlDel, rsDel, arrUser arrUser = "" sqlDel = "select * from PE_Article where Deleted=" & PE_True & " and ChannelID=" & ChannelID Set rsDel = Server.CreateObject("ADODB.Recordset") rsDel.Open sqlDel, Conn, 1, 3 Do While Not rsDel.EOF If FoundInArr(arrUser, rsDel("Inputer"), ",") = True Then If arrUser = "" Then arrUser = rsDel("Inputer") Else arrUser = arrUser & "," & rsDel("Inputer") End If End If If rsDel("Status") = 3 Then Conn.Execute ("update PE_User set UserExp=UserExp+" & rsDel("PresentExp") & " where UserName='" & rsDel("Inputer") & "'") End If rsDel("Deleted") = False rsDel.Update rsDel.MoveNext Loop rsDel.Close Set rsDel = Nothing Call UpdateChannelData(ChannelID) Call UpdateUserData(0, arrUser, 0, 0) Call ClearSiteCache(0) Call WriteSuccessMsg("操作成功!", "Admin_Article.asp?ChannelID=" & ChannelID) Call CreateAllJS End Sub Sub DelUploadFiles(strUploadFiles) On Error Resume Next If Trim(strUploadFiles) = "" Or ObjInstalled_FSO <> True Then Exit Sub Dim arrUploadFiles, strFileName, i arrUploadFiles = Split(strUploadFiles, "|") For i = 0 To UBound(arrUploadFiles) If Trim(arrUploadFiles(i)) <> "" Then strFileName = InstallDir & ChannelDir & "/" & UploadDir & "/" & arrUploadFiles(i) If fso.FileExists(Server.MapPath(strFileName)) Then fso.DeleteFile (Server.MapPath(strFileName)) End If End If Next End Sub Sub Del_User_UnsignedItems(ByVal ArticleID, ByVal strUser) If IsNull(strUser) Or strUser = "" Then Exit Sub strUser = Replace(strUser, "|", ",") strUser = Replace(strUser, ",", "','") Dim arrID arrID = Split(ArticleID, ",") Dim sqlUser, rsUser, i, tmpUnsignedItems, tmpArticleID Set rsUser = Server.CreateObject("adodb.recordset") sqlUser = "select UserID,UserName,UnsignedItems from PE_User where UserName in ('" & strUser & "')" rsUser.Open sqlUser, Conn, 1, 3 Do While Not rsUser.EOF For i = 0 To UBound(arrID) If FoundInArr(rsUser("UnsignedItems"), CStr(arrID(i)), ",") = True Then tmpUnsignedItems = "," & rsUser("UnsignedItems") & "," tmpArticleID = "," & arrID(i) & "," tmpUnsignedItems = Replace(tmpUnsignedItems, tmpArticleID, ",") If tmpUnsignedItems = "," Then rsUser("UnsignedItems") = "" Else rsUser("UnsignedItems") = Mid(tmpUnsignedItems, 2, Len(tmpUnsignedItems) - 2) End If rsUser.Update End If Next rsUser.MoveNext Loop rsUser.Close Set rsUser = Nothing End Sub Sub Add_User_UnsignedItems(ByVal ArticleID, ByVal ReceiveUser) If IsNull(ReceiveUser) Or ReceiveUser = "" Then Exit Sub ReceiveUser = Replace(ReceiveUser, "|", ",") ReceiveUser = Replace(ReceiveUser, ",", "','") Dim sqlUser, rsUser, i Set rsUser = Server.CreateObject("adodb.recordset") sqlUser = "select UserID,UserName,UnsignedItems from PE_User where UserName in ('" & ReceiveUser & "')" rsUser.Open sqlUser, Conn, 1, 3 Do While Not rsUser.EOF If rsUser("UnsignedItems") = "" Or IsNull(rsUser("UnsignedItems")) Then rsUser("UnsignedItems") = ArticleID Else If FoundInArr(rsUser("UnsignedItems"), CStr(ArticleID), ",") = False Then rsUser("UnsignedItems") = rsUser("UnsignedItems") & "," & ArticleID End If End If rsUser.Update rsUser.MoveNext Loop rsUser.Close Set rsUser = Nothing End Sub Function UnsignedItemsState(ArticleID) Dim rsState, sqlState, strState, arrUser, i Dim NotReceiveUser sqlState = "select top 1 ReceiveUser,Received from PE_Article where ArticleID=" & ArticleID Set rsState = Conn.Execute(sqlState) If Not (rsState.BOF And rsState.EOF) Then If rsState("Received") = "" Then NotReceiveUser = rsState("ReceiveUser") Else NotReceiveUser = "" arrUser = Split(rsState("ReceiveUser"), ",") For i = 0 To UBound(arrUser) If FoundInArr(rsState("Received"), arrUser(i), "|") = False Then If NotReceiveUser = "" Then NotReceiveUser = arrUser(i) Else NotReceiveUser = NotReceiveUser & "," & arrUser(i) End If End If Next End If If NotReceiveUser <> "" Then strState = strState & "[签收中]" Else strState = strState & "[已签收]" End If End If rsState.Close Set rsState = Nothing UnsignedItemsState = strState End Function '***************************************** '函 数 名:getWordNumber() '参 数:str 字符串 '返 回 值:文章字数 '作 用:计算文章的字数 可以计算纯中文,纯英文,中英混排,误差范围在20字以内 '作 者:壮志,刘永涛 '创建日期:2005-09-07 '***************************************** Function getWordNumber(ByVal str) str = nohtml(PE_HtmlDecode(str)) regEx.Pattern = "[a-z\-]+|\.+" str = regEx.Replace(str, "动") str = Replace(str, " ", "") getWordNumber = Len(str) End Function Sub ExportExcel() Dim strSql, SelectType, rsArticleOut, PayStatus, searchDate SelectType = Trim(Request("SelectType")) '检查输入的ID,和 日期 strSql = "Select * From PE_Article Where Copymoney>0 And Status=3" PayStatus = Trim(Request("PayStatus")) If PayStatus = "False" Then PayStatus = PE_False searchDate = "UpDateTime" Else PayStatus = PE_True searchDate = "PayDate" End If Select Case SelectType Case "ID" Dim BeginID, EndID BeginID = PE_CLng(Trim(Request("BeginID"))) EndID = PE_CLng(Trim(Request("EndID"))) If BeginID <> 0 And EndID <> 0 Then strSql = strSql & "And Ispayed=" & PayStatus & " and (ArticleID Between " & BeginID & " and " & EndID & ")" End If Case "Date" Dim BeginDate, EndDate BeginDate = Trim(Request("BeginDate")) EndDate = Trim(Request("EndDate")) If BeginDate = "" Then BeginDate = "1900-1-1" Else BeginDate = ReplaceBadChar(BeginDate) End If If EndDate = "" Then EndDate = FormatDateTime(Date, 2) Else EndDate = ReplaceBadChar(EndDate) End If If IsDate(BeginDate) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请输入正确的起始日期!
  • " End If If IsDate(EndDate) = False Then FoundErr = True ErrMsg = ErrMsg & "
  • 请输入正确的结束日期!
  • " End If If FoundErr = True Then Exit Sub End If If SystemDatabaseType = "SQL" Then strSql = strSql & "And Ispayed=" & PayStatus & " and UpdateTime Between '" & BeginDate & "' and '" & EndDate & "'" Else strSql = strSql & "And Ispayed=" & PayStatus & " and UpdateTime Between #" & BeginDate & "# and #" & EndDate & "#" End If Case Else If InStr(ArticleID, ",") >= 0 And ArticleID <> "" Then strSql = strSql & "And Ispayed=" & PayStatus & " And ArticleID in (" & ArticleID & ")" Else FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If End Select Set rsArticleOut = Conn.Execute(strSql) If rsArticleOut.BOF And rsArticleOut.EOF Then Response.Write "" Else Call outHead2 Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf If PayStatus = PE_True Then Response.Write "" & vbCrLf Else Response.Write "" & vbCrLf End If Response.Write "" & vbCrLf Do While Not rsArticleOut.EOF Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf If PayStatus = PE_True Then Response.Write "" & vbCrLf Else Response.Write "" & vbCrLf End If Response.Write "" & vbCrLf rsArticleOut.MoveNext Loop rsArticleOut.Close Set rsArticleOut = Nothing Response.Write "
    文章ID文章标题录入者作者稿费受益者文章字数稿费(单位:元)已支付支付时间录入时间
    " & rsArticleOut("ArticleID") & "" & rsArticleOut("Title") & "" & rsArticleOut("Inputer") & "" & rsArticleOut("Author") & "" & rsArticleOut("Beneficiary") & "" & getWordNumber(rsArticleOut("Content")) & "" & rsArticleOut("Copymoney") & "" If rsArticleOut("IsPayed") Then Response.Write "是" Else Response.Write "否" End If Response.Write "" & rsArticleOut("payDate") & "" & rsArticleOut("UpdateTime") & "
    " & vbCrLf End If End Sub Sub ConfirmPay() Dim strSql, rsArticle, i, arrArticleID strSql = "Update PE_Article Set IsPayed=" & PE_True & ",PayDate=" & PE_Now & " Where Copymoney>0 And Ispayed=" & PE_False & " And Status=3" If InStr(ArticleID, ",") >= 0 And ArticleID <> "" Then strSql = strSql & " And ArticleID in (" & ArticleID & ")" Else FoundErr = True ErrMsg = ErrMsg & "
  • 请先选定" & ChannelShortName & "!
  • " Exit Sub End If Conn.Execute (strSql) Conn.Close Set Conn = Nothing Response.Redirect "Admin_Article.asp?ChannelID=" & ChannelID & "&ManageType=PayMoney&Status=9" End Sub Sub outHead2() Response.Write "" & vbCrLf Response.ContentType = "application/vnd.ms-excel" & vbCrLf Response.AddHeader "Content-Disposition", "attachment" Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "稿费列表" & vbCrLf Response.Write "" & vbCrLf End Sub %>