OTSReport_Export.cs 82 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927
  1. using OTSIncAReportApp.Controls;
  2. using OTSIncAReportApp.DataOperation.DataAccess;
  3. using OTSCommon.Model;
  4. using OTSIncAReportApp.OTSSampleReportInfo;
  5. using OTSIncAReportApp.OTSTemplateDesigner;
  6. using OTSIncAReportApp.SysMgrTools;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.ComponentModel;
  10. using System.Data;
  11. using System.Data.SQLite;
  12. using System.Diagnostics;
  13. using System.Drawing;
  14. using System.IO;
  15. using System.Linq;
  16. using System.Windows.Forms;
  17. using System.Xml;
  18. using OTSIncAReportApp._1_UI.OTSTemplateDesigner;
  19. using DevExpress.XtraReports.UI;
  20. using OTSIncAReportApp.ReportTemplate;
  21. namespace OTSIncAReportApp
  22. {
  23. public partial class OTSReport_Export : Form
  24. {
  25. #region 全局变量
  26. public string m_thread_flag = "无"; //线程操作的标识
  27. public string m_str_tmpbitmappath = "d:\\1.bmp"; //存放临时图片 的路径名和文件名
  28. public string m_str_tmpbitmappath2 = "d:\\2.bmp";
  29. public string m_str_tmpdocxpath = "d:\\1.doc";
  30. public string m_strDBpath = ""; //报表模板数据库文件
  31. public string m_strDBpathGB = ""; //报告国标导出
  32. public string m_strDBpath_ParticleList = ""; //报表模板,颗粒列表数据库文件
  33. public int m_SelectedIndex = 0;
  34. System.Collections.Hashtable table;
  35. public frmReportApp m_ReportApp = null; //报告项目总进程对象
  36. public string m_export_type = "Excel"; //导出文件的格式类型Excel,Word,Pdf
  37. Export_ReportTemplate m_export_reporttemplate;
  38. public string strPath = "./Config/ReportTemplate/ReportTemplateConfig.xml"; //报告模板设置文件的路径
  39. public string strPath2;
  40. public XmlOperateUtil xmlutil;
  41. public XmlOperateUtil xmlutil2;
  42. public c_TemplateClass m_mbszclass = null;
  43. OTS_DEVReport DEVReport;
  44. GBReport GB_Report;
  45. /*public bool ReportExporting = false;*///判断报告是不在是在导出的过程中
  46. #endregion
  47. #region 条件参数变量
  48. /// <summary>
  49. /// 选择的数据类型
  50. /// </summary>
  51. public string SJLX { get; set; }
  52. /// <summary>
  53. /// 尺寸计算方法
  54. /// </summary>
  55. public string CCJSFF { get; set; }
  56. /// <summary>
  57. /// 粒级表
  58. /// </summary>
  59. public string LJB { get; set; }
  60. /// <summary>
  61. /// 三元相图模板
  62. /// </summary>
  63. public string SYXTMB { get; set; }
  64. #endregion
  65. #region 模板设置类
  66. /// <summary>
  67. /// 模板设置类
  68. /// </summary>
  69. public class c_TemplateClass
  70. {
  71. /// <summary>
  72. /// 配置文件路径
  73. /// </summary>
  74. public DZ M_DZ { get; set; }
  75. #region 属性
  76. /// <summary>
  77. /// 首页
  78. /// </summary>
  79. public SY M_SY { get; set; }
  80. /// <summary>
  81. /// 页眉页脚
  82. /// </summary>
  83. public YMYJ M_YMYJ { get; set; }
  84. /// <summary>
  85. /// 颗粒分析结果
  86. /// </summary>
  87. public KLFXJG M_KLFXJG { get; set; }
  88. /// <summary>
  89. /// 元素分析结果
  90. /// </summary>
  91. public YSFXJG M_YSFXJG { get; set; }
  92. /// <summary>
  93. /// 三元相图
  94. /// </summary>
  95. public SYXT M_SYXT { get; set; }
  96. /// <summary>
  97. /// 颗粒列表信息
  98. /// </summary>
  99. public KLLBXX M_KLLBXX { get; set; }
  100. /// <summary>
  101. /// 夹杂物占比
  102. /// </summary>
  103. public JZWZB M_JZWZB { get; set; }
  104. #endregion
  105. #region 构造函数
  106. public c_TemplateClass()
  107. {
  108. M_SY = new SY();
  109. M_YMYJ = new YMYJ();
  110. M_KLFXJG = new KLFXJG();
  111. M_YSFXJG = new YSFXJG();
  112. M_YSFXJG.list_str_tb_yscf_ysxx = new List<string>();
  113. M_YSFXJG.list_str_tb_ysfx_xsys = new List<string>();
  114. M_SYXT = new SYXT();
  115. M_SYXT.list_lbv_syxt_mblb = new List<string>();
  116. M_SYXT.list_lbv_syxt_mblb_index = new List<int>();
  117. M_KLLBXX = new KLLBXX();
  118. M_JZWZB = new JZWZB();
  119. M_KLLBXX.list_str_tb_lllb_sxys = new List<string>();
  120. M_KLLBXX.list_str_kllb_qcys = new List<string>();
  121. M_KLLBXX.list_str_kllb_DeleteClass = new List<string>();
  122. M_DZ = new DZ();
  123. }
  124. #endregion
  125. public class DZ
  126. {
  127. public string route { get; set; }
  128. }
  129. #region 首页部份
  130. public class SY
  131. {
  132. /// <summary>
  133. /// 主标题
  134. /// </summary>
  135. public string str_tb_ZBT { get; set; }
  136. /// <summary>
  137. /// 副标题
  138. /// </summary>
  139. public string str_tb_FBT { get; set; }
  140. /// <summary>
  141. /// 样品编号
  142. /// </summary>
  143. public string str_tb_YPBH { get; set; }
  144. /// <summary>
  145. /// 参考标准
  146. /// </summary>
  147. public string str_tb_CKBZ { get; set; }
  148. /// <summary>
  149. /// 是否显示样品说明
  150. /// </summary>
  151. public bool b_ck_ypsm { get; set; }
  152. /// <summary>
  153. /// 是否显示结果概况
  154. /// </summary>
  155. public bool b_ck_jggk { get; set; }
  156. /// <summary>
  157. /// 报告备注
  158. /// </summary>
  159. public string str_bz { get; set; }
  160. /// <summary>
  161. /// 选择颗粒导出范围_内容
  162. /// </summary>
  163. public string str_xzkl { get; set; }
  164. /// <summary>
  165. /// 选择颗粒导出范围,索引
  166. /// </summary>
  167. public int int_xzkl { get; set; }
  168. }
  169. #endregion
  170. #region 页眉页脚部份
  171. public class YMYJ
  172. {
  173. /// <summary>
  174. /// 页眉文本
  175. /// </summary>
  176. public string str_tb_ymwb { get; set; }
  177. /// <summary>
  178. /// 客户号
  179. /// </summary>
  180. public string str_tb_KHH { get; set; }
  181. /// <summary>
  182. /// 是否显示页码
  183. /// </summary>
  184. public bool b_ck_ym { get; set; }
  185. /// <summary>
  186. /// 页脚文本
  187. /// </summary>
  188. public string str_tb_yjwb { get; set; }
  189. }
  190. #endregion
  191. #region 颗粒分析结果部份
  192. public class KLFXJG
  193. {
  194. /// <summary>
  195. /// 大分类是否显示
  196. /// </summary>
  197. public bool b_ck_klcc_dfl { get; set; }
  198. /// <summary>
  199. /// 小分类是否显示
  200. /// </summary>
  201. public bool b_ck_klcc_xfl { get; set; }
  202. /// <summary>
  203. /// 是否显示颗粒尺寸分析结果表
  204. /// </summary>
  205. public bool b_ck_klcc_xsmk { get; set; }
  206. /// <summary>
  207. /// 是否显示颗粒尺寸 堆叠图
  208. /// </summary>
  209. public bool b_ck_klcc_xsddt { get; set; }
  210. /// <summary>
  211. ///颗粒尺寸分析结果表 计算方式文本
  212. /// </summary>
  213. public string str_cb_klcc_jsfs { get; set; }
  214. /// <summary>
  215. ///颗粒尺寸分析结果表 计算方式索引
  216. /// </summary>
  217. public int index_cb_klcc_jsfs { get; set; }
  218. /// <summary>
  219. ///颗粒尺寸分析结果表 粒级表文本
  220. /// </summary>
  221. public string str_cb_klcc_ljb { get; set; }
  222. /// <summary>
  223. ///颗粒尺寸分析结果表 粒级表索引
  224. /// </summary>
  225. public int index_cb_klcc_ljb { get; set; }
  226. /// <summary>
  227. ///颗粒尺寸分析结果表 颗粒选择范围文本
  228. /// </summary>
  229. public string str_cb_klcc_klfw { get; set; }
  230. /// <summary>
  231. ///颗粒尺寸分析结果表 颗粒选择范围索引
  232. /// </summary>
  233. public int index_cb_klcc_klfw { get; set; }
  234. /// <summary>
  235. /// 夹杂物分类图 是否显示该模块
  236. /// </summary>
  237. public bool b_cb_jzwfl_xsmk { get; set; }
  238. /// <summary>
  239. ///夹杂物分类图 显示图形选择文本
  240. /// </summary>
  241. public string str_cb_jzwfl_xstx { get; set; }
  242. /// <summary>
  243. ///夹杂物分类图 显示图形 选择索引
  244. /// </summary>
  245. public int index_cb_jzwfl_xstx { get; set; }
  246. /// <summary>
  247. ///夹杂物分类图 计算方式 选择文本
  248. /// </summary>
  249. public string str_cb_jzwfl_jsfs { get; set; }
  250. /// <summary>
  251. ///夹杂物分类图 计算方式 选择索引
  252. /// </summary>
  253. public int index_cb_jzwfl_jsfs { get; set; }
  254. /// <summary>
  255. ///夹杂物分类图 粒级表 选择文本
  256. /// </summary>
  257. public string str_cb_jzwfl_ljb { get; set; }
  258. /// <summary>
  259. ///夹杂物分类图 粒级表 选择索引
  260. /// </summary>
  261. public int index_cb_jzwfl_ljb { get; set; }
  262. /// <summary>
  263. ///夹杂物分类图 颗粒范围 选择文本
  264. /// </summary>
  265. public string str_cb_jzwfl_klfw { get; set; }
  266. /// <summary>
  267. ///夹杂物分类图 颗粒范围 选择索引
  268. /// </summary>
  269. public int index_cb_jzwfl_klfw { get; set; }
  270. }
  271. #endregion
  272. #region 元素分析结果部份
  273. public class YSFXJG
  274. {
  275. /// <summary>
  276. /// 元素分析表 是否显示该模块
  277. /// </summary>
  278. public bool b_ck_ysfx_xsmk { get; set; }
  279. /// <summary>
  280. /// 元素分析表 计算方式 选择文本
  281. /// </summary>
  282. public string str_cb_yxfx_jsfs { get; set; }
  283. /// <summary>
  284. /// 元素分析表 计算方式 选择索引
  285. /// </summary>
  286. public int index_cb_yxfx_jsfs { get; set; }
  287. /// <summary>
  288. /// 元素分析表 颗粒范围 选择文本
  289. /// </summary>
  290. public string str_cb_ysfx_klfw { get; set; }
  291. /// <summary>
  292. /// 元素分析表 颗粒范围 选择索引
  293. /// </summary>
  294. public int index_cb_ysfx_klfw { get; set; }
  295. /// <summary>
  296. /// 元素分析表 显示元素显示文本
  297. /// </summary>
  298. public string str_tb_ysfx_xsys { get; set; }
  299. /// <summary>
  300. /// 元素分析表 显示元素拆分元素列表
  301. /// </summary>
  302. public List<string> list_str_tb_ysfx_xsys { get; set; }
  303. /// <summary>
  304. /// 元素成份图 是否显示该模块
  305. /// </summary>
  306. public bool b_ck_yscf_xsmk { get; set; }
  307. /// <summary>
  308. /// 元素成份图 显示图形 文本
  309. /// </summary>
  310. public string str_cb_yscf_xstx { get; set; }
  311. /// <summary>
  312. /// 元素成份图 显示图形 索引
  313. /// </summary>
  314. public int index_cb_yscf_xstx { get; set; }
  315. /// <summary>
  316. /// 元素成份图 计算方式 文本
  317. /// </summary>
  318. public string str_cb_yscf_jsfs { get; set; }
  319. /// <summary>
  320. /// 元素成份图 计算方式 索引
  321. /// </summary>
  322. public int index_cb_yscf_jsfs { get; set; }
  323. /// <summary>
  324. /// 元素成份图 颗粒范围 文本
  325. /// </summary>
  326. public string str_cb_yscf_klfw { get; set; }
  327. /// <summary>
  328. /// 元素成份图 颗粒范围 索引
  329. /// </summary>
  330. public int index_cb_yscf_klfw { get; set; }
  331. /// <summary>
  332. /// 元素成份图 元素信息
  333. /// </summary>
  334. public string str_tb_yscf_ysxx { get; set; }
  335. /// <summary>
  336. /// 元素成份图 元素信息列表拆分字符列表
  337. /// </summary>
  338. public List<string> list_str_tb_yscf_ysxx { get; set; }
  339. }
  340. #endregion
  341. #region 三元相图部份
  342. public class SYXT
  343. {
  344. /// <summary>
  345. /// 三元相图 是否显示该模块
  346. /// </summary>
  347. public bool b_ck_syxt_xsmk { get; set; }
  348. /// <summary>
  349. /// 计算方式 文本
  350. /// </summary>
  351. public string str_cb_syxt_jsfs { get; set; }
  352. /// <summary>
  353. /// 计算方式 索引
  354. /// </summary>
  355. public int index_cb_syxt_jsfs { get; set; }
  356. /// <summary>
  357. /// 颗粒范围 文本
  358. /// </summary>
  359. public string str_cb_syxt_klfw { get; set; }
  360. /// <summary>
  361. /// 颗粒范围 索引
  362. /// </summary>
  363. public int index_cb_syxt_klfw { get; set; }
  364. /// <summary>
  365. /// 粒级表信息 文本
  366. /// </summary>
  367. public string str_cb_syxt_ljb { get; set; }
  368. /// <summary>
  369. /// 粒级表信息 索引
  370. /// </summary>
  371. public int index_cb_syxt_ljb { get; set; }
  372. /// <summary>
  373. /// 每行显示数量 文本
  374. /// </summary>
  375. public string str_cb_syxt_mhxssl { get; set; }
  376. /// <summary>
  377. /// 每行显示数量 索引
  378. /// </summary>
  379. public int index_cb_syxt_mhxssl { get; set; }
  380. /// <summary>
  381. /// 三元相图模板集合列表
  382. /// </summary>
  383. public List<string> list_lbv_syxt_mblb { get; set; }
  384. /// <summary>
  385. /// 三元相图模板索引集合列表
  386. /// </summary>
  387. public List<int> list_lbv_syxt_mblb_index { get; set; }
  388. }
  389. #endregion
  390. #region 颗粒列表信息部份
  391. public class KLLBXX
  392. {
  393. /// <summary>
  394. /// 颗粒列表 是否显示该模块
  395. /// </summary>
  396. public bool b_ck_kllb_xsmk { get; set; }
  397. /// <summary>
  398. /// 颗粒列表 是否显示附加帧图模块
  399. /// </summary>
  400. public bool b_ck_kllb_fjzt { get; set; }
  401. /// <summary>
  402. /// 颗粒列表 计算方式 文本
  403. /// </summary>
  404. public string str_cb_kllb_jsfs { get; set; }
  405. /// <summary>
  406. /// 颗粒列表 计算方式 索引
  407. /// </summary>
  408. public int index_cb_kllb_jsfs { get; set; }
  409. /// <summary>
  410. /// 颗粒列表 颗粒范围 文本
  411. /// </summary>
  412. public string str_cb_kllb_klfw { get; set; }
  413. /// <summary>
  414. /// 颗粒列表 颗粒范围 索引
  415. /// </summary>
  416. public int index_cb_kllb_klfw { get; set; }
  417. /// <summary>
  418. /// 颗粒列表 数量上限
  419. /// </summary>
  420. public int int_tb_kllb_ylsx { get; set; }
  421. /// <summary>
  422. /// 颗粒列表 显示元素
  423. /// </summary>
  424. public string str_tb_kllb_sxys { get; set; }
  425. /// <summary>
  426. /// 颗粒列表 显示元素拆分元素列表
  427. /// </summary>
  428. public List<string> list_str_tb_lllb_sxys { get; set; }
  429. /// <summary>
  430. /// 颗粒列表 是否显示原始图像
  431. /// </summary>
  432. public bool b_ck_kllb_ystx { get; set; }
  433. /// <summary>
  434. /// 颗粒列表 是否显示放大图像
  435. /// </summary>
  436. public bool b_ck_kllb_fdtx { get; set; }
  437. /// <summary>
  438. /// 颗粒列表 是否显示能谱信息
  439. /// </summary>
  440. public bool b_ck_kllb_npxx { get; set; }
  441. /// <summary>
  442. /// 颗粒列表 颗粒排序表行中第一个可选字段 文本
  443. /// </summary>
  444. public string str_cb_kllb_sort_p1 { get; set; }
  445. /// <summary>
  446. /// 颗粒列表 颗粒排序表行中第一个可选字段 索引
  447. /// </summary>
  448. public int index_cb_kllb_sort_p1 { get; set; }
  449. /// <summary>
  450. /// 颗粒列表 颗粒排序表行中第二个可选字段 文本
  451. /// </summary>
  452. public string str_cb_kllb_sort_p2 { get; set; }
  453. /// <summary>
  454. /// 颗粒列表 颗粒排序表行中第二个可选字段 索引
  455. /// </summary>
  456. public int index_cb_kllb_sort_p2 { get; set; }
  457. /// <summary>
  458. /// 颗粒列表 颗粒排序表行中第三个可选字段 文本
  459. /// </summary>
  460. public string str_cb_kllb_sort_p3 { get; set; }
  461. /// <summary>
  462. /// 颗粒列表 颗粒排序表行中第三个可选字段 索引
  463. /// </summary>
  464. public int index_cb_kllb_sort_p3 { get; set; }
  465. /// <summary>
  466. /// 颗粒列表 颗粒帧图表行中第一个可选字段 文本
  467. /// </summary>
  468. public string str_cb_kllb_chartSort_p1 { get; set; }
  469. /// <summary>
  470. /// 颗粒列表 颗粒帧图表行中第一个可选字段 索引
  471. /// </summary>
  472. public int index_cb_kllb_chartSort_p1 { get; set; }
  473. /// <summary>
  474. /// 颗粒列表 颗粒帧图表行中第二个可选字段 文本
  475. /// </summary>
  476. public string str_cb_kllb_chartSort_p2 { get; set; }
  477. /// <summary>
  478. /// 颗粒列表 颗粒帧图表行中第二个可选字段 索引
  479. /// </summary>
  480. public int index_cb_kllb_chartSort_p2 { get; set; }
  481. /// <summary>
  482. /// 颗粒列表去除不要的颗粒
  483. /// </summary>
  484. public string str_kllb_qcys { get; set; }
  485. /// <summary>
  486. /// 颗粒列表去除不要的颗粒
  487. /// </summary>
  488. public List<string> list_str_kllb_qcys { get; set; }
  489. /// <summary>
  490. /// 颗粒列表去除不要的物质分类
  491. /// </summary>
  492. public string str_kllb_DeleteClass { get; set; }
  493. /// <summary>
  494. /// 颗粒列表去除不要的物质分类
  495. /// </summary>
  496. public List<string> list_str_kllb_DeleteClass { get; set; }
  497. /// <summary>
  498. /// 显示颗粒数量
  499. /// </summary>
  500. public int list_int_kllb_number { get; set; }
  501. }
  502. #endregion
  503. #region 夹杂物占比
  504. public class JZWZB
  505. {
  506. /// <summary>
  507. /// 夹杂物占比表
  508. /// </summary>
  509. public bool b_ck_surface { get; set; }
  510. /// <summary>
  511. /// 夹杂物占比图
  512. /// </summary>
  513. public bool b_ck_chart { get; set; }
  514. }
  515. #endregion
  516. }
  517. #endregion
  518. #region 窗体加载及构造函数
  519. public OTSReport_Export(frmReportApp ReportApp)
  520. {
  521. InitializeComponent();
  522. m_ReportApp = ReportApp;
  523. m_export_reporttemplate = new Export_ReportTemplate(this);
  524. //初始化xml类
  525. xmlutil = new XmlOperateUtil(strPath);
  526. m_mbszclass = new c_TemplateClass();
  527. //读取配置文件中的模板路径
  528. LoadMBSZClass();
  529. LoadRouteclass();
  530. #region 国际化语言
  531. Language lan = new Language(this);
  532. table = lan.GetNameTable(this.Name);
  533. #endregion
  534. }
  535. ///<summary>
  536. ///从配置文件中读取报告模板信息
  537. /// </summary>
  538. private void LoadRouteclass()
  539. {
  540. if (m_mbszclass.M_DZ.route == null)
  541. {
  542. strPath2 = strPath;
  543. m_mbszclass.M_DZ.route = strPath;
  544. }
  545. else
  546. if (m_mbszclass.M_DZ.route == "")
  547. {
  548. strPath2 = strPath;
  549. m_mbszclass.M_DZ.route = strPath;
  550. }
  551. else
  552. {
  553. strPath2 = m_mbszclass.M_DZ.route;
  554. }
  555. xmlutil2 = new XmlOperateUtil(strPath2);
  556. //首页
  557. m_mbszclass.M_SY.str_tb_ZBT = xmlutil2.Read("M_SY", "str_tb_ZBT");
  558. m_mbszclass.M_SY.str_tb_FBT = xmlutil2.Read("M_SY", "str_tb_FBT");
  559. m_mbszclass.M_SY.str_tb_YPBH = xmlutil2.Read("M_SY", "str_tb_YPBH");
  560. m_mbszclass.M_SY.str_tb_CKBZ = xmlutil2.Read("M_SY", "str_tb_CKBZ");
  561. m_mbszclass.M_SY.str_bz = xmlutil2.Read("M_SY", "str_bz");
  562. m_mbszclass.M_SY.b_ck_ypsm = Convert.ToBoolean(xmlutil2.Read("M_SY", "b_ck_ypsm"));
  563. m_mbszclass.M_SY.b_ck_jggk = Convert.ToBoolean(xmlutil2.Read("M_SY", "b_ck_jggk"));
  564. m_mbszclass.M_SY.str_xzkl= xmlutil2.Read("M_SY", "str_xzkl");
  565. m_mbszclass.M_SY.int_xzkl = Convert.ToInt32(xmlutil2.Read("M_SY", "int_xzkl"));
  566. //页眉页脚
  567. m_mbszclass.M_YMYJ.str_tb_ymwb = xmlutil2.Read("M_YMYJ", "str_tb_ymwb");
  568. m_mbszclass.M_YMYJ.str_tb_KHH = xmlutil2.Read("M_YMYJ", "str_tb_KHH");
  569. m_mbszclass.M_YMYJ.b_ck_ym = Convert.ToBoolean(xmlutil2.Read("M_YMYJ", "b_ck_ym"));
  570. m_mbszclass.M_YMYJ.str_tb_yjwb = xmlutil2.Read("M_YMYJ", "str_tb_yjwb");
  571. //颗粒分析结果
  572. m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_ck_klcc_xsmk"));//是否显示模块
  573. m_mbszclass.M_KLFXJG.b_ck_klcc_xsddt = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_ck_klcc_xsddt"));
  574. m_mbszclass.M_KLFXJG.index_cb_klcc_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_jsfs"));//计算方式
  575. m_mbszclass.M_KLFXJG.str_cb_klcc_jsfs = Convert.ToString(xmlutil2.Read("M_KLFXJG", "str_cb_klcc_jsfs"));//计算方式
  576. m_mbszclass.M_KLFXJG.index_cb_klcc_ljb = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_ljb"));//粒级表
  577. m_mbszclass.M_KLFXJG.index_cb_klcc_klfw = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_klcc_klfw"));//颗粒范围
  578. m_mbszclass.M_KLFXJG.b_cb_jzwfl_xsmk = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_cb_jzwfl_xsmk"));//是否显示该模块
  579. m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_xstx"));//选择图像
  580. m_mbszclass.M_KLFXJG.index_cb_jzwfl_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_jsfs"));//计算方式
  581. m_mbszclass.M_KLFXJG.index_cb_jzwfl_ljb = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_ljb"));//粒级表
  582. m_mbszclass.M_KLFXJG.index_cb_jzwfl_klfw = Convert.ToInt32(xmlutil2.Read("M_KLFXJG", "index_cb_jzwfl_klfw"));//颗粒范围
  583. m_mbszclass.M_KLFXJG.b_ck_klcc_dfl = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_ck_klcc_dfl"));//大分类是否显示
  584. m_mbszclass.M_KLFXJG.b_ck_klcc_xfl = Convert.ToBoolean(xmlutil2.Read("M_KLFXJG", "b_ck_klcc_xfl"));//小分类是否显示
  585. //元素分析结果
  586. m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk = Convert.ToBoolean(xmlutil2.Read("M_YSFXJG", "b_ck_ysfx_xsmk")); //是否显示模块
  587. m_mbszclass.M_YSFXJG.index_cb_yxfx_jsfs = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yxfx_jsfs")); //计算方式
  588. m_mbszclass.M_YSFXJG.index_cb_ysfx_klfw = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_ysfx_klfw")); //颗粒范围
  589. m_mbszclass.M_YSFXJG.str_tb_ysfx_xsys = xmlutil2.Read("M_YSFXJG", "str_tb_ysfx_xsys"); //显示元素
  590. m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Clear();
  591. for (int i = 0; i < 100; i++) //取得所有元素列表
  592. {
  593. string str = xmlutil2.Read("M_YSFXJG", "list_str_tb_ysfx_xsys", "YS" + i.ToString());
  594. if (str == null)
  595. {
  596. break;
  597. }
  598. else
  599. {
  600. m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Add(str);
  601. }
  602. }
  603. m_mbszclass.M_YSFXJG.b_ck_yscf_xsmk = Convert.ToBoolean(xmlutil2.Read("M_YSFXJG", "b_ck_yscf_xsmk")); //是否显示模块
  604. m_mbszclass.M_YSFXJG.index_cb_yscf_xstx = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_xstx")); //显示图形
  605. m_mbszclass.M_YSFXJG.index_cb_yscf_jsfs = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_jsfs")); //计算方式
  606. m_mbszclass.M_YSFXJG.index_cb_yscf_klfw = Convert.ToInt32(xmlutil2.Read("M_YSFXJG", "index_cb_yscf_klfw")); //颗粒范围
  607. m_mbszclass.M_YSFXJG.str_tb_yscf_ysxx = xmlutil2.Read("M_YSFXJG", "str_tb_yscf_ysxx"); //显示元素
  608. m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Clear();
  609. for (int i = 0; i < 100; i++) //取得所有元素列表
  610. {
  611. string str = xmlutil2.Read("M_YSFXJG", "list_str_tb_yscf_ysxx", "YS" + i.ToString());
  612. if (str == null)
  613. {
  614. break;
  615. }
  616. else
  617. {
  618. m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Add(str);
  619. }
  620. }
  621. //三元相图
  622. m_mbszclass.M_SYXT.b_ck_syxt_xsmk = Convert.ToBoolean(xmlutil2.Read("M_SYXT", "b_ck_syxt_xsmk")); //是否显示模块
  623. m_mbszclass.M_SYXT.index_cb_syxt_jsfs = Convert.ToInt32(xmlutil2.Read("M_SYXT", "index_cb_syxt_jsfs")); //计算方式
  624. m_mbszclass.M_SYXT.index_cb_syxt_klfw = Convert.ToInt32(xmlutil2.Read("M_SYXT", "index_cb_syxt_klfw")); //颗粒范围
  625. m_mbszclass.M_SYXT.str_cb_syxt_mhxssl = xmlutil2.Read("M_SYXT", "str_cb_syxt_mhxssl"); //每行显示数量
  626. m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Clear();
  627. for (int i = 0; i < 100; i++) //取得所有模板列表
  628. {
  629. string str = xmlutil2.Read("M_SYXT", "list_lbv_syxt_mblb", "MB" + i.ToString());
  630. if (str == null)
  631. {
  632. break;
  633. }
  634. else
  635. {
  636. m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Add(str);
  637. }
  638. }
  639. m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Clear();
  640. for (int i = 0; i < 100; i++) //取得所有模板列表 索引
  641. {
  642. string str = xmlutil2.Read("M_SYXT", "list_lbv_syxt_mblb_index", "MBIndex" + i.ToString());
  643. if (str == null)
  644. {
  645. break;
  646. }
  647. else
  648. {
  649. m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Add(Convert.ToInt32(str));
  650. }
  651. }
  652. //颗粒列表信息
  653. m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_xsmk")); //是否显示模块
  654. m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_fjzt")); //是否显示帧图模块
  655. m_mbszclass.M_KLLBXX.index_cb_kllb_jsfs = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_jsfs")); //计算方式
  656. m_mbszclass.M_KLLBXX.index_cb_kllb_klfw = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_klfw")); //颗粒范围
  657. m_mbszclass.M_KLLBXX.int_tb_kllb_ylsx = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "int_tb_kllb_ylsx")); //数量上限
  658. m_mbszclass.M_KLLBXX.str_tb_kllb_sxys = xmlutil2.Read("M_KLLBXX", "str_tb_kllb_sxys"); //显示元素
  659. m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Clear();
  660. for (int i = 0; i < 100; i++) //取得所有元素列表
  661. {
  662. string str = xmlutil2.Read("M_KLLBXX", "list_str_tb_lllb_sxys", "YS" + i.ToString());
  663. if (str == null)
  664. {
  665. break;
  666. }
  667. else
  668. {
  669. m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Add(str);
  670. }
  671. }
  672. m_mbszclass.M_KLLBXX.b_ck_kllb_ystx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_ystx")); //原始图像
  673. m_mbszclass.M_KLLBXX.b_ck_kllb_fdtx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_fdtx")); //放大图像
  674. m_mbszclass.M_KLLBXX.b_ck_kllb_npxx = Convert.ToBoolean(xmlutil2.Read("M_KLLBXX", "b_ck_kllb_npxx")); //能谱图像
  675. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p1 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p1"));//颗粒列表列中第一个可选参数
  676. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p1 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p1"));
  677. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p2 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p2"));//颗粒列表中第二个可选参数
  678. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p2 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p2"));
  679. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p3 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_sort_p3"));//颗粒列表中第三个可选参数
  680. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p3 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_sort_p3"));
  681. m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p1 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p1"));//帧图表列中第一个可选参数
  682. m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p1 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p1"));
  683. m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p2 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p2"));//帧图表列中第二个可选参数
  684. m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p2 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p2"));
  685. //m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p3 = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_cb_kllb_chartSort_p3"));//帧图表列中第三个可选参数
  686. //m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p3 = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "index_cb_kllb_chartSort_p3"));
  687. m_mbszclass.M_KLLBXX.str_kllb_qcys = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_kllb_qcys"));
  688. m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Clear();
  689. for (int i = 0; i < 100; i++) //取得所有元素列表
  690. {
  691. string str = xmlutil2.Read("M_KLLBXX", "list_str_kllb_qcys", "YS" + i.ToString());
  692. if (str == null)
  693. {
  694. break;
  695. }
  696. else
  697. {
  698. m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Add(str);
  699. }
  700. }
  701. m_mbszclass.M_KLLBXX.str_kllb_DeleteClass = Convert.ToString(xmlutil2.Read("M_KLLBXX", "str_kllb_DeleteClass"));
  702. m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Clear();
  703. for (int i = 0; i < 100; i++) //取得所有元素列表
  704. {
  705. string str = xmlutil2.Read("M_KLLBXX", "list_str_kllb_DeleteClass", "YS" + i.ToString());
  706. if (str == null)
  707. {
  708. break;
  709. }
  710. else
  711. {
  712. m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Add(str);
  713. }
  714. }
  715. //夹杂物占比
  716. m_mbszclass.M_JZWZB.b_ck_surface = Convert.ToBoolean(xmlutil2.Read("M_JZWZB", "b_ck_surface"));//夹杂物占比表
  717. m_mbszclass.M_JZWZB.b_ck_chart= Convert.ToBoolean(xmlutil2.Read("M_JZWZB", "b_ck_chart"));//夹杂物占比图
  718. m_mbszclass.M_KLLBXX.list_int_kllb_number = Convert.ToInt32(xmlutil2.Read("M_KLLBXX", "list_int_kllb_number"));//保存显示颗粒数量
  719. }
  720. /// <summary>
  721. /// 从配置文件中读取报告模板路径
  722. /// </summary>
  723. private void LoadMBSZClass()
  724. {
  725. //文件路径
  726. m_mbszclass.M_DZ.route = xmlutil.Read("M_address", "Path");
  727. if (m_mbszclass.M_DZ.route == "")
  728. {
  729. tb_mblj.Text = strPath;
  730. m_mbszclass.M_DZ.route = strPath;
  731. }
  732. else
  733. if (File.Exists(m_mbszclass.M_DZ.route))
  734. {
  735. tb_mblj.Text = m_mbszclass.M_DZ.route;
  736. }
  737. else
  738. {
  739. tb_mblj.Text = strPath;
  740. m_mbszclass.M_DZ.route = strPath;
  741. }
  742. }
  743. /// <summary>
  744. /// 将报告模板信息保存到配置文件中
  745. /// </summary>
  746. private void SaveMBSClass()
  747. {
  748. //文件路径
  749. xmlutil.Write(m_mbszclass.M_DZ.route.ToString(), "M_address", "Path");
  750. }
  751. /// <summary>
  752. /// 传入,3个层级的xml结点标识,进行删除结点
  753. /// </summary>
  754. /// <param name="strnode_mk"></param>
  755. /// <param name="strnode_kj"></param>
  756. /// <param name="strnode_xh"></param>
  757. private void RemoveMBSZClassNode(string strnode_mk, string strnode_kj, string strnode_xh, int int_start)
  758. {
  759. for (int i = int_start; i < 1000; i++)
  760. {
  761. string strxh = i.ToString();
  762. if (null != xmlutil.Read(strnode_mk, strnode_kj, strnode_xh + strxh))
  763. {
  764. //删除该节点
  765. xmlutil.RemoveNode(strnode_mk, strnode_kj, strnode_xh + strxh);
  766. }
  767. else
  768. {
  769. break;
  770. }
  771. }
  772. }
  773. /// <summary>
  774. /// 加载报告模板选择项,数据源选项
  775. /// </summary>
  776. private void BindComboBox()
  777. {
  778. //加载数据源
  779. for (int i = 0; i < m_ReportApp.m_rstDataMgr.ResultFilesList.Count; i++)
  780. {
  781. cbo_sjy.Items.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
  782. }
  783. if (cbo_sjy.Items.Count > 0)
  784. cbo_sjy.SelectedIndex = 0;
  785. }
  786. private void OTSReport_Export_Load(object sender, EventArgs e)
  787. {
  788. //先获取D盘,如果没有,则再获取C盘
  789. string str_drivename = GetSecondDriveName();
  790. if (str_drivename == "")
  791. str_drivename = GetFirstDriveName();
  792. //初始化临时文件位置
  793. m_str_tmpbitmappath = str_drivename + "1.bmp";
  794. m_str_tmpbitmappath2 = str_drivename + "2.bmp";
  795. m_str_tmpdocxpath = str_drivename + "1.doc";
  796. //窗体加载时,初始化Combobox
  797. BindComboBox();
  798. //设置界面线程
  799. backgroundWorker2.WorkerReportsProgress = true;
  800. backgroundWorker2.WorkerSupportsCancellation = true;
  801. //确定报表进程db数据库的路径
  802. string strdbname = "ReportTemplateDB.db";
  803. m_strDBpath = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath;
  804. m_strDBpathGB = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath;
  805. m_strDBpath = m_strDBpath + "\\" + strdbname;
  806. m_strDBpathGB = m_strDBpathGB + "\\" + "ReportGBDB.db";
  807. string strdbparticlelistname = "ReportTemplateDBParticleList.db";
  808. m_strDBpath_ParticleList = m_ReportApp.m_rstDataMgr.ResultFilesList[cbo_sjy.SelectedIndex].FilePath;
  809. m_strDBpath_ParticleList = m_strDBpath_ParticleList + "\\" + strdbparticlelistname;
  810. }
  811. #endregion
  812. #region 自定义方法
  813. /// <summary>
  814. /// 传入完整的路径及文件名,和需要的扩展名,返回文件加上需要的扩展名
  815. /// </summary>
  816. /// <param name="in_str"></param>
  817. /// <param name="in_extename"></param>
  818. /// <returns></returns>
  819. public string GetFileExteName(string in_str, string in_extename)
  820. {
  821. string ret_str = in_str.Substring(0, in_str.IndexOf('.'));
  822. ret_str = ret_str + in_extename;
  823. return ret_str;
  824. }
  825. /// <summary>
  826. /// 获取第一个磁盘盘符的名称
  827. /// </summary>
  828. /// <returns></returns>
  829. public string GetFirstDriveName()
  830. {
  831. System.IO.DriveInfo[] ls_driveinfo = System.IO.DriveInfo.GetDrives();
  832. if (ls_driveinfo.Count() > 0)
  833. return ls_driveinfo[0].Name;
  834. return "";
  835. }
  836. /// <summary>
  837. /// 获取第二个磁盘盘符的名称,因为有时c盘不会给予读写的权限,所以要用到这个
  838. /// </summary>
  839. /// <returns></returns>
  840. private string GetSecondDriveName()
  841. {
  842. System.IO.DriveInfo[] ls_driveinfo = System.IO.DriveInfo.GetDrives();
  843. if (ls_driveinfo.Count() > 1)
  844. return ls_driveinfo[1].Name;
  845. return "";
  846. }
  847. /// <summary>
  848. /// 将文本追加到RictBox的尾部上
  849. /// </summary>
  850. public void WriteRictBox(string in_str)
  851. {
  852. //追加到rictbox尾部
  853. richTextBox1.AppendText("[" + DateTime.Now.Hour.ToString() + ":"
  854. + DateTime.Now.Minute.ToString() + ":"
  855. + DateTime.Now.Second.ToString() + "]"
  856. + in_str + Environment.NewLine);
  857. richTextBox1.SelectionColor = GetRandomColor30(30);
  858. richTextBox1.ScrollToCaret();
  859. }
  860. /// <summary>
  861. /// 重载输出文本,带有可以指定颜色
  862. /// </summary>
  863. /// <param name="in_str"></param>
  864. /// <param name="in_c"></param>
  865. public void WriteRictBox(string in_str, Color in_c)
  866. {
  867. //追加到rictbox尾部
  868. richTextBox1.AppendText("[" + DateTime.Now.Hour.ToString() + ":"
  869. + DateTime.Now.Minute.ToString() + ":"
  870. + DateTime.Now.Second.ToString() + "]"
  871. + in_str + Environment.NewLine);
  872. richTextBox1.SelectionColor = in_c;
  873. richTextBox1.ScrollToCaret();
  874. }
  875. /// <summary>
  876. /// 根据传入的颜色,及传入Size的大小,返回一个该色的bitmap对象
  877. /// </summary>
  878. /// <param name="in_c"></param>
  879. /// <returns></returns>
  880. public Bitmap GetBitmapByColor(Color in_c, Size in_z)
  881. {
  882. Bitmap bmp = new Bitmap(in_z.Width, in_z.Height); //这里给104是为了左边和右边空出2个像素,剩余的100就是百分比的值
  883. Graphics g = Graphics.FromImage(bmp);
  884. g.Clear(Color.White);
  885. SolidBrush drawBrush = new SolidBrush(Color.Black);
  886. g.FillRectangle(new SolidBrush(in_c), 0, 0, in_z.Width, in_z.Height);
  887. return bmp;
  888. }
  889. /// <summary>
  890. /// [颜色:16进制转成RGB]
  891. /// </summary>
  892. /// <param name="strColor">设置16进制颜色 [返回RGB]</param>
  893. /// <returns></returns>
  894. public System.Drawing.Color colorHx16toRGB(string strHxColor)
  895. {
  896. try
  897. {
  898. if (strHxColor.Length == 0)
  899. {//如果为空
  900. return System.Drawing.Color.FromArgb(0, 0, 0);//设为黑色
  901. }
  902. else
  903. {//转换颜色
  904. if (strHxColor.IndexOf('#') > -1)
  905. {
  906. //如果颜色格式是 #0000FF 格式的
  907. 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));
  908. }
  909. else
  910. {
  911. //如果颜色格式是 0000FF 格式的
  912. 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));
  913. }
  914. }
  915. }
  916. catch
  917. {//设为黑色
  918. return System.Drawing.Color.FromArgb(0, 0, 0);
  919. }
  920. }
  921. /// <summary>
  922. /// [颜色:RGB转成16进制]专为输出Excel表头格式而定制,其它地方不要使用该方法,或修改返回加#号,例#000000FF
  923. /// </summary>
  924. /// <param name="R">红 int</param>
  925. /// <param name="G">绿 int</param>
  926. /// <param name="B">蓝 int</param>
  927. /// <returns></returns>
  928. public string colorRGBtoHx16ForExcel(Color color)
  929. {
  930. if (color.IsEmpty)
  931. return "000000";
  932. return String.Format("{0:X2}{1:X2}{2:X2}", color.R, color.G, color.B);
  933. }
  934. /// <summary>
  935. /// 将RGB颜色转成整数
  936. /// </summary>
  937. /// <param name="color"></param>
  938. /// <returns></returns>
  939. public int ParseRGB(Color color)
  940. {
  941. return (int)(((int)color.B << 16) | (ushort)(((ushort)color.G << 8) | color.R));
  942. }
  943. /// <summary>
  944. /// 从指定的几种颜色中进行随机颜色,传入30个颜色的范围,越大颜色越多
  945. /// </summary>
  946. /// <returns></returns>
  947. public Color GetRandomColor30(int i_randomrange)
  948. {
  949. Random r = new Random();
  950. int n = r.Next(0, i_randomrange);
  951. Color ret_color;
  952. switch (n)
  953. {
  954. case 1:
  955. ret_color = Color.Aqua;
  956. break;
  957. case 2:
  958. ret_color = Color.Black;
  959. break;
  960. case 3:
  961. ret_color = Color.Blue;
  962. break;
  963. case 4:
  964. ret_color = Color.BlueViolet;
  965. break;
  966. case 5:
  967. ret_color = Color.Brown;
  968. break;
  969. case 6:
  970. ret_color = Color.BurlyWood;
  971. break;
  972. case 7:
  973. ret_color = Color.CadetBlue;
  974. break;
  975. case 8:
  976. ret_color = Color.CadetBlue;
  977. break;
  978. case 9:
  979. ret_color = Color.CornflowerBlue;
  980. break;
  981. case 10:
  982. ret_color = Color.DarkBlue;
  983. break;
  984. case 11:
  985. ret_color = Color.Gray;
  986. break;
  987. case 12:
  988. ret_color = Color.Indigo;
  989. break;
  990. case 13:
  991. ret_color = Color.LightSlateGray;
  992. break;
  993. case 14:
  994. ret_color = Color.Magenta;
  995. break;
  996. case 15:
  997. ret_color = Color.Maroon;
  998. break;
  999. case 16:
  1000. ret_color = Color.MediumBlue;
  1001. break;
  1002. case 17:
  1003. ret_color = Color.MediumOrchid;
  1004. break;
  1005. case 18:
  1006. ret_color = Color.MidnightBlue;
  1007. break;
  1008. case 19:
  1009. ret_color = Color.Navy;
  1010. break;
  1011. case 20:
  1012. ret_color = Color.Olive;
  1013. break;
  1014. case 21:
  1015. ret_color = Color.PaleVioletRed;
  1016. break;
  1017. case 22:
  1018. ret_color = Color.Peru;
  1019. break;
  1020. case 23:
  1021. ret_color = Color.Purple;
  1022. break;
  1023. case 24:
  1024. ret_color = Color.Red;
  1025. break;
  1026. case 25:
  1027. ret_color = Color.RosyBrown;
  1028. break;
  1029. case 26:
  1030. ret_color = Color.RoyalBlue;
  1031. break;
  1032. case 27:
  1033. ret_color = Color.SaddleBrown;
  1034. break;
  1035. case 28:
  1036. ret_color = Color.SeaGreen;
  1037. break;
  1038. case 29:
  1039. ret_color = Color.Teal;
  1040. break;
  1041. case 30:
  1042. ret_color = Color.Tomato;
  1043. break;
  1044. case 31:
  1045. ret_color = Color.YellowGreen;
  1046. break;
  1047. default:
  1048. ret_color = Color.Black;
  1049. break;
  1050. }
  1051. return ret_color;
  1052. }
  1053. /// <summary>
  1054. /// 打开报表模板进程
  1055. /// </summary>
  1056. private void OpenOTSINcAreportTemplateAPP()
  1057. {
  1058. ReportPrintTool tool = new ReportPrintTool(DEVReport);
  1059. tool.ShowPreview();
  1060. }
  1061. /// <summary>
  1062. /// 打开报表模板进程,颗粒列表
  1063. /// </summary>
  1064. public void OpenOTSINcAreportTemplateAPP_ParticleList(string arg4)
  1065. {
  1066. //----------------------------------
  1067. //共传4个参数
  1068. //参数1:是需要打开db数据库的路径
  1069. //参数2:是打开报表模板xml文件的路径
  1070. //参数3:是要执行查看报表的类型,输出主报表,还是输出颗粒列表
  1071. //参数4:打开主报表时是是指定夹杂物的数量,打开颗粒列表时,是颗粒列表显示的范围如,0-50,50-100
  1072. //参数5:是要执行查看报表的类型,输出主报表时,指定读取的标记帧图图像范围,如0-50,50-100,输出颗粒列表时无用
  1073. //----------------------------------
  1074. ProcessStartInfo process = new ProcessStartInfo();
  1075. process.FileName = "ReportTemplateExe\\OTSIncAReportTemplate.exe";//打开app的路径
  1076. string arg1 = m_strDBpath_ParticleList.Replace(" ", "^");//参数1,是需要打开db数据库的路径
  1077. string arg2 = tb_mblj.Text.Trim().Replace(" ", "^");//参数2,是模板文件的路径
  1078. string arg3 = "ParticleListReport";//颗粒列表
  1079. //string arg4 = "";//夹杂物数量,从多少到多少
  1080. string arg5 = "0";//在打开颗粒列表时,传的标记帧图图像数量参数暂不用
  1081. process.Arguments = string.Format("{0} {1} {2} {3} {4}", arg1, arg2, arg3, arg4, arg5); //多个参数用空格隔开
  1082. process.WindowStyle = ProcessWindowStyle.Normal;
  1083. Process.Start(process);
  1084. }
  1085. #endregion
  1086. #region 窗体控件事件
  1087. private void OTSReport_Export_FormClosing(object sender, FormClosingEventArgs e)
  1088. {
  1089. if (backgroundWorker2.IsBusy == true)
  1090. {
  1091. //导出线程正在工作中,不让退出该界面
  1092. MessageBox.Show(table["messagebox1"].ToString(), table["messagebox2"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information);
  1093. //然后取消关闭窗体的事件
  1094. e.Cancel = true;
  1095. }
  1096. }
  1097. private void btn_preview_Click(object sender, EventArgs e)
  1098. {
  1099. DEVReport = new OTS_DEVReport(this, m_mbszclass);
  1100. //DEVReport.Dispose();
  1101. m_ReportApp.m_rstDataMgr.setSelectedIndex(cbo_sjy.SelectedIndex);
  1102. //重新导出报表数据
  1103. m_ReportApp.m_ChartsWindow.Activate();
  1104. WriteRictBox(table["rictbox1"].ToString());
  1105. progressBar1.Value = 0;
  1106. //预览
  1107. if (backgroundWorker2.IsBusy != true)
  1108. {
  1109. // 启动异步操作
  1110. backgroundWorker2.RunWorkerAsync();
  1111. }
  1112. }
  1113. private void button3_Click(object sender, EventArgs e)
  1114. {
  1115. if (File.Exists(tb_lj.Text.Trim()))
  1116. {
  1117. //打开刚才导出的文件
  1118. System.Diagnostics.Process.Start(tb_lj.Text.Trim());
  1119. }
  1120. else
  1121. {
  1122. WriteRictBox(table["rictbox2"].ToString() + tb_lj.Text.Trim() + table["rictbox3"].ToString());
  1123. }
  1124. }
  1125. private void button2_Click(object sender, EventArgs e)
  1126. {
  1127. //退出
  1128. this.Close();
  1129. }
  1130. private void btn_openfilepath_Click(object sender, EventArgs e)
  1131. {
  1132. LoadControlsToXml();
  1133. SaveMBSClass();
  1134. }
  1135. private void btn_selectPath_Click(object sender, EventArgs e)
  1136. {
  1137. //选择保存文件路径对话框
  1138. SaveFileDialog saveFileDialog1 = new SaveFileDialog();
  1139. //获取默认操作的数据源名,用来当做保存的文件名
  1140. saveFileDialog1.FileName = m_ReportApp.m_rstDataMgr.GetSampleName();
  1141. saveFileDialog1.Filter = "Excel (*.xls)|*.xls|Word (*.doc)|*.doc|PDF (*.pdf)|*.pdf";
  1142. saveFileDialog1.FilterIndex = 1;
  1143. saveFileDialog1.RestoreDirectory = true;
  1144. if (saveFileDialog1.ShowDialog() == DialogResult.OK)
  1145. {
  1146. if (saveFileDialog1.FilterIndex == 1)
  1147. {
  1148. //选择输出Excel
  1149. m_export_type = "Excel";
  1150. }
  1151. if (saveFileDialog1.FilterIndex == 2)
  1152. {
  1153. //选择输出Word
  1154. m_export_type = "Word";
  1155. }
  1156. if (saveFileDialog1.FilterIndex == 3)
  1157. {
  1158. //选择输出PDF
  1159. m_export_type = "PDF";
  1160. }
  1161. tb_lj.Text = saveFileDialog1.FileName;
  1162. }
  1163. }
  1164. //调用编辑模板窗体
  1165. private void btn_TempDes_Click(object sender, EventArgs e)
  1166. {
  1167. //预览设置
  1168. OTSReport_TemplateDesignerRM OtsTemDRM = new OTSReport_TemplateDesignerRM(this);
  1169. if (OtsTemDRM.ShowDialog() == DialogResult.Yes)
  1170. {
  1171. //如果用户点击确定,则将m_mbszclass,模板设置类的内容存到文件中。
  1172. // m_mbszclass.M_DZ.route = tb_mblj.Text;
  1173. m_mbszclass.M_DZ.route = tb_mblj.Text;
  1174. SaveMBSClass();
  1175. }
  1176. }
  1177. #endregion
  1178. #region 导出工作线程部份
  1179. private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
  1180. {
  1181. BackgroundWorker worker = sender as BackgroundWorker;
  1182. //主任务的实现
  1183. #region //获取模板设置的导出的内容-------------------------------------------------
  1184. //获取报告模板设置内容
  1185. worker.ReportProgress(0, table["rictbox4"].ToString());//已获取模板中设置内容为:
  1186. System.Threading.Thread.Sleep(1);
  1187. //更新进度
  1188. worker.ReportProgress(5);
  1189. #endregion //设置模板导出内容结束--------------------------------------------------------
  1190. int processvalue = 12;//各功能模块从进度条为15时开始依次调用
  1191. #region //依次循环调用各功能模块-------------------------------------------------------------
  1192. int i_zz = 0;//增值
  1193. i_zz = 80 / 9;
  1194. //首先将测量结果信息表导出,在表头------------------------------------------------
  1195. worker.ReportProgress(0, table["result_information_ing"].ToString());//加载测量结果信息表模块中....
  1196. worker.ReportProgress(0, table["load_result_information"].ToString());//加载:测量结果信息表
  1197. //更新进度条
  1198. processvalue = processvalue + 1;
  1199. worker.ReportProgress(processvalue);
  1200. lock (m_thread_flag)
  1201. m_thread_flag = table["rictbox7"].ToString();//等待
  1202. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1203. {
  1204. System.Threading.Thread.Sleep(500);
  1205. }
  1206. worker.ReportProgress(0, table["loading_result_information_completed"].ToString());//加载测量结果信息表模块完成
  1207. //-------------------------------------------------------------------------
  1208. //调用,颗粒尺寸分析表------------------------------------------------
  1209. worker.ReportProgress(0, table["dimensional_analysis_table_ing"].ToString());//加载颗粒尺寸分析表模块中....
  1210. worker.ReportProgress(0, table["loading_dimension_analysis_table"].ToString());//加载:颗粒尺寸分析表
  1211. //更新进度条
  1212. processvalue = processvalue + i_zz;
  1213. worker.ReportProgress(processvalue);
  1214. lock (m_thread_flag)
  1215. m_thread_flag = table["rictbox7"].ToString();//等待
  1216. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1217. {
  1218. System.Threading.Thread.Sleep(500);
  1219. }
  1220. worker.ReportProgress(0, table["loading_dimension_analysis_table_completed"].ToString());//加载颗粒尺寸分析表模块完成
  1221. //调用,元素分析表---------------------------------------------
  1222. worker.ReportProgress(0, table["element_analysis_table_ing"].ToString());//加载元素分析表模块中....
  1223. worker.ReportProgress(0, table["load_element_analysis_table"].ToString());//加载:元素分析表
  1224. //更新进度条
  1225. processvalue = processvalue + i_zz;
  1226. worker.ReportProgress(processvalue);
  1227. lock (m_thread_flag)
  1228. m_thread_flag = table["rictbox7"].ToString();//等待
  1229. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1230. {
  1231. System.Threading.Thread.Sleep(500);
  1232. }
  1233. worker.ReportProgress(0, table["loading_element_analysis_table_completed"].ToString());//加载元素分析表模块完成
  1234. //调用,夹杂物面积比表---------------------------------------------
  1235. worker.ReportProgress(0, table["inca_area_ratio_table_ing"].ToString());//加载夹杂物面积比表模块中....
  1236. worker.ReportProgress(0, table["load_inca_area_ratio_table"].ToString());//加载:夹杂物面积比表
  1237. //更新进度条
  1238. processvalue = processvalue + i_zz;
  1239. worker.ReportProgress(processvalue);
  1240. lock (m_thread_flag)
  1241. m_thread_flag = table["rictbox7"].ToString();//等待
  1242. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1243. {
  1244. System.Threading.Thread.Sleep(500);
  1245. }
  1246. worker.ReportProgress(0, table["loading_inca_area_ratio_table_completed"].ToString());//加载夹杂物面积比表模块完成
  1247. //调用,夹杂物面积比图---------------------------------------------
  1248. worker.ReportProgress(0, table["inca_area_ratio_diagram_ing"].ToString());//加载夹杂物面积比图模块中....
  1249. worker.ReportProgress(0, table["load_inca_area_ratio_diagram"].ToString());//加载:夹杂物面积比图
  1250. //更新进度条
  1251. processvalue = processvalue + i_zz;
  1252. worker.ReportProgress(processvalue);
  1253. lock (m_thread_flag)
  1254. m_thread_flag = table["rictbox7"].ToString();//等待
  1255. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1256. {
  1257. System.Threading.Thread.Sleep(500);
  1258. }
  1259. worker.ReportProgress(0, table["loading_inca_area_ratio_diagram_completed"].ToString());//加载夹杂物面积比图模块完成
  1260. //System.Threading.Thread.Sleep(2000);
  1261. //调用,三元相图----------------------------------------------
  1262. worker.ReportProgress(0, table["ternary_graph_ing"].ToString());//加载三元相图模块中....
  1263. worker.ReportProgress(0, table["load_ternary_graph"].ToString());//加载:三元相图
  1264. //更新进度条
  1265. processvalue = processvalue + i_zz;
  1266. worker.ReportProgress(processvalue);
  1267. lock (m_thread_flag)
  1268. m_thread_flag = table["rictbox7"].ToString();//等待
  1269. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1270. {
  1271. System.Threading.Thread.Sleep(500);
  1272. }
  1273. worker.ReportProgress(0, table["loading_ternary_graph_completed"].ToString());//加载三元相图模块完成
  1274. //调用输出,颗粒列表----------------------------------------
  1275. worker.ReportProgress(0, table["particle_list_ing"].ToString());//加载颗粒列表模块中....
  1276. worker.ReportProgress(0, table["load_particle_list"].ToString());//加载:颗粒列表
  1277. //更新进度条
  1278. processvalue = processvalue + i_zz;
  1279. worker.ReportProgress(processvalue);
  1280. lock (m_thread_flag)
  1281. m_thread_flag = table["rictbox7"].ToString();//等待
  1282. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1283. {
  1284. System.Threading.Thread.Sleep(500);
  1285. }
  1286. worker.ReportProgress(0, table["loading_particle_list_completed"].ToString());//加载颗粒列表模块完成
  1287. //调用输出,颗粒列表帧图----------------------------------------
  1288. worker.ReportProgress(0, table["particle_list_frame_diagram_ing"].ToString());//加载颗粒列表帧图模块中....
  1289. worker.ReportProgress(0, table["load_particle_list_frame_diagram"].ToString());//加载:颗粒列表帧图
  1290. //更新进度条
  1291. processvalue = processvalue + i_zz;
  1292. worker.ReportProgress(processvalue);
  1293. lock (m_thread_flag)
  1294. m_thread_flag = table["rictbox7"].ToString();//等待
  1295. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1296. {
  1297. System.Threading.Thread.Sleep(500);
  1298. }
  1299. worker.ReportProgress(0, table["loading_particle_list_frame_diagram_completed"].ToString());//加载颗粒列表帧图模块完成
  1300. //生成,模板临时数据库文件----------------------------------------------
  1301. worker.ReportProgress(0, table["rictbox35"].ToString());//生成模板临时数据库文件....
  1302. worker.ReportProgress(0, table["rictbox36"].ToString());//加载:生成模板临时数据库文件
  1303. //更新进度条
  1304. processvalue = processvalue + i_zz;
  1305. worker.ReportProgress(processvalue);
  1306. lock (m_thread_flag)
  1307. m_thread_flag = table["rictbox7"].ToString();//等待
  1308. while (m_thread_flag == table["rictbox7"].ToString())//等待
  1309. {
  1310. System.Threading.Thread.Sleep(500);
  1311. }
  1312. worker.ReportProgress(0, table["rictbox37"].ToString());//模板临时数据库文件完成
  1313. #endregion 依将循环调用各功能模块结束-------------------------------------------------------
  1314. }
  1315. private string AnalyticGraphics(int a_Indexes)
  1316. {
  1317. if (a_Indexes == 0)
  1318. return "pie";//饼图
  1319. else if (a_Indexes == 1)
  1320. return "radius";//圈图
  1321. else if (a_Indexes == 2)
  1322. return "bar";//柱状图
  1323. else if (a_Indexes == 3)
  1324. return "line";//线状图
  1325. else return "stack";//堆叠图
  1326. }
  1327. private void backgroundWorker2_ProgressChanged(object sender, ProgressChangedEventArgs e)
  1328. {
  1329. string strNill = table["rictbox40"].ToString();
  1330. BackgroundWorker worker = sender as BackgroundWorker;
  1331. //更新进度条的进度
  1332. if (e.UserState != null)
  1333. {
  1334. string ls_str = (string)e.UserState;
  1335. WriteRictBox((string)e.UserState);
  1336. string s = AnalyticGraphics(m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx);
  1337. if (ls_str.IndexOf(table["rictbox12"].ToString()) > -1)//加载:
  1338. {
  1339. if (ls_str.IndexOf(table["result_information"].ToString()) > -1)//测量结果信息表
  1340. {
  1341. DEVReport.International_language(dev_internationalLanguage());
  1342. DEVReport.setResultGrid();
  1343. lock (m_thread_flag)
  1344. m_thread_flag = strNill;
  1345. }
  1346. if (ls_str.IndexOf(table["dimensional_analysis_table"].ToString()) > -1)//颗粒尺寸分析表
  1347. {
  1348. if (m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk)
  1349. {
  1350. //DEVReport.setParticleSizeTable(true, false);
  1351. 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);
  1352. }
  1353. //DEVReport.setParticleSizeTable(true,false);
  1354. lock (m_thread_flag)
  1355. m_thread_flag = strNill;
  1356. }
  1357. if (ls_str.IndexOf(table["element_analysis_table"].ToString()) > -1)//元素分析表
  1358. {
  1359. if (m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk)
  1360. {
  1361. DEVReport.XRPageBreak();
  1362. DEVReport.setElementAvgGrid();
  1363. }
  1364. //DEVReport.setElementAvgGrid();
  1365. lock (m_thread_flag)
  1366. m_thread_flag = strNill;
  1367. }
  1368. if (ls_str.IndexOf(table["inca_area_ratio_table"].ToString()) > -1)//夹杂物面积比表
  1369. {
  1370. if (m_mbszclass.M_JZWZB.b_ck_surface)
  1371. {
  1372. DEVReport.XRPageBreak();
  1373. DEVReport.setINCAtable();
  1374. }
  1375. lock (m_thread_flag)
  1376. m_thread_flag = strNill;
  1377. }
  1378. if (ls_str.IndexOf(table["inca_area_ratio_diagram"].ToString()) > -1)//夹杂物面积比图
  1379. {
  1380. if (m_mbszclass.M_JZWZB.b_ck_chart)
  1381. {
  1382. DEVReport.XRPageBreak();
  1383. DEVReport.set_incaPIC_classify();
  1384. DEVReport.set_incaPIC_subdivision();
  1385. }
  1386. lock (m_thread_flag)
  1387. m_thread_flag = strNill;
  1388. }
  1389. if (ls_str.IndexOf(table["ternary_graph"].ToString()) > -1)//三元图
  1390. {
  1391. if (m_mbszclass.M_SYXT.b_ck_syxt_xsmk)
  1392. {
  1393. DEVReport.XRPageBreak();
  1394. DEVReport.InsertReportTemplateChart_Trianglediagram();
  1395. }
  1396. lock (m_thread_flag)
  1397. m_thread_flag = strNill;
  1398. }
  1399. if (ls_str.IndexOf(table["particle_list"].ToString()) > -1)//颗粒列表
  1400. {
  1401. if (m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk)
  1402. {
  1403. DEVReport.XRPageBreak();
  1404. DEVReport.set_kllb_data();
  1405. }
  1406. lock (m_thread_flag)
  1407. m_thread_flag = strNill;
  1408. }
  1409. if (ls_str.IndexOf(table["particle_list_frame_diagram"].ToString()) > -1)//颗粒帧图列表
  1410. {
  1411. if (m_mbszclass.M_KLLBXX.b_ck_kllb_fjzt)
  1412. {
  1413. DEVReport.XRPageBreak();
  1414. DEVReport.set_kllb_data_frame();
  1415. }
  1416. lock (m_thread_flag)
  1417. m_thread_flag = strNill;
  1418. }
  1419. if (ls_str.IndexOf(table["rictbox38"].ToString()) > -1)//生成模板临时数据库文件
  1420. {
  1421. //DEVReport.International_language(dev_internationalLanguage());
  1422. lock (m_thread_flag)
  1423. m_thread_flag = strNill;
  1424. }
  1425. }
  1426. }
  1427. else
  1428. {
  1429. progressBar1.Value = e.ProgressPercentage;
  1430. WriteRictBox(table["rictbox39"].ToString() + e.ProgressPercentage.ToString() + "%");
  1431. }
  1432. }
  1433. private void backgroundWorker2_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
  1434. {
  1435. WriteRictBox(table["rictbox41"].ToString() + m_export_reporttemplate.m_list_dt.Count.ToString() + table["rictbox42"].ToString(), Color.Red);
  1436. //处理结束后,再将button的状态更新回去
  1437. progressBar1.Value = 100;
  1438. WriteRictBox("-----------------"+ table["rictbox43"].ToString() + "--------------------", Color.Red);
  1439. MemoryManagementClass.FlushMemory();
  1440. //导出完成,打开报表
  1441. OpenOTSINcAreportTemplateAPP();
  1442. //m_ReportApp.m_conditionChoose.ShowsTheDefaultPic();
  1443. this.Close();
  1444. }
  1445. #endregion
  1446. #region 读取文件
  1447. private void LoadControlsToXml()
  1448. {
  1449. string path = string.Empty;
  1450. OpenFileDialog Load = new OpenFileDialog();
  1451. Load.Filter = "XML File|*.xml";
  1452. Load.InitialDirectory = @System.Windows.Forms.Application.StartupPath + "\\Config\\ProData";
  1453. if (Load.ShowDialog() == DialogResult.OK)
  1454. path = Load.FileName;//赋值目录
  1455. if (path != string.Empty)
  1456. {
  1457. tb_mblj.Text = path;
  1458. m_mbszclass.M_DZ.route = path;
  1459. OTSIncAReportApp.Controls.XmlOperateUtil xmlutil = new OTSIncAReportApp.Controls.XmlOperateUtil(path);
  1460. //首页
  1461. m_mbszclass.M_SY.str_tb_ZBT = xmlutil.Read("M_SY", "str_tb_ZBT");
  1462. m_mbszclass.M_SY.str_tb_FBT = xmlutil.Read("M_SY", "str_tb_FBT");
  1463. m_mbszclass.M_SY.str_tb_YPBH = xmlutil.Read("M_SY", "str_tb_YPBH");
  1464. m_mbszclass.M_SY.str_tb_CKBZ = xmlutil.Read("M_SY", "str_tb_CKBZ");
  1465. m_mbszclass.M_SY.str_bz = xmlutil.Read("M_SY", "str_bz");
  1466. m_mbszclass.M_SY.b_ck_ypsm = Convert.ToBoolean(xmlutil.Read("M_SY", "b_ck_ypsm"));
  1467. m_mbszclass.M_SY.b_ck_jggk = Convert.ToBoolean(xmlutil.Read("M_SY", "b_ck_jggk"));
  1468. m_mbszclass.M_SY.str_xzkl = xmlutil.Read("M_SY", "str_xzkl");
  1469. m_mbszclass.M_SY.int_xzkl = Convert.ToInt32(xmlutil.Read("M_SY", "int_xzkl"));
  1470. //页眉页脚
  1471. m_mbszclass.M_YMYJ.str_tb_ymwb = xmlutil.Read("M_YMYJ", "str_tb_ymwb");
  1472. m_mbszclass.M_YMYJ.str_tb_KHH = xmlutil.Read("M_YMYJ", "str_tb_KHH");
  1473. m_mbszclass.M_YMYJ.b_ck_ym = Convert.ToBoolean(xmlutil.Read("M_YMYJ", "b_ck_ym"));
  1474. m_mbszclass.M_YMYJ.str_tb_yjwb = xmlutil.Read("M_YMYJ", "str_tb_yjwb");
  1475. //颗粒分析结果
  1476. m_mbszclass.M_KLFXJG.b_ck_klcc_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_xsmk"));//是否显示模块
  1477. m_mbszclass.M_KLFXJG.b_ck_klcc_xsddt = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_ck_klcc_xsddt"));
  1478. m_mbszclass.M_KLFXJG.index_cb_klcc_jsfs = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_jsfs"));//计算方式
  1479. m_mbszclass.M_KLFXJG.index_cb_klcc_ljb = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_ljb"));//粒级表
  1480. m_mbszclass.M_KLFXJG.index_cb_klcc_klfw = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_klcc_klfw"));//颗粒范围
  1481. m_mbszclass.M_KLFXJG.b_cb_jzwfl_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLFXJG", "b_cb_jzwfl_xsmk"));//是否显示该模块
  1482. m_mbszclass.M_KLFXJG.index_cb_jzwfl_xstx = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_xstx"));//选择图像
  1483. m_mbszclass.M_KLFXJG.index_cb_jzwfl_jsfs = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_jsfs"));//计算方式
  1484. m_mbszclass.M_KLFXJG.index_cb_jzwfl_ljb = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_ljb"));//粒级表
  1485. m_mbszclass.M_KLFXJG.index_cb_jzwfl_klfw = Convert.ToInt32(xmlutil.Read("M_KLFXJG", "index_cb_jzwfl_klfw"));//颗粒范围
  1486. //元素分析结果
  1487. m_mbszclass.M_YSFXJG.b_ck_ysfx_xsmk = Convert.ToBoolean(xmlutil.Read("M_YSFXJG", "b_ck_ysfx_xsmk")); //是否显示模块
  1488. m_mbszclass.M_YSFXJG.index_cb_yxfx_jsfs = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yxfx_jsfs")); //计算方式
  1489. m_mbszclass.M_YSFXJG.index_cb_ysfx_klfw = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_ysfx_klfw")); //颗粒范围
  1490. m_mbszclass.M_YSFXJG.str_tb_ysfx_xsys = xmlutil.Read("M_YSFXJG", "str_tb_ysfx_xsys"); //显示元素
  1491. m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Clear();
  1492. for (int i = 0; i < 100; i++) //取得所有元素列表
  1493. {
  1494. string str = xmlutil.Read("M_YSFXJG", "list_str_tb_ysfx_xsys", "YS" + i.ToString());
  1495. if (str == null)
  1496. {
  1497. break;
  1498. }
  1499. else
  1500. {
  1501. m_mbszclass.M_YSFXJG.list_str_tb_ysfx_xsys.Add(str);
  1502. }
  1503. }
  1504. m_mbszclass.M_YSFXJG.b_ck_yscf_xsmk = Convert.ToBoolean(xmlutil.Read("M_YSFXJG", "b_ck_yscf_xsmk")); //是否显示模块
  1505. m_mbszclass.M_YSFXJG.index_cb_yscf_xstx = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_xstx")); //显示图形
  1506. m_mbszclass.M_YSFXJG.index_cb_yscf_jsfs = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_jsfs")); //计算方式
  1507. m_mbszclass.M_YSFXJG.index_cb_yscf_klfw = Convert.ToInt32(xmlutil.Read("M_YSFXJG", "index_cb_yscf_klfw")); //颗粒范围
  1508. m_mbszclass.M_YSFXJG.str_tb_yscf_ysxx = xmlutil.Read("M_YSFXJG", "str_tb_yscf_ysxx"); //显示元素
  1509. m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Clear();
  1510. for (int i = 0; i < 100; i++) //取得所有元素列表
  1511. {
  1512. string str = xmlutil.Read("M_YSFXJG", "list_str_tb_yscf_ysxx", "YS" + i.ToString());
  1513. if (str == null)
  1514. {
  1515. break;
  1516. }
  1517. else
  1518. {
  1519. m_mbszclass.M_YSFXJG.list_str_tb_yscf_ysxx.Add(str);
  1520. }
  1521. }
  1522. //三元相图
  1523. m_mbszclass.M_SYXT.b_ck_syxt_xsmk = Convert.ToBoolean(xmlutil.Read("M_SYXT", "b_ck_syxt_xsmk")); //是否显示模块
  1524. m_mbszclass.M_SYXT.index_cb_syxt_jsfs = Convert.ToInt32(xmlutil.Read("M_SYXT", "index_cb_syxt_jsfs")); //计算方式
  1525. m_mbszclass.M_SYXT.index_cb_syxt_klfw = Convert.ToInt32(xmlutil.Read("M_SYXT", "index_cb_syxt_klfw")); //颗粒范围
  1526. m_mbszclass.M_SYXT.str_cb_syxt_mhxssl = xmlutil.Read("M_SYXT", "str_cb_syxt_mhxssl"); //每行显示数量
  1527. m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Clear();
  1528. for (int i = 0; i < 100; i++) //取得所有模板列表
  1529. {
  1530. string str = xmlutil.Read("M_SYXT", "list_lbv_syxt_mblb", "MB" + i.ToString());
  1531. if (str == null)
  1532. {
  1533. break;
  1534. }
  1535. else
  1536. {
  1537. m_mbszclass.M_SYXT.list_lbv_syxt_mblb.Add(str);
  1538. }
  1539. }
  1540. m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Clear();
  1541. for (int i = 0; i < 100; i++) //取得所有模板列表 索引
  1542. {
  1543. string str = xmlutil.Read("M_SYXT", "list_lbv_syxt_mblb_index", "MBIndex" + i.ToString());
  1544. if (str == null)
  1545. {
  1546. break;
  1547. }
  1548. else
  1549. {
  1550. m_mbszclass.M_SYXT.list_lbv_syxt_mblb_index.Add(Convert.ToInt32(str));
  1551. }
  1552. }
  1553. //颗粒列表信息
  1554. m_mbszclass.M_KLLBXX.b_ck_kllb_xsmk = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_xsmk")); //是否显示模块
  1555. m_mbszclass.M_KLLBXX.index_cb_kllb_jsfs = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_jsfs")); //计算方式
  1556. m_mbszclass.M_KLLBXX.index_cb_kllb_klfw = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_klfw")); //颗粒范围
  1557. m_mbszclass.M_KLLBXX.int_tb_kllb_ylsx = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "int_tb_kllb_ylsx")); //数量上限
  1558. m_mbszclass.M_KLLBXX.str_tb_kllb_sxys = xmlutil.Read("M_KLLBXX", "str_tb_kllb_sxys"); //显示元素
  1559. m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Clear();
  1560. for (int i = 0; i < 100; i++) //取得所有元素列表
  1561. {
  1562. string str = xmlutil.Read("M_KLLBXX", "list_str_tb_lllb_sxys", "YS" + i.ToString());
  1563. if (str == null)
  1564. {
  1565. break;
  1566. }
  1567. else
  1568. {
  1569. m_mbszclass.M_KLLBXX.list_str_tb_lllb_sxys.Add(str);
  1570. }
  1571. }
  1572. m_mbszclass.M_KLLBXX.b_ck_kllb_ystx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_ystx")); //原始图像
  1573. m_mbszclass.M_KLLBXX.b_ck_kllb_fdtx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_fdtx")); //放大图像
  1574. m_mbszclass.M_KLLBXX.b_ck_kllb_npxx = Convert.ToBoolean(xmlutil.Read("M_KLLBXX", "b_ck_kllb_npxx")); //能谱图像
  1575. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p1 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p1"));//颗粒列表列中第一个可选参数
  1576. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p1 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p1"));
  1577. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p2 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p2"));//颗粒列表中第二个可选参数
  1578. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p2 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p2"));
  1579. m_mbszclass.M_KLLBXX.str_cb_kllb_sort_p3 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_sort_p3"));//颗粒列表中第三个可选参数
  1580. m_mbszclass.M_KLLBXX.index_cb_kllb_sort_p3 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_sort_p3"));
  1581. m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p1 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p1"));//帧图表列中第一个可选参数
  1582. m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p1 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p1"));
  1583. m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p2 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p2"));//帧图表列中第二个可选参数
  1584. m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p2 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p2"));
  1585. //m_mbszclass.M_KLLBXX.str_cb_kllb_chartSort_p3 = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_cb_kllb_chartSort_p3"));//帧图表列中第三个可选参数
  1586. //m_mbszclass.M_KLLBXX.index_cb_kllb_chartSort_p3 = Convert.ToInt32(xmlutil.Read("M_KLLBXX", "index_cb_kllb_chartSort_p3"));
  1587. m_mbszclass.M_KLLBXX.list_int_kllb_number= Convert.ToInt32(xmlutil.Read("M_KLLBXX", "list_int_kllb_number"));//保存显示颗粒数量
  1588. m_mbszclass.M_KLLBXX.str_kllb_qcys = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_kllb_qcys"));
  1589. m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Clear();
  1590. for (int i = 0; i < 100; i++) //取得所有元素列表
  1591. {
  1592. string str = xmlutil.Read("M_KLLBXX", "list_str_kllb_qcys", "YS" + i.ToString());
  1593. if (str == null)
  1594. {
  1595. break;
  1596. }
  1597. else
  1598. {
  1599. m_mbszclass.M_KLLBXX.list_str_kllb_qcys.Add(str);
  1600. }
  1601. }
  1602. m_mbszclass.M_KLLBXX.str_kllb_DeleteClass = Convert.ToString(xmlutil.Read("M_KLLBXX", "str_kllb_DeleteClass"));
  1603. m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Clear();
  1604. for (int i = 0; i < 100; i++) //取得所有元素列表
  1605. {
  1606. string str = xmlutil.Read("M_KLLBXX", "list_str_kllb_DeleteClass", "YS" + i.ToString());
  1607. if (str == null)
  1608. {
  1609. break;
  1610. }
  1611. else
  1612. {
  1613. m_mbszclass.M_KLLBXX.list_str_kllb_DeleteClass.Add(str);
  1614. }
  1615. }
  1616. //夹杂物占比
  1617. m_mbszclass.M_JZWZB.b_ck_surface = Convert.ToBoolean(xmlutil.Read("M_JZWZB", "b_ck_surface"));//夹杂物占比表
  1618. m_mbszclass.M_JZWZB.b_ck_chart = Convert.ToBoolean(xmlutil.Read("M_JZWZB", "b_ck_chart"));//夹杂物占比图
  1619. }
  1620. }
  1621. #endregion
  1622. private void button7_Click(object sender, EventArgs e)
  1623. {
  1624. OTSReport_criterion criterion = new OTSReport_criterion(m_export_reporttemplate, GB_Report,this);
  1625. criterion.Sample_order = cbo_sjy.SelectedIndex;
  1626. criterion.Language_dt = dev_internationalLanguage();
  1627. criterion.ShowDialog();
  1628. }
  1629. private void OTSReport_Export_FormClosed(object sender, FormClosedEventArgs e)
  1630. {
  1631. }
  1632. private void button1_Click(object sender, EventArgs e)
  1633. {
  1634. DEVReport = new OTS_DEVReport(this, m_mbszclass);
  1635. //DEVReport.Dispose();
  1636. //DEVReport = new OTS_DEVReport(this);
  1637. DEVReport.setResultGrid();
  1638. DEVReport.setParticleSizeTable(true,true,true);
  1639. DEVReport.setElementAvgGrid();
  1640. DEVReport.setINCAtable();
  1641. DEVReport.set_incaPIC_classify();
  1642. DEVReport.set_incaPIC_subdivision();
  1643. DEVReport.InsertReportTemplateChart_Trianglediagram();
  1644. DEVReport.set_kllb_data();
  1645. DEVReport.set_kllb_data_frame();
  1646. DEVReport.International_language(dev_internationalLanguage());
  1647. ReportPrintTool tool = new ReportPrintTool(DEVReport);
  1648. tool.ShowPreview();
  1649. }
  1650. /// <summary>
  1651. /// 从数据库中读取语言配置信息
  1652. /// </summary>
  1653. /// <returns></returns>
  1654. private DataTable dev_internationalLanguage()
  1655. {
  1656. string Language = "ZH";
  1657. OTSCommon.SqLiteHelper sh = new OTSCommon.SqLiteHelper("data source='" + System.IO.Directory.GetCurrentDirectory() + "\\Config\\ReportTemplate\\language.db'");
  1658. DataTable dt_stl = sh.ExecuteQuery("select * from "+ Language);
  1659. return dt_stl;
  1660. }
  1661. private void button2_Click_1(object sender, EventArgs e)
  1662. {
  1663. }
  1664. }
  1665. }