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

📄 updateaddfourstep.asp

📁 XXX档案美女图片站适合给图片广告的站长下载使用
💻 ASP
📖 第 1 页 / 共 2 页
字号:
<%
Set UpdateConn = Nothing
%>
<script language="JavaScript">
var FieldCorrStr='<% = FieldCorrStr %>';
var FieldCorrObjArray=new Array();
var CurrOperateTableSOID='';
function FieldCorrObj(TableSOID,TableCorr)
{
	this.TableSOID=TableSOID;
	this.TableCorr=TableCorr;
}
InitialFieldCorrObjArray();
function InitialFieldCorrObjArray()
{
	var TempArray=null,TempTempArray,i=0,TempFieldCorrObj=null;
	if (FieldCorrStr!='')
	{
		TempArray=FieldCorrStr.split('***');
		for (i=0;i<TempArray.length;i++)
		{
			TempTempArray=TempArray[i].split('###');
			TempFieldCorrObj=new FieldCorrObj(TempTempArray[0],TempTempArray[1]);
			FieldCorrObjArray[FieldCorrObjArray.length]=TempFieldCorrObj;
		}
	}
}
function AddTableFieldCorr()
{
	var ErrorStr='',i=0,AddOption=null,AddTF=false;
	var TableFieldCorrListObj=document.UpdateForm.TableFieldCorrList;
	var SourceTableFieldListObj=document.UpdateForm.SourceTableFieldList;
	var ObjectTableFieldListObj=document.UpdateForm.ObjectTableFieldList;
	var SelectedSourceTable=SourceTableFieldListObj.value;
	var SelectedObjectTable=ObjectTableFieldListObj.value;
	if (SelectedSourceTable=='')
	{
		if (document.UpdateForm.UserDataType.value=='')
		{
			ErrorStr='请选择源数据库表字段';
			alert(ErrorStr);
			SourceTableFieldListObj.focus();
			return;
		}
		else
		{
			if (document.UpdateForm.UserData.value=='')
			{
				alert('请填写自定义数据');
				document.UpdateForm.UserData.focus();
				return;
			}
		}
	}
	if (SelectedObjectTable=='') {ErrorStr='请选择目标数据库表字段';alert(ErrorStr);ObjectTableFieldListObj.focus();return;}
	if (document.UpdateForm.UserDataType.value=='')
	{
		if (!SearchUserPosition(TableFieldCorrListObj,SelectedObjectTable))
		{
			if (SourceTableFieldListObj.options(SourceTableFieldListObj.selectedIndex).Type!=ObjectTableFieldListObj.options(ObjectTableFieldListObj.selectedIndex).Type)
			{
				if (confirm('数据类型不一致,如果添加在数据转移的时候可能发生错误。\n\n                                     确定要添加吗?')) AddTF=true;
				else AddTF=false;
			}
			else AddTF=true;
			if (AddTF)
			{
				AddOption=document.createElement("OPTION");
				AddOption.text=SelectedSourceTable+'---'+SelectedObjectTable;
				AddOption.value='---'+SelectedSourceTable+'---'+SelectedObjectTable;
				TableFieldCorrListObj.add(AddOption);
				UpDateTableFieldCorrList();
			}
		}
		else alert('目标字段'+SelectedObjectTable+'已经设置了值');
	}
	else
	{
		if (!SearchUserPosition(TableFieldCorrListObj,SelectedObjectTable))
		{
			AddOption=document.createElement("OPTION");
			AddOption.text='!'+document.UpdateForm.UserData.value+'!'+'---'+SelectedObjectTable;
			AddOption.value='---'+'!'+document.UpdateForm.UserData.value+'!'+'---'+SelectedObjectTable;
			TableFieldCorrListObj.add(AddOption);
			document.UpdateForm.UserDataType.options(0).selected=true;
			document.UpdateForm.UserData.value='';
			UpDateTableFieldCorrList();
		}
		else alert('目标字段'+SelectedObjectTable+'已经设置了值');
	}
}
function DelTableFieldCorr()
{
	var TableFieldCorrListObj=document.UpdateForm.TableFieldCorrList,i=0;
	while (i<TableFieldCorrListObj.options.length)
	{
		if (TableFieldCorrListObj.options(i).selected) {TableFieldCorrListObj.options.remove(i);}
		else i=i+1;
	}
	UpDateTableFieldCorrList();
}
function SearchUserPosition(ObjectObj,Str)
{
	var i=0,TempText='',TextArray=null;
	for(i=0;i<ObjectObj.length;i++)
	{
		TempText=ObjectObj.options(i).text;
		TextArray=TempText.split('---');
		if (TextArray[1]==Str) return true;
	}
	return false;
}
function SearchPosition(ObjectObj,Str)
{
	var i=0;
	for(i=0;i<ObjectObj.length;i++)
	{
		if (ObjectObj.options(i).text.indexOf(Str)!=-1) return true;
	}
	return false;
}
function SubmitData()
{
	var i=0,ReturnStr='';
	for (i=0;i<FieldCorrObjArray.length;i++)
	{
		if (ReturnStr=='') ReturnStr=FieldCorrObjArray[i].TableSOID+'###'+FieldCorrObjArray[i].TableCorr;
		else ReturnStr=ReturnStr+'***'+FieldCorrObjArray[i].TableSOID+'###'+FieldCorrObjArray[i].TableCorr;
	}
	document.UpdateForm.TableFieldCorrInfo.value=ReturnStr;
	document.UpdateForm.submit();
	//alert(ReturnStr);
}
//////////////////////////////////////////////////////////////////////////////////////
function SetBtnStatus(Flag)
{
	document.UpdateForm.BtnAdd.disabled=Flag;
	document.UpdateForm.BtnDel.disabled=Flag;
	document.UpdateForm.BtnUp.disabled=Flag;
	document.UpdateForm.BtnNext.disabled=Flag;
}
function GetTableFieldStr(Obj)
{
	SetBtnStatus(true);
	CurrOperateTableSOID=Obj.value;
	if (Obj.value!='')
	{
		frames["ListTableFieldFrame"].location='ListTableAllField.asp?TableSOID='+Obj.value;
	}
	InitialTableFieldCorrList(Obj.value);
}
function InitialTableFieldCorrList(ID)
{
	var i=0,OperateObj=document.UpdateForm.TableFieldCorrList,OperateStr='',OperateArray=null,AddOption=null;
	var j=0;
	DeleteAllOption(OperateObj);
	for (i=0;i<FieldCorrObjArray.length;i++)
	{
		if (FieldCorrObjArray[i].TableSOID==ID)
		{
			OperateStr=FieldCorrObjArray[i].TableCorr;
			OperateArray=OperateStr.split('$$$');
			for (j=0;j<OperateArray.length;j++)
			{
				if (OperateArray[j]!='')
				{
					AddOption=document.createElement("OPTION");
					AddOption.text=OperateArray[j].substr(OperateArray[j].indexOf('---')+3);
					AddOption.value=OperateArray[j];
					OperateObj.add(AddOption);
				}
			}
		}
	}
}
function UpDateTableFieldCorrList()
{
	var i=0,OperateObj=document.UpdateForm.TableFieldCorrList,ReturnStr='';
	for (i=0;i<OperateObj.length;i++)
	{
		if (ReturnStr=='') ReturnStr=OperateObj.options(i).value;
		else ReturnStr=ReturnStr+'$$$'+OperateObj.options(i).value;
	}
	for (i=0;i<FieldCorrObjArray.length;i++)
	{
		if (FieldCorrObjArray[i].TableSOID==CurrOperateTableSOID) FieldCorrObjArray[i].TableCorr=ReturnStr;
	}
}
function SetTableField(FieldStr,Flag)
{
	var FieldArray=FieldStr.split('$$$'),FieldAttrubute='';
	var OperateObj=null,i=0,AddOption=null;
	switch (Flag)
	{
		case 'Source':
			OperateObj=document.UpdateForm.SourceTableFieldList;
			break;
		case 'Object':
			OperateObj=document.UpdateForm.ObjectTableFieldList;
			break;
		default :
			return;
	}
	DeleteAllOption(OperateObj);
	for (i=0;i<FieldArray.length;i++)
	{
		FieldAttrubute=FieldArray[i].substr(FieldArray[i].lastIndexOf('<'));
		FieldAttrubute=FieldAttrubute.replace('<','');
		FieldAttrubute=FieldAttrubute.replace('>','');
		AddOption=document.createElement("OPTION");
		AddOption.text=FieldArray[i];
		AddOption.value=FieldArray[i].slice(0,FieldArray[i].lastIndexOf('<'));
		AddOption.IsRequested=FieldAttrubute.split('|')[0];
		AddOption.Type=FieldAttrubute.split('|')[1];
		OperateObj.add(AddOption);
	}
}
function DeleteAllOption(SelectObj)
{
	var OptionLength=SelectObj.length;
	for(var i=0;i<OptionLength;i++)
	{
		SelectObj.options.remove(SelectObj.length-1);
	}
}
function SetUserData(Obj)
{
	document.UpdateForm.UserData.value='';
	switch (Obj.value)
	{
		case 'GetRandomID18':
			document.UpdateForm.UserData.value='GetRandomID18';
			break;
		default :
		
	}
}
</script>

⌨️ 快捷键说明

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