HYTOS

  <configSections>

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

  </configSections>

  <entityFramework>

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">

      <parameters>

        <parameter value="mssqllocaldb" />

      </parameters>

    </defaultConnectionFactory>

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />

    </providers>

  </entityFramework>

  <system.data>

    <DbProviderFactories>

      <remove invariant="System.Data.SQLite.EF6" />

      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />

    <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>

  </system.data>

    <NuGetPackageImportStamp>

    </NuGetPackageImportStamp>

    <OutputPath>..\SPPIDConverterDll\</OutputPath>

    <Reference Include="EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">

      <HintPath>..\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.dll</HintPath>

    </Reference>

    <Reference Include="EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">

      <HintPath>..\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.SqlServer.dll</HintPath>

    </Reference>

    <Reference Include="System.ComponentModel.DataAnnotations" />

    <Reference Include="System.Data.SQLite, Version=1.0.110.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">

      <HintPath>..\packages\System.Data.SQLite.Core.1.0.110.0\lib\net46\System.Data.SQLite.dll</HintPath>

    </Reference>

    <Reference Include="System.Data.SQLite.EF6, Version=1.0.110.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">

      <HintPath>..\packages\System.Data.SQLite.EF6.1.0.110.0\lib\net46\System.Data.SQLite.EF6.dll</HintPath>

    </Reference>

    <Reference Include="System.Data.SQLite.Linq, Version=1.0.110.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">

      <HintPath>..\packages\System.Data.SQLite.Linq.1.0.110.0\lib\net46\System.Data.SQLite.Linq.dll</HintPath>

    </Reference>

    <None Include="packages.config" />

  <Import Project="..\packages\System.Data.SQLite.Core.1.0.110.0\build\net46\System.Data.SQLite.Core.targets" Condition="Exists('..\packages\System.Data.SQLite.Core.1.0.110.0\build\net46\System.Data.SQLite.Core.targets')" />

  <Target Name="EnsureNuGetPackageBuildImports" BeforeTargets="PrepareForBuild">

    <PropertyGroup>

      <ErrorText>이 프로젝트는 이 컴퓨터에 없는 NuGet 패키지를 참조합니다. 해당 패키지를 다운로드하려면 NuGet 패키지 복원을 사용하십시오. 자세한 내용은 http://go.microsoft.com/fwlink/?LinkID=322105를 참조하십시오. 누락된 파일은 {0}입니다.</ErrorText>

    </PropertyGroup>

    <Error Condition="!Exists('..\packages\System.Data.SQLite.Core.1.0.110.0\build\net46\System.Data.SQLite.Core.targets')" Text="$([System.String]::Format('$(ErrorText)', '..\packages\System.Data.SQLite.Core.1.0.110.0\build\net46\System.Data.SQLite.Core.targets'))" />

  </Target>

using System.Globalization;

using System.Data.SQLite;

using System.Data;

        const string SPPID_DB_INFO_TABLE = "SPPID_CONNECTION_INFO";

        public static void Conn()

        {

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                connection.Open();

            }

        }

        public static bool ConnTestAndCreateTable()

        {

            bool result = false;

            Project_Info projectInfo = Project_Info.GetInstance();

            SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, @"Data Source = {0}", projectInfo.DBFilePath));

            try

            {

                connection.Open();

                if (connection.State == ConnectionState.Open)

                {

                    CreateTable(connection);

                    result = true;

                }

                connection.Close();

            }

            catch (Exception ex)

            {

            }

            finally

            {

                connection.Dispose();

            }

            return result;

        }

        public static bool SaveSPPID_DB_INFO(string jsonString)

        {

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                try

                {

                    connection.Open();

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = string.Format("DELETE FROM {0}", SPPID_DB_INFO_TABLE);

                        cmd.ExecuteNonQuery();

                        cmd.CommandText = string.Format("INSERT INTO {0} VALUES (@jsonString)", SPPID_DB_INFO_TABLE);

                        cmd.Parameters.AddWithValue("@jsonString", jsonString);

                        cmd.ExecuteNonQuery();

                    }

                    connection.Close();

                }

                catch (Exception ex)

                {

                    return false;

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return true;

        }

        public static DataTable SelectSPPID_DB_INFO()

        {

            DataTable dt = new DataTable();

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                try

                {

                    connection.Open();

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_DB_INFO_TABLE);

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                    }

                    connection.Close();

                }

                catch (Exception ex)

                {

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return dt;

        }

        private static void CreateTable(SQLiteConnection connection)

        {

            using (SQLiteCommand cmd = connection.CreateCommand())

            {

                cmd.CommandText = "SELECT NAME FROM sqlite_master WHERE type='table'";

                using (SQLiteDataReader dr = cmd.ExecuteReader())

                using (DataTable dt = new DataTable())

                {

                    dt.Load(dr);

                    if (dt.Select(string.Format("NAME = '{0}'", SPPID_DB_INFO_TABLE)).Length == 0)

                    {

                        cmd.CommandText = string.Format("CREATE TABLE {0} (JsonString TEXT)", SPPID_DB_INFO_TABLE);

                        cmd.ExecuteNonQuery();

                    }

                }

            }

        }

