OTS/OTSIncAReportApp/1-UI/OTSReportExport/DataIntegration/ElementalAnalysis.cs


using OTSCommon.DBOperate;
using OTSCommon.DBOperate.Model;
using OTSIncAReportApp.DataOperation.DataAccess;
using OTSIncAReportApp.OTSSampleReportInfo;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static OTSDataType.otsdataconst;
using static OTSIncAReportApp.OTSReport_Export;

namespace OTSIncAReportApp._1_UI.OTSReportExport.DataIntegration
{
    /// <summary>
    /// 元素分析
    /// </summary>
    class ElementalAnalysis
    {
        /// <summary>
        /// 元素分析表（表头、表数据、全数据）
        /// </summary>
        /// <param name="m_mbszclass"></param>
        /// <param name="m_otsreport_export"></param>
        /// <returns></returns>
        public List<DataTable> GetElementData(BasicData basicData, OTSReport_Export m_otsreport_export,bool lingge)
        {
            DataTable data = basicData.GetDBData();
            //根据sql条件，查询获取颗粒信息数据
            DataTable AllAnalysisDetails = new DataTable();
            AllAnalysisDetails.TableName = "ElementValue";
            AllAnalysisDetails.Columns.Add("Name");
            AllAnalysisDetails.Columns.Add("TypeId");
            AllAnalysisDetails.Columns.Add("Area", typeof(double));
            AllAnalysisDetails.Columns.Add("Class");
            for (int i = 0; i < data.Rows.Count; i++)
            {
                DataRow dr2 = AllAnalysisDetails.NewRow();
                dr2["Name"] = data.Rows[i]["TypeName"].ToString();
                dr2["Area"] = Convert.ToDouble(data.Rows[i]["ar"]);
                dr2["TypeId"] = data.Rows[i]["TypeId"].ToString();
                dr2["Class"] = data.Rows[i]["Class"].ToString();
                AllAnalysisDetails.Rows.Add(dr2);
            }

            //按照list列表进行物质类排序，物质类中的元素分类按照面积的大小进行排序

            List<string> ClassName = ObtainParticleCategory(m_otsreport_export, basicData);

			//List<string> ClassName = new List<string>();
			////DataTable getClass_dt = basicData.GetAllClass();
			//DataTable get_dt = ReadClassification(basicData);
			//DataTable getClass_dt = get_dt.Clone();
			//DataRow[] dataRow = get_dt.Select("", "iorder ASC");
			//foreach (DataRow row in dataRow)
			//{
			//	if (row.ItemArray[1].ToString() != "Default")
			//	{
			//		getClass_dt.ImportRow(row);
			//	}
			//}


			//for (int i = 0; i < getClass_dt.Rows.Count; i++)
			//{
			//	ClassName.Add(getClass_dt.Rows[i][1].ToString());
			//}
			//ClassName.Add("Default");
		

			//统计元素物质大类的元素信息和面积占比
			DataTable dt_ElementalSubstance = ElementalSubstance(AllAnalysisDetails, ClassName, basicData.getParticleData());
            DataTable dt_ElementSorting;
            //统计元素并按照Class Name自定义列表进行排序，大类中的小类元素信息按照面积从大到小排序
            if (lingge)
            {
               //单个大类
                dt_ElementSorting = ElementSortingSS(AllAnalysisDetails, ClassName, basicData.getParticleData());
                
            }
            else
            {
                dt_ElementSorting = ElementSorting(AllAnalysisDetails, ClassName, basicData.getParticleData());

            }
            //统计元素并按照Class Name自定义列表进行排序，大类中的小类元素信息按照面积从大到小排序
            //DataTable dt_ElementSorting = ElementSorting(AllAnalysisDetails, ClassName, basicData.getParticleData());
            ////生成最后导出时物质元素成分表
            DataTable dt = MaterialElementComposition(dt_ElementalSubstance, 13, m_otsreport_export);//导出14个元素成分信息
            dt.Columns.Add("TypeId");                                                                     //生成最后导出时物质元素细分表
DataTable dtname = new DataTable();
            DataTable dtData = new DataTable();
            SubdivisionOfMaterialElements(dt_ElementSorting, 13, ClassName, dt, out dtname, out dtData);
            List<DataTable> datas = new List<DataTable>();
            datas.Add(dtname);
            datas.Add(dtData);
            datas.Add(dt_ElementSorting);
			return datas;
		}
		/// <summary>
		/// 获得颗粒类别
		/// </summary>
		/// <returns></returns>
		private List<string> ObtainParticleCategory(OTSReport_Export m_otsreport_export ,BasicData basicData)
        {
			List<string> ClassName = new List<string>();
            if (m_otsreport_export.m_ReportApp.m_RptConfigFile.Systype != OTS_SysType_ID.IncA)
            {
                DataTable get_dt = ReadClassification(basicData);
                DataTable getClass_dt = get_dt.Clone();
                DataRow[] dataRow = get_dt.Select("", "iorder ASC");
                foreach (DataRow row in dataRow)
                {
                    if (row.ItemArray[1].ToString() != "Default")
                    {
                        getClass_dt.ImportRow(row);
                    }
                }
                for (int i = 0; i < getClass_dt.Rows.Count; i++)
                {
                    ClassName.Add(getClass_dt.Rows[i][1].ToString());
                }
                ClassName.Add("Default");

            }
            else
            {
				DataTable getClass_dt = ReadClassification(basicData);
				for (int i = 0; i < getClass_dt.Rows.Count; i++)
				{
					ClassName.Add(getClass_dt.Rows[i][1].ToString());

				}

                bool bl = false;
                for (int i = 0; i < getClass_dt.Rows.Count; i++)
                {
                    if (getClass_dt.Rows[i]["GroupName"].ToString() != "NOT_INCLUTION" && getClass_dt.Rows[i]["GroupName"].ToString() != "Invalid"
                    && getClass_dt.Rows[i]["GroupName"].ToString() != "Not Identified")
                        if (getClass_dt.Rows[i]["GroupName"].ToString() == "")
                        {
                            if (!bl)
                            {
                                ClassName.Add("Default");
                                bl = true;
                            }
                        }
                        else
                        {
                            bool isDefault = false;

                            for (int a = 0; a < ClassName.Count; a++)
                            {
                                if (getClass_dt.Rows[i]["GroupName"].ToString() == "Default")
                                {
                                    isDefault = true;
                                }
                            }
                            if (isDefault)
                            {
                                if (getClass_dt.Rows[i]["GroupName"].ToString() != "Default")
                                {
                                    ClassName.Add(getClass_dt.Rows[i]["GroupName"].ToString());
                                }
                            }
                            else
                            {
                                ClassName.Add(getClass_dt.Rows[i]["GroupName"].ToString());
                            }
                        }
                }
            }
			return ClassName;
		}


