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"; } } /// /// 更新控件显示数据 /// 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)); } } } } }