OTS/OTSIncAReportApp/1-UI/OTSReportExport/OTSReport_Export.cs

using OTSIncAReportApp.Controls;
using OTSCommon.Model;
using OTSIncAReportApp.OTSTemplateDesigner;
using OTSIncAReportApp.SysMgrTools;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
using OTSIncAReportApp._1_UI.OTSTemplateDesigner;
using DevExpress.XtraReports.UI;
using OTSIncAReportApp.ReportTemplate;
using System.Linq;

namespace OTSIncAReportApp
{
    public partial class OTSReport_Export : Form
    {
        
        #region 全局变量
        System.Collections.Hashtable table;
        public frmReportApp m_ReportApp = null;                         //报告项目总进程对象
        public string m_export_type = "Excel";                          //导出文件的格式类型Excel,Word,Pdf
        GBData m_export_reporttemplate;
        private string SummaryInfoPath = "./Config/ReportTemplate/SummaryInfo.xml";
        private XmlOperateUtil SummaryInfoXmluti;
        private string fileName = "";
        public c_TemplateClass m_mbszclass = null;
        OTS_DEVReport DEVReport;
        GBReport GB_Report;
        public List<string[]> LibraryName = new List<string[]>();
        private bool isExport = true;
        #endregion

        #region 模板设置类
        /// <summary>
        /// 模板设置类
        /// </summary>
        public class c_TemplateClass
        {
            /// <summary>
            /// 配置文件路径
            /// </summary>
            public DZ M_DZ { get; set; }

            #region 属性
            /// <summary>
            /// 首页
            /// </summary>
            public SY M_SY { get; set; }

            /// <summary>
            /// 页眉页脚
            /// </summary>
            public YMYJ M_YMYJ { get; set; }

            /// <summary>
            /// 颗粒分析结果
            /// </summary>
            public KLFXJG M_KLFXJG { get; set; }

            /// <summary>
            /// 元素分析结果
            /// </summary>
            public YSFXJG M_YSFXJG { get; set; }

            /// <summary>
            /// 三元相图
            /// </summary>
            public SYXT M_SYXT { get; set; }

            /// <summary>
            /// 颗粒列表信息
            /// </summary>
            public KLLBXX M_KLLBXX { get; set; }

            /// <summary>
            /// 夹杂物占比
            /// </summary>
            public JZWZB M_JZWZB { get; set; }


            /// <summary>
            /// 主要优先排序string
            /// </summary>
            public string str_MainPriority { get; set; }
            /// <summary>
            /// 主要优先排序
            /// </summary>
            public List<string> list_str_MainPriority { get; set; }
            /// <summary>
            /// 次要优先排序string
            /// </summary>
            public string str_SecondaryPriority { get; set; }
            /// <summary>
            /// 次要优先排序
            /// </summary>
            public List<string> list_str_SecondaryPriority { get; set; }
            #endregion

            #region 构造函数
            public c_TemplateClass()
            {
                M_SY = new SY();
                M_YMYJ = new YMYJ();
                M_KLFXJG = new KLFXJG();
                M_YSFXJG = new YSFXJG();
                M_YSFXJG.list_str_tb_yscf_ysxx = new List<string>();
                M_YSFXJG.list_str_tb_ysfx_xsys = new List<string>();
                M_SYXT = new SYXT();
                M_SYXT.list_lbv_syxt_mblb = new List<string>();
                M_SYXT.list_lbv_syxt_mblb_index = new List<int>();
                M_KLLBXX = new KLLBXX();
                M_JZWZB = new JZWZB();
                M_KLLBXX.list_str_tb_lllb_sxys = new List<string>();
                M_KLLBXX.list_str_kllb_qcys = new List<string>();
                M_KLLBXX.list_str_kllb_DeleteClass = new List<string>();
                M_DZ = new DZ();
                list_str_MainPriority = new List<string>();
                list_str_SecondaryPriority = new List<string>();
                str_MainPriority = "";
                str_SecondaryPriority = "";
            }
            #endregion

            public class DZ
            {
                public string route { get; set; }
            }

            #region 首页部份
            public class SY
            {

                public string LOGName { get; set; }
                /// <summary>
                /// 主标题
                /// </summary>
                public string str_tb_ZBT { get; set; }

                /// <summary>
                /// 副标题
                /// </summary>
                public string str_tb_FBT { get; set; }

                /// <summary>
                /// 样品编号
                /// </summary>
                public string str_tb_YPBH { get; set; }

