/// <summary>
/// 判断含有@TableName的存储过程在被执行之后
/// 是否成功创建了临时表，如果没有创建则抛出异常
/// </summary>
/// <param name="cmd">执行存储过程的SqlCommand对象</param>
private void CheckWhetherHadCreatedTempTable(SqlCommand cmd)
{
string tableName = this._tempTableName.ToLower().Replace("tempdb..", string.Empty);
if ((!string.IsNullOrEmpty(tableName)) && tableName.StartsWith("[") && tableName.EndsWith("]"))
{
tableName = tableName.Substring(1, tableName.Length - 2);
}
if (!SqlHelper.IsTableExsited(tableName, this._loginInfor.TempDBCnnString))
{
string exMsg = SqlCommandHelper.GetMsgWhenStoreProcedureError(cmd, null);
throw new TempDBServiceException(
"执行了含有@TableName参数的存储过程，但是存储过程内部没有成功创建临时表",
exMsg);
}
}
private void Storeprocedure2TempTable(
SqlCommand cmd,
string tempTableName)
{
SqlDataReader reader = null;
try
{
reader = SqlHelper.ExecuteReader(
this._loginInfor.UfDataCnnString,
cmd);
}
catch (Exception e)
{
string exMsg = SqlCommandHelper.GetMsgWhenStoreProcedureError(cmd, e);
throw new TempDBServiceException(e, exMsg);
}
this.Reader2TempTable(reader, tempTableName);
}