《每天一点点》 Meutopia
string sql= string.Format(@" /dialect/ select * from table ");
DataTable dt= DBServiceHelper.ExecuteDataSet(contxt, sql).Tables[0];
//结果插入临时表
string inpurTableName =AppServiceContext.DBService.CreateTemporaryTableName(this.Context);
//创建临时表
string strsql = “/dialect/create table " + inpurTableName + " as select FENTRYID from table where 1<>1”;
DBServiceHelper.Execute(this.Context, strsql);
Dictionary<string, DbType> columnInfos = new Dictionary<string, DbType>();
columnInfos.Add(“FENTRYID”, DbType.Int64);
BulkInsertAdapter bulkInsertAdapter = new BulkInsertAdapter(base.Context, columnInfos, inpurTableName, dt.Rows.Count);
foreach (DataRow dc in dt.Rows)
{
DataRow newRow = bulkInsertAdapter.NewRow;
newRow[“FENTRYID”] = Convert.ToInt64(dc[“FENTRYID”]);
bulkInsertAdapter.Insert(newRow);
}
bulkInsertAdapter.Finish();
