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; using Infragistics.Win.UltraWinGrid; using Infragistics.Win.UltraWinDataSource; using Core.Mes.Client.Comm.Control; using com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; namespace Core.StlMes.Client.Mcp.Control { public partial class PlanSizingControl : UserControl { private string actnum; private string actwt; private VrpSizingResultEntity _load = new VrpSizingResultEntity(); private OpeBase ob; public OpeBase Ob { get { return ob; } set { ob = value; } } public VrpSizingResultEntity 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 PlanSizingControl() { InitializeComponent(); GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1); _grid = this.ultraGrid1; } /// /// 刷新控件数据显示 /// public void UpdateData() { if (_load != null) { ultraDataSource1.Rows[0]["SPEED_IN"] = _load.SpeedIn; ultraDataSource1.Rows[0]["SPEED_OUT"] = _load.SpeedOut; ultraDataSource1.Rows[0]["MOTOR_SPEED1"] = _load.MotorSpeed1; ultraDataSource1.Rows[0]["MOTOR_SPEED2"] = _load.MotorSpeed2; ultraDataSource1.Rows[0]["MOTOR_SPEED3"] = _load.MotorSpeed3; ultraDataSource1.Rows[0]["MOTOR_SPEED4"] = _load.MotorSpeed4; ultraDataSource1.Rows[0]["MOTOR_SPEED5"] = _load.MotorSpeed5; ultraDataSource1.Rows[0]["MOTOR_DR"] = _load.MotorDr; ultraDataSource1.Rows[0]["PRO_NUM"] = _load.ProNum; ultraDataSource1.Rows[0]["PRO_WT"] = _load.ProWt; ultraDataSource1.Rows[0]["FAIL_NUM"] = string.IsNullOrEmpty(_load.FailNum)?"0" :_load.FailNum; ultraDataSource1.Rows[0]["FAIL_WT"] = string.IsNullOrEmpty(_load.FailWt) ? "0" : _load.FailWt; ultraDataSource1.Rows[0]["FAIL_REASON"] = _load.FailReason; ultraDataSource1.Rows[0]["PRODUCER"] = _load.Producer; ultraDataSource1.Rows[0]["PRODUCER_TIME"] = _load.ProducerTime; ultraDataSource1.Rows[0]["LOAD_TIME"] = _load.LoadTime; ultraDataSource1.Rows[0]["LOAD_SHIFT"] = _load.LoadShift; ultraDataSource1.Rows[0]["LOAD_GROUP"] = _load.LoadGroup; ultraDataSource1.Rows[0]["LOAD_USER"] = _load.LoadUser; ultraDataSource1.Rows[0]["SHE_DIMATER"] = _load.SheDimater; ultraDataSource1.Rows[0]["SHE_HEIGHT"] = _load.SheHeight; ultraDataSource1.Rows[0]["SIZ_DIMATER"] = _load.SizDimater; ultraDataSource1.Rows[0]["SIZ_HEIGHT"] = _load.SizHeight; ultraDataSource1.Rows[0]["ACT_COUNT"] = _load.ActNum; ultraDataSource1.Rows[0]["ACT_WEIGHT"] = _load.ActWt; actnum = _load.ProNum; actwt = _load.ProWt; } else { GridHelper.InitCardGrid(ultraDataSource1,ultraGrid1); } this.ultraGrid1.UpdateData(); } /// /// 控件编辑后更新已修改数据 /// public void CompleteEdit() { ultraGrid1.UpdateData(); } private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e) { try { if (e.Cell.Column.Key.Equals("SPEED_IN")) { Value.SpeedIn = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SPEED_OUT")) { Value.SpeedOut = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_SPEED1")) { Value.MotorSpeed1 = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_SPEED2")) { Value.MotorSpeed2 = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_SPEED3")) { Value.MotorSpeed3 = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_SPEED4")) { Value.MotorSpeed4 = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_SPEED5")) { Value.MotorSpeed5 = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("MOTOR_DR")) { Value.MotorDr = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("PRO_NUM")) { Value.ProNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("PRO_WT")) { Value.ProWt = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("FAIL_NUM")) { Value.FailNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("FAIL_WT")) { Value.FailWt = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("FAIL_REASON")) { Value.FailReason = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("PRODUCER")) { Value.Producer = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("PRODUCER_TIME")) { Value.ProducerTime = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LOAD_TIME")) { Value.LoadTime = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LOAD_SHIFT")) { Value.LoadShift = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LOAD_GROUP")) { Value.LoadGroup = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("LOAD_USER")) { Value.LoadUser = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SHE_DIMATER")) { Value.SheDimater = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SHE_HEIGHT")) { Value.SheHeight = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SIZ_DIMATER")) { Value.SizDimater = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("SIZ_HEIGHT")) { Value.SizHeight = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("ACT_COUNT")) { Value.ActNum = e.Cell.Value.ToString(); } if (e.Cell.Column.Key.Equals("ACT_WEIGHT")) { Value.ActWt = e.Cell.Value.ToString(); } } catch (Exception ex) { } } /// /// 验证格试 /// public bool ValidInput1() { ultraGrid1.UpdateData(); string TestingNum = ultraDataSource1.Rows[0]["PRO_NUM"].ToString(); string TestingWt = ultraDataSource1.Rows[0]["PRO_WT"].ToString(); string TestingNum1 = ultraDataSource1.Rows[0]["FAIL_NUM"].ToString(); string TestingWt1 = ultraDataSource1.Rows[0]["FAIL_WT"].ToString(); if (!StringUtil.IsInt(TestingNum)) { MessageBox.Show("合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (!StringUtil.IsDouble(TestingWt)) { MessageBox.Show("合格重量 请输入重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (!StringUtil.IsInt(TestingNum1)) { MessageBox.Show("废品支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (!StringUtil.IsDouble(TestingWt1)) { MessageBox.Show("废品重量 请输入重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } return true; } public void LoadData() { DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "6510" }, this.ob); cmbFaReason.DataSource = dt; cmbFaReason.ValueMember = "BASENAME"; YdmBaseClass.SetComboItemHeight(cmbFaReason); } private void ultraGrid1_CellChange(object sender, CellEventArgs e) { ultraGrid1.UpdateData(); if (e.Cell.Column.Key.Equals("FAIL_NUM")) { if (ultraDataSource1.Rows[0]["FAIL_NUM"].ToString().Equals("")) { ultraDataSource1.Rows[0]["FAIL_NUM"] = "0"; } double ctwt = 0; if (!ultraDataSource1.Rows[0]["PRO_WT"].ToString().Equals("0")) { if (actnum != null && !actnum.Equals("0")) { ctwt = double.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString()) * (double.Parse(actwt) / double.Parse(actnum)); } } ultraDataSource1.Rows[0]["FAIL_WT"] = ctwt.ToString("f3"); Value.FailWt = ultraDataSource1.Rows[0]["FAIL_WT"].ToString(); //ultraDataSource1.Rows[0]["PRO_NUM"] = (int.Parse(actnum) - int.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString())).ToString(); //ultraDataSource1.Rows[0]["PRO_NUM"] = (int.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString()) - int.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString())).ToString(); //Value.ProNum = ultraDataSource1.Rows[0]["PRO_NUM"].ToString(); //ultraDataSource1.Rows[0]["PRO_WT"] = (double.Parse(actwt) - ctwt).ToString("f3"); // ultraDataSource1.Rows[0]["PRO_WT"] = (double.Parse(ultraDataSource1.Rows[0]["PRO_WT"].ToString()) - ctwt).ToString("f3"); //Value.ProWt = ultraDataSource1.Rows[0]["PRO_WT"].ToString(); } if (e.Cell.Column.Key.Equals("PRO_NUM"))//动这个字段会进下面的内容里 { if (actnum != null && !actnum.Equals("0")) { e.Cell.Row.Cells["PRO_WT"].Value = (double.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString()) * (double.Parse(actwt)) / (double.Parse(actnum))).ToString("f3"); } if (ultraDataSource1.Rows[0]["FAIL_NUM"].ToString().Equals("")) { ultraDataSource1.Rows[0]["FAIL_NUM"] = "0"; } } } } }