📄 sys_addclienttyp.asp

📁 直接解压即可都是asp源码超经典的啊
💻 ASP
字号:
<!--#include file="conn.asp"-->
<% 
id=session("userid")
username=session("username")
if id="" or username="" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from adminuser where username='"& username &"' and id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>

<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
<link href="style.css" rel="stylesheet" type="text/css">
<% 
if request.querystring("cmd")="add" then
clienttyp=request.form("clienttyp")
linkurl=request.form("linkurl")
set rs=server.createobject("adodb.recordset")
sql="select * from clienttyp"
rs.open sql,conn,3,3
rs.addnew
rs("clienttyp")=clienttyp
rs("linkurl")=linkurl
rs.update
response.redirect "sys_addclienttyp.asp"
end if
if request.querystring("cmd")="del" then
set rs=server.createobject("adodb.recordset")
sql="select * from clienttyp where id="& request.querystring("id") &""
rs.open sql,conn,3,3
rs.delete
response.redirect "sys_addclienttyp.asp"
end if
if request.querystring("cmd")="up" then
clienttyp=request.form("clienttyp")
linkurl=request.form("linkurl")
set rs=server.createobject("adodb.recordset")
sql="select * from clienttyp where id="& request.querystring("id") &""
rs.open sql,conn,3,3
rs("clienttyp")=clienttyp
rs("linkurl")=linkurl
rs.update
response.redirect "sys_addclienttyp.asp"
end if 
%>

<body bgcolor="#FFFFFF" text="#000000" style="background-color: #D6DFF7">
<div align="center">
  <center>
<table width="98%" border="1" cellpadding="5" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
  <tr bordercolor="#FFFFFF"> 
    <td width="25%"><div align="center"><a href="sys_addaffiche.asp">首页公告管理</a></div></td>
    <td width="25%"><div align="center"><a href="sys_addbank.asp">付款事项管理</a></div></td>
    <td width="25%"><div align="center"><a href="sys_adddownload.asp">常用软件管理</a></div></td>
    <td width="25%"><div align="center"><a href="sys_addproblemtyp.asp">常见问题管理</a></div></td>
  </tr>
</table>
  </center>
</div>
<br>
<div align="center">
  <center>
<table width="98%" border="1" cellspacing="0" cellpadding="5" bordercolor="#6687BA" style="border-collapse: collapse">
  <form name="form" method="post" action="sys_addclienttyp.asp?cmd=add">
  <tr>
      <td colspan="2" background="images/admin/admin_bg_1.gif"> 
        <div align="center" class="f1" >客 户 中 心 栏 目 添 加</div>
    </td>
  </tr>
  <tr>
      <td bordercolor="#D6DFF7"> 
        <div align="center">&nbsp;栏目名称：  
          <input name="clienttyp" type="text" id="clienttyp" size="20"></td>
            <td bordercolor="#D6DFF7">链接地址：  
          <input name="linkurl" type="text" id="linkurl" size="20"></td>

        </div>
    </td>
  </tr>
  <tr>
      <td bordercolor="#D6DFF7" colspan="2"> 
        <div align="center">
        <input type="submit" name="Submit" value="提交">
        <input type="reset" name="Submit2" value="重写">
      </div>
    </td>
  </tr>
  </form>
</table>
  </center>
</div>
<br>
<%
myself=request.servervariables("path_info")
set rs=server.createobject("adodb.recordset")
sql="select * from clienttyp order by id desc"
rs.open sql,conn,3,3
if rs.eof then 
response.write"<div align=center> 暂 时 没 有 客 户 栏 目</div>"
else
 rs.Pagesize=8
page=clng(request("page"))

if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page%>
<br>
<div align="center">
  <center>
<table width="90%" border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  <tr> 
    <form action=<%=myself%> method=get>
      <td> 
        <%
if page<>1 then %>
        <div align="center"><a href=<%=myself%>?page=1>第一页</a> 
          <a href=<%=myself%>?page=<%=(page-1)%>>上一页</a>  
          <% 
end if
if page<>rs.pagecount then
%>
          <a href=<%=myself%>?page=<%=(page+1)%>>下一页</a>  
          <a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a>  
          <% end if %> 
          <font style="font-size:9pt">&nbsp;输入页次:</font>  
          <input type=text name=page22 size=3 class="border"> 
          <font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div> 
      </td>
    </form>
  </tr>
  </table>
  </center>
</div>
<br>
<div align="center">
  <center>
<table width="98%" border="1" cellpadding="5" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
  <tr> 
    <td height="17" background="images/admin/admin_bg_1.gif"> 
      <div align="center" class="f1" >客 户 中 心 栏 目 修 改</div> 
    </td>
  </tr>
  <tr>
    <td height="17"> 
      <% i=1
	  do while not rs.eof%>
      <table width="100%" border="0" align="center">
        <form name="form" method="post" action="sys_addclienttyp.asp?cmd=up&id=<%=rs("id")%>">
          <tr> 
            <td> <div align="center"><span class="f1">栏目名称：</span> 
                <input name="clienttyp" type="text" id="clienttyp" value="<%=rs("clienttyp")%>" size="20"></td> 
                <td>
              链接地址：  
                <input name="linkurl" type="text" id="linkurl" value="<%=rs("linkurl")%>" size="20"></td>
              </div></td>
            <td bgcolor="#EAF1FB" width="60"> <div align="center">&nbsp;&nbsp;<a href="sys_addclienttyp.asp?cmd=del&id=<%=rs("id")%>"><font color="#FF0000">删  
                除</font></a></div></td>
            <td bgcolor="#EAF1FB" width="60"><div align="center">
                <input type="submit" name="Submit3" value="修改">
              </div></td>
          </tr>
        </form>
        <% i=i+1
		  if i>8 then exit do
          RS.MoveNext
          Loop
          rs.close
         %>
      </table>
    </td>
  </tr>
</table>
  </center>
</div>
<% end if %>
</body>
</html>
<%
set rs=nothing
end if
%>
<% set conn=nothing %>
⌨️ 快捷键说明

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