新增文章

文章标题分类内容

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据转换流程：对应关系

SELECT ISNULL(a2.FTabIndex,'') FDstNo,a1.FDstCtlField FDstField,ISNULL(a2.FCaption,'') FDstName
         ,ISNULL(a3.FTabIndex,'') FSrcNo,a1.FName        FSrcField,ISNULL(a3.FCaption,'') FSrcName
         ,a1.FAction
         ,a1.* 
   
   FROM ICSelBills  a1
   LEFT JOIN (
      SELECT 'v1' FTableAlias ,FFieldName,FTabIndex,FCaption      FROM ICTemplate       WHERE FID = 'B01' 
      UNION All
      SELECT 'u1' FTableAlias ,FFieldName,FCtlOrder,FHeadCaption  FROM ICTemplateEntry  WHERE FID = 'B01' 
   ) a2 
     ON a1.FDstCtlField = a2.FFieldName AND a1.FTableAlias = a2.FTableAlias
   
   LEFT JOIN (
      SELECT 'v1' FTableAlias ,FFieldName,FTabIndex,FCaption      FROM ICTemplate       WHERE FID = 'S01' 
      UNION All
      SELECT 'u1' FTableAlias ,FFieldName,FCtlOrder,FHeadCaption  FROM ICTemplateEntry  WHERE FID = 'S01' 
   ) a3 
     ON a1.FName = a3.FFieldName AND a1.FTableAlias = a3.FTableAlias
   
   Where a1.FID          = 'B01' 
     AND a1.FFieldName   = 'FOrderInterID' 
     
     AND a1.FDstCtlField = 'FUniDiscount'

SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry  WHERE FID = 'B01' ORDER BY FCtlOrder   -- 表体
   SELECT FID,FCtlOrder,FOptionExt,FFieldName,FHeadCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplateEntry  WHERE FID = 'S01' ORDER BY FCtlOrder   -- 表体