📄 updateaddfourstep.asp
字号:
<%
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 + -