金蝶云星空常用控件 函数，SQL

1、简单帐表/动态表单几个主要事件

//初始化 public override void Initialize()

//构建动态列 public override BOS.Core.Report.ReportHeader GetReportHeaders(BOS.Core.Report.IRptParams filter)

//构建报表标题 public override BOS.Core.Report.ReportTitles GetReportTitles(BOS.Core.Report.IRptParams filter)

//创建报表临时表和SQL(将查询的数据插入到平台提供的临时表) public override void BuilderReportSqlAndTempTable(BOS.Core.Report.IRptParams filter, string tableName)

//设置汇总信息 public override List<SummaryField> GetSummaryColumnInfo(IRptParams filter)

//关闭报表

public override void CloseReport()

//表体数据填充前

protected override void FillBomChildData()

//简单帐表的表单插件

过滤条件参数--this.SysReportModel.FilterParameter

2.单据插件事件

//单据关闭前

public override void BeforeClosed(BeforeClosedEventArgs e)

//保存后

public override void AfterSave(AfterSaveEventArgs e)

//表体菜单单击

public override void EntryBarItemClick(BarItemClickEventArgs e)

//表头菜单单击

public override void BarItemClick(BarItemClickEventArgs e)

//下推/选单，自动填充目标字段值完毕

public override void OnAfterCreateLink(CreateLinkEventArgs e)

//字段数据更新时

 public override void DataChanged(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.DataChangedEventArgs e)
    {
        base.DataChanged(e);
        if (e.Key.Equals("字段名") || e.Key.Equals("字段名") || e.Key.Equals("字段名"))    //检测对应字段名的值是否发生变化
        {
           //执行逻辑代码

         }

//表头按钮点击事件

public override void AfterBarItemClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.AfterBarItemClickEventArgs e)
    {
        base.AfterBarItemClick(e);
        if(e.BarItemKey.EqualsIgnoreCase("tbGZHS")

       {
         //执行逻辑代码
        }
            
     }

//表体按钮点击事件

public override void AfterEntryBarItemClick(Kingdee.BOS.Core.DynamicForm.PlugIn.Args.AfterBarItemClickEventArgs e）

{
      base.AfterEntryBarItemClick(e);

      if (e.BarItemKey.EqualsIgnoreCase("填入按键标识"))//判断是否点击到对应的按键

}

3.列表插件事件

//列表双击

public override void ListRowDoubleClick(ListRowDoubleClickArgs e)

枚举：select b1.FID,n1.FName,b2.FSeq,b2.FValue,n2.FCaption from T_META_Formenum b1 inner join T_META_Formenum_L n1 on b1.FID=n1.FID and (n1.FName like '%年%' or n1.FName like '%月%') and n1.FLocaleID=2052 inner join T_META_FormenumItem b2 on b1.FID=b2.FID inner join T_META_FormenumItem_L n2 on b2.FEnumID=n2.FEnumID and n2.FLocaleID=2052 order by b1.FID,b2.FSeq
辅助资料：select b1.FID,b1.FNumber,n1.FName,b2.FEntryID,b2.FNumber,b2.FSeq,n2.FDataValue,b2.FUseOrgID from T_BAS_AssistantData b1 inner join T_BAS_AssistantData_L n1 on b1.FID=n1.FID and n1.FLocaleID=2052 inner join T_BAS_AssistantDataEntry b2 on b1.FID=b2.FID inner join T_BAS_AssistantDataEntry_L n2 on b2.FEntryID=n2.FEntryID and n2.FLocaleID=2052 where n1.FName like '%采购类型%' order by b1.FNumber,b2.FNumber,b2.FSeq
数据中心：select t1.FDATACENTERID,t1.FNUMBER,t2.FNAME,t1.FDATABASENAME from T_BAS_DATACENTER t1 inner join T_BAS_DATACENTER_L t2 on t1.FDATACENTERID=t2.FDATACENTERID and t2.FLOCALEID=2052
查询数据中心版本：select FVERSION from T_BOS_INSTALLEDPACKAGE where FISVID = 'Kingdee' and FPKGID='K3Cloud_DC_VERSION'
星空分组全名称：select t0.FID,((select t2.FName+'-' from T_BD_MaterialGroup t1 inner join T_BD_MaterialGroup_L t2 on t1.FID=t2.FID and t2.FLocaleID=2052 where t1.FID=t0.FID or charindex('.'+cast(t1.FID as varchar)+'.',t0.FFullParentID+'.')>0 order by (len(t1.FFullParentID)-len(replace(t1.FFullParentID,'.',''))+1) for xml path(''))) FFullName from T_BD_MaterialGroup t0
星空分组全编码：select t0.FID,((select t1.FNumber+'-' from T_BD_MaterialGroup t1 where t1.FID=t0.FID or charindex('.'+cast(t1.FID as varchar)+'.',t0.FFullParentID+'.')>0 order by (len(t1.FFullParentID)-len(replace(t1.FFullParentID,'.',''))+1) for xml path(''))) FFullNumber from T_BD_MaterialGroup t0
上机日志查询：select * from T_BAS_OperateLog where convert(varchar(10),fdatetime,23) between '2020-07-27' and '2020-07-28' and fobjecttypeid='PUR_PurchaseOrder' and foperatename='保存业务对象操作' order by fdatetime desc
科目核算维度字段：select t1.FFlexNumber,t1.FValueSource,t2.FName from T_BD_FlexItemProperty t1 inner join T_BD_FlexItemProperty_L t2 on t1.FID=t2.FID and t2.FLocaleID=2052 order by t1.FNumber
辅助属性字段：select t1.FID,t1.FNumber,t2.FName,t1.FFlexNumber,t1.FValueType,t1.FValueSource from T_BD_FlexAuxProperty t1 inner join T_BD_FlexAuxProperty_L t2 on t1.FID=t2.FID and t2.FLocaleID=2052
辅助属性组合值：select * from T_BD_FlexsitemDetailV
物料启用辅助属性：select t1.FMaterialID,t1.FNumber,t2.FName,t3.FAuxPropertyID,t4.FNumber,t5.FName,t4.FFlexNumber,t4.FValueType,t4.FValueSource from T_BD_Material t1 inner join T_BD_Material_L t2 on t1.FMaterialID=t2.FMaterialID and t1.FMaterialID=t1.FMasterID and t2.FLocaleID=2052 inner join T_BD_MaterialAuxPty t3 on t1.FMaterialID=t3.FMaterialID and t3.FIsEnable='1' inner join T_BD_FlexAuxProperty t4 on t3.FAuxPropertyID=t4.FID inner join T_BD_FlexAuxProperty_L t5 on t4.FID=t5.FID and t5.FLocaleID=2052 order by t1.FNumber,t4.FNumber
凭证生成记录表：select FSystemID,FSourceBill,FSourceBillID,FSourceBillNo,FBIZVoucherID,FGLVoucherID,FYear,FPeriod from T_BAS_VchBuildReport