		private DataTable ReadClassification(BasicData basicData)
		{
			DataTable dt_stl = new DataTable();
			SqLiteHelper sh = new SqLiteHelper("data source='" + basicData.GetFilePath() + "\\" + basicData.GetResfile() + "'");
			dt_stl = sh.ExecuteQuery("select * from STDGroups");
			return dt_stl;
		}
		private bool SubdivisionOfMaterialElements(DataTable a_ElementalSubstance, int NumberOfColumns, List<string> ClassName, DataTable data, out DataTable dt1, out DataTable dt2)
        {

            DataTable dt_ElementalSubstance = new DataTable();
            dt_ElementalSubstance = data.Copy();
            dt_ElementalSubstance.Clear();
            dt_ElementalSubstance.TableName = "ElementSubdivision_Value";
            dt_ElementalSubstance.Columns["Name"].ColumnName = "Class";
            dt_ElementalSubstance.Columns.Add("Name");
            //处理元素面积保留小数点后两位
            for (int i = 0; i < a_ElementalSubstance.Rows.Count; i++)
            {
                a_ElementalSubstance.Rows[i]["Area"] = Math.Round(Convert.ToDouble(a_ElementalSubstance.Rows[i]["Area"].ToString()), 2);
            }


            //循环元素物质大类
            for (int i = 0; i < ClassName.Count; i++)
            {
                DataTable dt_1 = new DataTable();
                dt_1 = data.Copy();
                dt_1.Clear();
                for (int a = 0; a < data.Rows.Count; a++)
                {
                    if (data.Rows[a]["Name"].ToString() == ClassName[i].ToString())
                    {
                        dt_1.Rows.Add(data.Rows[a].ItemArray);
                    }
                }
                dt_1.Columns["Name"].ColumnName = "Class";
                dt_1.Columns.Add("Name");

                DataTable dt_2 = new DataTable();
                dt_2 = dt_1.Copy();
                dt_2.Clear();
                dt_2.Rows.Add();
                //循环整个表筛选出当前的物质
                for (int a = 0; a < a_ElementalSubstance.Rows.Count; a++)
                {
                    if(ClassName.Count==1)
                    {
                        for (int b = 0; b < dt_1.Columns.Count; b++)
                        {
                            if (dt_2.Columns[b].ToString() != "Class")
                            {
                                if (a_ElementalSubstance.Columns.Contains(dt_2.Columns[b].ToString()))
                                {
                                    if (a_ElementalSubstance.Rows[a][dt_2.Columns[b].ToString()].ToString() == "")
                                    {
                                        dt_2.Rows[0][dt_2.Columns[b].ToString()] = 0;
                                    }
                                    else
                                    {
                                        dt_2.Rows[0][dt_2.Columns[b].ToString()] = a_ElementalSubstance.Rows[a][dt_2.Columns[b].ToString()];
                                    }
                                }
                                else
                                {
                                    dt_2.Rows[0][dt_2.Columns[b].ToString()] = 0;
                                }

                            }
                        }
                        dt_1.Rows.Add(dt_2.Rows[0].ItemArray);
                    }
                    else

                    if (ClassName[i].ToString() == a_ElementalSubstance.Rows[a]["Class"].ToString())
                    {
                        for (int b = 0; b < dt_1.Columns.Count; b++)
                        {
                            if (dt_2.Columns[b].ToString() != "Class")
                            {
                                if (a_ElementalSubstance.Columns.Contains(dt_2.Columns[b].ToString()))
                                {
                                    if (a_ElementalSubstance.Rows[a][dt_2.Columns[b].ToString()].ToString() == "")
                                    {
                                        dt_2.Rows[0][dt_2.Columns[b].ToString()] = 0;
                                    }
                                    else
                                    {
                                        dt_2.Rows[0][dt_2.Columns[b].ToString()] = a_ElementalSubstance.Rows[a][dt_2.Columns[b].ToString()];
                                    }
                                }
                                else
                                {
                                    dt_2.Rows[0][dt_2.Columns[b].ToString()] = 0;
                                }

                            }
                        }
                        dt_1.Rows.Add(dt_2.Rows[0].ItemArray);
                    }
                    
                }

                for (int a = 0; a < dt_1.Rows.Count; a++)
                {
                    dt_ElementalSubstance.Rows.Add(dt_1.Rows[a].ItemArray);
                }
            }



            DataTable dataTable = new DataTable();
            dataTable = dt_ElementalSubstance.Copy();
            dataTable.Clear();
            DataRow row = dataTable.NewRow();
            dataTable.Rows.Add(row);
            dataTable.TableName = "ElementSubdivision_Name";
            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                dataTable.Rows[0][dataTable.Columns[i].ToString()] = dataTable.Columns[i].ToString();
            }
            dt1 = dataTable.Copy();
            dt2 = dt_ElementalSubstance.Copy();

