参照文档用存储过程生成简单账表。运行不显示数据，问题出在哪里，求指点

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.ComponentModel;

using System.Data;

using Kingdee.BOS;

using Kingdee.BOS.Core;

using Kingdee.BOS.Contracts.Report;

using Kingdee.BOS.Core.Report;

using Kingdee.BOS.App.Data;

using Kingdee.BOS.Util;

using Kingdee.BOS.Orm.DataEntity;

namespace prozhangbiao

{

public class prozhangbiao : SysReportBaseService

{

StringBuilder strOrgNames = new StringBuilder();

/// 得到汇总字段信息

/// <param name="filter"></param>

/// <returns></returns>

//public override List<SummaryField> GetSummaryColumnInfo(IRptParams filter)

//{

// base.GetSummaryColumnInfo(filter);

// List<SummaryField> lstfield = new List<SummaryField>();

// SummaryField sField = new SummaryField("F_KKK_Amount", Core.Enums.BOSEnums.Enu_SummaryType.SUM);

// lstfield.Add(sField);

// return lstfield;

//}

/// 通过存储过程把数据灌入临时表中

/// <param name="filter"></param>

/// <param name="tableName"></param>

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

DynamicObject dyFilter = filter.FilterParameter.CustomFilter;//快捷页签过滤条件

//StringBuilder strOrgIds = new StringBuilder(); //组织内码集合

//if (dyFilter["FMulOrganiztions"] != null)

//{

// var mulOrgObjs = dyFilter["FMulOrganiztions"] as DynamicObjectCollection;

// foreach (var orgObj in mulOrgObjs)

// {

// strOrgIds.Append(orgObj["FMulOrganiztions_Id"] + ",");

// var oObj = orgObj["FMulOrganiztions"] as DynamicObject;

// strOrgNames.Append(oObj["Name"] + ","); //组织名称

// }

//}

//base.BuilderReportSqlAndTempTable(filter, tableName);

//string seqFld = string.Format(base.KSQL_SEQ, "id");

List<SqlParam> lstParam =new List<SqlParam>();

lstParam.Add(new SqlParam("@tbname", KDDbType.AnsiString, tableName));

//lstParam.Add(new SqlParam("@tbname", DbType.AnsiString, tableName));

//lstParam.Add(new SqlParam("@FOrgIds", DbType.AnsiString, strOrgIds.ToString()));

DBUtils.ExecuteStoreProcedure(this.Context, "[Pro_test]", lstParam); //调用存储过程

}

/// 得到页面列表显示列头，动态增加列

/// <param name="filter"></param>

/// <returns></returns>

public override ReportHeader GetReportHeaders(IRptParams filter)

{

base.GetReportHeaders(filter);

ReportHeader rHeader = new ReportHeader();

rHeader.AddChild("FIDENTITYID", new LocaleValue("ID"));

rHeader.AddChild("FID", new LocaleValue("单据ID"));

rHeader.AddChild("FBILLNO", new LocaleValue("单据编号"));

rHeader.AddChild("FDATE", new LocaleValue("日期"));

//var arrOrgName= strOrgNames.ToString().Split(',');

//foreach (var orgName in arrOrgName) //创建动态列, 列名一定要对应存储过程插入临时表中的列

//{

// rHeader.AddChild(orgName, new LocaleValue(orgName));

//}

return rHeader;

}

}

}

产品问题简单账表不显示数据

20 产品问题 简单账表不显示数据

恭喜您！

产品问题
简单账表不显示数据

20 产品问题简单账表不显示数据