using System.Data;

namespace OTSIncAReportApp.DataOperation.DataAccess
{
    public class OtherDB
    {
        private SqlHelper dbHelper;
        public OtherDB(string path)
        {
            dbHelper = new SqlHelper("data source='" + path + "'");
        }
        /// <summary>
        /// 获取所有元素
        /// </summary>
        /// <param name="typeid">类型</param>
        /// <returns></returns>
        public DataTable GetAllElement(string typeid)
        {

            string sqlp = @"select element from ClassifySTD where STDid in(" + typeid + ") ";

            DataTable DT = dbHelper.ExecuteDataTable(sqlp, null);
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("elementName");

            foreach (DataRow item in DT.Rows)
            {
                string element = item["element"].ToString();
                for (int i = 0; i < element.Split(',').Length; i++)
                {
                    string el = element.Split(',')[i].Split(':')[0];
                    if (dataTable.Select("elementName='" + el + "'").Length == 0)
                    {
                        DataRow dr = dataTable.NewRow();
                        dr["elementName"] = el;
                        dataTable.Rows.Add(dr);
                    }
                }
            }

            return dataTable;

        }
        /// <summary>
        /// 获取小颗粒的元素
        /// </summary>
        /// <param name="typeid">类型</param>
        /// <returns></returns>
        public DataTable GetInfoByTypeid(string typeid)
        {

            string sqlp = @"select * from ClassifySTD where STDid =" + typeid;
            DataTable DT = dbHelper.ExecuteDataTable(sqlp, null);
            // List<Model.Particle> listp = dbHelper.TableToList<Model.Particle>(DT);
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("elementName");
            dataTable.Columns.Add("elementPercentage");
            foreach (DataRow item in DT.Rows)
            {
                string element = item["element"].ToString();
                for (int i = 0; i < element.Split(',').Length; i++)
                {
                    string el = element.Split(',')[i].Split(':')[0];
                    string pen = element.Split(',')[i].Split(':')[1];
                    if (dataTable.Select("elementName='" + el + "'").Length == 0)
                    {
                        DataRow dr = dataTable.NewRow();
                        dr["elementName"] = el;
                        dr["elementPercentage"] = pen;
                        dataTable.Rows.Add(dr);
                    }
                }
            }
            return dataTable;

        }
    }
}