private static object ExecuteScalar(IDbConnection connection, IDbCommand command)
{
DbConnectionStatus item = new DbConnectionStatus(connection);
object result = null;
item.OpenDbConnection();
try
{
result = command.ExecuteScalar();
}
catch (Exception ex)
{
TkDebug.ThrowToolkitException(string.Format(ObjectUtil.SysCulture,
"执行SQL:{0}出错", command.CommandText), ex, null);
}
finally
{
item.CloseDbConnection();
}
if (result == null)
{
result = DBNull.Value;
}
return(result);
}
public void Execute()
{
CreateStoredProc();
DbConnectionStatus item = new DbConnectionStatus(fConnection);
item.OpenDbConnection();
try
{
Command.ExecuteNonQuery();
}
catch (Exception ex)
{
TkDebug.ThrowToolkitException(string.Format(ObjectUtil.SysCulture,
"执行存储过程:{0}出错", Command.CommandText), ex, null);
}
finally
{
item.CloseDbConnection();
}
SetOutputValues();
}
private static int ExecuteNonQuery(IDbConnection connection, IDbCommand command)
{
DbConnectionStatus item = new DbConnectionStatus(connection);
item.OpenDbConnection();
try
{
int result = command.ExecuteNonQuery();
return(result);
}
catch (Exception ex)
{
TkDebug.ThrowToolkitException(string.Format(ObjectUtil.SysCulture,
"执行SQL:{0}出错", command.CommandText), ex, null);
return(-1);
}
finally
{
item.CloseDbConnection();
}
}
