internal static io.Data.Return<object> RunScalar(string sql, bool noTimeout) { using (io.Database.Command cmd = new io.Database.Command(ActiveConnection(), sql, Common.IOSystem, true)) { return cmd.ExecuteScalar(); } }
internal static io.Data.Return<bool> RunNonQuery(string connectionString, string sql, bool noTimeout) { using (io.Database.Command cmd = new io.Database.Command(connectionString, sql, Common.IOSystem, noTimeout)) { return cmd.ExecuteNonQuery(); } }
private Return<bool> RunInsertSQLWithIOSystem() { string sql = InsertSQL(); if (sql.Length != 0) { using (var cmd = new io.Database.Command(_view.ConnectionIndex, sql + Constants.SEPARATOR + "SELECT @@IDENTITY", _ioSystem, true)) { var runSQLResult = cmd.ExecuteScalar(); if (runSQLResult.Success) { this[_view.ID] = Convert.ToInt32(runSQLResult.Value); _view.SyncForeignKeys((int)this[_view.ID]); return new Return<bool>(Return<bool>.ResultEnum.Success, runSQLResult.Message, "", true); } else { return TrapErrors(new Return<bool>(Return<bool>.ResultEnum.Failure, runSQLResult.Message, "", false)); } } } else { return new Return<bool>(Return<bool>.ResultEnum.Success, "Nothing to update.", "", true); } }