HYTOS

        public static DataTable SelectSymbolAttribute()

        {

            DataTable dt = new DataTable();

            ID2Info id2Info = ID2Info.GetInstance();

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

            {

                try

                {

                    connection.Open();

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = "SELECT DISTINCT Attribute, DisplayAttribute FROM SymbolAttribute;";

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                    }

                    connection.Close();

                }

                catch (Exception ex)

                {

                    Log.Write(ex.Message + "\r\n" + ex.StackTrace);

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return dt;

        }

            item.Attributes = GetAttributes(element.Element("SYMBOLATTRIBUTES"));

            equipment.Attributes.AddRange(item.Attributes);

            this.comboBoxEditEquipTagName = new DevExpress.XtraEditors.ComboBoxEdit();

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

            this.layoutControlGroup3 = new DevExpress.XtraLayout.LayoutControlGroup();

            this.checkEditEquipTag = new DevExpress.XtraEditors.CheckEdit();

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

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

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

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

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

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

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

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

            // comboBoxEditEquipTagName

            // 

            this.comboBoxEditEquipTagName.Location = new System.Drawing.Point(96, 175);

            this.comboBoxEditEquipTagName.MenuManager = this.ribbonControl;

            this.comboBoxEditEquipTagName.Name = "comboBoxEditEquipTagName";

            this.comboBoxEditEquipTagName.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

            this.comboBoxEditEquipTagName.Size = new System.Drawing.Size(124, 20);

            this.comboBoxEditEquipTagName.StyleController = this.layoutControl1;

            this.comboBoxEditEquipTagName.TabIndex = 10;

            this.comboBoxEditEquipTagName.SelectedIndexChanged += new System.EventHandler(this.comboBoxEditEquipTagName_SelectedIndexChanged);

            // 

            this.layoutControlItem6,

            this.layoutControlGroup3});

            this.emptySpaceItem1.Location = new System.Drawing.Point(0, 168);

            this.emptySpaceItem1.Size = new System.Drawing.Size(212, 583);

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.comboBoxEditEquipTagName;

            this.layoutControlItem7.Location = new System.Drawing.Point(0, 23);

            this.layoutControlItem7.Name = "layoutControlItem7";

            this.layoutControlItem7.Size = new System.Drawing.Size(188, 24);

            this.layoutControlItem7.Text = "Attr Name";

            this.layoutControlItem7.TextSize = new System.Drawing.Size(57, 14);

            // 

            // layoutControlGroup3

            // 

            this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.layoutControlItem7,

            this.layoutControlItem8});

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

            this.layoutControlGroup3.Name = "layoutControlGroup3";

            this.layoutControlGroup3.Size = new System.Drawing.Size(212, 90);

            this.layoutControlGroup3.Text = "Equipment Tag No Setting";

            // 

            // checkEditEquipTag

            // 

            this.checkEditEquipTag.Location = new System.Drawing.Point(36, 152);

            this.checkEditEquipTag.MenuManager = this.ribbonControl;

            this.checkEditEquipTag.Name = "checkEditEquipTag";

            this.checkEditEquipTag.Properties.Caption = "Use ID2 Attribute";

            this.checkEditEquipTag.Size = new System.Drawing.Size(184, 19);

            this.checkEditEquipTag.StyleController = this.layoutControl1;

            this.checkEditEquipTag.TabIndex = 11;

            this.checkEditEquipTag.CheckedChanged += new System.EventHandler(this.checkEdit1_CheckedChanged);

            // 

            // layoutControlItem8

            // 

            this.layoutControlItem8.Control = this.checkEditEquipTag;

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

            this.layoutControlItem8.Name = "layoutControlItem8";

            this.layoutControlItem8.Size = new System.Drawing.Size(188, 23);

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

            this.layoutControlItem8.TextVisible = false;

            // 

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

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

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

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

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

        private DevExpress.XtraEditors.ComboBoxEdit comboBoxEditEquipTagName;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraEditors.CheckEdit checkEditEquipTag;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup3;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem8;

using ID2PSN.Properties;

            comboBoxEditEquipTagName.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            string equipTag = Settings.Default.EquipTagAttribute;

            DataTable dt = DB.SelectSymbolAttribute();

            foreach (DataRow row in dt.Rows)

            {

                string value = row["Attribute"].ToString();

                comboBoxEditEquipTagName.Properties.Items.Add(value);

                if (!string.IsNullOrEmpty(equipTag) && value.Equals(equipTag))

                    comboBoxEditEquipTagName.SelectedItem = value;

            }

            checkEditEquipTag.Checked = Settings.Default.UseEquipTag;

            comboBoxEditEquipTagName.Enabled = checkEditEquipTag.Checked;

            if (checkEditEquipTag.Checked)

                psn.EquipTagNoAttributeName = comboBoxEditEquipTagName.SelectedItem.ToString();

        private void comboBoxEditEquipTagName_SelectedIndexChanged(object sender, EventArgs e)

        {

            string value = comboBoxEditEquipTagName.SelectedItem.ToString();

            Settings.Default.EquipTagAttribute = value;

            Settings.Default.Save();

        }

        private void checkEdit1_CheckedChanged(object sender, EventArgs e)

        {

            Settings.Default.UseEquipTag = checkEditEquipTag.Checked;

            Settings.Default.Save();

            comboBoxEditEquipTagName.Enabled = checkEditEquipTag.Checked;

        }

            Attributes = new List<Attribute>();

        public List<Attribute> Attributes { get; set; }

        public string ItemTag { get; set; }

        public string EquipTagNoAttributeName = string.Empty;

                if (!string.IsNullOrEmpty(EquipTagNoAttributeName))

                {

                    Attribute attribute = equipment.Attributes.Find(x => x.Name == EquipTagNoAttributeName);

                    if (attribute != null)

                        equipment.ItemTag = attribute.Value;

                }

                else

                    equipment.ItemTag = equipment.Name;

                row["ITEMTAG"] = equipment.ItemTag;

                result = Groups.First().Items.First().Equipment.ItemTag;

                result = Groups.Last().Items.Last().Equipment.ItemTag;

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

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

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

        public string EquipTagAttribute {

            get {

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

            }

            set {

                this["EquipTagAttribute"] = value;

            }

        }

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

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

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

        public bool UseEquipTag {

            get {

                return ((bool)(this["UseEquipTag"]));

            }

            set {

                this["UseEquipTag"] = value;

            }

        }

  <Settings>

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

      <Value Profile="(Default)"></Value>

    </Setting>

    <Setting Name="UseEquipTag" Type="System.Boolean" Scope="User">

      <Value Profile="(Default)">False</Value>

    </Setting>

  </Settings>