DataTemplate.cs 137 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516
  1. using DevExpress.Utils;
  2. using DevExpress.XtraCharts;
  3. using DevExpress.XtraPrinting.Drawing;
  4. using DevExpress.XtraReports.UI;
  5. using OTSCommon;
  6. using OTSCommon.Model;
  7. using OTSIncAReportApp._1_UI.OTSReportExport.DataIntegration;
  8. using OTSIncAReportApp.OTSSampleReportInfo;
  9. using OTSIncAReportApp.OTSTemplateDesigner;
  10. using OTSIncAReportGrids;
  11. using System;
  12. using System.Collections;
  13. using System.Collections.Generic;
  14. using System.Data;
  15. using System.Drawing;
  16. using System.Windows.Forms;
  17. using static OTSIncAReportApp.OTSReport_Export;
  18. namespace OTSIncAReportApp._1_UI.OTSTemplateDesigner
  19. {
  20. public partial class OTS_DEVReport : DevExpress.XtraReports.UI.XtraReport
  21. {
  22. public OTSReport_Export m_otsreport_export;
  23. string Schriftart_chinese = "微软雅黑";
  24. string Schriftart_english = "Calibri";
  25. List<string> TemplateList;
  26. float NeueStartposition = 3300f;
  27. private string FieldOfViewArea = "";
  28. DataTable FrameData = new DataTable();
  29. ElementSubscript subscript = new ElementSubscript();
  30. c_TemplateClass TemplateClass;
  31. DataTable languageData = new DataTable();
  32. private string ComputeMode = "";//计算方式
  33. private string ComputeModeName = "";//计算方式
  34. private string PartSizeFile = "";//粒级文件
  35. System.Collections.Hashtable table;
  36. public OTS_DEVReport(OTSReport_Export in_export, c_TemplateClass a_Template, frmReportApp a_frmReportApp , Hashtable a_table)
  37. {
  38. TemplateClass = a_Template;
  39. m_otsreport_export = in_export;
  40. TemplateList = new List<string>();
  41. //加载三元相图各项
  42. string pathtpf = in_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.TrigTemplateFileFolder + "\\" + in_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.TriTempFile;
  43. DataSet ds = DataOperation.DataAccess.XMLoperate.GetXmlData(pathtpf, "XMLData");
  44. DataTable dt = ds.Tables["Member"];
  45. foreach (DataRow item in dt.Rows)
  46. {
  47. if (item["TemplateName"].ToString() != "")
  48. {
  49. TemplateList.Add(item["TemplateName"].ToString());
  50. }
  51. }
  52. //string con = a_frmReportApp.m_conditionChoose.m_conditionData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
  53. string con = "";
  54. DataSet ds1 = XMLoperate.GetXmlData(Application.StartupPath + RptConfigFile.m_ReportMgrParamFile, "XMLData");
  55. DataTable dt1 = ds1.Tables["Member"];
  56. string po = "";
  57. foreach (DataRow element in dt1.Rows)
  58. {
  59. string RegName = element["RegName"].ToString();
  60. if (RegName == "PartSizeFile")
  61. {
  62. PartSizeFile = element["name"].ToString();
  63. //comboBox_PartiSizeFileFolder.SelectedIndex = comboBox_PartiSizeFileFolder.Items.IndexOf(element["name"].ToString());
  64. }
  65. if (RegName == "TRIO_CHART_TYPE")
  66. {
  67. po = element["strValue"].ToString();
  68. //cB_sjtmbwj.SelectedIndex = cB_sjtmbwj.Items.IndexOf(element["strValue"].ToString());
  69. }
  70. if (RegName == "SIZE_CAL_METHOD_TYPE")
  71. {
  72. po = element["strValue"].ToString();
  73. //cB_SIZE_CAL_METHOD_TYPE.SelectedIndex = cB_SIZE_CAL_METHOD_TYPE.Items.IndexOf(element["strValue"].ToString());
  74. }
  75. }
  76. for (int i=0;i< dt1.Rows.Count;i++)
  77. {
  78. if (dt1.Rows[i]["RegName"].ToString()== "SIZE_CAL_METHOD_TYPE")
  79. {
  80. con = dt1.Rows[i]["strValue"].ToString();
  81. }
  82. }
  83. switch (con)
  84. {
  85. case "DMAX":
  86. po = "DMAX";
  87. break;
  88. case "DMIN":
  89. po = "DMIN";
  90. break;
  91. case "ECD":
  92. po = "Area";
  93. break;
  94. case "FERET":
  95. po = "DFERET";
  96. break;
  97. }
  98. if(po=="")
  99. {
  100. ComputeMode = "Area";
  101. ComputeModeName = "ECD";
  102. }
  103. else
  104. {
  105. ComputeMode = po;
  106. ComputeModeName = con;
  107. }
  108. InitializeComponent();
  109. }
  110. #region 接口
  111. /// <summary>
  112. /// 国际化显示
  113. /// </summary>
  114. /// <param name="languageData"></param>
  115. public void International_language(DataTable a_languageData)
  116. {
  117. languageData = a_languageData.Copy();
  118. setXRLabelData(dev_ypbh_up, GetlanguageData(dev_ypbh_up.Name.ToString(), languageData, dev_ypbh_up.Text));//样品编号(中间的)
  119. setXRLabelData(dev_bgsj_up, GetlanguageData(dev_bgsj_up.Name.ToString(), languageData, dev_bgsj_up.Text));//报告时间(中间的)
  120. //setXRLabelData(dev_jcjgwj_up, GetlanguageData(dev_jcjgwj_up.Name.ToString(), languageData));//检测结果文件(中间的)
  121. //setXRLabelData(dev_ckbz_up, GetlanguageData(dev_ckbz_up.Name.ToString(), languageData));//参考标准(中间的)
  122. setXRLabelData(dev_ypsm, GetlanguageData(dev_ypsm.Name.ToString(), languageData, dev_ypsm.Text));//表中样品说明
  123. setXRLabelData(dev_jcjgwj, GetlanguageData(dev_jcjgwj.Name.ToString(), languageData, dev_jcjgwj.Text));//表中测量结果名称
  124. setXRLabelData(dev_cljggk, GetlanguageData(dev_cljggk.Name.ToString(), languageData, dev_cljggk.Text));//表中测量结果概况
  125. setXRLabelData(dev_yxsj, GetlanguageData(dev_yxsj.Name.ToString(), languageData, dev_yxsj.Text));//表中运行时间
  126. setXRLabelData(dev_sczs, GetlanguageData(dev_sczs.Name.ToString(), languageData, dev_sczs.Text));//表中视场总数
  127. setXRLabelData(dev_flfa, GetlanguageData(dev_flfa.Name.ToString(), languageData, dev_flfa.Text));//表中分类方案
  128. setXRLabelData(dev_ckbz, GetlanguageData(dev_ckbz.Name.ToString(), languageData, dev_ckbz.Text));//表中参考标准
  129. setXRLabelData(dev_yjctz, GetlanguageData(dev_yjctz.Name.ToString(), languageData, dev_yjctz.Text));//表中已检测特征
  130. setXRLabelData(dev_scmj, GetlanguageData(dev_scmj.Name.ToString(), languageData, dev_scmj.Text));//表中视场面积 总检测面积
  131. setXRLabelData(dev_bgsj, GetlanguageData(dev_bgsj.Name.ToString(), languageData, dev_bgsj.Text));//表中报告时间
  132. setXRLabelData(dev_fdbs, GetlanguageData(dev_fdbs.Name.ToString(), languageData, dev_fdbs.Text));//表中放大倍数
  133. //颗粒列表图
  134. setXRLabelData(xrLabel_size_IconQuestion_Class, GetlanguageData(xrLabel_size_IconQuestion_Class.Name.ToString(), languageData, xrLabel_size_IconQuestion_Class.Text));//大类图表头
  135. setXRLabelData(xrLabel_size_IconQuestion_Subdivision, GetlanguageData(xrLabel_size_IconQuestion_Subdivision.Name.ToString(), languageData, xrLabel_size_IconQuestion_Subdivision.Text));//细分类表头
  136. //夹杂物面积比
  137. //夹杂物面积比图
  138. setXRLabelData(xrLabel_inca_pic_class, GetlanguageData(xrLabel_inca_pic_class.Name.ToString(), languageData, xrLabel_inca_pic_class.Text));//夹杂物面积比图
  139. setXRLabelData(xrLabel_inca_pic_subdivision, GetlanguageData(xrLabel_inca_pic_subdivision.Name.ToString(), languageData, xrLabel_inca_pic_subdivision.Text));
  140. //setXRLabelData(xrLabel_size_IconQuestion_Subdivision, GetlanguageData(xrLabel_size_IconQuestion_Subdivision.Name.ToString(), languageData));
  141. //setXRLabelData(xrTableCell1, GetlanguageData(xrTableCell1.Name.ToString(), languageData));//备注
  142. setXRLabelData(xrTableCell1, "Notes");//备注
  143. setXRLabelData(xrLabel1, GetlanguageData(xrLabel1.Name.ToString(), languageData, xrLabel1.Text));
  144. //颗粒尺寸表
  145. //Bitmap bitmap = (Bitmap)Image.FromFile(str3 + "\\Config\\ReportTemplate\\ReportIdentification.bmp");
  146. //setXRLabelData(xrLabel_inca_pic_class, GetlanguageData(xrLabel_inca_pic_class.Name.ToString(), languageData));
  147. Bitmap bitmap = (Bitmap)Image.FromFile(System.IO.Directory.GetCurrentDirectory() + "\\Config\\ReportTemplate\\"+ TemplateClass.M_SY.LOGName);
  148. xrPictureBox1.ImageSource = new ImageSource(bitmap);
  149. xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
  150. }
  151. /// <summary>
  152. /// 首页部分数据插入
  153. /// </summary>ReportIdentification
  154. /// <param name="TemplateClass"></param>
  155. public void setResultGrid(DataTable a_languageData,bool a_isINCA)
  156. {
  157. xrChart_ParticelSizeCalss.Visible = false;
  158. xrChart_ParticelSizeSubdivision.Visible = false;
  159. #region 从Grid表中读取样品数据
  160. TableHeaderData HeaderData = new TableHeaderData();
  161. DataTable data = HeaderData.GetData(m_otsreport_export);
  162. #endregion
  163. #region 加载Grid表数据
  164. setXRLabelData(dev_jcjgwj_text, data.Rows[0][1].ToString());//测量结果名称
  165. setXRLabelData(dev_yxsj_text, data.Rows[1][1].ToString());//运行时间
  166. setXRLabelData(dev_sczs_text, data.Rows[2][1].ToString());//视场总数
  167. setXRLabelData(dev_flfa_text, data.Rows[3][1].ToString());//分类方案
  168. setXRLabelData(dev_yjctz_text, data.Rows[4][1].ToString());//已检测特征
  169. setXRLabelData(dev_scmj_text, data.Rows[5][1].ToString() + "μm²");//视场面积
  170. setXRLabelData(dev_fdbs_text, data.Rows[6][1].ToString());//放大倍数
  171. setXRLabelData(dev_bgsj_text, DateTime.Now.ToShortDateString().ToString());//报告时间:
  172. setXRLabelData(dev_ckbz_text, TemplateClass.M_SY.str_tb_CKBZ.ToString());//参考标准
  173. FieldOfViewArea = data.Rows[5][1].ToString();
  174. #endregion
  175. #region 加载模板设置文档数据
  176. setXRLabelData(dev_yj, TemplateClass.M_YMYJ.str_tb_yjwb.ToString());//页脚
  177. setXRLabelData(dev_zbt, TemplateClass.M_SY.str_tb_ZBT.ToString());//主标题
  178. setXRLabelData(dev_fbt, TemplateClass.M_SY.str_tb_FBT.ToString());//副标题
  179. setXRLabelData(dev_ypbh_text_up, TemplateClass.M_SY.str_tb_YPBH.ToString());//样品编号
  180. setXRLabelData(dev_bgsj_text_up, DateTime.Now.ToShortDateString().ToString());//当前日期
  181. //setXRLabelData(xrTableCell1, xrTableCell1)
  182. #endregion
  183. if (a_isINCA)
  184. xrTable1.Rows.Add(AddInclusionIndex(a_languageData, data.Rows[7][1].ToString()));
  185. xrTableCell3.Text = TemplateClass.M_DZ.Notes.ToString();
  186. xrTable3.SizeF = new SizeF(630f, 90.62f);
  187. xrTable3.Borders = DevExpress.XtraPrinting.BorderSide.All;
  188. xrTable2.Borders = DevExpress.XtraPrinting.BorderSide.All;
  189. if(TemplateClass.M_DZ.Notes.ToString()=="")
  190. {
  191. xrTable3.Visible = false;
  192. xrTable2.Visible = false;
  193. xrTable1.LocationF = new PointF(30.42f, 721.79f);
  194. }
  195. //630, 90.62.
  196. }
  197. private void add_SetTableS(List<DataTable> CompositeData, DataTable surface_dt2)
  198. {
  199. XRTable xrTa_ParticleSizeTable = add_particleSizeS();
  200. xrChart_ParticelSizeCalss.Visible = true;
  201. xrChart_ParticelSizeSubdivision.Visible = true;
  202. List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
  203. for (int i = 0; i < CompositeData[1].Rows.Count; i++)
  204. {
  205. list_ParticelSizeData.Add(switch_ParticleSize(subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Name"].ToString()), CompositeData[1].Rows[i]["total"].ToString(), CompositeData[1].Rows[i]["c1"].ToString(), CompositeData[1].Rows[i]["c2"].ToString(), CompositeData[1].Rows[i]["c3"].ToString(),
  206. CompositeData[1].Rows[i]["c4"].ToString(), CompositeData[1].Rows[i]["c5"].ToString(), CompositeData[1].Rows[i]["c6"].ToString(), CompositeData[1].Rows[i]["c7"].ToString()));
  207. }
  208. setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", languageData,"分类"));//分类
  209. setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_subdivision", languageData, "二级分类"));//二级分类(子分类)
  210. setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[2], GetlanguageData("dev_quantity", languageData, "数量"));//数量
  211. setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], GetlanguageData("dev_DimensionTable", languageData, "颗粒尺寸分析结果"));//颗粒尺寸分析结果
  212. setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_DimensionTable_2", languageData, "尺寸计算基于"));//尺寸计算基于:
  213. //dev_classify.Text = "分类";
  214. xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
  215. //dev_subdivision.Text = "子分类";
  216. xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
  217. //dev_quantity.Text = "数量";
  218. xrTa_ParticleSizeTable.Rows[2].Cells[2].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[2].Font.Size);
  219. xrTa_ParticleSizeTable.Rows[2].Cells[3].Text = CompositeData[0].Rows[0]["c1"].ToString();
  220. xrTa_ParticleSizeTable.Rows[2].Cells[4].Text = CompositeData[0].Rows[0]["c2"].ToString();
  221. xrTa_ParticleSizeTable.Rows[2].Cells[5].Text = CompositeData[0].Rows[0]["c3"].ToString();
  222. xrTa_ParticleSizeTable.Rows[2].Cells[6].Text = CompositeData[0].Rows[0]["c4"].ToString();
  223. xrTa_ParticleSizeTable.Rows[2].Cells[7].Text = CompositeData[0].Rows[0]["c5"].ToString();
  224. xrTa_ParticleSizeTable.Rows[2].Cells[8].Text = CompositeData[0].Rows[0]["c6"].ToString();
  225. xrTa_ParticleSizeTable.Rows[2].Cells[9].Text = CompositeData[0].Rows[0]["c7"].ToString();
  226. xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  227. xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
  228. xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
  229. int total = 0;
  230. for (int i = 0; i < CompositeData[1].Rows.Count; i++)
  231. {
  232. XRTableRow row = new XRTableRow();
  233. XRTableCell tCell_Class = new XRTableCell();
  234. XRTableCell tCell_Name = new XRTableCell();
  235. XRTableCell tCell_total = new XRTableCell();
  236. XRTableCell tCell_size_1 = new XRTableCell();
  237. XRTableCell tCell_size_2 = new XRTableCell();
  238. XRTableCell tCell_size_3 = new XRTableCell();
  239. XRTableCell tCell_size_4 = new XRTableCell();
  240. XRTableCell tCell_size_5 = new XRTableCell();
  241. XRTableCell tCell_size_6 = new XRTableCell();
  242. XRTableCell tCell_size_7 = new XRTableCell();
  243. tCell_Class.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
  244. tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
  245. tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
  246. tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
  247. tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
  248. tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
  249. tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
  250. tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
  251. tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
  252. tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[9].WidthF;
  253. XRTableCellData(row, tCell_Class, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Class");
  254. XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
  255. XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
  256. XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
  257. XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
  258. XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
  259. XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
  260. XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
  261. XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
  262. XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
  263. xrTa_ParticleSizeTable.Rows.Add(row);
  264. if (CompositeData[1].Rows[i]["Name"].ToString()!="")
  265. {
  266. total += Convert.ToInt32(CompositeData[1].Rows[i]["total"]);
  267. }
  268. }
  269. this.Detail.Controls.Add(xrTa_ParticleSizeTable);
  270. xrTa_ParticleSizeTable.LocationF = new PointF(10f, 940f);
  271. XRTable xrTable3 = add_particleSizeS_end();
  272. xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
  273. List<int> vs = new List<int>();
  274. vs.Add(0);
  275. vs.Add(0);
  276. vs.Add(0);
  277. vs.Add(0);
  278. vs.Add(0);
  279. vs.Add(0);
  280. vs.Add(0);
  281. vs.Add(0);
  282. vs.Add(0);
  283. vs.Add(0);
  284. for (int i = 0; i < surface_dt2.Rows.Count; i++)
  285. {
  286. for (int a = 1; a < 10; a++)
  287. {
  288. if (surface_dt2.Rows[i]["c" + a.ToString()] != " " && surface_dt2.Rows[i]["c" + a.ToString()] != "" && surface_dt2.Rows[i]["c" + a.ToString()] != null)
  289. {
  290. bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + a.ToString()].ToString(), out double result);
  291. if (isNumeric)
  292. vs[a - 1] += Convert.ToInt32(result);
  293. }
  294. }
  295. //total += Convert.ToInt32(surface_dt2.Rows[i]["total"]);
  296. }
  297. setXRLabelData(xrTable3.Rows[0].Cells[0], GetlanguageData("dev_total", languageData, "总数量"));
  298. //xrTable3.Rows[0].Cells[0].Text = "总数量";
  299. xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  300. xrTable3.Rows[0].Cells[1].Text = total.ToString();
  301. xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  302. xrTable3.Rows[0].Cells[2].Text = vs[0].ToString();
  303. xrTable3.Rows[0].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  304. xrTable3.Rows[0].Cells[3].Text = vs[1].ToString();
  305. xrTable3.Rows[0].Cells[3].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  306. xrTable3.Rows[0].Cells[4].Text = vs[2].ToString();
  307. xrTable3.Rows[0].Cells[4].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  308. xrTable3.Rows[0].Cells[5].Text = vs[3].ToString();
  309. xrTable3.Rows[0].Cells[5].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  310. xrTable3.Rows[0].Cells[6].Text = vs[4].ToString();
  311. xrTable3.Rows[0].Cells[6].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  312. xrTable3.Rows[0].Cells[7].Text = vs[5].ToString();
  313. xrTable3.Rows[0].Cells[7].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  314. xrTable3.Rows[0].Cells[8].Text = vs[6].ToString();
  315. xrTable3.Rows[0].Cells[8].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  316. NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
  317. this.Detail.Controls.Add(xrTable3);
  318. }
  319. private void add_SetTable(List<DataTable> CompositeData, DataTable surface_dt2)
  320. {
  321. XRTable xrTa_ParticleSizeTable = add_particleSize();
  322. xrChart_ParticelSizeCalss.Visible = true;
  323. xrChart_ParticelSizeSubdivision.Visible = true;
  324. List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
  325. int ls = 0;
  326. DataTable REORDER_data = REORDER(CompositeData[1], "Name");
  327. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  328. {
  329. if (REORDER_data.Rows[i]["Name"].ToString() == "" || REORDER_data.Rows[i]["Name"].ToString() == null)
  330. {
  331. ls = i;
  332. continue;
  333. }
  334. list_ParticelSizeData.Add(switch_ParticleSize(subscript.Getsubscriptstring(REORDER_data.Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(REORDER_data.Rows[i]["Name"].ToString()), REORDER_data.Rows[i]["total"].ToString(), REORDER_data.Rows[i]["c1"].ToString(), REORDER_data.Rows[i]["c2"].ToString(), REORDER_data.Rows[i]["c3"].ToString(),
  335. REORDER_data.Rows[i]["c4"].ToString(), REORDER_data.Rows[i]["c5"].ToString(), REORDER_data.Rows[i]["c6"].ToString(), REORDER_data.Rows[i]["c7"].ToString()));
  336. }
  337. //if (REORDER_data.Rows.Count!=1)
  338. //{
  339. // REORDER_data.Rows[ls].Delete();
  340. // REORDER_data.AcceptChanges();
  341. //}
  342. setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", languageData, "分类"));//二级分类(子分类)
  343. setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_quantity", languageData, "数量"));//数量
  344. setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], GetlanguageData("dev_DimensionTable", languageData, "颗粒尺寸分析结果"));//颗粒尺寸分析结果
  345. setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_DimensionTable_2", languageData, "尺寸计算基于:"));//尺寸计算基于:
  346. //dev_subdivision.Text = "子分类";
  347. xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
  348. //dev_quantity.Text = "数量";
  349. xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
  350. xrTa_ParticleSizeTable.Rows[2].Cells[2].Text = CompositeData[0].Rows[0]["c1"].ToString();
  351. xrTa_ParticleSizeTable.Rows[2].Cells[3].Text = CompositeData[0].Rows[0]["c2"].ToString();
  352. xrTa_ParticleSizeTable.Rows[2].Cells[4].Text = CompositeData[0].Rows[0]["c3"].ToString();
  353. xrTa_ParticleSizeTable.Rows[2].Cells[5].Text = CompositeData[0].Rows[0]["c4"].ToString();
  354. xrTa_ParticleSizeTable.Rows[2].Cells[6].Text = CompositeData[0].Rows[0]["c5"].ToString();
  355. xrTa_ParticleSizeTable.Rows[2].Cells[7].Text = CompositeData[0].Rows[0]["c6"].ToString();
  356. xrTa_ParticleSizeTable.Rows[2].Cells[8].Text = CompositeData[0].Rows[0]["c7"].ToString();
  357. xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  358. xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
  359. xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
  360. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  361. {
  362. XRTableRow row = new XRTableRow();
  363. XRTableCell tCell_Name = new XRTableCell();
  364. XRTableCell tCell_total = new XRTableCell();
  365. XRTableCell tCell_size_1 = new XRTableCell();
  366. XRTableCell tCell_size_2 = new XRTableCell();
  367. XRTableCell tCell_size_3 = new XRTableCell();
  368. XRTableCell tCell_size_4 = new XRTableCell();
  369. XRTableCell tCell_size_5 = new XRTableCell();
  370. XRTableCell tCell_size_6 = new XRTableCell();
  371. XRTableCell tCell_size_7 = new XRTableCell();
  372. tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
  373. tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
  374. tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
  375. tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
  376. tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
  377. tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
  378. tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
  379. tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
  380. tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
  381. XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
  382. XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
  383. XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
  384. XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
  385. XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
  386. XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
  387. XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
  388. XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
  389. XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
  390. xrTa_ParticleSizeTable.Rows.Add(row);
  391. }
  392. this.Detail.Controls.Add(xrTa_ParticleSizeTable);
  393. xrTa_ParticleSizeTable.LocationF = new PointF(10f, 940f);
  394. XRTable xrTable3 = add_particleSize_end();
  395. xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
  396. List<int> vs = new List<int>();
  397. vs.Add(0);
  398. vs.Add(0);
  399. vs.Add(0);
  400. vs.Add(0);
  401. vs.Add(0);
  402. vs.Add(0);
  403. vs.Add(0);
  404. vs.Add(0);
  405. vs.Add(0);
  406. vs.Add(0);
  407. int total = 0;
  408. for (int i = 0; i < surface_dt2.Rows.Count; i++)
  409. {
  410. for (int a = 1; a < 10; a++)
  411. {
  412. if (surface_dt2.Rows[i]["c" + a.ToString()] != " " && surface_dt2.Rows[i]["c" + a.ToString()] != "" && surface_dt2.Rows[i]["c" + a.ToString()] != null)
  413. {
  414. bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + a.ToString()].ToString(), out double result);
  415. if (isNumeric)
  416. vs[a - 1] += Convert.ToInt32(result);
  417. }
  418. }
  419. total += Convert.ToInt32(surface_dt2.Rows[i]["total"]);
  420. }
  421. //xrTable3.Rows[0].Cells[0].Text = "总数量";
  422. setXRLabelData(xrTable3.Rows[0].Cells[0], "总数量");
  423. xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  424. xrTable3.Rows[0].Cells[1].Text = total.ToString();
  425. xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  426. xrTable3.Rows[0].Cells[2].Text = vs[0].ToString();
  427. xrTable3.Rows[0].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  428. xrTable3.Rows[0].Cells[3].Text = vs[1].ToString();
  429. xrTable3.Rows[0].Cells[3].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  430. xrTable3.Rows[0].Cells[4].Text = vs[2].ToString();
  431. xrTable3.Rows[0].Cells[4].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  432. xrTable3.Rows[0].Cells[5].Text = vs[3].ToString();
  433. xrTable3.Rows[0].Cells[5].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  434. xrTable3.Rows[0].Cells[6].Text = vs[4].ToString();
  435. xrTable3.Rows[0].Cells[6].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  436. xrTable3.Rows[0].Cells[7].Text = vs[5].ToString();
  437. xrTable3.Rows[0].Cells[7].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  438. xrTable3.Rows[0].Cells[8].Text = vs[6].ToString();
  439. xrTable3.Rows[0].Cells[8].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  440. NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
  441. this.Detail.Controls.Add(xrTable3);
  442. }
  443. /// <summary>
  444. /// 优先级排序
  445. /// </summary>
  446. /// <param name="data"></param>
  447. /// <param name="field"></param>
  448. /// <returns></returns>
  449. private DataTable REORDER(DataTable data,string field)
  450. {
  451. DataTable dataTable = data.Clone();
  452. List<int> vs = new List<int>();
  453. for (int i=0;i< data.Rows.Count;i++)
  454. {
  455. if (TemplateClass.list_str_MainPriority.Count!=0)
  456. {
  457. for (int a = 0; a < TemplateClass.list_str_MainPriority.Count; a++)
  458. {
  459. if (data.Rows[i][field].ToString() == TemplateClass.list_str_MainPriority[a])
  460. {
  461. dataTable.Rows.Add(data.Rows[i].ItemArray);
  462. continue;
  463. }
  464. }
  465. }
  466. else
  467. {
  468. dataTable.Rows.Add(data.Rows[i].ItemArray);
  469. }
  470. }
  471. for (int i=0;i< dataTable.Rows.Count;i++)
  472. {
  473. if (!string.IsNullOrWhiteSpace(dataTable.Rows[i]["Class"].ToString()))
  474. {
  475. //vs.Add(i);
  476. dataTable.Rows[i].Delete();
  477. }
  478. //dataTable.Rows[i].Delete();
  479. }
  480. //for (int i=0;i<vs.Count;i++)
  481. //{
  482. // dataTable.Rows[i].Delete();
  483. //}
  484. dataTable.AcceptChanges();
  485. // dataTable.Rows[ls].Delete();
  486. // dataTable.AcceptChanges();
  487. return dataTable.Copy();
  488. }
  489. /// <summary>
  490. /// 颗粒尺寸分析表
  491. /// </summary>
  492. /// <param name="a_pieSeriesClass">大分类</param>
  493. /// <param name="a_pieSeries">小分类</param>
  494. public void setParticleSizeTable(bool a_pieSeriesClass, bool a_pieSeries, bool isStacking)
  495. {
  496. xrPageBreak1.Visible = true;
  497. ParticleAnalysis particleList = new ParticleAnalysis();
  498. List<DataTable> CompositeData = particleList.GetClassificationConsolidationTable(TemplateClass, m_otsreport_export, ComputeMode, PartSizeFile);
  499. DataTable classData= particleList.GetLargeClassification(TemplateClass, m_otsreport_export, ComputeMode);
  500. DataTable subdivdeData = particleList.GetSubClassification(TemplateClass, m_otsreport_export, ComputeMode);
  501. DataTable chartmax= particleList.GetChartDataCalss(TemplateClass, m_otsreport_export, ComputeMode);
  502. //DataTable surface_dt2 = particleList.ParticleResults(TemplateClass, m_otsreport_export, ComputeMode);
  503. DataTable surface_dt2 = CompositeData[1].Clone();
  504. for (int i=0;i< CompositeData[1].Rows.Count;i++)
  505. {
  506. if (CompositeData[1].Rows[i]["Name"].ToString()!="")
  507. {
  508. surface_dt2.Rows.Add(CompositeData[1].Rows[i].ItemArray);
  509. }
  510. }
  511. for (int i = 0; i < classData.Rows.Count; i++)
  512. {
  513. classData.Rows[i]["Class"] = subscript.Getsubscriptstring(classData.Rows[i]["Class"].ToString());
  514. }
  515. for (int i = 0; i < subdivdeData.Rows.Count; i++)
  516. {
  517. subdivdeData.Rows[i]["Name"] = subscript.Getsubscriptstring(subdivdeData.Rows[i]["Name"].ToString());
  518. subdivdeData.Rows[i]["Class"] = subscript.Getsubscriptstring(subdivdeData.Rows[i]["Class"].ToString());
  519. }
  520. #region 插入数据
  521. if(CompositeData[1].Rows.Count>0)
  522. {
  523. if (particleList.IsThereAMajorClassification(m_otsreport_export))
  524. {
  525. add_SetTableS(CompositeData, surface_dt2);
  526. }
  527. else
  528. {
  529. add_SetTable(CompositeData, surface_dt2);
  530. }
  531. }
  532. if (isStacking)
  533. {
  534. HistogramChart(particleList);
  535. }
  536. if (a_pieSeriesClass || a_pieSeries)
  537. {
  538. XRPageBreak();
  539. }
  540. xrChart_ParticelSizeCalss.Visible = false;
  541. #region 大分类chart图
  542. if (a_pieSeriesClass&& chartmax.Rows.Count>0)
  543. {
  544. xrChart_ParticelSizeCalss.Visible = true;
  545. xrLabel_size_IconQuestion_Class.Visible = true;
  546. xrLabel_size_IconQuestion_Class.LocationF = new PointF(xrLabel_size_IconQuestion_Class.LocationF.X, NeueStartposition);
  547. NeueStartposition = xrLabel_size_IconQuestion_Class.LocationF.Y + xrLabel_size_IconQuestion_Class.SizeF.Height + 10;
  548. //DataView dv = subdivdeData.DefaultView;
  549. //dv.Sort = "total DESC";
  550. //DataTable dt_class_dt = dv.ToTable();
  551. // 实例化饼图对象
  552. Series pieSeriesClass = new Series("尺寸分类", ViewType.Pie);
  553. pieSeriesClass.ArgumentScaleType = ScaleType.Qualitative;
  554. // 项目名称
  555. pieSeriesClass.ArgumentDataMember = "name";
  556. pieSeriesClass.ValueScaleType = ScaleType.Numerical;
  557. //取值字段
  558. pieSeriesClass.ValueDataMembers.AddRange(new string[] { "quantity" });
  559. (pieSeriesClass.Label as PieSeriesLabel).Position = PieSeriesLabelPosition.Inside;
  560. //显示百分比
  561. pieSeriesClass.PointOptions.PointView = PointView.ArgumentAndValues;
  562. pieSeriesClass.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
  563. //设置数据源
  564. pieSeriesClass.DataSource = chartmax;
  565. pieSeriesClass.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
  566. // 饼图空间添加 新建的饼图对象
  567. xrChart_ParticelSizeCalss.Series.Add(pieSeriesClass);
  568. //右上角分组视图
  569. this.xrChart_ParticelSizeCalss.Legend.MarkerSize = new System.Drawing.Size(20, 20);
  570. this.xrChart_ParticelSizeCalss.Legend.TextOffset = 5;
  571. this.xrChart_ParticelSizeCalss.Legend.VerticalIndent = 5;
  572. this.xrChart_ParticelSizeCalss.Legend.Border.Color = Color.Red;//红色边框
  573. xrChart_ParticelSizeCalss.LocationF = new PointF(30f, NeueStartposition);
  574. NeueStartposition = xrChart_ParticelSizeCalss.LocationF.Y + xrChart_ParticelSizeCalss.SizeF.Height+1 ;
  575. }
  576. #endregion
  577. #region 细分chart图
  578. xrChart_ParticelSizeSubdivision.Visible = false;
  579. if (a_pieSeries && surface_dt2.Rows.Count>0)
  580. {
  581. DataView dv2 = surface_dt2.DefaultView;
  582. dv2.Sort = "total DESC";
  583. DataTable dt_subdivde_dt = dv2.ToTable();
  584. xrChart_ParticelSizeSubdivision.Visible = true;
  585. xrLabel_size_IconQuestion_Subdivision.Visible = true;
  586. xrLabel_size_IconQuestion_Subdivision.LocationF = new PointF(xrLabel_size_IconQuestion_Subdivision.LocationF.X, NeueStartposition);
  587. NeueStartposition = xrLabel_size_IconQuestion_Subdivision.LocationF.Y + xrLabel_size_IconQuestion_Subdivision.SizeF.Height + 1;
  588. // 实例化饼图对象
  589. Series pieSeries = new Series("颗粒尺寸细化分类", ViewType.Pie);
  590. pieSeries.ArgumentScaleType = ScaleType.Qualitative;
  591. // 项目名称
  592. pieSeries.ArgumentDataMember = "Name";
  593. pieSeries.ValueScaleType = ScaleType.Numerical;
  594. //取值字段
  595. pieSeries.ValueDataMembers.AddRange(new string[] { "total" });
  596. (pieSeries.Label as PieSeriesLabel).Position = PieSeriesLabelPosition.Inside;
  597. //显示百分比
  598. pieSeries.PointOptions.PointView = PointView.ArgumentAndValues;
  599. pieSeries.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
  600. //设置数据源
  601. pieSeries.DataSource = dt_subdivde_dt;
  602. pieSeries.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
  603. // 饼图空间添加 新建的饼图对象
  604. xrChart_ParticelSizeSubdivision.Series.Add(pieSeries);
  605. //右上角分组视图
  606. this.xrChart_ParticelSizeSubdivision.Legend.MarkerSize = new System.Drawing.Size(20, 20);
  607. this.xrChart_ParticelSizeSubdivision.Legend.TextOffset = 5;
  608. this.xrChart_ParticelSizeSubdivision.Legend.VerticalIndent = 5;
  609. this.xrChart_ParticelSizeSubdivision.Legend.Border.Color = Color.Red;//红色边框
  610. xrChart_ParticelSizeSubdivision.LocationF = new PointF(30f, NeueStartposition);
  611. NeueStartposition = xrChart_ParticelSizeSubdivision.LocationF.Y + xrChart_ParticelSizeSubdivision.SizeF.Height + 10;
  612. }
  613. #endregion
  614. #endregion
  615. }
  616. private XRChart ParticleSpectrogramControl(DataTable dt)
  617. {
  618. XRChart xRChart = new XRChart();
  619. // 添加数据系列
  620. Series series = new Series("", ViewType.Line);
  621. series.ArgumentDataMember = "XName"; // X轴数据
  622. series.ValueDataMembers.AddRange(new string[] { "data", "Serial" }); // Y轴数据
  623. // 绑定数据源
  624. series.DataSource = dt; // 获取数据源的方法
  625. xrChart1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
  626. series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
  627. LineSeriesView lineView = (LineSeriesView)series.View;
  628. lineView.LineMarkerOptions.Size = 1;
  629. xRChart.Series.Add(series);
  630. xRChart.SizeF = new SizeF(560f, 115f);
  631. return xRChart;
  632. }
  633. private void HistogramChart(ParticleAnalysis particleList)
  634. {
  635. XRPageBreak();
  636. List<Series> seriesList = new List<Series>();
  637. DataTable dataTable = particleList.ParticleResults(TemplateClass, m_otsreport_export, ComputeMode);
  638. DataTable TypeRange = particleList.TypeRange(TemplateClass, m_otsreport_export);
  639. if(dataTable.Rows.Count==0)
  640. {
  641. return;
  642. }
  643. xrLabel1.Visible = true;
  644. xrChart1.Visible = true;
  645. DataTable dt = new DataTable();
  646. dt.Columns.Add("name");
  647. dt.Columns.Add("range");
  648. dt.Columns.Add("num");
  649. for (int i = 0; i < dataTable.Rows.Count; i++)
  650. {
  651. for (int a = 0; a < 11; a++)
  652. {
  653. if (string.IsNullOrEmpty(TypeRange.Rows[0][a].ToString()))
  654. continue;
  655. DataRow dr = dt.NewRow();
  656. dr["name"] = subscript.Getsubscriptstring(dataTable.Rows[i]["Name"].ToString());
  657. dr["range"] = TypeRange.Rows[0][a];
  658. if (double.TryParse(dataTable.Rows[i]["c" + (a+1).ToString()].ToString(), out double result))
  659. {
  660. dr["num"] = result;
  661. }
  662. else
  663. {
  664. dr["num"] = 0;
  665. }
  666. dt.Rows.Add(dr);
  667. }
  668. }
  669. foreach (DataRow dr in dt.DefaultView.ToTable(true, "name").Rows)
  670. {
  671. Series s = new Series(dr["name"].ToString(), ViewType.StackedBar)
  672. {
  673. LegendTextPattern = dr["name"].ToString(),
  674. ArgumentScaleType = ScaleType.Qualitative,
  675. };
  676. foreach (DataRow drl in dt.Select("name='" + dr["name"].ToString() + "'"))
  677. s.Points.Add(new SeriesPoint(drl["range"].ToString(), int.Parse(drl["num"].ToString())));
  678. s.LabelsVisibility = DefaultBoolean.False;
  679. seriesList.Add(s);
  680. }
  681. foreach (Series sr in seriesList.ToArray())
  682. xrChart1.Series.Add(sr);
  683. ((XYDiagram)xrChart1.Diagram).AxisY.Title.Text = "";
  684. ((XYDiagram)xrChart1.Diagram).AxisX.Title.Text = "";
  685. ((XYDiagram)xrChart1.Diagram).AxisY.Title.Visibility = DefaultBoolean.True;
  686. ((XYDiagram)xrChart1.Diagram).AxisX.Title.Visibility = DefaultBoolean.True;
  687. ((XYDiagram)xrChart1.Diagram).AxisY.Title.Font = new Font("Tahoma", 9);
  688. ((XYDiagram)xrChart1.Diagram).AxisX.Title.Font = new Font("Tahoma", 9);
  689. ((XYDiagram)xrChart1.Diagram).AxisY.Title.Alignment = StringAlignment.Far;
  690. ((XYDiagram)xrChart1.Diagram).AxisX.Title.Alignment = StringAlignment.Far;
  691. xrLabel1.LocationF = new PointF(xrLabel1.LocationF.X, NeueStartposition);
  692. NeueStartposition = xrLabel1.LocationF.Y + xrLabel1.SizeF.Height ;
  693. xrChart1.LocationF = new PointF(xrChart1.LocationF.X, NeueStartposition);
  694. NeueStartposition = xrChart1.LocationF.Y + xrChart1.SizeF.Height + 20;
  695. }
  696. /// <summary>
  697. /// 元素分析有大分类数据加载
  698. /// </summary>
  699. private void add_SetElementAvgGridS(List<DataTable> a_datas)
  700. {
  701. XRTable xRTable = add_ElementListS();
  702. setXRLabelData(xRTable.Rows[2].Cells[3], a_datas[0].Rows[0][2].ToString());
  703. setXRLabelData(xRTable.Rows[2].Cells[4], a_datas[0].Rows[0][3].ToString());
  704. setXRLabelData(xRTable.Rows[2].Cells[5], a_datas[0].Rows[0][4].ToString());
  705. setXRLabelData(xRTable.Rows[2].Cells[6], a_datas[0].Rows[0][5].ToString());
  706. setXRLabelData(xRTable.Rows[2].Cells[7], a_datas[0].Rows[0][6].ToString());
  707. setXRLabelData(xRTable.Rows[2].Cells[8], a_datas[0].Rows[0][7].ToString());
  708. setXRLabelData(xRTable.Rows[2].Cells[9], a_datas[0].Rows[0][8].ToString());
  709. setXRLabelData(xRTable.Rows[2].Cells[10], a_datas[0].Rows[0][9].ToString());
  710. setXRLabelData(xRTable.Rows[2].Cells[11], a_datas[0].Rows[0][10].ToString());
  711. setXRLabelData(xRTable.Rows[2].Cells[12], a_datas[0].Rows[0][11].ToString());
  712. List<List<ElementalAnalysisDEVData>> list_ElementalAnalysisData = new List<List<ElementalAnalysisDEVData>>();
  713. for (int i = 0; i < a_datas[1].Rows.Count; i++)
  714. {
  715. double quantity = 0;
  716. for (int a = 2; a < 12; a++)
  717. {
  718. if (a_datas[1].Rows[i][a].ToString() != "")
  719. {
  720. if (double.TryParse(a_datas[1].Rows[i][a].ToString(), out double number))
  721. {
  722. quantity = quantity + number;
  723. }
  724. }
  725. }
  726. list_ElementalAnalysisData.Add(set_ElementalAnalysis(subscript.Getsubscriptstring(a_datas[1].Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(a_datas[1].Rows[i]["Name"].ToString()), a_datas[1].Rows[i]["Area"].ToString(),
  727. a_datas[1].Rows[i][2].ToString(), a_datas[1].Rows[i][3].ToString(), a_datas[1].Rows[i][4].ToString(), a_datas[1].Rows[i][5].ToString(), a_datas[1].Rows[i][6].ToString(),
  728. a_datas[1].Rows[i][7].ToString(), a_datas[1].Rows[i][8].ToString(), a_datas[1].Rows[i][9].ToString(), a_datas[1].Rows[i][10].ToString(), a_datas[1].Rows[i][11].ToString()));
  729. }
  730. for (int i = 0; i < a_datas[1].Rows.Count; i++)
  731. {
  732. XRTableRow row = new XRTableRow();
  733. XRTableCell tCell_classify = new XRTableCell();
  734. XRTableCell tCell_subdivision = new XRTableCell();
  735. XRTableCell tCell_area = new XRTableCell();
  736. XRTableCell tCell_s1 = new XRTableCell();
  737. XRTableCell tCell_s2 = new XRTableCell();
  738. XRTableCell tCell_s3 = new XRTableCell();
  739. XRTableCell tCell_s4 = new XRTableCell();
  740. XRTableCell tCell_s5 = new XRTableCell();
  741. XRTableCell tCell_s6 = new XRTableCell();
  742. XRTableCell tCell_s7 = new XRTableCell();
  743. XRTableCell tCell_s8 = new XRTableCell();
  744. XRTableCell tCell_s9 = new XRTableCell();
  745. XRTableCell tCell_s10 = new XRTableCell();
  746. tCell_classify.WidthF = xRTable.Rows[2].Cells[0].WidthF;
  747. tCell_subdivision.WidthF = xRTable.Rows[2].Cells[1].WidthF;
  748. tCell_area.WidthF = xRTable.Rows[2].Cells[2].WidthF;
  749. tCell_s1.WidthF = xRTable.Rows[2].Cells[3].WidthF;
  750. tCell_s2.WidthF = xRTable.Rows[2].Cells[4].WidthF;
  751. tCell_s3.WidthF = xRTable.Rows[2].Cells[5].WidthF;
  752. tCell_s4.WidthF = xRTable.Rows[2].Cells[6].WidthF;
  753. tCell_s5.WidthF = xRTable.Rows[2].Cells[7].WidthF;
  754. tCell_s6.WidthF = xRTable.Rows[2].Cells[8].WidthF;
  755. tCell_s7.WidthF = xRTable.Rows[2].Cells[9].WidthF;
  756. tCell_s8.WidthF = xRTable.Rows[2].Cells[10].WidthF;
  757. tCell_s9.WidthF = xRTable.Rows[2].Cells[11].WidthF;
  758. tCell_s10.WidthF = xRTable.Rows[2].Cells[12].WidthF;
  759. XRTableCellData_ElementAnalysis(row, tCell_classify, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "classify");
  760. XRTableCellData_ElementAnalysis(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "subdivision");
  761. XRTableCellData_ElementAnalysis(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Area");
  762. XRTableCellData_ElementAnalysis(row, tCell_s1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s1");
  763. XRTableCellData_ElementAnalysis(row, tCell_s2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s2");
  764. XRTableCellData_ElementAnalysis(row, tCell_s3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s3");
  765. XRTableCellData_ElementAnalysis(row, tCell_s4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s4");
  766. XRTableCellData_ElementAnalysis(row, tCell_s5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s5");
  767. XRTableCellData_ElementAnalysis(row, tCell_s6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s6");
  768. XRTableCellData_ElementAnalysis(row, tCell_s7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s7");
  769. XRTableCellData_ElementAnalysis(row, tCell_s8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s8");
  770. XRTableCellData_ElementAnalysis(row, tCell_s9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s9");
  771. XRTableCellData_ElementAnalysis(row, tCell_s10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s10");
  772. xRTable.Rows.Add(row);
  773. }
  774. xRTable.LocationF = new PointF(10f, NeueStartposition);
  775. NeueStartposition = xRTable.LocationF.Y + xRTable.SizeF.Height + 10;
  776. this.Detail.Controls.Add(xRTable);
  777. }
  778. private void add_SetElementAvgGrid(List<DataTable> a_datas)
  779. {
  780. XRTable xRTable = add_ElementList();
  781. setXRLabelData(xRTable.Rows[2].Cells[2], a_datas[0].Rows[0][2].ToString());
  782. setXRLabelData(xRTable.Rows[2].Cells[3], a_datas[0].Rows[0][3].ToString());
  783. setXRLabelData(xRTable.Rows[2].Cells[4], a_datas[0].Rows[0][4].ToString());
  784. setXRLabelData(xRTable.Rows[2].Cells[5], a_datas[0].Rows[0][5].ToString());
  785. setXRLabelData(xRTable.Rows[2].Cells[6], a_datas[0].Rows[0][6].ToString());
  786. setXRLabelData(xRTable.Rows[2].Cells[7], a_datas[0].Rows[0][7].ToString());
  787. setXRLabelData(xRTable.Rows[2].Cells[8], a_datas[0].Rows[0][8].ToString());
  788. setXRLabelData(xRTable.Rows[2].Cells[9], a_datas[0].Rows[0][9].ToString());
  789. setXRLabelData(xRTable.Rows[2].Cells[10], a_datas[0].Rows[0][10].ToString());
  790. setXRLabelData(xRTable.Rows[2].Cells[11], a_datas[0].Rows[0][11].ToString());
  791. int ls = 0;
  792. DataTable REORDER_data = REORDER(a_datas[1], "Name");
  793. if (REORDER_data.Rows.Count == 0)
  794. return;
  795. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  796. {
  797. if (REORDER_data.Rows[i]["Name"].ToString() == "" || REORDER_data.Rows[i]["Name"].ToString() == null)
  798. {
  799. ls = i;
  800. continue;
  801. }
  802. }
  803. //REORDER_data.Rows[ls].Delete();
  804. //REORDER_data.AcceptChanges();
  805. List<List<ElementalAnalysisDEVData>> list_ElementalAnalysisData = new List<List<ElementalAnalysisDEVData>>();
  806. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  807. {
  808. double quantity = 0;
  809. for (int a = 2; a < 12; a++)
  810. {
  811. if (REORDER_data.Rows[i][a].ToString() != "")
  812. {
  813. if (double.TryParse(REORDER_data.Rows[i][a].ToString(), out double number))
  814. {
  815. quantity = quantity + number;
  816. }
  817. }
  818. }
  819. list_ElementalAnalysisData.Add(set_ElementalAnalysisS(subscript.Getsubscriptstring(REORDER_data.Rows[i]["Name"].ToString()), REORDER_data.Rows[i]["Area"].ToString(),
  820. REORDER_data.Rows[i][2].ToString(), REORDER_data.Rows[i][3].ToString(), REORDER_data.Rows[i][4].ToString(), REORDER_data.Rows[i][5].ToString(), REORDER_data.Rows[i][6].ToString(),
  821. REORDER_data.Rows[i][7].ToString(), REORDER_data.Rows[i][8].ToString(), REORDER_data.Rows[i][9].ToString(), REORDER_data.Rows[i][10].ToString(), REORDER_data.Rows[i][11].ToString()));
  822. }
  823. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  824. {
  825. XRTableRow row = new XRTableRow();
  826. XRTableCell tCell_subdivision = new XRTableCell();
  827. XRTableCell tCell_area = new XRTableCell();
  828. XRTableCell tCell_s1 = new XRTableCell();
  829. XRTableCell tCell_s2 = new XRTableCell();
  830. XRTableCell tCell_s3 = new XRTableCell();
  831. XRTableCell tCell_s4 = new XRTableCell();
  832. XRTableCell tCell_s5 = new XRTableCell();
  833. XRTableCell tCell_s6 = new XRTableCell();
  834. XRTableCell tCell_s7 = new XRTableCell();
  835. XRTableCell tCell_s8 = new XRTableCell();
  836. XRTableCell tCell_s9 = new XRTableCell();
  837. XRTableCell tCell_s10 = new XRTableCell();
  838. tCell_subdivision.WidthF = xRTable.Rows[2].Cells[0].WidthF;
  839. tCell_area.WidthF = xRTable.Rows[2].Cells[1].WidthF;
  840. tCell_s1.WidthF = xRTable.Rows[2].Cells[2].WidthF;
  841. tCell_s2.WidthF = xRTable.Rows[2].Cells[3].WidthF;
  842. tCell_s3.WidthF = xRTable.Rows[2].Cells[4].WidthF;
  843. tCell_s4.WidthF = xRTable.Rows[2].Cells[5].WidthF;
  844. tCell_s5.WidthF = xRTable.Rows[2].Cells[6].WidthF;
  845. tCell_s6.WidthF = xRTable.Rows[2].Cells[7].WidthF;
  846. tCell_s7.WidthF = xRTable.Rows[2].Cells[8].WidthF;
  847. tCell_s8.WidthF = xRTable.Rows[2].Cells[9].WidthF;
  848. tCell_s9.WidthF = xRTable.Rows[2].Cells[10].WidthF;
  849. tCell_s10.WidthF = xRTable.Rows[2].Cells[11].WidthF;
  850. XRTableCellData_ElementAnalysis(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "subdivision");
  851. XRTableCellData_ElementAnalysis(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Area");
  852. XRTableCellData_ElementAnalysis(row, tCell_s1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s1");
  853. XRTableCellData_ElementAnalysis(row, tCell_s2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s2");
  854. XRTableCellData_ElementAnalysis(row, tCell_s3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s3");
  855. XRTableCellData_ElementAnalysis(row, tCell_s4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s4");
  856. XRTableCellData_ElementAnalysis(row, tCell_s5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s5");
  857. XRTableCellData_ElementAnalysis(row, tCell_s6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s6");
  858. XRTableCellData_ElementAnalysis(row, tCell_s7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s7");
  859. XRTableCellData_ElementAnalysis(row, tCell_s8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s8");
  860. XRTableCellData_ElementAnalysis(row, tCell_s9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s9");
  861. XRTableCellData_ElementAnalysis(row, tCell_s10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "s10");
  862. xRTable.Rows.Add(row);
  863. }
  864. xRTable.LocationF = new PointF(10f, NeueStartposition);
  865. NeueStartposition = xRTable.LocationF.Y + xRTable.SizeF.Height + 10;
  866. this.Detail.Controls.Add(xRTable);
  867. }
  868. /// <summary>
  869. /// 设置插入元素分析表数据
  870. /// </summary>
  871. /// <param name="TemplateClass"></param>
  872. public void setElementAvgGrid()
  873. {
  874. ElementalAnalysis elementalAnalysis = new ElementalAnalysis();
  875. List<DataTable> datas = elementalAnalysis.GetElementData(TemplateClass, m_otsreport_export, ComputeMode);
  876. if (elementalAnalysis.IsThereAMajorClassification(m_otsreport_export))
  877. add_SetElementAvgGridS(datas);
  878. else
  879. add_SetElementAvgGrid(datas);
  880. //xrTb_ElementAnalysis.Visible = true;
  881. ////元素分析表————————
  882. //setXRLabelData(xrTableCell30, GetlanguageData("xrCellElementArea", languageData));//元素分析表表头
  883. //setXRLabelData(xrTableCell31, GetlanguageData("xrCellElementArea_details", languageData));//详情
  884. //DataTable REORDER_data = REORDER(datas[2], "Name");
  885. //for (int i = 0; i < REORDER_data.Rows.Count; i++)
  886. //{
  887. // double quantity = 0;
  888. // for (int a = 4; a < REORDER_data.Columns.Count; a++)
  889. // {
  890. // if (REORDER_data.Rows[i][a].ToString() != "")
  891. // {
  892. // quantity = quantity + Convert.ToDouble(REORDER_data.Rows[i][a].ToString());
  893. // }
  894. // }
  895. // string str_data = "";
  896. // for (int a = 4; a < REORDER_data.Columns.Count; a++)
  897. // {
  898. // if (REORDER_data.Rows[i][a].ToString() != "")
  899. // {
  900. // str_data = str_data + REORDER_data.Columns[a].ColumnName.ToString() + "=" + elementalAnalysis.ParameterNormalization(quantity, Convert.ToDouble(REORDER_data.Rows[i][a].ToString())) + "%" + " ";
  901. // }
  902. // }
  903. // xrTb_ElementAnalysis.Rows.Add(addElementalAnalysisRows(REORDER_data.Rows[i]["Name"].ToString(), str_data));
  904. //}
  905. //xrTb_ElementAnalysis.LocationF = new PointF(10f, NeueStartposition);
  906. //NeueStartposition = xrTb_ElementAnalysis.LocationF.Y + xrTb_ElementAnalysis.SizeF.Height + 10;
  907. }
  908. private XRTableRow addElementalAnalysisRows(string className, string data)
  909. {
  910. XRTableRow row = new XRTableRow();
  911. XRTableCell tCell_class = new XRTableCell();
  912. XRTableCell tCell_data = new XRTableCell();
  913. tCell_class.Text = className;
  914. tCell_class.WidthF = 116.29f;
  915. tCell_data.Text = data;
  916. tCell_data.WidthF = 551.71f;
  917. row.Controls.Add(tCell_class);
  918. row.Controls.Add(tCell_data);
  919. return row;
  920. }
  921. private XRTableRow AddInclusionIndex(DataTable a_data,string a_str)
  922. {
  923. XRTableRow row = new XRTableRow();
  924. XRTableCell tCell_Name = new XRTableCell();
  925. XRTableCell tCell_Text = new XRTableCell();
  926. XRTableCell tCell_Notes = new XRTableCell();
  927. string name = "";
  928. string notes = "";
  929. for (int i=0;i< a_data.Rows.Count;i++)
  930. {
  931. if (languageData.Rows[i]["Name"].ToString()== "tCell_Name")
  932. {
  933. name = languageData.Rows[i]["Text"].ToString();
  934. }
  935. if (languageData.Rows[i]["Name"].ToString() == "tCell_Notes")
  936. {
  937. notes = languageData.Rows[i]["Text"].ToString();
  938. }
  939. }
  940. tCell_Name.Font = new Font(Schriftart_chinese, tCell_Name.Font.Size);
  941. tCell_Name.Text = name;
  942. tCell_Name.WidthF = 157.5f;
  943. tCell_Text.Font = new Font(Schriftart_chinese, tCell_Text.Font.Size);
  944. tCell_Text.Text = a_str;
  945. tCell_Text.WidthF = 157.5f;
  946. tCell_Notes.Font = new Font(Schriftart_chinese, tCell_Notes.Font.Size);
  947. tCell_Notes.Text = notes;
  948. tCell_Notes.WidthF = 315f;
  949. row.Cells.Add(tCell_Name);
  950. row.Cells.Add(tCell_Text);
  951. row.Cells.Add(tCell_Notes);
  952. row.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  953. return row;
  954. }
  955. private void add_SetINCAtableS(DataTable a_data)
  956. {
  957. XRTable xRTable = add_IncaDormS();
  958. List<List<AreaOfInclusionDEVData>> list_AreaOfInclusion = new List<List<AreaOfInclusionDEVData>>();
  959. for (int i = 0; i < a_data.Rows.Count; i++)
  960. {
  961. list_AreaOfInclusion.Add(set_AreaOfInclusion(subscript.Getsubscriptstring(a_data.Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(a_data.Rows[i]["subdivision"].ToString()), a_data.Rows[i]["Area"].ToString(), a_data.Rows[i]["inca_proportion"].ToString(),
  962. a_data.Rows[i]["inca_FieldRatio"].ToString()));
  963. }
  964. for (int i = 0; i < a_data.Rows.Count; i++)
  965. {
  966. XRTableRow row = new XRTableRow();
  967. XRTableCell tCell_classify = new XRTableCell();
  968. XRTableCell tCell_subdivision = new XRTableCell();
  969. XRTableCell tCell_area = new XRTableCell();
  970. XRTableCell tCell_inca_proportion = new XRTableCell();
  971. XRTableCell tCell_inca_FieldRatio = new XRTableCell();
  972. XRTableCellData_AreaOfInclusion(row, tCell_classify, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "classify");
  973. XRTableCellData_AreaOfInclusion(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "subdivision");
  974. XRTableCellData_AreaOfInclusion(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "Area");
  975. XRTableCellData_AreaOfInclusion(row, tCell_inca_proportion, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_proportion");
  976. XRTableCellData_AreaOfInclusion(row, tCell_inca_FieldRatio, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_FieldRatio");
  977. xRTable.Rows.Add(row);
  978. }
  979. xRTable.LocationF = new PointF(10f, NeueStartposition);
  980. NeueStartposition = xRTable.LocationF.Y + xRTable.SizeF.Height;
  981. this.Detail.Controls.Add(xRTable);
  982. }
  983. private void add_SetINCAtable(DataTable a_data)
  984. {
  985. XRTable xRTable = add_IncaDorm();
  986. int ls = 0;
  987. DataTable REORDER_data = REORDER(a_data, "subdivision");
  988. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  989. {
  990. if (REORDER_data.Rows[i]["subdivision"].ToString() == "" || REORDER_data.Rows[i]["subdivision"].ToString() == null)
  991. {
  992. ls = i;
  993. continue;
  994. }
  995. }
  996. REORDER_data.Rows[ls].Delete();
  997. REORDER_data.AcceptChanges();
  998. List<List<AreaOfInclusionDEVData>> list_AreaOfInclusion = new List<List<AreaOfInclusionDEVData>>();
  999. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  1000. {
  1001. list_AreaOfInclusion.Add(set_AreaOfInclusion(subscript.Getsubscriptstring(REORDER_data.Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(REORDER_data.Rows[i]["subdivision"].ToString()), REORDER_data.Rows[i]["Area"].ToString(), REORDER_data.Rows[i]["inca_proportion"].ToString(),
  1002. REORDER_data.Rows[i]["inca_FieldRatio"].ToString()));
  1003. }
  1004. for (int i = 0; i < REORDER_data.Rows.Count; i++)
  1005. {
  1006. XRTableRow row = new XRTableRow();
  1007. XRTableCell tCell_subdivision = new XRTableCell();
  1008. XRTableCell tCell_area = new XRTableCell();
  1009. XRTableCell tCell_inca_proportion = new XRTableCell();
  1010. XRTableCell tCell_inca_FieldRatio = new XRTableCell();
  1011. XRTableCellData_AreaOfInclusion(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "subdivision");
  1012. XRTableCellData_AreaOfInclusion(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "Area");
  1013. XRTableCellData_AreaOfInclusion(row, tCell_inca_proportion, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_proportion");
  1014. XRTableCellData_AreaOfInclusion(row, tCell_inca_FieldRatio, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_FieldRatio");
  1015. xRTable.Rows.Add(row);
  1016. }
  1017. xRTable.LocationF = new PointF(10f, NeueStartposition);
  1018. NeueStartposition = xRTable.LocationF.Y + xRTable.SizeF.Height;
  1019. this.Detail.Controls.Add(xRTable);
  1020. }
  1021. /// <summary>
  1022. /// 设置插入夹杂物面积比表数据
  1023. /// </summary>
  1024. /// <param name="TemplateClass"></param>
  1025. public void setINCAtable()
  1026. {
  1027. InclusionProportion inclusionProportion = new InclusionProportion();
  1028. DataTable dt = inclusionProportion.GetINCAtable(FieldOfViewArea, m_otsreport_export, TemplateClass);
  1029. if (inclusionProportion.IsThereAMajorClassification(m_otsreport_export))
  1030. add_SetINCAtableS(dt);
  1031. else
  1032. add_SetINCAtable(dt);
  1033. }
  1034. public void XRPageBreak()
  1035. {
  1036. XRPageBreak xRPage = new XRPageBreak();
  1037. xRPage.Name = "kllb_Page";
  1038. xRPage.LocationF = new PointF(0, NeueStartposition);
  1039. this.Detail.Controls.Add(xRPage);
  1040. NeueStartposition = xRPage.LocationF.Y + xRPage.HeightF + 1;
  1041. }
  1042. /// <summary>
  1043. /// 设置插入夹杂物面积比图像
  1044. /// </summary>
  1045. /// <param name="TemplateClass"></param>
  1046. public void set_incaPIC_classify()
  1047. {
  1048. InclusionProportion inclusionProportion = new InclusionProportion();
  1049. DataTable data = inclusionProportion.Get_incaPIC_classify(dev_sczs_text.Text, TemplateClass, m_otsreport_export);
  1050. if (data.Rows.Count == 0)
  1051. {
  1052. return;
  1053. }
  1054. xrLabel_inca_pic_class.Visible = true;
  1055. xrLabel_inca_pic_class.LocationF = new PointF(xrLabel_inca_pic_class.LocationF.X, NeueStartposition);
  1056. NeueStartposition = xrLabel_inca_pic_class.LocationF.Y + xrLabel_inca_pic_class.SizeF.Height + 1;
  1057. for (int i = 0; i < data.Rows.Count; i++)
  1058. {
  1059. if (data.Rows[i]["Class"].ToString() == "Other")
  1060. {
  1061. data.Rows[i].Delete();
  1062. }
  1063. }
  1064. data.AcceptChanges();
  1065. DataView dv = data.DefaultView;
  1066. dv.Sort = "Cunt DESC";
  1067. DataTable dt_data = dv.ToTable();
  1068. for (int i = 0; i < dt_data.Rows.Count; i++)
  1069. {
  1070. dt_data.Rows[i]["Class"] = subscript.Getsubscriptstring(dt_data.Rows[i]["Class"].ToString());
  1071. }
  1072. // 实例化饼图对象
  1073. Series pieSeriesClass = new Series("夹杂物面积比分类", ViewType.Pie);
  1074. pieSeriesClass.ArgumentScaleType = ScaleType.Qualitative;
  1075. // 项目名称
  1076. pieSeriesClass.ArgumentDataMember = "Class";
  1077. pieSeriesClass.ValueScaleType = ScaleType.Numerical;
  1078. //取值字段
  1079. pieSeriesClass.ValueDataMembers.AddRange(new string[] { "Cunt" });
  1080. (pieSeriesClass.Label as PieSeriesLabel).Position = PieSeriesLabelPosition.Inside;
  1081. //显示百分比
  1082. pieSeriesClass.PointOptions.PointView = PointView.ArgumentAndValues;
  1083. pieSeriesClass.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
  1084. //设置数据源
  1085. pieSeriesClass.DataSource = dt_data;
  1086. pieSeriesClass.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
  1087. // 饼图空间添加 新建的饼图对象
  1088. xrChart_incaClass.Series.Add(pieSeriesClass);
  1089. //右上角分组视图
  1090. this.xrChart_incaClass.Legend.MarkerSize = new System.Drawing.Size(20, 20);
  1091. this.xrChart_incaClass.Legend.TextOffset = 5;
  1092. this.xrChart_incaClass.Legend.VerticalIndent = 5;
  1093. this.xrChart_incaClass.Legend.Border.Color = Color.Red;//红色边框
  1094. xrChart_incaClass.Visible = true;
  1095. xrChart_incaClass.LocationF = new PointF(30f, NeueStartposition);
  1096. NeueStartposition = xrChart_incaClass.LocationF.Y + xrChart_incaClass.SizeF.Height + 1;
  1097. }
  1098. public void set_incaPIC_subdivision()
  1099. {
  1100. InclusionProportion inclusionProportion = new InclusionProportion();
  1101. DataTable data = inclusionProportion.Get_incaPIC_subdivision(TemplateClass, m_otsreport_export);
  1102. if(data.Rows.Count==0)
  1103. {
  1104. return;
  1105. }
  1106. xrChart_incaSubdivision.Visible = true;
  1107. xrLabel_inca_pic_subdivision.Visible = true;
  1108. xrLabel_inca_pic_subdivision.LocationF = new PointF(xrLabel_inca_pic_subdivision.LocationF.X, NeueStartposition);
  1109. NeueStartposition = xrLabel_inca_pic_subdivision.LocationF.Y + xrLabel_inca_pic_subdivision.Height + 1;
  1110. for (int i = 0; i < data.Rows.Count; i++)
  1111. {
  1112. if (data.Rows[i]["TypeName"].ToString() == "Not Identified")
  1113. {
  1114. data.Rows[i].Delete();
  1115. }
  1116. }
  1117. data.AcceptChanges();
  1118. DataView dv = data.DefaultView;
  1119. dv.Sort = "con DESC";
  1120. DataTable dt_data = dv.ToTable();
  1121. for (int i = 0; i < dt_data.Rows.Count; i++)
  1122. {
  1123. dt_data.Rows[i]["TypeName"] = subscript.Getsubscriptstring(dt_data.Rows[i]["TypeName"].ToString());
  1124. dt_data.Rows[i]["GroupName"] = subscript.Getsubscriptstring(dt_data.Rows[i]["GroupName"].ToString());
  1125. }
  1126. // 实例化饼图对象
  1127. Series pieSeriesClass = new Series("夹杂物面积比细分类", ViewType.Pie);
  1128. pieSeriesClass.ArgumentScaleType = ScaleType.Qualitative;
  1129. // 项目名称
  1130. pieSeriesClass.ArgumentDataMember = "TypeName";
  1131. pieSeriesClass.ValueScaleType = ScaleType.Numerical;
  1132. //取值字段
  1133. pieSeriesClass.ValueDataMembers.AddRange(new string[] { "con" });
  1134. (pieSeriesClass.Label as PieSeriesLabel).Position = PieSeriesLabelPosition.Inside;
  1135. //显示百分比
  1136. pieSeriesClass.PointOptions.PointView = PointView.ArgumentAndValues;
  1137. pieSeriesClass.PointOptions.ValueNumericOptions.Format = NumericFormat.Percent;
  1138. //设置数据源
  1139. pieSeriesClass.DataSource = dt_data;
  1140. pieSeriesClass.LabelsVisibility = DevExpress.Utils.DefaultBoolean.False;
  1141. // 饼图空间添加 新建的饼图对象
  1142. xrChart_incaSubdivision.Series.Add(pieSeriesClass);
  1143. //右上角分组视图
  1144. this.xrChart_incaSubdivision.Legend.MarkerSize = new System.Drawing.Size(20, 20);
  1145. this.xrChart_incaSubdivision.Legend.TextOffset = 5;
  1146. this.xrChart_incaSubdivision.Legend.VerticalIndent = 5;
  1147. this.xrChart_incaSubdivision.Legend.Border.Color = Color.Red;//红色边框
  1148. xrChart_incaSubdivision.LocationF = new PointF(30f, NeueStartposition);
  1149. NeueStartposition = xrChart_incaSubdivision.LocationF.Y + xrChart_incaSubdivision.Height + 1;
  1150. }
  1151. public static Color FromHex(string hex)
  1152. {
  1153. hex = hex.Replace("#", ""); // 移除 # 前缀
  1154. byte a = 255; // 默认Alpha值为255(不透明)
  1155. byte r = Convert.ToByte(hex.Substring(0, 2), 16);
  1156. byte g = Convert.ToByte(hex.Substring(2, 2), 16);
  1157. byte b = Convert.ToByte(hex.Substring(4, 2), 16);
  1158. return Color.FromArgb(a, r, g, b);
  1159. }
  1160. /// <summary>
  1161. /// 三元图
  1162. /// </summary>
  1163. /// <param name="TemplateClass"></param>
  1164. public void InsertReportTemplateChart_Trianglediagram()
  1165. {
  1166. this.Detail.Controls.Add(add_label(GetlanguageData("dev_Ternary_diagram", languageData, "三元图")));
  1167. List<Color> Color_list = new List<Color>();
  1168. Color_list.Add(FromHex("#0f4471"));
  1169. Color_list.Add(FromHex("#FFD700"));
  1170. Color_list.Add(FromHex("#ff5722"));
  1171. Color_list.Add(FromHex("#5628b4"));
  1172. Color_list.Add(FromHex("#20BF55"));
  1173. Color_list.Add(FromHex("#f23557"));
  1174. Color_list.Add(FromHex("#118df0"));
  1175. Color_list.Add(FromHex("#FF00FF"));
  1176. Color_list.Add(FromHex("#d3327b"));
  1177. Color_list.Add(FromHex("#ae318a"));
  1178. Color_list.Add(FromHex("#993090"));
  1179. Color_list.Add(FromHex("#6f3071"));
  1180. Color_list.Add(FromHex("#7711AF"));
  1181. Color_list.Add(FromHex("#CF77FF"));
  1182. Color_list.Add(FromHex("#AE004F"));
  1183. Color_list.Add(FromHex("#F35872"));
  1184. Color_list.Add(FromHex("#FA7729"));
  1185. Color_list.Add(FromHex("#FFC526"));
  1186. Color_list.Add(FromHex("#F8E71C"));
  1187. Color_list.Add(FromHex("#34ADAE"));
  1188. Color_list.Add(FromHex("#3DDFD2"));
  1189. Color_list.Add(FromHex("#A0FFFF"));
  1190. TernaryDiagram ternaryDiagram = new TernaryDiagram();
  1191. for (int i = 0; i < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count; i = i + 4)
  1192. {
  1193. var xRPicture = set_syt_pic_legend(Color_list, i, ternaryDiagram);
  1194. if (i < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
  1195. {
  1196. set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i], Color_list, new PointF(10f, NeueStartposition), ternaryDiagram);
  1197. }
  1198. if (i + 1 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
  1199. {
  1200. set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 1], Color_list, new PointF(343.8f, NeueStartposition), ternaryDiagram);
  1201. }
  1202. if (i + 2 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
  1203. {
  1204. set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 2], Color_list, new PointF(10f, NeueStartposition + 345), ternaryDiagram);
  1205. }
  1206. if (i + 3 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
  1207. {
  1208. set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 3], Color_list, new PointF(343.8f, NeueStartposition + 345), ternaryDiagram);
  1209. }
  1210. XRLine rLine = new XRLine();
  1211. rLine.SizeF = new SizeF(5f, 698.5f);
  1212. rLine.LineDirection = LineDirection.Vertical;
  1213. rLine.LocationF = new PointF(335f, NeueStartposition + 2);
  1214. this.Detail.Controls.Add(rLine);
  1215. XRLine rLine_level = new XRLine();
  1216. rLine_level.SizeF = new SizeF(668f, 5f);
  1217. rLine_level.LineDirection = LineDirection.Horizontal;
  1218. rLine_level.LocationF = new PointF(10f, NeueStartposition + 345);
  1219. this.Detail.Controls.Add(rLine_level);
  1220. XRPageBreak xRPage = new XRPageBreak();
  1221. xRPage.LocationF = new PointF(0, NeueStartposition + 850);
  1222. this.Detail.Controls.Add(xRPicture);
  1223. NeueStartposition = NeueStartposition + 870;
  1224. this.Detail.Controls.Add(xRPage);
  1225. }
  1226. }
  1227. /// <summary>
  1228. /// 颗粒列表
  1229. /// </summary>
  1230. /// <param name="TemplateClass"></param>
  1231. public void set_kllb_data()
  1232. {
  1233. XRPageBreak xRPage = new XRPageBreak();
  1234. xRPage.Name = "kllb_Page";
  1235. xRPage.LocationF = new PointF(0, NeueStartposition);
  1236. this.Detail.Controls.Add(xRPage);
  1237. xrTable_kllb_surface.LocationF = new PointF(0, NeueStartposition + 5);
  1238. xrTable_kllb_surface.Visible = true;
  1239. NeueStartposition = xrTable_kllb_surface.LocationF.Y + xrTable_kllb_surface.SizeF.Height;
  1240. setXRLabelData(xrTable_kllb, GetlanguageData("dev_Particle_List", languageData, "颗粒列表"));
  1241. setXRLabelData(xrTableCell2, "Selected particles based on:" + TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString() + "(μm)");
  1242. ParticleList particleList = new ParticleList();
  1243. DataTable dataTable = particleList.Get_dev_kllb_data(TemplateClass, m_otsreport_export,out DataTable data ,out List<DataTable> ElementIcons);
  1244. FrameData = data.Copy();
  1245. for (int i = 0; i < dataTable.Rows.Count; i++)
  1246. {
  1247. dataTable.Rows[i]["Class"] = subscript.Getsubscriptstring(dataTable.Rows[i]["Class"].ToString());
  1248. }
  1249. for (int i = 0; i < dataTable.Rows.Count; i++)
  1250. {
  1251. XRTable table = add_XRTable();
  1252. add_kllb(TemplateClass, dataTable, i, table, ElementIcons[i]);
  1253. }
  1254. NeueStartposition = NeueStartposition + 10;
  1255. }
  1256. /// <summary>
  1257. /// 颗粒列表 帧图
  1258. /// </summary>
  1259. /// <param name="TemplateClass"></param>
  1260. public void set_kllb_data_frame()
  1261. {
  1262. ParticleList particleList = new ParticleList();
  1263. particleList.Get_dev_kllb_data_frame(TemplateClass, out DataTable dt_pic, out List<DataTable> listData, m_otsreport_export, FrameData);
  1264. for (int i = 0; i < listData.Count; i++)
  1265. {
  1266. for (int a = 0; a < listData[i].Rows.Count; a++)
  1267. {
  1268. listData[i].Rows[a]["Class"] = subscript.Getsubscriptstring(listData[i].Rows[a]["Class"].ToString());
  1269. }
  1270. }
  1271. for (int i = 0; i < dt_pic.Rows.Count; i++)
  1272. {
  1273. //分页符
  1274. XRPageBreak xRPage = new XRPageBreak();
  1275. xRPage.Name = "framePage_" + i.ToString();
  1276. xRPage.LocationF = new PointF(0, NeueStartposition);
  1277. NeueStartposition = NeueStartposition + 10;
  1278. this.Detail.Controls.Add(xRPage);
  1279. //表头
  1280. XRTable Template = new XRTable();
  1281. XRTableRow Template_Rows_1 = new XRTableRow();
  1282. XRTableRow Template_Rows_2 = new XRTableRow();
  1283. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1284. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1285. Template_Rows1_Cell_1.WidthF = 688f;
  1286. Template_Rows2_Cell_1.WidthF = 688f;
  1287. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1288. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1289. Template.Rows.Add(Template_Rows_1);
  1290. Template.Rows.Add(Template_Rows_2);
  1291. Template.SizeF = new SizeF(688f, 25f);
  1292. Template.Rows[0].Cells[0].Text = GetlanguageData("dev_Frame_diagram", languageData, "帧图") + dt_pic.Rows[i]["id"];
  1293. Template.LocationF = new PointF(0, NeueStartposition);
  1294. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1295. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1296. Template.Rows[0].Font = new Font(Schriftart_chinese, 14f, FontStyle.Regular);
  1297. Template.Rows[0].BackColor = Color.DarkGray;
  1298. this.Detail.Controls.Add(Template);
  1299. //图片
  1300. XRPictureBox xRPicture = new XRPictureBox();
  1301. xRPicture.Name = "frameName_" + i.ToString();
  1302. xRPicture.SizeF = new SizeF(688f, 485f);
  1303. xRPicture.ImageAlignment = DevExpress.XtraPrinting.ImageAlignment.MiddleCenter;
  1304. xRPicture.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
  1305. ImageSource imageSource = new ImageSource((Bitmap)dt_pic.Rows[i]["Field_pic"]);
  1306. xRPicture.ImageSource = imageSource;
  1307. xRPicture.LocationF = new PointF(0, NeueStartposition + Template.SizeF.Height);
  1308. xRPicture.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1309. this.Detail.Controls.Add(xRPicture);
  1310. NeueStartposition = NeueStartposition + xRPicture.SizeF.Height + Template.SizeF.Height;
  1311. for (int a = 0; a < listData.Count; a++)
  1312. {
  1313. if (dt_pic.Rows[i]["id"].ToString() == listData[a].Rows[0]["FieldId"].ToString())
  1314. {
  1315. for (int b = 0; b < listData[a].Rows.Count; b++)
  1316. {
  1317. //数据表
  1318. XRTable xRTable = add_XRTable_frame();
  1319. xRTable.Rows[0].Cells[0].Text = GetlanguageData("dev_image", languageData, "图像");
  1320. xRTable.Rows[0].Cells[0].Font = new Font(Schriftart_chinese, xRTable.Rows[0].Cells[0].Font.Size);
  1321. xRTable.Rows[0].Cells[1].Text = GetlanguageData("dev_Class", languageData, "分类");
  1322. xRTable.Rows[0].Cells[1].Font = new Font(Schriftart_chinese, xRTable.Rows[0].Cells[1].Font.Size);
  1323. xRTable.Rows[0].Cells[2].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString();
  1324. xRTable.Rows[0].Cells[3].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p2.ToString();
  1325. xRTable.Rows[1].Cells[1].Text = listData[a].Rows[b]["Class"].ToString();
  1326. xRTable.Rows[1].Cells[2].Text = listData[a].Rows[b]["pid"].ToString();
  1327. xRTable.Rows[1].Cells[3].Text = listData[a].Rows[b]["Size"].ToString();
  1328. for (int c = 1; c < 10; c++)
  1329. {
  1330. xRTable.Rows[2].Cells[c].Text = listData[a].Rows[b]["ColName" + (c).ToString()].ToString();
  1331. xRTable.Rows[3].Cells[c].Text = listData[a].Rows[b]["ColVal" + (c).ToString()].ToString();
  1332. }
  1333. xRTable.LocationF = new PointF(0, NeueStartposition);
  1334. XRPictureBox xRPicture1 = new XRPictureBox();
  1335. xRPicture1.ImageSource = new ImageSource((Bitmap)listData[a].Rows[b]["pic"]);
  1336. xRPicture1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
  1337. xRPicture1.SizeF = new SizeF(94, 70);
  1338. xRPicture1.LocationF = new PointF(0, NeueStartposition + 20);
  1339. this.Detail.Controls.Add(xRTable);
  1340. this.Detail.Controls.Add(xRPicture1);
  1341. NeueStartposition = NeueStartposition + xRTable.SizeF.Height + 1;
  1342. }
  1343. }
  1344. }
  1345. }
  1346. }
  1347. #endregion
  1348. private void setXRLabelData(XRLabel cell, string str)
  1349. {
  1350. cell.Text = str;
  1351. cell.Font = new Font(Schriftart_chinese, cell.Font.Size);
  1352. }
  1353. /// <summary>
  1354. /// 读取报告控件中英文
  1355. /// </summary>
  1356. /// <param name="strName"></param>
  1357. /// <param name="languageData"></param>
  1358. /// <returns></returns>
  1359. private string GetlanguageData(string strName, DataTable languageData,string TextName)
  1360. {
  1361. for (int i = 0; i < languageData.Rows.Count; i++)
  1362. {
  1363. if (strName == languageData.Rows[i]["Name"].ToString())
  1364. {
  1365. return languageData.Rows[i]["Text"].ToString();
  1366. }
  1367. }
  1368. return TextName;
  1369. }
  1370. #region 整理成DEV需要的数据格式
  1371. private void XRTableCellData(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<ParticleSizeDEVData> switchDEVDatas, string cellName)
  1372. {
  1373. rTableCell.TextAlignment = textAlignment;
  1374. rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
  1375. xR.Cells.Add(rTableCell);
  1376. rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
  1377. }
  1378. private void XRTableCellData_ElementAnalysis(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<ElementalAnalysisDEVData> switchDEVDatas, string cellName)
  1379. {
  1380. rTableCell.TextAlignment = textAlignment;
  1381. rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
  1382. xR.Cells.Add(rTableCell);
  1383. rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
  1384. }
  1385. private void XRTableCellData_AreaOfInclusion(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<AreaOfInclusionDEVData> switchDEVDatas, string cellName)
  1386. {
  1387. rTableCell.TextAlignment = textAlignment;
  1388. rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
  1389. xR.Cells.Add(rTableCell);
  1390. rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
  1391. }
  1392. /// <summary>
  1393. /// 颗粒尺寸表向list中插入数据
  1394. /// </summary>
  1395. /// <param name="Class"></param>
  1396. /// <param name="Name"></param>
  1397. /// <param name="total"></param>
  1398. /// <param name="size_1"></param>
  1399. /// <param name="size_2"></param>
  1400. /// <param name="size_3"></param>
  1401. /// <param name="size_4"></param>
  1402. /// <param name="size_5"></param>
  1403. /// <param name="size_6"></param>
  1404. /// <param name="size_7"></param>
  1405. /// <returns></returns>
  1406. private List<ParticleSizeDEVData> switch_ParticleSize(string Class, string Name, string total, string size_1, string size_2, string size_3, string size_4, string size_5, string size_6, string size_7)
  1407. {
  1408. List<ParticleSizeDEVData> oTS_DEVs = new List<ParticleSizeDEVData>();
  1409. oTS_DEVs.Add(new ParticleSizeDEVData
  1410. {
  1411. size_total = total,
  1412. size_Class = Class,
  1413. size_Name = Name,
  1414. size_1 = size_1,
  1415. size_2 = size_2,
  1416. size_3 = size_3,
  1417. size_4 = size_4,
  1418. size_5 = size_5,
  1419. size_6 = size_6,
  1420. size_7 = size_7
  1421. });
  1422. return oTS_DEVs;
  1423. }
  1424. /// <summary>
  1425. /// 元素分析表向list中插入数据
  1426. /// </summary>
  1427. /// <param name="classify"></param>
  1428. /// <param name="subdivision"></param>
  1429. /// <param name="area"></param>
  1430. /// <param name="s1"></param>
  1431. /// <param name="s2"></param>
  1432. /// <param name="s3"></param>
  1433. /// <param name="s4"></param>
  1434. /// <param name="s5"></param>
  1435. /// <param name="s6"></param>
  1436. /// <param name="s7"></param>
  1437. /// <param name="s8"></param>
  1438. /// <param name="s9"></param>
  1439. /// <param name="s10"></param>
  1440. /// <returns></returns>
  1441. private List<ElementalAnalysisDEVData> set_ElementalAnalysis(string classify, string subdivision, string area, string s1, string s2, string s3, string s4, string s5, string s6, string s7, string s8, string s9, string s10)
  1442. {
  1443. List<ElementalAnalysisDEVData> oTS_DEVs = new List<ElementalAnalysisDEVData>();
  1444. oTS_DEVs.Add(new ElementalAnalysisDEVData
  1445. {
  1446. classify = classify,
  1447. subdivision = subdivision,
  1448. Area = area,
  1449. s1 = s1,
  1450. s2 = s2,
  1451. s3 = s3,
  1452. s4 = s4,
  1453. s5 = s5,
  1454. s6 = s6,
  1455. s7 = s7,
  1456. s8 = s8,
  1457. s9 = s9,
  1458. s10 = s10
  1459. });
  1460. return oTS_DEVs;
  1461. }
  1462. private List<ElementalAnalysisDEVData> set_ElementalAnalysisS( string subdivision, string area, string s1, string s2, string s3, string s4, string s5, string s6, string s7, string s8, string s9, string s10)
  1463. {
  1464. List<ElementalAnalysisDEVData> oTS_DEVs = new List<ElementalAnalysisDEVData>();
  1465. oTS_DEVs.Add(new ElementalAnalysisDEVData
  1466. {
  1467. subdivision = subdivision,
  1468. Area = area,
  1469. s1 = s1,
  1470. s2 = s2,
  1471. s3 = s3,
  1472. s4 = s4,
  1473. s5 = s5,
  1474. s6 = s6,
  1475. s7 = s7,
  1476. s8 = s8,
  1477. s9 = s9,
  1478. s10 = s10
  1479. });
  1480. return oTS_DEVs;
  1481. }
  1482. /// <summary>
  1483. /// 夹杂物分析表(清洁度不需要)
  1484. /// </summary>
  1485. /// <param name="classify"></param>
  1486. /// <param name="subdivision"></param>
  1487. /// <param name="Area"></param>
  1488. /// <param name="inca_proportion"></param>
  1489. /// <param name="inca_FieldRatio"></param>
  1490. /// <returns></returns>
  1491. private List<AreaOfInclusionDEVData> set_AreaOfInclusion(string classify, string subdivision, string Area, string inca_proportion, string inca_FieldRatio)
  1492. {
  1493. List<AreaOfInclusionDEVData> oTS_DEVs = new List<AreaOfInclusionDEVData>();
  1494. oTS_DEVs.Add(new AreaOfInclusionDEVData
  1495. {
  1496. classify = classify,
  1497. subdivision = subdivision,
  1498. Area = Area,
  1499. inca_proportion = inca_proportion,
  1500. inca_FieldRatio = inca_FieldRatio
  1501. });
  1502. return oTS_DEVs;
  1503. }
  1504. #endregion
  1505. #region 三元相图数据
  1506. /// <summary>
  1507. /// 动态生成加载三元图图片加分页符
  1508. /// </summary>
  1509. /// <param name="syt_pic_name"></param>
  1510. /// <param name="syt_Page_name"></param>
  1511. /// <param name="TemplateClass"></param>
  1512. /// <param name="index"></param>
  1513. private void set_syt_pic(c_TemplateClass TemplateClass, int index, List<Color> Color_list, PointF position, TernaryDiagram ternaryDiagram)
  1514. {
  1515. XRPictureBox xRPicture = new XRPictureBox();
  1516. xRPicture.LocationF = position;
  1517. xRPicture.SizeF = new SizeF(321f, 330.2f);
  1518. ImageSource imageSource = new ImageSource(ternaryDiagram.DrawATernaryPicture(index, TemplateClass, Color_list,m_otsreport_export, PartSizeFile));
  1519. xRPicture.ImageSource = imageSource;
  1520. xRPicture.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
  1521. xRPicture.Visible = true;
  1522. this.Detail.Controls.Add(xRPicture);
  1523. }
  1524. private XRPictureBox set_syt_pic_legend(List<Color> Color_list, int i, TernaryDiagram ternaryDiagram)
  1525. {
  1526. XRPictureBox xRPicture_legend = new XRPictureBox();
  1527. xRPicture_legend.Name = "XRPicture" + i.ToString();
  1528. xRPicture_legend.LocationF = new PointF(400f, NeueStartposition);
  1529. xRPicture_legend.SizeF = new SizeF(260f, 120f);
  1530. xRPicture_legend.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
  1531. ImageSource imageSource_legend = new ImageSource(ternaryDiagram.DrawATernaryDiagramLegend(Color_list,m_otsreport_export, PartSizeFile));
  1532. xRPicture_legend.ImageSource = imageSource_legend;
  1533. NeueStartposition = xRPicture_legend.LocationF.Y + xRPicture_legend.SizeF.Height;
  1534. return xRPicture_legend;
  1535. }
  1536. #endregion
  1537. private XRTable add_label(string str)
  1538. {
  1539. XRTable Template = new XRTable();
  1540. XRTableRow Template_Rows_1 = new XRTableRow();
  1541. XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
  1542. Template_Rows1_Cell_2.WidthF = 630f;
  1543. setXRLabelData(Template_Rows1_Cell_2, str);
  1544. //Template_Rows1_Cell_2.Text = str;
  1545. Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
  1546. Template.Rows.Add(Template_Rows_1);
  1547. Template.WidthF = 630f;
  1548. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1549. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1550. Template.LocationF = new PointF(30.42f, NeueStartposition);
  1551. Template.BackColor = Color.DarkGray;
  1552. NeueStartposition = Template.LocationF.Y + Template.SizeF.Height;
  1553. return Template;
  1554. }
  1555. /// <summary>
  1556. /// 颗粒尺寸无大分类表格式
  1557. /// </summary>
  1558. /// <returns></returns>
  1559. private XRTable add_particleSize()
  1560. {
  1561. XRTable Template = new XRTable();
  1562. XRTableRow Template_Rows_1 = new XRTableRow();
  1563. XRTableRow Template_Rows_2 = new XRTableRow();
  1564. XRTableRow Template_Rows_3 = new XRTableRow();
  1565. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1566. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1567. XRTableCell Template_Rows3_Cell_1 = new XRTableCell();
  1568. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  1569. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  1570. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  1571. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  1572. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  1573. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  1574. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  1575. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  1576. Template_Rows1_Cell_1.WidthF = 668f;
  1577. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1578. Template_Rows2_Cell_1.WidthF = 668f;
  1579. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1580. Template_Rows3_Cell_1.WidthF = 100f;
  1581. Template_Rows3_Cell_2.WidthF = 55;
  1582. Template_Rows3_Cell_3.WidthF = 59;
  1583. Template_Rows3_Cell_4.WidthF = 59;
  1584. Template_Rows3_Cell_5.WidthF = 59;
  1585. Template_Rows3_Cell_6.WidthF = 59;
  1586. Template_Rows3_Cell_7.WidthF = 59;
  1587. Template_Rows3_Cell_8.WidthF = 59;
  1588. Template_Rows3_Cell_9.WidthF = 59;
  1589. Template_Rows_3.Controls.Add(Template_Rows3_Cell_1);
  1590. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  1591. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  1592. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  1593. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  1594. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  1595. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  1596. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  1597. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  1598. Template.Rows.Add(Template_Rows_1);
  1599. Template.Rows.Add(Template_Rows_2);
  1600. Template.Rows.Add(Template_Rows_3);
  1601. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1602. Template.SizeF = new SizeF(668f, Template.SizeF.Height);
  1603. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1604. Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1605. Template.Rows[0].BackColor = Color.DarkGray;
  1606. return Template;
  1607. }
  1608. /// <summary>
  1609. /// 颗粒尺寸无大分类表格式 总结
  1610. /// </summary>
  1611. /// <returns></returns>
  1612. private XRTable add_particleSize_end()
  1613. {
  1614. XRTable Template = new XRTable();
  1615. XRTableRow Template_Rows_1 = new XRTableRow();
  1616. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1617. XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
  1618. XRTableCell Template_Rows1_Cell_3 = new XRTableCell();
  1619. XRTableCell Template_Rows1_Cell_4 = new XRTableCell();
  1620. XRTableCell Template_Rows1_Cell_5 = new XRTableCell();
  1621. XRTableCell Template_Rows1_Cell_6 = new XRTableCell();
  1622. XRTableCell Template_Rows1_Cell_7 = new XRTableCell();
  1623. XRTableCell Template_Rows1_Cell_8 = new XRTableCell();
  1624. XRTableCell Template_Rows1_Cell_9 = new XRTableCell();
  1625. Template_Rows1_Cell_1.WidthF = 100;
  1626. Template_Rows1_Cell_2.WidthF = 55f;
  1627. Template_Rows1_Cell_3.WidthF = 59f;
  1628. Template_Rows1_Cell_4.WidthF = 59f;
  1629. Template_Rows1_Cell_5.WidthF = 59f;
  1630. Template_Rows1_Cell_6.WidthF = 59f;
  1631. Template_Rows1_Cell_7.WidthF = 59f;
  1632. Template_Rows1_Cell_8.WidthF = 59f;
  1633. Template_Rows1_Cell_9.WidthF = 59f;
  1634. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1635. Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
  1636. Template_Rows_1.Controls.Add(Template_Rows1_Cell_3);
  1637. Template_Rows_1.Controls.Add(Template_Rows1_Cell_4);
  1638. Template_Rows_1.Controls.Add(Template_Rows1_Cell_5);
  1639. Template_Rows_1.Controls.Add(Template_Rows1_Cell_6);
  1640. Template_Rows_1.Controls.Add(Template_Rows1_Cell_7);
  1641. Template_Rows_1.Controls.Add(Template_Rows1_Cell_8);
  1642. Template_Rows_1.Controls.Add(Template_Rows1_Cell_9);
  1643. Template.Rows.Add(Template_Rows_1);
  1644. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1645. Template.SizeF = new SizeF(668f, Template.SizeF.Height);
  1646. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1647. //Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1648. return Template;
  1649. }
  1650. /// <summary>
  1651. /// 颗粒尺寸有大分类表格式
  1652. /// </summary>
  1653. /// <returns></returns>
  1654. private XRTable add_particleSizeS()
  1655. {
  1656. XRTable Template = new XRTable();
  1657. XRTableRow Template_Rows_1 = new XRTableRow();
  1658. XRTableRow Template_Rows_2 = new XRTableRow();
  1659. XRTableRow Template_Rows_3 = new XRTableRow();
  1660. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1661. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1662. XRTableCell Template_Rows3_Cell_1 = new XRTableCell();
  1663. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  1664. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  1665. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  1666. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  1667. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  1668. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  1669. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  1670. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  1671. XRTableCell Template_Rows3_Cell_10 = new XRTableCell();
  1672. Template_Rows1_Cell_1.WidthF = 668f;
  1673. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1674. Template_Rows2_Cell_1.WidthF = 668f;
  1675. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1676. Template_Rows3_Cell_1.WidthF = 100f;
  1677. Template_Rows3_Cell_2.WidthF = 100f;
  1678. Template_Rows3_Cell_3.WidthF = 55;
  1679. Template_Rows3_Cell_4.WidthF = 59;
  1680. Template_Rows3_Cell_5.WidthF = 59;
  1681. Template_Rows3_Cell_6.WidthF = 59;
  1682. Template_Rows3_Cell_7.WidthF = 59;
  1683. Template_Rows3_Cell_8.WidthF = 59;
  1684. Template_Rows3_Cell_9.WidthF = 59;
  1685. Template_Rows3_Cell_10.WidthF = 59;
  1686. Template_Rows_3.Controls.Add(Template_Rows3_Cell_1);
  1687. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  1688. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  1689. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  1690. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  1691. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  1692. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  1693. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  1694. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  1695. Template_Rows_3.Controls.Add(Template_Rows3_Cell_10);
  1696. Template.Rows.Add(Template_Rows_1);
  1697. Template.Rows.Add(Template_Rows_2);
  1698. Template.Rows.Add(Template_Rows_3);
  1699. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1700. Template.SizeF = new SizeF(668f, Template.SizeF.Height);
  1701. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1702. Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1703. Template.Rows[0].BackColor = Color.DarkGray;
  1704. return Template;
  1705. }
  1706. /// <summary>
  1707. /// 颗粒尺寸有大分类表格式总结
  1708. /// </summary>
  1709. /// <returns></returns>
  1710. private XRTable add_particleSizeS_end()
  1711. {
  1712. XRTable Template = new XRTable();
  1713. XRTableRow Template_Rows_1 = new XRTableRow();
  1714. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1715. XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
  1716. XRTableCell Template_Rows1_Cell_3 = new XRTableCell();
  1717. XRTableCell Template_Rows1_Cell_4 = new XRTableCell();
  1718. XRTableCell Template_Rows1_Cell_5 = new XRTableCell();
  1719. XRTableCell Template_Rows1_Cell_6 = new XRTableCell();
  1720. XRTableCell Template_Rows1_Cell_7 = new XRTableCell();
  1721. XRTableCell Template_Rows1_Cell_8 = new XRTableCell();
  1722. XRTableCell Template_Rows1_Cell_9 = new XRTableCell();
  1723. Template_Rows1_Cell_1.WidthF = 200f;
  1724. Template_Rows1_Cell_2.WidthF = 55f;
  1725. Template_Rows1_Cell_3.WidthF = 59f;
  1726. Template_Rows1_Cell_4.WidthF = 59f;
  1727. Template_Rows1_Cell_5.WidthF = 59f;
  1728. Template_Rows1_Cell_6.WidthF = 59f;
  1729. Template_Rows1_Cell_7.WidthF = 59f;
  1730. Template_Rows1_Cell_8.WidthF = 59f;
  1731. Template_Rows1_Cell_9.WidthF = 59f;
  1732. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1733. Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
  1734. Template_Rows_1.Controls.Add(Template_Rows1_Cell_3);
  1735. Template_Rows_1.Controls.Add(Template_Rows1_Cell_4);
  1736. Template_Rows_1.Controls.Add(Template_Rows1_Cell_5);
  1737. Template_Rows_1.Controls.Add(Template_Rows1_Cell_6);
  1738. Template_Rows_1.Controls.Add(Template_Rows1_Cell_7);
  1739. Template_Rows_1.Controls.Add(Template_Rows1_Cell_8);
  1740. Template_Rows_1.Controls.Add(Template_Rows1_Cell_9);
  1741. Template.Rows.Add(Template_Rows_1);
  1742. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1743. Template.SizeF = new SizeF(668f, Template.SizeF.Height);
  1744. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1745. //Template.Rows[0].BackColor = Color.DarkGray;
  1746. //Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1747. return Template;
  1748. }
  1749. /// <summary>
  1750. /// 元素分析无大分类
  1751. /// </summary>
  1752. /// <returns></returns>
  1753. private XRTable add_ElementList()
  1754. {
  1755. XRTable Template = new XRTable();
  1756. XRTableRow Template_Rows_1 = new XRTableRow();
  1757. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1758. Template_Rows1_Cell_1.WidthF = 688F;
  1759. Template_Rows1_Cell_1.BackColor = Color.DarkGray;
  1760. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1761. Template.Rows.Add(Template_Rows_1);
  1762. XRTableRow Template_Rows_2 = new XRTableRow();
  1763. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1764. Template_Rows2_Cell_1.WidthF = 688f;
  1765. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1766. Template.Rows.Add(Template_Rows_2);
  1767. XRTableRow Template_Rows_3 = new XRTableRow();
  1768. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  1769. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  1770. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  1771. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  1772. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  1773. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  1774. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  1775. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  1776. XRTableCell Template_Rows3_Cell_10 = new XRTableCell();
  1777. XRTableCell Template_Rows3_Cell_11 = new XRTableCell();
  1778. XRTableCell Template_Rows3_Cell_12 = new XRTableCell();
  1779. XRTableCell Template_Rows3_Cell_13 = new XRTableCell();
  1780. Template_Rows3_Cell_2.WidthF = 69f;
  1781. Template_Rows3_Cell_3.WidthF = 50f;
  1782. Template_Rows3_Cell_4.WidthF = 50f;
  1783. Template_Rows3_Cell_5.WidthF = 50f;
  1784. Template_Rows3_Cell_6.WidthF = 50f;
  1785. Template_Rows3_Cell_7.WidthF = 50f;
  1786. Template_Rows3_Cell_8.WidthF = 50f;
  1787. Template_Rows3_Cell_9.WidthF = 50f;
  1788. Template_Rows3_Cell_10.WidthF = 50f;
  1789. Template_Rows3_Cell_11.WidthF = 50f;
  1790. Template_Rows3_Cell_12.WidthF = 50f;
  1791. Template_Rows3_Cell_13.WidthF = 50f;
  1792. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  1793. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  1794. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  1795. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  1796. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  1797. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  1798. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  1799. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  1800. Template_Rows_3.Controls.Add(Template_Rows3_Cell_10);
  1801. Template_Rows_3.Controls.Add(Template_Rows3_Cell_11);
  1802. Template_Rows_3.Controls.Add(Template_Rows3_Cell_12);
  1803. Template_Rows_3.Controls.Add(Template_Rows3_Cell_13);
  1804. Template.Rows.Add(Template_Rows_3);
  1805. Template.WidthF = 668f;
  1806. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1807. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1808. Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1809. //元素分析表
  1810. setXRLabelData(Template.Rows[0].Cells[0], GetlanguageData("xrCellElementArea", languageData, "元素分析表"));//元素分析表表头
  1811. setXRLabelData(Template.Rows[1].Cells[0], GetlanguageData("xrCellElementArea_details", languageData, "Reported average chemical composition (w %), area(μ m^2)"));//详情
  1812. setXRLabelData(Template.Rows[2].Cells[0], GetlanguageData("xrCell_Element_classify", languageData, "分类"));//细分
  1813. setXRLabelData(Template.Rows[2].Cells[1], GetlanguageData("xrCell_Element_Area", languageData, "面积"));//面积
  1814. return Template;
  1815. }
  1816. /// <summary>
  1817. /// 元素分析有大分类
  1818. /// </summary>
  1819. /// <returns></returns>
  1820. private XRTable add_ElementListS()
  1821. {
  1822. XRTable Template = new XRTable();
  1823. XRTableRow Template_Rows_1 = new XRTableRow();
  1824. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1825. Template_Rows1_Cell_1.WidthF = 688F;
  1826. Template_Rows1_Cell_1.BackColor = Color.DarkGray;
  1827. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1828. Template.Rows.Add(Template_Rows_1);
  1829. XRTableRow Template_Rows_2 = new XRTableRow();
  1830. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1831. Template_Rows2_Cell_1.WidthF = 688f;
  1832. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1833. Template.Rows.Add(Template_Rows_2);
  1834. XRTableRow Template_Rows_3 = new XRTableRow();
  1835. XRTableCell Template_Rows3_Cell_1 = new XRTableCell();
  1836. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  1837. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  1838. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  1839. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  1840. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  1841. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  1842. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  1843. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  1844. XRTableCell Template_Rows3_Cell_10 = new XRTableCell();
  1845. XRTableCell Template_Rows3_Cell_11 = new XRTableCell();
  1846. XRTableCell Template_Rows3_Cell_12 = new XRTableCell();
  1847. XRTableCell Template_Rows3_Cell_13 = new XRTableCell();
  1848. Template_Rows3_Cell_1.WidthF = 69f;
  1849. Template_Rows3_Cell_2.WidthF = 69f;
  1850. Template_Rows3_Cell_3.WidthF = 50f;
  1851. Template_Rows3_Cell_4.WidthF = 50f;
  1852. Template_Rows3_Cell_5.WidthF = 50f;
  1853. Template_Rows3_Cell_6.WidthF = 50f;
  1854. Template_Rows3_Cell_7.WidthF = 50f;
  1855. Template_Rows3_Cell_8.WidthF = 50f;
  1856. Template_Rows3_Cell_9.WidthF = 50f;
  1857. Template_Rows3_Cell_10.WidthF = 50f;
  1858. Template_Rows3_Cell_11.WidthF = 50f;
  1859. Template_Rows3_Cell_12.WidthF = 50f;
  1860. Template_Rows3_Cell_13.WidthF = 50f;
  1861. Template_Rows_3.Controls.Add(Template_Rows3_Cell_1);
  1862. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  1863. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  1864. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  1865. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  1866. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  1867. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  1868. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  1869. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  1870. Template_Rows_3.Controls.Add(Template_Rows3_Cell_10);
  1871. Template_Rows_3.Controls.Add(Template_Rows3_Cell_11);
  1872. Template_Rows_3.Controls.Add(Template_Rows3_Cell_12);
  1873. Template_Rows_3.Controls.Add(Template_Rows3_Cell_13);
  1874. Template.Rows.Add(Template_Rows_3);
  1875. Template.WidthF = 668f;
  1876. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1877. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1878. Template.Rows[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
  1879. //元素分析表
  1880. setXRLabelData(Template.Rows[0].Cells[0], GetlanguageData("xrCellElementArea", languageData, "元素分析表"));//元素分析表表头
  1881. setXRLabelData(Template.Rows[1].Cells[0], GetlanguageData("xrCellElementArea_details", languageData, "Reported average chemical composition (w %), area(μ m^2)"));//详情
  1882. setXRLabelData(Template.Rows[2].Cells[0], GetlanguageData("xrCell_Element_classify", languageData, "分类"));//分类
  1883. setXRLabelData(Template.Rows[2].Cells[1], GetlanguageData("xrCell_Element_subdivision", languageData, "二级分类"));//细分
  1884. setXRLabelData(Template.Rows[2].Cells[2], GetlanguageData("xrCell_Element_Area", languageData, "面积"));//面积
  1885. ////元素分析表————————
  1886. //setXRLabelData(xrTableCell30, GetlanguageData("xrCellElementArea", languageData));//元素分析表表头
  1887. //setXRLabelData(xrTableCell31, GetlanguageData("xrCellElementArea_details", languageData));//详情
  1888. return Template;
  1889. }
  1890. private XRTable add_IncaDorm()
  1891. {
  1892. XRTable Template = new XRTable();
  1893. XRTableRow Template_Rows_1 = new XRTableRow();
  1894. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1895. Template_Rows1_Cell_1.WidthF = 668F;
  1896. Template_Rows1_Cell_1.BackColor = Color.DarkGray;
  1897. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1898. Template.Rows.Add(Template_Rows_1);
  1899. XRTableRow Template_Rows_2 = new XRTableRow();
  1900. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1901. XRTableCell Template_Rows2_Cell_2 = new XRTableCell();
  1902. XRTableCell Template_Rows2_Cell_3 = new XRTableCell();
  1903. XRTableCell Template_Rows2_Cell_4 = new XRTableCell();
  1904. Template_Rows2_Cell_1.WidthF = 133.6f;
  1905. Template_Rows2_Cell_2.WidthF = 133.6f;
  1906. Template_Rows2_Cell_3.WidthF = 133.6f;
  1907. Template_Rows2_Cell_4.WidthF = 133.6f;
  1908. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1909. Template_Rows_2.Controls.Add(Template_Rows2_Cell_2);
  1910. Template_Rows_2.Controls.Add(Template_Rows2_Cell_3);
  1911. Template_Rows_2.Controls.Add(Template_Rows2_Cell_4);
  1912. Template.Rows.Add(Template_Rows_2);
  1913. Template.WidthF = 668f;
  1914. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1915. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1916. setXRLabelData(Template.Rows[0].Cells[0], GetlanguageData("xrCellAreaOfInclusion", languageData, "夹杂物面积比表"));//夹杂物面积比表表头
  1917. setXRLabelData(Template.Rows[1].Cells[0], "分类");//细分类
  1918. setXRLabelData(Template.Rows[1].Cells[1], GetlanguageData("xrCell_inclusion_Area", languageData, "面积(μm^2)"));//面积(μm^2)
  1919. setXRLabelData(Template.Rows[1].Cells[2], GetlanguageData("xrCell_inclusion_percentageOfIncA", languageData, "夹杂物比(%)"));//夹杂物比(%)
  1920. setXRLabelData(Template.Rows[1].Cells[3], GetlanguageData("xrCell_inclusion_FieldRatio", languageData, "视场占比(%)"));//视场占比(%)
  1921. return Template;
  1922. }
  1923. private XRTable add_IncaDormS()
  1924. {
  1925. XRTable Template = new XRTable();
  1926. XRTableRow Template_Rows_1 = new XRTableRow();
  1927. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  1928. Template_Rows1_Cell_1.WidthF = 668F;
  1929. Template_Rows1_Cell_1.BackColor = Color.DarkGray;
  1930. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  1931. Template.Rows.Add(Template_Rows_1);
  1932. XRTableRow Template_Rows_2 = new XRTableRow();
  1933. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  1934. XRTableCell Template_Rows2_Cell_2 = new XRTableCell();
  1935. XRTableCell Template_Rows2_Cell_3 = new XRTableCell();
  1936. XRTableCell Template_Rows2_Cell_4 = new XRTableCell();
  1937. XRTableCell Template_Rows2_Cell_5 = new XRTableCell();
  1938. Template_Rows2_Cell_1.WidthF = 133.6f;
  1939. Template_Rows2_Cell_2.WidthF = 133.6f;
  1940. Template_Rows2_Cell_3.WidthF = 133.6f;
  1941. Template_Rows2_Cell_4.WidthF = 133.6f;
  1942. Template_Rows2_Cell_5.WidthF = 133.6f;
  1943. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  1944. Template_Rows_2.Controls.Add(Template_Rows2_Cell_2);
  1945. Template_Rows_2.Controls.Add(Template_Rows2_Cell_3);
  1946. Template_Rows_2.Controls.Add(Template_Rows2_Cell_4);
  1947. Template_Rows_2.Controls.Add(Template_Rows2_Cell_5);
  1948. Template.Rows.Add(Template_Rows_2);
  1949. Template.WidthF = 668f;
  1950. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  1951. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  1952. setXRLabelData(Template.Rows[0].Cells[0], GetlanguageData("xrCellAreaOfInclusion", languageData, "夹杂物面积比表"));//夹杂物面积比表表头
  1953. setXRLabelData(Template.Rows[1].Cells[0], GetlanguageData("xrCell_inclusion_classify", languageData, "分类"));//分类
  1954. setXRLabelData(Template.Rows[1].Cells[1], GetlanguageData("xrCell_inclusion_subdivision", languageData, "二级分类"));//细分类
  1955. setXRLabelData(Template.Rows[1].Cells[2], GetlanguageData("xrCell_inclusion_Area", languageData, "面积(μm^2)"));//面积(μm^2)
  1956. setXRLabelData(Template.Rows[1].Cells[3], GetlanguageData("xrCell_inclusion_percentageOfIncA", languageData, "夹杂物比(%)"));//夹杂物比(%)
  1957. setXRLabelData(Template.Rows[1].Cells[4], GetlanguageData("xrCell_inclusion_FieldRatio", languageData, "视场占比(%)"));//视场占比(%)
  1958. return Template;
  1959. }
  1960. #region 颗粒列表
  1961. private XRTable add_XRTable()
  1962. {
  1963. XRTable Template = new XRTable();
  1964. XRTableRow Template_Rows_1 = new XRTableRow();
  1965. XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
  1966. XRTableCell Template_Rows1_Cell_3 = new XRTableCell();
  1967. XRTableCell Template_Rows1_Cell_4 = new XRTableCell();
  1968. XRTableCell Template_Rows1_Cell_5 = new XRTableCell();
  1969. XRTableCell Template_Rows1_Cell_6 = new XRTableCell();
  1970. XRTableRow Template_Rows_2 = new XRTableRow();
  1971. XRTableCell Template_Rows2_Cell_2 = new XRTableCell();
  1972. XRTableCell Template_Rows2_Cell_3 = new XRTableCell();
  1973. XRTableCell Template_Rows2_Cell_4 = new XRTableCell();
  1974. XRTableCell Template_Rows2_Cell_5 = new XRTableCell();
  1975. XRTableCell Template_Rows2_Cell_6 = new XRTableCell();
  1976. XRTableRow Template_Rows_3 = new XRTableRow();
  1977. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  1978. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  1979. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  1980. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  1981. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  1982. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  1983. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  1984. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  1985. XRTableCell Template_Rows3_Cell_10 = new XRTableCell();
  1986. XRTableCell Template_Rows3_Cell_11 = new XRTableCell();
  1987. XRTableRow Template_Rows_4 = new XRTableRow();
  1988. XRTableCell Template_Rows4_Cell_2 = new XRTableCell();
  1989. XRTableCell Template_Rows4_Cell_3 = new XRTableCell();
  1990. XRTableCell Template_Rows4_Cell_4 = new XRTableCell();
  1991. XRTableCell Template_Rows4_Cell_5 = new XRTableCell();
  1992. XRTableCell Template_Rows4_Cell_6 = new XRTableCell();
  1993. XRTableCell Template_Rows4_Cell_7 = new XRTableCell();
  1994. XRTableCell Template_Rows4_Cell_8 = new XRTableCell();
  1995. XRTableCell Template_Rows4_Cell_9 = new XRTableCell();
  1996. XRTableCell Template_Rows4_Cell_10 = new XRTableCell();
  1997. XRTableCell Template_Rows4_Cell_11 = new XRTableCell();
  1998. XRTableRow Template_Rows_5 = new XRTableRow();
  1999. XRTableCell Template_Rows5_Cell_1 = new XRTableCell();
  2000. XRTableCell Template_Rows5_Cell_2 = new XRTableCell();
  2001. XRTableCell Template_Rows5_Cell_3 = new XRTableCell();
  2002. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  2003. Template_Rows1_Cell_2.WidthF = 57.22f;
  2004. Template_Rows1_Cell_3.WidthF = 256f;
  2005. Template_Rows1_Cell_4.WidthF = 85.85f;
  2006. Template_Rows1_Cell_5.WidthF = 85.85f;
  2007. Template_Rows1_Cell_6.WidthF = 85.85f;
  2008. Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
  2009. Template_Rows_1.Controls.Add(Template_Rows1_Cell_3);
  2010. Template_Rows_1.Controls.Add(Template_Rows1_Cell_4);
  2011. Template_Rows_1.Controls.Add(Template_Rows1_Cell_5);
  2012. Template_Rows_1.Controls.Add(Template_Rows1_Cell_6);
  2013. Template_Rows2_Cell_2.WidthF = 57.22f;
  2014. Template_Rows2_Cell_3.WidthF = 256f;
  2015. Template_Rows2_Cell_4.WidthF = 85.85f;
  2016. Template_Rows2_Cell_5.WidthF = 85.85f;
  2017. Template_Rows2_Cell_6.WidthF = 85.85f;
  2018. Template_Rows_2.Controls.Add(Template_Rows2_Cell_2);
  2019. Template_Rows_2.Controls.Add(Template_Rows2_Cell_3);
  2020. Template_Rows_2.Controls.Add(Template_Rows2_Cell_4);
  2021. Template_Rows_2.Controls.Add(Template_Rows2_Cell_5);
  2022. Template_Rows_2.Controls.Add(Template_Rows2_Cell_6);
  2023. Template_Rows3_Cell_2.WidthF = 57.23f;//63.59f
  2024. Template_Rows3_Cell_3.WidthF = 57.23f;
  2025. Template_Rows3_Cell_4.WidthF = 57.23f;
  2026. Template_Rows3_Cell_5.WidthF = 57.23f;
  2027. Template_Rows3_Cell_6.WidthF = 57.23f;
  2028. Template_Rows3_Cell_7.WidthF = 57.23f;
  2029. Template_Rows3_Cell_8.WidthF = 57.23f;
  2030. Template_Rows3_Cell_9.WidthF = 57.23f;
  2031. Template_Rows3_Cell_10.WidthF = 57.23f;
  2032. Template_Rows3_Cell_11.WidthF = 57.23f;
  2033. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  2034. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  2035. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  2036. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  2037. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  2038. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  2039. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  2040. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  2041. Template_Rows_3.Controls.Add(Template_Rows3_Cell_10);
  2042. Template_Rows_3.Controls.Add(Template_Rows3_Cell_11);
  2043. Template_Rows4_Cell_2.WidthF = 57.23f;//63.59f
  2044. Template_Rows4_Cell_3.WidthF = 57.23f;
  2045. Template_Rows4_Cell_4.WidthF = 57.23f;
  2046. Template_Rows4_Cell_5.WidthF = 57.23f;
  2047. Template_Rows4_Cell_6.WidthF = 57.23f;
  2048. Template_Rows4_Cell_7.WidthF = 57.23f;
  2049. Template_Rows4_Cell_8.WidthF = 57.23f;
  2050. Template_Rows4_Cell_9.WidthF = 57.23f;
  2051. Template_Rows4_Cell_10.WidthF = 57.23f;
  2052. Template_Rows4_Cell_11.WidthF = 57.23f;
  2053. Template_Rows_4.Controls.Add(Template_Rows4_Cell_2);
  2054. Template_Rows_4.Controls.Add(Template_Rows4_Cell_3);
  2055. Template_Rows_4.Controls.Add(Template_Rows4_Cell_4);
  2056. Template_Rows_4.Controls.Add(Template_Rows4_Cell_5);
  2057. Template_Rows_4.Controls.Add(Template_Rows4_Cell_6);
  2058. Template_Rows_4.Controls.Add(Template_Rows4_Cell_7);
  2059. Template_Rows_4.Controls.Add(Template_Rows4_Cell_8);
  2060. Template_Rows_4.Controls.Add(Template_Rows4_Cell_9);
  2061. Template_Rows_4.Controls.Add(Template_Rows4_Cell_10);
  2062. Template_Rows_4.Controls.Add(Template_Rows4_Cell_11);
  2063. Template_Rows5_Cell_1.WidthF = 120f;
  2064. Template_Rows5_Cell_2.WidthF = 120f;
  2065. Template_Rows5_Cell_3.WidthF = 448f;
  2066. Template_Rows_5.Controls.Add(Template_Rows5_Cell_1);
  2067. Template_Rows_5.Controls.Add(Template_Rows5_Cell_2);
  2068. Template_Rows_5.Controls.Add(Template_Rows5_Cell_3);
  2069. Template.Rows.Add(Template_Rows_1);
  2070. Template.Rows.Add(Template_Rows_2);
  2071. Template.Rows.Add(Template_Rows_3);
  2072. Template.Rows.Add(Template_Rows_4);
  2073. Template.Rows.Add(Template_Rows_5);
  2074. Template.SizeF = new SizeF(688f, 125);
  2075. Template.Rows[0].Font = new Font(Schriftart_english, 12f);
  2076. Template.Rows[2].Font = new Font(Schriftart_english, 12f);
  2077. Template.Rows[1].Font = new Font(Schriftart_english, 12f);
  2078. Template.Rows[3].Font = new Font(Schriftart_english, 12f);
  2079. Template.Rows[0].BackColor = Color.DarkGray;
  2080. Template.Rows[2].BackColor = Color.DarkGray;
  2081. Template.Rows[2].BackColor = Color.DarkGray;
  2082. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  2083. return Template;
  2084. }
  2085. private void add_kllb(c_TemplateClass TemplateClass, DataTable dataTable, int position, XRTable xRTable, DataTable ElementIcons)
  2086. {
  2087. XRTable table = new XRTable();
  2088. table = xRTable;
  2089. table.Name = "table_kllb_" + position.ToString();
  2090. table.Rows[0].Cells[0].Text = "ID";
  2091. table.Rows[0].Cells[1].Text = "Class";
  2092. table.Rows[0].Cells[2].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString();
  2093. table.Rows[0].Cells[3].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p2.ToString();
  2094. table.Rows[0].Cells[4].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p3.ToString();
  2095. table.Rows[1].Cells[0].Text = dataTable.Rows[position]["pid"].ToString();
  2096. table.Rows[1].Cells[1].Text = dataTable.Rows[position]["Class"].ToString();
  2097. table.Rows[1].Cells[2].Text = dataTable.Rows[position]["Size"].ToString();
  2098. table.Rows[1].Cells[3].Text = dataTable.Rows[position]["DMAX"].ToString();
  2099. table.Rows[1].Cells[4].Text = dataTable.Rows[position]["DMIN"].ToString();
  2100. for (int i = 0; i < 10; i++)
  2101. {
  2102. table.Rows[2].Cells[i].Text = dataTable.Rows[position]["ColName" + (i + 1).ToString()].ToString();
  2103. string str_ColVal = "";
  2104. if (dataTable.Rows[position]["ColVal" + (i + 1).ToString()].ToString() == "0")
  2105. {
  2106. str_ColVal = "0";
  2107. }
  2108. else
  2109. {
  2110. str_ColVal = dataTable.Rows[position]["ColVal" + (i + 1).ToString()].ToString();
  2111. }
  2112. table.Rows[3].Cells[i].Text = str_ColVal;
  2113. }
  2114. XRPictureBox xRPicture2 = new XRPictureBox();
  2115. xRPicture2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.AutoSize;
  2116. xRPicture2.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p3"]);
  2117. XRPictureBox xRPicture3 = new XRPictureBox();
  2118. xRPicture3.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p1"]);
  2119. xRPicture3.SizeF = new SizeF(120f, 120f);
  2120. xRPicture3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
  2121. XRPictureBox xRPicture4 = new XRPictureBox();
  2122. xRPicture4.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p2"]);
  2123. xRPicture4.SizeF = new SizeF(120f, 120f);
  2124. xRPicture4.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
  2125. //XRChart xRChart= ParticleSpectrogramControl(ElementIcons);
  2126. table.Rows[4].Cells[0].Controls.Add(xRPicture3);
  2127. table.Rows[4].Cells[1].Controls.Add(xRPicture4);
  2128. table.Rows[4].Cells[2].Controls.Add(xRPicture2);
  2129. //table.Rows[4].Cells[1].Controls.Add(xRChart);
  2130. table.Rows[4].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  2131. table.Visible = true;
  2132. table.LocationF = new PointF(0, NeueStartposition);
  2133. table.SendToBack();
  2134. table.BorderWidth = 0.5f;
  2135. this.Detail.Controls.Add(table);
  2136. NeueStartposition = table.SizeF.Height + NeueStartposition;
  2137. }
  2138. #endregion
  2139. #region 颗粒列表帧图
  2140. private XRTable add_XRTable_frame()
  2141. {
  2142. XRTable Template = new XRTable();
  2143. XRTableRow Template_Rows_1 = new XRTableRow();
  2144. XRTableRow Template_Rows_2 = new XRTableRow();
  2145. XRTableRow Template_Rows_3 = new XRTableRow();
  2146. XRTableRow Template_Rows_4 = new XRTableRow();
  2147. XRTableCell Template_Rows1_Cell_1 = new XRTableCell();
  2148. XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
  2149. XRTableCell Template_Rows1_Cell_3 = new XRTableCell();
  2150. XRTableCell Template_Rows1_Cell_4 = new XRTableCell();
  2151. XRTableCell Template_Rows2_Cell_1 = new XRTableCell();
  2152. XRTableCell Template_Rows2_Cell_2 = new XRTableCell();
  2153. XRTableCell Template_Rows2_Cell_3 = new XRTableCell();
  2154. XRTableCell Template_Rows2_Cell_4 = new XRTableCell();
  2155. XRTableCell Template_Rows3_Cell_1 = new XRTableCell();
  2156. XRTableCell Template_Rows3_Cell_2 = new XRTableCell();
  2157. XRTableCell Template_Rows3_Cell_3 = new XRTableCell();
  2158. XRTableCell Template_Rows3_Cell_4 = new XRTableCell();
  2159. XRTableCell Template_Rows3_Cell_5 = new XRTableCell();
  2160. XRTableCell Template_Rows3_Cell_6 = new XRTableCell();
  2161. XRTableCell Template_Rows3_Cell_7 = new XRTableCell();
  2162. XRTableCell Template_Rows3_Cell_8 = new XRTableCell();
  2163. XRTableCell Template_Rows3_Cell_9 = new XRTableCell();
  2164. XRTableCell Template_Rows3_Cell_10 = new XRTableCell();
  2165. XRTableCell Template_Rows4_Cell_1 = new XRTableCell();
  2166. XRTableCell Template_Rows4_Cell_2 = new XRTableCell();
  2167. XRTableCell Template_Rows4_Cell_3 = new XRTableCell();
  2168. XRTableCell Template_Rows4_Cell_4 = new XRTableCell();
  2169. XRTableCell Template_Rows4_Cell_5 = new XRTableCell();
  2170. XRTableCell Template_Rows4_Cell_6 = new XRTableCell();
  2171. XRTableCell Template_Rows4_Cell_7 = new XRTableCell();
  2172. XRTableCell Template_Rows4_Cell_8 = new XRTableCell();
  2173. XRTableCell Template_Rows4_Cell_9 = new XRTableCell();
  2174. XRTableCell Template_Rows4_Cell_10 = new XRTableCell();
  2175. Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
  2176. Template_Rows1_Cell_1.WidthF = 94.63f;
  2177. Template_Rows1_Cell_2.WidthF = 334.15f;
  2178. Template_Rows1_Cell_3.WidthF = 133.66f;
  2179. Template_Rows1_Cell_4.WidthF = 133.66f;
  2180. Template_Rows_1.Controls.Add(Template_Rows1_Cell_1);
  2181. Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
  2182. Template_Rows_1.Controls.Add(Template_Rows1_Cell_3);
  2183. Template_Rows_1.Controls.Add(Template_Rows1_Cell_4);
  2184. Template_Rows2_Cell_1.WidthF = 94.63f;
  2185. Template_Rows2_Cell_2.WidthF = 334.15f;
  2186. Template_Rows2_Cell_3.WidthF = 133.66f;
  2187. Template_Rows2_Cell_4.WidthF = 133.66f;
  2188. Template_Rows_2.Controls.Add(Template_Rows2_Cell_1);
  2189. Template_Rows_2.Controls.Add(Template_Rows2_Cell_2);
  2190. Template_Rows_2.Controls.Add(Template_Rows2_Cell_3);
  2191. Template_Rows_2.Controls.Add(Template_Rows2_Cell_4);
  2192. Template_Rows3_Cell_1.WidthF = 94.63f;
  2193. Template_Rows3_Cell_2.WidthF = 66.83f;
  2194. Template_Rows3_Cell_3.WidthF = 66.83f;
  2195. Template_Rows3_Cell_4.WidthF = 66.83f;
  2196. Template_Rows3_Cell_5.WidthF = 66.83f;
  2197. Template_Rows3_Cell_6.WidthF = 66.83f;
  2198. Template_Rows3_Cell_7.WidthF = 66.83f;
  2199. Template_Rows3_Cell_8.WidthF = 66.83f;
  2200. Template_Rows3_Cell_9.WidthF = 66.83f;
  2201. Template_Rows3_Cell_10.WidthF = 66.83f;
  2202. Template_Rows_3.Controls.Add(Template_Rows3_Cell_1);
  2203. Template_Rows_3.Controls.Add(Template_Rows3_Cell_2);
  2204. Template_Rows_3.Controls.Add(Template_Rows3_Cell_3);
  2205. Template_Rows_3.Controls.Add(Template_Rows3_Cell_4);
  2206. Template_Rows_3.Controls.Add(Template_Rows3_Cell_5);
  2207. Template_Rows_3.Controls.Add(Template_Rows3_Cell_6);
  2208. Template_Rows_3.Controls.Add(Template_Rows3_Cell_7);
  2209. Template_Rows_3.Controls.Add(Template_Rows3_Cell_8);
  2210. Template_Rows_3.Controls.Add(Template_Rows3_Cell_9);
  2211. Template_Rows_3.Controls.Add(Template_Rows3_Cell_10);
  2212. Template_Rows4_Cell_1.WidthF = 94.63f;
  2213. Template_Rows4_Cell_2.WidthF = 66.83f;
  2214. Template_Rows4_Cell_3.WidthF = 66.83f;
  2215. Template_Rows4_Cell_4.WidthF = 66.83f;
  2216. Template_Rows4_Cell_5.WidthF = 66.83f;
  2217. Template_Rows4_Cell_6.WidthF = 66.83f;
  2218. Template_Rows4_Cell_7.WidthF = 66.83f;
  2219. Template_Rows4_Cell_8.WidthF = 66.83f;
  2220. Template_Rows4_Cell_9.WidthF = 66.83f;
  2221. Template_Rows4_Cell_10.WidthF = 66.83f;
  2222. Template_Rows_4.Controls.Add(Template_Rows4_Cell_1);
  2223. Template_Rows_4.Controls.Add(Template_Rows4_Cell_2);
  2224. Template_Rows_4.Controls.Add(Template_Rows4_Cell_3);
  2225. Template_Rows_4.Controls.Add(Template_Rows4_Cell_4);
  2226. Template_Rows_4.Controls.Add(Template_Rows4_Cell_5);
  2227. Template_Rows_4.Controls.Add(Template_Rows4_Cell_6);
  2228. Template_Rows_4.Controls.Add(Template_Rows4_Cell_7);
  2229. Template_Rows_4.Controls.Add(Template_Rows4_Cell_8);
  2230. Template_Rows_4.Controls.Add(Template_Rows4_Cell_9);
  2231. Template_Rows_4.Controls.Add(Template_Rows4_Cell_10);
  2232. Template.Rows.Add(Template_Rows_1);
  2233. Template.Rows.Add(Template_Rows_2);
  2234. Template.Rows.Add(Template_Rows_3);
  2235. Template.Rows.Add(Template_Rows_4);
  2236. Template.Rows[0].BackColor = Color.DarkGray;
  2237. Template.Rows[2].BackColor = Color.DarkGray;
  2238. Template.Rows[2].Cells[0].BackColor = Color.Transparent;
  2239. Template.Rows[2].Cells[0].Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right;
  2240. Template.Rows[1].Cells[0].Borders = DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right | DevExpress.XtraPrinting.BorderSide.Top;
  2241. //Transparent
  2242. Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
  2243. Template.SizeF = new SizeF(688f, 30);
  2244. Template.Font = new Font(Schriftart_english, 12f);
  2245. return Template;
  2246. }
  2247. #endregion
  2248. private void xrLabel_pageinfo_PrintOnPage(object sender, PrintOnPageEventArgs e)
  2249. {
  2250. int pagecount = e.PageCount;
  2251. int pageindex = e.PageIndex;
  2252. if (pageindex < 1)
  2253. {
  2254. this.xrLabel_pageinfo.Visible = false;
  2255. }
  2256. else
  2257. {
  2258. xrLabel_pageinfo.Font = new Font(Schriftart_chinese, xrLabel_pageinfo.Font.Size);
  2259. this.xrLabel_pageinfo.Visible = true;
  2260. //this.xrLabel_pageinfo.Text = string.Format("第{0}页,共{1}页", pageindex, pagecount - 1);
  2261. this.xrLabel_pageinfo.Text = string.Format(GetlanguageData("dev_Page", languageData, "页码") + " {0} "+ GetlanguageData("dev_of", languageData, "/") + " {1}" , pageindex, pagecount - 1);
  2262. }
  2263. }
  2264. }
  2265. public class ParticleSizeDEVData
  2266. {
  2267. public string size_Class { get; set; }
  2268. public string size_Name { get; set; }
  2269. public string size_total { get; set; }
  2270. public string size_1 { get; set; }
  2271. public string size_2 { get; set; }
  2272. public string size_3 { get; set; }
  2273. public string size_4 { get; set; }
  2274. public string size_5 { get; set; }
  2275. public string size_6 { get; set; }
  2276. public string size_7 { get; set; }
  2277. }
  2278. public class ElementalAnalysisDEVData
  2279. {
  2280. public string classify { get; set; }
  2281. public string subdivision { get; set; }
  2282. public string Area { get; set; }
  2283. public string s1 { get; set; }
  2284. public string s2 { get; set; }
  2285. public string s3 { get; set; }
  2286. public string s4 { get; set; }
  2287. public string s5 { get; set; }
  2288. public string s6 { get; set; }
  2289. public string s7 { get; set; }
  2290. public string s8 { get; set; }
  2291. public string s9 { get; set; }
  2292. public string s10 { get; set; }
  2293. }
  2294. public class ElementalAnalysisDEVDataS
  2295. {
  2296. public string classify { get; set; }
  2297. public string subdivision { get; set; }
  2298. public string Area { get; set; }
  2299. public string s1 { get; set; }
  2300. public string s2 { get; set; }
  2301. public string s3 { get; set; }
  2302. public string s4 { get; set; }
  2303. public string s5 { get; set; }
  2304. public string s6 { get; set; }
  2305. public string s7 { get; set; }
  2306. public string s8 { get; set; }
  2307. public string s9 { get; set; }
  2308. public string s10 { get; set; }
  2309. }
  2310. public class AreaOfInclusionDEVData
  2311. {
  2312. public string classify { get; set; }
  2313. public string subdivision { get; set; }
  2314. public string Area { get; set; }
  2315. public string inca_proportion { get; set; }
  2316. public string inca_FieldRatio { get; set; }
  2317. }
  2318. }