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 Core.Mes.Client.Comm.Control; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Tool; using com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Server; //using Core.StlMes.Client.ZGMil.NodeResultQuery; namespace Core.StlMes.Client.Mcp.Control { /// /// 管端探伤实绩编辑区控件 /// public partial class CrackDetectControl : UserControl { private string num = ""; private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null; public string plinCode; public string SlGx; public string heatNo; public string ResultNo; public string fenum; public string open = "1"; public OpeBase ob; public OpeBase Ob { get { return ob; } set { ob = value; } } private MchUtResultEntity _plan = new MchUtResultEntity(); /// /// 计划实体对象 /// public MchUtResultEntity Value { get { return _plan; } set { if (value != null) { _plan = value; UpdateData(); } } } private string banCi; public string BanCi { get { return banCi; } set { banCi = value; } } private string plineNam = ""; public void init(string plineName) { plineNam = plineName; if (_plan.ProGroup == "1") { banCi = "甲"; } else if (_plan.ProGroup == "2") { banCi = "乙"; } else if (_plan.ProGroup == "3") { banCi = "丙"; } else if (_plan.ProGroup == "4") { banCi = "丁"; } DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmMcpLoading.getPerson", new object[] { banCi, plineName }, this.ob);//如果是“”里面添加的是条件 name.DataSource = dt; name.DisplayMember = "NAME"; // name.ValueMember = "ID"; YdmBaseClass.SetComboItemHeight(name); } /// /// 编辑区GRID /// public Infragistics.Win.UltraWinGrid.UltraGrid Grid { get { return _grid; } } public CrackDetectControl() { InitializeComponent(); GridHelper.InitCardGrid(this.ultraDataSource1, this.ultraGrid1); _grid = this.ultraGrid1; } //探伤标准下拉选 public void init() { DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmCrackDetectResult.getQuerybase", new object[] { "4021" }, this.ob); //comm.FilComboboxAdd(standard, dt2, "BASECODE", "BASENAME", "validflag NOT in ('0')", false, "全部", ""); standard.DataSource = dt2; standard.DisplayMember = "BASENAME"; standard.ValueMember = "BASECODE"; YdmBaseClass.SetComboItemHeight(standard); } //探伤等级下拉选 public void init1() { DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpRotexpFace.getQuerybase", new object[] { "4022" }, this.ob); comm.FilComboboxAdd(level, dt2, "BASECODE", "BASENAME", "validflag NOT in ('0')", false, "全部", ""); } //探伤废品原因 public void failson() { DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmCrackDetectResult.getQuerybase", new object[] { "7004" }, this.ob); //comm.FilComboboxAdd(standard, dt2, "BASECODE", "BASENAME", "validflag NOT in ('0')", false, "全部", ""); reason.DataSource = dt2; reason.DisplayMember = "BASENAME"; reason.ValueMember = "BASECODE"; YdmBaseClass.SetComboItemHeight(reason); } /// /// 刷新控件数据显示 /// public void UpdateData() { if (_plan != null) { ultraDataSource1.Rows[0]["Shift"] = _plan.ProShift; ultraDataSource1.Rows[0]["Group"] = _plan.ProGroup; ultraDataSource1.Rows[0]["DisQualified_Pieces"] = _plan.FailNum; ultraDataSource1.Rows[0]["Operator"] = _plan.UtMan; ultraDataSource1.Rows[0]["OperateTime"] = _plan.CreateTime; ultraDataSource1.Rows[0]["Suspect_Pieces"] = _plan.DubiousNum; ultraDataSource1.Rows[0]["Retested_Pieces"] = _plan.FtestingNum; ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = _plan.FpassNum; // ultraDataSource1.Rows[0]["IsProduce"] = Convert.ToString(_plan.IfMonitorDbk == null ? "" : _plan.IfMonitorDbk == "1" ? "是" : "否"); ultraDataSource1.Rows[0]["Testing_Standard1"] = _plan.TestingStandard1; ultraDataSource1.Rows[0]["Testing_Standard2"] = _plan.TestingStandard2; ultraDataSource1.Rows[0]["Testing_Standard3"] = _plan.TestingStandard3; ultraDataSource1.Rows[0]["Testing_Standard4"] = _plan.TestingStandard4; ultraDataSource1.Rows[0]["Testing_Standard5"] = _plan.TestingGrade1; ultraDataSource1.Rows[0]["Testing_Standard6"] = _plan.TestingGrade2; ultraDataSource1.Rows[0]["Testing_Standard7"] = _plan.TestingGrade3; ultraDataSource1.Rows[0]["Testing_Standard8"] = _plan.TestingGrade4; ultraDataSource1.Rows[0]["LExternalL_LVL"] = _plan.LexternalLvl; ultraDataSource1.Rows[0]["LInternalL_LVL"] = _plan.LinternalLvl; ultraDataSource1.Rows[0]["TExternalL_LVL"] = _plan.TexternalLvl; ultraDataSource1.Rows[0]["TInternalL_LVL"] = _plan.TinternalLvl; ultraDataSource1.Rows[0]["Testing_Speed"] = _plan.PipeRotSpeed; ultraDataSource1.Rows[0]["Probe_Speed"] = _plan.ProbeRunSpeed; ultraDataSource1.Rows[0]["TransMagCurrent"] = _plan.TransMagCur; ultraDataSource1.Rows[0]["TransEmiFreq"] = _plan.TransEmiFreq; ultraDataSource1.Rows[0]["LongMagCurrent"] = _plan.LongMagCur; ultraDataSource1.Rows[0]["LongEmiFreq"] = _plan.LongEmiFreq; ultraDataSource1.Rows[0]["SignAndIssue"] = _plan.SignMan; ultraDataSource1.Rows[0]["Tested_Pieces"] = _plan.TetNum; ultraDataSource1.Rows[0]["Qualified_Pieces"] = _plan.ProNum; ultraDataSource1.Rows[0]["SingManGrade"] = _plan.SignManGrade; ultraDataSource1.Rows[0]["Qualification_Level"] = _plan.UtManGrade; ultraDataSource1.Rows[0]["resultNo"] = _plan.ResultNo; num = _plan.TetNum; //DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryRCLPortVrp2", new object[] { heno }, ob); } else { GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1); } } /// /// 控件编辑后更新已修改数据 /// public new void Update() { ultraGrid1.UpdateData(); } private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e) { try { if (e.Cell.Column.Key.Equals("Shift")) { Value.ProShift = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Group")) { Value.ProGroup = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Operator")) { Value.UtMan = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("OperateTime")) { Value.CreateTime = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard1")) { Value.TestingStandard1 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard2")) { Value.TestingStandard2 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard3")) { Value.TestingStandard3 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard4")) { Value.TestingStandard4 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("LExternalL_LVL")) { Value.LexternalLvl = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("LInternalL_LVL")) { Value.LinternalLvl = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("TExternalL_LVL")) { Value.TexternalLvl = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("TInternalL_LVL")) { Value.TinternalLvl = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Probe_Speed")) { Value.ProbeRunSpeed = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("TransMagCurrent")) { Value.TransMagCur = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("TransEmiFreq")) { Value.TransEmiFreq = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LongMagCurrent")) { Value.LongMagCur = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LongEmiFreq")) { Value.LongEmiFreq = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SignAndIssue")) { Value.SignMan = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Tested_Pieces")) { Value.TetNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Qualified_Pieces")) { Value.ProNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("DisQualified_Pieces")) { Value.FailNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Suspect_Pieces")) { Value.DubiousNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Retested_Pieces")) { Value.FtestingNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("RetestedQualified_Pieces")) { Value.FpassNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Speed")) { Value.PipeRotSpeed = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard5")) { Value.TestingGrade1 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard6")) { Value.TestingGrade2 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard7")) { Value.TestingGrade3 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Standard8")) { Value.TestingGrade4 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("SingManGrade")) { Value.SignManGrade = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Qualification_Level")) { Value.UtManGrade = e.Cell.Value.ToString(); } //if (e.Cell.Column.Key.Equals("RetestedQualified_Pieces")) //{ // Value.JValueMax = e.Cell.Value.ToString(); //} //if (e.Cell.Column.Key.Equals("CouplingHeatNo")) //{ // Value.CouplingHeatNo = e.Cell.Value.ToString(); //} //if (e.Cell.Column.Key.Equals("CouplingLotNo")) //{ // Value.CouplingLotNo = e.Cell.Value.ToString(); //} //if (e.Cell.Column.Key.Equals("CouplingCount")) //{ // Value.CouplingNum = e.Cell.Value.ToString(); //} //if (e.Cell.Column.Key.Equals("ScrewOilModel")) //{ // Value.ScrewoilType = e.Cell.Value.ToString(); //} //if (e.Cell.Column.Key.Equals("ScrewOilLotNo")) //{ // Value.ScrewoilBachno = e.Cell.Value.ToString(); //} } catch (Exception ex) { } } public bool ValidInput1() { ultraGrid1.UpdateData(); //string FailNum = ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString(); //if (!StringUtil.IsInt(FailNum)) //{ // MessageBox.Show("废品支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} return true; } private void ultraGrid1_CellChange(object sender, CellEventArgs e) { ultraGrid1.UpdateData(); if (e.Cell.Column.Key.Equals("Group")) { if (_plan.ProGroup == "1") { banCi = "甲"; } else if (_plan.ProGroup == "2") { banCi = "乙"; } else if (_plan.ProGroup == "3") { banCi = "丙"; } else if (_plan.ProGroup == "4") { banCi = "丁"; } DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmMcpLoading.getPerson", new object[] { banCi, plineNam }, this.ob);//如果是“”里面添加的是条件 name.DataSource = dt1; name.DisplayMember = "NAME"; //name.ValueMember = "ID"; YdmBaseClass.SetComboItemHeight(name); } if (ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Suspect_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Retested_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Retested_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Qualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Tested_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Tested_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["DisQualified_Pieces"] = "0"; } this.ultraGrid1.UpdateData(); //double actnum = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()); if (num != null && !num.Equals("0")) { //if (int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) > int.Parse(num)) //{ // MessageBox.Show("可疑的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} //if (int.Parse(ultraDataSource1.Rows[0]["Tested_Pieces"].ToString()) > int.Parse(num)) //{ // MessageBox.Show("检测的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} //if (int.Parse(ultraDataSource1.Rows[0]["Retested_Pieces"].ToString()) > int.Parse(num)) //{ // MessageBox.Show("复探的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} //if (int.Parse(ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()) > int.Parse(num)) //{ // MessageBox.Show("复探合格的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} //if ((int.Parse(ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()) + int.Parse(ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString())) > int.Parse(num)) //{ // MessageBox.Show("合格支数与复探合格支数的和不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} if (int.Parse(ultraDataSource1.Rows[0]["Retested_Pieces"].ToString()) > int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString())) { MessageBox.Show("复探支数不能超过可疑支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) > int.Parse(ultraDataSource1.Rows[0]["Tested_Pieces"].ToString())) { MessageBox.Show("可疑支数不能超过检测支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (int.Parse(ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()) > int.Parse(ultraDataSource1.Rows[0]["Retested_Pieces"].ToString())) { MessageBox.Show("复探合格支数不能超过复探支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } if (e.Cell.Column.Key.Equals("Tested_Pieces")) { Value.ProNum = ultraDataSource1.Rows[0]["Tested_Pieces"].ToString(); ultraDataSource1.Rows[0]["Qualified_Pieces"] = Value.ProNum; ultraDataSource1.Rows[0]["Suspect_Pieces"] = "0"; ultraDataSource1.Rows[0]["DisQualified_Pieces"] = "0"; ultraDataSource1.Rows[0]["Retested_Pieces"] = "0"; } //double actnum = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()); //ultraDataSource1.Rows[0]["Qualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Tested_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) + int.Parse(ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()); //Value.ProNum = ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString(); ultraDataSource1.Rows[0]["DisQualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Tested_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString()); Value.FailNum = ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString(); } private void craftImg_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { if (heatNo == null) { return; } if (plinCode == null) { return; } DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmCrackDetectResult.getQueryExpandResultStuts", new object[] { heatNo, plinCode }, this.ob); if (dt1.Rows.Count > 0) { if (dt1.Rows[0]["STATION_STATUS"].ToString() == "2") { MessageUtil.ShowTips("该工序已经结炉,不允许录入废品数!"); return; } } //if (Convert.ToInt32(fenum) <= 0) //{ // MessageUtil.ShowTips("剩余支数为零,不允许录入废品数!"); // return; //} //string heatno = ""; //string lotno = ""; //string plinename = ""; //UltraGridRow urg = ultraGrid1.ActiveRow; //if (urg != null) //{ // heatno = urg.Cells["HEAT_PLAN_NO"].Value.ToString(); // lotno = urg.Cells["LAST_BATCH_NO"].Value.ToString(); // plinename = urg.Cells["PLINE_NAME"].Text.ToString(); //} FrmScrap matfrm = new FrmScrap(heatNo,SlGx, plinCode,ResultNo,open,fenum, this.ob); matfrm.ShowDialog(); ultraDataSource1.Rows[0]["DisQualified_Pieces"] = matfrm.scrapNum; Value.FailNum = matfrm.scrapNum; ultraDataSource1.Rows[0]["Suspect_Pieces"] = matfrm.alamNum; Value.DubiousNum = matfrm.alamNum; ultraDataSource1.Rows[0]["Retested_Pieces"] = matfrm.alamNum; Value.FtestingNum = matfrm.alamNum; if (ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Suspect_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Retested_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Retested_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Qualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Tested_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Tested_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["DisQualified_Pieces"] = "0"; } if (int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString()) <= 0) { ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = 0; Value.FpassNum = ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString(); } else { ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["DisQualified_Pieces"].ToString()); Value.FpassNum = ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString(); } this.ultraGrid1.UpdateData(); //ultraDataSource1.Rows[0]["Qualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Tested_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString()) + int.Parse(ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()); //Value.ProNum = ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString(); //ultraGrid1.UpdateData(); ultraGrid1.PerformAction(UltraGridAction.ExitEditMode); ultraGrid1.PerformAction(UltraGridAction.EnterEditMode); } } }