                /// <summary>
                /// 参考标准
                /// </summary>
                public string str_tb_CKBZ { get; set; }

                /// <summary>
                /// 是否显示样品说明
                /// </summary>
                public bool b_ck_ypsm { get; set; }

               
               

                /// <summary>
                /// 标准库名称
                /// </summary>
                public string StandardLibraryName { get; set; }
            }
            #endregion

            #region 页眉页脚部份
            public class YMYJ
            {
                /// <summary>
                /// 页眉文本
                /// </summary>
                public string str_tb_ymwb { get; set; }

                /// <summary>
                /// 客户号
                /// </summary>
                public string str_tb_KHH { get; set; }

                /// <summary>
                /// 是否显示页码
                /// </summary>
                public bool b_ck_ym { get; set; }

                /// <summary>
                /// 页脚文本
                /// </summary>
                public string str_tb_yjwb { get; set; }

                
            }
            #endregion

            #region 颗粒分析结果部份
            public class KLFXJG
            {
                /// <summary>
                /// 大分类是否显示
                /// </summary>
                public bool b_ck_klcc_dfl { get; set; }
                /// <summary>
                /// 小分类是否显示
                /// </summary>
                public bool b_ck_klcc_xfl { get; set; }

                /// <summary>
                /// 是否显示颗粒尺寸分析结果表
                /// </summary>
                public bool b_ck_klcc_xsmk { get; set; }
                /// <summary>
                /// 是否显示颗粒尺寸 堆叠图
                /// </summary>
                public bool b_ck_klcc_xsddt { get; set; }

                /// <summary>
                ///颗粒尺寸分析结果表 颗粒选择范围索引
                /// </summary>
                public int index_cb_klcc_klfw { get; set; }

                /// <summary>
                /// 夹杂物分类图 是否显示该模块
                /// </summary>
                public bool b_cb_jzwfl_xsmk { get; set; }

             

                /// <summary>
                ///夹杂物分类图 显示图形 选择索引
                /// </summary>
                public int index_cb_jzwfl_xstx { get; set; }

           

                /// <summary>
                ///夹杂物分类图 计算方式 选择索引
                /// </summary>
                public int index_cb_jzwfl_jsfs { get; set; }

            

                /// <summary>
                ///夹杂物分类图 粒级表 选择索引
                /// </summary>
                public int index_cb_jzwfl_ljb { get; set; }

               

                /// <summary>
                ///夹杂物分类图 颗粒范围 选择索引
                /// </summary>
                public int index_cb_jzwfl_klfw { get; set; }
            }

            #endregion

            #region 元素分析结果部份
            public class YSFXJG
            {
                /// <summary>
                /// 元素分析表 是否显示该模块
                /// </summary>
                public bool b_ck_ysfx_xsmk { get; set; }

              

                /// <summary>
                /// 元素分析表 计算方式  选择索引
                /// </summary>
                public int index_cb_yxfx_jsfs { get; set; }

              

                /// <summary>
                /// 元素分析表 颗粒范围 选择索引
                /// </summary>
                public int index_cb_ysfx_klfw { get; set; }

                /// <summary>
                /// 元素分析表 显示元素显示文本
                /// </summary>
                public string str_tb_ysfx_xsys { get; set; }

                /// <summary>
                /// 元素分析表 显示元素拆分元素列表
                /// </summary>
                public List<string> list_str_tb_ysfx_xsys { get; set; }

                /// <summary>
                /// 元素成份图 是否显示该模块
                /// </summary>
                public bool b_ck_yscf_xsmk { get; set; }

            

                /// <summary>
                /// 元素成份图 显示图形 索引
                /// </summary>
                public int index_cb_yscf_xstx { get; set; }

              

                /// <summary>
                /// 元素成份图 计算方式 索引
                /// </summary>
                public int index_cb_yscf_jsfs { get; set; }

              

                /// <summary>
                /// 元素成份图 颗粒范围 索引
                /// </summary>
                public int index_cb_yscf_klfw { get; set; }

                /// <summary>
                /// 元素成份图 元素信息
                /// </summary>
                public string str_tb_yscf_ysxx { get; set; }

                /// <summary>
                /// 元素成份图 元素信息列表拆分字符列表
                /// </summary>
                public List<string> list_str_tb_yscf_ysxx { get; set; }

            }
            #endregion

            #region 三元相图部份
            public class SYXT
            {
                /// <summary>
                /// 三元相图 是否显示该模块
                /// </summary>
                public bool b_ck_syxt_xsmk { get; set; }

               

