报表二次开发添加自定义字段不显示请帮忙看下哪里出问题
金蝶云社区-凤凰初生
凤凰初生
0人赞赏了该文章 1,188次浏览 未经作者许可,禁止转载编辑于2018年05月10日 09:19:33



[float=left]


[tr][td]public class CustomReportService: StockClassStaRpt
{
private string[] CMK_LS_PayMentAnalyseReportTableNames;

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService();
CMK_LS_PayMentAnalyseReportTableNames = dbservice.CreateTemporaryTableName(this.Context,1);
string strTable = CMK_LS_PayMentAnalyseReportTableNames[0];
base.BuilderReportSqlAndTempTable(filter, strTable);

StringBuilder sb = new StringBuilder();
string strsql = "select t2.FSalePrice_CMK as FDANJIAA,t1.* "
+ " into {0}"
+ " from {1} t1 "
+ " left join CMK_BD_MATERIAL t2 on t1.FMATERIALID=t2.FMATERIALID ";

sb.AppendFormat(strsql,tableName,strTable);
DBUtils.Execute(this.Context, sb.ToString());

}

public override void CloseReport()
{
if (CMK_LS_PayMentAnalyseReportTableNames.IsNullOrEmptyOrWhiteSpace())
{
return;
}
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService();
dbservice.DeleteTemporaryTableName(this.Context, CMK_LS_PayMentAnalyseReportTableNames);

base.CloseReport();
}

}




显示隐藏列能看见这个列,但实际表里却没有这个列,哪里出问题了吗


[/float]