📄 banner.asp
字号:
<%
'设计：潘树文
'开发时间：2001.12
%>
<!--#include file="../include/odbc.asp" -->
<!--#include file="../include/killStr.asp" -->
<!--#include file="../include/checkUser.asp" -->
<!--#include file="../include/checkServer.asp" -->
<%set rs=server.CreateObject("adodb.recordset")
sql="select * from news2_commend where menuid='"&request("menuid")&"' order by infoindex "
rs.open sql,conn,3,3%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Qinhp NetModel Generator">
<link rel="stylesheet" href="../script/style.css" type="text/css">
<title>新闻推荐表管理</title>
<base target=_self>
<script language='JavaScript'>
function check(form1){
if (isNaN(form1.webnum.value))
{alert('WEB上条目必须是数字!');
form1.webnum.focus();
form1.webnum.select();
return (false);
}
if (form1.webnum.value<1)
{alert('WEB上条目必须大于1!');
form1.webnum.focus();
form1.webnum.select();
return (false);
}
}
</script>
</head>
<%
if trim(request("submit"))<>"" then
nwebcount=clng(request("webnum"))
rsRecordCount=rs.RecordCount
'***********************
set rs2=server.CreateObject("adodb.recordset")
sqll="select * from news2_commend order by commendid desc"
'**********************
if rsRecordCount<nwebcount then
for i=1 to nwebcount-rsRecordCount
rs2.open sqll,conn,3,3
rs.AddNew
if rs2.eof then
tempno=1
else
tempno=clng(rs2("commendid"))+1
end if
rs2.close
this1Id=right("00000000000000000000"&cstr(tempno),10)
rs("commendId")= this1Id
rs("menuid")=trim(request("menuid"))
rs("infoid")="0000000000"
rs("newstitle")="新增加文章标题"
rs("infoindex")=rsRecordCount+i
rs("visible")="0"
rs("hot")="0"
rs("regtime")=now()
rs.Update
next
else
' Response.Write
sqqq="delete from news2_commend where menuid='"&trim(request("menuid"))&"' and infoindex >"&cstr(nwebcount)
conn.execute sqqq
end if
end if
rs.Close
rs.open sql,conn,3,3
%>
<body bgcolor="#DDDDDD"><p align=center><b><font size=4 color=#0000FF>新闻推荐表</font></b></p>
<form method=POST action=<%=request.servervariables("path_info")%> name=add onsubmit="return check(this);">
<table width="100%">
<%'显示推荐新闻
for i2=1 to rs.RecordCount %>
<tr><td width='70%'><%=i2%> <%=rs("newstitle")%></td>
<td width='15%'><a href="srch.asp?menuid=<%=request("menuid")%>&commendid=<%=rs("commendid")%>" target="right">更新</A> </td>
<% if rs("visible")<>"0" then%>
<td width='15%'><a href="view.asp?menuid=<%=request("menuid")%>&commendid=<%=rs("commendid")%>" target="right">查看</A></td></tr>
<%end if
rs.MoveNext
next
%>
</table><table>
<tr><td> </td></tr>
<tr>
<td>WEB条目:
<input type=Text name=webnum size=3 value=<%=rs.RecordCount%> maxLength=2> <input type=submit name=submit value="修改">
</td><td><input type=button name=刷新 value="刷新" onclick="javascript:location.reload();"></td></tr></table>
<input type=hidden name=menuid value=<%=request("menuid")%> >
</form>
<p>[<a href=../user/loginProcess.asp target=_top>返回</a>][<a href=../user/logout.asp target=_top>退出</a>]</p></body></html>
<%rs.Close
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -