28,391
社区成员
发帖
与我相关
我的任务
分享
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="connect.asp" -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>管理员界面</title>
</head>
<body>
<div align="center">
<p><font color="#339966" size="6" face="楷体_GB2312"><strong>数据管理界面</strong></font></p>
<form name="form2" method="post" action="pizhun1.asp">
<font color="#CC9900">
<%
Set rs=Server.CreateObject("ADODB.Recordset")
strSql="Select * From scwj order by shijian desc "
rs.Open strSql,dbconn,1
dim pgsize,page,pgnm,count
pgsize=10
page=request.querystring("page")
rs.pagesize=pgsize
pgnm=rs.pagecount
if page=""or clng(page)<1 then page=1
if clng(page)>pgnm then page=pgnm
if pgnm>0 then rs.absolutepage=page
count=0
if not rs.eof then
do while not rs.eof and count<rs.pagesize
count=count+1
%>
</font>
<table width="750" border="1" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#EBEBEB" colspan="5"><div align="center">
<center>
<p><font size="3" face="楷体_GB2312"><strong></strong></font>
</center>
</div></td>
</tr>
<div align="center">
<%'Response.Write "共找到" & rs.RecordCount & "条记录"%>
</div>
<tr bgcolor="#339966">
<td width="163">
<div align="center">文件名称</div></td>
<td width="163">
<div align="center">文件类型</div></td>
<td width="163">
<div align="center">上传部门</div></td>
<td width="162">
<div align="center">上传时间</div></td>
<td width="87"><div align="center">批准</div></td>
<%
'if not rs.eof then
' do while not rs.Eof
' rs.movelast
%>
</tr>
<tr bgcolor="#99FF66">
<td>
<div align="center"><%=rs("wjmc")%></div></td>
<td>
<div align="center"></div></td>
<td>
<div align="center"><%=rs("fsbm")%></div></td>
<td>
<div align="center"><%=rs("shijian")%></div></td>
<td><div align="center"><a href="guanliyuan_1.asp?recno=<%=rs("shijian")%>" >
<input type="checkbox" name="checkbox" value="checkbox">
</a></div></td>
</tr>
<%
rs.movenext
loop
end if %>
<tr align="center">
<td height="2" colspan="5" bgcolor="#EBEBEB">
<center>
<p>
</center></td>
</tr>
</table>
<p>
<td height="17"> <div align="center"><a href=gly.asp?page=1><font size="2" face="仿宋_GB2312" >第一页</font></a> <font face="仿宋_GB2312">
<a href=gly.asp?page=<%=page-1%>><font size="2" >上一页</font></a>
<a href=gly.asp?page=<%=page+1%>><font size="2" >下一页</font></a>
<a href=gly.asp?page=<%=pgnm%>><font size="2" >最后一页</font></a> </p>
<p>
<input type="submit" name="Submit" value="提交">
</p>
</form>
<form name="form4" method="post" action="">
<p align="center"><font size="2">返回主页</font></p>
</form>
<p> </p>
</div>
<div align="center">
<% 'end if %>
</div>
</body>
</html>
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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=gb2312" />
<title>信息修改</title>
</head>
<!--#include file="connect.asp" -->
<body>
<%
dim sql,id
id=request.form("ids")
if shijian<>"" then
sql="update scwj set pizhun=1 where [shijian] in (" & shijian & ")"
conn.execute(sql)
end if
%>
<%
dim dbconn,strsql
set dbconn=server.createobject("adodb.connection")
dbconn.open "driver={sql server};database=test;uid=sa;pwd=123456;server=SERVER-2;"
%>
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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=gb2312" />
<title>信息修改</title>
</head>
<!--#include file="connect.asp" -->
<body>
<%
dim sql,id
id=request.form("ids")
if id<>"" then
sql="update scwj set pizhun=1 where [shijian] in (" & shijian & ")"
conn.execute(sql)
end if
%>
<input type="checkbox" name="ids" value="<%=rs("ID")%>">
<%
dim sql,id
id=request.form("ids")
if id<>"" then
sql="update scwj set pizhun=1 where [ID] in (" & id & ")"
conn.execute(sql)
end if
%>