OTSReport_Export.cs 78 KB

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