private void button2_Click(object sender, EventArgs e) { // DataBase.GetXLS(BusinessLogics.DumpDataSet(DataBase.LoadFromFile("Measure.xls"))); BusinessLogics.GernerateXls(); System.Diagnostics.Process.Start("数据.xls"); MessageBox.Show("Excel 生成成功"); }
public static List <double> GetChartYList() { List <List <string> > l = BusinessLogics.GetListFromDataBase(); List <double> y = new List <double>(l.Capacity); for (int i = 0; i < l.Count; i++) { y.Add(double.Parse(l[i][3]) / double.Parse(l[i][1])); } return(y); }
public static double[] GetRealMeasureList() { List <List <string> > l = BusinessLogics.GetListFromDataBase(); List <double> x = new List <double>(l.Capacity); for (int i = 0; i < l.Count; i++) { x.Add(double.Parse(l[i][2])); } return(x.ToArray()); }
public static List <string> GetChartXList() { List <List <string> > l = BusinessLogics.GetListFromDataBase(); List <string> x = new List <string>(l.Capacity); for (int i = 0; i < l.Count; i++) { x.Add(l[i][1]); } return(x); }
private void clear_Click(object sender, EventArgs e) { DialogResult ds = MessageBox.Show("你是否要清空历史数据?", "Warn", MessageBoxButtons.OKCancel); if (ds == DialogResult.OK) { //del BusinessLogics.Clear(); } else if (ds == DialogResult.Cancel) { //do nothing } }
private void GetList() { List <List <string> > l = BusinessLogics.GetListFromDataBase(); Screen.Items.Clear(); for (int i = l.Count() - 1; i >= 0; i--) { ListViewItem item1 = new ListViewItem(l[i][0], 0); item1.Checked = false; item1.SubItems.Add(l[i][1]); item1.SubItems.Add(l[i][2]); item1.SubItems.Add(l[i][3]); item1.SubItems.Add(l[i][4]); item1.SubItems.Add(l[i][5]); Screen.Items.AddRange(new ListViewItem[] { item1 }); //Screen.ListViewItemSorter = new ListViewItemComparer(4); //Screen.Sorting = SortOrder.Descending; } }
private void Save_Click(object sender, EventArgs e) { if (Validation(Temp.Text.ToString(), Mea.Text.ToString())) { if (RealMea.Text != "" && RealTemp.Text != "") { if (Validation(RealTemp.Text.ToString(), RealMea.Text.ToString())) { BusinessLogics.AddData(double.Parse(Mea.Text.ToString()), double.Parse(Temp.Text.ToString()), double.Parse(RealMea.Text.ToString()), double.Parse(RealTemp.Text.ToString())); RealMea.Text = ""; RealTemp.Text = ""; MessageBox.Show("添加成功"); } } else { MessageBox.Show("数据不能为空"); } } else { MessageBox.Show("请打开串口"); } }
public static void GernerateXls() { DataBaseManager.GetXLS(BusinessLogics.DumpDataSet(DataBaseManager.LoadFromFile("Measure.xls"))); }
private void button4_Click(object sender, EventArgs e) { Chart chart = new Chart(BusinessLogics.GetChartXList(), BusinessLogics.GetChartYList()); chart.Show(); }