MES_Client/TGMES/Core.StlMes.Client.ZGMil/NodeResultQuery/FrmNodeResultQuery.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.ZGMil.Common;

namespace Core.StlMes.Client.ZGMil.NodeResultQuery
{
    public partial class FrmNodeResultQuery : FrmBase
    {

        string JudgeStoveNo = "";
        string ResultNo = "";
        int _ProcessNo = 0;
        int FeedNum = 0;
        int ScrapFeedNum = 0;
        int ScrapNum = 0;
        int QANum = 0;
        int ChangeNum = 0;
        double QYHeight = 0;
        double QYLength = 0;
        double QAHeight = 0;
        OpeBase _ob = null;

        int DETECTION_NUM = 0;//检测支数
        int SUSPECT_PRODUCT_NUM = 0;//可疑品支数
        int REINSPECTION_NUM = 0;//复探支数
        int REINSPECTION_QUALIFIED_NUM = 0;//复探合格支数
        int SCRAP_NUM = 0;//最终废品支数
        int QUALIFIED_NUM = 0;//最终合格支数

        int SCRAP_NUM1 = 0;//1‘操作台矫废支数
        int QUALIFIED_NUM1 = 0;//1’操作台合格支数
        int SCRAP_NUM2 = 0;//2‘操作台矫废支数
        int QUALIFIED_NUM2 = 0;//2’操作台合格支数
        int SCRAP_NUM3 = 0;//3‘操作台矫废支数
        int QUALIFIED_NUM3 = 0;//3’操作台合格支数
        int IN_MAT_NUM = 0;//来料支数
        // int SCRAP_NUM = 0;//最终废品支数
        // int QUALIFIED_NUM = 0;//最终合格支数

        /// <summary>
        /// 
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="ProcessNo">1-锯切 2-加热炉 3-穿孔 4-连轧 5-再加热炉 6-定径 7-ET探伤 8-人工质检 9-分切 10-矫直 11-MT 12-UT </param>
        public FrmNodeResultQuery(DataTable dt, int ProcessNo, string Date, string Shift, string Group, OpeBase ob)
        {
            DataTable refdt = new DataTable();
            InitializeComponent();
            _ProcessNo = ProcessNo;
            _ob = ob;
            switch (Shift)
            {
                case "0":
                    Shift = "常白班";
                    break;
                case "1":
                    Shift = "早班";
                    break;
                case "2":
                    Shift = "中班";
                    break;
                case "3":
                    Shift = "夜班";
                    break;
            }
            switch (Group)
            {
                case "1":
                    Group = "甲";
                    break;
                case "2":
                    Group = "乙";
                    break;
                case "3":
                    Group = "丙";
                    break;
                case "4":
                    Group = "丁";
                    break;
            }
            switch (ProcessNo)
            {
                case 1:
                    refdt = dtFeed;
                    ultraTabControl1.Tabs[0].Visible = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 2:
                    refdt = dtFur;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 3:
                    refdt = dtPer;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 4:
                    refdt = dtRoll;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 5:
                    refdt = dtReFur;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 6:
                    refdt = dtSizing;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 7:
                    refdt = dtETResult;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = true;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 8:
                    refdt = dtSurface;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = true;
                    label16.Text = "废品量";
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 9:
                    refdt = dtSawResult;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = true;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 10:
                    refdt = dtStraight;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = true;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 11:
                    refdt = dtMT;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = true;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
                case 12:
                    refdt = dtUT;
                    ultraTabControl1.Tabs[0].Visible = false;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = true;
                    ultraTabControl1.Tabs[3].Visible = false;
                    ultraTabControl1.Tabs[4].Visible = false;
                    ultraTabControl1.Tabs[5].Visible = false;
                    GridDisplay(ProcessNo - 1);
                    break;
            }
            txtDate.Text = Date;
            txtShift.Text = Shift;
            txtGroup.Text = Group;
            refdt.Clear();
            // ultraGrid1.DataSource = refdt;
            GridHelper.CopyDataToDatatable(ref dt, ref refdt, true);
            TotalEdit(ProcessNo);
        }

