⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 manage_moveaction.asp

📁 5237 论坛.rar
💻 ASP
字号:
🔍 
<!--#include file="Connections/connY.asp" -->
<!--#include file="Inc/Set.asp" -->
<!--#include file="Inc/Level01.asp" -->
<%
'定义参数
ID=Request.Form("ID")
IDArray=Split(ID,"|")
IDNum=UBound(IDArray)
FromID=Request.Form("FromID")
ToID=Request.Form("ToID")
User=Request.Form("User")
ToSubject=Request.Form("ToSubject")
ToSubjectArray=Split(ToSubject,"|")
Subj=ToSubjectArray(0)
Typ=ToSubjectArray(1)
Set rsS = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tSubjectManage Where rID="&Subj
rsS.Open Sql,ConnY,3,3
SubjName=rsS("rName")
rsS.Close
Set rsS=Nothing
Set rsT = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tTypeManage Where rID="&Typ
rsT.Open Sql,ConnY,3,3
TypName=rsT("rTypeName")
rsT.Close
Set rsT=Nothing

'转移指定帖子
If ID<>"" Then
Set rsMove = Server.CreateObject("ADODB.Recordset")
For I=0 To IDNum
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&IDArray(I)
rsMove.Open Sql,ConnY,3,3
If rsMove.Eof Then
Note=Note&" ID."&IDArray(I)&"操作失败;"
rsMove.Close
Else
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 转移 至"&TypName&SubjName&"版"
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 接受 来自"&TypName&SubjName&"版"
rsOperate("rSubject")=Subj
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsMove("rSubject")=Subj
rsMove("rType")=Typ
rsMove.Update
rsMove.Close
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&IDArray(I)
rsMove.Open Sql,ConnY,3,3
While Not rsMove.Eof
rsMove("rSubject")=Subj
rsMove("rType")=Typ
rsMove.Update
rsMove.MoveNext
Wend
rsMove.Close
Note=Note&" ID."&IDArray(I)&"操作成功;"
End If
Next
Set rsMove=Nothing
End If

'批量转移帖子
If FromID<>"" And ToID<>"" Then
Set rsMove = Server.CreateObject("ADODB.Recordset")
For I=FromID To ToID
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rID="&I
rsMove.Open Sql,ConnY,3,3
If rsMove.Eof Then
Note=Note&" ID."&I&"操作失败;"
rsMove.Close
Else
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 转移 至"&TypName&SubjName&"版"
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 接受 来自"&TypName&SubjName&"版"
rsOperate("rSubject")=Subj
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsMove("rSubject")=Subj
rsMove("rType")=Typ
rsMove.Update
rsMove.Close
Sql = "Select *  From tArticleManage Where rSubject="&Forum_ID&" And rRepID="&IDArray(I)
rsMove.Open Sql,ConnY,3,3
While Not rsMove.Eof
rsMove("rSubject")=Subj
rsMove("rType")=Typ
rsMove.Update
rsMove.MoveNext
Wend
rsMove.Close
Note=Note&" ID."&I&"操作成功;"
End If
Next
Set rsMove=Nothing
End If

'转移指定用户所有在本版的主题帖子.
If User<>"" Then
Set rsMove = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rRepID=0 And rSubject="&Forum_ID&" And rPosterNickName='"&User&"'"
rsMove.Open Sql,ConnY,3,3
If rsMove.Eof Then
Note="操作失败或者无此用户"
rsMove.Close
Else
While Not rsMove.Eof And Not rsMove.Bof
Note=Note&" ID."&rsMove("rID")&"操作成功;"
Set rsOperate = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tOperateManage"
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 转移 至"&TypName&SubjName&"版"
rsOperate("rSubject")=Forum_ID
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
rsOperate.Open Sql,ConnY,3,3
rsOperate.AddNew
rsOperate("rToWho")=rsMove("rPosterNickName")
rsOperate("rWhoDo")=Session("SNickName")
rsOperate("rDo")="文章(ID:"&rsMove("rID")&") 接受 来自"&TypName&SubjName&"版"
rsOperate("rSubject")=Subj
rsOperate("rTime")=Now()
rsOperate.Update
rsOperate.Close
Set rsOperate=Nothing
rsMove("rSubject")=Subj
rsMove("rType")=Typ
rsMove.Update
rsMove.MoveNext
Wend
rsMove.Close
End If
Set rsMove=Nothing
End If
%>
<html>
<head>
<title><%=Forum_Title%></title>
<meta http-equiv="Content-Type" content="text/html;">
<meta http-equiv="Expires" CONTENT="0">
<meta http-equiv="Cache-Control" CONTENT="no-cache">
<meta http-equiv="Pragma" CONTENT="no-cache">
<!--#include file="Inc/Css.asp" -->
</head>
<body leftmargin="0" topmargin="0"  bgcolor="<%=Forum_BgColor%>" vlink="<%=Forum_Css_A_Link_Color%>">
<!--#include file="Inc/Top.asp" -->
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="<%=Forum_BorderColor%>">
  <tr> 
    <td height="20" bgcolor="<%=Forum_BgColor%>"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
        <tr> 
          <td>&nbsp;您所在的位置： <a href="../" onFocus="this.blur()">首页</a> &gt;&gt; 
            <a href="List.asp" onFocus="this.blur()">讨论组</a> &gt;&gt; <a href="List.asp?T=<%=Forum_TypeID%>"  onFocus="this.blur()"><%=Forum_TypeName%></a> 
            &gt;&gt; <a href="Board.asp?S=<%=Forum_ID%>" onFocus="this.blur()"><%=Forum_Name%></a> 
            &gt;&gt; <a href="Manage.asp?S=<%=Forum_ID%>" onFocus="this.blur()">版面管理</a> 
            &gt;&gt; <font color="<%=Forum_NavFontColor%>">转移</font></td>
          <td width="150"></td>
          <td width="18"> </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height=1></td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="2" align="center" class="font" bgcolor="<%=Forum_BorderColor%>">
  <tr>
    <td  bgcolor="<%=Forum_BgColor%>" height="394"> 
      <div align="center"> 
        <table width="400" border="0" cellspacing="1" cellpadding="2" bgcolor="<%=Forum_BorderColor%>" class="font">
          <tr> 
            <td height="100" bgcolor="<%=Forum_AlternateColor1%>"> 
              <div align="center">
			    <font color="<%=Forum_PFontColor%>"><%=Note%></font>
				<br>
                <br>
                <a href="Manage_Move.asp?S=<%=Forum_ID%>" onFocus="this.blur()">返回转移页面</a></div>
            </td>
          </tr>
        </table>
        <br>
        <br>
        <br>
        <br>
        <br>
        <br>
      </div>
    </td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center" id=infoborder style="DISPLAY: none">
  <tr> 
    <td height=1></td>
  </tr>
</table>
<!--#include file="Inc/Bottom.asp" -->
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -