private void CargarFormularioChartPorSexo() { //conexionBD.Add(dataSource); //conexionBD.Add(initialCatalog); //conexionBD.Add(user); //conexionBD.Add(password); rcView.Series.Clear(); BarSeries barSeries = new BarSeries("Performance", "RepresentativeName"); barSeries.Name = "Q1"; BarSeries barSeries2 = new BarSeries("Performance", "RepresentativeName"); barSeries2.Name = "Q2"; BarSeries barSeries3 = new BarSeries("Performance", "RepresentativeName"); barSeries3.Name = "Q2"; SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter da = new SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter(); SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable dt = new WinUI.SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable(); da.Connection.ConnectionString = cadenaConexion; da.Fill(dt); foreach (DataRow dr in dt.Rows) { barSeries.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Paciente"].ToString()), dr["nombre"].ToString())); barSeries.ShowLabels = true; barSeries2.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Femenino"].ToString()), dr["nombre"].ToString())); barSeries3.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Masculino"].ToString()), dr["nombre"].ToString())); barSeries2.ShowLabels = true; barSeries3.ShowLabels = true; } rcView.View.Palette = KnownPalette.Cold; //rcView.ShowToolTip = true; this.rcView.Series.Add(barSeries); this.rcView.Series.Add(barSeries2); this.rcView.Series.Add(barSeries3); pbLeyenda.Image = global::SisOxi.WinUI.Properties.Resources.LeyendaSexo1; }
private void CargarFormularioChartPorSexo() { //conexionBD.Add(dataSource); //conexionBD.Add(initialCatalog); //conexionBD.Add(user); //conexionBD.Add(password); rcView.Series.Clear(); //SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter da = new SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter(); //SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable dt = new WinUI.SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable(); //da.Connection.ConnectionString = cadenaConexion; //da.Fill(dt); //rcView.DataSource = dt; //BarSeries barSeries = new BarSeries("Paciente", "Enfermedad"); //barSeries.DataMember = "Paciente"; //barSeries.LegendTitle = "Paciente"; //rcView.Series.Add(barSeries); //rcView.ShowLegend = true; rcView.Title = " Grafico de Barras para la Frencuencia en Sexo de Todas las Enfermedades"; rcView.ShowTitle = true; BarSeries barSeries = new BarSeries("Paciente", "nombre"); barSeries.Name = "Q1"; BarSeries barSeries2 = new BarSeries("Performance", "RepresentativeName"); barSeries2.Name = "Q2"; BarSeries barSeries3 = new BarSeries("Performance", "RepresentativeName"); barSeries3.Name = "Q2"; SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter da = new SisOxibariterapiaDataSetTableAdapters.spr_ReporteEnfermedadesPorSexoTableAdapter(); SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable dt = new WinUI.SisOxibariterapiaDataSet.spr_ReporteEnfermedadesPorSexoDataTable(); da.Connection.ConnectionString = cadenaConexion; da.Fill(dt); DataTable dx = new DataTable(); dx.Columns.Add("nombre"); dx.Columns.Add("Femenino"); dx.Columns.Add("Masculino"); foreach (DataRow dr in dt.Rows) { dx.Rows.Add(dr["nombre"].ToString(),dr["Femenino"].ToString(),dr["Masculino"].ToString()); barSeries.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Paciente"].ToString()), dr["nombre"].ToString())); barSeries.ShowLabels = true; barSeries.LegendTitle = "Paciente"; barSeries2.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Femenino"].ToString()), dr["nombre"].ToString())); barSeries3.DataPoints.Add(new CategoricalDataPoint(Convert.ToDouble(dr["Masculino"].ToString()), dr["nombre"].ToString())); barSeries2.LegendTitle = "Femenino"; barSeries2.ShowLabels = true; barSeries3.ShowLabels = true; barSeries3.LegendTitle = "Masculino"; } rcView.View.Palette = KnownPalette.Cold; //rcView.ShowToolTip = true; this.rcView.Series.Add(barSeries); this.rcView.Series.Add(barSeries2); this.rcView.Series.Add(barSeries3); this.rcView.ShowLegend = true; //this.rcView.Controllers.Add(new SmartLabelsController()); this.rcView.ShowSmartLabels = true; this.rcView.LegendTitle = "Leyenda"; this.rcView.ChartElement.LegendElement.TitleElement.Font = new Font(rcView.ChartElement.Font.FontFamily.Name, 18); foreach (LegendItemElement item in this.rcView.ChartElement.LegendElement.StackElement.Children) { item.Font = new Font(rcView.ChartElement.Font.FontFamily.Name, 14); } //this.rcView.ChartElement.LegendPosition = LegendPosition.Float; //this.rcView.ChartElement.LegendOffset = new Point(200, 0); //this.rcViewPastel.Series.Add(series); //pbLeyenda.Image = global::SisOxi.WinUI.Properties.Resources.LeyendaSexo1; dtPie = dx; CargarCboEnfermedad(dx); }