OTS/OTSIncAReportApp/1-UI/Control_ECharts/EChart_ParticlesComposition.cs

using CefSharp;
using CefSharp.WinForms;
using Newtonsoft.Json;
using OTSIncAReportApp.DataOperation.DataAccess;
using OTSIncAReportApp.DataOperation.Model;
using OTSIncAReportApp.OTSDataMgrFunction;
using OTSIncAReportApp.OTSSampleReportInfo;
using OTSIncAReportApp.OTSTemplateDesigner;
using OTSIncAReportApp.SysMgrTools;
using OTSIncAReportGrids;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Windows.Forms;

namespace OTSIncAReportApp.Control_ECharts
{
    /// <summary>
    /// 各图char相关模块
    /// </summary>
    public partial class EChart_ParticlesComposition : UserControl
    {
        Hashtable table;

        #region 图表相关变量
        //y轴名称
        public string m_str_AxisY { get; set; }

        //定义图片
        //JsEvent js;
        //定义图片base64
        public string pic { get; set; }
        //定义图形类型
        public string type { get; set; }
        //图形数据
        public string data { get; set; }

        string url = "Resources/HTML/charts.html";
        //数据图类型:常用夹杂物分类CommonlyUsedClassify ,颗粒成分PComponent，元素成分EComponent，颗粒尺寸分布PSize
        string ComSel { get; set; }
        frmReportApp m_ReportApp;
        List<int> FLID = new List<int>() { 0, 1, 2, 4, 6, 7, 8, 9 };
        List<string> NameList = new List<string>() { "过小颗粒", "过大颗粒", "亮度不在分析范围内的颗粒", "低计数率颗粒", "不含分析元素的颗粒", "非夹杂物颗粒SiC", "非夹杂物颗粒FeO", "未识别颗粒" };
        private frmReportConditionChoose m_conditionChoose;
        private ResultDataMgr m_DataMgr;
        Export_ReportTemplate m_export_reporttemplate;
        #endregion

        #region 窗体加载及构造函数
        public EChart_ParticlesComposition(frmReportApp ReportApp, string comsel)
        {
            ComSel = comsel;
            m_ReportApp = ReportApp;
            m_conditionChoose = ReportApp.m_conditionChoose;
            m_DataMgr = ReportApp.m_rstDataMgr;
            InitializeComponent();
            //国际化
            Language lan = new Language();
            table = lan.GetNameTable("CompositionDistributionGrid");

            m_export_reporttemplate = new Export_ReportTemplate();
        }
        private void EChart_ParticlesComposition_Load(object sender, EventArgs e)
        {
            

            NameList = new List<string>() { table["partcletype0"].ToString(), table["partcletype1"].ToString(), table["partcletype2"].ToString(), table["partcletype4"].ToString(), table["partcletype6"].ToString(), table["partcletype7"].ToString(), table["partcletype8"].ToString(), table["partcletype9"].ToString() };

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
            //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
            string sou = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
            if (sou.Contains("+"))
            {
                if (m_ReportApp.more)
                {
                    m_ReportApp.trans = false;
                }
                else
                {
                    m_ReportApp.trans = true;
                }
                m_ReportApp.more = true;

                //获取到List,json的字符串
                ChartdateMore list_json_str = GetListJsonStr();
                url = "Resources/HTML/chartsMore.html";
                m_ReportApp.data = JsonConvert.SerializeObject(list_json_str);
            }
            else
            {
                if (!m_ReportApp.more)
                {
                    m_ReportApp.trans = false;
                }
                else
                {
                    m_ReportApp.trans = true;
                }
                m_ReportApp.more = false;
                //获取到List,json的字符串
                List<Chartdate> list_json_str = GetListJsonStrByChartStruct();
                url = "Resources/HTML/charts.html";
                m_ReportApp.data = JsonConvert.SerializeObject(list_json_str[0]);
            }
            InitBrowser();
        }

        #endregion

