//查詢資料庫符合條件的資料
function SelectAlterNativeVenues(field)
{
var xmlhttp;
var pid = document.getElementById("nameandaddress").valuef; 🎜>var url = "${RetrieveURL}?accessorType=${AccessorType}";
url = url "&method=RetrieveSelectResult&NameAndAddress=" escape(pid);
if (window.XMLHttpRequest)
{
xmlhttp = new XMLHttpRequest();
}
else if (window.ActiveXObject)
{
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); //IE
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); //IE
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
if (xmlhttp != null)
{
xmlhttp.open("GET", url, true);
xmlhttp.setRequestHeader("If-Modified-Since", "0");
xmlhttp.send(null);
xmlhttp.onreadystatechange = function processRefreshUsers() //註冊方法
{
if (xmlhttp.readyState == 4)
{
if (xmlhttp.readyState == 4)
{
if (xmlhttp .status == 200)
{
//responseXML取得執行RetrieveCitiesByProvinceId方法的回傳值
var datas = xmlhttp.responseXML.documentElement.getElementsByTagName("AlterNativeVenues); getElementById("table1");
var pchildren = nname.childNodes;//清空表中的行和列
for(var a=0; a
{
nname.removeChild(pchildren[a]);
}
//新增查詢行
var aaRow=nname.insertRow(0);
var aaCell=aaRow.insertCell(0);
aaCell.innerHTML="";
aaRow.insertCell(1).innerHTML="查詢";
//新增標題行
var aRow=nname.insertRow(1) ;
aRow.insertCell(0).innerHTML="";
aRow.insertCell(1).innerHTML="名稱";
aRow.insertCell(2).innerHTML="位址";
aRow.insertCell(2).innerHTML="位址";
aRow.insertCell(3).innerHTML="電話";
//循環加入資料行
for (i = 0; i {
var Id = datas[i].getElementsByTagName("Id")[0].firstChild.nodeValue;
var Name = datas[i].getElementsByTagName("Name")[0].firstChild.nodeValue;
var Address= datas[i].getElementsByTagName("Address")[0].firstChild.nodeValue;
var Phone=datas[i].getElementsByTagName("Phone")[0].firstChild.nodeValue;
var aNewRow=nname.insertRow(i 2);
aNewRow.insertCell(0).innerHTML="";
aNewRow.insertCell(1).innerHTML=Name;
aNewRow.insertCell(2).innerHTML=Name;
aNewRow.insertCell(2).innerHTML=Address; >aNewRow.insertCell(3).innerHTML=Phone;
}
}
}
}
}
}
}
}
/新增已選取的資料
function AddRowSelectAfter(id,field)
{
//把隱藏域裡面的所有id分割開然後把對應的checked綁定
var state=false; //判斷下面列表是否存在
var _hiddenId=document.getElementById(field).value.substr(0,document.getElementById(field).value.length-1).split(',');
for(j=0 ;j<_hiddenid.length>{
if(_hiddenId[j]==id.split('_')[1])
{
state=true;
}
}
if(state==false)
{
//只要點擊checkbox就出發一次更改隱藏域的值
///非選取狀態需要把id從非選取隱藏控制項裡面移除
var arrs=document.getElementById(field).value.substr(0,document.getElementById(field).value.length-1).split(',');
//定義一個欄位重新取得id
var newids="";
for(var arr=0;arr{
if(arrs[arr]!=id. split('_')[1])
newids =arrs[arr] ",";
}
//重新賦予隱藏控制項
//最後一個字元可能是,
var fh=newids.substr(newids.length-1,newids.length);
if(fh==",")
document.getElementById(field).value=newids.substr(0,newids .length-1);
else
document.getElementById(field).value=newids;
if(document.getElementById(id).checked==false)
{ //選取狀態點選改為非點中狀態移除已選取的場館document.getElementById(id).checked=false; //給tr設定id用來刪除tr document.getElementById("table2").deleteRow(document.getElementById("NewRow_" id.split('_')[1]).rowIndex); } else { document.getElementById(id).checked=true; var input =document.getElementById(field); var xmlhttp; var url = "${RetrieveURL}?accessorType=${AccessorType }"; url = url "&method=SelectResult&id=" id; if (window.XMLHttpRequest) { xmlhttp = new XMLHttpRequest(); } } { xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); //IE }
if (xmlhttp != null)
{
xmlhttp.open("GET", url, true);
xmlhttp.setRequestHeader("If-Modified-Since", "0");
xmlhttp.send(null);
xmlhttp.onreadystatechange = function processRefreshUsers() //註冊方式
{
if (xmlhttp.readyState == 4)
{
if (xmlhttp.readyState == 4)
{
if ( xmlhttp.status == 200)
{
//responseXML取得執行RetrieveCitiesByProvinceId方法的回傳值
var datas = xmlhttp.responseXML.documentElement.getElementsByTagName("AlativeNativeVenuename); .getElementById("table2");
nname.style.width="560px";
if(nname.rows.length==0&&datas.length>0)
{
//第一行
var firstRow=nname.insertRow(0);
firstRow.id="NewRow_0";
firstRow.insertCell(0).innerHTML="名稱";
firstRow..ertM. .innerHTML="地址";
firstRow.insertCell(2).innerHTML="電話";
firstRow.insertCell(3).innerHTML="操作";
}
for (i = 0; i {
var Id = datas[i].getElementsByTagName("Id")[0].firstChild.nodeValue;
var Name = datas[i]. getElementsByTagName("Name")[0].firstChild.nodeValue;
var Address=datas[i].getElementsByTagName("Address")[0].firstChild.nodeValue;
var Phone=datas[i]. getElementsByTagName("Phone")[0].firstChild.nodeValue;
var aNewRow=nname.insertRow(nname.rows.length);
aNewRow.id="NewRow_" Id; oneCell=aNewRow.insertCell(0);
oneCell.innerHTML=Name;
oneCell.width=140;
var twoCell=aNewRow.insertCell(1);
var twoCell=aNewRow.insertCell(1);
twog. 🎜>twoCell.width=280;
var threeCell=aNewRow.insertCell(2);
threeCell.innerHTML=Phone;
NewCell.width=100; fourCell.innerHTML="刪除";
fourCell.width=40;
if(input.value!="")
input.value =",";
input.value =Id;
}
}
}
}
}
}
}
}
}
function DeleteRow(id,obj,field)
{
obj.parentNode.parentNode. parentNode.removeChild(obj.parentNode.parentNode)
var nname = document.getElementById("table2");
if(nname.rows.length==1)
{
nname.deleteRow( 0);
}
//已經儲存到資料庫的查詢之後上面清單沒有的情況
if(document.getElementById("AlterNativeVenues_" id)!=null||document.getElementById("AlterNativeVenues_" id)!=undefined)
{
if(document.getElementById("AlterNativeVenues_" id).checked==true)
{
document.getElementById("AlterNativeVenues_ 🎜>document.getElementById("AlterNativeVenues_eck"al) ;
}
}
//非選取狀態需要把id從隱藏控制項裡面移除
var arrs=document.getElementById(field).value.substr(0,document.getElementById(field ).value.length-1).split(',');
//定義一個欄位重新取得id
var newids="";
for(var arr=0;arr{
if(arrs[arr]!=id)
newids =arrs[arr] ",";
}
//重新給隱藏控制項賦值
//重新賦值隱藏控制
//最後一個字元可能是,
var fh=newids.substr(newids.length-1,newids.length);
if(fh==", ")
{
document.getElementById(field).value=newids.substr(0,newids.length-1);
}
else
document.getElementById(field).value =newids;
}
