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

📄 class_manage.asp

📁 适用于网络/信息企业
💻 ASP
字号:
<!--#include file="../INC/Conn.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim PartID,RootID,NumberID
PartID  = Request.QueryString("PartID")
RootID  = Request.QueryString("RootID")
NumberID= Request.QueryString("NumberID")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="100%"  border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
        <tr>
          <td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%"  border="0" cellpadding="3" cellspacing="0">
              <tr bgcolor="eeeeee">
                <td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
                <td width="78%"><span class="style2">管理中心 &gt;&gt;&gt; 管理分类 
				<%
				if Request.QueryString("NumberID")<>"" then
				sql="select * from Class where NumberID='"& Request.QueryString("NumberID")&"'"
				set rs=server.createobject("adodb.recordset")
	            rs.open sql,conn,1,1
				if not(rs.bof and rs.eof) then
				response.write "&nbsp;>>>&nbsp;<a href=Class_Manage.asp?RootID="&NumberID&"&PartID="&PartID&"&NumberID="&NumberID&">"&rs("class")&"</a>"
				end if
				rs.close
				end if
				%>
				
				</span></td>
                <td width="17%" align="right">
				<%
 				sql="select * from Class where NumberID='"& PartID &"'"
				set rs=server.createobject("adodb.recordset")
	            rs.open sql,conn,1,1
				if not(rs.bof and rs.eof) then
				response.write "<a href=Class_Manage.asp?RootID="&rs("RootID")&"&PartID="&rs("PartID")&"&NumberID="&rs("NumberID")&"><img src=""Images/back1.gif"" border=""0""></a>"
				end if
				rs.close
				%>
</td>
              </tr>
          </table></td>
        </tr>
    </table></td>
  </tr>
</table>
<table width="98%" height="90%"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
  <tr>
    <td valign="top" bgcolor="ffffff"><table width="100%"  border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td align="center" bgcolor="ffffff">          <table width=100% border=0 align='center' cellpadding=3 cellspacing=1 bordercolordark=#ffffff bgcolor="eaeaea">
            <tr align="left" bgcolor="ffffff" background="Images/box_bg.gif">
              <td width="5%" height="20" background="Images/box_bg.gif" class='color01'>ID</td>
              <td width="27%" height="20" background="Images/box_bg.gif" class='color01'>识别码</td>
              <td width="39%" height="20" background="Images/box_bg.gif" class='color01'>名称</td>
              <td width="11%" height="20" background="Images/box_bg.gif" class='color01'>商品统计</td>
              <td width="18%" height="20" background="Images/box_bg.gif" class='color01'>修改</td>
            </tr>
            <%
if NumberID<>"" then
	sql="select * from Class where PartID='"& NumberID &"' order by Classorder"
else
	sql="select * from Class where LagID=0 order by Classorder"
end if
    set rs=server.createobject("adodb.recordset")
	rs.open sql,conn,1,1
	if not(rs.bof and rs.eof) then
	'==============================page
	rs.PageSize =16
	%>
	<!--#include file="../inc/page.asp"-->
            <tr align="left" bgcolor="ffffff" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#F5F5F5'">
              <td height="24"><%=RS("ID")%></td>
              <td height="24"><%=rs("NumberID")%></td>
              <td height="24"><%=rs("Class")%>
			  <%
				sql="select COUNT(*) as CLASSCOUNT from Class where NumberID like '"&rs("NumberID")&"%' and NumberID<>'"& rs("NumberID") &"'" 
				set rs_COUNT=conn.execute(sql) 
				response.write "<FONT color=cccccc>["&rs_COUNT("CLASSCOUNT")&"]</font>"
			  %>			  </td>
              <td><%=rs("ProductCount")%></td>
              <td height="24"><span class="color01"><a href="Class_Add.asp?RootID=<%=rs("NumberID")%>&PartID=<%=rs("PartID")%>&NumberID=<%=rs("NumberID")%>&ID=<%=rs("ID")%>">修改</a>|<a href="Class_Add.asp?Makking=del&ID=<%=rs("NumberID")%>" onClick="return confirm('您将删除该分类下的所有子分类,您确定要这样操作吗?')">删除</a>|<a href="Class_Manage.asp?RootID=<%=rs("NumberID")%>&PartID=<%=rs("PartID")%>&NumberID=<%=rs("NumberID")%>">下一级</a></span></td>
            </tr>
            <%   
			rs.movenext
			next
			end if
           %>
          </table></td>
        </tr>
    </table>
      <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="50%" height="24" align="left" valign="bottom" background="Images/box_bg_1.gif">
		  <a href="Class_add.asp?RootID=<%=RootID%>&PartID=<%=PartID%>&NumberID=<%=NumberID%>"><img src="Images/add.gif" width="36" height="21" border="0"></a>&nbsp;</td>
          <td width="50%" height="24" align="right" valign="top" background="Images/box_bg_1.gif">
		    <%Page_links="NumberID="&NumberID&"&"
			call PageControl(iCount,maxpage,page)
			rs.close
			set rs=nothing
			Conn.Close
			Set Conn = Nothing
			%></td>
        </tr>
      </table>
	  <table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="1" bgcolor="#E2E1E1"></td>
        </tr>
      </table></td>
  </tr>
</table>
<table width="98%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="6"></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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