private void Page_Load(object sender, System.EventArgs e) { int x = -1; // int y = 0; // int rowCnt = 7; // int rowCtr=0; // int cellCtr=0; // int cellCnt = 3; string sFName; long[] LASpecific = new long[7]; long[] LAGeneral = new long[7]; long[] LAStopCode = new long[7]; // long lTemp=0,lTotalAnon=0,lTotalCustomer=0; Object[] yValues = new Object[7]; Object[] xValues = new Object[7]; Object[] yValues1 = new Object[3]; Object[] xValues1 = new Object[3]; OCAData.CCountDailyClass rpt = new OCAData.CCountDailyClass(); System.DateTime dDate = new System.DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month, System.DateTime.Now.Day); OWC.WCChart oChart; // OWC.WCChart oChart1; OWC.ChartSpaceClass oSpace = new OWC.ChartSpaceClass(); OWC.ChartSpaceClass oSpace1 = new OWC.ChartSpaceClass(); OWC.WCSeries oSeries; // OWC.WCSeries oSeries1; // OWC.WCDataLabels oLabels; // OWC.WCDataLabelsCollection oLabelCollection; //System.Array xValues = System.Array.CreateInstance(typeof(Object), 7, 1); //Array xValues = Array.CreateInstance(typeof(Object),3); Server.ScriptTimeout = 360; oSpace.Clear(); oSpace.Refresh(); oChart = oSpace.Charts.Add(0); oChart.Type = OWC.ChartChartTypeEnum.chChartTypeBarClustered; oChart.HasLegend = true; //Begin Image One for (x = 0; x < 7; x++) { oSeries = oChart.SeriesCollection.Add(x); try { LASpecific[x] = rpt.GetSpecificSolutions(dDate.AddDays(-(x + 1))); } catch { LASpecific[x] = 0; } try { LAGeneral[x] = rpt.GetGeneralSolutions(dDate.AddDays(-(x + 1))); } catch { LAGeneral[x] = 0; } try { LAStopCode[x] = rpt.GetStopCodeSolutions(dDate.AddDays(-(x + 1))); } catch { LAStopCode[x] = 0; } xValues.SetValue(LASpecific[x], 0); xValues.SetValue(LAGeneral[x], 1); xValues.SetValue(LAStopCode[x], 2); yValues.SetValue("Specific", 0); yValues.SetValue("General", 1); yValues.SetValue("StopCode", 2); oChart.HasTitle = true; oChart.Title.Caption = "Daily Solution Status"; oSeries.Caption = dDate.AddDays(-(x + 1)).Date.ToString(); //chDimCategories oSeries.SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, yValues); oSeries.SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xValues); oSeries.Type = OWC.ChartChartTypeEnum.chChartTypeColumnClustered; } sFName = "DailySolution"; oSpace.ExportPicture(Server.MapPath(sFName), "gif", 1000, 512); imgDailySolution.ImageUrl = sFName; }
/************************************************************************************* * module: frmSolutionStatus.cs - TLoadData * * author: Tim Ragain * date: Jan 24, 2002 * * Purpose: Takes two variables the x represents the day as an integer and the sCount is a * short representing the column of the Calendar control. This initializes the OCAData.dll * control and calls the GetDailyCount and GetDailyAnon procedures. The anonymous count is * subtracted from the total count to get the customer count. The appropriate column * and row is updated. *************************************************************************************/ private void TLoadData(int x, short sCount) { OCAData.CCountDailyClass rpt = new OCAData.CCountDailyClass(); System.DateTime dDate = new System.DateTime(monthCalendar1.SelectionStart.Year, monthCalendar1.SelectionStart.Month, monthCalendar1.SelectionStart.Day); long l_SpecificSolutions = 0, l_GeneralSolutions = 0, l_StopCodes = 0, l_TotalRecords = 0; //***********Total Record Count*************** UpdateStatus(); statusBar1.Text = "Getting Specific Solutions for " + dDate.AddDays(x).Date.ToString(); lDate[x] = dDate.AddDays(x); try { l_SpecificSolutions = rpt.GetSpecificSolutions(dDate.AddDays(x)); } catch { l_SpecificSolutions = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)1; axMSChart1.RowLabel = dDate.AddDays(x).ToShortDateString(); //+ dDate.Date.ToString(); axMSChart1.Data = l_SpecificSolutions.ToString(); lSpecific[x] = l_SpecificSolutions; } UpdateStatus(); statusBar1.Text = "Getting General Solutions for " + dDate.AddDays(x).Date.ToString(); try { l_GeneralSolutions = rpt.GetGeneralSolutions(dDate.AddDays(x)); } catch { l_GeneralSolutions = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)2; axMSChart1.Data = l_GeneralSolutions.ToString(); lGeneral[x] = l_GeneralSolutions; } UpdateStatus(); statusBar1.Text = "Getting Stop Code Troubleshooters for " + dDate.AddDays(x).Date.ToString(); try { l_StopCodes = rpt.GetStopCodeSolutions(dDate.AddDays(x)); } catch { l_StopCodes = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)3; axMSChart1.Data = l_StopCodes.ToString(); lStopCode[x] = l_StopCodes; } UpdateStatus(); statusBar1.Text = "Getting No Solution incidents for " + dDate.AddDays(x).Date.ToString(); try { l_TotalRecords = rpt.GetDailyCount(dDate.AddDays(x)); } catch { l_TotalRecords = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)4; l_TotalRecords = l_TotalRecords - (l_StopCodes + l_GeneralSolutions + l_SpecificSolutions); axMSChart1.Data = l_TotalRecords.ToString(); lNoSolution[x] = l_TotalRecords; } UpdateStatus(); this.Refresh(); }