新增文章

文章标题分类内容

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 联查：关联信息

select

it11.FMasterId ,it11.FInstanceId,it11.FFLowId,it11.FFirstFormId,it11.FFirstBillNo,it11.FFirstBillId,it11.FStartTime,it11.FStatus,it11.FSourceId  ,'|' A

,it12.FInstanceId,it12.FRouteId,it12.FsTableName,it12.FsId,it12.FtTableName,it12.FtId,it12.FCreateTime,it12.FLineId,it12.FFirstNode,it12.FIsBreak

,it11.FFirstBillNo     FBillNo_PpBom
      ,isnull(pb12.FSeq,'')     FSeq_PpBom

,isnull(pm11.FBillNo ,'')  FBillNo_PickMtrl
      ,isnull(pm12.FSeq    ,'')     FSeq_PickMtrl

from      t_BF_Instance        it11
   left join t_BF_InstanceEntry   it12  on it11.FInstanceId = it12.FInstanceId

left join t_Prd_PpBomEntry    pb12  on (case when it12.FtTableName = 't_Prd_PpBomEntry'   then it12.FtId else 0 end) = pb12.FEntryId 
   left join t_Prd_PickMtrlData  pm12  on (case when it12.FtTableName = 't_Prd_PickMtrlData' then it12.FtId else 0 end) = pm12.FEntryId

left join t_Prd_PickMtrl  pm11  on pm11.FID = pm12.FID 
   
   where it11.FFirstBillNo = 'PPBOM64260'  and it11.FInstanceId = '1'

order by   it11.FMasterId ,it11.FInstanceId ,it12.FRouteId

/*
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   
   dbcc checkIdent('Z_Prd_PickMtrlData_LK', noReSeed) ;  -- 种子表

t_BF_InstanceEntry

FFirstNode = 1  是否存在【关联关系】

FLineId = 5     具体的【关联关系】

delete from t_BF_Instance       where FInstanceId = '1'  
   delete from t_BF_InstanceEntry  where FInstanceId = '1'

insert into t_BF_Instance ( FMasterId	,FInstanceId	,FFirstFormId	,FFirstBillNo	,FFirstBillId	)   -- 源单：表头信息
   select '1'	,'1'	,'PRD_PPBOM'	,'PPBOM64260'	,'205129'

insert into t_BF_InstanceEntry ( FInstanceId	,FRouteId	,FsTableName	,FsId	,FtTableName	,FtId	,FLineId	,FFirstNode	)   -- 源单：表体信息 + 对应关系
   select '1'	,'2'	,' '	,'0'	,'T_PRD_PPBOMENTRY'	,'1849488'	,'0'	,'1'	union all
   select '1'	,'3'	,'T_PRD_PPBOMENTRY'	,'1849488'	,'T_PRD_PICKMTRLDATA'	,'995718'	,'5'	,'0'	union all
   select '1'	,'4'	,'T_PRD_PPBOMENTRY'	,'1849488'	,'T_PRD_PICKMTRLDATA'	,'998663'	,'5'	,'0'

select * from t_BF_Instance      where FInstanceId = '6859002b528307'  
   select * from t_BF_InstanceEntry where FtId = 1849488