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