📄 typeindex1.asp
字号:
<!--#include file="../conn.asp"-->
<%
dbpath="../"
dblink
%>
<!--#include file="check.asp"-->
<%
dim action,id,dname
id=clng(request.QueryString("id"))
action=Server.HtmlEncode(request.querystring("action"))
dname=Server.HtmlEncode(request("dname"))
''''''''
''''''''''k
select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from typeindex where name='"&dname&"' and threeid=0 and twoid=0",conn,1,1
if rs.EOF and rs.BOF then
rs.close
rs.open "select * from typeindex where threeid=0 and twoid=0 order by id desc",conn,1,1
if rs.eof and rs.bof then
id=1
else
id=rs("id")+1
end if
rs.close
rs.open "typeindex",conn,1,3
rs.AddNew
if id=0 then
rs("id")=1
else
rs("id")=id
end if
rs("name")=rTrim(dname)
rs("indexid")=clng(request("indexid"))
rs("indexshow")=Server.HtmlEncode(request("indexshow"))
rs("titlecolor")=Server.HtmlEncode(request("colorshow"))
rs.Update
rs.Close
set rs=nothing
else
response.write "<script>window.alert('你输入的分类名称:"&dname&"已经有了！');history.go(-1);</script>"
end if
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from typeindex where twoid=0 and id="&id,conn,1,3
yname=rs("name")
rs("name")=rTrim(dname)
rs("indexid")=clng(request("indexid"))
rs("indexshow")=Server.HtmlEncode(request("indexshow"))
rs("titlecolor")=Server.HtmlEncode(request("colorshow"))
rs.Update
rs.Close
set rs=nothing
case "del"
set rs=server.CreateObject("adodb.recordset")
conn.execute ("delete from typeindex where id="&id&"")
conn.close
set conn=nothing
response.Redirect "?"
end select
%>
<HTML>
<HEAD>
<LINK rel="stylesheet" type="text/css" href="Inc/style.css">
<SCRIPT language="javascript" src="color.js"></SCRIPT>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<META name="GENERATOR" content="Microsoft FrontPage 4.0">
<META name="ProgId" content="FrontPage.Editor.Document">
<TITLE>导航管理</TITLE>
</HEAD>
<BODY background="images/background.gif">
<TABLE width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#799AE1">
<TR>
<TD height="20" bgcolor="#799AE1" align="center"><FONT color="#FFFFFF" style="font-size:14px">首 页 网 址 导 航 管 理</FONT></TD>
</TR>
<TR>
<TD bgcolor="#FFFFFF">
<TABLE width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#D6DFF7">
<TR align="center" bgcolor="#FFFFFF" height="20">
<TD width="35">编号</TD>
<TD >导航名称</TD>
<TD >管理操作</TD>
</TR>
<%set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from typeindex where twoid=0 and id>0 order by i",conn,1,1
dim follows
if rs.EOF and rs.BOF then
response.write"<tr bgcolor=#FFFFFF><td colspan='6'><p align='center'><font color='red'>暂无分类！</font></td></tr></table><br>"
follows=0
else
do while not rs.EOF
i=i+1
%>
<FORM name="form1" method="post" action="?action=edit&id=<%=int(rs("id"))%>">
<TR bgcolor="#FFFFFF" align="center">
<TD><%=rs("i")%></TD>
<TD><INPUT name="dname" type="text" size="12" maxlength="4" value="<%=trim(rs("name"))%>">
<input class="lkbtn" style="MARGIN-BOTTOM: -1px; PADDING-TOP: 2px" onclick="javascript:location.href='urlindex.asp?typeindexid=<%=rs("i")%>'" type="button" value="管理该分类网址" name="fanhui"></TD>
<TD><INPUT type="submit" name="Submit" value="修 改">
<%if rs("sfdel") = "1" then
else
%>
<INPUT type="button" name="DEL" onClick="{if(confirm('确定要删除这个分类吗？\n将删除此分类下所有信息\n此操作不可以恢复！')){location.href='?name=<%=rs("name")%>&action=del&id=<%=rs("id")%>';}return false;}" value="删除" >
<%end if%>
</TD>
</TR>
</FORM>
<%
rs.MoveNext
loop
follows=rs.RecordCount
end if%>
</TABLE>
<BR></TD>
</TR>
</TABLE>
</BODY>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -