HYTOS

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 Microsoft.VisualBasic;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors;

using System.Globalization;

using System.Threading;

using System.IO;

using Ingr.RAD2D;

using Converter.BaseModel;

using Converter.SPPID.Properties;

using Converter.SPPID.DB;

using Converter.SPPID.Util;

using Converter.SPPID.Form;

using Converter.SPPID.Model;

using Plaice;

using Llama;

namespace Converter.SPPID

{

    public partial class ConverterForm : DevExpress.XtraBars.Ribbon.RibbonForm

    {

        private Dictionary<string, SPPID_Document> _DicDocuments = new Dictionary<string, SPPID_Document>();

        private List<SPPID_Document> _Documents = new List<SPPID_Document>();

        public List<SPPID_Document> Documents { get { return _Documents; } }

        private DataTable _ConverterDT = new DataTable();

        private DataTable _SPPIDSymbolPathDT = new DataTable();

        private DataTable _SPPIDUnitDT = new DataTable();

        private DataTable _SPPIDAttributeDT = new DataTable();

        private RepositoryItemComboBox templateComboBox;

        private RepositoryItemComboBox bulkRuleComboBox;

        private DataTable _ID2SymbolDT = new DataTable();

        private DataTable _ID2ChildSymbolDT = new DataTable();

        private DataTable _ID2LineDT = new DataTable();

        private DataTable _ID2AttributeDT = new DataTable();

        private DataTable _ID2DrawingAttributeDT = new DataTable();

        private DataTable _ID2LinePropertyDT = new DataTable();

        private DataTable _ID2SymbolTypeDT = new DataTable();

        private DataTable _ID2SymbolTable = new DataTable();

        private List<SymbolMapping> symbolMappings = new List<SymbolMapping>();

        private List<ChildSymbolMapping> childSymbolMappings = new List<ChildSymbolMapping>();

        private List<LineMapping> lineMappings = new List<LineMapping>();

        private List<LineNumberMapping> lineNumberMappings = new List<LineNumberMapping>();

        private List<AttributeMapping> attributeMappings = new List<AttributeMapping>();

        string TemplatePath;

        public ConverterForm()

        {

            InitializeComponent();

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

            Msg.Culture = culture;

            this._SPPIDUnitDT = SPPIDUtil.GetUnitInfo();

            TemplatePath = SPPIDUtil.T_OPTIONSETTING_Value("PID Template Path");

            InitUsedDataTable();

            InitGridControl();

            InitID2Project();

            //

            //labelID2ProjectName.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            //labelDBType.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            //labelID2ProjectStatus.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            //labelSPPIDPlantName.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            //labelSPPIDDBStatus.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            //labelItemMappingStatus.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

        }

        private void InitUsedDataTable()

        {

            // Converter Table

            DataColumn col = _ConverterDT.Columns.Add("colDrawingFileName");

            col.Caption = "Drawing File Name";

            col = _ConverterDT.Columns.Add("colDrawingFilePath");

            col.Caption = "DrawingFilePath";

            col = _ConverterDT.Columns.Add("colUnit");

            col.Caption = "Unit";

            col = _ConverterDT.Columns.Add("colTemplate");

            col.Caption = "Template";

            col = _ConverterDT.Columns.Add("colDrawingNumber");

            col.Caption = "Drawing Number";

            col = _ConverterDT.Columns.Add("colDrawingName");

            col.Caption = "Drawing Name";

            col = _ConverterDT.Columns.Add("colRuleName");

            col.Caption = "Bulk Rule Name";

            col = _ConverterDT.Columns.Add("colStatus");

            col.Caption = "Status";

            col = _ConverterDT.Columns.Add("colUID");

            col = _ID2LineDT.Columns.Add("UID");

            col = _ID2LineDT.Columns.Add("Name");

            col.Caption = "Name";

            col = _ID2LineDT.Columns.Add("Type");

            col.Caption = "Type";

            col = _ID2LineDT.Columns.Add("SPPID_SYMBOL_PATH");

            col.Caption = "SPPID Symbol Path";

            col = _ID2LineDT.Columns.Add("Clear");

            col.Caption = "";

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

            gridViewConverter.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;

            gridControlConverter.DataSource = _ConverterDT;

            templateComboBox = new RepositoryItemComboBox();

            templateComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            templateComboBox.EditValueChanged += templateComboBox_EditValueChanged;

            gridControlConverter.RepositoryItems.Add(templateComboBox);

            gridViewConverter.Columns["colTemplate"].ColumnEdit = templateComboBox;

            bulkRuleComboBox = new RepositoryItemComboBox();

            bulkRuleComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            bulkRuleComboBox.EditValueChanged += templateComboBox_EditValueChanged;

            gridControlConverter.RepositoryItems.Add(bulkRuleComboBox);

            gridViewConverter.Columns["colRuleName"].ColumnEdit = bulkRuleComboBox;

            gridViewConverter.Columns["colUnit"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colDrawingFileName"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colUnit"].OptionsColumn.ReadOnly = true;

            gridViewConverter.Columns["colStatus"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colDrawingFilePath"].Visible = false;

            gridViewConverter.Columns["colUID"].Visible = false;

            gridViewConverter.BestFitColumns();

            #endregion

        }

        private void templateComboBox_EditValueChanged(object sender, EventArgs e)

        {

            gridViewConverter.CloseEditor();

            gridViewConverter.UpdateCurrentRow();

        }

        private void gridViewConverter_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)

