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

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.UserModel.Charts;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;
using OTSIncAReportApp;
using OTSIncAReportApp.DataOperation.DataAccess;
using OTSIncAReportApp.DataOperation.Model;
using OTSIncAReportApp.SysMgrTools;
using OTSIncAReportGraph.Class;
using OTSIncAReportGraph.OTSIncAReportGraphFuncation;
using OTSIncAReportGrids.OTSIncAReportGridsFuncation;
using OTSIncAReportMailInterface;

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Threading;
using System.Windows.Forms;


namespace OTSIncAReportGrids
{
    public partial class ParticlesGridDevidePage : UserControl
    {
        #region 枚举定义
        /// <summary>
        /// 样品台X轴方向
        /// </summary>
        enum OTS_X_AXIS_DIRECTION
        {
            LEFT_TOWARD = 0,
            RIGHT_TOWARD = 1
        }

        /// <summary>
        /// 样品台Y轴方向
        /// </summary>
        enum OTS_Y_AXIS_DIRECTION
        {
            UP_TOWARD = 0,
            DOWN_TOWARD = 1
        }
        #endregion

        //设置模拟数据表
        public DataTable m_dt = new DataTable();

        //底层操作类
        OTSReportGridsFun m_OTSIncAReportGridsFun = null;

        //进度条窗体
        public Frm_UserProgress m_frm_userprogress;

        //移动SEM到指定位置发生线程
        private Thread m_mythread;

        //记录线程是否已经运行完成的状态
        private bool m_mythread_state = false;

        //导出图像文件的路径
        private string m_imagefilepath = "";

        //显示元素列表
        public List<string> m_list_elementscolname = null;

        //单个数据源所拥有的列数，这里保存下来，供导出模块使用
        public int m_oneresult_columncount = 0;

        OTSImageDisHelp m_ReportFun = null;
        private OTSImageDisHelp ReportFun { get => m_ReportFun; set => m_ReportFun = value; }

        //多个数据源，每个数据源拥有的列数，这里保存下来，供分组使用
        public List<int> m_list_oneresult_columncount;
        //国际化
        Language lan;
        Hashtable table;
        //测量结果
        ResultFile result = null;
        string str_SysType = "";//当前启动模式（夹杂物、清洁度）
        frmReportConditionChoose m_condition;
        FieldData fieldData;
        DataTable particlesAll;
        DataTable particles;
        ParticleData Particledata;
        UserLibraryData userLibrary;
        DataTable userLibraryData;
        NLog.Logger log = NLog.LogManager.GetCurrentClassLogger();

        #region 分页器相关

        #region 分页字段和属性

        string condition = "";
        public string FileName = null;
        private int pageIndex = 1;

        /// <summary>
        /// 当前页面
        /// </summary>
        public virtual int PageIndex
        {
            get { return pageIndex; }
            set { pageIndex = value; }
        }

        private int pageSize = 20;
        /// <summary>
        /// 每页记录数
        /// </summary>
        public virtual int PageSize
        {
            get { return pageSize; }
            set { pageSize = value; }
        }

        //string OrderFunction = "fieldid,particleid";

        private int recordCount = 0;
        /// <summary>
        /// 总记录数
        /// </summary>
        public virtual int RecordCount
        {
            get { return recordCount; }
            set { recordCount = value; }
        }

        private int pageCount = 0;
        /// <summary>
        /// 总页数
        /// </summary>
        public int PageCount
        {
            get
            {
                pageCount = GetPageCount();
                return pageCount;
            }
        }
        /// <summary>
        /// 计算总页数
        /// </summary>
        /// <returns></returns>
        private int GetPageCount()
        {
            if (PageSize == 0)
            {
                return 0;
            }
            int pageCount = RecordCount / PageSize;
            if (RecordCount % PageSize == 0)
            {
                pageCount = RecordCount / PageSize;
            }
            else
            {
                pageCount = RecordCount / PageSize + 1;
            }
            return pageCount;
        }
        #endregion

        frmReportApp m_ReportApp;
        ResultFile resultFile = null;
        #endregion

        public ParticlesGridDevidePage(frmReportApp ReportApp)
        {
            m_ReportApp = ReportApp;
            m_condition = ReportApp.m_conditionChoose;
            resultFile = ReportApp.m_rstDataMgr.CurResultFile;
            ReportFun = new OTSImageDisHelp(resultFile);

            string sou = m_condition.m_CurrentConditions[OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE].itemDisplayVal.ToString();
            if (sou.Contains("+"))
            {
                result = m_ReportApp.m_rstDataMgr.ResultFilesList[0];
            } else
            {
                for (int i = 0; i < m_ReportApp.m_rstDataMgr.ResultFilesList.Count; i++)
                {
                    if (sou == m_ReportApp.m_rstDataMgr.ResultFilesList[i].FileName.ToString())
                    {
                        result = m_ReportApp.m_rstDataMgr.ResultFilesList[i];
                    }

                }
            }
            //result = m_ReportApp.m_rstDataMgr.ResultFilesList[m_ReportApp.m_rstDataMgr.GetWorkingResult()];


            //设置窗体的双缓冲,以保证大数据时拖动不卡
            this.SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true);
            this.UpdateStyles();

            InitializeComponent();

