using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Diagnostics;

namespace SignusKHSVR
{
    public partial class Form1 : Form
    {
        const int MAX_PROCESS = 10;
        private Process[] m_ps = new Process[MAX_PROCESS];
        private List<string> m_lstExe = new List<string>();

        public Form1()
        {
            InitializeComponent();
        }

        private void ToolStripMenuItem_Close_Click(object sender, EventArgs e)
        {
            Program.PostMessage((IntPtr)0xffff, Program.messageQuit, 0, 0);

            for (int i = 0; i < MAX_PROCESS; i++)
            {
                if (m_ps[i] != null)
                {
                    m_ps[i].Kill();
                    m_ps[i] = null;
                }
            }
            this.Close();
        }

        private string m_strUrl = "http://192.168.1.17:8080";

        private void Form1_Load(object sender, EventArgs e)
        {
            string AppPath = Application.ExecutablePath.Substring(0, Application.ExecutablePath.LastIndexOf("\\"));

            //string strChrome1 = "C:\\Program Files\\Google\\Chrome\\Application\\chrome.exe";
            //string strChrome2 = "C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome.exe";
            //string strChrome3 = "C:\\Users\\CUPC\\AppData\\Local\\Google\\Chrome\\Application\\chrome.exe";

            //if (System.IO.File.Exists(strChrome1))
            //    this.m_lstExe.Add(strChrome1);
            //else if (System.IO.File.Exists(strChrome2))
            //    this.m_lstExe.Add(strChrome2);
            //else if (System.IO.File.Exists(strChrome3))
            //    this.m_lstExe.Add(strChrome3);

            //this.m_lstExe.Add(AppPath + string.Format("\\KHSCALE.exe"));

            timer1.Enabled = true;
            timer1.Interval = 500;

            timer_LogApi.Enabled = true;
            timer_LogApi.Interval = 30 * 60 * 1000;

            this.Visible = false; //창을 보이지 않게 한다.
            this.ShowIcon = false; //작업표시줄에서 제거.
        }

        private int m_nPrevSec = -1;

        private void timer1_Tick(object sender, EventArgs e)
        {
            DateTime dtNow = DateTime.Now;
            if (m_nPrevSec == dtNow.Second) return;
            m_nPrevSec = dtNow.Second;

            if (m_nPrevSec % 10 == 0)
            {
                SaveLog();
                SaveScaleLog();
            }

            UpdateProgram(m_nPrevSec % 10);

            //Program.MoveFiles("C:\\EDIM\\Edge Advance 16P\\CSV", "C:\\EDIM\\Edge Advance 16P\\CSV1");
        }