        {

            if (e.Column.Name == "colcolTemplate" || e.Column.Name == "colcolRuleName")

            {

                gridViewConverter.ShowEditor();

                (gridViewConverter.ActiveEditor as ComboBoxEdit).ShowPopup();

            }

            else if (e.Column.Name == "colcolUnit")

            {

                UnitForm unitForm = new UnitForm(_SPPIDUnitDT);

                if (unitForm.ShowDialog() == DialogResult.OK)

                {

                    gridViewConverter.SetRowCellValue(e.RowHandle, e.Column, unitForm.SelectedUnit);

                    gridViewConverter.CloseEditor();

                    gridViewConverter.UpdateCurrentRow();

                }

            }

        }

        private void btnID2DB_Click(object sender, EventArgs e)

        {

            ID2DBSetting form = new ID2DBSetting();

            DialogResult dialogResult = form.ShowDialog();

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            _ProjectInfo.DefaultPath = Settings.Default.ProjectPath;

            _ProjectInfo.DBType = (ID2DB_Type)Settings.Default.ProjectDBType;

            _ProjectInfo.ServerIP = Settings.Default.ProjectServerIP;

            _ProjectInfo.Port = Settings.Default.ProjectPort;

            _ProjectInfo.DBUser = Settings.Default.ProjectDBUser;

            _ProjectInfo.DBPassword = Settings.Default.ProjectDBPassword;

            if (dialogResult == DialogResult.OK)

            {

                if (InitID2Project())

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

                else

                    MessageBox.Show(Msg.FailProjectSelect, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

        }

        private bool InitID2Project()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (Project_DB.ConnTestAndCreateTable())

            {

                _ProjectInfo.Enable = true;

                labelDBType.Text = _ProjectInfo.DBType.ToString();

                labelDBType.AppearanceItemCaption.ForeColor = Color.Blue;

                labelID2ProjectName.Text = _ProjectInfo.Name;

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelID2ProjectStatus.Text = Msg.ConnectionSuccessful;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Blue;

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

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

            }

            else

            {

                _ProjectInfo.Enable = false;

                labelDBType.Text = " ";

                labelID2ProjectName.Text = " ";

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Red;

                labelID2ProjectStatus.Text = Msg.ConnectionFail;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Red;

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

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

            }

            InitMapping();

            InitSPPIDDB();

            return _ProjectInfo.Enable;

        }

        private void InitMapping()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                if (_ID2SymbolTable != null)

                {

                    _ID2SymbolTable.Dispose();

                    _ID2SymbolTable = null;

                }

                _ID2SymbolTable = Project_DB.SelectID2SymbolTable();

                if (_ID2SymbolTypeDT != null)

                {

                    _ID2SymbolTypeDT.Dispose();

                    _ID2SymbolTypeDT = null;

                }

                _ID2SymbolTypeDT = Project_DB.SelectSymbolType();

                InitID2Symbol();

                InitID2Line();

                InitID2LineNumber();

                InitID2Attribute();

                InitID2DrawingAttribute();

                InitETCSetting();

            }

        }

        private void InitETCSetting()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectSetting();

                foreach (DataRow item in dt.Rows)

