新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists (select * from sys.views where object_id = OBJECT_ID(N'dbo.a_DataFlow'))
              drop     view                                         dbo.a_DataFlow
   go

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 a_DataFlow 主控台列表

create view dbo.a_DataFlow
   as 
   select  
       isnull(a1.FToolTips    ,'')  FTopTips
      
      ,isnull(a1.FTopClassID  ,'')  FTopClassID
      ,isnull(a1.FTopClassName,'')  FTopName
      
      ,isnull(a2.FSubSysID    ,'')  FSubSysID
      ,isnull(a2.FName        ,'')  FSubName
      
      ,isnull(a3.FSubFuncID   ,'')  FSubFuncID
      ,isnull(a3.FFuncName    ,'')  FSubFuncName
      
      ,isnull(a4.FDetailFuncID,'')  FDetailFuncID
      ,isnull(a4.FFuncName    ,'')  FDetFuncName
      
      ,isnull(a1.FIndex       ,'')  FTopIndex
      ,isnull(a2.FIndex       ,'')  FSubIndex
      ,isnull(a3.FIndex       ,'')  FFuncIndex
      ,isnull(a4.FIndex       ,'')  FDetailIndex
      
      ,isnull(a1.FVisible       ,'')  FTopVisible
      ,isnull(a2.FVisible       ,'')  FSubVisible
      ,isnull(a3.FVisible       ,'')  FFuncVisible
      ,isnull(a4.FVisible       ,'')  FDetailVisible
      
   from      t_DataFlowTopClass    a1
   left join t_DataFlowSubSystem   a2 on a2.FTopClassID = a1.FTopClassID
   left join t_DataFlowSubFunc     a3 on a3.FSubSysID   = a2.FSubSysID
   left join t_DataFlowDetailFunc  a4 on a4.FSubFuncID  = a3.FSubFuncID

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from t_DataFlowTopClass                            ORDER BY FIndex         --【供应链】
   select * from t_DataFlowSubSystem  where FTopClassID = 20   ORDER BY FSubSysID      --【销售管理】
   select * from t_DataFlowSubFunc    where FSubSysID   = 23   ORDER BY FSubSysID      --【销售订单】
   select * from t_DataFlowDetailFunc where FSubFuncID  = 2302 ORDER BY FDetailFuncID  --【销售订单 - 新增】
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   select * from a_DataFlow  where FTopName = '供应链' AND FSubName = '销售管理' AND FSubFuncName = '销售订单'

*/
go