using OTSIncAReportApp.OTSSampleReportInfo; 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(); DataTable SelectParticlesListConvertToTable(List selectParticles) { DataTable dataTable = new DataTable(); return dataTable; } //国际化 Language lan; Hashtable table; //测量结果 OTSIncAReportApp.DataOperation.Model.ResultFile result = null; OTSIncAReportApp.OTSSampleReportInfo.ReportCondition source; OTSIncAReportApp.frmReportApp m_ReportApp; #endregion #region 多数据源 /// /// 绑定datagridview数据 /// public void BindDataGridView(string path, int num, string filename) { 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() }; DataTable dt; 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(); string str13 = table["str13"].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); //创建Grid的列面积占比 gridView.Columns.Add("AreaRadio", str13); string con = m_ReportApp.m_conditionChoose.m_SourceGridData.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).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 "CIRCLE": 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; } double totalArea = 0; //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE); //int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetPropIndexByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE); int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE); if (sel == 1) { List selectParticles = m_ReportApp.GetSelectedParticles(); Dictionary> selectNameGroup = new Dictionary>(); for(int i=0;i< selectParticles.Count;i++) { if(!selectNameGroup.ContainsKey(selectParticles[i].TypeId)) { List particles = new List(); particles.Add(selectParticles[i]); selectNameGroup.Add(selectParticles[i].TypeId, particles); } else { selectNameGroup[selectParticles[i].TypeId].Add(selectParticles[i]); } } double areaSum = 0,avg = 0,max = 0; DataTable dtUelect = new DataTable(); dtUelect.Columns.Add("typeid"); dtUelect.Columns.Add("TypeName"); dtUelect.Columns.Add("TypeColor"); dtUelect.Columns.Add("con"); dtUelect.Columns.Add("Area"); dtUelect.Columns.Add("av"); dtUelect.Columns.Add("max"); foreach (KeyValuePair> kv in selectNameGroup) { areaSum = avg = max = 0; for(int i=0;i< kv.Value.Count;i++) { areaSum += kv.Value[i].Area; switch (con) { case "DMAX": avg += kv.Value[i].DMAX; if(kv.Value[i].DMAX> max) { max = kv.Value[i].DMAX; } break; case "DMIN": avg += kv.Value[i].DMIN; if (kv.Value[i].DMIN > max) { max = kv.Value[i].DMIN; } break; case "CIRCLE": avg += kv.Value[i].Area; if (kv.Value[i].Area > max) { max = kv.Value[i].Area; } break; case "FERET": avg += kv.Value[i].FERET; if (kv.Value[i].FERET > max) { max = kv.Value[i].FERET; } break; } } avg = avg / kv.Value.Count; dtUelect.Rows.Add(kv.Key, kv.Value[0].TypeName, kv.Value[0].TypeColor, kv.Value.Count, areaSum, avg, max); } totalArea = OTSIncAReportApp.frmReportApp.selectedRegion.Width * OTSIncAReportApp.frmReportApp.selectedRegion.Height; dt = dtUelect.Copy(); } else { Dictionary sampleMembers = ((Dictionary)((Dictionary)result.ResultInfo["Sample"])["Members"]); Dictionary semDataMsr = (Dictionary)sampleMembers["SEMDataMsr"]; double scanFieldSize = Convert.ToDouble(semDataMsr["ScanFieldSize"]); Dictionary imageScanParam = (Dictionary)((Dictionary)((Dictionary)sampleMembers["MsrParams"])["Members"])["ImageScanParam"]; string ImageResolution = imageScanParam["ImageResolution"].ToString(); double wide = Convert.ToDouble(ImageResolution.Split('_')[2]); int filedCount = Convert.ToInt32(semDataMsr["TotalFields"]); totalArea = scanFieldSize * wide * filedCount; dt = particledata.GetParticleListByIncA(po); } 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 = DrawFunction.colorHx16toRGB(color); } else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max") { if (con == "CIRCLE") { double Area = Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]); gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Math.Sqrt(Area / Math.PI), 2); } else { 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.ToLower() == "arearadio") { if (totalArea == 0) { gridView.Rows[add_rowindex].Cells[k].Value = 0; } else { gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["Area"]) * 100 / totalArea, 3); } 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 = DrawFunction.colorHx16toRGB(color); } else if (gridView.Columns[k].Name.ToLower() == "av" || gridView.Columns[k].Name.ToLower() == "max") { if (con == "CIRCLE") { double Area = Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]); gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Math.Sqrt(Area / Math.PI), 2); } else { 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 if (gridView.Columns[k].Name.ToLower() == "arearadio") { if (totalArea == 0) { gridView.Rows[add_rowindex].Cells[k].Value = 0; } else { gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["Area"]) * 100/ totalArea, 5); } 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.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()]; source = m_ReportApp.m_conditionChoose.m_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.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); //string sou = m_ReportApp.m_conditionChoose.m_SourceGridData.GetPropItemValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString(); 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); ////设置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.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE); //string sou = source.GetPropItemValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString(); string sou = source.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 } }