CompositionDistributionGrid.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764
  1. using DevExpress.Utils;
  2. using DevExpress.XtraCharts;
  3. using DevExpress.XtraRichEdit.Layout;
  4. using DevExpress.XtraTreeList.Data;
  5. using NPOI.SS.Formula.Functions;
  6. using OTSCommon.DBOperate.Model;
  7. using OTSIncAReportApp;
  8. using OTSIncAReportApp._1_UI.Control_DEVCharts;
  9. using OTSIncAReportApp.DataOperation.DataAccess;
  10. using OTSIncAReportApp.OTSRstMgrFunction;
  11. using OTSIncAReportApp.OTSSampleReportInfo;
  12. using OTSIncAReportApp.SysMgrTools;
  13. using OTSIncAReportGraph.Class;
  14. using System;
  15. using System.Collections;
  16. using System.Collections.Generic;
  17. using System.Data;
  18. using System.Drawing;
  19. using System.Linq;
  20. using System.Windows.Forms;
  21. namespace OTSIncAReportGrids
  22. {
  23. /// <summary>
  24. /// 成分分布表 颗粒成份分布表
  25. /// </summary>
  26. public partial class CompositionDistributionGrid : UserControl
  27. {
  28. #region 设置变量
  29. //设置模拟数据表
  30. public DataTable m_dt = new DataTable();
  31. DataTable SelectParticlesListConvertToTable(List<Particle> selectParticles)
  32. {
  33. DataTable dataTable = new DataTable();
  34. return dataTable;
  35. }
  36. //国际化
  37. Language lan;
  38. Hashtable table;
  39. //测量结果
  40. ResultFile result = null;
  41. OTSIncAReportApp.OTSSampleReportInfo.ReportCondition source;
  42. OTSIncAReportApp.frmReportApp m_ReportApp;
  43. frmReportConditionChoose m_condition;
  44. //int gridheight = 0;
  45. List<int> list_gridheight = new List<int>();
  46. List<DataTable> list_table_data = new List<DataTable>();
  47. List<Point> list_table_size = new List<Point>();
  48. List<Point> list_table_Point = new List<Point>();
  49. List<string> list_fileName = new List<string>();
  50. int DataNumber = 0;//当前数据;
  51. List<ComboBox> list_ComboBox = new List<ComboBox>();
  52. List<ChartControl> list_ChartControl = new List<ChartControl>();
  53. int gridwidth = 0;
  54. int GridPosition = 0;
  55. int chartposition = 0;
  56. int indexGraphicType = 0;
  57. string GraphicType = "柱状图";
  58. #endregion
  59. #region 多数据源
  60. /// <summary>
  61. /// 绑定datagridview数据
  62. /// </summary>
  63. public void BindDataGridView(string path, int num, string filename)
  64. {
  65. List<int> FLID = new List<int>() { 0, 1, 2, 4, 6, 7, 8, 9 };
  66. 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() };
  67. DataTable dt;
  68. OTSGridView gridView = new OTSGridView();
  69. OTSIncAReportApp.DataOperation.DataAccess.ParticleData particledata = new OTSIncAReportApp.DataOperation.DataAccess.ParticleData(path);
  70. string str1 = table["str1"].ToString();
  71. string str2 = table["str2"].ToString();
  72. string str3 = table["str3"].ToString();
  73. string str4 = table["str4"].ToString();
  74. string str5 = table["str5"].ToString();
  75. string str6 = table["str6"].ToString();
  76. string str7 = table["str7"].ToString();
  77. string str8 = table["str8"].ToString();
  78. string str9 = table["str9"].ToString();
  79. string str10 = table["str10"].ToString();
  80. string str11 = table["str11"].ToString();
  81. string str13 = table["str13"].ToString();
  82. //创建Grid的列序号
  83. gridView.Columns.Add("rowid", str1);
  84. //创建Grid的列颗粒名
  85. gridView.Columns.Add("TypeName", str8);
  86. //创建Grid的列代表色
  87. gridView.Columns.Add("TypeColor", str9);
  88. //创建Grid的列颗粒数
  89. gridView.Columns.Add("con", str10);
  90. //创建Grid的列颗粒数
  91. //gridView.Columns.Add("SmallParticle", str11);
  92. //创建Grid的列面积占比
  93. gridView.Columns.Add("AreaRadio", str13);
  94. string con = m_ReportApp.m_conditionChoose.m_conditionData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
  95. string po = "";
  96. switch (con)
  97. {
  98. case "DMAX":
  99. po = "DMAX";
  100. //创建Grid的列平均直径
  101. gridView.Columns.Add("av", str4);
  102. //创建Grid的列最大直径
  103. gridView.Columns.Add("max", str7);
  104. break;
  105. case "DMIN":
  106. po = "DMIN";
  107. //创建Grid的列平均直径
  108. gridView.Columns.Add("av", str4);
  109. //创建Grid的列最大直径
  110. gridView.Columns.Add("max", str7);
  111. break;
  112. case "ECD":
  113. po = "Area";
  114. //创建Grid的列平均直径
  115. gridView.Columns.Add("av", str3);
  116. //创建Grid的列最大直径
  117. gridView.Columns.Add("max", str6);
  118. break;
  119. case "FERET":
  120. po = "DFERET";
  121. //创建Grid的列平均直径
  122. gridView.Columns.Add("av", str4);
  123. //创建Grid的列最大直径
  124. gridView.Columns.Add("max", str7);
  125. break;
  126. }
  127. double totalArea = 0;
  128. int sel = m_ReportApp.m_conditionChoose.m_conditionData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
  129. gridView.MergeColumnNames.Add(filename);
  130. gridView.AddSpanHeader(1, gridView.Columns.Count - 1, filename);
  131. FieldData fielddata = new FieldData(path);
  132. double scanFieldSize = result.GetScanFieldSizeX();
  133. double wide = result.GetImageWidth();
  134. double high = result.GetImageHeight();
  135. double pixelSize = scanFieldSize / wide;
  136. int filedCount = fielddata.GetFiledCount();
  137. totalArea = high * pixelSize*wide* pixelSize * filedCount;
  138. dt = particledata.GetParticleListByIncA(po);
  139. for (int i = 0; i < dt.Rows.Count; i++)
  140. {
  141. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100)
  142. {
  143. continue;
  144. }
  145. int add_rowindex = gridView.Rows.Add();
  146. gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;
  147. for (int k = 1; k < gridView.ColumnCount; k++)
  148. {
  149. if (gridView.Columns[k].Name == "TypeColor" && dt.Rows[i]["TypeColor"].ToString() != "")
  150. {
  151. string color = dt.Rows[i]["TypeColor"].ToString();
  152. if (!color.Contains("#"))
  153. {
  154. color = "#" + dt.Rows[i]["TypeColor"].ToString();
  155. }
  156. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = DrawFunction.colorHx16toRGB(color);
  157. }
  158. else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max")
  159. {
  160. if (con == "ECD")
  161. {
  162. double Area = Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]);
  163. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Math.Sqrt(Area / Math.PI)* 2,2);
  164. }
  165. else
  166. {
  167. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round( Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name])* 2,2);
  168. }
  169. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  170. }
  171. else if (gridView.Columns[k].Name.ToLower() == "arearadio")
  172. {
  173. if (totalArea == 0)
  174. {
  175. gridView.Rows[add_rowindex].Cells[k].Value = 0;
  176. }
  177. else
  178. {
  179. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["Area"]) * 100 / totalArea, 3);
  180. }
  181. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  182. }
  183. else
  184. {
  185. gridView.Rows[add_rowindex].Cells[k].Value = dt.Rows[i][gridView.Columns[k].Name];
  186. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  187. }
  188. }
  189. }
  190. for (int i = 0; i < dt.Rows.Count; i++)
  191. {
  192. if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100)
  193. {
  194. continue;
  195. }
  196. int add_rowindex = gridView.Rows.Add();
  197. int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
  198. if (index == -1)
  199. {
  200. index = 7;
  201. }
  202. string name = NameList[index];
  203. gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;
  204. for (int k = 1; k < gridView.ColumnCount; k++)
  205. {
  206. if (gridView.Columns[k].Name == "TypeColor" && dt.Rows[i]["TypeColor"].ToString() != "")
  207. {
  208. string color = "#000000";
  209. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = DrawFunction.colorHx16toRGB(color);
  210. }
  211. else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max")
  212. {
  213. if (con == "ECD")
  214. {
  215. double Area = Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]);
  216. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Math.Sqrt(Area / Math.PI) * 2, 2);
  217. }
  218. else
  219. {
  220. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]) * 2, 2);
  221. }
  222. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  223. }
  224. else if (gridView.Columns[k].Name.ToLower() == "arearadio")
  225. {
  226. if (totalArea == 0)
  227. {
  228. gridView.Rows[add_rowindex].Cells[k].Value = 0;
  229. }
  230. else
  231. {
  232. gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["Area"]) * 100 / totalArea, 5);
  233. }
  234. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  235. }
  236. else
  237. {
  238. gridView.Rows[add_rowindex].Cells[k].Value = dt.Rows[i][gridView.Columns[k].Name];
  239. gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
  240. }
  241. }
  242. }
  243. gridView.Name = "gridView" + num.ToString();
  244. int a1 = gridView.Rows.Add();
  245. gridView.Rows[a1].Cells[1].Value = "Sum";
  246. for (int j = 0; j < gridView.Rows.Count - 2; j++)
  247. {
  248. if (gridView.Rows[a1].Cells[3].Value == null)
  249. gridView.Rows[a1].Cells[3].Value = 0;
  250. gridView.Rows[a1].Cells[3].Value = Convert.ToInt32(gridView.Rows[a1].Cells[3].Value) + Convert.ToInt32(gridView.Rows[j].Cells[3].Value);
  251. if(gridView.Rows[a1].Cells[4].Value == null)
  252. gridView.Rows[a1].Cells[4].Value = 0;
  253. gridView.Rows[a1].Cells[4].Value = Convert.ToDouble(gridView.Rows[a1].Cells[4].Value) + Convert.ToDouble(gridView.Rows[j].Cells[4].Value);
  254. }
  255. list_table_Point.Add(SetDataGridViewStyle(gridView));
  256. panel1.Controls.Add(gridView);
  257. // Panel panel = new Panel();
  258. //panel.Size = new Size(gridwidth, 27);
  259. ////panel.Dock = DockStyle.Top;
  260. //panel.Location=new Point(0, list_gridheight.Max());
  261. // panel.BackColor = Color.WhiteSmoke;
  262. list_table_data.Add(dt);
  263. //Graphics(dt, filename, GraphicType, position);
  264. }
  265. private void Graphics(DataTable data,string filename,string comboBox1Text,int pos)
  266. {
  267. ChartControl chartControl1 = new ChartControl();
  268. chartControl1.Series.Clear();
  269. // 假设你已经有一个 ChartControl 实例,并且已经添加了一个饼图 Series
  270. Series series = new Series(filename, ViewType.Bar);
  271. for (int a = 0; a < data.Rows.Count; a++)
  272. {
  273. string name = data.Rows[a]["TypeName"].ToString();
  274. double Cunt = Convert.ToDouble(data.Rows[a]["con"]);
  275. series.Points.Add(new SeriesPoint(name, Cunt));
  276. }
  277. series.LabelsVisibility = DefaultBoolean.True;
  278. chartControl1.Series.Add(series);
  279. //图例的位置定义
  280. chartControl1.Legend.AlignmentVertical = LegendAlignmentVertical.Top;
  281. chartControl1.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.RightOutside;
  282. chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
  283. chartControl1.Legend.Direction = LegendDirection.TopToBottom;
  284. //十字准线光标
  285. chartControl1.CrosshairEnabled = DefaultBoolean.True;
  286. chartControl1.CrosshairOptions.ShowValueLine = true;
  287. chartControl1.CrosshairOptions.ShowArgumentLabels = true;
  288. DevFunctions.ChangeView2(chartControl1, comboBox1Text);
  289. chartControl1.Location = new Point(pos, list_gridheight.Max());
  290. chartControl1.Size = new Size(GridPosition, GridPosition);
  291. // 获取图表的坐标系(通常为 XYDiagram)
  292. XYDiagram diagram = chartControl1.Diagram as XYDiagram;
  293. if (diagram != null)
  294. {
  295. // 设置横坐标(X轴)名称
  296. diagram.AxisX.Title.Text = "种类";
  297. diagram.AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
  298. // 设置纵坐标(Y轴)名称
  299. diagram.AxisY.Title.Text = "数量";
  300. diagram.AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
  301. }
  302. panel1.Controls.Add(chartControl1);
  303. }
  304. /// <summary>
  305. /// 设置DataGridView样式
  306. /// </summary>
  307. private Point SetDataGridViewStyle(OTSGridView gridView)
  308. {
  309. //用户不能调整标题的高度
  310. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  311. //用户不能调整 行高
  312. gridView.AllowUserToResizeRows = false;
  313. //改变行的高度;
  314. //gridView.RowTemplate.Height = 20;
  315. //点击选择整行
  316. gridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  317. //居中显示
  318. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  319. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  320. gridView.DefaultCellStyle = dataGridViewCellStyle1;
  321. gridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  322. //再次重覆禁用拖动表头高度,居然有效果了
  323. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  324. //设置grid可以复制
  325. gridView.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  326. //设置每列的宽度
  327. gridView.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  328. gridView.Columns[1].Width = 200;
  329. //设置序号列不排序
  330. gridView.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  331. //设置序号列不可以设置宽度
  332. gridView.Columns[0].Resizable = DataGridViewTriState.False;
  333. gridView.AllowUserToAddRows = false;
  334. gridView.AllowUserToDeleteRows = false;
  335. gridView.AllowUserToResizeRows = false;
  336. gridView.BackgroundColor = System.Drawing.SystemColors.ButtonHighlight;
  337. gridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
  338. gridView.ContextMenuStrip = this.contextMenuStrip1;
  339. gridView.BorderStyle = 0;
  340. //gridView.Dock = System.Windows.Forms.DockStyle.Fill;
  341. //gridView.Location = new System.Drawing.Point(0, 0);
  342. //gridView.Location = new System.Drawing.Point(0, gridheight);
  343. int gridheight = 0;
  344. //chartposition = gridwidth;
  345. int outpos = gridwidth;
  346. gridView.Location = new System.Drawing.Point(gridwidth, 0);
  347. gridView.Margin = new System.Windows.Forms.Padding(2);
  348. gridView.MergeColumnHeaderBackColor = System.Drawing.SystemColors.ButtonHighlight;
  349. //gridView.Name = "Gview_gz";
  350. gridView.ReadOnly = true;
  351. gridView.RowHeadersVisible = false;
  352. gridView.RowHeadersWidth = 40;
  353. gridView.RowTemplate.Height = 30;
  354. //gridView.Size = new System.Drawing.Size(667, 520);
  355. gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30);
  356. //gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30 + 30);
  357. //gridheight = gridheight + gridView.RowCount * 30 + 80;
  358. gridheight = gridheight + gridView.RowCount * 30 + 5;
  359. gridwidth = gridwidth + gridView.ColumnCount * 100 + 60;
  360. chartposition = chartposition + gridView.ColumnCount * 100;
  361. GridPosition = gridView.ColumnCount * 100 +40;
  362. list_gridheight.Add(gridheight);
  363. gridView.TabIndex = 0;
  364. gridView.SortCompare += new System.Windows.Forms.DataGridViewSortCompareEventHandler(this.Gview_gz_SortCompare);
  365. gridView.Sorted += new System.EventHandler(this.Gview_gz_Sorted);
  366. //先设置一下头的高度,否则会太矮不好看
  367. gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
  368. gridView.ColumnHeadersHeight = 40;
  369. list_table_size.Add( new Point(gridView.ColumnCount * 100+40, gridView.RowCount * 30));
  370. return new Point(outpos, gridheight);
  371. }
  372. #endregion
  373. #region 窗体加载及初始化
  374. /// <summary>
  375. /// 成份分布表,构造函数
  376. /// </summary>
  377. /// <param name="in_sec">传入,委托类对象</param>
  378. /// <param name="in_Cotsreportprojfilemgrclr">传入,项目管理类对象</param>
  379. public CompositionDistributionGrid(OTSIncAReportApp.frmReportApp ReportApp)
  380. {
  381. m_ReportApp = ReportApp;
  382. result = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()];
  383. source = m_ReportApp.m_conditionChoose.m_conditionData;
  384. m_condition= ReportApp.m_conditionChoose;
  385. InitializeComponent();
  386. //国际化
  387. lan = new Language(this);
  388. table = lan.GetNameTable(this.Name);
  389. }
  390. public void SetGraphicType(ReportCondition sourceGridData)
  391. {
  392. string stdId_TYPE = "";
  393. int stdIdIndex = 0;
  394. //find the stdId condition
  395. var STDIdItm = sourceGridData.ConditionItemList.Find(s => s.iItemId == OTS_REPORT_PROP_GRID_ITEMS.GRAPHIC_TYPE);
  396. if (STDIdItm != null)
  397. {
  398. stdId_TYPE = STDIdItm.itemDisplayVal.ToString();
  399. stdIdIndex = STDIdItm.comboDownList.IndexOf(stdId_TYPE);
  400. }
  401. indexGraphicType = stdIdIndex;
  402. GraphicType = stdId_TYPE;
  403. int high = 0;
  404. for (int i = 0; i < list_table_Point.Count; i++)
  405. {
  406. if (high < list_table_Point[i].Y)
  407. {
  408. high = list_table_Point[i].Y;
  409. }
  410. }
  411. for (int i = 0; i < list_table_data.Count; i++)
  412. {
  413. DataNumber = i;
  414. Graphics(list_table_data[i], list_fileName[i], stdId_TYPE, list_table_size[i], list_table_Point[i], high);
  415. }
  416. }
  417. /// <summary>
  418. /// chart图创建
  419. /// </summary>
  420. /// <param name="dt"></param>
  421. /// <param name="stdId"></param>
  422. private void Graphics(DataTable data, string filename, string comboBox1Text, Point a_size, Point a_Location, int location_hig)
  423. {
  424. ChartControl chartControl1 = new ChartControl();
  425. chartControl1.Series.Clear();
  426. // 假设你已经有一个 ChartControl 实例,并且已经添加了一个饼图 Series
  427. Series series = new Series(filename, ViewType.Bar);
  428. for (int a = 0; a < data.Rows.Count; a++)
  429. {
  430. string name = data.Rows[a]["TypeName"].ToString();
  431. double Cunt = Convert.ToDouble(data.Rows[a]["con"]);
  432. series.Points.Add(new SeriesPoint(name, Cunt));
  433. }
  434. series.LabelsVisibility = DefaultBoolean.True;
  435. chartControl1.Series.Add(series);
  436. //图例的位置定义
  437. chartControl1.Legend.AlignmentVertical = LegendAlignmentVertical.Top;
  438. chartControl1.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.RightOutside;
  439. chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
  440. chartControl1.Legend.Direction = LegendDirection.TopToBottom;
  441. //十字准线光标
  442. chartControl1.CrosshairEnabled = DefaultBoolean.True;
  443. chartControl1.CrosshairOptions.ShowValueLine = true;
  444. chartControl1.CrosshairOptions.ShowArgumentLabels = true;
  445. DevFunctions.ChangeView2(chartControl1, comboBox1Text);
  446. chartControl1.Location = new Point(a_Location.X, location_hig+20);
  447. chartControl1.Size = new Size(a_size.X, a_size.Y);
  448. // 获取图表的坐标系(通常为 XYDiagram)
  449. XYDiagram diagram = chartControl1.Diagram as XYDiagram;
  450. if (diagram != null)
  451. {
  452. // 设置横坐标(X轴)名称
  453. diagram.AxisX.Title.Text = "种类";
  454. diagram.AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
  455. // 设置纵坐标(Y轴)名称
  456. diagram.AxisY.Title.Text = "数量";
  457. diagram.AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
  458. }
  459. ComboBox comboBox = new ComboBox();
  460. list_ChartControl.Add(chartControl1);
  461. list_ComboBox.Add(comboBox);
  462. list_ComboBox[list_ComboBox.Count - 1].Items.Add("柱状图");
  463. list_ComboBox[list_ComboBox.Count - 1].Items.Add("折线图");
  464. list_ComboBox[list_ComboBox.Count - 1].Items.Add("饼图");
  465. list_ComboBox[list_ComboBox.Count - 1].Items.Add("圆环图");
  466. list_ComboBox[list_ComboBox.Count - 1].Items.Add("气泡图");
  467. list_ComboBox[list_ComboBox.Count - 1].Items.Add("簇状条形图");
  468. list_ComboBox[list_ComboBox.Count - 1].Items.Add("堆积条形图");
  469. list_ComboBox[list_ComboBox.Count - 1].Items.Add("瀑布图");
  470. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D柱状图");
  471. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D圆环图");
  472. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D饼图");
  473. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D折线图");
  474. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D百分比堆积条形图");
  475. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D漏斗图");
  476. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3DManhattan 条形图");
  477. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D堆积条形图");
  478. list_ComboBox[list_ComboBox.Count - 1].Items.Add("3D阶梯线图");
  479. list_ComboBox[list_ComboBox.Count - 1].Name = Convert.ToString(list_ComboBox.Count - 1);
  480. list_ComboBox[list_ComboBox.Count - 1].SelectedIndex = 0;
  481. list_ComboBox[list_ComboBox.Count - 1].Location = new Point(a_Location.X+chartControl1.Size.Width-100, location_hig);
  482. list_ComboBox[list_ComboBox.Count - 1].Size = new Size(100, 5);
  483. list_ComboBox[list_ComboBox.Count - 1].SelectedIndexChanged += ComboBox_SelectedIndexChanged;
  484. panel1.Controls.Add(chartControl1);
  485. panel1.Controls.Add(list_ComboBox[list_ComboBox.Count - 1]);
  486. }
  487. private void ComboBox_SelectedIndexChanged(object sender, EventArgs e)
  488. {
  489. ComboBox comboBox = sender as ComboBox;
  490. if (comboBox != null)
  491. {
  492. DevFunctions.ChangeView2(list_ChartControl[Convert.ToInt32(comboBox.Name)], comboBox.Text);
  493. }
  494. //DevFunctions.ChangeView2(list_ChartControl[DataNumber], comboBox.Text);
  495. }
  496. private void CompositionDistributionGrid_Load(object sender, EventArgs e)
  497. {
  498. list_table_data.Clear();
  499. list_table_size.Clear();
  500. list_table_Point.Clear();
  501. list_fileName.Clear();
  502. string sou = m_condition.m_CurrentConditions[OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE].itemDisplayVal.ToString();
  503. if (sou.Contains("+"))
  504. {
  505. for (int i = 0; i < sou.Split('+').Length; i++)
  506. {
  507. ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
  508. if (resultFile != null)
  509. {
  510. BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName);
  511. list_fileName.Add(resultFile.anotherFileName);
  512. }
  513. }
  514. }
  515. else
  516. {
  517. for (int i = 0; i < m_ReportApp.m_rstDataMgr.ResultFilesList.Count; i++)
  518. {
  519. if (sou == m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName.ToString())
  520. {
  521. BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[i].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
  522. list_fileName.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
  523. }
  524. }
  525. }
  526. }
  527. #endregion
  528. #region 相关事件
  529. private void ToolStripMenuItem1_Click(object sender, EventArgs e)
  530. {
  531. OTSGridView otv = (OTSGridView)((ContextMenuStrip)(sender as ToolStripMenuItem).Owner).SourceControl;
  532. //复制整个表
  533. CopyAll(otv);
  534. }
  535. private void ToolStripMenuItem2_Click(object sender, EventArgs e)
  536. {
  537. OTSGridView otv = (OTSGridView)((ContextMenuStrip)(sender as ToolStripMenuItem).Owner).SourceControl;
  538. CopySelected(otv);
  539. }
  540. /// <summary>
  541. /// 复制选择区域
  542. /// </summary>
  543. public void CopySelected(OTSGridView in_ogv)
  544. {
  545. Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent());
  546. }
  547. /// <summary>
  548. /// 复制选择区域
  549. /// </summary>
  550. public void CopySelected()
  551. {
  552. DataGridView dgv = (DataGridView)panel1.Controls["Gview_gz"];
  553. //复制选择区域
  554. object oo = dgv.GetClipboardContent();
  555. Clipboard.SetDataObject(dgv.GetClipboardContent());
  556. }
  557. /// <summary>
  558. /// 复制所有
  559. /// </summary>
  560. public void CopyAll(OTSGridView in_ogv)
  561. {
  562. in_ogv.SelectAll();
  563. Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent());
  564. }
  565. /// <summary>
  566. /// 复制所有
  567. /// </summary>
  568. public void CopyAll()
  569. {
  570. DataGridView dgv = (DataGridView)panel1.Controls["Gview_gz"];
  571. dgv.SelectAll();
  572. Clipboard.SetDataObject(((OTSGridView)dgv).GetClipboardContent());
  573. }
  574. private void ToolStripMenuItem3_Click(object sender, EventArgs e)
  575. {
  576. foreach (var item in panel1.Controls)
  577. {
  578. if (item.GetType().ToString() == "OTSGridView")
  579. {
  580. panel1.Controls.Remove((OTSGridView)item);
  581. }
  582. }
  583. list_table_data.Clear();
  584. list_table_size.Clear();
  585. list_table_Point.Clear();
  586. list_fileName.Clear();
  587. string sou = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
  588. if (sou.Contains("+"))
  589. {
  590. for (int i = 0; i < sou.Split('+').Length; i++)
  591. {
  592. ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
  593. if (resultFile != null)
  594. {
  595. BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName);
  596. list_fileName.Add(resultFile.anotherFileName);
  597. }
  598. }
  599. }
  600. else
  601. {
  602. BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].anotherFileName);
  603. list_fileName.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].anotherFileName);
  604. }
  605. }
  606. private void Gview_gz_SortCompare(object sender, DataGridViewSortCompareEventArgs e)
  607. {
  608. //排序中
  609. if (((OTSGridView)sender).Rows[e.RowIndex1].Tag != null && ((OTSGridView)sender).Rows[e.RowIndex1].Tag.ToString() == "统计行")
  610. {
  611. //ROW1>ROW2
  612. e.SortResult = 1;
  613. if (((OTSGridView)sender).SortOrder == SortOrder.Descending)
  614. e.SortResult = -1;
  615. e.Handled = true;
  616. return;
  617. }
  618. if (((OTSGridView)sender).Rows[e.RowIndex2].Tag != null && ((OTSGridView)sender).Rows[e.RowIndex2].Tag.ToString() == "统计行")
  619. {
  620. //ROW1<ROW2
  621. e.SortResult = -1;
  622. if (((OTSGridView)sender).SortOrder == SortOrder.Descending)
  623. e.SortResult = 1;
  624. e.Handled = true;
  625. return;
  626. }
  627. }
  628. private void Gview_gz_Sorted(object sender, EventArgs e)
  629. {
  630. //排序完成,重新设置序号
  631. for (int i = 0; i < ((OTSGridView)sender).Rows.Count; i++)
  632. {
  633. if (((OTSGridView)sender).Rows[i].Tag != null && ((OTSGridView)sender).Rows[i].Tag.ToString() == "统计行")
  634. { }
  635. else
  636. {
  637. ((OTSGridView)sender).Rows[i].Cells[0].Value = i.ToString();
  638. }
  639. }
  640. }
  641. #endregion
  642. #region 获取向导出模块提供的DataTable和GridView对象
  643. /// <summary>
  644. /// 获取到该模块输出后形成的DataTable,和GridView
  645. /// </summary>
  646. /// <param name="out_dt"></param>
  647. /// <param name="out_dg"></param>
  648. public void GetDataTableAndGridView(out DataTable out_dt, out DataGridView out_dg)
  649. {
  650. out_dt = m_dt;
  651. out_dg = null;
  652. foreach (var item in panel1.Controls)
  653. {
  654. if (item.GetType().ToString() == "OTSGridView")
  655. {
  656. out_dg = ((OTSGridView)item);
  657. }
  658. }
  659. }
  660. #endregion
  661. }
  662. }