参数OLD_DEPT长度为0时LENGTH(a.DEPT_CODE)=6,否则判断参数OLD_DEPT长度为6时LENGTH(a.DEPT_CODE)=6,参数OLD_DEPT长度为8时LENGTH(a.DEPT_CODE)=8,
${IF( LEN(OLD_DEPT)=0," AND "+ LENGTH(a.DEPT_CODE)=6 ,IF( LEN(OLD_DEPT)=6," AND "+ LENGTH(a.DEPT_CODE)=6,"AND"+ LENGTH(a.DEPT_CODE)=8 ) ) }
帆软的长度用len() 多了 $,双引号位置也不对
---------
${IF(LEN(OLD_DEPT)=0," AND LENGTH(a.DEPT_CODE)=6" ,IF(LEN(OLD_DEPT)=6," AND LENGTH(a.DEPT_CODE)=6","AND LENGTH(a.DEPT_CODE)=8")) }
用len()函数,帆软里面是len() 例如:${if(len(dept_code)=0 && len(dept_code)=8,"a","b")} &&是and的意思,||代表或的意思
${if(len(OLD_DEPT)==0,"and LENGTH(a.DEPT_CODE)=6",if(len(OLD_DEPT)==6,"and LENGTH(a.DEPT_CODE)=6",if(len(OLD_DEPT)==8,"and LENGTH(a.DEPT_CODE)=8","")))}