admin_down.asp

漂亮的企业网站系统v11 1、整体修改了上一版的一些BUG。 2、修改了页面底部的统计形式。 3、修改了“公告更新”栏目

<tr><td align=center height=300><%
  strsql="select * from down_code where id="&id
  set rs=server.createobject("adodb.recordset")
  rs.open strsql,conn,1,3
  if request("types")="edit" then
    dim name,username,code,remark
    name=code_form(trim(request("name")))
    username=code_form(trim(request("username")))
    code=code_form(trim(request("code")))
    remark=request("remark")
    if name="" or isnull(name) or code="" or isnull(code) then
      response.write("软件名称和注 册 码不能为空！<br><br>"&go_back)
    else
      rs("name")=name
      rs("username")=username
      rs("code")=code
      rs("remark")=remark
      rs.update
      rs.close:set rs=nothing
      response.write("注册码修改成功！<br><br><a href='admin_down.asp?action=code'>点击返回</a>")
      response.write(VbCrLf & "<meta http-equiv='refresh' content='" & time_go & "; url=admin_down.asp?action=code'>")
    end if
else
%>
<table border="0" width="400" cellspacing="0" cellpadding="2">
  <tr><td colspan=2 height=50 align=center><font class=font_color1>注册码属性修改</font></td></tr>
  <form action="?action=code_edit&types=edit&id=<%=id%>" method=post>
  <tr><td>软件名称</td><td><input type=text name=name value='<%=rs("name")%>' size=50 maxlength=100></td></tr>
  <tr><td>注册名称</td><td><input type=text name=username value='<%=rs("username")%>' size=50 maxlength=100></td></tr>
  <tr><td>注 册 码</td><td><input type=text name=code value='<%=rs("code")%>' size=50 maxlength=100></td></tr>
  <tr><td>备注说明</td><td><%response.write("<textarea rows=6 name=remark cols=50>"&rs("remark")&"</textarea>")%></td></tr>
  <tr height=30><td></td><td><input type="submit" value=" 修 改 "></td></tr>
</form></table>
<%  end if%></td></tr><tr></table><%
end sub

sub code_add()
%><table border="0" width="600" cellspacing="0" cellpadding="0">
<tr><td align=center height=300><%
if request("types")="add" then
  dim name,username,code,remark
  name=code_form(trim(request("name")))
  username=code_form(trim(request("username")))
  code=code_form(trim(request("code")))
  remark=request("remark")
  if name="" or isnull(name) or code="" or isnull(code) then
    response.write("软件名称和注 册 码不能为空！<br><br>"&go_back)
  else
    dim rs,strsql
    strsql="select * from down_code where (id is null)"
    set rs=server.createobject("adodb.recordset")
    rs.open strsql,conn,1,3
    rs.addnew
    rs("name")=name
    rs("username")=username
    rs("code")=code
    rs("remark")=remark
    rs.update
    rs.close
    set rs=nothing
    response.write("注册码添加成功！<br><br><a href='admin_down.asp?action=code_add'>点击继续添加</a>")
    response.write(VbCrLf & "<meta http-equiv='refresh' content='" & time_go & "; url=admin_down.asp?action=code_add'>")
  end if
else
%><table border="0" width="400" cellspacing="0" cellpadding="2">
<form action="?action=code_add&types=add" method=post>
  <tr><td colspan=2 height=50 align=center><font class=font_color1>添加新注册码</font></td></tr>
  <tr><td>软件名称</td><td><input type=text name=name size=50 maxlength=100></td></tr>
  <tr><td>注册名称</td><td><input type=text name=username size=50 maxlength=100></td></tr>
  <tr><td>注 册 码</td><td><input type=text name=code size=50 maxlength=100></td></tr>
  <tr><td>备注说明</td><td><textarea rows="6" name=remark cols="50"></textarea></td></tr>
  <tr height=30><td></td><td><input type="submit" value=" 添 加 "></td></tr>
</form></table>
<%  end if%></td></tr></table><%
end sub

sub code_main()
%><table border=0 width='95%' cellspacing=0 cellpadding=2><%
  dim rs,strsql
  sqladd=""
  strsql="select * from down_code " & sqladd & "order by id desc"
  set rs=server.createobject("adodb.recordset")
  rs.open strsql,conn,1,1
  if rs.eof and rs.bof then
    rssum=0
  else
    rssum=rs.recordcount
  end if
  call format_pagecute()
  response.write "<tr><td colspan=3 align=center height=30>共有个 <font class=red>"&rssum&"</font> 注册码  分页:"&jk_pagecute(nummer,thepages,viewpage,pageurl,10,"#ff0000")&"</td></tr>" & _
	         "<tr align=center><td width='10%'>序号</td><td width='75%'>类型和名称</td><td width='15%'>操作</td></tr>"
  if int(viewpage)>1 then
    rs.move (viewpage-1)*nummer
  end if
  for i=1 to nummer
    if rs.eof then exit for
    response.write "<tr align=center><td>"&(viewpage-1)*nummer+i&"</td><td align=left>"&rs("name")&"</td><td><a href='admin_down.asp?action=code_edit&id="&rs("id")&"'>修改</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href='admin_down.asp?action=code_del&id="&rs("id")&"'>删除</a></td></tr>"
    rs.movenext
  next
  rs.close:set rs=nothing
