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;

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;
        #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 str_xzkl { get; set; }
                /// <summary>
                /// 选择颗粒导出范围，索引
                /// </summary>
                public int int_xzkl { 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 string str_cb_klcc_jsfs { get; set; }

                /// <summary>
                ///颗粒尺寸分析结果表 计算方式索引
                /// </summary>
                public int index_cb_klcc_jsfs { get; set; }

                /// <summary>
                ///颗粒尺寸分析结果表 粒级表文本
                /// </summary>
                public string str_cb_klcc_ljb { get; set; }

                /// <summary>
                ///颗粒尺寸分析结果表 粒级表索引
                /// </summary>
                public int index_cb_klcc_ljb { 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_cb_kllb_chartSort_p1 { get; set; }

                /// <summary>
                /// 颗粒列表 颗粒帧图表行中第一个可选字段 索引
                /// </summary>
                public int index_cb_kllb_chartSort_p1 { get; set; }
                /// <summary>
                /// 颗粒列表 颗粒帧图表行中第二个可选字段 文本
                /// </summary>
                public string str_cb_kllb_chartSort_p2 { get; set; }

                /// <summary>
                /// 颗粒列表 颗粒帧图表行中第二个可选字段 索引
                /// </summary>
                public int index_cb_kllb_chartSort_p2 { 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 窗体加载及构造函数
        public OTSReport_Export(frmReportApp ReportApp)
        {
            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

        }
   
        /// <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;
        }
        #endregion
        #region 自定义方法

        /// <summary>
        /// 将文本追加到RictBox的尾部上
        /// </summary>
        public void WriteRictBox(string in_str)
        {
            //追加到rictbox尾部
            richTextBox1.AppendText("[" + DateTime.Now.Hour.ToString() + ":"
                + DateTime.Now.Minute.ToString() + ":"
                + DateTime.Now.Second.ToString() + "]"
                + in_str + Environment.NewLine);
            richTextBox1.SelectionColor = GetRandomColor30(30);
            richTextBox1.ScrollToCaret();
        }

        /// <summary>
        /// 从指定的几种颜色中进行随机颜色,传入30个颜色的范围，越大颜色越多
        /// </summary>
        /// <returns></returns>
        public Color GetRandomColor30(int i_randomrange)
        {
            Random r = new Random();
            int n = r.Next(0, i_randomrange);

            Color ret_color;
            switch (n)
            {
                case 1:
                    ret_color = Color.Aqua;
                    break;
                case 2:
                    ret_color = Color.Black;
                    break;
                case 3:
                    ret_color = Color.Blue;
                    break;
                case 4:
                    ret_color = Color.BlueViolet;
                    break;
                case 5:
                    ret_color = Color.Brown;
                    break;
                case 6:
                    ret_color = Color.BurlyWood;
                    break;
                case 7:
                    ret_color = Color.CadetBlue;
                    break;
                case 8:
                    ret_color = Color.CadetBlue;
                    break;
                case 9:
                    ret_color = Color.CornflowerBlue;
                    break;
                case 10:
                    ret_color = Color.DarkBlue;
                    break;
                case 11:
                    ret_color = Color.Gray;
                    break;
                case 12:
                    ret_color = Color.Indigo;
                    break;
                case 13:
                    ret_color = Color.LightSlateGray;
                    break;
                case 14:
                    ret_color = Color.Magenta;
                    break;
                case 15:
                    ret_color = Color.Maroon;
                    break;
                case 16:
                    ret_color = Color.MediumBlue;
                    break;
                case 17:
                    ret_color = Color.MediumOrchid;
                    break;
                case 18:
                    ret_color = Color.MidnightBlue;
                    break;
                case 19:
                    ret_color = Color.Navy;
                    break;
                case 20:
                    ret_color = Color.Olive;
                    break;
                case 21:
                    ret_color = Color.PaleVioletRed;
                    break;
                case 22:
                    ret_color = Color.Peru;
                    break;
                case 23:
                    ret_color = Color.Purple;
                    break;
                case 24:
                    ret_color = Color.Red;
                    break;
                case 25:
                    ret_color = Color.RosyBrown;
                    break;
                case 26:
                    ret_color = Color.RoyalBlue;
                    break;
                case 27:
                    ret_color = Color.SaddleBrown;
                    break;
                case 28:
                    ret_color = Color.SeaGreen;
                    break;
                case 29:
                    ret_color = Color.Teal;
                    break;
                case 30:
                    ret_color = Color.Tomato;
                    break;
                case 31:
                    ret_color = Color.YellowGreen;
                    break;

                default:
                    ret_color = Color.Black;
                    break;
            }

            return ret_color;
        }

        #endregion

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

        private void button3_Click(object sender, EventArgs e)
        {
            if (File.Exists(tb_lj.Text.Trim()))
            {
                //打开刚才导出的文件
                System.Diagnostics.Process.Start(tb_lj.Text.Trim());
            }
            else
            {
                WriteRictBox(table["rictbox2"].ToString() + tb_lj.Text.Trim() + table["rictbox3"].ToString());
            }
        }
        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();
            fileName = NameSelect.ChangePathName;
            m_mbszclass.M_DZ.route = fileName;
            LoadControlsToXml();
            SaveMBSClass();
        }
        private void btn_selectPath_Click(object sender, EventArgs e)
        {
            //选择保存文件路径对话框
            SaveFileDialog saveFileDialog1 = new SaveFileDialog();
            //获取默认操作的数据源名，用来当做保存的文件名
            saveFileDialog1.FileName = m_ReportApp.m_rstDataMgr.GetSampleName();
            saveFileDialog1.Filter = "Excel (*.xls)|*.xls|Word (*.doc)|*.doc|PDF (*.pdf)|*.pdf";
            saveFileDialog1.FilterIndex = 1;
            saveFileDialog1.RestoreDirectory = true;
            if (saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if (saveFileDialog1.FilterIndex == 1)
                {
                    //选择输出Excel
                    m_export_type = "Excel";
                }
                if (saveFileDialog1.FilterIndex == 2)
                {
                    //选择输出Word
                    m_export_type = "Word";
                }
                if (saveFileDialog1.FilterIndex == 3)
                {
                    //选择输出PDF
                    m_export_type = "PDF";
                }
                tb_lj.Text = saveFileDialog1.FileName;
            }
        }
        //调用编辑模板窗体
        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("加载：测量结果信息表……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.International_language(dev_internationalLanguage());
                    DEVReport.setResultGrid();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("测量结果信息表加载失败！\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("加载：颗粒尺寸分析表……\n");
                    richTextBox1.AppendText("加载：" + 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("颗粒尺寸分析表加载失败！\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("加载：元素分析表……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.setElementAvgGrid();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("元素分析表加载失败！\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("加载：夹杂物面积比表……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.setINCAtable();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("夹杂物面积比表加载失败！\n");
                return;
            }
            try
            {

                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("加载：夹杂物面积比图……\n");
                    richTextBox1.AppendText("加载：" + 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("夹杂物面积加载失败！\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("加载：三元图……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.InsertReportTemplateChart_Trianglediagram();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("三元图加载失败！\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("加载：颗粒列表……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.set_kllb_data();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("颗粒列表加载失败！\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("加载：颗粒帧图列表……\n");
                    richTextBox1.AppendText("加载：" + Math.Round(d1, length).ToString() + "%\n");
                    DEVReport.XRPageBreak();
                    DEVReport.set_kllb_data_frame();
                    richTextBox1.ScrollToCaret();
                }
            }
            catch
            {
                richTextBox1.SelectionColor = Color.Red;
                richTextBox1.AppendText("颗粒帧图列表加载失败！\n");
                return;
            }
            richTextBox1.SelectionColor = Color.Red;
            richTextBox1.AppendText("-----------------加载完成！--------------------\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.int_xzkl = Convert.ToInt32(xmlutil.Read("M_SY", "int_xzkl"));
            m_mbszclass.M_SY.str_xzkl = xmlutil.Read("M_SY", "str_xzkl");
            m_mbszclass.M_SY.LOGName = xmlutil.Read("M_SY", "LOGName");
            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_jsfs = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_jsfs"));//计算方式
            m_mbszclass.M_KLFXJG.index_cb_klcc_ljb = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_ljb"));//粒级表
            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.str_cb_klcc_jsfs = xmlutil.Read("M_KLFXJG", "str_cb_klcc_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.str_cb_kllb_chartSort_p1 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p1"));//帧图表列中第一个可选参数
            m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p1 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p1"));
            m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p2 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p2"));//帧图表列中第二个可选参数
            m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p2 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p2"));
            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_KLFXJG.str_cb_klcc_ljb = Convert.ToString(xmlutil.Read("M_KLFXJG", "str_cb_klcc_ljb"));
            m_mbszclass.M_SYXT.str_cb_syxt_ljb = Convert.ToString(xmlutil.Read("M_SYXT", "str_cb_syxt_ljb"));
        }
        #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 = "ZH";
            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;
        }
    
    }

}