📄 colorcondition.asp

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

//判断数值型、日期型字段输入的From、To的合法性，即：From<=to
function CheckFromTo() 
{
	var ID;
	var FieldDataFrom,FieldDataTo;
	if (FieldCount>0)
	{
		for (var i=1 ; i<=FieldID.length; i++) 
		{
			if(typeof(frmData.all[FieldID[i-1]])!="undefined")
			{
				if(FieldType[i-1]==DataType_Number || FieldType[i-1]==DataType_Date || FieldType[i-1]==DataType_DateAndTime)
				{
					if(FieldID[i-1].substr(0,2)=='To')
						ID=FieldID[i-1].substr(2)
					else
						ID=FieldID[i-1].substr(4)
					FieldDataFrom=JTrim(frmData.all["From" + ID].value);
					FieldDataTo=JTrim(frmData.all["To" + ID].value);
					if(DataCheck(FieldCaption[i-1].substr(0,FieldCaption[i-1].length-3),parseInt(FieldType[i-1]),FieldDataFrom,"",FieldDataTo)==false)
						return(false);	
				}
			}
		}
		return(true);	
	}
	else
	{
		return(true);	
	}
}

//选择型字段是多选的情况下，需检查多选的个数，最多不得超过30个
function CheckMultiSelect() 
{
	var MaxCount=30;
	var ListCount,SelectedCount;
	var FieldData;
	if (FieldCount>0)
	{
		for (var i=1 ; i<=FieldID.length; i++) 
		{
			if(typeof(frmData.all[FieldID[i-1]])!="undefined")
			{
				if(FieldType[i-1]==DataType_Option)
				{
					ListCount=frmData.all[FieldID[i-1]].length;
					if(ListCount>0)
					{
						SelectedCount=0;
						for (var j=1 ; j<=ListCount; j++) 
						{
							if(frmData.all[FieldID[i-1]].options[j-1].selected==true)
							{
								SelectedCount=SelectedCount+1;
							}
						}
						if(SelectedCount>MaxCount)
						{
							alert(FieldCaption[i-1]+"选择的列表项太多，最多选"+MaxCount+"项，请适当减少。");
							return(false);	
						}
					}
				}
			}
		}
		return(true);	
	}
	else
	{
		return(true);	
	}
}

//根据界面上用户的输入，获取公式条件，按结构要求拼接
//结构：Fldxxx ConItemSep Value GroupSep Fldxxx ConItemSep Value
function GetResult() 
{
	var strResult;
	var ID;
	var FieldData;

	strResult="";
	if (FieldCount>0)
	{
		for (var i=1 ; i<=FieldID.length; i++) 
		{
			if(typeof(frmData.all[FieldID[i-1]])!="undefined")
			{
				if(FieldType[i-1]==DataType_Number || FieldType[i-1]==DataType_Date || FieldType[i-1]==DataType_DateAndTime)
				{
					FieldData=JTrim(frmData.all[FieldID[i-1]].value);
				}
				else if(FieldType[i-1]==DataType_Option)
				{
					var ListCount;
					ListCount=frmData.all[FieldID[i-1]].length;
					if(ListCount>0)
					{
						FieldData="";
						for (var j=1 ; j<=ListCount; j++) 
						{
							if(frmData.all[FieldID[i-1]].options[j-1].selected==true)
							{
								if(FieldData=="")
									FieldData=frmData.all[FieldID[i-1]].options[j-1].value;
								else
									FieldData=FieldData + "," + frmData.all[FieldID[i-1]].options[j-1].value;
							}
						}
					}
				}
				if(!isEmpty(FieldData))
				{
					if(strResult=="")
						strResult=FieldID[i-1] + ConItemSep + FieldData;
					else
						strResult=strResult + GroupSep + FieldID[i-1] + ConItemSep + FieldData;
				}
			}
		}
	}
	return strResult;
}

function LocalDC() 
{
	if(CheckFromTo() && CheckMultiSelect())
		return true;
	else
		return false;
}

function SaveCondition() 
{
	if(GeneralDC() && LocalDC())
	{
		window.returnValue = "1,"+GetResult();
		window.close();
	}
}

function CancelCondition()
{
	window.returnValue = "0";
	window.close();
}

//-->
</script>

<%
	dim WExcel
	set WExcel=server.CreateObject("WExcel.System")

	dim SheetID
	SheetID=Request.Cookies("System")("StructureSheetID")

	dim CurCondition
	CurCondition=Request.QueryString("CurCondition")

	dim BodyStr,GCScript
	WExcel.GetConditionPage cint(UserID),cint(SheetID),cstr(CurCondition),BodyStr,GCScript

	Response.Write GCScript
	CheckErr
%>

<html>
	<head>
		<title>条件</title>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	</head>
	<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
		<form METHOD="post" name="frmData">
			<table width="100%" border="0" cellPadding="0" cellSpacing="1">
				<tr height="35">
					<td colspan="5">
						<b>
							设置颜色对应的条件
						</b>
					</td>
				</tr>
				<%=BodyStr%>
				<tr height="40" valign="center">
					<td colspan="5">
						<input type="button" name="btnSave" value="确定" style="cursor:hand; WIDTH: 80px; HEIGHT: 24px" LANGUAGE="javascript" onclick="return SaveCondition()">
						<input type="button" name="btnCancel" value="取消" style="cursor:hand; WIDTH: 80px; HEIGHT: 24px" LANGUAGE="javascript" onclick="return CancelCondition()">
					</td>
				</tr>
			</table>
		</form>
	</body>                                                                                                           
</html>
💿 文件大小 8499 K
👤 上传用户 ddddong
📂 所属分类 JavaScript
🏷️ 相关标签

#记录
⌨️ 快捷键说明

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