//多功能查询
|
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;
|
}
|