예제 #1
0
        /*
            Member:     ChartPopulation
            Purpose:    This function charts a population graph given a start date and an end
            data along with a list of species to chart side by side.  This graph is useful for
            comparing success between different species.
        */
        public static string ChartPopulation(DateTime beginTime, DateTime endTime, DataSet included)
        {
            DataSet includedData = included;
            DateTime begin = beginTime;
            DateTime end = endTime;
            ChartControl chartControl = new ChartControl ();
            ChartControl.PhysicalPath = ServerSettings.ChartPath + "\\";
            ChartControl.VirtualPath = "/Terrarium/ChartData";

            if ( includedData != null )
            {
                SqlConnection myConnection = new SqlConnection(ServerSettings.SpeciesDsn);

                myConnection.Open();

                int index=0;
                ChartPointCollection[] data=new ChartPointCollection[12];
                Chart[] charts=new Chart[12];
                chartControl.Charts.Clear();

                long beginTicks = beginTime.Ticks;
                long totalTicks = endTime.Ticks - beginTicks;
                float[] buckets = new float[24];

                foreach(DataRow item in includedData.Tables[0].Rows)
                {
                    SqlCommand command = new SqlCommand("TerrariumGrabSpeciesDataInDateRange", myConnection);
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.Add("@SpeciesName", SqlDbType.VarChar, 50).Value = item["SpeciesName"];
                    command.Parameters.Add("@BeginDate", SqlDbType.DateTime, 8).Value = begin;
                    command.Parameters.Add("@EndDate", SqlDbType.DateTime, 8).Value = end;

                    SqlDataReader dr = command.ExecuteReader();
                    data[index] = new ChartPointCollection();

                    while(dr.Read())
                    {
                        TimeSpan offset = endTime - ((DateTime) dr["SampleDateTime"]);
                        int bucket = 24 - (int) Math.Round(offset.TotalHours);

                        if ( bucket > -1 && bucket < buckets.Length ) {
                            buckets[bucket] = (float) (int) dr["Population"];
                        }
                    }

                    dr.Close();

                    for(int i = 0; i < buckets.Length; i++)
                    {
                        data[index].Add(new ChartPoint(i.ToString(), buckets[i]));
                        buckets[i] = 0;
                    }

                    charts[index] = new SmoothLineChart(data[index], Color.Black );
                    charts[index].LineMarker = new CircleLineMarker(0,charts[index].Fill.Color ,charts[index].Fill.Color );
                    charts[index].ShowLineMarkers = false;
                    charts[index].DataLabels.ShowValue = false;
                    charts[index].Legend = item["SpeciesName"].ToString();
                    charts[index].Fill.Color = colors[index];
                    charts[index].Line.Color = colors[index];
                    charts[index].Line.Width = 2;

                    chartControl.Charts.Add(charts[index]);
                    index++;
                }
            }

            chartControl.Width = 640;
            chartControl.Height = 480;
            chartControl.ChartPadding = 40;
            chartControl.TopPadding = 32;
            chartControl.Border = new ChartLine( Color.Black );

            chartControl.Background = new ChartInterior( Color.FromArgb( 216, 216, 216 ) );

            chartControl.GridLines = GridLines.Horizontal;
            chartControl.Legend.Position = LegendPosition.Right;

            chartControl.ChartTitle = new ChartText();
            chartControl.ChartTitle.Text = "Population (24 hours starting " + begin.ToString() + ")";
            chartControl.ChartTitle.Font = new Font( "Verdana", 10.0f, FontStyle.Bold );
            chartControl.ShowXValues = false;
            chartControl.XTicksInterval = 4;
            chartControl.YCustomStart = 1;
            chartControl.RedrawChart();

            return "~/ChartData/" + chartControl.ImageID + ".png";
        }
