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;
}