            //利用反射设置DataGridView的双缓冲
            Type dgvType = this.dgV_ParticlesDevidePage.GetType();
            PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
            pi.SetValue(this.dgV_ParticlesDevidePage, true, null);
        }
        bool Init()
        {
            try
            {
                lan = new Language(this);
                table = lan.GetNameTable(this.Name);


                m_mythread_state = false;
                m_mythread = new Thread(new ParameterizedThreadStart(Thread_GO));
                //m_frm_userprogress = new Frm_UserProgress();
                fieldData = new FieldData(result.FilePath);
                Particledata = new ParticleData(result.FilePath);
                str_SysType = ((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["Sample"])["Members"])["MsrParams"])["SysType"].ToString();
                if (str_SysType == "0:IncA")
                {
                    userLibraryData = null;
                }
                else
                {
                    string str_libraryName = ((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["Sample"])["Members"])["MsrParams"])["STDName"].ToString();
                    userLibrary = new UserLibraryData(str_libraryName);
                    if (userLibrary.GetSqlHelper() != null)
                    {
                        userLibraryData = userLibrary.GetSubAttributeFromDatabase();
                    }
                    else
                    {
                        userLibraryData = null;
                    }
                }
                //初始化底层操作类
                m_OTSIncAReportGridsFun = new OTSReportGridsFun(m_ReportApp, this);
                return true;
            }
            catch (Exception ex)
            {
                log.Error(ex.ToString());
                return false;
            }

        }
        private void ParticlesGridDevidePage_Load(object sender, EventArgs e)
        {

            UpdateLoad();
        }
        private void UpdateLoad()
        {
            if (!Init())
            {
                return;
            }
            ProgressStart();//进度条关闭通过cbB_PageSize.SelectedIndex事件

            if (!UpdateTable())
            {
                return;
            }

            cbB_PageSize.Items.Add("20");
            cbB_PageSize.Items.Add("100");
            cbB_PageSize.Items.Add("500");
            cbB_PageSize.Items.Add("1000");
            cbB_PageSize.Items.Add("5000");
            cbB_PageSize.Items.Add("All");
            cbB_PageSize.SelectedIndex = 0;
        }
        #region 自定义方法

        bool UpdateTable()
        {
            int sel = m_ReportApp.m_conditionChoose.m_SourceGridData.GetComboDownListIndexByItemName(OTSIncAReportApp.OTSSampleReportInfo.OTS_REPORT_PROP_GRID_ITEMS.DATA_SOURCE_TYPE);
            if (sel == 1)
            {
                List<OTSIncAReportApp.DataOperation.Model.Particle> selectParticles = m_ReportApp.GetSelectedParticles();
                DataTable dtUelect = new DataTable();
                dtUelect.Columns.Add("fieldid");
                dtUelect.Columns.Add("particleid");
                dtUelect.Columns.Add("AveGray");
                dtUelect.Columns.Add("RectLeft");
                dtUelect.Columns.Add("RectTop");
                dtUelect.Columns.Add("RectWidth");
                dtUelect.Columns.Add("RectHeight");
                dtUelect.Columns.Add("Area");
                dtUelect.Columns.Add("PosX");
                dtUelect.Columns.Add("PosY");
                dtUelect.Columns.Add("TypeId");
                //dtUelect.Columns.Add("ElementNum");
                dtUelect.Columns.Add("SegmentNum");
                dtUelect.Columns.Add("SEMPosX");
                dtUelect.Columns.Add("SEMPosY");
                dtUelect.Columns.Add("XrayId");
                dtUelect.Columns.Add("DMAX");
                dtUelect.Columns.Add("DMIN");
                dtUelect.Columns.Add("DPERP");
                dtUelect.Columns.Add("PERIMETER");
                dtUelect.Columns.Add("ORIENTATION");
                dtUelect.Columns.Add("DINSCR");
                dtUelect.Columns.Add("DMEAN");
                dtUelect.Columns.Add("DELONG");
                dtUelect.Columns.Add("DFERET");
                dtUelect.Columns.Add("TypeName");
                dtUelect.Columns.Add("TypeColor");
                dtUelect.Columns.Add("SubParticles");
                dtUelect.Columns.Add("Element");
                dtUelect.Columns.Add("Hardness");
                dtUelect.Columns.Add("Density");
                dtUelect.Columns.Add("Electrical_conductivity");
                for (int i = 0; i < selectParticles.Count; i++)
                {
                    dtUelect.Rows.Add(selectParticles[i].FieldId, selectParticles[i].ParticleId, selectParticles[i].AveGray, selectParticles[i].RectLeft, selectParticles[i].RectTop, selectParticles[i].RectWidth, selectParticles[i].RectHeight, selectParticles[i].Area, selectParticles[i].PosX, selectParticles[i].PosX, selectParticles[i].TypeId, /*selectParticles[i].ElementNum,*/ selectParticles[i].SegmentNum, selectParticles[i].SEMPosX, selectParticles[i].SEMPosY, selectParticles[i].ParticleId, selectParticles[i].DMAX, selectParticles[i].DMIN, selectParticles[i].DPERP, selectParticles[i].PERIMETER, selectParticles[i].ORIENTATION, selectParticles[i].DINSCR, selectParticles[i].DMEAN, selectParticles[i].DELONG, selectParticles[i].DFERET, selectParticles[i].TypeName, selectParticles[i].TypeColor, "", "", "", "", "");
                }
                if (userLibraryData != null)
                {
                    for (int i = 0; i < dtUelect.Rows.Count; i++)
                    {
                        DataRow[] dr = userLibraryData.Select("STDId=" + dtUelect.Rows[i]["TypeId"].ToString());
                        if (dr.Length > 0)
                        {
                            dtUelect.Rows[i]["Hardness"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Hardness"].ToString(), @"[^\d.\d]", "");
                            dtUelect.Rows[i]["Density"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Density"].ToString(), @"[^\d.\d]", "");
                            dtUelect.Rows[i]["Electrical_conductivity"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Electrical_conductivity"].ToString(), @"[^\d.\d]", "");
                        }
                        else
                        {
                            dtUelect.Rows[i]["Hardness"] = "";
                            dtUelect.Rows[i]["Density"] = "";
                            dtUelect.Rows[i]["Electrical_conductivity"] = "";
                        }
                    }
                }
                else
                {
                    for (int i = 0; i < dtUelect.Rows.Count; i++)
                    {
                        dtUelect.Rows[i]["Hardness"] = "";
                        dtUelect.Rows[i]["Density"] = "";
                        dtUelect.Rows[i]["Electrical_conductivity"] = "";
                    }
                }
                particlesAll = new DataTable();
                particlesAll = dtUelect.Copy();
                btn_Sel.Enabled = false;
            }
            else
            {
                //多次测试发现 读取数据库时间耗时长，但读取条数目对读取数据库时长影响不大，故此处直接读取所有数据库信息，以取代多次连接数据库方式，优化分页速度
                particlesAll = new DataTable();
                particlesAll = Particledata.GetInfoForPartucleDevidePage2(condition);
                particlesAll.Columns.Add("Hardness");
                particlesAll.Columns.Add("Density");
                particlesAll.Columns.Add("Electrical_conductivity");
                if (userLibraryData != null)
                {
                    for (int i = 0; i < particlesAll.Rows.Count; i++)
                    {
                        DataRow[] dr = userLibraryData.Select("STDId=" + particlesAll.Rows[i]["TypeId"].ToString());
                        if (dr.Length > 0)
                        {
                            particlesAll.Rows[i]["Hardness"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Hardness"].ToString(), @"[^\d.\d]", "");
                            particlesAll.Rows[i]["Density"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Density"].ToString(), @"[^\d.\d]", "");
                            particlesAll.Rows[i]["Electrical_conductivity"] = System.Text.RegularExpressions.Regex.Replace(dr[0]["Electrical_conductivity"].ToString(), @"[^\d.\d]", "");
                        }
                        else
                        {
                            particlesAll.Rows[i]["Hardness"] = "";
                            particlesAll.Rows[i]["Density"] = "";
                            particlesAll.Rows[i]["Electrical_conductivity"] = "";
                        }
                    }
                }
                else
                {
                    for (int i = 0; i < particlesAll.Rows.Count; i++)
                    {
                        particlesAll.Rows[i]["Hardness"] = "";
                        particlesAll.Rows[i]["Density"] = "";
                        particlesAll.Rows[i]["Electrical_conductivity"] = "";
                    }
                }
                if (sel == 0)
                {
                    string str = "TypeId <> -1 and TypeId <> 9 and TypeId <> 0";
                    particlesAll = SreeenDataTable(particlesAll, str);
                }
                if (sel == 2)
                {
                    string str = "TypeId = " + "-1 or TypeId =" + "9 or TypeId =" + "0";
                    particlesAll = SreeenDataTable(particlesAll, str);
                }
                btn_Sel.Enabled = true;
            }
            if (particlesAll == null)
            {
                log.Error("There is an exception in the data of the database!");
                #region 加载进度条进度部份结束
                //加载完成设置鼠标为默认
                this.Cursor = Cursors.Default;
                //加载完成，关闭进度条
                m_frm_userprogress.Close();
                #endregion
                return false;
            }
            DataTable elementchemistry = Particledata.GetElementChemistry();
            for (int i = 0; i < particlesAll.Rows.Count; i++)
            {
                string str = "XRayId = " + particlesAll.Rows[i]["particleId"].ToString() + " and fieldid = " + particlesAll.Rows[i]["fieldid"].ToString();
                DataRow[] drs = elementchemistry.Select(str);
                string ConcatenatedString = "";
                for (int j = 0; j < drs.Length; j++)
                {
                    ConcatenatedString += drs[j]["name"] + "-" + drs[j]["Percentage"] + ';';
                }
                particlesAll.Rows[i]["Element"] = ConcatenatedString;
            }
            return true;
        }
        /// <summary>
        /// DataRow转换为DataTable
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="strWhere">筛选的条件</param>
        /// <returns></returns>
        public DataTable SreeenDataTable(DataTable dt, string strWhere)
        {
            if (dt.Rows.Count <= 0) return dt;        //当数据为空时返回
            DataTable dtNew = dt.Clone();         //复制数据源的表结构
            DataRow[] dr = dt.Select(strWhere);  //strWhere条件筛选出需要的数据！
            for (int i = 0; i < dr.Length; i++)
            {
                dtNew.Rows.Add(dr[i].ItemArray);  // 将DataRow添加到DataTable中
            }
            return dtNew;
        }
        /// <summary>
        /// 传入单颗颗粒的particle类对象,返回从field中抠取出的bitmap对象,抠取单颗颗粒
        /// </summary>
        /// <param name="in_cotsparticleclr"></param>
        /// <returns></returns>
        public Bitmap GetBitmapByParticle(string fieldImage, Rectangle offset_rect)
        {

            //然后将取出的数据，转换成Bitmap对象
            Bitmap ls_bt = DrawFunction.ReadImageFile(fieldImage);

            //为了能把整个颗粒显示完整
            offset_rect.X = offset_rect.X - 5;
            offset_rect.Y = offset_rect.Y - 5;
            offset_rect.Width = offset_rect.Width + 10;
            offset_rect.Height = offset_rect.Height + 10;

            //防止计算偏差后，有坐标溢出现象
            if (offset_rect.X < 0)
                offset_rect.X = 0;
            if (offset_rect.Y < 0)
                offset_rect.Y = 0;
            if (offset_rect.X + offset_rect.Width > ls_bt.Width)
            {
                offset_rect.Width = ls_bt.Width - offset_rect.X;
            }
            if (offset_rect.Y + offset_rect.Height > ls_bt.Height)
            {
                offset_rect.Height = ls_bt.Height - offset_rect.Y;
            }

            //
            Bitmap new_ret_bp;
            //防止为0后面计算出错
            if (offset_rect.Width > 0 && offset_rect.Height > 0)
            {
                //最后通过list_showsegment组建成新的图片，进行返回
                new_ret_bp = ls_bt.Clone(offset_rect, PixelFormat.Format8bppIndexed);
            }
            else
            {

                new_ret_bp = new Bitmap(offset_rect.Width, offset_rect.Height);
            }

            return new_ret_bp;
        }
        public Bitmap GetBitmapForBig(string sub, ParticleData fielddata, double xs)
        {

            string vs = "," + sub.Replace(':', '-') + ",";

            DataTable dataTable = fielddata.GetParticleAll(vs);
            if (dataTable.Rows.Count == 0)
            {
                return null;
            }
            string path = result.FilePath;

            //内接矩形
            double max_Y = Convert.ToInt64(dataTable.Rows[0]["FieldPosY"]) * xs - Convert.ToInt64(dataTable.Rows[0]["RectTop"]);
            double max_X = Convert.ToInt64(dataTable.Rows[0]["FieldPosX"]) * xs + Convert.ToInt64(dataTable.Rows[0]["RectLeft"]);
            double min_Y = max_Y;
            double min_X = max_X;

            //拼接field矩形
            double MAX_Y = Convert.ToInt64(dataTable.Rows[0]["FieldPosY"]) * xs;
            double MAX_X = Convert.ToInt64(dataTable.Rows[0]["FieldPosX"]) * xs;
            double MIN_Y = MAX_Y;
            double MIN_X = MAX_X;
            foreach (DataRow item in dataTable.Rows)
            {
                //颗粒外接矩形
                double lefttopX = Convert.ToInt64(item["FieldPosX"]) * xs + Convert.ToInt64(item["RectLeft"]);
                if (lefttopX < min_X)
                {
                    min_X = lefttopX;
                }
                if (lefttopX + Convert.ToInt64(item["RectWidth"]) > max_X)
                {
                    max_X = lefttopX + Convert.ToInt64(item["RectWidth"]);
                }
                double lrfttopY = Convert.ToInt64(item["FieldPosY"]) * xs - Convert.ToInt64(item["RectTop"]);
                if (max_Y < lrfttopY)
                {
                    max_Y = lrfttopY;
                }
                if (min_Y > lrfttopY - Convert.ToInt64(item["RectHeight"]))
                {
                    min_Y = lrfttopY - Convert.ToInt64(item["RectHeight"]);
                }
                //画布
                double lefttopXH = Convert.ToInt64(item["FieldPosX"]) * xs;
                if (lefttopXH > MAX_X)
                {
                    MAX_X = lefttopXH;
                }
                if (lefttopXH < MIN_X)
                {
                    MIN_X = lefttopXH;
                }
                double lrfttopYH = Convert.ToInt64(item["FieldPosY"]) * xs;
                if (MAX_Y < lrfttopYH)
                {
                    MAX_Y = lrfttopYH;
                }
                if (MIN_Y > lrfttopYH)
                {
                    MIN_Y = lrfttopYH;
                }
            }
            int WIDTH = Convert.ToInt32(MAX_X - MIN_X) + 1024;
            int HEIGHT = Convert.ToInt32(MAX_Y - MIN_Y) + 768;
            //构造最终的图片白板
            Bitmap tableChartImage = new Bitmap(WIDTH, HEIGHT);
            Graphics graph = Graphics.FromImage(tableChartImage);
            //初始化这个大图
            graph.DrawImage(tableChartImage, 0, 0);


            int width = Convert.ToInt32(max_X - min_X);
            int height = Convert.ToInt32(max_Y - min_Y);
            int X = Convert.ToInt32(min_X - MIN_X);
            int Y = Convert.ToInt32(MAX_Y - max_Y);
            Rectangle rectangle = new Rectangle() { X = X, Y = Y, Width = width, Height = height };


            foreach (DataRow item in dataTable.Rows)
            {
                string filePath = path + "\\FIELD_FILES\\";
                string imagePath = filePath + "Field" + item["fieldid"].ToString() + ".bmp";
                //然后将取出的数据，转换成Bitmap对象
                Bitmap ls_bt = DrawFunction.ReadImageFile(imagePath);
                int x = Convert.ToInt32(Convert.ToDouble(item["FieldPosX"]) * xs - MIN_X);
                int y = System.Math.Abs(Convert.ToInt32(Convert.ToDouble(item["FieldPosY"]) * xs - MAX_Y));
                try
                {
                    graph.DrawImage(ls_bt, x, y);
                }
                catch /*(Exception e)*/
                {

                    throw;
                }

            }

            Bitmap bmap = tableChartImage.Clone(rectangle, PixelFormat.Format8bppIndexed);
            return bmap;
        }

        private void BindDataGridView()
        {
            dgV_ParticlesDevidePage.Visible = false;

            if (m_frm_userprogress.IsDisposed)
            {
                ProgressStart();
            }

            dgV_ParticlesDevidePage.Rows.Clear();
            dgV_ParticlesDevidePage.Columns.Clear();
            //从报告xml文件中加载,显示计算列，显示元素信息
            string str_DefaultComputedColName = "", str_ElementsColName = "";
            DataSet ds = OTSIncAReportApp.DataOperation.DataAccess.XMLoperate.GetXmlData(Application.StartupPath + m_ReportApp.m_OTSReportMgrParamFile, "XMLData");
            DataTable dt = ds.Tables["Member"];
            foreach (DataRow element in dt.Rows)
            {
                string RegName = element["RegName"].ToString();

                if (RegName == "DefaultComputedColName")
                {
                    str_DefaultComputedColName = element["strValue"].ToString();
                }

                if (RegName == "ElementsColName")
                {
                    str_ElementsColName = element["strValue"].ToString();
                }
            }

            //获取需要显示的计算列
            string[] strs = str_DefaultComputedColName.Split(',');

            //列名
            Dictionary<string, string> keyValues = new Dictionary<string, string>() { };

            keyValues.Add("rowid", table["str4"].ToString());
            keyValues.Add("TypeName", table["str6"].ToString());
            keyValues.Add("ParticleImage", table["str5"].ToString());
            keyValues.Add("FieldID", "FieldID");
            keyValues.Add("SEMPosX", "SEMPosX");
            keyValues.Add("SEMPosY", "SEMPosY");
            for (int i = 0; i < strs.Count(); i++)
            {
                if (strs[i] == "Area")
                {
                    keyValues.Add("Area", table["str21"].ToString());
                }
                if (strs[i] == "EquivalentCircleDiameter")
                {
                    keyValues.Add("Equivalent", table["str22"].ToString());
                }
                if (strs[i] == "MaxDiameter")
                {
                    keyValues.Add("DMAX", table["str23"].ToString());
                }
                if (strs[i] == "MinDiameter")
                {
                    keyValues.Add("DMIN", table["str24"].ToString());
                }
                if (strs[i] == "DiameterRatio")
                {
                    keyValues.Add("DiameterRatio", table["str25"].ToString());
                }
                if (strs[i] == "FerretDiameter")
                {
                    keyValues.Add("DFERET", table["str26"].ToString());
                }
                if (strs[i] == "PERP")
                {
                    keyValues.Add("DPERP", table["str27"].ToString());
                }
                if (strs[i] == "PERI")
                {
                    keyValues.Add("PERIMETER", table["str28"].ToString());
                }
                if (strs[i] == "INSCR")
                {
                    keyValues.Add("DINSCR", table["str29"].ToString());
                }
                if (strs[i] == "MEAN")
                {
                    keyValues.Add("DMEAN", table["str30"].ToString());
                }
                if (strs[i] == "ELONG")
                {
                    keyValues.Add("DELONG", table["str31"].ToString());
                }
                if (strs[i] == "ASPECT_ELONG")
                {
                    keyValues.Add("ASPECT_ELONG", table["str32"].ToString());
                }
                if (strs[i] == "Orientation")
                {
                    keyValues.Add("ORIENTATION", table["str33"].ToString());
                }
                if (str_SysType == "1:CleannessA")
                {
                    if (strs[i] == "Hardness")
                    {
                        keyValues.Add("Hardness", table["str34"].ToString());
                    }
                    if (strs[i] == "Density")
                    {
                        keyValues.Add("Density", table["str35"].ToString());
                    }
                    if (strs[i] == "Electrical_conductivity")
                    {
                        keyValues.Add("Electrical_conductivity", table["str36"].ToString());
                    }
                }

            }
            keyValues.Add("Element", "Element");

            Dictionary<string, string>.Enumerator en = keyValues.GetEnumerator();
            for (int irow = 0; irow < keyValues.Count; irow++)
            {
                if (en.MoveNext())
                {
                    if (en.Current.Key == "ParticleImage")
                    {
                        DataGridViewImageColumn iconColumn = new DataGridViewImageColumn();
                        iconColumn.Name = en.Current.Key;
                        iconColumn.HeaderText = en.Current.Value;
                        dgV_ParticlesDevidePage.Columns.Add(iconColumn);
                    }
                    else if (en.Current.Key == "Element")
                    {

                    }
                    else
                    {
                        int columndid = dgV_ParticlesDevidePage.Columns.Add(en.Current.Key, en.Current.Value);
                    }

                }
            }
            if (PageSize == -1)
            {
                PageSize = particlesAll.Rows.Count;
            }

            if (particlesAll == null)
            {
                return;
            }
            RecordCount = particlesAll.Rows.Count;
            particles = particlesAll.Clone();
            for (int fi = (PageIndex - 1) * pageSize; fi < PageIndex * pageSize; fi++)
            {
                if (fi > RecordCount - 1)
                {
                    break;
                }
                particles.ImportRow(particlesAll.Rows[fi]);
            }
            string particleM = "";
            //获取需要显示的元素名
            List<string> ElementTypeSort = new List<string>(str_ElementsColName.Split(',').ToList());//去重
            for (int i = 0; i < ElementTypeSort.Count; i++)
            {
                dgV_ParticlesDevidePage.Columns.Add(ElementTypeSort[i], ElementTypeSort[i]);
            }
            double jd = 95f / (double)particles.Rows.Count;//计算进度刻度

            string filePath = result.FilePath + "\\FIELD_FILES\\";
            KeyValuePair<string, Bitmap> FieldImage = new KeyValuePair<string, Bitmap>();
            for (int i = 0; i < particles.Rows.Count; i++)
            {
                //更新进度,每100条记录加载完，更新一次进度
                if (i % 10 == 0)
                    m_frm_userprogress.SetProgressValueAndText((int)(jd * i), "loading..");

                Dictionary<string, string>.Enumerator enl = keyValues.GetEnumerator();

                int add_rowindex = dgV_ParticlesDevidePage.Rows.Add();
                dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[0].Value = (pageSize * (PageIndex - 1) + add_rowindex + 1).ToString();

                for (int k = 0; k < keyValues.Count; k++)
                {
                    if (enl.MoveNext())
                    {
                        if (enl.Current.Key == "rowid")
                        {
                            //dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = i + 1;
                        }
                        if (enl.Current.Key == "ParticleImage")
                        {
                            string subt = particles.Rows[i]["SubParticles"].ToString();
                            if (subt != null && subt != "")
                            {
                                double ScanFieldSize = Convert.ToDouble(((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["Sample"])["Members"])["SEMDataMsr"])["ScanFieldSize"]);
                                string filePatht = result.FilePath + "\\FIELD_FILES\\";
                                string imagePatht = filePatht + "Field" + subt.Split(',')[0].Split(':')[0].ToString() + ".bmp";
                                //然后将取出的数据，转换成Bitmap对象
                                Bitmap tempbit = Particledata.ReadImageFile(imagePatht);
                                int pixw = tempbit.Width;
                                double xs = pixw / ScanFieldSize;

                                particleM = particleM + "," + subt;
                                Bitmap bmap = Particledata.GetBitmapForBig(subt, xs, result.FilePath, tempbit.Height, tempbit.Width);
                                if (bmap != null)
                                {
                                    string[] str = subt.Split(',');
                                    bmap.Tag = new List<string>() { str[0].Split(':')[0], str[0].Split(':')[1], particles.Rows[i]["TypeId"].ToString() };
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Height = 150;
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = bmap;
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].DefaultCellStyle.ForeColor = Color.Chocolate;
                                }
                                else
                                {
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Height = 150;

                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Style.BackColor = Color.Azure;
                                }
                            }
                            else
                            {
                                if (FieldImage.Key != particles.Rows[i]["fieldid"].ToString() || FieldImage.Value == null)
                                {
                                    string imagePath = filePath + "Field" + particles.Rows[i]["fieldid"].ToString() + ".bmp";
                                    FieldImage = new KeyValuePair<string, Bitmap>(particles.Rows[i]["fieldid"].ToString(), Particledata.ReadImageFile(imagePath));
                                }

                                Rectangle rectangle = new Rectangle() { X = Convert.ToInt32(particles.Rows[i]["RectLeft"]), Y = Convert.ToInt32(particles.Rows[i]["RectTop"]), Width = Convert.ToInt32(particles.Rows[i]["RectWidth"]), Height = Convert.ToInt32(particles.Rows[i]["RectHeight"]) };
                                Bitmap bmap = Particledata.GetBitmapByParticle(FieldImage.Value, rectangle);
                                bmap.Tag = new List<string>() { particles.Rows[i]["FieldId"].ToString(), particles.Rows[i]["ParticleId"].ToString(), particles.Rows[i]["TypeId"].ToString() };
                                dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = bmap;
                                dgV_ParticlesDevidePage.Rows[add_rowindex].Height = bmap.Height + 20;
                            }
                        }
                        if (enl.Current.Key == "DiameterRatio")
                        {
                            double d = Convert.ToDouble(particles.Rows[i]["DMAX"]) / Convert.ToDouble(particles.Rows[i]["DMIN"]);
                            dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = Math.Round(d, 2);
                        }
                        if (enl.Current.Key == "ASPECT_ELONG")
                        {
                            double d = Convert.ToDouble(particles.Rows[i]["DELONG"]) / Convert.ToDouble(particles.Rows[i]["DMEAN"]);
                            dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = Math.Round(d, 2);
                        }
                        if (particles.Columns.Contains(enl.Current.Key))
                        {
                            double num = 0;
                            if (double.TryParse(particles.Rows[i][enl.Current.Key].ToString(), out num))
                            {
                                dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = Math.Round(num, 2);
                            }
                            else if (enl.Current.Key == "Element")
                            {
                                List<string> elementtemp = new List<string>(ElementTypeSort);
                                string[] strcbo = particles.Rows[i][enl.Current.Key].ToString().Split(';');
                                for (int j = 0; j < strcbo.Length; j++)
                                {
                                    string[] str = strcbo[j].Split('-');
                                    if (ElementTypeSort.Contains(str[0]))
                                    { dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[str[0].ToString()].Value = Math.Round(double.Parse(str[1]), 2).ToString(); }
                                    elementtemp.Remove(str[0].ToString());
                                }
                                foreach (var ele in elementtemp)
                                {
                                    dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[ele].Value = "0";
                                }
                            }
                            else
                            {
                                dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = particles.Rows[i][enl.Current.Key];
                            }
                        }
                        if (enl.Current.Key == "TypeName")
                        {
                            if (particles.Rows[i]["TypeId"].ToString() == "9")
                            {
                                dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = "Not Identified";
                            }
                        }
                        if (enl.Current.Key == "Equivalent")
                        {
                            double dSize = Convert.ToDouble(particles.Rows[i]["Area"]);
                            double Diameter = Math.Sqrt(dSize / Math.PI) * 2;
                            dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[k].Value = Math.Round(Diameter, 2);
                        }
                    }
                }
            }


            #region 加载进度条进度部份结束
            //加载完成设置鼠标为默认
            this.Cursor = Cursors.Default;
            string str8 = table["str8"].ToString();
            m_frm_userprogress.SetProgressValueAndText(100, str8);
            //加载完成，关闭进度条
            m_frm_userprogress.Close();
            #endregion

            dgV_ParticlesDevidePage.Visible = true;
        }



        /// <summary>
        /// 设置DataGridView样式
        /// </summary>
        private void SetDataGridViewStyle()
        {
            //用户不能调整标题的高度
            dgV_ParticlesDevidePage.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            //用户不能调整 行高
            dgV_ParticlesDevidePage.AllowUserToResizeRows = false;

            //点击选择整行
            dgV_ParticlesDevidePage.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

            //居中显示
            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
            dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
            dgV_ParticlesDevidePage.DefaultCellStyle = dataGridViewCellStyle1;
            dgV_ParticlesDevidePage.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

            //再次重覆禁用拖动表头高度，居然有效果了
            dgV_ParticlesDevidePage.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            //设置grid可以复制
            dgV_ParticlesDevidePage.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;

            //设置每列的宽度
            dgV_ParticlesDevidePage.Columns[0].Width = 40;//第一列序号的宽度设置一下吧，要不太丑
            dgV_ParticlesDevidePage.Columns[1].Width = 150;
            //dgV_ParticlesDevidePage.Columns[dgV_ParticlesDevidePage.Columns.Count - 1].Width = 450;
            //dgV_ParticlesDevidePage.Columns[dgV_ParticlesDevidePage.Columns.Count - 1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;

            //设置序号列不排序
            dgV_ParticlesDevidePage.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;

            //设置序号列不可以设置宽度
            dgV_ParticlesDevidePage.Columns[0].Resizable = DataGridViewTriState.False;

            dgV_ParticlesDevidePage.RowsDefaultCellStyle.BackColor = Color.Azure;
        }

        #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()
        {
            //复制选择区域
            object oo = dgV_ParticlesDevidePage.GetClipboardContent();
            if (oo != null)
                Clipboard.SetDataObject(dgV_ParticlesDevidePage.GetClipboardContent());
        }

        /// <summary>
        /// 复制所有
        /// </summary>
        public void CopyAll()
        {
            dgV_ParticlesDevidePage.SelectAll();
            Clipboard.SetDataObject(dgV_ParticlesDevidePage.GetClipboardContent());

        }

        /// <summary>
        /// 以图像的方式将GridView进行截图
        /// </summary>
        public void CopyImage()
        {
            int height, width;
            width = dgV_ParticlesDevidePage.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) + 2;
            height = this.Height;

            Bitmap image = new Bitmap(width, height);
            dgV_ParticlesDevidePage.DrawToBitmap(image, new Rectangle(0, 0, width, height));

            Clipboard.SetImage(image);
        }

        private void toolStripMenuItem4_Click(object sender, EventArgs e)
        {
            //对gridview进行截图
            CopyImage();
        }


        private void dgV_ParticlesDevidePage_SortCompare(object sender, DataGridViewSortCompareEventArgs e)
        {
            //排序中
            if (this.dgV_ParticlesDevidePage.Rows[e.RowIndex1].Tag != null && this.dgV_ParticlesDevidePage.Rows[e.RowIndex1].Tag.ToString() == "统计行")
            {
                //ROW1>ROW2  
                e.SortResult = 1;
                if (this.dgV_ParticlesDevidePage.SortOrder == SortOrder.Descending)
                    e.SortResult = -1;
                e.Handled = true;
                return;
            }

            if (this.dgV_ParticlesDevidePage.Rows[e.RowIndex2].Tag != null && this.dgV_ParticlesDevidePage.Rows[e.RowIndex2].Tag.ToString() == "统计行")
            {
                //ROW1<ROW2  
                e.SortResult = -1;
                if (this.dgV_ParticlesDevidePage.SortOrder == SortOrder.Descending)
                    e.SortResult = 1;
                e.Handled = true;
                return;
            }
        }

        /// <summary>
        /// 将OTS坐标转换为Sem 坐标
        /// </summary>
        /// <param name="POTSCoord"></param>
        /// <returns></returns>
        public Point ChangeOTSToSemCoord(Point POTSCoord)
        {
            //first if m_semstagedata is null to get stage inforation

            Convert.ToDouble(((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["scanFieldSize"]);
            //after obtaining stage info,calc stage point data
            Point ret_SEM_point = new Point();

            // get center point, um
            long xStart = Convert.ToInt64(((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["Members"])["XAxis"])["start"]);
            long xEnd = Convert.ToInt64(((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["Members"])["XAxis"])["end"]);

            long xCenter = (xStart + xEnd) / 2;

            long yStart = Convert.ToInt64(((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["Members"])["YAxis"])["start"]);
            long yEnd = Convert.ToInt64(((Dictionary<string, object>)((Dictionary<string, object>)((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["Members"])["YAxis"])["end"]);

            long yCenter = (yStart + yEnd) / 2;

            // delte = SEM - OTSa
            long deltex = xCenter - 0;
            long deltey = yCenter - 0;
            int xdir = Convert.ToInt32(((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["xAxisDir"]);
            int ydir = Convert.ToInt32(((Dictionary<string, object>)result.ResultInfo["SEMStageData"])["yAxisDir"]);
            if (xdir == (int)OTS_X_AXIS_DIRECTION.LEFT_TOWARD)
            {
                ret_SEM_point.X = -1 * (POTSCoord.X - Convert.ToInt32(deltex));
            }
            else if (xdir == (int)OTS_X_AXIS_DIRECTION.RIGHT_TOWARD)
            {
                ret_SEM_point.X = POTSCoord.X + Convert.ToInt32(deltex);
            }

            if (ydir == (int)OTS_Y_AXIS_DIRECTION.UP_TOWARD)
            {
                ret_SEM_point.Y = POTSCoord.Y + Convert.ToInt32(deltey);
            }
            else if (ydir == (int)OTS_Y_AXIS_DIRECTION.DOWN_TOWARD)
            {
                ret_SEM_point.Y = -1 * (POTSCoord.Y - Convert.ToInt32(deltey));
            }

            return ret_SEM_point;
        }
        #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 = this.dgV_ParticlesDevidePage;//同样通过 dgV_ParticlesDevidePage.Rows[add_rowindex].Cells[2].Value 来获取bitmap对象
        }



        #endregion

        #region 连接电镜相关
        /// <summary>
        /// 移动SEM到指定位置线程函数
        /// </summary>
        private void Thread_GO(object in_obj)
        {
            if (m_mythread_state == false)
            {
                m_mythread_state = true;

                Point sem_point = (Point)in_obj;

                //第一步，连接电镜
                m_OTSIncAReportGridsFun.Connection_ForParticlesGrid();

                Thread.Sleep(500);

                //第二步，移动到指定位置,先读取再设置
                if (m_OTSIncAReportGridsFun.m_SEMConnectionState == true)
                {
                    m_OTSIncAReportGridsFun.MoveSemToPointXY_ForParticlesGrid(sem_point.X, sem_point.Y);

                }

                Thread.Sleep(1500);

                //第三步，断开电镜连接
                m_OTSIncAReportGridsFun.DisConnectSEM_ForParticlesGrid();

                //Thread.Sleep(500);

                m_mythread_state = false;
            }

        }




        #endregion

        private void ToolStripMenuItem_exportzoomimagefile_Click(object sender, EventArgs e)
        {
            //导出放大图像
            FolderBrowserDialog fbd = new FolderBrowserDialog();
            if (fbd.ShowDialog() == DialogResult.OK)
            {
                m_imagefilepath = fbd.SelectedPath;

                for (int i = 0; i < m_dt.Rows.Count; i++)
                {
                    Bitmap ls_bp = new Bitmap(1, 1);
                    ls_bp = (Bitmap)m_dt.Rows[i][1];

                    string strPath = m_imagefilepath + "\\" + (i + 1).ToString() + ".jpg";
                    string strPath2 = m_imagefilepath + "\\" + (i + 1).ToString() + "s.jpg";
                    ls_bp.Save(strPath);
                    //m_COTSReportProjFileMgrClr.ReZoom(strPath, strPath2);

                    System.IO.File.Delete(strPath);//再将文件删除
                }
                string str1 = table["str9"].ToString();
                MessageBox.Show(str1 + m_dt.Rows.Count.ToString());
            }
        }

        /// <summary>
        /// 导出二次放大图像
        /// </summary>
        /// <param name="str_srcPathName"></param>
        /// <param name="str_outPathName"></param>
        public void ParticleReZoom(string str_srcPathName, string str_outPathName)
        {
            //m_COTSReportProjFileMgrClr.ReZoom(str_srcPathName, str_outPathName);
        }

        private void ToolStripMenuItem3_Click(object sender, EventArgs e)
        {
            //恢复至初始状态

            dgV_ParticlesDevidePage.Rows.Clear();
            dgV_ParticlesDevidePage.Columns.Clear();

            BindDataGridView();

            SetDataGridViewStyle();
        }

        private void ToolStripMenuItem5_Click(object sender, EventArgs e)
        {
            /*注意:多数据源情况下，只获取第一个数据源的选择了多行的情况下，只获取最后一个选择行的,没有办法,这是为了符合李阳博士提出的要求*/

            //先获取鼠标所选择的行里的颗粒的FieldID和ParticleID
            string i_ls_fieldid = "";
            string i_ls_particleid = "";
            int cou = dgV_ParticlesDevidePage.SelectedRows.Count;
            if (cou > 0)
            {
                DataGridViewRow dgvr = dgV_ParticlesDevidePage.SelectedRows[cou - 1];
                Bitmap ls_bp = (Bitmap)dgvr.Cells[2].Value;
                List<string> list_str = (List<string>)ls_bp.Tag;
                if (list_str != null)
                {
                    i_ls_fieldid = list_str[0];
                    i_ls_particleid = list_str[1];
                }
            }
            ParticleData particleData = new ParticleData(result.FilePath);
            Particle particle = particleData.GetParticleByFidAndPid(i_ls_fieldid, i_ls_particleid);
            ////然后遍历所有的Field
            //Point ls_ots_point = new Point() { X = particle.PosX, Y = particle.PosY };
            ////将该坐标转成SEM坐标
            //Point ls_sem_point = ChangeOTSToSemCoord(ls_ots_point);

            //取得Field的Position,然后执行线程移动SEM到当前Field的位置
            if (m_mythread == null)
            {
                return;
            }

            if (m_mythread.ThreadState == ThreadState.Running || m_mythread.ThreadState == ThreadState.WaitSleepJoin)
            {
                return;
            }

            if (m_mythread.ThreadState == ThreadState.Stopped)
            {
                m_mythread = new Thread(new ParameterizedThreadStart(Thread_GO));
            }

            //改为线程调用,先判断线程状态
            m_mythread.Start(new Point(particle.SEMPosX, particle.SEMPosY));

        }

        private void ToolStripMenuItem_selectparticle_Click(object sender, EventArgs e)
        {
            string path = result.FilePath;
            ParticleData fielddata = new ParticleData(result.FilePath);
            List<Particle> particles = fielddata.GetParticleAllList();

            List<Particle> ls_list_cotsparticleclr = new List<Particle>();
            for (int l = 0; l < dgV_ParticlesDevidePage.SelectedRows.Count; l++)
            {
                //从事先加载的Bitmap对象的Tag中取出List<string>
                DataGridViewRow dgvr = dgV_ParticlesDevidePage.SelectedRows[l];
                Bitmap ls_bp = (Bitmap)dgvr.Cells[2].Value;
                List<string> list_str = (List<string>)ls_bp.Tag;
                if (list_str != null)
                {
                    int i_ls_fieldid = Convert.ToInt32(list_str[0]);
                    int i_ls_particleid = Convert.ToInt32(list_str[1]);
                    foreach (Particle item in particles)
                    {
                        if (i_ls_fieldid == item.FieldId && i_ls_particleid == item.ParticleId)
                        {
                            ls_list_cotsparticleclr.Add(item);
                            break;
                        }
                    }

                }
            }
            m_ReportApp.SetSelectedParticles(ls_list_cotsparticleclr);
            string str1 = table["str1"].ToString();
            //然后循环得出，list cotsparticleclr列表，返回给框架
            //m_sec.SendCall(str1, "", "", ls_list_cotsparticleclr);
            string str2 = table["str2"].ToString();
            string str3 = table["str3"].ToString();
            MessageBox.Show(str2 + ls_list_cotsparticleclr.Count.ToString() + str3);
        }

        private void ToolStripMenuItem_exportimagefile_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog fbd = new FolderBrowserDialog();
            if (fbd.ShowDialog() == DialogResult.OK)
            {
                m_imagefilepath = fbd.SelectedPath;

                for (int i = 0; i < dgV_ParticlesDevidePage.Rows.Count; i++)
                {
                    Bitmap ls_bp = new Bitmap(1, 1);
                    ls_bp = (Bitmap)dgV_ParticlesDevidePage.Rows[i].Cells[2].Value;

                    ls_bp.Save(m_imagefilepath + "\\" + (i + 1).ToString() + ".jpg");
                }
                string str9 = table["str9"].ToString();
                MessageBox.Show(str9 + dgV_ParticlesDevidePage.Rows.Count.ToString());
            }
        }

        private void testToolStripMenuItem_Click(object sender, EventArgs e)
        {
            ////测试导出指定颗粒的能谱图,测试相关代码
            //OTSIncAReportGraph.DParticle ls_dparticle = new OTSIncAReportGraph.DParticle();
            //for (int i = 0; i < dgV_ParticlesDevidePage.SelectedRows.Count; i++)
            //{
            //    //获取选择行颗粒的fieldid,和particleid
            //    string str_fieldid = "";
            //    string str_particleid = "";
            //    string str_stdtypeid = "";

            //    DataGridViewRow dgvr = dgV_ParticlesDevidePage.SelectedRows[i];
            //    Bitmap ls_bp = (Bitmap)dgvr.Cells[2].Value;
            //    List<string> list_str = (List<string>)ls_bp.Tag;
            //    if (list_str != null)
            //    {
            //        str_fieldid = list_str[0];
            //        str_particleid = list_str[1];
            //        str_stdtypeid = list_str[2];
            //    }

            //    ls_dparticle.CLRFieldID = Convert.ToInt32(str_fieldid);
            //    ls_dparticle.CLRTagID = Convert.ToInt32(str_particleid);
            //    ls_dparticle.STDTypeID = Convert.ToInt32(str_stdtypeid);
            //}

            ////显示xray能谱
            //ShowXRay(ls_dparticle);

            //Bitmap ls_bpex = new Bitmap(control_XRayTable1.Width, control_XRayTable1.Height);
            //control_XRayTable1.DrawToBitmap(ls_bpex, new Rectangle(0, 0, control_XRayTable1.Width, control_XRayTable1.Height));

            ////Bitmap ls_bpex = control_XRayTable1.ExportXRayImage();

            //ls_bpex.Save("e:\\test222.jpg");
        }
        /// <summary>
        /// 判断条件输入 前<后
        /// </summary>
        /// <param name="min"></param>
        /// <param name="max"></param>
        /// <returns></returns>
        bool CompareInput(string min, string max)
        {
            int imax = 0;
            int imin = 0;
            double dmax = 0;
            double dmin = 0;
            if (int.TryParse(max, out imax))
            {
                dmax = (double)imax;
            }
            else
            {
                dmax = Convert.ToDouble(max);
            }
            if (int.TryParse(min, out imin))
            {
                dmin = (double)imin;
            }
            else
            {
                dmin = Convert.ToDouble(min);
            }
            if (dmin <= dmax)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        private void btn_Sel_Click(object sender, EventArgs e)
        {
            condition = "";
            if (!string.IsNullOrWhiteSpace(tBx_AreaMin.Text))
            {
                double dnum = 0;
                int inum = 0;
                if (double.TryParse(tBx_AreaMin.Text, out dnum) && dnum >= 0)
                {
                    condition += " and Area" + " > " + tBx_AreaMin.Text;
                }
                else if (int.TryParse(tBx_AreaMin.Text, out inum) && inum >= 0)
                {
                    condition += " and Area" + " > " + tBx_AreaMin.Text;
                }
                else
                {
                    MessageBox.Show(table["str10"].ToString());
                    return;
                }
            }

            if (!string.IsNullOrWhiteSpace(Tbx_AreaMax.Text))
            {
                double dnum = 0;
                int inum = 0;
                if (double.TryParse(Tbx_AreaMax.Text, out dnum) && dnum >= 0)
                {
                    condition += " and Area" + "<" + Tbx_AreaMax.Text;
                }
                else if (int.TryParse(Tbx_AreaMax.Text, out inum) && inum >= 0)
                {
                    condition += " and Area" + "<" + Tbx_AreaMax.Text;
                }
                else
                {
                    MessageBox.Show(table["str10"].ToString());
                    return;
                }
            }

            if (!string.IsNullOrWhiteSpace(tBx_AreaMin.Text) && !string.IsNullOrWhiteSpace(Tbx_AreaMax.Text))
            {
                if (!CompareInput(tBx_AreaMin.Text, Tbx_AreaMax.Text))
                {
                    MessageBox.Show(table["str11"].ToString());
                    return;
                }
            }


            if (!string.IsNullOrWhiteSpace(tbx_DmaxMin.Text))
            {
                double dnum = 0;
                int inum = 0;
                if (double.TryParse(tbx_DmaxMin.Text, out dnum) && dnum >= 0)
                {
                    condition += " and DMAX" + " > " + tbx_DmaxMin.Text;
                }
                else if (int.TryParse(tbx_DmaxMin.Text, out inum) && inum >= 0)
                {
                    condition += " and DMAX" + " > " + tbx_DmaxMin.Text;
                }
                else
                {
                    MessageBox.Show(table["str10"].ToString());
                    return;
                }
            }

            if (!string.IsNullOrWhiteSpace(tbx_DmaxMax.Text))
            {
                double dnum = 0;
                int inum = 0;
                if (double.TryParse(tbx_DmaxMax.Text, out dnum) && dnum > 0)
                {
                    condition += " and DMAX" + "<" + tbx_DmaxMax.Text;
                }
                else if (int.TryParse(tbx_DmaxMax.Text, out inum) && inum >= 0)
                {
                    condition += " and DMAX" + "<" + tbx_DmaxMax.Text;
                }
                else
                {
                    MessageBox.Show(table["str10"].ToString());
                    return;
                }
            }

            if (!string.IsNullOrWhiteSpace(tbx_DmaxMin.Text) && !string.IsNullOrWhiteSpace(tbx_DmaxMax.Text))
            {
                if (!CompareInput(tbx_DmaxMin.Text, tbx_DmaxMax.Text))
                {
                    MessageBox.Show(table["str11"].ToString());
                    return;
                }
            }

            if (!string.IsNullOrWhiteSpace(tbx_Type.Text))
            {
                condition += " and TypeName Like \"%" + tbx_Type.Text + "%\" ";
            }

            if (m_frm_userprogress.IsDisposed)
            {
                ProgressStart();
            }

            UpdateTable();

            lnkFirst_Click(null, null);
            SetDataGridViewStyle();
        }

        void ProgressStart()
        {
            #region 加载显示进度条部份
            this.Cursor = Cursors.WaitCursor;
            m_frm_userprogress = new Frm_UserProgress();

            //显示进度条,计算进度条应该显示的位置和宽度
            Form ls_main_form = this.ParentForm.ParentForm;//取出父窗体
            if (ls_main_form == null)
            {
                m_frm_userprogress.Visible = false;
            }
            else
            {
                m_frm_userprogress.Width = (int)(MyPrimaryScreen.DESKTOP.Width / MyPrimaryScreen.ScaleX * 0.9);
                m_frm_userprogress.Location = new Point(ls_main_form.Location.X + 200, ls_main_form.Location.Y + 200 + (int)(MyPrimaryScreen.DESKTOP.Height / MyPrimaryScreen.ScaleX) / 2);
                m_frm_userprogress.Show();
                m_frm_userprogress.SetProgressValueAndText(0, "Loading data of particles...");
            }
            #endregion
        }

        private void cbB_order_SelectedIndexChanged(object sender, EventArgs e)
        {
            //int ordernum = cbB_order.SelectedIndex;
            //if (ordernum == 0)
            //{
            //    OrderFunction = "fieldid,particleid";
            //}
            //else if (ordernum == 1)
            //{
            //    OrderFunction = "TypeName";
            //}
            //else if (ordernum == 2)
            //{
            //    OrderFunction = "DMAX";
            //}
            //else if (ordernum == 3)
            //{
            //    OrderFunction = "DMAX desc";
            //}
            //else if (ordernum == 4)
            //{
            //    OrderFunction = "Area";
            //}
            //else if (ordernum == 5)
            //{
            //    OrderFunction = "Area desc";
            //}

            lnkFirst_Click(null, null);
            SetDataGridViewStyle();
        }

        /// <summary>
        /// 页面控件呈现
        /// </summary>
        private void DrawControl(bool callEvent)
        {
            BindDataGridView();
            lblTotalCount.Text = RecordCount.ToString();
            lblPageCount.Text = PageCount.ToString();
            txtPageNum.Text = PageIndex.ToString();

            SetFormCtrEnabled();
            if (PageCount == 0 || PageCount == 1)//有且仅有一页
            {
                lnkFirst.Enabled = false;
                lnkPrev.Enabled = false;
                lnkNext.Enabled = false;
                lnkLast.Enabled = false;
                btnGo.Enabled = false;
            }
            else if (PageIndex == 1)//第一页
            {
                lnkFirst.Enabled = false;
                lnkPrev.Enabled = false;
            }
            else if (PageIndex == PageCount)//最后一页
            {
                lnkNext.Enabled = false;
                lnkLast.Enabled = false;
            }

        }
        private void SetFormCtrEnabled()
        {
            lnkFirst.Enabled = true;
            lnkPrev.Enabled = true;
            lnkNext.Enabled = true;
            lnkLast.Enabled = true;
            btnGo.Enabled = true;
        }

        /// <summary>
        /// 分页属性改变了。
        /// </summary>
        private void txtPageSize_TextChanged(object sender, EventArgs e)
        {
            int num = 0;
            if (int.TryParse(txtPageNum.Text.Trim(), out num) && num > 0)
            {

            }
            else { txtPageNum.Text = "1"; }
        }

        private void lnkFirst_Click(object sender, EventArgs e)
        {
            PageIndex = 1;
            DrawControl(true);
        }

        private void lnkPrev_Click(object sender, EventArgs e)
        {
            PageIndex = Math.Max(1, PageIndex - 1);
            DrawControl(true);
        }

        private void lnkNext_Click(object sender, EventArgs e)
        {
            PageIndex = Math.Min(PageCount, PageIndex + 1);
            DrawControl(true);
        }

        private void lnkLast_Click(object sender, EventArgs e)
        {
            PageIndex = PageCount;
            DrawControl(true);
        }

        /// <summary>
        /// 跳转
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnGo_Click(object sender, EventArgs e)
        {
            int num = 0;
            if (int.TryParse(txtPageNum.Text.Trim(), out num) && num > 0)
            {
                if (num > PageCount)
                {
                    num = PageCount;
                    txtPageNum.Text = PageCount.ToString();
                }
                PageIndex = num;
                DrawControl(true);
            }
        }
        private void DisplayData()
        {
            if (cbB_PageSize.SelectedItem.ToString() == "All")
            {
                pageSize = -1;
            }
            else
            {
                pageSize = int.Parse(cbB_PageSize.SelectedItem.ToString());
            }
            lnkFirst_Click(null, null);
            SetDataGridViewStyle();
        }

        private void cbB_PageSize_SelectedIndexChanged(object sender, EventArgs e)
        {
            DisplayData();
        }

        /// <summary>
        /// 在帧图上标记颗粒的位置矩形,并保存到FIELD_FILES_MARK文件夹中
        /// </summary>
        public void SaveMarkParticleRectangleOnFieldFile(string str_resultPath, DataTable dataTable, out List<string> vs, out DataTable dt_FIeld)
        {
            Init();

            List<string> maxlength = new List<string>();
            for (int i = 0; i < dataTable.Rows.Count; i++)
            {
                if (dataTable.Rows[i]["TypeName"].ToString() != "Not Identified")
                {
                    if (maxlength.Count < 10)
                    {
                        maxlength.Add(dataTable.Rows[i]["Fieldid"].ToString());
                    }
                    else
                    {
                        break;
                    }
                }
            }
            List<string> max_list = maxlength.Distinct().ToList();

            string str_path_FIELD_FILES = str_resultPath + "\\FIELD_FILES\\";
            string str_path_FIELD_FILES_MARK = str_resultPath + "\\FIELD_FILES_MARK\\";
            int intQuantity = 0;
            //List<string> vs = new List<string>();
            dt_FIeld = new DataTable();
            vs = new List<string>();
            ////判断是否已经有导出过的标记帧图文件夹,如果已经存在，则直接返回不输出,先不加
            DirectoryInfo theFolder_FieldMark = new DirectoryInfo(str_path_FIELD_FILES_MARK);
            if (!theFolder_FieldMark.Exists)
            {
                //创建
                theFolder_FieldMark.Create();
            }
            else
            {
                theFolder_FieldMark.Delete(true);

                //创建
                theFolder_FieldMark.Create();
                //已经存在的话，直接返回
                //return;
            }

            //查找该field下对应所有的颗粒
            DataTable dt_AllParticle = fieldData.GetAllParticle_DataTable();

            DirectoryInfo theFolder = new DirectoryInfo(str_path_FIELD_FILES);
            if (theFolder.Exists)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("fieldid");
                dt.Columns.Add("id");
                dt.Columns.Add("fieldName");
                dt.Columns.Add("cunt", typeof(int));
                dt.Columns.Add("fieldFullName");
                for (int i = 0; i < max_list.Count; i++)
                {
                    foreach (FileInfo nextifile in theFolder.GetFiles())
                    {
                        if (nextifile.Name.Contains(".bmp") == true || nextifile.Name.Contains(".BMP") == true)
                        {
                            //确认对应的帧图名
                            string str_fieldid = Path.GetFileNameWithoutExtension(nextifile.Name);
                            str_fieldid = str_fieldid.Substring(5, str_fieldid.Length - 5);//减去field字符长度
                            bool bl = false;

                            if (str_fieldid == max_list[i].ToString())
                            {
                                bl = true;
                            }

                            if (bl)
                            {
                                DataRow dr = dt.NewRow();
                                dr["fieldid"] = " fieldid = " + str_fieldid;
                                dr["cunt"] = dataTable.Select(" fieldid = " + str_fieldid).Count();
                                dr["fieldName"] = nextifile.Name;
                                dr["fieldFullName"] = nextifile.FullName;
                                dr["id"] = str_fieldid;
                                dt.Rows.Add(dr);
                            }

                        }
                    }
                }
                //DataView dv = dt.DefaultView;
                //dv.Sort = "cunt DESC";
                dt_FIeld = dt.Copy();

                for (int i = 0; i < dt_FIeld.Rows.Count; i++)
                {
                    if (dataTable.Select(dt_FIeld.Rows[i]["fieldid"].ToString()).Count() > 0)
                    {
                        vs.Add(dt_FIeld.Rows[i]["id"].ToString());

                        Image img = Image.FromFile(dt_FIeld.Rows[i]["fieldFullName"].ToString());
                        //img.Save(@"D:\1.bmp");
                        Bitmap ls_fieldbp = new Bitmap(img.Width, img.Height, System.Drawing.Imaging.PixelFormat.Format32bppArgb);
                        using (Graphics g = Graphics.FromImage(ls_fieldbp))
                        {
                            g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
                            g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
                            g.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
                            g.DrawImage(img, new Rectangle(0, 0, img.Width, img.Height));
                        }
                        //ls_fieldbp.Save(@"D:\1.bmp");
                        img.Dispose();
                        img = null;


                        //循环将颗粒，进行标记到bitmap图上
                        DataRow[] drlist = dt_AllParticle.Select(dt_FIeld.Rows[i]["fieldid"].ToString());
                        if (drlist.Count() > 0)
                            intQuantity = intQuantity + 1;
                        for (int i_row = 0; i_row < drlist.Count(); i_row++)
                        {
                            //string str_fieldid = drlist[i_row]["fieldid"].ToString();
                            string str_particleid = drlist[i_row]["particleid"].ToString();
                            string str_stdtypeid = drlist[i_row]["typeid"].ToString();
                            string str_offset_rect_X = drlist[i_row]["RectLeft"].ToString();
                            string str_offset_rect_Y = drlist[i_row]["RectTop"].ToString();
                            string str_offset_rect_Width = drlist[i_row]["RectWidth"].ToString();
                            string str_offset_rect_Height = drlist[i_row]["RectHeight"].ToString();

                            //确定需要标记颗粒的定位
                            Rectangle offset_rect = new Rectangle(Convert.ToInt32(str_offset_rect_X), Convert.ToInt32(str_offset_rect_Y),
                    Convert.ToInt32(str_offset_rect_Width), Convert.ToInt32(str_offset_rect_Height));

                            //向帧图进行标记颗粒位置
                            Graphics g = Graphics.FromImage(ls_fieldbp);
                            g.DrawRectangle(new Pen(Color.Aquamarine), offset_rect);

                            //判断是否超出了图像外面，是的话，让文字在左侧显示，默认在右侧显示
                            int ls_offsetx = offset_rect.X + offset_rect.Width;
                            if (ls_offsetx > ls_fieldbp.Width - 10)
                            {
                                ls_offsetx = offset_rect.X - 10;
                            }

                            g.DrawString(dt_FIeld.Rows[i]["id"].ToString() + "" + str_particleid.ToString(),
                                new Font("黑体", 8), new SolidBrush(Color.Aqua), new PointF(ls_offsetx, offset_rect.Y));

                            //保存带有标记的帧图
                            ls_fieldbp.Save(str_path_FIELD_FILES_MARK + dt_FIeld.Rows[i]["id"].ToString() + ".bmp");

                            //ls_fieldbp.Dispose();
                        }
                    }
                }

            }
            //
            GC.Collect();
            GC.WaitForPendingFinalizers();
        }

        private void testToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            //SaveMarkParticleRectangleOnFieldFile();
            MessageBox.Show("Export completed!");
        }

        private void EXCELToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //将所有的数据导出到EXCEL中
            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "Excel File（*.xlsx）|*.xlsx";
            //设置默认文件类型显示顺序
            sfd.FilterIndex = 1;

            //保存对话框是否记忆上次打开的目录
            sfd.RestoreDirectory = true;

            if (sfd.ShowDialog() == DialogResult.OK)
            {
                //IWorkbook workbook = new HSSFWorkbook();   //用于创建.xls  office2003开始以前的
                IWorkbook workbook = new NPOI.XSSF.UserModel.XSSFWorkbook();        //用于创建.xlsx office2007开始以后的
                ISheet sheet;

                //创建Excel文件
                FileStream fs = File.Create(sfd.FileName);
                fs.Close();

                sheet = workbook.CreateSheet("Particles");//创建工作表
                ISheet sheet3;
                sheet3 = workbook.CreateSheet("Peak spectrum");

                //创建表格边框样式风格
                ICellStyle cellStyle = workbook.CreateCellStyle();
                cellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
                cellStyle.VerticalAlignment = VerticalAlignment.Center;

                //设置上4边
                cellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
                cellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
                cellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
                cellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;

                //设置字符大小和颜色
                IFont font = workbook.CreateFont();
                font.FontName = "黑体";
                font.FontHeightInPoints = 10;
                cellStyle.SetFont(font);

                //设置颗粒名列宽
                sheet.SetColumnWidth(1, 30 * 256);//夹杂物名列宽
                sheet.SetColumnWidth(2, 7 * 256);//图像列宽

                IRow row;
                ICell cell;

                //插入表头
                row = sheet.CreateRow(1);//从第15行添加一行
                row.Height = 30 * 20;
                for (int i_cell = 0; i_cell < dgV_ParticlesDevidePage.Columns.Count; i_cell++)
                {
                    cell = row.CreateCell(i_cell);
                    cell.CellStyle = cellStyle;

                    cell.SetCellValue(dgV_ParticlesDevidePage.Columns[i_cell].Name);
                }


                //插入表内容
                for (int i_row = 0; i_row < dgV_ParticlesDevidePage.Rows.Count; i_row++)
                {
                    row = sheet.CreateRow(2 + i_row);
                    row.Height = 45 * 20;
                    for (int i_cell = 0; i_cell < dgV_ParticlesDevidePage.Columns.Count; i_cell++)
                    {
                        cell = row.CreateCell(i_cell);
                        cell.CellStyle = cellStyle;

                        if (dgV_ParticlesDevidePage[i_cell, i_row].Value == null)
                            continue;

                        if (i_cell == 2)
                        {
                            //颗粒图像列
                            Bitmap bp = (Bitmap)dgV_ParticlesDevidePage.Rows[i_row].Cells[2].Value;

                            byte[] bytes = ImageConvertToBytes(bp);

                            //第二步，将图片添加到workbook中，指定图片的格式，返回图片所在workbook->paicture数组中的索引的地址，从1开始
                            int pictureIdx = workbook.AddPicture(bytes, PictureType.JPEG);

                            //第三步，在sheet中创建画布
                            IDrawing patriarch = sheet.CreateDrawingPatriarch();

                            //第四步，设置锚点，（在起始单元格的X坐标0-1023，Y的坐标0-255，在终止单元格的X坐标0-1023，Y的坐标0-255，起始单元格行数，列数，终止单元格行数，列数）
                            IClientAnchor anchor = patriarch.CreateAnchor(1, 1, 2, 2, i_cell, i_row + 2, i_cell + 1, i_row + 3);//终止比开始位置大1,会自动缩放到一个单元格内的

                            //第五步，创建图片
                            IPicture pict = patriarch.CreatePicture(anchor, pictureIdx);

                            //图像效果不好，自己另外导出吧,这里对该列宽进行了设置0
                        }
                        //else if(i_cell==0)
                        //{
                        //    ICreationHelper createHelper = workbook.GetCreationHelper();
                        //    XSSFHyperlink link = (XSSFHyperlink)createHelper.CreateHyperlink(HyperlinkType.Url);
                        //    link.Address=;
                        //    cell.Hyperlink.Address(link);
                        //}
                        else
                        {
                            //非图像列
                            double dbl = 0;
                            if (double.TryParse(dgV_ParticlesDevidePage[i_cell, i_row].Value.ToString(), out dbl))
                            {
                                cell.SetCellValue(dbl);
                            }
                            else
                            {
                                cell.SetCellValue(dgV_ParticlesDevidePage[i_cell, i_row].Value.ToString());
                            }
                        }

                    }
                }

                ISheet sheet2;
                sheet2 = workbook.CreateSheet("Peak spectrum Data");//创建工作表
                //插入表头
                row = sheet2.CreateRow(1);
                row.Height = 30 * 20;
                cell = row.CreateCell(0);
                cell.CellStyle = cellStyle;
                cell.SetCellValue("rowid");

                for (int i_cell = 1; i_cell < 2001; i_cell++)
                {
                   cell = row.CreateCell(i_cell);
                   cell.CellStyle = cellStyle;
                    if (i_cell == 1)
                    {
                        cell.SetCellValue("PeakSpectrumData");
                    }
                }

                sheet2.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 1, 1, 2000));

                for (int j = 0; j < particles.Rows.Count; j++)
                {
                    row = sheet2.CreateRow(2 + j);
                    cell = row.CreateCell(0);
                    cell.CellStyle = cellStyle;
                    cell.SetCellValue(j + 1);
                    var tmpPart = Particledata.GetParticleXrayDataByFidAndPid(particles.Rows[j]["fieldid"].ToString(), particles.Rows[j]["particleid"].ToString());
                    if (tmpPart != null)
                    {
                        if (tmpPart.XrayId > -1)
                        {
                            uint[] Analysis_xray = new uint[2000];
                            for (int i = 0; i < 2000; i++)
                            {
                                Analysis_xray[i] = BitConverter.ToUInt32(tmpPart.XRayData, i * 4);
                                cell = row.CreateCell(i + 1);
                                cell.CellStyle = cellStyle;
                                cell.SetCellValue(Analysis_xray[i]);
                            }

                        }

                    }
                }

                
                sheet3.SetColumnWidth(1, 200 * 256);//图像列宽
                //插入表头
                row = sheet3.CreateRow(1);
                row.Height = 30 * 20;
                cell = row.CreateCell(0);
                cell.CellStyle = cellStyle;
                cell.SetCellValue("rowid");

                cell = row.CreateCell(1);
                cell.CellStyle = cellStyle;
                cell.SetCellValue("PeakSpectrum");

                IDrawing drawing;
                IClientAnchor anchor3;
                for (int j = 0; j < particles.Rows.Count; j++)
                {
                    row = sheet3.CreateRow(j + 2);
                    row.Height = 120 * 20;
                    cell = row.CreateCell(0);
                    cell.CellStyle = cellStyle;
                    cell.SetCellValue(j + 1);
                    cell = row.CreateCell(1);
                    cell = row.CreateCell(2);
                    cell = row.CreateCell(3);
                    drawing = sheet3.CreateDrawingPatriarch();
                    //锚点
                    anchor3 = drawing.CreateAnchor(0, 0, 0, 0, 1, j + 2, 2, j + 3);//XSSFClientAnchor(dx1,dy1,dx2,dy2,col1,row1,col2,row2);参数说明:dx1 dy1 起始单元格中的x,y坐标.dx2 dy2 结束单元格中的x,y坐标col1, row1 指定起始的单元格，下标从0开始col2, row2 指定结束的单元格，下标从0开始
                    CreateChart(drawing, sheet2, anchor3, j + 2);
                }
                //row = sheet3.CreateRow(2);
                //row.Height = 120 * 20;
                //cell = row.CreateCell(0);
                //cell.CellStyle = cellStyle;
                //cell.SetCellValue(1);
                //cell = row.CreateCell(1);
                //cell = row.CreateCell(2);
                //cell = row.CreateCell(3);

                //drawing = sheet3.CreateDrawingPatriarch();
                ////锚点
                //anchor3 = drawing.CreateAnchor(0, 0, 0, 0, 1, 2, 2, 3);//XSSFClientAnchor(dx1,dy1,dx2,dy2,col1,row1,col2,row2);参数说明:dx1 dy1 起始单元格中的x,y坐标.dx2 dy2 结束单元格中的x,y坐标col1, row1 指定起始的单元格，下标从0开始col2, row2 指定结束的单元格，下标从0开始
                //CreateChart(drawing, sheet2, anchor3, 2);

                //row = sheet3.CreateRow(3);
                //row.Height = 120 * 20;
                //cell = row.CreateCell(0);
                //cell.CellStyle = cellStyle;
                //cell.SetCellValue(1);
                //cell = row.CreateCell(1);
                //cell = row.CreateCell(2);
                //cell = row.CreateCell(3);

                //drawing = sheet3.CreateDrawingPatriarch();
                ////锚点
                //anchor3 = drawing.CreateAnchor(0, 0, 0, 0, 1, 3, 2, 4);//XSSFClientAnchor(dx1,dy1,dx2,dy2,col1,row1,col2,row2);参数说明:dx1 dy1 起始单元格中的x,y坐标.dx2 dy2 结束单元格中的x,y坐标col1, row1 指定起始的单元格，下标从0开始col2, row2 指定结束的单元格，下标从0开始
                //CreateChart(drawing, sheet2, anchor3, 3);

                //完成后，对Excel进行保存
                FileStream file = new FileStream(sfd.FileName, FileMode.Create);
                workbook.Write(file);
                file.Close();

                MessageBox.Show("Export complete!");

                //导出完成后，打开Excel文件
                if (File.Exists(sfd.FileName))
                {
                    //打开刚才导出的文件
                    System.Diagnostics.Process.Start(sfd.FileName);
                }

                // 生成一个 单元格 对象 HSSFCell cellTableName = CreateCell(sheetTableIndex, t + 1, 0, strTableName, true); 
                //创建一个超链接对象 HSSFHyperlink link = new HSSFHyperlink(HSSFHyperlink.LINK_DOCUMENT); 
                // strTableName 这个参数为 sheet名字 A1 为单元格 其他是固定格式 link.Address = "#" + strTableName + "!A1"; 
                //设置 cellTableName 单元格 的连接对象 cellTableName.Hyperlink = link;



            }
        }

        void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, int rowid)
        {
            var chart = drawing.CreateChart(anchor) as XSSFChart;
            // 创建图形注释的位置
            //var legend = chart.GetOrCreateLegend();
            //legend.Position = LegendPosition.Top;


            //图表
            var data = chart.ChartDataFactory.CreateLineChartData<double, double>(); //折线图

            IChartAxis bottomAxis = chart.ChartAxisFactory.CreateCategoryAxis(AxisPosition.Bottom);
            
            IValueAxis leftAxis = chart.ChartAxisFactory.CreateValueAxis(AxisPosition.Left);
            leftAxis.Crosses=AxisCrosses.AutoZero;
            leftAxis.IsVisible = true;
            bottomAxis.IsVisible = true;
            //数据源
            IChartDataSource<double> ys = DataSources.FromNumericCellRange(sheet, new CellRangeAddress(rowid, rowid, 1, 2001));

            Double[] doubles = new Double[2000];
            for (int i = 0; i < 2000; i++)
            {
                doubles[i] = i;
            }
            IChartDataSource<double> xs = DataSources.FromArray(doubles);
            //IChartDataSource<double> ys = DataSources.FromArray(doubles);

            //数据系列
            var s1 = data.AddSeries(xs, ys);

            // 开始绘制折线图
            chart.Plot(data, bottomAxis, leftAxis);

        }
        /// <summary>
        /// 将image转成bytes
        /// </summary>
        /// <param name="in_img"></param>
        /// <returns></returns>
        public byte[] ImageConvertToBytes(System.Drawing.Image in_img)
        {
            MemoryStream ms = new MemoryStream();
            in_img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
            return ms.ToArray();
        }

        public bool CheckParamExist<T>(T Param)
        {
            if (Param == null)
            {
                return false;
            }
            else
            {
                return true;
            }
        }



        private void ToolStripMenuItem_Delete_Particle_Click(object sender, EventArgs e)
        {
            string path = result.FilePath;
            ParticleData fielddata = new ParticleData(result.FilePath);
            List<Particle> particles = fielddata.GetParticleAllList();

            List<Particle> ls_list_cotsparticleclr = new List<Particle>();
            for (int l = 0; l < dgV_ParticlesDevidePage.SelectedRows.Count; l++)
            {
                //从事先加载的Bitmap对象的Tag中取出List<string>
                DataGridViewRow dgvr = dgV_ParticlesDevidePage.SelectedRows[l];
                Bitmap ls_bp = (Bitmap)dgvr.Cells[2].Value;
                List<string> list_str = (List<string>)ls_bp.Tag;
                if (list_str != null)
                {
                    int i_ls_fieldid = Convert.ToInt32(list_str[0]);
                    int i_ls_particleid = Convert.ToInt32(list_str[1]);
                    foreach (Particle item in particles)
                    {
                        if (i_ls_fieldid == item.FieldId && i_ls_particleid == item.ParticleId)
                        {
                            if (ReportFun.DeleteParticlesFromLibrary(item.ParticleId, item.FieldId))
                            {
                                MessageBox.Show("Deleted successfully");

                                for (int i = 0; i < particlesAll.Rows.Count; i++)
                                {
                                    if (particlesAll.Rows[i]["Fieldid"].ToString() == item.FieldId.ToString() && particlesAll.Rows[i]["Particleid"].ToString() == item.ParticleId.ToString())
                                    {
                                        particlesAll.Rows.RemoveAt(i);
                                    }
                                }

                                DisplayData();

                            }
                            else
                            {
                                MessageBox.Show("Delete failed");
                            }
                            break;
                        }
                    }

                }
            }
        }


        #region 将DataTable中的数据写到Excel的指定Sheet中
        /// <summary>
        /// 将DataTable中的数据写到Excel的指定Sheet中
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="m_Sheet"></param>
        public void DataTableToSheet(string title, DataTable dt, Microsoft.Office.Interop.Excel._Worksheet m_Sheet,
                                    Microsoft.Office.Interop.Excel._Workbook m_Book, int startrow)
        {

            //以下是填写EXCEL中数据
            Microsoft.Office.Interop.Excel.Range range = m_Sheet.get_Range(m_Sheet.Cells[1, 1], m_Sheet.Cells[1, 2]);
            range.MergeCells = true;  //合并单元格
            range.Font.Bold = true;   //加粗单元格内字符
            //写入题目
            m_Sheet.Cells[startrow, startrow] = title;
            int rownum = dt.Rows.Count;//行数
            int columnnum = dt.Columns.Count;//列数
            int num = rownum + 2;   //得到数据中的最大行数


            //写入列标题
            for (int j = 0; j < columnnum; j++)
            {
                int bt_startrow = startrow + 1;

                //将字段名写入文档
                m_Sheet.Cells[bt_startrow, 1 + j] = dt.Columns[j].ColumnName;

                //单元格内背景色
                m_Sheet.get_Range(m_Sheet.Cells[bt_startrow, 1 + j], m_Sheet.Cells[bt_startrow, 1 + j]).Interior.ColorIndex = 15;
            }


            //逐行写入数据
            for (int i = 0; i < rownum; i++)
            {
                for (int j = 0; j < columnnum; j++)
                {
                    m_Sheet.Cells[startrow + 2 + i, 1 + j] = dt.Rows[i][j].ToString();
                }
            }
            m_Sheet.Columns.AutoFit();



            //在当前工作表中根据数据生成图表

            CreateChart(m_Book, m_Sheet, num);
        }
        private void CreateChart(Microsoft.Office.Interop.Excel._Workbook m_Book, Microsoft.Office.Interop.Excel._Worksheet m_Sheet, int num)
        {
            Microsoft.Office.Interop.Excel.Range oResizeRange;
            Microsoft.Office.Interop.Excel.Series oSeries;

            m_Book.Charts.Add(Missing.Value, Missing.Value, 1, Missing.Value);
            m_Book.ActiveChart.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlLine;//设置图形

            //设置数据取值范围
            m_Book.ActiveChart.SetSourceData(m_Sheet.get_Range("A2", "C" + num.ToString()), Microsoft.Office.Interop.Excel.XlRowCol.xlColumns);
            //m_Book.ActiveChart.Location(Microsoft.Office.Interop.Excel.XlChartLocation.xlLocationAutomatic, title);
            //以下是给图表放在指定位置
            m_Book.ActiveChart.Location(Microsoft.Office.Interop.Excel.XlChartLocation.xlLocationAsObject, m_Sheet.Name);
            oResizeRange = (Microsoft.Office.Interop.Excel.Range)m_Sheet.Rows.get_Item(10, Missing.Value);
            m_Sheet.Shapes.Item("Chart 1").Top = (float)(double)oResizeRange.Top;  //调图表的位置上边距
            oResizeRange = (Microsoft.Office.Interop.Excel.Range)m_Sheet.Columns.get_Item(6, Missing.Value);  //调图表的位置左边距
                                                                                                              // m_Sheet.Shapes.Item("Chart 1").Left = (float)(double)oResizeRange.Left;
            m_Sheet.Shapes.Item("Chart 1").Width = 400;   //调图表的宽度
            m_Sheet.Shapes.Item("Chart 1").Height = 250;  //调图表的高度

            m_Book.ActiveChart.PlotArea.Interior.ColorIndex = 19;  //设置绘图区的背景色
            m_Book.ActiveChart.PlotArea.Border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlLineStyleNone;//设置绘图区边框线条
            m_Book.ActiveChart.PlotArea.Width = 400;   //设置绘图区宽度
            //m_Book.ActiveChart.ChartArea.Interior.ColorIndex = 10; //设置整个图表的背影颜色
            //m_Book.ActiveChart.ChartArea.Border.ColorIndex = 8;// 设置整个图表的边框颜色
            m_Book.ActiveChart.ChartArea.Border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlLineStyleNone;//设置边框线条
            m_Book.ActiveChart.HasDataTable = false;


            //设置Legend图例的位置和格式
            m_Book.ActiveChart.Legend.Top = 20.00; //具体设置图例的上边距
            m_Book.ActiveChart.Legend.Left = 60.00;//具体设置图例的左边距
            m_Book.ActiveChart.Legend.Interior.ColorIndex = Microsoft.Office.Interop.Excel.XlColorIndex.xlColorIndexNone;
            m_Book.ActiveChart.Legend.Width = 150;
            m_Book.ActiveChart.Legend.Font.Size = 9.5;
            //m_Book.ActiveChart.Legend.Font.Bold = true;
            m_Book.ActiveChart.Legend.Font.Name = "宋体";
            //m_Book.ActiveChart.Legend.Position = Microsoft.Office.Interop.Excel.XlLegendPosition.xlLegendPositionTop;//设置图例的位置
            m_Book.ActiveChart.Legend.Border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlLineStyleNone;//设置图例边框线条



            //设置X轴的显示
            Microsoft.Office.Interop.Excel.Axis xAxis = (Microsoft.Office.Interop.Excel.Axis)m_Book.ActiveChart.Axes(Microsoft.Office.Interop.Excel.XlAxisType.xlValue, Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary);
            xAxis.MajorGridlines.Border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlDot;
            xAxis.MajorGridlines.Border.ColorIndex = 1;//gridLine横向线条的颜色
            xAxis.HasTitle = false;
            xAxis.MinimumScale = 1500;
            xAxis.MaximumScale = 6000;
            xAxis.TickLabels.Font.Name = "宋体";
            xAxis.TickLabels.Font.Size = 9;



            //设置Y轴的显示
            Microsoft.Office.Interop.Excel.Axis yAxis = (Microsoft.Office.Interop.Excel.Axis)m_Book.ActiveChart.Axes(Microsoft.Office.Interop.Excel.XlAxisType.xlCategory, Microsoft.Office.Interop.Excel.XlAxisGroup.xlPrimary);
            yAxis.TickLabelSpacing = 30;
            yAxis.TickLabels.NumberFormat = "M月D日";
            yAxis.TickLabels.Orientation = Microsoft.Office.Interop.Excel.XlTickLabelOrientation.xlTickLabelOrientationHorizontal;//Y轴显示的方向,是水平还是垂直等
            yAxis.TickLabels.Font.Size = 8;
            yAxis.TickLabels.Font.Name = "宋体";

            //m_Book.ActiveChart.Floor.Interior.ColorIndex = 8;
            /***以下是设置标题*****
            m_Book.ActiveChart.HasTitle=true;
            m_Book.ActiveChart.ChartTitle.Text = "净值指数";
            m_Book.ActiveChart.ChartTitle.Shadow = true;
            m_Book.ActiveChart.ChartTitle.Border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
            */

            oSeries = (Microsoft.Office.Interop.Excel.Series)m_Book.ActiveChart.SeriesCollection(1);
            oSeries.Border.ColorIndex = 45;
            oSeries.Border.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThick;
            oSeries = (Microsoft.Office.Interop.Excel.Series)m_Book.ActiveChart.SeriesCollection(2);
            oSeries.Border.ColorIndex = 9;
            oSeries.Border.Weight = Microsoft.Office.Interop.Excel.XlBorderWeight.xlThick;

        }

        #endregion
    }




}