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 com.steering.mes.mcp.entity; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; using Core.Mes.Client.Comm.Server; namespace Core.StlMes.Client.Mcp.Control { public partial class FrmDetectResultControl : UserControl { 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 string num = ""; private MchMtResultEntity _load = new MchMtResultEntity(); public MchMtResultEntity Value { get { return _load; } set { if (value != null) { this._load = value; UpdateData(); } } } private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null; /// /// 编辑区GRID /// public Infragistics.Win.UltraWinGrid.UltraGrid Grid { get { return _grid; } } public FrmDetectResultControl() { InitializeComponent(); GridHelper.InitCardGrid(this.ultraDataSource1, this.ultraGrid1); _grid = this.ultraGrid1; } private string banCi; public string BanCi { get { return banCi; } set { banCi = value; } } private string plineNam = ""; public void init(string plineName) { plineNam = plineName; if (_load.ProGroup == "1") { banCi = "甲"; } else if (_load.ProGroup == "2") { banCi = "乙"; } else if (_load.ProGroup == "3") { banCi = "丙"; } else if (_load.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); } //探伤标准下拉选 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 type() { DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpRotexpFace.getQuerybase", new object[] { "7008" }, this.ob); shipiantype.DataSource = dt2; shipiantype.DisplayMember = "BASENAME"; shipiantype.ValueMember = "BASECODE"; YdmBaseClass.SetComboItemHeight(shipiantype); } //湿磁粉种类 public void species() { DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpRotexpFace.getQuerybase", new object[] { "7009" }, this.ob); cifenspecies.DataSource = dt2; cifenspecies.DisplayMember = "BASENAME"; cifenspecies.ValueMember = "BASECODE"; YdmBaseClass.SetComboItemHeight(cifenspecies); } /// /// 刷新控件数据显示 /// public void UpdateData() { if (_load != null) { ultraDataSource1.Rows[0]["OperateTime"] = _load.CreateTime; ultraDataSource1.Rows[0]["Shift"] = _load.ProShift; ultraDataSource1.Rows[0]["Group"] = _load.ProGroup; ultraDataSource1.Rows[0]["Operator"] = _load.CreateUser; ultraDataSource1.Rows[0]["Testing_Standard1"] = _load.TestingStandard1; ultraDataSource1.Rows[0]["Testing_Standard2"] = _load.TestingStandard2; ultraDataSource1.Rows[0]["Testing_Standard3"] = _load.TestingStandard3; ultraDataSource1.Rows[0]["Testing_Standard4"] = _load.TestingStandard4; ultraDataSource1.Rows[0]["Testing_Gride1"] = _load.TestingGrade1; ultraDataSource1.Rows[0]["Testing_Gride2"] = _load.TestingGrade2; ultraDataSource1.Rows[0]["Testing_Gride3"] = _load.TestingGrade3; ultraDataSource1.Rows[0]["Testing_Gride4"] = _load.TestingGrade4; ultraDataSource1.Rows[0]["Testing_Pieces"] = _load.TetNum; ultraDataSource1.Rows[0]["Qualified_Pieces"] = _load.ProNum; ultraDataSource1.Rows[0]["Suspect_Pieces"] = _load.DubiousNum; ultraDataSource1.Rows[0]["SignAndIssue"] = _load.SignMan; ultraDataSource1.Rows[0]["SIGN_MAN_GRADE"] = _load.SignManGrade; ultraDataSource1.Rows[0]["Retested_Pieces"] = _load.FtestingNum; ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = _load.FpassNum; ultraDataSource1.Rows[0]["FinalRejected_Pieces"] = _load.FailNum; ultraDataSource1.Rows[0]["SHIM_MAG_INDIC"] = _load.ShimMagIndic; ultraDataSource1.Rows[0]["SHIM_MAG_TYPE"] = _load.ShimMagType; ultraDataSource1.Rows[0]["MT_TYPE"] = _load.MtType; ultraDataSource1.Rows[0]["MAG_SUSP_LIQ_CON"] = _load.MagSuspLiqCon; ultraDataSource1.Rows[0]["COIL_CUR_INT"] = _load.CoilCurInt; ultraDataSource1.Rows[0]["CTR_STI_CUR_INT"] = _load.CtrStiCurInt; ultraDataSource1.Rows[0]["DEMAG_VOL"] = _load.DemagVol; ultraDataSource1.Rows[0]["UT_MAN"] = _load.UtMan; ultraDataSource1.Rows[0]["UT_MAN_GRADE"] = _load.UtManGrade; ultraDataSource1.Rows[0]["Reject_Reason"] = _load.MtNote; num = _load.TetNum; } else { GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1); } this.ultraGrid1.UpdateData(); } /// /// 控件编辑后更新已修改数据 /// public new void Update() { ultraGrid1.UpdateData(); } private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e) { try { if (e.Cell.Column.Key.Equals("Shift")) { //_load.LoadPieces = e.Cell.Value.ToString(); 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.CreateUser = 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("Testing_Gride1")) { Value.TestingGrade1 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Gride2")) { Value.TestingGrade2 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Gride3")) { Value.TestingGrade3 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Gride4")) { Value.TestingGrade4 = e.Cell.Text.ToString(); } if (e.Cell.Column.Key.Equals("Testing_Pieces")) { Value.TetNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Qualified_Pieces")) { Value.CutNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Suspect_Pieces")) { Value.DubiousNum = e.Cell.Value.ToString(); } //if (e.Cell.Column.Key.Equals("Reason")) //{ // Value.FtestingReason = 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("OperateTime")) { Value.CreateTime = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SignAndIssue")) { Value.SignMan = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SIGN_MAN_GRADE")) { Value.SignManGrade = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("FinalRejected_Pieces")) { Value.FailNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SHIM_MAG_INDIC")) { Value.ShimMagIndic = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SHIM_MAG_TYPE")) { Value.ShimMagType = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MT_TYPE")) { Value.MtType = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MAG_SUSP_LIQ_CON")) { Value.MagSuspLiqCon = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("COIL_CUR_INT")) { Value.CoilCurInt = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("CTR_STI_CUR_INT")) { Value.CtrStiCurInt = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("DEMAG_VOL")) { Value.DemagVol = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("UT_MAN")) { Value.UtMan = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("UT_MAN_GRADE")) { Value.UtManGrade = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("Reject_Reason")) { Value.MtNote = e.Cell.Value.ToString(); } } catch (Exception ex) { } } /// /// 验证格试 /// public bool ValidInput1() { //bool p = true; ultraGrid1.UpdateData(); //string TetNum = ultraDataSource1.Rows[0]["Testing_Pieces"].ToString(); //string PassNum = ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString(); //string DubiousNum = ultraDataSource1.Rows[0]["Suspect_Pieces"].ToString(); //string FtestingNum = ultraDataSource1.Rows[0]["Retested_Pieces"].ToString(); //string FpassNum = ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString(); //string EwasteNum = ultraDataSource1.Rows[0]["FinalRejected_Pieces"].ToString(); //string EpassNum = ultraDataSource1.Rows[0]["FinalQualified_Pieces"].ToString(); //if (!StringUtil.IsInt(TetNum)) //{ // MessageBox.Show("检测支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} //if (!StringUtil.IsInt(PassNum)) //{ // MessageBox.Show("合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} //if (DubiousNum != "") //{ // if (!StringUtil.IsInt(DubiousNum)) // { // MessageBox.Show("可疑支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; // } //} //if (FtestingNum != "") //{ // if (!StringUtil.IsInt(FtestingNum)) // { // MessageBox.Show("复探支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; // } //} //if (FpassNum != "") //{ // if (!StringUtil.IsInt(FpassNum)) // { // MessageBox.Show("复探合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; // } //} //if (EwasteNum != "") //{ // if (!StringUtil.IsInt(EwasteNum)) // { // MessageBox.Show("最终废品支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; // } //} // if (!StringUtil.IsInt(EpassNum)) // { // MessageBox.Show("最终合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; // } //if (Convert.ToInt32(TestingNum) != Convert.ToInt32(PassNum) + // Convert.ToInt32(DubiousNum == "" ? "0" : DubiousNum) + // Convert.ToInt32(FtestingNum == "" ? "0" : FtestingNum) + // Convert.ToInt32(EwasteNum == "" ? "0" : EwasteNum)) //{ // MessageBox.Show("检测支数=合格支数+可疑支数+复探支数+最终废品支数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} //if (Convert.ToInt32(EpassNum) != //Convert.ToInt32(PassNum == "" ? "0" : PassNum) + //Convert.ToInt32(FpassNum == "" ? "0" : FpassNum)) //{ // MessageBox.Show("最终合格支数=合格支数+复探合格支数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} //if (Convert.ToInt32(Repaired_Pcs) != // Convert.ToInt32(Repaired_Pcs1 == "" ? "0" : Repaired_Pcs1) + // Convert.ToInt32(Repaired_Pcs2 == "" ? "0" : Repaired_Pcs2) + // Convert.ToInt32(Repaired_Pcs3 == "" ? "0" : Repaired_Pcs3) + // Convert.ToInt32(Repaired_Pcs4 == "" ? "0" : Repaired_Pcs4) + // Convert.ToInt32(Repaired_Pcs5 == "" ? "0" : Repaired_Pcs5) + // Convert.ToInt32(Repaired_Pcs6 == "" ? "0" : Repaired_Pcs6) + // Convert.ToInt32(Repaired_Pcs7 == "" ? "0" : Repaired_Pcs7) + // Convert.ToInt32(Repaired_Pcs8 == "" ? "0" : Repaired_Pcs8)) //{ // MessageBox.Show("废品总个数=废品个数1+废品个数2+废品个数3+废品个数4+废品个数5+废品个数6+废品个数7+废品个数8,请查验 ", "提示", 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 (_load.ProGroup == "1") { banCi = "甲"; } else if (_load.ProGroup == "2") { banCi = "乙"; } else if (_load.ProGroup == "3") { banCi = "丙"; } else if (_load.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"].ToString()==null) { ultraDataSource1.Rows[0]["Suspect_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Retested_Pieces"].ToString().Equals("") || ultraDataSource1.Rows[0]["Retested_Pieces"].ToString()==null) { ultraDataSource1.Rows[0]["Retested_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString().Equals("") || ultraDataSource1.Rows[0]["RetestedQualified_Pieces"].ToString()==null) { ultraDataSource1.Rows[0]["RetestedQualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString().Equals("") || ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString()==null) { ultraDataSource1.Rows[0]["Qualified_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["Testing_Pieces"].ToString().Equals("") || ultraDataSource1.Rows[0]["Testing_Pieces"].ToString()==null) { ultraDataSource1.Rows[0]["Testing_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]["Testing_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]["Testing_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; } } //double actnum = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()); ultraDataSource1.Rows[0]["Qualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Testing_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]["FinalQualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Testing_Pieces"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["Qualified_Pieces"].ToString()); // Value.FailNum = ultraDataSource1.Rows[0]["FinalQualified_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.FrmDetectResult.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; //} FrmScrap matfrm = new FrmScrap(heatNo, SlGx, plinCode, ResultNo,open,fenum, this.ob); matfrm.ShowDialog(); ultraDataSource1.Rows[0]["FinalRejected_Pieces"] = matfrm.scrapNum; Value.FailNum = matfrm.scrapNum; ultraDataSource1.Rows[0]["Suspect_Pieces"] = matfrm.alamNum; Value.DubiousNum = 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]["Testing_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["Testing_Pieces"] = "0"; } if (ultraDataSource1.Rows[0]["FinalRejected_Pieces"].ToString().Equals("")) { ultraDataSource1.Rows[0]["FinalRejected_Pieces"] = "0"; } this.ultraGrid1.UpdateData(); ultraDataSource1.Rows[0]["Qualified_Pieces"] = int.Parse(ultraDataSource1.Rows[0]["Testing_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); } } }