addonesave.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_ypxxone_id=" & request("ypxxone_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_ypxxone_id=" & request("ypxxone_id"))
conn.execute("delete from SMT_yp where SMT_ypxxone_id=" & request("ypxxone_id"))
conn.execute("delete from SMT_sca where SMT_ypxxone_id=" & request("ypxxone_id"))
conn.execute("delete from SMT_exhibit where SMT_ypxxone_id=" & request("ypxxone_id"))

conn.execute("delete from SMT_ypxxone where SMT_ypxxone_id=" & request("ypxxone_id"))
conn.execute("delete from SMT_ypxxtwo where SMT_ypxxone_id=" & request("ypxxone_id"))

Response.Redirect "addoneadd.asp"
end if
dim ypxxone

if request("action")="add" then
ypxxone=request("ypxxone")
pic=request("pic")
if pic="" then pic=null
if ypxxone="" then
	response.write "<script>alert('对不起，大类不能为空！');history.go(-1);</Script>"
	Response.End 
end if
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from SMT_ypxxone" 
rs.open sql,conn,1,3
rs.AddNew
rs("SMT_ypxxone")=ypxxone
rs("SMT_pic")=pic
rs.Update
rs.Close
set rs=nothing
Response.Redirect "addoneadd.asp"
end if


if request("action")="edit" then
ypxxone=request("ypxxone")
pic=request("pic")
if pic="" then pic=null
if ypxxone="" then
	response.write "<script>alert('对不起，大类不能为空！');history.go(-1);</Script>"
	Response.End 
end if
set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from SMT_ypxxone where SMT_ypxxone_id="&request("ypxxone_id")
rs.open sql,conn,1,3
rs("SMT_ypxxone")=ypxxone
rs("SMT_pic")=pic
rs.Update
rs.Close
set rs=nothing

set rs=Server.CreateObject("Adodb.Recordset")
sql="select * from SMT_ypxxtwo where SMT_ypxxone_id="&request("ypxxone_id")
rs.open sql,conn,1,3
do while not rs.eof
rs("SMT_ypxxone")=ypxxone
rs.Update
rs.movenext
loop
rs.Close
set rs=nothing
Response.Redirect "addoneadd.asp"
end if

if request("action")="aa" then
conn.execute("update SMT_ypxxone set SMT_date="&SMT_citytime&" where SMT_ypxxone_id="&request("id"))
Response.Redirect "addoneadd.asp"
end if
if request("action")="aaa" then
conn.execute("update SMT_ypxxtwo set SMT_date="&SMT_citytime&" where SMT_ypxxtwo_id="&request("id"))
Response.Redirect "addoneadd.asp?id="&request("oneid")&"&one="&request("one")
end if
%>