freelable_edit.asp

asp源码 图片ASP整站

	{
		if(ExpressionArray[i].indexOf("=") != -1)
		{
			for(j=0;j<TablesArray.length;j++)
				if(ExpressionArray[i].indexOf(TablesArray[j]+".",ExpressionArray[i].indexOf("=")) != -1)
				{
					ExpressionArray[i] = "";
					break;
				}
		}
	}
	FieldsListFrame_0.Initial(TableFieldArray,ExpressionArray,OrderSearchArray);
	FieldsListFrame_1.Initial(TableFieldArray,ExpressionArray,OrderSearchArray);

	StyleContent = FreeLableForm.StyleContent.value.replace(/\%3C/g,"<").replace(/\%3E/g,">").replace(/\%22/g,"\"");
	FreeLableForm.StyleContent.value = "";
	Editer_HTML.document.body.innerHTML = StyleContent;
	Editer_Code.document.body.innerText = StyleContent;
	
	ShowSql();
}
<%
	End if
%>
function NextStep()
{
	if(!CanNextToStyle())
	{
		alert("没有选择字段！");
		return;
	}
	document.all.PreiorStepButton.style.display='';
	document.all.PreiorStepButtonX.style.display='';
	document.all.NextStepButton.style.display='none';
	document.all.NextStepButtonX.style.display='none';
	document.all.SaveButton.style.display='';
	document.all.SaveButtonX.style.display='';
	document.all.Step_CreateSql.style.display = 'none';
	document.all.Step_SetStyle.style.display = '';
	RefreshValidFields();
}
function PreiorStep()
{
	document.all.PreiorStepButton.style.display='none';
	document.all.PreiorStepButtonX.style.display='none';
	document.all.NextStepButton.style.display='';
	document.all.NextStepButtonX.style.display='';
	document.all.SaveButton.style.display='none';
	document.all.SaveButtonX.style.display='none';
	document.all.Step_CreateSql.style.display = '';
	document.all.Step_SetStyle.style.display = 'none';
}
//预览标签样式
function PreView()
{
	var StyleContent = "";
	switch (Target)
	{
		case "Editer_HTML":
			StyleContent = Editer_HTML.document.body.innerHTML;
			break;
		case "Editer_Code":
			StyleContent = Editer_Code.document.body.innerText;
			break;
		default:
			StyleContent = Editer_Code.document.body.innerText;
			break;
	}
	PreviewForm.SqlStr.value = FreeLableForm.SqlPreview.value;
	PreviewForm.StyleContent.value = StyleContent;
	PreviewForm.submit();
}
//生成结果并保存
function DoSubmit()
{
	var i,FieldsCName;
	FieldsCName = "";
	switch (Target)
	{
		case "Editer_HTML":
			FreeLableForm.StyleContent.value = Editer_HTML.document.body.innerHTML;
			break;
		case "Editer_Code":
			FreeLableForm.StyleContent.value = Editer_Code.document.body.innerText;
			break;
		default:
			FreeLableForm.StyleContent.value = Editer_Code.document.body.innerText;
			break;
	}

	for(i=0;i<TableFieldArray.length;i++)
		if(TableFieldArray[i] != "")
		{
			if(FieldsCName == "")
				FieldsCName = TableFieldsCNameArray[i];
			else
				FieldsCName = FieldsCName + "," + TableFieldsCNameArray[i];
		}
	FreeLableForm.FieldsCName.value = FieldsCName;
	FreeLableForm.submit();
}
//在编辑样式代码时同步两个编辑窗口
function Refresh()
{
	if(Target != "")
	{
		switch (Target)
		{
			case "Editer_HTML":
				Editer_Code.document.body.innerText = Editer_HTML.document.body.innerHTML;
				break;
			case "Editer_Code":
				Editer_HTML.document.body.innerHTML = Editer_Code.document.body.innerText;
				break;
		}
	}

}
//选择用户编辑好的样式文件,在隐藏窗体StyleContainer中下载样式文件,并调用检测函数
function SelectStyle()
{
	var CurrPath,ReturnValue,XmlObj,StyleStr,StreamObj,XmlhttpObjName,StreamObjName
	if(SysRootDir!="")
		CurrPath = "/" + SysRootDir + "/" + StyleFiles;
	else
		CurrPath = "/" + StyleFiles;
	ReturnValue = OpenWindow("../../funpages/frame.asp?FileName=SelectStyleFrame.asp&Pagetitle=选择样式&CurrPath="+CurrPath,600,350,window);
	if(ReturnValue == "")
		return;
	if(SysRootDir!="")
		ReturnValue ="/" + SysRootDir + ReturnValue;	
	StyleContainer.document.location.href = ReturnValue;
	CheckStyleContainer();
}
//检测样式文件是否下载,如果已下载则装入两个编辑窗口
function CheckStyleContainer()
{
	var StyleStr;
	if(StyleContainer.document.body.innerHTML != "")
	{
			
		StyleStr = StyleContainer.document.body.innerHTML;
		StyleContainer.document.body.innerHTML = "";
		if(StyleStr.toLowerCase().indexOf("<body") != -1)
			StyleStr = StyleStr.substr(StyleStr.indexOf(">",StyleStr.toLowerCase().indexOf("<body"))+1);
		if(StyleStr.toLowerCase().indexOf("</body>") != -1)
			StyleStr = StyleStr.substring(0,StyleStr.toLowerCase().indexOf("</body>"));

		Editer_HTML.document.body.innerHTML = StyleStr;
		Editer_Code.document.body.innerText = StyleStr;
	}
	else
		setTimeout("CheckStyleContainer();",300);
}
//从生成SQL语句转入下一步时,更新编辑区域
function RefreshValidFields()
{
	var i,TableFlag = 0;
	var ValidFieldsObj = FreeLableForm.ValidFields;
	var OptionObj;
	var ValidFieldsLength = ValidFieldsObj.length;
	var DateStyle_Flag = false;
	for(i=0;i<ValidFieldsLength;i++)
	{
		ValidFieldsObj.remove(0);
	}
	for (i=0;i<TableFieldArray.length;i++)
	{
		TempArray=TableFieldArray[i].split('.');
		if (TempArray.length>=2)
		{
			if (TableFlag!==3)
			{
				switch (TableFlag)
				{
					case 0:
						if (TempArray[0]=='FS_News') TableFlag=1;
						if (TempArray[0]=='FS_NewsClass') TableFlag=2;
						if (TempArray[0]=='FS_Download') TableFlag=4;
						break;
					case 1:
						if (TempArray[0]=='FS_NewsClass') TableFlag=3;
						break;
					case 2:
						if (TempArray[0]=='FS_News') TableFlag=3;
						if (TempArray[0]=='FS_Download') TableFlag=5;
						break;
					case 4:
						if (TempArray[0]=='FS_NewsClass') TableFlag=5;
						break;
				}
			}
		}
	}
	for(i=0;i<TableFieldArray.length;i++)
	{
		if(TableFieldArray[i] != "")
		{
			if(TableFieldArray[i].toLowerCase().indexOf("adddate") != -1)
				DateStyle_Flag = true;
			OptionObj = document.createElement("option");
			if(TableFlag == 1 || TableFlag == 2 || TableFlag == 4)
			{
				OptionObj.setAttribute("value","[*"+TableFieldArray[i].substr(TableFieldArray[i].indexOf(".")+1)+"*]");
				OptionObj.setAttribute("innerText",TableFieldsCNameArray[i].substr(TableFieldsCNameArray[i].indexOf(".")+1));
			}
			else
			{
				OptionObj.setAttribute("value","[*"+TableFieldArray[i]+"*]");
				OptionObj.setAttribute("innerText",TableFieldsCNameArray[i]);
			}
			ValidFieldsObj.appendChild(OptionObj)
		}
	}
	document.all.DateStyleButton.disabled = !DateStyle_Flag
}
//插入内容(字段代码、系统定义代码、日期样式代码）到编辑窗口
function InsertStr(Str)
{
	if(Target != "")
	{
		switch (Target)
		{
			case "Editer_HTML":
				Editer_HTML.focus();
				if (Editer_HTML.document.selection.type.toLowerCase() != "none")
				{
					Editer_HTML.document.selection.clear() ;
				}
				Editer_HTML.document.selection.createRange().pasteHTML(Str) ; 
				Editer_Code.document.body.innerText = Editer_HTML.document.body.innerHTML;
				break;
			case "Editer_Code":
				Editer_Code.focus();
				if (Editer_Code.document.selection.type.toLowerCase() != "none")
				{
					Editer_Code.document.selection.clear() ;
				}
				Editer_Code.document.selection.createRange().pasteHTML(Str) ; 
				Editer_HTML.document.body.innerHTML = Editer_Code.document.body.innerText;
				break;
		}
	}
}
//更新添加赋值操作超链接，该函数由字段列表子窗体调用
function SetAddExpContainerHTML(TableName,HTMLStr)
{
	var i;
	for(i=0;i<TablesArray.length;i++)
	{
		TableName = TableName + ".";
		if(TableName.indexOf(TablesArray[i]+".") != -1)
			document.all("FieldsList_"+i+"_AddExpContainer").innerHTML = HTMLStr;
	}
}
//调用字段列表子窗体的添加赋值操作函数
function AddExpression(TableName,index)
{
	var i;
	for(i=0;i<TablesArray.length;i++)
	{
		TableName = TableName + ".";
		if(TableName.indexOf(TablesArray[i]+".") != -1)
			eval("FieldsListFrame_"+i+".AddExpression("+index+");")
	}
}
//更新赋值操作表达式数组，由字段列表子窗体调用
function SetExpressionToArray(ExpArray,TableName)
{
	var i;
	if(TableName != "")
	{
		for(i=0;i<ExpressionArray.length;i++)
			if(ExpressionArray[i] != "" && ExpressionArray[i].indexOf(TableName+".") == -1)
				ExpArray[ExpArray.length] = ExpressionArray[i];
		
	}
	ExpressionArray = null;
	ExpressionArray = ExpArray;
	ShowSql();
}
//保存排序项到排序数组，排序项只包含字段名为删除该排序项
function SetOrderToArray(OrderStr)
{
	var Operation = "Del",TempStr = OrderStr,flag=false;
	if(OrderStr == "") return;
	if(OrderStr.indexOf(" Asc") != -1)
	{
		Operation = "Asc";
		TempStr = OrderStr.substring(0,OrderStr.indexOf(" Asc"));
	}
	else if(OrderStr.indexOf(" Desc") != -1)
	{
		Operation = "Desc";
		TempStr = OrderStr.substring(0,OrderStr.indexOf(" Desc"));
	}
	for(i=0;i<OrderSearchArray.length;i++)
	{
		if(OrderSearchArray[i].indexOf(TempStr) !== -1)
			switch(Operation)
			{
				case "Del":
					OrderSearchArray[i] = "";
					flag = true;
					break;
				case "Asc":
					OrderSearchArray[i] = TempStr;
					flag = true;
					break;
				case "Desc":
					OrderSearchArray[i] = OrderStr;
					flag = true;
					break;
			}
	}
	if(flag == false)
		switch (Operation)
		{
			case "Asc":
				OrderSearchArray[OrderSearchArray.length] = TempStr;
				break;
			case "Desc":
				OrderSearchArray[OrderSearchArray.length] = OrderStr;
				break;
		}
	ShowSql();
}
//清除某个字段列表子窗体中选择的字段
function CleanSelectedOfTable(table)
{
	var i;
	switch(table)
	{
		case 1:
			document.FieldsListFrame_0.CleanSelected();
			for(i=0;i<TableFieldArray.length;i++)
				if(TableFieldArray[i].indexOf(TablesArray[0]+".") > -1)
				{
					TableFieldArray[i]='';
					TableFieldsCNameArray[i]='';
				}
			ShowSql();
			break;
		case 2:
			document.FieldsListFrame_1.CleanSelected();
			for(i=0;i<TableFieldArray.length;i++)
				if(TableFieldArray[i].indexOf(TablesArray[1]+".") > -1)
				{
					TableFieldArray[i]='';
					TableFieldsCNameArray[i]='';
				}
			ShowSql();
			break;
	}
}
//设置选中字段、排序项的次序和查询的数量
function SetSearchArraySequence()
{
	var OrderStr,FieldsStr,FieldsCNameStr,i,Url,TempArray
	OrderStr = "";
	FieldsStr = "";
	for(i=0;i<OrderSearchArray.length;i++)
		if(OrderSearchArray[i] !="")
			if(OrderStr == "")
				OrderStr = OrderSearchArray[i];
			else
				OrderStr = OrderStr+","+OrderSearchArray[i];
	for(i=0;i<TableFieldArray.length;i++)
		if(TableFieldArray[i] != '')
			if(FieldsStr == "")
			{
				FieldsStr = TableFieldArray[i];
				FieldsCNameStr = TableFieldsCNameArray[i];
			}
			else
			{
				FieldsStr = FieldsStr+","+TableFieldArray[i];
				FieldsCNameStr = FieldsCNameStr + ","+TableFieldsCNameArray[i];