public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType, SqlInt32 upToLevel)
{
SPMultipleSkylineBNL skyline = new SPMultipleSkylineBNL();
SqlContext.Pipe.Send("upto: " + upToLevel.Value.ToString());
skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, sortType.Value, upToLevel.Value);
}
public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
//Additional parameter
DataTable dt = new DataTable();
int upToLevel = int.Parse(AdditionParameters[4]);
if (HasIncomparablePreferences)
{
SPMultipleSkylineBNL skyline = new SPMultipleSkylineBNL();
dt = skyline.GetSkylineTable(querySQL, preferenceOperators, ConnectionString, Provider, RecordAmountLimit, SortType, upToLevel);
}
else
{
SPMultipleSkylineBNLLevel skyline = new SPMultipleSkylineBNLLevel();
dt = skyline.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = skyline.TimeInMs;
NumberOfComparisons = skyline.NumberOfOperations;
NumberOfMoves = skyline.NumberOfMoves;
}
return(dt);
}
public override DataTable GetSkylineTable(String querySQL, String preferenceOperators)
{
//Additional parameter
DataTable dt = new DataTable();
int upToLevel = int.Parse(AdditionParameters[4]);
if (HasIncomparablePreferences)
{
SPMultipleSkylineBNL skyline = new SPMultipleSkylineBNL();
dt = skyline.GetSkylineTable(querySQL, preferenceOperators, ConnectionString, Provider, RecordAmountLimit, SortType, upToLevel);
}
else
{
SPMultipleSkylineBNLLevel skyline = new SPMultipleSkylineBNLLevel();
dt = skyline.GetSkylineTable(querySQL, preferenceOperators, RecordAmountLimit, true, ConnectionString, Provider, AdditionParameters, SortType);
TimeMilliseconds = skyline.TimeInMs;
NumberOfComparisons = skyline.NumberOfOperations;
NumberOfMoves = skyline.NumberOfMoves;
}
return dt;
}
public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType, SqlInt32 upToLevel)
{
SPMultipleSkylineBNL skyline = new SPMultipleSkylineBNL();
SqlContext.Pipe.Send("upto: " +upToLevel.Value.ToString());
skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, sortType.Value, upToLevel.Value);
}