123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627 |
- using DevExpress.Utils;
- using DevExpress.XtraCharts;
- using DevExpress.XtraRichEdit.Layout;
- using DevExpress.XtraTreeList.Data;
- using OTSCommon.DBOperate.Model;
- using OTSIncAReportApp;
- using OTSIncAReportApp._1_UI.Control_DEVCharts;
- using OTSIncAReportApp.DataOperation.DataAccess;
- using OTSIncAReportApp.OTSRstMgrFunction;
- 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.Linq;
- using System.Windows.Forms;
- namespace OTSIncAReportGrids
- {
- /// <summary>
- /// 成分分布表 颗粒成份分布表
- /// </summary>
- public partial class CompositionDistributionGrid : UserControl
- {
- #region 设置变量
- //设置模拟数据表
- public DataTable m_dt = new DataTable();
- DataTable SelectParticlesListConvertToTable(List<Particle> selectParticles)
- {
- DataTable dataTable = new DataTable();
- return dataTable;
- }
- //国际化
- Language lan;
- Hashtable table;
- //测量结果
- ResultFile result = null;
- OTSIncAReportApp.OTSSampleReportInfo.ReportCondition source;
- OTSIncAReportApp.frmReportApp m_ReportApp;
- frmReportConditionChoose m_condition;
- //int gridheight = 0;
- List<int> list_gridheight = new List<int>();
- int gridwidth = 0;
- int GridPosition = 0;
- int chartposition = 0;
- int indexGraphicType = 0;
- string GraphicType = "柱状图";
- #endregion
- #region 多数据源
- /// <summary>
- /// 绑定datagridview数据
- /// </summary>
- public void BindDataGridView(string path, int num, string filename,string GraphicType)
- {
- List<int> FLID = new List<int>() { 0, 1, 2, 4, 6, 7, 8, 9 };
- 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() };
- 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_conditionData.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 "ECD":
- 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 sel = m_ReportApp.m_conditionChoose.m_conditionData.GetComboDownListIndexByItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
- gridView.MergeColumnNames.Add(filename);
- gridView.AddSpanHeader(1, gridView.Columns.Count - 1, filename);
-
- FieldData fielddata = new FieldData(path);
- double scanFieldSize = result.GetScanFieldSizeX();
- double wide = result.GetImageWidth();
- double high = result.GetImageHeight();
- double pixelSize = scanFieldSize / wide;
- int filedCount = fielddata.GetFiledCount();
- totalArea = high * pixelSize*wide* pixelSize * 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 == "ECD")
- {
- 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,2);
- }
- else
- {
- gridView.Rows[add_rowindex].Cells[k].Value = Math.Round( Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name])* 2,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 == "ECD")
- {
- 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, 2);
- }
- else
- {
- gridView.Rows[add_rowindex].Cells[k].Value = Math.Round(Convert.ToDouble(dt.Rows[i][gridView.Columns[k].Name]) * 2, 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, 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;
- }
- }
- }
- gridView.Name = "gridView" + num.ToString();
- int a1 = gridView.Rows.Add();
- gridView.Rows[a1].Cells[1].Value = "Sum";
- for (int j = 0; j < gridView.Rows.Count - 2; j++)
- {
- if (gridView.Rows[a1].Cells[3].Value == null)
- gridView.Rows[a1].Cells[3].Value = 0;
- gridView.Rows[a1].Cells[3].Value = Convert.ToInt32(gridView.Rows[a1].Cells[3].Value) + Convert.ToInt32(gridView.Rows[j].Cells[3].Value);
- if(gridView.Rows[a1].Cells[4].Value == null)
- gridView.Rows[a1].Cells[4].Value = 0;
- gridView.Rows[a1].Cells[4].Value = Convert.ToDouble(gridView.Rows[a1].Cells[4].Value) + Convert.ToDouble(gridView.Rows[j].Cells[4].Value);
- }
- int position= SetDataGridViewStyle(gridView);
- panel1.Controls.Add(gridView);
- // Panel panel = new Panel();
- //panel.Size = new Size(gridwidth, 27);
- ////panel.Dock = DockStyle.Top;
- //panel.Location=new Point(0, list_gridheight.Max());
- // panel.BackColor = Color.WhiteSmoke;
-
- Graphics(dt, filename, GraphicType, position);
- }
- private void Graphics(DataTable data,string filename,string comboBox1Text,int pos)
- {
- ChartControl chartControl1 = new ChartControl();
- chartControl1.Series.Clear();
- // 假设你已经有一个 ChartControl 实例,并且已经添加了一个饼图 Series
- Series series = new Series(filename, ViewType.Bar);
- for (int a = 0; a < data.Rows.Count; a++)
- {
- string name = data.Rows[a]["TypeName"].ToString();
- double Cunt = Convert.ToDouble(data.Rows[a]["con"]);
- series.Points.Add(new SeriesPoint(name, Cunt));
- }
- series.LabelsVisibility = DefaultBoolean.True;
- chartControl1.Series.Add(series);
- //图例的位置定义
- chartControl1.Legend.AlignmentVertical = LegendAlignmentVertical.Top;
- chartControl1.Legend.AlignmentHorizontal = LegendAlignmentHorizontal.RightOutside;
- chartControl1.Legend.Visibility = DevExpress.Utils.DefaultBoolean.False;
- chartControl1.Legend.Direction = LegendDirection.TopToBottom;
- //十字准线光标
- chartControl1.CrosshairEnabled = DefaultBoolean.True;
- chartControl1.CrosshairOptions.ShowValueLine = true;
- chartControl1.CrosshairOptions.ShowArgumentLabels = true;
- DevFunctions.ChangeView2(chartControl1, comboBox1Text);
- chartControl1.Location = new Point(pos, list_gridheight.Max());
- chartControl1.Size = new Size(GridPosition, GridPosition);
- // 获取图表的坐标系(通常为 XYDiagram)
- XYDiagram diagram = chartControl1.Diagram as XYDiagram;
- if (diagram != null)
- {
- // 设置横坐标(X轴)名称
- diagram.AxisX.Title.Text = "种类";
- diagram.AxisX.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
- // 设置纵坐标(Y轴)名称
- diagram.AxisY.Title.Text = "数量";
- diagram.AxisY.Title.Visibility = DevExpress.Utils.DefaultBoolean.True; // 确保标题可见
- }
- panel1.Controls.Add(chartControl1);
- }
- /// <summary>
- /// 设置DataGridView样式
- /// </summary>
- private int SetDataGridViewStyle(OTSGridView gridView)
- {
- //用户不能调整标题的高度
- 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;
- 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.BorderStyle = 0;
- //gridView.Dock = System.Windows.Forms.DockStyle.Fill;
- //gridView.Location = new System.Drawing.Point(0, 0);
- //gridView.Location = new System.Drawing.Point(0, gridheight);
- int gridheight = 0;
- //chartposition = gridwidth;
- int outpos = gridwidth;
- gridView.Location = new System.Drawing.Point(gridwidth, 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.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30);
- //gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30 + 30);
- //gridheight = gridheight + gridView.RowCount * 30 + 80;
- gridheight = gridheight + gridView.RowCount * 30 + 5;
- gridwidth = gridwidth + gridView.ColumnCount * 100 + 60;
- chartposition = chartposition + gridView.ColumnCount * 100;
- GridPosition = gridView.ColumnCount * 100 +40;
- list_gridheight.Add(gridheight);
- 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.EnableResizing;
- gridView.ColumnHeadersHeight = 40;
- return outpos;
- }
- #endregion
- #region 窗体加载及初始化
- /// <summary>
- /// 成份分布表,构造函数
- /// </summary>
- /// <param name="in_sec">传入,委托类对象</param>
- /// <param name="in_Cotsreportprojfilemgrclr">传入,项目管理类对象</param>
- public CompositionDistributionGrid(OTSIncAReportApp.frmReportApp ReportApp)
- {
- m_ReportApp = ReportApp;
- result = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()];
- source = m_ReportApp.m_conditionChoose.m_conditionData;
- m_condition= ReportApp.m_conditionChoose;
- InitializeComponent();
- //国际化
- lan = new Language(this);
- table = lan.GetNameTable(this.Name);
- }
- public void SetGraphicType(ReportCondition sourceGridData)
- {
- string stdId = "";
- int stdIdIndex = 0;
- //find the stdId condition
- var STDIdItm = sourceGridData.ConditionItemList.Find(s => s.iItemId == OTS_REPORT_PROP_GRID_ITEMS.GRAPHIC_TYPE);
- if (STDIdItm != null)
- {
- stdId = STDIdItm.itemDisplayVal.ToString();
- stdIdIndex = STDIdItm.comboDownList.IndexOf(stdId);
- }
- indexGraphicType = stdIdIndex;
- GraphicType = stdId;
- string sou = m_condition.m_CurrentConditions[OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE].itemDisplayVal.ToString();
- if (sou.Contains("+"))
- {
- for (int i = 0; i < sou.Split('+').Length; i++)
- {
- ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
- if (resultFile != null)
- {
- BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName, stdId);
- }
- }
- }
- else
- {
- for (int i = 0; i < m_ReportApp.m_rstDataMgr.ResultFilesList.Count; i++)
- {
- if (sou == m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName.ToString())
- {
- BindDataGridView(m_ReportApp.m_rstDataMgr.ResultFilesList[i].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName, stdId);
- }
- }
- }
- }
- private void CompositionDistributionGrid_Load(object sender, EventArgs e)
- {
-
- }
- #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);
- }
- /// <summary>
- /// 复制选择区域
- /// </summary>
- public void CopySelected(OTSGridView in_ogv)
- {
- Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent());
- }
- /// <summary>
- /// 复制选择区域
- /// </summary>
- public void CopySelected()
- {
- DataGridView dgv = (DataGridView)panel1.Controls["Gview_gz"];
- //复制选择区域
- object oo = dgv.GetClipboardContent();
- Clipboard.SetDataObject(dgv.GetClipboardContent());
- }
- /// <summary>
- /// 复制所有
- /// </summary>
- public void CopyAll(OTSGridView in_ogv)
- {
- in_ogv.SelectAll();
- Clipboard.SetDataObject(((OTSGridView)in_ogv).GetClipboardContent());
- }
- /// <summary>
- /// 复制所有
- /// </summary>
- 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);
- }
- }
- string sou = source.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE).ToString();
- if (sou.Contains("+"))
- {
- for (int i = 0; i < sou.Split('+').Length; i++)
- {
- ResultFile resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList.Find(s => s.anotherFileName == sou.Split('+')[i]);
- if (resultFile != null)
- {
- BindDataGridView(resultFile.FilePath, i, resultFile.anotherFileName, GraphicType);
- }
- }
- }
- else
- {
- 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);
- }
- }
- 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<ROW2
- e.SortResult = -1;
- if (((OTSGridView)sender).SortOrder == SortOrder.Descending)
- e.SortResult = 1;
- e.Handled = true;
- return;
- }
- }
- private void Gview_gz_Sorted(object sender, EventArgs e)
- {
- //排序完成,重新设置序号
- for (int i = 0; i < ((OTSGridView)sender).Rows.Count; i++)
- {
- if (((OTSGridView)sender).Rows[i].Tag != null && ((OTSGridView)sender).Rows[i].Tag.ToString() == "统计行")
- { }
- else
- {
- ((OTSGridView)sender).Rows[i].Cells[0].Value = i.ToString();
- }
- }
- }
- #endregion
- #region 获取向导出模块提供的DataTable和GridView对象
- /// <summary>
- /// 获取到该模块输出后形成的DataTable,和GridView
- /// </summary>
- /// <param name="out_dt"></param>
- /// <param name="out_dg"></param>
- 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
- }
- }
|