protected override void GetGraphCategoriesAndDatasets() { var datasets = new List <FusionChartsDataset>(); var hoursInShift = new FusionChartsDataset { Name = CultureManager.GetLabel("HS_EN_TURNO") }; var hoursOutOfShift = new FusionChartsDataset { Name = CultureManager.GetLabel("HS_FUERA_DE_TURNO") }; foreach (var item in ReportObjectsList) { hoursInShift.addValue(item.HoursInShift.ToString(CultureInfo.InvariantCulture)); hoursOutOfShift.addValue(item.HoursOutOfShift.ToString(CultureInfo.InvariantCulture)); } var categories = ReportObjectsList.Select(nivel => String.Format("{0} - {1}", nivel.Date.ToShortDateString(), nivel.Date.ToShortTimeString())).ToList(); datasets.Add(hoursOutOfShift); datasets.Add(hoursInShift); GraphCategories = categories; GraphDataSet = datasets; }
protected override string GetGraphXml() { using (var helper = new FusionChartsMultiSeriesHelper()) { SetGraphConfiguration(helper); var hoursInShift = new FusionChartsDataset { Name = CultureManager.GetLabel("HS_EN_TURNO") }; hoursInShift.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_EN_TURNO")); var hoursOutOfShift = new FusionChartsDataset { Name = CultureManager.GetLabel("HS_FUERA_DE_TURNO") }; hoursOutOfShift.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_FUERA_DE_TURNO")); hoursOutOfShift.SetPropertyValue("color", "1E90FF"); if (!ReportObjectsList.Any(d => !d.HoursInShift.Equals(0) || !d.HoursOutOfShift.Equals(0))) { return(helper.BuildXml()); } foreach (var item in ReportObjectsList) { helper.AddCategory(item.Date.ToShortTimeString()); hoursInShift.addValue(item.HoursInShift.ToString(CultureInfo.InvariantCulture)); hoursOutOfShift.addValue(item.HoursOutOfShift.ToString(CultureInfo.InvariantCulture)); } helper.AddDataSet(hoursInShift); helper.AddDataSet(hoursOutOfShift); return(helper.BuildXml()); } }
/// <summary> /// Generates the Datasets and Categories for the CSV. /// </summary> protected override void GetGraphCategoriesAndDatasets() { var datasets = new List <FusionChartsDataset>(); var consumos = new FusionChartsDataset { Name = CultureManager.GetLabel("MOTORES") }; foreach (var consumo in _motores) { consumos.addValue(consumo.VolumenConsumido.ToString(CultureInfo.InvariantCulture)); } datasets.Add(consumos); var niveles = new FusionChartsDataset { Name = ddlTanque.SelectedItem.Text }; foreach (var r in ReportObjectsList) { niveles.addValue(r.VolumenConsumido.ToString(CultureInfo.InvariantCulture)); } datasets.Add(niveles); var categories = ReportObjectsList.Select(nivel => String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString())).ToList(); GraphCategories = categories; GraphDataSet = datasets; }
protected override string GetGraphXml() { using (var helper = new FusionChartsMultiSeriesHelper()) { if (ReportObjectsList.Count <= 0) { throw new Exception("No se encontraron datos asociados a los filtros seleccionados!"); } SetGraphProperties(helper); AddDates(helper); var maxTurnos = ReportObjectsList.Select(res => res.HsTurnos.Count).Max(); var colorGenerator = new ColorGenerator(); FusionChartsDataset niveles; for (var i = 0; i < maxTurnos; i++) { niveles = new FusionChartsDataset(); niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(colorGenerator.GetNextColor())); foreach (var dia in ReportObjectsList) { if (dia.HsTurnos.Count > 1) { niveles.addValue(dia.HsTurnos.First().ToString(CultureInfo.InvariantCulture)); dia.HsTurnos.Remove(dia.HsTurnos.First()); niveles.addValue(dia.HsReales.First().ToString(CultureInfo.InvariantCulture)); dia.HsReales.Remove(dia.HsReales.First()); niveles.addValue("0"); } else if (dia.HsTurnos.Count == 1) { niveles.addValue("0"); niveles.addValue("0"); niveles.addValue("0"); } } helper.AddDataSet(niveles); } niveles = new FusionChartsDataset(); niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(Color.Gray)); niveles.SetPropertyValue("seriesName", "Fuera de Turno"); foreach (var dia in ReportObjectsList) { niveles.addValue(dia.HsTurnos.First().ToString(CultureInfo.InvariantCulture)); niveles.addValue(dia.HsReales.First().ToString(CultureInfo.InvariantCulture)); niveles.addValue("0"); } helper.AddDataSet(niveles); return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsMultiSeriesHelper()) { SetGraphProperties(helper); var teoricDataset = new FusionChartsDataset(); var realDataset = new FusionChartsDataset(); var labelInterval = (ReportObjectsList.Count / MaxLabels) + 1; var i = labelInterval; int resto; Math.DivRem(Convert.ToInt32(npInterval.Value), 1440, out resto); var printOnlyDate = resto.Equals(0); teoricDataset.SetPropertyValue("seriesName", "Teórico"); realDataset.SetPropertyValue("seriesName", "Real"); realDataset.SetPropertyValue("color", "008ED6"); if (ReportObjectsList.Any(o => o.StockReal > 0 || o.StockTeorico > 0)) { foreach (var consist in ReportObjectsList) { var str = String.Empty; if (i == labelInterval) { str = printOnlyDate ? String.Format("{0}", consist.Fecha.ToShortDateString()) : String.Format("{0} - {1}", consist.Fecha.ToShortDateString(), consist.Fecha.ToShortTimeString()); i = 0; } i++; helper.AddCategory(str); teoricDataset.addValue(consist.StockTeorico.ToString(CultureInfo.InvariantCulture)); realDataset.addValue(consist.StockReal.ToString(CultureInfo.InvariantCulture)); } } if (chkTeorico.Checked) { helper.AddDataSet(teoricDataset); } if (chkReal.Checked) { helper.AddDataSet(realDataset); } var s = helper.BuildXml(); return(s); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsMultiSeriesHelper()) { if (ReportObjectsList.Count <= 0) { throw new Exception("No se encontraron datos asociados a los filtros seleccionados!"); } if (!ReportObjectsList.Any(r => r.HsOff > 0 || r.HsOn > 0 || r.HsTurnoOff > 0 || r.HsTurnoOn > 0)) { return(helper.BuildXml()); } SetGraphProperties(helper); var hsTurnoOn = new FusionChartsDataset(); hsTurnoOn.SetPropertyValue("color", "2E8B57"); hsTurnoOn.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_TURNO_ON")); var hsTurnoOff = new FusionChartsDataset(); hsTurnoOff.SetPropertyValue("color", "FFD700"); hsTurnoOff.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_TURNO_OFF")); var hsOn = new FusionChartsDataset(); hsOn.SetPropertyValue("color", "4876FF"); hsOn.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_ON")); var hsOff = new FusionChartsDataset(); hsOff.SetPropertyValue("color", "B22222"); hsOff.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_OFF")); foreach (var result in ReportObjectsList) { helper.AddCategory(String.Format("{0}", result.Fecha.ToShortDateString())); hsTurnoOn.addValue(result.HsTurnoOn.ToString(CultureInfo.InvariantCulture)); hsTurnoOff.addValue(result.HsTurnoOff.ToString(CultureInfo.InvariantCulture)); hsOn.addValue(result.HsOn.ToString(CultureInfo.InvariantCulture)); hsOff.addValue(result.HsOff.ToString(CultureInfo.InvariantCulture)); } helper.AddDataSet(hsTurnoOn); helper.AddDataSet(hsTurnoOff); helper.AddDataSet(hsOn); helper.AddDataSet(hsOff); return(helper.BuildXml()); } }
/// <summary> /// Adds configuration for the current report. /// </summary> /// <param name="helper"></param> /// <param name="vehicle"></param> private void AddConfiguration(FusionChartsHelper helper, Coche vehicle) { var km = ReportObjectsList.Sum(d => d.Kilometers); helper.AddConfigEntry("caption", String.Format(CultureManager.GetLabel(MovilDesdeHasta), vehicle.Interno.Replace('&', 'y'), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString()) + km.ToString(" - 0.00 km") ); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "km"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); }
/// <summary> /// Gets the graph XML file. /// </summary> /// <returns></returns> protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var hs = ReportObjectsList.Sum(d => d.ElapsedTime); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(MovilDesdeHasta), ddlMovil.SelectedItem.Text.Replace('&', 'y'), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString()) + TimeSpan.FromSeconds(hs).TotalHours.ToString(" - 0.00 hs") ); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("limitsDecimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); foreach (var timer in ReportObjectsList) { var item = new FusionChartsItem(); if (!timer.Fecha.DayOfWeek.Equals(DayOfWeek.Saturday) & !timer.Fecha.DayOfWeek.Equals(DayOfWeek.Sunday)) { item.AddPropertyValue("color", "008ED6"); } item.AddPropertyValue("name", String.Format("{0:dd/MM}", timer.Fecha)); item.AddPropertyValue("value", (timer.ElapsedTime / 3600.0).ToString(CultureInfo.InvariantCulture)); item.AddPropertyValue("hoverText", string.Concat(TimeSpan.FromSeconds(timer.ElapsedTime).ToString(), " ")); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Monitor/MonitorHistorico/monitorHistorico.aspx?Planta={1}&TypeMobile={2}&Movil={3}&InitialDate={4}&FinalDate={5}&Empresa={6}", ApplicationPath, ddlPlanta.Selected, ddlTipoVehiculo.Selected, ddlMovil.Selected, timer.Fecha.ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), timer.Fecha.Add(new TimeSpan(23, 59, 59)).ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), ddlDistrito.Selected))); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); if (ReportObjectsList.Select(r => r.ElapsedTime).Sum() == 0) { helper.AddConfigEntry("yAxisMaxValue", "24"); } foreach (var time in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Reportes/ControlDeAccesos/WorkedHours.aspx?Emp={1}&InitialDate={2}&FinalDate={3}", ApplicationPath, time.IdEmpleado, dpDesde.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture), dpHasta.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture)))); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", time.Empleado); item.AddPropertyValue("value", time.ElapsedTime.ToString(CultureInfo.InvariantCulture)); var hours = TimeSpan.FromHours(time.ElapsedTime); item.AddPropertyValue("hoverText", string.Concat(time.Empleado, string.Format(" - {0}dd {1}hh {2}mm {3}ss", hours.Days, hours.Hours, hours.Minutes, hours.Seconds))); helper.AddItem(item); } return(helper.BuildXml()); } }
/// <summary> /// Adds tank level variation. /// </summary> /// <param name="helper"></param> private void AddTankLevelVariation(FusionChartsMultiSeriesHelper helper) { var niveles = new FusionChartsDataset(); var labelInterval = (ReportObjectsList.Count / _MAX_LABELS) + 1; var i = labelInterval; int resto; Math.DivRem(Convert.ToInt32(npIntervalo.Value), 1440, out resto); var printOnlyDate = resto.Equals(0); niveles.SetPropertyValue("seriesName", ddlTanque.SelectedItem.Text); niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(Color.SteelBlue)); if (ReportObjectsList.Any(o => o.VolumenConsumido > 0.01)) { foreach (var nivel in ReportObjectsList) { var str = string.Empty; if (i.Equals(labelInterval)) { str = printOnlyDate ? String.Format("{0}", nivel.Fecha.ToShortDateString()) : String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString()); i = 0; } i++; helper.AddCategory(str); niveles.addValue(nivel.VolumenConsumido.ToString(CultureInfo.InvariantCulture)); } } helper.AddDataSet(niveles); }
protected override void GetGraphCategoriesAndDatasets() { var avgConsumption = (from nivel in ReportObjectsList select nivel.Consumo).Average(); var consumos = new FusionChartsDataset { Name = string.Format("{0}: {1}lit", CultureManager.GetLabel("CONSUMO"), (int)avgConsumption) }; var avgCaudal = (from nivel in ReportObjectsList select nivel.Caudal).Average(); var caudal = new FusionChartsDataset { Name = string.Format("{0}: {1}lit", CultureManager.GetLabel("CAUDAL"), (int)avgCaudal) }; int resto; Math.DivRem(Convert.ToInt32(npIntervalo.Value), 1440, out resto); var printOnlyDate = resto.Equals(0); var categories = ReportObjectsList.Select(nivel => printOnlyDate ? String.Format("{0}", nivel.Fecha.ToShortDateString()) : String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString())).ToList(); foreach (var nivel in ReportObjectsList) { caudal.addValue(nivel.Caudal.ToString(CultureInfo.InvariantCulture)); } foreach (var dia in ReportObjectsList) { consumos.addValue(dia.Consumo.ToString(CultureInfo.InvariantCulture)); } GraphCategories = categories; GraphDataSet = new List <FusionChartsDataset> { caudal, consumos }; }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Date.ToString("dd/MM"), t => t.Max.ToString("0"))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Fecha.ToShortDateString(), t => (t.HsOff + t.HsOn + t.HsTurnoOff + t.HsTurnoOn).ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => string.Format("{0:dd/MM}", t.Fecha), t => (t.ElapsedTime / 3600).ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Date.ToString("dd/MM/yyyy HH:mm"), t => (t.HoursInShift + t.HoursOutOfShift).ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => String.Format("{0:dd/MM}", t.Dia), t => t.Velocidad.ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => DateTime.Parse(t.Fecha).TimeOfDay.ToString(), t => t.Valor)); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(st => st.Corner, st => st.StoppedEvents.ToString("#0"))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.FechaHora.ToString("hh:mm:ss"), t => t.Velocidad.ToString())); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Empleado, t => t.ElapsedTime.ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Interno, t => t.Kilometers.ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => t.Fecha.ToDisplayDateTime().ToString("HH:mm"), t => t.Cantidad.ToString(CultureInfo.InvariantCulture))); }
protected override Dictionary <string, string> GetExcelItemList() { return(ReportObjectsList.ToDictionary(t => string.Format("{0:dd/MM}", t.Fecha), t => t.ElapsedTime.ToString())); }