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

📄 small_sort.asp

📁 后台管理系统
💻 ASP
字号:
<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<title>爱斯特淋浴设备有限公司管理后台</title>
<link href="../file/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../js/validator.js"></script>
<style type="text/css">
<!--
.STYLE4 {color: #394351}
-->
</style>
</head>

<body>
<table width="100%"  border="0" cellpadding="0" cellspacing="0">
  
  <tr>
    <td align="center"><table width="100%"  border="0" cellpadding="0" cellspacing="0" bgcolor="#B5BCC7">
      <tr align="center" bgcolor="#FFFFFF">
        <td width="200" valign="top" bgcolor="#B5BCC7"><table width="179"  border="0" cellpadding="2" cellspacing="1" class="TableBorder">
          <tr align="center" bgcolor="#F0F0F0">
            <th width="204" height="31" >产品大类管理</th>
          </tr>
          <tr align="center">
            <td height="25" align="center" valign="top" bgcolor="#eeeee6" class="STYLE4"><% set rs=server.createobject("adodb.recordset")
sql="select * from product_sort order by sx asc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
response.Write("暂无产品分类")
end if
 %>
                    <table width="170"  border="0" cellpadding="0" cellspacing="0">
                      <% do while not rs.eof %>
                      <tr align="center" >
                        <td width="25" height="22" align="center" ><img src="../img/leftarror.gif" width="15" height="20"></td>
                        <td width="152" align="left"><a href="?big_sortid=<%= rs("id") %>&sort=<%= rs("sort") %>"><%= rs("sort") %></a></td>
                      </tr>
                      <% rs.movenext
					loop
					'rs.close
					'set rs=nothing %>
                  </table></td>
          </tr>
        </table>
              <span class="STYLE4"><br>
          </span></td>
        <td align="left" valign="top" bgcolor="#B5BCC7"><% if request.QueryString("big_sortid")<>"" then %>
              <table cellpadding="2" cellspacing="1" border="0" width="96%" class="tableBorder" align=center>
                <tr bgcolor="#f0f0f0">
                  <th height="25" colspan="6"><strong>添加<font color="#FF0000">[<%= request.QueryString("sort") %>]</font>产品小类</strong></th>
                </tr>
                <form name="form1" method="post" action="save_small_sort.asp?action=add" onSubmit="return Validator.Validate(this,2)">
                  <input name="big_sort" type="hidden" id="big_sort" value="<%= request.QueryString("sort") %>">
                  <tr bgcolor="#FFFFFF">
                    <td height="25" align="left" class="TableRow2">   类别名称</td>
                    <td align="left" class="TableRow2">   小类排序</td>
                    <td align="left" class="TableRow2">  图片宽度</td>
                    <td align="left" class="TableRow2">  图片高度</td>
                    <td align="center" class="TableRow2">确定操作</td>
                    <td width="35" align="center" class="TableRow2">&nbsp;</td>
                  </tr>
                  <tr bgcolor="#FFFFFF">
                    <td width="146" height="25" align="center" class="TableRow2"><input name="big_sortid" type="hidden" id="big_sortid" value="<%= request.QueryString("big_sortid") %>">
                        <input name="sort" type="text" class="form2" id="sort" dataType="Require"  msg="请填写产品类别名称!"></td>
                    <td width="126" align="center" class="TableRow2"><input name="sx" type="text" class="form2" id="sx" size="15" dataType="Number"  msg="请填写产品类别排列序号(必须为数字)!"></td>
                    <td width="100" align="center" class="TableRow2"><input name="sort_width" type="text" class="form2" id="sort_width" size="8" dataType="Number"  msg="请填写图片的宽度(必须为数字)!"></td>
                    <td width="100" align="center" class="TableRow2"><input name="sort_height" type="text" class="form2" id="sort_height" size="8" dataType="Number"  msg="请填写图片的高度(必须为数字)!"></td>
                    <td width="77" align="center" class="TableRow2"><input type="submit" name="Submit" value=" 添 加 "></td>
                    <td align="center" class="TableRow2">&nbsp;</td>
                  </tr>
                </form>
            </table>
          <% End If %>
              <br>
              <% if request.QueryString("big_sortid")="" then
			%>
              <table width="242" border="0" cellpadding="0" cellspacing="1" bgcolor="#335ea8">
                <tr>
                  <td width="281" height="25" align="center" class="TableRow2">请选择左边产品大类进行管理操作!</td>
                </tr>
              </table>
          <%
			response.end
			end if
			 %>
              <%  set rs=server.CreateObject("adodb.recordset")
sql="select * from product_small_sort where big_sortid="&request.QueryString("big_sortid")&" order by sx asc" 
rs.open sql,conn,1,1        
 %>
              <!--#include file="../page1.asp"-->
              <table cellpadding="2" cellspacing="1" border="0" width="96%" class="tableBorder" align=center>
                <tr bgcolor="#f0f0f0">
                  <th height="25" colspan="6"  bgcolor="#E8F1FF"><strong><font color="#FF0000">[<%= request.QueryString("sort") %>]</font>小类管理</strong></th>
                </tr>
                <tr align="center" bgcolor="#FFFFFF">
                  <td width="146" height="25" align="left" class="BodyTitle">  类别名称</td>
                  <td width="50" align="center" class="BodyTitle">排列</td>
                  <td width="100" class="BodyTitle">图片宽度</td>
                  <td width="100" class="BodyTitle">图片高度</td>
                  <td width="60"  class="BodyTitle"">修改</td>
                  <td class="BodyTitle">删除</td>
                </tr>
                <% for i=1 to x %>
                <form name="form1" method="post" action="save_small_sort.asp?action=save" onSubmit="return Validator.Validate(this,2)">
                  <input type="hidden" name="big_sortid" value="<%=request.QueryString("big_sortid")%>">
                  <input name="big_sort" type="hidden" id="big_sort" value="<%= request.QueryString("sort") %>">
                  <tr bgcolor="#FFFFFF">
                    <td height="25" width="146" align="center" class="TableRow2"><input name="delid" type="hidden" id="delid" value="<%= rs("id") %>">
                    <input name="sort" type="text" class="form2" id="sort" value="<%=rs("sort")%>" dataType="Require"  msg="请填写产品类别名称!"></td>
                    <td width="50" align="center" class="TableRow2"><input name="sx" type="text" class="form2" id="sx" value="<%=rs("sx")%>" size="4" dataType="Number"  msg="请填写产品类别排列序号(必须为数字)!"></td>
                    <td width="100" align="center" class="TableRow2"><input name="sort_width" type="text" class="form2" id="sort_width" value="<%=rs("sort_width")%>" size="8" dataType="Number"  msg="请填写产品类别排列序号(必须为数字)!"></td>
                    <td width="100" align="center" class="TableRow2"><input name="sort_height" type="text" class="form2" id="sort_height" value="<%=rs("sort_height")%>" size="8" dataType="Number"  msg="请填写产品类别排列序号(必须为数字)!"></td>
                    <td width="20" align="center" class="TableRow2"><input type="submit" name="Submit2" value=" 修 改 "></td>
                    <td align="center" class="TableRow2"><a href="save_small_sort.asp?id=<%=rs("id")%>&action=delete&big_sortid=<%=request.QueryString("big_sortid")%>&big_sort=<%=request.QueryString("sort")%>" onClick="return confirm('您确定要删除吗?删除类别的同时也删除该类别所属的全部产品信息!');">删除</a></td>
                  </tr>
                </form>
                <%rs.movenext
			next %>
                <tr align="center" bgcolor="#F0F0F0">
                  <td height="25" colspan="6" align="left" bgcolor="#FFFFFF" class="TableRow2"><!--#include file="../page2.asp"--></td>
                </tr>
              </table>
          <br>        </td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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