标准报表去扩展增加字段 数据不显示 ,右下角提示有数据具体请参照截图
继承的标准组件 Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService
源码如下:
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
string tablenameExt = GetTableName();
base.BuilderReportSqlAndTempTable(filter, tablenameExt);
// TODO:关联查询,并将结果更新到tablename表,以下仅供参考
string strSql = string.Format("select A.*,c.FFULLNAME FBALANCEFULL into {0} from {1} as A left join T_BD_ACCOUNT b on a.FBALANCEID=b.FNumber LEFT JOIN T_BD_ACCOUNT_l C on c.FACCTID=b.FACCTID", tableName, tablenameExt);
DBUtils.Execute(this.Context, strSql);
string droptable = "drop table " + tablenameExt;
DBUtils.Execute(this.Context, droptable);
}
public override ReportHeader GetReportHeaders(IRptParams filter)
{
ReportHeader header = base.GetReportHeaders(filter);
header.AddChild("FBALANCEFULL", new LocaleValue("科目全称"));
return header;
}
推荐阅读