        private void SaveLog()
        {
            U3Database db = new U3Database();
            string strSQL = "";
            strSQL += " SELECT a.MACH_CD, (a.REAL_DATA * b.VALUE_RATIO) as PV_VAL";
            strSQL += " FROM T_HT_REAL_DATA a";
            strSQL += " left join T_STD_MACH b on a.MACH_CD = b.MACH_CD";
            strSQL += " where a.MACH_CD >= 'M0001' and a.MACH_CD <= 'M0030'";
            DataTable dt = db.OpenSQL(strSQL);

            Dictionary<string, float> m_dic = new Dictionary<string, float>();

            foreach (DataRow dr in dt.Rows)
            {
                string s = U3Util.toStr(dr["MACH_CD"]);
                float f = U3Util.toFloat(dr["PV_VAL"]);
                m_dic[s] = f;
            }

            strSQL = "";
            strSQL += " insert into T_TEMP_REAL_DATA_LOG (COMP_CD, REG_DT, M0001, M0002, M0003, M0004, M0005, M0006, M0007, M0008, M0009, M0010, M0011, M0012, M0013, M0014, M0015, M0016, M0017, M0018, M0019, M0020, M0021, M0022, M0023, M0024, M0025, M0026, M0027, M0028, M0029, M0030) values (";
            strSQL += " '0001', ";
            strSQL += " getdate(), ";
            strSQL += " " + (m_dic.ContainsKey("M0001") ? m_dic["M0001"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0002") ? m_dic["M0002"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0003") ? m_dic["M0003"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0004") ? m_dic["M0004"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0005") ? m_dic["M0005"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0006") ? m_dic["M0006"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0007") ? m_dic["M0007"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0008") ? m_dic["M0008"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0009") ? m_dic["M0009"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0010") ? m_dic["M0010"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0011") ? m_dic["M0011"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0012") ? m_dic["M0012"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0013") ? m_dic["M0013"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0014") ? m_dic["M0014"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0015") ? m_dic["M0015"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0016") ? m_dic["M0016"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0017") ? m_dic["M0017"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0018") ? m_dic["M0018"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0019") ? m_dic["M0019"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0020") ? m_dic["M0020"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0021") ? m_dic["M0021"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0022") ? m_dic["M0022"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0023") ? m_dic["M0023"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0024") ? m_dic["M0024"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0025") ? m_dic["M0025"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0026") ? m_dic["M0026"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0027") ? m_dic["M0027"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0028") ? m_dic["M0028"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0029") ? m_dic["M0029"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("M0030") ? m_dic["M0030"].ToString() : "0") + ") ";

            db.ExcuteSql(strSQL);
        }

        private void SaveScaleLog()
        {
            U3Database db = new U3Database();
            string strSQL = "";
            strSQL += " SELECT * FROM T_HT_REAL_SCALE ";
            DataTable dt = db.OpenSQL(strSQL);

            Dictionary<string, float> m_dic = new Dictionary<string, float>();

            foreach (DataRow dr in dt.Rows)
            {
                string s = U3Util.toStr(dr["TOUCH_CD"]);
                float f = U3Util.toFloat(dr["SCALE_VALUE"]);
                if (s.Length == 0) continue;
                m_dic[s] = f;
            }

            strSQL = "";
            strSQL += " insert into T_TEMP_REAL_SCALE_LOG (COMP_CD, REG_DT, TP01, TP02, TP03, TP04, TP05, TP06, TP07, TP08, TP09, TP10) values (";
            strSQL += " '0001', ";
            strSQL += " getdate(), ";
            strSQL += " " + (m_dic.ContainsKey("TP-01") ? m_dic["TP-01"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-02") ? m_dic["TP-02"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-03") ? m_dic["TP-03"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-04") ? m_dic["TP-04"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-05") ? m_dic["TP-05"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-06") ? m_dic["TP-06"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-07") ? m_dic["TP-07"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-08") ? m_dic["TP-08"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-09") ? m_dic["TP-09"].ToString() : "0") + ", ";
            strSQL += " " + (m_dic.ContainsKey("TP-10") ? m_dic["TP-10"].ToString() : "0") + ") ";

            db.ExcuteSql(strSQL);
        }

        public void UpdateProgram(int index)
        {
            if (index < 0) return;
            if (index >= this.m_lstExe.Count()) return;

            string AppExe = this.m_lstExe[index];
            if (System.IO.File.Exists(AppExe) == false)
                return;

            string AppPath = Application.ExecutablePath.Substring(0, Application.ExecutablePath.LastIndexOf("\\"));

            if (m_ps[index] == null)
            {
                m_ps[index] = new Process();
            }
            else
            {
                try
                {
                    if (m_ps[index].HasExited)
                    {
                        m_ps[index].Close();
                        m_ps[index] = new System.Diagnostics.Process();
                    }
                    else
                    {
                        return;
                    }
                }
                catch
                {
                    return;
                }
            }

            if (AppExe.IndexOf("chrome") > 0)
            {
                m_ps[index].StartInfo.FileName = AppExe;
                m_ps[index].StartInfo.WorkingDirectory = AppPath;
                m_ps[index].StartInfo.Arguments = " -kiosk -fullscreen " + m_strUrl;
                m_ps[index].StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
                m_ps[index].Start();
                return;
            }

            m_ps[index].StartInfo.FileName = AppExe;
            m_ps[index].StartInfo.WorkingDirectory = AppPath;
            m_ps[index].StartInfo.Arguments = "";
            m_ps[index].StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Minimized;
            m_ps[index].Start();
        }

        private void Form1_FormClosed(object sender, FormClosedEventArgs e)
        {
            Program.PostMessage((IntPtr)0xffff, Program.messageQuit, 0, 0);

            for (int i = 0; i < MAX_PROCESS; i++)
            {
                if (m_ps[i] != null)
                {
                    m_ps[i].Kill();
                    m_ps[i] = null;
                }
            }
        }

        private void Form1_Resize(object sender, EventArgs e)
        {
            if (this.WindowState == FormWindowState.Minimized)
            {
                this.Visible = false; //창을 보이지 않게 한다.
                this.ShowIcon = false; //작업표시줄에서 제거.
                //m_notify.Visible = true; //트레이 아이콘을 표시한다.
            }
        }

        private void timer_LogApi_Tick(object sender, EventArgs e)
        {
            SFLogApi log = new SFLogApi();
            log.Run();
        }
    }
}