新增文章

文章标题分类内容

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

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

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_ICTemplateCaption  金蝶老单 更改字段名称

create view dbo.a_ICTemplateCaption
   as
   select 
   
       FID
      ,FBillName
      ,FCtlIndex,FTabIndex
      ,FPage
      ,FFieldName
      ,FCaption2
      -----------------------------------------------------------------------------------------------------------------------
      ,'   exec a_ChangeCaption '
      
               + ''''+ FBillName  +'''' 
               +','''+ FPage      +''''
               +','''+ FFieldName +''''+ dbo.a_Space ( FFieldName ,'16en' )  
               
               +','''+ FCaption2  +''''
               
               + dbo.a_Space ( FCaption2 ,'8cn' ) 
               
               +'  --'+ FFullName   as FCaptionTxt
      -----------------------------------------------------------------------------------------------------------------------
      ,FFullName
      
   from aICField
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   
   select * from a_ICTemplateCaption  where FID = 'S01'  ORDER BY FPage,FTabIndex    -- 金蝶老单 更改字段名称

exec a_ChangeCaption '销售订单','单据','Fdate'           ,'日期'              --【S01,v1.Fdate 日期:】
   exec a_ChangeCaption '销售订单','单据','FCustID'         ,'购货单位'          --【S01,v1.FCustID 购货单位:】
   exec a_ChangeCaption '销售订单','单据','FSettleDate'     ,'结算日期'          --【S01,v1.FSettleDate 结算日期:】
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from aICField  where FID = 'S01'  ORDER BY FPage,FTabIndex    --【单据字段】
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go