c#学习心得（5）数据采集上位机开发

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO.Ports;
using System.Windows.Forms.DataVisualization.Charting;
using System.Globalization;
using Excel = Microsoft.Office.Interop.Excel;//不能直接引用和chart冲突
using NPOI.HSSF.UserModel;
using System.IO;


namespace HostCoumputer_edition1
{
    
    public partial class frmDataRecive : Form
    {
        //实例化一个先进先出的队列
        private Queue<double> dataqueue = new Queue<double>(200);
        //每次删除或增加的点?????
        int num = 1;
        //定义一个接收15个字节的数组
        private byte[] receivedData = new byte[15];
        //定义全局变量txt 此处还需要更改如何使图表不更新这个初始值
        string txt;
        //定义一个timer变量？（字段）
      //  private static System.Timers.Timer t;
        private SerialPort sp;
        //定义一个bool变量控制serialport和timer的开启
      //  bool btnstop = false;
   

        public frmDataRecive()
        {
            InitializeComponent();
        }

        private void btnStart_Click(object sender, EventArgs e)
        {
           
          
                SetSerialPort();
                InitChart();
               
                this.timer1.Start();
            
        }
        /// <summary>
        /// 设置串口参数
        /// </summary>
        private void SetSerialPort()
        {
           // int a = int.Parse(cbBaudateRate.Text);
           // int b = int.Parse(cbDataBits.Text);

            sp = new SerialPort();
            sp.BaudRate = 9600 ;
            sp.PortName = "COM1";
            sp.DataBits = 8;
            sp.Parity = Parity.None;
            sp.StopBits = StopBits.One;
            sp.ReadTimeout = -1;

            sp.DataReceived += new SerialDataReceivedEventHandler (serialPortDatarecived);
            if (sp.IsOpen)
            {
                sp.Close();

            }
         
            //设置 DataReceived 事件发生前内部输入缓冲区中的字节数为13
            sp.ReceivedBytesThreshold = 15;
          
          try
            {
                sp.Open();
            }
           catch (System.Exception ex)
           {
               MessageBox.Show("未能打开串口.\n" + ex.Message);
            }
          
      
        }
        /// <summary>
        /// datarecived方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void serialPortDatarecived(object sender,
                        SerialDataReceivedEventArgs e)
        {

           sp = (SerialPort)sender;
            sp.Read(receivedData, 0, 15);
            //可将鼠标放在函数上查看注释 GetString(Byte[], Int32, Int32) The index of the first byte to decode.
            //选择数据中有用的几位
            txt = Encoding.ASCII.GetString(receivedData, 7, 4);
            sp.DiscardInBuffer();
            
           
        }
       
        private void InitChart()
        {
            //定义图表区域
            this.chart1.ChartAreas.Clear();
            ChartArea chartArea1 = new ChartArea("C1");
            this.chart1.ChartAreas.Add(chartArea1);
            //定义存储和显示点的容器
            this.chart1.Series.Clear();
            Series series1 = new Series("S1");
            series1.ChartArea = "C1";
            this.chart1.Series.Add(series1);
            //设置图表显示样式
            this.chart1.ChartAreas[0].AxisX.Minimum = 0;
            this.chart1.ChartAreas[0].AxisX.Maximum = 150;
            this.chart1.ChartAreas[0].AxisY.Minimum = 0;
            this.chart1.ChartAreas[0].AxisY.Maximum =500;
            this.chart1.ChartAreas[0].AxisX.Interval = 10;
            this.chart1.ChartAreas[0].AxisX.MajorGrid.LineColor = System.Drawing.Color.Silver;
            this.chart1.ChartAreas[0].AxisY.MajorGrid.LineColor = System.Drawing.Color.Silver;
            //设置标题
            this.chart1.Titles.Clear();
            this.chart1.Titles.Add("S01");
            this.chart1.Titles[0].Text = "力曲线显示";
            this.chart1.Titles[0].ForeColor = Color.RoyalBlue;
            this.chart1.Titles[0].Font = new System.Drawing.Font("Microsoft Sans Serif", 12F);
            //设置图表显示样式
            this.chart1.Series[0].Color = Color.Red;
            this.chart1.Titles[0].Text = string.Format("力曲 {0} 显示", "线");
            this.chart1.Series[0].ChartType = SeriesChartType.Spline;
            this.chart1.Series[0].Points.Clear();
        }
        /// <summary>
        /// 更新数据
        /// </summary>
        private void upData(double d)
        {
            if (dataqueue.Count > 100)
            {

                for (int i = 0; i < num; i++)
                {

                    dataqueue.Dequeue();


                }
            }

            for (int i = 0; i < num; i++)
            {
                dataqueue.Enqueue(d);
            }
           

        }
        /// <summary>
        /// 找到最大值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void findMaxValue()
        {
    
                    this.Invoke(new EventHandler(delegate
                    {
                        cbFmaxValue.Text = Convert.ToString(dataqueue.Max ());

                    }));
        }
            
                
        

