预算执行分析提供取数接口,返回执行分析查询结果数据集合:
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.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
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;
}
预算分析接口参数说明.docx(23.04KB)
推荐阅读