bs_class.asp

好用的管理,代码程序 好用的管理,代码程序

<!--#include file="config.asp"-->
<!--#include file="Inc/Ubbcode.asp"-->
<!--#include file="Inc/Function.asp"-->
<!--#include file="Conn.asp"-->
<%
dim sql,rsBigClass,rsSmallClass
set rsBigClass=server.CreateObject("adodb.recordset")
rsBigClass.open "Select * from Bs_PrBigClass",conn,1,3
%>

<script language="JavaScript" type="text/javascript">
function checkBig()
{
  if (document.form1.BigClassName.value=="")
  {
    alert("大类名称不能为空！");
    document.form1.BigClassName.focus();
    return false;
  }
}
function checkSmall()
{
  if (document.form2.BigClassName.value=="")
  {
    alert("请先添加大类名称！");
	document.form1.BigClassName.focus();
	return false;
  }

  if (document.form2.SmallClassName.value=="")
  {
    alert("小类名称不能为空！");
	document.form2.SmallClassName.focus();
	return false;
  }
}
function ConfirmDelBig()
{
   if(confirm("确定要删除此大类吗？删除此大类同时将删除所包含的小类，并且不能恢复！"))
     return true;
   else
     return false;
	 
}

function ConfirmDelSmall()
{
   if(confirm("确定要删除此小类吗？一旦删除将不能恢复！"))
     return true;
   else
     return false;
	 
}
</script>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
<!-- #include file="Inc/Head.asp" -->
<br />
<table cellpadding="2" cellspacing="1" border="0" width="90%" align="center" class="a2">
	<tr>
		<td class="a1" height="25" align="center"><strong>产 品 类 别 设 置</strong></td>
	</tr>
	<tr class="a4">
		<td align="center">管理选项：<a href="Bs_Class_Add_Big.asp" class="STYLE1">添加产品大类</a><br />
      <table width="100%" border="0" cellpadding="2" cellspacing="1" >
        <tr bgcolor="#CCCCCC" class="title"> 
          <td width="76%" height="25" align="center"><strong>产 品 名 称</strong></td>
          <td width="24%" height="20" align="center" bgcolor="#CCCCCC"><strong>操 作 选 项</strong></td>
        </tr>
<%
do while not rsBigClass.eof
%>
        <tr bgcolor="#F0F0F0" class="tdbg"> 
          <td height="22" bgcolor="#F0F0F0"><img src="Img/tree_folder4.gif" width="15" height="15" /><%=rsBigClass("BigClassName")%></td>
          <td align="center" bgcolor="#F0F0F0"><a href="Bs_Class_Add_Small.asp?BigClassName=<%=rsBigClass("BigClassName")%>">添加子栏目</a> 
            | <a href="Bs_Class_Big_edit.asp?BigClassID=<%=rsBigClass("BigClassID")%>">修改</a> 
            | <a href="Bs_Class_Del_Big.asp?BigClassName=<%=rsBigClass("BigClassName")%>" onClick="return ConfirmDelBig();">删除</a></td>
        </tr>
<%
set rsSmallClass=server.CreateObject("adodb.recordset")
rsSmallClass.open "Select * from Bs_PrSmallClass Where BigClassName='" & rsBigClass("BigClassName") & "'",conn,1,3
if not(rsSmallClass.bof and rsSmallClass.eof) then
do while not rsSmallClass.eof
%>
        <tr bgcolor="#F0F0F0" class="tdbg"> 
          <td height="22">&nbsp;&nbsp;<img src="Img/tree_folder3.gif" width="15" height="15" /><%=rsSmallClass("SmallClassName")%></td>
          <td align="center">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
            <a href="Bs_Class_Small_edit.asp?SmallClassID=<%=rsSmallClass("SmallClassID")%>">修改</a> 
            | <a href="Bs_Class_Del_Small.asp?SmallClassID=<%=rsSmallClass("SmallClassID")%>" onClick="return ConfirmDelSmall();">删除</a></td>
        </tr>
<%
rsSmallClass.movenext
loop
end if
rsSmallClass.close
set rsSmallClass=nothing	
rsBigClass.movenext
loop
%>
      </table>
      <br />
	  </td>
	</tr>
</table>
<br />
<%
rsBigClass.close
set rsBigClass=nothing
call CloseConn()
%>
<%response.end%>