SelectSort.asp
资源名称:1.rar [点击查看]
上传用户:yrf020
上传日期:2007-07-24
资源大小:1287k
文件大小:4k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
HTML/CSS
- <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
- <% Option Explicit %>
- <HTML xmlns="http://www.w3.org/1999/xhtml">
- <HEAD>
- <TITLE>选择分类</TITLE>
- <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
- <META NAME="copyright" CONTENT="Copyright 2006-2008 - Hokilly.com-STUDIO" />
- <META NAME="Author" CONTENT="红金羚软件,www.hokilly.com" />
- <META NAME="Keywords" CONTENT="" />
- <META NAME="Description" CONTENT="" />
- <link rel="stylesheet" href="Images/CssAdmin.css">
- <script language="javascript" src="../Script/Admin.js"></script>
- </HEAD>
- <!--#include file="../Include/Const.asp" -->
- <!--#include file="../Include/ConnSiteData.asp" -->
- <!--#include file="CheckAdmin.asp"-->
- <BODY>
- <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6ab6b6">
- <tr>
- <td height="24" nowrap><A href="#Help"><IMG height="18" alt="使用帮助(Help)" src="Images/Explain.gif" width="18" align="absMiddle" border="0"></A> <font color="#FFFFFF"><strong>选择所属类别:点击'选择'添加</strong></font></td>
- </tr>
- <tr>
- <td height="24" nowrap bgcolor="#eafefe">
- <table width="100%" height="6" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td></td>
- </tr>
- </table>
- <%
- Dim Result,Datafrom
- Result=request.QueryString("Result")
- Select Case Result
- Case "Products"
- Datafrom="CompanyCMS_ProductSort"
- Case "News"
- Datafrom="CompanyCMS_NewsSort"
- Case "Download"
- Datafrom="CompanyCMS_DownSort"
- Case "Others"
- Datafrom="CompanyCMS_OthersSort"
- Case Else
- End Select
- ListSort(0)
- %>
- </td>
- </tr>
- </table>
- </body>
- </html>
- <%
- Function ListSort(id)
- Dim rs,sql,i,ChildCount,FolderType,FolderName,onMouseUp,ListType,ViewFlag
- Set rs=server.CreateObject("adodb.recordset")
- sql="Select * From "&Datafrom&" where ParentID="&id&" order by id"
- rs.open sql,conn,1,1
- if id=0 and rs.recordcount=0 then
- response.write ("暂无分类!")
- response.end
- end if
- i=1
- response.write("<table border='0' cellspacing='0' cellpadding='0'>")
- while not rs.eof
- ChildCount=conn.execute("select count(*) from "&Datafrom&" where ParentID="&rs("id"))(0)
- if rs("ViewFlagEn") then
- ViewFlag=ViewFlag&"<font color='green'>√</font>"
- else
- ViewFlag=ViewFlag&"<font color='red'>×</font>"
- end if
- if ChildCount=0 then
- if i=rs.recordcount then
- FolderType="SortFileEnd"
- else
- FolderType="SortFile"
- end if
- FolderName=rs("SortNameCh")&" "&ViewFlag
- onMouseUp=""
- else
- if i=rs.recordcount then
- FolderType="SortEndFolderClose"
- ListType="SortEndListline"
- onMouseUp="EndSortChange('a"&rs("id")&"','b"&rs("id")&"');"
- else
- FolderType="SortFolderClose"
- ListType="SortListline"
- onMouseUp="SortChange('a"&rs("id")&"','b"&rs("id")&"');"
- end if
- FolderName=rs("SortNameCh")&" "&ViewFlag
- end if
- response.write("<tr>")
- response.write("<td nowrap id='b"&rs("id")&"' class='"&FolderType&"' onMouseUp="&onMouseUp&"></td><td nowrap>"&FolderName&" ")
- response.write("<a href=javaScript:AddSort('"&SortText(rs("ID"))&"','"&rs("ID")&"','"&rs("SortPath")&"')><font color='#ff6600'>选择</font></a>")
- response.write("</td></tr>")
- if ChildCount>0 then
- %>
- <tr id="a<%= rs("id")%>" style="display:yes"><td class="<%= ListType%>" nowrap></td><td ><% ListSort(rs("id")) %></td></tr>
- <%
- end if
- rs.movenext
- i=i+1
- wend
- response.write("</table>")
- rs.close
- set rs=nothing
- end function
- %>
- <%
- '生成所属类别--------------------------
- Function SortText(ID)
- Dim rs,sql
- Set rs=server.CreateObject("adodb.recordset")
- sql="Select * From "&Datafrom&" where ID="&ID
- rs.open sql,conn,1,1
- ' SortText=rs("SortNameCh")
- SortText=rs("ID")
- rs.close
- set rs=nothing
- End Function
- %>
English
