HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using AVEVA.PID.CustomizationUtility.DB;

using AVEVA.PID.CustomizationUtility.Model;

using AVEVA.PID.CustomizationUtility.Properties;

using System.Data;

namespace AVEVA.PID.CustomizationUtility

{

    public class AvevaInfo

    {

        static AvevaInfo avevaInfo;

        public DataTable AvevaSymbolTable { get; set; }

        public List<SymbolInfo> SymbolInfo { get; set; }

        public List<AttributeInfo> AttributeInfo { get; set; }

        public static AvevaInfo GetInstance()

        {

            if (avevaInfo == null)

            {

                avevaInfo = new AvevaInfo();

                Refresh();

            }

            return avevaInfo;

        }

        public static void Refresh()

        {

            if (avevaInfo == null)

                avevaInfo = new AvevaInfo();

            avevaInfo.AvevaSymbolTable = Project_DB.SelectSymbolTable();

            SetSymbolInfo();

            SetAttributeInfo();

        }

        private static void SetSymbolInfo()

        {

            avevaInfo.SymbolInfo = new List<SymbolInfo>();

            DataTable dt = Project_DB.GetSymbolMappingTableOnlySymbol();

            foreach (DataRow row in dt.Rows)

            {

                SymbolInfo info = new SymbolInfo();

                info.UID = DBNull.Value.Equals(row["UID"]) ? string.Empty : row["UID"].ToString();

                info.NAME = DBNull.Value.Equals(row["NAME"]) ? string.Empty : row["NAME"].ToString();

                info.APID_SYMBOL = DBNull.Value.Equals(row["APID_SYMBOL"]) ? string.Empty : row["APID_SYMBOL"].ToString();

                info.DATA1 = DBNull.Value.Equals(row["DATA1"]) ? string.Empty : row["DATA1"].ToString();

                avevaInfo.SymbolInfo.Add(info);

            }

            dt.Dispose();

        }

        private static void SetAttributeInfo()

        {

            avevaInfo.AttributeInfo = new List<AttributeInfo>();

            DataTable dt = Project_DB.GetAttributeMappingTableOnlyAttribute();

            foreach (DataRow row in dt.Rows)

            {

                AttributeInfo info = new AttributeInfo();

                info.UID = DBNull.Value.Equals(row["UID"]) ? string.Empty : row["UID"].ToString();

                info.APID_ATTRIBUTE = DBNull.Value.Equals(row["APID_ATTRIBUTE"]) ? string.Empty : row["APID_ATTRIBUTE"].ToString();

                info.APID_ATTRIBUTE_TYPE = DBNull.Value.Equals(row["APID_ATTRIBUTE_TYPE"]) ? string.Empty : row["APID_ATTRIBUTE_TYPE"].ToString();

                if (!string.IsNullOrEmpty(info.APID_ATTRIBUTE) && !string.IsNullOrEmpty(info.APID_ATTRIBUTE_TYPE))

                {

                    string sRemove = "|" + info.APID_ATTRIBUTE_TYPE;

                    info.APID_ATTRIBUTE = info.APID_ATTRIBUTE.Remove(info.APID_ATTRIBUTE.LastIndexOf(sRemove), sRemove.Length);

                }

                avevaInfo.AttributeInfo.Add(info);

            }

            dt.Dispose();

        }

    }

    public class SymbolInfo

    {

        public string UID { get; set; }

        public string NAME { get; set; }

        public string APID_SYMBOL { get; set; }

        public string DATA1 { get; set; }

    }

    public class AttributeInfo

    {

        public string UID { get; set; }

        public string APID_ATTRIBUTE { get; set; }

        public string APID_ATTRIBUTE_TYPE { get; set; }

    }

}