EChart_ParticlesComposition.cs 61 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408
  1. using CefSharp;
  2. using CefSharp.WinForms;
  3. using Newtonsoft.Json;
  4. using OTSIncAReportApp.DataOperation.DataAccess;
  5. using OTSCommon.Model;
  6. using OTSIncAReportApp.OTSDataMgrFunction;
  7. using OTSIncAReportApp.OTSSampleReportInfo;
  8. using OTSIncAReportApp.OTSTemplateDesigner;
  9. using OTSIncAReportApp.SysMgrTools;
  10. using OTSIncAReportGrids;
  11. using System;
  12. using System.Collections;
  13. using System.Collections.Generic;
  14. using System.Data;
  15. using System.IO;
  16. using System.Linq;
  17. using System.Windows.Forms;
  18. namespace OTSIncAReportApp.Control_ECharts
  19. {
  20. /// <summary>
  21. /// 各图char相关模块
  22. /// </summary>
  23. public partial class EChart_ParticlesComposition : UserControl
  24. {
  25. Hashtable table;
  26. #region 图表相关变量
  27. //y轴名称
  28. public string m_str_AxisY { get; set; }
  29. //定义图片
  30. //JsEvent js;
  31. //定义图片base64
  32. public string pic { get; set; }
  33. //定义图形类型
  34. public string type { get; set; }
  35. //图形数据
  36. public string data { get; set; }
  37. string url = "Resources/HTML/charts.html";
  38. //数据图类型:常用夹杂物分类CommonlyUsedClassify ,颗粒成分PComponent,元素成分EComponent,颗粒尺寸分布PSize
  39. string ComSel { get; set; }
  40. public bool Report { get; set; }
  41. /// <summary>
  42. /// 选择颗粒范围(true为全部颗粒false为选择颗粒)
  43. /// </summary>
  44. public bool ParticleRange { set; get; }
  45. frmReportApp m_ReportApp;
  46. List<int> FLID = new List<int>() { 0, 1, 2, 4, 6, 7, 8, 9 };
  47. List<string> NameList = new List<string>() { "过小颗粒", "过大颗粒", "亮度不在分析范围内的颗粒", "低计数率颗粒", "不含分析元素的颗粒", "非夹杂物颗粒SiC", "非夹杂物颗粒FeO", "未识别颗粒" };
  48. private frmReportConditionChoose m_conditionChoose;
  49. private ResultDataMgr m_DataMgr;
  50. Export_ReportTemplate m_export_reporttemplate;
  51. #endregion
  52. #region 窗体加载及构造函数
  53. public EChart_ParticlesComposition(frmReportApp ReportApp, string comsel)
  54. {
  55. ComSel = comsel;
  56. m_ReportApp = ReportApp;
  57. m_conditionChoose = ReportApp.m_conditionChoose;
  58. m_DataMgr = ReportApp.m_rstDataMgr;
  59. InitializeComponent();
  60. //国际化
  61. Language lan = new Language();
  62. table = lan.GetNameTable("CompositionDistributionGrid");
  63. m_export_reporttemplate = new Export_ReportTemplate();
  64. }
  65. private void EChart_ParticlesComposition_Load(object sender, EventArgs e)
  66. {
  67. string sou = "";
  68. int sel = 0;//选择颗粒范围(0为全部颗粒1为选择颗粒)
  69. NameList = new List<string>() { table["partcletype0"].ToString(), table["partcletype1"].ToString(), table["partcletype2"].ToString(), table["partcletype4"].ToString(), table["partcletype6"].ToString(), table["partcletype7"].ToString(), table["partcletype8"].ToString(), table["partcletype9"].ToString() };
  70. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
  71. //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
  72. if (Report)
  73. {
  74. sou = m_DataMgr.ResultFilesList[m_DataMgr.getSelectedIndex()].FileName.ToString();
  75. if(ParticleRange)
  76. {
  77. sel = 0;
  78. }else
  79. {
  80. sel = 1;
  81. }
  82. }
  83. else
  84. {
  85. sou = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  86. sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  87. }
  88. Report = false;
  89. if (sou.Contains("+"))
  90. {
  91. if (m_ReportApp.more)
  92. {
  93. m_ReportApp.trans = false;
  94. }
  95. else
  96. {
  97. m_ReportApp.trans = true;
  98. }
  99. m_ReportApp.more = true;
  100. //获取到List,json的字符串
  101. ChartdateMore list_json_str = GetListJsonStr();
  102. url = "Resources/HTML/chartsMore.html";
  103. m_ReportApp.data = JsonConvert.SerializeObject(list_json_str);
  104. }
  105. else
  106. {
  107. if (!m_ReportApp.more)
  108. {
  109. m_ReportApp.trans = false;
  110. }
  111. else
  112. {
  113. m_ReportApp.trans = true;
  114. }
  115. m_ReportApp.more = false;
  116. //获取到List,json的字符串
  117. for (int i=0;i< m_conditionChoose.m_SourceGridData.ConditionItemList.Count;i++)
  118. {
  119. if (m_conditionChoose.m_SourceGridData.ConditionItemList[i].itemDisplayVal.ToString()== sou)
  120. {
  121. m_DataMgr.SetWorkingResult((int)m_conditionChoose.m_SourceGridData.ConditionItemList[i].itemVal);
  122. }
  123. }
  124. List<Chartdate> list_json_str = GetListJsonStrByChartStruct(sel);
  125. url = "Resources/HTML/charts.html";
  126. m_ReportApp.data = JsonConvert.SerializeObject(list_json_str[0]);
  127. }
  128. InitBrowser();
  129. }
  130. #endregion
  131. #region 获取单数据源
  132. private Chartdate GetCommonlyUsedClassifyData(string path)
  133. {
  134. string spinel = table["str20"].ToString();
  135. string oxide = table["str21"].ToString();
  136. string SulfurOxide = table["str22"].ToString();
  137. string nitrides = table["str23"].ToString();
  138. string sulfide = table["str24"].ToString();
  139. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  140. //创建新的图形数据源
  141. Chartdate chart = new Chartdate();
  142. chart.Title = m_ReportApp.m_reportname;
  143. chart.YName = m_str_AxisY;
  144. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  145. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  146. //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  147. int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  148. DataTable dt = new DataTable();
  149. if (sel == 1)
  150. {
  151. List<Particle> particles = m_ReportApp.GetSelectedParticles();
  152. int SPINEL = 0;
  153. int OXIDE = 0;
  154. int SULFIDE_OXIDE = 0;
  155. int NITRIDE = 0;
  156. int SULFIDE = 0;
  157. for (int i = 0; i < m_ReportApp.GetSelectedParticles().Count; i++)
  158. {
  159. //SPINEL
  160. if ((particles[i].TypeId >= 10100 || particles[i].TypeId <= 10199) || (particles[i].TypeId >= 12200 || particles[i].TypeId <= 12299) || (particles[i].TypeId >= 11300 || particles[i].TypeId <= 11299))
  161. {
  162. SPINEL = SPINEL + 1;
  163. }
  164. //OXIDE
  165. if (particles[i].TypeId >= 10000 || particles[i].TypeId <= 10999)
  166. {
  167. OXIDE = OXIDE + 1;
  168. }
  169. //SULFIDE_OXIDE
  170. if ((particles[i].TypeId >= 11200 || particles[i].TypeId <= 11299) || (particles[i].TypeId >= 11400 || particles[i].TypeId <= 11499) || (particles[i].TypeId >= 11200 || particles[i].TypeId <= 11599))
  171. {
  172. SULFIDE_OXIDE = SULFIDE_OXIDE + 1;
  173. }
  174. //NITRIDE
  175. if (particles[i].TypeId >= 12000 || particles[i].TypeId <= 12999)
  176. {
  177. NITRIDE = NITRIDE + 1;
  178. }
  179. //SULFIDE
  180. if (particles[i].TypeId >= 11000 || particles[i].TypeId <= 11999)
  181. {
  182. SULFIDE = SULFIDE + 1;
  183. }
  184. }
  185. DataTable dataTable = new DataTable();
  186. dataTable.Columns.Add("SPINEL", typeof(String));
  187. dataTable.Columns.Add("OXIDE", typeof(String));
  188. dataTable.Columns.Add("SULFIDE_OXIDE", typeof(String));
  189. dataTable.Columns.Add("NITRIDE", typeof(String));
  190. dataTable.Columns.Add("SULFIDE", typeof(String));
  191. dataTable.Rows.Add();
  192. dataTable.Rows[0]["SPINEL"] = SPINEL.ToString();
  193. dataTable.Rows[0]["OXIDE"] = OXIDE.ToString();
  194. dataTable.Rows[0]["SULFIDE_OXIDE"] = SULFIDE_OXIDE.ToString();
  195. dataTable.Rows[0]["NITRIDE"] = NITRIDE.ToString();
  196. dataTable.Rows[0]["SULFIDE"] = SULFIDE.ToString();
  197. dt = dataTable;
  198. }
  199. else
  200. {
  201. dt = particledata.GetCommonlyUsedClassifyData();
  202. }
  203. //DataTable dt = dataTable;
  204. //设置标签名称
  205. List<string> listName = new List<string>();
  206. listName.Add(spinel);
  207. listName.Add(oxide);
  208. listName.Add(SulfurOxide);
  209. listName.Add(nitrides);
  210. listName.Add(sulfide);
  211. chart.ListName = listName;
  212. //设置数据
  213. List<Item> listData = new List<Item>();
  214. //ListData
  215. for (int k = 0; k < dt.Rows.Count; k++)
  216. {
  217. try
  218. {
  219. Item item_SPINEL = new Item()
  220. {
  221. value = decimal.Round(decimal.Parse(dt.Rows[k]["SPINEL"].ToString()), 2).ToString(),
  222. name = spinel
  223. };
  224. listData.Add(item_SPINEL);
  225. Item item_OXIDE = new Item()
  226. {
  227. value = decimal.Round(decimal.Parse(dt.Rows[k]["OXIDE"].ToString()), 2).ToString(),
  228. name = oxide
  229. };
  230. listData.Add(item_OXIDE);
  231. Item item_SULFIDE_OXIDE = new Item()
  232. {
  233. value = decimal.Round(decimal.Parse(dt.Rows[k]["SULFIDE_OXIDE"].ToString()), 2).ToString(),
  234. name = SulfurOxide
  235. };
  236. listData.Add(item_SULFIDE_OXIDE);
  237. Item item_NITRIDE = new Item()
  238. {
  239. value = decimal.Round(decimal.Parse(dt.Rows[k]["NITRIDE"].ToString()), 2).ToString(),
  240. name = nitrides
  241. };
  242. listData.Add(item_NITRIDE);
  243. Item item_SULFIDE = new Item()
  244. {
  245. value = decimal.Round(decimal.Parse(dt.Rows[k]["SULFIDE"].ToString()), 2).ToString(),
  246. name = sulfide
  247. };
  248. listData.Add(item_SULFIDE);
  249. }
  250. catch
  251. {
  252. Item item = new Item()
  253. {
  254. value = "",
  255. name = ""
  256. };
  257. listData.Add(item);
  258. }
  259. }
  260. chart.ListData = listData;
  261. return chart;
  262. }
  263. private Chartdate GetInclusionAreaRatioData(string path,int sel)
  264. {
  265. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  266. //创建新的图形数据源
  267. Chartdate chart = new Chartdate();
  268. chart.Title = m_ReportApp.m_reportname;
  269. chart.YName = m_str_AxisY;
  270. //int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  271. DataTable data = new DataTable();
  272. if (sel == 0)
  273. {
  274. data = particledata.GetAreaByAllIncA("");//获取所有分类面积和数量信息
  275. }
  276. else
  277. {
  278. DataTable AllInca = particledata.GetAreaByAllIncA("");
  279. DataTable SelectParticl = SelectParticleData();
  280. data = GetParticleListForParticlSize(SelectParticl, AllInca);
  281. }
  282. //DataTable data = particledata.GetAreaByAllIncA("");
  283. DataTable dt = ConSolidateInvalid(data);
  284. //设置标签名称
  285. List<string> listName = new List<string>();
  286. //ListName
  287. for (int i = 0; i < dt.Rows.Count; i++)
  288. {
  289. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
  290. {
  291. continue;
  292. }
  293. listName.Add(dt.Rows[i]["TypeName"].ToString());
  294. }
  295. chart.ListName = listName;
  296. //设置数据
  297. List<Item> listData = new List<Item>();
  298. //ListData
  299. for (int k = 0; k < dt.Rows.Count; k++)
  300. {
  301. string str = dt.Rows[k]["ar"].ToString();
  302. string name = dt.Rows[k]["TypeName"].ToString();
  303. if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
  304. {
  305. continue;
  306. }
  307. Item item = new Item()
  308. {
  309. value = decimal.Round(decimal.Parse(dt.Rows[k]["ar"].ToString()), 2).ToString(),
  310. name = name
  311. };
  312. listData.Add(item);
  313. }
  314. chart.ListData = listData;
  315. return chart;
  316. }
  317. private Chartdate GetInclusionAreaRatioClassData(string path,int sel)
  318. {
  319. //创建新的图形数据源
  320. Chartdate chart = new Chartdate();
  321. chart.Title = m_ReportApp.m_reportname;
  322. chart.YName = m_str_AxisY;
  323. //计算分类整个表的数据
  324. DataTable dt= ClassificationIntegration(path,sel);
  325. List<string> listName = new List<string>();
  326. //ListName
  327. for (int i = 0; i < dt.Rows.Count; i++)
  328. {
  329. listName.Add(dt.Rows[i]["e1"].ToString());
  330. }
  331. chart.ListName = listName;
  332. //DataTable dt
  333. //设置数据
  334. List<Item> listData = new List<Item>();
  335. //ListData
  336. for (int k = 0; k < dt.Rows.Count; k++)
  337. {
  338. string str = dt.Rows[k]["Cunt"].ToString();
  339. string name = dt.Rows[k]["e1"].ToString();
  340. Item item = new Item()
  341. {
  342. value = decimal.Round(decimal.Parse(dt.Rows[k]["Cunt"].ToString()), 2).ToString(),
  343. name = name
  344. };
  345. listData.Add(item);
  346. }
  347. chart.ListData = listData;
  348. return chart;
  349. }
  350. private DataTable ClassificationIntegration(string path ,int sel)
  351. {
  352. //------------------加载模块,获取数据-------------------------------------------------
  353. ResultGrid ls_resultgrid = new ResultGrid(m_ReportApp);
  354. Dictionary<string, string> keyValues_ResultGrid = ls_resultgrid.GetData_ResultGrid_Report();
  355. //------------------加载模块,获取数据结束----------------------------------------------
  356. Dictionary<string, string>.Enumerator en = keyValues_ResultGrid.GetEnumerator();
  357. string str_SCZS = "";
  358. keyValues_ResultGrid.TryGetValue(ls_resultgrid.table["col5"].ToString(), out str_SCZS);//视场总数
  359. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  360. DataTable data = new DataTable();
  361. if (sel==0)
  362. {
  363. data = particledata.GetAreaByAllIncA("");//获取所有分类面积和数量信息
  364. }
  365. else
  366. {
  367. DataTable AllInca = particledata.GetAreaByAllIncA("");
  368. DataTable SelectParticl = SelectParticleData();
  369. data = GetParticleListForParticlSize(SelectParticl, AllInca);
  370. }
  371. DataTable AreaInformationOfAllElements = ConSolidateInvalid(data);
  372. DataTable AllAnalysisDetails = new DataTable();
  373. AllAnalysisDetails.Columns.Add("Name");
  374. AllAnalysisDetails.Columns.Add("TypeId");
  375. AllAnalysisDetails.Columns.Add("Area", typeof(double));
  376. AllAnalysisDetails.Columns.Add("Class");
  377. AllAnalysisDetails.Columns.Add("Cunt", typeof(double));
  378. for (int i = 0; i < AreaInformationOfAllElements.Rows.Count; i++)
  379. {
  380. DataRow dr2 = AllAnalysisDetails.NewRow();
  381. dr2["Name"] = AreaInformationOfAllElements.Rows[i]["TypeName"].ToString();
  382. dr2["Area"] = Convert.ToDouble(AreaInformationOfAllElements.Rows[i]["ar"]);
  383. dr2["TypeId"] = AreaInformationOfAllElements.Rows[i]["TypeId"].ToString();
  384. dr2["Cunt"] = Convert.ToDouble(AreaInformationOfAllElements.Rows[i]["con"]);
  385. dr2["Class"] = AreaInformationOfAllElements.Rows[i]["GroupName"].ToString();
  386. AllAnalysisDetails.Rows.Add(dr2);
  387. }
  388. //按照list列表进行物质类排序,物质类中的元素分类按照面积的大小进行排序
  389. List<string> ClassName = new List<string>();
  390. DataTable getClass_dt = particledata.GetAllClass();
  391. for (int i = 0; i < getClass_dt.Rows.Count; i++)
  392. {
  393. ClassName.Add(getClass_dt.Rows[i]["GroupName"].ToString());
  394. }
  395. DataTable AreaRatio = new DataTable();
  396. AreaRatio.TableName = "InclusionAreaRatio";
  397. AreaRatio.Columns.Add("e1");
  398. AreaRatio.Columns.Add("e2");
  399. AreaRatio.Columns.Add("e3", typeof(double));
  400. AreaRatio.Columns.Add("e4");
  401. AreaRatio.Columns.Add("e5");
  402. AreaRatio.Columns.Add("Cunt", typeof(int));
  403. //获取夹杂物的总面积用于计算夹杂物类别的占比(gridview最后一个固定是未识别颗粒,要排除未识别颗粒所以for循环至grid view长度减一)
  404. double totalInclusionArea = 0;
  405. totalInclusionArea = Convert.ToDouble(decimal.Parse(AllAnalysisDetails.Compute("sum(Area)", "").ToString()));
  406. for (int i = 0; i < AllAnalysisDetails.Rows.Count; i++)
  407. {
  408. DataRow dr2 = AreaRatio.NewRow();
  409. dr2["e1"] = AllAnalysisDetails.Rows[i]["Class"].ToString();
  410. dr2["e2"] = AllAnalysisDetails.Rows[i]["Name"].ToString();
  411. dr2["e3"] = Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]);
  412. dr2["e4"] = Math.Round((Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]) / totalInclusionArea) * 100, 2);
  413. dr2["e5"] = Math.Round((Convert.ToDouble(AllAnalysisDetails.Rows[i]["Area"]) / Convert.ToDouble(str_SCZS)) * 100, 4);
  414. dr2["Cunt"]= AllAnalysisDetails.Rows[i]["Cunt"].ToString();
  415. AreaRatio.Rows.Add(dr2);
  416. }
  417. DataTable AreaRatio_dt = AreaRatio.Copy();
  418. AreaRatio_dt.Clear();
  419. for (int i = 0; i < ClassName.Count(); i++)
  420. {
  421. DataTable dt = AreaRatio.Copy();
  422. dt.Clear();
  423. for (int a = 0; a < AreaRatio.Rows.Count; a++)
  424. {
  425. if (AreaRatio.Rows[a]["e1"].ToString() == ClassName[i].ToString())
  426. {
  427. dt.Rows.Add(AreaRatio.Rows[a].ItemArray);
  428. }
  429. }
  430. DataView dv = dt.DefaultView;
  431. dv.Sort = "e3 DESC";
  432. DataTable dt_Element = dv.ToTable();
  433. for (int a = 0; a < dt_Element.Rows.Count; a++)
  434. {
  435. AreaRatio_dt.Rows.Add(dt_Element.Rows[a].ItemArray);
  436. }
  437. }
  438. DataTable AllAnalysisDetails1 = AreaRatio_dt.Copy();
  439. AllAnalysisDetails1.Clear();
  440. for (int i = 0; i < ClassName.Count; i++)
  441. {
  442. DataTable dt = AreaRatio_dt.Copy();
  443. dt.Clear();
  444. for (int a = 0; a < AreaRatio_dt.Rows.Count; a++)
  445. {
  446. if (AreaRatio_dt.Rows[a]["e1"].ToString() == ClassName[i].ToString())
  447. {
  448. dt.Rows.Add(AreaRatio_dt.Rows[a].ItemArray);
  449. }
  450. }
  451. if (dt.Rows.Count > 0)
  452. {
  453. double totalInclusionArea2 = Convert.ToDouble(decimal.Parse(AreaRatio_dt.Compute("sum(e3)", "").ToString()));
  454. double Area = Convert.ToDouble(decimal.Parse(dt.Compute("sum(e3)", "").ToString()));
  455. int cunt= Convert.ToInt32(decimal.Parse(dt.Compute("sum(Cunt)", "").ToString()));
  456. DataRow dr3 = AllAnalysisDetails1.NewRow();
  457. dr3["e1"] = ClassName[i].ToString();
  458. dr3["e3"] = Math.Round(Area, 2);
  459. //Convert.ToDouble(decimal.Parse(dt.Compute("sum(e3)", "").ToString()));
  460. dr3["e4"] = Math.Round((Convert.ToDouble(dt.Rows[0]["e3"]) / totalInclusionArea2) * 100, 2);
  461. dr3["e5"] = Math.Round((Convert.ToDouble(dt.Rows[0]["e3"]) / Convert.ToDouble(str_SCZS)) * 100, 4);
  462. dr3["Cunt"] = cunt;
  463. AllAnalysisDetails1.Rows.Add(dr3);
  464. }
  465. }
  466. return AllAnalysisDetails1;
  467. }
  468. private DataTable GetParticleListForParticlSize(DataTable data, DataTable table)
  469. {
  470. DataTable dt_Partick = new DataTable();
  471. dt_Partick.Columns.Add("TypeId");
  472. dt_Partick.Columns.Add("TypeName");
  473. dt_Partick.Columns.Add("TypeColor");
  474. dt_Partick.Columns.Add("con");
  475. dt_Partick.Columns.Add("av");
  476. dt_Partick.Columns.Add("max");
  477. dt_Partick.Columns.Add("ar", typeof(double));
  478. dt_Partick.Columns.Add("GroupName");
  479. List<string> typeName = new List<string>();
  480. for (int i = 0; i < data.Rows.Count; i++)
  481. {
  482. typeName.Add(data.Rows[i]["TypeId"].ToString());
  483. }
  484. typeName = typeName.Distinct().ToList();
  485. for (int i = 0; i < typeName.Count; i++)
  486. {
  487. DataTable dt = dt_Partick.Clone();
  488. for (int j = 0; j < data.Rows.Count; j++)
  489. {
  490. if (typeName[i].ToString() == data.Rows[j]["TypeId"].ToString())
  491. {
  492. DataRow row = dt.NewRow();
  493. row["TypeId"] = data.Rows[j]["TypeId"];
  494. row["TypeName"] = data.Rows[j]["TypeName"];
  495. row["TypeColor"] = data.Rows[j]["TypeColor"];
  496. row["ar"] = data.Rows[j]["Area"];
  497. dt.Rows.Add(row);
  498. }
  499. }
  500. DataRow dr = dt_Partick.NewRow();
  501. dr["TypeId"] = dt.Rows[0]["TypeId"].ToString();
  502. dr["TypeName"] = dt.Rows[0]["TypeName"].ToString();
  503. dr["TypeColor"] = dt.Rows[0]["TypeColor"].ToString();
  504. dr["con"] = dt.Rows.Count;
  505. dr["av"] = dt.Compute("min(ar)", "");
  506. dr["max"] = dt.Compute("Max(ar)", "");
  507. dr["ar"] = dt.Compute("SUM(ar)", "");
  508. dt_Partick.Rows.Add(dr);
  509. }
  510. for (int i = 0; i < dt_Partick.Rows.Count; i++)
  511. {
  512. for (int j = 0; j < table.Rows.Count; j++)
  513. {
  514. if (dt_Partick.Rows[i]["TypeId"].ToString() == table.Rows[j]["TypeId"].ToString())
  515. {
  516. dt_Partick.Rows[i]["GroupName"] = table.Rows[j]["GroupName"];
  517. break;
  518. }
  519. }
  520. }
  521. return dt_Partick;
  522. }
  523. #region 读取选择颗粒数据
  524. private DataTable SelectParticleData()
  525. {
  526. List<Particle> selectParticles = m_ReportApp.GetSelectedParticles();
  527. #region Datatable数据表格式
  528. DataTable dtUelect = new DataTable();
  529. dtUelect.Columns.Add("fieldid");
  530. dtUelect.Columns.Add("particleid");
  531. dtUelect.Columns.Add("AveGray");
  532. dtUelect.Columns.Add("RectLeft");
  533. dtUelect.Columns.Add("RectTop");
  534. dtUelect.Columns.Add("RectWidth");
  535. dtUelect.Columns.Add("RectHeight");
  536. dtUelect.Columns.Add("Area");
  537. dtUelect.Columns.Add("PosX");
  538. dtUelect.Columns.Add("PosY");
  539. dtUelect.Columns.Add("TypeId");
  540. dtUelect.Columns.Add("SegmentNum");
  541. dtUelect.Columns.Add("SEMPosX");
  542. dtUelect.Columns.Add("SEMPosY");
  543. dtUelect.Columns.Add("XrayId");
  544. dtUelect.Columns.Add("DMAX");
  545. dtUelect.Columns.Add("DMIN");
  546. dtUelect.Columns.Add("DPERP");
  547. dtUelect.Columns.Add("PERIMETER");
  548. dtUelect.Columns.Add("ORIENTATION");
  549. dtUelect.Columns.Add("DINSCR");
  550. dtUelect.Columns.Add("DMEAN");
  551. dtUelect.Columns.Add("DELONG");
  552. dtUelect.Columns.Add("DFERET");
  553. dtUelect.Columns.Add("TypeName");
  554. dtUelect.Columns.Add("TypeColor");
  555. #endregion
  556. for (int i = 0; i < selectParticles.Count; i++)
  557. {
  558. dtUelect.Rows.Add(selectParticles[i].FieldId, selectParticles[i].ParticleId, selectParticles[i].AveGray, selectParticles[i].RectLeft, selectParticles[i].RectTop, selectParticles[i].RectWidth, selectParticles[i].RectHeight, selectParticles[i].Area, selectParticles[i].PosX, selectParticles[i].PosX, selectParticles[i].TypeId, /*selectParticles[i].ElementNum,*/ selectParticles[i].SegmentNum, selectParticles[i].SEMPosX, selectParticles[i].SEMPosY, selectParticles[i].ParticleId, selectParticles[i].DMAX, selectParticles[i].DMIN, selectParticles[i].DPERP, selectParticles[i].PERIMETER, selectParticles[i].ORIENTATION, selectParticles[i].DINSCR, selectParticles[i].DMEAN, selectParticles[i].DELONG, selectParticles[i].DFERET, selectParticles[i].TypeName, selectParticles[i].TypeColor);
  559. }
  560. return dtUelect;
  561. }
  562. #endregion
  563. private DataTable ConSolidateInvalid(DataTable dt)
  564. {
  565. DataTable dt_invalid = dt.Clone();
  566. DataTable dt_no_invalid = dt.Clone();
  567. for (int i = 0; i < dt.Rows.Count; i++)
  568. {
  569. if (dt.Rows[i]["TypeName"].ToString()=="Invalid")
  570. {
  571. dt_invalid.Rows.Add(dt.Rows[i].ItemArray);
  572. }
  573. else
  574. {
  575. dt_no_invalid.Rows.Add(dt.Rows[i].ItemArray);
  576. }
  577. }
  578. return dt_no_invalid;
  579. }
  580. /// <summary>
  581. /// 获取颗粒成分数据
  582. /// </summary>
  583. private Chartdate GetPComponentData(string path)
  584. {
  585. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  586. //创建新的图形数据源
  587. Chartdate chart = new Chartdate();
  588. chart.Title = m_ReportApp.m_reportname;
  589. chart.YName = m_str_AxisY;
  590. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  591. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  592. //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  593. int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  594. string filedAndParticl = "";
  595. if (sel == 1)
  596. {
  597. List<Particle> selectParticles = m_ReportApp.GetSelectedParticles();
  598. foreach (var item in selectParticles)
  599. {
  600. filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
  601. }
  602. if (filedAndParticl != "")
  603. {
  604. filedAndParticl = filedAndParticl + ",";
  605. }
  606. }
  607. DataTable dt = particledata.GetParticleListForParticlSize("area", filedAndParticl);
  608. //设置标签名称
  609. List<string> listName = new List<string>();
  610. //ListName
  611. for (int i = 0; i < dt.Rows.Count; i++)
  612. {
  613. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
  614. {
  615. continue;
  616. }
  617. listName.Add(dt.Rows[i]["TypeName"].ToString());
  618. }
  619. for (int i = 0; i < dt.Rows.Count; i++)
  620. {
  621. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100)
  622. {
  623. continue;
  624. }
  625. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
  626. if (index == -1)
  627. {
  628. index = 7;
  629. }
  630. string name = NameList[index];
  631. if (listName.IndexOf(name) == -1)
  632. {
  633. listName.Add(name);
  634. }
  635. }
  636. chart.ListName = listName;
  637. //设置数据
  638. List<Item> listData = new List<Item>();
  639. //ListData
  640. for (int k = 0; k < dt.Rows.Count; k++)
  641. {
  642. string str = dt.Rows[k]["con"].ToString();
  643. string name = dt.Rows[k]["TypeName"].ToString();
  644. if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
  645. {
  646. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[k]["TypeId"]));
  647. if (index == -1)
  648. {
  649. index = 7;
  650. }
  651. name = NameList[index];
  652. }
  653. Item item = new Item()
  654. {
  655. value = decimal.Round(decimal.Parse(str), 2).ToString(),
  656. name = name
  657. };
  658. listData.Add(item);
  659. }
  660. chart.ListData = listData;
  661. return chart;
  662. }
  663. /// <summary>
  664. /// 获取元素成分数据
  665. /// </summary>
  666. private Chartdate GetEComponentData(string path)
  667. {
  668. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  669. //创建新的图形数据源
  670. Chartdate chart = new Chartdate();
  671. chart.Title = m_ReportApp.m_reportname;
  672. chart.YName = m_str_AxisY;
  673. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  674. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  675. //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  676. int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  677. string filedAndParticl = "";
  678. if (sel == 1)
  679. {
  680. List<Particle> selectParticles = m_ReportApp.GetSelectedParticles();
  681. foreach (var item in selectParticles)
  682. {
  683. filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
  684. }
  685. if (filedAndParticl != "")
  686. {
  687. filedAndParticl = filedAndParticl + ",";
  688. }
  689. }
  690. DataTable dt = particledata.GetElementForArea(filedAndParticl);
  691. //设置标签名称
  692. List<string> listName = new List<string>();
  693. //ListName
  694. for (int i = 0; i < dt.Rows.Count; i++)
  695. {
  696. listName.Add(dt.Rows[i]["name"].ToString());
  697. }
  698. chart.ListName = listName;
  699. //设置数据
  700. List<Item> listData = new List<Item>();
  701. //ListData
  702. for (int k = 0; k < dt.Rows.Count; k++)
  703. {
  704. string str = dt.Rows[k]["earea"].ToString();
  705. try
  706. {
  707. Item item = new Item()
  708. {
  709. value = decimal.Round(decimal.Parse(str), 2).ToString(),
  710. name = dt.Rows[k]["name"].ToString()
  711. };
  712. listData.Add(item);
  713. }
  714. catch
  715. {
  716. Item item = new Item()
  717. {
  718. value = str,
  719. name = dt.Rows[k]["name"].ToString()
  720. };
  721. listData.Add(item);
  722. }
  723. }
  724. chart.ListData = listData;
  725. return chart;
  726. }
  727. /// <summary>
  728. /// 获取此尺寸分布图数据
  729. /// </summary>
  730. private Chartdate GetPSizeData(string path)
  731. {
  732. DataOperation.DataAccess.ParticleData particledata = new DataOperation.DataAccess.ParticleData(path);
  733. //创建新的图形数据源
  734. Chartdate chart = new Chartdate();
  735. chart.Title = m_ReportApp.m_reportname;
  736. chart.YName = m_str_AxisY;
  737. //设置标签名称
  738. List<string> listName = new List<string>();
  739. //获取粒级表
  740. string pathe = m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder + m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
  741. DataSet ds = DataOperation.DataAccess.XMLoperate.GetXml(pathe);
  742. string sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();
  743. for (int i = 0; i < sizestr.Split(',').Length - 1; i++)
  744. {
  745. if (sizestr.Split(',')[i].Length > 0)
  746. {
  747. double d1 = Convert.ToDouble(sizestr.Split(',')[i]);
  748. double d2 = Convert.ToDouble(sizestr.Split(',')[i + 1]);
  749. listName.Add(d1.ToString() + "~" + d2.ToString());
  750. }
  751. }
  752. double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
  753. listName.Add(d.ToString() + "~MAX");
  754. chart.ListName = listName;
  755. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  756. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  757. //int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  758. int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  759. string filedAndParticl = "";
  760. if (sel == 1)
  761. {
  762. List<Particle> selectParticles = m_ReportApp.GetSelectedParticles();
  763. foreach (var item in selectParticles)
  764. {
  765. filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
  766. }
  767. if (filedAndParticl != "")
  768. {
  769. filedAndParticl = filedAndParticl + ",";
  770. }
  771. }
  772. //idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE);
  773. //string con = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
  774. string con = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
  775. string po = "";
  776. switch (con)
  777. {
  778. case "DMAX":
  779. po = "DMAX";
  780. break;
  781. case "DMIN":
  782. po = "DMIN";
  783. break;
  784. case "CIRCLE":
  785. po = "Area";
  786. break;
  787. case "FERET":
  788. po = "DFERET";
  789. break;
  790. }
  791. DataTable dtp = particledata.GetParticleAll(filedAndParticl);
  792. //设置数据
  793. List<Item> listData = new List<Item>();
  794. //ListData
  795. for (int k = 0; k < listName.Count; k++)
  796. {
  797. string str = listName[k];
  798. string d1 = str.Split('~')[0];
  799. string d2 = str.Split('~')[1];
  800. if (d2 == "MAX")
  801. {
  802. d2 = "999";
  803. }
  804. DataRow[] datas = dtp.Select(getWhere(d2, d1, po));
  805. Item item = new Item()
  806. {
  807. value = datas.Count().ToString(),
  808. name = str
  809. };
  810. listData.Add(item);
  811. }
  812. chart.ListData = listData;
  813. return chart;
  814. }
  815. private string getWhere(string max, string min, string col)
  816. {
  817. return col + ">=" + min + " and " + col + "<=" + max;
  818. }
  819. #endregion
  820. #region echarts
  821. /// <summary>
  822. /// 通过m_list_chartstruct,组合json数据格式
  823. /// </summary>
  824. /// <returns></returns>
  825. private List<Chartdate> GetListJsonStrByChartStruct(int sel)
  826. {
  827. List<Chartdate> list = new List<Chartdate>();
  828. Chartdate chartdate = new Chartdate();
  829. switch (ComSel)
  830. {
  831. case "CommonlyUsedClassify":
  832. //chartdate = GetCommonlyUsedClassifyData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
  833. chartdate = GetInclusionAreaRatioClassData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath, sel);
  834. break;
  835. case "PComponent":
  836. chartdate = GetPComponentData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
  837. break;
  838. case "EComponent":
  839. chartdate = GetEComponentData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
  840. break;
  841. case "PSize":
  842. chartdate = GetPSizeData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath);
  843. break;
  844. case "InclusionareaRatio":
  845. chartdate = GetInclusionAreaRatioData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath, sel);
  846. break;
  847. case "InclusionareaClassRatio":
  848. chartdate=GetInclusionAreaRatioClassData(m_DataMgr.ResultFilesList[m_DataMgr.GetWorkingResult()].FilePath, sel);
  849. break;
  850. }
  851. list.Add(chartdate);
  852. return list;
  853. }
  854. /// <summary>
  855. /// 通过m_list_chartstruct,组合json数据格式
  856. /// </summary>
  857. /// <returns></returns>
  858. private ChartdateMore GetListJsonStr()
  859. {
  860. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  861. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  862. int sel = m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  863. string filedAndParticl = "";
  864. if (sel == 1)
  865. {
  866. List<Particle> selectParticles = m_ReportApp.GetSelectedParticles();
  867. foreach (var item in selectParticles)
  868. {
  869. filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString());
  870. }
  871. if (filedAndParticl != "")
  872. {
  873. filedAndParticl = filedAndParticl + ",";
  874. }
  875. }
  876. DataOperation.DataAccess.ParticleData particledata = null;
  877. DataTable dt = new DataTable();
  878. ChartdateMore chart = new ChartdateMore();
  879. chart.Title = m_ReportApp.m_reportname;
  880. chart.YName = m_str_AxisY;
  881. List<string> listName = new List<string>();
  882. List<string> soursName = new List<string>();
  883. List<List<Item>> listDataMore = new List<List<Item>>();
  884. //idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
  885. //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
  886. string sou = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  887. if (sou.Contains("+"))
  888. {
  889. for (int i = 0; i < sou.Split('+').Length; i++)
  890. {
  891. ResultFile resultFile = m_DataMgr.ResultFilesList.Find(s => s.FileName == sou.Split('+')[i]);
  892. if (resultFile == null)
  893. {
  894. continue;
  895. }
  896. soursName.Add(resultFile.FileName);
  897. particledata = new DataOperation.DataAccess.ParticleData(resultFile.FilePath);
  898. switch (ComSel)
  899. {
  900. case "InclusionareaRatio":
  901. dt = particledata.GetAreaByAllIncA("");
  902. //设置标签名称
  903. for (int a = 0; a < dt.Rows.Count; a++)
  904. {
  905. if (Convert.ToInt32(dt.Rows[a]["TypeId"]) < 100)
  906. {
  907. continue;
  908. }
  909. listName.Add(dt.Rows[a]["TypeName"].ToString());
  910. }
  911. //设置数据
  912. List<Item> listData3 = new List<Item>();
  913. for (int k = 0; k < dt.Rows.Count; k++)
  914. {
  915. string str = dt.Rows[k]["ar"].ToString();
  916. string name = dt.Rows[k]["TypeName"].ToString();
  917. if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
  918. {
  919. continue;
  920. }
  921. Item item = new Item()
  922. {
  923. value = decimal.Round(decimal.Parse(dt.Rows[k]["ar"].ToString()), 2).ToString(),
  924. name = name
  925. };
  926. listData3.Add(item);
  927. }
  928. listDataMore.Add(listData3);
  929. break;
  930. case "CommonlyUsedClassify":
  931. //计算分类整个表的数据
  932. dt = ClassificationIntegration(resultFile.FilePath,sel);
  933. ////List<string> listName = new List<string>();
  934. ////ListName
  935. for (int a = 0; a < dt.Rows.Count; a++)
  936. {
  937. listName.Add(dt.Rows[a]["e1"].ToString());
  938. }
  939. //chart.ListName = listName;
  940. ////DataTable dt
  941. //设置数据
  942. List<Item> listData2 = new List<Item>();
  943. ////ListData
  944. for (int k = 0; k < dt.Rows.Count; k++)
  945. {
  946. string str = dt.Rows[k]["Cunt"].ToString();
  947. string name = dt.Rows[k]["e1"].ToString();
  948. Item item = new Item()
  949. {
  950. value = decimal.Round(decimal.Parse(str), 2).ToString(),
  951. name = name
  952. };
  953. listData2.Add(item);
  954. //listData2.Add(item);
  955. }
  956. listDataMore.Add(listData2);
  957. break;
  958. case "PComponent":
  959. //创建新的图形数据源
  960. dt = particledata.GetParticleListByIncA("area");
  961. //设置标签名称
  962. for (int j = 0; j < dt.Rows.Count; j++)
  963. {
  964. if (Convert.ToInt32(dt.Rows[j]["TypeId"]) < 100)
  965. {
  966. continue;
  967. }
  968. string name = dt.Rows[j]["TypeName"].ToString();
  969. if (!listName.Contains(name))
  970. {
  971. listName.Add(name);
  972. }
  973. }
  974. for (int j = 0; j < dt.Rows.Count; j++)
  975. {
  976. if (Convert.ToInt32(dt.Rows[j]["TypeId"]) > 100)
  977. {
  978. continue;
  979. }
  980. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[j]["TypeId"]));
  981. if (index == -1)
  982. {
  983. index = 7;
  984. }
  985. string name = NameList[index];
  986. if (!listName.Contains(name))
  987. {
  988. listName.Add(name);
  989. }
  990. }
  991. //设置数据
  992. List<Item> listData = new List<Item>();
  993. //ListData
  994. for (int k = 0; k < dt.Rows.Count; k++)
  995. {
  996. string str = dt.Rows[k]["con"].ToString();
  997. string name = dt.Rows[k]["TypeName"].ToString();
  998. if (Convert.ToInt32(dt.Rows[k]["TypeId"]) < 100)
  999. {
  1000. if (Convert.ToInt32(dt.Rows[k]["TypeId"])==-1)
  1001. {
  1002. name = NameList[7];
  1003. }
  1004. else
  1005. {
  1006. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[k]["TypeId"]));
  1007. name = NameList[index];
  1008. }
  1009. }
  1010. Item item = new Item()
  1011. {
  1012. value = decimal.Round(decimal.Parse(str), 2).ToString(),
  1013. name = name
  1014. };
  1015. listData.Add(item);
  1016. }
  1017. listDataMore.Add(listData);
  1018. break;
  1019. case "EComponent":
  1020. //创建新的图形数据源
  1021. dt = particledata.GetElementForArea(filedAndParticl);
  1022. //ListName
  1023. for (int j = 0; j < dt.Rows.Count; j++)
  1024. {
  1025. string name = dt.Rows[j]["name"].ToString();
  1026. if (!listName.Contains(name))
  1027. {
  1028. listName.Add(name);
  1029. }
  1030. }
  1031. //设置数据
  1032. List<Item> listData1 = new List<Item>();
  1033. //ListData
  1034. for (int k = 0; k < dt.Rows.Count; k++)
  1035. {
  1036. string str = dt.Rows[k]["earea"].ToString();
  1037. try
  1038. {
  1039. Item item = new Item()
  1040. {
  1041. value = decimal.Round(decimal.Parse(str), 2).ToString(),
  1042. name = dt.Rows[k]["name"].ToString()
  1043. };
  1044. listData1.Add(item);
  1045. }
  1046. catch
  1047. {
  1048. Item item = new Item()
  1049. {
  1050. value = str,
  1051. name = dt.Rows[k]["name"].ToString()
  1052. };
  1053. listData1.Add(item);
  1054. }
  1055. }
  1056. listDataMore.Add(listData1);
  1057. break;
  1058. case "PSize":
  1059. //获取粒级表
  1060. string pathe = m_DataMgr.m_RptConfigFile.PartSizeFileFolder + m_DataMgr.m_RptConfigFile.PartSizeFile;
  1061. DataSet ds = DataOperation.DataAccess.XMLoperate.GetXml(pathe);
  1062. string sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();
  1063. List<string> temp = new List<string>();
  1064. for (int j = 0; j < sizestr.Split(',').Length - 1; j++)
  1065. {
  1066. if (sizestr.Split(',')[j].Length > 0)
  1067. {
  1068. double d1 = Convert.ToDouble(sizestr.Split(',')[j]);
  1069. double d2 = Convert.ToDouble(sizestr.Split(',')[j + 1]);
  1070. string name = d1.ToString() + "~" + d2.ToString();
  1071. temp.Add(name);
  1072. if (!listName.Contains(name))
  1073. {
  1074. listName.Add(name);
  1075. }
  1076. }
  1077. }
  1078. double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
  1079. string name1 = d.ToString() + "~MAX";
  1080. temp.Add(name1);
  1081. if (!listName.Contains(name1))
  1082. {
  1083. listName.Add(name1);
  1084. }
  1085. //string con = m_ReportApp.SourceGridData.ConditionItemList[m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE)].itemVal.ToString();
  1086. string con = m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
  1087. string po = "";
  1088. switch (con)
  1089. {
  1090. case "DMAX":
  1091. po = "DMAX";
  1092. break;
  1093. case "DMIN":
  1094. po = "DMIN";
  1095. break;
  1096. case "CIRCLE":
  1097. po = "Area";
  1098. break;
  1099. case "FERET":
  1100. po = "DFERET";
  1101. break;
  1102. }
  1103. DataTable dtp = particledata.GetParticleAll(filedAndParticl);
  1104. //设置数据
  1105. List<Item> listData4 = new List<Item>();
  1106. //ListData
  1107. for (int k = 0; k < temp.Count; k++)
  1108. {
  1109. string str = temp[k];
  1110. string d1 = str.Split('~')[0];
  1111. string d2 = str.Split('~')[1];
  1112. if (d2 == "MAX")
  1113. {
  1114. d2 = "999";
  1115. }
  1116. DataRow[] datas = dtp.Select(getWhere(d2, d1, po));
  1117. Item item = new Item()
  1118. {
  1119. value = datas.Count().ToString(),
  1120. name = str
  1121. };
  1122. listData4.Add(item);
  1123. }
  1124. listDataMore.Add(listData4);
  1125. break;
  1126. }
  1127. }
  1128. }
  1129. chart.ListName = listName;
  1130. chart.SoursName = soursName;
  1131. chart.ListData = listDataMore;
  1132. return chart;
  1133. }
  1134. class Chartdate
  1135. {
  1136. public string Title { get; set; }
  1137. public string YName { get; set; }
  1138. public List<string> ListName { get; set; }
  1139. public List<Item> ListData { get; set; }
  1140. }
  1141. class ChartdateMore
  1142. {
  1143. public string Title { get; set; }
  1144. public string YName { get; set; }
  1145. public List<string> ListName { get; set; }
  1146. public List<string> SoursName { get; set; }
  1147. public List<List<Item>> ListData { get; set; }
  1148. }
  1149. class Item
  1150. {
  1151. public string value { get; set; }
  1152. public string name { get; set; }
  1153. }
  1154. //获取图片
  1155. private void button1_Click(object sender, EventArgs e)
  1156. {
  1157. //string str = GetPic();
  1158. //pic = str;
  1159. ////保存目录
  1160. //string dir = Path.Combine(Directory.GetCurrentDirectory(), "Resources/HTML/pic");
  1161. ////文件名称
  1162. //string fileName = "headdemo" + DateTime.Now.ToString("yyyyMMddHHmmssff");
  1163. ////保存文件所在站点位置
  1164. //string filePath = Path.Combine(dir, fileName);
  1165. //if (!System.IO.Directory.Exists(dir))
  1166. // System.IO.Directory.CreateDirectory(dir);
  1167. ////将Base64String转为图片并保存
  1168. //byte[] arr2 = Convert.FromBase64String(str.Substring(str.IndexOf(',') + 1));
  1169. //using (MemoryStream ms2 = new MemoryStream(arr2))
  1170. //{
  1171. // System.Drawing.Bitmap bmp2 = new System.Drawing.Bitmap(ms2);
  1172. // bmp2.Save(filePath + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
  1173. //}
  1174. }
  1175. /// <summary>
  1176. /// 加载浏览器
  1177. /// </summary>
  1178. public void InitBrowser()
  1179. {
  1180. //加载网页
  1181. if (m_ReportApp.browser == null || m_ReportApp.trans)
  1182. {
  1183. // 获取生成路径下网页文件的绝对路径
  1184. string fileName = Path.Combine(Directory.GetCurrentDirectory(), url);
  1185. //加载网页
  1186. m_ReportApp.browser = new ChromiumWebBrowser(fileName);
  1187. //禁止网页
  1188. m_ReportApp.browser.MenuHandler = new MenuHandler();
  1189. m_ReportApp.browser.Dock = DockStyle.Fill;
  1190. m_ReportApp.js.MessageText = "";
  1191. //添加网页到当前自定义控件
  1192. this.Controls.Add(m_ReportApp.browser);
  1193. //供页面调用以传递数据
  1194. m_ReportApp.browser.RegisterJsObject("jsObj", m_ReportApp.js, false);
  1195. //升级cef版本后新方法
  1196. //CefSharpSettings.LegacyJavascriptBindingEnabled = true;
  1197. //CefSharpSettings.WcfEnabled = true;
  1198. //m_ReportApp.browser.JavascriptObjectRepository.Register("jsObj", m_ReportApp.js, isAsync: false, options: BindingOptions.DefaultBinder);
  1199. //网页加载结束后调用事件
  1200. m_ReportApp.browser.FrameLoadEnd += WebBrowser_FrameLoadEnd;
  1201. }
  1202. else
  1203. {
  1204. m_ReportApp.browser.ResetText();
  1205. m_ReportApp.browser.Reload();
  1206. m_ReportApp.browser.Refresh();
  1207. //供页面调用以传递数据
  1208. this.Controls.Add(m_ReportApp.browser);
  1209. }
  1210. if (m_ReportApp.timerKG)
  1211. {
  1212. timer1.Enabled = true;
  1213. }
  1214. }
  1215. /// <summary>
  1216. /// 页面加载结束后事件
  1217. /// </summary>
  1218. /// <param name="sender"></param>
  1219. /// <param name="e"></param>
  1220. private void WebBrowser_FrameLoadEnd(object sender, FrameLoadEndEventArgs e)
  1221. {
  1222. if (e.Frame.IsMain)
  1223. {
  1224. //为页面图形提供数据参数
  1225. string str = m_ReportApp.data;
  1226. //执行网页脚本事件
  1227. m_ReportApp.browser.ExecuteScriptAsync("showchart('" + str + "','" + m_ReportApp.type + "')");
  1228. }
  1229. }
  1230. //public string GetPic()
  1231. //{
  1232. // return js.MessageText;
  1233. //}
  1234. //禁止网页操作,右键点击等
  1235. class MenuHandler : CefSharp.IContextMenuHandler
  1236. {
  1237. void CefSharp.IContextMenuHandler.OnBeforeContextMenu(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.IMenuModel model)
  1238. {
  1239. model.Clear();
  1240. }
  1241. bool CefSharp.IContextMenuHandler.OnContextMenuCommand(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.CefMenuCommand commandId, CefSharp.CefEventFlags eventFlags)
  1242. {
  1243. //throw new NotImplementedException();
  1244. return false;
  1245. }
  1246. void CefSharp.IContextMenuHandler.OnContextMenuDismissed(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame)
  1247. {
  1248. //throw new NotImplementedException();
  1249. }
  1250. bool CefSharp.IContextMenuHandler.RunContextMenu(CefSharp.IWebBrowser browserControl, CefSharp.IBrowser browser, CefSharp.IFrame frame, CefSharp.IContextMenuParams parameters, CefSharp.IMenuModel model, CefSharp.IRunContextMenuCallback callback)
  1251. {
  1252. return false;
  1253. }
  1254. }
  1255. class JsEvent
  1256. {
  1257. public string MessageText { set; get; }
  1258. public void ShowTest()
  1259. {
  1260. MessageBox.Show(MessageText);
  1261. }
  1262. }
  1263. #endregion
  1264. #region EChart导出图像委托调用部份
  1265. public delegate void MyDelgate(string va);
  1266. public event MyDelgate butclic;
  1267. private void timer1_Tick(object sender, EventArgs e)
  1268. {
  1269. if (butclic == null)
  1270. return;
  1271. if (m_ReportApp.js == null)
  1272. return;
  1273. if (m_ReportApp.js.MessageText == null)
  1274. return;
  1275. if (m_ReportApp.js.MessageText != "")
  1276. {
  1277. butclic(m_ReportApp.js.MessageText);
  1278. timer1.Enabled = false;
  1279. m_ReportApp.timerKG = false;
  1280. }
  1281. }
  1282. #endregion
  1283. }
  1284. }