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;
}
}