HYTOS

using Newtonsoft.Json;

using System;

using System.Collections.Generic;

using System.Data;

using System.IO;

using System.Linq;

using System.Net.Sockets;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace ID2PSN

{

    static class Program

    {

        /// <summary>

        /// 해당 애플리케이션의 주 진입점입니다.

        /// </summary>

        [STAThread]

        static void Main(string[] args)

        {

            if (!SingleInstance.Start("ecf2ed2e-1a3f-4926-a561-512857785805"))

            {

                return;

            }

            ID2Info info = ID2Info.GetInstance();

            DataTable projectTable = null;

            try

            {

                //DB Type 확인

                projectTable = DB.GetProject();

                using (TcpClient tcpClient = new TcpClient())

                {

                    tcpClient.SendTimeout = 500;

                    tcpClient.Connect("localhost", 2549);

                    var _params = new Dictionary<string, string>()

                    {

                        {"request", "database" },

                    };

                    var json = JsonConvert.SerializeObject(_params, Formatting.Indented);

                    byte[] message = Encoding.UTF8.GetBytes(json);

                    using (NetworkStream networkStream = tcpClient.GetStream())

                    {

                        networkStream.Write(message, 0, message.Length);

                        byte[] outbuf = new byte[1024];

                        int nbytes = networkStream.Read(outbuf, 0, outbuf.Length);

                        string output = Encoding.UTF8.GetString(outbuf, 4, nbytes - 5);

                        var result = JsonConvert.DeserializeObject<Dictionary<string, string>>(output);

                        if (result["db_type"] == "SQLite")

                        {

                            info.ID2DBType = ID2DB_Type.SQLite;

                            var parent = Directory.GetParent(Path.GetDirectoryName(result["db_name"]));

                            DataRow dr = projectTable.Select(string.Format("DBTypes_UID = 2 AND Name = '{0}'", result["db_name"])).FirstOrDefault();

                            info.DefaultPath = dr.Field<string>("Path");

                        }

                        else if (result["db_type"] == "MSSQL")

                        {

                            info.ID2DBType = ID2DB_Type.MSSQL;

                            info.ServerIP = result["host"];

                            //info.Port = "3389"; 

                            info.DBUser = result["user"];

                            info.DBPassword = result["password"];

                            //info.DefaultPath = result["db_name"];

                            DataRow dr = projectTable.Select(string.Format("DBTypes_UID = 2 AND Name = '{0}'", result["db_name"])).FirstOrDefault();

                            info.DefaultPath = dr.Field<string>("Path");

                        }

                    }

                    tcpClient.Close();

                }

                if (DB.ConnTestAndCreateTable())

                {

                    Application.EnableVisualStyles();

                    Application.SetCompatibleTextRenderingDefault(false);

                    Application.Run(new MainForm());

                }

                else

                    MessageBox.Show("fail");

            }

            catch (Exception ex)

            {

                MessageBox.Show("Failed to open ID2 drawing.", "ID2PSN", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

        }

    }

}