%></table><%
end sub

sub down_main()
%><table border=0 width='100%' cellspacing=0 cellpadding=0>
<tr align=center height=300 valign=top>
<td width='20%' class=htd><br><%call left_sort()%></td>
<td width='80%'>
<table border=1 width='100%' cellspacing=0 cellpadding=1 bordercolorlight=#C0C0C0 bordercolordark=#FFFFFF>
<script language=javascript src='style/admin_del.js'></script>
<form name=del_form action='<%response.write pageurl%>del_ok=ok' method=post><%
  call sql_cid_sid()
  keyword=trim(request.querystring("keyword"))
  if keyword<>"" and not isnull(keyword) then
    if sqladd<>"" then
      sqladd=sqladd&" and name like '%"&keyword&"%' "
    else
      sqladd=sqladd&" where name like '%"&keyword&"%' "
    end if
    pageurl=pageurl&"keyword="&server.urlencode(keyword)&"&"
  end if
  sql="select id,c_id,s_id,name,types,hidden from down"&sqladd&" order by tim desc"
  set rs=server.createobject("adodb.recordset")
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then
    rssum=0
  else
    rssum=int(rs.recordcount)
  end if
  call format_pagecute()
  del_temp=nummer
  if rssum=0 then del_temp=0
  if int(page)=int(thepages) then
    del_temp=rssum-nummer*(thepages-1)
  end if
%>
<tr><td colspan=3 align=center height=25>
现有<font class=red><%response.write rssum%></font>个软件　<%response.write "<a href='?action=add&c_id="&cid&"&s_id="&sid&"'>添加软件</a>"%>
　<input type=checkbox name=del_all value=1 onClick=selectall('<%response.write del_temp%>')> 选中所有　<input type=submit value='删除所选' onclick=""return suredel('<%response.write del_temp%>');"">
</td></tr>
<tr align=center bgcolor=#ffffff><td width='8%'>序号</td><td width='77%'>类型和名称</td><td width='15%'>操作</td></tr>
<%
  if int(viewpage)>1 then
    rs.move (viewpage-1)*nummer
  end if
  for i=1 to nummer
    if rs.eof then exit for
    now_id=rs("id"):nid=int(rs("types")):ncid=rs("c_id"):nsid=rs("s_id")
    response.write vbcrlf&"<tr align=center><td>"&(viewpage-1)*nummer+i&"</td><td align=left><a href='?action=down_edit&id="&now_id&"'>"&rs("name")&"</a></td><td align=right><a href='?action=hidden&c_id="&cid&"&s_id="&sid&"&id="&now_id&"&page="&viewpage&"'>"
    if rs("hidden")=true then
      response.write "显</a> "
    else
      response.write "<font class=red_2>隐</font></a> "
    end if
    response.write "<font class=red>"&nid&"</font>&nbsp;星&nbsp;<input type=checkbox name=del_id value='"&now_id&"'></td></tr>"
    rs.movenext
  next
  rs.close:set rs=nothing
%></form>
<tr><td colspan=3 height=1 bgcolor=#ededede></td></tr>
<tr><td colspan=3 height=25>页次：<font class=red><%response.write viewpage%></font>/<font class=red><%response.write thepages%></font>
分页：<%response.write jk_pagecute(nummer,thepages,viewpage,pageurl,5,"#ff0000")%>
</td></tr>
    <table border=0 align=left>
    <form name=sea_frm action='<%response.write pageurl%>'>
    <tr>
    <td>关键字：</td>
    <td><input type=text name=keyword value='<%response.write keyword%>' size=50 maxlength=20> </td>
    <td> <input type=submit value=' 搜 索 '> </td>
    </tr>
    </form>
    </table>
</table></td></tr></table><%
end sub


sub common_soft_del()
  id=trim(request.querystring("id"))
  if not(isnumeric(id)) then call common_soft_main():exit sub
  conn.execute("delete from common_soft where id="&id)
  call common_soft_main()
end sub

sub common_soft_edit()
  dim titler,rs,strsql
  if id="" or isnull(id) then call common_soft_main():exit sub
