using OTSIncAReportApp.OTSSampleReportInfo; using OTSIncAReportApp.SysMgrTools; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Drawing; using System.Windows.Forms; namespace OTSIncAReportGrids { /// /// 元素含量表 /// public partial class ElementContentGrid : UserControl { #region 设置变量 //设置模拟数据表 public DataTable m_dt = new DataTable(); //国际化 Language lan; Hashtable table; OTSIncAReportApp.frmReportApp m_ReportApp; int gridwidth = 0; #endregion #region 自定义方法 /// /// 绑定datagridview数据 /// public void BindDataGridView(string path, int num, string filename) { OTSIncAReportApp.DataOperation.DataAccess.ParticleData particledata = new OTSIncAReportApp.DataOperation.DataAccess.ParticleData(path); OTSGridView gridView = new OTSGridView(); List colid = new List() { "rowid", "ename", "percent" }; List colname = new List() { table["str1"].ToString(), table["str8"].ToString(), table["str9"].ToString() }; //创建Grid的列 for (int i = 0; i < colid.Count; i++) { gridView.Columns.Add(colid[i], colname[i]); } //设置grid默认值的样式,防止图像为空时有红x for (int i = 0; i < gridView.Columns.Count; i++) { gridView.Columns[i].DefaultCellStyle.NullValue = null; } int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE); string filedAndParticle = ""; if (sel == 1) { List selectParticles = m_ReportApp.GetSelectedParticles(); foreach (var item in selectParticles) { filedAndParticle = filedAndParticle + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString()); } if (filedAndParticle != "") { filedAndParticle = filedAndParticle + ","; } if (filedAndParticle != "") { DataTable dt = particledata.GetElementForArea(filedAndParticle); double totalArea = 0; foreach (DataRow item in dt.Rows) { totalArea += Convert.ToDouble(item["earea"]); } for (int i = 0; i < dt.Rows.Count; i++) { int add_rowindex = gridView.Rows.Add(); gridView.Rows[i].Cells[0].Value = (i + 1).ToString(); gridView.Rows[i].Cells[1].Value = dt.Rows[i]["name"]; double d = Convert.ToDouble(dt.Rows[i]["earea"]) / totalArea; gridView.Rows[i].Cells[2].Value = Math.Round(d, 6) * 100; gridView.Rows[i].Cells[1].Style.BackColor = Color.Azure; gridView.Rows[i].Cells[2].Style.BackColor = Color.Azure; } } else { } } else { Hashtable hashtable = new Hashtable(); DataTable dt = particledata.GetElementForArea(filedAndParticle); double totalArea = 0; foreach (DataRow item in dt.Rows) { totalArea += Convert.ToDouble(item["earea"]); hashtable.Add(item["name"].ToString(), Convert.ToDouble(item["earea"])); } DataTable dt1 = particledata.GetSmallElementForArea(); foreach (DataRow item in dt1.Rows) { totalArea += Convert.ToDouble(item["earea"]); if (hashtable.Contains(item["name"].ToString())) { double temp = Convert.ToDouble(item["earea"]) + Convert.ToDouble(hashtable[item["name"].ToString()]); hashtable[item["name"].ToString()] = temp; } else { hashtable.Add(item["name"].ToString(), Convert.ToDouble(item["earea"])); } } foreach (DictionaryEntry de in hashtable) //ht为一个Hashtable实例 { int add_rowindex = gridView.Rows.Add(); gridView.Rows[add_rowindex].Cells[0].Value = (add_rowindex + 1).ToString(); gridView.Rows[add_rowindex].Cells[1].Value = de.Key; double d = Convert.ToDouble(de.Value) / totalArea; gridView.Rows[add_rowindex].Cells[2].Value = Math.Round(d, 6) * 100; gridView.Rows[add_rowindex].Cells[1].Style.BackColor = Color.Azure; gridView.Rows[add_rowindex].Cells[2].Style.BackColor = Color.Azure; } } gridView.Name = "gridView" + num.ToString(); SetDataGridViewStyle(gridView); panel1.Controls.Add(gridView); gridwidth = gridwidth + 1; } /// /// 设置DataGridView样式 /// private void SetDataGridViewStyle(OTSGridView gridView) { gridView.AllowUserToAddRows = false; gridView.AllowUserToDeleteRows = false; gridView.AllowUserToResizeRows = false; gridView.BackgroundColor = System.Drawing.SystemColors.ButtonHighlight; gridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; gridView.ContextMenuStrip = this.contextMenuStrip1; gridView.Dock = System.Windows.Forms.DockStyle.Fill; gridView.Location = new System.Drawing.Point(0, 0); gridView.Margin = new System.Windows.Forms.Padding(2); gridView.MergeColumnHeaderBackColor = System.Drawing.SystemColors.ButtonHighlight; gridView.Name = "Gview_gz"; gridView.ReadOnly = true; gridView.RowHeadersVisible = false; gridView.RowHeadersWidth = 40; gridView.RowTemplate.Height = 30; gridView.Size = new System.Drawing.Size(667, 520); gridView.TabIndex = 0; gridView.SortCompare += new System.Windows.Forms.DataGridViewSortCompareEventHandler(this.Gview_gz_SortCompare); gridView.Sorted += new System.EventHandler(this.Gview_gz_Sorted); //用户不能调整标题的高度 gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //用户不能调整 行高 gridView.AllowUserToResizeRows = false; //改变行的高度; //gridView.RowTemplate.Height = 20; //点击选择整行 gridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //居中显示 System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; gridView.DefaultCellStyle = dataGridViewCellStyle1; gridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //再次重覆禁用拖动表头高度,居然有效果了 gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //设置grid可以复制 gridView.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText; //设置每列的宽度 gridView.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑 gridView.Columns[1].Width = 200; //设置序号列不排序 gridView.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable; //设置序号列不可以设置宽度 gridView.Columns[0].Resizable = DataGridViewTriState.False; } #endregion #region 窗体初始化及加载 /// /// 元素含量表,构造函数 /// /// 传入,委托类对象 /// 传入,项目管理类对象 public ElementContentGrid(OTSIncAReportApp.frmReportApp ReportApp) { m_ReportApp = ReportApp; InitializeComponent(); //国际化 lan = new Language(this); table = lan.GetNameTable(this.Name); } private void ElementContentGrid_Load(object sender, EventArgs e) { //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); string sou = m_ReportApp.m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString(); if (sou.Contains("+")) { for (int i = 0; i < sou.Split('+').Length; i++) { OTSIncAReportApp.DataOperation.Model.ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.FileName == sou.Split('+')[i]); if (resultFile != null) { BindDataGridView(resultFile.FilePath, i, resultFile.FileName); } } } else { BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()].FileName); } } #endregion #region 相关事件 private void ToolStripMenuItem1_Click(object sender, EventArgs e) { //复制整个表 CopyAll(); } private void ToolStripMenuItem2_Click(object sender, EventArgs e) { //复制选择区域 CopySelected(); } /// /// 复制选择区域 /// public void CopySelected() { foreach (var item in panel1.Controls) { if (item.GetType().ToString() == "OTSGridView") { //复制选择区域 object oo = ((OTSGridView)item).GetClipboardContent(); Clipboard.SetDataObject(((OTSGridView)item).GetClipboardContent()); } } } /// /// 复制所有 /// public void CopyAll() { foreach (var item in panel1.Controls) { if (item.GetType().ToString() == "OTSGridView") { ((OTSGridView)item).SelectAll(); Clipboard.SetDataObject(((OTSGridView)item).GetClipboardContent()); } } } //恢复至初始状态 private void ToolStripMenuItem3_Click(object sender, EventArgs e) { foreach (var item in panel1.Controls) { if (item.GetType().ToString() == "OTSGridView") { panel1.Controls.Remove((OTSGridView)item); } } gridwidth = 0; //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); string sou = m_ReportApp.m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString(); if (sou.Contains("+")) { for (int i = 0; i < sou.Split('+').Length; i++) { OTSIncAReportApp.DataOperation.Model.ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.FileName == sou.Split('+')[i]); if (resultFile != null) { BindDataGridView(resultFile.FilePath, i, resultFile.FileName); } } } else { BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()].FileName); } } private void Gview_gz_SortCompare(object sender, DataGridViewSortCompareEventArgs e) { //排序中 if (((OTSGridView)sender).Rows[e.RowIndex1].Tag != null && ((OTSGridView)sender).Rows[e.RowIndex1].Tag.ToString() == "统计行") { //ROW1>ROW2 e.SortResult = 1; if (((OTSGridView)sender).SortOrder == SortOrder.Descending) e.SortResult = -1; e.Handled = true; return; } if (((OTSGridView)sender).Rows[e.RowIndex2].Tag != null && ((OTSGridView)sender).Rows[e.RowIndex2].Tag.ToString() == "统计行") { //ROW1 /// 获取到该模块输出后形成的DataTable,和GridView /// /// /// public void GetDataTableAndGridView(out DataTable out_dt, out DataGridView out_dg) { out_dt = m_dt; out_dg = null; foreach (var item in panel1.Controls) { if (item.GetType().ToString() == "OTSGridView") { out_dg = ((OTSGridView)item); } } } #endregion } }