                /// <summary>
                /// 计算方式 索引
                /// </summary>
                public int index_cb_syxt_jsfs { get; set; }

               

                /// <summary>
                /// 颗粒范围 索引
                /// </summary>
                public int index_cb_syxt_klfw { get; set; }

                /// <summary>
                /// 粒级表信息 文本
                /// </summary>
                public string str_cb_syxt_ljb { get; set; }

                /// <summary>
                /// 粒级表信息 索引
                /// </summary>
                public int index_cb_syxt_ljb { get; set; }

                /// <summary>
                /// 每行显示数量 文本
                /// </summary>
                public string str_cb_syxt_mhxssl { get; set; }

               

                /// <summary>
                /// 三元相图模板集合列表
                /// </summary>
                public List<string> list_lbv_syxt_mblb { get; set; }

                /// <summary>
                /// 三元相图模板索引集合列表
                /// </summary>
                public List<int> list_lbv_syxt_mblb_index { get; set; }
            }
            #endregion

            #region 颗粒列表信息部份
            public class KLLBXX
            {
                /// <summary>
                /// 颗粒列表 是否显示该模块
                /// </summary>
                public bool b_ck_kllb_xsmk { get; set; }

                /// <summary>
                /// 颗粒列表 是否显示附加帧图模块
                /// </summary>
                public bool b_ck_kllb_fjzt { get; set; }

               

                /// <summary>
                /// 颗粒列表 计算方式 索引
                /// </summary>
                public int index_cb_kllb_jsfs { get; set; }

               

                /// <summary>
                /// 颗粒列表 颗粒范围 索引
                /// </summary>
                public int index_cb_kllb_klfw { get; set; }

                

                /// <summary>
                /// 颗粒列表 显示元素
                /// </summary>
                public string str_tb_kllb_sxys { get; set; }

                /// <summary>
                /// 颗粒列表 显示元素拆分元素列表
                /// </summary>
                public List<string> list_str_tb_lllb_sxys { get; set; }

                
                /// <summary>
                /// 颗粒列表 颗粒排序表行中第一个可选字段 文本
                /// </summary>
                public string str_cb_kllb_sort_p1 { get; set; }

                /// <summary>
                /// 颗粒列表 颗粒排序表行中第一个可选字段 索引
                /// </summary>
                public int index_cb_kllb_sort_p1 { get; set; }
                /// <summary>
                /// 颗粒列表 颗粒排序表行中第二个可选字段 文本
                /// </summary>
                public string str_cb_kllb_sort_p2 { get; set; }

                /// <summary>
                /// 颗粒列表 颗粒排序表行中第二个可选字段 索引
                /// </summary>
                public int index_cb_kllb_sort_p2 { get; set; }
                /// <summary>
                /// 颗粒列表 颗粒排序表行中第三个可选字段 文本
                /// </summary>
                public string str_cb_kllb_sort_p3 { get; set; }

                /// <summary>
                /// 颗粒列表 颗粒排序表行中第三个可选字段 索引
                /// </summary>
                public int index_cb_kllb_sort_p3 { get; set; }
          

               
                

               
                /// <summary>
                /// 颗粒列表去除不要的颗粒
                /// </summary>
                public string str_kllb_qcys { get; set; }
                /// <summary>
                /// 颗粒列表去除不要的颗粒
                /// </summary>
                public List<string> list_str_kllb_qcys { get; set; }

                /// <summary>
                /// 颗粒列表去除不要的物质分类
                /// </summary>
                public string str_kllb_DeleteClass { get; set; }
                /// <summary>
                /// 颗粒列表去除不要的物质分类
                /// </summary>
                public List<string> list_str_kllb_DeleteClass { get; set; }


                /// <summary>
                /// 显示颗粒数量
                /// </summary>
                public int list_int_kllb_number { get; set; }
            }
            #endregion
            #region 夹杂物占比
            public class JZWZB
            {
                /// <summary>
                /// 夹杂物占比表
                /// </summary>
                public bool b_ck_surface { get; set; }
                /// <summary>
                /// 夹杂物占比图
                /// </summary>
                public bool b_ck_chart { get; set; }
            }

            #endregion
        }
        #endregion

