DataTemplate.cs 136 KB

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