public class CustomReportsWebApiService : AbstractWebApiBusinessService

{

public CustomReportsWebApiService(KDServiceContext context) : base(context)

{

}

/// <summary>

/// 获取销售订单执行汇总表数据

/// </summary>

/// <param name="filterSchemeNo">查询过滤方案编号，该过滤方案必须要事先定义好</param>

/// <param name="orderNo">销售订单编号</param>

/// <param name="orderDate">订单日期，'yyyyMMdd'格式</param>

/// <returns>返回请求方法和请求参数</returns>

public string getSaleOrderCollectReport(string filterSchemeNo, string orderNo, string orderDate)

{

var ctx = this.KDContext.Session.AppContext;

ISysReportService sysReporSservice = ServiceFactory.GetSysReportService(ctx);

var filterMetadata = FormMetaDataCache.GetCachedFilterMetaData(ctx);

var reportMetadata = FormMetaDataCache.GetCachedFormMetaData(ctx, "SAL_CollectReport");

var reportFilterMetadata = FormMetaDataCache.GetCachedFormMetaData(ctx, "SAL_CollectReportFilter");

var reportFilterServiceProvider = reportFilterMetadata.BusinessInfo.GetForm().GetFormServiceProvider();

var model = new SysReportFilterModel();

model.SetContext(ctx, reportFilterMetadata.BusinessInfo, reportFilterServiceProvider);

model.FormId = reportFilterMetadata.BusinessInfo.GetForm().Id;

model.FilterObject.FilterMetaData = filterMetadata;

model.InitFieldList(reportMetadata, reportFilterMetadata);

model.GetSchemeList(); // 经过试验，这一步代码不能省略，必须要执行

// 这里的过滤方案必须要事先定义好！！！

var entity = model.Load(filterSchemeNo);

var filter = model.GetFilterParameter();

filter.CustomFilter["SoFromDate"] = DateTime.ParseExact(orderDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture);

filter.CustomFilter["SaleOFrom"] = orderNo;

filter.CustomFilter["SaleOTo"] = orderNo;

filter.CustomOption["dspSumData"] = true; // 仅显示汇总行数据

filter.CustomOption["noDspSubTotalRow"] = false; // 汇总行不显示小计

filter.CustomOption["noDspSumTotalRow"] = true; // 汇总行不显示合计

IRptParams p = new RptParams();

p.FormId = reportFilterMetadata.BusinessInfo.GetForm().Id;

p.StartRow = 1;

p.EndRow = 1000;

p.FilterParameter = filter;

p.FilterFieldInfo = model.FilterFieldInfo;

var rpt = sysReporSservice.GetData(ctx, reportMetadata.BusinessInfo, p);

var jsonData = JsonConvert.SerializeObject(rpt);

ServiceFactory.CloseService(sysReporSservice);

return jsonData;

}

产品问题自定义webapi读取销售订单执行汇总表数据，选项设置相关参数怎么设值？filter.CustomOption设了不起作

50 产品问题 自定义webapi读取销售订单执行汇总表数据，选项设置相关参数怎么设值？filter.CustomOption设了不起作

恭喜您！

产品问题
自定义webapi读取销售订单执行汇总表数据，选项设置相关参数怎么设值？filter.CustomOption设了不起作

50 产品问题自定义webapi读取销售订单执行汇总表数据，选项设置相关参数怎么设值？filter.CustomOption设了不起作