⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 sheetinfo.asp

📁 学生档案与成绩管理(1)学生档案管理:记录每个学生的档案信息
💻 ASP
字号:
<!-- #include file = "../../include/asphead.asp" -->
<!-- #include file = "../../include/function.asp" -->
<%CheckUser()%>
<link href="../../include/main.css" rel="stylesheet" type="text/css">
<%

	dim WExcel
	set WExcel=server.CreateObject("WExcel.System")
	
	dim Success
	dim Caption,Status,Publish,RecordCount, FileCount, RecordSize, RoleCount, FieldCount, UserCount, SearchCount, LogCount
	SheetID=Request.Form("SheetID")
	Response.Cookies("System")("StructureSheetID")=SheetID

	dim Exist
	Exist=WExcel.SheetExist(cint(UserID),cint(SheetID))
	CheckErr
	if Exist=false then
		Response.Redirect "/hcgis/notfound.asp?Name=数据表&Depth=0"
	end if
	Success=WExcel.GetSheetStatistics(cint(UserID),cint(SheetID),Caption,Status,Publish,RecordCount,FileCount,RecordSize,FieldCount,RoleCount,UserCount,ReportCount,TableCount,EmailCount,SearchCount,ViewCount,LogCount)
	CheckErr

%>

<HTML>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	</head>
	<BODY>
		<TABLE WIDTH=40% align=center BORDER=0 CELLSPACING="2" CELLPADDING=0>
			<TR height=30 valign=top>
				<TD colspan=2><%=Caption%>相关数据统计</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">数据表号</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=SheetID%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">状态</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=Status%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">公开发布</p>
				</TD>
				<TD width="50%">
					<p align="center"><%if Publish="1" then%>是<%else%>否<%end if%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">记录数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=RecordCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">附件数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=FileCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">总计大小</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=RecordSize%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">字段数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=FieldCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">角色数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=RoleCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">用户数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=UserCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">统计报表数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=ReportCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">表单模板数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=TableCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">提醒模板数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=EmailCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">查询器数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=SearchCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">视图数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=ViewCount%></p>
				</TD>
			</TR>
			<TR>
				<TD bgcolor="#e0e0e0" width="50%">
					<p align="left">Log记录数</p>
				</TD>
				<TD width="50%">
					<p align="center"><%=LogCount%></p>
				</TD>
			</TR>
		</TABLE>
	</BODY>
</HTML>

⌨️ 快捷键说明

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