C# EventLogProvider.GetAllEvents方法代码示例

    /// <summary>
    /// Gets and bulk updates eventss. Called when the "Get and bulk update events" button is pressed.
    /// Expects the LogEvent method to be run first.
    /// </summary>
    private bool GetAndBulkUpdateEvents()
    {
        // Create new instance of event log provider
        EventLogProvider eventLog = new EventLogProvider();

        // Get events matching the where condition
        string where = "EventCode = 'APIEXAMPLE'";
        DataSet events = eventLog.GetAllEvents(where, null);

        if (!DataHelper.DataSourceIsEmpty(events))
        {
            // Loop through the individual items
            foreach (DataRow eventDr in events.Tables[0].Rows)
            {
                // Create the object from DataRow
                EventLogInfo updateEvent = new EventLogInfo(eventDr);

                // Update the properties
                updateEvent.EventDescription = updateEvent.EventDescription.ToUpper();

                // Save the changes
                eventLog.SetEventLogInfo(updateEvent);
            }

            return true;
        }

        return false;
    }

    /// <summary>
    /// Gets and updates abuse report. Called when the "Get and update report" button is pressed.
    /// Expects the LogEvent method to be run first.
    /// </summary>
    private bool GetAndUpdateEvent()
    {
        // Create new instance of event log provider
        EventLogProvider eventLog = new EventLogProvider();

        // Get top 1 event matching the where condition
        string where = "EventCode = 'APIEXAMPLE'";
        int topN = 1;
        DataSet events = eventLog.GetAllEvents(where, null, topN, null);

        if (!DataHelper.DataSourceIsEmpty(events))
        {
            // Create the object from DataRow
            EventLogInfo updateEvent = new EventLogInfo(events.Tables[0].Rows[0]);

            // Update the properties
            updateEvent.EventDescription = updateEvent.EventDescription.ToLower();

            // Save the changes
            eventLog.SetEventLogInfo(updateEvent);

            return true;
        }

        return false;
    }

    /// <summary>
    /// Returns last 20 events from EventLog.
    /// </summary>
    private string GetEventLog()
    {
        StringBuilder sb = new StringBuilder();
        sb.Append("<div>");

        EventLogProvider eventProvider = new EventLogProvider();
        DataSet ds = eventProvider.GetAllEvents("EventType = 'E' OR EventType = 'W'", "EventTime DESC", 20, null);
        if (!DataHelper.DataSourceIsEmpty(ds))
        {
            sb.Append("<table style=\"width: 100%;\">");
            sb.AppendLine("<tr>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.EventType") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.EventCode") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.UserName") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.IPAddress") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.DocumentName") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.SiteName") + "</strong></td>");
            sb.AppendLine("<td><strong>" + ResHelper.GetString("cmstesting.eventlog.EventMachineName") + "</strong></td>");
            sb.AppendLine("</tr>");

            string evenStyle = " background-color: rgb(244, 244, 244);";

            int i = 0;
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                string siteName = SiteInfoProvider.GetSiteName(ValidationHelper.GetInteger(dr["SiteID"], 0));

                sb.AppendLine("<tr style=\"cursor: pointer;" + (i % 2 == 0 ? evenStyle : "") + "\" onclick=\"document.getElementById('table_event_" + i + "').style.display = (this.hide ? 'none' : 'block'); this.hide = !this.hide; return false;\">");
                sb.AppendLine("<td>" + dr["EventType"] + "</td>");
                sb.AppendLine("<td>" + dr["EventCode"] + "</td>");
                sb.AppendLine("<td>" + dr["UserName"] + "</td>");
                sb.AppendLine("<td>" + dr["IPAddress"] + "</td>");
                sb.AppendLine("<td>" + dr["DocumentName"] + "</td>");
                sb.AppendLine("<td>" + siteName + "</td>");
                sb.AppendLine("<td>" + dr["EventMachineName"] + "</td>");
                sb.AppendLine("</tr>");
                sb.AppendLine("<tr><td colspan=\"7\">");
                string item = "<table style=\"display: none;\" id=\"table_event_" + i + "\">";
                foreach (DataColumn col in ds.Tables[0].Columns)
                {
                    item += GetEventLogItem(col.ColumnName, dr);
                }
                item += "</table>";
                sb.AppendLine(item);
                sb.AppendLine("</td></tr>");

                i++;
            }
            sb.Append("</table>");
        }
        sb.Append("</div>");
        return sb.ToString();
    }

    /// <summary>
    /// Runs example.
    /// </summary>
    public void Run()
    {
        try
        {
            if (RunExample != null)
            {
                bool success = RunExample();

                if (!success)
                {
                    // Display error message
                    lblError.Text = ErrorMessage;
                    lblError.Visible = true;

                    return;
                }
            }
        }
        catch (Exception ex)
        {
            // Log exception
            EventLogProvider ep = new EventLogProvider();
            ep.LogEvent("APIExample", "EXCEPTION", ex);

            string  msg = "";

            // Try to find id of last interesting log
            string where = ep.GetSiteWhereCondition(0) + " AND (Source = 'APIExample') AND (IPAddress = '" + HTTPHelper.UserHostAddress + "')";
            string orderBy = "EventTime DESC, EventID DESC";
            DataSet ds = ep.GetAllEvents(where, orderBy, 1, "EventID");

            // Get id
            int eventId = 0;
            if (!DataHelper.DataSourceIsEmpty(ds))
            {
                eventId = ValidationHelper.GetInteger(ds.Tables[0].Rows[0]["EventID"], 0);
            }

            if(eventId != 0)
            {
                string identificator = Guid.NewGuid().ToString();
                Hashtable mParameters = new Hashtable();
                mParameters["where"] = where;
                mParameters["orderby"] = orderBy;

                WindowHelper.Add(identificator, mParameters);

                string queryString = "?params=" + identificator;
                queryString = URLHelper.AddParameterToUrl(queryString, "hash", QueryHelper.GetHash(queryString));
                queryString = URLHelper.AddParameterToUrl(queryString, "eventid", eventId.ToString());

                // Add link to event details in event log
                msg = String.Format("The API example failed. See event log for <a href=\"\" onclick=\"modalDialog('" + ResolveUrl("~/CMSModules/EventLog/EventLog_Details.aspx") + queryString + "', 'eventdetails', 920, 700); return false;\">more details</a>.");
            }
            else
            {
                // Add link to Event log
                msg = String.Format("The API example failed. See <a href=\"" + ResolveUrl("~/CMSModules/EventLog/EventLog.aspx") + "\" target=\"_blank\">event log</a> for more details.");
            }

            // Display error message
            lblError.Text = msg;
            lblError.ToolTip = ex.Message;
            lblError.Visible = true;

            return;
        }

        //Display info message
        lblInfo.Text = InfoMessage;
        lblInfo.Visible = true;
    }