示例#1
0
        //列表
        public static DataTable CreateViewReport(string _selCol, string _strTestSampleNo, int ab)
        {
            BLL.Compress bllts = new HR_Test.BLL.Compress();
            DataSet      dst   = bllts.GetFinishListReport(_selCol, " testSampleNo in ('" + _strTestSampleNo + ") and isFinish=true  and  isEffective=false ", ab);

            return(dst.Tables[0]);
        }
示例#2
0
        //列表
        public static DataTable CreateView(string _selCol, string _strTestNo, int ab)
        {
            BLL.Compress bllts = new HR_Test.BLL.Compress();
            DataSet      dst   = bllts.GetFinishList1(_selCol, " testNo = '" + _strTestNo + "' and isFinish=true", ab);

            return(dst.Tables[0]);
        }
示例#3
0
        private static List <TreeNode> ReadGBT7314Samples(DateTime dtp)
        {
            BLL.Compress    bllC  = new HR_Test.BLL.Compress();
            DataSet         dsc   = bllC.GetNotOverlapList(" testDate = #" + dtp.Date + "#");
            int             count = dsc.Tables[0].Rows.Count;
            List <TreeNode> ltn   = new List <TreeNode>();

            for (int j = 0; j < count; j++)
            {
                DataSet  _dsc = bllC.GetList(" testNo='" + dsc.Tables[0].Rows[j]["testNo"].ToString() + "' and testDate=#" + dtp.Date + "#");
                TreeNode tn   = new TreeNode();
                tn.Text       = dsc.Tables[0].Rows[j]["testNo"].ToString();
                tn.Name       = "GBT7314-2005";
                tn.ImageIndex = 0;
                foreach (DataRow dr in _dsc.Tables[0].Rows)
                {
                    if (Convert.ToBoolean(dr["isFinish"].ToString()) == true)
                    {
                        //左侧node完成试验的图标
                        TreeNode ftn = new TreeNode();
                        ftn.ImageIndex = 1;
                        ftn.Text       = dr["testSampleNo"].ToString();
                        ftn.Name       = "GBT7314-2005_c";
                        ftn.Tag        = dr;
                        tn.Nodes.Add(ftn);
                    }
                    else
                    {
                        //左侧node未完成试验的图标
                        TreeNode ftn = new TreeNode();
                        ftn.ImageIndex = 2;
                        ftn.Text       = dr["testSampleNo"].ToString();
                        ftn.Name       = "GBT7314-2005_c";
                        ftn.Tag        = dr;
                        tn.Nodes.Add(ftn);
                    }
                }
                _dsc.Dispose();
                ltn.Add(tn);
            }
            dsc.Dispose();
            return(ltn);
        }