        #region 窗体加载及构造函数
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ReportApp"></param>
        /// <param name="a_isTemplate">是否有导出功能</param>
        public OTSReport_Export(frmReportApp ReportApp,bool a_isExport)
        {
            InitializeComponent();
            m_ReportApp = ReportApp;
            m_export_reporttemplate = new GBData(this);
            SummaryInfoXmluti = new XmlOperateUtil(SummaryInfoPath);
            m_mbszclass = new c_TemplateClass();
            //读取配置文件中的模板路径
            LoadMBSZClass();
            #region 国际化语言
            Language lan = new Language(this);
            table = lan.GetNameTable(this.Name);
            #endregion
            isExport = a_isExport;
            if (!a_isExport)
            {
                button7.Enabled = false;
                btn_preview.Enabled = false;
            }
        }
   
        /// <summary>
        /// 从配置文件中读取报告模板路径
        /// </summary>
        private void LoadMBSZClass()
        {
            string path;
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
                path = SummaryInfoXmluti.Read("M_address", "Path_CA");
            else
                path = SummaryInfoXmluti.Read("M_address", "Path");
          
                fileName = path;
                tb_mblj.Text = fileName;
                m_mbszclass.M_DZ.route = fileName;
        }

        /// <summary>
        /// 将报告模板信息保存到配置文件中
        /// </summary>
        private void SaveMBSClass()
        {
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
                //文件路径
                SummaryInfoXmluti.Write(m_mbszclass.M_DZ.route.ToString(), "M_address", "Path_CA");
            else
                SummaryInfoXmluti.Write(m_mbszclass.M_DZ.route.ToString(), "M_address", "Path"); 
        }


        /// <summary>
        /// 加载报告模板选择项，数据源选项
        /// </summary>
        private void BindComboBox()
        {
            //加载数据源
            for (int i = 0; i < m_ReportApp.m_rstDataMgr.ResultFilesList.Count; i++)
            {
                cbo_sjy.Items.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
            }

            if (cbo_sjy.Items.Count > 0)
                cbo_sjy.SelectedIndex = 0;

        }

        private void OTSReport_Export_Load(object sender, EventArgs e)
        {
            //窗体加载时，初始化Combobox
            BindComboBox();
            LoadControlsToXml();
            tb_mblj.Text = fileName;
            if (isExport)
                ReadClassification();
            else
                ReadClassificationNo();
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
            {
                button7.Visible = false;
            }
        }
        #endregion
        #region 自定义方法

        #endregion

        #region 窗体控件事件
        private void btn_preview_Click(object sender, EventArgs e)
        {
            DEVReport = new OTS_DEVReport(this, m_mbszclass, m_ReportApp);
            LoadData();
            ReportPrintTool tool = new ReportPrintTool(DEVReport);
            tool.ShowPreview();
        }

      
        private void button2_Click(object sender, EventArgs e)
        {
            //退出
            this.Close();
        }
        private void btn_openfilepath_Click(object sender, EventArgs e)
        {
            string path;
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
                path = Application.StartupPath + "\\Config\\ReportTemplate\\CleannessA_Template";
            else
                path = Application.StartupPath + "\\Config\\ReportTemplate\\Inca_Template";
            FileNameSelect NameSelect = new FileNameSelect(path, fileName);
            NameSelect.ShowDialog();

            if (NameSelect.yes)
            {
                fileName = NameSelect.ChangePathName;
                m_mbszclass.M_DZ.route = fileName;
                LoadControlsToXml();
                SaveMBSClass();
                if (isExport)
                    ReadClassification();
                else
                    ReadClassificationNo();
            }
           
        }
       
        //调用编辑模板窗体
        private void btn_TempDes_Click(object sender, EventArgs e)
        {
            //预览设置
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
            {
                OTSReport_Template_CleannessA OtsTemDRM = new OTSReport_Template_CleannessA(this, fileName);
                if (OtsTemDRM.ShowDialog() == DialogResult.Yes)
                {
                    //如果用户点击确定，则将m_mbszclass,模板设置类的内容存到文件中。
                    m_mbszclass.M_DZ.route = tb_mblj.Text;
                    SaveMBSClass();
                }
            }
            else
            {
                OTSReport_Template_INCA OtsTemDRM = new OTSReport_Template_INCA(this, fileName);
                if (OtsTemDRM.ShowDialog() == DialogResult.Yes)
                {
                    //如果用户点击确定，则将m_mbszclass,模板设置类的内容存到文件中。
                    m_mbszclass.M_DZ.route = tb_mblj.Text;
                    SaveMBSClass();
                }
            }
        }
        #endregion
        #region 导出工作线程部份
        private void LoadData()
        {
            double  total = 1;
            if (m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk)
                total++;
            if (m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk)
                total++;
            if (m_mbszclass.M_JZWZB.b_ck_surface)
                total++;
            if(m_mbszclass.M_JZWZB.b_ck_chart)
                total++;
            if(m_mbszclass.M_SYXT.b_ck_syxt_xsmk)
                total++;
            if(m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk)
                total++;
            if(m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt)
                total++;

            double Serial = 1;
            int length = 2;
            try
            {
                if (true)//测量结果信息表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["measurement_result"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.International_language(dev_internationalLanguage());
                    bool isINCA = false;
                    if (m_ReportApp.m_RptConfigFile.Systype != OTS_SysType_ID.CleannessA)
                    {
                        isINCA = true;
                    }
                        DEVReport.setResultGrid(dev_internationalLanguage(), isINCA);
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["measurementResult_fail"].ToString() + "\n");
                return;
            }

