📄 addsort3.asp
字号:
<%
if session("admin_name")="" then response.end
%>
<!--#include file="conn.asp"-->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<%
set rs1=server.createobject("adodb.recordset")
set rs=server.createobject("adodb.recordset")
Sql="select * from sort"
Rs.open Sql,conn,1,1
Do while not Rs.eof
sort_Name=Rs("sort_Name")
sort_id=Rs("sort_id")
Sql1="select * from sort2 where sort_id='"&sort_id&"'"
Rs1.open Sql1,conn,1,1
Do while not Rs1.eof
i=i+1
sort2_id=Rs1("sort2_id")
sort2_Name=Rs1("sort2_name")
if request("Class_Nclass")=sort_id&","&sort2_id then
k=" selected"
else
k=""
end if
Class_Type=Class_Type&"<option "&k&" value="&sort_id&","&sort2_id&">"&sort_Name&"──→"&sort2_Name&"</option>"
Rs1.movenext
loop
Rs1.close
Rs.movenext
loop
Rs.close
%>添加第三商品类别
<%
if request("action")="save" then
if instr(Request("Class_Nclass"),",")>0 then
Class_array=split(Request.Form("Class_Nclass"),",")
sort_Id=Class_array(0)
sort2_Id=Class_array(1)
else
response.write "请选择所属类别"
end if
sql="select * from sort3"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
rs.addnew
rs("sort_id")=sort_id
rs("sort2_id")=sort2_id
rs("sort3_name")=request("sort3_name")
rs.update
rs.close
response.write "<br>第三商品类别添加成功"
response.write "<br>"
response.write "<a href=addsort3.asp>返回</a>"
else
%> <form method="POST" action="addsort3.asp?action=save">
<table border="0" width="100%" cellspacing="1">
<tr>
<td width="100%">请选择一、二级分类<select name="Class_Nclass" size="1" onChange="window.open('addsort3.asp?Class_Nclass='+this.options[this.selectedIndex].value,'_self')">
<option value="">请选择分类</option>
<%=Class_Type%>
</select>
</td></tr>
<tr>
<td width="100%">
第三商品类别名称<input type="text" name="sort3_name" size="20" class=input><input type="submit" value="提交" name="B1" class=input>
</form>
</td>
</tr>
</table>
<%
end if
set rs=nothing
conn.close
set conn=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -