www.gusucode.com > 艺帆全站DIV+CSS体育用品公司网站源码 1.7.5源码程序 > i5808/admin_link_txt.asp
<!--#include file="../Conn.asp" --> <!--#include file="seeion.asp"--> <!--#include file="page.asp" --> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" id="css" href="images/style.css"> <title>文字链接管理</title> </head> <body> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" > <tr> <td height="30" background="images/bg_list.gif"><div style="padding-left:10px; font-weight:bold; color:#0075a9">文字链接管理</div></td> </tr> <tr> <td height="35" bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td bgcolor="#FFFFFF"><% set rs=server.createobject("adodb.recordset") exec="select * from link where lx=1 order by px_id asc" rs.open exec,conn,1,1 if rs.eof then response.Write " 暂无信息!" else rs.PageSize =500 '每页记录条数 iCount=rs.RecordCount '记录总数 iPageSize=rs.PageSize maxpage=rs.PageCount page=request("page") if Not IsNumeric(page) or page="" then page=1 else page=cint(page) end if if page<1 then page=1 elseif page>maxpage then page=maxpage end if rs.AbsolutePage=Page if page=maxpage then x=iCount-(maxpage-1)*iPageSize else x=iPageSize end if %> <% for i=1 to rs.pagesize j=i if j mod 2=0 then bg="#F1F5F8" else bg="#FFFFFF" end if %> </td> </tr> <tr onmouseover="style.backgroundColor='#EEEEEE'" onmouseout="style.backgroundColor='<%=bg%>'" bgcolor="<%=bg%>"> <td colspan="2"><table width="100%" border="0" cellpadding="5" cellspacing="0"> <form action="?xiugai=ok" method="post" name="add"> <tr> <td width="11%" class="td">ID:<%=rs("id")%><input name="id" type="hidden" id="id" value="<%=rs("id")%>" /></td> <td width="26%" height="25" class="td"><input name="title" type="text" value="<%=rs("title")%>" size="18" /></td> <td width="29%" class="td"><input name="url" type="text" value="<%=rs("url")%>" size="25" /></td> <td width="16%" class="td">排序: <input name="px_id" type="text" value="<%=rs("px_id")%>" size="5" /></td> <td width="9%" class="td"><label> <input type="submit" name="button" id="button" value="修改" class="btn"/> </label></td> <td width="9%" class="td"><input type="button" name="Submit" value="删除" onClick="javascript:if(confirm('确定删除?删除后不可恢复!')){window.location.href='?act=del&id=<%=rs("id")%>';}else{history.go(0);}" class="btn"/></td> </tr></form> </table> <% rs.movenext if rs.eof then exit for next %> <% end if %></td> </tr> </table> <table width="100%" border="0" cellpadding="5" cellspacing="0"> <tr> <td bgcolor="#F1F5F8"><%call PageControl(iCount,maxpage,page,"border=0 align=right","<p align=right>") rs.close set rs=nothing %></td> </tr> </table></td> </tr> </table> </body> </html> <% if Request.QueryString("xiugai")="ok" then id=request("id") if id="" then Response.Write "<script language='javascript'>alert('参数错误!');document.location.href('admin_link_txt.asp');</script>" Response.End() end if sql="select * from link where id="&id set rs=server.CreateObject("adodb.recordset") rs.open sql,conn,1,3 IF not isNumeric(request("px_id")) then response.write("<script>alert(""排序ID必须为数字!""); history.go(-1);</script>") response.end end if rs("title")=request.form("title") rs("url")=request.form("url") rs("px_id")=request.form("px_id") rs.update rs.close response.Write("<script language=""javascript"">alert(""修改链接成功!"");window.location.href='admin_link_txt.asp';</script>") end if %> <% if request("act")="del" then id=request("id") if id="" then Response.Write "<script language='javascript'>alert('参数错误!');document.location.href('admin_link_txt.asp');</script>" Response.End() end if set rs=server.createobject("adodb.recordset") rs.open "Select * from Link where id="&Request("id"),conn,1,3 if rs.bof and rs.eof then Response.Write "<script language='javascript'>alert('数据库中没有该记录!');document.location.href('admin_link_txt.asp');</script>" Response.End() else rs.Delete rs.Update Response.Write "<script language='javascript'>alert('删除成功!');document.location.href('admin_link_txt.asp');</script>" end if end if %>