            // 执行后台任务...  
            try
            {
                if (m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk)//颗粒尺寸分析表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["particle_size"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.setParticleSizeTable(m_mbszclass.M_KLFXJG.b_ck_klcc_dfl, m_mbszclass.M_KLFXJG.b_ck_klcc_xfl, m_mbszclass.M_KLFXJG.b_ck_klcc_xsddt);
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["particle_size_fail"].ToString() + "\n");
                return;
            }

            try
            {
                if (m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk)//元素分析表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["elemental_analysis"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.setElementAvgGrid();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["elemental_analysis_fail"].ToString() + "\n");
                return;
            }
            try
            {
                if (m_mbszclass.M_JZWZB.b_ck_surface)//夹杂物面积比表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["inclusion"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.setINCAtable();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["inclusion_fail"].ToString() + "\n");
                return;
            }
            try
            {
                if (m_mbszclass.M_JZWZB.b_ck_surface)
                {
                    if (m_mbszclass.M_KLFXJG.b_ck_klcc_dfl == true || m_mbszclass.M_KLFXJG.b_ck_klcc_xfl == true)
                    {
                        double d1 = Convert.ToDouble(Serial / total) * 100.0;
                        Serial++;
                        richTextBox1.SelectionColor = Color.Black;
                        richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                        richTextBox1.AppendText(table["inclusion_chart"].ToString() + "\n");
                        richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                        DEVReport.XRPageBreak();
                        if (m_mbszclass.M_KLFXJG.b_ck_klcc_dfl)
                        {
                            DEVReport.set_incaPIC_classify();
                        }
                        if (m_mbszclass.M_KLFXJG.b_ck_klcc_xfl)
                        {
                            DEVReport.set_incaPIC_subdivision();
                        }
                        richTextBox1.ScrollToCaret();
                    }
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["inclusion_chart_fail"].ToString() + "\n");
                return;
            }

