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 DevExpress.XtraEditors.Repository;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors;

using System.Globalization;

using System.Threading;

using System.IO;

using AVEVA.PID.CustomizationUtility.DB;

using AVEVA.PID.CustomizationUtility.Model;

using AVEVA.PID.CustomizationUtility.Properties;

namespace AVEVA.PID.CustomizationUtility

{

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

    {

        public APIDConverter()

        {

            InitializeComponent();

            InitUsedDataTable();

            InitGridControl();

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

        }

        DataTable ID2SymbolTypeTable = null;

        private DataTable _ConverterDT = new DataTable();

        public List<Document> Documents = new List<Document>();

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

        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("colTemplate");

            col.Caption = "Template";

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

            col.Caption = "Drawing Number";

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

            col.Caption = "Sheet Number";

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

            col.Caption = "Status";

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

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

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

            gridControlConverter.DataSource = _ConverterDT;

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

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

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

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

            gridViewConverter.BestFitColumns();

            #endregion

            #region set lookUpEdit

            DataTable templateTable = Project_DB.GetDrawingTemplate();

            RepositoryItemGridLookUpEdit lookUpEdit = new RepositoryItemGridLookUpEdit();

            lookUpEdit.BeginInit();

            lookUpEdit.DataSource = templateTable;

            lookUpEdit.DisplayMember = "Name";

            lookUpEdit.ValueMember = "ID";

            lookUpEdit.NullText = "";

            lookUpEdit.BestFitMode = BestFitMode.BestFitResizePopup;

            lookUpEdit.EndInit();

            lookUpEdit.View.OptionsBehavior.AutoPopulateColumns = false;

            DevExpress.XtraGrid.Columns.GridColumn colName = lookUpEdit.View.Columns.AddField("Name");

            colName.VisibleIndex = 0;

            DevExpress.XtraGrid.Columns.GridColumn colDate = lookUpEdit.View.Columns.AddField("DateCreation");

            colDate.VisibleIndex = 1;

            DevExpress.XtraGrid.Columns.GridColumn colMachineName = lookUpEdit.View.Columns.AddField("MachineName");

            colMachineName.VisibleIndex = 2;

            gridControlConverter.RepositoryItems.Add(lookUpEdit);

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

            #endregion

        }

        private void btnLoadFile_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            OpenFileDialog dia = new OpenFileDialog();

            dia.Filter = "Xml Files(*.xml)|*.xml";

            dia.InitialDirectory = _ProjectInfo.TempDirPath;

            dia.Multiselect = true;

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

            {

                DataTable drawingTable = Project_DB.SelectDrawingTable();

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

                DataTable symbolMappingTable = Project_DB.GetSymbolMappingTable();

                DataTable lineMappingTable = Project_DB.GetLineMappingTable();

                DataTable opcMappingTable = Project_DB.GetOPCMappingTable();

                foreach (var fileName in dia.FileNames)

                {

                    Document document = new Document(fileName, ID2SymbolTypeTable);

                    if (!document.SetAvevaInfo(symbolMappingTable, lineMappingTable, opcMappingTable))

                    {

                        validationFailDocs.Add(document);

                        document.Enable = false;

                    }

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

                    if (rows.Length == 0)

                    {

                        DataRow row = _ConverterDT.NewRow();

                        string drawingName = Path.GetFileNameWithoutExtension(fileName);

                        row["colDrawingFileName"] = drawingName;

                        row["colDrawingFilePath"] = fileName;

                        if (document.Enable)

                            row["colStatus"] = "Ready";

                        else

                            row["colStatus"] = "Error";

                        row["colUID"] = "";

                        row["colDrawingNumber"] = drawingName;

                        row["colSheetNumber"] = GetSheetNumber(drawingTable, drawingName);

                        _ConverterDT.Rows.Add(row);

                        if (document.Enable)

                            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 (document.Enable)

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

                        }

                    }

                    // validation check

                    if (!_DicDocuments.ContainsKey(fileName))

                        _DicDocuments.Add(fileName, null);

                    _DicDocuments[fileName] = document;

                }

                symbolMappingTable.Dispose();

                lineMappingTable.Dispose();

                opcMappingTable.Dispose();

                if (validationFailDocs.Count > 0)

                {

                    MessageForm messageForm = new MessageForm(validationFailDocs);

                    messageForm.ShowDialog();

                }

            }

        }

        private string GetSheetNumber(DataTable drawingTable, string drawingName)

        {

            string result = string.Empty;

            List<DataRow> rows = drawingTable.Select(string.Format("XDNLABEL = '{0}'", drawingName)).ToList();

            if (rows.Count != 0)

            {

                int index = 1;

                while (true)

                {

                    DataRow row = rows.Find(x => !DBNull.Value.Equals(x["XDSLABEL"]) && x["XDSLABEL"].ToString() == index.ToString());

                    if (row == null)

                    {

                        result = index.ToString();

                        break;

                    }

                    index++;

                }    

            }

            return result;

        }

        private void APIDConverter_Load(object sender, EventArgs e)

        {

            Project_Info project = Project_Info.GetInstance();

            if (!project.Enable)

            {

                MessageBox.Show("Check Project Setting!", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                //DialogResult = DialogResult.Cancel;

            }

            else

            {

                ID2SymbolTypeTable = Project_DB.GetSymbolType();

            }

        }

        private void btnRun_Click(object sender, EventArgs e)

        {

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

            {

                MessageBox.Show("Select Document", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

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

            DataTable symbolMappingTable = Project_DB.GetSymbolMappingTable();

            DataTable lineMappingTable = Project_DB.GetLineMappingTable();

            DataTable opcMappingTable = Project_DB.GetOPCMappingTable();

            DataTable tDrawing = Project_DB.GetDrawings();

            Documents.Clear();

            foreach (int rowHandle in gridViewConverter.GetSelectedRows())

            {

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

                string _ID = gridViewConverter.GetRowCellValue(rowHandle, "colTemplate").ToString();

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

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

                string _SheetNumber = gridViewConverter.GetRowCellDisplayText(rowHandle, "colSheetNumber");

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

                if (rows.Length != 1)

                    continue;

                Document document = _DicDocuments[_FilePath];

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

                document.AvevaDrawingNumber = _DrawingNumber;

                document.AvevaSheetNumber = _SheetNumber;

                document.AvevaTemplateID = _ID;

                document.AvevaTemplateName = _TemplateName;

                // validation check

                if (document.SetAvevaInfo(symbolMappingTable, lineMappingTable, opcMappingTable))

                    Documents.Add(document);

                else

                    validationFailDocs.Add(document);

            }

            symbolMappingTable.Dispose();

            lineMappingTable.Dispose();

            opcMappingTable.Dispose();

            if (validationFailDocs.Count > 0)

            {

                MessageForm messageForm = new MessageForm(validationFailDocs);

                messageForm.ShowDialog();

            }

            else if (Documents.Count > 0)

            {

                DialogResult = DialogResult.OK;

            }

            else

            {

            }

        }

        private void btnRefresh_Click(object sender, EventArgs e)

        {

            foreach (DataRow row in _ConverterDT.Rows)

            {

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

                Document document = new Document(fileName, ID2SymbolTypeTable);

                if (document.Enable)

                    row["colStatus"] = "Ready";

                else

                    row["colStatus"] = "Error";

                if (!_DicDocuments.ContainsKey(fileName))

                    _DicDocuments.Add(fileName, null);

                _DicDocuments[fileName] = document;

                if (document.Enable)

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

            }

        }

        private void btnID2DB_Click(object sender, EventArgs e)

        {

            ProjectForm form = new ProjectForm();

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

            {

                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 (Project_DB.ConnTestAndCreateTable())

                {

                    _ProjectInfo.Enable = true;

                    MessageBox.Show("Success project setting", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Information);

                }

                else

                {

                    _ProjectInfo.Enable = false;

                    MessageBox.Show("Fail project setting", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Error);

                }

            }

        }

        private void btnItemMapping_Click(object sender, EventArgs e)

        {

            Project_Info project = Project_Info.GetInstance();

            if (!project.Enable)

            {

                MessageBox.Show("Check Project Setting!", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

            else

            {

                MappingForm form = new MappingForm();

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

                {

                }

            }

        }

    }

}