using OTSIncAReportApp.SysMgrTools; using OTSIncAReportGraph.Class; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Drawing; using System.Windows.Forms; namespace OTSIncAReportGrids { /// /// 成分分布表 颗粒成份分布表 /// public partial class CompositionDistributionGrid : UserControl { #region 设置变量 //设置模拟数据表 public DataTable m_dt = new DataTable(); //国际化 Language lan; Hashtable table; //测量结果 OTSIncAReportApp.DataOperation.Model.ResultFile result = null; OTSIncAReportApp.OTSSampleReportInfo.OTSSampleMeaInfo source; OTSIncAReportApp.frmReportApp m_ReportApp; #endregion #region 多数据源 /// /// 绑定datagridview数据 /// public void BindDataGridView(string path, int num, string filename) { OTSGridView gridView = new OTSGridView(); OTSIncAReportApp.DataOperation.DataAccess.ParticleData particledata = new OTSIncAReportApp.DataOperation.DataAccess.ParticleData(path); string str1 = table["str1"].ToString(); string str2 = table["str2"].ToString(); string str3 = table["str3"].ToString(); string str4 = table["str4"].ToString(); string str5 = table["str5"].ToString(); string str6 = table["str6"].ToString(); string str7 = table["str7"].ToString(); string str8 = table["str8"].ToString(); string str9 = table["str9"].ToString(); string str10 = table["str10"].ToString(); string str11 = table["str11"].ToString(); //创建Grid的列序号 gridView.Columns.Add("rowid", str1); //创建Grid的列颗粒名 gridView.Columns.Add("TypeName", str8); //创建Grid的列代表色 gridView.Columns.Add("TypeColor", str9); //创建Grid的列颗粒数 gridView.Columns.Add("con", str10); //创建Grid的列颗粒数 //gridView.Columns.Add("SmallParticle", str11); string con = m_ReportApp.SourceGridData.SampleDataList[m_ReportApp.m_DataMgrFun.GetSampleIndexByPropItemName(m_ReportApp.SourceGridData.SampleDataList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE)].itemVal.ToString(); string po = ""; switch (con) { case "DMAX": po = "DMAX"; //创建Grid的列平均直径 gridView.Columns.Add("av", str4); //创建Grid的列最大直径 gridView.Columns.Add("max", str7); break; case "DMIN": po = "DMIN"; //创建Grid的列平均直径 gridView.Columns.Add("av", str4); //创建Grid的列最大直径 gridView.Columns.Add("max", str7); break; case "Area": po = "Area"; //创建Grid的列平均直径 gridView.Columns.Add("av", str3); //创建Grid的列最大直径 gridView.Columns.Add("max", str6); break; case "FERET": po = "DFERET"; //创建Grid的列平均直径 gridView.Columns.Add("av", str4); //创建Grid的列最大直径 gridView.Columns.Add("max", str7); break; } int idx = m_ReportApp.m_DataMgrFun.GetSampleIndexByPropItemName(m_ReportApp.SourceGridData.SampleDataList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE); int sel = m_ReportApp.SourceGridData.SampleDataList[idx].comboDownList.IndexOf(m_ReportApp.SourceGridData.SampleDataList[idx].itemVal.ToString()); string filedAndParticl = ""; if (sel == 1) { List selectParticles = m_ReportApp.SelectedParticles; foreach (var item in selectParticles) { filedAndParticl = filedAndParticl + "," + (item.FieldId.ToString() + "-" + item.ParticleId.ToString()); } if (filedAndParticl != "") { filedAndParticl = filedAndParticl + ","; } } DataTable dt = particledata.GetParticleListByIncA(po, filedAndParticl); List FLID = new List() { 0, 1, 2, 4, 6, 7, 8, 9 }; List NameList = new List() { table["partcletype0"].ToString(), table["partcletype1"].ToString(), table["partcletype2"].ToString(), table["partcletype4"].ToString(), table["partcletype6"].ToString(), table["partcletype7"].ToString(), table["partcletype8"].ToString(), table["partcletype9"].ToString() }; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["TypeId"]) < 100) { continue; } int add_rowindex = gridView.Rows.Add(); gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1; for (int k = 1; k < gridView.ColumnCount; k++) { if (gridView.Columns[k].Name == "TypeColor" && dt.Rows[i]["TypeColor"].ToString() != "") { string color = dt.Rows[i]["TypeColor"].ToString(); if (!color.Contains("#")) { color = "#" + dt.Rows[i]["TypeColor"].ToString(); } gridView.Rows[add_rowindex].Cells[k].Style.BackColor = DrawFuncation.colorHx16toRGB(color); } else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max") { gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]), 2); gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure; } else { gridView.Rows[add_rowindex].Cells[k].Value = dt.Rows[i][gridView.Columns[k].Name]; gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure; } } } for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToInt32(dt.Rows[i]["TypeId"]) > 100) { continue; } int add_rowindex = gridView.Rows.Add(); int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"])); if (index == -1) { index = 7; } string name = NameList[index]; gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1; for (int k = 1; k < gridView.ColumnCount; k++) { if (gridView.Columns[k].Name == "TypeColor" && dt.Rows[i]["TypeColor"].ToString() != "") { string color = "#000000"; gridView.Rows[add_rowindex].Cells[k].Style.BackColor = DrawFuncation.colorHx16toRGB(color); } else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max") { gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]), 2); gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure; } else if (gridView.Columns[k].Name == "TypeName") { gridView.Rows[add_rowindex].Cells[k].Value = name; gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure; } else { gridView.Rows[add_rowindex].Cells[k].Value = dt.Rows[i][gridView.Columns[k].Name]; gridView.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure; } } } SetDataGridViewStyle(gridView); panel1.Controls.Add(gridView); } /// /// 设置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 CompositionDistributionGrid(OTSIncAReportApp.frmReportApp ReportApp) { m_ReportApp = ReportApp; result = m_ReportApp.resultFilesList[m_ReportApp.WorkingResult]; source = m_ReportApp.SourceGridData; InitializeComponent(); //国际化 lan = new Language(this); table = lan.GetNameTable(this.Name); } private void CompositionDistributionGrid_Load(object sender, EventArgs e) { int idx = m_ReportApp.m_DataMgrFun.GetSampleIndexByPropItemName(m_ReportApp.SourceGridData.SampleDataList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); string sou = m_ReportApp.SourceGridData.SampleDataList[idx].itemVal.ToString(); if (sou.Contains("+")) { for (int i = 0; i < sou.Split('+').Length; i++) { OTSIncAReportApp.DataOperation.Model.ResultFile resultFile = m_ReportApp.resultFilesList.Find(s => s.FileName == sou.Split('+')[i]); if (resultFile != null) { BindDataGridView(resultFile.FilePath, i, resultFile.FileName); } } } else { BindDataGridView(m_ReportApp.resultFilesList[m_ReportApp.WorkingResult].FilePath, 0, m_ReportApp.resultFilesList[m_ReportApp.WorkingResult].FileName); ////设置grid风格 //SetDataGridViewStyle(); } } #endregion #region 相关事件 private void ToolStripMenuItem1_Click(object sender, EventArgs e) { OTSGridView otv = (OTSGridView)((ContextMenuStrip)((sender as ToolStripMenuItem).Owner)).SourceControl; //复制整个表 CopyAll(otv); } private void ToolStripMenuItem2_Click(object sender, EventArgs e) { OTSGridView otv = (OTSGridView)((ContextMenuStrip)((sender as ToolStripMenuItem).Owner)).SourceControl; CopySelected(otv); } /// /// 复制选择区域 /// public void CopySelected(OTSGridView in_ogv) { Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent()); } /// /// 复制选择区域 /// public void CopySelected() { DataGridView dgv = (DataGridView)panel1.Controls["Gview_gz"]; //复制选择区域 object oo = dgv.GetClipboardContent(); Clipboard.SetDataObject(dgv.GetClipboardContent()); } /// /// 复制所有 /// public void CopyAll(OTSGridView in_ogv) { in_ogv.SelectAll(); Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent()); } /// /// 复制所有 /// public void CopyAll() { DataGridView dgv = (DataGridView)panel1.Controls["Gview_gz"]; dgv.SelectAll(); Clipboard.SetDataObject(((OTSGridView)dgv).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); } } int idx = m_ReportApp.m_DataMgrFun.GetSampleIndexByPropItemName(m_ReportApp.SourceGridData.SampleDataList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); string sou = m_ReportApp.SourceGridData.SampleDataList[idx].itemVal.ToString(); if (sou.Contains("+")) { for (int i = 0; i < sou.Split('+').Length; i++) { OTSIncAReportApp.DataOperation.Model.ResultFile resultFile = m_ReportApp.resultFilesList.Find(s => s.FileName == sou.Split('+')[i]); if (resultFile != null) { BindDataGridView(resultFile.FilePath, i, resultFile.FileName); } } } else { BindDataGridView(m_ReportApp.resultFilesList[m_ReportApp.WorkingResult].FilePath, 0, m_ReportApp.resultFilesList[m_ReportApp.WorkingResult].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 } }