addtwosave.asp

购物网站源码有需要的赶快下载机不可失

<%dbdns="../../"%>
<!--#include file="../../inc/conn.asp"-->
<!--#include file="../cook.asp"-->
<%if fla0<>1 then
response.write "<script>alert('操作权限出错，您没有权限操作些功能');history.go(-1);</Script>"
Response.End 
end if%>
<%
if request("action")="del" then
set Fs = Server.CreateObject("Scripting.FileSystemObject")
set rs = Server.CreateObject("ADODB.Recordset")
set rs1 = Server.CreateObject("ADODB.Recordset")
sql="select * from SMT_yp where SMT_ypxxtwo_id=" & request("ypxxtwo_id")
rs.open sql,conn,1,1
do while not rs.eof

userfolder="../../UserDocument/"&rs("SMT_user")
If Fs.folderExists(server.mappath(userfolder)) Then
Fs.DeleteFolder(server.mappath(userfolder))
end if

sql1="select * from SMT_news where SMT_yp_id="&id(i)
rs1.open sql1,conn,1,1
filename="../../html/news/"&year(rs1("SMT_date"))&month(rs1("SMT_date"))&"/"&replace(replace(replace(rs1("SMT_date"),"-",""),":","")," ","")&".html"
rs1.close
If Fs.FileExists(server.mappath(filename)) Then
set Os = Fs.GetFile(server.mappath(filename))
Os.Delete
end if
conn.execute("delete from SMT_news where SMT_yp_id=" & rs("SMT_id"))

sql1="select * from SMT_xxnews where SMT_yp_id="&id(i)
rs1.open sql1,conn,1,1
filename="../../html/xxnews/"&year(rs1("SMT_date"))&month(rs1("SMT_date"))&"/"&replace(replace(replace(rs1("SMT_date"),"-",""),":","")," ","")&".html"
rs1.close
If Fs.FileExists(server.mappath(filename)) Then
set Os = Fs.GetFile(server.mappath(filename))
Os.Delete
end if
conn.execute("delete from SMT_xxnews where SMT_yp_id=" & rs("SMT_id"))

conn.execute("delete from SMT_cp where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_cp_sort where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_Job_zp where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_sca where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_yp where SMT_id=" & rs("SMT_id"))
conn.execute("delete from SMT_upfile where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_leaveword where SMT_book_ypid=" & rs("SMT_id"))
conn.execute("delete from SMT_message where SMT_yp_id=" & rs("SMT_id") & " or SMT_send_id=" & rs("SMT_id"))
conn.execute("delete from SMT_collection where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_collection_sort where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_friend where SMT_yp_id=" & rs("SMT_id"))
conn.execute("delete from SMT_exhibit where SMT_yp_id=" & rs("SMT_id"))
rs.movenext
loop
rs.close
set rs1=nothing
set rs=nothing
set fs=nothing

conn.execute("delete from SMT_cp where SMT_ypxxtwo_id=" & request("ypxxtwo_id"))
conn.execute("delete from SMT_yp where SMT_ypxxtwo_id=" & request("ypxxtwo_id"))
conn.execute("delete from SMT_sca where SMT_ypxxtwo_id=" & request("ypxxtwo_id"))
conn.execute("delete from SMT_exhibit where SMT_ypxxtwo_id=" & request("ypxxtwo_id"))

conn.execute("delete from SMT_ypxxtwo where SMT_ypxxtwo_id=" & request("ypxxtwo_id"))

Response.Redirect "addoneadd.asp"
end if

dim ypxxtwo
ypxxtwo=request("ypxxtwo")
pic=request("pic")
if pic="" then pic=null
if ypxxtwo="" then
	response.write "<script>alert('对不起，小类栏目不能为空！');history.go(-1);</Script>"
	Response.End 
end if

if request("action")="add" then
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from SMT_ypxxtwo" 
rs.open sql,conn,1,3

rs.AddNew
rs("SMT_ypxxtwo")=ypxxtwo
rs("SMT_ypxxone")=request("ypxxone")
rs("SMT_ypxxone_id")=request("ypxxone_id")
rs("SMT_pic")=pic
rs.Update
rs.Close
set rs=nothing
conn.Close
set conn=nothing
Response.Redirect "addoneadd.asp?id="&request("ypxxone_id")&"&one="&request("ypxxone")
end if

if request("action")="edit" then
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from SMT_ypxxtwo where SMT_ypxxtwo_id="&request("ypxxtwo_id")
rs.open sql,conn,1,3
rs("SMT_ypxxtwo")=ypxxtwo
rs("SMT_pic")=pic
rs.Update
rs.Close
set rs=nothing
conn.Close
set conn=nothing
Response.Redirect "addoneadd.asp"
end if
%>