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
}
}