save_small_sort.asp

后台管理系统

<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<% if request.querystring("action")="add" then
set rs=server.createobject("adodb.recordset")
sql="select * from product_small_sort"
rs.open sql,conn,1,3
rs.addnew
rs("big_sortid")=trim(request.form("big_sortid"))
rs("sort")=trim(request.form("sort"))
rs("sx")=trim(request.form("sx"))
rs("sort_width")=trim(request.form("sort_width"))
rs("sort_height")=trim(request.form("sort_height"))
rs.update
response.Write "<script language=javascript>alert('添加小类成功！');window.location.href='small_sort.asp"&"?big_sortid="&trim(request.form("big_sortid"))&"&sort="&trim(request.form("big_sort"))&"';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
<% if request.querystring("action")="save" then
set rs=server.createobject("adodb.recordset")
sql="select * from product_small_sort where id="&cint(request.form("delid"))
rs.open sql,conn,1,3
rs("sort")=trim(request.form("sort"))
rs("sx")=trim(request.form("sx"))
rs("sort_width")=trim(request.form("sort_width"))
rs("sort_height")=trim(request.form("sort_height"))
rs.update
response.Write "<script language=javascript>alert('修改小类成功！');window.location.href='small_sort.asp"&"?big_sortid="&trim(request.form("big_sortid"))&"&sort="&trim(request.form("big_sort"))&"';</script>"
rs.close
set rs=nothing
elseif request.querystring("action")="delete"then
deltxt="delete from product_small_sort where id="&request("id")
deltxt0="delete from product_info where sort_id="&request("id")
conn.execute deltxt
conn.execute deltxt0
response.Write "<script language=javascript>alert('类别删除成功！');window.location.href='small_sort.asp"&"?big_sortid="&trim(request("big_sortid"))&"&sort="&trim(request("big_sort"))&"';</script>"
conn.close
set conn=nothing
end if
%>