using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Globalization; using System.Linq; using System.Text; using System.Windows.Forms; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Control.Entity; using CoreFS.CA06; using Core.Mes.Client.Comm.Control; using System.Collections; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Server; using Infragistics.Win.UltraWinDataSource; namespace Core.StlMes.Client.Mcp.Mch.MchResult { public partial class InformationZj: UserControl { private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null; public bool isReturn = true; /// /// 编辑区GRID /// public Infragistics.Win.UltraWinGrid.UltraGrid Grid { get { return _grid; } } public InformationZj() { InitializeComponent(); GridHelper.InitCardGrid(MatMesDataSource, ultraGrid4); _grid = this.ultraGrid4; //ultraGrid4.DisplayLayout. } public static void ResetUltraDataSource(UltraDataSource ultDataSource, UltraGrid ultraGrid) { try { ResetUltraDataSource(ultDataSource); } catch { } finally { if (ultraGrid != null) ultraGrid.UpdateData(); } } public static void ResetUltraDataSource(UltraDataSource ultDataSource) { try { if (ultDataSource.Rows.Count == 0) { InitUltraDataSource(ultDataSource); return; } for (int i = 0; i < ultDataSource.Band.Columns.Count; i++) { try { if (ultDataSource.Band.Columns[i].DataType == typeof(Bitmap) || ultDataSource.Band.Columns[i].DataType == typeof(Image)) ultDataSource.Rows[0][i] = null; else if (ultDataSource.Band.Columns[i].DataType == typeof(DateTime)) ultDataSource.Rows[0][i] = DBNull.Value; else if (ultDataSource.Band.Columns[i].DataType == typeof(decimal) || ultDataSource.Band.Columns[i].DataType == typeof(double) || ultDataSource.Band.Columns[i].DataType == typeof(Single)) ultDataSource.Rows[0][i] = 0; else ultDataSource.Rows[0][i] = ""; } catch { } } } catch { } } public static void InitUltraDataSource(UltraDataSource ultDataSource) { try { int iColumnsCount = ultDataSource.Band.Columns.Count; object[] obj = new object[iColumnsCount]; if (ultDataSource.Rows.Count > 0) ultDataSource.Rows.Clear(); for (int i = 0; i < ultDataSource.Band.Columns.Count; i++) { try { if (ultDataSource.Band.Columns[i].DataType == typeof(Bitmap) || ultDataSource.Band.Columns[i].DataType == typeof(Image)) obj[i] = null; else if (ultDataSource.Band.Columns[i].DataType == typeof(DateTime)) obj[i] = DBNull.Value; else if (ultDataSource.Band.Columns[i].DataType == typeof(decimal) || ultDataSource.Band.Columns[i].DataType == typeof(double) || ultDataSource.Band.Columns[i].DataType == typeof(Single)) obj[i] = 0; else obj[i] = ""; } catch { } } ultDataSource.Rows.Add(obj); } catch { } } public void CopyDataToDatatableplnZyZjDtail(DataTable dt, OpeBase ob) { ResetUltraDataSource(MatMesDataSource, UltraGrid4); string judgeStoveNo = dt.Rows[0]["JUDGE_STOVE_NO"].ToString(); //查询详情信息 //if (dt == null || dt.Rows[0]["ZJID"].ToString().Equals("")) //{ // return; //} UltraGridRow ultraGridinformationZj = this.UltraGrid4.ActiveRow; DataTable dtDtail = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmZjResult.getQueryZjDetail", new object[] { judgeStoveNo }, ob); if (dtDtail != null) { ultraGridinformationZj.Cells["incomingPcs"].Value = dtDtail.Rows[0]["INCOMING_PCS"].ToString(); ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value = dtDtail.Rows[0]["INCOMING_PCS"].ToString(); // ultraGridinformationZj.Cells["outofLine"].Value = dt.Rows[0]["INCOMING_PCS"].ToString(); // ultraGridinformationZj.Cells["rejectPcs"].Value = dt.Rows[0]["INCOMING_PCS"].ToString(); ultraGridinformationZj.Cells["scratchOut"].Value = dtDtail.Rows[0]["SCRATCH_OUT"].ToString(); ultraGridinformationZj.Cells["cracksOut"].Value = dtDtail.Rows[0]["SCRATCH_OUT"].ToString(); ultraGridinformationZj.Cells["arcBurnsOut"].Value = dtDtail.Rows[0]["ARC_BURNS_OUT"].ToString(); ultraGridinformationZj.Cells["laminationsOut"].Value = dtDtail.Rows[0]["LAMINATIONS_OUT"].ToString(); ultraGridinformationZj.Cells["geometricDeviationsOut"].Value = dtDtail.Rows[0]["GEOMETRIC_DEVIATIONS_OUT"].ToString(); ultraGridinformationZj.Cells["otherOut"].Value = dtDtail.Rows[0]["OTHER_OUT"].ToString(); ultraGridinformationZj.Cells["scratchPcs"].Value = dtDtail.Rows[0]["CRACKS_PCS"].ToString(); ultraGridinformationZj.Cells["dentPcs"].Value = dtDtail.Rows[0]["DENT_PCS"].ToString(); ultraGridinformationZj.Cells["dentOut"].Value = dtDtail.Rows[0]["DENT_OUT"].ToString(); ultraGridinformationZj.Cells["cracksPcs"].Value = dtDtail.Rows[0]["CRACKS_PCS"].ToString(); ultraGridinformationZj.Cells["arcBurnsPcs"].Value = dtDtail.Rows[0]["ARC_BURNS_PCS"].ToString(); ultraGridinformationZj.Cells["laminationsPcs"].Value = dtDtail.Rows[0]["LAMINATIONS_PCS"].ToString(); ultraGridinformationZj.Cells["arcBurnsPcs"].Value = dtDtail.Rows[0]["ARC_BURNS_PCS"].ToString(); ultraGridinformationZj.Cells["geometricDeviationsPcs"].Value = dtDtail.Rows[0]["GEOMETRIC_DEVIATIONS_PCS"].ToString(); ultraGridinformationZj.Cells["otherPcs"].Value = dtDtail.Rows[0]["OTHER_PCS"].ToString(); ultraGridinformationZj.Cells["ZJID"].Value = dtDtail.Rows[0]["ZJID"].ToString(); } } public ArrayList getplinZyZjdetal() { ArrayList plnZyZjcDtail = new ArrayList(); this.UltraGrid4.UpdateData(); UltraGridRow ultraGridinformationZj = this.UltraGrid4.ActiveRow; string incomingPcs = ultraGridinformationZj.Cells["incomingPcs"].Value.ToString(); string comprehensiveQualifiedPcs = ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value.ToString(); string outofLine = ultraGridinformationZj.Cells["outofLine"].Value.ToString(); string rejectPcs = ultraGridinformationZj.Cells["rejectPcs"].Value.ToString(); string scratchOut = ultraGridinformationZj.Cells["scratchOut"].Value.ToString(); string dentOut = ultraGridinformationZj.Cells["dentOut"].Value.ToString(); string cracksOut = ultraGridinformationZj.Cells["cracksOut"].Value.ToString(); string arcBurnsOut = ultraGridinformationZj.Cells["arcBurnsOut"].Value.ToString(); string laminationsOut = ultraGridinformationZj.Cells["laminationsOut"].Value.ToString(); string laminationsPcs = ultraGridinformationZj.Cells["laminationsPcs"].Value.ToString(); string geometricDeviationsOut = ultraGridinformationZj.Cells["geometricDeviationsOut"].Value.ToString(); string otherOut = ultraGridinformationZj.Cells["otherOut"].Value.ToString(); string scratchPcs = ultraGridinformationZj.Cells["scratchPcs"].Value.ToString(); string dentPcs = ultraGridinformationZj.Cells["dentPcs"].Value.ToString(); string cracksPcs = ultraGridinformationZj.Cells["cracksPcs"].Value.ToString(); string arcBurnsPcs = ultraGridinformationZj.Cells["arcBurnsPcs"].Value.ToString(); string geometricDeviationsPcs = ultraGridinformationZj.Cells["geometricDeviationsPcs"].Value.ToString(); string otherPcs = ultraGridinformationZj.Cells["otherPcs"].Value.ToString(); string zjid = ultraGridinformationZj.Cells["ZJID"].Value.ToString(); plnZyZjcDtail.Add(incomingPcs); plnZyZjcDtail.Add(comprehensiveQualifiedPcs); plnZyZjcDtail.Add(scratchOut); plnZyZjcDtail.Add(scratchPcs); plnZyZjcDtail.Add(dentOut); plnZyZjcDtail.Add(dentPcs); plnZyZjcDtail.Add(cracksOut); plnZyZjcDtail.Add(cracksPcs); plnZyZjcDtail.Add(arcBurnsOut); plnZyZjcDtail.Add(arcBurnsPcs); plnZyZjcDtail.Add(laminationsOut); plnZyZjcDtail.Add(laminationsPcs); plnZyZjcDtail.Add(geometricDeviationsOut); plnZyZjcDtail.Add(geometricDeviationsPcs); plnZyZjcDtail.Add(otherOut); plnZyZjcDtail.Add(otherPcs); plnZyZjcDtail.Add(zjid); return plnZyZjcDtail; } /// /// 刷新控件数据显示 /// public void UpdateData() { // if (_plan != null) // { // //生产批号 // MatMesDataSource.Rows[0]["RollLotNo"]= _plan.LotNo; // //炉号 // MatMesDataSource.Rows[0]["HeatNo"] = _plan.JudgeStoveNo; // //监制 // MatMesDataSource.Rows[0]["Producer"] = _plan.Producer; // //执行工艺号 // MatMesDataSource.Rows[0]["ImpProcess"] = _plan.ImpProcess; // //执行工艺号路径 // MatMesDataSource.Rows[0]["ImpProcessPath"] = _plan.ImpProcessPath; // //工序合同号 // MatMesDataSource.Rows[0]["ContractNo"] = _plan.ContractNo; // //品种,标准类别 钢级,规格,扣型 // string Pz = ""; // Pz = _plan.Varieties + "," + _plan.StdStyleDesc + " " + _plan.SteelName + "," + _plan.PipeSize + "," + _plan.BuckleType; // if (_plan.StdStyleDesc == null) // { // Pz = _plan.Varieties + "," + _plan.SteelName + "," + _plan.PipeSize + "," + _plan.BuckleType; // } // MatMesDataSource.Rows[0]["Varieties"] = Pz; // //长度范围 // MatMesDataSource.Rows[0]["LengthRange"] = _plan.LengthRange; // //用户 // MatMesDataSource.Rows[0]["FinishUser"] = _plan.FinishUser; // //轧管判定标准 // MatMesDataSource.Rows[0]["RollStandard"] = _plan.RollStandrad; // //单倍长 // MatMesDataSource.Rows[0]["DbLength"] = _plan.DbLength; // //制程号 // MatMesDataSource.Rows[0]["ProcessNo"] = _plan.ProcessNo; // //炼钢判定标准 // MatMesDataSource.Rows[0]["SteelStandard"] = _plan.SteelStandrad; // //目标长度 // MatMesDataSource.Rows[0]["ContractLength"] = _plan.TargetLength; // //去向 // MatMesDataSource.Rows[0]["Destination"] = _plan.Target; // //断面,钢种 // string DM = ""; // DM = _plan.PipeSection + "," + _plan.GradeName; // MatMesDataSource.Rows[0]["Section"] = DM; // //成品备注 // MatMesDataSource.Rows[0]["ProductRemark"] = _plan.ReMark; // //轧制长度 // MatMesDataSource.Rows[0]["RollLength"] = _plan.RollLength; // //分切数 // MatMesDataSource.Rows[0]["SawSize"] = _plan.SawNum; // //工艺状态 // MatMesDataSource.Rows[0]["Status"] = _plan.ProcessStatus; // //支 // MatMesDataSource.Rows[0]["PlanNum"] = _plan.PlanNum; // //吨 // MatMesDataSource.Rows[0]["PlanTons"] = _plan.PlanTon; // //目标库 // MatMesDataSource.Rows[0]["TargetLirbrary"] = _plan.TargetLiabrary; // } // else // { // //GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1); // } } /// /// 控件编辑后更新已修改数据 /// public new void Update() { ultraGrid4.UpdateData(); } private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e) { // string CraftPath = _plan.ImpProcessPath.ToString().Trim(); // if (CraftPath == "" ) // { // return; // } // BaseMethod.ViewCarft_No(CraftPath); } private void ultraGrid4_KeyPress(object sender, KeyPressEventArgs e) { if (this.ultraGrid4.ActiveCell == null) return; string strKey = this.ultraGrid4.ActiveCell.Column.ToString(); if (!(e.KeyChar == '\b') && ultraGrid4.ActiveRow.Cells[strKey].Value.ToString().Length >= 4) { e.Handled = true; } if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.')) { e.Handled = true; } if (e.KeyChar == '.') { char[] arrary = ultraGrid4.ActiveRow.Cells[strKey].Text.ToCharArray(); if (arrary.Length == 0) { ultraGrid4.ActiveRow.Cells[strKey].Value = "0."; ultraGrid4.ActiveRow.Cells[strKey].SelStart = ultraGrid4.ActiveRow.Cells[strKey].Value.ToString().Length; e.Handled = true; } else { for (int i = 0; i < arrary.Length; i++) { if (arrary[i] == '.') e.Handled = true; } } } } private void ultraGrid4_KeyUp(object sender, KeyEventArgs e) { string strKey = this.ultraGrid4.ActiveCell.Column.ToString(); this.UltraGrid4.UpdateData(); UltraGridRow ultraGridinformationZj = this.ultraGrid4.ActiveRow; double num1 = Double.Parse(ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value.ToString()); double num2 = Double.Parse(ultraGridinformationZj.Cells["scratchOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["scratchOut"].Value.ToString()); double num3 = Double.Parse(ultraGridinformationZj.Cells["scratchPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["scratchPcs"].Value.ToString()); double num4 = Double.Parse(ultraGridinformationZj.Cells["dentOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["dentOut"].Value.ToString()); double num5 = Double.Parse(ultraGridinformationZj.Cells["dentPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["dentPcs"].Value.ToString()); double num6 = Double.Parse(ultraGridinformationZj.Cells["cracksOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["cracksOut"].Value.ToString()); double num7 = Double.Parse(ultraGridinformationZj.Cells["cracksPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["cracksPcs"].Value.ToString()); double num8 = Double.Parse(ultraGridinformationZj.Cells["arcBurnsOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["arcBurnsOut"].Value.ToString()); double num9 = Double.Parse(ultraGridinformationZj.Cells["arcBurnsPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["arcBurnsPcs"].Value.ToString()); double num10 = Double.Parse(ultraGridinformationZj.Cells["laminationsOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["laminationsOut"].Value.ToString()); double num11 = Double.Parse(ultraGridinformationZj.Cells["laminationsPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["laminationsPcs"].Value.ToString()); double num12 = Double.Parse(ultraGridinformationZj.Cells["geometricDeviationsOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["geometricDeviationsOut"].Value.ToString()); double num13 = Double.Parse(ultraGridinformationZj.Cells["geometricDeviationsPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["geometricDeviationsPcs"].Value.ToString()); double num14 = Double.Parse(ultraGridinformationZj.Cells["otherOut"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["otherOut"].Value.ToString()); double num15 = Double.Parse(ultraGridinformationZj.Cells["otherPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["otherPcs"].Value.ToString()); double num16 = Double.Parse(ultraGridinformationZj.Cells["incomingPcs"].Value.ToString().Equals("") ? "0" : ultraGridinformationZj.Cells["incomingPcs"].Value.ToString()); double num = num16 - (num2 + num3 + num4 + num5 + num6 + num7 + num8 + num9 + num10 + num11 + num12 + num13 + num14 + num15); if (num < 0) { //ultraGridinformationZj.Cells[strKey].Value = ""; ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value = num1; isReturn = false; } else { ultraGridinformationZj.Cells["comprehensiveQualifiedPcs"].Value = num; isReturn = true; } } } }