        private void btnStop_Click(object sender, EventArgs e)
        {
            this.timer1.Stop();
            calculateIFSS();
            saveToXls();
            // Display the list in an Excel spreadsheet.
            DisplayInExcel();

        }
        /// <summary>
        /// 定时器函数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void timer1_Tick(object sender, EventArgs e)
        {
            //定义全局变量txt 此处还需要更改如何使图表不更新这个初始值（参数传递）
            if (!(txt == null))
            {
                double dt = double.Parse(txt);
                upData(dt);
            }
           
            
            this.chart1.Series[0].Points.Clear();
            for (int i = 0; i < dataqueue.Count; i++)
            {
                this.chart1.Series[0].Points.AddXY((i + 1), dataqueue.ElementAt(i));
                findMaxValue();
            }
        }
        /// <summary>
        /// 计算强度
        /// </summary>
        private void calculateIFSS()
        {
            try
            {
                double vifss;
                double le = double.Parse(cbLenth.Text);//最好设置默认值或者消息弹出框
                double d = double.Parse(cbDiameter.Text);
                double fmax = double.Parse(cbFmaxValue.Text);

                vifss = fmax / (3.14 * d * le);

                this.Invoke(new EventHandler(delegate
                {
                    cbIfssValue.Text = Convert.ToString(vifss);

                }));
            }
            catch (Exception e)
            {
                MessageBox.Show("出问题了 你自己看着办");
            }
        }
        /// <summary>
        /// 保存数据至表格
        /// </summary>
        private string saveToXls()
        {
            String[] format ={"d","t" };
            CultureInfo cultures = CultureInfo.CreateSpecificCulture("de-DE");
            string y = DateTime.Now.ToString(format[0], cultures );
            string t = DateTime.Now.ToString(format[1], cultures);
           //string.Replace函数去掉影响字符串格式的符号（如“：”）
            textBox1.Text = y.Replace (".","") + t.Replace (":","") ;//设置文件名
            string s = y.Replace(".", "") + t.Replace(":", "");
            return s;
        }
 
        /// <summary>
        /// NPOI写数据到表格
        /// </summary>
        private void DisplayInExcel()
        {
            HSSFWorkbook workbook = new HSSFWorkbook();
            //创建工作表
            var sheet = workbook.CreateSheet();
            //创建标题行（重点）
            var row = sheet.CreateRow(0);
            //创建单元格
            
            var cellnum = row.CreateCell(0);
            cellnum.SetCellValue("序号");
            var celldata = row.CreateCell(1);
            celldata.SetCellValue("F/mN");
            var cellfmax = row.CreateCell(2);
            cellfmax.SetCellValue("Fmax/mN");
            var cellifss = row.CreateCell(4);
            cellifss.SetCellValue("IFSS/Mpa");
            //将力最大值与IFSS写入第二行
         
            var cellfmaxvalue = row.CreateCell(3);
            cellfmaxvalue.SetCellValue(cbFmaxValue .Text );
            var cellifssvalue = row.CreateCell(5);
            cellifssvalue.SetCellValue(cbIfssValue.Text);
            //将数据循环写入表格
            for (int i = 0; i < dataqueue.Count; i++)
            {
                var rowx = sheet.CreateRow(i + 1);
                var cellnumvalue = rowx.CreateCell(0);
                cellnumvalue.SetCellValue(i + 1);
                var celldatavalue = rowx.CreateCell(1);
                celldatavalue.SetCellValue(dataqueue.ElementAt(i));
            }
            string s = saveToXls();
            string path =@"C:\Users\admin\Desktop\"+ s+".xls";//文件格式不能带“：”号
            
            FileStream file = new FileStream(path, FileMode.CreateNew, FileAccess.Write);
            workbook.Write(file);
            file.Dispose();
        }
    }
}