//多功能查询
function multifunctional(valueis, colis, jqcz,f) {// 一般like查找,jqcz勾上则=
	var sqlReturn = "";
	var value = document.getElementById(valueis).value;
	var cols = document.getElementById(colis).value;
	var colss = null;
	var dts = null;   //每个字段的数据类型
	var temp = null;  //临时数组,用于保存参数分割后的字段和字段对应的数据类型
	if (cols != null) {
		if(cols.indexOf("|") >=0)
		{
			temp = cols.split("|");
			colss = temp[0].split(";");
			dts = temp[1].split(";");
		}else{
			colss = cols.split(";");
		}
	}
	//if(dts != null){	//如果是查询全部,清空条件输入框
		//document.getElementById(valueis).value = "";
		//value = "";
//	}
	var gou = document.getElementById(jqcz).value;
	var fuhao = (gou == "1") ? " = " : " "+f+" ";
	var val = (gou == "1") ? value : "@~" + value + "@~";
	for (i = 0; i < colss.length; i++) {
		if(dts != null){     //查询全部
			if(dts[i] == "money" || dts[i] == "int"){
				continue;
			}else{
				sqlReturn += colss[i] + fuhao + " \'" + val + "\' or ";
			}
		}else{	//单个查询
			temp = (document.getElementById('dataType').value).split("|");	//得到所有字段和所有字段对应的数据类型
			var colss1 = temp[0].split(";");
			dts = temp[1].split(";");
			var index = 0;
			for(var j = 0;j<colss1.length;j++){   //查询下拉列表选中字段在所有字段中的下标
				if(colss[i] == colss1[j]){		
					index = j;
					break;
				}
			}
			if(dts[index] == "money" || dts[index] == "int"){	//得到字段数据类型判断是否为Money或者Int类型
				if(value == null || value == ""){	//判断查询的值是否为空
					sqlReturn += colss[i] + " is null or ";
				}else{
					sqlReturn += colss[i] +" = "+  value +  " or ";
				}
			}else{	//其他数据类型
				sqlReturn += colss[i] + fuhao + " \'" + val + "\' or ";
			}
		}
//		sqlReturn += colss[i] + fuhao + " \'" + value + "\' or ";
	}
	if (colss == "") {
		sqlReturn = "";
	} else {
		sqlReturn = sqlReturn.substring(0, sqlReturn.length - 3);
		//alert(sqlReturn);
	}	
	return sqlReturn;
}
// 复选框
function getCheck(id,f) {
	var sqlStr = "";
	var idCheck = id + "CheckBox";
	if (document.getElementById(idCheck).checked) {
		sqlStr = id + " "+f+" \'" + document.getElementById(idCheck).value + "\'";
		// alert(sqlStr);
	}
	return sqlStr;
}
// 单选按钮
function getRadio(id,f) {
	var rads = document.getElementsByName(id+"Radio");
	var sqlStr = "";
	for (i = 0; i < rads.length; i++) {
		if (rads[i].checked) {
			document.getElementById(id).value=rads[i].value;
			sqlStr = id + " "+f+" " + rads[i].value;
			// alert(sqlStr);
		}
	}
	return sqlStr;
}
// 日期之间
function getBetweenDate(date, bengin, end) {
	var sqlStr = "";
	var ben = document.getElementById(bengin).value;
	var en = document.getElementById(end).value;
	if (ben != "" && en != "") {
		sqlStr = date + "  between \'" + ben + "\' and \'" + en + "\' ";
		// alert(sqlStr);
	}
	return sqlStr;
}
// 下拉，有可能逗号分隔
function getSelect(col, fuhao) {
	var sqlStr = "";
	var vStr = document.getElementById(col).value;
	if (vStr != "" && vStr != 'null') {
	  sqlStr = getSql(col,vStr,fuhao);
	}
//	if (vStr != "") {
//		var vStrs = vStr.split(",");
//		vStr = "";
//		for (i = 0; i < vStrs.length; i++) {
//			vStr += "'" + vStrs[i] + "',";
//		}
//		vStr = vStr.substring(0, vStr.length - 1);
//		sqlStr = col + " " + fuhao + " (" + vStr + ") ";
//		// alert(sqlStr);
//	}
	return sqlStr;
}
// 复选框，多选。 1.控件name 2.符合
function getCheckList(id,idCheck, f) {
	var checks = document.getElementsByName(idCheck);
	var sqlStr = "";
	for (i = 0; i < checks.length; i++) {
		if (checks[i].checked) {
			sqlStr += id + " " + f + " " + checks[i].value + " or ";
		}
	}
// alert(sqlStr);
	sqlStr = sqlStr.substring(0, sqlStr.length - 3);
	return sqlStr;
}
// 输入文本 1.控件id 2.符合
function getText(id, f) {
	var sqlStr = "";
	var value = document.getElementById(id).value;
	if (value != "") {
		sqlStr += id + " " + f + " (\'" + value +"\')";
	}
	// alert(sqlStr);
	return sqlStr;
}


function getSql(id,valStr,f){
	var Str="";
	switch(f){
	case "=":
	case "in":
		Str = " isnull(\'"+valStr+"\',\'\') = \'\' or "+id+" "+ f +" ( select list from getinstr(\'"+valStr+"\'))"
		break;
	case "like":
	case "not like"://为使用
		Str=" isnull(\'"+valStr+"\',\'\') = \'\' or "+id+" "+ f +" '@~"+valStr+"@~' ";
		break;
	default :
		break;
	}
	return Str;
}


function getqx(ReaderUsercodes,ReaderOrganizations,ReaderRoles){
	var str="( isnull(ReaderUsercodes,'') =  '' and isnull(ReaderOrganizations,'') =  '' and isnull(ReaderRoles , '' )  =  '' ) ";
	var shuZu=ReaderUsercodes.split(',');
	var strHui=getStr('ReaderUsercodes',shuZu);
	if(strHui!=""){
		str +=" or "+strHui;		
	}
	shuZu=ReaderOrganizations.split(',');
	strHui=getStr('ReaderOrganizations',shuZu);
	if(strHui!=""){
		str +=" or "+strHui;		
	}
	shuZu=ReaderRoles.split(',');
	strHui=getStr('ReaderRoles',shuZu);
	parent.rot=shuZu;
	if(strHui!=""){
		str +=" or "+strHui;		
	}
	return getKuoHao(str);
}

function getStr(col,shuZhu){
	var str="isnull("+col+",'') <>  '' and ";
	var strAdd="";
	for(var i=0;i<shuZhu.length;i++){
		if(shuZhu[i]!=""){
			strAdd +=" ("+col+" like   '@~,"+shuZhu[i]+",@~') or";
		}
	}
	if(strAdd!=""){
		strAdd=strAdd.substring(0, strAdd.length - 2);
		strAdd=getKuoHao(strAdd);
	}else{//没有就不判断了
		str="";
	}
	str += strAdd;
	str=getKuoHao(str);
	return str;
}

function getKuoHao(str){ 
	if(str!=""){
		str="( "+str+" )";
	}
	return str;
}