<?xml version="1.0" encoding="utf-8"?>

<packages>

  <package id="EntityFramework" version="6.2.0" targetFramework="net46" />

  <package id="System.Data.SQLite" version="1.0.110.0" targetFramework="net46" />

  <package id="System.Data.SQLite.Core" version="1.0.110.0" targetFramework="net46" />

  <package id="System.Data.SQLite.EF6" version="1.0.110.0" targetFramework="net46" />

  <package id="System.Data.SQLite.Linq" version="1.0.110.0" targetFramework="net46" />

</packages>

    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

      <section name="Converter.AutoModeling.SPPID.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />

    </sectionGroup>

  <userSettings>

    <Converter.AutoModeling.SPPID.Properties.Settings>

      <setting name="LatestProjectPath" serializeAs="String">

        <value />

      </setting>

    </Converter.AutoModeling.SPPID.Properties.Settings>

  </userSettings>

            CultureInfo culture = CultureInfo.GetCultureInfo("ko");

            InitID2Project();

            xtraFolderBrowserDialog.SelectedPath = btnID2Project.Text;

                if (xtraFolderBrowserDialog.SelectedPath[xtraFolderBrowserDialog.SelectedPath.Length - 1] == '\\')

                    xtraFolderBrowserDialog.SelectedPath = xtraFolderBrowserDialog.SelectedPath.Remove(xtraFolderBrowserDialog.SelectedPath.Length - 1);

                Settings.Default.LatestProjectPath = xtraFolderBrowserDialog.SelectedPath;

                Settings.Default.Save();

                if (InitID2Project())

                    MessageBox.Show(Msg.SuccessProjectSelect, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);

                else

        private bool InitID2Project()

            _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

            if (Project_DB.ConnTestAndCreateTable())

                _ProjectInfo.Enable = true;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

                InitSPPIDDB();

                return true;

                _ProjectInfo.Enable = false;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

                InitSPPIDDB();

                return false;

        private void InitSPPIDDB()

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectSPPID_DB_INFO();

                SPPIDUtil.ConvertToSPPIDInfo(dt.Rows[0][0].ToString());

            }

                InitSPPIDDB();

        public static bool CheckAndSetSPPIDInfo(SPPID_DBInfo dbInfo)

        public static bool SetPlantDBSetting(SPPID_DBInfo dbInfo)

        public static List<string> GetPlantList(SPPID_DBInfo dbInfo)

            this.btnCancel = new DevExpress.XtraEditors.SimpleButton();

            this.layoutControl1.Controls.Add(this.btnCancel);

            // btnCancel

            this.btnCancel.ImageOptions.SvgImage = global::Converter.AutoModeling.SPPID.Properties.Resources.close;

            this.btnCancel.Location = new System.Drawing.Point(202, 392);

            this.btnCancel.Name = "btnCancel";

            this.btnCancel.Size = new System.Drawing.Size(203, 36);

            this.btnCancel.StyleController = this.layoutControl1;

            this.btnCancel.TabIndex = 14;

            this.btnCancel.Text = "Cancel";

            this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);

            this.layoutControlItem11.Control = this.btnCancel;

        private DevExpress.XtraEditors.SimpleButton btnCancel;

