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

📄 search.asp

📁 学生档案与成绩管理(1)学生档案管理:记录每个学生的档案信息
💻 ASP
字号:
<!-- #include file = "../../include/asphead.asp" -->
<!-- #include file = "../../include/function.asp" -->
<!-- #include file = "../../include/calendar.asp" -->
<%CheckUser()%>
<style type="text/css">
	#SheetOperateDiv {position:absolute;visibility:hidden;left:0;top:0;width:0;height:0;z-index:-1}
</style>    
<link href="../../include/main.css" rel="stylesheet" type="text/css">
<script src="../../include/function.js" type="text/javascript"></script>
<script ID="clientEventHandlersJS" LANGUAGE="javascript">
<!--

function HideSearch()
{
	parent.RightHead.document.all['SearchIcon'].width = 26
	parent.window.Content.cols="0,0,*"
	parent.RightHead.document.all['divShowSearch'].style.visibility = 'visible'
}

function Search() 
{
	if(LocalDC())
	{
		frmData.target ="RightData";
		frmData.action ="list.asp";
		frmData.submit();
	}
}

function LocalDC() 
{
	
	//判from日志号是否合法
	if(DataCheck("日志号(从)",DataType_Number,frmData.FromOperateID.value,"","")==false)
	{
		return(false);	
	}
	//判to日志号是否合法
	if(DataCheck("日志号(至)",DataType_Number,frmData.ToOperateID.value,"","")==false)
	{
		return(false);	
	}
	//判from日志号是否小于to日志号
	if(DataCheck("日志号",DataType_Number,frmData.FromOperateID.value,"",frmData.ToOperateID.value)==false)
	{
		return(false);	
	}

	//判from操作时间是否合法
	if(DataCheck("操作时间(从)",DataType_DateAndTime,frmData.FromOperateTime.value,"","")==false)
	{
		return(false);	
	}
	//判to操作时间是否合法
	if(DataCheck("操作时间(至)",DataType_DateAndTime,frmData.ToOperateTime.value,"","")==false)
	{
		return(false);	
	}
	//判from操作时间是否小于to操作时间
	if(DataCheck("操作时间",DataType_DateAndTime,frmData.FromOperateTime.value,"",frmData.ToOperateTime.value)==false)
	{
		return(false);	
	}
	return true;
	
}

function OperationChg() 
{
	var curOperation;
	curOperation=frmData.Operation.value;
	if(curOperation>=SheetOperationMin && curOperation<=SheetOperationMax) 
	{
		SheetOperate.innerHTML =SheetOperateDiv.innerHTML;
	}
	else
	{
		SheetOperate.innerHTML ="";
	}
}

function window_onload() 
{
	frmData.btnSearch.disabled =false;
}

//日期弹出窗口会调用HasChange()函数,此处没必要记录Change情况,放置一个空的函数即可
function HasChange() 
{
}

//-->
</script>
<%
	dim WExcel
	set WExcel=server.CreateObject("WExcel.System")

	dim OptionUserID,OptionOperation,OptionSheetID
	if Request.Cookies("Temp")("ButtonOn")="myfold" then
		'如果是从个人信息中查询log,则将可选项限制在当前操作者
		OptionUserID=WExcel.GetUserOption (cint(UserID),"","",cstr(UserID),true)
	else
		OptionUserID=WExcel.GetUserOption(0)
	end if
	OptionOperation=WExcel.GetOperationOption (0)
	OptionSheetID=WExcel.GetSheetOption (0)
	CheckErr	
