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