| | |
| | | idList.add(acc.id); |
| | | } |
| | | } |
| | | // 20210623 SQL优化 Start |
| | | // List<Account> exsitAcc = [select id,Hospital_Department_Class__c,name from Account where Hospital_Department_Class__c in:idList]; |
| | | List<Account> exsitAcc = new List<Account>(); |
| | | if (idList.size() > 0) { |
| | | exsitAcc = [select id,Hospital_Department_Class__c,name from Account where Hospital_Department_Class__c in:idList]; |
| | | } |
| | | |
| | | // 20210623 SQL优化 End |
| | | List<Account> exsitAcc = [select id,Hospital_Department_Class__c,name from Account where Hospital_Department_Class__c in:idList]; |
| | | for(Account acc: exsitAcc){ |
| | | exsitMapAcc.put(acc.Hospital_Department_Class__c, acc.name); |
| | | } |