        #region 获取单数据源
        private Chartdate GetCommonlyUsedClassifyData(string path)
        {
            string spinel = table["str20"].ToString();
            string oxide = table["str21"].ToString();
            string SulfurOxide = table["str22"].ToString();
            string nitrides = table["str23"].ToString();
            string sulfide = table["str24"].ToString();
            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
            //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            DataTable dt = new DataTable();
            if (sel == 1)
            {
                
                List<Particle> particles = m_ReportApp.GetSelectedParticles();
                int SPINEL = 0;
                int OXIDE = 0;
                int SULFIDE_OXIDE = 0;
                int NITRIDE = 0;
                int SULFIDE = 0;
                for (int i = 0; i < m_ReportApp.GetSelectedParticles().Count; i++)
                {
                    //SPINEL 
                    if ((particles[i].TypeId >= 10100 || particles[i].TypeId <= 10199) || (particles[i].TypeId >= 12200 || particles[i].TypeId <= 12299) || (particles[i].TypeId >= 11300 || particles[i].TypeId <= 11299))
                    {
                        SPINEL = SPINEL + 1;
                    }
                    //OXIDE 
                    if (particles[i].TypeId >= 10000 || particles[i].TypeId <= 10999)
                    {
                        OXIDE = OXIDE + 1;
                    }
                    //SULFIDE_OXIDE
                    if ((particles[i].TypeId >= 11200 || particles[i].TypeId <= 11299) || (particles[i].TypeId >= 11400 || particles[i].TypeId <= 11499) || (particles[i].TypeId >= 11200 || particles[i].TypeId <= 11599))
                    {
                        SULFIDE_OXIDE = SULFIDE_OXIDE + 1;
                    }
                    //NITRIDE 
                    if (particles[i].TypeId >= 12000 || particles[i].TypeId <= 12999)
                    {
                        NITRIDE = NITRIDE + 1;
                    }
                    //SULFIDE 
                    if (particles[i].TypeId >= 11000 || particles[i].TypeId <= 11999)
                    {
                        SULFIDE = SULFIDE + 1;
                    }
                }
                DataTable dataTable = new DataTable();
                dataTable.Columns.Add("SPINEL", typeof(String));
                dataTable.Columns.Add("OXIDE", typeof(String));
                dataTable.Columns.Add("SULFIDE_OXIDE", typeof(String));
                dataTable.Columns.Add("NITRIDE", typeof(String));
                dataTable.Columns.Add("SULFIDE", typeof(String));
                dataTable.Rows.Add();
                dataTable.Rows[0]["SPINEL"] = SPINEL.ToString();
                dataTable.Rows[0]["OXIDE"] = OXIDE.ToString();
                dataTable.Rows[0]["SULFIDE_OXIDE"] = SULFIDE_OXIDE.ToString();
                dataTable.Rows[0]["NITRIDE"] = NITRIDE.ToString();
                dataTable.Rows[0]["SULFIDE"] = SULFIDE.ToString();
                dt = dataTable;

            }
            else
            {
                dt = particledata.GetCommonlyUsedClassifyData();
            }


            //DataTable dt = dataTable;

            //设置标签名称
            List<string> listName = new List<string>();
            listName.Add(spinel);
            listName.Add(oxide);
            listName.Add(SulfurOxide);
            listName.Add(nitrides);
            listName.Add(sulfide);
            chart.ListName = listName;

            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                try
                {
                    Item item_SPINEL = new Item()
                    {
                        value = decimal.Round(decimal.Parse(dt.Rows[k]["SPINEL"].ToString()), 2).ToString(),
                        name = spinel
                    };
                    listData.Add(item_SPINEL);
                    Item item_OXIDE = new Item()
                    {
                        value = decimal.Round(decimal.Parse(dt.Rows[k]["OXIDE"].ToString()), 2).ToString(),
                        name = oxide
                    };
                    listData.Add(item_OXIDE);
                    Item item_SULFIDE_OXIDE = new Item()
                    {
                        value = decimal.Round(decimal.Parse(dt.Rows[k]["SULFIDE_OXIDE"].ToString()), 2).ToString(),
                        name = SulfurOxide
                    };
                    listData.Add(item_SULFIDE_OXIDE);
                    Item item_NITRIDE = new Item()
                    {
                        value = decimal.Round(decimal.Parse(dt.Rows[k]["NITRIDE"].ToString()), 2).ToString(),
                        name = nitrides
                    };
                    listData.Add(item_NITRIDE);
                    Item item_SULFIDE = new Item()
                    {
                        value = decimal.Round(decimal.Parse(dt.Rows[k]["SULFIDE"].ToString()), 2).ToString(),
                        name = sulfide
                    };
                    listData.Add(item_SULFIDE);
                }
                catch
                {
                    Item item = new Item()
                    {
                        value = "",
                        name = ""
                    };
                    listData.Add(item);
                }
            }
            chart.ListData = listData;

