Exemplo n.º 1
0
        /// <summary>
        /// Summarizes sets of SearchInfo instances that were created during the specified datetime range.
        /// </summary>
        /// <param name="startDay">The start day.</param>
        /// <param name="endDay">The end day.</param>
        /// <returns>A <see cref="IndexLibrary.Analysis.SearchInfoSummary"/> that represents a summary of the data in that timespan</returns>
        public static SearchInfoSummary SummarizeSearchData(DateTime startDay, DateTime endDay)
        {
            if (startDay > endDay)
            {
                throw new ArgumentOutOfRangeException("startDay", "startDay cannot be newer than endDay");
            }

            DataTable         table;
            SearchInfoSummary summary = new SearchInfoSummary();

            Action <DataTable> action = delegate(DataTable inputTable) {
                if (inputTable != null && inputTable.Columns.Contains("IndexName") && inputTable.Columns.Contains("Query") && inputTable.Columns.Contains("SearchMethodType") && inputTable.Columns.Contains("TotalResults") && inputTable.Columns.Contains("Canceled") && inputTable.Columns.Contains("CreateTime"))
                {
                    int count = inputTable.Rows.Count;
                    for (int j = 0; j < count; j++)
                    {
                        DataRow row = inputTable.Rows[j];
                        try {
                            summary.AddSearchInfo(new SearchInfo(row["IndexName"].ToString(), row["Query"].ToString(), (SearchMethodType)Enum.Parse(typeof(SearchMethodType), row["SearchMethodType"].ToString()), int.Parse(row["TotalResults"].ToString()), bool.Parse(row["Canceled"].ToString()), DateTime.Parse(row["CreateTime"].ToString())));
                        }
                        catch (Exception) {
                        }
                    }
                }
            };

            if (startDay.Date < endDay.Date)
            {
                table = ReadDay(startDay, TableName.SearchAnalysis, true);
                action(table);
                startDay = startDay.Date.AddDays(1.0);
            }

            while (startDay < endDay)
            {
                table = ReadDay(startDay, TableName.SearchAnalysis, true);
                action(table);
                startDay = startDay.AddDays(1.0);
            }

            if (startDay.Date == endDay.Date)
            {
                table = ReadDay(endDay, TableName.SearchAnalysis, false);
                action(table);
                endDay = new DateTime(endDay.Year, endDay.Month, endDay.Day, 23, 59, 59);
            }

            return(summary);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Summarizes sets of SearchInfo instances that were created during the specified datetime range.
        /// </summary>
        /// <param name="startDay">The start day.</param>
        /// <param name="endDay">The end day.</param>
        /// <returns>A <see cref="IndexLibrary.Analysis.SearchInfoSummary"/> that represents a summary of the data in that timespan</returns>
        public static SearchInfoSummary SummarizeSearchData(DateTime startDay, DateTime endDay)
        {
            if (startDay > endDay) throw new ArgumentOutOfRangeException("startDay", "startDay cannot be newer than endDay");

            DataTable table;
            SearchInfoSummary summary = new SearchInfoSummary();

            Action<DataTable> action = delegate(DataTable inputTable) {
                if (inputTable != null && inputTable.Columns.Contains("IndexName") && inputTable.Columns.Contains("Query") && inputTable.Columns.Contains("SearchMethodType") && inputTable.Columns.Contains("TotalResults") && inputTable.Columns.Contains("Canceled") && inputTable.Columns.Contains("CreateTime")) {
                    int count = inputTable.Rows.Count;
                    for (int j = 0; j < count; j++) {
                        DataRow row = inputTable.Rows[j];
                        try {
                            summary.AddSearchInfo(new SearchInfo(row["IndexName"].ToString(), row["Query"].ToString(), (SearchMethodType)Enum.Parse(typeof(SearchMethodType), row["SearchMethodType"].ToString()), int.Parse(row["TotalResults"].ToString()), bool.Parse(row["Canceled"].ToString()), DateTime.Parse(row["CreateTime"].ToString())));
                        }
                        catch (Exception) {
                        }
                    }
                }
            };

            if (startDay.Date < endDay.Date) {
                table = ReadDay(startDay, TableName.SearchAnalysis, true);
                action(table);
                startDay = startDay.Date.AddDays(1.0);
            }

            while (startDay < endDay) {
                table = ReadDay(startDay, TableName.SearchAnalysis, true);
                action(table);
                startDay = startDay.AddDays(1.0);
            }

            if (startDay.Date == endDay.Date) {
                table = ReadDay(endDay, TableName.SearchAnalysis, false);
                action(table);
                endDay = new DateTime(endDay.Year, endDay.Month, endDay.Day, 23, 59, 59);
            }

            return summary;
        }