function fbtnQuery_onclick()
{
	fLog("進行查詢程序!!", 1, false);
	mPageIndex = 1;
	if (fQueryData()) return;
}

function fbtnClear_onclick()
{
	document.body.innerHTML = mBody;
	fLog("進行清除程序!!", 1, false);
	mPageCount = 0;
	mPageIndex = 1;
	mSQLXML = "";
	fPageButtonControl();
}

function fbtnPageFirst_onclick()
{
	fMoveDetail("F");
}

function fbtnPagePrev_onclick()
{
	fMoveDetail("P");
}

function fbtnPageNext_onclick()
{
	fMoveDetail("N");
}

function fbtnPageLast_onclick()
{
	fMoveDetail("L");
}

function fbtnOpen_onclick()
{
	var lRow = window.event.srcElement.parentElement.parentElement;
	var lIndex = lRow.rowIndex;
	if (lRow.pExpand=="N")
	{
		lRow.pExpand = "Y";
		DetailTable.rows[lIndex+1].style.display = "";
		DetailTable.rows[lIndex+2].style.display = "";
		lRow.all("btnOpen").src = "../common/img/foldopen.gif";
	}
	else
	{
		lRow.pExpand = "N";
		DetailTable.rows[lIndex+1].style.display = "none";
		DetailTable.rows[lIndex+2].style.display = "none";
		lRow.all("btnOpen").src = "../common/img/foldclose.gif";
	}
}

function fAfterQuery(pXML)
{
//	alert(unescape(pXML));
}

function fQueryData()
{
	var lXML;
	var lType = "2";
	var lAdvance = "0";
	mPageSize = txtPageSize.value;
	if (radFuzzy.checked) lType = "1";
	lXML = "<LoginUser>" + mLoginUser + "</LoginUser>";
	lXML += "<AppID>" + mAppID + "</AppID>";
	lXML += "<QueryStr>" + txtString.value + "</QueryStr>";
	lXML += "<Type>" + lType + "</Type>";
	lXML += "<PageCount>" + mPageSize + "</PageCount>";
	lXML += "<PageIndex>" + mPageIndex + "</PageIndex>";
	lXML = "<Root>" + lXML + "</Root>";
	fOpenQuery(mAppID + "Query.asp", lXML);
	if (mResult.Err) 
	{
		fLog('無法取出查詢的資料:\n' + mResult.ErrDesc, 3, true);
		return true;
	}
	if (mResult.EOF) 
	{
		fLog('查詢結果為沒有資料!!', 3, true);
		return true;
	}
	mRecordCount = mResult.Single.Rows[0].Count;
	mPageCount = mResult.Single.Rows[0].PageCount
	fClearTable(DetailTable, 4);
	fMoveVauleToDetail(mResult["Multi" + mPageIndex])
	
	disCurPage.innerText = mPageIndex;
	disPageCount.innerText = mPageCount;
	fPageButtonControl();
	txtPageSize.disabled = true;
	return false;
}
// pForward: F-第一頁 N-下一頁 P-上一頁 L-最後一頁
function fMoveDetail(pForward)
{	
	switch (pForward)
	{
		case "F":
			mPageIndex = 1;
			break;
		case "N":
			mPageIndex++;
			if (mPageIndex >= mPageCount) mPageIndex = mPageCount;
			break;
		case "P":
			mPageIndex--;
			if (mPageIndex <= 0) mPageIndex = 1;
			break;
		case "L":
			mPageIndex = mPageCount;
			break;
	}
	fPageButtonControl();
	fQueryData()
}

function fQueryDetail()
{
	fReadDraft("", "Multi" + mPageIndex);
	if (mResult.Err)
	{
		fLog("資料取得失敗:\n" + mResult.ErrDesc, 2, true);
		return;
	}
	fClearTable(DetailTable, 4);
	fMoveVauleToDetail(mResult["Multi"+mPageIndex])	
}


function fMoveValueToScreen(pArea, pData)
{
	var lStr;
	for (var lField in pData)
	{
		if (pArea.all("dis"+lField)!=null)
		{
			if (pArea.all("dis"+lField).getAttribute("pLength") != null)
			{
				pArea.all("dis"+lField).innerText = pData[lField].substr(0,parseInt(pArea.all("dis"+lField).pLength,10)) + "...";
			}
			else
			{
				pArea.all("dis"+lField).innerText = pData[lField]
			}
		}
	}
}

function fMoveVauleToDetail(pData)
{
	for (var i=0; i < pData.Rows.length; i++)
	{
		var lRow = fNewRow(DetailTable, 2);
		lRow.pExpand = 'N';
		lRow.all["disStockName"].pLength = 10;
		lRow.all["disStockEng"].pLength = 10;
		lRow.all["disStaging"].onclick = fCallStaging;
		fMoveValueToScreen(lRow, pData.Rows[i]);
		lRow.all["disStaging"].innerHTML = "<U>" + lRow.all["disStaging"].innerText + "</U>";
		lRow.all["disStaging"].style.cursor = "hand";
		lRow.all["disStaging"].align = "center"
		lRow.all["disTax"].align = "center"
		var lRow = fNewRow(DetailTable, 3);
		lRow.style.display = 'none';
		lRow.cells[1].colSpan = 5;
		lRow.all("txtStockName").innerText = pData.Rows[i].StockName
		var lRow = fNewRow(DetailTable, 4);
		lRow.style.display = 'none';
		lRow.cells[1].colSpan = 5;
		lRow.all("txtStockEng").innerText = pData.Rows[i].StockEng
	}
}

function fNewRow(pTable, pRowIndex)
{
	var lNewRow = pTable.insertRow();
	for (var i=0; i < pTable.rows[pRowIndex].cells.length; i++)
	{
		var lCell = lNewRow.insertCell();
		lCell.innerHTML = pTable.rows[pRowIndex].cells[i].innerHTML;
		lCell.id = pTable.rows[pRowIndex].cells[i].id
	}
	return lNewRow;
}

function fClearTable(pTable, pRowIndex)
{
	var lRowCount = pTable.rows.length;
	for (var i=lRowCount-1;i > pRowIndex; i--)
	{
		pTable.deleteRow(i);
	}
}

function fCancelClick()
{
	if (document.activeElement.id=='btnClear') return true;
	if (document.activeElement.id=='btnExit') return true;
	return false;
}	

function fPageButtonControl()
{
	btnPageFirst.disabled = false;
	btnPagePrev.disabled = false;
	btnPageNext.disabled = false;
	btnPageLast.disabled = false;
	if (mPageIndex <= 1) 
	{
		btnPageFirst.disabled = true;
		btnPagePrev.disabled = true;
	}
	if (mPageIndex == mPageCount || mPageCount== 0) 
	{
		btnPageNext.disabled = true;
		btnPageLast.disabled = true;
	}
}

function fCallStaging()
{
	var lValue = window.event.srcElement.innerText;
	if (lValue != "")
	{
		fOpenDialog("Staging.asp", "s=" + lValue);
	}
}