簽核流程設置(3)

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+1,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[二級簽核]))
  from dbo.[zlq_PCO1107] where  [二級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+2,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[三級簽核]))
  from dbo.[zlq_PCO1107] where  [三級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+3,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[四級簽核]))
  from dbo.[zlq_PCO1107] where  [四級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+4,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[五級簽核]))
  from dbo.[zlq_PCO1107] where  [五級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+5,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[六級簽核]))
  from dbo.[zlq_PCO1107] where  [六級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])
 select [流程號]+6,(select CheckmanID from dbo.PCO_CheckMan
                     where UserName=(select UserName from dbo.member where  Isvalid=1 and Realname=[七級簽核]))
  from dbo.[zlq_PCO1107] where  [七級簽核] is not null

INSERT INTO [QBRClient].[dbo].[PCO_WorkFlowChecker]([StepID]  , [CheckManID])