list.asp

功能齐全的oa系统

<%option explicit%>
<%
Response.Expires = -1
Response.AddHeader "Pragma","no-cache"
Response.AddHeader "Cache-Control","no-cache,must-revalidate"
%>
<!-- #include virtual="include/DataEnvi.asp" -->
<!-- #include virtual="include/String.asp" -->
<!-- #include virtual="include/Page.asp" -->
<%
	Dim ObjDB,StrSQL
	Dim IntPageCount,IntPageNo,IntPageSize
	Dim C,ArrList,i,j,IntRows,IntCols
	Dim IntDirID
	
	IntPageNo	= Request.QueryString("PageNo")
	IntPageSize = 12
	
	IntDirID = Request.QueryString("DirID")
	
	If IntDirID = "" Then IntDirID = 0
	
	StrSQL = "Select ID,FileName,Createtime From t_OA_Private_Document Where DirID = " & FixSQL(IntDirID)

	Set ObjDB = Server.CreateObject("Adodb.Connection")
	OpenDB ObjDB
	
	Set C = Server.CreateObject ("CMS2003.DBhandle")

	C.Init(ObjDB)
	ArrList = C.List(IntPageNo,IntPageSize,StrSQL)	'使用List()函数获得列表数组
	IntPageCount = C.GetPageCount()					        '使用GetPageCount()函数获得总页码
	IntRows = C.GetRows()						              	'使用GetRows()获得总返回的行数
	IntCols = C.GetCols()						              	'使用GetCols()获得总返回的列数
 
	ObjDB.Close
	Set ObjDB = Nothing
%>

<%'==================================================================%>
<%Sub Main%>
<%'------------------------------------------------------------------%>
	<table class=Ltable cellspacing=1 cellpadding=3>
	<tr class=LHtr>
		<td width=2%><input type=checkbox id=0 name=ITEM></td>
		<td width=2%>ID</td>
		<td width=60%>文件名称</td>
		<td width=30%>创建时间</td>

	<%
		For i = 0 To IntRows
	%>
	<tr class=Ltr name=ITEMTR id=<%=ArrList(0,i)%>>
		<td><input type=checkbox name=ITEM  id=<%=ArrList(0,i)%>></td>
		<%
		For j = 0 To IntCols
		%>
	<td><%=ArrList(j,i)%></td>
		<%
		Next
		%>
	</tr>

	<%
		Next		
	%>
	
	
	
	</table>
	
	<%
	If Cint(IntDirID)<>0 Then 	 
	%>

	<input type="button" onclick="parent.location='Account/index.asp?ParentID=<%=IntDirID%>'" value=" 列出本文档文件 " name="B5"> 

	<%
	End If
	%>

	<%=PageFooter(IntPageCount,"PageNo")%>

<%'------------------------------------------------------------------%>
<%End Sub%>
<%'==================================================================%>

<!-- #include file="Templet.asp" -->