没有批准的就不显示在列表中

列表显示责任人

       ALTER TABLE [dbo].[OA_ShebeiWeixiu]  ADD      ApprovalStatus [int] NULL DEFAULT (0) ;

GO

update  [dbo].[OA_ShebeiWeixiu] set ApprovalStatus=(select [ApprovalStatus] from [dbo].[OA_WorkPlan] a where a.Keyid = [OA_ShebeiWeixiu].WeixiuShebeiId  )