private void showAllFindedData() { String sql = "select * " + "from BasicData " + "where 性别='" + cmbSex.Text + "' and 胸围>" + txt1_Bust.Text + " and 胸围<" + txt2_Bust.Text + " " + "and 腰围>" + txt1_Waist.Text + " and 腰围<" + txt2_Waist.Text + " " + "and 臀围>" + txt1_ButtockGirth.Text + " and 臀围<" + txt2_ButtockGirth.Text + " " + "and 年龄>" + txt1_Age.Text + " and 年龄<" + txt2_Age.Text + "and 身高>" + txt1_BodyHigh.Text + " and 身高<" + txt2_BodyHigh.Text; BaseClass.DataBase myDataUtil = new BaseClass.DataBase(); this.allFindedDataSet = myDataUtil.RunProcReturn(sql, "BasicData"); this.dataGridViewFindResult.DataSource = allFindedDataSet.Tables[0]; }
private void paint(SeriesChartType chartType, Chart 需要绘图的表, String legend) { String sql = ""; for (int index = 0; index < selectedElements.Count; index++) { String str = selectedElements[index]; changeRange(str); sql += "select count(*) " + "from BasicData " + "where 年龄>" + this.fromAge + " and 年龄<" + this.toAge; DataSet dataset = dataBaseUtil.RunProcReturn(sql, "BasicData"); selectedElementsCount.Add(int.Parse(dataset.Tables[index].Rows[0].ItemArray[0].ToString())); } Series series = new Series(); series.ChartType = chartType; series.BorderWidth = 2; series.Color = graphColor; series.LegendText = legend; series.IsValueShownAsLabel = true; series["PieLabelStyle"] = "outside"; if (chartType == SeriesChartType.Column) { for (int index = 0; index < selectedElements.Count; index++) { series.Points.AddXY(this.selectedElements[index], this.selectedElementsCount[index]); } } else { series.Points.DataBindXY(this.selectedElements, this.selectedElementsCount); series.Label = "#INDEX(#PERCENT)"; } 需要绘图的表.Series.Clear(); 需要绘图的表.Series.Add(series); // 设置显示范围 ChartArea chartArea = 需要绘图的表.ChartAreas[0]; //chartArea.AxisX.Minimum = xMin; //chartArea.AxisX.Maximum = xMax; chartArea.AxisY.IsInterlaced = true; chartArea.Area3DStyle.Enable3D = true; }