using OTSIncAReportApp.Controls; using OTSIncAReportApp.DataOperation.DataAccess; using OTSCommon.Model; using OTSIncAReportApp.OTSSampleReportInfo; using OTSIncAReportApp.OTSTemplateDesigner; using OTSIncAReportApp.SysMgrTools; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SQLite; using System.Diagnostics; using System.Drawing; using System.IO; using System.Linq; using System.Windows.Forms; using System.Xml; using OTSIncAReportApp._1_UI.OTSTemplateDesigner; using DevExpress.XtraReports.UI; using OTSIncAReportApp.ReportTemplate; namespace OTSIncAReportApp { public partial class OTSReport_Export : Form { #region 全局变量 public string m_thread_flag = "无"; //线程操作的标识 public string m_str_tmpbitmappath = "d:\\1.bmp"; //存放临时图片 的路径名和文件名 public string m_str_tmpbitmappath2 = "d:\\2.bmp"; public string m_str_tmpdocxpath = "d:\\1.doc"; public string m_strDBpath = ""; //报表模板数据库文件 public string m_strDBpathGB = ""; //报告国标导出 public string m_strDBpath_ParticleList = ""; //报表模板,颗粒列表数据库文件 public int m_SelectedIndex = 0; System.Collections.Hashtable table; public frmReportApp m_ReportApp = null; //报告项目总进程对象 public string m_export_type = "Excel"; //导出文件的格式类型Excel,Word,Pdf Export_ReportTemplate m_export_reporttemplate; public string strPath = "./Config/ReportTemplate/ReportTemplateConfig.xml"; //报告模板设置文件的路径 public string strPath2; public XmlConfigUtil xmlutil; public XmlConfigUtil xmlutil2; public c_TemplateClass m_mbszclass = null; OTS_DEVReport DEVReport; GBReport GB_Report; /*public bool ReportExporting = false;*///判断报告是不在是在导出的过程中 #endregion #region 条件参数变量 /// /// 选择的数据类型 /// public string SJLX { get; set; } /// /// 尺寸计算方法 /// public string CCJSFF { get; set; } /// /// 粒级表 /// public string LJB { get; set; } /// /// 三元相图模板 /// public string SYXTMB { get; set; } #endregion #region 模板设置类 /// /// 模板设置类 /// public class c_TemplateClass { public DZ M_DZ { get; set; } #region 属性 /// /// 首页 /// public SY M_SY { get; set; } /// /// 页眉页脚 /// public YMYJ M_YMYJ { get; set; } /// /// 颗粒分析结果 /// public KLFXJG M_KLFXJG { get; set; } /// /// 元素分析结果 /// public YSFXJG M_YSFXJG { get; set; } /// /// 三元相图 /// public SYXT M_SYXT { get; set; } /// /// 颗粒列表信息 /// public KLLBXX M_KLLBXX { get; set; } /// /// 夹杂物占比 /// public JZWZB M_JZWZB { 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(); M_YSFXJG.list_str_tb_ysfx_xsys = new List(); M_SYXT = new SYXT(); M_SYXT.list_lbv_syxt_mblb = new List(); M_SYXT.list_lbv_syxt_mblb_index = new List(); M_KLLBXX = new KLLBXX(); M_JZWZB = new JZWZB(); M_KLLBXX.list_str_tb_lllb_sxys = new List(); M_KLLBXX.list_str_kllb_qcys = new List(); M_KLLBXX.list_str_kllb_DeleteClass = new List(); M_DZ = new DZ(); } #endregion public class DZ { public string route { get; set; } } #region 首页部份 public class SY { /// /// 主标题 /// public string str_tb_ZBT { get; set; } /// /// 副标题 /// public string str_tb_FBT { get; set; } /// /// 样品编号 /// public string str_tb_YPBH { get; set; } /// /// 参考标准 /// public string str_tb_CKBZ { get; set; } /// /// 是否显示样品说明 /// public bool b_ck_ypsm { get; set; } /// /// 是否显示结果概况 /// public bool b_ck_jggk { get; set; } /// /// 报告备注 /// public string str_bz { get; set; } /// /// 选择颗粒导出范围_内容 /// public string str_xzkl { get; set; } /// /// 选择颗粒导出范围,索引 /// public int int_xzkl { get; set; } } #endregion #region 页眉页脚部份 public class YMYJ { /// /// 页眉文本 /// public string str_tb_ymwb { get; set; } /// /// 客户号 /// public string str_tb_KHH { get; set; } /// /// 是否显示页码 /// public bool b_ck_ym { get; set; } /// /// 页脚文本 /// public string str_tb_yjwb { get; set; } } #endregion #region 颗粒分析结果部份 public class KLFXJG { /// /// 是否显示颗粒尺寸分析结果表 /// public bool b_ck_klcc_xsmk { get; set; } /// ///颗粒尺寸分析结果表 计算方式文本 /// public string str_cb_klcc_jsfs { get; set; } /// ///颗粒尺寸分析结果表 计算方式索引 /// public int index_cb_klcc_jsfs { get; set; } /// ///颗粒尺寸分析结果表 粒级表文本 /// public string str_cb_klcc_ljb { get; set; } /// ///颗粒尺寸分析结果表 粒级表索引 /// public int index_cb_klcc_ljb { get; set; } /// ///颗粒尺寸分析结果表 颗粒选择范围文本 /// public string str_cb_klcc_klfw { get; set; } /// ///颗粒尺寸分析结果表 颗粒选择范围索引 /// public int index_cb_klcc_klfw { get; set; } /// /// 夹杂物分类图 是否显示该模块 /// public bool b_cb_jzwfl_xsmk { get; set; } /// ///夹杂物分类图 显示图形选择文本 /// public string str_cb_jzwfl_xstx { get; set; } /// ///夹杂物分类图 显示图形 选择索引 /// public int index_cb_jzwfl_xstx { get; set; } /// ///夹杂物分类图 计算方式 选择文本 /// public string str_cb_jzwfl_jsfs { get; set; } /// ///夹杂物分类图 计算方式 选择索引 /// public int index_cb_jzwfl_jsfs { get; set; } /// ///夹杂物分类图 粒级表 选择文本 /// public string str_cb_jzwfl_ljb { get; set; } /// ///夹杂物分类图 粒级表 选择索引 /// public int index_cb_jzwfl_ljb { get; set; } /// ///夹杂物分类图 颗粒范围 选择文本 /// public string str_cb_jzwfl_klfw { get; set; } /// ///夹杂物分类图 颗粒范围 选择索引 /// public int index_cb_jzwfl_klfw { get; set; } } #endregion #region 元素分析结果部份 public class YSFXJG { /// /// 元素分析表 是否显示该模块 /// public bool b_ck_ysfx_xsmk { get; set; } /// /// 元素分析表 计算方式 选择文本 /// public string str_cb_yxfx_jsfs { get; set; } /// /// 元素分析表 计算方式 选择索引 /// public int index_cb_yxfx_jsfs { get; set; } /// /// 元素分析表 颗粒范围 选择文本 /// public string str_cb_ysfx_klfw { get; set; } /// /// 元素分析表 颗粒范围 选择索引 /// public int index_cb_ysfx_klfw { get; set; } /// /// 元素分析表 显示元素显示文本 /// public string str_tb_ysfx_xsys { get; set; } /// /// 元素分析表 显示元素拆分元素列表 /// public List list_str_tb_ysfx_xsys { get; set; } /// /// 元素成份图 是否显示该模块 /// public bool b_ck_yscf_xsmk { get; set; } /// /// 元素成份图 显示图形 文本 /// public string str_cb_yscf_xstx { get; set; } /// /// 元素成份图 显示图形 索引 /// public int index_cb_yscf_xstx { get; set; } /// /// 元素成份图 计算方式 文本 /// public string str_cb_yscf_jsfs { get; set; } /// /// 元素成份图 计算方式 索引 /// public int index_cb_yscf_jsfs { get; set; } /// /// 元素成份图 颗粒范围 文本 /// public string str_cb_yscf_klfw { get; set; } /// /// 元素成份图 颗粒范围 索引 /// public int index_cb_yscf_klfw { get; set; } /// /// 元素成份图 元素信息 /// public string str_tb_yscf_ysxx { get; set; } /// /// 元素成份图 元素信息列表拆分字符列表 /// public List list_str_tb_yscf_ysxx { get; set; } } #endregion #region 三元相图部份 public class SYXT { /// /// 三元相图 是否显示该模块 /// public bool b_ck_syxt_xsmk { get; set; } /// /// 计算方式 文本 /// public string str_cb_syxt_jsfs { get; set; } /// /// 计算方式 索引 /// public int index_cb_syxt_jsfs { get; set; } /// /// 颗粒范围 文本 /// public string str_cb_syxt_klfw { get; set; } /// /// 颗粒范围 索引 /// public int index_cb_syxt_klfw { get; set; } /// /// 粒级表信息 文本 /// public string str_cb_syxt_ljb { get; set; } /// /// 粒级表信息 索引 /// public int index_cb_syxt_ljb { get; set; } /// /// 每行显示数量 文本 /// public string str_cb_syxt_mhxssl { get; set; } /// /// 每行显示数量 索引 /// public int index_cb_syxt_mhxssl { get; set; } /// /// 三元相图模板集合列表 /// public List list_lbv_syxt_mblb { get; set; } /// /// 三元相图模板索引集合列表 /// public List list_lbv_syxt_mblb_index { get; set; } } #endregion #region 颗粒列表信息部份 public class KLLBXX { /// /// 颗粒列表 是否显示该模块 /// public bool b_ck_kllb_xsmk { get; set; } /// /// 颗粒列表 是否显示附加帧图模块 /// public bool b_ck_kllb_fjzt { get; set; } /// /// 颗粒列表 计算方式 文本 /// public string str_cb_kllb_jsfs { get; set; } /// /// 颗粒列表 计算方式 索引 /// public int index_cb_kllb_jsfs { get; set; } /// /// 颗粒列表 颗粒范围 文本 /// public string str_cb_kllb_klfw { get; set; } /// /// 颗粒列表 颗粒范围 索引 /// public int index_cb_kllb_klfw { get; set; } /// /// 颗粒列表 数量上限 /// public int int_tb_kllb_ylsx { get; set; } /// /// 颗粒列表 显示元素 /// public string str_tb_kllb_sxys { get; set; } /// /// 颗粒列表 显示元素拆分元素列表 /// public List list_str_tb_lllb_sxys { get; set; } /// /// 颗粒列表 是否显示原始图像 /// public bool b_ck_kllb_ystx { get; set; } /// /// 颗粒列表 是否显示放大图像 /// public bool b_ck_kllb_fdtx { get; set; } /// /// 颗粒列表 是否显示能谱信息 /// public bool b_ck_kllb_npxx { get; set; } /// /// 颗粒列表 颗粒排序表行中第一个可选字段 文本 /// public string str_cb_kllb_sort_p1 { get; set; } /// /// 颗粒列表 颗粒排序表行中第一个可选字段 索引 /// public int index_cb_kllb_sort_p1 { get; set; } /// /// 颗粒列表 颗粒排序表行中第二个可选字段 文本 /// public string str_cb_kllb_sort_p2 { get; set; } /// /// 颗粒列表 颗粒排序表行中第二个可选字段 索引 /// public int index_cb_kllb_sort_p2 { get; set; } /// /// 颗粒列表 颗粒排序表行中第三个可选字段 文本 /// public string str_cb_kllb_sort_p3 { get; set; } /// /// 颗粒列表 颗粒排序表行中第三个可选字段 索引 /// public int index_cb_kllb_sort_p3 { get; set; } /// /// 颗粒列表 颗粒帧图表行中第一个可选字段 文本 /// public string str_cb_kllb_chartSort_p1 { get; set; } /// /// 颗粒列表 颗粒帧图表行中第一个可选字段 索引 /// public int index_cb_kllb_chartSort_p1 { get; set; } /// /// 颗粒列表 颗粒帧图表行中第二个可选字段 文本 /// public string str_cb_kllb_chartSort_p2 { get; set; } /// /// 颗粒列表 颗粒帧图表行中第二个可选字段 索引 /// public int index_cb_kllb_chartSort_p2 { get; set; } /// /// 颗粒列表去除不要的颗粒 /// public string str_kllb_qcys { get; set; } /// /// 颗粒列表去除不要的颗粒 /// public List list_str_kllb_qcys { get; set; } /// /// 颗粒列表去除不要的物质分类 /// public string str_kllb_DeleteClass { get; set; } /// /// 颗粒列表去除不要的物质分类 /// public List list_str_kllb_DeleteClass { get; set; } } #endregion #region 夹杂物占比 public class JZWZB { /// /// 夹杂物占比表 /// public bool b_ck_surface { get; set; } /// /// 夹杂物占比图 /// public bool b_ck_chart { get; set; } } #endregion } #endregion #region 窗体加载及构造函数 public OTSReport_Export(frmReportApp ReportApp) { InitializeComponent(); m_ReportApp = ReportApp; m_export_reporttemplate = new Export_ReportTemplate(this); //初始化xml类 xmlutil = new XmlConfigUtil(strPath); m_mbszclass = new c_TemplateClass(); //读取配置文件中的模板 LoadMBSZClass(); LoadRouteclass(); #region 国际化语言 Language lan = new Language(this); table = lan.GetNameTable(this.Name); #endregion } /// ///从配置文件中读取报告模板信息 /// private void LoadRouteclass() { if (m_mbszclass.M_DZ.route == null) { strPath2 = strPath; m_mbszclass.M_DZ.route = strPath; } else if (m_mbszclass.M_DZ.route == "") { strPath2 = strPath; m_mbszclass.M_DZ.route = strPath; } else { strPath2 = m_mbszclass.M_DZ.route; } xmlutil2 = new XmlConfigUtil(strPath2); //首页 m_mbszclass.M_SY.str_tb_ZBT = xmlutil2.Read("M_SY", "str_tb_ZBT"); m_mbszclass.M_SY.str_tb_FBT = xmlutil2.Read("M_SY", "str_tb_FBT"); m_mbszclass.M_SY.str_tb_YPBH = xmlutil2.Read("M_SY", "str_tb_YPBH"); m_mbszclass.M_SY.str_tb_CKBZ = xmlutil2.Read("M_SY", "str_tb_CKBZ"); m_mbszclass.M_SY.str_bz = xmlutil2.Read("M_SY", "str_bz"); m_mbszclass.M_SY.b_ck_ypsm = Convert.ToBoolean(xmlutil2.Read("M_SY", "b_ck_ypsm")); m_mbszclass.M_SY.b_ck_jggk = Convert.ToBoolean(xmlutil2.Read("M_SY", "b_ck_jggk")); m_mbszclass.M_SY.str_xzkl= xmlutil2.Read("M_SY", "str_xzkl"); m_mbszclass.M_SY.int_xzkl = Convert.ToInt32(xmlutil2.Read("M_SY", "int_xzkl")); //页眉页脚 m_mbszclass.M_YMYJ.str_tb_ymwb = xmlutil2.Read("M_YMYJ", "str_tb_ymwb"); m_mbszclass.M_YMYJ.str_tb_KHH = xmlutil2.Read("M_YMYJ", "str_tb_KHH"); m_mbszclass.M_YMYJ.b_ck_ym = Convert.ToBoolean(xmlutil2.Read("M_YMYJ", "b_ck_ym")); m_mbszclass.M_YMYJ.str_tb_yjwb = xmlutil2.Read("M_YMYJ", "str_tb_yjwb"); //颗粒分析结果 m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_ck_klcc_xsmk"));//是否显示模块 m_mbszclass.M_KLFXJG.index_cb_klcc_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_jsfs"));//计算方式 m_mbszclass.M_KLFXJG.str_cb_klcc_jsfs = Convert.ToString(xmlutil2.Read("M_KLFXJG", "str_cb_klcc_jsfs"));//计算方式 m_mbszclass.M_KLFXJG.index_cb_klcc_ljb = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_ljb"));//粒级表 m_mbszclass.M_KLFXJG.index_cb_klcc_klfw = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_klfw"));//颗粒范围 m_mbszclass.M_KLFXJG.b_cb_jzwfl_xsmk = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_cb_jzwfl_xsmk"));//是否显示该模块 m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_xstx"));//选择图像 m_mbszclass.M_KLFXJG.index_cb_jzwfl_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_jsfs"));//计算方式 m_mbszclass.M_KLFXJG.index_cb_jzwfl_ljb = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_ljb"));//粒级表 m_mbszclass.M_KLFXJG.index_cb_jzwfl_klfw = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_klfw"));//颗粒范围 //元素分析结果 m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk = Convert.ToBoolean(xmlutil2.Read("M_YSFXJG", "b_ck_ysfx_xsmk")); //是否显示模块 m_mbszclass.M_YSFXJG.index_cb_yxfx_jsfs = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yxfx_jsfs")); //计算方式 m_mbszclass.M_YSFXJG.index_cb_ysfx_klfw = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_ysfx_klfw")); //颗粒范围 m_mbszclass.M_YSFXJG.str_tb_ysfx_xsys = xmlutil2.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 = xmlutil2.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(xmlutil2.Read("M_YSFXJG", "b_ck_yscf_xsmk")); //是否显示模块 m_mbszclass.M_YSFXJG.index_cb_yscf_xstx = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_xstx")); //显示图形 m_mbszclass.M_YSFXJG.index_cb_yscf_jsfs = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_jsfs")); //计算方式 m_mbszclass.M_YSFXJG.index_cb_yscf_klfw = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_klfw")); //颗粒范围 m_mbszclass.M_YSFXJG.str_tb_yscf_ysxx = xmlutil2.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 = xmlutil2.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(xmlutil2.Read("M_SYXT", "b_ck_syxt_xsmk")); //是否显示模块 m_mbszclass.M_SYXT.index_cb_syxt_jsfs = Convert.ToInt32(xmlutil2.Read("M_SYXT", "index_cb_syxt_jsfs")); //计算方式 m_mbszclass.M_SYXT.index_cb_syxt_klfw = Convert.ToInt32(xmlutil2.Read("M_SYXT", "index_cb_syxt_klfw")); //颗粒范围 m_mbszclass.M_SYXT.str_cb_syxt_mhxssl = xmlutil2.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 = xmlutil2.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 = xmlutil2.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(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_xsmk")); //是否显示模块 m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_fjzt")); //是否显示帧图模块 m_mbszclass.M_KLLBXX.index_cb_kllb_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_jsfs")); //计算方式 m_mbszclass.M_KLLBXX.index_cb_kllb_klfw = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_klfw")); //颗粒范围 m_mbszclass.M_KLLBXX.int_tb_kllb_ylsx = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "int_tb_kllb_ylsx")); //数量上限 m_mbszclass.M_KLLBXX.str_tb_kllb_sxys = xmlutil2.Read("M_KLLBXX", "str_tb_kllb_sxys"); //显示元素 m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Clear(); for (int i = 0; i < 100; i++) //取得所有元素列表 { string str = xmlutil2.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.b_ck_kllb_ystx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_ystx")); //原始图像 m_mbszclass.M_KLLBXX.b_ck_kllb_fdtx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_fdtx")); //放大图像 m_mbszclass.M_KLLBXX.b_ck_kllb_npxx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_npxx")); //能谱图像 m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p1 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p1"));//颗粒列表列中第一个可选参数 m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p1 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p1")); m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p2 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p2"));//颗粒列表中第二个可选参数 m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p2 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p2")); m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p3 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p3"));//颗粒列表中第三个可选参数 m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p3 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p3")); m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p1 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p1"));//帧图表列中第一个可选参数 m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p1 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p1")); m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p2 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p2"));//帧图表列中第二个可选参数 m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p2 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p2")); //m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p3 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p3"));//帧图表列中第三个可选参数 //m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p3 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p3")); m_mbszclass.M_KLLBXX.str_kllb_qcys = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_kllb_qcys")); m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Clear(); for (int i = 0; i < 100; i++) //取得所有元素列表 { string str = xmlutil2.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(xmlutil2.Read("M_KLLBXX", "str_kllb_DeleteClass")); m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Clear(); for (int i = 0; i < 100; i++) //取得所有元素列表 { string str = xmlutil2.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(xmlutil2.Read("M_JZWZB", "b_ck_surface"));//夹杂物占比表 m_mbszclass.M_JZWZB.b_ck_chart= Convert.ToBoolean(xmlutil2.Read("M_JZWZB", "b_ck_chart"));//夹杂物占比图 } /// /// 从配置文件中读取报告模板路径 /// private void LoadMBSZClass() { //文件路径 m_mbszclass.M_DZ.route = xmlutil.Read("M_address", "Path"); if (m_mbszclass.M_DZ.route == "") { tb_mblj.Text = strPath; m_mbszclass.M_DZ.route = strPath; } else if (File.Exists(m_mbszclass.M_DZ.route)) { tb_mblj.Text = m_mbszclass.M_DZ.route; } else { tb_mblj.Text = strPath; m_mbszclass.M_DZ.route = strPath; } } /// /// 将报告模板信息保存到配置文件中 /// private void SaveMBSClass() { //文件路径 xmlutil.Write(m_mbszclass.M_DZ.route.ToString(), "M_address", "Path"); } /// /// 传入,3个层级的xml结点标识,进行删除结点 /// /// /// /// private void RemoveMBSZClassNode(string strnode_mk, string strnode_kj, string strnode_xh, int int_start) { for (int i = int_start; i < 1000; i++) { string strxh = i.ToString(); if (null != xmlutil.Read(strnode_mk, strnode_kj, strnode_xh + strxh)) { //删除该节点 xmlutil.RemoveNode(strnode_mk, strnode_kj, strnode_xh + strxh); } else { break; } } } /// /// 加载报告模板选择项,数据源选项 /// 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) { //先获取D盘,如果没有,则再获取C盘 string str_drivename = GetSecondDriveName(); if (str_drivename == "") str_drivename = GetFirstDriveName(); //初始化临时文件位置 m_str_tmpbitmappath = str_drivename + "1.bmp"; m_str_tmpbitmappath2 = str_drivename + "2.bmp"; m_str_tmpdocxpath = str_drivename + "1.doc"; //窗体加载时,初始化Combobox BindComboBox(); //设置界面线程 backgroundWorker2.WorkerReportsProgress = true; backgroundWorker2.WorkerSupportsCancellation = true; //确定报表进程db数据库的路径 string strdbname = "ReportTemplateDB.db"; m_strDBpath = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath; m_strDBpathGB = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath; m_strDBpath = m_strDBpath + "\\" + strdbname; m_strDBpathGB = m_strDBpathGB + "\\" + "ReportGBDB.db"; string strdbparticlelistname = "ReportTemplateDBParticleList.db"; m_strDBpath_ParticleList = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath; m_strDBpath_ParticleList = m_strDBpath_ParticleList + "\\" + strdbparticlelistname; } #endregion #region 自定义方法 /// /// 传入完整的路径及文件名,和需要的扩展名,返回文件加上需要的扩展名 /// /// /// /// public string GetFileExteName(string in_str, string in_extename) { string ret_str = in_str.Substring(0, in_str.IndexOf('.')); ret_str = ret_str + in_extename; return ret_str; } /// /// 获取第一个磁盘盘符的名称 /// /// public string GetFirstDriveName() { System.IO.DriveInfo[] ls_driveinfo = System.IO.DriveInfo.GetDrives(); if (ls_driveinfo.Count() > 0) return ls_driveinfo[0].Name; return ""; } /// /// 获取第二个磁盘盘符的名称,因为有时c盘不会给予读写的权限,所以要用到这个 /// /// private string GetSecondDriveName() { System.IO.DriveInfo[] ls_driveinfo = System.IO.DriveInfo.GetDrives(); if (ls_driveinfo.Count() > 1) return ls_driveinfo[1].Name; return ""; } /// /// 将文本追加到RictBox的尾部上 /// 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(); } /// /// 重载输出文本,带有可以指定颜色 /// /// /// public void WriteRictBox(string in_str, Color in_c) { //追加到rictbox尾部 richTextBox1.AppendText("[" + DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString() + ":" + DateTime.Now.Second.ToString() + "]" + in_str + Environment.NewLine); richTextBox1.SelectionColor = in_c; richTextBox1.ScrollToCaret(); } /// /// 根据传入的颜色,及传入Size的大小,返回一个该色的bitmap对象 /// /// /// public Bitmap GetBitmapByColor(Color in_c, Size in_z) { Bitmap bmp = new Bitmap(in_z.Width, in_z.Height); //这里给104是为了左边和右边空出2个像素,剩余的100就是百分比的值 Graphics g = Graphics.FromImage(bmp); g.Clear(Color.White); SolidBrush drawBrush = new SolidBrush(Color.Black); g.FillRectangle(new SolidBrush(in_c), 0, 0, in_z.Width, in_z.Height); return bmp; } /// /// [颜色:16进制转成RGB] /// /// 设置16进制颜色 [返回RGB] /// public System.Drawing.Color colorHx16toRGB(string strHxColor) { try { if (strHxColor.Length == 0) {//如果为空 return System.Drawing.Color.FromArgb(0, 0, 0);//设为黑色 } else {//转换颜色 if (strHxColor.IndexOf('#') > -1) { //如果颜色格式是 #0000FF 格式的 return System.Drawing.Color.FromArgb(System.Int32.Parse(strHxColor.Substring(1, 2), System.Globalization.NumberStyles.AllowHexSpecifier), System.Int32.Parse(strHxColor.Substring(3, 2), System.Globalization.NumberStyles.AllowHexSpecifier), System.Int32.Parse(strHxColor.Substring(5, 2), System.Globalization.NumberStyles.AllowHexSpecifier)); } else { //如果颜色格式是 0000FF 格式的 return System.Drawing.Color.FromArgb(System.Int32.Parse(strHxColor.Substring(0, 2), System.Globalization.NumberStyles.AllowHexSpecifier), System.Int32.Parse(strHxColor.Substring(2, 2), System.Globalization.NumberStyles.AllowHexSpecifier), System.Int32.Parse(strHxColor.Substring(4, 2), System.Globalization.NumberStyles.AllowHexSpecifier)); } } } catch {//设为黑色 return System.Drawing.Color.FromArgb(0, 0, 0); } } /// /// [颜色:RGB转成16进制]专为输出Excel表头格式而定制,其它地方不要使用该方法,或修改返回加#号,例#000000FF /// /// 红 int /// 绿 int /// 蓝 int /// public string colorRGBtoHx16ForExcel(Color color) { if (color.IsEmpty) return "000000"; return String.Format("{0:X2}{1:X2}{2:X2}", color.R, color.G, color.B); } /// /// 将RGB颜色转成整数 /// /// /// public int ParseRGB(Color color) { return (int)(((int)color.B << 16) | (ushort)(((ushort)color.G << 8) | color.R)); } /// /// 从指定的几种颜色中进行随机颜色,传入30个颜色的范围,越大颜色越多 /// /// 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; } /// /// 打开报表模板进程 /// private void OpenOTSINcAreportTemplateAPP() { ReportPrintTool tool = new ReportPrintTool(DEVReport); tool.ShowPreview(); } /// /// 打开报表模板进程,颗粒列表 /// public void OpenOTSINcAreportTemplateAPP_ParticleList(string arg4) { //---------------------------------- //共传4个参数 //参数1:是需要打开db数据库的路径 //参数2:是打开报表模板xml文件的路径 //参数3:是要执行查看报表的类型,输出主报表,还是输出颗粒列表 //参数4:打开主报表时是是指定夹杂物的数量,打开颗粒列表时,是颗粒列表显示的范围如,0-50,50-100 //参数5:是要执行查看报表的类型,输出主报表时,指定读取的标记帧图图像范围,如0-50,50-100,输出颗粒列表时无用 //---------------------------------- ProcessStartInfo process = new ProcessStartInfo(); process.FileName = "ReportTemplateExe\\OTSIncAReportTemplate.exe";//打开app的路径 string arg1 = m_strDBpath_ParticleList.Replace(" ", "^");//参数1,是需要打开db数据库的路径 string arg2 = tb_mblj.Text.Trim().Replace(" ", "^");//参数2,是模板文件的路径 string arg3 = "ParticleListReport";//颗粒列表 //string arg4 = "";//夹杂物数量,从多少到多少 string arg5 = "0";//在打开颗粒列表时,传的标记帧图图像数量参数暂不用 process.Arguments = string.Format("{0} {1} {2} {3} {4}", arg1, arg2, arg3, arg4, arg5); //多个参数用空格隔开 process.WindowStyle = ProcessWindowStyle.Normal; Process.Start(process); } #endregion #region 窗体控件事件 private void OTSReport_Export_FormClosing(object sender, FormClosingEventArgs e) { if (backgroundWorker2.IsBusy == true) { //导出线程正在工作中,不让退出该界面 MessageBox.Show(table["messagebox1"].ToString(), table["messagebox2"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information); //然后取消关闭窗体的事件 e.Cancel = true; } } private void btn_preview_Click(object sender, EventArgs e) { DEVReport = new OTS_DEVReport(this, m_mbszclass); //DEVReport.Dispose(); m_ReportApp.m_rstDataMgr.setSelectedIndex(cbo_sjy.SelectedIndex); //重新导出报表数据 m_ReportApp.m_ChartsWindow.Activate(); WriteRictBox(table["rictbox1"].ToString()); progressBar1.Value = 0; //预览 if (backgroundWorker2.IsBusy != true) { // 启动异步操作 backgroundWorker2.RunWorkerAsync(); } } 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) { 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) { //预览设置 OTSReport_TemplateDesignerRM OtsTemDRM = new OTSReport_TemplateDesignerRM(this); if (OtsTemDRM.ShowDialog() == DialogResult.Yes) { //如果用户点击确定,则将m_mbszclass,模板设置类的内容存到文件中。 // m_mbszclass.M_DZ.route = tb_mblj.Text; m_mbszclass.M_DZ.route = tb_mblj.Text; SaveMBSClass(); } } #endregion #region 导出工作线程部份 private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; //主任务的实现 #region //获取模板设置的导出的内容------------------------------------------------- //获取报告模板设置内容 worker.ReportProgress(0, table["rictbox4"].ToString());//已获取模板中设置内容为: System.Threading.Thread.Sleep(1); //更新进度 worker.ReportProgress(5); #endregion //设置模板导出内容结束-------------------------------------------------------- int processvalue = 12;//各功能模块从进度条为15时开始依次调用 #region //依次循环调用各功能模块------------------------------------------------------------- int i_zz = 0;//增值 i_zz = 80 / 9; //首先将测量结果信息表导出,在表头------------------------------------------------ worker.ReportProgress(0, table["result_information_ing"].ToString());//加载测量结果信息表模块中.... worker.ReportProgress(0, table["load_result_information"].ToString());//加载:测量结果信息表 //更新进度条 processvalue = processvalue + 1; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_result_information_completed"].ToString());//加载测量结果信息表模块完成 //------------------------------------------------------------------------- //调用,颗粒尺寸分析表------------------------------------------------ worker.ReportProgress(0, table["dimensional_analysis_table_ing"].ToString());//加载颗粒尺寸分析表模块中.... worker.ReportProgress(0, table["loading_dimension_analysis_table"].ToString());//加载:颗粒尺寸分析表 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_dimension_analysis_table_completed"].ToString());//加载颗粒尺寸分析表模块完成 //调用,元素分析表--------------------------------------------- worker.ReportProgress(0, table["element_analysis_table_ing"].ToString());//加载元素分析表模块中.... worker.ReportProgress(0, table["load_element_analysis_table"].ToString());//加载:元素分析表 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_element_analysis_table_completed"].ToString());//加载元素分析表模块完成 //调用,夹杂物面积比表--------------------------------------------- worker.ReportProgress(0, table["inca_area_ratio_table_ing"].ToString());//加载夹杂物面积比表模块中.... worker.ReportProgress(0, table["load_inca_area_ratio_table"].ToString());//加载:夹杂物面积比表 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_inca_area_ratio_table_completed"].ToString());//加载夹杂物面积比表模块完成 //调用,夹杂物面积比图--------------------------------------------- worker.ReportProgress(0, table["inca_area_ratio_diagram_ing"].ToString());//加载夹杂物面积比图模块中.... worker.ReportProgress(0, table["load_inca_area_ratio_diagram"].ToString());//加载:夹杂物面积比图 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_inca_area_ratio_diagram_completed"].ToString());//加载夹杂物面积比图模块完成 //System.Threading.Thread.Sleep(2000); //调用,三元相图---------------------------------------------- worker.ReportProgress(0, table["ternary_graph_ing"].ToString());//加载三元相图模块中.... worker.ReportProgress(0, table["load_ternary_graph"].ToString());//加载:三元相图 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_ternary_graph_completed"].ToString());//加载三元相图模块完成 //调用输出,颗粒列表---------------------------------------- worker.ReportProgress(0, table["particle_list_ing"].ToString());//加载颗粒列表模块中.... worker.ReportProgress(0, table["load_particle_list"].ToString());//加载:颗粒列表 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_particle_list_completed"].ToString());//加载颗粒列表模块完成 //调用输出,颗粒列表帧图---------------------------------------- worker.ReportProgress(0, table["particle_list_frame_diagram_ing"].ToString());//加载颗粒列表帧图模块中.... worker.ReportProgress(0, table["load_particle_list_frame_diagram"].ToString());//加载:颗粒列表帧图 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["loading_particle_list_frame_diagram_completed"].ToString());//加载颗粒列表帧图模块完成 //生成,模板临时数据库文件---------------------------------------------- worker.ReportProgress(0, table["rictbox35"].ToString());//生成模板临时数据库文件.... worker.ReportProgress(0, table["rictbox36"].ToString());//加载:生成模板临时数据库文件 //更新进度条 processvalue = processvalue + i_zz; worker.ReportProgress(processvalue); lock (m_thread_flag) m_thread_flag = table["rictbox7"].ToString();//等待 while (m_thread_flag == table["rictbox7"].ToString())//等待 { System.Threading.Thread.Sleep(500); } worker.ReportProgress(0, table["rictbox37"].ToString());//模板临时数据库文件完成 #endregion 依将循环调用各功能模块结束------------------------------------------------------- } private string AnalyticGraphics(int a_Indexes) { if (a_Indexes == 0) return "pie";//饼图 else if (a_Indexes == 1) return "radius";//圈图 else if (a_Indexes == 2) return "bar";//柱状图 else if (a_Indexes == 3) return "line";//线状图 else return "stack";//堆叠图 } private void backgroundWorker2_ProgressChanged(object sender, ProgressChangedEventArgs e) { string strNill = table["rictbox40"].ToString(); BackgroundWorker worker = sender as BackgroundWorker; //更新进度条的进度 if (e.UserState != null) { string ls_str = (string)e.UserState; WriteRictBox((string)e.UserState); string s = AnalyticGraphics(m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx); if (ls_str.IndexOf(table["rictbox12"].ToString()) > -1)//加载: { if (ls_str.IndexOf(table["result_information"].ToString()) > -1)//测量结果信息表 { DEVReport.International_language(dev_internationalLanguage()); DEVReport.setResultGrid(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["dimensional_analysis_table"].ToString()) > -1)//颗粒尺寸分析表 { if (m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk) DEVReport.setParticleSizeTable(true,true); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["element_analysis_table"].ToString()) > -1)//元素分析表 { if (m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk) DEVReport.setElementAvgGrid(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["inca_area_ratio_table"].ToString()) > -1)//夹杂物面积比表 { if (m_mbszclass.M_JZWZB.b_ck_surface) DEVReport.setINCAtable(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["inca_area_ratio_diagram"].ToString()) > -1)//夹杂物面积比图 { if (m_mbszclass.M_JZWZB.b_ck_chart) { DEVReport.set_incaPIC_classify(); DEVReport.set_incaPIC_subdivision(); } lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["ternary_graph"].ToString()) > -1)//三元图 { if (m_mbszclass.M_SYXT.b_ck_syxt_xsmk) DEVReport.InsertReportTemplateChart_Trianglediagram(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["particle_list"].ToString()) > -1)//颗粒列表 { if (m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk) DEVReport.set_kllb_data(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["particle_list_frame_diagram"].ToString()) > -1)//颗粒帧图列表 { if (m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt) DEVReport.set_kllb_data_frame(); lock (m_thread_flag) m_thread_flag = strNill; } if (ls_str.IndexOf(table["rictbox38"].ToString()) > -1)//生成模板临时数据库文件 { //DEVReport.International_language(dev_internationalLanguage()); lock (m_thread_flag) m_thread_flag = strNill; } } } else { progressBar1.Value = e.ProgressPercentage; WriteRictBox(table["rictbox39"].ToString() + e.ProgressPercentage.ToString() + "%"); } } private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { WriteRictBox(table["rictbox41"].ToString() + m_export_reporttemplate.m_list_dt.Count.ToString() + table["rictbox42"].ToString(), Color.Red); //处理结束后,再将button的状态更新回去 progressBar1.Value = 100; WriteRictBox("-----------------"+ table["rictbox43"].ToString() + "--------------------", Color.Red); MemoryManagementClass.FlushMemory(); //导出完成,打开报表 OpenOTSINcAreportTemplateAPP(); m_ReportApp.m_conditionChoose.ShowsTheDefaultPic(); this.Close(); } #endregion #region 读取文件 private void LoadControlsToXml() { string path = string.Empty; OpenFileDialog Load = new OpenFileDialog(); Load.Filter = "XML File|*.xml"; Load.InitialDirectory = @System.Windows.Forms.Application.StartupPath + "\\Config\\ProData"; if (Load.ShowDialog() == DialogResult.OK) path = Load.FileName;//赋值目录 if (path != string.Empty) { tb_mblj.Text = path; m_mbszclass.M_DZ.route = path; OTSIncAReportApp.Controls.XmlConfigUtil xmlutil = new OTSIncAReportApp.Controls.XmlConfigUtil(path); //首页 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.str_bz = xmlutil.Read("M_SY", "str_bz"); m_mbszclass.M_SY.b_ck_ypsm = Convert.ToBoolean(xmlutil.Read("M_SY", "b_ck_ypsm")); m_mbszclass.M_SY.b_ck_jggk = Convert.ToBoolean(xmlutil.Read("M_SY", "b_ck_jggk")); m_mbszclass.M_SY.str_xzkl = xmlutil.Read("M_SY", "str_xzkl"); m_mbszclass.M_SY.int_xzkl = Convert.ToInt32(xmlutil.Read("M_SY", "int_xzkl")); //页眉页脚 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.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.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.int_tb_kllb_ylsx = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "int_tb_kllb_ylsx")); //数量上限 m_mbszclass.M_KLLBXX.str_tb_kllb_sxys = xmlutil.Read("M_KLLBXX", "str_tb_kllb_sxys"); //显示元素 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.b_ck_kllb_ystx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_ystx")); //原始图像 m_mbszclass.M_KLLBXX.b_ck_kllb_fdtx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_fdtx")); //放大图像 m_mbszclass.M_KLLBXX.b_ck_kllb_npxx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_npxx")); //能谱图像 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.str_cb_kllb_chartSort_p3 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p3"));//帧图表列中第三个可选参数 //m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p3 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p3")); } } #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) { } private void button1_Click(object sender, EventArgs e) { DEVReport = new OTS_DEVReport(this, m_mbszclass); //DEVReport.Dispose(); //DEVReport = new OTS_DEVReport(this); DEVReport.setResultGrid(); DEVReport.setParticleSizeTable(true,true); DEVReport.setElementAvgGrid(); DEVReport.setINCAtable(); DEVReport.set_incaPIC_classify(); DEVReport.set_incaPIC_subdivision(); DEVReport.InsertReportTemplateChart_Trianglediagram(); DEVReport.set_kllb_data(); DEVReport.set_kllb_data_frame(); DEVReport.International_language(dev_internationalLanguage()); ReportPrintTool tool = new ReportPrintTool(DEVReport); tool.ShowPreview(); } /// /// 从数据库中读取语言配置信息 /// /// 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; } } }