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