📄 grguan.asp

📁 一款用ASP写的办公自动化软件
💻 ASP
字号:
<!--#include file=data/conn.asp-->
<!--#include file=connfig.asp-->
<!--#include file=inc/yan.asp-->
<%call case4%>
<%
	'批准时进行传值
	if request("pass")<>""  then
	call geren
	end if
	function geren
		set rs2=server.CreateObject("adodb.recordset")
		sql2="select * from gerenhuodong where id="&request("id")
		rs2.open sql2,conn,1,3
		rs2("pass")=1
		rs2("pname")=session("admin_name")
		rs2.update
		rs2.close
	end function
	if request("del")<>"" then 
	call del
	end if
	function del
		sql2="delete from gerenhuodong where id="&request("del")
		conn.Execute(sql2)
	end function
%>
<%
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from gerenhuodong order by time desc"
	rs.open sql,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
-->
</style>
<link href="table.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:link {
	color: #0000FF;
	text-decoration: none;
}
a:visited {
	color: #0000FF;
	text-decoration: none;
}
a:hover {
	color: #000000;
	text-decoration: none;
}
a:active {
	text-decoration: none;
}
body {
	background-color: #ffffff;
}
.style3 {color: #FF0000}
.style4 {color: #000000}
-->
</style></head>

<body>
<table width="508" border="0" align="center" cellspacing="1" bgcolor="#D8E2FF" style="border:ta">
  <tr bgcolor="#FFFF00">
    <td width="164" height="31" background="images/tile_sub.gif"><div align="center" class="style4">发文标题</div></td>
    <td width="50" background="images/tile_sub.gif"><div align="center" class="style4">发文人</div></td>
    <td width="101" background="images/tile_sub.gif"><div align="center" class="style4">日期</div></td>
    <td colspan="2" background="images/tile_sub.gif"><div align="center" class="style4">管理</div></td>
    <td background="images/tile_sub.gif"><span class="style4">批准人</span></td>
  </tr>
  <%
  if not rs.eof then 
  tel=rs.recordcount
  shum=15
  rs.pagesize=shum
  maxpage=rs.pagecount
  requestpage=clng(request("p"))
  if requestpage="" or requestpage=0 then 
  requestpage=1
  end if 
  if requestpage>maxpage then 
  requestpage=maxpage
  end if 
  if not requestpage=1 then 
  rs.move (requestpage-1)*rs.pagesize
  end if 
  for i=1 to rs.pagesize and not rs.eof
  %>
  <tr >
    <td height="26" bgcolor="#FFFFFF" ><span class="style3">→</span><a href="#" onClick="window.open('grxian.asp?id=<%=rs("id")%>','','scrollbars=yes,width=510,height=500')"><%=rs("title")%></a></td>
    <td height="26" bgcolor="#FFFFFF" ><div align="center"><%=rs("name")%></div></td>
    <td bgcolor="#FFFFFF" ><div align="center"><%=rs("time")%></div></td>
    <td bgcolor="#FFFFFF" >
	<div align="center">
	</div>	<div align="center"></div>	
	
	<div align="center"></div>	<div align="center">
        <%if rs("pass")=1 then%>
        批准
        <%else%>
        <a href=grguan.asp?pass=1&id=<%=rs("id")%> onClick="return confirm('确定批准吗？')">未批</a>
        <%end if%>
    </div></td>
	<% If ps("chaoji")=1 Then %>
    <td width="36" bgcolor="#FFFFFF" ><div align="center"><a href=grguan.asp?del=<%=rs("id")%>&p=<%=requestpage%>>删除</a></div></td>
    <% Else %>
    <td width="36" bgcolor="#FFFFFF" ><div align="center">删除</div></td>
	<% End If %>

	<td width="38" bgcolor="#FFFFFF" ><%=rs("pname")%></td>
  </tr>
  <%
  rs.movenext 
  if rs.eof then exit for 
  next
  else
  response.Write("暂无信息")
  end if
  rs.close
  %>
  <tr bgcolor="#F3F3F3">
  <td height="35" colspan="6"><div align="right">
  共 <%= maxpage %> 页　　当前页：<%= requestpage %>  　        <a href=grguan.asp?p=<%=requestpage-1%>>上一页</a>        <a href=grguan.asp?p=<%=requestpage+1%>>下一页</a>
  </div></td>
  </tr>
</table>
<div align="center">
 
</div>
</body>
</html>
⌨️ 快捷键说明

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