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();
}
}
显示隐藏列能看见这个列,但实际表里却没有这个列,哪里出问题了吗
推荐阅读