在职人员 __FzvHfvXn2CJUj1uucEj __MaYb74WQzpuReipenIM true 5 false false false false false relatedForm month normal false 0 __PKmAV6wvcwAGZBdSndr true __UDJZRqjDAOtuiTdKEuu public "+department) var whereStr=" " if(isNotNull(securityName)){ whereStr += "and ITEM_securityName like '%"+securityName+"%' "; } if(isNotNull(documentID)){ whereStr += "and ITEM_documentID like '%"+documentID+"%' "; } if(isNotNull(department)){ whereStr += "and '"+department+"' like concat('%',ITEM_DeptId,'%')"; } var sql="select * from ( select ITEM_userID as id,domainid,ITEM_securityName,ITEM_documentID,item_phone"+ " from baibaodunFlow.vw_employee where domainid='"+getDomainid()+"' and ITEM_isInMyCompany='1' ) t "+whereStr; println(sql) return sql; })()]]> [] 1 02 0 0