ParticlesSizeGrid.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703
  1. 
  2. using DevExpress.Utils;
  3. using DevExpress.XtraCharts;
  4. using OTSIncAReportApp._1_UI.Control_DEVCharts;
  5. using OTSIncAReportApp.OTSRstMgrFunction;
  6. using OTSIncAReportApp.OTSSampleReportInfo;
  7. using OTSIncAReportApp.SysMgrTools;
  8. using OTSIncAReportGraph.Class;
  9. using System;
  10. using System.Collections;
  11. using System.Collections.Generic;
  12. using System.Data;
  13. using System.Drawing;
  14. using System.Linq;
  15. using System.Windows.Forms;
  16. namespace OTSIncAReportGrids
  17. {
  18. /// <summary>
  19. /// 颗粒尺寸分布表 颗粒尺寸表
  20. /// </summary>
  21. public partial class ParticlesSizeGrid : UserControl
  22. {
  23. #region 设置变量
  24. //设置模拟数据表
  25. public DataTable m_dt = new DataTable();
  26. //国际化
  27. Language lan;
  28. Hashtable table;
  29. //测量结果
  30. ResultFile result = null;
  31. OTSIncAReportApp.OTSSampleReportInfo.ReportCondition source;
  32. OTSIncAReportApp.frmReportApp m_ReportApp;
  33. int gridheight = 0;
  34. int gridwidth = 0;
  35. public string condition = "";
  36. List<DataTable> list_table_data = new List<DataTable>();
  37. List<Point> list_table_size = new List<Point>();
  38. List<Point> list_table_Point = new List<Point>();
  39. List<string> list_fileName = new List<string>();
  40. #endregion
  41. #region 自定义方法
  42. private string getWhere(string max, string min, string col, string partic)
  43. {
  44. if (col == "Area")
  45. {
  46. return col + ">=" + ((Convert.ToDouble(min)/2) * (Convert.ToDouble(min)/2) * Math.PI).ToString() + " and " + col + "<" + ((Convert.ToDouble(max)/2) * (Convert.ToDouble(max)/2) * Math.PI).ToString() + " and TypeId=" + partic;
  47. }
  48. else
  49. {
  50. return col + ">=" + min + " and " + col + "<" + max + " and TypeId=" + partic;
  51. }
  52. }
  53. /// <summary>
  54. /// 绑定datagridview数据
  55. /// </summary>
  56. public void BindDataGridView(string path, int num, string filename)
  57. {
  58. List<string> colid = new List<string>() { "rowid", "pname", "color", "TypeId", "Largest", "Total" };
  59. List<string> colname = new List<string>() { table["str1"].ToString(), table["str8"].ToString(), table["str9"].ToString(), "TypeId", table["str10"].ToString(), table["str11"].ToString() };
  60. OTSGridView gridView = new OTSGridView();
  61. OTSIncAReportApp.DataOperation.DataAccess.ParticleData particledata = new OTSIncAReportApp.DataOperation.DataAccess.ParticleData(path);
  62. DataTable dtp = particledata.GetParticleAll("");
  63. string sizestr = null;
  64. string con = "";
  65. if (condition != "")
  66. {
  67. con = condition;
  68. }
  69. else
  70. {
  71. con = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
  72. }
  73. string po = "";
  74. switch (con)
  75. {
  76. case "DMAX":
  77. po = "DMAX";
  78. break;
  79. case "DMIN":
  80. po = "DMIN";
  81. break;
  82. case "ECD":
  83. po = "Area";
  84. break;
  85. case "FERET":
  86. po = "DFERET";
  87. break;
  88. }
  89. //获取粒级表
  90. if (m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile == "AUTO.psf")
  91. {
  92. double dn = 99999;
  93. string sou = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  94. if (sou.Contains("+"))
  95. {
  96. for (int i = 0; i < sou.Split('+').Length; i++)
  97. {
  98. ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
  99. if (resultFile != null)
  100. {
  101. if(dn> resultFile.GetParticleMINECD())
  102. {
  103. dn = resultFile.GetParticleMINECD();
  104. }
  105. }
  106. }
  107. }
  108. else
  109. {
  110. ResultFile resultFile = m_ReportApp.m_rstDataMgr.CurResultFile;
  111. dn = resultFile.GetParticleMINECD();
  112. }
  113. sizestr = dn.ToString()+",";
  114. for(double p= dn; p<50;p=p * Math.Sqrt(2))
  115. {
  116. if(p > dn&& p <= 50.5)
  117. {
  118. double dd = Math.Round(p);
  119. sizestr += dd.ToString() + ",";
  120. }
  121. }
  122. sizestr = sizestr.Remove(sizestr.Length - 1, 1);
  123. }
  124. else
  125. {
  126. string path1 = m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder + m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
  127. DataSet ds = OTSIncAReportApp.DataOperation.DataAccess.XMLoperate.GetXml(path1);
  128. sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();
  129. }
  130. for (int i = 0; i < sizestr.Split(',').Length - 1; i++)
  131. {
  132. if (sizestr.Split(',')[i].Length > 0)
  133. {
  134. double d1 = Convert.ToDouble(sizestr.Split(',')[i]);
  135. double d2 = Convert.ToDouble(sizestr.Split(',')[i + 1]);
  136. colid.Add(d1.ToString() + "~" + d2.ToString());
  137. colname.Add(d1.ToString() + "~" + d2.ToString());
  138. }
  139. }
  140. double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
  141. colid.Add(d.ToString() + "~MAX");
  142. colname.Add(d.ToString() + "~MAX");
  143. //创建Grid的列 创建Datatable的列
  144. for (int i = 0; i < colid.Count; i++)
  145. {
  146. gridView.Columns.Add(colid[i], colname[i]);
  147. if (!m_dt.Columns.Contains(colid[i]))
  148. m_dt.Columns.Add(colid[i]);
  149. gridView.Columns[i].ValueType = typeof(System.Int32);
  150. }
  151. if (!m_dt.Columns.Contains("Class"))
  152. m_dt.Columns.Add("Class");
  153. //设置grid默认值的样式,防止图像为空时有红x
  154. for (int i = 0; i < gridView.Columns.Count; i++)
  155. {
  156. gridView.Columns[i].DefaultCellStyle.NullValue = null;
  157. }
  158. List<int> FLID = new List<int>() { 0, 1, 2, 4, 6, 7, 8, 9 };
  159. List<string> 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() };
  160. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
  161. //int sel = m_ReportApp.SourceGridData.ConditionItemList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString());
  162. int sel = m_ReportApp.m_conditionChoose.m_conditionData.GetComboDownListIndexByItemName(OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  163. string filedAndParticl = "";
  164. DataTable dt;
  165. dt = particledata.GetParticleListForParticlSize("area", filedAndParticl);
  166. gridView.MergeColumnNames.Add(filename);
  167. gridView.AddSpanHeader(1, gridView.Columns.Count - 1, filename);
  168. for (int i = 0; i < dt.Rows.Count; i++)
  169. {
  170. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
  171. {
  172. continue;
  173. }
  174. int add_rowindex = gridView.Rows.Add();
  175. gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;
  176. gridView.Rows[add_rowindex].Cells[1].Value = dt.Rows[i]["TypeName"];
  177. gridView.Rows[add_rowindex].Cells[1].Style.BackColor = Color.Azure;
  178. string color = dt.Rows[i]["TypeColor"].ToString();
  179. if (!color.Contains("#"))
  180. {
  181. color = "#" + dt.Rows[i]["TypeColor"].ToString();
  182. }
  183. gridView.Rows[add_rowindex].Cells[2].Style.BackColor = DrawFunction.colorHx16toRGB(color);
  184. gridView.Rows[add_rowindex].Cells[3].Value = dt.Rows[i]["TypeId"];
  185. gridView.Rows[add_rowindex].Cells[4].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
  186. gridView.Rows[add_rowindex].Cells[4].Style.BackColor = Color.Azure;
  187. gridView.Rows[add_rowindex].Cells[5].Value = dt.Rows[i]["con"];
  188. gridView.Rows[add_rowindex].Cells[5].Style.BackColor = Color.Azure;
  189. m_dt.Rows.Add();
  190. m_dt.Rows[add_rowindex]["pname"]= dt.Rows[i]["TypeName"];
  191. m_dt.Rows[add_rowindex]["TypeId"]=dt.Rows[i]["TypeId"];
  192. m_dt.Rows[add_rowindex]["Largest"] = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
  193. m_dt.Rows[add_rowindex]["Total"]= dt.Rows[i]["con"];
  194. m_dt.Rows[add_rowindex]["Class"] = dt.Rows[i]["GroupName"];
  195. }
  196. for (int i = 0; i < dt.Rows.Count; i++)
  197. {
  198. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100)
  199. {
  200. continue;
  201. }
  202. int add_rowindex = gridView.Rows.Add();
  203. gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;
  204. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
  205. if (index == -1)
  206. {
  207. index = 7;
  208. }
  209. string name = NameList[index];
  210. //gridView.Rows[add_rowindex].Cells[1].Value = name;
  211. gridView.Rows[add_rowindex].Cells[1].Value = dt.Rows[i]["TypeName"];
  212. gridView.Rows[add_rowindex].Cells[1].Style.BackColor = Color.Azure;
  213. string color = "#000000";
  214. gridView.Rows[add_rowindex].Cells[2].Style.BackColor = DrawFunction.colorHx16toRGB(color);
  215. gridView.Rows[add_rowindex].Cells[3].Value = dt.Rows[i]["TypeId"];
  216. gridView.Rows[add_rowindex].Cells[4].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
  217. gridView.Rows[add_rowindex].Cells[4].Style.BackColor = Color.Azure;
  218. gridView.Rows[add_rowindex].Cells[5].Value = dt.Rows[i]["con"];
  219. gridView.Rows[add_rowindex].Cells[5].Style.BackColor = Color.Azure;
  220. m_dt.Rows.Add();
  221. m_dt.Rows[add_rowindex]["pname"] = dt.Rows[i]["TypeName"];
  222. m_dt.Rows[add_rowindex]["TypeId"] = dt.Rows[i]["TypeId"];
  223. m_dt.Rows[add_rowindex]["Largest"] = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
  224. m_dt.Rows[add_rowindex]["Total"] = dt.Rows[i]["con"];
  225. m_dt.Rows[add_rowindex]["Class"] = dt.Rows[i]["GroupName"];
  226. }
  227. for (int i = 0; i < gridView.Rows.Count - 1; i++)
  228. {
  229. for (int j = 6; j < colid.Count; j++)
  230. {
  231. string d1 = colid[j].Split('~')[0];
  232. string d2 = colid[j].Split('~')[1];
  233. if (d2 == "MAX")
  234. {
  235. d2 = "999";
  236. }
  237. DataRow[] datas = dtp.Select(getWhere(d2, d1, po, gridView.Rows[i].Cells[3].Value.ToString()));
  238. gridView.Rows[i].Cells[j].Value = datas.Count();
  239. gridView.Rows[i].Cells[j].Style.BackColor = Color.Azure;
  240. m_dt.Rows[i][colid[j]]= datas.Count();
  241. }
  242. }
  243. gridView.Columns[3].Visible = false;
  244. //设置grid默认值的样式,防止图像为空时有红x
  245. for (int i = 0; i < gridView.Columns.Count; i++)
  246. {
  247. gridView.Columns[i].DefaultCellStyle.NullValue = null;
  248. }
  249. gridView.Name = "gridView" + num.ToString();
  250. int a1=gridView.Rows.Add();
  251. gridView.Rows[a1].Cells[1].Value = "Sum";
  252. for(int j=0;j< gridView.Rows.Count-2;j++)
  253. {
  254. for(int k=3;k< gridView.Columns.Count;k++)
  255. {
  256. if (gridView.Rows[a1].Cells[k].Value == null)
  257. gridView.Rows[a1].Cells[k].Value = 0;
  258. if (k == 5)
  259. {
  260. gridView.Rows[a1].Cells[k].Value = Convert.ToInt64(gridView.Rows[a1].Cells[k].Value) + Convert.ToInt64(gridView.Rows[j].Cells[k].Value);
  261. }
  262. else
  263. {
  264. gridView.Rows[a1].Cells[k].Value = Convert.ToInt32(gridView.Rows[a1].Cells[k].Value) + Convert.ToInt32(gridView.Rows[j].Cells[k].Value);
  265. }
  266. }
  267. }
  268. list_table_Point.Add(SetDataGridViewStyle(gridView));
  269. panel1.Controls.Add(gridView);
  270. list_table_data.Add(m_dt);
  271. }
  272. /// <summary>
  273. /// 设置DataGridView样式
  274. /// </summary>
  275. private Point SetDataGridViewStyle(OTSGridView gridView)
  276. {
  277. //用户不能调整标题的高度
  278. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  279. //用户不能调整 行高
  280. gridView.AllowUserToResizeRows = false;
  281. //改变行的高度;
  282. //gridView.RowTemplate.Height = 20;
  283. //点击选择整行
  284. gridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  285. //居中显示
  286. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  287. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  288. gridView.DefaultCellStyle = dataGridViewCellStyle1;
  289. gridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  290. //再次重覆禁用拖动表头高度,居然有效果了
  291. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  292. //设置grid可以复制
  293. gridView.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  294. //设置每列的宽度
  295. gridView.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  296. gridView.Columns[1].Width = 200;
  297. //设置序号列不排序
  298. gridView.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  299. //设置序号列不可以设置宽度
  300. gridView.Columns[0].Resizable = DataGridViewTriState.False;
  301. gridView.AllowUserToAddRows = false;
  302. gridView.AllowUserToDeleteRows = false;
  303. gridView.AllowUserToResizeRows = false;
  304. gridView.BackgroundColor = System.Drawing.SystemColors.ButtonHighlight;
  305. gridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
  306. gridView.ContextMenuStrip = this.contextMenuStrip1;
  307. gridView.BorderStyle = 0;
  308. int outpos = gridwidth;
  309. gridView.Location = new System.Drawing.Point(gridwidth, 0);
  310. gridView.Margin = new System.Windows.Forms.Padding(2);
  311. gridView.MergeColumnHeaderBackColor = System.Drawing.SystemColors.ButtonHighlight;
  312. gridView.ReadOnly = true;
  313. gridView.RowHeadersVisible = false;
  314. gridView.RowHeadersWidth = 40;
  315. gridView.RowTemplate.Height = 30;
  316. //gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30 + 30);
  317. int gridView_Width = 0;
  318. for (int i = 0; i < gridView.ColumnCount; i++)
  319. {
  320. gridView_Width = gridView_Width + gridView.Columns[i].Width;
  321. }
  322. gridView.Size = new System.Drawing.Size(gridView_Width, gridView.RowCount * 30);
  323. //gridheight = gridheight + gridView.RowCount * 30 + 80;
  324. gridheight = gridheight + gridView.RowCount * 30 + 5;
  325. gridwidth = gridwidth + gridView.ColumnCount * 100;
  326. gridView.TabIndex = 0;
  327. gridView.Sorted += Gview_gz_Sorted;
  328. //先设置一下头的高度,否则会太矮不好看
  329. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
  330. gridView.ColumnHeadersHeight = 40;
  331. gridView.Columns[4].Visible = false;
  332. list_table_size.Add(new Point(gridView.ColumnCount * 100 - 40, gridView.RowCount * 30));
  333. return new Point(outpos, gridheight);
  334. //list_table_Point.Add(new Point(gridwidth, gridheight));
  335. }
  336. #endregion
  337. #region 窗体加载及初始化
  338. public ParticlesSizeGrid()
  339. {
  340. InitializeComponent();
  341. }
  342. /// <summary>
  343. /// 成份分布表,构造函数
  344. /// </summary>
  345. /// <param name="in_sec">传入,委托类对象</param>
  346. /// <param name="in_Cotsreportprojfilemgrclr">传入,项目管理类对象</param>
  347. public ParticlesSizeGrid(OTSIncAReportApp.frmReportApp ReportApp)
  348. {
  349. m_ReportApp = ReportApp;
  350. result = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()];
  351. source = m_ReportApp.m_conditionChoose.m_conditionData;
  352. InitializeComponent();
  353. //国际化
  354. lan = new Language(this);
  355. table = lan.GetNameTable(this.Name);
  356. }
  357. private void ParticlesSizeGrid_Load(object sender, EventArgs e)
  358. {
  359. list_table_data.Clear();
  360. list_table_size.Clear();
  361. list_table_Point.Clear();
  362. list_fileName.Clear();
  363. string sou = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  364. if (sou.Contains("+"))
  365. {
  366. for (int i = 0; i < sou.Split('+').Length; i++)
  367. {
  368. ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
  369. if (resultFile != null)
  370. {
  371. BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName);
  372. list_fileName.Add(resultFile.anotherFileName);
  373. }
  374. }
  375. }
  376. else
  377. {
  378. for (int i=0;i< m_ReportApp.m_rstDataMgr.ResultFilesList.Count;i++)
  379. {
  380. if (sou == m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName.ToString())
  381. {
  382. BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[i].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
  383. list_fileName.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
  384. }
  385. }
  386. }
  387. }
  388. public void SetGraphicType(ReportCondition sourceGridData)
  389. {
  390. string stdId = "";
  391. int stdIdIndex = 0;
  392. //find the stdId condition
  393. var STDIdItm = sourceGridData.ConditionItemList.Find(s => s.iItemId == OTS_REPORT_PROP_GRID_ITEMS.STD_ID);
  394. if (STDIdItm != null)
  395. {
  396. stdId = STDIdItm.itemDisplayVal.ToString();
  397. stdIdIndex = STDIdItm.comboDownList.IndexOf(stdId);
  398. }
  399. int high = 0;
  400. for (int i = 0; i < list_table_Point.Count; i++)
  401. {
  402. if (high < list_table_Point[i].Y)
  403. {
  404. high = list_table_Point[i].Y;
  405. }
  406. }
  407. for (int i = 0; i < list_table_data.Count; i++)
  408. {
  409. Graphics_Stacking(list_table_data[i], stdId, list_table_size[i],list_table_Point[i], high);
  410. }
  411. }
  412. /// <summary>
  413. /// chart图创建
  414. /// </summary>
  415. /// <param name="dt"></param>
  416. /// <param name="stdId"></param>
  417. private void Graphics_Stacking(DataTable dt, string stdId, Point a_size ,Point a_Location,int location_hig)
  418. {
  419. ChartControl chartControl1 = new ChartControl();
  420. chartControl1.Series.Clear();
  421. chartControl1.Size = new Size(a_size.X, a_size.Y);
  422. chartControl1.Location = new Point(a_Location.X, location_hig);
  423. DataTable dataTable = new DataTable();
  424. dataTable.Columns.Add("name");
  425. dataTable.Columns.Add("size");
  426. if (stdId != "All")
  427. {
  428. for (int i = 0; i < dt.Rows.Count; i++)
  429. {
  430. if (dt.Rows[i]["pname"].ToString() == stdId)
  431. {
  432. for (int a = 7; a < dt.Columns.Count-1; a++)
  433. {
  434. DataRow dr = dataTable.NewRow();
  435. dr["name"] = dt.Columns[a].ColumnName;
  436. dr["size"] = Convert.ToInt16(dt.Rows[i][a]);
  437. dataTable.Rows.Add(dr);
  438. }
  439. }
  440. }
  441. }
  442. if (stdId == "All")
  443. {
  444. List<Series> seriesList = new List<Series>();
  445. DataTable data = new DataTable();
  446. data.Columns.Add("name");
  447. data.Columns.Add("range");
  448. data.Columns.Add("num");
  449. for (int i = 0; i < dt.Rows.Count; i++)
  450. {
  451. if (dt.Rows[i]["pname"].ToString() != "")
  452. {
  453. for (int a = 6; a < dt.Columns.Count - 1; a++)
  454. {
  455. DataRow dr = data.NewRow();
  456. dr["name"] = dt.Rows[i]["pname"].ToString();
  457. dr["range"] = dt.Columns[a].ColumnName;
  458. dr["num"] = dt.Rows[i][a].ToString();
  459. data.Rows.Add(dr);
  460. }
  461. }
  462. }
  463. foreach (DataRow dr in data.DefaultView.ToTable(true, "name").Rows)
  464. {
  465. Series s = new Series(dr["name"].ToString(), ViewType.StackedBar)
  466. {
  467. LegendTextPattern = dr["name"].ToString(),
  468. ArgumentScaleType = ScaleType.Qualitative,
  469. };
  470. foreach (DataRow drl in data.Select("name='" + dr["name"].ToString() + "'"))
  471. s.Points.Add(new SeriesPoint(drl["range"].ToString(), int.Parse(drl["num"].ToString())));
  472. s.LabelsVisibility = DefaultBoolean.False;
  473. seriesList.Add(s);
  474. }
  475. foreach (Series sr in seriesList.ToArray())
  476. chartControl1.Series.Add(sr);
  477. }
  478. else
  479. {
  480. // 假设你已经有一个 ChartControl 实例,并且已经添加了一个饼图 Series
  481. Series series = new Series(stdId, ViewType.Bar);
  482. for (int a = 0; a < dataTable.Rows.Count; a++)
  483. {
  484. string name = dataTable.Rows[a]["name"].ToString();
  485. double Cunt = Convert.ToDouble(dataTable.Rows[a]["size"]);
  486. series.Points.Add(new SeriesPoint(name, Cunt));
  487. }
  488. series.LabelsVisibility = DefaultBoolean.True;
  489. chartControl1.Series.Add(series);
  490. }
  491. ((XYDiagram)chartControl1.Diagram).AxisY.Title.Text = "";
  492. ((XYDiagram)chartControl1.Diagram).AxisX.Title.Text = "";
  493. ((XYDiagram)chartControl1.Diagram).AxisY.Title.Visibility = DefaultBoolean.True;
  494. ((XYDiagram)chartControl1.Diagram).AxisX.Title.Visibility = DefaultBoolean.True;
  495. ((XYDiagram)chartControl1.Diagram).AxisY.Title.Font = new Font("Tahoma", 9);
  496. ((XYDiagram)chartControl1.Diagram).AxisX.Title.Font = new Font("Tahoma", 9);
  497. ((XYDiagram)chartControl1.Diagram).AxisY.Title.Alignment = System.Drawing.StringAlignment.Far;
  498. ((XYDiagram)chartControl1.Diagram).AxisX.Title.Alignment = System.Drawing.StringAlignment.Far;
  499. //图例的位置定义
  500. chartControl1.Legend.AlignmentVertical = LegendAlignmentVertical.Top;
  501. chartControl1.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.RightOutside;
  502. chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
  503. chartControl1.Legend.Direction = LegendDirection.TopToBottom;
  504. //十字准线光标
  505. chartControl1.CrosshairEnabled = DefaultBoolean.True;
  506. chartControl1.CrosshairOptions.ShowValueLine = true;
  507. chartControl1.CrosshairOptions.ShowArgumentLabels = true;
  508. panel1.Controls.Add(chartControl1);
  509. }
  510. #endregion
  511. #region 相关事件
  512. private void ToolStripMenuItem1_Click(object sender, EventArgs e)
  513. {
  514. //复制整个表
  515. CopyAll();
  516. }
  517. private void ToolStripMenuItem2_Click(object sender, EventArgs e)
  518. {
  519. CopySelected();
  520. }
  521. /// <summary>
  522. /// 复制选择区域
  523. /// </summary>
  524. public void CopySelected()
  525. {
  526. foreach (var item in panel1.Controls)
  527. {
  528. if (item.GetType().ToString() == "OTSGridView")
  529. {
  530. //复制选择区域
  531. object oo = ((OTSGridView)item).GetClipboardContent();
  532. Clipboard.SetDataObject(((OTSGridView)item).GetClipboardContent());
  533. }
  534. }
  535. }
  536. /// <summary>
  537. /// 复制所有
  538. /// </summary>
  539. public void CopyAll()
  540. {
  541. foreach (var item in panel1.Controls)
  542. {
  543. if (item.GetType().ToString() == "OTSGridView")
  544. {
  545. ((OTSGridView)item).SelectAll();
  546. Clipboard.SetDataObject(((OTSGridView)item).GetClipboardContent());
  547. }
  548. }
  549. }
  550. private void ToolStripMenuItem3_Click(object sender, EventArgs e)
  551. {
  552. foreach (var item in panel1.Controls)
  553. {
  554. if (item.GetType().ToString() == "OTSGridView")
  555. {
  556. panel1.Controls.Remove((OTSGridView)item);
  557. }
  558. }
  559. gridheight = 0;
  560. //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
  561. //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
  562. string sou = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  563. if (sou.Contains("+"))
  564. {
  565. for (int i = 0; i < sou.Split('+').Length; i++)
  566. {
  567. ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
  568. if (resultFile != null)
  569. {
  570. BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName);
  571. }
  572. }
  573. }
  574. else
  575. {
  576. BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].anotherFileName);
  577. }
  578. }
  579. private void Gview_gz_Sorted(object sender, EventArgs e)
  580. {
  581. //排序完成,重新设置序号
  582. for (int i = 0; i < ((OTSGridView)sender).Rows.Count; i++)
  583. {
  584. ((OTSGridView)sender).Rows[i].Cells[0].Value = (i+1).ToString();
  585. }
  586. }
  587. #endregion
  588. #region 获取向导出模块提供的DataTable和GridView对象
  589. /// <summary>
  590. /// 获取到该模块输出后形成的DataTable,和GridView
  591. /// </summary>
  592. /// <param name="out_dt"></param>
  593. /// <param name="out_dg"></param>
  594. public void GetDataTableAndGridView(out DataTable out_dt, out DataGridView out_dg)
  595. {
  596. out_dt = m_dt;
  597. out_dg = null;
  598. foreach (var item in panel1.Controls)
  599. {
  600. if (item.GetType().ToString() == "OTSGridView")
  601. {
  602. out_dg = ((OTSGridView)item);
  603. }
  604. }
  605. }
  606. #endregion
  607. }
  608. }