From 4f200849487fc6f914e237d5af3ecefd6d802457 Mon Sep 17 00:00:00 2001
From: buli <137736985@qq.com>
Date: 星期一, 10 七月 2023 09:52:59 +0800
Subject: [PATCH] backup1007
---
force-app/main/default/triggers/ConsumableOrderDetail2Trigger.trigger | 57 +++++++++++++++++++++++++++------------------------------
1 files changed, 27 insertions(+), 30 deletions(-)
diff --git a/force-app/main/default/triggers/ConsumableOrderDetail2Trigger.trigger b/force-app/main/default/triggers/ConsumableOrderDetail2Trigger.trigger
index c99b289..ae0c34a 100644
--- a/force-app/main/default/triggers/ConsumableOrderDetail2Trigger.trigger
+++ b/force-app/main/default/triggers/ConsumableOrderDetail2Trigger.trigger
@@ -333,11 +333,14 @@
update consumableOrderlist;
}
}
- //Back up by DTT - Li Jun 2023-06-14 Start for reduce soql times
+
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鑾峰彇鎵�鏈夌殑record ID start by 寮犵帀灞�
- //List<RecordType> allrtList = [select Id,DeveloperName from RecordType where SobjectType = 'Consumable_orderdetails__c'];
+ List<RecordType> allrtList = [
+ SELECT Id, DeveloperName
+ FROM RecordType
+ WHERE SobjectType = 'Consumable_orderdetails__c'
+ ];
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鑾峰彇鎵�鏈夌殑record ID end by 寮犵帀灞�
- //Back up by DTT - Li Jun 2023-06-14 Start
//鍒拌揣鍜岃繑鍝佹椂,鐢熸垚鎴栦慨鏀规秷璐瑰搧璁㈣揣鏄庣粏
Set<String> arrivedSet = new Set<String>();
Set<String> returnSet = new Set<String>();
@@ -434,27 +437,22 @@
ar.get('Asset_Model_No__c');
keyCount.put(key, Integer.valueOf(ar.get('recordCount')));
}
- //Back up by DTT - Li Jun 2023-06-14 Start
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鏇夸唬涓嬮潰SQL select start by 寮犵帀灞�
- // List<RecordType> rtList = new List<RecordType>();
- // for(RecordType rtl : allrtList){
- // if('Detail1_Arrival'.equals(rtl.DeveloperName)){
- // rtList.add(rtl);
- // }
- // }
+ List<RecordType> rtList = new List<RecordType>();
+ for (RecordType rtl : allrtList) {
+ if ('Detail1_Arrival'.equals(rtl.DeveloperName)) {
+ rtList.add(rtl);
+ }
+ }
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鏇夸唬涓嬮潰SQL select end by 寮犵帀灞�
- //Back up by DTT - Li Jun 2023-06-14 End
/* 2018骞�8鏈�9鏃� HWAG-B3D9UV 鍘熻幏鍙� recordtype start by 寮犵帀灞�
List<RecordType> rtList = [select Id from RecordType where DeveloperName = 'Detail1_Arrival' and SobjectType = 'Consumable_orderdetails__c'];
2018骞�8鏈�9鏃� HWAG-B3D9UV 鍘熻幏鍙� recordtype end by 寮犵帀灞� */
- //Back up by DTT - Li Jun 2023-06-14 Start
- // Id recordTypeId = null;
- // if (rtList.size() > 0) recordTypeId = rtList[0].Id;
- //Back up by DTT - Li Jun 2023-06-14 End
- Id recordtypeId = Schema.SObjectType.Consumable_Orderdetails__c.getRecordTypeInfosByDeveloperName()
- .get('Detail1_Arrival')
- .getRecordTypeId();
+ Id recordTypeId = null;
+ if (rtList.size() > 0)
+ recordTypeId = rtList[0].Id;
+
results = [
SELECT Consumable_order__c, count(Id) noCount
FROM Consumable_orderdetails__c
@@ -697,24 +695,23 @@
ar.get('Asset_Model_No__c');
keyCount.put(key, Integer.valueOf(ar.get('recordCount')));
}
- //Back up by DTT - Li Jun 2023-06-14 Start for reduce soql times
+
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鏇夸唬涓嬮潰SQL select start by 寮犵帀灞�
- // List<RecordType> rtList = new List<RecordType>();
- // for(RecordType rtl : allrtList){
- // if('Detail1_ReturnGoods'.equals(rtl.DeveloperName)){
- // rtList.add(rtl);
- // }
- // }
+ List<RecordType> rtList = new List<RecordType>();
+ for (RecordType rtl : allrtList) {
+ if ('Detail1_ReturnGoods'.equals(rtl.DeveloperName)) {
+ rtList.add(rtl);
+ }
+ }
// 2018骞�8鏈�9鏃� HWAG-B3D9UV 鏇夸唬涓嬮潰SQL select end by 寮犵帀灞�
- //Back up by DTT - Li Jun 2023-06-14 End
+
/* 2018骞�8鏈�9鏃� HWAG-B3D9UV 鍘熻幏鍙� recordtype start by 寮犵帀灞�
List<RecordType> rtList = [select Id from RecordType where DeveloperName = 'Detail1_ReturnGoods' and SobjectType = 'Consumable_orderdetails__c'];
2018骞�8鏈�9鏃� HWAG-B3D9UV 鍘熻幏鍙� recordtype end by 寮犵帀灞� */
- Id recordTypeId = Schema.SObjectType.Consumable_Orderdetails__c.getRecordTypeInfosByDeveloperName()
- .get('Detail1_ReturnGoods')
- .getRecordTypeId();
- //if (rtList.size() > 0) recordTypeId = rtList[0].Id;
+ Id recordTypeId = null;
+ if (rtList.size() > 0)
+ recordTypeId = rtList[0].Id;
results = [
SELECT Consumable_order__c, count(Id) noCount
--
Gitblit v1.9.1