HYTOS

                            SELECT sp.UID, s.Name, st.Type, sp.SPPID_SYMBOL_PATH FROM {1} as st, {0} as s 

        public static DataTable SelectProjectChildSymbol()

        {

            DataTable result = new DataTable();

            result.Columns.Add("UID");

            result.Columns.Add("Name");

            result.Columns.Add("Type");

            result.Columns.Add("SPPID_SYMBOL_PATH");

            Project_Info projectInfo = Project_Info.GetInstance();

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

            using (DataTable dt = new DataTable())

            {

                try

                {

                    connection.Open();

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = string.Format(@"

                            SELECT AdditionalSymbol FROM Symbol");

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                        List<string> childList = new List<string>();

                        foreach (DataRow row in dt.Rows)

                        {

                            if (!string.IsNullOrEmpty((string)row["AdditionalSymbol"]))

                            {

                                string[] array = row["AdditionalSymbol"].ToString().Split(new char[] { '/' });

                                foreach (var childString in array)

                                {

                                    childList.Add(childString.Split(new char[] { ',' })[2]);

                                }

                            }

                        }

                        dt.Clear();

                        cmd.Reset();

                        cmd.CommandText = string.Format(@"

                            SELECT * FROM {0}", SPPID_SYMBOL_MAPPING_TABLE);

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                        childList = childList.Distinct().ToList();

                        foreach (var child in childList)

                        {

                            string mappingPath = string.Empty;

                            DataRow[] rows = dt.Select(string.Format("UID = '{0}'", child));

                            if (rows.Length == 1)

                                mappingPath = !DBNull.Value.Equals(rows[0]["SPPID_SYMBOL_PATH"]) ? (string)rows[0]["SPPID_SYMBOL_PATH"] : null;

                            DataRow newRow = result.NewRow();

                            newRow["UID"] = child;

                            newRow["Name"] = child;

                            newRow["Type"] = "Child Symbol";

                            newRow["SPPID_SYMBOL_PATH"] = mappingPath;

                            result.Rows.Add(newRow);

                        }

                    }

                    connection.Close();

                }

                catch (Exception ex)

                {

                }

                finally

                {

                    connection.Dispose();

                }

            }

            return result;

        }