using Converter.BaseModel;

        SPPID_DBInfo formDBInfo = new SPPID_DBInfo();

            SPPID_DBInfo info = SPPID_DBInfo.GetInstance();

            if (SetPlantList() && formDBInfo.PlantList.Contains(comboPlant.SelectedItem.ToString()))

                formDBInfo.SelectedPlant = comboPlant.SelectedItem.ToString();

                if (SPPID_DB.SetPlantDBSetting(formDBInfo))

                    formDBInfo.Enable = true;

                    string jsonString = JsonConvert.SerializeObject(formDBInfo);

                    if (Project_DB.SaveSPPID_DB_INFO(jsonString))

                    {

                        SPPIDUtil.ConvertToSPPIDInfo(jsonString);

                    }

                    else

                    {

                    }

                comboPlant.Properties.Items.AddRange(formDBInfo.PlantList);

                formDBInfo.Enable = false;

                formDBInfo.DBType = textBoxDBType.Text;

                formDBInfo.Service = textBoxServiceName.Text;

                formDBInfo.Site = textBoxSiteName.Text;

                formDBInfo.ServerIP = textBoxServerIP.Text;

                formDBInfo.Port = textBoxPort.Text;

                formDBInfo.DBUser = textBoxDBUser.Text;

                formDBInfo.DBPassword = textBoxDBPassword.Text;

                formDBInfo.PlantList = SPPID_DB.GetPlantList(formDBInfo);

                if (formDBInfo.PlantList.Count > 0)

        private void btnCancel_Click(object sender, EventArgs e)

        {

            DialogResult = DialogResult.Cancel;

        }

//------------------------------------------------------------------------------

// <auto-generated>

//     이 코드는 도구를 사용하여 생성되었습니다.

//     런타임 버전:4.0.30319.42000

//

//     파일 내용을 변경하면 잘못된 동작이 발생할 수 있으며, 코드를 다시 생성하면

//     이러한 변경 내용이 손실됩니다.

// </auto-generated>

//------------------------------------------------------------------------------

namespace Converter.AutoModeling.SPPID.Properties {

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "15.9.0.0")]

    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));

        public static Settings Default {

            get {

                return defaultInstance;

            }

        }

        [global::System.Configuration.UserScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.DefaultSettingValueAttribute("")]

        public string LatestProjectPath {

            get {

                return ((string)(this["LatestProjectPath"]));

            }

            set {

                this["LatestProjectPath"] = value;

            }

        }

    }

}

<?xml version='1.0' encoding='utf-8'?>

<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="Converter.AutoModeling.SPPID.Properties" GeneratedClassName="Settings">

  <Profiles />

  <Settings>

    <Setting Name="LatestProjectPath" Type="System.String" Scope="User">

      <Value Profile="(Default)" />

    </Setting>

  </Settings>

</SettingsFile>

    <OutputPath>..\SPPIDConverterDll\</OutputPath>

    <Compile Include="Properties\Settings.Designer.cs">

      <AutoGen>True</AutoGen>

      <DesignTimeSharedInput>True</DesignTimeSharedInput>

      <DependentUpon>Settings.settings</DependentUpon>

    </Compile>

    <Compile Include="Settings.cs" />

    <None Include="Properties\Settings.settings">

      <Generator>SettingsSingleFileGenerator</Generator>

      <LastGenOutput>Settings.Designer.cs</LastGenOutput>

    </None>

namespace Converter.AutoModeling.SPPID.Properties {

    // 이 클래스를 사용하여 설정 클래스에 대한 특정 이벤트를 처리할 수 있습니다.

    //  SettingChanging 이벤트는 설정 값이 변경되기 전에 발생합니다.

    //  PropertyChanged 이벤트는 설정 값이 변경된 후에 발생합니다.

    //  SettingsLoaded 이벤트는 설정 값이 로드된 후에 발생합니다.

    //  SettingsSaving 이벤트는 설정 값이 저장되기 전에 발생합니다.

    internal sealed partial class Settings {

        public Settings() {

            // // 설정을 저장 및 변경하기 위한 이벤트 처리기를 추가하려면 아래 줄에서 주석 처리를 제거하세요.

            //

            // this.SettingChanging += this.SettingChangingEventHandler;

            //

            // this.SettingsSaving += this.SettingsSavingEventHandler;

            //

        }

        private void SettingChangingEventHandler(object sender, System.Configuration.SettingChangingEventArgs e) {

            // SettingChangingEvent 이벤트를 처리하는 코드를 여기에 추가하세요.

        }

        private void SettingsSavingEventHandler(object sender, System.ComponentModel.CancelEventArgs e) {

            // SettingsSaving 이벤트를 처리하는 코드를 여기에 추가하세요.

        }

    }

}

        public static bool ConvertToSPPIDInfo(string jsonString)

                SPPID_DBInfo jsonSPPIDInfo = JsonConvert.DeserializeObject<SPPID_DBInfo>(jsonString);

                _SPPIDInfo.Enable = false;

    <OutputPath>..\SPPIDConverterDll\</OutputPath>