If Request.Form("Action") = "Del" then
Dim DelID,Str_Tmp,Str_Tmp1
DelID = NoSqlHack(request.Form("MessageID"))
if DelID = "" then
strShowErr = "<li>你必须选择一项再删除</li>"
Call ReturnError(strShowErr,"")
End if
if Trim(Request.Form("strAction")) = "drabox" then
Dim RsTFSQLd,RsTFObjd
Set RsTFObjd = Server.CreateObject(G_FS_RS)
RsTFSQLd = "Select isDelR,isSend From FS_ME_Message where MessageId in ("&DelID&") "
RsTFObjd.Open RsTFSQLd,User_Conn,1,3
do while not RsTFObjd.eof
if
RsTFObjd("isDelR") = 1 and RsTFObjd("isSend") = 0 then
User_Conn.execute("Delete From FS_ME_Message where MessageId in ("&DelID&")")
Else
User_Conn.execute("Update FS_ME_Message set isDraft = 0 where MessageId in ("&DelID&") and M_FromUserNumber ='"& Fs_User.UserNumber&"'")
End if
RsTFObjd.movenext
loopElseif Trim(Request.Form("strAction")) = "sendbox" then
Dim RsTFSQL,RsTFObj
Set RsTFObj = Server.CreateObject(G_FS_RS)
RsTFSQL = "Select isDelR,isDraft From FS_ME_Message where MessageId in ("&DelID&") "
RsTFObj.Open RsTFSQL,User_Conn,1,3
do while not RsTFObj.eof if
RsTFObj("isDelR") = 1 and RsTFObj("isDraft")=0 then
User_Conn.execute("Delete From FS_ME_Message where MessageId in ("&DelID&")")
Else
User_Conn.execute("Update FS_ME_Message set isSend = 0 where MessageId in ("&DelID&") and M_FromUserNumber ='"& Fs_User.UserNumber&"'")
End if
RsTFObj.movenext
loopElseif Trim(Request.Form("strAction")) = "rebox" then
Dim RsTFSQL1,RsTFObj1
Set RsTFObj1 = Server.CreateObject(G_FS_RS)
RsTFSQL1 = "Select isDelF,isSend,isDraft From FS_ME_Message where MessageId in ("&DelID&") "
RsTFObj1.Open RsTFSQL1,User_Conn,1,3
do while not RsTFObj1.eof if
RsTFObj1("isSend") = 0 and RsTFObj1("isDraft")=0 then
User_Conn.execute("Delete From FS_ME_Message where MessageId in ("&DelID&") and M_ReadUserNumber ='"& Fs_User.UserNumber&"'")
Else
User_Conn.execute("Update FS_ME_Message set isDelR = 1 where MessageId in ("&DelID&") and M_ReadUserNumber ='"& Fs_User.UserNumber&"'")
End if
RsTFObj1.movenext
loopElse
strShowErr = "<li>错误的参数</li>"
Call ReturnError(strShowErr,"")
'User_Conn.execute("Update FS_ME_Message set isDelR = 1 where MessageId in ("&DelID&") and M_ReadUserNumber ='"& Fs_User.UserNumber&"'")
End if
strShowErr = "<li>删除短信成功</li>"
Response.Redirect("lib/Success.asp?ErrCodes="&Server.URLEncode(strShowErr)&"&ErrorUrl=")
Response.end
End if
红色 只是大体标注!