采购订单里面的需求单据编号添加到采购订单执行明细表里，写了一串代码，有没有高手帮我看一下，哪里出问题。非常感谢，现在是不取值

using Kingdee.BOS;

using Kingdee.BOS.App.Data;

using Kingdee.BOS.Contracts;

using Kingdee.BOS.Core.Report;

using Kingdee.K3.SCM.App.Purchase.Report;

using System.ComponentModel;

using System.Text;

namespace Kingdee.Bos.TestPOOrderTable

{

[Description("采购扩展")]

public class Test : PurchaseOrderExecuteRpt

{

private string[] TempTableName;

public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)

{

//创建临时表用于保存自己的数据

IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService<IDBService>();

TempTableName = dbservice.CreateTemporaryTableName(this.Context, 1);

string strTable = TempTableName[0];

//调用基类方法，获取初步的查询结果

base.BuilderReportSqlAndTempTable(filter, strTable);

//对初步的查询结果处理，然后回填到默认的存放查询结果到临时表

StringBuilder sb = new StringBuilder();

string strSql = @"/*dialect*/select t1.*,t3.FName as Fscjh

into {0} from {1} t1 left join T_PUR_POORDER t2

on t1.FBILLNO = t2.FBILLNO left join T_PUR_POORDERENTRY t3

on t2.FDEMANDBILLNO=t3.FID and t3.FLOCALEID=2052";

sb.AppendFormat(strSql, tableName, strTable);

DBUtils.Execute(this.Context, sb.ToString());

}

public override void CloseReport()

{

//删除临时表

if (TempTableName == null || TempTableName.Length == 0)

{

return;

}

IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService<IDBService>();

dbservice.DeleteTemporaryTableName(this.Context, TempTableName);

base.CloseReport();

}

}

产品问题采购订单里面的需求单据编号添加到采购订单执行明细表里

产品问题 采购订单里面的需求单据编号添加到采购订单执行明细表里