预算执行分析取数接口说明

预算执行分析提供取数接口,返回执行分析查询结果数据集合:
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;
}
我只是想取可用预算那个数,一直取不到,大家帮忙看看,我的问题出在哪?
BudgetFilterParameter filter = new BudgetFilterParameter();
filter.FilterOption = new BudgetFilterOption(); //过滤选项
filter.FilterOption.IncludeUnAuditBill = true; //包含已提交未审核单据
filter.FilterOption.IsContianNullBudgetValue = true;//包含预算数为空数据
filter.FilterOption.IsShowLastCumValue = false;//显示往期未执行数
filter.SchemeId = 104152; //预算方案
filter.RuleId = 1; //预算控制规则
filter.PeriodType = "3"; //周期类型
//filter.StartDate =Convert.ToDateTime("2018-01-01 00:00:00");
//filter.EndDate = Convert.ToDateTime("2018-01-31 23:59:59");
////预算组织
Dictio
预算执行分析取数接口说明
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



