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

using DevExpress.Utils;
using DevExpress.XtraCharts;
using OTSIncAReportApp._1_UI.Control_DEVCharts;
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 ParticlesSizeGrid : UserControl
    {
        #region 设置变量
        //设置模拟数据表
        public DataTable m_dt = new DataTable();

        //国际化
        Language lan;
        Hashtable table;

        //测量结果
        ResultFile resultFile = null;
        OTSIncAReportApp.OTSSampleReportInfo.ReportCondition reportCondition;
        OTSIncAReportApp.frmReportApp m_ReportApp;

        int gridheight = 0;
		int gridwidth = 0;
		public string condition = "";

        List<DataTable> list_table_data = new List<DataTable>();
        List<Point> list_table_size = new List<Point>();
        List<Point> list_table_Point = new List<Point>();
        List<string> list_fileName = new List<string>();
		#endregion

		
        
        
        #region 自定义方法

		private string getWhere(string max, string min, string col, string partic)
        {
			if (col == "Area")
			{
				return col + ">=" + ((Convert.ToDouble(min)/2) * (Convert.ToDouble(min)/2) * Math.PI).ToString() + " and " + col + "<" + ((Convert.ToDouble(max)/2) * (Convert.ToDouble(max)/2) * Math.PI).ToString() + " and TypeId=" + partic;

			}
			else
			{
				return col + ">=" + min + " and " + col + "<" + max + " and TypeId=" + partic;
			}
		}

        /// <summary>
        /// 绑定datagridview数据
        /// </summary>
        public void UpdateDataGrid(string path, int num, string filename)
        {
            List<string> colid = new List<string>() { "rowid", "pname", "color", "TypeId", "Largest", "Total" };
            List<string> colname = new List<string>() { table["str1"].ToString(), table["str8"].ToString(), table["str9"].ToString(), "TypeId", table["str10"].ToString(), table["str11"].ToString() };

            OTSGridView gridView = new OTSGridView();

            gridView.ColumnHeaderMouseClick += new DataGridViewCellMouseEventHandler(Gview_ColumnHeaderMouseClick);
            gridView.Sorted += Gview_gz_Sorted;

            OTSIncAReportApp.DataOperation.DataAccess.ParticleData particledata = new OTSIncAReportApp.DataOperation.DataAccess.ParticleData(path);

            DataTable dtp = particledata.GetParticleAll("");
            string sizestr = null;
            string con = "";
            if (condition != "")
            {
                con = condition;
            }
            else
            {
                con = reportCondition.GetPropItemDisplayValueByPropItemName(OTS_REPORT_PROP_GRID_ITEMS.SIZE_CAL_METHOD_TYPE).ToString();
            }

            string po = "";
            switch (con)
            {
                case "DMAX":
                    po = "DMAX";
                    break;
                case "DMIN":
                    po = "DMIN";
                    break;
                case "ECD":
                    po = "Area";
                    break;
                case "FERET":
                    po = "DFERET";
                    break;
            }
            //获取粒级表
            if (m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile == "AUTO.psf")
            {
                double dn = 99999;
                string sou = reportCondition.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)
                        {
                            if(dn> resultFile.GetParticleMINECD())
                            {
                                dn = resultFile.GetParticleMINECD();
                            }
                        }
                    }
                }
                else
                {
                    ResultFile resultFile = m_ReportApp.m_rstDataMgr.CurResultFile;
                    dn = resultFile.GetParticleMINECD();
                }
                sizestr = dn.ToString()+",";
                for(double p= dn; p<50;p=p * Math.Sqrt(2))
                {
                    if(p > dn&& p <= 50.5)
                    {
                        double dd = Math.Round(p);
                        sizestr += dd.ToString() + ",";
                    }
                }
                sizestr = sizestr.Remove(sizestr.Length - 1, 1);
            }
            else
            {
                string path1 = m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFileFolder + m_ReportApp.m_rstDataMgr.m_RptConfigFile.PartSizeFile;
                DataSet ds = OTSIncAReportApp.DataOperation.DataAccess.XMLoperate.GetXml(path1);
                sizestr = ds.Tables[0].Rows[0]["Sizes"].ToString();
            }

            for (int i = 0; i < sizestr.Split(',').Length - 1; i++)
            {
                if (sizestr.Split(',')[i].Length > 0)
                {
                    double d1 = Convert.ToDouble(sizestr.Split(',')[i]);
                    double d2 = Convert.ToDouble(sizestr.Split(',')[i + 1]);
                    colid.Add(d1.ToString() + "~" + d2.ToString());
                    colname.Add(d1.ToString() + "~" + d2.ToString());
                }
            }
            double d = Convert.ToDouble(sizestr.Split(',')[sizestr.Split(',').Length - 1]);
            colid.Add(d.ToString() + "~MAX");
            colname.Add(d.ToString() + "~MAX");
            //创建Grid的列 创建Datatable的列
            for (int i = 0; i < colid.Count; i++)
            {
                gridView.Columns.Add(colid[i], colname[i]);
                if (!m_dt.Columns.Contains(colid[i]))
                    m_dt.Columns.Add(colid[i]);
                gridView.Columns[i].ValueType = typeof(System.Int32);
            }
            if (!m_dt.Columns.Contains("Class"))
                m_dt.Columns.Add("Class");
            //设置grid默认值的样式，防止图像为空时有红x
            for (int i = 0; i < gridView.Columns.Count; i++)
            {
                gridView.Columns[i].DefaultCellStyle.NullValue = null;
            }

            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() };
            int sel = m_ReportApp.m_conditionChoose.m_conditionData.GetComboDownListIndexByItemName(OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            string filedAndParticl = "";
            DataTable dt;
            dt = particledata.GetParticleListForParticlSize("area", filedAndParticl);
            gridView.MergeColumnNames.Add(filename);
            gridView.AddSpanHeader(1, gridView.Columns.Count - 1, filename);

            

            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].Tag = "Statistics";
                gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;
                gridView.Rows[add_rowindex].Cells[1].Value = dt.Rows[i]["TypeName"];
                gridView.Rows[add_rowindex].Cells[1].Style.BackColor = Color.Azure;
                string color = dt.Rows[i]["TypeColor"].ToString();
                if (!color.Contains("#"))
                {
                    color = "#" + dt.Rows[i]["TypeColor"].ToString();
                }
                gridView.Rows[add_rowindex].Cells[2].Style.BackColor = DrawFunction.colorHx16toRGB(color);
                gridView.Rows[add_rowindex].Cells[3].Value = dt.Rows[i]["TypeId"];
                gridView.Rows[add_rowindex].Cells[4].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
                gridView.Rows[add_rowindex].Cells[4].Style.BackColor = Color.Azure;
                gridView.Rows[add_rowindex].Cells[5].Value = dt.Rows[i]["con"];
                gridView.Rows[add_rowindex].Cells[5].Style.BackColor = Color.Azure;
                m_dt.Rows.Add();
                m_dt.Rows[add_rowindex]["pname"]= dt.Rows[i]["TypeName"];
                m_dt.Rows[add_rowindex]["TypeId"]=dt.Rows[i]["TypeId"];
                m_dt.Rows[add_rowindex]["Largest"] = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
                m_dt.Rows[add_rowindex]["Total"]= dt.Rows[i]["con"];
                m_dt.Rows[add_rowindex]["Class"] = dt.Rows[i]["GroupName"];
            }
            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].Tag = "Statistics";
                gridView.Rows[add_rowindex].Cells[0].Value = add_rowindex + 1;

                int index = FLID.IndexOf(Convert.ToInt32(dt.Rows[i]["TypeId"]));
                if (index == -1)
                {
                    index = 7;
                }
                
                string name = NameList[index];
                //gridView.Rows[add_rowindex].Cells[1].Value = name;
                gridView.Rows[add_rowindex].Cells[1].Value = dt.Rows[i]["TypeName"];
                gridView.Rows[add_rowindex].Cells[1].Style.BackColor = Color.Azure;
                string color = "#000000";
                gridView.Rows[add_rowindex].Cells[2].Style.BackColor = DrawFunction.colorHx16toRGB(color);
                gridView.Rows[add_rowindex].Cells[3].Value = dt.Rows[i]["TypeId"];
                gridView.Rows[add_rowindex].Cells[4].Value = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
                gridView.Rows[add_rowindex].Cells[4].Style.BackColor = Color.Azure;
                gridView.Rows[add_rowindex].Cells[5].Value = dt.Rows[i]["con"];
                gridView.Rows[add_rowindex].Cells[5].Style.BackColor = Color.Azure;

                m_dt.Rows.Add();
                m_dt.Rows[add_rowindex]["pname"] = dt.Rows[i]["TypeName"];
                m_dt.Rows[add_rowindex]["TypeId"] = dt.Rows[i]["TypeId"];
                m_dt.Rows[add_rowindex]["Largest"] = Math.Round(Convert.ToDouble(dt.Rows[i]["max"]), 2);
                m_dt.Rows[add_rowindex]["Total"] = dt.Rows[i]["con"];
                m_dt.Rows[add_rowindex]["Class"] = dt.Rows[i]["GroupName"];
            }

            
            
            for (int i = 0; i < gridView.Rows.Count - 1; i++)
            {
                for (int j = 6; j < colid.Count; j++)
                {
                    string d1 = colid[j].Split('~')[0];
                    string d2 = colid[j].Split('~')[1];
                    if (d2 == "MAX")
                    {
                        d2 = "999";
                    }
                    DataRow[] datas = dtp.Select(getWhere(d2, d1, po, gridView.Rows[i].Cells[3].Value.ToString()));
                    gridView.Rows[i].Cells[j].Value = datas.Count();
                    gridView.Rows[i].Cells[j].Style.BackColor = Color.Azure;

                    m_dt.Rows[i][colid[j]]= datas.Count();
                }
            }
            gridView.Columns[3].Visible = false;

            //设置grid默认值的样式，防止图像为空时有红x
            for (int i = 0; i < gridView.Columns.Count; i++)
            {
                gridView.Columns[i].DefaultCellStyle.NullValue = null;
            }

            gridView.Name = "gridView" + num.ToString();
            list_table_Point.Add(SetDataGridViewStyle(gridView));
            AddSumRow(gridView);
            panel1.Controls.Add(gridView);
			list_table_data.Add(m_dt);

		}



        void AddSumRow(OTSGridView gridView)
        {
            if (gridView.Rows == null || gridView.Rows.Count <1)
                return;
            int a1 = gridView.Rows.Add();
            gridView.Rows[a1].Tag = "Sum";
            gridView.Rows[a1].Cells[1].Value = "Sum";
            for (int j = 0; j < gridView.Rows.Count - 1; j++)
            {
                for (int k = 5; k < gridView.Columns.Count; k++)
                {
                    if (gridView.Rows[a1].Cells[k].Value == null)
                        gridView.Rows[a1].Cells[k].Value = 0;
                    if (k == 5)
                    {
                        gridView.Rows[a1].Cells[k].Value = Convert.ToInt64(gridView.Rows[a1].Cells[k].Value) + Convert.ToInt64(gridView.Rows[j].Cells[k].Value);
                    }
                    else
                    {
                        gridView.Rows[a1].Cells[k].Value = Convert.ToInt32(gridView.Rows[a1].Cells[k].Value) + Convert.ToInt32(gridView.Rows[j].Cells[k].Value);
                    }
                }
            }
            //gridView.Rows[a1].Height = 30;

            gridView.Rows[a1].DefaultCellStyle.BackColor = Color.Azure;
            gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30);
        }
        /// <summary>
        /// 设置DataGridView样式
        /// </summary>
        private Point 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.Margin = new System.Windows.Forms.Padding(2);
            gridView.MergeColumnHeaderBackColor = System.Drawing.SystemColors.ButtonHighlight;

            gridView.ReadOnly = true;
            gridView.RowHeadersVisible = false;
            gridView.RowHeadersWidth = 40;
            gridView.RowTemplate.Height = 30;
            //gridView.Size = new System.Drawing.Size(gridView.ColumnCount * 100 + 60, gridView.RowCount * 30 + 30);
            int gridView_Width = 0;

			for (int i = 0; i < gridView.ColumnCount; i++)
            {
                gridView_Width = gridView_Width + gridView.Columns[i].Width;

			}

			int gridViewHeight = 0;

			for (int i = 0; i < gridView.Rows.Count; i++)
			{
				gridViewHeight = gridViewHeight + gridView.Rows[i].Height;

			}

			gridView.Size = new System.Drawing.Size(gridView_Width, gridViewHeight);
			

			//gridView.Size = new System.Drawing.Size(gridView_Width, gridView.RowCount * 30);
            gridheight = gridheight + gridViewHeight;
            gridwidth = gridwidth + gridView.ColumnCount * 100;
			gridView.TabIndex = 0;
            //先设置一下头的高度，否则会太矮不好看
            gridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing;
            gridView.ColumnHeadersHeight = 40;

            gridView.Columns[4].Visible = false;

			list_table_size.Add(new Point(gridView.ColumnCount * 100 - 40, gridViewHeight+30));
            int outpos = gridView.Location.X;
            int a_height = gridheight - gridViewHeight;


			gridView.Location = new System.Drawing.Point(gridwidth- gridView.ColumnCount * 100, 0);
			return new Point(outpos, a_height);
            //list_table_Point.Add(new Point(gridwidth, gridheight));
        }
        #endregion

        #region 窗体加载及初始化
        public ParticlesSizeGrid()
        {
            InitializeComponent();
        }


        /// <summary>
        /// 成份分布表，构造函数
        /// </summary>
        /// <param name="in_sec">传入,委托类对象</param>
        /// <param name="in_Cotsreportprojfilemgrclr">传入，项目管理类对象</param>
        public ParticlesSizeGrid(OTSIncAReportApp.frmReportApp ReportApp)
        {
            m_ReportApp = ReportApp;
            resultFile = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()];
            reportCondition = m_ReportApp.m_conditionChoose.m_conditionData;


            InitializeComponent();
            //国际化
            lan = new Language(this);
            table = lan.GetNameTable(this.Name);
        }
        private void ParticlesSizeGrid_Load(object sender, EventArgs e)
        {
			list_table_data.Clear();
            list_table_size.Clear();
            list_table_Point.Clear();
            list_fileName.Clear();
	

			string sou = reportCondition.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)
                    {
                        UpdateDataGrid(resultFile.FilePath, i, resultFile.anotherFileName);
                        list_fileName.Add(resultFile.anotherFileName);

					}
                }
            }
            else
            {
                for (int i=0;i< m_ReportApp.m_rstDataMgr.ResultFilesList.Count;i++)
                {
                    if (sou == m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName.ToString())
                    {
						UpdateDataGrid(m_ReportApp.m_rstDataMgr.ResultFilesList[i].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
                        list_fileName.Add(m_ReportApp.m_rstDataMgr.ResultFilesList[i].anotherFileName);
					}
                 
                }
            }
        }

        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.STD_ID);
			if (STDIdItm != null)
			{
				stdId = STDIdItm.itemDisplayVal.ToString();
				stdIdIndex = STDIdItm.comboDownList.IndexOf(stdId); 
			}
            int high = 0;
            for (int i = 0; i < list_table_Point.Count; i++)
            {
                if (high < list_table_Point[i].Y)
                {
					high = list_table_Point[i].Y;
				}
            }

            for (int i = 0; i < list_table_data.Count; i++)
            {
                Graphics_Stacking(list_table_data[i], stdId, list_table_size[i],list_table_Point[i], high);
			}

		}



        /// <summary>
        /// chart图创建
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="stdId"></param>
		private void Graphics_Stacking(DataTable dt, string stdId, Point a_size ,Point a_Location,int location_hig)
		{
			ChartControl chartControl1 = new ChartControl();
			chartControl1.Series.Clear();

            chartControl1.Size = new Size(a_size.X, a_size.Y);
            chartControl1.Location = new Point(a_Location.X+ a_size.X+20, a_size.Y+20);

			DataTable dataTable = new DataTable();
			dataTable.Columns.Add("name");
			dataTable.Columns.Add("size");

			if (stdId != "All")
			{
				for (int i = 0; i < dt.Rows.Count; i++)
				{
					if (dt.Rows[i]["pname"].ToString() == stdId)
					{
						for (int a = 7; a < dt.Columns.Count-1; a++)
						{
							DataRow dr = dataTable.NewRow();
							dr["name"] = dt.Columns[a].ColumnName;
							dr["size"] = Convert.ToInt16(dt.Rows[i][a]);
							dataTable.Rows.Add(dr);
						}
					}
				}
			}

			if (stdId == "All")
			{
				List<Series> seriesList = new List<Series>();

				DataTable data = new DataTable();
				data.Columns.Add("name");
				data.Columns.Add("range");
				data.Columns.Add("num");
				for (int i = 0; i < dt.Rows.Count; i++)
				{
                    if (dt.Rows[i]["pname"].ToString() != "")
                    {
						for (int a = 6; a < dt.Columns.Count - 1; a++)
						{
							DataRow dr = data.NewRow();
							dr["name"] = dt.Rows[i]["pname"].ToString();
							dr["range"] = dt.Columns[a].ColumnName;
							dr["num"] = dt.Rows[i][a].ToString();
							data.Rows.Add(dr);
						}
					}
					
				}

				foreach (DataRow dr in data.DefaultView.ToTable(true, "name").Rows)
				{
					Series s = new Series(dr["name"].ToString(), ViewType.StackedBar)
					{
						LegendTextPattern = dr["name"].ToString(),
						ArgumentScaleType = ScaleType.Qualitative,
					};
					foreach (DataRow drl in data.Select("name='" + dr["name"].ToString() + "'"))
						s.Points.Add(new SeriesPoint(drl["range"].ToString(), int.Parse(drl["num"].ToString())));
					s.LabelsVisibility = DefaultBoolean.False;
					seriesList.Add(s);
				}
				foreach (Series sr in seriesList.ToArray())
					chartControl1.Series.Add(sr);
			}
			else
			{



				// 假设你已经有一个 ChartControl 实例，并且已经添加了一个饼图 Series
				Series series = new Series(stdId, ViewType.Bar);

				for (int a = 0; a < dataTable.Rows.Count; a++)
				{
					string name = dataTable.Rows[a]["name"].ToString();
					double Cunt = Convert.ToDouble(dataTable.Rows[a]["size"]);
					series.Points.Add(new SeriesPoint(name, Cunt));
				}
				series.LabelsVisibility = DefaultBoolean.True;
				chartControl1.Series.Add(series);


			}


				((XYDiagram)chartControl1.Diagram).AxisY.Title.Text = "";
			((XYDiagram)chartControl1.Diagram).AxisX.Title.Text = "";
			((XYDiagram)chartControl1.Diagram).AxisY.Title.Visibility = DefaultBoolean.True;
			((XYDiagram)chartControl1.Diagram).AxisX.Title.Visibility = DefaultBoolean.True;
			((XYDiagram)chartControl1.Diagram).AxisY.Title.Font = new Font("Tahoma", 9);
			((XYDiagram)chartControl1.Diagram).AxisX.Title.Font = new Font("Tahoma", 9);
			((XYDiagram)chartControl1.Diagram).AxisY.Title.Alignment = System.Drawing.StringAlignment.Far;
			((XYDiagram)chartControl1.Diagram).AxisX.Title.Alignment = System.Drawing.StringAlignment.Far;

			//图例的位置定义
			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;


			panel1.Controls.Add(chartControl1);
		}

	
		#endregion

		#region 相关事件
		private void ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            //复制整个表
            CopyAll();
        }

        private void ToolStripMenuItem2_Click(object sender, EventArgs e)
        {
            CopySelected();
        }

        /// <summary>
        /// 复制选择区域
        /// </summary>
        public void CopySelected()
        {
            foreach (var item in panel1.Controls)
            {
                if (item.GetType().ToString() == "OTSGridView")
                {
                    //复制选择区域
                    object oo = ((OTSGridView)item).GetClipboardContent();
                    Clipboard.SetDataObject(((OTSGridView)item).GetClipboardContent());
                }
            }
        }

        /// <summary>
        /// 复制所有
        /// </summary>
        public void CopyAll()
        {
            foreach (var item in panel1.Controls)
            {
                if (item.GetType().ToString() == "OTSGridView")
                {
                    ((OTSGridView)item).SelectAll();
                    Clipboard.SetDataObject(((OTSGridView)item).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);
                }
            }
            gridheight = 0;

            //int idx = m_ReportApp.m_DataMgrFun.GetPropIndexByPropItemName(m_ReportApp.SourceGridData.ConditionItemList, OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE);
            //string sou = m_ReportApp.SourceGridData.ConditionItemList[idx].itemVal.ToString();
            string sou = reportCondition.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)
                    {
                        UpdateDataGrid(resultFile.FilePath, i, resultFile.anotherFileName);
                    }
                }
            }
            else
            {
                UpdateDataGrid(m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].FilePath, 0, m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResultId()].anotherFileName);
            }
        }

        private void Gview_gz_Sorted(object sender, EventArgs e)
        {
            if (((OTSGridView)sender).Rows == null || ((OTSGridView)sender).Rows.Count == 0)
                return;
            for (int i = 0; i < ((OTSGridView)sender).Rows.Count; i++)
            {
                if (((OTSGridView)sender).Rows[i].Tag.ToString() == "Sum")
                { ((OTSGridView)sender).Rows.RemoveAt(i); break; }
            }
            //排序完成，重新设置序号
            for (int i = 0; i < ((OTSGridView)sender).Rows.Count; i++)
            {
                ((OTSGridView)sender).Rows[i].Cells[0].Value = (i+1).ToString();
            }
            ((OTSGridView)sender).Refresh();
        }
        void Gview_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (((OTSGridView)sender).Rows == null || ((OTSGridView)sender).Rows.Count == 0)
                return;
            AddSumRow((OTSGridView)sender);
        }
        #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


    }
}