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