删除关联关系

付煜

2022-03-24 0ac2c8c62a4ba1b92bcae9f11f7f4d9c6f54875b

 force-app/main/default/classes/TenderDeleteLwcController.cls

@@ -2,7 +2,7 @@
    @AuraEnabled
    public static  String GetTenderinformationcData(String ParamIdStr) {

         List<Tender_information__c> arrays = Database.query('Select Id, InfoId__c, Logical_delete__c, ProjectId__c, Retain_Tender__c From Tender_information__c Where id = : ParamIdStr');
         List<Tender_information__c> arrays = Database.query('Select Id,Name,InfoId__c,Logical_delete__c,ProjectId__c,Retain_Tender__c From Tender_information__c Where id = : ParamIdStr');
         
         return JSON.serialize(arrays);
    }
@@ -34,33 +34,46 @@
         // 删除项目关联但不与保留项目关联的询价关联信息
         List<Tender_Opportunity_Link__c> linksList = [select id, Opportunity__c, Tender_information__c
                 from Tender_Opportunity_Link__c
                 where Tender_information__c = :TenInfo.Id and Opportunity__c
                                               not in : BlinkOppId];
                 where Tender_information__c = :TenInfo.Id ];
                                             //  and Opportunity__c not in : BlinkOppId];
         // 把删除招投标 关联的询价 赋给 保留招投标上
         List<Tender_Opportunity_Link__c> addlinksList = new List<Tender_Opportunity_Link__c>();
         // 删除招投标关联的询价
         // 增加一个判断 看看是否还会写空进去
         if (linksList != null && linksList.size() > 0) {
            for (Tender_Opportunity_Link__c link : linksList) {
               Tender_Opportunity_Link__c linkinfo =  new Tender_Opportunity_Link__c();
               linkinfo.Tender_information__c = BTen.Id;
               linkinfo.Opportunity__c = link.Opportunity__c;
               linkinfo.Tender_Opportunity_Uniq__c = BTen.Id + '' + link.Opportunity__c;
               linkinfo.IsRelated__c = true;
               // if (BlinksList.contains(linkinfo)) {
               addlinksList.add(linkinfo);
               // }
               if(!BlinkOppId.contains(link.Opportunity__c)){
                  Tender_Opportunity_Link__c linkinfo =  new Tender_Opportunity_Link__c();
                  linkinfo.Tender_information__c = BTen.Id;
                  linkinfo.Opportunity__c = link.Opportunity__c;
                  linkinfo.Tender_Opportunity_Uniq__c = BTen.Id + '' + link.Opportunity__c;
                  linkinfo.IsRelated__c = true;
                  // if (BlinksList.contains(linkinfo)) {
                  addlinksList.add(linkinfo);
                  // }
               }
            }
            // 删除项目删掉关联询价
            // delete linksList;
            delete linksList;
            // 保留项目新增关联询价
            if (addlinksList.size() > 0) {
               insert addlinksList;
            }
         }
         // 【委托】招标项目-逻辑删除的项目需要自动取消与询价的关系 fy 2022.3.7 start
         List<Tender_Opportunity_Link__c> linksListdelect = [select id, Opportunity__c, Tender_information__c
                 from Tender_Opportunity_Link__c
                 where Tender_information__c = :TenInfo.Id];
         if(linksListdelect.size()>0){
            delete linksListdelect;
         }
         // 【委托】招标项目-逻辑删除的项目需要自动取消与询价的关系 fy 2022.3.7 end
         // }
         // 互换保留招投标与删除招投标的信息Id
         TenInfo.Retain_Tender__c = BTen.Id;
         // 【委托】招标项目-逻辑删除的项目需要自动取消与询价的关系 fy 2022.3.7 start
         TenInfo.Name = '逻辑删除:'+TenInfo.Name;
         // 【委托】招标项目-逻辑删除的项目需要自动取消与询价的关系 fy 2022.3.7 end
         String BTenInfo = BTen.InfoId__c;
         BTen.InfoId__c = TenInfo.InfoId__c;//保留招投标的信息Id赋给删除招投标的信息Id
         TenInfo.InfoId__c = BTenInfo;//删除招投标的信息Id赋给保留招投标的信息Id