新增文章

文章标题分类内容

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- KIS-Z-1602 序时簿字段

select * from ICListTemplate   order by FTemplateID,FID
   select * from ICChatBillTitle  order by FTypeID,FInterID
   
   
   select * from ICListTemplate
   select * from ICChatBillTitle where FTypeID = 58 order by FInterID
   
   select * from ICChatBillTitle where FTypeID = 58 and FColCaption != '$' and FVisible != 0 order by FInterID
   
   
   select 
              FInterID ,FTypeID ,FCtlIndex  ,FListSort  ,FAlign  ,FColType   ,FColWidth  ,FVisible   ,FVisForQuest  ,FVisForOrder  ,FColCaption   ,FColCaption_CHT  ,FColCaption_EN   ,FHeadSecond   ,FTableName          ,FTableAlias   ,FName      ,FColName   ,FItemClassID  ,FReturnDataType  ,FCountPriceType  ,FAction ,FNeedCount ,FIsPrimary    ,FLogicAction  ,FStatistical  ,FMergeable ,FControl   ,FMode   ,FControlType  ,FPrecisionField  ,FEditable  ,FFormat       ,FFormatType   ,FIsVisibleForTemplate  ,FColCaptionByShow   ,FHeadSecondByShow
     from ICChatBillTitle 
    where FTypeID = 58 and FColCaption like '%行号%' or FColCaption like '%新增列36%'
    order by FInterID