APL_TestCheck/Main.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.IO.Ports;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using Microsoft.WindowsAPICodePack.Dialogs;
using System.Threading;
using System.Data.OleDb;
using System.Collections;


//using Microsoft.Office.Interop.Excel;
namespace APL_TestCheck
{
    public partial class Main : Form
    {
        public string Serial_Name { get => serialPort.PortName; set => serialPort.PortName = value; }

        public Main()
        {
            InitializeComponent();
        }



        private void panel_PanelMode_MouseLeave(object sender, EventArgs e)
        {
            System.Windows.Forms.Panel Panel = (System.Windows.Forms.Panel)sender;
            Panel.BackColor = Color.FromArgb(0, 159, 200);
            label_GPSTest_MouseLeave(null, null);
        }

        private void panel_PanelMode_MouseMove(object sender, MouseEventArgs e)
        {
            System.Windows.Forms.Panel Panel = (System.Windows.Forms.Panel)sender;
            Panel.BackColor = Color.FromArgb(0, 159, 255);
        }



        private void label_GPSTest_MouseLeave(object sender, EventArgs e)
        {
            if (panel_GpsTest.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 255);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_Catm1Test.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 255);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_SensorTest.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 255);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_MergeMain.Visible == true)
            {
                panel_Merge.BackColor = Color.FromArgb(0, 159, 255);
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_SnCheckMain.Visible == true)
            {
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 255);
            }
        }




        private void label_SnCheck_MouseMove(object sender, MouseEventArgs e)
        {
            panel_SnCheck.BackColor = Color.FromArgb(0, 159, 255);
        }
        private void label_Merge_MouseMove(object sender, MouseEventArgs e)
        {
            panel_Merge.BackColor = Color.FromArgb(0, 159, 255);
        }
        private void label_Catm1Test_MouseMove(object sender, MouseEventArgs e)
        {
            panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 255);
        }

        private void label_SensorTest_MouseMove(object sender, MouseEventArgs e)
        {
            panel_SensorMode.BackColor = Color.FromArgb(0, 159, 255);
        }

        private void label_GPSTest_MouseMove(object sender, MouseEventArgs e)
        {
            panel_GpsMode.BackColor = Color.FromArgb(0, 159, 255);
        }
        public struct POINT { public int X, Y; }
        [DllImport("user32.dll")] // 현재 마우스 위치를 얻기위한 API함수.
        public extern static void GetCursorPos(out POINT point);

        System.Drawing.Point FormLocation; // 현재 폼 위치
        POINT LastLocation = new POINT(); // 방금 전의 마우스 위치
        POINT CurrentLocation = new POINT(); // 현재 마우스 위치
                                             // 폼이 움직일 양 = CurrentLocation - LastLocation.
        bool IsMouseMoveStart = false; // 현재 마우스 움직이기 기능이 켜져있는가.
                                       // 만약 이게 없으면 그냥 폼위에서
        private void panel_Main_MouseDown(object sender, MouseEventArgs e)
        {
            GetCursorPos(out CurrentLocation);
            FormLocation = this.Location;
            IsMouseMoveStart = true;
        }

        private void panel_Main_MouseMove(object sender, MouseEventArgs e)
        {
            if (!IsMouseMoveStart) return;

            GetCursorPos(out LastLocation);
            FormLocation.X -= (CurrentLocation.X - LastLocation.X);
            FormLocation.Y -= (CurrentLocation.Y - LastLocation.Y);
            this.Location = FormLocation;
            CurrentLocation = LastLocation;
        }

        private void panel_Main_MouseUp(object sender, MouseEventArgs e)
        {
            IsMouseMoveStart = false;
        }



        private void pictureBox_min_red_Click(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Minimized;
        }

        private void pictureBox_X_red_Click(object sender, EventArgs e)
        {
            //Application.Exit();
        }

        private void label_GPSTest_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = true;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = false;
        }

        private void label_Catm1Test_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = false;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = true;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = false;

        }

        private void label_SensorTest_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = false;
            panel_SensorTest.Visible = true;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = false;
        }

        private void Main_Load(object sender, EventArgs e)
        {
            Serial_Initialize(ref comboBox_Port);
            dataGridView_Gps.RowCount = 1;
            dataGridView_Catm1.RowCount = 1;
            dataGridView_Sensor.RowCount = 1;
            dataGridView_SnInsert.RowCount = 1;



            dataGridView_Gps.Rows[0].Cells[2].Value = "100";
            dataGridView_Gps.Rows[0].Cells[3].Value = "40";
            dataGridView_Gps.Rows[0].Cells[5].Value = "50";
            dataGridView_Gps.Rows[0].Cells[6].Value = "0";
            panel_GpsTest.Visible = true;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = false;

            pictureBox_Check1.Visible = false;
            pictureBox_Check2.Visible = false;
            pictureBox_Check3.Visible = false;
            pictureBox_Check4.Visible = false;
            button_Path_Click(null, null);
        }
        public void Serial_Initialize(ref ComboBox cb_port)
        {

            this.serialPort = new System.IO.Ports.SerialPort();
            this.serialPort.DataReceived += new System.IO.Ports.SerialDataReceivedEventHandler(this.sPort_DataReceived);

            cb_port.BeginUpdate();
            foreach (string comport in SerialPort.GetPortNames())//foreach (string comport in SerialPort_TestProgram.GetPortNames())
            {
                cb_port.Items.Add(comport);
            }
            cb_port.EndUpdate();
            //SerialPort 초기 설정.
            //  serialPort.Encoding = Encoding.GetEncoding("Windows-1252");
            cb_port.DataSource = SerialPort.GetPortNames();
            try
            {
                serialPort.PortName = Serial_Name = cb_port.SelectedItem.ToString();
                serialPort.BaudRate = (int)115200;
                serialPort.DataBits = (int)8;
                serialPort.Parity = System.IO.Ports.Parity.None;
                serialPort.StopBits = StopBits.One;
            }
            catch { }

        }
        private delegate void StringSend(string Text);
        private delegate void ByteSend(byte[] Text);

        string startStr = "V";
        string endStr = "\n";
        public void Serial_DataRecvFunction(object sender, SerialDataReceivedEventArgs e)
        {
            int TmpLength = 0;
            //System.Threading.Thread.Sleep(50);
            int nLnegth = serialPort.BytesToRead;
            byte[] btdata = new byte[nLnegth];

            serialPort.Read(btdata, 0, nLnegth);
            string data = Encoding.Default.GetString(btdata);
            if (checkBox_TerminalStop.Checked == true)
                return;
            // string data = serialPort.ReadExisting();
            if (panel_SensorTest.Visible == true)
            {

                if (data.Contains(startStr))
                {
                    data = data.Substring(data.IndexOf(startStr));
                    if (data.Contains(endStr))
                    {
                        this.Invoke(new StringSend(Data_Recv_Str), data);
                    }
                }
                else
                {
                    if (data.Contains("No need write SN"))
                    {
                        MessageBox.Show("이미 시리얼 넘버가 등록되어 있습니다.");
                    }
                    else
                    {
                        this.Invoke(new StringSend(Data_Recv_Str), data);
                    }
                }

            }
            else
            {
                this.Invoke(new StringSend(Data_Recv_Str), data);
            }
            /*try
            {
                this.Invoke(new ByteSend(Data_Recv_Str), btdata);
            }
            catch
            {

            }*/
            /****
             *메모리 누수 방지용 코드
             */
            System.GC.Collect(0, GCCollectionMode.Forced);
            System.GC.WaitForFullGCComplete();
        }
        int offset = 0;
        byte[] rxBuffer;
        private void sPort_DataReceived(object sender, SerialDataReceivedEventArgs e)
        {
            if (checkBox_TerminalStop.Checked == true)
                return;
            try
            {

                if (offset == 0)
                {
                    rxBuffer = new byte[4096];
                }

                string rxString = "";
                int intRecSize = serialPort.BytesToRead;

                if (intRecSize != 0)
                {




                    /* if (panel_GpsTest.Visible == true)
                     {
                         byte[] btdata = new byte[intRecSize];
                         serialPort.Read(btdata, 0, intRecSize);
                         string data = Encoding.Default.GetString(rxBuffer);

                         this.Invoke(new StringSend(Data_Recv_Str), data);
                     }
                     else*/
                    {
                        serialPort.Read(rxBuffer, offset, intRecSize);
                        offset += intRecSize;
                        for (int iTemp = 0; iTemp < offset; iTemp++)
                        {
                            rxString += Convert.ToChar(rxBuffer[iTemp]);
                        }
                        if (panel_SensorTest.Visible == true)
                        {
                            startStr = "V";
                            endStr = "\n";
                        }

                        else if (panel_Catm1Test.Visible == true)
                        {
                            startStr = "B";
                            endStr = "\n";
                        }
                        else if (panel_GpsTest.Visible == true)
                        {
                            startStr = "$";
                            endStr = "\n";
                        }
                        if (rxString.Contains(startStr))
                        {
                            rxString = rxString.Substring(rxString.IndexOf(startStr));
                            if (rxString.Contains(endStr))
                            {
                                this.Invoke(new StringSend(Data_Recv_Str), rxString);
                                //program.dataReceived(rxString, "Receive");
                                offset = 0;
                            }
                        }
                    }

                }
            }
            catch { }

        }

        private void label_Port_MouseClick(object sender, MouseEventArgs e)
        {

        }

        int LineLimit = 500;
        [DllImport("user32.dll")]
        public static extern int SendMessage(IntPtr hWnd, Int32 wMsg, bool wParam, Int32 lParam);
        private const int WM_SETREDRAW = 11;

        public void Data_Recv_Str(string text)
        {

            System.Windows.Forms.RichTextBox tbReceived = null;
            if (panel_GpsTest.Visible == true)
            {
                tbReceived = richTextBox_Gps;

            }
            else if (panel_Catm1Test.Visible == true)
            {
                tbReceived = richTextBox_catm1;
            }
            else if (panel_SensorTest.Visible == true)
            {
                tbReceived = richTextBox_Sensor;
            }

            int nLimitLines = Convert.ToInt32(LineLimit); //제한 라인 수
            try
            {
                try
                {
                    SendMessage(this.Handle, WM_SETREDRAW, false, 0);
                }
                catch (Exception e) { MessageBox.Show(e.StackTrace); }
                if (tbReceived.Lines.Length > nLimitLines)
                {
                    LinkedList<string> tempLines = new LinkedList<string>(tbReceived.Lines);
                    while ((tempLines.Count - nLimitLines) > 0)
                    {
                        tempLines.RemoveFirst();
                    }
                    tbReceived.Lines = tempLines.ToArray();
                }
                try
                {
                    SendMessage(this.Handle, WM_SETREDRAW, true, 0);
                }
                catch { return; }
                if (checkBox_GPGSV.Checked == true && panel_GpsTest.Visible == true)
                {
                    tbReceived.AppendText(GPS_TestFunc(text));
                }
                else if (panel_SensorTest.Visible == true)
                {

                    Sensor_TestFunc(text);
                    tbReceived.AppendText(text);
                }
                else if (panel_Catm1Test.Visible == true)
                {
                    Catm1_TestFunc(text);
                    tbReceived.AppendText(text);
                }
                else
                {
                    tbReceived.AppendText(text);
                }
                tbReceived.SelectionStart = tbReceived.Text.Length;//맨 마지막 선택... 
                tbReceived.ScrollToCaret();
            }
            catch { try { SendMessage(this.Handle, WM_SETREDRAW, true, 0); } catch { return; } }
        }
        public void Data_Recv_Str(byte[] text)
        {
            string strtext = Encoding.Default.GetString(text);

            System.Windows.Forms.RichTextBox tbReceived = null;
            if (panel_GpsTest.Visible == true)
            {
                tbReceived = richTextBox_Gps;

            }
            else if (panel_Catm1Test.Visible == true)
            {
                tbReceived = richTextBox_catm1;
            }
            else if (panel_SensorTest.Visible == true)
            {
                tbReceived = richTextBox_Sensor;
            }

            int nLimitLines = Convert.ToInt32(LineLimit); //제한 라인 수
            try
            {
                try
                {
                    SendMessage(this.Handle, WM_SETREDRAW, false, 0);
                }
                catch (Exception e) { MessageBox.Show(e.StackTrace); }
                if (tbReceived.Lines.Length > nLimitLines)
                {
                    LinkedList<string> tempLines = new LinkedList<string>(tbReceived.Lines);
                    while ((tempLines.Count - nLimitLines) > 0)
                    {
                        tempLines.RemoveFirst();
                    }
                    tbReceived.Lines = tempLines.ToArray();
                }
                try
                {
                    SendMessage(this.Handle, WM_SETREDRAW, true, 0);
                }
                catch { return; }
                if (checkBox_GPGSV.Checked == true && panel_GpsTest.Visible == true)
                {
                    tbReceived.AppendText(GPS_TestFunc(Encoding.Default.GetString(text)));
                }
                else if (panel_SensorTest.Visible == true)
                {
                    Sensor_TestFunc(strtext);
                    tbReceived.AppendText(strtext);
                }
                else
                {
                    tbReceived.AppendText(strtext);
                }
                tbReceived.SelectionStart = tbReceived.Text.Length;//맨 마지막 선택... 
                tbReceived.ScrollToCaret();
            }
            catch { try { SendMessage(this.Handle, WM_SETREDRAW, true, 0); } catch { return; } }
        }
        public int WordNum(String data, String fixdata)
        {
            MatchCollection matches = Regex.Matches(data, fixdata);
            return matches.Count;

        }
        double GPS_TestSnRValue = 0;
        int Gps_CurrentCount = 0;
        int TestVal = 0;
        int GPGGA_Cnt = 0,ColdCnt = 0;
        int ArrageGpsData = 0;
        double[] Gps_Arrange = new double[11];
        int gps_arrangecnt = 0;
        private string GPS_TestFunc(string data)
        {
            int Gps_Count, Sentence, SnrIndex = 3;
            //  string tmpstr = "$GPGSV,2,1,08,10,69,246,47,12,50,082,43,15,12,108,29,20,49,190,45*77\r\n";
            // string tmpstr1 = "$GPGSV,2,2,08,24,36,052,37,25,48,159,42,31,17,245,,32,46,312,45*74\r\n";
            string[] tmpstr = new String[3];
            string[] GPGGAstr = new String[3];
            string splitstr = null, str = data;
            string[] sp = str.Split(',');
            string[] GPGGA_sp = str.Split(',');
            int Losscount = 0;
            int location1, location2, LastLocation, SentenceCount;
            int GPGGA_Location,ColdTime = 0;
            bool SaveOk = false;
            try
            {
                /*
                if(TestVal == 0)
                {
                    str = tmpstr;
                    TestVal++;
                }
                else
                {
                    str = tmpstr1;
                    TestVal = 0;
                }
                */
                GPGGA_Location = str.IndexOf("$GPGGA");
                //  SentenceCount = WordNum(str, "GPGGA");
                //ColdTime = Convert.ToInt32(dataGridView_Sensor.Rows[0].Cells[4].Value);
                if (GPGGA_Location != -1)
                {
                    str = str.Substring(GPGGA_Location);
                    location2 = str.IndexOf("\r\n");
                    splitstr = str.Substring(location2 + 2);
                    GPGGAstr[0] = str.Substring(0, location2 + 2);
                    GPGGA_sp = GPGGAstr[0].Split(',');
                    if (GPGGA_sp[2] != "")
                    {
                        GPGGA_Cnt++;

                        if (GPGGA_Cnt >= 5)
                        {
                            if (GPGGA_Cnt >= 15)
                            {
                                SaveOk = true;
                            }
                        }
                       // dataGridView_Gps.Rows[0].Cells[3].Value = GPGGA_sp[2];
                        
                    }
                    else
                    {
                        ColdCnt++;
                        dataGridView_Gps.Rows[0].Cells[4].Value = ColdCnt.ToString();
                        return "";
                    }

                }
                location1 = str.IndexOf("$GPGSV");
                SentenceCount = WordNum(str, "GPGSV");
                GPS_TestSnRValue = 0;
                Gps_CurrentCount = 0;
                if (location1 != -1)
                {
                    if (gps_arrangecnt < 10)
                    {
                        for (int ii = 0; ii < SentenceCount; ii++)
                        {
                            SnrIndex = 3;
                            if (ii != 0)
                                str = splitstr;
                            location1 = str.IndexOf("$GPGSV");
                            str = str.Substring(location1);
                            location2 = str.IndexOf("\r\n");
                            splitstr = str.Substring(location2 + 2);
                            tmpstr[ii] = str = str.Substring(0, location2 + 2);

                            sp = str.Split(',');
                            if (sp[3].Contains("*"))
                            {
                                sp[3] = sp[3].Substring(0, 2);
                                //   dataGridView_Gps.Rows[0].Cells[1].Value = sp[3];
                                Gps_Arrange[gps_arrangecnt++] = Convert.ToDouble(sp[3]);
                                return str;
                            }
                            else
                            {
                                Sentence = Convert.ToInt32(sp[2]);
                                Gps_Count = Convert.ToInt32(sp[3]);
                                for (int i = 0; i < 4; i++)
                                {
                                    SnrIndex += 4;
                                    if (sp[SnrIndex].Contains("*"))
                                    {
                                        LastLocation = sp[SnrIndex].IndexOf("*") - 2;
                                        sp[SnrIndex] = sp[SnrIndex].Substring(0, 2);
                                        GPS_TestSnRValue += Convert.ToInt32(sp[SnrIndex]);
                                    }
                                    else
                                    {
                                        if (sp[SnrIndex] == "")
                                        {
                                            sp[SnrIndex] = "0";
                                            Losscount++;
                                        }
                                        GPS_TestSnRValue += Convert.ToInt32(sp[SnrIndex]);
                                    }
                                    Gps_CurrentCount++;
                                    if (Gps_CurrentCount == Gps_Count)
                                    {
                                        GPS_TestSnRValue /= (Gps_Count - Losscount);
                                        GPS_TestSnRValue = Math.Round(GPS_TestSnRValue, 1);
                                        // dataGridView_Gps.Rows[0].Cells[1].Value = GPS_TestSnRValue.ToString();
                                        Gps_Arrange[gps_arrangecnt++] = Convert.ToDouble(GPS_TestSnRValue);
                                        break;
                                    }
                                }
                            }

                        }
                    }
                    if(gps_arrangecnt == 10 && dataGridView_Gps.Rows[0].Cells[1].Value == null)
                    {
                        for (int retcnt = 0; retcnt < 10; retcnt++)
                        {
                            Gps_Arrange[10] += Gps_Arrange[retcnt];
                            Gps_Arrange[retcnt] = 0;
                        }
                        Gps_Arrange[10] = Gps_Arrange[10] / 10;
                        dataGridView_Gps.Rows[0].Cells[1].Value = Gps_Arrange[10].ToString();
                    }
                    str = null;
                    for (int a = 0; a < SentenceCount; a++)
                        str += tmpstr[a];

                    if (dataGridView_Sensor.Rows[0].Cells[0].Value != null && SaveOk == true)
                    {
                        int SnrMinref = Convert.ToInt32(dataGridView_Gps.Rows[0].Cells[3].Value);
                        int SnrValue = Convert.ToInt32(dataGridView_Gps.Rows[0].Cells[1].Value);
                        if (SnrMinref > SnrValue)
                        {
                            MessageBox.Show("APL 부적합 Device 입니다.");
                            return "";
                        }
                        button_GpsTestSave_Click(null, null);
                        gps_arrangecnt = 0;
                        ColdCnt = 0;
                        SaveOk = false;
                    }

                    return str;
                }
                return "";
            }
            catch (Exception e) { /*MessageBox.Show(e.StackTrace); */}
            return "";
        }
        string SensorData = null;
        private void Sensor_TestFunc(string data)
        {
            string str = data;
            string[] sp = new string[11];
            try
            {
                if (data.Contains("\r\n") == false)
                {
                    return;
                }
                else
                {
                    SensorData += data;
                    str = SensorData;
                }

                //if (dataGridView_Sensor.Rows[0].Cells[0].Value != null)
                {
                    //location1 = str.IndexOf("\r\n");
                    //str = str.Substring(0, location1);
                    sp = str.Split(',');
                    if (sp[0].Contains("V") == false/* || sp.Length != 11*/)
                    {
                        SensorData = null;
                        return;
                    }

                    dataGridView_Sensor.Rows[0].Cells[5].Value = sp[0]; //version
                    dataGridView_Sensor.Rows[0].Cells[2].Value = "8627850" + sp[2]; //,IMEI
                    dataGridView_Sensor.Rows[0].Cells[3].Value = sp[3];//, Phone Number, 
                    dataGridView_Sensor.Rows[0].Cells[4].Value = sp[4];//USIM Number
                    dataGridView_Sensor.Rows[0].Cells[6].Value = sp[5];//, Battery Voltage,
                    dataGridView_Sensor.Rows[0].Cells[7].Value = sp[6];// System Voltage, 
                    dataGridView_Sensor.Rows[0].Cells[8].Value = sp[7];//Temp, BMA400 값 출력 x, y, z
                    dataGridView_Sensor.Rows[0].Cells[9].Value = sp[8];//Temp, BMA400 값 출력 x, y, z
                    dataGridView_Sensor.Rows[0].Cells[10].Value = sp[9];//Temp, BMA400 값 출력 x, y, z
                    if (sp[10].Contains("\r"))
                    {
                        int loc = sp[10].IndexOf("\r");
                        sp[10] = sp[10].Substring(0, loc);
                    }
                    dataGridView_Sensor.Rows[0].Cells[11].Value = sp[10];//Temp, BMA400 값 출력 x, y, z
                    SensorData = null;
                    string value = "";
                    /*if (checkBox_Edit.Checked == false)
                    {
                        if (InputBox("번호 입력", "일련 번호:", ref value) == DialogResult.OK)
                        {
                            // SN
                            dataGridView_Sensor.Rows[0].Cells[1].Value  = Name = value;
                            serialPort.Write("APLSN Write:" + value + "\r\n");
                            button_SensorTestSave();
                            for (int i = 0; i < 12; i++)
                                dataGridView_Sensor.Rows[0].Cells[i].Value = null;

                        }
                    }*/
                    if (dataGridView_Sensor.Rows[0].Cells[0].Value != null)
                    {
                        if (dataGridView_Sensor.Rows[0].Cells[1].Value != null)
                        {
                            //dataGridView_Sensor.Rows[0].Cells[1].Value = Name = value;
                            if (dataGridView_Sensor.Rows[0].Cells[1].Value.ToString().Length == 7)
                                serialPort.Write("APLSN Write:" + dataGridView_Sensor.Rows[0].Cells[1].Value.ToString() + "\r\n");
                            else
                                MessageBox.Show("SKT SN이 틀립니다.");
                        }
                        // button_SensorTestSave();

                    }
                    dataGridView_Sensor.Refresh();

                }
                return;
            }
            catch (Exception ex) { /*MessageBox.Show(ex.StackTrace); */ }
        }
        string Catm1Data = null;
        private void Catm1_TestFunc(string data)
        {
            string str = data;
            string[] sp = new string[4];
            try
            {
                if (data.Contains("\r\n") == false)
                {
                    return;
                }
                else
                {
                    Catm1Data += data;
                    str = Catm1Data;
                }

                //if (dataGridView_Catm1.Rows[0].Cells[0].Value != null)
                {
                    //location1 = str.IndexOf("\r\n");
                    //str = str.Substring(0, location1);
                    sp = str.Split(',');
                    if (sp[0].Contains("B") == false/* || sp.Length != 11*/)
                    {
                        Catm1Data = null;
                        return;
                    }

                    dataGridView_Catm1.Rows[0].Cells[1].Value = sp[0]; //Modem Ver
                    dataGridView_Catm1.Rows[0].Cells[2].Value = sp[1];//RSRP


                    if (sp[2].Contains("\r"))
                    {
                        int loc = sp[2].IndexOf("\r");
                        sp[2] = sp[2].Substring(0, loc);
                    }
                    dataGridView_Catm1.Rows[0].Cells[3].Value = sp[2];//RSRQ
                    Catm1Data = null;
                    dataGridView_Catm1.Refresh();

                }
                return;
            }
            catch (Exception ex) { /*MessageBox.Show(ex.StackTrace); */ }
        }
        private void label_Port_MouseLeave(object sender, EventArgs e)
        {
            panel_Port.BackColor = Color.FromArgb(0, 159, 200);
        }

        private void label_Port_MouseMove(object sender, MouseEventArgs e)
        {
            panel_Port.BackColor = Color.FromArgb(0, 159, 255);
        }

        private void label_Port_Click(object sender, EventArgs e)
        {
            //  Boolean ret = false;
            try
            {
                if (serialPort.IsOpen) // 이미 포트가 열려 있을 때 
                { //When the port is open
                    serialPort.Close();
                    label_Port.Text = "Port Open";
                    //ret = true;
                }
                else//When the port is close //포트가 열려 있지 않을 때 
                {
                    if (comboBox_Port.Text != "")
                    {
                        serialPort.PortName = Serial_Name = comboBox_Port.SelectedItem.ToString();
                        serialPort.BaudRate = Convert.ToInt32(comboBox_bps.Text);
                        serialPort.Open();
                        label_Port.Text = "Port Close";
                        //   Debug.Debug_Main_Form_Get(this.main_form);
                    }
                    else
                    {
                        MessageBox.Show("Port is not set");
                        //  ret = true;
                    }
                }
            }
            catch
            {
                MessageBox.Show("Port Open Faile" + Serial_Name);

            }
            // return ret;
        }

        public static DialogResult InputBox(string title, string promptText, ref string value)
        {
            Form form = new Form();
            System.Windows.Forms.Label label = new System.Windows.Forms.Label();
            System.Windows.Forms.TextBox textBox = new System.Windows.Forms.TextBox();
            System.Windows.Forms.Button buttonOk = new System.Windows.Forms.Button();
            System.Windows.Forms.Button buttonCancel = new System.Windows.Forms.Button();

            form.Text = title;
            label.Text = promptText;
            textBox.Text = value;

            buttonOk.Text = "OK";
            buttonCancel.Text = "Cancel";
            buttonOk.DialogResult = DialogResult.OK;
            buttonCancel.DialogResult = DialogResult.Cancel;

            label.SetBounds(9, 20, 372, 13);
            textBox.SetBounds(12, 36, 372, 20);
            buttonOk.SetBounds(228, 72, 75, 23);
            buttonCancel.SetBounds(309, 72, 75, 23);

            label.AutoSize = true;
            textBox.Anchor = textBox.Anchor | AnchorStyles.Right;
            buttonOk.Anchor = AnchorStyles.Bottom | AnchorStyles.Right;
            buttonCancel.Anchor = AnchorStyles.Bottom | AnchorStyles.Right;

            form.ClientSize = new Size(396, 107);
            form.Controls.AddRange(new Control[] { label, textBox, buttonOk, buttonCancel });
            form.ClientSize = new Size(Math.Max(300, label.Right + 10), form.ClientSize.Height);
            form.FormBorderStyle = FormBorderStyle.FixedDialog;
            form.StartPosition = FormStartPosition.CenterScreen;
            form.MinimizeBox = false;
            form.MaximizeBox = false;
            form.AcceptButton = buttonOk;
            form.CancelButton = buttonCancel;

            DialogResult dialogResult = form.ShowDialog();
            value = textBox.Text;
            return dialogResult;
        }



        private void button_Clear_Click(object sender, EventArgs e)
        {
            System.Windows.Forms.RichTextBox tbReceived = null;
            if (panel_GpsTest.Visible == true)
            {
                tbReceived = richTextBox_Gps;
            }
            else if (panel_Catm1Test.Visible == true)
            {
                tbReceived = richTextBox_catm1;
            }
            else if (panel_SensorTest.Visible == true)
            {
                tbReceived = richTextBox_Sensor;
            }
            tbReceived.Text = "";
        }
        string FileSaveSet = null;


        void Gps_ThreadRun(string dst, object Value1, object Value2)
        {
            //DST    : 위치
            //Value1 : 생산 번호
            //Value2 : SNR
            Thread Gps_thread = new Thread(delegate ()
            {
                Gps_DataxlsWrite(dst, Value1, Value2);
            });
            Gps_thread.Start();
        }

        void Catm1_ThreadRun(object dst, object Product, object Modemver, object Rsrp, object Rsrq)
        {
            //DST    : 위치
            //Value1 : 생산 번호
            //Value2 : Modem Ver
            //Value3 : RSRP
            //Value4 : RSRQ
            Thread Catm1_thread = new Thread(delegate ()
            {
                Catm1_DataxlsWrite(dst, Product, Modemver, Rsrp, Rsrq);
            });
            Catm1_thread.Start();

        }
        void Sensor_ThreadRun(object[] data)
        {
            //DST    : 위치
            //Value1 : 생산 번호
            //Value2 : Modem Ver
            //Value3 : RSRP
            //Value4 : RSRQ
            Thread Catm1_thread = new Thread(delegate ()
            {
                Sensor_DataxlsWrite(data);
            });
            Catm1_thread.Start();

        }
        void Sninsert_ThreadRun(object[] data)
        {
            //DST    : 위치
            //Value1 : 생산 번호
            //Value2 : SKT NUM
            //Value3 : IMEI
            Thread Sninsert_thread = new Thread(delegate ()
            {
                Sninsert_DataxlsWrite(data);
            });
            Sninsert_thread.Start();
        }


        //Thread rTh_Gps;
        private void button_GpsTestSave_Click(object sender, EventArgs e)
        {
            //rTh_Gps = new Thread(new ParameterizedThreadStart(Gps_DataxlsWrite));

            //Thread.Sleep(1000);
            AutoClosingMessageBox.Show("저장 중.....", "알림", 1000);
            string CheckProductionNum = null;
            try
            {
                CheckProductionNum = dataGridView_Gps.Rows[0].Cells[0].Value.ToString();
            }
            catch
            {

            }
            try
            {
                if (!CheckProductionNum.Contains("BL-VITE00-V"))
                {
                    MessageBox.Show("잘못된 생산 번호 입니다.");
                    return;
                }
            }
            catch
            {
                MessageBox.Show("생산번호를 적어주세요.");
            }
            string Ref_Xls_File = new System.IO.DirectoryInfo(System.Windows.Forms.Application.StartupPath).ToString();
            string Dst_Xls_File = null;
            Ref_Xls_File = Ref_Xls_File + @"\APL_200305.xls";
            FileInfo SrcfileInfo = new FileInfo(Ref_Xls_File);
            FileInfo DstfileInfo;

            if (dataGridView_Gps.Rows[0].Cells[0].Value != null
                && dataGridView_Gps.Rows[0].Cells[1].Value != null)
            {
                if (SrcfileInfo.Exists)
                {
                    if (FileSaveSet == null)
                    {
                        button_Path_Click(null, null);
                        return;
                        //                        MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    }
                    else
                    {
                        // File Copy 후 Data 입력 
                        Dst_Xls_File = FileSaveSet + @"\" + dataGridView_Gps.Rows[0].Cells[0].Value.ToString() + @".xls";
                        DstfileInfo = new FileInfo(Dst_Xls_File);
                        if (DstfileInfo.Exists)
                        {
                            if (MessageBox.Show("이미 파일이 있습니다.\r\n 덮어씌우겠습니까?", "YesOrNo", MessageBoxButtons.YesNo) == DialogResult.Yes)
                            {
                                try
                                {
                                    //   File.Copy(Ref_Xls_File, Dst_Xls_File, true);
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.StackTrace);
                                    return;
                                }
                            }
                            else
                            {
                                //MessageBox.Show("아니요 클릭");
                                return; // 아니오시 Return;
                            }
                        }
                        else
                        {
                            File.Copy(Ref_Xls_File, Dst_Xls_File);
                            Thread.Sleep(2000);
                        }
                    }
                }
                else
                {
                    MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    return;
                }
            }
            else
            {
                MessageBox.Show("생산번호/GPS SNR 값이 제대로 입력 되지 않았습니다.\r\n확인후 다시 저장하세요.");
                return;
            }
            // rTh_Gps.Start();
            //Gps_DataxlsWrite(Dst_Xls_File, dataGridView_Gps.Rows[0].Cells[0].Value, dataGridView_Gps.Rows[0].Cells[1].Value);
            Gps_ThreadRun(Dst_Xls_File, dataGridView_Gps.Rows[0].Cells[0].Value, dataGridView_Gps.Rows[0].Cells[1].Value);
            dataGridView_Gps.Rows[0].Cells[0].Value = null;
            dataGridView_Gps.Rows[0].Cells[1].Value = null;
            dataGridView_Gps.Rows[0].Cells[4].Value = null;
            dataGridView_Gps.Refresh();
            //   if (!di.Exists) { di.Create(); }
            //string tmppath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
#if false
            if (dataGridView_Gps.Rows[0].Cells[1].Value != null)
            {
                string path = @"xxxx.txt";
                FileInfo file = new FileInfo(path);
                if (file.Exists)
                { //파일이 있는지
                  //복사(경로,덮어쓰기 옵션 기본값 false)
                  //만약 덮어쓰기 false일 때 파일이 존재하면 에러남.
                    file.CopyTo(@"xxx2.txt", true);
                }
            }
#endif

            //this.Close();
            //MessageBox.
        }
        private void button_SensorTestSave()
        {
            string CheckProductionNum = null;
            object[] data = new object[13];// 0 :파일위치
            AutoClosingMessageBox.Show("저장 중.....", "알림", 1000);

            try
            {
                CheckProductionNum = dataGridView_Sensor.Rows[0].Cells[0].Value.ToString();
            }
            catch
            {

            }
            try
            {
                if (!CheckProductionNum.Contains("BL-VITE00-V"))
                {
                    MessageBox.Show("잘못된 생산 번호 입니다.");
                    return;
                }
            }
            catch
            {
                MessageBox.Show("생산번호를 적어주세요.");
            }
            string Ref_Xls_File = new System.IO.DirectoryInfo(System.Windows.Forms.Application.StartupPath).ToString();
            string Dst_Xls_File = null;
            Ref_Xls_File = Ref_Xls_File + @"\APL_200305.xls";
            FileInfo SrcfileInfo = new FileInfo(Ref_Xls_File);
            FileInfo DstfileInfo;

            if (dataGridView_Sensor.Rows[0].Cells[0].Value != null)
            {
                if (SrcfileInfo.Exists)
                {
                    if (FileSaveSet == null)
                    {
                        button_Path_Click(null, null);
                        return;
                        //                        MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    }
                    else
                    {
                        // File Copy 후 Data 입력 
                        Dst_Xls_File = FileSaveSet + @"\" + dataGridView_Sensor.Rows[0].Cells[0].Value.ToString() + @".xls";
                        DstfileInfo = new FileInfo(Dst_Xls_File);
                        if (DstfileInfo.Exists)
                        {
                            if (MessageBox.Show("이미 파일이 있습니다.\r\n 덮어씌우겠습니까?", "YesOrNo", MessageBoxButtons.YesNo) == DialogResult.Yes)
                            {
                                try
                                {
                                    //  File.Copy(Ref_Xls_File, Dst_Xls_File, true);
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.StackTrace);
                                    return;
                                }
                            }
                            else
                            {
                                //MessageBox.Show("아니요 클릭");
                                return; // 아니오시 Return;
                            }
                        }
                        else
                        {
                            File.Copy(Ref_Xls_File, Dst_Xls_File);
                            Thread.Sleep(2000);
                        }
                    }
                }
                else
                {
                    MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    return;
                }
            }
            else
            {
                MessageBox.Show("생산번호 값이 제대로 입력 되지 않았습니다.\r\n확인후 다시 저장하세요.");
                return;
            }
            //
            data[0] = Dst_Xls_File;
            for (int i = 0; i < 12; i++)
                data[i + 1] = dataGridView_Sensor.Rows[0].Cells[i].Value;

            //Sensor_DataxlsWrite();
            Sensor_ThreadRun(data);
            AutoClosingMessageBox.Show("완료 되었습니다.", "알림", 1000);


            for (int i = 0; i < 12; i++)
                dataGridView_Sensor.Rows[0].Cells[i].Value = null;

            dataGridView_Sensor.Refresh();
            //  dataGridView_Sensor.Rows[0].Cells[0].Value = null;
            // dataGridView_Sensor.Rows[0].Cells[1].Value = null;

            //   if (!di.Exists) { di.Create(); }
            //string tmppath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
#if false
            if (dataGridView_Gps.Rows[0].Cells[1].Value != null)
            {
                string path = @"xxxx.txt";
                FileInfo file = new FileInfo(path);
                if (file.Exists)
                { //파일이 있는지
                  //복사(경로,덮어쓰기 옵션 기본값 false)
                  //만약 덮어쓰기 false일 때 파일이 존재하면 에러남.
                    file.CopyTo(@"xxx2.txt", true);
                }
            }
#endif
        }
        private void button_Catm1TestSave()
        {
            string CheckProductionNum = null;
            AutoClosingMessageBox.Show("저장 중.....", "알림", 1000);
            try
            {
                CheckProductionNum = dataGridView_Catm1.Rows[0].Cells[0].Value.ToString();
            }
            catch
            {

            }
            try
            {
                if (!CheckProductionNum.Contains("BL-VITE00-V"))
                {
                    MessageBox.Show("잘못된 생산 번호 입니다.");
                    return;
                }
            }
            catch
            {
                MessageBox.Show("생산번호를 적어주세요.");
            }
            string Ref_Xls_File = new System.IO.DirectoryInfo(System.Windows.Forms.Application.StartupPath).ToString();
            string Dst_Xls_File = null;
            Ref_Xls_File = Ref_Xls_File + @"\APL_200305.xls";
            FileInfo SrcfileInfo = new FileInfo(Ref_Xls_File);
            FileInfo DstfileInfo;

            if (dataGridView_Catm1.Rows[0].Cells[0].Value != null)
            {
                if (SrcfileInfo.Exists)
                {
                    if (FileSaveSet == null)
                    {
                        button_Path_Click(null, null);
                        return;
                        //                        MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    }
                    else
                    {
                        // File Copy 후 Data 입력 
                        Dst_Xls_File = FileSaveSet + @"\" + dataGridView_Catm1.Rows[0].Cells[0].Value.ToString() + @".xls";
                        DstfileInfo = new FileInfo(Dst_Xls_File);
                        if (DstfileInfo.Exists)
                        {
                            if (MessageBox.Show("이미 파일이 있습니다.\r\n 덮어씌우겠습니까?", "YesOrNo", MessageBoxButtons.YesNo) == DialogResult.Yes)
                            {
                                try
                                {
                                    //  File.Copy(Ref_Xls_File, Dst_Xls_File, true);
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.StackTrace);
                                    return;
                                }
                            }
                            else
                            {
                                //MessageBox.Show("아니요 클릭");
                                return; // 아니오시 Return;
                            }
                        }
                        else
                        {
                            File.Copy(Ref_Xls_File, Dst_Xls_File);
                            Thread.Sleep(2000);
                        }
                    }
                }
                else
                {
                    MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    return;
                }
            }
            else
            {
                MessageBox.Show("생산번호 값이 제대로 입력 되지 않았습니다.\r\n확인후 다시 저장하세요.");
                return;
            }
            Catm1_ThreadRun(Dst_Xls_File, dataGridView_Catm1.Rows[0].Cells[0].Value, dataGridView_Catm1.Rows[0].Cells[1].Value, dataGridView_Catm1.Rows[0].Cells[2].Value, dataGridView_Catm1.Rows[0].Cells[3].Value);
            for (int i = 0; i < 4; i++)
                dataGridView_Catm1.Rows[0].Cells[i].Value = null;

            dataGridView_Catm1.Refresh();

            AutoClosingMessageBox.Show("완료 되었습니다.", "알림", 1000);
            //Catm1_DataxlsWrite(Dst_Xls_File, dataGridView_Catm1.Rows[0].Cells[0].Value, dataGridView_Catm1.Rows[0].Cells[1].Value, dataGridView_Catm1.Rows[0].Cells[2].Value, dataGridView_Catm1.Rows[0].Cells[3].Value);
            //  dataGridView_Catm1.Rows[0].Cells[0].Value = null;
            // dataGridView_Catm1.Rows[0].Cells[1].Value = null;

            //   if (!di.Exists) { di.Create(); }
            //string tmppath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
#if false
            if (dataGridView_Gps.Rows[0].Cells[1].Value != null)
            {
                string path = @"xxxx.txt";
                FileInfo file = new FileInfo(path);
                if (file.Exists)
                { //파일이 있는지
                  //복사(경로,덮어쓰기 옵션 기본값 false)
                  //만약 덮어쓰기 false일 때 파일이 존재하면 에러남.
                    file.CopyTo(@"xxx2.txt", true);
                }
            }
#endif
        }
		private void button_SninsertTestSave()
        {
            string CheckProductionNum = null;
            object[] data = new object[4];// 0 :파일위치
            AutoClosingMessageBox.Show("저장 중.....", "알림", 1000);

            try
            {
                CheckProductionNum = dataGridView_SnInsert.Rows[0].Cells[0].Value.ToString();
            }
            catch
            {

            }
            try
            {
                if (!CheckProductionNum.Contains("BL-VITE00-V"))
                {
                    MessageBox.Show("잘못된 생산 번호 입니다.");
                    return;
                }
            }
            catch
            {
                MessageBox.Show("생산번호를 적어주세요.");
            }
            string Ref_Xls_File = new System.IO.DirectoryInfo(System.Windows.Forms.Application.StartupPath).ToString();
            string Dst_Xls_File = null;
            Ref_Xls_File = Ref_Xls_File + @"\APL_200305.xls";
            FileInfo SrcfileInfo = new FileInfo(Ref_Xls_File);
            FileInfo DstfileInfo;

            if (dataGridView_SnInsert.Rows[0].Cells[0].Value != null)
            {
                if (SrcfileInfo.Exists)
                {
                    if (FileSaveSet == null)
                    {
                        button_Path_Click(null, null);
                        return;
                        //                        MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    }
                    else
                    {
                        // File Copy 후 Data 입력 
                        Dst_Xls_File = FileSaveSet + @"\" + dataGridView_SnInsert.Rows[0].Cells[0].Value.ToString() + @".xls";
                        DstfileInfo = new FileInfo(Dst_Xls_File);
                        if (DstfileInfo.Exists)
                        {
                            if (MessageBox.Show("이미 파일이 있습니다.\r\n 덮어씌우겠습니까?", "YesOrNo", MessageBoxButtons.YesNo) == DialogResult.Yes)
                            {
                                try
                                {
                                    //  File.Copy(Ref_Xls_File, Dst_Xls_File, true);
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.StackTrace);
                                    return;
                                }
                            }
                            else
                            {
                                //MessageBox.Show("아니요 클릭");
                                return; // 아니오시 Return;
                            }
                        }
                        else
                        {
                            File.Copy(Ref_Xls_File, Dst_Xls_File);
                            Thread.Sleep(2000);
                        }
                    }
                }
                else
                {
                    MessageBox.Show("레퍼런스 엑셀 파일이 존재하지 않습니다. \r\n강차장님에게 문의 하세요.");
                    return;
                }
            }
            else
            {
                MessageBox.Show("생산번호 값이 제대로 입력 되지 않았습니다.\r\n확인후 다시 저장하세요.");
                return;
            }
            //
            data[0] = Dst_Xls_File;
            for (int i = 0; i < 3; i++)
                data[i + 1] = dataGridView_SnInsert.Rows[0].Cells[i].Value;

            //Sensor_DataxlsWrite();
            Sninsert_ThreadRun(data);
            AutoClosingMessageBox.Show("완료 되었습니다.", "알림", 1000);


            for (int i = 0; i < 3; i++)
                dataGridView_SnInsert.Rows[0].Cells[i].Value = null;

            dataGridView_SnInsert.Refresh();
            //  dataGridView_Sensor.Rows[0].Cells[0].Value = null;
            // dataGridView_Sensor.Rows[0].Cells[1].Value = null;

            //   if (!di.Exists) { di.Create(); }
            //string tmppath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
#if false
            if (dataGridView_Gps.Rows[0].Cells[1].Value != null)
            {
                string path = @"xxxx.txt";
                FileInfo file = new FileInfo(path);
                if (file.Exists)
                { //파일이 있는지
                  //복사(경로,덮어쓰기 옵션 기본값 false)
                  //만약 덮어쓰기 false일 때 파일이 존재하면 에러남.
                    file.CopyTo(@"xxx2.txt", true);
                }
            }
#endif
        }
        private void ExcelKill()
        {
            System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("EXCEL");
            foreach (System.Diagnostics.Process p in process)
            {
                if (!string.IsNullOrEmpty(p.ProcessName))
                {
                    try
                    {
                        p.Kill();
                    }
                    catch { }
                }
            }
        }
        Excel.Application ExcelApp = null;
        Excel.Workbook wb = null;
        Excel.Worksheet ws = null;
        private void Gps_DataxlsWrite(object dst, object Value1, object Value2)
        {



            /*  #region // 프로세스 얻기 
              System.Diagnostics.Process[] BeforeExcelProcess;
              BeforeExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");
              ArrayList arlProcessID = new ArrayList();
              for (int i = 0; i < BeforeExcelProcess.Length; i++)
              {
                  arlProcessID.Add(BeforeExcelProcess[i].Id);
              }
              #endregion
              */
            ExcelKill();
            //Write

            //파일이 존재 한다면..삭제 하고..
            /*if (File.Exists("C:\\Test.xls"))
            {
                File.Delete("C:\\Test.xls");
            }*/
            try
            {
                ExcelApp = new Excel.Application();
                Thread.Sleep(1);
                try
                {
                    wb = ExcelApp.Workbooks.Open(dst.ToString(), 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                       Missing.Value, true, false, Missing.Value, false, false, false);
                }
                catch { ExcelKill(); return; }
                Thread.Sleep(1);
                ws = wb.Worksheets["Sheet1"] as Excel.Worksheet;
                Thread.Sleep(1);
                /*ExcelApp = new Excel.Application();
                wb = ExcelApp.Workbooks.Open(dst.ToString(), 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                   Missing.Value, true, false, Missing.Value, false, false, false);
                wb = ExcelApp.Workbooks.Open(dst.ToString());*/


                ws = wb.Worksheets["Sheet1"] as Excel.Worksheet;

                //엑셀 시트 인덱스 번호는 0,0 부터 시작 하는 것이 아니라 1,1 A1 부터 시작 함. 0,0 으로 시작하면 오류...
                //시트에 값 쓰기...
                ws.Cells[8, 9] = Value1.ToString();//dataGridView_Gps.Rows[0].Cells[0].Value;
                ws.Cells[8, 11] = Value2.ToString();//dataGridView_Gps.Rows[0].Cells[1].Value;
                                                    /*ws.Cells[1, 3] = "123";
                                                    ws.Cells[1, 4] = "1234";
                                                    ws.Cells[2, 1] = "Test1"; //A2
                                                    ws.Cells[3, 1] = "Test12"; //A3
                                                    ws.Cells[4, 1] = "Test123"; //A4*/


                //다른 이름으로 저장하기...
                wb.Save(); // => 오픈한 파일 그대로 저장...
                           /* wb.SaveAs("C:\\Test.xls",
                                      Excel.XlFileFormat.xlWorkbookNormal,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Excel.XlSaveAsAccessMode.xlNoChange,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing);
                                      */
                           //파일 닫기... 
                wb.Close(false, Type.Missing, Type.Missing);
                // wb = null;
                ExcelApp.Quit();
            }
            catch (Exception ex)
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
            finally
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                //ExcelApp = null;
                GC.Collect();
            }
        }
        private void Sensor_DataxlsWrite(object[] data)
        {

            ExcelKill();
            /* #region // 프로세스 얻기 
             System.Diagnostics.Process[] BeforeExcelProcess;
             BeforeExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");
             ArrayList arlProcessID = new ArrayList();
             for (int i = 0; i < BeforeExcelProcess.Length; i++)
             {
                 arlProcessID.Add(BeforeExcelProcess[i].Id);
             }
             #endregion*/
            //Write

            //파일이 존재 한다면..삭제 하고..
            /*if (File.Exists("C:\\Test.xls"))
            {
                File.Delete("C:\\Test.xls");
            }*/
            try
            {
                ExcelApp = new Excel.Application();
                Thread.Sleep(1);
                try
                {
                    wb = ExcelApp.Workbooks.Open(data[0].ToString(), 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                       Missing.Value, true, false, Missing.Value, false, false, false);
                }
                catch { ExcelKill(); return; }
                Thread.Sleep(1);
                ws = wb.Worksheets["Sheet1"] as Excel.Worksheet;
                Thread.Sleep(1);

                //엑셀 시트 인덱스 번호는 0,0 부터 시작 하는 것이 아니라 1,1 A1 부터 시작 함. 0,0 으로 시작하면 오류...
                //시트에 값 쓰기...
                ws.Cells[8, 9] = data[1].ToString();//dataGridView_Sensor.Rows[0].Cells[0].Value; // 제조 번호
                ws.Cells[8, 4] = data[2].ToString();//dataGridView_Sensor.Rows[0].Cells[1].Value; // 일련번호
                ws.Cells[8, 6] = data[3].ToString();//dataGridView_Sensor.Rows[0].Cells[2].Value; //IMEI 
                ws.Cells[8, 7] = data[4].ToString();//dataGridView_Sensor.Rows[0].Cells[3].Value;// PHONE
                ws.Cells[8, 8] = data[5].ToString();//dataGridView_Sensor.Rows[0].Cells[4].Value;//USIM
                ws.Cells[8, 10] = data[6].ToString();//dataGridView_Sensor.Rows[0].Cells[5].Value;//FIRM VER
                ws.Cells[8, 18] = data[7].ToString();//dataGridView_Sensor.Rows[0].Cells[6].Value;//BATT
                ws.Cells[8, 19] = data[8].ToString();//dataGridView_Sensor.Rows[0].Cells[7].Value;//SYS
                ws.Cells[8, 20] = data[9].ToString();//dataGridView_Sensor.Rows[0].Cells[8].Value;//TEMP
                ws.Cells[8, 21] = data[10].ToString();//dataGridView_Sensor.Rows[0].Cells[9].Value;//BMA
                ws.Cells[8, 22] = data[11].ToString();//dataGridView_Sensor.Rows[0].Cells[10].Value;//BMA
                ws.Cells[8, 23] = data[12].ToString();//dataGridView_Sensor.Rows[0].Cells[11].Value;//BMA
                /*ws.Cells[1, 3] = "123";
                ws.Cells[1, 4] = "1234";
                ws.Cells[2, 1] = "Test1"; //A2
                ws.Cells[3, 1] = "Test12"; //A3
                ws.Cells[4, 1] = "Test123"; //A4*/


                //다른 이름으로 저장하기...
                wb.Save(); // => 오픈한 파일 그대로 저장...
                           /* wb.SaveAs("C:\\Test.xls",
                                      Excel.XlFileFormat.xlWorkbookNormal,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Excel.XlSaveAsAccessMode.xlNoChange,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing);
                                      */
                           //파일 닫기... 
                wb.Close(false, Type.Missing, Type.Missing);
                // wb = null;
                ExcelApp.Quit();
                //ExcelApp = null;
            }
            catch (Exception ex)
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
            finally
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
        }
        private void Catm1_DataxlsWrite(object dst, object Product, object Modemver, object Rsrp, object Rsrq)
        {

            ExcelKill();
            /* #region // 프로세스 얻기 
             System.Diagnostics.Process[] BeforeExcelProcess;
             BeforeExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");
             ArrayList arlProcessID = new ArrayList();
             for (int i = 0; i < BeforeExcelProcess.Length; i++)
             {
                 arlProcessID.Add(BeforeExcelProcess[i].Id);
             }
             #endregion*/
            //Write

            //파일이 존재 한다면..삭제 하고..
            /*if (File.Exists("C:\\Test.xls"))
            {
                File.Delete("C:\\Test.xls");
            }*/
            try
            {
                ExcelApp = new Excel.Application();
                Thread.Sleep(1);
                try
                {
                    wb = ExcelApp.Workbooks.Open(dst.ToString(), 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                       Missing.Value, true, false, Missing.Value, false, false, false);
                }
                catch { ExcelKill(); return; }
                Thread.Sleep(1);
                ws = wb.Worksheets["Sheet1"] as Excel.Worksheet;
                Thread.Sleep(1);

                //엑셀 시트 인덱스 번호는 0,0 부터 시작 하는 것이 아니라 1,1 A1 부터 시작 함. 0,0 으로 시작하면 오류...
                //시트에 값 쓰기...
                ws.Cells[8, 9] = Product.ToString();//dataGridView_Catm1.Rows[0].Cells[0].Value; //Bluecell 제조 번호
                ws.Cells[8, 12] = Modemver.ToString(); //dataGridView_Catm1.Rows[0].Cells[5].Value;//RSRP
                ws.Cells[8, 13] = Rsrp.ToString(); //dataGridView_Catm1.Rows[0].Cells[6].Value;//RSRQ
                ws.Cells[8, 14] = Rsrq.ToString(); //dataGridView_Catm1.Rows[0].Cells[6].Value;//RSRQ
                /*ws.Cells[1, 3] = "123";
                ws.Cells[1, 4] = "1234";
                ws.Cells[2, 1] = "Test1"; //A2
                ws.Cells[3, 1] = "Test12"; //A3
                ws.Cells[4, 1] = "Test123"; //A4*/


                //다른 이름으로 저장하기...
                wb.Save(); // => 오픈한 파일 그대로 저장...
                           /* wb.SaveAs("C:\\Test.xls",
                                      Excel.XlFileFormat.xlWorkbookNormal,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Excel.XlSaveAsAccessMode.xlNoChange,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing);
                                      */
                           //파일 닫기... 
                wb.Close(false, Type.Missing, Type.Missing);
                // wb = null;
                ExcelApp.Quit();
                //ExcelApp = null;
            }
            catch (Exception ex)
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
            finally
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
        }
        private void Sninsert_DataxlsWrite(object[] data)
        {
            ExcelKill();
            /* #region // 프로세스 얻기 
             System.Diagnostics.Process[] BeforeExcelProcess;
             BeforeExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");
             ArrayList arlProcessID = new ArrayList();
             for (int i = 0; i < BeforeExcelProcess.Length; i++)
             {
                 arlProcessID.Add(BeforeExcelProcess[i].Id);
             }
             #endregion*/
            //Write

            //파일이 존재 한다면..삭제 하고..
            /*if (File.Exists("C:\\Test.xls"))
            {
                File.Delete("C:\\Test.xls");
            }*/
            try
            {
                ExcelApp = new Excel.Application();
                Thread.Sleep(1);
                try
                {
                    wb = ExcelApp.Workbooks.Open(data[0].ToString(), 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                       Missing.Value, true, false, Missing.Value, false, false, false);
                }
                catch { ExcelKill(); return; }
                Thread.Sleep(1);
                ws = wb.Worksheets["Sheet1"] as Excel.Worksheet;
                Thread.Sleep(1);

                //엑셀 시트 인덱스 번호는 0,0 부터 시작 하는 것이 아니라 1,1 A1 부터 시작 함. 0,0 으로 시작하면 오류...
                //시트에 값 쓰기...
                ws.Cells[8, 9] = data[1].ToString();// 제조 번호
                ws.Cells[8, 4] = data[2].ToString();// 일련번호
                ws.Cells[8, 6] = data[3].ToString();//IMEI 
                


                //다른 이름으로 저장하기...
                wb.Save(); // => 오픈한 파일 그대로 저장...
                           /* wb.SaveAs("C:\\Test.xls",
                                      Excel.XlFileFormat.xlWorkbookNormal,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Excel.XlSaveAsAccessMode.xlNoChange,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing,
                                      Type.Missing);
                                      */
                           //파일 닫기... 
                wb.Close(false, Type.Missing, Type.Missing);
                // wb = null;
                ExcelApp.Quit();
                //ExcelApp = null;
            }
            catch (Exception ex)
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
            finally
            {
                //객체들 메모리 해제
                ReleaseExcelObject(ws);
                ReleaseExcelObject(wb);
                ReleaseExcelObject(ExcelApp);
                /*  #region // 프로세스 죽이기
                  System.Diagnostics.Process[] AfterExcelProcess;
                  AfterExcelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");

                  for (int i = 0; i < AfterExcelProcess.Length; i++)
                  {
                      try
                      {
                          if (!arlProcessID.Contains(AfterExcelProcess[i].Id))
                              AfterExcelProcess[i].Kill();
                      }
                      catch { }
                  }
                  #endregion*/
                GC.Collect();
            }
        }
        private void ExportExcel(bool captions)
        {

            this.openFileDialog.FileName = "TempName";
            this.openFileDialog.DefaultExt = "xls";
            this.openFileDialog.Filter = "Excel files (*.xls)|*.xls";
            this.openFileDialog.InitialDirectory = "c:\\";

            DialogResult result = openFileDialog.ShowDialog();

            if (result == DialogResult.OK)
            {
                int num = 0;
                object missingType = Type.Missing;

                Excel.Application objApp;
                Excel._Workbook objBook;
                Excel.Workbooks objBooks;
                Excel.Sheets objSheets;
                Excel._Worksheet objSheet;
                Excel.Range range;

                string[] headers = new string[dataGridView_SnInsert.ColumnCount];
                string[] columns = new string[dataGridView_SnInsert.ColumnCount];

                for (int c = 0; c < dataGridView_SnInsert.ColumnCount; c++)
                {
                    headers[c] = dataGridView_SnInsert.Rows[0].Cells[c].OwningColumn.HeaderText.ToString();
                    num = c + 65;
                    columns[c] = Convert.ToString((char)num);
                }

                try
                {
                    objApp = new Excel.Application();
                    objBooks = objApp.Workbooks;
                    objBook = objBooks.Add(Missing.Value);
                    objSheets = objBook.Worksheets;
                    objSheet = (Excel._Worksheet)objSheets.get_Item(1);

                    if (captions)
                    {
                        for (int c = 0; c < dataGridView_SnInsert.ColumnCount; c++)
                        {
                            range = objSheet.get_Range(columns[c] + "1", Missing.Value);
                            range.set_Value(Missing.Value, headers[c]);
                        }
                    }

                    for (int i = 0; i < dataGridView_SnInsert.RowCount - 1; i++)
                    {
                        for (int j = 0; j < dataGridView_SnInsert.ColumnCount; j++)
                        {
                            range = objSheet.get_Range(columns[j] + Convert.ToString(i + 2),
                                                                   Missing.Value);
                            range.set_Value(Missing.Value,
                                                  dataGridView_SnInsert.Rows[i].Cells[j].Value.ToString());
                        }
                    }

                    objApp.Visible = false;
                    objApp.UserControl = false;

                    objBook.SaveAs(@openFileDialog.FileName,
                              Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal,
                              missingType, missingType, missingType, missingType,
                              Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
                              missingType, missingType, missingType, missingType, missingType);
                    objBook.Close(false, missingType, missingType);

                    Cursor.Current = Cursors.Default;

                    MessageBox.Show("Save Success!!!");
                }
                catch (Exception theException)
                {
                    String errorMessage;
                    errorMessage = "Error: ";
                    errorMessage = String.Concat(errorMessage, theException.Message);
                    errorMessage = String.Concat(errorMessage, " Line: ");
                    errorMessage = String.Concat(errorMessage, theException.Source);

                    MessageBox.Show(errorMessage, "Error");
                }
            }
        }

        private void ReleaseExcelObject(object obj)
        {
            try
            {
                if (obj != null)
                {
                    Marshal.ReleaseComObject(obj);
                    obj = null;
                }
            }
            catch (Exception ex)
            {
                obj = null;
                throw ex;
            }
            finally
            {
                GC.Collect();
            }
        }

        // CommonOpenFileDialog 클래스 생성 
        CommonOpenFileDialog dialog = new CommonOpenFileDialog();
        private void button_Path_Click(object sender, EventArgs e)
        {
            // 처음 보여줄 폴더 설정(안해도 됨) 
            //dialog.InitialDirectory = "";
            dialog.IsFolderPicker = true;
            if (dialog.ShowDialog() == CommonFileDialogResult.Ok)
            {
                FileSaveSet = dialog.FileName;
                //  label.Text = dialog.FileName; 
                // 테스트용, 폴더 선택이 완료되면 선택된 폴더를 label에 출력 
            }
        }

        private void dataGridView_Gps_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //button_GpsTestSave_Click(null, null);
                //to do
            }
            else
            {
                return;
            }
        }

        private void button_PrevFile_Click(object sender, EventArgs e)
        {

            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                foreach (string x in openFileDialog.FileNames)
                {
                    listBox_PreviousFile.Items.Add(x);
                }
            }
        }

        private void button_AfterFile_Click(object sender, EventArgs e)
        {
            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                foreach (string x in openFileDialog.FileNames)
                {
                    listBox_AfterFile.Items.Add(x);
                }
            }
        }

        private void label_Merge_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = false;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = true;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = false;
        }

        private void label_SnCheck_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = false;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = true;
            panel_SnTest.Visible = false;
        }
        private string Excel03ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR={1}'";
        private string Excel07ConString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR={1}'";

        List<string> list1 = new List<string>();
        List<string> list2 = new List<string>();

        private void readExcel()
        {
            /*Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            Excel.Range range;

            string str;
            int rCnt = 0; // 열 갯수
            int cCnt = 0; // 행 갯수

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open("d:\\test.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); // 첫번째 시트를 가져 옴.

            range = xlWorkSheet.UsedRange; // 가져 온 시트의 데이터 범위 값

            for (rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
            {
                for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
                {
                    str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2; // 열과 행에 해당하는 데이터를 문자열로 반환
                    MessageBox.Show(str);
                }
            }

            xlWorkBook.Close(true, null, null);
            xlApp.Quit();

            ReleaseExcelObject(xlWorkSheet);
            ReleaseExcelObject(xlWorkBook);
            ReleaseExcelObject(xlApp);
            GC.Collect();*/

            // 엑셀 문서 내용 추출
            openFileDialog1_FileOk(null, null);


        }
        private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
        {
            string filePath = openFileDialog.FileName;
            string fileExtension = Path.GetExtension(filePath);
            string header = "No";//rbHeaderYes.Checked ? "Yes" : "No";
            string connectionString = string.Empty;
            string sheetName = string.Empty;
            list1.Clear();
            list2.Clear();

            // 확장자로 구분하여 커넥션 스트링을 가져옮
            switch (fileExtension)
            {
                case ".xls":    //Excel 97-03
                    connectionString = string.Format(Excel03ConString, filePath, header);
                    break;
                case ".xlsx":  //Excel 07
                    connectionString = string.Format(Excel07ConString, filePath, header);
                    break;
            }

            // 첫 번째 시트의 이름을 가져옮
            using (OleDbConnection con = new OleDbConnection(connectionString))
            {
                using (OleDbCommand cmd = new OleDbCommand())
                {
                    cmd.Connection = con;
                    con.Open();
                    DataTable dtExcelSchema = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                    sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
                    con.Close();
                }
            }
            //Console.WriteLine("sheetName = " + sheetName);

            // 첫 번째 쉬트의 데이타를 읽어서 datagridview 에 보이게 함.
            using (OleDbConnection con = new OleDbConnection(connectionString))
            {
                using (OleDbCommand cmd = new OleDbCommand())
                {
                    using (OleDbDataAdapter oda = new OleDbDataAdapter())
                    {
                        DataTable dt = new DataTable();
                        cmd.CommandText = "SELECT * From [" + sheetName + "]";
                        cmd.Connection = con;
                        con.Open();
                        oda.SelectCommand = cmd;
                        oda.Fill(dt);
                        con.Close();

                        //Populate DataGridView.
                        dataGridView_Chk.DataSource = dt;
                    }
                }
            }
            //dataGridView_Chk.Rows.Remove(1);
            /*  for (int i = 0; i < 54; i++)
              {
                  dataGridView_Chk.Rows.Remove(dataGridView_Chk.Rows[i]);
              }*/
            for (int i = 1; i <= 18; i++)
            {
                if (i == 3 || i == 8)
                    continue;
                dataGridView_Chk.Columns.Remove("F" + i.ToString());
            }



            dataGridView_Chk.Sort(dataGridView_Chk.Columns.GetFirstColumn(DataGridViewElementStates.Visible, DataGridViewElementStates.None), ListSortDirection.Descending);
            for (int i = 0; i < dataGridView_Chk.RowCount; i++)
            {
                if (dataGridView_Chk.Rows[i].Cells[0].Value.ToString() == ""
                    || dataGridView_Chk.Rows[i].Cells[1].Value.ToString() == "")
                {
                    break;
                }
                list1.Add(dataGridView_Chk.Rows[i].Cells[0].Value.ToString());
                list2.Add(dataGridView_Chk.Rows[i].Cells[1].Value.ToString());
            }

        }



        private void button_FileFindLoad_Click(object sender, EventArgs e)
        {
            if (openFileDialog.ShowDialog() == DialogResult.OK)
            {
                openFileDialog1_FileOk(null, null);

                /*foreach (string x in openFileDialog.FileNames)
                {
                    listBox_Previous.Items.Add(x);
                }*/
            }
        }

        private Thread rTh;

        private void button_Merge_Click(object sender, EventArgs e)
        {
            rTh = new Thread(OpenExcelFile);
            rTh.Start();
            //OpenExcelFile();
        }


        // progress bar
        private delegate void myDelegate(int theValue, int theMax);
        delegate void SetTextCallback(string text);
        // 컨트롤의 접근은 따로 함수를 만들어서 접근하도록 한다.
        private void SetText(string text)
        {
            // InvokeRequired required compares the thread ID of the
            // calling thread to the thread ID of the creating thread.
            // If these threads are different, it returns true.
            if (this.label_Cnt.InvokeRequired)
            {
                SetTextCallback d = new SetTextCallback(SetText);
                this.Invoke(d, new object[] { text });
            }
            else
            {
                this.label_Cnt.Text = "Count : " + text;
            }
        }
        private void LabelChkSetText(string text)
        {
            // InvokeRequired required compares the thread ID of the
            // calling thread to the thread ID of the creating thread.
            // If these threads are different, it returns true.
            if (this.label_Cnt.InvokeRequired)
            {
                SetTextCallback d = new SetTextCallback(SetText);
                this.Invoke(d, new object[] { text });
            }
            else
            {
                this.label_Cnt.Text = "Count : " + text;
            }
        }

        //스레드에서 아래 함수를 호출하면 된다.

        private void updateProgress(int theValue, int theMax)
        {
            if (theMax != 0)
                progressBar_Merge.Maximum = theMax;
            progressBar_Merge.Value = theValue;
        }



        #region
        /// <summary>
        /// 엑셀 정식 파일 형식이 아닌 파일 읽기
        /// </summary>
        /// <param name="FileName">파일명.확장자</param>
        /// <returns></returns>

        public void OpenExcelFile()
        {
            string[] APL_CopyArray =
            {
                "D8", "E8", "F8", "G8", "H8",//SKT 일련번호   ,VC생산번호 ,IMEI      ,PHONE     ,USIM
                "I8", "J8", "K8", "L8", "M8",//블루셀 제조번호,Ver        ,SNR       ,모뎀 버전 ,RSRP,
                "N8", "O8", "P8", "Q8", "R8",//RSRQ           ,"숨기기1"  ,"숨기기2" ,"숨기기3" ,BATT,
                "S8", "T8", "U8", "V8", "W8",//SySVolt        ,TEMP       ,BMAX      ,BMAY      ,BMAZ
            };

            for (int index = 0; index < listBox_PreviousFile.Items.Count; index++)
            {
                Excel.Workbook xlWorkbook_copy = null;
                Excel.Workbook xlWorkbook_paste = null;

                Excel.Worksheet xlWorksheet_copy = null;
                Excel.Worksheet xlWorksheet_paste = null;

                Excel.Application xlApp_paste = null;
                Excel.Application xlApp_copy = null;
                Excel.Range range = null;
                object data = null;
                string PrevFile = listBox_PreviousFile.Items[index].ToString();
                string AfterFile = listBox_AfterFile.Items[0].ToString();
                try
                {
                    xlApp_copy = new Excel.Application();
                    xlApp_paste = new Excel.Application();
                    xlWorkbook_copy = xlApp_copy.Workbooks.Open(PrevFile);
                    //   xlWorkbook_paste = xlApp_paste.Workbooks.Open(listBox_AfterFile.Items[0].ToString());
                    /* Data 붙여넣을 Excel 파일 변수 초기화  */
                    xlWorkbook_paste = xlApp_paste.Workbooks.Open(AfterFile, 0, false, 5, Missing.Value, Missing.Value, false, Missing.Value,
                       Missing.Value, true, false, Missing.Value, false, false, false);
                    //   xlWorksheet_paste = xlApp_paste.Worksheets.Item["2-1 NR 100MHz DL"]; // 특정시트 불러오기.
                    /* 2-1 NR 100MHz DL Copy area*/

                    xlWorksheet_paste = xlApp_paste.Worksheets.Item[1]; // 특정시트 불러오기.
                    xlWorksheet_copy = xlApp_copy.Worksheets.Item[1]; // 특정시트 불러오기.
                    for (int i = 0; i < APL_CopyArray.Length; i++)
                    {
                        range = xlWorksheet_copy.Range[APL_CopyArray[i]];
                        data = range.Value;
                        xlWorksheet_paste.Cells[8 + index, 4 + i] = data; // 블루셀 제조번호
                    }
                    xlWorkbook_paste.Save();
                    xlWorkbook_paste.Close(true);
                    xlApp_paste.Quit();

                    xlWorkbook_copy.Close(true);
                    xlApp_copy.Quit();
                    xlWorkbook_copy = null;
                    //xlWorkbook_copy.Save();


                    //xlWorkbook_paste = null;
                    //

                }
                catch (Exception ex)
                {
                    //객체들 메모리 해제
                    xlWorkbook_paste.Close(true);
                    xlWorkbook_copy.Close(true);

                    xlApp_paste.Quit();
                    xlApp_copy.Quit();

                    ReleaseExcelObject(xlWorksheet_paste);
                    ReleaseExcelObject(xlWorkbook_paste);
                    ReleaseExcelObject(xlApp_paste);

                    ReleaseExcelObject(xlWorksheet_copy);
                    ReleaseExcelObject(xlWorkbook_copy);
                    ReleaseExcelObject(xlApp_copy);
                    GC.Collect();
                    rTh.Abort(); //쓰레드 강제 종료
                }
                finally
                {
                    //객체들 메모리 해제
                    ReleaseExcelObject(xlWorksheet_paste);
                    ReleaseExcelObject(xlWorkbook_paste);
                    ReleaseExcelObject(xlApp_paste);

                    ReleaseExcelObject(xlWorksheet_copy);
                    ReleaseExcelObject(xlWorkbook_copy);
                    ReleaseExcelObject(xlApp_copy);

                    GC.Collect();

                    this.Invoke(new myDelegate(updateProgress), new object[] { index + 1, listBox_PreviousFile.Items.Count });
                    SetText((index + 1).ToString());

                }
            }
            rTh.Abort(); //쓰레드 강제 종료

        }


        #endregion

        private void button_ChkStart_Click(object sender, EventArgs e)
        {
            string value = "";
            int Chkcnt = 0;
            bool Failed = false;
            int index1 = 0;
            int index2 = 0;
            string data1 = "", data2 = "";
            if (InputBox("번호 입력", "일련 번호:", ref value) == DialogResult.OK)
            {

                for (int i = 0; i < list1.Count; i++)
                {
                    if (value == list1[i])
                    {
                        Chkcnt++;
                        index1 = i;
                        data1 = value;
                    }
                }
                if (Chkcnt > 1)
                {
                    listBox_SNDuplicate.Items.Add(value + " Cnt : " + Chkcnt.ToString());
                    Failed = true;
                }
                Chkcnt = 0;

                if (InputBox("번호 입력", "생산 번호", ref value) == DialogResult.OK)
                {

                    for (int i = 0; i < list2.Count; i++)
                    {
                        if (value == list2[i])
                        {
                            Chkcnt++;
                            index2 = i;
                            data2 = value;
                        }
                    }
                    if (Chkcnt > 1)
                    {
                        listBox_ProductDuplicate.Items.Add(value + " Cnt : " + Chkcnt.ToString());
                        Failed = true;
                    }
                    Chkcnt = 0;
                }

                if (Failed == true)
                {
                    MessageBox.Show("중복항목을 제거 한 후 다시 시도해주세요.", "Error Check", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                    return;
                }
                if (index1 != index2)
                {
                    MessageBox.Show("서로 다른 짝 입니다. 확인해주세요.\r" + "\r일련번호 : " + list1[index1] + "\r생산번호 : " + list2[index2], "Error Check", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    if (list1[index1] == data1)
                    {
                        if (list2[index2] == data2)
                        {
                            MessageBox.Show("서로 맞는 짝입니다.\r" + "\r일련번호 : " + list1[index1] + "\r생산번호 : " + list2[index2]);
                        }
                    }
                }



                // SN
                /*dataGridView_Sensor.Rows[0].Cells[1].Value = Name = value;
                serialPort.Write(value);
                button_SensorTestSave();
                for (int i = 0; i < 12; i++)
                    dataGridView_Sensor.Rows[0].Cells[i].Value = null;*/

            }
        }

        private void button_SNClear_Click(object sender, EventArgs e)
        {
            listBox_SNDuplicate.Items.Clear();
        }

        private void button_DuplicateClear_Click(object sender, EventArgs e)
        {
            listBox_ProductDuplicate.Items.Clear();
        }

        private void button_DiffClear_Click(object sender, EventArgs e)
        {
            listBox_Diff.Items.Clear();
        }



        private void dataGridView_Gps_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string value = "";
            //BL-VITE00-V
            if (InputBox("번호 입력", "생산 번호:", ref value) == DialogResult.OK)
            {
                // SN
                dataGridView_Sensor.Rows[0].Cells[0].Value = value;
                if (dataGridView_Sensor.Rows[0].Cells[0].Value != null)
                {
                    Double SnrMinref = Convert.ToDouble(dataGridView_Gps.Rows[0].Cells[3].Value);
                    Double SnrValue = Convert.ToDouble(dataGridView_Gps.Rows[0].Cells[1].Value);
                    Double SecValue = Convert.ToDouble(dataGridView_Gps.Rows[0].Cells[4].Value);
                    Double SecMaxref = Convert.ToDouble(dataGridView_Gps.Rows[0].Cells[3].Value);
                    if (SnrMinref > SnrValue || SecMaxref <= SecValue)
                    {
                        MessageBox.Show("APL 부적합 Device 입니다.");
                        return;
                    }
                    button_GpsTestSave_Click(null, null);
                    dataGridView_Gps_CellClick(null, null);
                    gps_arrangecnt = 0;
                    ColdCnt = 0;
                    GPGGA_Cnt = 0;
                    dataGridView_Gps.Rows[0].Cells[0].Value = Name = value;
                   // button_GpsTestSave_Click(null, null);
                }

            }
        }

        private void dataGridView_Catm1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string value = "";
            //BL-VITE00-V
            if (InputBox("번호 입력", "생산 번호:", ref value) == DialogResult.OK)
            {
                // SN
                dataGridView_Catm1.Rows[0].Cells[0].Value = Name = value;
                button_Catm1TestSave();
                dataGridView_Catm1_CellClick(null, null);

            }
        }

        private void dataGridView_Sensor_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string value = "";
            string value1 = "";
            //BL-VITE00-V
            if (InputBox("번호 입력", "생산 번호:", ref value) == DialogResult.OK)
            {
                // SN
                dataGridView_Sensor.Rows[0].Cells[0].Value = Name = value;
                if (InputBox("번호 입력", "SKT SN:", ref value1) == DialogResult.OK)
                {
                    dataGridView_Sensor.Rows[0].Cells[1].Value = value1;
                    dataGridView_Sensor.Refresh();
                    button_SensorTestSave();
                    dataGridView_Sensor_CellClick(null, null);
                }

            }
        }

        private void label_SnInsert_Click(object sender, EventArgs e)
        {
            panel_GpsTest.Visible = false;
            panel_SensorTest.Visible = false;
            panel_Catm1Test.Visible = false;
            panel_MergeMain.Visible = false;
            panel_SnCheckMain.Visible = false;
            panel_SnTest.Visible = true;

        }



        private void label_SnInsert_MouseMove(object sender, MouseEventArgs e)
        {
            panel_Sninsert.BackColor = Color.FromArgb(0, 159, 255);
        }

        private void label_Check_MouseLeave(object sender, EventArgs e)
        {
            if (panel_GpsTest.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 255);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_Catm1Test.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 255);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_SensorTest.Visible == true)
            {
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 255);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_MergeMain.Visible == true)
            {
                panel_Merge.BackColor = Color.FromArgb(0, 159, 255);
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_SnCheckMain.Visible == true)
            {
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 255);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 200);
            }
            else if (panel_SnTest.Visible == true)
            {
                panel_Merge.BackColor = Color.FromArgb(0, 159, 200);
                panel_Catm1Mode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SensorMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_GpsMode.BackColor = Color.FromArgb(0, 159, 200);
                panel_SnCheck.BackColor = Color.FromArgb(0, 159, 200);
                panel_Sninsert.BackColor = Color.FromArgb(0, 159, 255);
            }
        }

        private void label_Check_MouseMove(object sender, MouseEventArgs e)
        {

        }

        private void dataGridView_SnInsert_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string ProductNum = "";
            string SKTNUM = "";
            string IMEI = "";
            if (InputBox("번호 입력", "생산 번호:", ref ProductNum) == DialogResult.OK)
            {
                // SN

                dataGridView_SnInsert.Rows[0].Cells[0].Value = Name = ProductNum;
                if (InputBox("번호 입력", "SKT SN:", ref SKTNUM) == DialogResult.OK)
                {
                    dataGridView_SnInsert.Rows[0].Cells[1].Value = SKTNUM;
                    if (InputBox("번호 입력", "IMEI:", ref IMEI) == DialogResult.OK)
                    {
                        dataGridView_SnInsert.Rows[0].Cells[2].Value = IMEI;
                        button_SninsertTestSave();
                        dataGridView_Sensor.Refresh();
                        dataGridView_SnInsert_CellClick(null, null);
                    }
                }

            }
        }


        class AutoClosingMessageBox
        {
            [System.Runtime.InteropServices.DllImport("user32.dll", SetLastError = true)]
            static extern IntPtr FindWindow(string lpClassName, string lpWindowName);
            [System.Runtime.InteropServices.DllImport("user32.dll", CharSet = System.Runtime.InteropServices.CharSet.Auto)]
            static extern IntPtr SendMessage(IntPtr hWnd, UInt32 Msg, IntPtr wParam, IntPtr lParam);

            System.Threading.Timer _timeoutTimer; //쓰레드 타이머
            string _caption;

            const int WM_CLOSE = 0x0010; //close 명령 

            AutoClosingMessageBox(string text, string caption, int timeout)
            {
                _caption = caption;
                _timeoutTimer = new System.Threading.Timer(OnTimerElapsed,
                    null, timeout, System.Threading.Timeout.Infinite);
                MessageBox.Show(text, caption);
            }

            //생성자 함수
            public static void Show(string text, string caption, int timeout)
            {
                new AutoClosingMessageBox(text, caption, timeout);
            }

            //시간이 다되면 close 메세지를 보냄

            void OnTimerElapsed(object state)
            {
                IntPtr mbWnd = FindWindow(null, _caption);
                if (mbWnd != IntPtr.Zero)
                    SendMessage(mbWnd, WM_CLOSE, IntPtr.Zero, IntPtr.Zero);
                _timeoutTimer.Dispose();
            }
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            
        }
    }
}