?? addsort.asp
字號:
<%
if session("admin_name")="" then response.end
%>
<!--#include file="../inc/adconn.asp"-->
<!--#include file="../css.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=../css.css rel=STYLESHEET type=text/css>
<%
sql="select * from sort"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
%>
<table border="0" width="450" cellspacing="1" align="center">
<tr>
<td width="100%">
<form method="POST" action="addsort1.asp" align="center" language="javascript" onsubmit="return test(this);">
<input type="hidden" name="options" value>
<TABLE cellSpacing=1 cellPadding=0 width="450" align=center bgColor=#999999
border=0>
<TBODY>
<TR>
<TD width="735" bgcolor="f0f0f0" id=maintitleback>
<TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD width="10"><IMG height=8 src="../images/pics/nav_m.gif" width=8
border=0></TD>
<TD height="30" valign="bottom" id=maintitle>產品管理 -><b>產品類別</b></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
<TR>
<TD id=mainbg> <TABLE cellSpacing=1 cellPadding=4 width="100%" border=0 height="156">
<TBODY>
<TR>
<TD height="30" noWrap
background=../images/pics/tile_sub.gif id=titlemedium width="104">
<div align="center"><font color="#FFFFFF">產品分類</font></div>
</TD>
<TD width="325" height="30" noWrap
background=../images/pics/tile_sub.gif id=titlemedium>
<div align="left">
<select name="subject" size="1"style="font-size: 9pt">
<%
if rs.eof and rs.bof then
response.write "<option value=>請增加類別"
else
Do while not rs.eof
response.write "<option value='" + Cstr(rs("sort_id")) + "'>" + rs("sort_name") + "</option>"
rs.MoveNext
Loop
end if
%>
</select>
<input name="submit" type=image id="B2" alt=刪除 src="../images/pics/delete.gif" align=absMiddle width="45" height="20" onclick="form.options.value='del'">
</div>
</TD>
</TR>
<TR>
<TD bgColor=#ffffff height="30" width="104">
<div align="center">更改分類名字</div></TD>
<TD height="30" align=middle bgColor=#ffffff width="325">
<div align="left">
<input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="reTitle" size="20" class=smallinput>
<input name="submit" type=image id="B12" alt=改名 src="../images/pics/change.gif" align=absMiddle width="75" height="20" onclick="form.options.value='rename'">
</div>
</TD>
</TR>
<TR>
<TD width=104 bgColor=#ffffff height="30">
<div align="center">添加分類名字
</div></TD>
<TD height="30" align=middle bgColor=#ffffff width="325">
<div align="left">
<input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="newTitle" size="20" class=smallinput>
<input name="submit" type=image id="B3" alt=新增 src="../images/pics/add.gif" align=absMiddle width="75" height="20" onclick="form.options.value='new'">
</div>
</TD>
</TR>
<TR>
<TD height="30" colspan="2" bgColor=#ffffff><div align="center"><img src="../../images/pics/seperator.gif" width="359" height="1"></div></TD>
</TR>
<TR bgcolor="f0f0f0">
<TD height="20"
colSpan=2 id=mainfoot>
<div align="center"> </div></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
</form>
</td>
</tr>
</table>
<%
set rs=nothing
%>
<% set rs2=server.createobject("adodb.recordset")
sql2="select * from Nsort order by Nsort_id"
rs2.open sql2,conn,1,1
%>
<table width="450" border="0" cellspacing="0" cellpadding="0" height="75" align="center">
<tr>
<td>
<form method="POST" action="addsort2.asp" align="center" language="javascript" onsubmit="return test(this);">
<input type="hidden" name="options" value>
<TABLE cellSpacing=1 cellPadding=0 width="450" align=center bgColor=#999999
border=0>
<TBODY>
<TR>
<TD width="735" bgcolor="f0f0f0" id=maintitleback>
<TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD width="10"><IMG height=8 src="../images/pics/nav_m.gif" width=8
border=0></TD>
<TD height="30" valign="bottom" id=maintitle>產品管理 -><b>子專題管理</b></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
<TR>
<TD id=mainbg> <TABLE cellSpacing=1 cellPadding=4 width="100%" border=0 height="177">
<TBODY>
<TR>
<TD height="30" noWrap
background=../images/pics/tile_sub.gif id=titlemedium width="123">
<div align="center"><font color="#FFFFFF">產品分類</font></div>
</TD>
<TD width="306" height="30" noWrap
background=../images/pics/tile_sub.gif id=titlemedium>
<div align="left">
<select name="subject" size="1" style="font-size: 9pt">
<%
if rs2.eof and rs2.bof then
response.write "<option value=>請增加專題"
else
Do while not rs2.eof
response.write "<option value='" + Cstr(rs2("Nsort_id")) + "'>" + rs2("Nsort_name") + "</option>"
rs2.MoveNext
Loop
end if
%>
</select>
<input name="submit" type=image id="B2" alt=刪除 src="../images/pics/delete.gif" align=absMiddle width="45" height="20" onclick="form.options.value='del'">
</div>
</TD>
</TR>
<TR>
<TD height="30" colspan="2" bgColor=#ffffff> </TD>
</TR>
<% set rs=server.createobject("adodb.recordset")
sql="select * from sort order by sort_id"
rs.open sql,conn,1,1
%>
<TR>
<TD bgColor=#ffffff height="30" width="123">
<div align="center">更改專題名字</div></TD>
<TD height="30" align=middle bgColor=#ffffff width="306">
<div align="left">
<input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="reTitle" size="20" class=smallinput>
在
<select name="sort_id" size="1"style="font-size: 9pt">
<%
if rs.eof and rs.bof then
response.write "<option value=>請增加類別"
else
rs.MoveFirst
Do while not rs.eof
response.write "<option value='" + Cstr(rs("sort_id")) + "'>" + rs("sort_name") + "</option>"
rs.MoveNext
Loop
end if
%>
</select>
中
<input name="submit" type=image id="B12" alt=改名 src="../images/pics/change.gif" align=absMiddle width="75" height="20" onclick="form.options.value='rename'">
</div>
</TD>
</TR>
<TR>
<TD width=123 bgColor=#ffffff height="30">
<div align="center">添加專題名字</div></TD>
<TD height="30" align=middle bgColor=#ffffff width="306">
<div align="left">
<input style="FONT-SIZE: 12px; WIDTH: 110px" type="text" name="newTitle" size="20" class=smallinput>
在
<select name="psubject" size="1"style="font-size: 9pt">
<%
if rs.eof and rs.bof then
response.write "<option value=>請增加類別"
else
rs.MoveFirst
Do while not rs.eof
response.write "<option value='" + Cstr(rs("sort_id")) + "'>" + rs("sort_name") + "</option>"
rs.MoveNext
Loop
end if
%>
</select>
中
<input name="submit" type=image id="B3" alt=新增 src="../images/pics/add.gif" align=absMiddle width="75" height="20" onclick="form.options.value='new'">
</div>
</TD>
</TR>
<TR>
<TD height="30" colspan="2" bgColor=#ffffff><div align="center"><img src="../../images/pics/seperator.gif" width="359" height="1"></div></TD>
</TR>
<TR bgcolor="f0f0f0">
<TD height="20"
colSpan=2 id=mainfoot>
<div align="center"> </div></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
</form></td>
</tr>
</table>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -