HYTOS

        public static DataTable SelectStandardSymbolTable()

                    cmd.CommandText = string.Format(@"

                    SELECT ss.ID, ss.Symbol_Name, sps.Relative_Path FROM {0} as ss

                    LEFT OUTER JOIN {1} as sps

                    ON ss.Relative_Path = sps.ID

                    ORDER BY sps.ID ASC

                    ;", "stdSymbols", "StdPrjFolStructure");

                    using (SqlDataReader dr = cmd.ExecuteReader())

                        dt.Load(dr);

                }

                connection.Close();

            }

            return dt;

        }

        public static DataTable SelectStandardSymbolStructureTable()

        {

            DataTable dt = new DataTable();

            using (SqlConnection connection = new SqlConnection())

            {

                connection.ConnectionString = GetAvevaConnectionString_Admin();

                connection.Open();

                using (SqlCommand cmd = connection.CreateCommand())

                {

                    cmd.CommandText = string.Format(@"

                    SELECT * FROM {0}

                    ;", "StdPrjFolStructure");

                    using (SqlDataReader dr = cmd.ExecuteReader())

                        dt.Load(dr);

                }

                connection.Close();

            }

            return dt;

        }

        public static DataTable SelectStandardSymbolImageTable()

        {

            DataTable dt = new DataTable();

            using (SqlConnection connection = new SqlConnection())

            {

                connection.ConnectionString = GetAvevaConnectionString_Admin();

                connection.Open();

                using (SqlCommand cmd = connection.CreateCommand())

                {

                    cmd.CommandText = string.Format(@"

                    SELECT ss.Symbol_Name, ss.Pic_Binary, sps.Relative_Path FROM {0} as ss

                    LEFT OUTER JOIN {1} as sps

                    ON ss.Relative_Path = sps.ID

                    ORDER BY sps.ID ASC

                    ;", "stdSymbols", "StdPrjFolStructure");

            DevExpress.XtraBars.Ribbon.GalleryItemGroup galleryItemGroup1 = new DevExpress.XtraBars.Ribbon.GalleryItemGroup();

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

            this.galleryControlAvevaSymbols = new DevExpress.XtraBars.Ribbon.GalleryControl();

            this.galleryControlClient1 = new DevExpress.XtraBars.Ribbon.GalleryControlClient();

            this.pictureEditMapped = new DevExpress.XtraEditors.PictureEdit();

            this.pictureEditID2Symbol = new DevExpress.XtraEditors.PictureEdit();

            this.treeListAvevaSymbol = new DevExpress.XtraTreeList.TreeList();

            this.layoutControlItem8 = new DevExpress.XtraLayout.LayoutControlItem();

            ((System.ComponentModel.ISupportInitialize)(this.galleryControlAvevaSymbols)).BeginInit();

            this.galleryControlAvevaSymbols.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.pictureEditMapped.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.pictureEditID2Symbol.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.treeListAvevaSymbol)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem8)).BeginInit();

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

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

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

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

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

            // btnRefreshSymbol

            this.btnRefreshSymbol.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnRefreshSymbol.ImageOptions.SvgImage")));

            this.btnRefreshSymbol.Location = new System.Drawing.Point(783, 642);

            this.btnRefreshSymbol.Name = "btnRefreshSymbol";

            this.btnRefreshSymbol.Size = new System.Drawing.Size(328, 36);

            this.btnRefreshSymbol.StyleController = this.layoutControl1;

            this.btnRefreshSymbol.TabIndex = 12;

            this.btnRefreshSymbol.Text = "Refresh AVEVA Symbol Image";

            this.btnRefreshSymbol.Click += new System.EventHandler(this.btnRefreshSymbol_Click);

            // galleryControlAvevaSymbols

            this.galleryControlAvevaSymbols.Controls.Add(this.galleryControlClient1);

            galleryItemGroup1.Caption = "Items";

            this.galleryControlAvevaSymbols.Gallery.Groups.AddRange(new DevExpress.XtraBars.Ribbon.GalleryItemGroup[] {

            galleryItemGroup1});

            this.galleryControlAvevaSymbols.Location = new System.Drawing.Point(795, 357);

            this.galleryControlAvevaSymbols.Name = "galleryControlAvevaSymbols";

            this.galleryControlAvevaSymbols.Size = new System.Drawing.Size(304, 269);

            this.galleryControlAvevaSymbols.StyleController = this.layoutControl1;

            this.galleryControlAvevaSymbols.TabIndex = 11;

            this.galleryControlAvevaSymbols.Text = "galleryControl1";

            // galleryControlClient1

            // 

            this.galleryControlClient1.GalleryControl = this.galleryControlAvevaSymbols;

            this.galleryControlClient1.Location = new System.Drawing.Point(2, 2);

            this.galleryControlClient1.Size = new System.Drawing.Size(283, 265);

            // 

            // pictureEditMapped

            // 

            this.pictureEditMapped.Location = new System.Drawing.Point(412, 399);

            this.pictureEditMapped.MenuManager = this.ribbonControl;

            this.pictureEditMapped.Name = "pictureEditMapped";

            this.pictureEditMapped.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;

            this.pictureEditMapped.Size = new System.Drawing.Size(333, 255);

            this.pictureEditMapped.StyleController = this.layoutControl1;

            this.pictureEditMapped.TabIndex = 10;

            // 

            // pictureEditID2Symbol

            // 

            this.pictureEditID2Symbol.Location = new System.Drawing.Point(36, 399);

            this.pictureEditID2Symbol.MenuManager = this.ribbonControl;

            this.pictureEditID2Symbol.Name = "pictureEditID2Symbol";

            this.pictureEditID2Symbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;

            this.pictureEditID2Symbol.Size = new System.Drawing.Size(338, 255);

            this.pictureEditID2Symbol.StyleController = this.layoutControl1;

            this.pictureEditID2Symbol.TabIndex = 9;

            // 

            // treeListAvevaSymbol

            // 

            this.treeListAvevaSymbol.Cursor = System.Windows.Forms.Cursors.Default;

            this.treeListAvevaSymbol.Location = new System.Drawing.Point(795, 45);

            this.treeListAvevaSymbol.Name = "treeListAvevaSymbol";

            this.treeListAvevaSymbol.Size = new System.Drawing.Size(304, 253);

            this.treeListAvevaSymbol.TabIndex = 8;

            this.gridControlSymbol.Size = new System.Drawing.Size(709, 261);

            this.btnClose.Location = new System.Drawing.Point(1025, 682);

            this.btnClose.Size = new System.Drawing.Size(86, 36);

            this.btnSave.Location = new System.Drawing.Point(927, 682);

            this.btnSave.Size = new System.Drawing.Size(84, 36);

            this.splitterItem4,

            this.layoutControlItem8});

            this.emptySpaceItem1.MinSize = new System.Drawing.Size(104, 24);

            this.emptySpaceItem1.Size = new System.Drawing.Size(915, 40);

            this.emptySpaceItem1.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.tabbedControlGroup1.Size = new System.Drawing.Size(761, 670);

            this.layoutControlGroup1.Size = new System.Drawing.Size(737, 624);

            this.splitterItem2.Size = new System.Drawing.Size(737, 10);

            this.splitterItem3.Location = new System.Drawing.Point(366, 320);

            this.layoutControlGroup4.Size = new System.Drawing.Size(366, 304);

            this.layoutControlItem5.Control = this.pictureEditID2Symbol;

            this.layoutControlItem5.Size = new System.Drawing.Size(342, 259);

            this.layoutControlGroup5.Location = new System.Drawing.Point(376, 320);

            this.layoutControlGroup5.Size = new System.Drawing.Size(361, 304);

            this.layoutControlItem6.Control = this.pictureEditMapped;

            this.layoutControlItem6.Size = new System.Drawing.Size(337, 259);

            this.layoutControlGroup7.Size = new System.Drawing.Size(737, 310);

            this.layoutControlItem4.Size = new System.Drawing.Size(713, 265);

            this.layoutControlGroup2.Size = new System.Drawing.Size(737, 624);

            this.layoutControlItem2.Location = new System.Drawing.Point(915, 670);

            this.layoutControlItem2.MaxSize = new System.Drawing.Size(88, 40);

            this.layoutControlItem2.MinSize = new System.Drawing.Size(88, 40);

            this.layoutControlItem2.Size = new System.Drawing.Size(88, 40);

            this.layoutControlItem2.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.layoutControlItem3.Location = new System.Drawing.Point(1013, 670);

            this.layoutControlItem3.MaxSize = new System.Drawing.Size(90, 40);

            this.layoutControlItem3.MinSize = new System.Drawing.Size(90, 40);

            this.layoutControlItem3.Size = new System.Drawing.Size(90, 40);

            this.layoutControlItem3.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.splitterItem1.Location = new System.Drawing.Point(761, 0);

            this.layoutControlGroup3.Location = new System.Drawing.Point(771, 0);

            this.layoutControlGroup3.Size = new System.Drawing.Size(332, 302);

            this.layoutControlGroup3.Text = "Aveva Symbol Structure";

            this.layoutControlItem1.Control = this.treeListAvevaSymbol;

            this.layoutControlItem1.Size = new System.Drawing.Size(308, 257);

            this.emptySpaceItem2.Location = new System.Drawing.Point(1003, 670);

            this.emptySpaceItem2.MaxSize = new System.Drawing.Size(10, 40);

            this.emptySpaceItem2.MinSize = new System.Drawing.Size(10, 40);

            this.emptySpaceItem2.Size = new System.Drawing.Size(10, 40);

            this.emptySpaceItem2.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.layoutControlGroup6.Location = new System.Drawing.Point(771, 312);

            this.layoutControlGroup6.Size = new System.Drawing.Size(332, 318);

            this.layoutControlGroup6.Text = "Aveva Symbols";

            this.layoutControlItem7.Control = this.galleryControlAvevaSymbols;

            this.layoutControlItem7.Size = new System.Drawing.Size(308, 273);

            this.splitterItem4.Location = new System.Drawing.Point(771, 302);

            this.splitterItem4.Size = new System.Drawing.Size(332, 10);

            // 

            // layoutControlItem8

            // 

            this.layoutControlItem8.Control = this.btnRefreshSymbol;

            this.layoutControlItem8.Location = new System.Drawing.Point(771, 630);

            this.layoutControlItem8.Name = "layoutControlItem8";

            this.layoutControlItem8.Size = new System.Drawing.Size(332, 40);

            this.layoutControlItem8.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem8.TextVisible = false;

            ((System.ComponentModel.ISupportInitialize)(this.galleryControlAvevaSymbols)).EndInit();

            this.galleryControlAvevaSymbols.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.pictureEditMapped.Properties)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.pictureEditID2Symbol.Properties)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.treeListAvevaSymbol)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem8)).EndInit();

        private DevExpress.XtraTreeList.TreeList treeListAvevaSymbol;

        private DevExpress.XtraEditors.PictureEdit pictureEditMapped;

        private DevExpress.XtraEditors.PictureEdit pictureEditID2Symbol;

        private DevExpress.XtraBars.Ribbon.GalleryControl galleryControlAvevaSymbols;

        private DevExpress.XtraBars.Ribbon.GalleryControlClient galleryControlClient1;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraEditors.SimpleButton btnRefreshSymbol;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem8;

