<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
option explicit
response.buffer=true
Const PurviewLevel=2
Const CheckChannelID=4
Const PurviewLevel_Photo=2
%>
<%
dim PhotoID,ClassID,TargetClassID,SpecialID
dim Action,FoundErr,ErrMsg
dim strComeUrl
dim SkinID,LayoutID,SkinCount,LayoutCount,ClassMaster,BrowsePurview,AddPurview
if trim(request("strComeUrl"))="" then
strComeUrl=Request.ServerVariables("HTTP_REFERER")
else
strComeUrl=trim(request("strComeUrl"))
end if
PhotoID=trim(request("PhotoID"))
TargetClassID=trim(request("TargetClassID"))
SpecialID=trim(request("SpecialID"))
Action=Trim(Request("Action"))
if Action="MoveToClass" then
call MoveToClass()
elseif Action="MoveToSpecial" then
call MoveToSpecial()
elseif Action="Move" then
call MovePhoto()
else
call main()
end if
if FoundErr=True then
call WriteErrMsg()
end if
call CloseConn()
sub main()
if PhotoID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请选择要移动的图片！
"
exit sub
else
PhotoID=CLng(PhotoID)
end if
dim sqlPhoto,rsPhoto
dim PhotoName,PhotoUrl_Thumb,ClassName,ParentPath,Depth
sqlPhoto="select Photo.ClassID,Photo.PhotoName,PhotoClass.ClassName,PhotoClass.ParentPath,PhotoClass.Depth,Photo.PhotoUrl_Thumb from Photo"
sqlPhoto=sqlPhoto & " inner join PhotoClass on Photo.ClassID=PhotoClass.ClassID where Photo.PhotoID=" & PhotoID
set rsPhoto=Server.CreateObject("ADODB.Recordset")
rsPhoto.open sqlPhoto,conn,1,1
if rsPhoto.bof and rsPhoto.eof then
FoundErr=True
ErrMsg=ErrMsg & "
找不到要移到的图片
"
else
ClassID=rsPhoto(0)
PhotoName=rsPhoto(1)
ClassName=rsPhoto(2)
ParentPath=rsPhoto(3)
Depth=rsPhoto(4)
PhotoUrl_Thumb=rsPhoto(5)
%>
图片移动
<%
end if
rsPhoto.close
set rsPhoto=nothing
end sub
sub MovePhoto()
dim tClass
if PhotoID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请选择要移动的图片！
"
end if
if TargetClassID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请指定目标栏目！
"
else
TargetClassID=CLng(TargetClassID)
set tClass=conn.execute("select Child from PhotoClass where ClassID=" & TargetClassID)
if tClass.bof and tClass.eof then
FoundErr=True
ErrMsg=ErrMsg & "
找不到指定的目标栏目！
"
else
if tClass(0)>0 then
FoundErr=True
ErrMsg=ErrMsg & "
不能将图片移到有子栏目的栏目中！
"
end if
end if
end if
if FoundErr=True then exit sub
if SpecialID="" then
SpecialID=0
else
SpecialID=Clng(SpecialID)
end if
PhotoID=replace(PhotoID," ","")
'conn.execute("update Photo set ClassID=" & TargetClassID & ",SpecialID=" & SpecialID & " where PhotoId in (" & PhotoID & ")")
conn.execute("update Photo set ClassID=" & TargetClassID & " where PhotoId in (" & PhotoID & ")")
conn.execute("update PhotoComment set ClassID=" & TargetClassID & " where PhotoID in (" & PhotoID & ")")
call CloseConn()
response.Redirect strComeUrl
end sub
sub MoveToClass()
dim tClass
if PhotoID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请选择要移动的图片！
"
end if
if TargetClassID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请指定目标栏目！
"
else
TargetClassID=CLng(TargetClassID)
set tClass=conn.execute("select Child from PhotoClass where ClassID=" & TargetClassID)
if tClass.bof and tClass.eof then
FoundErr=True
ErrMsg=ErrMsg & "
找不到指定的目标栏目！
"
else
if tClass(0)>0 then
FoundErr=True
ErrMsg=ErrMsg & "
不能将图片移到有子栏目的栏目中！
"
end if
end if
end if
if FoundErr=True then exit sub
PhotoID=replace(PhotoID," ","")
conn.execute("update Photo set ClassID=" & TargetClassID & " where PhotoId in (" & PhotoID & ")")
conn.execute("update PhotoComment set ClassID=" & TargetClassID & " where PhotoId in (" & PhotoID & ")")
call CloseConn()
response.Redirect strComeUrl
end sub
sub MoveToSpecial()
if SpecialID="" then
FoundErr=True
ErrMsg=ErrMsg & "
请指定目标专题！
"
exit sub
else
SpecialID=CLng(SpecialID)
end if
PhotoID=replace(PhotoID," ","")
conn.execute("update Photo set SpecialID=" & SpecialID & " where PhotoID in (" & PhotoID & ")")
call CloseConn()
response.Redirect strComeUrl
end sub
%>