Esempio n. 1
0
        internal static string GetDataValueRangeFilderString(DataValueFilter dataValueFilter)
        {
            string WhereClause = " WHERE NOT (";
            string CurrentThreadDecimalChar = System.Threading.Thread.CurrentThread.CurrentCulture.NumberFormat.NumberDecimalSeparator;
            string InvariantCultureDecimalChar = new System.Globalization.CultureInfo("en-US").NumberFormat.NumberDecimalSeparator;
            switch (dataValueFilter.OpertorType)
            {
                case OpertorType.EqualTo:
                    WhereClause += " VAL([" + Data.DataValue + "]) = " + dataValueFilter.FromDataValue.ToString().Replace(CurrentThreadDecimalChar, InvariantCultureDecimalChar);
                    break;
                case OpertorType.Between:
                    //Inclusive of min & max values as per ANSI SQL
                    WhereClause += "(VAL([" + Data.DataValue + "]) >= " + dataValueFilter.FromDataValue.ToString().Replace(CurrentThreadDecimalChar, InvariantCultureDecimalChar) + " AND VAL([" + Data.DataValue + "]) <= " + dataValueFilter.ToDataValue.ToString().Replace(CurrentThreadDecimalChar, InvariantCultureDecimalChar) + ")";
                    break;
                case OpertorType.GreaterThan:
                    WhereClause += "(VAL([" + Data.DataValue + "]) > " + dataValueFilter.FromDataValue.ToString().Replace(CurrentThreadDecimalChar, InvariantCultureDecimalChar) + ")";
                    break;
                case OpertorType.LessThan:
                    WhereClause += "(VAL([" + Data.DataValue + "]) < " + dataValueFilter.ToDataValue.ToString().Replace(CurrentThreadDecimalChar, InvariantCultureDecimalChar) + ")";
                    break;
            }

            WhereClause += " )";

            return WhereClause;
        }
Esempio n. 2
0
        /// <summary>
        /// Clears all dataview filters
        /// </summary>
        public void Reset()
        {
            this._MostRecentData = false;
            this._DeletedDataNIds = string.Empty;
            this._DeletedSourceNIds = string.Empty;
            this._DeletedUnitNIds = string.Empty;
            this._DeletedSubgroupNIds = string.Empty;

            this._DeletedDataGIds = string.Empty;
            this._DeletedSourceNames = string.Empty;
            this._DeletedUnitGIds = string.Empty;
            this._DeletedSubgroupGIds = string.Empty;

            this._ShowSourceByIUS = true;
            this._ShowSubgroupByIndicator = true;
            this._ShowUnitByIndicator = true;

            this._ShowRecommendedSourceByRank = true;
            this._DeletedRanks = string.Empty;

            this._MostRecentData = false;

            this._DataValueFilter = new DataValueFilter();
            this._IndicatorDataValueFilters.Clear();
            this._IndicatorDataValueFilters.ShowIUS = true;
            this._IndicatorDataValueFilters.IncludeArea = false;
            this._UltraWinGridAutoFilters.Clear();
        }