%>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	</head>
	<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" LANGUAGE=javascript onload="return window_onload()">
		<form METHOD="post" name="frmData">
			<table width="108%" border="0" cellPadding="0" cellSpacing="1">
				<tr height="20">
					<td colspan="2">
						<table width="100%" border="0" cellPadding="0" cellSpacing="0">
							<tr>
								<td width="40%">
									<p align="left">
										<img src="../../images/hide.gif" alt="隐藏查询条件" style="cursor:hand" onClick="HideSearch()" width="26" height="20" border="0">
									</p>
								</td>
								<td width="60%">
									<p align="left">
										<b>查询日志</b>
									</p>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan=2>
						<hr>
					</td>
				</tr>
				<tr>
					<td colspan=2>
						<table width=100% align=left border=0 cellPadding=1 cellSpacing=0>
							<tr>
								<td rowspan=2 bgcolor="#e0e0e0" width="25%">
									<p align="left">日志号</p>
								</td>
								<td bgcolor="#e0e0e0" width="10%">
									<p align="left">从</p>
								</td>
								<td width="65%">
									<p align="right"><input TYPE="input" NAME=FromOperateID style="width:131px;" value='' maxLength=9></p>
								</td>
							</tr>
							<tr>
								<td bgcolor="#e0e0e0" width="10%">
									<p align="left">至</p>
								</td>
								<td width="65%">
									<p align="right"><input TYPE="input" NAME=ToOperateID style="width:131px;" value='' maxLength=9></p>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td bgcolor="#e0e0e0" width="35%">
						<p align="left">操作者</p>
					</td>
					<td width="65%">
						<p align="right">
							<select name=UserID style="width:132px;">
								<%=OptionUserID%>
							</select>
						</p>
					</td>
				</tr>
				<tr>
					<td bgcolor="#e0e0e0" width="35%">
						<p align="left">操作类型</p>
					</td>
					<td width="65%">
						<p align="right">
							<select name=Operation style="width:132px;" onchange="OperationChg()">
								<%=OptionOperation%>
							</select>
						</p>
					</td>
				</tr>
				<tr>
					<td colspan=2>
						<table width=100% align=left border=0 cellPadding=1 cellSpacing=0>
							<tr>
								<td rowspan=2 bgcolor="#e0e0e0" width="25%">
									<p align="left">操作<br>时间</p>
								</td>
								<td bgcolor="#e0e0e0" width="10%">
									<p align="left">从</p>
								</td>
								<td width="65%">
									<p align="right"><input TYPE="input" NAME=FromOperateTime style="width:116px;" value='' onchange="this.value=DateConvert(DataType_DateAndTime,0,this.value);" onblur="this.value=DateConvert(DataType_DateAndTime,0,this.value);" maxLength=20><INPUT type='button' value='v' onclick='fPopCalendar(1,this)' id='button' name='button'></p>
								</td>
							</tr>
							<tr>
								<td bgcolor="#e0e0e0" width="10%">
									<p align="left">至</p>
								</td>
								<td width="65%">
									<p align="right"><input TYPE="input" NAME=ToOperateTime style="width:116px;" value='' onchange="this.value=DateConvert(DataType_DateAndTime,1,this.value);" onblur="this.value=DateConvert(DataType_DateAndTime,1,this.value);" maxLength=20><INPUT type='button' value='v' onclick='fPopCalendar(1,this)' id='button' name='button'></p>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan=2>
						<p id=SheetOperate></p>
					</td>
				</tr>
				<tr height=30 valign="bottom">
					<td  colspan=2>
						<input type="button" name="btnSearch" disabled value="查询" style="cursor:hand; WIDTH: 50px; HEIGHT: 24px" LANGUAGE="javascript" onclick="return Search()">
					</td>
				</tr>
				<%if Request.Cookies("Temp")("ButtonOn")="myfold" then%>
				<tr height=80 valign="bottom">
					<td  colspan=2>
						<p align=left>说明:这里只可查询您自己的操作日志,要查询其他人的日志请进入系统管理 → 操作日志。
					</td>
				</tr>
				<%end if%>
				
			</table>
			<input TYPE="hidden" NAME="CurButton" value="<%=Request.Cookies("Temp")("ButtonOn")%>">
		</form>
	</body>                                                                                                           
	<div id=SheetOperateDiv>
		<table width=100% align=left border=0 cellPadding=1 cellSpacing=0>
			<tr>
				<td bgcolor="#e0e0e0" width="35%">
					<p align="left">数据表</p>
				</td>
				<td width="65%">
					<p align="right">
						<select name=SheetID style="width:132px;">
							<%=OptionSheetID%>
						</select>
					</p>
				</td>
			</tr>
		</table>
	</div>
</html>

⌨️ 快捷键说明

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