public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType, SqlInt32 upToLevel)
 {
     SPMultipleSkylineBNLLevel skyline = new SPMultipleSkylineBNLLevel();
     string[] additionalParameters = new string[5];
     additionalParameters[4] = upToLevel.ToString();
     skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, additionalParameters, sortType.Value, true);
 }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        public static void GetSkyline(SqlString strQuery, SqlString strOperators, SqlInt32 numberOfRecords, SqlInt32 sortType, SqlInt32 upToLevel)
        {
            SPMultipleSkylineBNLLevel skyline = new SPMultipleSkylineBNLLevel();

            string[] additionalParameters = new string[5];
            additionalParameters[4] = upToLevel.ToString();
            skyline.GetSkylineTable(strQuery.ToString(), strOperators.ToString(), numberOfRecords.Value, false, Helper.CnnStringSqlclr, Helper.ProviderClr, additionalParameters, sortType.Value, true);
        }
Exemplo n.º 4
0
        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;
        }