using System.IO;

using AVEVA.PID.Utilities;

            SetAvevaSymbolStructure();

            gridViewSymbol.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(gridViewSymbol_FocusedRowChanged);

            treeListAvevaSymbol.FocusedNodeChanged += new FocusedNodeChangedEventHandler(treeListAvevaSymbol_FocusedNodeChanged);

            galleryControlAvevaSymbols.Gallery.ItemSize = new System.Drawing.Size(32, 32);

            galleryControlAvevaSymbols.Gallery.ShowItemImage = true;

            galleryControlAvevaSymbols.Gallery.ShowItemText = true;

        #region Init

        private void SetAvevaSymbolStructure()

        {

            DataTable stdStructure = Project_DB.SelectStandardSymbolStructureTable();

            DataTable symbolTable = new DataTable();

            symbolTable.Columns.Add("ID1", typeof(string));

            symbolTable.Columns.Add("ID2", typeof(string));

            symbolTable.Columns.Add("Name", typeof(string));

            symbolTable.Rows.Add("STANDARD", null, "Standard");

            foreach (DataRow row in stdStructure.Rows)

            {

                string path = row["Relative_Path"].ToString();

                string[] split = path.Split(new char[] { '\\' });

                string prevID = null;

                for (int i = 0; i < split.Length; i++)

                {

                    string splitName = split[i];

                    if (i == 0)

                    {

                        DataRow[] rows = symbolTable.Select(string.Format("Name = '{0}' AND ID2 = 'STANDARD'", splitName));

                        if (rows.Length == 0)

                        {

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

                            symbolTable.Rows.Add(newID, "STANDARD", splitName);

                            prevID = newID;

                        }

                        else

                            prevID = rows[0]["ID1"].ToString();

                    }

                    else

                    {

                        DataRow[] rows = symbolTable.Select(string.Format("Name = '{0}' AND ID2 = '{1}'", splitName, prevID));

                        if (rows.Length == 0)

                        {

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

                            symbolTable.Rows.Add(newID, prevID, splitName);

                            prevID = newID;

                        }

                        else

                            prevID = rows[0]["ID1"].ToString();

                    }

                }

            }

            treeListAvevaSymbol.DataSource = symbolTable;

            treeListAvevaSymbol.KeyFieldName = "ID1";

            treeListAvevaSymbol.ParentFieldName = "ID2";

            treeListAvevaSymbol.OptionsView.ShowIndicator = false;

            treeListAvevaSymbol.OptionsView.ShowColumns = false;

            treeListAvevaSymbol.OptionsView.ShowHorzLines = false;

            treeListAvevaSymbol.OptionsView.ShowVertLines = false;

            treeListAvevaSymbol.OptionsView.FocusRectStyle = DrawFocusRectStyle.CellFocus;

            treeListAvevaSymbol.OptionsBehavior.Editable = false;

            treeListAvevaSymbol.ExpandToLevel(0);

            stdStructure.Dispose();

        }

        #endregion

        private void gridViewSymbol_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)

        {

            if (pictureEditID2Symbol.Image != null)

                pictureEditID2Symbol.Image.Dispose();

            pictureEditID2Symbol.Image = null;

            if (e.FocusedRowHandle >= 0)

            {

                Project_Info info = Project_Info.GetInstance();

                string _Type = gridViewSymbol.GetRowCellDisplayText(e.FocusedRowHandle, "Type");

                string _Name = gridViewSymbol.GetRowCellDisplayText(e.FocusedRowHandle, "Name");

                string _ImagePath = string.Format(@"{0}{1}\{2}.png", info.ImageDirPath, _Type, _Name);

                string _MappedPath = gridViewSymbol.GetRowCellDisplayText(e.FocusedRowHandle, "APID_SYMBOL");

                if (File.Exists(_ImagePath))

                    pictureEditID2Symbol.Image = Image.FromFile(_ImagePath);

                string fullPath = _MappedPath;

                string _ID2ImagePath = info.AVEVA_ImageDirPath + fullPath + ".png";

                if (pictureEditMapped.Image != null)

                {

                    pictureEditMapped.Image.Dispose();

                    pictureEditMapped.Image = null;

                }

                if (File.Exists(_ID2ImagePath))

                {

                    pictureEditMapped.Image = Image.FromFile(_ID2ImagePath);

                }

            }

        }

        private void btnRefreshSymbol_Click(object sender, EventArgs e)

        {

            Cursor = Cursors.WaitCursor;

            try

            {

                Project_Info project_Info = Project_Info.GetInstance();

                if (Directory.Exists(project_Info.AVEVA_ImageDirPath))

                    Directory.Delete(project_Info.AVEVA_ImageDirPath, true);

                Directory.CreateDirectory(project_Info.AVEVA_ImageDirPath);

                string stdDirPath = project_Info.AVEVA_ImageDirPath + @"\Standard";

                Directory.CreateDirectory(stdDirPath);

                #region directory

                DataTable stdStructure = Project_DB.SelectStandardSymbolStructureTable();

                foreach (DataRow row in stdStructure.Rows)

                {

                    string path = row["Relative_Path"].ToString();

                    if (!string.IsNullOrEmpty(path))

                    {

                        string newPath = stdDirPath + @"\" + path;

                        if (!Directory.Exists(newPath))

                            Directory.CreateDirectory(newPath);

                    }

                }

                stdStructure.Dispose();

                #endregion

                DataTable imageTable = Project_DB.SelectStandardSymbolImageTable();

                foreach (DataRow row in imageTable.Rows)

                {

                    string path = stdDirPath + @"\" + row["Relative_Path"] + @"\" + row["Symbol_Name"] + ".png";

                    byte[] picBinary = (byte[])row["Pic_Binary"];

                    MemoryStream mStream = new MemoryStream();

                    mStream.Write(picBinary, 0, picBinary.Length);

                    mStream.Seek(0, SeekOrigin.Begin);

                    Bitmap bm = new Bitmap(mStream);

                    bm.Save(path);

                    bm.Dispose();

                    mStream.Dispose();

                }

                imageTable.Dispose();

            }

            catch (Exception ex)

            {

            }

            Cursor = Cursors.Default;

        }

        private void treeListAvevaSymbol_FocusedNodeChanged(object sender, FocusedNodeChangedEventArgs e)

        {

            if (e.Node != null)

            {

                try

                {

                    Project_Info project_Info = Project_Info.GetInstance();

                    string imagePath = project_Info.AVEVA_ImageDirPath;

                    string dirPath = "";

                    GetNodeLoopText(e.Node, ref dirPath);

                    string resultPath = imagePath + dirPath;

                    string[] fileNames = Directory.GetFiles(resultPath, "*.png", SearchOption.TopDirectoryOnly);

                    galleryControlAvevaSymbols.Gallery.Groups[0].Caption = e.Node.GetDisplayText("Name");

                    while (galleryControlAvevaSymbols.Gallery.Groups[0].Items.Count > 0)

                    {

                        //DevExpress.XtraBars.Ribbon.GalleryItem item = galleryControlAvevaSymbols.Gallery.Groups[0].Items[0];

                        galleryControlAvevaSymbols.Gallery.Groups[0].Items.RemoveAt(0);

                    }

                    foreach (var fileName in fileNames)

                    {

                        DevExpress.XtraBars.Ribbon.GalleryItem item = new DevExpress.XtraBars.Ribbon.GalleryItem(Image.FromFile(fileName), Path.GetFileNameWithoutExtension(fileName), Path.GetFileNameWithoutExtension(fileName));

                        galleryControlAvevaSymbols.Gallery.Groups[0].Items.Add(item);

                    }

                }

                catch (Exception ex)

                {

                }

            }

            void GetNodeLoopText(TreeListNode node, ref string result)

            {

                result = @"\" + node.GetDisplayText("Name") + result;

                if (node.ParentNode != null)

                    GetNodeLoopText(node.ParentNode, ref result);

            }

        }

  <data name="btnRefreshSymbol.ImageOptions.SvgImage" type="DevExpress.Utils.Svg.SvgImage, DevExpress.Data.v18.2" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        AAEAAAD/////AQAAAAAAAAAMAgAAAFlEZXZFeHByZXNzLkRhdGEudjE4LjIsIFZlcnNpb249MTguMi43

        LjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjg4ZDE3NTRkNzAwZTQ5YQUBAAAAHURl

        dkV4cHJlc3MuVXRpbHMuU3ZnLlN2Z0ltYWdlAQAAAAREYXRhBwICAAAACQMAAAAPAwAAAIgCAAAC77u/

        PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz4NCjxzdmcgeD0iMHB4IiB5PSIwcHgi

        IHZpZXdCb3g9IjAgMCAzMiAzMiIgdmVyc2lvbj0iMS4xIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv

        MjAwMC9zdmciIHhtbG5zOnhsaW5rPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5L3hsaW5rIiBlbmFibGUt

        YmFja2dyb3VuZD0ibmV3IDAgMCAzMiAzMiIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSIgaWQ9IkxheWVyXzEi

        Pg0KICA8ZyBpZD0iUmVmcmVzaF8xXyI+DQogICAgPHBhdGggZD0iTTI0LjUsNy41QzIyLjMsNS4zLDE5

        LjMsNCwxNiw0QzEwLjEsNCw1LjEsOC4zLDQuMiwxNGg0LjFjMC45LTMuNCw0LTYsNy43LTZjMi4yLDAs

        NC4yLDAuOSw1LjYsMi40TDE4LDE0ICAgaDUuN2g0LjFIMjhWNEwyNC41LDcuNXoiIGZpbGw9IiMwMzlD

        MjMiIGNsYXNzPSJHcmVlbiIgLz4NCiAgICA8cGF0aCBkPSJNMTYuMiwyNGMtMi4yLDAtNC4yLTAuOS01

        LjYtMi40bDMuNi0zLjZIOC40SDQuNEg0LjJ2MTBsMy41LTMuNWMyLjIsMi4yLDUuMiwzLjUsOC41LDMu

        NSAgIEMyMi4xLDI4LDI3LDIzLjcsMjgsMThoLTQuMUMyMywyMS40LDE5LjksMjQsMTYuMiwyNHoiIGZp

        bGw9IiMwMzlDMjMiIGNsYXNzPSJHcmVlbiIgLz4NCiAgPC9nPg0KPC9zdmc+Cw==

</value>

  </data>

        private string _AVEVA_ImageDirPath;

                _AVEVA_ImageDirPath = value + @"\AVEVA_Image";

                Directory.CreateDirectory(_AVEVA_ImageDirPath);

        public string AVEVA_ImageDirPath

            get { return _AVEVA_ImageDirPath; }