| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701 |
- using DevExpress.Utils;
- using DevExpress.XtraCharts;
- using DevExpress.XtraPrinting.Drawing;
- using DevExpress.XtraReports.UI;
- using Microsoft.Office.Interop.Excel;
- using NPOI.Util;
- using OpenCvSharp;
- using OTSCommon;
- using OTSCommon.DBOperate.Model;
- using OTSIncAReportApp._1_UI.OTSReportExport.DataIntegration;
- using OTSIncAReportApp._1_UI.OTSReportExport.Template;
- using OTSIncAReportApp.OTSRstMgrFunction;
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Data;
- using System.Drawing;
- using System.Windows.Forms;
- using static OTSDataType.otsdataconst;
- using static OTSIncAReportApp.OTSReport_Export;
- using Application = System.Windows.Forms.Application;
- using DataTable = System.Data.DataTable;
- using Font = System.Drawing.Font;
- using Series = DevExpress.XtraCharts.Series;
- namespace OTSIncAReportApp._1_UI.OTSTemplateDesigner
- {
- public partial class OTS_DEVReport : DevExpress.XtraReports.UI.XtraReport
- {
- public OTSReport_Export m_otsreport_export;
-
- string Schriftart_chinese = "微软雅黑";
- string Schriftart_english = "Calibri";
- List<string> TemplateList;
- float NeueStartposition = 3300f;
- private string FieldOfViewArea = "";
- List<DataTable> FrameData = new List<DataTable>();
- ElementSubscript subscript = new ElementSubscript();
- c_TemplateClass TemplateClass;
- private string ComputeMode = "";//计算方式
- private string ComputeModeName = "";//计算方式
- private string PartSizeFile = "";//粒级文件
- BasicData basicData = new BasicData();
- Hashtable table;
- public OTS_DEVReport(OTSReport_Export in_export, c_TemplateClass a_Template, frmReportApp a_frmReportApp , Hashtable a_table)
- {
- table = a_table;
- TemplateClass = a_Template;
- m_otsreport_export = in_export;
- TemplateList = new List<string>();
- //加载三元相图各项
- string pathtpf = in_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.TrigTemplateFileFolder + "\\" + in_export.m_ReportApp.m_rstDataMgr.m_RptConfigFile.TriTempFile;
- DataSet ds = DataOperation.DataAccess.XMLoperate.GetXmlData(pathtpf, "XMLData");
- DataTable dt = ds.Tables["Member"];
- foreach (DataRow item in dt.Rows)
- {
- if (item["TemplateName"].ToString() != "")
- {
- TemplateList.Add(item["TemplateName"].ToString());
- }
- }
- string con = "";
- DataSet ds1 = XMLoperate.GetXmlData(Application.StartupPath + RptConfigFile.m_ReportMgrParamFile, "XMLData");
- DataTable dt1 = ds1.Tables["Member"];
- string po = "";
- foreach (DataRow element in dt1.Rows)
- {
- string RegName = element["RegName"].ToString();
- if (RegName == "PartSizeFile")
- {
- PartSizeFile = element["name"].ToString();
- }
- if (RegName == "TRIO_CHART_TYPE")
- {
- po = element["strValue"].ToString();
- }
- if (RegName == "SIZE_CAL_METHOD_TYPE")
- {
- po = element["strValue"].ToString();
- }
- }
- for (int i=0;i< dt1.Rows.Count;i++)
- {
- if (dt1.Rows[i]["RegName"].ToString()== "SIZE_CAL_METHOD_TYPE")
- {
- con = dt1.Rows[i]["strValue"].ToString();
- }
- }
- switch (con)
- {
- case "DMAX":
- po = "DMAX";
- break;
- case "DMIN":
- po = "DMIN";
- break;
- case "ECD":
- po = "Area";
- break;
- case "FERET":
- po = "DFERET";
- break;
- }
- if(po=="")
- {
- ComputeMode = "Area";
- ComputeModeName = "ECD";
- }
- else
- {
- ComputeMode = po;
- ComputeModeName = con;
- }
- InitializeComponent();
-
- }
- #region 接口
- /// <summary>
- /// 国际化显示
- /// </summary>
- /// <param name="languageData"></param>
- public void International_language()
- {
- basicData = new BasicData();
- basicData.IsFilePath(m_otsreport_export);
- basicData.IsResultFilesList(m_otsreport_export);
- basicData.SetDBData(TemplateClass,m_otsreport_export,ComputeMode);
- basicData.SetParticlesizeTable(m_otsreport_export);
- basicData.newParticleData(m_otsreport_export);
- basicData.SetAllClass();
- basicData.SetAllElement();
- basicData.IsThereAMajorClassification(basicData, m_otsreport_export);
-
- setXRLabelData(dev_ypmc_up, "产品名称:");
- setXRLabelData(dev_ypbh_up, "产品型号:");//样品编号(中间的)
- setXRLabelData(dev_bgsj_up, GetlanguageData("dev_bgsj_up", dev_bgsj_up.Text));//报告时间(中间的)
- setXRLabelData(dev_ypsm, GetlanguageData("dev_ypsm", dev_ypsm.Text));//表中样品说明
- setXRLabelData(dev_jcjgwj, GetlanguageData("dev_jcjgwj", dev_jcjgwj.Text));//表中测量结果名称
- setXRLabelData(dev_cljggk, GetlanguageData("dev_cljggk", dev_cljggk.Text));//表中测量结果概况
- setXRLabelData(dev_yxsj, GetlanguageData("dev_yxsj", dev_yxsj.Text));//表中运行时间
- setXRLabelData(dev_sczs, GetlanguageData("dev_sczs", dev_sczs.Text));//表中视场总数
- setXRLabelData(dev_flfa, GetlanguageData("dev_flfa", dev_flfa.Text));//表中分类方案
- setXRLabelData(dev_ckbz, GetlanguageData("dev_ckbz", dev_ckbz.Text));//表中参考标准
- setXRLabelData(dev_yjctz, GetlanguageData("dev_yjctz", dev_yjctz.Text));//表中已检测特征
- setXRLabelData(dev_scmj, GetlanguageData("dev_scmj", dev_scmj.Text));//表中视场面积 总检测面积
- setXRLabelData(dev_bgsj, GetlanguageData("dev_bgsj", dev_bgsj.Text));//表中报告时间
- setXRLabelData(dev_fdbs, GetlanguageData("dev_fdbs", dev_fdbs.Text));//表中放大倍数
- //颗粒列表图
- //setXRLabelData(xrLabel_size_IconQuestion_Class, GetlanguageData("xrlabel_size_iconquestion_class", xrLabel_size_IconQuestion_Class.Text));//大类图表头
- //setXRLabelData(xrLabel_size_IconQuestion_Subdivision, GetlanguageData("xrlabel_size_iconquestion_subdivision", xrLabel_size_IconQuestion_Subdivision.Text));//细分类表头
- //夹杂物面积比图
- setXRLabelData(xrLabel_inca_pic_class, GetlanguageData("xrlabel_inca_pic_class", xrLabel_inca_pic_class.Text));//夹杂物面积比图
- setXRLabelData(xrLabel_inca_pic_subdivision, GetlanguageData("xrlabel_inca_pic_subdivision", xrLabel_inca_pic_subdivision.Text));
- setXRLabelData(xrTableCell1, "Notes");//备注
- setXRLabelData(xrLabel1, GetlanguageData("xrlabel1", xrLabel1.Text));
- Bitmap bitmap = (Bitmap)Image.FromFile(System.IO.Directory.GetCurrentDirectory() + "\\Config\\ReportTemplate\\"+ TemplateClass.M_SY.LOGName);
- xrPictureBox1.ImageSource = new ImageSource(bitmap);
- xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
- }
- /// <summary>
- /// 首页部分数据插入
- /// </summary>ReportIdentification
- /// <param name="TemplateClass"></param>
- public void setResultGrid(DataTable data)
- {
- //xrChart_ParticelSizeCalss.Visible = false;
- //xrChart_ParticelSizeSubdivision.Visible = false;
-
- #region 加载Grid表数据
- setXRLabelData(dev_jcjgwj_text, data.Rows[0][1].ToString());//测量结果名称
- setXRLabelData(dev_yxsj_text, data.Rows[1][1].ToString());//运行时间
- setXRLabelData(dev_sczs_text, data.Rows[2][1].ToString());//视场总数
- setXRLabelData(dev_flfa_text, data.Rows[3][1].ToString());//分类方案
- setXRLabelData(dev_yjctz_text, data.Rows[4][1].ToString());//已检测特征
- setXRLabelData(dev_scmj_text, data.Rows[5][1].ToString() + "mm²");//视场面积
- setXRLabelData(dev_fdbs_text, data.Rows[6][1].ToString()+"X");//放大倍数
- //setXRLabelData(dev_bgsj_text, DateTime.Now.ToShortDateString().ToString());//报告时间:
- setXRLabelData(dev_bgsj_text, TemplateClass.M_SY.str_tb_Surveyor.ToString());//测量人员:
- setXRLabelData(dev_ckbz_text, TemplateClass.M_SY.str_tb_CKBZ.ToString());//参考标准
- //FieldOfViewArea = HeaderData.filedsArea.ToString();
- FieldOfViewArea = data.Rows[5][1].ToString();
- #endregion
- #region 加载模板设置文档数据
- setXRLabelData(dev_yj, TemplateClass.M_YMYJ.str_tb_yjwb.ToString());//页脚
- setXRLabelData(dev_zbt, TemplateClass.M_SY.str_tb_ZBT.ToString());//主标题
- setXRLabelData(dev_fbt, TemplateClass.M_SY.str_tb_FBT.ToString());//副标题
- setXRLabelData(dev_ypmc_text_up, TemplateClass.M_SY.str_tb_SampleName.ToString());
- setXRLabelData(dev_ypbh_text_up, TemplateClass.M_SY.str_tb_YPBH.ToString());//样品编号
- //setXRLabelData(dev_bgsj_text_up, DateTime.Now.ToShortDateString().ToString());//当前日期
- setXRLabelData(dev_bgsj_text_up, TemplateClass.M_SY.str_tb_Surveyor.ToString());//测量人员
- setXRLabelData(dev_sb_text, TemplateClass.M_SY.str_tb_djsb.ToString());//电镜设备名称
- setXRLabelData(dev_np_text, TemplateClass.M_SY.str_tb_npsb.ToString());//能谱设备名称
- //setXRLabelData(xrTableCell1, xrTableCell1)
- #endregion
-
- xrTableCell3.Text = TemplateClass.M_DZ.Notes.ToString();
- xrTable3.SizeF = new SizeF(630f, 90.62f);
- xrTable3.Borders = DevExpress.XtraPrinting.BorderSide.All;
- xrTable2.Borders = DevExpress.XtraPrinting.BorderSide.All;
- if(TemplateClass.M_DZ.Notes.ToString()=="")
- {
- xrTable3.Visible = false;
- xrTable2.Visible = false;
- xrTable1.LocationF = new PointF(30.42f, 721.79f);
- }
-
- }
-
- /// <summary>
- /// 普通颗粒尺寸表(大分类)
- /// </summary>
- /// <param name="CompositeData"></param>
- /// <param name="surface_dt2"></param>
- private void add_Particle_size_table_multi_element(List<DataTable> CompositeData, DataTable surface_dt2)
- {
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- //XRTable xrTa_ParticleSizeTable = add_particleSizeS();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.add_particleSizeS();
- //xrChart_ParticelSizeCalss.Visible = true;
- // xrChart_ParticelSizeSubdivision.Visible = true;
- List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
- List<List<string>> llstr = new List<List<string>>();
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 4; a < CompositeData[1].Columns.Count; a++)
- {
- strings.Add(CompositeData[1].Rows[i][a].ToString());
- }
- llstr.Add(strings);
- }
- List<List<string>> llwrite = new List<List<string>>();
- for (int i = 0; i < llstr.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 0; a < 12; a++)
- {
- if (llstr[i].Count <= a)
- {
- strings.Add("");
- }
- else
- {
- strings.Add(llstr[i][a]);
- }
- }
- llwrite.Add(strings);
- }
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- list_ParticelSizeData.Add(switch_ParticleSize(subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Name"].ToString()),
- CompositeData[1].Rows[i]["total"].ToString(),
- llwrite[i][0], llwrite[i][1], llwrite[i][2],llwrite[i][3],llwrite[i][4],llwrite[i][5],llwrite[i][6],
- llwrite[i][7], llwrite[i][8], llwrite[i][9], llwrite[i][10], llwrite[i][11]));
- }
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", "分类"));//分类
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_subdivision", "二级分类"));//二级分类(子分类)
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[2], GetlanguageData("dev_quantity", "数量"));//数量
- setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], "颗粒尺寸分析结果");//颗粒尺寸分析结果
- setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_dimensiontable_2", "尺寸计算基于"));//尺寸计算基于:
- //dev_classify.Text = "分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
- //dev_subdivision.Text = "子分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
- //dev_quantity.Text = "数量";
- xrTa_ParticleSizeTable.Rows[2].Cells[2].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[2].Font.Size);
- for (int i=0;i< CompositeData[0].Columns.Count;i++)
- {
- if (i>11)
- {
- continue;
- }
- xrTa_ParticleSizeTable.Rows[2].Cells[i+3].Text = CompositeData[0].Rows[0]["c"+(i+1).ToString()].ToString();
- }
- xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
- int total = 0;
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_Class = new XRTableCell();
- XRTableCell tCell_Name = new XRTableCell();
- XRTableCell tCell_total = new XRTableCell();
- XRTableCell tCell_size_1 = new XRTableCell();
- XRTableCell tCell_size_2 = new XRTableCell();
- XRTableCell tCell_size_3 = new XRTableCell();
- XRTableCell tCell_size_4 = new XRTableCell();
- XRTableCell tCell_size_5 = new XRTableCell();
- XRTableCell tCell_size_6 = new XRTableCell();
- XRTableCell tCell_size_7 = new XRTableCell();
- XRTableCell tCell_size_8 = new XRTableCell();
- XRTableCell tCell_size_9 = new XRTableCell();
- XRTableCell tCell_size_10 = new XRTableCell();
- XRTableCell tCell_size_11 = new XRTableCell();
- XRTableCell tCell_size_12 = new XRTableCell();
- tCell_Class.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
- tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
- tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
- tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
- tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
- tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
- tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
- tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
- tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
- tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[9].WidthF;
- tCell_size_8.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[10].WidthF;
- tCell_size_9.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[11].WidthF;
- tCell_size_10.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[12].WidthF;
- tCell_size_11.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[13].WidthF;
- tCell_size_12.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[14].WidthF;
- XRTableCellData(row, tCell_Class, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Class");
- XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
- XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
- XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
- XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
- XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
- XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
- XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
- XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
- XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
- XRTableCellData(row, tCell_size_8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_8");
- XRTableCellData(row, tCell_size_9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_9");
- XRTableCellData(row, tCell_size_10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_10");
- XRTableCellData(row, tCell_size_11, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_11");
- XRTableCellData(row, tCell_size_12, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_12");
- xrTa_ParticleSizeTable.Rows.Add(row);
- if (CompositeData[1].Rows[i]["Name"].ToString()!="")
- {
- total += Convert.ToInt32(CompositeData[1].Rows[i]["total"]);
- }
- }
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- float fl = xrPageBreak1.LocationF.Y + 20;
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, fl);
- XRTable xrTable3 = particleSizeTableCreation.add_particleSizeS_end();
- xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
- List<int> vs = new List<int>();
- for (int i = 0; i < surface_dt2.Columns.Count - 4; i++)
- {
- vs.Add(0);
- }
- for (int i = 0; i < surface_dt2.Rows.Count; i++)
- {
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- if ( surface_dt2.Rows[i]["c" + (a+1).ToString()] != null)
- {
- bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + (a + 1).ToString()].ToString(), out double result);
- if (isNumeric)
- vs[a] += Convert.ToInt32(result);
- }
- }
- }
- setXRLabelData(xrTable3.Rows[0].Cells[0], GetlanguageData("dev_total", "总数量"));
- xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[1].Text = total.ToString();
- xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- for(int i=0;i< vs.Count;i++)
- {
- if (i > 11)
- {
- continue;
- }
- xrTable3.Rows[0].Cells[i+2].Text = vs[i].ToString();
- xrTable3.Rows[0].Cells[i + 2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- }
- NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
- this.Detail.Controls.Add(xrTable3);
- }
- /// <summary>
- /// VDA19颗粒尺寸表(大分类)
- /// </summary>
- /// <param name="CompositeData"></param>
- /// <param name="surface_dt2"></param>
- private void add_Set_VDA19_TableS(List<DataTable> CompositeData, DataTable surface_dt2)
- {
- //XRTable xrTa_ParticleSizeTable = add_VDA19_particleSizeS();
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.add_VDA19_particleSizeS();
- //xrChart_ParticelSizeCalss.Visible = true;
- //xrChart_ParticelSizeSubdivision.Visible = true;
- List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
- List<List<string>> llstr = new List<List<string>>();
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 4; a < CompositeData[1].Columns.Count; a++)
- {
- strings.Add(CompositeData[1].Rows[i][a].ToString());
- }
- llstr.Add(strings);
- }
- List<List<string>> llwrite = new List<List<string>>();
- for (int i = 0; i < llstr.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 0; a < 12; a++)
- {
- if (llstr[i].Count <= a)
- {
- strings.Add("");
- }
- else
- {
- strings.Add(llstr[i][a]);
- }
- }
- llwrite.Add(strings);
- }
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- list_ParticelSizeData.Add(switch_ParticleSize(subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Name"].ToString()),
- CompositeData[1].Rows[i]["total"].ToString(),
- llwrite[i][0], llwrite[i][1], llwrite[i][2], llwrite[i][3], llwrite[i][4], llwrite[i][5], llwrite[i][6],
- llwrite[i][7], llwrite[i][8], llwrite[i][9], llwrite[i][10], llwrite[i][11]));
- }
- setXRLabelData(xrTa_ParticleSizeTable.Rows[3].Cells[0], GetlanguageData("dev_classify", "分类"));//分类
- setXRLabelData(xrTa_ParticleSizeTable.Rows[3].Cells[1], GetlanguageData("dev_subdivision", "二级分类"));//二级分类(子分类)
- setXRLabelData(xrTa_ParticleSizeTable.Rows[3].Cells[2], GetlanguageData("dev_quantity", "数量"));//数量
- setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], GetlanguageData("dev_dimensiontable", "颗粒尺寸分析结果 ISO16232/VDA-19 Results"));//颗粒尺寸分析结果
- setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_dimensiontable_2", "尺寸计算基于"));//尺寸计算基于:
- //dev_classify.Text = "分类";
- xrTa_ParticleSizeTable.Rows[3].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[3].Cells[0].Font.Size);
- //dev_subdivision.Text = "子分类";
- xrTa_ParticleSizeTable.Rows[3].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[3].Cells[1].Font.Size);
- //dev_quantity.Text = "数量";
- xrTa_ParticleSizeTable.Rows[3].Cells[2].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[3].Cells[2].Font.Size);
- for (int i = 0; i < CompositeData[0].Columns.Count; i++)
- {
- if (i > 9)
- {
- continue;
- }
- xrTa_ParticleSizeTable.Rows[3].Cells[i + 3].Text = CompositeData[0].Rows[0]["c" + (i + 1).ToString()].ToString();
- }
- xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
- int total = 0;
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_Class = new XRTableCell();
- XRTableCell tCell_Name = new XRTableCell();
- XRTableCell tCell_total = new XRTableCell();
- XRTableCell tCell_size_1 = new XRTableCell();
- XRTableCell tCell_size_2 = new XRTableCell();
- XRTableCell tCell_size_3 = new XRTableCell();
- XRTableCell tCell_size_4 = new XRTableCell();
- XRTableCell tCell_size_5 = new XRTableCell();
- XRTableCell tCell_size_6 = new XRTableCell();
- XRTableCell tCell_size_7 = new XRTableCell();
- XRTableCell tCell_size_8 = new XRTableCell();
- XRTableCell tCell_size_9 = new XRTableCell();
- XRTableCell tCell_size_10 = new XRTableCell();
- tCell_Class.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[0].WidthF;
- tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[1].WidthF;
- tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[2].WidthF;
- tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[3].WidthF;
- tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[4].WidthF;
- tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[5].WidthF;
- tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[6].WidthF;
- tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[7].WidthF;
- tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[8].WidthF;
- tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[9].WidthF;
- tCell_size_8.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[10].WidthF;
- tCell_size_9.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[11].WidthF;
- tCell_size_10.WidthF = xrTa_ParticleSizeTable.Rows[3].Cells[12].WidthF;
-
- XRTableCellData(row, tCell_Class, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Class");
- XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
- XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
- XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
- XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
- XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
- XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
- XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
- XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
- XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
- XRTableCellData(row, tCell_size_8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_8");
- XRTableCellData(row, tCell_size_9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_9");
- XRTableCellData(row, tCell_size_10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_10");
-
- xrTa_ParticleSizeTable.Rows.Add(row);
- if (CompositeData[1].Rows[i]["Name"].ToString() != "")
- {
- total += Convert.ToInt32(CompositeData[1].Rows[i]["total"]);
- }
- }
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- float fl = xrPageBreak1.LocationF.Y + 20;
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, fl);
- XRTable xrTable3 = particleSizeTableCreation.add_VDA19_particleSizeS_end();
- xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
- List<int> vs = new List<int>();
- for (int i = 0; i < surface_dt2.Columns.Count - 4; i++)
- {
- vs.Add(0);
- }
- for (int i = 0; i < surface_dt2.Rows.Count; i++)
- {
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- if (surface_dt2.Rows[i]["c" + (a + 1).ToString()] != null)
- {
- bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + (a + 1).ToString()].ToString(), out double result);
- if (isNumeric)
- vs[a] += Convert.ToInt32(result);
- }
- }
- }
- setXRLabelData(xrTable3.Rows[0].Cells[0], GetlanguageData("dev_total", "总数量"));
- xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[1].Text = total.ToString();
- xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- for (int i = 0; i < vs.Count; i++)
- {
- if (i > 9)
- {
- continue;
- }
- xrTable3.Rows[0].Cells[i + 2].Text = vs[i].ToString();
- xrTable3.Rows[0].Cells[i + 2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- }
- NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
- this.Detail.Controls.Add(xrTable3);
- XRPageBreak();
- XRTable VDA19_ResultTable = particleSizeTableCreation.add_VDA19_ResultTable();
- setXRLabelData(VDA19_ResultTable.Rows[0].Cells[0], GetlanguageData("dev_dimensiontable", "颗粒尺寸分析结果 ISO16232/VDA-19 Results"));//颗粒尺寸分析结果
- //粒级名称
- for (int i = 0; i < CompositeData[0].Columns.Count; i++)
- {
- VDA19_ResultTable.Rows[2].Cells[i + 2].Text = CompositeData[0].Rows[0][i].ToString();
- }
- //总数量
- VDA19_ResultTable.Rows[3].Cells[1].Text = total.ToString();
- List<string> strings1 = new List<string>();
- strings1.Add("B");
- strings1.Add("C");
- strings1.Add("D");
- strings1.Add("E");
- strings1.Add("F");
- strings1.Add("G");
- strings1.Add("H");
- strings1.Add("I");
- strings1.Add("J");
- strings1.Add("K");
- //当前级别
- List<string> List_Level = new List<string>();
- int pos = 0;
- string currentLevel = "";
- bool isPass = true;
- //粒级数量+粒级评级
- for (int i = 4; i < surface_dt2.Columns.Count; i++)
- {
- int quantity = Convert.ToInt32(surface_dt2.Rows[0][i]);
- VDA19_ResultTable.Rows[3].Cells[i - 2].Text = quantity.ToString();
- string Level = particleSizeTableCreation.VDA_Level(quantity);
- VDA19_ResultTable.Rows[4].Cells[i - 3].Text = Level;
- strings1[pos] = strings1[pos] + Level;
- pos++;
- List_Level.Add(Level);
- }
- for (int i = 0; i < strings1.Count; i++)
- {
- if (i != strings1.Count - 1)
- currentLevel = currentLevel + strings1[i] + "/";
- else currentLevel = currentLevel + strings1[i];
- }
- VDA19_ResultTable.Rows[5].Cells[1].Text = "V("+ currentLevel+")";
- VDA19_ResultTable.Rows[6].Cells[2].Text = particleSizeTableCreation.isPassLevel(List_Level);
- VDA19_ResultTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = VDA19_ResultTable.LocationF.Y + VDA19_ResultTable.SizeF.Height + 1;
- this.Detail.Controls.Add(VDA19_ResultTable);
- }
-
- private void add_SetTable(List<DataTable> CompositeData, DataTable surface_dt2)
- {
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.add_particleSize();
- //xrChart_ParticelSizeCalss.Visible = true;
- //xrChart_ParticelSizeSubdivision.Visible = true;
- List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
-
- DataTable data = CompositeData[1].Clone();
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- if (CompositeData[1].Rows[i]["Class"].ToString() == "")
- {
- data.Rows.Add(CompositeData[1].Rows[i].ItemArray);
- }
- }
- List<List<string>> llstr = new List<List<string>>();
- for (int i=0;i< data.Rows.Count;i++)
- {
-
- List<string> strings = new List<string>();
- for (int a = 4; a < data.Columns.Count ; a++)
- {
- strings.Add(data.Rows[i][a].ToString());
- }
- llstr.Add(strings);
- }
- List<List<string>> llwrite = new List<List<string>>();
- for (int i=0;i< llstr.Count;i++)
- {
- List<string> strings = new List<string>();
- for (int a = 0; a < 12; a++)
- {
- if (llstr[i].Count <= a)
- {
- strings.Add("");
- }
- else
- {
- strings.Add(llstr[i][a]);
- }
- }
- llwrite.Add(strings);
- }
- for (int i = 0; i < data.Rows.Count; i++)
- {
- list_ParticelSizeData.Add(switch_ParticleSize(subscript.Getsubscriptstring(data.Rows[i]["Class"].ToString()), subscript.Getsubscriptstring(data.Rows[i]["Name"].ToString()), data.Rows[i]["total"].ToString(),
- llwrite[i][0], llwrite[i][1], llwrite[i][2],llwrite[i][3], llwrite[i][4],
- llwrite[i][5], llwrite[i][6], llwrite[i][7], llwrite[i][8], llwrite[i][9],
- llwrite[i][10], llwrite[i][11]));
- }
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", "分类"));//二级分类(子分类)
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_quantity", "数量"));//数量
- setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], "颗粒尺寸分析结果");//颗粒尺寸分析结果
- setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_dimensiontable_2", "尺寸计算基于:"));//尺寸计算基于:
- //dev_subdivision.Text = "子分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
- //dev_quantity.Text = "数量";
- xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
- for(int i=0;i< CompositeData[0].Columns.Count;i++)
- {
- if (i > 11)
- {
- continue;
- }
- xrTa_ParticleSizeTable.Rows[2].Cells[i+2].Text= CompositeData[0].Rows[0]["c"+(i+1).ToString()].ToString();
- }
- xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
- for (int i = 0; i < data.Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
-
- XRTableCell tCell_Name = new XRTableCell();
- XRTableCell tCell_total = new XRTableCell();
- XRTableCell tCell_size_1 = new XRTableCell();
- XRTableCell tCell_size_2 = new XRTableCell();
- XRTableCell tCell_size_3 = new XRTableCell();
- XRTableCell tCell_size_4 = new XRTableCell();
- XRTableCell tCell_size_5 = new XRTableCell();
- XRTableCell tCell_size_6 = new XRTableCell();
- XRTableCell tCell_size_7 = new XRTableCell();
- XRTableCell tCell_size_8 = new XRTableCell();
- XRTableCell tCell_size_9 = new XRTableCell();
- XRTableCell tCell_size_10 = new XRTableCell();
- XRTableCell tCell_size_11 = new XRTableCell();
- XRTableCell tCell_size_12 = new XRTableCell();
- tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
- tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
- tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
- tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
- tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
- tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
- tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
- tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
- tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
- tCell_size_8.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[9].WidthF;
- tCell_size_9.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[10].WidthF;
- tCell_size_10.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[11].WidthF;
- tCell_size_11.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[12].WidthF;
- tCell_size_12.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[13].WidthF;
- XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
- XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
- XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
- XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
- XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
- XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
- XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
- XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
- XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
- XRTableCellData(row, tCell_size_8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_8");
- XRTableCellData(row, tCell_size_9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_9");
- XRTableCellData(row, tCell_size_10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_10");
- XRTableCellData(row, tCell_size_11, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_11");
- XRTableCellData(row, tCell_size_12, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_12");
- xrTa_ParticleSizeTable.Rows.Add(row);
- }
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- float fl = xrPageBreak1.LocationF.Y + 20;
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, fl);
- XRTable xrTable3 = particleSizeTableCreation.add_particleSize_end();
- xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
- List<int> vs = new List<int>();
- for(int i=0;i< surface_dt2.Columns.Count - 4;i++)
- {
- vs.Add(0);
- }
- int total = 0;
- for (int i = 0; i < surface_dt2.Rows.Count; i++)
- {
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- if (surface_dt2.Rows[i]["c" + (a + 1).ToString()] != null)
- {
- bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + (a + 1).ToString()].ToString(), out double result);
- if (isNumeric)
- vs[a] += Convert.ToInt32(result);
- }
- }
- }
- setXRLabelData(xrTable3.Rows[0].Cells[0], "总数量");
- xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[1].Text = total.ToString();
- xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- for (int i=0;i< vs.Count; i++)
- {
- if (i > 11)
- {
- continue;
- }
- xrTable3.Rows[0].Cells[i+2].Text = vs[i].ToString();
- xrTable3.Rows[0].Cells[i + 2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- }
- NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
- this.Detail.Controls.Add(xrTable3);
- }
-
- private void add_ParticleList_Below7_NoGrouping(List<DataTable> CompositeData, DataTable surface_dt2)
- {
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
-
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.add_particleSize_Below7();
- //xrChart_ParticelSizeCalss.Visible = true;
- //xrChart_ParticelSizeSubdivision.Visible = true;
- List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
- int ls = 0;
- DataTable data = CompositeData[1].Clone();
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- if (CompositeData[1].Rows[i]["Class"].ToString() == "")
- {
- data.Rows.Add(CompositeData[1].Rows[i].ItemArray);
- }
- }
- for (int i = 0; i < data.Rows.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 0; a < 12; a++)
- {
- if (CompositeData[0].Columns.Count > a)
- {
- strings.Add(data.Rows[i]["c" + (a + 1)].ToString());
- }
- else
- {
- strings.Add("");
- }
- }
- list_ParticelSizeData.Add(switch_ParticleSize(
- subscript.Getsubscriptstring(data.Rows[i]["Class"].ToString()),
- subscript.Getsubscriptstring(data.Rows[i]["Name"].ToString()),
- data.Rows[i]["total"].ToString(),
- strings[0], strings[1],
- strings[2], strings[3],
- strings[4], strings[5],
- strings[6], strings[7], strings[8], strings[9], strings[10], strings[11]));
- }
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", "分类"));//二级分类(子分类)
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_quantity", "数量"));//数量
- setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], "颗粒尺寸分析结果");//颗粒尺寸分析结果
- setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_dimensiontable_2", "尺寸计算基于:"));//尺寸计算基于:
- //dev_subdivision.Text = "子分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
- //dev_quantity.Text = "数量";
- xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- xrTa_ParticleSizeTable.Rows[2].Cells[a + 2].Text = CompositeData[0].Rows[0]["c" + (a + 1)].ToString();
- }
- xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
- int total = 0;
- for (int i = 0; i < data.Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_Name = new XRTableCell();
- XRTableCell tCell_total = new XRTableCell();
- XRTableCell tCell_size_1 = new XRTableCell();
- XRTableCell tCell_size_2 = new XRTableCell();
- XRTableCell tCell_size_3 = new XRTableCell();
- XRTableCell tCell_size_4 = new XRTableCell();
- XRTableCell tCell_size_5 = new XRTableCell();
- XRTableCell tCell_size_6 = new XRTableCell();
- XRTableCell tCell_size_7 = new XRTableCell();
- tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
- tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
- tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
- tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
- tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
- tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
- tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
- tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
- tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
- XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
- XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
- XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
- XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
- XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
- XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
- XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
- XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
- XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
- xrTa_ParticleSizeTable.Rows.Add(row);
- if (data.Rows[i]["Name"].ToString() != "")
- {
- total += Convert.ToInt32(data.Rows[i]["total"]);
- }
- }
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- float fl = xrPageBreak1.LocationF.Y + 20;
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, fl);
- XRTable xrTable3 = particleSizeTableCreation.add_particleSize_Below7_end();
- xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
- List<int> vs = new List<int>();
- for (int i = 0; i < surface_dt2.Columns.Count - 4; i++)
- {
- vs.Add(0);
- }
- for (int i = 0; i < surface_dt2.Rows.Count; i++)
- {
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- if (surface_dt2.Rows[i]["c" + (a + 1).ToString()] != null)
- {
- bool isNumeric = double.TryParse(surface_dt2.Rows[i]["c" + (a + 1).ToString()].ToString(), out double result);
- if (isNumeric)
- vs[a] += Convert.ToInt32(result);
- }
- }
-
- }
-
- if (vs.Count < 7)
- {
- for (int i = 0; i < 7; i++)
- {
- vs.Add(0);
- }
- }
- setXRLabelData(xrTable3.Rows[0].Cells[0], "总数量");
- xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[1].Text = total.ToString();
- xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[2].Text = vs[0].ToString();
- xrTable3.Rows[0].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[3].Text = vs[1].ToString();
- xrTable3.Rows[0].Cells[3].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[4].Text = vs[2].ToString();
- xrTable3.Rows[0].Cells[4].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[5].Text = vs[3].ToString();
- xrTable3.Rows[0].Cells[5].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[6].Text = vs[4].ToString();
- xrTable3.Rows[0].Cells[6].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[7].Text = vs[5].ToString();
- xrTable3.Rows[0].Cells[7].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[8].Text = vs[6].ToString();
- xrTable3.Rows[0].Cells[8].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
- this.Detail.Controls.Add(xrTable3);
- }
- private void add_ParticleList_Below7(List<DataTable> CompositeData, DataTable surface_dt2)
- {
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- //XRTable xrTa_ParticleSizeTable = add_particleSizeS_Below7();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation. add_particleSizeS_Below7();
- //xrChart_ParticelSizeCalss.Visible = true;
- //xrChart_ParticelSizeSubdivision.Visible = true;
- List<List<ParticleSizeDEVData>> list_ParticelSizeData = new List<List<ParticleSizeDEVData>>();
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- List<string> strings = new List<string>();
- for (int a = 0; a < 12; a++)
- {
- if (CompositeData[0].Columns.Count > a)
- {
- strings.Add(CompositeData[1].Rows[i]["c" + (a + 1)].ToString());
- }
- else
- {
- strings.Add("");
- }
- }
- list_ParticelSizeData.Add(switch_ParticleSize(
- subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Class"].ToString()),
- subscript.Getsubscriptstring(CompositeData[1].Rows[i]["Name"].ToString()),
- CompositeData[1].Rows[i]["total"].ToString(), strings[0],
- strings[1], strings[2],
- strings[3], strings[4],
- strings[5], strings[6], strings[7], strings[8], strings[9], strings[10], strings[11]));
- }
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[0], GetlanguageData("dev_classify", "分类"));//分类
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[1], GetlanguageData("dev_subdivision", "二级分类"));//二级分类(子分类)
- setXRLabelData(xrTa_ParticleSizeTable.Rows[2].Cells[2], GetlanguageData("dev_quantity", "数量"));//数量
- setXRLabelData(xrTa_ParticleSizeTable.Rows[0].Cells[0], "颗粒尺寸分析结果");//颗粒尺寸分析结果
- setXRLabelData(xrTa_ParticleSizeTable.Rows[1].Cells[0], GetlanguageData("dev_dimensiontable_2", "尺寸计算基于"));//尺寸计算基于:
- //dev_classify.Text = "分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[0].Font.Size);
- //dev_subdivision.Text = "子分类";
- xrTa_ParticleSizeTable.Rows[2].Cells[1].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[1].Font.Size);
- //dev_quantity.Text = "数量";
- xrTa_ParticleSizeTable.Rows[2].Cells[2].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[2].Cells[2].Font.Size);
- for (int a = 0; a < CompositeData[0].Columns.Count; a++)
- {
- xrTa_ParticleSizeTable.Rows[2].Cells[a + 3].Text = CompositeData[0].Rows[0]["c" + (a + 1)].ToString();
- }
- xrTa_ParticleSizeTable.Rows[1].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Text = xrTa_ParticleSizeTable.Rows[1].Cells[0].Text + ComputeModeName + "(μm)";
- xrTa_ParticleSizeTable.Rows[1].Cells[0].Font = new Font(Schriftart_chinese, xrTa_ParticleSizeTable.Rows[1].Cells[0].Font.Size);
- for (int i = 0; i < CompositeData[1].Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_Class = new XRTableCell();
- XRTableCell tCell_Name = new XRTableCell();
- XRTableCell tCell_total = new XRTableCell();
- XRTableCell tCell_size_1 = new XRTableCell();
- XRTableCell tCell_size_2 = new XRTableCell();
- XRTableCell tCell_size_3 = new XRTableCell();
- XRTableCell tCell_size_4 = new XRTableCell();
- XRTableCell tCell_size_5 = new XRTableCell();
- XRTableCell tCell_size_6 = new XRTableCell();
- XRTableCell tCell_size_7 = new XRTableCell();
- tCell_Class.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[0].WidthF;
- tCell_Name.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[1].WidthF;
- tCell_total.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[2].WidthF;
- tCell_size_1.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[3].WidthF;
- tCell_size_2.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[4].WidthF;
- tCell_size_3.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[5].WidthF;
- tCell_size_4.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[6].WidthF;
- tCell_size_5.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[7].WidthF;
- tCell_size_6.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[8].WidthF;
- tCell_size_7.WidthF = xrTa_ParticleSizeTable.Rows[2].Cells[9].WidthF;
- XRTableCellData(row, tCell_Class, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Class");
- XRTableCellData(row, tCell_Name, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_Name");
- XRTableCellData(row, tCell_total, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_total");
- XRTableCellData(row, tCell_size_1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_1");
- XRTableCellData(row, tCell_size_2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_2");
- XRTableCellData(row, tCell_size_3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_3");
- XRTableCellData(row, tCell_size_4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_4");
- XRTableCellData(row, tCell_size_5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_5");
- XRTableCellData(row, tCell_size_6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_6");
- XRTableCellData(row, tCell_size_7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ParticelSizeData[i], "size_7");
- xrTa_ParticleSizeTable.Rows.Add(row);
- }
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- float fl = xrPageBreak1.LocationF.Y + 20;
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, fl);
- XRTable xrTable3 = particleSizeTableCreation.add_particleSizeS_Below7_end();
- xrTable3.LocationF = new PointF(10f, xrTa_ParticleSizeTable.LocationF.Y + xrTa_ParticleSizeTable.HeightF);
- List<int> vs = new List<int>();
- int total = 0;
- for (int i = 0; i < surface_dt2.Rows.Count; i++)
- {
- for (int a = 4; a < surface_dt2.Columns.Count; a++)
- {
- if (surface_dt2.Rows[i][a] != null)
- {
- bool isNumeric = double.TryParse(surface_dt2.Rows[i][a].ToString(), out double result);
- if (isNumeric)
- {
- vs.Add(Convert.ToInt32(result));
- total = total + Convert.ToInt32(result);
- }
-
- }
- }
- }
- if (vs.Count < 7)
- {
- for (int i = 0; i < 7; i++)
- {
- vs.Add(0);
- }
- }
- setXRLabelData(xrTable3.Rows[0].Cells[0], GetlanguageData("dev_total", "总数量"));
- //xrTable3.Rows[0].Cells[0].Text = "总数量";
- xrTable3.Rows[0].Cells[0].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[1].Text = total.ToString();
- xrTable3.Rows[0].Cells[1].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[2].Text = vs[0].ToString();
- xrTable3.Rows[0].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[3].Text = vs[1].ToString();
- xrTable3.Rows[0].Cells[3].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[4].Text = vs[2].ToString();
- xrTable3.Rows[0].Cells[4].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[5].Text = vs[3].ToString();
- xrTable3.Rows[0].Cells[5].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[6].Text = vs[4].ToString();
- xrTable3.Rows[0].Cells[6].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[7].Text = vs[5].ToString();
- xrTable3.Rows[0].Cells[7].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- xrTable3.Rows[0].Cells[8].Text = vs[6].ToString();
- xrTable3.Rows[0].Cells[8].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- NeueStartposition = xrTable3.LocationF.Y + xrTable3.SizeF.Height + 1;
- this.Detail.Controls.Add(xrTable3);
- }
-
- /// <summary>
- /// 优先级排序
- /// </summary>
- /// <param name="data"></param>
- /// <param name="field"></param>
- /// <returns></returns>
- private DataTable REORDER(DataTable data,string field)
- {
- DataTable dataTable = data.Clone();
- List<int> vs = new List<int>();
-
- for (int i=0;i< data.Rows.Count;i++)
- {
- if (TemplateClass.list_str_MainPriority_Serial.Count!=0)
- {
- for (int a = 0; a < TemplateClass.list_str_MainPriority_Serial.Count; a++)
- {
- if (data.Rows[i][field].ToString() == TemplateClass.list_str_MainPriority_Serial[a])
- {
- dataTable.Rows.Add(data.Rows[i].ItemArray);
- break;
- }
- }
- }
- else
- {
- dataTable.Rows.Add(data.Rows[i].ItemArray);
- }
- }
- DataTable dt = dataTable.Clone();
- for (int i=0;i< dataTable.Rows.Count;i++)
- {
- if (dataTable.Rows[i]["Name"].ToString()!="")
- {
- dt.Rows.Add(dataTable.Rows[i].ItemArray);
- }
- }
- return dt.Copy();
-
- }
-
- /// <summary>
- /// 颗粒尺寸分析表
- /// </summary>
- /// <param name="a_pieSeriesClass">大分类</param>
- /// <param name="a_pieSeries">小分类</param>
- public int setParticleSizeTable(c_TemplateClass m_mbszclass, bool a_isINCA)
- {
- //if (m_ReportApp.m_RptConfigFile.Systype != OTS_SysType_ID.IncA)
- xrPageBreak1.Visible = true;
- ParticleAnalysis particleList = new ParticleAnalysis();
- DataTable statisticalAuantity = new DataTable();
- List<DataTable> CompositeData = particleList.GetClassificationConsolidationTable(m_otsreport_export,basicData,out statisticalAuantity);
- DataTable classData = particleList.GetLargeClassification(m_otsreport_export,basicData);
- int TotalParticleCount = 0;
- for (int i = 0; i < classData.Rows.Count; i++)
- {
- if (classData.Rows[i]["total"].ToString() != "")
- {
- TotalParticleCount = TotalParticleCount + Convert.ToInt32(classData.Rows[i]["total"]);
- }
- }
- DataTable subdivdeData = particleList.GetSubClassification(basicData);
- if (m_mbszclass.M_VDA19.IsVDA19)
- {
- add_Set_VDA19_TableS(CompositeData, statisticalAuantity);
- }
- else
- {
- if (basicData.GetParticlesizeTable().Count > 7)
- {
- if (CompositeData[1].Rows.Count > 0)
- {
- if (basicData.GetIsThereAMajorClassification())
- {
- add_Particle_size_table_multi_element(CompositeData, statisticalAuantity);
- }
- else
- {
- add_SetTable(CompositeData, statisticalAuantity);
- }
- }
- }
- else
- {
- if (CompositeData[1].Rows.Count > 0)
- {
- if (basicData.GetIsThereAMajorClassification())
- {
- add_ParticleList_Below7(CompositeData, statisticalAuantity);
- }
- else
- {
- add_ParticleList_Below7_NoGrouping(CompositeData, statisticalAuantity);
- }
- }
- }
- }
- #region 插入数据
- if (m_mbszclass.M_KLFXJG.b_ck_klcc_xsddt)
- {
- HistogramChart(particleList, basicData);
- }
- if (m_mbszclass.M_KLFXJG.b_ck_klcc_dfl || m_mbszclass.M_KLFXJG.b_ck_klcc_xfl)
- {
- XRPageBreak();
- }
- //xrChart_ParticelSizeCalss.Visible = false;
- //ViewType viewType;
- //DefaultBoolean VisDefaultBoolean;
- //string Pat;
- //string CPat;
- //if (m_mbszclass.M_KLFXJG.GroupShapeSelection==0)
- //{
- // viewType = ViewType.Pie;
- // Pat = "{A}";
- // CPat = "{A}";
- // VisDefaultBoolean = DefaultBoolean.True;
- //}
- //else if(m_mbszclass.M_KLFXJG.GroupShapeSelection == 1)
- //{
- // viewType = ViewType.Bar;
- // Pat = "{V}";
- // CPat = "{V}";
- // VisDefaultBoolean = DefaultBoolean.False;
- //}
- //else /*if (m_mbszclass.M_KLFXJG.GroupShapeSelection == 2)*/
- //{
- // viewType = ViewType.Line;
- // Pat = "{V}";
- // CPat = "{V}";
- // VisDefaultBoolean = DefaultBoolean.False;
- //}
- // #region 大分类chart图
- // if (m_mbszclass.M_KLFXJG.b_ck_klcc_dfl && classData.Rows.Count>0)
- //{
- // xrChart_ParticelSizeCalss.Visible = true;
- // xrLabel_size_IconQuestion_Class.Visible = true;
- // xrLabel_size_IconQuestion_Class.LocationF = new PointF(xrLabel_size_IconQuestion_Class.LocationF.X, NeueStartposition);
- // NeueStartposition = xrLabel_size_IconQuestion_Class.LocationF.Y + xrLabel_size_IconQuestion_Class.SizeF.Height + 10;
- // // 实例化饼图对象
- // Series pieSeriesClass = new Series("尺寸分类", viewType);
- // for (int i=0;i< classData.Rows.Count;i++)
- // {
- // string name = classData.Rows[i]["Class"].ToString();
- // double Cunt = Convert.ToDouble(classData.Rows[i]["total"]);
- // pieSeriesClass.Points.Add(new SeriesPoint(name, Cunt));
- // }
- // pieSeriesClass.LabelsVisibility = DefaultBoolean.True;
- // pieSeriesClass.Label.TextPattern = Pat;
- // if(m_mbszclass.M_KLFXJG.GroupShapeSelection == 0)
- // {
- // pieSeriesClass.LabelsVisibility = DefaultBoolean.False;
- // }
- // xrChart_ParticelSizeCalss.Series.Add(pieSeriesClass);
- // xrChart_ParticelSizeCalss.Legend.Visibility = VisDefaultBoolean;
-
- // xrChart_ParticelSizeCalss.LocationF = new PointF(30f, NeueStartposition);
- // NeueStartposition = xrChart_ParticelSizeCalss.LocationF.Y + xrChart_ParticelSizeCalss.SizeF.Height+1 ;
- //}
- //#endregion
- //#region 细分chart图
- //xrChart_ParticelSizeSubdivision.Visible = false;
- //if (m_mbszclass.M_KLFXJG.b_ck_klcc_xfl && subdivdeData.Rows.Count>0)
- //{
-
- // xrChart_ParticelSizeSubdivision.Visible = true;
- // xrLabel_size_IconQuestion_Subdivision.Visible = true;
- // xrLabel_size_IconQuestion_Subdivision.LocationF = new PointF(xrLabel_size_IconQuestion_Subdivision.LocationF.X, NeueStartposition);
- // NeueStartposition = xrLabel_size_IconQuestion_Subdivision.LocationF.Y + xrLabel_size_IconQuestion_Subdivision.SizeF.Height + 1;
- // Series pieSeries = new Series("颗粒尺寸细化分类", viewType);
- // for (int i = 0; i < subdivdeData.Rows.Count; i++)
- // {
- // string name = subdivdeData.Rows[i]["Name"].ToString();
- // double Cunt = Convert.ToDouble(subdivdeData.Rows[i]["total"]);
- // pieSeries.Points.Add(new SeriesPoint(name, Cunt));
- // }
- // pieSeries.LabelsVisibility = DefaultBoolean.True;
- // pieSeries.Label.TextPattern = CPat;
- // if (m_mbszclass.M_KLFXJG.GroupShapeSelection == 0)
- // {
- // pieSeries.LabelsVisibility = DefaultBoolean.False;
- // }
- // xrChart_ParticelSizeSubdivision.Series.Add(pieSeries);
- // xrChart_ParticelSizeSubdivision.Legend.Visibility = VisDefaultBoolean;
-
- // xrChart_ParticelSizeSubdivision.LocationF = new PointF(30f, NeueStartposition);
- // NeueStartposition = xrChart_ParticelSizeSubdivision.LocationF.Y + xrChart_ParticelSizeSubdivision.SizeF.Height + 10;
- //}
- //#endregion
- #endregion
- dev_yjctz_text.Text = TotalParticleCount.ToString();
- return TotalParticleCount;
- }
- /// <summary>
- /// 结果表,显示不同碳化物类型的名称、数量、总面积。
- /// </summary>
- public void SetMaterialTesting(c_TemplateClass m_mbszclass)
- {
- //获取各个分类的数量
- ParticleAnalysis particleList = new ParticleAnalysis();
- DataTable statisticalAuantity = new DataTable();
- List<DataTable> CompositeData = particleList.GetClassificationConsolidationTable(m_otsreport_export, basicData, out statisticalAuantity);
- //计算视野面积
- InclusionProportion inclusionProportion = new InclusionProportion();
- //夹杂物面积比添加大类
- DataTable RawParticleData = inclusionProportion.ObtainClassificationArea(FieldOfViewArea, basicData, TemplateClass);
- double total = 0;
- double TotalArea = 0;
- DataTable dt = new DataTable();
- dt.Columns.Add("Name");
- dt.Columns.Add("TypeId");
- dt.Columns.Add("sun");
- dt.Columns.Add("Area", typeof(double));
- for (int i = 0; i < RawParticleData.Rows.Count; i++)
- {
- DataRow dr = dt.NewRow();
- dr["Name"] = RawParticleData.Rows[i]["subdivision"].ToString();
- dr["TypeId"] = RawParticleData.Rows[i]["TypeId"].ToString();
- dr["Area"] =Convert.ToDouble(RawParticleData.Rows[i]["Area"]);
- int quantity = 0;
-
- for (int a = 0; a < CompositeData[1].Rows.Count; a++)
- {
- if (RawParticleData.Rows[i]["TypeId"].ToString() == CompositeData[1].Rows[a]["TypeId"].ToString())
- {
- quantity = Convert.ToInt32(CompositeData[1].Rows[a]["total"]);
- }
- }
- dr["sun"] = quantity;
- total = total + quantity;
- TotalArea= TotalArea+ Convert.ToDouble(RawParticleData.Rows[i]["Area"]);
- dt.Rows.Add(dr);
- }
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.addMaterialTesting(m_mbszclass.M_SY.str_tb_JCW);
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- XRTableRow header_row = new XRTableRow();
- XRTableCell header_tCell_1 = new XRTableCell();
- XRTableCell header_tCell_2 = new XRTableCell();
- XRTableCell header_tCell_3 = new XRTableCell();
- XRTableCell header_tCell_4 = new XRTableCell();
- XRTableCell header_tCell_5 = new XRTableCell();
- header_tCell_1.Text = dt.Rows[i]["Name"].ToString();
- header_tCell_1.WidthF = 126f;
- header_tCell_2.Text = dt.Rows[i]["sun"].ToString();
- header_tCell_2.WidthF = 126f;
- double pp = Convert.ToDouble(dt.Rows[i]["sun"]) / total * 100 ;
- double ppr = Math.Round(pp, 2);
- header_tCell_3.Text = ppr.ToString();
- header_tCell_3.WidthF = 126f;
- header_tCell_4.Text = Math.Round(Convert.ToDouble(dt.Rows[i]["Area"]), 2).ToString();
- header_tCell_4.WidthF = 126f;
- double paa = Convert.ToDouble(dt.Rows[i]["Area"]) / TotalArea * 100 ;
- double paar = Math.Round(paa, 2);
- header_tCell_5.Text = paar.ToString();
- header_tCell_5.WidthF = 126f;
- header_row.Cells.Add(header_tCell_1);
- header_row.Cells.Add(header_tCell_2);
- header_row.Cells.Add(header_tCell_3);
- header_row.Cells.Add(header_tCell_4);
- header_row.Cells.Add(header_tCell_5);
- xrTa_ParticleSizeTable.Rows.Add(header_row);
- }
- XRTableRow xR = particleSizeTableCreation.addMaterialTestingTotal();
- xR.Cells[1].Text = total.ToString();
- xR.Cells[3].Text = Math.Round(TotalArea, 2).ToString();
- xrTa_ParticleSizeTable.Rows.Add(xR);
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, NeueStartposition+5);
- NeueStartposition= NeueStartposition + xrTa_ParticleSizeTable.HeightF + 10;
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- DataTable ddt = new DataTable();
- ddt.Columns.Add("NameSun");
- ddt.Columns.Add("NameArea");
- ddt.Columns.Add("sun");
- ddt.Columns.Add("Area");
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- DataRow row = ddt.NewRow();
- row["NameSun"] = dt.Rows[i]["Name"].ToString() + " " + dt.Rows[i]["sun"].ToString();
- double area = Convert.ToDouble(dt.Rows[i]["Area"]);
- row["NameArea"] = dt.Rows[i]["Name"].ToString() + " " + Math.Round(area, 2).ToString();
- row["sun"] = dt.Rows[i]["sun"].ToString();
- row["Area"] = dt.Rows[i]["Area"].ToString();
- ddt.Rows.Add(row);
- }
- if (m_mbszclass.M_JZWZB.b_ck_surfaceNumber || m_mbszclass.M_JZWZB.b_ck_surfaceArea)
- {
- XRPageBreak();
- //图表填充参数
- if (m_mbszclass.M_JZWZB.b_ck_surfaceNumber)
- ChartFillingParameters("数量占比图", ddt, "NameSun", "sun", particleSizeTableCreation, m_mbszclass, m_mbszclass.M_KLFXJG.SubdivisionGraphicSelection);
- if (m_mbszclass.M_JZWZB.b_ck_surfaceArea)
- ChartFillingParameters("面积占比图", ddt, "NameArea", "Area", particleSizeTableCreation, m_mbszclass, m_mbszclass.M_KLFXJG.SubdivisionGraphicSelection);
- }
- }
- /// <summary>
- /// 图表填充参数
- /// </summary>
- /// <param name="a_title"></param>
- /// <param name="a_dt"></param>
- /// <param name="a_name"></param>
- /// <param name="a_parameter"></param>
- private void ChartFillingParameters(string a_title,DataTable a_dt,string a_name,string a_parameter, ParticleSizeTableCreation particleSizeTableCreation, c_TemplateClass m_mbszclass,int INCAGraphicSelection)
- {
- XRTable TitleOfQuantityChart = new XRTable();
- XRTableRow T_row = new XRTableRow();
- XRTableCell T_tCell_1 = new XRTableCell();
- T_tCell_1.Text = a_title;
- T_tCell_1.WidthF = 668f;
- T_row.Cells.Add(T_tCell_1);
- TitleOfQuantityChart.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- TitleOfQuantityChart.Borders = DevExpress.XtraPrinting.BorderSide.All;
- TitleOfQuantityChart.SizeF = new SizeF(668f, TitleOfQuantityChart.SizeF.Height);
- TitleOfQuantityChart.BackColor = Color.DarkGray;
- TitleOfQuantityChart.Rows.Add(T_row);
- TitleOfQuantityChart.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + TitleOfQuantityChart.HeightF;
- this.Detail.Controls.Add(TitleOfQuantityChart);
- XRChart xRChart = particleSizeTableCreation.addChart(a_dt, a_name, a_parameter, m_mbszclass,INCAGraphicSelection);
- xRChart.SizeF = new SizeF(630f, 400);
- xRChart.LocationF = new PointF(30f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRChart.SizeF.Height + 1;
- this.Detail.Controls.Add(xRChart);
- }
- /// <summary>
- /// 图表填充参数
- /// </summary>
- /// <param name="a_title"></param>
- /// <param name="a_dt"></param>
- /// <param name="a_name"></param>
- /// <param name="a_parameter"></param>
- private void ChartFillingParameters(string a_title, DataTable a_dt, string a_name, string a_parameter, InclusionProportion particleSizeTableCreation, c_TemplateClass m_mbszclass, int INCAGraphicSelection)
- {
- XRTable TitleOfQuantityChart = new XRTable();
- XRTableRow T_row = new XRTableRow();
- XRTableCell T_tCell_1 = new XRTableCell();
- T_tCell_1.Text = a_title;
- T_tCell_1.WidthF = 668f;
- T_row.Cells.Add(T_tCell_1);
- TitleOfQuantityChart.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- TitleOfQuantityChart.Borders = DevExpress.XtraPrinting.BorderSide.All;
- TitleOfQuantityChart.SizeF = new SizeF(668f, TitleOfQuantityChart.SizeF.Height);
- TitleOfQuantityChart.BackColor = Color.DarkGray;
- TitleOfQuantityChart.Rows.Add(T_row);
- TitleOfQuantityChart.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + TitleOfQuantityChart.HeightF;
- this.Detail.Controls.Add(TitleOfQuantityChart);
- XRChart xRChart = particleSizeTableCreation.addChart(a_dt, a_name, a_parameter, m_mbszclass, INCAGraphicSelection);
- xRChart.SizeF = new SizeF(630f, 400);
- xRChart.LocationF = new PointF(30f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRChart.SizeF.Height + 1;
- this.Detail.Controls.Add(xRChart);
- }
- /// <summary>
- /// 结果表,显示夹杂物数量及占比。
- /// </summary>
- public void SetINCAProportion(int incaSun,int sun)
- {
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- XRTable xRTable = particleSizeTableCreation.addINCAProportionTable();
- xRTable.Rows[1].Cells[0].Text = sun.ToString();
- xRTable.Rows[1].Cells[1].Text = incaSun.ToString();
- double pp = (double)incaSun / (double)sun * 100;
- xRTable.Rows[1].Cells[2].Text = Math.Round(pp, 2).ToString();
- xRTable.LocationF = new PointF(10f, NeueStartposition + 5);
- NeueStartposition = NeueStartposition + xRTable.HeightF + 10;
- this.Detail.Controls.Add(xRTable);
- }
- private void HistogramChart(ParticleAnalysis particleList, BasicData basicData)
- {
- XRPageBreak();
- List<Series> seriesList = new List<Series>();
-
- DataTable dataTable = particleList.GetSubClassification(basicData);
- DataTable TypeRange = particleList.TypeRange(TemplateClass, m_otsreport_export);
- if(dataTable.Rows.Count==0)
- {
- return;
- }
- xrLabel1.Visible = true;
- xrChart1.Visible = true;
- DataTable dt = new DataTable();
- dt.Columns.Add("name");
- dt.Columns.Add("range");
- dt.Columns.Add("num");
- for (int i = 0; i < dataTable.Rows.Count; i++)
- {
- for (int a = 0; a < TypeRange.Columns.Count; a++)
- {
- if (string.IsNullOrEmpty(TypeRange.Rows[0][a].ToString()))
- continue;
- DataRow dr = dt.NewRow();
- dr["name"] = subscript.Getsubscriptstring(dataTable.Rows[i]["Name"].ToString());
- dr["range"] = TypeRange.Rows[0][a];
- if (double.TryParse(dataTable.Rows[i]["c" + (a+1).ToString()].ToString(), out double result))
- {
- dr["num"] = result;
- }
- else
- {
- dr["num"] = 0;
- }
- dt.Rows.Add(dr);
- }
- }
- foreach (DataRow dr in dt.DefaultView.ToTable(true, "name").Rows)
- {
- Series s = new Series(dr["name"].ToString(), ViewType.StackedBar)
- {
- LegendTextPattern = dr["name"].ToString(),
- ArgumentScaleType = ScaleType.Qualitative,
- };
- foreach (DataRow drl in dt.Select("name='" + dr["name"].ToString() + "'"))
- s.Points.Add(new SeriesPoint(drl["range"].ToString(), int.Parse(drl["num"].ToString())));
- s.LabelsVisibility = DefaultBoolean.False;
- seriesList.Add(s);
- }
- foreach (Series sr in seriesList.ToArray())
- xrChart1.Series.Add(sr);
- ((XYDiagram)xrChart1.Diagram).AxisY.Title.Text = "";
- ((XYDiagram)xrChart1.Diagram).AxisX.Title.Text = "";
- ((XYDiagram)xrChart1.Diagram).AxisY.Title.Visibility = DefaultBoolean.True;
- ((XYDiagram)xrChart1.Diagram).AxisX.Title.Visibility = DefaultBoolean.True;
- ((XYDiagram)xrChart1.Diagram).AxisY.Title.Font = new Font("Tahoma", 9);
- ((XYDiagram)xrChart1.Diagram).AxisX.Title.Font = new Font("Tahoma", 9);
- ((XYDiagram)xrChart1.Diagram).AxisY.Title.Alignment = StringAlignment.Far;
- ((XYDiagram)xrChart1.Diagram).AxisX.Title.Alignment = StringAlignment.Far;
- xrLabel1.LocationF = new PointF(xrLabel1.LocationF.X, NeueStartposition);
- NeueStartposition = xrLabel1.LocationF.Y + xrLabel1.SizeF.Height ;
- xrChart1.LocationF = new PointF(xrChart1.LocationF.X, NeueStartposition);
- NeueStartposition = xrChart1.LocationF.Y + xrChart1.SizeF.Height + 20;
- }
- /// <summary>
- /// 添加元素分析表格式并填充数据(大于7个元素种类的表格显示)
- /// </summary>
- private void Add_and_create_element_analysis_table_multi_element(List<DataTable> a_datas)
- {
- ElementAnalysisTableCreation elementAnalysisTableCreation = new ElementAnalysisTableCreation();
- XRTable xRTable = elementAnalysisTableCreation.add_ElementListS();
- //元素分析表
- setXRLabelData(xRTable.Rows[0].Cells[0], GetlanguageData("xrcellelementarea", "元素分析表"));//元素分析表表头
- setXRLabelData(xRTable.Rows[1].Cells[0], GetlanguageData("xrcellelementarea_details", "Reported average chemical composition (w %), area(μ m^2)"));//详情
- setXRLabelData(xRTable.Rows[2].Cells[0], GetlanguageData("xrcell_element_classify", "分类"));//分类
- setXRLabelData(xRTable.Rows[2].Cells[1], GetlanguageData("xrcell_element_subdivision", "二级分类"));//细分
- setXRLabelData(xRTable.Rows[2].Cells[2], GetlanguageData("xrcell_element_area", "面积"));//面积
- setXRLabelData(xRTable.Rows[2].Cells[3], a_datas[0].Rows[0][4].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[4], a_datas[0].Rows[0][5].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[5], a_datas[0].Rows[0][6].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[6], a_datas[0].Rows[0][7].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[7], a_datas[0].Rows[0][8].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[8], a_datas[0].Rows[0][9].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[9], a_datas[0].Rows[0][10].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[10], a_datas[0].Rows[0][11].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[11], a_datas[0].Rows[0][12].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[12], a_datas[0].Rows[0][13].ToString());
- List<List<ElementalAnalysisDEVData>> list_ElementalAnalysisData = new List<List<ElementalAnalysisDEVData>>();
- for (int i = 0; i < a_datas[1].Rows.Count; i++)
- {
- double quantity = 0;
- for (int a = 4; a < 12; a++)
- {
- if (a_datas[1].Rows[i][a].ToString() != "")
- {
- if (double.TryParse(a_datas[1].Rows[i][a].ToString(), out double number))
- {
- quantity = quantity + number;
- }
- }
- }
- 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(),
- 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(),
- 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()));
- }
- for (int i = 0; i < a_datas[1].Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_classify = new XRTableCell();
- XRTableCell tCell_subdivision = new XRTableCell();
- XRTableCell tCell_area = new XRTableCell();
- XRTableCell tCell_s1 = new XRTableCell();
- XRTableCell tCell_s2 = new XRTableCell();
- XRTableCell tCell_s3 = new XRTableCell();
- XRTableCell tCell_s4 = new XRTableCell();
- XRTableCell tCell_s5 = new XRTableCell();
- XRTableCell tCell_s6 = new XRTableCell();
- XRTableCell tCell_s7 = new XRTableCell();
- XRTableCell tCell_s8 = new XRTableCell();
- XRTableCell tCell_s9 = new XRTableCell();
- XRTableCell tCell_s10 = new XRTableCell();
- tCell_classify.WidthF = xRTable.Rows[2].Cells[0].WidthF;
- tCell_subdivision.WidthF = xRTable.Rows[2].Cells[1].WidthF;
- tCell_area.WidthF = xRTable.Rows[2].Cells[2].WidthF;
- tCell_s1.WidthF = xRTable.Rows[2].Cells[3].WidthF;
- tCell_s2.WidthF = xRTable.Rows[2].Cells[4].WidthF;
- tCell_s3.WidthF = xRTable.Rows[2].Cells[5].WidthF;
- tCell_s4.WidthF = xRTable.Rows[2].Cells[6].WidthF;
- tCell_s5.WidthF = xRTable.Rows[2].Cells[7].WidthF;
- tCell_s6.WidthF = xRTable.Rows[2].Cells[8].WidthF;
- tCell_s7.WidthF = xRTable.Rows[2].Cells[9].WidthF;
- tCell_s8.WidthF = xRTable.Rows[2].Cells[10].WidthF;
- tCell_s9.WidthF = xRTable.Rows[2].Cells[11].WidthF;
- tCell_s10.WidthF = xRTable.Rows[2].Cells[12].WidthF;
- XRTableCellData_ElementAnalysis(row, tCell_classify, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "classify");
- XRTableCellData_ElementAnalysis(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "subdivision");
- XRTableCellData_ElementAnalysis(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Area");
- XRTableCellData_ElementAnalysis(row, tCell_s1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data1");
- XRTableCellData_ElementAnalysis(row, tCell_s2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data2");
- XRTableCellData_ElementAnalysis(row, tCell_s3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data3");
- XRTableCellData_ElementAnalysis(row, tCell_s4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data4");
- XRTableCellData_ElementAnalysis(row, tCell_s5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data5");
- XRTableCellData_ElementAnalysis(row, tCell_s6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data6");
- XRTableCellData_ElementAnalysis(row, tCell_s7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data7");
- XRTableCellData_ElementAnalysis(row, tCell_s8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data8");
- XRTableCellData_ElementAnalysis(row, tCell_s9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data9");
- XRTableCellData_ElementAnalysis(row, tCell_s10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data10");
- xRTable.Rows.Add(row);
- }
- xRTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRTable.SizeF.Height + 10;
- this.Detail.Controls.Add(xRTable);
- }
- /// <summary>
- /// 添加创建元素分析表针对7钟元素以下的表格显示
- /// </summary>
- /// <param name="a_datas">大类表排序的数据</param>
- private void Add_and_create_element_analysis_table(List<DataTable> a_datas)
- {
- ElementAnalysisTableCreation elementAnalysisTableCreation = new ElementAnalysisTableCreation();
- XRTable xRTable = elementAnalysisTableCreation.add_ElementList();
- //元素分析表
- setXRLabelData(xRTable.Rows[0].Cells[0], GetlanguageData("xrcellelementarea", "元素分析表"));//元素分析表表头
- setXRLabelData(xRTable.Rows[1].Cells[0], GetlanguageData("xrcellelementarea_details", "Reported average chemical composition (w %), area(μ m^2)"));//详情
- setXRLabelData(xRTable.Rows[2].Cells[0], GetlanguageData("xrcell_element_classify", "分类"));//细分
- setXRLabelData(xRTable.Rows[2].Cells[1], GetlanguageData("xrcell_element_area", "面积"));//面积
- setXRLabelData(xRTable.Rows[2].Cells[2], a_datas[0].Rows[0][4].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[3], a_datas[0].Rows[0][5].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[4], a_datas[0].Rows[0][6].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[5], a_datas[0].Rows[0][7].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[6], a_datas[0].Rows[0][8].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[7], a_datas[0].Rows[0][9].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[8], a_datas[0].Rows[0][10].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[9], a_datas[0].Rows[0][11].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[10], a_datas[0].Rows[0][12].ToString());
- setXRLabelData(xRTable.Rows[2].Cells[11], a_datas[0].Rows[0][13].ToString());
- int ls = 0;
- DataTable REORDER_data = REORDER(a_datas[1], "TypeId");
- if (REORDER_data.Rows.Count == 0)
- return;
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- if (REORDER_data.Rows[i]["Name"].ToString() == "" || REORDER_data.Rows[i]["Name"].ToString() == null)
- {
- ls = i;
- continue;
- }
- }
- List<List<ElementalAnalysisDEVData>> list_ElementalAnalysisData = new List<List<ElementalAnalysisDEVData>>();
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- double quantity = 0;
- for (int a = 4; a < 14; a++)
- {
- if (REORDER_data.Rows[i][a].ToString() != "")
- {
- if (double.TryParse(REORDER_data.Rows[i][a].ToString(), out double number))
- {
- quantity = quantity + number;
- }
- }
- }
- list_ElementalAnalysisData.Add(set_ElementalAnalysisS(subscript.Getsubscriptstring(REORDER_data.Rows[i]["Name"].ToString()), REORDER_data.Rows[i]["Area"].ToString(),
- 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(),
- 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()));
- }
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_subdivision = new XRTableCell();
- XRTableCell tCell_area = new XRTableCell();
- XRTableCell tCell_s1 = new XRTableCell();
- XRTableCell tCell_s2 = new XRTableCell();
- XRTableCell tCell_s3 = new XRTableCell();
- XRTableCell tCell_s4 = new XRTableCell();
- XRTableCell tCell_s5 = new XRTableCell();
- XRTableCell tCell_s6 = new XRTableCell();
- XRTableCell tCell_s7 = new XRTableCell();
- XRTableCell tCell_s8 = new XRTableCell();
- XRTableCell tCell_s9 = new XRTableCell();
- XRTableCell tCell_s10 = new XRTableCell();
- tCell_subdivision.WidthF = xRTable.Rows[2].Cells[0].WidthF;
- tCell_area.WidthF = xRTable.Rows[2].Cells[1].WidthF;
- tCell_s1.WidthF = xRTable.Rows[2].Cells[2].WidthF;
- tCell_s2.WidthF = xRTable.Rows[2].Cells[3].WidthF;
- tCell_s3.WidthF = xRTable.Rows[2].Cells[4].WidthF;
- tCell_s4.WidthF = xRTable.Rows[2].Cells[5].WidthF;
- tCell_s5.WidthF = xRTable.Rows[2].Cells[6].WidthF;
- tCell_s6.WidthF = xRTable.Rows[2].Cells[7].WidthF;
- tCell_s7.WidthF = xRTable.Rows[2].Cells[8].WidthF;
- tCell_s8.WidthF = xRTable.Rows[2].Cells[9].WidthF;
- tCell_s9.WidthF = xRTable.Rows[2].Cells[10].WidthF;
- tCell_s10.WidthF = xRTable.Rows[2].Cells[11].WidthF;
- XRTableCellData_ElementAnalysis(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "subdivision");
- XRTableCellData_ElementAnalysis(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Area");
- XRTableCellData_ElementAnalysis(row, tCell_s1, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data1");
- XRTableCellData_ElementAnalysis(row, tCell_s2, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data2");
- XRTableCellData_ElementAnalysis(row, tCell_s3, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data3");
- XRTableCellData_ElementAnalysis(row, tCell_s4, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data4");
- XRTableCellData_ElementAnalysis(row, tCell_s5, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data5");
- XRTableCellData_ElementAnalysis(row, tCell_s6, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data6");
- XRTableCellData_ElementAnalysis(row, tCell_s7, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data7");
- XRTableCellData_ElementAnalysis(row, tCell_s8, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data8");
- XRTableCellData_ElementAnalysis(row, tCell_s9, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data9");
- XRTableCellData_ElementAnalysis(row, tCell_s10, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_ElementalAnalysisData[i], "Data10");
- xRTable.Rows.Add(row);
- }
- xRTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRTable.SizeF.Height + 10;
- this.Detail.Controls.Add(xRTable);
- }
- /// <summary>
- /// 设置插入元素分析表数据
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void setElementAvgGrid()
- {
- ElementalAnalysis elementalAnalysis = new ElementalAnalysis();
- //判断元素数量是否大于7
- if (basicData.GetIsThereAMajorClassification())
- {
- //得到元素分析数据列表
- List<DataTable> datas = elementalAnalysis.GetElementData(basicData, m_otsreport_export);
- //动态创建表格形式并填充数据
- Add_and_create_element_analysis_table_multi_element(datas);
- }
- else
- {
- List<DataTable> datas = elementalAnalysis.GetElementData(basicData, m_otsreport_export);
- Add_and_create_element_analysis_table(datas);
- }
- }
-
- private void add_SetINCAtableS(DataTable a_data)
- {
- CreationOfInclusionAreaTable creationOfInclusionAreaTable = new CreationOfInclusionAreaTable();
- XRTable xRTable = creationOfInclusionAreaTable.add_IncaDormS();
- setXRLabelData(xRTable.Rows[0].Cells[0], GetlanguageData("xrcellareaofinclusion", "分析物质面积比表"));//夹杂物面积比表表头
- setXRLabelData(xRTable.Rows[1].Cells[0], GetlanguageData("xrcell_inclusion_classify", "分类"));//分类
- setXRLabelData(xRTable.Rows[1].Cells[1], GetlanguageData("xrcell_inclusion_subdivision", "二级分类"));//细分类
- setXRLabelData(xRTable.Rows[1].Cells[2], GetlanguageData("xrcell_inclusion_area", "面积(μm^2)"));//面积(μm^2)
- setXRLabelData(xRTable.Rows[1].Cells[3], GetlanguageData("xrcell_inclusion_percentageofinca", "占比(%)"));//夹杂物比(%)
- setXRLabelData(xRTable.Rows[1].Cells[4], GetlanguageData("xrcell_inclusion_fieldratio", "视场占比(%)"));//视场占比(%)
- List<List<AreaOfInclusionDEVData>> list_AreaOfInclusion = new List<List<AreaOfInclusionDEVData>>();
- for (int i = 0; i < a_data.Rows.Count; i++)
- {
- 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(),
- a_data.Rows[i]["inca_FieldRatio"].ToString()));
- }
- double area_total = 0;
- float Fieldratio = 0;
- for (int i = 0; i < a_data.Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_classify = new XRTableCell();
- XRTableCell tCell_subdivision = new XRTableCell();
- XRTableCell tCell_area = new XRTableCell();
- XRTableCell tCell_inca_proportion = new XRTableCell();
- XRTableCell tCell_inca_FieldRatio = new XRTableCell();
- XRTableCellData_AreaOfInclusion(row, tCell_classify, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "classify");
- XRTableCellData_AreaOfInclusion(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "subdivision");
- XRTableCellData_AreaOfInclusion(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "Area");
- XRTableCellData_AreaOfInclusion(row, tCell_inca_proportion, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_proportion");
- XRTableCellData_AreaOfInclusion(row, tCell_inca_FieldRatio, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_FieldRatio");
- xRTable.Rows.Add(row);
- if (a_data.Rows[i]["Class"].ToString() != "")
- {
- area_total = area_total + Convert.ToDouble(a_data.Rows[i]["Area"]);
- Fieldratio = Fieldratio+ float.Parse(a_data.Rows[i]["inca_FieldRatio"].ToString());
- }
- }
- XRTableRow row_z = new XRTableRow();
- XRTableCell tCell_classify_z = new XRTableCell();
- tCell_classify_z.WidthF = 267.2f;
- tCell_classify_z.Text = "统计";
- XRTableCell tCell_area_z = new XRTableCell();
- tCell_area_z.WidthF = 133.6f;
- tCell_area_z.Text = area_total.ToString();
- XRTableCell tCell_inca_proportion_z = new XRTableCell();
- tCell_inca_proportion_z.WidthF = 133.6f;
- tCell_inca_proportion_z.Text = "100%";
- XRTableCell tCell_inca_FieldRatio_z = new XRTableCell();
- tCell_inca_FieldRatio_z.WidthF = 133.6f;
- tCell_inca_FieldRatio_z.Text = Fieldratio.ToString()+"%";
- row_z.WidthF = 668f;
- row_z.Borders = DevExpress.XtraPrinting.BorderSide.All;
- row_z.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- row_z.Controls.Add(tCell_classify_z);
- row_z.Controls.Add(tCell_area_z);
- row_z.Controls.Add(tCell_inca_proportion_z);
- row_z.Controls.Add(tCell_inca_FieldRatio_z);
- xRTable.Rows.Add(row_z);
- xRTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRTable.SizeF.Height;
- this.Detail.Controls.Add(xRTable);
- }
- private void add_SetINCAtable(DataTable a_data)
- {
- CreationOfInclusionAreaTable creationOfInclusionAreaTable = new CreationOfInclusionAreaTable();
- XRTable xRTable = creationOfInclusionAreaTable.add_IncaDorm();
- setXRLabelData(xRTable.Rows[0].Cells[0], GetlanguageData("xrcellareaofinclusion", "夹杂物面积比表"));//夹杂物面积比表表头
- setXRLabelData(xRTable.Rows[1].Cells[0], "分类");//细分类
- setXRLabelData(xRTable.Rows[1].Cells[1], GetlanguageData("xrcell_inclusion_area", "面积(μm^2)"));//面积(μm^2)
- setXRLabelData(xRTable.Rows[1].Cells[2], GetlanguageData("xrcell_inclusion_percentageofinca", "夹杂物比(%)"));//夹杂物比(%)
- setXRLabelData(xRTable.Rows[1].Cells[3], GetlanguageData("xrcell_inclusion_fieldratio", "视场占比(%)"));//视场占比(%)
- int ls = 0;
- DataTable REORDER_data = a_data.Copy();
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- if (REORDER_data.Rows[i]["subdivision"].ToString() == "" || REORDER_data.Rows[i]["subdivision"].ToString() == null)
- {
- ls = i;
- continue;
- }
- }
- REORDER_data.Rows[ls].Delete();
- REORDER_data.AcceptChanges();
- List<List<AreaOfInclusionDEVData>> list_AreaOfInclusion = new List<List<AreaOfInclusionDEVData>>();
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- 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(),
- REORDER_data.Rows[i]["inca_FieldRatio"].ToString()));
- }
- for (int i = 0; i < REORDER_data.Rows.Count; i++)
- {
- XRTableRow row = new XRTableRow();
- XRTableCell tCell_subdivision = new XRTableCell();
- XRTableCell tCell_area = new XRTableCell();
- XRTableCell tCell_inca_proportion = new XRTableCell();
- XRTableCell tCell_inca_FieldRatio = new XRTableCell();
- XRTableCellData_AreaOfInclusion(row, tCell_subdivision, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "subdivision");
- XRTableCellData_AreaOfInclusion(row, tCell_area, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "Area");
- XRTableCellData_AreaOfInclusion(row, tCell_inca_proportion, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_proportion");
- XRTableCellData_AreaOfInclusion(row, tCell_inca_FieldRatio, Schriftart_english, DevExpress.XtraPrinting.TextAlignment.MiddleCenter, "Text", list_AreaOfInclusion[i], "inca_FieldRatio");
- xRTable.Rows.Add(row);
- }
- xRTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + xRTable.SizeF.Height+10;
- this.Detail.Controls.Add(xRTable);
- }
- /// <summary>
- /// 设置插入夹杂物面积比表数据
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void setINCAtable()
- {
- InclusionProportion inclusionProportion = new InclusionProportion();
- DataTable dt = inclusionProportion.GetINCAtable(basicData, FieldOfViewArea, TemplateClass);
- if (basicData.GetIsThereAMajorClassification())
- add_SetINCAtableS(dt);
- else
- add_SetINCAtable(dt);
- }
- public void XRPageBreak()
- {
- XRPageBreak xRPage = new XRPageBreak();
- xRPage.Name = "kllb_Page";
- xRPage.LocationF = new PointF(0, NeueStartposition);
- this.Detail.Controls.Add(xRPage);
- NeueStartposition = NeueStartposition+ xRPage.HeightF + 1;
- }
- /// <summary>
- /// 设置大分类图表
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void set_incaPIC_classify(c_TemplateClass m_mbszclass)
- {
- InclusionProportion inclusionProportion = new InclusionProportion();
- DataTable data = inclusionProportion.Get_incaPIC_classify(dev_sczs_text.Text, TemplateClass, m_otsreport_export);
- if (data.Rows.Count == 0)
- {
- return;
- }
- for (int i = 0; i < data.Rows.Count; i++)
- {
- if (data.Rows[i]["Class"].ToString() == "Other")
- {
- data.Rows[i].Delete();
- }
- }
- data.AcceptChanges();
- DataView dv = data.DefaultView;
- dv.Sort = "Cunt DESC";
- DataTable dt_data = dv.ToTable();
- double total = 0;
- double TotalArea = 0;
- for (int i = 0; i < dt_data.Rows.Count; i++)
- {
- total = total + Convert.ToDouble(dt_data.Rows[i]["Cunt"]);
- TotalArea = TotalArea + Convert.ToDouble(dt_data.Rows[i]["Area"]);
- }
- ParticleSizeTableCreation particleSizeTableCreation = new ParticleSizeTableCreation();
- XRTable xrTa_ParticleSizeTable = particleSizeTableCreation.addMaterialTestingDamx();
- for (int i = 0; i < dt_data.Rows.Count; i++)
- {
- XRTableRow header_row = new XRTableRow();
- XRTableCell header_tCell_1 = new XRTableCell();
- XRTableCell header_tCell_2 = new XRTableCell();
- XRTableCell header_tCell_3 = new XRTableCell();
- XRTableCell header_tCell_4 = new XRTableCell();
- XRTableCell header_tCell_5 = new XRTableCell();
- header_tCell_1.Text = dt_data.Rows[i]["Class"].ToString();
- header_tCell_1.WidthF = 126f;
- header_tCell_2.Text = dt_data.Rows[i]["Cunt"].ToString();
- header_tCell_2.WidthF = 126f;
- double pp = Convert.ToDouble(dt_data.Rows[i]["Cunt"]) / total * 100;
- double ppr = Math.Round(pp, 2);
- header_tCell_3.Text = ppr.ToString();
- header_tCell_3.WidthF = 126f;
- header_tCell_4.Text = Math.Round(Convert.ToDouble(dt_data.Rows[i]["Area"]), 2).ToString();
- header_tCell_4.WidthF = 126f;
- double paa = Convert.ToDouble(dt_data.Rows[i]["Area"]) / TotalArea * 100;
- double paar = Math.Round(paa, 2);
- header_tCell_5.Text = paar.ToString();
- header_tCell_5.WidthF = 126f;
- header_row.Cells.Add(header_tCell_1);
- header_row.Cells.Add(header_tCell_2);
- header_row.Cells.Add(header_tCell_3);
- header_row.Cells.Add(header_tCell_4);
- header_row.Cells.Add(header_tCell_5);
- xrTa_ParticleSizeTable.Rows.Add(header_row);
- }
- XRTableRow xR = particleSizeTableCreation.addMaterialTestingTotal();
- xR.Cells[1].Text = total.ToString();
- xR.Cells[3].Text = Math.Round(TotalArea, 2).ToString();
- xrTa_ParticleSizeTable.Rows.Add(xR);
- xrTa_ParticleSizeTable.LocationF = new PointF(10f, NeueStartposition);
- NeueStartposition = NeueStartposition + xrTa_ParticleSizeTable.HeightF;
- this.Detail.Controls.Add(xrTa_ParticleSizeTable);
- DataTable dt = new DataTable();
- dt.Columns.Add("nameCunt");
- dt.Columns.Add("nameArea");
- dt.Columns.Add("Cunt");
- dt.Columns.Add("Area");
- for (int i = 0; i < dt_data.Rows.Count; i++)
- {
- DataRow dr = dt.NewRow();
- dr["nameCunt"] = dt_data.Rows[i]["Class"].ToString() + " " + dt_data.Rows[i]["Cunt"].ToString();
- dr["nameArea"] = dt_data.Rows[i]["Class"].ToString() + " " + dt_data.Rows[i]["Area"].ToString();
- dr["Cunt"] = dt_data.Rows[i]["Cunt"].ToString();
- dr["Area"] = dt_data.Rows[i]["Area"].ToString();
- dt.Rows.Add(dr);
- }
- if (m_mbszclass.M_JZWZB.b_ck_surfaceBigNumber || m_mbszclass.M_JZWZB.b_ck_surfaceBigArea)
- {
- XRPageBreak();
- //图表填充参数
- if (m_mbszclass.M_JZWZB.b_ck_surfaceBigNumber)
- ChartFillingParameters("大分类数量占比图", dt, "nameCunt", "Cunt", inclusionProportion, m_mbszclass, m_mbszclass.M_KLFXJG.GroupShapeSelection);
- if (m_mbszclass.M_JZWZB.b_ck_surfaceBigArea)
- ChartFillingParameters("大分类面积占比图", dt, "nameArea", "Area", inclusionProportion, m_mbszclass, m_mbszclass.M_KLFXJG.GroupShapeSelection);
- }
- }
- public void set_incaPIC_subdivision(c_TemplateClass m_mbszclass)
- {
- ViewType viewType;
- DefaultBoolean VisDefaultBoolean;
- string Pat;
- string CPat;
- if (m_mbszclass.M_KLFXJG.SubdivisionGraphicSelection == 0)
- {
- viewType = ViewType.Pie;
- Pat = "{A}";
- CPat = "{A}";
- VisDefaultBoolean = DefaultBoolean.True;
- }
- else if (m_mbszclass.M_KLFXJG.SubdivisionGraphicSelection == 1)
- {
- viewType = ViewType.Bar;
- Pat = "{V}";
- CPat = "{V}";
- VisDefaultBoolean = DefaultBoolean.False;
- }
- else /*if (m_mbszclass.M_KLFXJG.GroupShapeSelection == 2)*/
- {
- viewType = ViewType.Line;
- Pat = "{V}";
- CPat = "{V}";
- VisDefaultBoolean = DefaultBoolean.False;
- }
- if (m_mbszclass.M_KLFXJG.b_ck_klcc_xfl)
- {
- InclusionProportion inclusionProportion = new InclusionProportion();
- DataTable data = inclusionProportion.Get_incaPIC_subdivision(TemplateClass, m_otsreport_export);
- if (data.Rows.Count == 0)
- {
- return;
- }
- xrChart_incaSubdivision.Visible = true;
- xrLabel_inca_pic_subdivision.Visible = true;
- xrLabel_inca_pic_subdivision.LocationF = new PointF(xrLabel_inca_pic_subdivision.LocationF.X, NeueStartposition);
- NeueStartposition = xrLabel_inca_pic_subdivision.LocationF.Y + xrLabel_inca_pic_subdivision.Height + 1;
- for (int i = 0; i < data.Rows.Count; i++)
- {
- if (data.Rows[i]["TypeName"].ToString() == "Not Identified")
- {
- data.Rows[i].Delete();
- }
- }
- data.AcceptChanges();
- DataView dv = data.DefaultView;
- dv.Sort = "con DESC";
- DataTable dt_data = dv.ToTable();
- for (int i = 0; i < dt_data.Rows.Count; i++)
- {
- dt_data.Rows[i]["TypeName"] = subscript.Getsubscriptstring(dt_data.Rows[i]["TypeName"].ToString());
- dt_data.Rows[i]["GroupName"] = subscript.Getsubscriptstring(dt_data.Rows[i]["GroupName"].ToString());
- }
- // 实例化饼图对象
- Series pieSeriesClass = new Series("夹杂物面积比细分类", viewType);
- for (int i = 0; i < dt_data.Rows.Count; i++)
- {
- string name = dt_data.Rows[i]["TypeName"].ToString();
- double Cunt = Convert.ToDouble(dt_data.Rows[i]["con"]);
- pieSeriesClass.Points.Add(new SeriesPoint(name, Cunt));
- }
- pieSeriesClass.LabelsVisibility = DefaultBoolean.True;
- pieSeriesClass.Label.TextPattern = Pat;
- if (m_mbszclass.M_KLFXJG.GroupShapeSelection == 0)
- {
- pieSeriesClass.LabelsVisibility = DefaultBoolean.False;
- }
- xrChart_incaSubdivision.Series.Add(pieSeriesClass);
- xrChart_incaSubdivision.Legend.Visibility = VisDefaultBoolean;
- xrChart_incaSubdivision.LocationF = new PointF(30f, NeueStartposition);
- NeueStartposition = xrChart_incaSubdivision.LocationF.Y + xrChart_incaSubdivision.Height + 1;
- }
-
- }
- public static Color FromHex(string hex)
- {
- hex = hex.Replace("#", ""); // 移除 # 前缀
- byte a = 255; // 默认Alpha值为255(不透明)
- byte r = Convert.ToByte(hex.Substring(0, 2), 16);
- byte g = Convert.ToByte(hex.Substring(2, 2), 16);
- byte b = Convert.ToByte(hex.Substring(4, 2), 16);
- return Color.FromArgb(a, r, g, b);
- }
- /// <summary>
- /// 三元图
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void InsertReportTemplateChart_Trianglediagram()
- {
- this.Detail.Controls.Add(add_label(GetlanguageData("dev_ternary_diagram", "三元图")));
- List<Color> Color_list = new List<Color>();
- Color_list.Add(FromHex("#0f4471"));
- Color_list.Add(FromHex("#FFD700"));
- Color_list.Add(FromHex("#ff5722"));
- Color_list.Add(FromHex("#5628b4"));
- Color_list.Add(FromHex("#20BF55"));
- Color_list.Add(FromHex("#f23557"));
- Color_list.Add(FromHex("#118df0"));
- Color_list.Add(FromHex("#FF00FF"));
- Color_list.Add(FromHex("#d3327b"));
- Color_list.Add(FromHex("#ae318a"));
- Color_list.Add(FromHex("#993090"));
- Color_list.Add(FromHex("#6f3071"));
- Color_list.Add(FromHex("#7711AF"));
- Color_list.Add(FromHex("#CF77FF"));
- Color_list.Add(FromHex("#AE004F"));
- Color_list.Add(FromHex("#F35872"));
- Color_list.Add(FromHex("#FA7729"));
- Color_list.Add(FromHex("#FFC526"));
- Color_list.Add(FromHex("#F8E71C"));
- Color_list.Add(FromHex("#34ADAE"));
- Color_list.Add(FromHex("#3DDFD2"));
- Color_list.Add(FromHex("#A0FFFF"));
- TernaryDiagram ternaryDiagram = new TernaryDiagram();
- for (int i = 0; i < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count; i = i + 4)
- {
- var xRPicture = set_syt_pic_legend(Color_list, i, ternaryDiagram);
- if (i < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
- {
- set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i], Color_list, new PointF(10f, NeueStartposition), ternaryDiagram);
- }
- if (i + 1 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
- {
- set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 1], Color_list, new PointF(343.8f, NeueStartposition), ternaryDiagram);
- }
- if (i + 2 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
- {
- set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 2], Color_list, new PointF(10f, NeueStartposition + 345), ternaryDiagram);
- }
- if (i + 3 < TemplateClass.M_SYXT.list_lbv_syxt_mblb_index.Count)
- {
- set_syt_pic(TemplateClass, TemplateClass.M_SYXT.list_lbv_syxt_mblb_index[i + 3], Color_list, new PointF(343.8f, NeueStartposition + 345), ternaryDiagram);
- }
- XRLine rLine = new XRLine();
- rLine.SizeF = new SizeF(5f, 698.5f);
- rLine.LineDirection = LineDirection.Vertical;
- rLine.LocationF = new PointF(335f, NeueStartposition + 2);
- this.Detail.Controls.Add(rLine);
- XRLine rLine_level = new XRLine();
- rLine_level.SizeF = new SizeF(668f, 5f);
- rLine_level.LineDirection = LineDirection.Horizontal;
- rLine_level.LocationF = new PointF(10f, NeueStartposition + 345);
- this.Detail.Controls.Add(rLine_level);
- XRPageBreak xRPage = new XRPageBreak();
- xRPage.LocationF = new PointF(0, NeueStartposition + 850);
- this.Detail.Controls.Add(xRPicture);
- NeueStartposition = NeueStartposition + 870;
- this.Detail.Controls.Add(xRPage);
- }
- }
- /// <summary>
- /// 颗粒列表
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void set_Particle_List_data()
- {
- ParticleList particleList = new ParticleList();
- ParticleListCreation particleListCreation = new ParticleListCreation();
- List<DataTable> datas = particleList.Get_dev_kllb_data(TemplateClass, m_otsreport_export, basicData,out List<DataTable> OutDt );
- //DataTable dataTable = particleList.Get_dev_kllb_data(TemplateClass, m_otsreport_export, out DataTable data, out List<DataTable> ElementIcons);
- FrameData = OutDt.Copy();
- for (int i = 0; i < datas.Count; i++)
- {
- if (datas[i].Rows.Count == 0)
- {
- continue;
- }
- XRPageBreak();
- XRPageBreak xRPage = new XRPageBreak();
- xRPage.Name = "kllb_Page";
- xRPage.LocationF = new PointF(0, NeueStartposition);
- this.Detail.Controls.Add(xRPage);
- //表头
- XRTable Template = particleListCreation.CreateParticleListHeader(
- "颗粒列表(" + datas[i].Rows[0]["GroupName"] + "组)",
- "Selected particles based on:" + TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString() + "(μm)",
- Schriftart_chinese, NeueStartposition);
- NeueStartposition = NeueStartposition + Template.SizeF.Height+25;
- this.Detail.Controls.Add(Template);
- for (int a = 0; a < datas[i].Rows.Count; a++)
- {
- XRTable table = particleListCreation.add_XRTable(Schriftart_chinese);
- add_Particle_List(TemplateClass, datas[i], a, table);
- }
- NeueStartposition = NeueStartposition + 10;
- }
- }
- /// <summary>
- /// 颗粒列表 帧图
- /// </summary>
- /// <param name="TemplateClass"></param>
- public void set_Particle_List_data_frame()
- {
- ParticleListCreation particleListCreation = new ParticleListCreation();
- ParticleList particleList = new ParticleList();
- //particleList.Get_dev_kllb_data_frame(TemplateClass, out List<DataTable> dt_pic, out List<List<DataTable>> listData, m_otsreport_export, FrameData);
- particleList.Get_dev_kllb_data_frame_pic(TemplateClass, out DataTable dt_pic, out List<DataTable> listData, m_otsreport_export, FrameData);
- for (int i = 0; i < listData.Count; i++)
- {
- for (int a = 0; a < listData[i].Rows.Count; a++)
- {
- listData[i].Rows[a]["Class"] = subscript.Getsubscriptstring(listData[i].Rows[a]["Class"].ToString());
- }
- }
- for (int i = 0; i < dt_pic.Rows.Count; i++)
- {
- //分页符
- XRPageBreak xRPage = new XRPageBreak();
- xRPage.Name = "framePage_" + i.ToString();
- xRPage.LocationF = new PointF(0, NeueStartposition);
- NeueStartposition = NeueStartposition + 10;
- this.Detail.Controls.Add(xRPage);
- //表头
- XRTable Template = particleListCreation.CreateParticleListHeader(GetlanguageData("dev_frame_diagram", "帧图") + dt_pic.Rows[i]["id"],
- NeueStartposition, Schriftart_chinese);
-
- this.Detail.Controls.Add(Template);
- //图片
- XRPictureBox xRPicture = new XRPictureBox();
- xRPicture.Name = "frameName_" + i.ToString();
- xRPicture.SizeF = new SizeF(688f, 485f);
- xRPicture.ImageAlignment = DevExpress.XtraPrinting.ImageAlignment.MiddleCenter;
- xRPicture.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
- ImageSource imageSource = new ImageSource((Bitmap)dt_pic.Rows[i]["Field_pic"]);
- xRPicture.ImageSource = imageSource;
- xRPicture.LocationF = new PointF(0, NeueStartposition + Template.SizeF.Height);
- xRPicture.Borders = DevExpress.XtraPrinting.BorderSide.All;
- this.Detail.Controls.Add(xRPicture);
- NeueStartposition = NeueStartposition + xRPicture.SizeF.Height + Template.SizeF.Height;
- for (int a = 0; a < listData.Count; a++)
- {
- if (dt_pic.Rows[i]["id"].ToString() == listData[a].Rows[0]["FieldId"].ToString())
- {
- for (int b = 0; b < listData[a].Rows.Count; b++)
- {
- //数据表
- XRTable xRTable = particleListCreation.add_XRTable_frame(Schriftart_chinese);
- xRTable.Rows[0].Cells[0].Text = GetlanguageData("dev_image", "图像");
- xRTable.Rows[0].Cells[0].Font = new Font(Schriftart_chinese, xRTable.Rows[0].Cells[0].Font.Size);
- xRTable.Rows[0].Cells[1].Text = GetlanguageData("dev_class", "分类");
- xRTable.Rows[0].Cells[1].Font = new Font(Schriftart_chinese, xRTable.Rows[0].Cells[1].Font.Size);
- xRTable.Rows[0].Cells[2].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString();
- xRTable.Rows[0].Cells[3].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p2.ToString();
- xRTable.Rows[1].Cells[1].Text = listData[a].Rows[b]["Class"].ToString();
- xRTable.Rows[1].Cells[2].Text = listData[a].Rows[b]["pid"].ToString();
- xRTable.Rows[1].Cells[3].Text = listData[a].Rows[b]["Size"].ToString();
- for (int c = 1; c < 10; c++)
- {
- xRTable.Rows[2].Cells[c].Text = listData[a].Rows[b]["ColName" + (c).ToString()].ToString();
- xRTable.Rows[3].Cells[c].Text = listData[a].Rows[b]["ColVal" + (c).ToString()].ToString();
- }
- xRTable.LocationF = new PointF(0, NeueStartposition);
- XRPictureBox xRPicture1 = new XRPictureBox();
- xRPicture1.ImageSource = new ImageSource((Bitmap)listData[a].Rows[b]["pic"]);
- xRPicture1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
- xRPicture1.SizeF = new SizeF(94, 70);
- xRPicture1.LocationF = new PointF(0, NeueStartposition + 20);
- this.Detail.Controls.Add(xRTable);
- this.Detail.Controls.Add(xRPicture1);
- NeueStartposition = NeueStartposition + xRTable.SizeF.Height + 1;
- }
- }
- }
- }
- }
- #endregion
-
- private void setXRLabelData(XRLabel cell, string str)
- {
- cell.Text = str;
- cell.Font = new Font(Schriftart_chinese, cell.Font.Size);
- }
- /// <summary>
- /// 读取报告控件中英文
- /// </summary>
- /// <param name="strName"></param>
- /// <param name="languageData"></param>
- /// <returns></returns>
- private string GetlanguageData(string strName,string TextName)
- {
- string str = TextName;
- try
- {
- str = table[strName].ToString();
- }
- catch { }
-
- return str;
- }
- #region 整理成DEV需要的数据格式
- private void XRTableCellData(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<ParticleSizeDEVData> switchDEVDatas, string cellName)
- {
- rTableCell.TextAlignment = textAlignment;
- rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
- xR.Cells.Add(rTableCell);
- rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
- }
- private void XRTableCellData_ElementAnalysis(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<ElementalAnalysisDEVData> switchDEVDatas, string cellName)
- {
- rTableCell.TextAlignment = textAlignment;
- rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
- xR.Cells.Add(rTableCell);
- rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
- }
- private void XRTableCellData_AreaOfInclusion(XRTableRow xR, XRTableCell rTableCell, string typeface, DevExpress.XtraPrinting.TextAlignment textAlignment, string cellText, List<AreaOfInclusionDEVData> switchDEVDatas, string cellName)
- {
- rTableCell.TextAlignment = textAlignment;
- rTableCell.Font = new Font(typeface, rTableCell.Font.Size);
- xR.Cells.Add(rTableCell);
- rTableCell.DataBindings.Add(cellText, switchDEVDatas, cellName);
- }
- /// <summary>
- /// 颗粒尺寸表向list中插入数据
- /// </summary>
- /// <param name="Class"></param>
- /// <param name="Name"></param>
- /// <param name="total"></param>
- /// <param name="size_1"></param>
- /// <param name="size_2"></param>
- /// <param name="size_3"></param>
- /// <param name="size_4"></param>
- /// <param name="size_5"></param>
- /// <param name="size_6"></param>
- /// <param name="size_7"></param>
- /// <returns></returns>
- private List<ParticleSizeDEVData> switch_ParticleSize(string Class, string Name,
- string total, string size_1, string size_2, string size_3, string size_4, string size_5,
- string size_6, string size_7, string size_8, string size_9, string size_10, string size_11
- , string size_12)
- {
- List<ParticleSizeDEVData> oTS_DEVs = new List<ParticleSizeDEVData>();
- oTS_DEVs.Add(new ParticleSizeDEVData
- {
- size_total = total,
- size_Class = Class,
- size_Name = Name,
- size_1 = size_1,
- size_2 = size_2,
- size_3 = size_3,
- size_4 = size_4,
- size_5 = size_5,
- size_6 = size_6,
- size_7 = size_7,
- size_8 = size_8,
- size_9 = size_9,
- size_10 = size_10,
- size_11 = size_11,
- size_12 = size_12
- });
- return oTS_DEVs;
- }
- /// <summary>
- /// 元素分析表向list中插入数据
- /// </summary>
- /// <param name="classify">分组名称</param>
- /// <param name="subdivision">颗粒条目名称</param>
- /// <param name="area">面积</param>
- /// <param name="s1">数据1</param>
- /// <param name="s2">数据2</param>
- /// <param name="s3">数据3</param>
- /// <param name="s4">数据4</param>
- /// <param name="s5">数据5</param>
- /// <param name="s6">数据6</param>
- /// <param name="s7">数据7</param>
- /// <param name="s8">数据8</param>
- /// <param name="s9">数据9</param>
- /// <param name="s10">数据10</param>
- /// <returns></returns>
- 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)
- {
- List<ElementalAnalysisDEVData> oTS_DEVs = new List<ElementalAnalysisDEVData>();
- oTS_DEVs.Add(new ElementalAnalysisDEVData
- {
- classify = classify,
- subdivision = subdivision,
- Area = area,
- Data1 = s1,
- Data2 = s2,
- Data3 = s3,
- Data4 = s4,
- Data5 = s5,
- Data6 = s6,
- Data7 = s7,
- Data8 = s8,
- Data9 = s9,
- Data10 = s10
- });
- return oTS_DEVs;
- }
- 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)
- {
- List<ElementalAnalysisDEVData> oTS_DEVs = new List<ElementalAnalysisDEVData>();
- oTS_DEVs.Add(new ElementalAnalysisDEVData
- {
- subdivision = subdivision,
- Area = area,
- Data1 = s1,
- Data2 = s2,
- Data3 = s3,
- Data4 = s4,
- Data5 = s5,
- Data6 = s6,
- Data7 = s7,
- Data8 = s8,
- Data9 = s9,
- Data10 = s10
- });
- return oTS_DEVs;
- }
- /// <summary>
- /// 夹杂物分析表(清洁度不需要)
- /// </summary>
- /// <param name="classify"></param>
- /// <param name="subdivision"></param>
- /// <param name="Area"></param>
- /// <param name="inca_proportion"></param>
- /// <param name="inca_FieldRatio"></param>
- /// <returns></returns>
- private List<AreaOfInclusionDEVData> set_AreaOfInclusion(string classify, string subdivision, string Area, string inca_proportion, string inca_FieldRatio)
- {
- List<AreaOfInclusionDEVData> oTS_DEVs = new List<AreaOfInclusionDEVData>();
- oTS_DEVs.Add(new AreaOfInclusionDEVData
- {
- classify = classify,
- subdivision = subdivision,
- Area = Area,
- inca_proportion = inca_proportion,
- inca_FieldRatio = inca_FieldRatio
- });
- return oTS_DEVs;
- }
- #endregion
- #region 三元相图数据
- /// <summary>
- /// 动态生成加载三元图图片加分页符
- /// </summary>
- /// <param name="syt_pic_name"></param>
- /// <param name="syt_Page_name"></param>
- /// <param name="TemplateClass"></param>
- /// <param name="index"></param>
- private void set_syt_pic(c_TemplateClass TemplateClass, int index, List<Color> Color_list, PointF position, TernaryDiagram ternaryDiagram)
- {
- XRPictureBox xRPicture = new XRPictureBox();
- xRPicture.LocationF = position;
- xRPicture.SizeF = new SizeF(321f, 330.2f);
- ImageSource imageSource = new ImageSource(ternaryDiagram.DrawATernaryPicture(index, TemplateClass, Color_list,m_otsreport_export, PartSizeFile));
- xRPicture.ImageSource = imageSource;
- xRPicture.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
- xRPicture.Visible = true;
- this.Detail.Controls.Add(xRPicture);
- }
- private XRPictureBox set_syt_pic_legend(List<Color> Color_list, int i, TernaryDiagram ternaryDiagram)
- {
- XRPictureBox xRPicture_legend = new XRPictureBox();
- xRPicture_legend.Name = "XRPicture" + i.ToString();
- xRPicture_legend.LocationF = new PointF(400f, NeueStartposition);
- xRPicture_legend.SizeF = new SizeF(260f, 120f);
- xRPicture_legend.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
- ImageSource imageSource_legend = new ImageSource(ternaryDiagram.DrawATernaryDiagramLegend(Color_list,m_otsreport_export, PartSizeFile));
- xRPicture_legend.ImageSource = imageSource_legend;
- NeueStartposition = xRPicture_legend.LocationF.Y + xRPicture_legend.SizeF.Height;
- return xRPicture_legend;
- }
- #endregion
- private XRTable add_label(string str)
- {
- XRTable Template = new XRTable();
- XRTableRow Template_Rows_1 = new XRTableRow();
- XRTableCell Template_Rows1_Cell_2 = new XRTableCell();
- Template_Rows1_Cell_2.WidthF = 630f;
- setXRLabelData(Template_Rows1_Cell_2, str);
- //Template_Rows1_Cell_2.Text = str;
- Template_Rows_1.Controls.Add(Template_Rows1_Cell_2);
- Template.Rows.Add(Template_Rows_1);
- Template.WidthF = 630f;
- Template.Borders = DevExpress.XtraPrinting.BorderSide.All;
- Template.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- Template.LocationF = new PointF(30.42f, NeueStartposition);
- Template.BackColor = Color.DarkGray;
- NeueStartposition = Template.LocationF.Y + Template.SizeF.Height;
- return Template;
- }
-
- #region 颗粒列表
- private void add_Particle_List(c_TemplateClass TemplateClass, DataTable dataTable, int position, XRTable xRTable)
- {
- XRTable table = new XRTable();
- table = xRTable;
- table.Name = "table_kllb_" + position.ToString();
- table.Rows[0].Cells[0].Text = "ID";
- table.Rows[0].Cells[1].Text = "Class";
- table.Rows[0].Cells[2].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p1.ToString();
- table.Rows[0].Cells[3].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p2.ToString();
- table.Rows[0].Cells[4].Text = TemplateClass.M_KLLBXX.str_cb_kllb_sort_p3.ToString();
- table.Rows[1].Cells[0].Text = dataTable.Rows[position]["pid"].ToString();
- table.Rows[1].Cells[1].Text = dataTable.Rows[position]["Class"].ToString();
- table.Rows[1].Cells[2].Text = dataTable.Rows[position]["Size"].ToString();
- table.Rows[1].Cells[3].Text = dataTable.Rows[position]["DMAX"].ToString();
- table.Rows[1].Cells[4].Text = dataTable.Rows[position]["DMIN"].ToString();
- for (int i = 0; i < 10; i++)
- {
- table.Rows[2].Cells[i].Text = dataTable.Rows[position]["ColName" + (i + 1).ToString()].ToString();
- string str_ColVal = "";
- if (dataTable.Rows[position]["ColVal" + (i + 1).ToString()].ToString() == "0")
- {
- str_ColVal = "0";
- }
- else
- {
- str_ColVal = dataTable.Rows[position]["ColVal" + (i + 1).ToString()].ToString();
- }
- table.Rows[3].Cells[i].Text = str_ColVal;
- }
- XRPictureBox xRPicture2 = new XRPictureBox();
- xRPicture2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.AutoSize;
- xRPicture2.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p3"]);
- XRPictureBox xRPicture3 = new XRPictureBox();
- xRPicture3.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p1"]);
- xRPicture3.SizeF = new SizeF(120f, 120f);
- xRPicture3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
- XRPictureBox xRPicture4 = new XRPictureBox();
- xRPicture4.ImageSource = new ImageSource((Bitmap)dataTable.Rows[position]["p2"]);
- xRPicture4.SizeF = new SizeF(120f, 120f);
- xRPicture4.Sizing = DevExpress.XtraPrinting.ImageSizeMode.Squeeze;
- table.Rows[4].Cells[0].Controls.Add(xRPicture3);
- table.Rows[4].Cells[1].Controls.Add(xRPicture4);
- table.Rows[4].Cells[2].Controls.Add(xRPicture2);
-
- table.Rows[4].Cells[2].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- table.Visible = true;
- table.LocationF = new PointF(0, NeueStartposition);
- table.SendToBack();
- table.BorderWidth = 0.5f;
- this.Detail.Controls.Add(table);
- NeueStartposition = table.SizeF.Height + NeueStartposition;
- }
- #endregion
-
- private void xrLabel_pageinfo_PrintOnPage(object sender, PrintOnPageEventArgs e)
- {
- int pagecount = e.PageCount;
- int pageindex = e.PageIndex;
- if (pageindex < 1)
- {
- this.xrLabel_pageinfo.Visible = false;
- }
- else
- {
- xrLabel_pageinfo.Font = new Font(Schriftart_chinese, xrLabel_pageinfo.Font.Size);
- this.xrLabel_pageinfo.Visible = true;
- this.xrLabel_pageinfo.Text = string.Format(GetlanguageData("dev_page", "页码") + " {0} "+ GetlanguageData("dev_of", "/") + " {1}" , pageindex, pagecount - 1);
- }
- }
- }
- public class ParticleSizeDEVData
- {
- /// <summary>
- /// 分组名称
- /// </summary>
- public string size_Class { get; set; }
- /// <summary>
- /// 种类条目名称
- /// </summary>
- public string size_Name { get; set; }
- /// <summary>
- /// 数量
- /// </summary>
- public string size_total { get; set; }
- public string size_1 { get; set; }
- public string size_2 { get; set; }
- public string size_3 { get; set; }
- public string size_4 { get; set; }
- public string size_5 { get; set; }
- public string size_6 { get; set; }
- public string size_7 { get; set; }
- public string size_8 { get; set; }
- public string size_9 { get; set; }
- public string size_10 { get; set; }
- public string size_11 { get; set; }
- public string size_12 { get; set; }
- }
- /// <summary>
- /// 存储元素数据
- /// </summary>
- public class ElementalAnalysisDEVData
- {
- //分组名称
- public string classify { get; set; }
- //种类条目名称
- public string subdivision { get; set; }
- //面积
- public string Area { get; set; }
- public string Data1 { get; set; }
- public string Data2 { get; set; }
- public string Data3 { get; set; }
- public string Data4 { get; set; }
- public string Data5 { get; set; }
- public string Data6 { get; set; }
- public string Data7 { get; set; }
- public string Data8 { get; set; }
- public string Data9 { get; set; }
- public string Data10 { get; set; }
- }
- public class AreaOfInclusionDEVData
- {
- public string classify { get; set; }
- public string subdivision { get; set; }
- public string Area { get; set; }
- public string inca_proportion { get; set; }
- public string inca_FieldRatio { get; set; }
- }
- }
|