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);
}
}
}