⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 menu.asp

📁 亿众购物系统 一套设计完善、高效的web商城解决方案
💻 ASP
字号:
<!--#include file="../Session.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/site.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
  <tr align="center"> 
    <td height="50" colspan="6" class="tdstyle"><font color="#000000" size="3"><strong>菜单管理</strong></font></td>
  </tr>
  <tr align="center"> 
    <td width="10%" height="25" class="tdstyle">位置</td>
    <td width="20%" class="tdstyle">名称</td>
    <td width="30%" class="tdstyle">连接</td>
    <td width="10%" class="tdstyle">修改</td>
    <td width="10%" class="tdstyle">删除</td>
  </tr>
  <%sql="select * from Menu"
  set rs = Server.CreateObject("ADODB.Recordset")
  rs.open sql,conn,1,1
  For i=1 to rs.recordcount%>
  <form name="form1" method="post" action="?Act=a">
  <input name="id" type="hidden" id="id" value="<%=rs("id")%>">
    <tr> 
      <td height="20" align="center" class="tdstyle"><%if rs("sort")=1 then:Response.Write("顶部"):else:Response.Write("底部")%></td>
      <td class="tdstyle"><input name="MenuName" type="text" class="input1" id="MenuName" value="<%=rs("MenuName")%>" size="25"></td>
      <td class="tdstyle"><strong><input name="url" type="text" class="input1" id="url" value="<%=rs("url")%>" size="25"></strong></td>
      <td align="center" class="tdstyle"><input name="Submit" type="submit" class="button2" value="修改"></td>
      <td align="center" class="tdstyle"><input name="Submit2" type="button" class="button2" value="删除" onclick="if(confirm('您确定要删除吗?')) location.href='Menu.asp?Act=c&id=<%=rs("id")%>'"></td>
    </tr>
  </form>
  <%rs.movenext
  next
  rs.close
  %>
</table>
<form action="?Act=b" method="post" name="form" id="form">
  <table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
    <tr align="center"> 
      <td height="50" colspan="2" class="tdstyle"><font color="#000000" size="3"><strong>添加</strong></font></td>
    </tr>
    <tr> 
      <td colspan="2" align="center" class="tdstyle">
	  位置:<input type="radio" name="Sort" value="1">顶部 <input type="radio" name="Sort" value="2">底部 
	  名称: <input name="MenuName" type="text" class="input1" id="MenuName" size="25">  
	  连接: <input name="url" type="text" class="input1" id="url" size="30"></td>
    </tr>
    <tr> 
      <td height="30" colspan="2" align="center" class="tdstyle"> <input name="Submit3" type="submit" class="button" value="提 交"> 
      </td>
    </tr>
  </table>
</form>
<bt><br>
<%
If request("Act")<>"" then
	Select case request("Act")
	   case "a"
		   conn.execute("Update Menu set MenuName = '"&request("MenuName")&"',Url = '"&request("Url")&"' where id="&request("id")&"")
	   case "b"
		   if request("Sort")="" then
				Response.Write("<script>alert(""菜单位置不能为空!"");history.back();</script>")
				response.end
			end if 
			conn.execute("Insert into Menu(MenuName,Url,Sort)values('"&request("MenuName")&"','"&request("Url")&"',"&request("Sort")&")")
	   case "c"
			conn.execute("Delete From Menu where id="&request("id")&"")
	End Select
	
	'更新顶部菜单
	Dim Html,FolderPath,Fso,ObjFso
	set rs=conn.execute("select * from Menu where Sort=1")
	Html=Html+"<TABLE border=0 cellPadding=0 cellSpacing=0>"&vbcrlf&" <TR align=middle height=18>"&vbcrlf&" "
	do until rs.eof
		Html=Html+" <TD align=center> <A onfocus=blur() href="&rs("Url")&">"&rs("MenuName")&"</A></TD>"&vbcrlf&" "
	rs.movenext             
	loop
	rs.close  
	set rs=nothing
	Html=Html+"</TR>"&vbcrlf&"</TABLE>"
	
	Set Fso = Server.CreateObject("Scripting.FileSystemObject")
	FolderPath = Server.MapPath("../../")
	Set ObjFso = Fso.CreateTextFile(FolderPath&"\Html\MenuHead.htm")
	ObjFso.WriteLine Html
	Html=""
	ObjFso.close
	set ObjFso = nothing
	'更新底部菜单
	set rs=conn.execute("select * from Menu where Sort=2")
	Html=Html+"<TABLE align=center border=0 cellPadding=0 cellSpacing=0>"&vbcrlf&" <TR align=middle height=18>"&vbcrlf&" "
	do until rs.eof
		Html=Html+" <TD align=center> <A onfocus=blur() href="&rs("Url")&"><Font color=#FFFFFF  size=2>"&rs("MenuName")&"</FONT></A></TD>"&vbcrlf&" "
	rs.movenext             
	loop
	rs.close  
	set rs=nothing
	Html=Html+"</TR>"&vbcrlf&"</TABLE>"
	
	Set Fso = Server.CreateObject("Scripting.FileSystemObject")
	FolderPath = Server.MapPath("../../")
	Set ObjFso = Fso.CreateTextFile(FolderPath&"\Html\MenuFoot.htm")
	ObjFso.WriteLine Html
	Html=""
	ObjFso.close
	set ObjFso = nothing

	Response.redirect "Menu.asp"
End If
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -