新增文章

文章标题分类内容

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

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

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_ICTemplateAll  金蝶老单 单据字段

create view dbo.a_ICTemplateAll
   as 
   select  
       FID
      ,FBillName
      ,FPage
      
      ,FOptionExt
      ,FCtlIndex,FTabIndex
      ,FFullName
      ,FRelationID,FAction,FFilter
      
      ,FLeft,FTop,FWidth,FHeight
      
      ,FVisForBillType,FIsVisibleForList
      ,FEnable,FMustInput,FNeedSave,FNeedCount
      ,FAllowCopy,IsSupportImport
      ,FPrint
      ,FInEntryForSPrint
      
      ,FCtlType,FLookUpType,FLookUpCls
      
      ,FSort
      ,FTableName,FTableAlias
      ,FFieldName,FCaption,FCaption2
   
   from a_ICTemplate
   
   union all
   select 
       FID
      ,FBillName
      ,FPage
      
      ,FOptionExt
      ,FCtlIndex,FCtlOrder
      
      ,FFullName
      ,FRelationID,FAction,FFilter
      
      ,0 FLeft,0 FTop,FWidth,0 FHeight
      
      ,FVisForBillType,FIsVisibleForList
      ,FEnable,FMustInput,FNeedSave,FNeedCount
      ,FAllowCopy,IsSupportImport
      ,FPrint
      ,0 FInEntryForSPrint
      
      ,FCtlType,FLookUpType,FLookUpCls
      
      ,FSort
      ,FTableName,FTableAlias
      ,FFieldName,FHeadCaption,FCaption2
      
   from a_ICTemplateEntry
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_ICTemplateAll where FID = 'S01' order by FSort,FTabIndex -- 金蝶老单 单据字段
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from  a_ICTemplate       where FID = 'S01'
   select * from  a_ICTemplateEntry  where FID = 'S01'
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go