            try
            {
                if (m_mbszclass.M_SYXT.b_ck_syxt_xsmk)//三元图
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["ternary_diagram"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.InsertReportTemplateChart_Trianglediagram();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["ternary_diagram_fail"].ToString() + "\n");
                return;
            }
            try
            {
                if (m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk)//颗粒列表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["particle_list"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.set_kllb_data();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["particle_list_fail"].ToString() + "\n");
                return;
            }
            try
            {
                if (m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt)//颗粒帧图列表
                {
                    double d1 = Convert.ToDouble(Serial / total) * 100.0;
                    Serial++;
                    richTextBox1.SelectionColor = Color.Black;
                    richTextBox1.SelectionStart = 0; // 设置选择开始位置 
                    richTextBox1.AppendText(table["particle_list_chart"].ToString() + "\n");
                    richTextBox1.AppendText(table["loading"].ToString() + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.set_kllb_data_frame();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText(table["particle_list_chart_fail"].ToString() + "\n");
                return;
            }
            richTextBox1.SelectionColor = Color.Red;
            richTextBox1.AppendText(table["complete"].ToString() + "\n");
            richTextBox1.ScrollToCaret();

        }
        #endregion
        #region 读取文件
        private void LoadControlsToXml()
        {
            string strpath;
            if (m_ReportApp.m_RptConfigFile.Systype == OTS_SysType_ID.CleannessA)
                strpath = Application.StartupPath + "\\Config\\ReportTemplate\\CleannessA_Template\\" + fileName;
            else
                strpath = Application.StartupPath + "\\Config\\ReportTemplate\\Inca_Template\\" + fileName;
            tb_mblj.Text = fileName;
            OTSIncAReportApp.Controls.XmlOperateUtil xmlutil = new OTSIncAReportApp.Controls.XmlOperateUtil(strpath);
            //首页
            m_mbszclass.M_SY.str_tb_ZBT = xmlutil.Read("M_SY", "str_tb_ZBT");
            m_mbszclass.M_SY.str_tb_FBT = xmlutil.Read("M_SY", "str_tb_FBT");
            m_mbszclass.M_SY.str_tb_YPBH = xmlutil.Read("M_SY", "str_tb_YPBH");
            m_mbszclass.M_SY.str_tb_CKBZ = xmlutil.Read("M_SY", "str_tb_CKBZ");
            m_mbszclass.M_SY.b_ck_ypsm = Convert.ToBoolean(xmlutil.Read("M_SY", "b_ck_ypsm"));
          
            m_mbszclass.M_SY.LOGName = xmlutil.Read("M_SY", "LOGName");
            m_mbszclass.M_SY.StandardLibraryName= xmlutil.Read("M_SY", "StandardLibraryName");
            if (m_mbszclass.M_SY.LOGName == null || m_mbszclass.M_SY.LOGName == "")
            {
                m_mbszclass.M_SY.LOGName = "ReportIdentification.bmp";
            }
            //页眉页脚
            m_mbszclass.M_YMYJ.str_tb_ymwb = xmlutil.Read("M_YMYJ", "str_tb_ymwb");
            m_mbszclass.M_YMYJ.str_tb_KHH = xmlutil.Read("M_YMYJ", "str_tb_KHH");
            m_mbszclass.M_YMYJ.b_ck_ym = Convert.ToBoolean(xmlutil.Read("M_YMYJ", "b_ck_ym"));
            m_mbszclass.M_YMYJ.str_tb_yjwb = xmlutil.Read("M_YMYJ", "str_tb_yjwb");
            //颗粒分析结果
            m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_xsmk"));//是否显示模块
            m_mbszclass.M_KLFXJG.b_ck_klcc_xsddt = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_xsddt"));
           
            m_mbszclass.M_KLFXJG.index_cb_klcc_klfw = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_klfw"));//颗粒范围
            m_mbszclass.M_KLFXJG.b_cb_jzwfl_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_cb_jzwfl_xsmk"));//是否显示该模块
            m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_xstx"));//选择图像
            m_mbszclass.M_KLFXJG.index_cb_jzwfl_jsfs = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_jsfs"));//计算方式
         
            m_mbszclass.M_KLFXJG.index_cb_jzwfl_ljb = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_ljb"));//粒级表
            m_mbszclass.M_KLFXJG.index_cb_jzwfl_klfw = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_klfw"));//颗粒范围
                                                                                                                        //元素分析结果
            m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk = Convert.ToBoolean(xmlutil.Read("M_YSFXJG", "b_ck_ysfx_xsmk"));    //是否显示模块
            m_mbszclass.M_YSFXJG.index_cb_yxfx_jsfs = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yxfx_jsfs"));    //计算方式
            m_mbszclass.M_YSFXJG.index_cb_ysfx_klfw = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_ysfx_klfw"));    //颗粒范围
            m_mbszclass.M_YSFXJG.str_tb_ysfx_xsys = xmlutil.Read("M_YSFXJG", "str_tb_ysfx_xsys");        //显示元素
            m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有元素列表
            {
                string str = xmlutil.Read("M_YSFXJG", "list_str_tb_ysfx_xsys", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Add(str);
                }
            }
            m_mbszclass.M_YSFXJG.b_ck_yscf_xsmk = Convert.ToBoolean(xmlutil.Read("M_YSFXJG", "b_ck_yscf_xsmk"));    //是否显示模块
            m_mbszclass.M_YSFXJG.index_cb_yscf_xstx = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_xstx"));    //显示图形
            m_mbszclass.M_YSFXJG.index_cb_yscf_jsfs = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_jsfs"));    //计算方式
            m_mbszclass.M_YSFXJG.index_cb_yscf_klfw = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_klfw"));    //颗粒范围
            m_mbszclass.M_YSFXJG.str_tb_yscf_ysxx = xmlutil.Read("M_YSFXJG", "str_tb_yscf_ysxx");    //显示元素
            m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有元素列表
            {
                string str = xmlutil.Read("M_YSFXJG", "list_str_tb_yscf_ysxx", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Add(str);
                }
            }
            //三元相图
            m_mbszclass.M_SYXT.b_ck_syxt_xsmk = Convert.ToBoolean(xmlutil.Read("M_SYXT", "b_ck_syxt_xsmk"));    //是否显示模块
            m_mbszclass.M_SYXT.index_cb_syxt_jsfs = Convert.ToInt32(xmlutil.Read("M_SYXT", "index_cb_syxt_jsfs"));    //计算方式
            m_mbszclass.M_SYXT.index_cb_syxt_klfw = Convert.ToInt32(xmlutil.Read("M_SYXT", "index_cb_syxt_klfw"));    //颗粒范围
            m_mbszclass.M_SYXT.str_cb_syxt_mhxssl = xmlutil.Read("M_SYXT", "str_cb_syxt_mhxssl");    //每行显示数量
            m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有模板列表
            {
                string str = xmlutil.Read("M_SYXT", "list_lbv_syxt_mblb", "MB" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Add(str);
                }
            }
            m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有模板列表 索引
            {
                string str = xmlutil.Read("M_SYXT", "list_lbv_syxt_mblb_index", "MBIndex" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Add(Convert.ToInt32(str));
                }
            }
            //颗粒列表信息
            m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_xsmk"));    //是否显示模块
            m_mbszclass.M_KLLBXX.index_cb_kllb_jsfs = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_jsfs"));    //计算方式
            m_mbszclass.M_KLLBXX.index_cb_kllb_klfw = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_klfw"));    //颗粒范围
            m_mbszclass.M_KLLBXX.str_tb_kllb_sxys = xmlutil.Read("M_KLLBXX", "str_tb_kllb_sxys");    //显示元素
            m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_fjzt"));
            m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有元素列表
            {
                string str = xmlutil.Read("M_KLLBXX", "list_str_tb_lllb_sxys", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Add(str);
                }
            }
            m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p1 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p1"));//颗粒列表列中第一个可选参数
            m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p1 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p1"));
            m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p2 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p2"));//颗粒列表中第二个可选参数
            m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p2 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p2"));
            m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p3 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p3"));//颗粒列表中第三个可选参数
            m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p3 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p3"));
        
            m_mbszclass.M_KLLBXX.list_int_kllb_number = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "list_int_kllb_number"));//保存显示颗粒数量
            m_mbszclass.M_KLLBXX.str_kllb_qcys = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_kllb_qcys"));
            m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有元素列表
            {
                string str = xmlutil.Read("M_KLLBXX", "list_str_kllb_qcys", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Add(str);
                }
            }
            m_mbszclass.M_KLLBXX.str_kllb_DeleteClass = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_kllb_DeleteClass"));
            m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Clear();
            for (int i = 0; i < 100; i++)                              //取得所有元素列表
            {
                string str = xmlutil.Read("M_KLLBXX", "list_str_kllb_DeleteClass", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Add(str);
                }
            }
            //夹杂物占比
            m_mbszclass.M_JZWZB.b_ck_surface = Convert.ToBoolean(xmlutil.Read("M_JZWZB", "b_ck_surface"));//夹杂物占比表
            m_mbszclass.M_JZWZB.b_ck_chart = Convert.ToBoolean(xmlutil.Read("M_JZWZB", "b_ck_chart"));//夹杂物占比图
            m_mbszclass.list_str_MainPriority.Clear();
            for (int i = 0; i < 100; i++)                              //全局优先排序
            {
                string str = xmlutil.Read("whole", "list_str_MainPriority", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.list_str_MainPriority.Add(str);
                }
            }
            m_mbszclass.list_str_SecondaryPriority.Clear();
            for (int i = 0; i < 100; i++)                              //全局次要排序
            {
                string str = xmlutil.Read("whole", "list_str_SecondaryPriority", "YS" + i.ToString());
                if (str == null)
                {
                    break;
                }
                else
                {
                    m_mbszclass.list_str_SecondaryPriority.Add(str);
                }
            }
            m_mbszclass.str_MainPriority = Convert.ToString(xmlutil.Read("whole", "str_MainPriority"));
            m_mbszclass.str_SecondaryPriority = Convert.ToString(xmlutil.Read("whole", "str_SecondaryPriority"));
        
