| | |
| | | List<Attachment> NtList = [Select id,ParentId,Name,Body FROM Attachment where Id in : Rlist]; |
| | | Map<Id,Repair__c> updateRprMap = new Map<Id,Repair__c>(); |
| | | Map<Id,QIS_Report__c> updateQisMap = new Map<Id,QIS_Report__c>(); |
| | | for (Repair__c re :[select id,Name,SerialNumber__c,Delivered_Product__r.Name,HP_Name__c |
| | | from Repair__c where id in : ParentIdList] ) { |
| | | //DB202308180733 P-新投诉系统GCHS项目--SQL中加入新字段-刘川-Latest_upload_time_attachments__c |
| | | for (Repair__c re :[select id,Name,SerialNumber__c,Delivered_Product__r.Name,HP_Name__c,Latest_upload_time_attachments__c |
| | | from Repair__c where id in : ParentIdList]) { |
| | | //DB202308180733 P-新投诉系统GCHS项目-刘川-新字段赋值 |
| | | re.Latest_upload_time_attachments__c = DateTime.now(); |
| | | updateRprMap.put(re.id, re); |
| | | } |
| | | for (QIS_Report__c qi :[select id,Name,lot_or_serial__c,nonyushohin__r.Name,Hospital__r.Name |
| | | // DB202308180733 P-新投诉系统GCHS项目-刘川-更新字段 |
| | | if (updateRprMap != null && updateRprMap.size() > 0) { |
| | | update updateRprMap.values(); |
| | | } |
| | | for (QIS_Report__c qi :[select id,Name,lot_or_serial__c,nonyushohin__r.Name,Hospital__r.Name,Latest_upload_time_attachments__c |
| | | from QIS_Report__c where id in : ParentIdList] ) { |
| | | qi.Latest_upload_time_attachments__c = DateTime.now(); |
| | | updateQisMap.put(qi.id, qi); |
| | | } |
| | | //DB202308180733 P-新投诉系统GCHS项目-刘川-更新字段 |
| | | if (updateQisMap != null && updateQisMap.size() > 0) { |
| | | update updateQisMap.values(); |
| | | } |
| | | // Map<Id,Repair__c> updateRprMap = [select id,Name,SerialNumber__c,Delivered_Product__r.Name |
| | | // from Repair__c where id in : ParentIdList]; |
| | | // Map<Id,QIS_Report__c>updateQisMap = [select id,Name,lot_or_serial__c,nonyushohin__r.Name |