search.js

医院信息系统(Hospital Information System

var SQLExpression="";
var parameterArray=new Array();

/////////////////////////////////////////////
//////////////////////去掉字符串中的空格
function  jtrim(s)
{
    var  i,b=0,e=s.length;
    for(i=0;i<s.length;i++)
        if(s.charAt(i)!=' '){b=i;break;}
    if(i==s.length)
        return  "";
    for(i=s.length-1;i>b;i--)
        if(s.charAt(i)!=' '){e=i;break;}
    return  s.substring(b,e+1);
}
////////////////////////////////////////////////////////
///////////////////高级查询的初始化
function init()
{
	parameterArray=window.dialogArguments;
	//document.getElementById("baseTableName").value=checkUndefined(parameterArray["baseTableName"]);
	//document.getElementById("superTableName").value=checkUndefined(parameterArray["superTableName"]);
	document.getElementById("keyNames").value=checkUndefined(parameterArray["keyNames"]);
	document.getElementById("menuID").value=checkUndefined(parameterArray["menuID"]);
	document.getElementById("searchText").value=checkUndefined(parameterArray["searchText"]);
	document.getElementById("searchSQL").value=checkUndefined(parameterArray["searchSQL"]);
	document.getElementById("orderColumn").value=checkUndefined(parameterArray["orderColumn"]);
	document.getElementById("orderKind").value=checkUndefined(parameterArray["orderKind"]);
	document.getElementById("multiSort").value=checkUndefined(parameterArray["multiSort"]);
	document.getElementById("pageShowType").value=checkUndefined(parameterArray["pageShowType"]);
	
	SQLExpression=parameterArray["searchSQL"];
}
//////////////////////////////////////////////////////////
//////////////////////根据用户的选择产生相应的查询条件
function Search(jointWord,jointWordChs)
{
	//jointWord代表按下的是“与”还是“或”
	
	var tempTableName=document.getElementById("superTableName").value;
	
	var columnNameIndex=document.getElementById("select1").selectedIndex;
	var relationIndex  =document.getElementById("select2").selectedIndex;
	
	//代表查询数据项的内容
    var columnName=document.getElementById("select1").options(columnNameIndex).value;
    //代表关系符的内容
    var relationContent=document.getElementById("select2").options(relationIndex).innerText;
	
	//代表查询数据项内容所转化的值
	var itemValue=tempTableName+"."+columnName;
    //代表表达式的内容
	var expressionContent=document.getElementById("text1").value;
	           
	if(	(document.getElementById("text1").value=="") && 
		(document.getElementById("select2").options[columnNameIndex].innerText!="=空") && 
		(document.getElementById("select2").options[relationIndex].innerText!="<>空"))
	{
		alert("表达式不能为空,请填写!");
	}
	else
	{
		if(document.getElementById("searchText").value=="")
		{
			document.getElementById("searchText").value=columnName+" "+relationContent+" "+expressionContent;
			switch(relationContent)
			{
				case "=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case "<>":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case ">":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case ">=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case "<":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"' or "+itemValue+" is null";break;
				case "<=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"' or "+itemValue+" is null";break;
				case "包含":
					SQLExpression =itemValue+" "+"like"+" "+"'%"+expressionContent+"%'";break;
				case "不包含":
					SQLExpression =itemValue+" "+"not like"+" "+"'%"+expressionContent+"%'";break;
				case "=空":
					SQLExpression =itemValue+" is null";break;
				case "<>空":
					SQLExpression =itemValue+" is not null";break;
				case "包含%":
					SQLExpression =itemValue+" like "+"'"+expressionContent+"%'";break;
				case "不含%":
					SQLExpression =itemValue+" not like "+"'"+expressionContent+"%'";break;
			}
		}
		else
		{
			document.getElementById("searchText").value="("+document.getElementById("searchText").value+")"+" "+jointWordChs+" "+columnName+" "+relationContent+" "+expressionContent;
			switch(relationContent)
			{
				case "=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case "<>":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case ">":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case ">=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case "<":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"'  or "+itemValue+" is null)";break;
				case "<=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"'  or "+itemValue+" is null)";break;
				case "包含":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"like"+" "+"'%"+expressionContent+"%')";break;
				case "不包含":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"not like"+" "+"'%"+expressionContent+"%')";break;
				case "=空":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" is  null)";break;
				case "<>空":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" is not null)";break;
				case "包含_%":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"like"+" "+"'"+expressionContent+"')";break;
				case "不含_%":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"not like"+" "+"'"+expressionContent+"')";break;
			}
		}
	}
	
    SQLExpression="("+SQLExpression+")";
	//存储要回传的SQL表达式
    document.getElementById("searchSQL").value=SQLExpression;
}
///////////////////////////////////////////////////////////////
/////////////////////清空查询条件
function expression_clear()
{
    document.getElementById("searchSQL").value="";
    document.getElementById("searchText").value="";
    SQLExpression="";
}
//////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////点击确定的操作：将查询的条件放入域中，并且传递条件至servlet查询
function form_submit()
{
	if(document.getElementById("searchText").value=="")
    {
        alert("请输入查询的条件");
    }
    else
    {
        document.deleteActionForm.submit();
        window.close();
    }
}

//如果传入参数的值为null或者undefined，则转化为空串
function checkUndefined(str){
	if(str==undefined||str==null){
		str=""	
	}	
	return str;
}