        public void TotalEdit(int ProcessNo)
        {
            switch (ProcessNo)
            {
                case 1:
                    FeedTotalData();
                    break;
                case 2:
                    FurTotalData();
                    break;
                case 3:
                    PerTotalData();
                    break;
                case 4:
                    RollTotalData();
                    break;
                case 5:
                    ReFurTotalData();
                    break;
                case 6:
                    SizingTotalData();
                    break;
                case 7:
                    ETResultTotalData();
                    break;
                case 8:
                    SurfaceTotalData();
                    break;
                case 9:
                    SAWResultTotalData();
                    break;
                case 10:
                    StraightTotalData();
                    break;
                case 11:
                    MTandUTTotalData();
                    break;
                case 12:
                    MTandUTTotalData();
                    break;


            }
        }
        /// <summary>
        /// 上料数据统计
        /// </summary>
        public void FeedTotalData()
        {

            if (ultraGrid0.Rows.Count > 0)
            {

                foreach (UltraGridRow ugr in ultraGrid0.Rows)
                {
                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    ScrapFeedNum += Convert.ToInt32(ugr.Cells["BEFORE_SCRAP_NUM"].Value.ToString());
                    ScrapNum += Convert.ToInt32(ugr.Cells["AFTER_SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["CUT_NUM"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["CHANGE_NUM"].Value.ToString()))
                    {
                        ChangeNum += 0;
                    }
                    else
                    {
                        ChangeNum += Convert.ToInt32(ugr.Cells["CHANGE_NUM"].Value.ToString());
                    }
                    if (!string.IsNullOrEmpty(ugr.Cells["CUT_WEIGHT"].Value.ToString()))
                    {
                        QYHeight += Convert.ToDouble(ugr.Cells["CUT_WEIGHT"].Value.ToString());
                    }
                    else
                    {
                        QYHeight += 0;
                    }
                    QYLength += Convert.ToDouble(ugr.Cells["CUT_LENGTH"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }
                }
                //lblFeedNum.Text = FeedNum.ToString();
                lblScrapFeedNum.Text = ScrapFeedNum.ToString();
                lblScrapNum.Text = ScrapNum.ToString();
                lblQANum.Text = (QANum-ChangeNum).ToString();
                lblQYHeight.Text = QYHeight.ToString();
                lblQYLength.Text = QYLength.ToString();
                lblQATons.Text = QAHeight.ToString();

            }
        }

        /// <summary>
        /// 加热炉数据统计
        /// </summary>
        public void FurTotalData()
        {
            if (ultraGrid1.Rows.Count > 0)
            {

                foreach (UltraGridRow ugr in ultraGrid1.Rows)
                {

                    ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["OUT_FUR_NUM"].Value.ToString());
                    //QAHeight += Convert.ToDouble(ugr.Cells["CUT_HEIGHT"].Value.ToString());
                    double BurnningRate = 0;
                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    ChangeNum += Convert.ToInt32(ugr.Cells["CHANGE_NUM"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }

                    lblRollScrapNum.Text = ScrapNum.ToString();
                    lblRollQANum.Text = QANum.ToString();
                    lblRollTons.Text = QAHeight.ToString();
                }
            }
        }

        /// <summary>
        /// 穿孔数据统计
        /// </summary>
        public void PerTotalData()
        {
            if (ultraGrid2.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid2.Rows)
                {
                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["PERFORATION_NUM"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }
                    lblRollScrapNum.Text = ScrapNum.ToString();
                    lblRollQANum.Text = QANum.ToString();
                    lblRollTons.Text = QAHeight.ToString();
                }
            }
        }

        /// <summary>
        /// 连轧数据统计
        /// </summary>
        public void RollTotalData()
        {
            if (ultraGrid3.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid3.Rows)
                {
                    ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());

                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }
                }
                lblRollScrapNum.Text = ScrapNum.ToString();
                lblRollQANum.Text = QANum.ToString();
                lblRollTons.Text = QAHeight.ToString();
            }
        }


