临时表查询
下面一段代码,是生成了一个临时表,然后重写这表 ,我想知道查看select t1.* from {1} t1
这个结果集的内容,代码应该怎么写,谢谢!
public class retest : ARDetailReportService
{
private string[] tbname;
public override void BuilderReportSqlAndTempTable(IRptParams filter, string tableName)
{
IDBService dbservice = Kingdee.BOS.App.ServiceHelper.GetService<IDBService>();
tbname = dbservice.CreateTemporaryTableName(this.Context, 1);
string strTable = tbname[0];
//原表
base.BuilderReportSqlAndTempTable(filter, strTable);
//返回结果是void类型
//重写
StringBuilder sb = new StringBuilder();
string strsql = "select t1.*,'abc' as faa into {0} from {1} t1";
sb.AppendFormat(strsql, tableName, strTable);
DBUtils.Execute(this.Context, sb.ToString());
//返回结果是int