判断单据明细表是否存在某些值，然后更新表头单据的值

-- Create date: <2024-5-31,>
-- Description:    <是否手工单,,>
-- =============================================
alter TRIGGER [dbo].[fjl_zhidan]
   ON  [dbo].[PORequest]
   AFTER INSERT,update
AS 

 if exists(select * from PORequestEntry a 
           join PORequest b on a.FInterID=b.FInterID 
           join inserted t on t.FInterID=b.FInterID
           where b.fbillerid<>16482 and a.FPlanOrderInterID='')   ---判断是否存在
 begin
    
      update  PORequest set PORequest.FHeadSelfP0132 ='是'    ---存在更新为是
      from inserted t
      join PORequest b on t.FInterID=b.FInterID
      join PORequestEntry a on a.FInterID=b.FInterID 
 end

else
    begin
        update  PORequest set PORequest.FHeadSelfP0132 ='否'  --不存在更新为否
        from inserted t
        join PORequest b on t.FInterID=b.FInterID
        join PORequestEntry a on a.FInterID=b.FInterID 
     end