Outside_SecuritySeviceCompany __Y9CgIRXkFMdS6B9o5P8 __wGomeHJBz6CpLFCCl4y 外地保安服务公司信息 true 05 true false false false false relatedForm month normal false 0 __ynGeRfB8O9NquTWSRxG false public : " + superiorDept); //sql += " AND s.item_registerpoliceidindex LIKE '%" + superiorDept + "%'"; sql += " AND c.ITEM_REGISTERADDRESS not LIKE '%湖南%' ";//注册地在湖南省之外 //sql += " AND s.item_registerPoliceIDIndex not like '"+superiorDept+"%' ";//过滤出不在本监管地的数据 //查询条件过滤 var companyName=getItemValueAsString("s_companyName"); var legalPerson=getItemValueAsString("s_legalPerson"); var legalPersonPhone=getItemValueAsString("s_legalPersonPhone"); if(isNotNull(companyName)){ sql+=" AND item_companyName like '%"+companyName+"%'"; } if(isNotNull(legalPerson)){ sql+=" AND item_legalPerson like '%"+legalPerson+"%'"; } if(isNotNull(legalPersonPhone)){ sql+=" AND item_legalPersonPhone like '%"+legalPersonPhone+"%'"; } println("Outside_SecuritySeviceCompany="+sql); return sql; })()]]> [] 277 02 0 0