            m_mbszclass.M_SYXT.str_cb_syxt_ljb = Convert.ToString(xmlutil.Read("M_SYXT", "str_cb_syxt_ljb"));


            m_mbszclass.M_KLFXJG.b_ck_klcc_dfl = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_dfl"));
            m_mbszclass.M_KLFXJG.b_ck_klcc_xfl = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_xfl"));
           
        }
        #endregion
        private void button7_Click(object sender, EventArgs e)
        {
            OTSReport_criterion criterion = new OTSReport_criterion(m_export_reporttemplate, GB_Report,this);
            criterion.Sample_order = cbo_sjy.SelectedIndex;
            criterion.Language_dt = dev_internationalLanguage();
            criterion.ShowDialog();
        }
       
        private void OTSReport_Export_FormClosed(object sender, FormClosedEventArgs e)
        {
           
        }
          /// <summary>
        /// 从数据库中读取语言配置信息
        /// </summary>
        /// <returns></returns>
        private DataTable dev_internationalLanguage()
        {
            string Language;
            if (table["language"].ToString() == "ZH")
                Language = "ZH";
            else
                Language = "EN";
            OTSCommon.SqLiteHelper sh = new OTSCommon.SqLiteHelper("data source='" + System.IO.Directory.GetCurrentDirectory() + "\\Config\\ReportTemplate\\language.db'");
            DataTable dt_stl = sh.ExecuteQuery("select * from "+ Language);
            return dt_stl;
        }

        private void ReadClassificationNo()
        {
            LibraryName.Clear();
            string MeasurementFiles = System.IO.Directory.GetCurrentDirectory() + "\\Config\\SysData";
            // 获取文件夹中的所有文件信息  
            List<string> getNameM = GetDbFilesInDirectory(MeasurementFiles);
            // 遍历文件信息数组并打印出文件名  
            for (int i = 0; i < getNameM.Count; i++)
            {
                string[] vs = new string[] { getNameM[i], MeasurementFiles + "\\" + getNameM[i] };
                LibraryName.Add(vs);
            }
            if ( m_mbszclass.M_SY.StandardLibraryName == "NoSTDDB.db")
            {
                m_mbszclass.M_SY.StandardLibraryName = "";
            }
        }

        private void ReadClassification()
        {
            LibraryName.Clear();
            string fullPathM = "";
            string fullPathR = "";
            ResultFile resfile = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.getSelectedIndex()];
            string str_libraryName = resfile.GetSTDName();
            bool endsWithDb = str_libraryName.EndsWith(".db", StringComparison.OrdinalIgnoreCase);
            if(!endsWithDb)
            {
                str_libraryName = str_libraryName + ".db";
            }
            try
            {
                fullPathM = System.IO.Directory.GetCurrentDirectory() + "\\Config\\SysData\\" + str_libraryName /*+ ".db"*/;
                string MeasurementFiles = System.IO.Directory.GetCurrentDirectory() + "\\Config\\SysData";
                // 获取文件夹中的所有文件信息  
                List<string> getNameM = GetDbFilesInDirectory(MeasurementFiles);
                // 遍历文件信息数组并打印出文件名  
                for (int i = 0; i < getNameM.Count; i++)
                {
                    string[] vs = new string[] { getNameM[i], MeasurementFiles + "\\" + getNameM[i] };
                    LibraryName.Add(vs);
                }

            }
            catch
            {

            }
            try
            {
                fullPathR = m_ReportApp.m_rstDataMgr.CurResultFile.FilePath + "\\" + str_libraryName /*+ ".db"*/;
                string ReportFile = m_ReportApp.m_rstDataMgr.CurResultFile.FilePath;
                // 获取文件夹中的所有文件信息  
                List<string> getNameR = GetDbFilesInDirectory(ReportFile);
                for (int i = 0; i < getNameR.Count; i++)
                {
                    string[] vs = new string[] { getNameR[i], ReportFile + "\\" + getNameR[i] };
                    LibraryName.Add(vs);
                }
            }
            catch
            {

            }
            
            if (str_libraryName == "NoSTDDB.db" || m_mbszclass.M_SY.StandardLibraryName== "NoSTDDB.db")
            {
                m_mbszclass.M_SY.StandardLibraryName = "";
            }
            else
            {

                if (System.IO.File.Exists(fullPathR))
                {
                    return;
                }
                else if (System.IO.File.Exists(fullPathM))
                {
                    return;
                }
                else
                {
                    MessageBox.Show(table["library_does_not_match"].ToString());
                }
            
            }
        }


        static List<string> GetDbFilesInDirectory(string directoryPath)
        {
            List<string> files = new List<string>();

            // 使用搜索模式 "*.db" 来查找所有.db文件  
            string[] allDbFiles = Directory.GetFiles(directoryPath, "*.db");

            // 将找到的文件名添加到列表中  
            files.AddRange(allDbFiles.Select(Path.GetFileName)); // 如果只需要文件名，而不是完整路径  

            // 如果你需要文件的完整路径，可以直接返回 allDbFiles 数组（转换为List<string>）  
            // return allDbFiles.ToList();  

            return files;
        }

    }

}