coalition-clend.asp

西亚电子购物系统

<!--#include file="../manage/check-4.asp"-->
<!--#include file="../conn/conn.asp" -->
<%
clid1=request("clid1")
clid2=request("clid2")
clidto=request("clidto")

if clid1="0" or clid2="0" then 
response.write"<SCRIPT language=JavaScript>alert('主分类选择错误！');history.back();"
response.write "</SCRIPT>"
response.end
end if

if sia_categoryto="" then 
response.write"<SCRIPT language=JavaScript>alert('请填写合并后的主分类名！');history.back();"
response.write "</SCRIPT>"
response.end
end if

if clid1=clid2 then 
response.write"<SCRIPT language=JavaScript>alert('主分类选择错误，不要选择相同的！');history.back();"
response.write "</SCRIPT>"
response.end
end if


conn.execute "update sia_category set clname='"&clidto&"' where clid="&clid1&""
conn.execute "delete * from sia_category where clid="&clid2&""
conn.execute "update sia_class set clid="&clid1&" where clid="&clid2&""
conn.execute "update sia_product set clid="&clid1&" where clid="&clid2&""
response.write"<SCRIPT language=JavaScript>alert('主分类合并成功！');location.href=""class.asp"";"
response.write "</SCRIPT>"
%>