金蝶不同账套BOS单据界面同步保持一致

A账套的销售报价单的界面以及字段触发的处理时间要保持跟B账套一样。 如果通过BOS平台来重新做， 费时费力。故想到通过数据库来处理，主要是在表ICClassTableInfo和表ICCLASSACTIONLIST。 具体sql如下

  -- 查出表名PORFQ                                                                           
   select  * from t_TableDescription  where   FDescription  like '%销售报价%'
  -- 查出ClassType=1007006    
   select  * from   ICClassType where   FTableName='PORFQ'
   --表单界面的字段 要更新
   select  * from   AIS20230113160504.dbo.ICClassTableInfo where fclasstypeid=1007006 
 
   ---字段事件     要更新
SELECT * FROM AIS20230113160504.dbo.ICCLASSACTIONLIST  WHERE FCLASSTYPEID=1007006

select   *  into ICClassTableInfo20230802 from   AIS20230113160504.dbo.ICClassTableInfo  where fclasstypeid=1007006 

delete     AIS20230113160504.dbo.ICClassTableInfo  where fclasstypeid=1007006 

INSERT INTO AIS20230113160504.dbo.[ICClassTableInfo]
           ([FClassTypeID]
           ,[FPage]
           ,[FCaption_CHS]
           ,[FCaption_CHT]
           ,[FCaption_EN]
           ,[FKey]
           ,[FFieldName]
           ,[FTableName]
           ,[FTableNameAs]
           ,[FListIndex]
           ,[FListClassName]
           ,[FVisible]
           ,[FEnable]
           ,[FNeedSave]
           ,[FMustInput]
           ,[FCtlType]
           ,[FProperty]
           ,[FLookUpType]
           ,[FLookUpClassID]
           ,[FLookUpList]
           ,[FSRCFieldName]
           ,[FSRCTableName]
           ,[FSRCTableNameAs]
           ,[FDSPFieldName]
           ,[FFNDFieldName]
           ,[FValueLocation]
           ,[FFilter]
           ,[FFilterGroup]
           ,[FValueType]
           ,[FDspColType]
           ,[FEditlen]
           ,[FValuePrecision]
           ,[FSaveRule]
           ,[FDefValue]
           ,[FAction]
           ,[FUserDefine]
           ,[FNote]
           ,[FKeyWord]
           ,[FLeft]
           ,[FTop]
           ,[FHeight]
           ,[FWidth]
           ,[FCondition]
           ,[FTabIndex]
           ,[FLock]
           ,[FSum]
           ,[FPrec]
           ,[FScale]
           ,[FLayer]
           ,[FLoadAction]
           ,[FUnControl]
           ,[FFont]
           ,[FSourceType]
           ,[FSubKey]
           ,[FParentKey]
           ,[FConditionExt]
           ,[FFrameBorder]
           ,[FFrameBorderColor]
           ,[FLabelWidth]
           ,[FLabelColor]
           ,[FTextColor]
           ,[FIsF7]
           ,[FContainer]
           ,[FStyle]
           ,[FDescription]
           ,[FDescription_CHT]
           ,[FDescription_EN]
           ,[IsSupportImport]
           ,[FMargin]
           ,[FMobileFieldLinkID]
           ,[FIsShowTitle]
           ,[FBackgroundImage])
            SELECT  
       [FClassTypeID]
      ,[FPage]
      ,[FCaption_CHS]
      ,[FCaption_CHT]
      ,[FCaption_EN]
      ,[FKey]
      ,[FFieldName]
      ,[FTableName]
      ,[FTableNameAs]
      ,[FListIndex]
      ,[FListClassName]
      ,[FVisible]
      ,[FEnable]
      ,[FNeedSave]
      ,[FMustInput]
      ,[FCtlType]
      ,[FProperty]
      ,[FLookUpType]
      ,[FLookUpClassID]
      ,[FLookUpList]
      ,[FSRCFieldName]
      ,[FSRCTableName]
      ,[FSRCTableNameAs]
      ,[FDSPFieldName]
      ,[FFNDFieldName]
      ,[FValueLocation]
      ,[FFilter]
      ,[FFilterGroup]
      ,[FValueType]
      ,[FDspColType]
      ,[FEditlen]
      ,[FValuePrecision]
      ,[FSaveRule]
      ,[FDefValue]
      ,[FAction]
      ,[FUserDefine]
      ,[FNote]
      ,[FKeyWord]
      ,[FLeft]
      ,[FTop]
      ,[FHeight]
      ,[FWidth]
      ,[FCondition]
      ,[FTabIndex]
      ,[FLock]
      ,[FSum]
      ,[FPrec]
      ,[FScale]
      ,[FLayer]
      ,[FLoadAction]
      ,[FUnControl]
      ,[FFont]
      ,[FSourceType]
      ,[FSubKey]
      ,[FParentKey]
      ,[FConditionExt]
      ,[FFrameBorder]
      ,[FFrameBorderColor]
      ,[FLabelWidth]
      ,[FLabelColor]
      ,[FTextColor]
      ,[FIsF7]
      ,[FContainer]
      ,[FStyle]
      ,[FDescription]
      ,[FDescription_CHT]
      ,[FDescription_EN]
      ,[IsSupportImport]
      ,[FMargin]
      ,[FMobileFieldLinkID]
      ,[FIsShowTitle]
      ,[FBackgroundImage]  
      from         AIS20130423125012.dbo.ICClassTableInfo where fclasstypeid=1007006 
 
 select * into ICCLASSACTIONLIST20230802 from  AIS20230113160504.dbo.ICCLASSACTIONLIST WHERE FCLASSTYPEID=1007006
 
delete AIS20230113160504.dbo.ICCLASSACTIONLIST WHERE FCLASSTYPEID=1007006
 
INSERT INTO AIS20230113160504.dbo.[ICClassActionList]
           ([FClassTypeID]
           ,[FClassActionID]
           ,[FObject]
           ,[FDefineType]
           ,[FSourceType]
           ,[FSourceField]
           ,[FAction]
           ,[FExpression]
           ,[FOrder]
           ,[FDescription])
 SELECT 
       [FClassTypeID]
      ,[FClassActionID]
      ,[FObject]
      ,[FDefineType]
      ,[FSourceType]
      ,[FSourceField]
      ,[FAction]
      ,[FExpression]
      ,[FOrder]
      ,[FDescription] from  AIS20130423125012.dbo.ICCLASSACTIONLIST WHERE FCLASSTYPEID=1007006

【注意】操作完之后要进bOS平台点击保存，要不不起效

看效果，下图是未执行sql之前的界面

 下图是执行sql后的界面