高章伟
2023-03-03 d8dc84a3d56df839895f1c417a4d9cbee763d262
force-app/main/default/classes/AfterCreateHospitalTrigger.cls
@@ -33,14 +33,7 @@
                     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);
            }