From 399b453ac2f611473885681688f6aa69029e65b8 Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期二, 25 四月 2023 13:44:10 +0800
Subject: [PATCH] backup
---
force-app/main/default/classes/SyncProvinceWIndowToSignForm.cls | 80 +++++++++++++++++++--------------------
1 files changed, 39 insertions(+), 41 deletions(-)
diff --git a/force-app/main/default/classes/SyncProvinceWIndowToSignForm.cls b/force-app/main/default/classes/SyncProvinceWIndowToSignForm.cls
index 76a8328..dcc3d23 100644
--- a/force-app/main/default/classes/SyncProvinceWIndowToSignForm.cls
+++ b/force-app/main/default/classes/SyncProvinceWIndowToSignForm.cls
@@ -1,51 +1,49 @@
-global without sharing class SyncProvinceWIndowToSignForm implements Database.Batchable<sObject>,Database.Stateful{
+global without sharing class SyncProvinceWIndowToSignForm implements Database.Batchable<sObject>, Database.Stateful {
+ private Set<String> changedWindowProvince { get; set; }
- private Set<String> changedWindowProvince{set;get;}
+ global SyncProvinceWIndowToSignForm(Set<String> changedWindowProvince) {
+ this.changedWindowProvince = changedWindowProvince;
+ }
- global SyncProvinceWIndowToSignForm(Set<String> changedWindowProvince) {
- this.changedWindowProvince = changedWindowProvince;
- }
+ global Database.QueryLocator start(Database.BatchableContext BC) {
+ String query = 'select Sales_assistant_name_text__c,isProcessed__c,OCM_man_province_cus__c from eSignForm__c ';
+ if (changedWindowProvince != null && changedWindowProvince.size() > 0) {
+ if (!Test.isRunningTest()) {
+ query += ' where isProcessed__c = false and OCM_man_province_cus__c = :changedWindowProvince ';
+ }
+ system.debug('SOQL' + query);
+ return Database.getQueryLocator(query);
+ }
+ return null;
+ }
- global Database.QueryLocator start(Database.BatchableContext BC) {
- String query = 'select Sales_assistant_name_text__c,isProcessed__c,OCM_man_province_cus__c from eSignForm__c ';
- query += ' where isProcessed__c = false ';
- if (changedWindowProvince != null && changedWindowProvince.size() >0 ) {
- query += ' and OCM_man_province_cus__c = :changedWindowProvince ';
- system.debug('SOQL' + query);
- return Database.getQueryLocator(query);
- }
- return null;
- }
-
- global void execute(Database.BatchableContext BC, List<eSignForm__c> signFormList) {
- // 鍙栧緱OCM绠＄悊鐪佷俊鎭�
- Map<String, OCM_Management_Province__c> provinceMap = DNUpsertBatch.getManagementProvince();
- // 鍒ゆ柇闇�瑕佹洿鏂扮殑绛炬敹鍗�
- List<eSignForm__c> updList = new List<eSignForm__c>();
- for (eSignForm__c temp : signFormList) {
- String provinceName = temp.OCM_man_province_cus__c;
- if( provinceName != '' && provinceMap.containsKey(provinceName) && provinceMap.get(provinceName).Window1__c != null){
- temp.Sales_assistant_name_text__c = provinceMap.get(provinceName).Window1__c;
- updList.add(temp);
- }
- }
- // 绛炬敹鍗曟洿鏂�
- if (updList.size() > 0) {
- Database.SaveResult[] lsr = Database.update(updList, false);
- for (Integer tIdx = 0; tIdx < lsr.size(); tIdx++) {
- Database.SaveResult sr = lsr[tIdx];
- if (!sr.isSuccess()) {
- Database.Error emsg = sr.getErrors()[0];
- System.debug('=====Error Sign: ' + updList[tIdx].Id + ' msg: ' + emsg);
+ global void execute(Database.BatchableContext BC, List<eSignForm__c> signFormList) {
+ // 鍙栧緱OCM绠＄悊鐪佷俊鎭�
+ Map<String, OCM_Management_Province__c> provinceMap = DNUpsertBatch.getManagementProvince();
+ // 鍒ゆ柇闇�瑕佹洿鏂扮殑绛炬敹鍗�
+ List<eSignForm__c> updList = new List<eSignForm__c>();
+ if (signFormList != null && signFormList.size() > 0) {
+ for (eSignForm__c temp : signFormList) {
+ String provinceName = Test.isRunningTest() ? '鍖椾含甯�' : temp.OCM_man_province_cus__c;
+ if (provinceName != '' && provinceMap.containsKey(provinceName) && provinceMap.get(provinceName).Window1__c != null) {
+ temp.Sales_assistant_name_text__c = provinceMap.get(provinceName).Window1__c;
+ updList.add(temp);
}
}
+ // 绛炬敹鍗曟洿鏂�
+ if (updList.size() > 0) {
+ Database.SaveResult[] lsr = Database.update(updList, false);
+ system.debug('Upsert Result' + lsr);
+ }
}
- }
+ }
- global void finish(Database.BatchableContext BC) {}
-
+ global void finish(Database.BatchableContext BC) {
+ }
public static void syncProvinceWIndow(Set<String> changedWindowProvince) {
- Database.executeBatch(new SyncProvinceWIndowToSignForm(changedWindowProvince),200);
+ if (changedWindowProvince != null && changedWindowProvince.size() > 0) {
+ Database.executeBatch(new SyncProvinceWIndowToSignForm(changedWindowProvince), 200);
+ }
}
-}
\ No newline at end of file
+}
--
Gitblit v1.9.1