using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Windows.Forms;

namespace DataCollectionSystem
{
 public   class ExcelHelper
    {
     public static void SaveDataTableToExcel2(double[] line1Datas, double[] line2Datas, DateTime beginTime, int fileNumber)
        {

          //  Environment.CurrentDirectory = MainForm.CurrentSystemDic;
            string fileName = Environment.CurrentDirectory + string.Format("\\excelExport\\{0}_{1}.xls", DateTime.Now.ToString("yyyy-MM-dd-HHmmss"), fileNumber);
            Stream myStream = File.Create(fileName);
            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
            string strHeaderText = "";
            try
            {
                //写标题

                strHeaderText += string.Format("             报表数据      ");
                sw.WriteLine(strHeaderText);
                strHeaderText += "编  号";
                strHeaderText += "\t";
                strHeaderText += "   记 录 时 间  ";
                strHeaderText += "\t";
                strHeaderText += "通道1";
                strHeaderText += "\t";
            
          


                sw.WriteLine(strHeaderText);
                //写内容
                string strItemValue = "";           
                for(int i=0;i<line1Datas.Length;i++)
                {
                    strItemValue = "";
                    strItemValue += i;
                    strItemValue += "\t";
                    strItemValue += beginTime;
                    strItemValue += "\t";
                    strItemValue += line1Datas[i];
                    strItemValue += "\t";                
                    sw.WriteLine(strItemValue); //把dgv的每一行的信息写为sw的每一行
                   

                }
                // MessageBox.Show("导出完成!");

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "软件提示");
                // throw ex;
            }
            finally
            {

                sw.Close();
                myStream.Close();
                System.Diagnostics.Process.Start(Environment.CurrentDirectory + "\\excelExport");
                // System.Diagnostics.Process.Start(fileName);

            }

        }

        static string LastExportFileName = string.Empty;
        public static void WriteCSV(double[] datas ,string FileName,ref int startRowNO)
        {
            try
            {
                if (startRowNO == 0)
                {
                    LastExportFileName = Environment.CurrentDirectory + string.Format("\\excelExport\\{0}.csv", DateTime.Now.ToString("yyyy-MM-dd-HHmmss"));
                }
                string strPath = Path.GetDirectoryName(LastExportFileName);
                if (!Directory.Exists(strPath))
                {
                    Directory.CreateDirectory(strPath);
                }
               // if (!File.Exists(LastExportFileName)) //当文件不存在时创建文件
                {
                    //创建文件流(创建文件)
                    FileStream fs = new FileStream(LastExportFileName, FileMode.OpenOrCreate, FileAccess.Write);
                    fs.Seek(0, SeekOrigin.End);
                    //创建流写入对象，并绑定文件流
                    StreamWriter sw = new StreamWriter(fs);
                    //实例化字符串流
                    string sb = string.Empty;
                    //将数据添加进字符串流中（如果数据标题有变更，修改此处）
                    
                    if (startRowNO == 0)
                    {
                        sb = string.Format("ID,PointValue,");
                        //将字符串流数据写入文件
                        sw.WriteLine(sb);
                        startRowNO++;
                    }
                    
                    for (int i = 0; i < datas.Length; i++)
                    {
                        sb = string.Empty; ;
                        sb = string.Format("{0},{1},", startRowNO, datas[i]);
                        startRowNO++;
                        sw.WriteLine(sb);

                    }
                    //刷新文件流
                    sw.Flush();
                    sw.Close();
                    fs.Close();
                }
            }
            catch (Exception et)
            {
                MessageBox.Show(et.Message, "软件提示" + et.Message);
            }
            finally
            {
                System.Diagnostics.Process.Start(Environment.CurrentDirectory + "\\excelExport");
            }
        } 

      /// <summary>
        /// Write CSV File
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="id"></param>
        /// <param name="data"></param>
     public  static void WriteCVS(double[] line1Datas, DateTime beginTime, int fileNumber)
     {
         try
         {
                string fileName = Environment.CurrentDirectory + string.Format("\\excelExport\\{0}_{1}.csv", DateTime.Now.ToString("yyyy-MM-dd-HHmmss"), fileNumber);
                string strPath = Path.GetDirectoryName(fileName);
                if (!Directory.Exists(strPath))
                {
                    Directory.CreateDirectory(strPath);
                }
                if (!File.Exists(fileName)) //当文件不存在时创建文件
                {
                    //创建文件流(创建文件)
                    FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write);
                    //创建流写入对象，并绑定文件流
                    StreamWriter sw = new StreamWriter(fs);
                    //实例化字符串流
                    string sb = string.Empty;
                    //将数据添加进字符串流中（如果数据标题有变更，修改此处）
                    sb = string.Format("ID,PointValue,");
                    //将字符串流数据写入文件
                    sw.WriteLine(sb);
                    for (int i = 0; i < fileNumber; i++)
                    {
                        sb = string.Empty; ;
                        sb = string.Format("{0},{1},", i + 1, line1Datas[i]);
                        sw.WriteLine(sb);

                    }
                    //刷新文件流
                    sw.Flush();
                    sw.Close();
                    fs.Close();
                }
            }
         catch(Exception et)
         {
             MessageBox.Show(et.Message, "软件提示" + et.Message);
         }
         finally
         {
             System.Diagnostics.Process.Start(Environment.CurrentDirectory + "\\excelExport");
         }
        }

    }
}