        /// <summary>
        /// 再加热炉数据统计
        /// </summary>
        public void ReFurTotalData()
        {
            if (ultraGrid4.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid4.Rows)
                {
                    ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["OUT_FUR_NUM"].Value.ToString());
      
                
                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }
                }

                lblRollScrapNum.Text = ScrapNum.ToString();
                lblRollQANum.Text = QANum.ToString();
                lblRollTons.Text = QAHeight.ToString();
            }
        }


        /// <summary>
        /// 定径数据统计
        /// </summary>
        public void SizingTotalData()
        {
            if (ultraGrid5.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid5.Rows)
                {
                    ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                    QANum += Convert.ToInt32(ugr.Cells["PRODUCT_NUM"].Value.ToString());


                    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
                    {
                        QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
                    }
                    else
                    {
                        QAHeight += 0;
                    }
                }

                lblRollScrapNum.Text = ScrapNum.ToString();
                lblRollQANum.Text = QANum.ToString();
                lblRollTons.Text = QAHeight.ToString();
            }
        }

        /// <summary>
        /// 探伤实绩统计
        /// </summary>
        public void ETResultTotalData()
        {
            if (this.ultraGrid6.Rows.Count > 0)
            {
                int scrap1 = 0; int qu1 = 0; int re1 = 0; int requ1 = 0; int de1 = 0; int su1 = 0;
                int scrap2 = 0; int qu2 = 0; int re2 = 0; int requ2 = 0; int de2 = 0; int su2 = 0;
                int scrap3 = 0; int qu3 = 0; int re3 = 0; int requ3 = 0; int de3 = 0; int su3 = 0;
                foreach (UltraGridRow ugr in ultraGrid6.Rows)
                {
                    scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
                    qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
                    re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
                    requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
                    de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
                    su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());

                    scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
                    qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
                    re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
                    requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
                    de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
                    su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());

                    scrap3 += Convert.ToInt32(ugr.Cells["SCRAP_NUM3"].Value.ToString());
                    qu3 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM3"].Value.ToString());
                    re3 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM3"].Value.ToString());
                    requ3 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM3"].Value.ToString());
                    de3 += Convert.ToInt32(ugr.Cells["DETECTION_NUM3"].Value.ToString());
                    su3 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM3"].Value.ToString());
                }
                labetscrp1.Text = scrap1.ToString();
                labetqu1.Text = qu1.ToString();
                labetre1.Text = re1.ToString();
                labetrequ1.Text = requ1.ToString();
                labetde1.Text = de1.ToString();
                labetsu1.Text = su1.ToString();

                labetscrp2.Text = scrap2.ToString();
                labetqu2.Text = qu2.ToString();
                labetre2.Text = re2.ToString();
                labetrequ2.Text = requ2.ToString();
                labetde2.Text = de2.ToString();
                labetsu2.Text = su2.ToString();

                labetscrp3.Text = scrap3.ToString();
                labetqu3.Text = qu3.ToString();
                labetre3.Text = re3.ToString();
                labetrequ3.Text = requ3.ToString();
                labetde3.Text = de3.ToString();
                labetsu3.Text = su3.ToString();

                labetscrptotal.Text = (scrap1 + scrap2 + scrap3).ToString();
                labetqutotal.Text = (qu1 + qu2 + qu3).ToString();
                labetretotal.Text = (re1 + re2 + re3).ToString();
                labetrequtotal.Text = (requ1 + requ2 + requ3).ToString();
                labetdetotal.Text = (de1 + de2 + de3).ToString();
                labetsutotal.Text = (su1 + su2 + su3).ToString();

            }
        }

        /// <summary>
        /// 分切实绩统计
        /// </summary>
        public void SAWResultTotalData()
        {
            double CUT_HEAD_LENGTH_TOTAL = 0;
            double CUT_TRAIL_LENGTH_TOTAL = 0;
            double CUT_HEAD_HEIGHT_TOTAL = 0;
            double CUT_TRAIL_HEIGTH_TOTAL = 0;
            int SCRAP_NUM = 0;
            int SCRAP_DBNUM = 0;
            int CUT_NUM = 0;
            int CUT_DBNUM = 0;
            if (this.ultraGrid8.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid8.Rows)
                {
                    CUT_HEAD_LENGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_HEAD_LENGTH_TOTAL"].Value.ToString()); //切头总长度
                    CUT_TRAIL_LENGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_TRAIL_LENGTH_TOTAL"].Value.ToString());//   切尾总长度
                    CUT_HEAD_HEIGHT_TOTAL += Convert.ToDouble(ugr.Cells["CUT_HEAD_HEIGHT_TOTAL"].Value.ToString());//  切头总重量
                    CUT_TRAIL_HEIGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_TRAIL_HEIGTH_TOTAL"].Value.ToString());//  切尾总重量
                    SCRAP_NUM += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());//  切前剔除支数
                    SCRAP_DBNUM += Convert.ToInt32(ugr.Cells["SCRAP_DBNUM"].Value.ToString());//  剔除支数
                    CUT_NUM += Convert.ToInt32(ugr.Cells["CUT_NUM"].Value.ToString());// 切前合格支数
                    CUT_DBNUM += Convert.ToInt32(ugr.Cells["CUT_DBNUM"].Value.ToString());//  切后支数

                }
                //lable赋值
                labCUT_HEAD_LENGTH_TOTAL.Text = Convert.ToString(CUT_HEAD_LENGTH_TOTAL);
                labCUT_TRAIL_LENGTH_TOTAL.Text = Convert.ToString(CUT_TRAIL_LENGTH_TOTAL);
                labCUT_HEAD_HEIGHT_TOTAL.Text = Convert.ToString(CUT_HEAD_HEIGHT_TOTAL);
                labCUT_TRAIL_HEIGTH_TOTAL.Text = Convert.ToString(CUT_TRAIL_HEIGTH_TOTAL);
                labSCRAP_NUM1.Text = Convert.ToString(SCRAP_NUM);
                labSCRAP_DBNUM1.Text = Convert.ToString(SCRAP_DBNUM);
                labCUT_NUM1.Text = Convert.ToString(CUT_NUM);
                labCUT_DBNUM1.Text = Convert.ToString(CUT_DBNUM);
            }
        }
        /// <summary>
        /// 结炉实绩统计
        /// </summary>
        public void SurfaceTotalData()
        {
            if (this.ultraGrid7.Rows.Count > 0)
            {
                int num_QUALIFIED_BRANCH = 0;//合格支数
                double num_QUALIFIED_TONS = 0.0;//合格吨数
                double num_WASTE_QUANTITY = 0.0;//废品量
                int num = 1;
                double wgt = 0.0;
                double wasteTon = 0.0;
                foreach (UltraGridRow ugr in ultraGrid7.Rows)
                {
                    int.TryParse(ugr.Cells["QUALIFIED_BRANCH"].Value.ToString(), out num);
                    num_QUALIFIED_BRANCH += num;//合格总支数

                    double.TryParse(ugr.Cells["QUALIFIED_TONS"].Value.ToString(), out wgt);
                    num_QUALIFIED_TONS += wgt;//合格总吨数

                    double.TryParse(ugr.Cells["WASTE_QUANTITY"].Value.ToString(), out wasteTon);
                    num_WASTE_QUANTITY += wasteTon;//废品总量
                }
                lblRollScrapNum.Text = num_WASTE_QUANTITY.ToString();
                lblRollQANum.Text = num_QUALIFIED_BRANCH.ToString();
                lblRollTons.Text = num_QUALIFIED_TONS.ToString();
            }
        }
        /// <summary>
        /// 矫直实绩统计
        /// </summary>
        public void StraightTotalData()
        {
            if (this.ultraGrid9.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid9.Rows)
                {
                    SCRAP_NUM1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString()); //1‘操作台矫废支数
                    QUALIFIED_NUM1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());//1’操作台合格支数
                    SCRAP_NUM2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());//2‘操作台矫废支数
                    QUALIFIED_NUM2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());//2’操作台合格支数
                    SCRAP_NUM3 += Convert.ToInt32(ugr.Cells["SCRAP_NUM3"].Value.ToString());//3‘操作台矫废支数
                    QUALIFIED_NUM3 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM3"].Value.ToString());//3’操作台合格支数
                    IN_MAT_NUM += Convert.ToInt32(ugr.Cells["IN_MAT_NUM"].Value.ToString());//来料支数
                    SCRAP_NUM += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());//来料支数;//最终废品支数
                    QUALIFIED_NUM += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());//来料支数;//最终合格支数                 
                }
                labSCRAP_NUM11.Text = SCRAP_NUM1.ToString();
                labQUALIFIED_NUM11.Text = QUALIFIED_NUM1.ToString();
                labSCRAP_NUM22.Text = SCRAP_NUM2.ToString();
                labQUALIFIED_NUM22.Text = QUALIFIED_NUM2.ToString();
                labSCRAP_NUM33.Text = SCRAP_NUM3.ToString();
                labQUALIFIED_NUM33.Text = QUALIFIED_NUM3.ToString();
                labIN_MAT_NUMs.Text = IN_MAT_NUM.ToString();
                labSCRAP_NUMs.Text = SCRAP_NUM.ToString();
                labQUALIFIED_NUMs.Text = QUALIFIED_NUM.ToString();
            }

        }

        /// <summary>
        /// MT，UT统计
        /// </summary>
        public void MTandUTTotalData()
        {
            if (ultraGrid11.Rows.Count >0||ultraGrid10.Rows.Count>0)
            {
                int scrap1 = 0; int qu1 = 0; int re1 = 0; int requ1 = 0; int de1 = 0; int su1 = 0;
                int scrap2 = 0; int qu2 = 0; int re2 = 0; int requ2 = 0; int de2 = 0; int su2 = 0;
                int scrap = 0; int qu = 0; int re = 0; int requ = 0; int de = 0; int su = 0;
                double quweight = 0;

                if (ultraGrid11.Rows.Count > 0)
                {
                    foreach (UltraGridRow ugr in ultraGrid11.Rows)
                    {
                        scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
                        qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
                        re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
                        requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
                        de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
                        su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());

                        scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
                        qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
                        re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
                        requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
                        de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
                        su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());

                       
                    }
                }
                if (ultraGrid10.Rows.Count > 0)
                {
                    foreach (UltraGridRow ugr in ultraGrid10.Rows)
                    {
                        scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
                        qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
                        re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
                        requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
                        de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
                        su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());

                        scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
                        qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
                        re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
                        requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
                        de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
                        su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());

                        scrap += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
                        qu += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());
                        re += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM"].Value.ToString());
                        requ += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM"].Value.ToString());
                        de += Convert.ToInt32(ugr.Cells["DETECTION_NUM"].Value.ToString());
                        su += Convert.ToInt32(ugr.Cells["ALARM_NUM"].Value.ToString());
                        quweight += double.Parse(ugr.Cells["QA_TON"].Value.ToString()); 
                    }
                }

                labmtscrap1.Text = scrap1.ToString();
                labmtqu1.Text = qu1.ToString();
                labmtre1.Text = re1.ToString();
                labmtrequ1.Text = requ1.ToString();
                labmtde1.Text = de1.ToString();
                labmtsu1.Text = su1.ToString();

                labmtscrap2.Text = scrap2.ToString();
                labmtqu2.Text = qu2.ToString();
                labmtre2.Text = re2.ToString();
                labmtrequ2.Text = requ2.ToString();
                labmtde2.Text = de2.ToString();
                labmtsu2.Text = su2.ToString();
                if (ultraGrid10.Rows.Count > 0)
                {
                    labmtscraptotal.Text = (scrap).ToString();
                    labmtqutotal.Text = (qu).ToString();
                    labmtretotal.Text = (re).ToString();
                    labmtrequtotal.Text = (requ).ToString();
                    labmtdetotal.Text = (de).ToString();
                    labmtsutotal.Text = (su).ToString();
                    labmtquweight.Text = quweight.ToString();
                }
                else if (ultraGrid11.Rows.Count > 0)
                {
                    labmtscraptotal.Text = (scrap1 + scrap2).ToString();
                    labmtqutotal.Text = (qu1 + qu2).ToString();
                    labmtretotal.Text = (re1 + re2).ToString();
                    labmtrequtotal.Text = (requ1 + requ2).ToString();
                    labmtdetotal.Text = (de1 + de2).ToString();
                    labmtsutotal.Text = (su1 + su2).ToString();
                }
                

                
            }

        }



        private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
        {
            if (ultraGrid1.ActiveRow == null)
            {
                return;
            }
            JudgeStoveNo = ultraGrid1.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
            ResultNo = ultraGrid1.ActiveRow.Cells["RESULT_NO"].Value.ToString();
            string ColumnName = "";
            string ColumnValue = "";
            int Flag = 0;
            if (e.Cell.Column.Key == "JUDGE_NO")
            {
                return;
            }
            else if (e.Cell.Column.Style == Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime)
            {
                Flag = 1;
            }
            ColumnName = e.Cell.Column.Key;
            ColumnValue = e.Cell.Value.ToString();
            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.updateResult", new object[] { JudgeStoveNo, ResultNo, ColumnName, ColumnValue, _ProcessNo, Flag }, this._ob);
        }

        private void FrmNodeResultQuery_FormClosing(object sender, FormClosingEventArgs e)
        {
            ultraGrid1.UpdateData();
        }

        /// <summary>
        /// 结炉实绩TAB页显示控制
        /// </summary>
        /// <param name="ProcessNo"></param>
        private void GridDisplay(int ProcessNo)
        {
            for (int i = 0; i < 12; i++)
            {
                ultraTabControl2.Tabs[i].Visible = false;

            }
            ultraTabControl2.Tabs[ProcessNo].Visible = true;
        }


    }
}