MES_Client/TGMES/Core.StlMes.Client.Mcp.Mch/McmZj/InformationZj.cs

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;
        /// <summary>
        /// 编辑区GRID
        /// </summary>
        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;
        }
        



        /// <summary>
        /// 刷新控件数据显示
        /// </summary>
        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);
        //    }
        }

        /// <summary>
        /// 控件编辑后更新已修改数据
        /// </summary>
        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;
            }
        }

    }
}