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


using DevExpress.Office.Drawing;
using NPOI.Util;
using OTSCommon.DBOperate;
using OTSIncAReportApp.DataOperation.DataAccess;
using OTSIncAReportApp.OTSRstMgrFunction;
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
{
	public class BasicData
    {
        ParticleData fielddata;
        private string SizeChart = "";

        List<string> colid = new List<string>();
        List<string> colid_Below7 = new List<string>();

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

		private List<DataTable> BData = new List<DataTable>();
        private List<DataTable> Measurements = new List<DataTable>();//测量结果数据列队

		private DataTable AllClass = new DataTable();
        private DataTable AllElement = new DataTable();
        private bool IsShereAClassificationGroup = false;
        private ResultFile resfile;
        private string FilePath = "";
        /// <summary>
        /// 获取粒级表
        /// </summary>
        public void SetParticlesizeTable(OTSReport_Export m_otsreport_export)
        {
            colid_Below7.Clear();
            //获取粒级表
            string path1 = m_otsreport_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder +
                 m_otsreport_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
            DataSet ds = OTSIncAReportApp.DataOperation.DataAccess.XMLoperate.GetXml(path1);
            SizeChart = ds.Tables[0].Rows[0]["Sizes"].ToString();

            for (int i = 0; i < SizeChart.Split(',').Length; i++)
            {
                if (SizeChart.Split(',')[i].Length > 0)
                {
                    double d1 = Convert.ToDouble(SizeChart.Split(',')[i]);
                    //double d2 = Convert.ToDouble(SizeChart.Split(',')[i + 1]);
                    colid.Add("≥"+ d1.ToString() /*+ "~" + d2.ToString()*/);
                }
            }


            for (int i = 0; i < SizeChart.Split(',').Length - 1; i++)
            {
                if (SizeChart.Split(',')[i].Length > 0)
                {
                    double d1 = Convert.ToDouble(SizeChart.Split(',')[i]);
                    double d2 = Convert.ToDouble(SizeChart.Split(',')[i + 1]);
                    colid_Below7.Add(d1.ToString() + "~" + d2.ToString());
                } 
            }
            double d = Convert.ToDouble(SizeChart.Split(',')[SizeChart.Split(',').Length - 1]);
            colid_Below7.Add(d.ToString() + "~MAX");
            //double d = Convert.ToDouble(SizeChart.Split(',')[SizeChart.Split(',').Length - 1]);
            //colid.Add(d.ToString() + "~MAX");
        }
        /// <summary>
        /// 获取粒级表
        /// </summary>
        /// <returns></returns>
        public List<string> GetParticlesizeTable()
        {
            if(colid.Count>7)
            {
                return colid;
            }else
            {
                return colid_Below7;
            }
            
        }
       
        public void SetDBData(c_TemplateClass m_mbszclass, OTSReport_Export m_otsreport_export, string ComputeMode)
        {
            DataTable m_bt_DBData = new DataTable();
            ParticleData fielddata = new ParticleData(m_otsreport_export.m_ReportApp.m_rstDataMgr.ResultFilesList[m_otsreport_export.m_ReportApp.m_rstDataMgr.GetWorkingResultId()].FilePath);
            List<string> colid = new List<string>() { "TypeName", "ar", "TypeId", "Largest", "Class", "GroupId", "con" };
            //获取粒级表
            string path1 = m_otsreport_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder +
                 m_otsreport_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
            DataSet ds = OTSIncAReportApp.DataOperation.DataAccess.XMLoperate.GetXml(path1);
            string sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();

            bool blBelow7 = false;

            if (sizestr.Split(',').Length>7)
            {
                for (int i = 0; i < sizestr.Split(',').Length; i++)
                {
                    if (sizestr.Split(',')[i].Length > 0)
                    {
                        double d1 = Convert.ToDouble(sizestr.Split(',')[i]);
                        //double d2 = Convert.ToDouble(sizestr.Split(',')[i + 1]);
                        colid.Add("≥" + d1.ToString() /*+ "~" + d2.ToString()*/);
                    }
                }
                blBelow7 = true;
            }
            else
            {
                for (int i = 0; i < sizestr.Split(',').Length - 1; i++)
                {
                    if (sizestr.Split(',')[i].Length > 0)
                    {
                        double d1 = Convert.ToDouble(sizestr.Split(',')[i]);
                        double d2 = Convert.ToDouble(sizestr.Split(',')[i + 1]);
                        colid.Add(d1.ToString() + "~" + d2.ToString());
                    }
                }
                double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
                colid.Add(d.ToString() + "~MAX");
                blBelow7 = false;
            }

            for (int i = 0; i < colid.Count; i++)
            {
                m_bt_DBData.Columns.Add(colid[i].ToString());
            }

            DataTable dt = InvalidRemoval(fielddata.GetParticleListForParticlSize("area", ""));
            DataTable AreaInformationOfAllElements = InvalidRemoval(fielddata.GetAreaByAllIncA(""));
            DataTable dtp = InvalidRemoval(fielddata.GetParticleAll(""));

            string po = ComputeMode;
            switch (po)
            {
                case "DMAX":
                    po = "DMAX";
                    break;
                case "DMIN":
                    po = "DMIN";
                    break;
                case "ECD":
                    po = "Area";
                    break;
                case "FERET":
                    po = "DFERET";
                    break;
            }

     



			for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr = m_bt_DBData.NewRow();
                dr["TypeName"] = dt.Rows[i]["TypeName"].ToString();
                dr["TypeId"] = dt.Rows[i]["TypeId"].ToString();
                dr["con"] = dt.Rows[i]["con"].ToString();

                dr["GroupId"] = dt.Rows[i]["GroupId"].ToString();
				if (dt.Rows[i]["GroupName"].ToString() == "")
                    dr["Class"] = "Default";
                else
                    dr["Class"] = dt.Rows[i]["GroupName"].ToString();
                //continue;
                dr["Largest"] = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);

                if(blBelow7)
                {
                    for (int a = 7; a < colid.Count; a++)
                    {
                        string d1 = colid[a].Split('≥')[1];
                        string d2;
                        if (a == colid.Count - 1)
                        {
                            d2 = "999";
                        }
                        else
                        {
                            d2 = colid[a + 1].Split('≥')[1];
                        }
                        DataRow[] datas = dtp.Select(getWhere(d2, d1, po, dt.Rows[i]["TypeId"].ToString()));
                        dr[colid[a]] = datas.Count();
                    }
                }
                else
                {
                    for (int a = 7; a < colid.Count; a++)
                    {
                        string d1 = colid[a].Split('~')[0];
                        string d2 = colid[a].Split('~')[1];
                        if (d2 == "MAX")
                        {
                            d2 = "999";
                        }
                        DataRow[] datas = dtp.Select(getWhere(d2, d1, po, dt.Rows[i]["TypeId"].ToString()));
                        dr[colid[a]] = datas.Count();
                    }
                }
             
                for (int a = 0; a < AreaInformationOfAllElements.Rows.Count; a++)
                {
                    if (dt.Rows[i]["TypeId"].ToString() == AreaInformationOfAllElements.Rows[a]["TypeId"].ToString())
                    {
                        dr["ar"] = AreaInformationOfAllElements.Rows[a]["ar"];
                    }
                }
                m_bt_DBData.Rows.Add(dr);
            }



            //去除物质分类（非夹杂物分类）
            for (int a = 0; a < m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass_Serial.Count; a++)
            {
                for (int i = m_bt_DBData.Rows.Count - 1; i >= 0; i--)
                {
                    if (m_bt_DBData.Rows[i]["TypeId"].ToString() == m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass_Serial[a].ToString())
                    {
                        m_bt_DBData.Rows.RemoveAt(i);
                    }
                }
            }
			
			GroupInformation = new List<string>();
			for (int i = 0; i < m_bt_DBData.Rows.Count; i++)
			{
				bool bl = false;
				for (int a = 0; a < GroupInformation.Count; a++)
                {
					if (GroupInformation[a] == m_bt_DBData.Rows[i]["Class"].ToString())
					{
						bl = true;
					}
				}
				if (!bl)
				{
					GroupInformation.Add(m_bt_DBData.Rows[i]["Class"].ToString());
				}
			}
            
            if (m_otsreport_export.m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.IncA)
            {
                Measurements = new List<DataTable>();

				for (int i = 0; i < GroupInformation.Count; i++)
                {
                    DataTable table = m_bt_DBData.Clone();
                    for (int a = 0; a < m_bt_DBData.Rows.Count; a++)
                    {
                        if (GroupInformation[i] == m_bt_DBData.Rows[a]["Class"].ToString())
                        {
                            table.Rows.Add(m_bt_DBData.Rows[a].ItemArray);
						}
                    }
                    BData.Add(table);
				}
                //Measurements = BData.Copy();

				for (int i = 0; i < GroupInformation.Count; i++)
				{
					DataTable table = dtp.Clone();
					for (int a = 0; a < dtp.Rows.Count; a++)
					{
						if (GroupInformation[i] == dtp.Rows[a]["GroupName"].ToString())
						{
							table.Rows.Add(dtp.Rows[a].ItemArray);
						}
					}
					Measurements.Add(table);
				}
				return;


			}

				#region 判断是否使用指定选择组和规则
				bool bl1 = false;
			for (int i = 0; i < m_otsreport_export.m_mbszclass.RuleGroup.Rows.Count; i++)
			{
				if (m_otsreport_export.m_mbszclass.RuleGroup.Rows[i]["GroupId"].ToString() == "0")
				{
					bl1 = true;
				}
			}
			#endregion

			if (!bl1)
            {
				#region 筛选现有组
				List<string> strings = new List<string>();
				for (int i = 0; i < m_bt_DBData.Rows.Count; i++)
				{
					bool bl2 = false;
					for (int a = 0; a < strings.Count; a++)
					{
						if (m_bt_DBData.Rows[i]["GroupId"].ToString() == strings[a])
						{
							bl2 = true;
						}
					}
					if (!bl2)
					{
						strings.Add(m_bt_DBData.Rows[i]["GroupId"].ToString());
					}
				}
				#endregion


				List<DataTable> OutData = new List<DataTable>();

                for (int i = 0; i < strings.Count(); i++)
                {
					DataTable data = m_bt_DBData.Clone();
					for (int a = 0; a < m_bt_DBData.Rows.Count; a++)
                    {
                        if (strings[i] == m_bt_DBData.Rows[a]["GroupId"].ToString())
                        {
                            data.Rows.Add(m_bt_DBData.Rows[a].ItemArray);
						}
                    }
                    OutData.Add(data);
				}

                BData = OutData.Copy();
				return;
			}

            List<DataTable> SpecifyGroup = new List<DataTable>();
			for (int i = 0; i < m_otsreport_export.m_mbszclass.List_data.Count; i++)
            {
				DataTable data= m_bt_DBData.Clone();

                bool b3 = false;
                string str_class = "";
                for (int a = 0; a < m_otsreport_export.m_mbszclass.RuleGroup.Rows.Count; a++)
                {
                    if (m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["GroupId"].ToString() == m_otsreport_export.m_mbszclass.List_data[i].TableName)
                    {
                        if (m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["display"].ToString() == "1")
                        {
                            str_class = m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["GroupName"].ToString();
							b3 = true;
						}
					}
                }
				data.TableName = m_otsreport_export.m_mbszclass.List_data[i].TableName;
				if (b3)
                {
					for (int a = 0; a < m_otsreport_export.m_mbszclass.List_data[i].Rows.Count; a++)
					{
						if (m_otsreport_export.m_mbszclass.List_data[i].Rows[a]["display"].ToString() == "1")
						{
							DataTable data1 = m_bt_DBData.Clone();
							DataRow row = data.NewRow();
							row["TypeName"] = m_otsreport_export.m_mbszclass.List_data[i].Rows[a]["StrName"];
							row["ar"] = 0;
							row["TypeId"] = m_otsreport_export.m_mbszclass.List_data[i].Rows[a]["STDId"];
							row["GroupId"] = m_otsreport_export.m_mbszclass.List_data[i].Rows[a]["GroupId"];
							row["con"] = 0;
                            row["Largest"] = 0;
                            row["Class"] = str_class;
                            for (int j = 7; j < data.Columns.Count; j++)
                            {
                                row[j] = 0;
							}

							bool b2 = false;
							for (int j = 0; j < m_bt_DBData.Rows.Count; j++)
							{
								if (m_otsreport_export.m_mbszclass.List_data[i].Rows[a]["STDId"].ToString() == m_bt_DBData.Rows[j]["TypeId"].ToString())
								{
									data1.Rows.Add(m_bt_DBData.Rows[j].ItemArray);
									b2 = true;
								}
							}
							if (b2)
							{
								data.Rows.Add(data1.Rows[0].ItemArray);
							}
							else
							{
								data.Rows.Add(row);
							}
						}
					}
				}
				SpecifyGroup.Add(data);
			}

            BData = SpecifyGroup.Copy();



            #region 测量结果颗粒组队列
            List<DataTable> datas1 = new List<DataTable>();
			List<string> stringsa = fielddata.ObtainParticleCategory(m_otsreport_export, this);
			for (int i = 0; i < stringsa.Count; i++)
			{
				DataTable data = dtp.Clone();
				for (int a = 0; a < dtp.Rows.Count; a++)
				{
					if (Convert.ToInt64(dtp.Rows[i]["TypeId"]) > 10)
					{
						if (stringsa[i].ToString() == dtp.Rows[a]["GroupName"].ToString())
						{
							data.Rows.Add(dtp.Rows[a].ItemArray);
						}
					}
				}
				datas1.Add(data);
			}

			Measurements = new List<DataTable>();
			for (int i = 0; i < m_otsreport_export.m_mbszclass.List_data.Count; i++)
            {
				bool b3 = false;
				string str_class = "";
				for (int a = 0; a < m_otsreport_export.m_mbszclass.RuleGroup.Rows.Count; a++)
				{
					if (m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["GroupId"].ToString() == m_otsreport_export.m_mbszclass.List_data[i].TableName)
					{
						if (m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["display"].ToString() == "1")
						{
							str_class = m_otsreport_export.m_mbszclass.RuleGroup.Rows[a]["GroupName"].ToString();
							b3 = true;
						}
					}
				}

                
				if (b3)
                {
					DataTable table = datas1[i].Clone();
					for (int a = 0; a < datas1[i].Rows.Count; a++)
                    {
						for (int b = 0; b < m_otsreport_export.m_mbszclass.List_data[i].Rows.Count; b++)
                        {
                            if (m_otsreport_export.m_mbszclass.List_data[i].Rows[b]["display"].ToString() == "1")
                            {
								if (datas1[i].Rows[a]["TypeId"].ToString() == m_otsreport_export.m_mbszclass.List_data[i].Rows[b]["STDId"].ToString())
								{
									table.Rows.Add(datas1[i].Rows[a].ItemArray);
								}
							}
                        }
					}
					Measurements.Add(table);
				}
			}
			#endregion

		}
        /// <summary>
        /// 获取夹杂物组信息
        /// </summary>
        /// <returns></returns>

        public List<string> GetGroupInformation()
        {
            return GroupInformation;
		}
		/// <summary>
		/// 获取读取数据库并过滤颗粒
		/// </summary>
		/// <returns></returns>
		public List<DataTable> GetDBData()
		{
			return BData;
		}
		/// <summary>
		/// 获取读取数据库并过滤颗粒
		/// </summary>
		/// <returns></returns>
		public List<DataTable> etDBData()
        {
            return BData;
        }
        public void SetAllClass()
        {
            AllClass = fielddata.GetAllClass();
        }
        /// <summary>
        /// 获取全部大类
        /// </summary>
        /// <returns></returns>
        public DataTable GetAllClass()
        {
            return AllClass;
        }
        /// <summary>
        ///测量结果数据列队
        /// </summary>
        /// <returns></returns>
        public List<DataTable> GetMeasurements()
        {
            return Measurements;

		}

		/// <summary>
		/// 定义ParticleData类
		/// </summary>
		public void newParticleData(OTSReport_Export m_otsreport_export)
        {
            fielddata = new ParticleData(m_otsreport_export.m_ReportApp.m_rstDataMgr.ResultFilesList[m_otsreport_export.m_ReportApp.m_rstDataMgr.GetWorkingResultId()].FilePath);
        }
        public ParticleData getParticleData()
        {
            return fielddata;
        }
        public void SetAllElement()
        {
            AllElement = fielddata.GetAllElement();
        }
        /// <summary>
        /// 获取全部元素
        /// </summary>
        /// <returns></returns>
        public DataTable GetAllElement()
        {
            return AllElement;
        }
        /// <summary>
        /// 判断是否有大分类，有为true
        /// </summary>
        /// <param name="m_otsreport_export"></param>
        /// <returns></returns>
        public void IsThereAMajorClassification(BasicData basicData, OTSReport_Export m_otsreport_export)
        {
            //List<string> ClassName = ObtainParticleCategory(m_otsreport_export, basicData);
            List<string> ClassName = new List<string>();

			for (int i = 0; i < BData.Count; i++)
            {
                if (BData[i].Rows.Count != 0)
                {
                    ClassName.Add(i.ToString());
				}
            }

			if (ClassName.Count < 2)
            {
                IsShereAClassificationGroup= false;
            }
            else
            {
                IsShereAClassificationGroup= true;
            }
        }
        public bool GetIsThereAMajorClassification()
        {
            return IsShereAClassificationGroup;
        }
		/// <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
			{
				ClassName = basicData.GetGroupInformation();
			}
			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;
		}
		public void IsResultFilesList(OTSReport_Export m_otsreport_export)
        {
            resfile = m_otsreport_export.m_ReportApp.m_rstDataMgr.ResultFilesList[m_otsreport_export.m_ReportApp.m_rstDataMgr.GetWorkingResultId()];
        }
        /// <summary>
        /// 获取标准库名称
        /// </summary>
        /// <returns></returns>
        public string GetResfile()
        {
            return resfile.GetSTDName();
        }
        public void IsFilePath(OTSReport_Export m_otsreport_export)
        {
            FilePath= m_otsreport_export.m_ReportApp.m_rstDataMgr.CurResultFile.FilePath;
        }
        /// <summary>
        /// 得到文件路径
        /// </summary>
        /// <returns></returns>
        public string GetFilePath()
        {
            return FilePath;
        }

        #region 内部函数
        private string getWhere(string max, string min, string col, string partic)
        {
            return col + ">=" + min + " and " + col + "<" + max + " and TypeId=" + partic;
        }
        private DataTable InvalidRemoval(DataTable dt)
        {
            DataTable dataTable = dt.Copy();
            dataTable.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 10)
                {
                    dataTable.Rows.Add(dt.Rows[i].ItemArray);
                }
            }
            return dataTable;
        }
        #endregion



    }
}