public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName) StringBuilder sb = new StringBuilder(); sb.AppendFormat(strsql,tableName,strTable); } public override void CloseReport() base.CloseReport(); }
[float=left]
[tr][td]public class CustomReportService: StockClassStaRpt
{
private string[] CMK_LS_PayMentAnalyseReportTableNames;
{
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);
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 ";
DBUtils.Execute(this.Context, sb.ToString());
{
if (CMK_LS_PayMentAnalyseReportTableNames.IsNullOrEmptyOrWhiteSpace())
{
return;
}
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService
dbservice.DeleteTemporaryTableName(this.Context, CMK_LS_PayMentAnalyseReportTableNames);
}
显示隐藏列能看见这个列,但实际表里却没有这个列,哪里出问题了吗
[/float]
推荐阅读