预算执行分析取数接口说明
金蝶云社区-yuan_liang
yuan_liang
9人赞赏了该文章 5,162次浏览 未经作者许可,禁止转载编辑于2018年06月11日 17:05:24

预算执行分析提供取数接口,返回执行分析查询结果数据集合:
BudgetExecutionInfo GetBudgetExecutionCollection (Context ctx, ReportEntity.BudgetFilterParameter filter)

示例:

BudgetFilterParameter filter = new BudgetFilterParameter(); //参数
filter.FilterOption = newBudgetFilterOption(); //过滤选项
filter.FilterOption.IncludeUnAuditBill=true; //包含已提交未审核单据
filter.FilterOption.IsContianNullBudgetValue= true; //包含预算数为空数据
filter.FilterOption.IsShowLastCumValue= false; //显示往期未执行数
filter.SchemeId = 12305; //预算方案
filter.RuleId =12; //预算控制规则
filter.PeriodType= “3”; //周期类型
Dictionary dicOrgId= new Dictionary(); //预算组织
dicOrgId.Add(123,”ORG”);
dicOrgId.Add(124,”DEPT”);
filter.OrgIds =dicOrgId; //预算组织
filter.StartYear = 2017; //开始年度
filter.EndYear =2018; //结束年度
filter.StartPeriod = 1; //开始期间
filter.EndPeriod = 12; //结束期间
filter.LstCurrencyId = newList {1 }; //币别
filter.IsStandardCurrency = false; //是否综合本位币


//调用接口函数
BudgetExecutionInfo budgetExecutionInfo = new CommonService().GetBudgetExecutionCollection (ctx,filter );


//预算维度在查询结果集对应显示字段
foreach (var dimType in budgetExcuteInfo.DicRptDimensionInfo)
{
int dimsionTypeId =dimType.Value.Id;
string mappingField =dimType.Value.ShowFieldId;
string mappingFieldName =dimType.Value.ShowFieldName;
}