Get Record(s) by Ids

Use this to get record or records by id.

/** * Created by mengt on 2017/4/18. */public class sobjectDaoHelper {    public static Sobject getById(Id recordId){        String queryStr = 'select ';        String sObjectName = sobjectDaoHelper.findObjectNameFromRecordIdPrefix(recordId);        if(sObjectName == ''|| sObjectName == null){ return null;}        List<Schema.DescribeSObjectResult> sObjectResults = Schema.describeSObjects(new List<String>{sObjectName});        if(sObjectResults == null || sObjectResults.size() == 0) {            return null;        }        Schema.DescribeSObjectResult sObjectResult = sObjectResults.get(0);        Map<String,SObjectField> maps = sObjectResult.fields.getMap();        for(Schema.SObjectField objectField : maps.values()) {            Schema.DescribeFieldResult fieldResult = objectField.getDescribe();            if(fieldResult.isAccessible()) {                queryStr += fieldResult.getName() + ',';            }        }        queryStr = queryStr.substring(0,queryStr.length()-1);        queryStr += ' from ' + sObjectName + ' where Id = :recordId';        List<sObject> objects = Database.query(queryStr);        if(objects == null || objects.size() == 0) {            return null;        }        return objects.get(0);    }    /*    可优化方案：循环查找perfixkey，可用map替换，在数据操作过大的时候计算时间会有所提高    List<Id>限制 50000    List对象限制 100     */    public static String findObjectNameFromRecordIdPrefix(String recordIdOrPrefix){        String objectName = '';        try{            //Get prefix from record ID            //This assumes that you have passed at least 3 characters            String myIdPrefix = String.valueOf(recordIdOrPrefix).substring(0,3);            //Get schema information            Map<String, Schema.SObjectType> gd =  Schema.getGlobalDescribe();            //Loop through all the sObject types returned by Schema            for(Schema.SObjectType stype : gd.values()){                Schema.DescribeSObjectResult r = stype.getDescribe();                String prefix = r.getKeyPrefix();                //Check if the prefix matches with requested prefix                if(prefix!=null && prefix.equals(myIdPrefix)){                    objectName = r.getName();                    break;                }            }        }catch(Exception e){            System.debug(e);        }        return objectName;    }    public static Map<String,List<SObject>> getByIds(List<Id> recordIds){        if(recordIds == null || recordIds.size()>50000){            return null;        }        Map<String,List<Id>> mapIds = new Map<String,List<Id>>();        for (Id thisid : recordIds) {            String objectType = findObjectNameFromRecordIdPrefix(thisid);            if(objectType == '' || objectType == null){ continue; }            if(!mapIds.containsKey(objectType)){                mapIds.put(objectType,new List<Id>());            }            mapIds.get(objectType).add(thisid);        }        if(mapIds.keySet().size() > 100){            return null;        }        Map<String,List<SObject>> returnMap = new Map<String,List<SObject>>();        List<String> objectNames = new List<String>();        objectNames.addAll(mapIds.keySet());        List<Schema.DescribeSObjectResult> sObjectResults = Schema.describeSObjects(objectNames);        for (DescribeSObjectResult sObjectResult : sObjectResults) {            String queryStr = 'select ';            Map<String,SObjectField> maps = sObjectResult.fields.getMap();            for(Schema.SObjectField objectField : maps.values()) {                Schema.DescribeFieldResult fieldResult = objectField.getDescribe();                if(fieldResult.isAccessible()) {                    queryStr += fieldResult.getName() + ',';                }            }            List<Id> queryIds = mapIds.get(sObjectResult.getName());            queryStr = queryStr.substring(0,queryStr.length()-1);            queryStr += ' from ' + sObjectResult.getName() + ' where Id = :queryIds';            returnMap.put(sObjectResult.getName(),Database.query(queryStr));        }        return returnMap;    }}