                {

                    string settingType = item["SettingType"].ToString();

                    if (settingType == "ETCSetting")

                        SPPIDUtil.ConvertToETCSetting(item["JsonString"].ToString());

                    else if (settingType == "GridSetting")

                        SPPIDUtil.ConvertToGridSetting(item["JsonString"].ToString());

                }

            }

        }

        private void InitID2Symbol()

        {

            using (DataTable symbolDT = Project_DB.SelectProjectSymbol())

            {

                symbolMappings.Clear();

                _ID2SymbolDT = symbolDT;

                _ID2SymbolDT.Columns.Add("Clear");

                _ID2SymbolDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in symbolDT.Rows)

                {

                    symbolMappings.Add(new SymbolMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        SYMBOLNAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                        LEADERLINE = DBNull.Value.Equals(row["LEADERLINE"]) ? false : (bool)row["LEADERLINE"]

                    });

                }

                MergeID2ChildSymbol();

            }

        }

        private void MergeID2ChildSymbol()

        {

            using (DataTable childSymbolDT = Project_DB.SelectProjectChildSymbol())

            {

                childSymbolMappings.Clear();

                _ID2ChildSymbolDT = childSymbolDT;

                _ID2ChildSymbolDT.Columns.Add("Clear");

                _ID2ChildSymbolDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in childSymbolDT.Rows)

                {

                    childSymbolMappings.Add(new ChildSymbolMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        SYMBOLNAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

                _ID2SymbolDT.Merge(_ID2ChildSymbolDT);

            }

        }

        private void InitID2Line()

        {

            using (DataTable lineTypes = Project_DB.SelectProjectLine())

            {

                lineMappings.Clear();

                _ID2LineDT.Rows.Clear();

                foreach (DataRow row in lineTypes.Rows)

                {

                    DataRow newRow = _ID2LineDT.NewRow();

                    newRow["UID"] = row["UID"] == null ? "" : row["UID"].ToString();

                    newRow["Name"] = row["Name"] == null ? "" : row["Name"].ToString();

                    newRow["Type"] = "Line";

                    newRow["SPPID_SYMBOL_PATH"] = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString();

                    _ID2LineDT.Rows.Add(newRow);

                    lineMappings.Add(new LineMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        LINENAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

            }

        }

        private void InitID2LineNumber()

        {

            using (DataTable linePropertiesDT = Project_DB.SelectProjectLineProperties())

            {

                lineNumberMappings.Clear();

                _ID2LinePropertyDT = linePropertiesDT;

                _ID2LinePropertyDT.Columns.Add("Type");

                foreach (DataRow row in linePropertiesDT.Rows)

                {

                    row["Type"] = "Line Property";

                    lineNumberMappings.Add(new LineNumberMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayName = row["DisplayName"] == null ? "" : row["DisplayName"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString()

                    });

                }

            }

        }

        private void InitID2Attribute()

        {

            using (DataTable attributeDT = Project_DB.SelectProjectAttribute())

            {

                attributeMappings.Clear();

                _ID2AttributeDT = attributeDT;

                _ID2AttributeDT.Columns.Add("Clear");

                _ID2AttributeDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in attributeDT.Rows)

                {

                    attributeMappings.Add(new AttributeMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayAttribute = row["DisplayAttribute"] == null ? "" : row["DisplayAttribute"].ToString(),

                        Type = row["Type"] == null ? "" : row["Type"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                        Location = DBNull.Value.Equals(row["LOCATION"]) ? Model.Location.None : (Location)row["LOCATION"],

                        LeaderLine = DBNull.Value.Equals(row["LEADERLINE"]) ? false : (bool)row["LEADERLINE"],

                        IsText = DBNull.Value.Equals(row["ISTEXT"]) ? false : (bool)row["ISTEXT"]

                    });

                }

            }

        }

        private void InitID2DrawingAttribute()

        {

            using (DataTable drawingAttributeDT = Project_DB.SelectDrawingProjectAttribute())

            {

                _ID2DrawingAttributeDT = drawingAttributeDT;

            }

        }

        private void InitSPPIDDB()

        {

            buttonEditDefaultUnit.TextChanged -= new EventHandler(buttonEditDefaultUnit_TextChanged);

            comboBoxEditDefaultTemplate.SelectedIndexChanged -= new EventHandler(comboBoxEditDefaultTemplate_SelectedIndexChanged);

            comboBoxEditBulk.SelectedIndexChanged -= new System.EventHandler(this.comboBoxEditBulk_SelectedIndexChanged);

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectSPPID_DB_INFO();

                if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

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

                else

                    SPPID_DBInfo.Clear();

            }

            templateComboBox.Items.Clear();

            comboBoxEditDefaultTemplate.SelectedIndex = -1;

            comboBoxEditDefaultTemplate.Properties.Items.Clear();

            buttonEditDefaultUnit.Text = "";

            // Bulk Attribute

            RefreshBulkRule();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (_SPPIDInfo.Enable)

            {

                labelSPPIDPlantName.Text = _SPPIDInfo.SelectedPlant;

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelSPPIDDBStatus.Text = Msg.ConnectionSuccessful;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Blue;

                if (!string.IsNullOrEmpty(TemplatePath))

                {

                    List<string> templateFiles = Directory.GetFiles(TemplatePath, "*.pid").ToList().Select(filePath => Path.GetFileName(filePath)).ToList();

                    templateComboBox.Items.AddRange(templateFiles);

                    comboBoxEditDefaultTemplate.Properties.Items.AddRange(templateFiles);

                }

                if (_SPPIDAttributeDT != null)

                {

                    _SPPIDAttributeDT.Dispose();

                    _SPPIDAttributeDT = null;

                }

                _SPPIDAttributeDT = SPPID_DB.GetSPPIDAttribute();

                if (_SPPIDAttributeDT != null)

                {

                    _SPPIDAttributeDT.Columns["DISPLAYNAME"].ColumnName = "DISPLAY NAME";

                }

                if (!string.IsNullOrEmpty(Settings.Default.DefaultTemplate) && comboBoxEditDefaultTemplate.Properties.Items.Contains(Settings.Default.DefaultTemplate))

                    comboBoxEditDefaultTemplate.SelectedItem = Settings.Default.DefaultTemplate;

                if (!string.IsNullOrEmpty(Settings.Default.DefaultBulkRule) && comboBoxEditBulk.Properties.Items.Contains(Settings.Default.DefaultBulkRule))

                    comboBoxEditBulk.SelectedItem = Settings.Default.DefaultBulkRule;

                // Unit 있는지 없는지 검사 필요

                if (!string.IsNullOrEmpty(Settings.Default.DefaultUnit))

                    buttonEditDefaultUnit.Text = Settings.Default.DefaultUnit;

            }

            else

            {

                labelSPPIDPlantName.Text = " ";

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Red;

                labelSPPIDDBStatus.Text = Msg.ConnectionFail;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Red;

            }

            _DicDocuments.Clear();

            _ConverterDT.Rows.Clear();

            InitSPPIDSymbolTreeTable();

            buttonEditDefaultUnit.TextChanged += new EventHandler(buttonEditDefaultUnit_TextChanged);

            comboBoxEditDefaultTemplate.SelectedIndexChanged += new EventHandler(comboBoxEditDefaultTemplate_SelectedIndexChanged);

            comboBoxEditBulk.SelectedIndexChanged += new System.EventHandler(this.comboBoxEditBulk_SelectedIndexChanged);

        }

        private void InitSPPIDSymbolTreeTable()

        {

            try

            {

                _SPPIDSymbolPathDT = new DataTable();

                _SPPIDSymbolPathDT.Columns.Add("ID");

                _SPPIDSymbolPathDT.Columns.Add("Parent");

                _SPPIDSymbolPathDT.Columns.Add("Name");

                _SPPIDSymbolPathDT.Columns.Add("FullPath");

                string symbolPath = SPPIDUtil.T_OPTIONSETTING_Value("Catalog Explorer root path");

                DirectoryInfo info = new DirectoryInfo(symbolPath);

                _SPPIDSymbolPathDT.Rows.Add(new object[] { "0", "-1", info.Name });

                loop(info, "0", symbolPath);

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace);

            }

        }

        private void loop(DirectoryInfo parentInfo, string parentUID, string defaultPath)

        {

            DirectoryInfo[] infos = parentInfo.GetDirectories();

            foreach (DirectoryInfo info in infos)

            {

                string uid = Guid.NewGuid().ToString();

                _SPPIDSymbolPathDT.Rows.Add(new object[] { uid, parentUID, info.Name });

                loop(info, uid, defaultPath);

                FileInfo[] files = info.GetFiles("*.sym");

                foreach (FileInfo fileInfo in files)

                {

                    _SPPIDSymbolPathDT.Rows.Add(new object[] { Guid.NewGuid().ToString(), uid, fileInfo.Name, fileInfo.FullName.Replace(defaultPath, "") });

                }

            }

        }

        private void btnLoadFile_Click(object sender, EventArgs e)

        {

            List< BaseModel.Document> validationFailDocs = new List<BaseModel.Document>();

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (!_ProjectInfo.Enable || !_SPPIDInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            xtraOpenFileDialog.InitialDirectory = _ProjectInfo.TempDirPath;

            if (xtraOpenFileDialog.ShowDialog() == DialogResult.OK)

            {

                foreach (string fileName in xtraOpenFileDialog.FileNames)

                {

                    SPPID_Document document = new SPPID_Document(fileName, _ID2SymbolTypeDT);

                    document.SymbolTable = _ID2SymbolTable;

                    document.SymbolMappings = symbolMappings;

                    document.ChildSymbolMappings = childSymbolMappings;

                    document.LineMappings = lineMappings;

                    document.LineNumberMappings = lineNumberMappings;

                    document.AttributeMappings = attributeMappings;

                    document.ETCSetting = ETCSetting.GetInstance();

                    document.SetSPPIDInfo();

                    if (!document.SetSPPIDMapping())

                    {

                        document.Enable = false;

                        document.MappingValidation = false;

                    }

                    DataRow[] rows = _ConverterDT.Select(string.Format("colDrawingFilePath = '{0}'", fileName));

                    if (rows.Length == 0)

                    {

                        DataRow row = _ConverterDT.NewRow();

                        row["colDrawingFileName"] = Path.GetFileNameWithoutExtension(fileName);

                        row["colDrawingFilePath"] = fileName;

                        row["colDrawingNumber"] = document.DWGNAME;

                        row["colDrawingName"] = document.DWGNAME;

                        if (document.Enable)

                            row["colStatus"] = "Ready";

                        else

                            row["colStatus"] = "Error";

                        row["colUID"] = "";

                        if (comboBoxEditDefaultTemplate.SelectedIndex > -1)

                            row["colTemplate"] = comboBoxEditDefaultTemplate.SelectedItem;

                        if (comboBoxEditBulk.SelectedIndex > -1)

                            row["colRuleName"] = comboBoxEditBulk.SelectedItem;

                        if (!string.IsNullOrEmpty(buttonEditDefaultUnit.Text))

                            row["colUnit"] = buttonEditDefaultUnit.Text;

                        _ConverterDT.Rows.Add(row);

                        if (document.Enable && document.Validation && document.MappingValidation)

                            gridViewConverter.SelectRow(gridViewConverter.GetRowHandle(_ConverterDT.Rows.IndexOf(row)));

                    }

                    else

                    {

                        foreach (DataRow row in rows)

                        {

                            if (document.Enable)

                                row["colStatus"] = "Ready";

                            else

                                row["colStatus"] = "Error";

                            if (comboBoxEditDefaultTemplate.SelectedIndex > -1)

                                row["colTemplate"] = comboBoxEditDefaultTemplate.SelectedItem;

                            if (comboBoxEditBulk.SelectedIndex > -1)

                                row["colRuleName"] = comboBoxEditBulk.SelectedItem;

                            if (!string.IsNullOrEmpty(buttonEditDefaultUnit.Text))

                                row["colUnit"] = buttonEditDefaultUnit.Text;

                            if (document.Enable && document.Validation && document.MappingValidation)

                                gridViewConverter.SelectRow(gridViewConverter.GetRowHandle(_ConverterDT.Rows.IndexOf(row)));

                        }

                    }

                    if (!_DicDocuments.ContainsKey(fileName))

                        _DicDocuments.Add(fileName, null);

                    if (!document.Validation || !document.MappingValidation)

                        validationFailDocs.Add(document);

                    _DicDocuments[fileName] = document;

                }

                if (validationFailDocs.Count > 0)

                {

                    MessageForm messageForm = new MessageForm(validationFailDocs);

                    messageForm.ShowDialog();

                }

            }

        }

        /// <summary>

        /// 선택한 도면의 정보를 로딩한다

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnRun_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (!_ProjectInfo.Enable || !_SPPIDInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            if (gridViewConverter.GetSelectedRows().Length == 0)

            {

                MessageBox.Show(Msg.SelectDocument, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            DataTable tDrawing = Project_DB.SelectDrawings();

            this._Documents.Clear();

            foreach (int rowHandle in gridViewConverter.GetSelectedRows())

            {

                string _FilePath = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingFilePath");

                string _Unit = gridViewConverter.GetRowCellDisplayText(rowHandle, "colUnit");

                string _Template = gridViewConverter.GetRowCellDisplayText(rowHandle, "colTemplate");

                string _DrawingNumber = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingNumber");

                string _DrawingName = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingName");

                string _RuleName = gridViewConverter.GetRowCellDisplayText(rowHandle, "colRuleName");

                DataRow[] rows = tDrawing.Select(string.Format("NAME = '{0}'", Path.GetFileNameWithoutExtension(_FilePath) + ".png"));

                if (rows.Length != 1)

                    continue;

                SPPID_Document document = _DicDocuments[_FilePath];

                document.Unit = _Unit;

                document.Template = _Template;

                document.DrawingNumber = _DrawingNumber;

                document.DrawingName = _DrawingName;

                document.UID = rows[0]["UID"].ToString();

                document.BulkAttributeName = _RuleName;

                document.SymbolTable = _ID2SymbolTable;

                document.SymbolMappings = symbolMappings;

                document.ChildSymbolMappings = childSymbolMappings;

                document.LineMappings = lineMappings;

                document.LineNumberMappings = lineNumberMappings;

                document.AttributeMappings = attributeMappings;

                document.ETCSetting = ETCSetting.GetInstance();

                document.SetSPPIDInfo();

                if (document.SetSPPIDMapping() && document.Enable)

                    this._Documents.Add(document);

            }

            if (_Documents.Count > 50)

                checkEditCloseDocument.Checked = true;

            tDrawing.Dispose();

            DialogResult = DialogResult.OK;

        }

        private void btnSPPIDDB_Click(object sender, EventArgs e)

        {

            SPPID_DB_SettingForm form = new SPPID_DB_SettingForm();

            if (form.ShowDialog() == DialogResult.OK)

                InitSPPIDDB();

        }

        private void btnItemMapping_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (!_ProjectInfo.Enable || !_SPPIDInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            MappingForm form = new MappingForm(_ID2SymbolDT,_SPPIDSymbolPathDT, _ID2LineDT, _ID2LinePropertyDT, _ID2AttributeDT, _SPPIDAttributeDT, _ID2DrawingAttributeDT);

            form.ShowDialog();

            InitMapping();

            RefreshBulkRule();

        }

        private List<int> prevSelectedList = new List<int>();

        private void gridViewConverter_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e)

        {

            if (e.Action == CollectionChangeAction.Add)

            {

                string _Unit = gridViewConverter.GetRowCellDisplayText(e.ControllerRow, "colUnit");

                string _Template = gridViewConverter.GetRowCellDisplayText(e.ControllerRow, "colTemplate");

                if (string.IsNullOrEmpty(_Unit) || string.IsNullOrEmpty(_Template))

                    gridViewConverter.UnselectRow(e.ControllerRow);

            }

            else if (e.Action == CollectionChangeAction.Refresh)

            {

                foreach (int rowHandle in gridViewConverter.GetSelectedRows())

                {

                    string _Unit = gridViewConverter.GetRowCellDisplayText(rowHandle, "colUnit");

                    string _Template = gridViewConverter.GetRowCellDisplayText(rowHandle, "colTemplate");

                    if (string.IsNullOrEmpty(_Unit) || string.IsNullOrEmpty(_Template))

                        gridViewConverter.UnselectRow(rowHandle);

                }

                List<int> selectedRowHandleList = gridViewConverter.GetSelectedRows().ToList();

                var firstNotSecond = prevSelectedList.Except(selectedRowHandleList).ToList();

                var secondNotFirst = selectedRowHandleList.Except(prevSelectedList).ToList();

                if (!firstNotSecond.Any() && !secondNotFirst.Any())

                {

                    this.gridViewConverter.SelectionChanged -= new DevExpress.Data.SelectionChangedEventHandler(this.gridViewConverter_SelectionChanged);

                    gridViewConverter.ClearSelection();

                    this.gridViewConverter.SelectionChanged += new DevExpress.Data.SelectionChangedEventHandler(this.gridViewConverter_SelectionChanged);

                }

            }

            prevSelectedList = gridViewConverter.GetSelectedRows().ToList();

        }

        private void buttonEditDefaulUnit_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            UnitForm unitForm = new UnitForm(_SPPIDUnitDT);

            if (unitForm.ShowDialog() == DialogResult.OK)

            {

                buttonEditDefaultUnit.Text = unitForm.SelectedUnit;

            }

        }

        private void btnRefresh_Click(object sender, EventArgs e)

        {

            List<BaseModel.Document> validationFailDocs = new List<BaseModel.Document>();

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (!_ProjectInfo.Enable || !_SPPIDInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            foreach (DataRow row in _ConverterDT.Rows)

            {

                string fileName = row["colDrawingFilePath"].ToString();

                SPPID_Document document = new SPPID_Document(fileName, _ID2SymbolTypeDT);

                document.SymbolTable = _ID2SymbolTable;

                document.SymbolMappings = symbolMappings;

                document.ChildSymbolMappings = childSymbolMappings;

                document.LineMappings = lineMappings;

                document.LineNumberMappings = lineNumberMappings;

                document.AttributeMappings = attributeMappings;

                document.ETCSetting = ETCSetting.GetInstance();

                document.SetSPPIDInfo();

                if (!document.SetSPPIDMapping())

                {

                    document.Enable = false;

                    document.MappingValidation = false;

                }

                row["colDrawingNumber"] = document.DWGNAME;

                row["colDrawingName"] = document.DWGNAME;

                if (document.Enable)

                    row["colStatus"] = "Ready";

                else

                    row["colStatus"] = "Error";

                if (!_DicDocuments.ContainsKey(fileName))

                    _DicDocuments.Add(fileName, null);

                if (!document.Validation || !document.MappingValidation)

                    validationFailDocs.Add(document);

                _DicDocuments[fileName] = document;

                if (document.Enable && document.Validation && document.MappingValidation)

                    gridViewConverter.SelectRow(gridViewConverter.GetRowHandle(_ConverterDT.Rows.IndexOf(row)));

            }

            if (validationFailDocs.Count > 0)

            {

                MessageForm messageForm = new MessageForm(validationFailDocs);

                messageForm.ShowDialog();

            }

        }

        private void buttonEditDefaultUnit_TextChanged(object sender, EventArgs e)

        {

            Settings.Default.DefaultUnit = buttonEditDefaultUnit.Text;

            Settings.Default.Save();

        }

        private void comboBoxEditDefaultTemplate_SelectedIndexChanged(object sender, EventArgs e)

        {

            Settings.Default.DefaultTemplate = comboBoxEditDefaultTemplate.SelectedItem.ToString();

            Settings.Default.Save();

        }

        private void comboBoxEditBulk_SelectedIndexChanged(object sender, EventArgs e)

        {

            Settings.Default.DefaultBulkRule = comboBoxEditBulk.SelectedItem.ToString();

            Settings.Default.Save();

        }

        private void RefreshBulkRule()

        {

            ETCSetting eTCSetting = ETCSetting.GetInstance();

            bulkRuleComboBox.Items.Clear();

            bulkRuleComboBox.Items.Add("");

            foreach (var item in eTCSetting.BulkAttributes)

                if (!bulkRuleComboBox.Items.Contains(item.RuleName))

                    bulkRuleComboBox.Items.Add(item.RuleName);

            for (int i = 0; i < gridViewConverter.DataRowCount; i++)

            {

                DataRow row = gridViewConverter.GetDataRow(i);

                object data = row["colRuleName"];

                if (data != null && !DBNull.Value.Equals(data))

                {

                    string sData = data.ToString();

                    if (eTCSetting.BulkAttributes.Find(x => x.RuleName.Equals(sData)) == null)

                        row["colRuleName"] = string.Empty;

                }

            }

            comboBoxEditBulk.Properties.Items.Clear();

            comboBoxEditBulk.Properties.Items.Add("");

            foreach (var item in eTCSetting.BulkAttributes)

                if (!comboBoxEditBulk.Properties.Items.Contains(item.RuleName))

                    comboBoxEditBulk.Properties.Items.Add(item.RuleName);

            if (eTCSetting.BulkAttributes.Find(x => x.RuleName.Equals(comboBoxEditBulk.Text)) == null)

                comboBoxEditBulk.SelectedIndex = 0;

        }

    }

}