📄 qry.js
字号:
type=2;
}
}
var obj = document.all("PLList");
allCount=obj.rows.length;
if(allCount==2){
form1.act.value=type;
forsubmit(form1);
return true;
}else if(allCount>2){
if(getValidate(form1)){
form1.act.value=type;
forsubmit(form1);
return true;
} else
return false;
}
}
function selectTotal(obj){
for (i=0; i<obj.options.length; i++){
obj.options[i].selected = true;
}
}
function doValue( rid){
index=rid.rowIndex;
allRow=rid.parentElement.rows.length;
var form1 =document.forms(0);
var destObj;
if(allRow==3){
destObj=form1.whereValue;
}else{
destObj=form1.whereValue[index-2];
}
var dataType=destObj.dataType;
switch(dataType){
case 'd':
fPopUpCalendarDlg(destObj);
break;
case 'code':
fPopUpCodeDlg(destObj.id);
break;
case 'OU':
fPopUpCodeDlg(destObj.id);
break;
default:
break;
}
return true;
}
function forSelItem(rid,ori){
index=rid.rowIndex;
allRow=rid.parentElement.rows.length;
var txtObj;
var buttonObj;
var form1 =document.forms(0);
if(allRow==3){
buttonObj=form1.selvalue;
txtObj=form1.whereValue;
}else{
buttonObj=form1.selvalue[index-2];
txtObj=form1.whereValue[index-2];
}
var itemID;
var setId;
for (i=0; i<ori.options.length; i++){
if( ori.options[i].selected ){
itemID=ori.options[i].value;
break;
}
}
if(itemID=="ID"){
setId="A001";
}else if(itemID=="ORGUID"){
setId="B001";
}else{
setId=itemID.substring(0,4);
}
var itemlist=itemHash.get(setId);
var codeobj=itemlist.get(itemID);
var datatype=codeobj.dataType;
txtObj.value="";
txtObj.dataType=datatype;
switch(datatype){
case 'code':
txtObj.dict_num=codeobj.code;
txtObj.dict="yes";
txtObj.code="";
//txtObj.readOnly=true;
buttonObj.disabled=false;
break;
case 'd':
buttonObj.disabled=false;
break;
case 'OU':
txtObj.dict_num="OU";
txtObj.dict="yes";
txtObj.code="";
buttonObj.disabled=false;
break;
default:
buttonObj.disabled=true;
txtObj.dict_num="";
txtObj.dict="no";
txtObj.code="";
txtObj.readOnly=false;
break;
}
return true;
}
//*******************************
function BetchforSelItem(arg){
var buttonObj;
var txtObj;
var itemlist=itemIfoHash
var length=itemlist.size();
var key=itemlist.keys();
var flage=true;
buttonObj=document.all.selvalue;
txtObj=document.all.itemValue;
var codeobj= itemlist.get(arg.value);
var datatype=codeobj.dataType;
var proper=codeobj.prop;
txtObj.value="";
txtObj.dataType=datatype;
switch(datatype){
case 'code':
txtObj.dict_num=codeobj.code;
txtObj.dict="yes";
txtObj.code="";
txtObj.readOnly=true;
if(proper=="2")
buttonObj.disabled=true;
else
buttonObj.disabled=false;
break;
case 'd':
if(proper=="2")
buttonObj.disabled=true;
else
buttonObj.disabled=false;
break;
case 'OU':
txtObj.dict_num="OU";
txtObj.readOnly=false;
txtObj.dict="yes";
txtObj.code="";
if(proper=="2")
buttonObj.disabled=true;
else
buttonObj.disabled=false;
break;
default:
buttonObj.disabled=false;
txtObj.readOnly=false;
txtObj.dict_num="";
txtObj.dict="no";
txtObj.code="";
break;
}
//}
return true;
}
function BetchdoValue(){
var destObj=document.all.itemValue;
var dataType=destObj.dataType;
switch(dataType){
case 'd':
fPopUpCalendarDlg(destObj);
break;
case 'code':
fPopUpCodeDlg(destObj.id);
break;
case 'OU':
fPopUpCodeDlg(destObj.id);
break;
default:
break;
}
return true;
}
function forReset(myform){
var mycount=myform.setType.length;
for(i=0;i<mycount;i++){
if(myform.setType[i].checked){
break;
}
}
myform.setType[0].disabled=false;
myform.setType[1].disabled=false;
myform.setType[2].disabled=false;
myform.ok.disabled=false;
return true;
}
function forReturn(myform){
var ss=myform.classId.value;
var ss2=myform.mode.value;
var ss1=null;
var mycount=myform.setType.length;
for(i=0;i<mycount;i++){
if(myform.setType[i].checked){
ss1=myform.setType[i].value
break;
}
}
if(ss2=="1")ss1=null;
document.location="/qry/qryList.do?classId="+ss+"&mode="+ss2+"&qryType="+ss1+"";
}
function getValidate(form1){
var len=form1.whereValue;
var ssAll="";
if(len.length==null){
var ss1=form1.whereSet;
var ss1Name;
if(ss1.value==""){
alert("指标集名称不能为空");
return false;
}
for (i=0; i<ss1.options.length; i++){
if( ss1.options[i].selected ){
ss1Name=ss1.options[i].text;
break;
}
}
var ss2=form1.whereItem;
var ss2Name;
if(ss2.value==""){
alert("指标项名称不能为空");
return false;
}
for (i=0; i<ss2.options.length; i++){
if( ss2.options[i].selected ){
ss2Name=ss2.options[i].text;
break;
}
}
var ss3=form1.whereOper;
var ss3Name;
if(ss3.value==""){
alert("条件不能为空");
return false;
}
for (i=0; i<ss3.options.length; i++){
if( ss3.options[i].selected ){
ss3Name=ss3.options[i].text;
break;
}
}
var ss4=form1.whereLogic.value;
if (ss4=="AND"||ss4=="or"){
alert('查询条件有错');
return false;
}
var ss5=form1.whereBrace.value;
if (ss5=="("||ss5==")"){
alert('查询条件有错');
return false;
}
var ssValue=form1.whereValue.value;
if(ss1=="--请选择--"){
alert('请选择指标');
return false;
}
if(ss2=="--请选择--"){
alert('请选择指标项');
return false;
}
if(ss3==""){
alert('请选择比较条件');
return false;
}
if(ss3.value!=2&&ss3.value!=3&&ss3.value!=8&&ss3.value!=9)
{
if(ssValue==""){
alert("请输入条件值");
return false;
}
}
ssAll+=" "+ss1Name+"."+ss2Name+" "+ss3Name+" "+ssValue;
//alert(ssAll);
return true;
}else{
for(var k=0;k<len.length;k++){
var ss1=form1.whereSet[k];
var ss1Name;
if(ss1.value==""){
alert("指标集名称不能为空");
return false;
}
for (i=0; i<ss1.options.length; i++){
if( ss1.options[i].selected ){
ss1Name=ss1.options[i].text;
break;
}
}
var ss2=form1.whereItem[k];
var ss2Name;
if(ss2.value==""){
alert("指标项名称不能为空");
return false;
}
for (i=0; i<ss2.options.length; i++){
if( ss2.options[i].selected ){
ss2Name=ss2.options[i].text;
break;
}
}
var ss3=form1.whereOper[k];
var ss3Name;
if(ss3.value==""){
alert("条件不能为空");
return false;
}
for (i=0; i<ss3.options.length; i++){
if( ss3.options[i].selected ){
ss3Name=ss3.options[i].text;
break;
}
}
var ss4=form1.whereLogic[k];
var ss4Name;
for (i=0; i<ss4.options.length; i++){
if( ss4.options[i].selected ){
ss4Name=ss4.options[i].value;
break;
}
}
var ss5=form1.whereBrace[k];
var ss5Name;
for (i=0; i<ss5.options.length; i++){
if( ss5.options[i].selected ){
ss5Name=ss5.options[i].text;
break;
}
}
var ssValue=form1.whereValue[k].value;
if(ss1=="--请选择--"){
alert('请选择指标');
return false;
}
if(ss2=="--请选择--"){
alert('请选择指标项');
return false;
}
if(ss3==""){
alert('请选择比较条件');
return false;
}
if((ss4=="")&&(k<len.length-1)){
alert('请选择过滤条件');
return false;
}
if(ss3.value!=2&&ss3.value!=3&&ss3.value!=8&&ss3.value!=9)
{
if(ssValue==""){
alert("请输入条件值");
return false;
}
}
ssAll+=" "+ss1Name+"."+ss2Name+" "+ss3Name+" "+ssValue+" "+ss4Name+" "+ss5Name;
}
if(form1.whereLogic[len.length-1].value!="")
{
alert('查询条件有错');
return false;
}
for(var k=0;k<form1.whereLogic.length-1;k++){
if(form1.whereLogic[k].value==""){
alert("查询条件有错");
return false;
}
}
/*888888888*/
var ss0=ssAll;
var h=0;
var m=0;
var ssa=ss0;
var ssb=ss0;
for(var i=0;i<ssa.length;i++){
while(ssa.indexOf("(")>0){
h++;
ssa=ssa.substring(ssa.indexOf("(")+1,ssa.length);
}
}
for(var i=0;i<ssb.length;i++){
while(ssb.indexOf(")")>0){
m++;
ssb=ssb.substring(ssb.indexOf(")")+1,ssb.length);
}
}
if(h!=m){
alert('查询条件有括号不对称');
}else{
//alert(ssAll);
return true;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -