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/Page.asp" -->
<!-- #include virtual="include/datefunction.asp" -->
<%
	Dim ObjDB,StrSQL
	Dim IntPageCount,IntPageNo,IntPageSize
	Dim C,ArrList,i,j,IntRows,IntCols
	Dim StrWhere
	
	IntPageNo	= Request.QueryString("PageNo")
	StrWhere	= Request.QueryString("W")
	IntPageSize = 12
	
	If StrWhere = "" Then
		StrSQL = "Select ID,RoleName,Des,CreateTime From t_OA_SYS_Role"
	Else
		StrSQL = "Select ID,RoleName,Des,CreateTime From t_OA_SYS_Role Where 1=1" & StrWhere
	End If

	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=1%><input type=checkbox id=0 name=ITEM></td>
		<td width=1%></td>
		<td width=20%>角色</td>
		<td width=63%>描述</td>
		<td width=15%>日期</td>
	</tr>

	<%
		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>
		<td><img src='../../../../images/oa/sys/role/icon.gif'></td>
		<td><%=ArrList(1,i)%></td>
		<td><%=ArrList(2,i)%></td>
		<td><%=FormatDate(ArrList(3,i))%></td>
	</tr>

	<%
		Next		
	%>
	
	
	
	</table>
	<%=PageFooter(IntPageCount,"PageNo")%>

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

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