📄 aboutlist.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<% Option Explicit %>
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
<META NAME="copyright" CONTENT="Copyright 2008-2010 - GLGK.COM-STUDIO" />
<META NAME="Author" CONTENT="冠龙科技,www.glgk.com" />
<META NAME="Keywords" CONTENT="" />
<META NAME="Description" CONTENT="" />
<TITLE>企业信息列表</TITLE>
<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"-->
<%
if Instr(session("AdminPurview"),"|12,")=0 then
response.write ("<font color='red')>你不具有该管理模块的操作权限，请返回！</font>")
response.end
end if
'========判断是否具有管理权限
%>
<BODY>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<tr>
<td height="24" nowrap><font color="#FFFFFF"><img src="Images/Explain.gif" width="18" height="18" border="0" align="absmiddle"> <strong>企业信息：添加，修改介绍企业相关的内容</strong></font></td>
</tr>
<tr>
<td height="24" align="center" nowrap bgcolor="#EBF2F9"><a href="AboutEdit.asp?Result=Add" onClick='changeAdminFlag("添加企业信息")'>添加企业信息</a><font color="#0000FF"> | </font><a href="AboutList.asp" onClick='changeAdminFlag("企业信息")'>查看企业信息</a></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<form action="DelContent.asp?Result=About" method="post" name="formDel" >
<tr>
<td width="18" nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>ID</strong></font></td>
<td width="18" height="24" nowrap bgcolor="#8DB5E9"><strong><font color="#FFFFFF">中</font></strong></td>
<td width="18" nowrap bgcolor="#8DB5E9"><strong><font color="#FFFFFF">英</font></strong></td>
<td nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>信息名称</strong></font></td>
<td width="88" nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>查看组别</strong></font></td>
<td width="52" nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>权限方式</strong></font></td>
<td width="52" nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>显示顺序</strong></font></td>
<td width="118" nowrap bgcolor="#8DB5E9"><strong><font color="#FFFFFF"><strong>发布时间</strong></font></strong></td>
<td width="52" nowrap bgcolor="#8DB5E9"><font color="#FFFFFF"><strong>查看次数</strong></font></td>
<td colspan="2" width="76" nowrap bgcolor="#8DB5E9"><strong><font color="#FFFFFF">操作</font></strong>
<input onClick="CheckAll(this.form)" name="buttonAllSelect" type="button" class="button" id="submitAllSearch" value="全" style="HEIGHT: 18px;WIDTH: 16px;">
<input onClick="CheckOthers(this.form)" name="buttonOtherSelect" type="button" class="button" id="submitOtherSelect" value="反" style="HEIGHT: 18px;WIDTH: 16px;"> </td>
</tr>
<%
call AboutList(0)
if conn.execute("select * from About where ParentID=0").eof then
response.write "<tr><td height='50' align='center' colspan='11' nowrap bgcolor='#EBF2F9'>暂无导航栏目</td></tr>"
else
Response.Write "<tr>" & vbCrLf
Response.Write "<td colspan='9' nowrap bgcolor='#EBF2F9'> </td>" & vbCrLf
Response.Write "<td colspan='2' nowrap bgcolor='#EBF2F9'><input name='submitDelSelect' type='button' class='button' id='submitDelSelect' value='删除所选' onClick='ConfirmDel(""您真的要删除这个企业信息及其下属信息吗？"");'></td>" & vbCrLf
Response.Write "</tr>" & vbCrLf
end if
%>
</form>
</table>
<% if request.QueryString("Result")="ModifySequence" then call ModifySequence() %>
<% if request.QueryString("Result")="SaveSequence" then call SaveSequence() %>
</body>
</html>
<%
'-----------------------------------------------------------
function AboutList(ParentID)
dim sql,rs
sql="select * from About where ParentID="&ParentID&" order by Sequence asc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,0,1
while(not rs.eof)'填充数据到表格
Response.Write "<tr bgcolor='#EBF2F9' onMouseOver = ""this.style.backgroundColor = '#FFFFFF'"" onMouseOut = ""this.style.backgroundColor = ''"" style='cursor:hand'>" & vbCrLf
Response.Write "<td nowrap>"&rs("ID")&"</td>" & vbCrLf
if rs("ViewFlagCh") then
Response.Write "<td nowrap><font color='blue'>√</font></td>" & vbCrLf
else
Response.Write "<td nowrap><font color='red'>×</font></td>" & vbCrLf
end if
if rs("ViewFlagEn") then
Response.Write "<td nowrap><font color='blue'>√</font></td>" & vbCrLf
else
Response.Write "<td nowrap><font color='red'>×</font></td>" & vbCrLf
end if
if rs("ParentID")<>0 then
Response.Write "<td nowrap> "&rs("AboutNameCh") &" | "&rs("AboutNameEn")& vbCrLf
if rs("ChildFlag") then Response.Write "<font color='red'>分页</font>" & vbCrLf
Response.Write "</td>" & vbCrLf
else
Response.Write "<td nowrap>"&rs("AboutNameCh")&" | "&rs("AboutNameEn")& vbCrLf
if rs("ChildFlag") then Response.Write "<font color='red'>分页</font>" & vbCrLf
Response.Write "</td>" & vbCrLf
end if
Response.Write "</td>"& vbCrLf
call ViewGroupNameCh(rs("GroupID"))
if rs("Exclusive")=">=" then
Response.Write "<td nowrap><font color='green'>隶属</font></td>" & vbCrLf
else
Response.Write "<td nowrap><font color='red'>专属</font></td>" & vbCrLf
end if
if rs("ParentID")<>0 then
Response.Write "<td nowrap> <font color='blue'>"&rs("Sequence")&"</font></td>"
else
Response.Write "<td nowrap><font color='blue'>"&rs("Sequence")&"</font></td>"
end if
Response.Write "<td nowrap title='创建时间："&rs("AddTime")&"'>"&rs("UpdateTime")&"</td>" & vbCrLf
Response.Write "<td nowrap>"&rs("ClickNumber")&"</td>" & vbCrLf
Response.Write "<td width='60' nowrap><a href='reg.asp' onClick='changeAdminFlag(""修改企业信息"")'><font color='#330099'>修改</font></a>.<a href='reg.asp' onClick='changeAdminFlag(""排序企业信息"")'><font color='#330099'>排序</font></a></td>" & vbCrLf
Response.Write "<td width='14' nowrap><input name='selectID' type='radio' value='"&rs("ID")&"' style='HEIGHT: 13px;WIDTH: 13px;'></td>" & vbCrLf
Response.Write "</tr>" & vbCrLf
call AboutList(rs("ID"))
rs.movenext
wend
end function
%>
<%
sub ViewGroupNameCh(GruopID)
dim rs,sql
set rs = server.createobject("adodb.recordset")
sql="select GroupID,GroupNameCh from MemGroup where GroupID='"&GruopID&"'"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write("<td nowrap>未设组别</td>")
else
response.write("<td nowrap>"&rs("GroupNameCh")&"</td>")
end if
rs.close
set rs=nothing
end sub
%>
<%
sub ModifySequence()
dim rs,sql,ID,AboutNameCh,Sequence
ID=request.QueryString("ID")
set rs = server.createobject("adodb.recordset")
sql="select * from About where ID="& ID
rs.open sql,conn,1,1
AboutNameCh=rs("AboutNameCh")
Sequence=rs("Sequence")
rs.close
set rs=nothing
response.write "<br>"
response.write "<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#6298E1'>"
response.write "<form action='AboutList.asp?Result=SaveSequence' method='post' name='formSequence'>"
response.write "<tr>"
response.write "<td height='24' align='center' nowrap bgcolor='#EBF2F9'>ID：<input name='ID' type='text' class='textfield' style='WIDTH: 30;' value='"&ID&"' maxlength='4' readonly> 企业信息名称：<input name='AboutNameCh' type='text' class='textfield' id='AboutNameCh' style='WIDTH: 180;' value='"&AboutNameCh&"' maxlength='36' readonly> 排序号：<input name='Sequence' type='text' class='textfield' style='WIDTH: 60;' value='"&Sequence&"' maxlength='4' onKeyDown='if(event.keyCode==13)event.returnValue=false' onchange=""if(/\D/.test(this.value)){alert('只能在排序号内输入整数！');this.value='"&Sequence&"';}""> <input name='submitSequence' type='submit' class='button' value='保存' style='WIDTH: 60;' ></td>"
response.write "</tr>"
response.write "</form>"
response.write "</table>"
end sub
sub SaveSequence()
dim rs,sql
set rs = server.createobject("adodb.recordset")
sql="select * from About where ID="& request.form("ID")
rs.open sql,conn,1,3
rs("Sequence")=request.form("Sequence")
rs.update
rs.close
set rs=nothing
response.redirect "AboutList.asp"
end sub
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -