gzw 测试环境代码更新

高章伟

2023-03-03 d8dc84a3d56df839895f1c417a4d9cbee763d262

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
global class SumEquipmentInventory implements Database.Batchable<sObject> {
    public String query;
 
    global SumEquipmentInventory() {
        this.query = query;
    }
 
    global Database.QueryLocator start(Database.BatchableContext bc) {
        query = 'select Hospital__c , COUNT(Id)conData from Asset where Status =\'使用中\' group by Hospital__c';
        return Database.getQueryLocator(query);
    }
 
    global void execute(Database.BatchableContext BC, list<AggregateResult> assList) {
        // Map<Account_Service_Of_Target__c,Integer> count = new Map<Account_Service_Of_Target__c,Integer>();
        List<Account_Service_Of_Target__c> asList = new List<Account_Service_Of_Target__c>();
        for (AggregateResult ass : assList ) {
            Account_Service_Of_Target__c asItem = new Account_Service_Of_Target__c();
            asItem.Account_HP__c = (Id)ass.get('Hospital__c');
            asItem.Equipment_Inventory_No__c = (Decimal)ass.get('conData');
            asList.add(asItem);
        }
        upsert asList;
    }
 
    global void finish(Database.BatchableContext BC) {
 
    }
}