MES_Client/TGMES/Core.StlMes.Client.ZGMil/ResultConrtrol/CrackDetectionResult.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinDataSource;
using Infragistics.Win;
using com.steering.mes.zgmil.entity;
using System.Collections;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.NodeResultQuery;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;

namespace Core.StlMes.Client.ZGMil.ResultConrtrol
{
    public partial class CrackDetectionResult : UserControl
    {
        public OpeBase ob;
        public CrackDetectionResult()
        {
            //this.IsCellSelect = false;
            InitializeComponent();
            GridHelper.InitCardGrid(TestingDataSource, ultraGrid3);
            _grid = this.ultraGrid3;
 
        }

        private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;
        
        public Infragistics.Win.UltraWinGrid.UltraGrid grid
        {
            get { return _grid; }
        }

        private MilEtResultEntity _milet = new MilEtResultEntity();
        private MilTestingResultDetailEntity mtDetail = new MilTestingResultDetailEntity();

        public event CellEventHandler cellChange;
        [Browsable(false)]
        [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
        public MilEtResultEntity Value
        {
            get { return _milet; }
            set
            {
                if (value != null)
                {
                    _milet = value;
                    UpdateData();
                }
            }
        }

        public void LoadData()
        {
            initGrade();
            initGrade1();
        }
        public MilTestingResultDetailEntity Value1
        {
            get { return mtDetail; }
            set
            {
                mtDetail = value;
                UpdateDetailData();
            }
        }
        //班次
        private String colOrder;

        public String ColOrder
        {
            get { return colOrder; }
            set { colOrder = value; }
        }
        //班组
        private String colGroup;

        public String ColGroup
        {
            get { return colGroup; }
            set { colGroup = value; }
        }
        //产线
        private String plineCode;

        public String PlineCode
        {
            get { return plineCode; }
            set { plineCode = value; }
        }
        //台号
        private String colNo;

        public String ColNo
        {
            get { return colNo; }
            set { colNo = value; }
        }

        //实绩编号
        private String resultNo;

        public String ResultNo
        {
            get { return resultNo; }
            set { resultNo = value; }
        }
        private bool isCellSelect = false;

        public bool IsCellSelect
        {
            get { return isCellSelect; }
            set { isCellSelect = value; }
        }

        public void UpdateDetailData()
        {
            if (mtDetail != null)
            {

                //1#台检测支数
                TestingDataSource.Rows[0]["detectionNum1"] = string.IsNullOrEmpty(mtDetail.DetectionNum1.ToString()) ? "0" : mtDetail.DetectionNum1;
                //1#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum1"] = string.IsNullOrEmpty(mtDetail.SuspectProductNum1.ToString()) ? "0" : mtDetail.SuspectProductNum1;
                //1#台剔除支数
                TestingDataSource.Rows[0]["scrapNum1"] = string.IsNullOrEmpty(mtDetail.ScrapNum1.ToString()) ? "0" : mtDetail.ScrapNum1;
                //1#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum1"] = string.IsNullOrEmpty(mtDetail.QualifiedNum1.ToString()) ? "0" : mtDetail.QualifiedNum1;
                //1#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum1"] = string.IsNullOrEmpty(mtDetail.ReinspectionNum1.ToString()) ? "0" : mtDetail.ReinspectionNum1;
                //1#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum1"] = string.IsNullOrEmpty(mtDetail.ReinspectionQualifiedNum1.ToString()) ? "0" : mtDetail.ReinspectionQualifiedNum1;

                //1#留样支数
                TestingDataSource.Rows[0]["sampleNum1"] = string.IsNullOrEmpty(mtDetail.SampleNum1.ToString()) ? "0" : mtDetail.SampleNum1;

                //2#台检测支数
                TestingDataSource.Rows[0]["detectionNum2"] = string.IsNullOrEmpty(mtDetail.DetectionNum2.ToString()) ? "0" : mtDetail.DetectionNum2;
                //2#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum2"] = string.IsNullOrEmpty(mtDetail.SuspectProductNum2.ToString()) ? "0" : mtDetail.SuspectProductNum2;
                //2#台剔除支数
                TestingDataSource.Rows[0]["scrapNum2"] = string.IsNullOrEmpty(mtDetail.ScrapNum2.ToString()) ? "0" : mtDetail.ScrapNum2;
                //2#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum2"] = string.IsNullOrEmpty(mtDetail.QualifiedNum2.ToString()) ? "0" : mtDetail.QualifiedNum2;
                //2#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum2"] = string.IsNullOrEmpty(mtDetail.ReinspectionNum2.ToString()) ? "0" : mtDetail.ReinspectionNum2;
                //2#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum2"] = string.IsNullOrEmpty(mtDetail.ReinspectionQualifiedNum2.ToString()) ? "0" : mtDetail.ReinspectionQualifiedNum2;
                //2#留样支数
                TestingDataSource.Rows[0]["sampleNum2"] = string.IsNullOrEmpty(mtDetail.SampleNum2.ToString()) ? "0" : mtDetail.SampleNum2;

                //3#台检测支数
                TestingDataSource.Rows[0]["detectionNum3"] = string.IsNullOrEmpty(mtDetail.DetectionNum3.ToString()) ? "0" : mtDetail.DetectionNum3;
                //3#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum3"] = string.IsNullOrEmpty(mtDetail.SuspectProductNum3.ToString()) ? "0" : mtDetail.SuspectProductNum3;
                //3#台剔除支数
                TestingDataSource.Rows[0]["scrapNum3"] = string.IsNullOrEmpty(mtDetail.ScrapNum3.ToString()) ? "0" : mtDetail.ScrapNum3;
                //3#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum3"] = string.IsNullOrEmpty(mtDetail.QualifiedNum3.ToString()) ? "0" : mtDetail.QualifiedNum3;
                //3#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum3"] = string.IsNullOrEmpty(mtDetail.ReinspectionNum3.ToString()) ? "0" : mtDetail.ReinspectionNum3;
                //3#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum3"] = string.IsNullOrEmpty(mtDetail.ReinspectionQualifiedNum3.ToString()) ? "0" : mtDetail.ReinspectionQualifiedNum3;
                //3#留样支数
                TestingDataSource.Rows[0]["sampleNum3"] = string.IsNullOrEmpty(mtDetail.SampleNum3.ToString()) ? "0" : mtDetail.SampleNum3;

            }
            else
            {
                //1#台检测支数
                TestingDataSource.Rows[0]["detectionNum1"] = "0";
                //1#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum1"] = "0";
                //1#台剔除支数
                TestingDataSource.Rows[0]["scrapNum1"] = "0";
                //1#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum1"] = "0";
                //1#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum1"] = "0";
                //1#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum1"] = "0";

                //1#留样支数
                TestingDataSource.Rows[0]["sampleNum1"] = "0";

                //2#台检测支数
                TestingDataSource.Rows[0]["detectionNum2"] = "0";
                //2#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum2"] = "0";
                //2#台剔除支数
                TestingDataSource.Rows[0]["scrapNum2"] = "0";
                //2#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum2"] = "0";
                //2#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum2"] = "0";
                //2#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum2"] = "0";
                //2#留样支数
                TestingDataSource.Rows[0]["sampleNum2"] = "0";

                //3#台检测支数
                TestingDataSource.Rows[0]["detectionNum3"] = "0";
                //3#台可疑品支数
                TestingDataSource.Rows[0]["suspectProductNum3"] = "0";
                //3#台剔除支数
                TestingDataSource.Rows[0]["scrapNum3"] = "0";
                //3#台合格支数
                TestingDataSource.Rows[0]["qualifiedNum3"] = "0";
                //3#台复探支数
                TestingDataSource.Rows[0]["reinspectionNum3"] = "0";
                //3#台复探合格支数
                TestingDataSource.Rows[0]["reinspectionQualifiedNum3"] = "0";
                //3#留样支数
                TestingDataSource.Rows[0]["sampleNum3"] = "0";
            }
        }

        /// <summary>
        /// 更新控件显示数据
        /// </summary>
        public void UpdateData()
        {
            if (_milet != null)
            {

                //技术资格等级从另一张表中获取，暂无。验收等级、合格支数
                //TestingDataSource.Rows[0]["OnlineShift"] = _milet.ColShift;
                //TestingDataSource.Rows[0]["OnlineGroup"] = _milet.ColGroup;
                //TestingDataSource.Rows[0]["OnlineUser"] = _milet.ColUser;

               

                    //班次
                    TestingDataSource.Rows[0]["ColShift"] = _milet.ColShift;
                    //班组
                    TestingDataSource.Rows[0]["ColGroup"] = _milet.ColGroup;
                    //操作人
                    TestingDataSource.Rows[0]["ColUser"] = _milet.ColUser;
                    //产品标准
                    TestingDataSource.Rows[0]["ProductStandards"] = _milet.ProductStandards;
                    //探伤标准
                    TestingDataSource.Rows[0]["InspectionStandard"] = _milet.InspectionStandard;
                    //探伤方法
                    if (_milet.TestingMethod.ToString() == "")
                    {
                        TestingDataSource.Rows[0]["TestingMethod"] = "穿过式";
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["TestingMethod"] = _milet.TestingMethod;
                    }
                    //校准方法
                    if (_milet.CalibrationMethod.ToString() == "")
                    {
                        TestingDataSource.Rows[0]["CalibrationMethod"] = "对比试样";
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["CalibrationMethod"] = _milet.CalibrationMethod;
                    }
                    //人工缺陷形状
                    if (_milet.ArtificialDefectShape.ToString() == "")
                    {
                        TestingDataSource.Rows[0]["ArtificialDefectShape"] = "通孔";
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["ArtificialDefectShape"] = _milet.ArtificialDefectShape;
                    }
                    //备注
                    if (_milet.Remark.ToString() == "")
                    {
                       TestingDataSource.Rows[0]["Remark"] = "";
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["Remark"] = _milet.Remark;
                    }
                    //检测支数
                    TestingDataSource.Rows[0]["DetectionNum"] = string.IsNullOrEmpty(_milet.DetectionNum.ToString()) ? "0" : _milet.DetectionNum;
                    //可疑品支数
                    TestingDataSource.Rows[0]["SuspectProductNum"] = string.IsNullOrEmpty(_milet.SuspectProductNum.ToString()) ? "0" : _milet.SuspectProductNum;
                    //原因
                    TestingDataSource.Rows[0]["SuspiciousReason"] = _milet.SuspiciousReason;
                    //复探支数
                    TestingDataSource.Rows[0]["ReinspectionNum"] = string.IsNullOrEmpty(_milet.ReinspectionNum.ToString()) ? "0" : _milet.ReinspectionNum;
                    //复探合格支数
                    TestingDataSource.Rows[0]["ReinspectionQualifiedNum"] = string.IsNullOrEmpty(_milet.ReinspectionQualifiedNum.ToString()) ? "0" : _milet.ReinspectionQualifiedNum;
                    //最终废品支数
                    TestingDataSource.Rows[0]["ScrapNum"] = string.IsNullOrEmpty(_milet.ScrapNum.ToString()) ? "0" : _milet.ScrapNum;
                    //已探伤下线支数
                    TestingDataSource.Rows[0]["inspectionedOfflineNum"] = string.IsNullOrEmpty(_milet.InspectionedOfflineNum.ToString()) ? 0 : _milet.InspectionedOfflineNum;
                    //留样支数
                    TestingDataSource.Rows[0]["sampleNum"] = string.IsNullOrEmpty(_milet.SampleNum.ToString()) ? 0 : _milet.SampleNum;
                    //1#激励频率
                    TestingDataSource.Rows[0]["ExcitationFrequency1"] = _milet.ExcitationFrequency1;
                    //2#激励频率
                    TestingDataSource.Rows[0]["ExcitationFrequency2"] = _milet.ExcitationFrequency2;
                    //3#激励频率
                    TestingDataSource.Rows[0]["ExcitationFrequency3"] = _milet.ExcitationFrequency3;
                    //判废原因
                    TestingDataSource.Rows[0]["ScrapReason"] = _milet.ScrapReason;
                    //最终合格支数
                    TestingDataSource.Rows[0]["QualifiedNum"] = string.IsNullOrEmpty(_milet.QualifiedNum.ToString()) ? "0" : _milet.QualifiedNum;
                    //1#探伤速度
                    TestingDataSource.Rows[0]["TestingSpeed1"] = _milet.TestingSpeed1;
                    //2#探伤速度
                    TestingDataSource.Rows[0]["TestingSpeed2"] = _milet.TestingSpeed2;
                    //3#探伤速度
                    TestingDataSource.Rows[0]["TestingSpeed3"] = _milet.TestingSpeed3;
                    //签发者ID
                    TestingDataSource.Rows[0]["Signid"] = _milet.Signid;
                    //操作者ID
                    TestingDataSource.Rows[0]["Userid"] = _milet.Userid;
                    //开始时间
                    TestingDataSource.Rows[0]["StartTime"] = _milet.StartTime;

                    //操作者1
                    TestingDataSource.Rows[0]["Userid1"] = _milet.Userid1;
                    //操作者2
                    TestingDataSource.Rows[0]["Userid2"] = _milet.Userid2;
                    //操作者等级1
                    TestingDataSource.Rows[0]["UseridGrade1"] = _milet.UseridGrade1;
                    //操作者等级2
                    TestingDataSource.Rows[0]["UseridGrade2"] = _milet.UseridGrade2;
                    //验收等级
                    TestingDataSource.Rows[0]["AcceptanceGrade"] = _milet.AcceptanceGrade;
                    //样管信息
                    TestingDataSource.Rows[0]["SampleNews"] = _milet.SampleNews;

                    //样管刻槽信息
                    TestingDataSource.Rows[0]["notchInfo"] = _milet.NotchInfo;
                    //槽长
                    TestingDataSource.Rows[0]["notchLength"] = _milet.NotchLength;
                    //槽宽
                    TestingDataSource.Rows[0]["notchWidth"] = _milet.NotchWidth;
                    //槽深
                    TestingDataSource.Rows[0]["notchDepth"] = _milet.NotchDepth;
                    
                    //备注
                    //TestingDataSource.Rows[0]["Remark"] = _milet.Remark;
                    ////1#台剔除支数
                    //TestingDataSource.Rows[0]["scrapNum1"] = _milet.ScrapNum1;
                    ////1#台合格支数
                    //TestingDataSource.Rows[0]["qualifiedNum1"] = _milet.QualifiedNum1;
                    ////1#台复探支数
                    //TestingDataSource.Rows[0]["reinspectionNum1"] = _milet.ReinspectionNum1;
                    ////1#台复探合格支数
                    //TestingDataSource.Rows[0]["reinspectionQualifiedNum1"] = _milet.ReinspectionQualifiedNum1;
                    ////2#台剔除支数
                    //TestingDataSource.Rows[0]["scrapNum2"] = _milet.ScrapNum2;
                    ////2#台合格支数
                    //TestingDataSource.Rows[0]["qualifiedNum2"] = _milet.QualifiedNum2;
                    ////2#台复探支数
                    //TestingDataSource.Rows[0]["reinspectionNum2"] = _milet.ReinspectionNum2;
                    ////2#台复探合格支数
                    //TestingDataSource.Rows[0]["reinspectionQualifiedNum2"] = _milet.ReinspectionQualifiedNum2;
                    ////3#台剔除支数
                    //TestingDataSource.Rows[0]["scrapNum3"] = _milet.ScrapNum3;
                    ////3#台合格支数
                    //TestingDataSource.Rows[0]["qualifiedNum3"] = _milet.QualifiedNum3;
                    ////3#台复探支数
                    //TestingDataSource.Rows[0]["reinspectionNum3"] = _milet.ReinspectionNum3;
                    ////3#台复探合格支数
                    //TestingDataSource.Rows[0]["reinspectionQualifiedNum3"] = _milet.ReinspectionQualifiedNum3;
                    ////1#台检测支数
                    //TestingDataSource.Rows[0]["detectionNum1"] = _milet.DetectionNum1;
                    ////2#台检测支数
                    //TestingDataSource.Rows[0]["detectionNum2"] = _milet.DetectionNum2;
                    ////3#台检测支数
                    //TestingDataSource.Rows[0]["detectionNum3"] = _milet.DetectionNum3;
                    ////1#台可疑品支数
                    //TestingDataSource.Rows[0]["suspectProductNum1"] = _milet.SuspectProductNum1;
                    ////2#台可疑品支数
                    //TestingDataSource.Rows[0]["suspectProductNum2"] = _milet.SuspectProductNum2;
                    ////3#台可疑品支数
                    //TestingDataSource.Rows[0]["suspectProductNum3"] = _milet.SuspectProductNum3;
                
            }
            else { }
 
        }

        public void Using1()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
        }
        public void Using2()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
        }
        public void Using3()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
        }

        public void Using4()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum1"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            
        }

        public void Using5()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum2"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;

        }

        public void Using6()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["scrapNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["qualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["reinspectionQualifiedNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["detectionNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["suspectProductNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["sampleNum3"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;

        }
        public void Using7()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["colNo"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.Disabled;
        }
        public void Using8()
        {
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["colNo"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
        }
        public void Clear()
        {
            for (int i = 0; i < ultraGrid3.DisplayLayout.Bands[0].Columns.Count; i++)
            {
                //ultraGrid3.DisplayLayout.Bands[0].Columns[i].ToString() = "";
                //ultraGrid3.
 
            }
 
        }

        private DataTable doQueryGrade(string userid)
        {
            DataTable df = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryGrade1", new object[] { userid }, ob);
            return df;
        }

        public void initGrade()
        {
            ArrayList list = new ArrayList();
            list.Add(colGroup);
            list.Add("8");
            list.Add(plineCode);
            PipeManageClass.InitComboEditor2(ultraComboEditor3, "com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryGrade", list, "USER_ID", ob, true);
        }
        public void initGrade1()
        {
            ArrayList list = new ArrayList();
            list.Add("8");
            list.Add(plineCode);
            PipeManageClass.InitComboEditor2(ultraComboEditor4, "com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryGrade2", list, "USER_ID", ob, true);
        }
        private void ultraGrid3_CellChange(object sender, CellEventArgs e)
        {
            isCellSelect = true;
            DataTable dd = new DataTable();
            this.ultraGrid3.UpdateData();
            if (e.Cell.Column.Key == "userid1")
            {
                TestingDataSource.Rows[0]["useridGrade1"] = "";
                dd = doQueryGrade(TestingDataSource.Rows[0]["userid1"].ToString());
                if (dd.Rows.Count > 0)
                {
                    TestingDataSource.Rows[0]["useridGrade1"] = dd.Rows[0][0].ToString();
                }
            }
            if (e.Cell.Column.Key == "userid2")
            {
                TestingDataSource.Rows[0]["useridGrade2"] = "";
                dd = doQueryGrade(TestingDataSource.Rows[0]["userid2"].ToString());
                if (dd.Rows.Count > 0)
                {
                    TestingDataSource.Rows[0]["useridGrade2"] = dd.Rows[0][0].ToString();
                }
            }
            if (e.Cell.Column.Key == "colNo")
            {
                if (TestingDataSource.Rows[0]["colNo"].ToString2() == "1")
                {
                    Using1();
                    Using4();
                }
                else if (TestingDataSource.Rows[0]["colNo"].ToString2() == "2")
                {
                    Using2();
                    Using5();
                }
                else if (TestingDataSource.Rows[0]["colNo"].ToString2() == "3")
                {
                    Using3();
                    Using6();
                }
                else
                {
                    Using1();
                    Using2();
                    Using3();
                }
            }
            //else
            //{
            //    Using1();
            //    Using2();
            //    Using3();
            //}
            if (TestingDataSource.Rows[0]["colNo"].ToString2() != "")
            {
                //查询该班次班组的下线支数
                DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryOfflineNum", new object[] { resultNo.ToString(), colOrder, colGroup, TestingDataSource.Rows[0]["colNo"].ToString2() }, ob);
                if (e.Cell.Column.Key == "detectionNum1" || e.Cell.Column.Key == "scrapNum1" || e.Cell.Column.Key == "sampleNum1" || e.Cell.Column.Key == "suspectProductNum1")
                {
                    if (ds.Rows.Count > 0)
                    {
                        //- int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["sampleNum1"].ToString3()) ? "0" : TestingDataSource.Rows[0]["sampleNum1"].ToString3()) 
                        TestingDataSource.Rows[0]["qualifiedNum1"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum1"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum1"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum1"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum1"].ToString3()) - int.Parse(ds.Rows[0]["REASON_NUMBER"].ToString3())).ToString();
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["qualifiedNum1"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum1"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum1"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum1"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum1"].ToString3())  - 0).ToString();
                    }
                }
                if (e.Cell.Column.Key == "detectionNum2" || e.Cell.Column.Key == "scrapNum2" || e.Cell.Column.Key == "sampleNum2" || e.Cell.Column.Key == "suspectProductNum2")
                {
                    if (ds.Rows.Count > 0)
                    {
                        //- int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["sampleNum2"].ToString3()) ? "0" : TestingDataSource.Rows[0]["sampleNum2"].ToString3())
                        TestingDataSource.Rows[0]["qualifiedNum2"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum2"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum2"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum2"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum2"].ToString3())  - int.Parse(ds.Rows[0]["REASON_NUMBER"].ToString3())).ToString();
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["qualifiedNum2"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum2"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum2"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum2"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum2"].ToString3()) - 0).ToString();
                    }
                }
                if (e.Cell.Column.Key == "detectionNum3" || e.Cell.Column.Key == "scrapNum3" || e.Cell.Column.Key == "sampleNum3" || e.Cell.Column.Key == "suspectProductNum3")
                {
                    if (ds.Rows.Count > 0)
                    {
                        //- int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["sampleNum3"].ToString3()) ? "0" : TestingDataSource.Rows[0]["sampleNum3"].ToString3())
                        TestingDataSource.Rows[0]["qualifiedNum3"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum3"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum3"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum3"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum3"].ToString3())  - int.Parse(ds.Rows[0]["REASON_NUMBER"].ToString3())).ToString();
                    }
                    else
                    {
                        TestingDataSource.Rows[0]["qualifiedNum3"] = (int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["detectionNum3"].ToString3()) ? "0" : TestingDataSource.Rows[0]["detectionNum3"].ToString3()) - int.Parse(string.IsNullOrEmpty(TestingDataSource.Rows[0]["scrapNum3"].ToString3()) ? "0" : TestingDataSource.Rows[0]["scrapNum3"].ToString3()) - 0).ToString();
                    }
                }
                doQueryMtResult(_milet.ResultNo.ToString());
                if (cellChange != null)
                {
                    cellChange(sender, e);
                }
            }
        }
        private void doQueryMtResult(string resultNo)
        {
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryEtResult", new object[] { resultNo }, ob);
            if (ds.Rows.Count > 0)
            {
                //报警支数
                TestingDataSource.Rows[0]["SuspectProductNum"] = ds.Rows[0]["SUSPECT_PRODUCT_NUM"].ToString();
                //最终废品支数
                TestingDataSource.Rows[0]["ScrapNum"] = ds.Rows[0]["SCRAP_NUM"].ToString();
                //已探伤下线支数
                TestingDataSource.Rows[0]["inspectionedOfflineNum"] = ds.Rows[0]["INSPECTIONED_OFFLINE_NUM"].ToString();
            }

        }
        private void ultraGrid3_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;
            //e.StayInEditMode = true;
            bool result = false;
            try
            {
                DateTime.Parse(this.ultraGrid3.Rows[0].Cells["StartTime"].ToString());
                result = true;
            }
            catch
            {

            }
            if (!result)
            {
                MessageBox.Show("您输入的开始时间格式不正确，请重新输入。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
        //已探伤下线支数
        public string testOfflineNum = "";
        private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            ArrayList list = new ArrayList();
            list.Add(_milet.ResultNo);
            list.Add(_milet.LotNo);
            list.Add(_milet.JudgeStoveNo);
            list.Add(colOrder);
            list.Add(colGroup);
            
            if (_milet.JudgeStoveNo.Equals(""))
            {
                MessageUtil.ShowTips("未开始探伤，不允许登记可疑、剔除品!");
                return;
            }
            if (ultraGrid3.ActiveCell.Column.Key == "suspectProductNum1")
            {
                list.Add("1");//台号
                list.Add(_milet.ProPlanId);
                list.Add(_milet.GxPlanNo);
                FrmScrap scrap = new FrmScrap(list, plineCode, ob);
                if (scrap.ShowDialog() == DialogResult.OK)
                {

                    this.ultraGrid3.ActiveRow.Cells["scrapNum1"].Value = string.IsNullOrEmpty(scrap.scrapNum.ToString()) ? "0" : scrap.scrapNum;
                    this.ultraGrid3.ActiveRow.Cells["suspectProductNum1"].Value = string.IsNullOrEmpty(scrap.alamNum.ToString()) ? "0" : scrap.alamNum;
                    testOfflineNum = scrap.testOfflineNum;
                    ultraGrid3_CellChange(null, new CellEventArgs(ultraGrid3.ActiveCell));

                }
            }
            else if (ultraGrid3.ActiveCell.Column.Key == "suspectProductNum2")
            {
                list.Add("2");
                list.Add(_milet.ProPlanId);
                list.Add(_milet.GxPlanNo);
                FrmScrap scrap = new FrmScrap(list, plineCode, ob);
                if (scrap.ShowDialog() == DialogResult.OK)
                {

                    this.ultraGrid3.ActiveRow.Cells["scrapNum2"].Value = string.IsNullOrEmpty(scrap.scrapNum.ToString()) ? "0" : scrap.scrapNum;
                    this.ultraGrid3.ActiveRow.Cells["suspectProductNum2"].Value = string.IsNullOrEmpty(scrap.alamNum.ToString()) ? "0" : scrap.alamNum;
                    testOfflineNum = scrap.testOfflineNum;
                    ultraGrid3_CellChange(null, new CellEventArgs(ultraGrid3.ActiveCell));

                }
            }
            else if (ultraGrid3.ActiveCell.Column.Key == "suspectProductNum3")
            {
                list.Add("3");
                list.Add(_milet.ProPlanId);
                list.Add(_milet.GxPlanNo);
                FrmScrap scrap = new FrmScrap(list, plineCode, ob);
                if (scrap.ShowDialog() == DialogResult.OK)
                {

                    this.ultraGrid3.ActiveRow.Cells["scrapNum3"].Value = string.IsNullOrEmpty(scrap.scrapNum.ToString()) ? "0" : scrap.scrapNum;
                    this.ultraGrid3.ActiveRow.Cells["suspectProductNum3"].Value = string.IsNullOrEmpty(scrap.alamNum.ToString()) ? "0" : scrap.alamNum;
                    testOfflineNum = scrap.testOfflineNum;
                    ultraGrid3_CellChange(null, new CellEventArgs(ultraGrid3.ActiveCell));

                }
            }
        }

    }
}