📄 public_admin.asp

📁 ASP网页
💻 ASP
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0
if Session("userqx")="1" or Session("userqx")="9" then
else
	Response.Redirect "../warn.asp"
end if
%>
<!-- #include file="../dsn.asp" -->
<%
htmltitle=Request.QueryString("title")
tablename=Request.QueryString("tablename")
code=Request.QueryString("keyno")
pageno=Request.QueryString("pageno")

htmlname="public_admin.asp?title="+htmltitle+"&tablename="+tablename
addhtml="public_edit.asp?title="+htmltitle+"&tablename="+tablename+"&pageno="+pageno

set cn=server.CreateObject("ADODB.Connection")
cn.Open mycnstr
set rs=server.CreateObject("ADODB.Recordset")

if code<>"" then
	sqltext="delete from "+tablename+" where classcode='"+code+"'"
	cn.Execute(sqltext)
end if 
%>
<html>
<head>
<title><%=htmltitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000000; font-family: 宋体}
td {font-size: 12px; color: #000000; font-family: 宋体;line-height:130%}
.t1 {font:12px 宋体;color=000000} 
.t2 {font:12px 宋体;color:ffffff} 
.t3 {font:12px 宋体;color:336699} 
.t4 {font:12px 宋体;color:ff0000} 

.bt1 {font:14px 宋体;color=000000} 
.bt2 {font:12px 宋体;color:ffffff} 
.bt3 {font:14px 宋体;color:336699} 
.bt4 {font:14px 宋体;color:ff0000} 
.bt5 {font:14px 宋体;color:0000ff}
.bt10 {font:14px 宋体;color:0000ff}

.td1 {font-size:12px;background-color:#3388bb;color:#ffffff}
.td2 {font-size:12px;background-color:#ffffff;color:#000000;}

A:link {color: #000077}
A:visited {color: #000077}
A:hover {color: #ff0000}

A.r:link {color: #000077}
A.r:visited {color: #000077}
A.r:hover {color: #ff6600}

-->
</style>
</head>
<body topmargin=5 leftmargin=5 bgcolor=#ffffff>
<table width="100%" align=center border="0" cellspacing="0" cellpadding="0">
	<tr><td align="left">
		<table width="100%" border="0" cellspacing="0" cellpadding="0"  height=18>
			<tr>
				<td><font color="navy" style="font-size:14px"><b><%=htmltitle%></b></font></td>
			</tr>
		</table>
	</td></tr>
	<tr><td>		
		<table width="100%" border="0">
			<tr>
	<%
		sqltext="select classcode,sortnum,classname from "+tablename+" order by sortnum"
		rs.Open sqltext,cn,1,1

		listcs=30
		rs.PageSize=listcs
		if pageno="" then 
			pageno=1
		else
			pageno=cint(pageno)	
		end if	
		if rs.PageCount>0 then rs.AbsolutePage=pageno
	%>
			<td class=t1 align="left" width=200>
				<a href="Javascript:window.location.reload()">[刷新列表]</a>
				<a href="<%=addhtml%>">[增加]</a></td>
			<td  align="right">
		<%if rs.PageCount>1 then%>
			[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]		              
			<%if pageno>1 then%>
				<a class=r href="<%=htmlname%>&pageno=1">[首页]</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>              
			<%end if              
			if pageno<rs.PageCount then%>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>              
			<%end if%>              
		<%end if              
		%>              
			</td>
			</tr>
			</table>
	</td></tr>
	<tr><td>
		<table width="100%" border="0" cellspacing="1" cellpadding="1" style="font-size:14.5px;line-height:100%">
			<tr bgcolor="336699" style="color:#ffffff" align="center">
				<td class=bt2>删除</td><td class=bt2>序号</td><td class=bt2>代码</td><td class=bt2>名称</td>
			</tr>
		<%
		i=0
		do while not rs.EOF and i<listcs 
			if (i mod 2)=1 then
				Response.Write("<tr bgcolor=fefefe>")
			else
				Response.Write("<tr bgcolor=efefef>")
			end if	
		%>
			<td onclick="delrec('<%=rs(0)%>','<%=trim(rs(2))%>')" width="35" align="center"><img src="delete.gif"></td>
			<td width="60" align="center"><%=rs(1)%></td>
			<td width="60" align="center"><%=trim(rs(0))%></td>
			<td align="left"><a href="<%=addhtml%>&keyno=<%=rs(0)%>"><%=trim(rs(2))%></td>
			</tr>
		<%	
			i=i+1
			rs.MoveNext
		loop
		%>
		 </table>
	</td></tr>
	<%if rs.PageCount>1 then%>
	<tr><td>
		<table width="100%" cellspacing="0" cellpadding="0" border=0> 
		<tr><td bgcolor="336699">
			<tr><td align=right>
			[第<b><%=pageno%></b>页, 共<b><%=rs.PageCount%></b>页<b><%=rs.RecordCount%></b>条记录]			
			<%if pageno>1 then%>
				<a class=r href="<%=htmlname%>&pageno=1">[首页]</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno-1%>">[上页]</a>              
			<%end if              
			if pageno<rs.PageCount then%>              
				<a class=r href="<%=htmlname%>&pageno=<%=pageno+1%>">[下页]</a>              
				<a class=r href="<%=htmlname%>&pageno=<%=rs.PageCount%>">[末页]</a>              
			<%end if%>              
			</td></tr>              
		</table>
	</td></tr>
	<%end if%>              
</table>
</body>
</html>

<script language="Javascript">

	function delrec(code,topic)
	{
		if (confirm('您确认要删除('+topic+')吗？')==true)
		{
		window.location.href="<%=htmlname%>&keyno="+code+"&pageno=<%=pageno%>" 
		}
	}
	
</script>
⌨️ 快捷键说明

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