?? 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>
<%
end if
set rs=nothing
conn.close
set conn=nothing
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -