user_infodel.asp

该软件是帮助大学生更好的生活

<!--#include file="inc/conn.asp"-->
<!--#include file="inc/Conn_User.asp"-->
<!--#include file="Inc/func.asp"-->
<!--#include file="inc/config.asp"-->
<%
if CheckUserLogined()=False then
	response.Redirect "User_Login.asp"
end if

dim ArticleID,Action,sqlDel,rsDel,FoundErr,ErrMsg,PurviewChecked,ObjInstalled
ArticleID=trim(request("ArticleID"))
Action=Trim(Request("Action"))
FoundErr=False
ObjInstalled=IsObjInstalled("Scripting.FileSystemObject")

if ArticleId="" or Action<>"Del" then
	FoundErr=True
	ErrMsg=ErrMsg & "<br><li>参数不足！</li>"
end if
if FoundErr=False then
	if instr(ArticleID,",")>0 then
		dim idarr,i
		idArr=split(ArticleID)
		for i = 0 to ubound(idArr)
			call DelArticle(clng(idarr(i)))
		next
	else
		call DelArticle(clng(ArticleID))
	end if
end if
call CloseConn()
if FoundErr=False then
	response.Redirect "User_infoManage.asp"
else
	call WriteErrMsg()
end if

sub DelArticle(ID)
	PurviewChecked=False
	sqlDel="select * from article where ArticleID=" & CLng(ID)
	Set rsDel= Server.CreateObject("ADODB.Recordset")
	rsDel.open sqlDel,conn,1,3
	if rsDel.bof and rsDel.eof then
		FoundErr=True
		ErrMsg=ErrMsg & "<br><li>找不到文章：" & rsDel("Title") & " </li>"
	else
		if rsDel("Editor")=Trim(Request.Cookies("luyeweb")("UserName")) then
			if rsDel("Passed")=True then
				FoundErr=True
				ErrMsg=ErrMsg & "<br><li>删除文章“" & rsDel("Title") & "”失败。原因：此文章已经被审核通过，你不能再删除！</li>"
			end if
		else
			FoundErr=True
			ErrMsg=ErrMsg & "<br><li>删除文章“" & rsDel("Title") & "”失败。原因：此文章是其他网友发表的，你不能删除其他人的文章！</li>"
		end if
	end if
	if FoundErr=False then
		rsDel("Deleted")=True
		rsDel.update
		Conn_User.execute("update " & db_User_Table & " set " & db_User_ArticleCount & "=" & db_User_ArticleCount & "-1 where " & db_User_Name & "='" & rsDel("Editor") & "'")
	end if
	rsDel.close
	set rsDel=nothing
end sub
%>