public YuMiPoHuaiTitleModel getYuMiPoHuaiTitle(string tableName, string shiYanHao)
{
YuMiPoHuaiTitleModel title = new YuMiPoHuaiTitleModel();
try
{
SqlConnection();
}
catch (Exception e)
{
throw e;
}
sqlStr = "select * from " + tableName + " where 实验号 = '" + shiYanHao + "'";
try
{
dataControl = new DataControl();
reader = dataControl.controlSql(sqlCon, sqlStr);
}
catch (Exception e)
{
throw e;
}
reader.Read();
title.temTitle = Convert.ToString(reader["温度标题"]);
title.poHuaiLvTitle = Convert.ToString(reader["破坏率标题"]);
title.temTitleSpeed = Convert.ToString(reader["温度标题速率"]);
title.poHuaiLvTitleSpeed = Convert.ToString(reader["破坏率标题速率"]);
title.ShiYanHao = Convert.ToString(reader["实验号"]);
title.XLabel = Convert.ToString(reader["x轴"]);
title.temLabelSpeed = Convert.ToString(reader["y轴温度速率"]);
title.temLabel = Convert.ToString(reader["y轴温度"]);
title.poHuaiLvLabelSpeed = Convert.ToString(reader["y轴破坏率速率"]);
title.poHuaiLvLabel = Convert.ToString(reader["y轴破坏率"]);
title.temChartMiaoShu = Convert.ToString(reader["温度描述"]);
title.poHuaiLvChartMiaoShu = Convert.ToString(reader["破坏率描述"]);
title.temChartSpeedMiaoShu = Convert.ToString(reader["温度速率图描述"]);
title.poHuaiLvChartSpeedMiaoShu = Convert.ToString(reader["破坏率速率描述"]);
try
{
SqlClose();
}
catch (Exception e)
{
throw e;
}
return(title);
}
private void setTitle(YuMiPoHuaiTitleModel title, String str)
{
String yLabel, xLabel, titleName, titleSpeedName, ySpeedLabel, miaoShu, miaoShuSpeed;
Type type = typeof(YuMiPoHuaiTitleModel);
PropertyInfo piY = type.GetProperty(str + "Label");
yLabel = Convert.ToString(piY.GetValue(title, null));
PropertyInfo piYSpeed = type.GetProperty(str + "LabelSpeed");
ySpeedLabel = Convert.ToString(piYSpeed.GetValue(title, null));
PropertyInfo piX = type.GetProperty("XLabel");
xLabel = Convert.ToString(piX.GetValue(title, null));
PropertyInfo piTitle = type.GetProperty(str + "Title");
titleName = Convert.ToString(piTitle.GetValue(title, null));
PropertyInfo piSpeedTitle = type.GetProperty(str + "TitleSpeed");
titleSpeedName = Convert.ToString(piSpeedTitle.GetValue(title, null));
PropertyInfo piMiaoShu = type.GetProperty(str + "ChartMiaoShu");
miaoShu = Convert.ToString(piMiaoShu.GetValue(title, null));
PropertyInfo piSpeedMiaoShu = type.GetProperty(str + "ChartSpeedMiaoShu");
miaoShuSpeed = Convert.ToString(piSpeedMiaoShu.GetValue(title, null));
if (YuMiPoHuaiPage.type == 2)
{
ChartDisplay.title.Content = titleSpeedName;
ChartDisplay.yText.Text = ySpeedLabel;
ChartDisplay.jieShi.Document = convertToBox.convertStringToFlowDocument(miaoShuSpeed);
}
else
{
ChartDisplay.title.Content = titleName;
ChartDisplay.yText.Text = yLabel;
ChartDisplay.jieShi.Document = convertToBox.convertStringToFlowDocument(miaoShu);
}
ChartDisplay.xText.Content = xLabel;
}
// private List<YuMiPoHuaiModel> predictModels;
private void Grid_Load(object sender, RoutedEventArgs e)
{
biaoShi_Loaded();
data = new InitData();
data.cengShuText = "实验层数：";
data.cengShuListText.Add("第一层");
data.cengShuListText.Add("第二层");
data.cengShuListText.Add("第三层");
data.jianCeDianText = "实验地点：";
data.jianCeDianListText.Add("地点一");
data.jianCeDianListText.Add("地点二");
data.jianCeDianListText.Add("地点三");
data.jianCeDianListText.Add("地点四");
data.jianCeDianListText.Add("地点五");
data.radioCheck1Text = "温度的变化情况";
data.radioCheck2Text = "破坏率的变化情况";
InitPage(data);
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000001");
setTitle(title, "tem");
try
{
models = dataSource.getYuMiPoHuaiData("000001");
}
catch (Exception)
{
MessageBox.Show("获取数据失败!!");
return;
}
if (dataChart.Series.Count > 0)
{
dataChart.Series.Clear();
}
switch (YuMiPoHuaiPage.type)
{
case 1:
setAxes(models, "tem");
InitBarChart(models, "tem");
InitLineBar(models, "temLow");
InitLineBar(models, "temHigh");
InitLineBar(models, "temMedia");
break;
case 2:
setAddToSpeedAxes(models, "tem");
InitAddToSpeedSpline(models, "tem");
break;
case 3:
setAxes(models, "tem");
InitSpline(models, "tem", MarkerType.None);
break;
case 4:
setAxes(models, "tem");
InitSpline(models, "tem", MarkerType.None);
break;
case 5:
setAxes(models, "tem");
InitBarChart(models, "tem");
break;
case 6:
setAxes(models, "tem");
InitLine(models, "tem");
break;
case 7:
InitDongTai(models, "tem");
break;
case 8:
setBubbleAxes(models, "tem");
InitBubble(models, "tem");
break;
}
}
private void PanDuan()
{
biaoShi_Loaded();
if (dataChart.Series.Count > 0)
{
dataChart.Series.Clear();
}
switch (cengShuCom.SelectedIndex)
{
case 0:
switch (jianCeDianCom.SelectedIndex)
{
case 0:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000001");
models = dataSource.getYuMiPoHuaiData("000001");
break;
case 1:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000002");
models = dataSource.getYuMiPoHuaiData("000002");
break;
case 2:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000003");
models = dataSource.getYuMiPoHuaiData("000003");
break;
case 3:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000004");
models = dataSource.getYuMiPoHuaiData("000004");
break;
case 4:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000005");
models = dataSource.getYuMiPoHuaiData("000005");
break;
}
break;
case 1:
switch (jianCeDianCom.SelectedIndex)
{
case 0:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000006");
models = dataSource.getYuMiPoHuaiData("000006");
break;
case 1:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000007");
models = dataSource.getYuMiPoHuaiData("000007");
break;
case 2:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000008");
models = dataSource.getYuMiPoHuaiData("000008");
break;
case 3:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000009");
models = dataSource.getYuMiPoHuaiData("000009");
break;
case 4:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000010");
models = dataSource.getYuMiPoHuaiData("000010");
break;
}
break;
case 2:
switch (jianCeDianCom.SelectedIndex)
{
case 0:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000011");
models = dataSource.getYuMiPoHuaiData("000011");
break;
case 1:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000012");
models = dataSource.getYuMiPoHuaiData("000012");
break;
case 2:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000013");
models = dataSource.getYuMiPoHuaiData("000013");
break;
case 3:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000014");
models = dataSource.getYuMiPoHuaiData("000014");
break;
case 4:
title = dataSource.getYuMiPoHuaiTitle("玉米加热破坏实验坐标轴描述表", "000015");
models = dataSource.getYuMiPoHuaiData("000015");
break;
}
break;
default:
MessageBox.Show("没有数据");
return;
}
switch (YuMiPoHuaiPage.type)
{
case 1:
if (tempCheck.IsChecked == true)
{
setAxes(models, "tem");
InitBarChart(models, "tem");
InitLineBar(models, "temLow");
InitLineBar(models, "temHigh");
InitLineBar(models, "temMedia");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAxes(models, "poHuaiLv");
InitBarChart(models, "poHuaiLv");
InitLineBar(models, "poHuaiLvLow");
InitLineBar(models, "poHuaiLvHigh");
InitLineBar(models, "poHuaiLvMedia");
setTitle(title, "poHuaiLv");
}
break;
case 2:
if (tempCheck.IsChecked == true)
{
setAddToSpeedAxes(models, "tem");
InitAddToSpeedSpline(models, "tem");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAddToSpeedAxes(models, "poHuaiLv");
InitAddToSpeedSpline(models, "poHuaiLv");
setTitle(title, "poHuaiLv");
}
break;
case 3:
if (tempCheck.IsChecked == true)
{
setAxes(models, "tem");
InitSpline(models, "tem", MarkerType.None);
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAxes(models, "poHuaiLv");
InitSpline(models, "poHuaiLv", MarkerType.None);
setTitle(title, "poHuaiLv");
}
break;
case 4:
if (tempCheck.IsChecked == true)
{
setAxes(models, "tem");
InitSpline(models, "tem", MarkerType.None);
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAxes(models, "poHuaiLv");
InitSpline(models, "poHuaiLv", MarkerType.None);
setTitle(title, "poHuaiLv");
}
break;
case 5:
if (tempCheck.IsChecked == true)
{
setAxes(models, "tem");
InitBarChart(models, "tem");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAxes(models, "poHuaiLv");
InitBarChart(models, "poHuaiLv");
setTitle(title, "poHuaiLv");
}
break;
case 6:
if (tempCheck.IsChecked == true)
{
setAxes(models, "tem");
InitLine(models, "tem");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setAxes(models, "poHuaiLv");
InitLine(models, "poHuaiLv");
setTitle(title, "poHuaiLv");
}
break;
case 7:
if (tempCheck.IsChecked == true)
{
InitDongTai(models, "tem");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
InitDongTai(models, "poHuaiLv");
setTitle(title, "poHuaiLv");
}
break;
case 8:
if (tempCheck.IsChecked == true)
{
setBubbleAxes(models, "tem");
InitBubble(models, "tem");
setTitle(title, "tem");
}
else if (poHuaiLvCheck.IsChecked == true)
{
setBubbleAxes(models, "poHuaiLv");
InitBubble(models, "poHuaiLv");
setTitle(title, "poHuaiLv");
}
break;
default:
break;
}
}