📄 doc_list.asp
字号:
<%response.expires=0%>
<!--#include file="../asp/sqlstr.asp"-->
<!--#include file="../asp/bgsub.asp"-->
<%
'session.abandon
'Server.ScriptTimeOut=500
function opendb(DBPath,sessionname,dbsort)
dim conn
'if not isobject(session(sessionname)) then
Set conn=Server.CreateObject("ADODB.Connection")
'if dbsort="accessdsn" then conn.Open "DSN=" & DBPath
'if dbsort="access" then conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'if dbsort="sqlserver" then conn.Open "DSN=" & DBPath & ";uid=wsw;pwd=wsw"
DBPath1=server.mappath("../db/jzud-oa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
'end if
set opendb=session(sessionname)
end function
%>
<!--#include file="../asp/keepformat.asp"-->
<!--#include file="public.asp"-->
<!--#include file="conn.asp"-->
<%
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='default.asp';")
response.write("</script>")
response.end
end if
doctypename=request.form("typelist")
set conn=openconn("conn")
set rs=server.createobject("adodb.recordset")
sql="select * from TypeTable"
rs.open sql,conn,1
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>档案资料库</title>
<link rel="stylesheet" type="text/css" href="../css/css.css">
</head>
<body bgcolor="#ffffff" topmargin="5" leftmargin="5">
<%
%>
<center>
<table align="center">
<tr>
<%
if not rs.eof and not rs.bof then
response.write("<form method=""post"" action=""Doc_List.asp"">")
response.write("<td><b>档案资料库</b> ")
response.write("<select name=""typelist"" size=""1"">")
response.write("<option value="""">所有档案资料</option>")
do while not rs.eof
if doctypename=rs("TypeName") then
response.write("<option selected value="&chr(34)&rs("TypeName")&chr(34)&">"&keepformat(rs("TypeName"))&"</option>")
else
response.write("<option value="&chr(34)&rs("TypeName")&chr(34)&">"&keepformat(rs("TypeName"))&"</option>")
end if
rs.movenext
loop
response.write("</select>")
response.write("<input type=""submit"" value=""查看"">")
response.write("</form>")
else
response.write("<td><b>档案资料库</b>")
end if
%>
</td></tr>
</table>
</center>
<%
if rs.eof and rs.bof then
response.write("<center><br><br><font color=""red"" size=""+1"">请先增加档案资料库类别！</font></center><br><br>")
else
if doctypename<>"" then
sql="select * from ContentTable where TypeName='"&replace(doctypename,"'","''")&"'"
else
sql="select * from ContentTable"
end if
call DispList(doctypename,sql,"disp")
end if
conn.close
set conn=nothing
%>
</body>
</html>
<html></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -