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

📄 addsort.asp

📁 ASP+ACCESS 产品报价系统 开发环境简单 主要是周杰伦FANs的交互活动
💻 ASP
字号:
<%
if session("admin_name")="" then response.end
%>
<!--#include file="conn.asp"--><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href=../css.css rel=STYLESHEET type=text/css>
<link href="../img/style.css" rel="stylesheet" type="text/css">
<title>网上手机销售系统</title></head>
<%
    sql="select * from sort"
    set rs=server.createobject("adodb.recordset")
    rs.open sql,conn,3,3
%>


<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form method="POST" action="addsort1.asp">
  <input type="hidden" name="options2" value>
  <table width="373" height="111" border="0" cellpadding="3" cellspacing="1" bgcolor="#378d02">
    <tr bgcolor="#99cc00"> 
      <td height="19" colspan="2"> 
        <div align="center"><b>主栏目管理</b></div></td>
    </tr>
    <tr> 
      <td width="70" bgcolor="#eef7ee"> 
        <div align="right"><font color="#FF0000">类别:</font></div></td>
      <td width="281" bgcolor="#eef7ee"> 
        <p align="left"> 
          <select name="select" size="1" class="beizhu"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 type="submit" value="删除" name="B22" onclick="form.options.value='del'" >
      </td>
    </tr>
    <tr align="center" bgcolor="#FFFFFF"> 
      <td> 
        <div align="right"><font color="#FF0000">新名字:</font></div></td>
      <td> 
        <p align="left"> 
          <input type="text" name="reTitle2" size="15" class=biaodan>
          <input name="B12" type="submit" class="tijiao" onclick="form.options.value='rename'" value="改名">
        
      </td>
    </tr>
    <tr align="center"> 
      <td bgcolor="#eef7ee"> 
        <div align="right"><font color="#FF0000">新类别:</font></div></td>
      <td bgcolor="#eef7ee"> 
        <p align="left"> 
          <input type="text" name="newTitle2" size="15" class=biaodan>
          <input name="B32" type="submit" class="tijiao" onclick="form.options.value='new'" value="新增">
      </td>
    </tr>
  </table>
</form>
<%

set rs=nothing

%>


<% set rs2=server.createobject("adodb.recordset")
   sql2="select * from Nsort order by Nsort_id"
   rs2.open sql2,conn,1,1
%>
<form method="POST" action="addsort2.asp">
  <input type="hidden" name="options" value>
  <table width="374" height="145" border="0" cellpadding="3" cellspacing="1" bgcolor="#378d02">
    <tr bgcolor="#99cc00"> 
      <td colspan="2" align="center"><b>子栏目管理</b></td>
    </tr>
    <tr> 
      <td width="72" bgcolor="#eef7ee"> 
        <div align="right"><font color="#FF0000">子专题:</font></div></td>
      <td width="313" bgcolor="#eef7ee"> 
        <p align="left"> 
          <select name="subject" size="1" class="beizhu" 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="B2" type="submit" class="tijiao" onclick="form.options.value='del'" value="删除">
      </td>
    </tr>
    <% set rs=server.createobject("adodb.recordset")
   sql="select * from sort order by sort_id"
   rs.open sql,conn,1,1
%>
    <tr align="center" bgcolor="#FFFFFF"> 
      <td> 
        <div align="right"><font color="#FF0000">专题修改:</font></div></td>
      <td bgcolor="#FFFFFF"> 
        <p align="left"> 
          <input type="text" name="reTitle" size="15"  class=biaodan>
          <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="B1" type="submit" class="tijiao" onclick="form.options.value='rename'" value="改名">
          <br>
          <br>
          <font color="#666666">(请选择上方相应子类别,然后输入新名字和选择类别) </font></td>
    </tr>
    <tr align="center"> 
      <td bgcolor="#eef7ee"> 
        <div align="right"><font color="#FF0000">新专题:</font></div></td>
      <td bgcolor="#eef7ee"> 
        <p align="left"> 
          <input type="text" name="newTitle" size="15"  class=biaodan>
          <select name="psubject" size="1" class="body"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="B3" type="submit" class="tijiao" onclick="form.options.value='new'" value="新增">
      </td>
    </tr>
  </table>
</form>

⌨️ 快捷键说明

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