OTS/OTSIncAReportApp/1-UI/Control_Grids/CompositionDistributionGrid.cs

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;

			//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_condition.m_CurrentConditions[OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE].itemDisplayVal.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++)
				{
					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);
					}
				}

				//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();
			}
		}


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

            //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++)
                {
                    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

    }
}