예제 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SmoothLineChart lcTBudget;
            DataRow         drownew;
            DataTable       tblOSIReport = new DataTable();
            tblOSIReport.Columns.Add("month");
            tblOSIReport.Columns.Add("tamount");
            chaBudCon.ChartTitle.Text = Request.QueryString["division"] + " Office Supplies Budget Consumption FY: 2007-2008 [As of " + DateTime.Now.ToString("MMMM dd, yyyy") + "]";

            double     dblHighest    = 0;
            int        intCtr        = 0;
            int        intDiviCtr    = 0;
            double[]   dblTotal      = new double[12];
            double[]   dblMonthTotal = new double[12];
            string[]   strMonth      = new string[] { "April", "May", "June", "July", "August", "September", "October", "November", "December", "January", "February", "March" };
            DateTime[] dteFrom       = new DateTime[] { Convert.ToDateTime("4/1/2007"), Convert.ToDateTime("5/1/2007"), Convert.ToDateTime("6/1/2007"), Convert.ToDateTime("7/1/2007"), Convert.ToDateTime("8/1/2007"), Convert.ToDateTime("9/1/2007"), Convert.ToDateTime("10/1/2007"), Convert.ToDateTime("11/1/2007"), Convert.ToDateTime("12/1/2007"), Convert.ToDateTime("1/1/2008"), Convert.ToDateTime("2/1/2008"), Convert.ToDateTime("3/1/2008") };
            DateTime[] dteTo         = new DateTime[] { Convert.ToDateTime("4/30/2007"), Convert.ToDateTime("5/31/2007"), Convert.ToDateTime("6/30/2007"), Convert.ToDateTime("7/31/2007"), Convert.ToDateTime("8/31/2007"), Convert.ToDateTime("9/30/2007"), Convert.ToDateTime("10/31/2007"), Convert.ToDateTime("11/30/2007"), Convert.ToDateTime("12/31/2007"), Convert.ToDateTime("1/31/2008"), Convert.ToDateTime("2/29/2008"), Convert.ToDateTime("3/31/2008") };
            Color[]    clrDivision   = new Color[] { Color.Blue, Color.Yellow, Color.Purple, Color.DarkGreen, Color.Orange, Color.DarkBlue, Color.Brown, Color.Pink };

            DataTable tblRC = new DataTable();
            using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GreatPlains"].ToString()))
            {
                SqlCommand cmd = cn.CreateCommand();
                cn.Open();
                SqlDataReader dr;

                cmd.CommandText = "SELECT custnmbr,custname FROM rm00101 WHERE rm00101.custclas='HQ DEPARTMENT' AND rm00101.custnmbr IN ('" + clsRC.GetSQLInClauseGP(Request.QueryString["divicode"]) + "') ORDER BY custname";
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(tblRC);

                foreach (DataRow drow in tblRC.Rows)
                {
                    for (intCtr = 0; intCtr <= 11; intCtr++)
                    {
                        dblMonthTotal[intCtr] = 0;
                    }

                    for (intCtr = 0; intCtr <= 11; intCtr++)
                    {
                        cmd.CommandText = "SELECT SUM(sop30200.docamnt) AS pTotal FROM sop30200 INNER JOIN rm00101 ON rm00101.custnmbr = sop30200.custnmbr WHERE rm00101.custclas='HQ DEPARTMENT' AND (left(sop30200.sopnumbe,3)='OSD') AND rm00101.custnmbr='" + drow["custnmbr"] + "' AND sop30200.docdate BETWEEN '" + dteFrom[intCtr] + "' AND '" + dteTo[intCtr] + "'";
                        dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            dblMonthTotal[intCtr] = dblMonthTotal[intCtr] + (Convert.IsDBNull(dr["pTotal"].ToString()) || dr["pTotal"].ToString() == "" ? 0 : Convert.ToDouble(dr["pTotal"].ToString()));
                            dblTotal[intCtr]      = dblTotal[intCtr] + dblMonthTotal[intCtr];
                        }
                        dr.Close();
                    }

                    for (intCtr = 0; intCtr <= 11; intCtr++)
                    {
                        drownew            = tblOSIReport.NewRow();
                        drownew["month"]   = strMonth[intCtr];
                        drownew["tamount"] = dblMonthTotal[intCtr];
                        tblOSIReport.Rows.Add(drownew);
                    }

                    lcTBudget                 = new SmoothLineChart();
                    lcTBudget.Line.Width      = 2;
                    lcTBudget.Line.Color      = clrDivision[intDiviCtr];
                    lcTBudget.Legend          = drow["custname"].ToString();
                    lcTBudget.DataSource      = tblOSIReport.DefaultView;
                    lcTBudget.DataXValueField = "month";
                    lcTBudget.DataYValueField = "tamount";
                    lcTBudget.DataBind();
                    chaBudCon.Charts.Add(lcTBudget);

                    tblOSIReport.Rows.Clear();
                    intDiviCtr++;
                }

                for (intCtr = 0; intCtr <= 11; intCtr++)
                {
                    drownew            = tblOSIReport.NewRow();
                    drownew["month"]   = strMonth[intCtr];
                    drownew["tamount"] = dblTotal[intCtr];
                    tblOSIReport.Rows.Add(drownew);
                    if (dblHighest == 0)
                    {
                        dblHighest = dblTotal[intCtr];
                    }
                    else
                    if (dblTotal[intCtr] > dblHighest)
                    {
                        dblHighest = dblTotal[intCtr];
                    }
                }

                lcTBudget                             = new SmoothLineChart();
                lcTBudget.Line.Width                  = 2;
                lcTBudget.Line.Color                  = Color.Red;
                lcTBudget.DataLabels.Visible          = true;
                lcTBudget.DataLabels.Background.Color = System.Drawing.Color.White;
                lcTBudget.Legend                      = Request.QueryString["division"];
                lcTBudget.DataSource                  = tblOSIReport.DefaultView;
                lcTBudget.DataXValueField             = "month";
                lcTBudget.DataYValueField             = "tamount";
                lcTBudget.DataBind();
                chaBudCon.Charts.Add(lcTBudget);
            }

            chaBudCon.YCustomEnd      = Convert.ToInt32(dblHighest) + 1000;
            chaBudCon.YValuesInterval = Convert.ToInt32((dblHighest + 1000) / 10);
            chaBudCon.RedrawChart();
        }
    }