%><table border="0" width="600" cellspacing="0" cellpadding="0">
<tr><td align=center height=300><%
  strsql="select * from common_soft where id="&id
  set rs=server.createobject("adodb.recordset")
  rs.open strsql,conn,1,3
  if request("types")="edit" then
    dim name,pic,url,remark
    name=code_form(trim(request("name")))
    pic=code_form(trim(request("pic")))
    url=code_form(trim(request("url")))
    remark=request("remark")
    if name="" or isnull(name) or url="" or isnull(url) then
      response.write("软件名称下载地址不能为空！<br><br>"&go_back)
    else
      rs("name")=name
      rs("pic")=pic
      rs("url")=url
      rs("remark")=remark
      rs.update
      rs.close:set rs=nothing
      response.write("常用软件修改成功！<br><br><a href='admin_down.asp?action=common_soft'>点击返回</a>")
    end if
else
%>
<table border="0" width="400" cellspacing="0" cellpadding="2">
  <tr><td colspan=2 height=50 align=center><font class=font_color1>常用软件属性修改</font></td></tr>
  <form action="?action=common_soft_edit&types=edit&id=<%=id%>" method=post>
  <tr><td>软件名称：</td><td><input type=text name=name value='<%=rs("name")%>' size=50 maxlength=100></td></tr>
  <tr><td>图片地址：</td><td><input type=text name=pic value='<%=rs("pic")%>' size=50 maxlength=100></td></tr>
  <tr><td>下载连结：</td><td><input type=text name=url value='<%=rs("url")%>' size=50 maxlength=100></td></tr>
  <tr><td>备注说明：</td><td><%response.write("<textarea rows=6 name=remark cols=50>"&rs("remark")&"</textarea>")%></td></tr>
  <tr height=30><td></td><td><input type="submit" value=" 修 改 "></td></tr>
</form></table>
<%  end if%></td></tr><tr></table><%
end sub

sub common_soft_add()
%><table border="0" width="600" cellspacing="0" cellpadding="0">
<tr><td align=center height=300><%
if request("types")="add" then
  dim name,pic,url,remark
  name=code_form(trim(request("name")))
  pic=code_form(trim(request("pic")))
  url=code_form(trim(request("url")))
  remark=request("remark")
  if name="" or isnull(name) or url="" or isnull(url) then
    response.write("软件名称下载地址不能为空！<br><br>"&go_back)
  else
    dim rs,strsql
    strsql="select * from common_soft where (id is null)"
    set rs=server.createobject("adodb.recordset")
    rs.open strsql,conn,1,3
    rs.addnew
    rs("name")=name
    rs("pic")=pic
    rs("url")=url
    rs("remark")=remark
    rs.update
    rs.close
    set rs=nothing
    response.write("常用软件添加成功！<br><br><a href='admin_down.asp?action=common_soft_add'>点击继续添加</a>")
  end if
else
%><table border="0" width="400" cellspacing="0" cellpadding="2">
<form action="?action=common_soft_add&types=add" method=post>
  <tr><td colspan=2 height=50 align=center><font class=font_color1>添加常用软件</font></td></tr>
  <tr><td>软件名称：</td><td><input type=text name=name size=50 maxlength=100></td></tr>
  <tr><td>图片地址：</td><td><input type=text name=pic size=50 maxlength=100></td></tr>
  <tr><td>下载连结：</td><td><input type=text name=url size=50 maxlength=100></td></tr>
  <tr><td>备注说明：</td><td><textarea rows="6" name=remark cols="50"></textarea></td></tr>
  <tr height=30><td></td><td><input type="submit" value=" 添 加 "></td></tr>
</form></table>
<%  end if%></td></tr></table><%
end sub

sub common_soft_main()
%><table border=1 width='95%' cellspacing=0 cellpadding=2 bordercolorlight=#C0C0C0 bordercolordark=#FFFFFF><%
  dim rs,strsql
  sqladd=""
  strsql="select * from common_soft " & sqladd & "order by id desc"
  set rs=server.createobject("adodb.recordset")
  rs.open strsql,conn,1,1
  if rs.eof and rs.bof then
    rssum=0
  else
    rssum=rs.recordcount
  end if
  call format_pagecute()
  response.write "<tr><td colspan=3 align=center height=30>共有个 <font class=red>"&rssum&"</font> 常用软件  分页:"&jk_pagecute(nummer,thepages,viewpage,pageurl,10,"#ff0000")&"</td></tr>" & _
	         "<tr align=center><td width='10%'>序号</td><td width='75%'>类型和名称</td><td width='15%'>操作</td></tr>"
  if int(viewpage)>1 then
    rs.move (viewpage-1)*nummer
  end if
  for i=1 to nummer
    if rs.eof then exit for
    response.write "<tr align=center><td>"&(viewpage-1)*nummer+i&"</td><td align=left>"&rs("name")&"</td><td><a href='admin_down.asp?action=common_soft_edit&id="&rs("id")&"'>修改</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href='admin_down.asp?action=common_soft_del&id="&rs("id")&"'>删除</a></td></tr>"
    rs.movenext
  next
  rs.close:set rs=nothing
%></table><%
end sub
%>