DotNet.WebApplication/Modules/OA/Maintain/MaintainUserChart.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.DataVisualization.Charting;
using System.Web.UI.WebControls;
using DotNet.Business;

public partial class MaintainUserChart : BasePage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //页面初次加载时的动作
            GetItemDetails();
            this.DoPageLoad();
        }
    }

    private void DoPageLoad()
    {
        // 检查是否登录&
        Utilities.CheckIsLogOn();
        txtStartDate.Text = DateTime.Today.AddDays(-30).ToString("yyyy-MM-dd");
        txtEndDate.Text = DateTime.Today.ToString("yyyy-MM-dd");
    }

    /// <summary>
    /// 绑定下拉筐数据
    /// </summary>
    private void GetItemDetails()
    {
        BaseItemDetailsManager manager = new BaseItemDetailsManager(this.UserCenterDbHelper, this.UserInfo, "BaseUser");
        DataTable dataTable = manager.GetDataTable(new KeyValuePair<string, object>(BaseItemDetailsEntity.FieldDeletionStateCode, 0)
            , new KeyValuePair<string, object>(BaseItemDetailsEntity.FieldEnabled, 1)
            , BaseItemDetailsEntity.FieldSortCode);
        this.ddlUsers.DataSource = dataTable;
        this.ddlUsers.DataTextField = "RealName";
        this.ddlUsers.DataValueField = "ID";
        this.ddlUsers.DataBind();
    }

    private void Chart(DataTable table)
    {
        chart.ChartAreas[0].AxisY.Title = "故障次数";
        var cateGroup = table.AsEnumerable().GroupBy(q => q["BugCategory"]);
        foreach (var g in cateGroup)
        {
            var series = new Series(g.Key.ToString());
            var reportTimeGroup = g.GroupBy(q => Convert.ToDateTime(q["ReportingTime"]).Date);
            foreach (var rows in reportTimeGroup)
            {
                series.Points.AddXY(rows.Key, rows.Count());
            }
            chart.Series.Add(series);
        }
    }