CompositionDistributionGrid.cs 25 KB

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