示例#4
0
        private void gBtnAddC_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.c_testNo.Text.Trim().Length == 0)
            {
                strErr += "试验编号不能为空!\r\n\r\n";
            }
            if (this.c_testSampleNo.Text.Trim().Length == 0)
            {
                strErr += "试样编号不能为空!\r\n\r\n";
            }

            if (this._sendCompany.Length == 0)
            {
                strErr += "送检单位不能为空!\r\n\r\n";
            }
            if (this.c_stuffCardNo.Text.Trim().Length == 0)
            {
                strErr += "材料牌号不能为空!\r\n\r\n";
            }
            if (this.c_stuffSpec.Text.Trim().Length == 0)
            {
                strErr += "材料规格不能为空!\r\n\r\n";
            }
            if (this.c_stuffType.Text.Trim().Length == 0)
            {
                strErr += "试样类型不能为空!\r\n\r\n";
            }

            if (this._temperature.Trim().Length == 0)
            {
                strErr += "试验温度不能为空!\r\n\r\n";
            }

            if (this._condition.Trim().Length == 0)
            {
                strErr += "试验条件不能为空!\r\n\r\n";
            }

            if (this._controlMode.Trim().Length == 0)
            {
                strErr += "控制方式不能为空!\r\n\r\n";
            }

            if (this._testStandard_C.Text.Trim().Length == 0)
            {
                strErr += "试验标准不能为空!\r\n\r\n";
            }

            if (this._sampleCharacter.Trim().Length == 0)
            {
                strErr += "试样标识不能为空!\r\n\r\n";
            }
            if (this.c_getSample.Text.Trim().Length == 0)
            {
                strErr += "试样取样不能为空!\r\n\r\n";
            }
            if (this.c_tester.Text.Trim().Length == 0)
            {
                strErr += "试验员不能为空!\r\n\r\n";
            }

            if (rBtnRect.Checked)
            {
                if (this.c_a.Text.Trim().Length == 0)
                {
                    strErr += "a不能为空!\r\n\r\n";
                }
                if (this.c_b.Text.Trim().Length == 0)
                {
                    strErr += "b不能为空!\r\n\r\n";
                }
            }

            if (rBtnCircle.Checked)
            {
                if (this.c_d.Text.Trim().Length == 0)
                {
                    strErr += "d不能为空!\r\n\r\n";
                }
            }

            if (this.c_S0.Text.Trim().Length == 0)
            {
                strErr += "S0不能为空!\r\n\r\n";
            }
            else
            {
                if (double.Parse(this.c_S0.Text.Trim()) == 0d)
                {
                    strErr += "S0不能为0!\r\n\r\n";
                }
            }

            if (this.c_L0.Text.Trim().Length == 0)
            {
                strErr += " L0不能为空!\r\n\r\n";
            }
            else
            {
                if (double.Parse(this.c_L0.Text.Trim()) == 0d)
                {
                    strErr += " L0不能为0!\r\n\r\n";
                }
            }

            if (this.Epc.Text.Trim().Length == 0)
            {
                strErr += "εpc 不能为空!\r\n\r\n";
            }
            else
            {
                if (double.Parse(this.Epc.Text.Trim()) == 0d)
                {
                    strErr += " εpc 不能为0!\r\n\r\n";
                }
            }

            if (this.Etc.Text.Trim().Length == 0)
            {
                strErr += "εtc 不能为空!\r\n\r\n";
            }
            else
            {
                if (double.Parse(this.Etc.Text.Trim()) == 0d)
                {
                    strErr += " εtc 不能为0!\r\n\r\n";
                }
            }

            if (this.txtn.Text.Trim().Length == 0)
            {
                strErr += "变形放大倍数 n 不能为空!\r\n\r\n";
            }
            else
            {
                if (double.Parse(this.txtn.Text.Trim()) == 0d)
                {
                    strErr += " 变形放大倍数 n 不能为0!\r\n\r\n";
                }
            }

            if (this.c_L.Text.Trim().Length == 0)
            {
                strErr += " L不能为空!\r\n\r\n";
            }


            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }

            HR_Test.Model.Compress model = new HR_Test.Model.Compress();
            model.testMethodName = this.c_testMethod.Text;
            model.testNo         = this.c_testNo.Text;
            model.testSampleNo   = this.c_testSampleNo.Text;
            model.reportNo       = "-";

            model.sendCompany     = this._sampleCharacter;
            model.temperature     = double.Parse(this._temperature);
            model.humidity        = double.Parse(this._humidity);
            model.testStandard    = this._testStandard_C.Text;
            model.sampleCharacter = this._sampleCharacter;
            model.hotStatus       = this._hotStatus;
            model.condition       = this._condition;
            model.controlMode     = this._controlMode;


            model.stuffCardNo   = this.c_stuffCardNo.Text;
            model.stuffSpec     = c_stuffSpec.Text;
            model.stuffType     = c_stuffType.Text;
            model.testMethod    = c_testMethod.Text;
            model.mathineType   = c_mathineType.Text;
            model.testCondition = "-";

            model.getSample = c_getSample.Text;
            model.tester    = c_tester.Text;
            model.assessor  = "-";
            model.sign      = this.c_sign.Text;

            model.a           = Convert.ToDouble(!string.IsNullOrEmpty(this.c_a.Text) ? this.c_a.Text : "0");
            model.b           = Convert.ToDouble(!string.IsNullOrEmpty(this.c_b.Text) ? this.c_b.Text : "0");
            model.d           = Convert.ToDouble(!string.IsNullOrEmpty(this.c_d.Text) ? this.c_d.Text : "0");
            model.L           = Convert.ToDouble(!string.IsNullOrEmpty(this.c_L.Text) ? this.c_L.Text : "0");
            model.L0          = Convert.ToDouble(!string.IsNullOrEmpty(this.c_L0.Text) ? this.c_L0.Text : "0");
            model.H           = Convert.ToDouble(!string.IsNullOrEmpty(this.c_HH.Text) ? this.c_HH.Text : "0");
            model.hh          = Convert.ToDouble(!string.IsNullOrEmpty(this.c_h.Text) ? this.c_h.Text : "0");
            model.S0          = Convert.ToDouble(!string.IsNullOrEmpty(this.c_S0.Text) ? this.c_S0.Text : "0");
            model.Ff          = Convert.ToDouble(!string.IsNullOrEmpty(this.c_Ff.Text) ? this.c_Ff.Text : "0");
            model.εpc         = Convert.ToDouble(!string.IsNullOrEmpty(this.Epc.Text) ? this.Epc.Text : "0");
            model.εtc         = Convert.ToDouble(!string.IsNullOrEmpty(this.Etc.Text) ? this.Etc.Text : "0");
            model.n           = Convert.ToDouble(!string.IsNullOrEmpty(this.txtn.Text) ? this.txtn.Text : "1");
            model.deltaL      = 0;
            model.F0          = 0;
            model.Fpc         = 0;
            model.Ftc         = 0;
            model.FeHc        = 0;
            model.FeLc        = 0;
            model.Fmc         = 0;
            model.Rpc         = 0;
            model.Rtc         = 0;
            model.ReHc        = 0;
            model.ReLc        = 0;
            model.Rmc         = 0;
            model.Ec          = 0;
            model.Avera       = 0;
            model.Avera1      = 0;
            model.isFinish    = false;
            model.isEffective = false;
            model.testDate    = this.c_testDate.Value.Date;
            BLL.Compress bllc = new HR_Test.BLL.Compress();
            if (bllc.GetList("testSampleNo ='" + this.c_testSampleNo.Text + "'").Tables[0].Rows.Count == 0)
            {
                if (bllc.Add(model))
                {
                    this.c_testSampleNo.Items.Remove(this.c_testSampleNo.SelectedItem);
                    //this.c_a.Text = "";
                    //this.c_b.Text = "";
                    //this.c_d.Text = "";
                    //this.c_S0.Text = "";
                    MessageBox.Show("添加压缩试样信息成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("添加压缩试样信息失败!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                MessageBox.Show("已经存在相同的编号,请重新设置!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //TestStandard.MethodControl.ReadMethod(this.treeviewTestMethod);
        }
示例#5
0
        //查询结果
        public static void ReadGBT7314(DataGridView dg, string testNo, string testSampleNo, DateTimePicker dtpFrom, DateTimePicker dtpTo, ZedGraph.ZedGraphControl zed)
        {
            BLL.Compress bllTs    = new HR_Test.BLL.Compress();
            string       strWhere = string.Empty;

            if (!string.IsNullOrEmpty(testNo))
            {
                strWhere += " and testNo like '%" + testNo + "%'";
            }

            if (!string.IsNullOrEmpty(testSampleNo))
            {
                strWhere += " and testSampleNo like '%" + testSampleNo + "%'";
            }

            double  maxValue = 0;
            DataSet dsmax    = bllTs.GetMaxFmc("isFinish=true and isEffective=false and testDate>=#" + dtpFrom.Value.Date + "# and testDate<=#" + dtpTo.Value.Date + "#" + strWhere);

            if (dsmax != null)
            {
                if (dsmax.Tables[0].Rows.Count > 0)
                {
                    if (!string.IsNullOrEmpty(dsmax.Tables[0].Rows[0]["Fmc"].ToString()))
                    {
                        maxValue = Convert.ToDouble(dsmax.Tables[0].Rows[0]["Fmc"].ToString());
                    }
                }
            }

            DataSet   ds = bllTs.GetFinishList("isFinish=true and isEffective=false and testDate>=#" + dtpFrom.Value.Date + "# and testDate<=#" + dtpTo.Value.Date + "#" + strWhere, maxValue);
            DataTable dt = ds.Tables[0];

            dg.DataSource = dt;

            DataGridViewCheckBoxColumn chkcol = new DataGridViewCheckBoxColumn();

            //DataGridViewDisableCheckBoxColumn chkcol = new DataGridViewDisableCheckBoxColumn();
            chkcol.Name = "选择";

            DataGridViewTextBoxColumn c = new DataGridViewTextBoxColumn();

            c.Visible = true;
            c.Name    = "  ";
            dg.Columns.Insert(0, c);
            dg.Columns.Insert(0, chkcol);

            dg.Columns[1].Frozen = true;
            dg.Columns[2].Frozen = true;

            //dg.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.DisplayedCells);
            dg.Columns[0].Width = 50;
            dg.Columns[1].Width = 50;
            dg.Columns[2].Width = 100;
            if (dg.ColumnCount > 0)
            {
                foreach (DataGridViewColumn dgvc in dg.Columns)
                {
                    dgvc.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                    dgvc.SortMode     = DataGridViewColumnSortMode.NotSortable;
                    dgvc.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
            }
            dg.Refresh();

            for (int i = 0; i < dg.Rows.Count; i++)
            {
                if (i > 19)
                {
                    dg.Rows[i].Cells[1].Style.BackColor          = Color.FromName(_Color_Array[i % 20]);
                    dg.Rows[i].Cells[1].Style.ForeColor          = Color.FromName(_Color_Array[i % 20]);
                    dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i % 20]);
                    dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i % 20]);
                    dg.Rows[i].Cells[1].Value = _Color_Array[i % 20].ToString();
                }
                else
                {
                    dg.Rows[i].Cells[1].Style.BackColor          = Color.FromName(_Color_Array[i]);
                    dg.Rows[i].Cells[1].Style.ForeColor          = Color.FromName(_Color_Array[i]);
                    dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i]);
                    dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i]);
                    dg.Rows[i].Cells[1].Value = _Color_Array[i].ToString();
                }
            }

            foreach (CurveItem ci in zed.GraphPane.CurveList)
            {
                ci.Clear();
                ci.Label.Text = "";
            }

            zed.AxisChange();
            zed.Refresh();
            ds.Dispose();
        }
