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(); } }