新增文章

文章标题分类内容

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据布局

-- S01 销售订单 / B01 销售出库 / I04 销售发票(专用) / I05 销售发票(普通)
-- P02 采购订单 / A01 外购入库 / I02 购货发票(专用) / I03 购货发票(普通)

SELECT * FROM ICTransactionType  WHERE FTemplateID = 'S01'  -- 整体

SELECT * FROM ICTemplate         WHERE FID = 'S01' ORDER BY FCtlIndex   -- 表头
   SELECT * FROM ICTemplateEntry    WHERE FID = 'S01' ORDER BY FCtlIndex   -- 表体

SELECT * FROM ICTemplate      WHERE FID = 'S01' ORDER BY FTabIndex
   SELECT * FROM ICTemplateEntry WHERE FID = 'S01' ORDER BY FCtlOrder
   
   SELECT * FROM ICTemplate      WHERE FID = 'S01' AND FCaption     LIKE '%日期%' ORDER BY FTabIndex
   SELECT * FROM ICTemplateEntry WHERE FID = 'S01' AND FHeadCaption LIKE '%日期%' ORDER BY FCtlOrder

SELECT FID,FTabIndex,FOptionExt,FFieldName,FCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplate WHERE FID = 'B01' ORDER BY FTabIndex   -- 表头
   SELECT FID,FTabIndex,FOptionExt,FFieldName,FCaption,FWidth,FEnable,FVisForBillType,FRelationID,FAction,FFilter FROM ICTemplate WHERE FID = 'S01' ORDER BY FTabIndex   -- 表头
   
   
   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   -- 表体
   
   SELECT FID,FTabIndex,FFieldName,FCaption,FTop,FHeight,FLeft,FWidth FROM ICTemplate WHERE FID = 'B01' ORDER BY FTabIndex   -- 表头
   SELECT FID,FTabIndex,FFieldName,FCaption,FTop,FHeight,FLeft,FWidth FROM ICTemplate WHERE FID = 'B01' ORDER BY FHeight,FTabIndex   -- 表头 高度

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 单据布局 更新设置

UPDATE ICClassType SET FID = FID