示例#6
0
        //求取平均值 X~,S,V
        public static DataTable CreateAverageViewReport(StringBuilder _selCol, StringBuilder _selSqlAver, string _strTestSampleNo, int ab)
        {
            BLL.Compress bllts = new HR_Test.BLL.Compress();
            //求平均
            DataSet dsaver = bllts.GetFinishSumList1(_selSqlAver.ToString(), " testSampleNo in ('" + _strTestSampleNo + ") and isFinish=true  and  isEffective=false ");

            //获取选择试样的数量和试样编号

            string  selCol   = _selCol.ToString();
            DataSet dsfinish = bllts.GetFinishList1(selCol.ToString(), " testSampleNo in ('" + _strTestSampleNo + ") and isFinish=true  and  isEffective=false ", ab);

            int fcount = dsfinish.Tables[0].Rows.Count;

            //变异系数 = sd/mean
            StringBuilder strCV = new StringBuilder();
            //中间值
            StringBuilder strMid = new StringBuilder();

            //创建新的数据计算结果表
            DataSet dsaverto = new DataSet();

            dsaverto.Tables.Add();
            dsaverto.Tables[0].Columns.Add("数量(" + fcount + ")").SetOrdinal(0);
            for (int i = 0; i < dsaver.Tables[0].Columns.Count; i++)
            {
                dsaverto.Tables[0].Columns.Add(dsaver.Tables[0].Columns[i].Caption).SetOrdinal(i + 1);
            }
            //给新数据表添加平均值列
            List <object> objmean = new List <object>();

            objmean.Add("Mean.:");
            for (int i = 0; i < dsaver.Tables[0].Columns.Count; i++)
            {
                if (double.Parse(dsaver.Tables[0].Rows[0][i].ToString()) != 0)
                {
                    objmean.Add(dsaver.Tables[0].Rows[0][i].ToString());
                }
                else
                {
                    objmean.Add("-");
                }
            }
            dsaverto.Tables[0].Rows.Add(objmean.ToArray());

            double sumsd = 0;
            double sd    = 0;
            double cv    = 0;
            double ctrue = 0;
            double caver = 0;
            double temp  = double.MaxValue;
            double mid   = 0;

            List <object> objsd = new List <object>();

            objsd.Add("S.D.:");
            List <object> objcv = new List <object>();

            objcv.Add("C.V.:");
            List <object> objmid = new List <object>();

            objmid.Add("Mid.:");

            //计算标准偏差
            for (int i = 0; i < dsaver.Tables[0].Columns.Count; i++)
            {
                for (int j = 0; j < dsfinish.Tables[0].Rows.Count; j++)
                {
                    //  求和 (真实值-平均值)^2
                    if (ab == 1)
                    {
                        ctrue = Convert.ToDouble(dsfinish.Tables[0].Rows[j][i + 4].ToString());
                    }
                    if (ab == 2)
                    {
                        ctrue = Convert.ToDouble(dsfinish.Tables[0].Rows[j][i + 3].ToString());
                    }
                    caver = Convert.ToDouble(dsaver.Tables[0].Rows[0][i].ToString());
                    double c1 = (ctrue - caver) * (ctrue - caver);
                    sumsd += c1;
                    //查找中间值,最接近平均值的
                    double d_value = Math.Abs(ctrue - caver);
                    if (d_value < temp)
                    {
                        temp = d_value;
                        mid  = ctrue;
                    }
                }
                //标准偏差
                if (fcount - 1 != 0)
                {
                    sd = Math.Sqrt(sumsd / (fcount - 1));
                }
                else
                {
                    sd = 0;
                }

                //变异系数 =( 标准偏差 / 平均值 ) *100
                if (caver != 0)
                {
                    cv = (sd / caver) * 100;
                }
                else
                {
                    cv = 0;
                }

                if (sd != 0)
                {
                    objsd.Add(sd.ToString("f4"));
                }
                else
                {
                    objsd.Add("-");
                }
                if (cv != 0)
                {
                    objcv.Add(cv.ToString("f4"));
                }
                else
                {
                    objcv.Add("-");
                }
                if (mid != 0)
                {
                    objmid.Add(mid.ToString("f4"));
                }
                else
                {
                    objmid.Add("-");
                }

                temp  = double.MaxValue;
                sumsd = 0;
            }

            //S.D.标准偏差行
            if (_isSelSD)
            {
                dsaverto.Tables[0].Rows.Add(objsd.ToArray());
            }
            //变异系数行
            if (_isSelCV)
            {
                dsaverto.Tables[0].Rows.Add(objcv.ToArray());
            }
            //中间值行
            if (_isSelMid)
            {
                dsaverto.Tables[0].Rows.Add(objmid.ToArray());
            }

            dsfinish.Dispose();
            return(dsaverto.Tables[0]);
        }