예제 #3
0
        /*
            Member:     ChartVitals
            Purpose:    This function charts all of the vital statistics between a given
            start and end data for a single species.  This is useful for determining the
            effectiveness of your creatures code.
        */
        public static string ChartVitals(DateTime beginTime, DateTime endTime, string species)
        {
            ChartControl chartControl = new ChartControl ();
            ChartControl.PhysicalPath = ServerSettings.ChartPath + "\\";
            ChartControl.VirtualPath = "/Terrarium/ChartData";

            ChartPointCollection[] data=new ChartPointCollection[8];
            Chart[] charts=new Chart[8];

            DateTime begin = beginTime;
            DateTime end = endTime;

            SqlConnection myConnection = new SqlConnection(ServerSettings.SpeciesDsn);

            myConnection.Open();

            long bottomTicks = begin.Ticks;
            long totalTicks = end.Ticks - begin.Ticks;

            SqlCommand command = new SqlCommand("TerrariumGrabSpeciesDataInDateRange", myConnection);
            command.CommandType = CommandType.StoredProcedure;

            command.Parameters.Add("@SpeciesName", SqlDbType.VarChar, 50).Value = species;
            command.Parameters.Add("@BeginDate", SqlDbType.DateTime, 8).Value = begin;
            command.Parameters.Add("@EndDate", SqlDbType.DateTime, 8).Value = end;

            for(int i = 0; i < data.Length; i++)
            {
                data[i] = new ChartPointCollection();
            }

            float[,] buckets = new float[8,24];
            for(int i = 0; i < 8; i++) {
                for(int j = 0; j < 24; j++) {
                    buckets[i, j] = -1;
                }
            }

            using(SqlDataReader dr = command.ExecuteReader())
            {
                while(dr.Read())
                {
                    TimeSpan offset = endTime - ((DateTime) dr["SampleDateTime"]);
                    int bucket = 24 - (int) Math.Round(offset.TotalHours);

                    if ( bucket > -1 && bucket <= buckets.GetUpperBound(1) ) {
                        buckets[0, bucket] = (float) (int) dr["BirthCount"];
                        buckets[1, bucket] = (float) (int) dr["StarvedCount"];
                        buckets[2, bucket] = (float) (int) dr["KilledCount"];
                        buckets[3, bucket] = (float) (int) dr["ErrorCount"];
                        buckets[4, bucket] = (float) (int) dr["TimeoutCount"];
                        buckets[5, bucket] = (float) (int) dr["SickCount"];
                        buckets[6, bucket] = (float) (int) dr["OldAgeCount"];
                        buckets[7, bucket] = (float) (int) dr["SecurityViolationCount"];
                    }

                    /*
                    long recordTicks = ((DateTime) dr["SampleDateTime"]).Ticks;
                    float normalizedSampleTime = (float) ((double) (recordTicks - bottomTicks) / (double) (totalTicks / 24));
                    int ibirth = (int) dr["BirthCount"];
                    int istarve = (int) dr["StarvedCount"];
                    int ikilled = (int) dr["KilledCount"];
                    int ierror = (int) dr["ErrorCount"];
                    int itimeout = (int) dr["TimeoutCount"];
                    int isick = (int) dr["SickCount"];
                    int iold = (int) dr["OldAgeCount"];
                    int isecurity = (int) dr["SecurityViolationCount"];

                    data[0].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) ibirth));
                    data[1].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) istarve));
                    data[2].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) ikilled));
                    data[3].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) ierror));
                    data[4].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) itimeout));
                    data[5].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) isick));
                    data[6].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) iold));
                    data[7].Add(new ChartPoint(normalizedSampleTime.ToString(), (float) isecurity));
                    */
                }
                dr.Close();
            }

            string[] names = new string[] { "Birth", "Starved", "Killed", "Errors", "Timed Out", "Sick", "Old Age", "Security Exception" };

            for(int i = 0; i < 24; i++)
            {
                data[0].Add(new ChartPoint(i.ToString(), buckets[0, i]));
                data[1].Add(new ChartPoint(i.ToString(), buckets[1, i]));
                data[2].Add(new ChartPoint(i.ToString(), buckets[2, i]));
                data[3].Add(new ChartPoint(i.ToString(), buckets[3, i]));
                data[4].Add(new ChartPoint(i.ToString(), buckets[4, i]));
                data[5].Add(new ChartPoint(i.ToString(), buckets[5, i]));
                data[6].Add(new ChartPoint(i.ToString(), buckets[6, i]));
                data[7].Add(new ChartPoint(i.ToString(), buckets[7, i]));
            }

            for(int i = 0; i < charts.Length; i++) {
                charts[i] = new SmoothLineChart(data[i], colors[i]);
                charts[i].Legend = names[i];
                charts[i].Fill.Color = colors[i];
                charts[i].Line.Color = colors[i];
                charts[i].ShowLineMarkers = false;
                charts[i].DataLabels.ShowValue = false;
                charts[i].Line.Width = 2;
                chartControl.Charts.Add(charts[i]);
            }

            chartControl.Width = 640;
            chartControl.Height = 480;
            chartControl.ChartPadding = 40;
            chartControl.TopPadding = 32;
            chartControl.Border = new ChartLine( Color.Black );
            chartControl.Background = new ChartInterior( Color.FromArgb( 216, 216, 216 ) );
            chartControl.GridLines = GridLines.Horizontal;
            chartControl.Legend.Position = LegendPosition.Right;

            chartControl.ChartTitle = new ChartText();
            chartControl.ChartTitle.Text = "Vitals (24 hours starting " + begin.ToString() + ")";
            chartControl.ChartTitle.Font = new Font( "Verdana", 10.0f, FontStyle.Bold );
            chartControl.ShowXValues = false;
            chartControl.XTicksInterval = 4;
            chartControl.RedrawChart();

            return "~/ChartData/" + chartControl.ImageID + ".png";
        }