            return true;
        }
        private DataTable MaterialElementComposition(DataTable a_ElementalSubstance, int NumberOfColumns,OTSReport_Export m_otsreport_export)
        {
            DataTable dt_ElementalSubstance = new DataTable();
            dt_ElementalSubstance.TableName = "ElementalSubstance_Value";
            dt_ElementalSubstance.Columns.Add("Name");
            dt_ElementalSubstance.Columns.Add("Area");
            for (int i = 0; i < a_ElementalSubstance.Rows.Count; i++)
            {
                dt_ElementalSubstance.Rows.Add(a_ElementalSubstance.Rows[i]["Name"]);
                dt_ElementalSubstance.Rows[i]["Area"] = Math.Round(Convert.ToDouble(a_ElementalSubstance.Rows[i]["Area"]), 2);
            }
            int cunt = 1;
            for (int i = 0; i < NumberOfColumns; i++)
            {

                if (i < m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Count())
                {
                    dt_ElementalSubstance.Columns.Add(m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]);
                    for (int a = 0; a < a_ElementalSubstance.Rows.Count; a++)
                    {
                        if (a_ElementalSubstance.Columns.Contains(m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]))
                        {
                            if (a_ElementalSubstance.Rows[a][m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]].ToString() == "")
                            {
                                dt_ElementalSubstance.Rows[a][m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]] = 0;
                            }
                            else
                            {
                                dt_ElementalSubstance.Rows[a][m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]] = a_ElementalSubstance.Rows[a][m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]];
                            }
                        }
                        else
                        {
                            dt_ElementalSubstance.Rows[a][m_otsreport_export.m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys[i]] = 0;
                        }
                    }
                }
                else
                {
                    dt_ElementalSubstance.Columns.Add("Null" + cunt.ToString());
                    cunt = cunt + 1;
                    for (int a = 0; a < a_ElementalSubstance.Rows.Count; a++)
                    {
                        dt_ElementalSubstance.Rows[a][i + 2] = "-";
                    }
                }
            }

            DataTable dataTable = new DataTable();
            dataTable = dt_ElementalSubstance.Copy();
            dataTable.Clear();
            DataRow row = dataTable.NewRow();
            dataTable.Rows.Add(row);
            dataTable.TableName = "ElementalSubstance_Name";
            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                dataTable.Rows[0][dataTable.Columns[i].ToString()] = dataTable.Columns[i].ToString();
            }

            //m_list_dt.Add(dataTable);
            //m_list_dt.Add(dt_ElementalSubstance);

            return dt_ElementalSubstance;
        }
        private DataTable ElementSorting(DataTable AllAnalysisDetails, List<string> ClassName, ParticleData fielddata)
        {
            DataTable dte = fielddata.GetAllElement();
            DataTable ElementSorting_dt = AllAnalysisDetails.Copy();
            ElementSorting_dt.Clear();
            for (int i = 0; i < ClassName.Count; i++)
            {
                DataTable dt = AllAnalysisDetails.Copy();
                dt.Clear();
                for (int a = 0; a < AllAnalysisDetails.Rows.Count; a++)
                {
                    if (AllAnalysisDetails.Rows[a]["Class"].ToString() == ClassName[i].ToString())
                    {
                        dt.Rows.Add(AllAnalysisDetails.Rows[a].ItemArray);
                    }
                }
                //将颗粒大小排序（从大到小）
                DataView dv = dt.DefaultView;
                dv.Sort = "Area DESC";
                DataTable dt_Element = dv.ToTable();

                for (int a = 0; a < dt_Element.Rows.Count; a++)
                {
                    ElementSorting_dt.Rows.Add(dt_Element.Rows[a].ItemArray);
                }
            }
            //循环创建元素列（类型定义为double，为以后计算做准备）
            for (int a = 0; a < dte.Rows.Count; a++)
            {
                ElementSorting_dt.Columns.Add(dte.Rows[a]["Name"].ToString(), typeof(double));
            }

            for (int a = 0; a < ElementSorting_dt.Rows.Count; a++)
            {
                DataTable ClassificationDetails = fielddata.GetAreaByIncA(ElementSorting_dt.Rows[a]["TypeId"].ToString(), "");//获取单个分类的元素信息
                //DataRow dr2 = ElementSorting_dt.NewRow();

                foreach (DataRow dr in ClassificationDetails.Rows)
                {
                    double doe = Convert.ToDouble(dr["pc"]);
                    ElementSorting_dt.Rows[a][dr["Name"].ToString()] = Math.Round(doe / Convert.ToDouble(ElementSorting_dt.Rows[a]["Area"]), 2);
                }
            }

            return ElementSorting_dt;
        }

        private DataTable ElementSortingSS(DataTable AllAnalysisDetails, List<string> ClassName, ParticleData fielddata)
        {
            DataTable dte = fielddata.GetAllElement();
            DataTable ElementSorting_dt = AllAnalysisDetails.Copy();
            ElementSorting_dt.Clear();
            for (int i = 0; i < ClassName.Count; i++)
            {
                DataTable dt = AllAnalysisDetails.Copy();
                //dt.Clear();
                //for (int a = 0; a < AllAnalysisDetails.Rows.Count; a++)
                //{
                //    if (AllAnalysisDetails.Rows[a]["Class"].ToString() == ClassName[i].ToString())
                //    {
                //        dt.Rows.Add(AllAnalysisDetails.Rows[a].ItemArray);
                //    }
                //}
                //将颗粒大小排序（从大到小）
                //DataView dv = dt.DefaultView;
                //dv.Sort = "Area DESC";
                //DataTable dt_Element = dv.ToTable();
                DataTable dt_Element = dt.Copy();
                for (int a = 0; a < dt_Element.Rows.Count; a++)
                {
                    ElementSorting_dt.Rows.Add(dt_Element.Rows[a].ItemArray);
                }
            }
            //循环创建元素列（类型定义为double，为以后计算做准备）
            for (int a = 0; a < dte.Rows.Count; a++)
            {
                ElementSorting_dt.Columns.Add(dte.Rows[a]["Name"].ToString(), typeof(double));
            }

            for (int a = 0; a < ElementSorting_dt.Rows.Count; a++)
            {
                DataTable ClassificationDetails = fielddata.GetAreaByIncA(ElementSorting_dt.Rows[a]["TypeId"].ToString(), "");//获取单个分类的元素信息
                //DataRow dr2 = ElementSorting_dt.NewRow();

                foreach (DataRow dr in ClassificationDetails.Rows)
                {
                    double doe = Convert.ToDouble(dr["pc"]);
                    ElementSorting_dt.Rows[a][dr["Name"].ToString()] = Math.Round(doe / Convert.ToDouble(ElementSorting_dt.Rows[a]["Area"]), 2);
                }
            }

            return ElementSorting_dt;
        }


        private DataTable ElementalSubstance(DataTable AllAnalysisDetails, List<string> ClassName, ParticleData fielddata)
        {
            //当前元素物质类面积的总和
            double ElementalSubstance = 0;
            DataTable dte = fielddata.GetAllElement();
            DataTable dt_Class = new DataTable();
            dt_Class.Columns.Add("Name");
            dt_Class.Columns.Add("Area");
            //循环创建元素列（类型定义为double，为以后计算做准备）
            for (int a = 0; a < dte.Rows.Count; a++)
            {
                dt_Class.Columns.Add(dte.Rows[a]["Name"].ToString(), typeof(double));
            }
            //循环大类物质列表
            for (int i = 0; i < ClassName.Count; i++)
            {
                //保留当前循环中大类物质，去除其他物质
                DataTable dt = AllAnalysisDetails.Copy();
                dt.Clear();
                for (int a = 0; a < AllAnalysisDetails.Rows.Count; a++)
                {
                    if (AllAnalysisDetails.Rows[a]["Class"].ToString() == ClassName[i].ToString())
                    {
                        dt.Rows.Add(AllAnalysisDetails.Rows[a].ItemArray);
                    }
                }
				//if (dt.Rows.Count == 0)
				//    continue;
				if (dt.Rows.Count == 0)
                {
                    DataRow dataRow = dt.NewRow();
                    dataRow["Area"] = 0;
                    dt.Rows.Add(dataRow);

					DataRow dataRow2 = dt_Class.NewRow();
					dataRow2["Name"]= ClassName[i].ToString();
                    double ar0 = 0;
                    dataRow2["Area"] = ar0;
                    dt_Class.Rows.Add(dataRow2);
					continue;
				}
					//计算出当前循环中大类物质的面积
					ElementalSubstance = Convert.ToDouble(decimal.Parse(dt.Compute("sum(Area)", "").ToString()));

                DataTable ta = new DataTable();
                ta = dt_Class.Copy();
                ta.Clear();

                for (int a = 0; a < dt.Rows.Count; a++)
                {
                    DataTable ClassificationDetails = fielddata.GetAreaByIncA(dt.Rows[a]["TypeId"].ToString(), "");//获取单个分类的元素信息
                    DataRow dr2 = ta.NewRow();

                    foreach (DataRow dr in ClassificationDetails.Rows)
                    {
                        double doe = Convert.ToDouble(dr["pc"]);
                        dr2[dr["Name"].ToString()] = doe;
                    }
                    ta.Rows.Add(dr2);
                }
                DataTable dataTable = ta.Copy();
                dataTable.Clear();
                DataRow row = dataTable.NewRow();
                dataTable.Rows.Add(row);
                for (int a = 0; a < ta.Columns.Count; a++)
                {
                    if (ta.Columns[a].ToString() != "Name" && ta.Columns[a].ToString() != "Class")
                    {
                        bool bl = false;
                        for (int b = 0; b < ta.Rows.Count; b++)
                        {
                            if (!ta.Rows[b].IsNull(ta.Columns[a].ToString()))
                            {
                                bl = true;
                            }
                        }
                        if (bl)
                            //datatSuncolumn(ta, ta.Columns[a].ToString());
                            dataTable.Rows[0][ta.Columns[a].ToString()] = Math.Round(datatSuncolumn(ta, ta.Columns[a].ToString()) / ElementalSubstance, 2);
                    }
                }
                dataTable.Rows[0]["Name"] = ClassName[i].ToString();
                dataTable.Rows[0]["Area"] = ElementalSubstance;

                dt_Class.Rows.Add(dataTable.Rows[0].ItemArray);

            }
            return dt_Class;
        }
        private double datatSuncolumn(DataTable dt, string str)
        {
            double sum = 0;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (dt.Rows[i][str].ToString() == "")
                {
                    dt.Rows[i][str] = 0;
                }
                sum = sum + Convert.ToDouble(dt.Rows[i][str].ToString());
            }
            return sum;
        }
    }
}