示例#7
0
        public static void readFinishSample(DataGridView dg, DataGridView dgSum, string testNo, DateTimePicker dtp, ZedGraph.ZedGraphControl zed)
        {
            //try
            //{
            //dg.MultiSelect = true;
            if (dg != null)
            {
                dg.DataSource = null;
                dg.Columns.Clear();
                dg.RowHeadersVisible = false;
            }
            BLL.Compress bllTs = new HR_Test.BLL.Compress();

            if (!string.IsNullOrEmpty(testNo))
            {
                //if (testNo.Contains('-'))
                //    testNo = testNo.Substring(0, testNo.LastIndexOf("-"));
                //获取不重复的试验编号列表
                DataSet ds       = bllTs.GetNotOverlapList(" testNo='" + testNo + "' and testDate =#" + dtp.Value.Date + "#");
                DataSet dsMax    = bllTs.GetMaxFmc(" testNo='" + testNo + "' and isEffective=false and testDate =#" + dtp.Value.Date + "#");
                double  maxValue = 0;
                if (dsMax != null)
                {
                    if (!string.IsNullOrEmpty(dsMax.Tables[0].Rows[0]["Fmc"].ToString()))
                    {
                        maxValue = Convert.ToDouble(dsMax.Tables[0].Rows[0]["Fmc"].ToString());
                    }
                }


                DataTable dt = ds.Tables[0];
                int       ab = 0;
                if (dt != null)
                {
                    //矩形
                    if (dt.Rows[0]["a"].ToString() != "0")
                    {
                        ab = 1;
                    }
                    //圆柱形
                    if (dt.Rows[0]["d"].ToString() != "0")
                    {
                        ab = 2;
                    }
                }

                DataSet   ds1        = bllTs.GetNotOverlapList1(" testNo='" + testNo + "' and testDate =#" + dtp.Value.Date + "#");
                DataTable dt1        = ds1.Tables[0];
                string    methodName = dt1.Rows[0]["testMethodName"].ToString();
                if (dt1 != null)
                {
                    StringBuilder[] tst = strSql_T(methodName, maxValue);
                    if (!string.IsNullOrEmpty(tst[0].ToString()) && dg != null)
                    {
                        dg.DataSource = CreateView(tst[0].ToString(), dt1.Rows[0]["testNo"].ToString(), ab);
                    }
                    if (!string.IsNullOrEmpty(tst[1].ToString()))
                    {
                        dgSum.DataSource = CreateAverageView(tst[0], tst[1], dt1.Rows[0]["testNo"].ToString(), ab);
                    }
                }
            }
            else
            {
                DataSet   ds = bllTs.GetFinishList(" testNo='" + testNo + "' and testDate=#" + dtp.Value.Date + "#", 0);
                DataTable dt = ds.Tables[0];
                DataRow   dr = dt.NewRow();
                dt.Rows.Add(dr);
                if (dg != null)
                {
                    dg.DataSource = dt;
                }
                ds.Dispose();
            }


            //DataGridViewDisableCheckBoxColumn chkcol = new DataGridViewDisableCheckBoxColumn();
            DataGridViewCheckBoxColumn chkcol = new DataGridViewCheckBoxColumn();

            chkcol.Name         = "选择";
            chkcol.MinimumWidth = 50;
            chkcol.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

            DataGridViewTextBoxColumn c = new DataGridViewTextBoxColumn();

            c.Name = "";
            if (dg != null)
            {
                dg.Columns.Insert(0, chkcol);
                dg.Columns.Insert(1, c);
                dg.Name = "tensile";

                //dg.Rows[0].Cells[0].Value = false;
                //dg.Rows[0].Cells[0].Selected = false;
                int rCount = dg.Rows.Count;
                for (int i = 0; i < rCount; i++)
                {
                    if (!string.IsNullOrEmpty(dg.Rows[i].Cells[2].Value.ToString()))
                    {
                        if (Convert.ToBoolean(dg.Rows[i].Cells[2].Value.ToString()) == true)
                        {
                            dg.Rows[i].DefaultCellStyle.BackColor = Color.IndianRed;
                        }
                    }
                    if (i > 19)
                    {
                        dg.Rows[i].Cells[1].Style.BackColor          = Color.FromName(_Color_Array[i % 20]);
                        dg.Rows[i].Cells[1].Style.ForeColor          = Color.FromName(_Color_Array[i % 20]);
                        dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i % 20]);
                        dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i % 20]);
                        dg.Rows[i].Cells[1].Value = _Color_Array[i % 20].ToString();
                    }
                    else
                    {
                        dg.Rows[i].Cells[1].Style.BackColor          = Color.FromName(_Color_Array[i]);
                        dg.Rows[i].Cells[1].Style.ForeColor          = Color.FromName(_Color_Array[i]);
                        dg.Rows[i].Cells[1].Style.SelectionBackColor = Color.FromName(_Color_Array[i]);
                        dg.Rows[i].Cells[1].Style.SelectionForeColor = Color.FromName(_Color_Array[i]);
                        dg.Rows[i].Cells[1].Value = _Color_Array[i].ToString();
                    }
                }


                foreach (DataGridViewColumn dgvc in dg.Columns)
                {
                    dgvc.SortMode = DataGridViewColumnSortMode.NotSortable;
                    dgvc.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
                }
                if (dg.Columns.Count > 1)
                {
                    dg.Columns[0].Frozen = true;
                    dg.Columns[1].Frozen = true;
                    dg.Columns[1].Width  = 10;
                }
                if (dg.Columns.Count > 2)
                {
                    dg.Columns[2].Frozen = true;
                }
                dg.Refresh();
            }

            //clear all curves

            if (zed != null)
            {
                foreach (CurveItem ci in zed.GraphPane.CurveList)
                {
                    ci.Clear();
                    ci.Label.Text = "";
                }
                zed.AxisChange();
                zed.Refresh();
            }
            //}
            //catch (Exception ee) { throw ee; }
        }