            return chart;
        }

        private Chartdate GetInclusionAreaRatioData(string path)
        {
            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            DataTable dt = particledata.GetAreaByAllIncA("");
            //设置标签名称
            List<string> listName = new List<string>();
            //ListName
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
                {
                    continue;
                }
                listName.Add(dt.Rows[i]["TypeName"].ToString());
            }
            //for (int i = 0; i < dt.Rows.Count; i++)
            //{
            //    if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100)
            //    {
            //        continue;
            //    }
            //    int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
            //    if (index == -1)
            //    {
            //        index = 7;
            //    }
            //    string name = NameList[index];
            //    if (listName.IndexOf(name) == -1)
            //    {
            //        listName.Add(name);

            //    }
            //}
            chart.ListName = listName;

            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                string str = dt.Rows[k]["ar"].ToString();
                string name = dt.Rows[k]["TypeName"].ToString();
                if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
                {
                    continue;
                }

                Item item = new Item()
                {
                    value = decimal.Round(decimal.Parse(dt.Rows[k]["ar"].ToString()), 2).ToString(),
                    name = name
                };
                listData.Add(item);

            }
            chart.ListData = listData;
            return chart;
        }

        private Chartdate GetInclusionAreaRatioClassData(string path)
        {
            
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            //计算分类整个表的数据
            DataTable dt= ClassificationIntegration(path);
            List<string> listName = new List<string>();
            //ListName
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                listName.Add(dt.Rows[i]["e1"].ToString());
            }
            chart.ListName = listName;
            //DataTable dt 
            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                string str = dt.Rows[k]["e3"].ToString();
                string name = dt.Rows[k]["e1"].ToString();
                

                Item item = new Item()
                {
                    value = decimal.Round(decimal.Parse(dt.Rows[k]["e3"].ToString()), 2).ToString(),
                    name = name
                };
                listData.Add(item);

            }
            chart.ListData = listData;
            return chart;
        }

        private DataTable ClassificationIntegration(string path )
        {

            //------------------加载模块,获取数据-------------------------------------------------
            ResultGrid ls_resultgrid = new ResultGrid(m_ReportApp);
            Dictionary<string, string> keyValues_ResultGrid = ls_resultgrid.GetData_ResultGrid();
            //------------------加载模块,获取数据结束----------------------------------------------
            Dictionary<string, string>.Enumerator en = keyValues_ResultGrid.GetEnumerator();
         
            string str_SCZS = "";
          
            keyValues_ResultGrid.TryGetValue(ls_resultgrid.table["col5"].ToString(), out str_SCZS);//视场总数

            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            DataTable AreaInformationOfAllElements = particledata.GetAreaByAllIncA("");//获取所有分类面积和数量信息
            DataTable AllAnalysisDetails = new DataTable();
            AllAnalysisDetails.Columns.Add("Name");
            AllAnalysisDetails.Columns.Add("TypeId");
            AllAnalysisDetails.Columns.Add("Area", typeof(double));
            AllAnalysisDetails.Columns.Add("Class");
            AllAnalysisDetails.Columns.Add("Cunt", typeof(double));
            for (int i = 0; i < AreaInformationOfAllElements.Rows.Count; i++)
            {
                DataRow dr2 = AllAnalysisDetails.NewRow();
                dr2["Name"] = AreaInformationOfAllElements.Rows[i]["TypeName"].ToString();
                dr2["Area"] = Convert.ToDouble(AreaInformationOfAllElements.Rows[i]["ar"]);
                dr2["TypeId"] = AreaInformationOfAllElements.Rows[i]["TypeId"].ToString();
                dr2["Cunt"] = Convert.ToDouble(AreaInformationOfAllElements.Rows[i]["con"]);
                dr2["Class"] = AreaInformationOfAllElements.Rows[i]["GroupName"].ToString();
                AllAnalysisDetails.Rows.Add(dr2);
            }
            //按照list列表进行物质类排序，物质类中的元素分类按照面积的大小进行排序
            List<string> ClassName = new List<string>();
            DataTable getClass_dt = particledata.GetAllClass();
            for (int i = 0; i < getClass_dt.Rows.Count; i++)
            {
                ClassName.Add(getClass_dt.Rows[i]["GroupName"].ToString());
            }

            DataTable AreaRatio = new DataTable();
            AreaRatio.TableName = "InclusionAreaRatio";
            AreaRatio.Columns.Add("e1");
            AreaRatio.Columns.Add("e2");
            AreaRatio.Columns.Add("e3", typeof(double));
            AreaRatio.Columns.Add("e4");
            AreaRatio.Columns.Add("e5");
            AreaRatio.Columns.Add("Cunt", typeof(int));

            //获取夹杂物的总面积用于计算夹杂物类别的占比（gridview最后一个固定是未识别颗粒，要排除未识别颗粒所以for循环至grid view长度减一）
            double totalInclusionArea = 0;
            totalInclusionArea = Convert.ToDouble(decimal.Parse(AllAnalysisDetails.Compute("sum(Area)", "").ToString()));
            for (int i = 0; i < AllAnalysisDetails.Rows.Count; i++)
            {
                DataRow dr2 = AreaRatio.NewRow();
                dr2["e1"] = AllAnalysisDetails.Rows[i]["Class"].ToString();
                dr2["e2"] = AllAnalysisDetails.Rows[i]["Name"].ToString();
                dr2["e3"] = Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]);
                dr2["e4"] = Math.Round((Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]) / totalInclusionArea) * 100, 2);
                dr2["e5"] = Math.Round((Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]) / Convert.ToDouble(str_SCZS)) * 100, 4);
                dr2["Cunt"]= AllAnalysisDetails.Rows[i]["Cunt"].ToString();
                AreaRatio.Rows.Add(dr2);
            }


            DataTable AreaRatio_dt = AreaRatio.Copy();
            AreaRatio_dt.Clear();

            for (int i = 0; i < ClassName.Count(); i++)
            {
                DataTable dt = AreaRatio.Copy();
                dt.Clear();
                for (int a = 0; a < AreaRatio.Rows.Count; a++)
                {
                    if (AreaRatio.Rows[a]["e1"].ToString() == ClassName[i].ToString())
                    {
                        dt.Rows.Add(AreaRatio.Rows[a].ItemArray);
                    }
                }

                DataView dv = dt.DefaultView;
                dv.Sort = "e3 DESC";
                DataTable dt_Element = dv.ToTable();
                for (int a = 0; a < dt_Element.Rows.Count; a++)
                {
                    AreaRatio_dt.Rows.Add(dt_Element.Rows[a].ItemArray);
                }
            }


            DataTable AllAnalysisDetails1 = AreaRatio_dt.Copy();
            AllAnalysisDetails1.Clear();

            for (int i = 0; i < ClassName.Count; i++)
            {
                DataTable dt = AreaRatio_dt.Copy();
                dt.Clear();
                for (int a = 0; a < AreaRatio_dt.Rows.Count; a++)
                {
                    if (AreaRatio_dt.Rows[a]["e1"].ToString() == ClassName[i].ToString())
                    {
                        dt.Rows.Add(AreaRatio_dt.Rows[a].ItemArray);
                    }
                }
                if (dt.Rows.Count > 0)
                {
                    double totalInclusionArea2 = Convert.ToDouble(decimal.Parse(AreaRatio_dt.Compute("sum(e3)", "").ToString()));
                    double Area = Convert.ToDouble(decimal.Parse(dt.Compute("sum(e3)", "").ToString()));
                    int cunt= Convert.ToInt32(decimal.Parse(dt.Compute("sum(Cunt)", "").ToString()));
                    DataRow dr3 = AllAnalysisDetails1.NewRow();
                    dr3["e1"] = ClassName[i].ToString();
                    dr3["e3"] = Math.Round(Area, 2);
                    //Convert.ToDouble(decimal.Parse(dt.Compute("sum(e3)", "").ToString()));
                    dr3["e4"] = Math.Round((Convert.ToDouble(dt.Rows[0]["e3"]) / totalInclusionArea2) * 100, 2);
                    dr3["e5"] = Math.Round((Convert.ToDouble(dt.Rows[0]["e3"]) / Convert.ToDouble(str_SCZS)) * 100, 4);
                    dr3["Cunt"] = cunt;
                    AllAnalysisDetails1.Rows.Add(dr3);
                }
            }
            return AllAnalysisDetails1;
        }

        /// <summary>
        /// 获取颗粒成分数据
        /// </summary>
        private Chartdate GetPComponentData(string path)
        {

            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
            //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);

            string filedAndParticl = "";
            if (sel == 1)
            {
                List<OTSIncAReportApp.DataOperation.Model.Particle> selectParticles = m_ReportApp.GetSelectedParticles();
                foreach (var item in selectParticles)
                {
                    filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
                }
                if (filedAndParticl != "")
                {
                    filedAndParticl = filedAndParticl + ",";
                }
            }

            DataTable dt = particledata.GetParticleListForParticlSize("area", filedAndParticl);
            //设置标签名称
            List<string> listName = new List<string>();
            //ListName
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
                {
                    continue;
                }
                listName.Add(dt.Rows[i]["TypeName"].ToString());
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100)
                {
                    continue;
                }
                int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
                if (index == -1)
                {
                    index = 7;
                }
                string name = NameList[index];
                if (listName.IndexOf(name) == -1)
                {
                    listName.Add(name);

                }
            }
            chart.ListName = listName;

            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                string str = dt.Rows[k]["con"].ToString();
                string name = dt.Rows[k]["TypeName"].ToString();
                if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
                {
                    int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[k]["TypeId"]));
                    if (index == -1)
                    {
                        index = 7;
                    }
                    name = NameList[index];
                }

                Item item = new Item()
                {
                    value = decimal.Round(decimal.Parse(str), 2).ToString(),
                    name = name
                };
                listData.Add(item);

            }
            chart.ListData = listData;
            return chart;
        }
        /// <summary>
        /// 获取元素成分数据
        /// </summary>
        private Chartdate GetEComponentData(string path)
        {

            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
            //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            string filedAndParticl = "";
            if (sel == 1)
            {
                List<OTSIncAReportApp.DataOperation.Model.Particle> selectParticles = m_ReportApp.GetSelectedParticles();
                foreach (var item in selectParticles)
                {
                    filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
                }
                if (filedAndParticl != "")
                {
                    filedAndParticl = filedAndParticl + ",";
                }
            }

            DataTable dt = particledata.GetElementForArea(filedAndParticl);

            //设置标签名称
            List<string> listName = new List<string>();
            //ListName
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                listName.Add(dt.Rows[i]["name"].ToString());
            }
            chart.ListName = listName;

            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < dt.Rows.Count; k++)
            {
                string str = dt.Rows[k]["earea"].ToString();
                try
                {
                    Item item = new Item()
                    {
                        value = decimal.Round(decimal.Parse(str), 2).ToString(),
                        name = dt.Rows[k]["name"].ToString()
                    };
                    listData.Add(item);
                }
                catch
                {
                    Item item = new Item()
                    {
                        value = str,
                        name = dt.Rows[k]["name"].ToString()
                    };
                    listData.Add(item);
                }
            }
            chart.ListData = listData;
            return chart;
        }
        /// <summary>
        /// 获取此尺寸分布图数据
        /// </summary>
        private Chartdate GetPSizeData(string path)
        {

            DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
            //创建新的图形数据源
            Chartdate chart = new Chartdate();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;

            //设置标签名称
            List<string> listName = new List<string>();

            //获取粒级表
            string pathe = m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder + m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
            DataSet ds = DataOperation.DataAccess.XMLoperate.GetXml(pathe);
            string sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();

            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]);
                    listName.Add(d1.ToString() + "~" + d2.ToString());
                }
            }
            double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
            listName.Add(d.ToString() + "~MAX");
            chart.ListName = listName;

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
            //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            string filedAndParticl = "";
            if (sel == 1)
            {
                List<OTSIncAReportApp.DataOperation.Model.Particle> selectParticles = m_ReportApp.GetSelectedParticles();
                foreach (var item in selectParticles)
                {
                    filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
                }
                if (filedAndParticl != "")
                {
                    filedAndParticl = filedAndParticl + ",";
                }
            }

            //idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE);
            //string con = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
            string con = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
            string po = "";
            switch (con)
            {
                case "DMAX":
                    po = "DMAX";
                    break;
                case "DMIN":
                    po = "DMIN";
                    break;
                case "CIRCLE":
                    po = "Area";
                    break;
                case "FERET":
                    po = "DFERET";
                    break;
            }
            DataTable dtp = particledata.GetParticleAll(filedAndParticl);

            //设置数据
            List<Item> listData = new List<Item>();
            //ListData
            for (int k = 0; k < listName.Count; k++)
            {
                string str = listName[k];
                string d1 = str.Split('~')[0];
                string d2 = str.Split('~')[1];
                if (d2 == "MAX")
                {
                    d2 = "999";
                }
                DataRow[] datas = dtp.Select(getWhere(d2, d1, po));


                Item item = new Item()
                {
                    value = datas.Count().ToString(),
                    name = str
                };
                listData.Add(item);
            }
            chart.ListData = listData;
            return chart;
        }
        private string getWhere(string max, string min, string col)
        {
            return col + ">=" + min + " and " + col + "<=" + max;
        }
        #endregion

        #region echarts

        /// <summary>
        /// 通过m_list_chartstruct,组合json数据格式
        /// </summary>
        /// <returns></returns>
        private List<Chartdate> GetListJsonStrByChartStruct()
        {
            List<Chartdate> list = new List<Chartdate>();
            Chartdate chartdate = new Chartdate();
            switch (ComSel)
            {
                case "CommonlyUsedClassify":
                    //chartdate = GetCommonlyUsedClassifyData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    chartdate = GetInclusionAreaRatioClassData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
                case "PComponent":
                    chartdate = GetPComponentData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
                case "EComponent":
                    chartdate = GetEComponentData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
                case "PSize":
                    chartdate = GetPSizeData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
                case "InclusionareaRatio":
                    chartdate = GetInclusionAreaRatioData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
                case "InclusionareaClassRatio":
                    chartdate=GetInclusionAreaRatioClassData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
                    break;
            }


            list.Add(chartdate);
            return list;
        }
        /// <summary>
        /// 通过m_list_chartstruct,组合json数据格式
        /// </summary>
        /// <returns></returns>
        private ChartdateMore GetListJsonStr()
        {
            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
            int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            string filedAndParticl = "";
            if (sel == 1)
            {
                List<OTSIncAReportApp.DataOperation.Model.Particle> selectParticles = m_ReportApp.GetSelectedParticles();
                foreach (var item in selectParticles)
                {
                    filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
                }
                if (filedAndParticl != "")
                {
                    filedAndParticl = filedAndParticl + ",";
                }
            }
            DataOperation.DataAccess.ParticleData particledata = null;
            DataTable dt = new DataTable();

            ChartdateMore chart = new ChartdateMore();
            chart.Title = m_ReportApp.m_reportname;
            chart.YName = m_str_AxisY;
            List<string> listName = new List<string>();
            List<string> soursName = new List<string>();
            List<List<Item>> listDataMore = new List<List<Item>>();

            //idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
            //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
            string sou = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
            if (sou.Contains("+"))
            {
                for (int i = 0; i < sou.Split('+').Length; i++)
                {
                    DataOperation.Model.ResultFile resultFile = m_DataMgr.ResultFilesList.Find(s => s.FileName == sou.Split('+')[i]);
                    if (resultFile == null)
                    {
                        continue;
                    }

                    soursName.Add(resultFile.FileName);
                    particledata = new DataOperation.DataAccess.ParticleData(resultFile.FilePath);
                    switch (ComSel)
                    {
                        case "CommonlyUsedClassify":
                            break;

                        case "PComponent":
                            //创建新的图形数据源
                            dt = particledata.GetParticleListByIncA("area");
                            //设置标签名称
                            for (int j = 0; j < dt.Rows.Count; j++)
                            {
                                if (Convert.ToInt32(dt.Rows[j]["TypeId"]) < 100)
                                {
                                    continue;
                                }
                                string name = dt.Rows[j]["TypeName"].ToString();
                                if (!listName.Contains(name))
                                {
                                    listName.Add(name);
                                }
                            }
                            for (int j = 0; j < dt.Rows.Count; j++)
                            {
                                if (Convert.ToInt32(dt.Rows[j]["TypeId"]) > 100)
                                {
                                    continue;
                                }
                                int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[j]["TypeId"]));
                                if (index == -1)
                                {
                                    index = 7;
                                }
                                string name = NameList[index];
                                if (!listName.Contains(name))
                                {
                                    listName.Add(name);
                                }
                            }
                            //设置数据
                            List<Item> listData = new List<Item>();
                            //ListData
                            for (int k = 0; k < dt.Rows.Count; k++)
                            {
                                string str = dt.Rows[k]["con"].ToString();
                                string name = dt.Rows[k]["TypeName"].ToString();
                                if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
                                {
                                    int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[k]["TypeId"]));
                                    name = NameList[index];
                                }

                                Item item = new Item()
                                {
                                    value = decimal.Round(decimal.Parse(str), 2).ToString(),
                                    name = name
                                };
                                listData.Add(item);



                            }
                            listDataMore.Add(listData);
                            break;
                        case "EComponent":
                            //创建新的图形数据源
                            dt = particledata.GetElementForArea(filedAndParticl);
                            //ListName
                            for (int j = 0; j < dt.Rows.Count; j++)
                            {
                                string name = dt.Rows[j]["name"].ToString();
                                if (!listName.Contains(name))
                                {
                                    listName.Add(name);
                                }
                            }
                            //设置数据
                            List<Item> listData1 = new List<Item>();
                            //ListData
                            for (int k = 0; k < dt.Rows.Count; k++)
                            {
                                string str = dt.Rows[k]["earea"].ToString();
                                try
                                {
                                    Item item = new Item()
                                    {
                                        value = decimal.Round(decimal.Parse(str), 2).ToString(),
                                        name = dt.Rows[k]["name"].ToString()
                                    };
                                    listData1.Add(item);
                                }
                                catch
                                {
                                    Item item = new Item()
                                    {
                                        value = str,
                                        name = dt.Rows[k]["name"].ToString()
                                    };
                                    listData1.Add(item);
                                }
                            }
                            listDataMore.Add(listData1);
                            break;
                        case "PSize":
                            //获取粒级表
                            string pathe = m_DataMgr.m_RptConfigFile.PartSizeFileFolder + m_DataMgr.m_RptConfigFile.PartSizeFile;
                            DataSet ds = DataOperation.DataAccess.XMLoperate.GetXml(pathe);
                            string sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();
                            List<string> temp = new List<string>();
                            for (int j = 0; j < sizestr.Split(',').Length - 1; j++)
                            {
                                if (sizestr.Split(',')[j].Length > 0)
                                {
                                    double d1 = Convert.ToDouble(sizestr.Split(',')[j]);
                                    double d2 = Convert.ToDouble(sizestr.Split(',')[j + 1]);
                                    string name = d1.ToString() + "~" + d2.ToString();
                                    temp.Add(name);
                                    if (!listName.Contains(name))
                                    {
                                        listName.Add(name);
                                    }
                                }
                            }
                            double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
                            string name1 = d.ToString() + "~MAX";
                            temp.Add(name1);
                            if (!listName.Contains(name1))
                            {
                                listName.Add(name1);
                            }
                            //string con = m_ReportApp.SourceGridData.ConditionItemList[m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE)].itemVal.ToString();
                            string con = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
                            string po = "";
                            switch (con)
                            {
                                case "DMAX":
                                    po = "DMAX";
                                    break;
                                case "DMIN":
                                    po = "DMIN";
                                    break;
                                case "Area":
                                    po = "Area";
                                    break;
                                case "FERET":
                                    po = "DFERET";
                                    break;
                            }
                            DataTable dtp = particledata.GetParticleAll(filedAndParticl);

                            //设置数据
                            List<Item> listData2 = new List<Item>();
                            //ListData
                            for (int k = 0; k < temp.Count; k++)
                            {
                                string str = temp[k];
                                string d1 = str.Split('~')[0];
                                string d2 = str.Split('~')[1];
                                if (d2 == "MAX")
                                {
                                    d2 = "999";
                                }
                                DataRow[] datas = dtp.Select(getWhere(d2, d1, po));
                                Item item = new Item()
                                {
                                    value = datas.Count().ToString(),
                                    name = str
                                };
                                listData2.Add(item);
                            }
                            listDataMore.Add(listData2);
                            break;
                    }
                }
            }
            chart.ListName = listName;
            chart.SoursName = soursName;
            chart.ListData = listDataMore;
            return chart;
        }

        class Chartdate
        {
            public string Title { get; set; }
            public string YName { get; set; }

            public List<string> ListName { get; set; }
            public List<Item> ListData { get; set; }
        }
        class ChartdateMore
        {
            public string Title { get; set; }
            public string YName { get; set; }

            public List<string> ListName { get; set; }
            public List<string> SoursName { get; set; }
            public List<List<Item>> ListData { get; set; }
        }
        class Item
        {
            public string value { get; set; }
            public string name { get; set; }
        }


        //获取图片
        private void button1_Click(object sender, EventArgs e)
        {
            //string str = GetPic();
            //pic = str;

            ////保存目录
            //string dir = Path.Combine(Directory.GetCurrentDirectory(), "Resources/HTML/pic");

            ////文件名称
            //string fileName = "headdemo" + DateTime.Now.ToString("yyyyMMddHHmmssff");
            ////保存文件所在站点位置
            //string filePath = Path.Combine(dir, fileName);

            //if (!System.IO.Directory.Exists(dir))
            //    System.IO.Directory.CreateDirectory(dir);



            ////将Base64String转为图片并保存
            //byte[] arr2 = Convert.FromBase64String(str.Substring(str.IndexOf(',') + 1));
            //using (MemoryStream ms2 = new MemoryStream(arr2))
            //{
            //    System.Drawing.Bitmap bmp2 = new System.Drawing.Bitmap(ms2);
            //    bmp2.Save(filePath + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);

            //}
        }
        /// <summary>
        /// 加载浏览器
        /// </summary>
        public void InitBrowser()
        {
            //加载网页
            if (m_ReportApp.browser == null || m_ReportApp.trans)
            {
                // 获取生成路径下网页文件的绝对路径
                string fileName = Path.Combine(Directory.GetCurrentDirectory(), url);
                //加载网页
                m_ReportApp.browser = new ChromiumWebBrowser(fileName);
                //禁止网页
                m_ReportApp.browser.MenuHandler = new MenuHandler();
                m_ReportApp.browser.Dock = DockStyle.Fill;
                m_ReportApp.js.MessageText = "";
                //添加网页到当前自定义控件
                this.Controls.Add(m_ReportApp.browser);

                //供页面调用以传递数据
                m_ReportApp.browser.RegisterJsObject("jsObj", m_ReportApp.js, false);
                //升级cef版本后新方法
                //CefSharpSettings.LegacyJavascriptBindingEnabled = true;
                //CefSharpSettings.WcfEnabled = true;
                //m_ReportApp.browser.JavascriptObjectRepository.Register("jsObj", m_ReportApp.js, isAsync: false, options: BindingOptions.DefaultBinder);

                //网页加载结束后调用事件
                m_ReportApp.browser.FrameLoadEnd += WebBrowser_FrameLoadEnd;
            }
            else
            {
                m_ReportApp.browser.ResetText();
                m_ReportApp.browser.Reload();
                m_ReportApp.browser.Refresh();

                //供页面调用以传递数据
                this.Controls.Add(m_ReportApp.browser);
            }

            if (m_ReportApp.timerKG)
            {
                timer1.Enabled = true;
            }
        }
        /// <summary>
        /// 页面加载结束后事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void WebBrowser_FrameLoadEnd(object sender, FrameLoadEndEventArgs e)
        {
            if (e.Frame.IsMain)
            {
                //为页面图形提供数据参数
                string str = m_ReportApp.data;
                //执行网页脚本事件
                m_ReportApp.browser.ExecuteScriptAsync("showchart('" + str + "','" + m_ReportApp.type + "')");
            }
        }
        //public string GetPic()
        //{
        //    return js.MessageText;
        //}
        //禁止网页操作，右键点击等
        class MenuHandler : CefSharp.IContextMenuHandler
        {
            void CefSharp.IContextMenuHandler.OnBeforeContextMenu(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.IMenuModel model)
            {
                model.Clear();
            }

            bool CefSharp.IContextMenuHandler.OnContextMenuCommand(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.CefMenuCommand commandId, CefSharp.CefEventFlags eventFlags)
            {
                //throw new NotImplementedException();
                return false;
            }

            void CefSharp.IContextMenuHandler.OnContextMenuDismissed(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame)
            {
                //throw new NotImplementedException();
            }

            bool CefSharp.IContextMenuHandler.RunContextMenu(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.IMenuModel model, CefSharp.IRunContextMenuCallback callback)
            {
                return false;
            }
        }
        class JsEvent
        {
            public string MessageText { set; get; }
            public void ShowTest()
            {
                MessageBox.Show(MessageText);
            }
        }
        #endregion

        #region EChart导出图像委托调用部份
        public delegate void MyDelgate(string va);
        public event MyDelgate butclic;
        private void timer1_Tick(object sender, EventArgs e)
        {
            if (butclic == null)
                return;
            if (m_ReportApp.js == null)
                return;
            if (m_ReportApp.js.MessageText == null)
                return;
            if (m_ReportApp.js.MessageText != "")
            {
                butclic(m_ReportApp.js.MessageText);
                timer1.Enabled = false;
                m_ReportApp.timerKG = false;
            }
        }
        #endregion

    }

}