MES_Client/TGMES/Core.StlMes.Client.ZGMil/Result/FrmStraighteningResult.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 CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using com.steering.mes.zgmil.entity;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.NodeResultQuery;
using Core.StlMes.Client.ZGMil.ResultConrtrol;
using Core.StlMes.Client.ZGMil.Entity;
using System.Net;
using Core.StlMes.Client.ZGMil.Common;
using Core.StlMes.Client.ZGMil.Popup;
using CoreFS.SA06;

namespace Core.StlMes.Client.ZGMil.Result
{
    public partial class FrmStraighteningResult : FrmBase
    {
        #region  初始化
        private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;

        public Infragistics.Win.UltraWinGrid.UltraGrid Grid
        {
            get { return _grid; }
        }

        public FrmStraighteningResult()
        {
            InitializeComponent();
        }
        int PanelSizeFlag = 0;
        RollingInfomation rf = new RollingInfomation();
        FeedRowPlan QuertFeedplan = new FeedRowPlan();
        MilPlan QueryMainPlan = new MilPlan();
        FeedRowPlan Feedplan = new FeedRowPlan();
        MilPlan MainPlan = new MilPlan();
        SawResult FeedSawResult = new SawResult();
        string PlanStatusQuery = "79";
        string PlanStartStatusQuery = "00"; //查询结炉实绩起始状态
        MilStraighteningResultEntity StraighteningResult = new MilStraighteningResultEntity();


        private string ActiveJUDGE_STOVE_NO = null;//主计划活动行的判定炉号
        private string ActiveStatus = null;////主计划活动行的状态
        private string proPlanId = null;//轧管订单编号
        private string gxPlanNo = null;//工序排产序号
        private string lotNo = null;//生产批号
        private string ActiveOFFLINE_FLAG = null;
        private string ActiveResultNo = null;
        private string WorkStand = "";//工作台
        private string Departm = "";//部门
        private string PlineCode = "";//产线
        private string stoveno = "";
        private string lotno = "";
        private string Flage = "";//
        MilStraighteningResultEntity temprstraght = new MilStraighteningResultEntity();//保存当前实绩类

        private string offlinenode = "";

        private string Shift = "";
        private string Group = "";
        private string _User = "";
        private string _UserName = ""; //签名 姓名
        private string _Url = "";      //签名 Url
        private string _UserID = "";      //签名 签名ID
        private string ChangeUserID = "";

        private string beforeQualifiedNum = "";//上道工序合格支数
        private string qualifiedNum = "";//该工序合格支数
        private string scrapNum = "";//该工序废品支数
        private string offineHas = "";//已下线支数
        private string offineHead = "";//返线支数
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //取消卡片筛选
            rollingInfomation1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            rollingCard1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            straighteningResult1.UltraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            frmStraighteningResult11.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            frmStraighteningResult21.UltraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGridPlan.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid_GHDL1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid_GHDL2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid_GHDL3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //ChangeGridColor();
            InitControl();
            //PanelSizeFlag = 0;

            //splitContainer2.SplitterDistance = 180;
            foreach (UltraGridColumn ugc in ultraGridPlan.DisplayLayout.Bands[0].Columns)
            {
                ugc.SortIndicator = SortIndicator.Disabled;
            }
        }

        protected override void OnShown(EventArgs e)
        {
            base.OnShown(e);
            string hostname = Dns.GetHostName();
            IPAddress ip = Dns.GetHostByName(hostname).AddressList[0];
            NativeMethodNew na = new NativeMethodNew(this.ob);
            WorkStand = na.GetOperateResult(ip.ToString(), "1");
            if (!WorkStand.Contains("矫直"))
            {
                //MessageBox.Show("提示：该电脑不是矫直操作台电脑，不允许操作改界面", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //this.Dispose();
                //this.Close();
                //return;
            }
            if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
            {
                offlinenode = "01";
            }
            if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
            {
                offlinenode = "02";

            }
            if (WorkStand.Contains("矫直") && WorkStand.Contains("3"))
            {
                offlinenode = "03";
            }
            Departm = UserInfo.GetDepartment();
            PlineCode = na.GetPCode(Departm);//获取 用户 对应的产线
            if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017") || PlineCode.Equals("C072"))
            {
                this.rollingCard1.ChangCard();
            }
            PlanQuery();

            //foreach (UltraGridRow ugr in ultraGridPlan.Rows)
            //{

            //    ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());

            //}
            Shift = UserInfo.GetUserOrder();
            Group = UserInfo.GetUserGroup();
            Sign();
            ShowShift();
        }

        private void ShowShift()
        {
            colShowShiftGroup1.Ob = this.ob;
            colShowShiftGroup1.Group = this.UserInfo.GetUserGroup();
            colShowShiftGroup1.Shift = this.UserInfo.GetUserOrder();
            colShowShiftGroup1.ShowShift();
            colShowShiftGroup1.Timer1.Enabled = true;
        }

        /// <summary>
        /// 初始化控件
        /// </summary>
        public void InitControl()
        {
            if (chkLotNo.Checked)
            {
                txtLOT_NO.Enabled = true;
            }
            else
            {
                txtLOT_NO.Enabled = false;
            }
            if (chkHeatNo.Checked)
            {
                txtJudgeStoveNo.Enabled = true;
            }
            else
            {
                txtJudgeStoveNo.Enabled = false;
            }
        }


        #endregion
        /// <summary>
        /// 签名
        /// </summary>
        private void Sign()
        {
            ColUserName col = new ColUserName();
            col.StationId = "7";
            col.PlineCode = PlineCode;
            col.ColGroup = Group;
            col.Ob = this.ob;
            col.ShowDialog();
            _UserID = col.getUserId();
            _UserName = col.getUserName();
        }
        /// <summary>
        /// 按钮事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    PlanQuery();
                    break;
                case "Save":
                    StraighteningSave();
                    break;
                case "Node":
                    StraighteningNode();
                    break;
                case "DoNodeBack":
                    NodeBack();
                    break;
                case "NodeQuery":
                    NodeQuery();
                    break;
                case "colchang":
                    colchang();
                    break;
                case "DoChangeCancel":
                    ChangeShiftBack();
                    break;
                case "DoPrint":
                    PrintResult();
                    break;
                case "Dooffline":
                    Offline();
                    break;
                case "Doofflinre2":
                    Offline2();
                    break;
                case "Doofflinre3":
                    Offline3();
                    break;
                case "ReLine1":
                    BackLine1();
                    break;
                case "ReLine2":
                    BackLine2();
                    break;
                case "ReLine3":
                    BackLine3();
                    break;
                case "DoStart":
                    DoStart();
                    break;
                case "DoStartBack":
                    StartBack();
                    break;
                case "DoSign":
                    Sign();
                    break;
                case "Close":
                    this.Dispose();
                    this.Close();
                    break;

            }
        }


        #region  辅助事件方法及赋值
        /// <summary>
        /// 修改IS_START名称
        /// </summary>
        public void ChangeCellName()
        {
            if (ultraGridPlan.Rows.Count > 0)
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                foreach (UltraGridRow ugr in ultraGridPlan.Rows)
                {
                    //String Judge_Stove_No = ugr.Cells["JUDGE_DTOVE_NO"].Value.ToString();
                    //if (na.isBegineNode(Judge_Stove_No, 0))
                    //{
                    //    ugr.Appearance.BackColor = Color.YellowGreen;
                    //}
                    if (ugr.Cells["IS_START"].Value.ToString() != "未开始矫直" && ugr.Cells["IS_START"].Value.ToString() != "已开始矫直" && ugr.Cells["IS_START"].Value.ToString() != "已完成矫直")
                    {
                        switch (Convert.ToInt32(ugr.Cells["IS_START"].Value))
                        {
                            case 3:
                                ugr.Cells["IS_START"].Value = "未开始矫直";
                                break;
                            case 0:
                                ugr.Cells["IS_START"].Value = "已开始矫直";
                                break;
                            case 1:
                                ugr.Cells["IS_START"].Value = "已完成矫直";
                                break;
                        }

                    }

                }
            }
        }

        public void ChangeGridColor()
        {
            foreach (UltraGridRow ugr in ultraGridPlan.Rows)
            {
                if (ugr.Cells["IS_START"].Value.ToString() == "已完成矫直")
                {
                    ugr.Appearance.BackColor = Color.YellowGreen;
                }
            }
            if (ultraGrid_GHDL1.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid_GHDL1.Rows)
                {
                    if (ugr != null)
                    {
                        switch (ugr.Cells["STATUS"].Value.ToString())
                        {
                            case "剔除":
                                ugr.Appearance.BackColor = Color.Yellow;
                                break;

                        }
                        switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
                        {
                            case "待接班确认":
                                ugr.Appearance.BackColor = Color.LightGreen;
                                break;

                        }
                    }
                }
            }
            if (ultraGrid_GHDL2.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid_GHDL2.Rows)
                {
                    if (ugr != null)
                    {
                        switch (ugr.Cells["STATUS"].Value.ToString())
                        {
                            case "剔除":
                                ugr.Appearance.BackColor = Color.Yellow;
                                break;

                        }
                        switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
                        {
                            case "待接班确认":
                                ugr.Appearance.BackColor = Color.LightGreen;
                                break;

                        }
                    }
                }
            }
            if (ultraGrid_GHDL3.Rows.Count > 0)
            {
                foreach (UltraGridRow ugr in ultraGrid_GHDL3.Rows)
                {
                    if (ugr != null)
                    {
                        switch (ugr.Cells["STATUS"].Value.ToString())
                        {
                            case "剔除":
                                ugr.Appearance.BackColor = Color.Yellow;
                                break;

                        }
                        switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
                        {
                            case "待接班确认":
                                ugr.Appearance.BackColor = Color.LightGreen;
                                break;

                        }
                    }
                }
            }
        }

        private void chkLotNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtLOT_NO.Enabled = this.chkLotNo.Checked;

        }

        private void chkHeatNo_CheckedChanged(object sender, EventArgs e)
        {
            if (this.chkHeatNo.Checked)
            {
                this.txtJudgeStoveNo.Enabled = true;
            }
            else
            {
                this.txtJudgeStoveNo.Enabled = false;
            }
            if (chkStatusQuery.Checked)
            {
                PlanStatusQuery = "99";
                PlanStartStatusQuery = "80";
            }
            else
            {
                PlanStatusQuery = "79";
                PlanStartStatusQuery = "00";
            }
        }

        /// <summary>
        /// 流通卡赋值
        /// </summary>
        /// <param name="dt"></param>
        public void RollingCardEditGrid(DataTable dt, string heatno)
        {
            if (dt.Rows.Count > 0)
            {
                //上料切前剔除支数
                this.rollingCard1.Value.FeedScrapNum = dt.Rows[0]["SCRAP_FEED"].ToString();
                //上料切前合格支数
                this.rollingCard1.Value.FeedQualifiedNum = dt.Rows[0]["QUALIFIED_FEED"].ToString();
                //上料剔除支数
                this.rollingCard1.Value.FeedScrapDBNum = dt.Rows[0]["SCRAP_DBFEED"].ToString();
                //上料合格支数
                this.rollingCard1.Value.FeedQualifiedDBNum = dt.Rows[0]["QUALIFIED_DBFEED"].ToString();
                //加热炉剔除支数
                this.rollingCard1.Value.FurScrapNum = dt.Rows[0]["SCRAP_FUR"].ToString();
                //加热炉合格支数
                this.rollingCard1.Value.FurQualifiedNum = dt.Rows[0]["QUALIFIED_FUR"].ToString();
                //穿孔剔除支数
                this.rollingCard1.Value.PerScrapNum = dt.Rows[0]["SCRAP_PER"].ToString();
                //穿孔合格支数
                this.rollingCard1.Value.PerQualifiedNum = dt.Rows[0]["QUALIFIED_PER"].ToString();
                //连轧剔除支数
                this.rollingCard1.Value.RollingScrapNum = dt.Rows[0]["SCRAP_ROLLING"].ToString();
                //连轧合格支数
                this.rollingCard1.Value.RollingQualifiedNum = dt.Rows[0]["QUALIFIED_ROLLING"].ToString();
                //再加热炉剔除支数
                this.rollingCard1.Value.RefurScrapNum = dt.Rows[0]["SCRAP_REFUR"].ToString();
                //再加热炉合格支数
                this.rollingCard1.Value.RefurQualifiedNum = dt.Rows[0]["QUALIFIED_REFUR"].ToString();
                //定径剔除支数
                this.rollingCard1.Value.SizingScrapNum = dt.Rows[0]["SCRAP_SIZING"].ToString();
                //定径合格支数
                this.rollingCard1.Value.SizingQualifiedNum = dt.Rows[0]["QUALIFIED_SIZING"].ToString();
                //分切前剔除支数
                this.rollingCard1.Value.SawScrapNumBE = dt.Rows[0]["SCRAP_SAW_BE"].ToString();
                //分切前合格支数
                this.rollingCard1.Value.SawQualifiedNumBE = dt.Rows[0]["QUALIFIED_SAW_BE"].ToString();
                //分切剔除支数
                this.rollingCard1.Value.SawScrapNum = dt.Rows[0]["SCRAP_SAW"].ToString();
                //分切合格支数
                this.rollingCard1.Value.SawQualifiedNum = dt.Rows[0]["QUALIFIED_SAW"].ToString();
                //矫直剔除支数
                this.rollingCard1.Value.StraightScrapNum = dt.Rows[0]["SCRAP_STRAIGHT"].ToString();
                //矫直合格支数
                this.rollingCard1.Value.StraightQualifiedNum = dt.Rows[0]["QUALIFIED_STRAIGHT"].ToString();
                //矫直下线支数
                this.rollingCard1.Value.OfflineStraight = dt.Rows[0]["OFFLINE_STRAIGHT"].ToString();
                //矫直返线支数
                this.rollingCard1.Value.BacklineStraight = dt.Rows[0]["BACKLINE_STRAIGHT"].ToString();
                //探伤剔除支数
                this.rollingCard1.Value.TestingScrapNum = dt.Rows[0]["SCRAP_TESTING"].ToString();
                //探伤合格支数
                this.rollingCard1.Value.TestingQualifiedNum = dt.Rows[0]["QUALIFIED_TESTING"].ToString();
                NativeMethodNew na = new NativeMethodNew(this.ob);
                if (na.isBegineNode(heatno, 8) || na.isBegineNode(heatno, 9) || na.isBegineNode(heatno, 10))
                {
                    //探伤下线支数
                    this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
                    this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
                }
                else
                {
                    if (dt.Rows[0]["OFFLINE_TESTING"].ToString() == "0")
                    {
                        this.rollingCard1.Value.OfflineTesting = "";
                        this.rollingCard1.Value.BacklineTesting = "";
                    }
                    else
                    {
                        //探伤下线支数
                        this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
                        this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
                    }
                }

                this.rollingCard1.UpdateData();
            }
            else
            {
                this.rollingCard1.ClearData();
            }
        }

        /// <summary>
        /// 流通卡赋值
        /// </summary>
        /// <param name="dt"></param>
        public void RollingCardEditGrid1(DataTable dt, string heatno)
        {
            if (dt.Rows.Count > 0)
            {
                //矫直剔除支数
                this.rollingCard1.Value.StraightScrapNum = dt.Rows[0]["SCRAP_STRAIGHT"].ToString();
                //矫直合格支数
                this.rollingCard1.Value.StraightQualifiedNum = dt.Rows[0]["QUALIFIED_STRAIGHT"].ToString();
                //矫直下线支数
                this.rollingCard1.Value.OfflineStraight = dt.Rows[0]["OFFLINE_STRAIGHT"].ToString();
                //矫直返线支数
                this.rollingCard1.Value.BacklineStraight = dt.Rows[0]["BACKLINE_STRAIGHT"].ToString();
                //探伤剔除支数
                this.rollingCard1.Value.TestingScrapNum = dt.Rows[0]["SCRAP_TESTING"].ToString();
                //探伤合格支数
                this.rollingCard1.Value.TestingQualifiedNum = dt.Rows[0]["QUALIFIED_TESTING"].ToString();
                NativeMethodNew na = new NativeMethodNew(this.ob);
                if (na.isBegineNode(heatno, 8) || na.isBegineNode(heatno, 9) || na.isBegineNode(heatno, 10))
                {
                    //探伤下线支数
                    this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
                    this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
                }
                else
                {
                    if (dt.Rows[0]["OFFLINE_TESTING"].ToString() == "0")
                    {
                        this.rollingCard1.Value.OfflineTesting = "";
                        this.rollingCard1.Value.BacklineTesting = "";
                    }
                    else
                    {
                        //探伤下线支数
                        this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
                        this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
                    }
                }

                this.rollingCard1.UpdateData();
            }
            else
            {
                this.rollingCard1.ClearData();
            }
        }
        public void RollingCardClear()
        {
            //上料切前剔除支数
            this.rollingCard1.Value.FeedScrapNum = "";
            //上料切前合格支数
            this.rollingCard1.Value.FeedQualifiedNum = "";
            //上料剔除支数
            this.rollingCard1.Value.FeedScrapDBNum = "";
            //上料合格支数
            this.rollingCard1.Value.FeedQualifiedDBNum = "";
            //加热炉剔除支数
            this.rollingCard1.Value.FurScrapNum = "";
            //加热炉合格支数
            this.rollingCard1.Value.FurQualifiedNum = "";
            //穿孔剔除支数
            this.rollingCard1.Value.PerScrapNum = "";
            //穿孔合格支数
            this.rollingCard1.Value.PerQualifiedNum = "";
            //连轧剔除支数
            this.rollingCard1.Value.RollingScrapNum = "";
            //连轧合格支数
            this.rollingCard1.Value.RollingQualifiedNum = "";
            //再加热炉剔除支数
            this.rollingCard1.Value.RefurScrapNum = "";
            //再加热炉合格支数
            this.rollingCard1.Value.RefurQualifiedNum = "";
            //定径剔除支数
            this.rollingCard1.Value.SizingScrapNum = "";
            //定径合格支数
            this.rollingCard1.Value.SizingQualifiedNum = "";
            //分切前剔除支数
            this.rollingCard1.Value.SawScrapNumBE = "";
            //分切前合格支数
            this.rollingCard1.Value.SawQualifiedNumBE = "";
            //分切剔除支数
            this.rollingCard1.Value.SawScrapNum = "";
            //分切合格支数
            this.rollingCard1.Value.SawQualifiedNum = "";
            //矫直剔除支数
            this.rollingCard1.Value.StraightScrapNum = "";
            //矫直合格支数
            this.rollingCard1.Value.StraightQualifiedNum = "";
            //矫直下线支数
            this.rollingCard1.Value.OfflineStraight = "";
            //矫直返线支数
            this.rollingCard1.Value.BacklineStraight = "";
            //探伤剔除支数
            this.rollingCard1.Value.TestingScrapNum = "";
            //探伤合格支数
            this.rollingCard1.Value.TestingQualifiedNum = "";

            //探伤下线支数
            this.rollingCard1.Value.OfflineTesting = "";
            this.rollingCard1.Value.BacklineTesting = "";
            this.rollingCard1.UpdateData();
        }
            
        
        /// <summary>
        /// 轧制信息Grid赋值
        /// </summary>
        /// <param name="dt">轧制计划信息datatable</param>
        public void GridEdit(DataTable dt)
        {
            if (dt.Rows.Count > 0)
            {
                DataRow row1 = dt.Rows[0];
                //熔炼炉号
                this.rollingInfomation1.Value.StoveNo = row1["stove_no"].ToString();
                //炉号
                this.rollingInfomation1.Value.JudgeStoveNo = BaseMethod.getJudgeStoveNo(row1["judge_stove_no"].ToString());
                //生产批号
                this.rollingInfomation1.Value.LotNo = row1["lot_no"].ToString();
                //工序合同号
                this.rollingInfomation1.Value.ContractNo = row1["contract_no"].ToString();
                //执行工艺号
                this.rollingInfomation1.Value.ImpProcess = row1["imp_process"].ToString();
                //执行工艺号路径
                this.rollingInfomation1.Value.ImpProcessPath = row1["imp_process_path"].ToString();
                //产线代码
                this.rollingInfomation1.Value.PlineCode = row1["pline_code"].ToString();
                //状态
                this.rollingInfomation1.Value.Status = row1["STATUS"].ToString();
                //监制
                this.rollingInfomation1.Value.Producer = row1["producer"].ToString();
                //工艺状态
                this.rollingInfomation1.Value.ProcessStatus = row1["process_status"].ToString();
                //单倍长
                this.rollingInfomation1.Value.DbLength = row1["db_length"].ToString();
                //单倍重
                this.rollingInfomation1.Value.DbHeight = row1["db_height"].ToString();
                //轧制长度
                this.rollingInfomation1.Value.RollLength = row1["roll_length"].ToString();
                //分切数
                this.rollingInfomation1.Value.SawNum = row1["saw_num"].ToString();
                //目标长度
                this.rollingInfomation1.Value.TargetLength = row1["target_length"].ToString();
                //最终用户
                this.rollingInfomation1.Value.FinishUser = row1["finish_user"].ToString();
                //目标库
                this.rollingInfomation1.Value.TargetLiabrary = row1["target_liabrary"].ToString();
                //品种
                this.rollingInfomation1.Value.Varieties = row1["varieties"].ToString();
                //成品规格
                this.rollingInfomation1.Value.PipeSize = row1["pipe_size"].ToString();
                //扣型
                this.rollingInfomation1.Value.BuckleType = row1["buckle_type"].ToString();
                //长度范围
                this.rollingInfomation1.Value.LengthRange = row1["length_range"].ToString();
                //轧管判定标准
                this.rollingInfomation1.Value.RollStandrad = row1["roll_standrad"].ToString();
                //断面
                this.rollingInfomation1.Value.PipeSection = row1["pipe_section"].ToString();
                //钢种代码
                this.rollingInfomation1.Value.SteelCode = row1["steelcode"].ToString();
                //钢种名称
                this.rollingInfomation1.Value.SteelName = row1["steelname"].ToString();
                //钢级代码
                this.rollingInfomation1.Value.GradeCode = row1["gradecode"].ToString();
                //钢级名称
                this.rollingInfomation1.Value.GradeName = row1["gradename"].ToString();
                //炼钢判定标准
                this.rollingInfomation1.Value.SteelStandrad = row1["steel_standrad"].ToString();
                //去向
                this.rollingInfomation1.Value.Target = row1["target"].ToString();
                //支
                this.rollingInfomation1.Value.PlanNum = row1["BRANCH"].ToString();
                //吨
                this.rollingInfomation1.Value.PlanTon = row1["TON"].ToString();
                //切损去向
                this.rollingInfomation1.Value.CutTarget = row1["cut_target"].ToString();
                //切损长度
                this.rollingInfomation1.Value.CutLength = row1["cut_length"].ToString();
                //切损重量
                this.rollingInfomation1.Value.CutHeight = row1["CUT_WEIGHT"].ToString();
                //倍尺数
                this.rollingInfomation1.Value.DbNum = row1["DB_NUM"].ToString();
                //标准类别代码
                this.rollingInfomation1.Value.StdStyle = row1["STD_STYLE"].ToString();
                //标准类别描述
                this.rollingInfomation1.Value.StdStyleDesc = row1["STD_STYLE_DESC"].ToString();
                //成品备注
                this.rollingInfomation1.Value.ReMark = row1["ReMark"].ToString();
                this.rollingInfomation1.UpdateData();

            }
        }

        /// <summary>
        /// 流通卡赋值
        /// </summary>
        public void GetRollingCard()
        {
            UltraGridRow ugr = ultraGridPlan.ActiveRow;
            if (ugr != null)
            {
                string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                DataTable dt = new DataTable();
                if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017"))
                {
                    dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard1", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
                }
                else
                {
                    dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
                }
                RollingCardEditGrid(dt, JudgeStoveNo);
            }
        }
        /// <summary>
        /// 流通卡赋值
        /// </summary>
        public void GetRollingCard1()
        {
            UltraGridRow ugr = ultraGridPlan.ActiveRow;
            if (ugr != null)
            {
                string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                DataTable dt = new DataTable();
                if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017"))
                {
                    dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard1BackLine", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
                }
                else
                {
                    dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingStaCard1", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
                }
                RollingCardClear();
                RollingCardEditGrid1(dt, JudgeStoveNo);
            }
        }
        /// <summary>
        /// 查询跟踪记录信息
        /// </summary>
        public void ultraGridTC()
        {
            if (this.dtPlan.Rows.Count > 0)
            {
                this.dtTC1.Rows.Clear();
                this.dtTC2.Rows.Clear();
                this.dtTC3.Rows.Clear();
                UltraGridRow ugr = ultraGridPlan.ActiveRow;
                string flagstatus = "0";
                if (this.ActiveStatus.Equals("已完成矫直"))
                {
                    flagstatus = "1";
                }
                //UltraGridRow ugr = e.Row;
                if (ugr != null)
                {
                    string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                    MainPlan.JudgeStoveNo = HeatNo;
                    DataTable dtMP1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC1", new object[] { MainPlan, flagstatus }, this.ob);
                    DataTable dtMP2 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC2", new object[] { MainPlan, flagstatus }, this.ob);
                    DataTable dtMP3 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC3", new object[] { MainPlan, flagstatus }, this.ob);
                    if (dtMP1.Rows.Count > 0)
                    {
                        //this.ultraTabControl2
                        this.ultraTabControl2.Tabs[0].Visible = true;
                        if (this.ultraTabControl1.Tabs[1].Visible == true)
                        {
                            this.frmStraighteningResult11.Using1();
                        }

                        GridHelper.CopyDataToDatatable(ref dtMP1, ref this.dtTC1, true);
                        //ultraGrid_GHDL1.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                        if (ultraGrid_GHDL1.Rows.Count > 0)
                        {

                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                            {
                                ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
                                ugr1.Cells["DELBACK"].Value = "剔料回退";
                                ugr1.Cells["ChangShift"].Value = "交班操作";
                                ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
                            }
                        }
                    }
                    else
                    {
                        this.ultraTabControl2.Tabs[0].Visible = false;
                        if (this.ultraTabControl1.Tabs[1].Visible == true)
                        {
                            this.frmStraighteningResult11.NoUsing1();
                        }
                    }
                    if (dtMP2.Rows.Count > 0)
                    {
                        this.ultraTabControl2.Tabs[1].Visible = true;
                        if (this.ultraTabControl1.Tabs[1].Visible == true)
                        {
                            this.frmStraighteningResult11.Using2();
                        }
                        GridHelper.CopyDataToDatatable(ref dtMP2, ref this.dtTC2, true);
                        //ultraGrid_GHDL2.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                        if (ultraGrid_GHDL2.Rows.Count > 0)
                        {
                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                            {
                                ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
                                ugr1.Cells["DELBACK"].Value = "剔料回退";
                                ugr1.Cells["ChangShift"].Value = "交班操作";
                                ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
                            }
                        }
                    }
                    else
                    {
                        this.ultraTabControl2.Tabs[1].Visible = false;
                        if (this.ultraTabControl1.Tabs[1].Visible == true)
                        {
                            this.frmStraighteningResult11.NoUsing2();
                        }
                    }
                    if (dtMP3.Rows.Count > 0)
                    {
                        this.ultraTabControl2.Tabs[2].Visible = true;
                        GridHelper.CopyDataToDatatable(ref dtMP3, ref this.dtTC3, true);
                        //ultraGrid_GHDL3.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                        if (ultraGrid_GHDL3.Rows.Count > 0)
                        {
                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
                            {
                                ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
                                ugr1.Cells["DELBACK"].Value = "剔料回退";
                                ugr1.Cells["ChangShift"].Value = "交班操作";
                                ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
                            }
                        }
                    }
                    else
                    {
                        this.ultraTabControl2.Tabs[2].Visible = false;
                    }
                    ChangeGridColor();

                }

            }
        }
        /// <summary>
        /// 更新矫直实绩
        /// </summary>
        /// <param name="heatNo"></param>
        /// <param name="PliceCode"></param>
        public void GetStraightResult(string heatNo, string PliceCode)
        {
            StraighteningResult.Clear();
            string strheatno = heatNo;
            string factoryId = PliceCode;

            DataTable dtResult = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getPerResult", new object[] { strheatno, proPlanId, gxPlanNo }, this.ob);
            if (dtResult.Rows.Count > 0)
            {
                //获取表里相应的字段值到类中
                StraighteningResult = NativeMethod.GetTableToEntity(dtResult, StraighteningResult);
                if (factoryId == "C010")//168三个矫直台
                {
                    ultraTabControl1.Tabs[0].Visible = true;
                    ultraTabControl1.Tabs[1].Visible = false;
                    ultraTabControl1.Tabs[2].Visible = false;

                    //ultraTabControl2.Tabs[0].Visible = true;
                    //ultraTabControl2.Tabs[1].Visible = true;
                    //ultraTabControl2.Tabs[2].Visible = true;
                    //设置168机组控件（straighteningResult1）值
                    this.straighteningResult1.Value = StraighteningResult;
                    if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
                    {
                        //this.straighteningResult1.NoUsing2();
                        //this.straighteningResult1.NoUsing3();
                        Flage = "1";
                    }
                    if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
                    {
                        //this.straighteningResult1.NoUsing1();
                        //this.straighteningResult1.NoUsing3();
                        Flage = "2";
                    }
                    if (WorkStand.Contains("矫直") && WorkStand.Contains("3"))
                    {
                        //this.straighteningResult1.NoUsing1();
                        //this.straighteningResult1.NoUsing2();
                        Flage = "3";
                    }
                }
                else
                {
                    if (factoryId == "C017")//460两个矫直台
                    {
                        ultraTabControl1.Tabs[0].Visible = false;
                        ultraTabControl1.Tabs[1].Visible = false;
                        ultraTabControl1.Tabs[2].Visible = true;
                        //ultraTabControl1.Tabs[0].Visible = false;
                        //ultraTabControl1.Tabs[1].Visible = true;
                        //ultraTabControl1.Tabs[2].Visible = false;

                        //ultraTabControl2.Tabs[0].Visible = true;
                        //ultraTabControl2.Tabs[1].Visible = true;
                        //ultraTabControl2.Tabs[2].Visible = false;
                        // 设置460机组控件（frmStraighteningResult21）值
                        this.frmStraighteningResult21.Value = StraighteningResult;
                        //this.frmStraighteningResult11.Value = StraighteningResult;
                        if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
                        {
                            //this.frmStraighteningResult21.NoUsing2();
                            Flage = "1";
                        }
                        if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
                        {
                            //this.frmStraighteningResult21.NoUsing1();
                            Flage = "2";
                        }
                    }
                    else//2 个矫直台
                    {
                        ultraTabControl1.Tabs[0].Visible = false;
                        ultraTabControl1.Tabs[1].Visible = true;
                        ultraTabControl1.Tabs[2].Visible = false;

                        //ultraTabControl2.Tabs[0].Visible = true;
                        //ultraTabControl2.Tabs[1].Visible = true;
                        //ultraTabControl2.Tabs[2].Visible = false;
                        // 设置其他机组控件值
                        this.frmStraighteningResult11.Value = StraighteningResult;
                        if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
                        {
                            //this.frmStraighteningResult11.NoUsing2();
                            Flage = "1";
                        }
                        if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
                        {
                            //this.frmStraighteningResult11.NoUsing1();
                            Flage = "2";
                        }


                    }
                }
            }
            else
            {
                this.straighteningResult1.Value = StraighteningResult;
                this.frmStraighteningResult21.Value = StraighteningResult;
                this.frmStraighteningResult11.Value = StraighteningResult;
            }

        }

        
        #endregion

        #region   事件方法
        /// <summary>
        /// 主计划查询
        /// </summary>
        public void PlanQuery()
        {
            string PrimaKey = "";
            UltraGridRow ugr = this.ultraGridPlan.ActiveRow;
            if (ugr != null)
            {
                PrimaKey = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
            }

            if (chkHeatNo.Checked == true)
            {

                if (this.txtJudgeStoveNo.Text == "")
                {
                    MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    QueryMainPlan.JudgeStoveNo = this.txtJudgeStoveNo.Text;
                }
            }
            else
            {
                QueryMainPlan.JudgeStoveNo = "";
            }
            if (chkLotNo.Checked == true)
            {
                if (this.txtLOT_NO.Text == "")
                {
                    MessageBox.Show("请输入生产批号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    QueryMainPlan.LotNo = this.txtLOT_NO.Text;
                }
            }
            else
            {
                QueryMainPlan.LotNo = "";
            }


            dtPlan.Rows.Clear();
            //ChangeGridColor();
            //查询主表记录
            QueryMainPlan.PlineCode = PlineCode;
            QueryMainPlan.Status = PlanStatusQuery;
            QueryMainPlan.StartStatus = PlanStartStatusQuery;
            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("未查询到匹配的数据，请重新查询！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
                //ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                ChangeCellName();
                ChangeGridColor();
                //this.ultraGridPlan.ActiveRow = null;
                if (ugr != null)
                {
                    foreach (UltraGridRow ugr1 in ultraGridPlan.Rows)
                    {


                        ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());


                        if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == PrimaKey)
                        {
                            this.ultraGridPlan.ActiveRow = ugr1;
                        }
                    }
                }
            }
        }

        private String doQueryJugeNoStaus(string resultNo, string jugeNo, string plineCode)
        {
            string staus = "3";
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryResultStaus", new object[] { resultNo, jugeNo, plineCode, "6", proPlanId, gxPlanNo }, ob);
            if (ds.Rows.Count > 0)
            {
                staus = ds.Rows[0]["NODE_FUR_FLAG"].ToString();
            }
            return staus;
        }

        /// <summary>
        /// 主表单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridPlan_AfterRowActivate(object sender, EventArgs e)
        {
            if (this.dtPlan.Rows.Count > 0)
            {
                UltraGridRow ugr = ultraGridPlan.ActiveRow;
                //UltraGridRow ugr = e.Row;
                if (ugr != null)
                {

                    //查询主计划信息
                    string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                    string resultNo = ugr.Cells["ID"].Value.ToString();
                    proPlanId = ugr.Cells["PRO_PLAN_ID"].Value.ToString();
                    gxPlanNo = ugr.Cells["GX_PLAN_NO"].Value.ToString();
                    lotNo = ugr.Cells["LOT_NO"].Value.ToString();
                    MainPlan.JudgeStoveNo = HeatNo;
                    MainPlan.ProPlanId = proPlanId;
                    MainPlan.GxPlanNo = gxPlanNo;
                    ActiveJUDGE_STOVE_NO = HeatNo;
                    //string Status = ugr.Cells["IS_START"].Value.ToString();
                    string Status = doQueryJugeNoStaus(resultNo, HeatNo,PlineCode);
                    ActiveStatus = Status;
                    string PCode = ugr.Cells["Pline_Code"].Value.ToString();
                    PlineCode = PCode;
                    DataTable dtMP = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlanForHeatNo", new object[] { MainPlan }, this.ob);
                    if (dtMP.Rows.Count > 0)
                    {
                        ActiveResultNo = dtMP.Rows[0]["ID"].ToString();
                        ActiveOFFLINE_FLAG = dtMP.Rows[0]["OFFLINE_FLAG"].ToString();
                        if (dtMP.Rows[0]["PLINE_CODE"].ToString() == "C010")
                        {
                            ultraTabControl1.Tabs[0].Visible = true;
                            ultraTabControl1.Tabs[1].Visible = false;
                            ultraTabControl1.Tabs[2].Visible = false;
                        }
                        else
                        {
                            if (dtMP.Rows[0]["PLINE_CODE"].ToString() == "C017")
                            {
                                ultraTabControl1.Tabs[0].Visible = false;
                                ultraTabControl1.Tabs[1].Visible = false;
                                ultraTabControl1.Tabs[2].Visible = true;
                            }
                            else
                            {
                                ultraTabControl1.Tabs[0].Visible = false;
                                ultraTabControl1.Tabs[1].Visible = true;
                                ultraTabControl1.Tabs[2].Visible = false;
                            }
                        }
                        PlineCode = dtMP.Rows[0]["PLINE_CODE"].ToString();
                        GridEdit(dtMP); //轧制计划信息
                        this.stoveno = dtMP.Rows[0]["STOVE_NO"].ToString();
                        this.lotno = dtMP.Rows[0]["LOT_NO"].ToString();
                    }
                    if (Status != "3")//查询跟踪记录表
                    {
                        ultraGridTC();
                    }
                    else
                    {
                        dtTC1.Rows.Clear();
                        dtTC2.Rows.Clear();
                        dtTC3.Rows.Clear();
                    }
                    DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, ob);
                    GetStraightResult(HeatNo, PlineCode);//更新实绩
                    if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                    {
                        GetRollingCard1();//更新流通卡
                    }
                    else
                    {
                        GetRollingCard();//更新流通卡
                    }
                    ChangeGridColor();

                    if (Status == "3" || Status == "1")//查询跟踪记录表
                    {
                        return;
                    }
                    UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
                    UltraGridRow ugr_roll = this.rollingCard1.UltraGrid4.Rows[0];

                    string JudgeStoveNo = ugr_plan.Cells["JUDGE_STOVE_NO"].Value.ToString();
                    Status = ugr_plan.Cells["IS_START"].Value.ToString();
                    //查看结炉标识
                    DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
                    if (dtFlag.Rows.Count > 0)
                    {
                        if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                        {
                            //MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            return;
                        }
                        if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
                        {
                            //MessageBox.Show("炉号【" + JudgeStoveNo + "】不能结炉，分切未完成。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                            return;
                        }
                    }
                    else
                    {
                        return;
                    }
                    StraighteningResult.Clear();
                    if (PlineCode == "C010")
                    {
                        this.straighteningResult1.UltraGrid2.UpdateData();
                        StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
                        int i = 0; int j = 0; int k = 0;
                        if (ultraGrid_GHDL1.Rows.Count > 0)
                        {
                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                            {
                                if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                {
                                    i = i + 1;
                                }
                            }
                        }
                        if (ultraGrid_GHDL2.Rows.Count > 0)
                        {
                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                            {
                                if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                {
                                    j = j + 1;
                                }
                            }
                        }
                        if (ultraGrid_GHDL3.Rows.Count > 0)
                        {
                            foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
                            {
                                if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                {
                                    k = k + 1;
                                }
                            }
                        }
                        StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                        StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                        StraighteningResult.QualifiedNum3 = k - int.Parse(StraighteningResult.ScrapNum3.ToString());
                    }
                    else
                    {
                        if (PlineCode == "C017")
                        {
                            this.frmStraighteningResult21.UltraGrid2.UpdateData();
                            StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
                            int i = 0; int j = 0; int k = 0;
                            if (ultraGrid_GHDL1.Rows.Count > 0)
                            {
                                foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                                {
                                    if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                    {
                                        i = i + 1;
                                    }
                                }
                            }
                            if (ultraGrid_GHDL2.Rows.Count > 0)
                            {
                                foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                                {
                                    if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                    {
                                        j = j + 1;
                                    }
                                }
                            }
                            StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                            StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                        }
                        else
                        {
                            this.frmStraighteningResult11.UltraGrid4.UpdateData();
                            StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
                            int i = 0; int j = 0; int k = 0;
                            if (ultraGrid_GHDL1.Rows.Count > 0)
                            {
                                foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                                {
                                    if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                    {
                                        i = i + 1;
                                    }
                                }
                            }
                            if (ultraGrid_GHDL2.Rows.Count > 0)
                            {
                                foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                                {
                                    if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                                    {
                                        j = j + 1;
                                    }
                                }
                            }
                            StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                            StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                        }
                    }
                    if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                    {
                        StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
                        if (int.Parse(StraighteningResult.InMatNum.ToString()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString()))
                        {
                            StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(this.rollingCard1.Value.OfflineStraight.ToString2()) - int.Parse(this.rollingCard1.Value.StraightScrapNum.ToString2());
                        }
                    }
                    else
                    {
                        if (!string.IsNullOrEmpty(ugr_roll.Cells["QualifiedNum10"].Value.ToString()))
                        {
                            //来料支数
                            StraighteningResult.InMatNum = ugr_roll.Cells["QualifiedNum10"].Value.ToString();
                        }
                        if (int.Parse(StraighteningResult.InMatNum.ToString()) > int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString()))
                        {
                            StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(this.rollingCard1.Value.OfflineStraight.ToString2()) - int.Parse(this.rollingCard1.Value.StraightScrapNum.ToString2());
                        }
                    }
                    //else
                    //{
                    //    MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    //    return;
                    //}

                    //合格吨

                    double DBHeight = 0;
                    double BurnningRate = 0;
                    double BurnningRate1 = 0;
                    double DBNum = 1;
                    NativeMethodNew na = new NativeMethodNew(this.ob);
                    string JudgeStoveNotemp = BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "-01";
                    double percent = na.GetLengthPercent(JudgeStoveNotemp, this.ob, 0);
                    if (percent == 100.0)
                    {
                        MessageBox.Show("炉号：【" + JudgeStoveNo + "】尚未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    DataTable dtDBH = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getDbHeight", new object[] { JudgeStoveNo, ActiveResultNo, proPlanId, gxPlanNo }, this.ob);
                    if (dtDBH.Rows.Count > 0)
                    {
                        if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_HEIGHT"].ToString()))
                        {
                            DBHeight = double.Parse(dtDBH.Rows[0]["DB_HEIGHT"].ToString());
                        }
                        if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNNING_RATE"].ToString()))
                        {
                            BurnningRate = double.Parse(dtDBH.Rows[0]["BURNNING_RATE"].ToString());
                        }
                        if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNINGRATE"].ToString()))
                        {
                            BurnningRate1 = double.Parse(dtDBH.Rows[0]["BURNINGRATE"].ToString());
                        }
                        if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_NUM"].ToString()))
                        {
                            DBNum = double.Parse(dtDBH.Rows[0]["DB_NUM"].ToString());
                        }
                    }
                    //分产线 是否经过再加热炉
                    if (this.PlineCode == "C009" || PlineCode == "C012" || PlineCode == "C017")
                    {
                        double temp = DBHeight * (1 - (BurnningRate / 100));
                        double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
                        StraighteningResult.QaTon = temp * percent / 100 * tempnum;
                    }
                    else
                    {
                        double temp = DBHeight * (1 - (BurnningRate / 100)) * (1 - (BurnningRate1 / 100));
                        double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
                        StraighteningResult.QaTon = temp * percent / 100 * tempnum;
                    }

                    StraighteningResult.JudgeStoveNo = JudgeStoveNo;
                    StraighteningResult.NodeFurFlag = "1";
                    StraighteningResult.ColGroup = UserInfo.GetUserGroup();
                    StraighteningResult.ColShift = UserInfo.GetUserOrder();
                    StraighteningResult.ColUser = UserInfo.GetUserName();
                    StraighteningResult.GxPlanNo = gxPlanNo;
                    StraighteningResult.ProPlanId = proPlanId;
                    int countafter = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.Qunum", new object[] { StraighteningResult }, this.ob);
                }

            }
        }


        /// <summary>
        /// 判断是否能开始当前炉次
        /// </summary>
        /// <returns></returns>
        private bool IsStart()
        {
            bool Start = true;
            foreach (UltraGridRow ugr in ultraGridPlan.Rows)
            {
                if (ugr.Cells["IS_START"].Value.ToString() == "已开始矫直")
                {
                    MessageBox.Show("炉号【" + ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】正在矫直，不能两炉同时开始矫直", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    Start = false;
                }

            }
            return Start;
        }
        /// <summary>
        /// 双击上料事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        // private void ultraGridPlan_DoubleClickRow(object sender, DoubleClickRowEventArgs e)
        private void DoStart()
        {
            if (ultraGridPlan.Rows.Count > 0)
            {
                //if (!IsStart())
                //{
                //    return;
                //}
                UltraGridRow ugr = ultraGridPlan.ActiveRow;

                if (ugr != null)
                {
                    string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                    ActiveJUDGE_STOVE_NO = HeatNo;
                    MainPlan.JudgeStoveNo = HeatNo;
                    //string Status = ugr.Cells["IS_START"].Value.ToString();
                   
                    string ResultNo = ugr.Cells["ID"].Value.ToString();
                    string Status = doQueryJugeNoStaus(ResultNo, HeatNo,PlineCode);
                    ActiveStatus = Status;
                    if (Status == "1")
                    {
                        MessageBox.Show("炉号：【" + HeatNo + "】已完成定径，不允许再次开始定径操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    PlineCode = ugr.Cells["Pline_Code"].Value.ToString();
                    StraighteningResult.Clear();
                    if (Status == "0")
                    {
                        MessageBox.Show("矫直工序正在进行，无法进行再次矫直!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    if (temprstraght != null)
                    {
                        StraighteningResult = NativeMethod.GetEntityToEntity(StraighteningResult, temprstraght);
                        StraighteningResult.ChangeNum = "";
                        StraighteningResult.InMatNum = "";
                        StraighteningResult.QualifiedNum = "";
                        StraighteningResult.QualifiedNum1 = "";
                        StraighteningResult.QualifiedNum2 = "";
                        StraighteningResult.QualifiedNum3 = "";
                        StraighteningResult.Remark = "";
                        StraighteningResult.ScrapNum = "";
                        StraighteningResult.ScrapNum1 = "";
                        StraighteningResult.ScrapNum2 = "";
                        StraighteningResult.ScrapNum3 = "";
                        StraighteningResult.SootBlowingTime = "";
                        StraighteningResult.StartTime = "";
                        StraighteningResult.EndTime = "";
                    }
                    DataTable dtMP = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlanForHeatNo", new object[] { MainPlan }, this.ob);
                    ActiveOFFLINE_FLAG = dtMP.Rows[0]["OFFLINE_FLAG"].ToString();
                    GridEdit(dtMP); //轧制计划信息
                    ActiveResultNo = dtMP.Rows[0]["ID"].ToString();
                    this.stoveno = dtMP.Rows[0]["STOVE_NO"].ToString();
                    this.lotno = dtMP.Rows[0]["LOT_NO"].ToString();
                    string PLineCode = dtMP.Rows[0]["PLINE_CODE"].ToString();
                    string LotNo = dtMP.Rows[0]["LOT_NO"].ToString();
                    string StoveNo = dtMP.Rows[0]["STOVE_NO"].ToString();
                    string Judge_stove_no = dtMP.Rows[0]["judge_stove_no"].ToString();
                    StraighteningResult.LotNo = LotNo;
                    StraighteningResult.ResultNo = ResultNo;
                    StraighteningResult.StoveNo = StoveNo;
                    StraighteningResult.PlineCode = PLineCode;
                    StraighteningResult.JudgeStoveNo = Judge_stove_no;
                    StraighteningResult.ColMode = "0";
                    StraighteningResult.ColGroup = UserInfo.GetUserGroup();
                    StraighteningResult.ColShift = UserInfo.GetUserOrder();
                    StraighteningResult.ColUser = UserInfo.GetUserName();
                    StraighteningResult.ProPlanId = proPlanId;
                    StraighteningResult.GxPlanNo = gxPlanNo;

                    //修改主表状态，插入矫直实绩
                    int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.UpdateStraighteningStatue", new object[] { StraighteningResult }, this.ob);

                    if (count > 0)
                    {
                        NativeMethodNew na = new NativeMethodNew(this.ob);
                        na.InsertSTAferDoubleClick(HeatNo, 7, "0", proPlanId, gxPlanNo);
                        DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
                        GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
                        //ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                        ChangeCellName();
                        foreach (UltraGridRow ugr1 in this.ultraGridPlan.Rows)
                        {



                            ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());


                            if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == HeatNo)
                            {
                                ultraGridPlan.ActiveRow = ugr1;
                            }
                        }
                    }
                }

            }
        }
        /// <summary>
        /// 开始回退
        /// </summary>
        private void StartBack()
        {
            if (ultraGridPlan.Rows.Count > 0)
            {
                if (this.ultraGridPlan.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要回退的炉号！！！");
                    return;
                }
                UltraGridRow ugr = ultraGridPlan.ActiveRow;
                string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                string ResultNo = ugr.Cells["ID"].Value.ToString();
                //string StartStatus = ugr.Cells["IS_START"].Value.ToString();
                string StartStatus = doQueryJugeNoStaus(ResultNo, JudgeStoveNo,PlineCode);
                if (StartStatus == "1")
                {
                    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】已结炉，不能入炉回退！！！！");
                    return;
                }
                if (StartStatus == "3")
                {
                    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】未开始入炉，不能入炉回退！！！！");
                    return;
                }
                int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.startBack", new object[] { JudgeStoveNo, ResultNo, 7, PlineCode, proPlanId, gxPlanNo }, this.ob);
                ultraGridTC();
                ChangeGridColor();
                ChangeCellName();
                PlanQuery();
            }
        }
        /// <summary>
        /// 保存跟踪记录表备注
        /// </summary>
        private void ultraGridMatSeq_AfterCellUpdate(object sender, CellEventArgs e)
        {
            UltraGridRow ugr = null;
            string heatno = "";
            int seq = 0;
            string remark = "";
            if (ultraTabControl2.Tabs[0].Visible == true)
            {
                ugr = ultraGrid_GHDL1.ActiveRow;
            }
            if (ultraTabControl2.Tabs[1].Visible == true)
            {
                ugr = ultraGrid_GHDL2.ActiveRow;
            }
            if (ultraTabControl2.Tabs[2].Visible == true)
            {
                ugr = ultraGrid_GHDL3.ActiveRow;
            }
            if (e.Cell.Column.Key == "REMARK")
            {
                if (ugr == null)
                {
                    //MessageBox.Show("您未选择任何管号队列数据，请重新选择后再进行保存操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                heatno = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
                seq = Convert.ToInt16(ugr.Cells["SEQ"].Value.ToString());
                if (!string.IsNullOrEmpty(ugr.Cells["REMARK"].Value.ToString()))
                {
                    remark = ugr.Cells["REMARK"].Value.ToString();
                }
                else
                {
                    remark = "";
                }
                NativeMethodNew na = new NativeMethodNew(this.ob);
                na.SaveRackRemark(1, seq, heatno, remark);
            }
        }
        /// <summary>
        /// 保存
        /// </summary>
        public void StraighteningSave()
        {
            StraighteningResult.Clear();
            UltraGridRow ugr = ultraGridPlan.ActiveRow;
            UltraGridRow ugr1 = straighteningResult1.UltraGrid2.Rows[0];
            UltraGridRow ugr11 = frmStraighteningResult11.UltraGrid4.Rows[0];
            UltraGridRow ugr21 = frmStraighteningResult21.UltraGrid2.Rows[0];
            UltraGridRow ugr2 = this.rollingCard1.UltraGrid4.Rows[0];
            string JudgeStoveNo = "";
            string saveflag = "0";
            if (this.ultraGridPlan.ActiveRow == null && ActiveJUDGE_STOVE_NO == null)
            {
                MessageBox.Show("未选择任何炉号，请选择炉号后进行保存操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (this.ultraGridPlan.ActiveRow == null)
            {
                JudgeStoveNo = ActiveJUDGE_STOVE_NO;
            }
            else
            {
                JudgeStoveNo = this.ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
            }
            DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);



            if (PlineCode == "C010")
            {
                this.straighteningResult1.UltraGrid2.UpdateData();
                StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
                //StraighteningResult.QualifiedNum1 = "0";
                //StraighteningResult.QualifiedNum1 = "0";
                //StraighteningResult.QualifiedNum1 = "0";
                //StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
                //StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
                //StraighteningResult.QualifiedNum3 = this.ultraGrid_GHDL3.Rows.Count - int.Parse(StraighteningResult.ScrapNum3.ToString());
            }
            else
            {
                if (PlineCode == "C017")
                {
                    this.frmStraighteningResult21.UltraGrid2.UpdateData();
                    StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
                    //StraighteningResult.QualifiedNum1 = "0";
                    //StraighteningResult.QualifiedNum1 = "0";
                    StraighteningResult.QualifiedNum3 = "0";
                    //StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
                    //StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
                }
                else
                {
                    this.frmStraighteningResult11.UltraGrid4.UpdateData();
                    StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
                    //StraighteningResult.QualifiedNum1 = "0";
                    //StraighteningResult.QualifiedNum1 = "0";
                    StraighteningResult.QualifiedNum3 = "0";
                    //StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
                    //StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
                }
            }
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);//查询计划是否为返线计划
            if (dtFlag.Rows.Count > 0)
            {
                if (!string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() == "1")
                    {
                        if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                        {
                            //来料支数
                            StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
                            StraighteningResult.QualifiedNum = "0";
                        }
                        else
                        {
                            if (!string.IsNullOrEmpty(ugr2.Cells["QualifiedNum10"].Value.ToString()))
                            {
                                //来料支数
                                StraighteningResult.InMatNum = ugr2.Cells["QualifiedNum10"].Value.ToString();
                                StraighteningResult.QualifiedNum = "0";
                            }
                        }
                        //if (int.Parse(StraighteningResult.InMatNum.ToString()) > int.Parse(ugr2.Cells["ScrapNum11"].Value.ToString()))
                        //{
                        //    //合格支数
                        //    StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr2.Cells["ScrapNum11"].Value.ToString());
                        //}

                    }
                }
            }
            if (this.ultraGridPlan.ActiveRow == null && ActiveJUDGE_STOVE_NO == null)
            {
                MessageBox.Show("未选择任何炉号，请选择炉号后进行保存操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (this.ultraGridPlan.ActiveRow == null)
            {
                StraighteningResult.JudgeStoveNo = ActiveJUDGE_STOVE_NO;

            }
            else
            {
                StraighteningResult.JudgeStoveNo = this.ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
            }
            if (ActiveStatus.Equals("3"))
            {
                MessageBox.Show("炉号：【" + StraighteningResult.JudgeStoveNo + "】未开始进行矫直，不允许进行保存操作！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (ActiveStatus.Equals("1"))
            {
                saveflag = "1";
                //MessageBox.Show("炉号：【" + StraighteningResult.JudgeStoveNo + "】已完成矫直，不允许进行保存操作！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //return;
            }
            //if (MessageUtil.ShowYesNoAndQuestion("确认炉号【" + StraighteningResult.JudgeStoveNo + "】保存实绩？") == DialogResult.No)
            //{
            //    return;
            //}

            ////剔除支数
            //if (!string.IsNullOrEmpty(ugr1.Cells["ScrapNum"].Value.ToString()))
            //{
            //    StraighteningResult.ScrapNum = ugr1.Cells["ScrapNum"].Value.ToString();
            //}
            //else
            //{
            //    StraighteningResult.ScrapNum = "0";
            //}
            //入炉支数
            //string lailiao = ugr2.Cells["QualifiedNum10"].Value.ToString();
            //int ck = 0;
            //if (string.IsNullOrEmpty(lailiao))
            //{
            //    ck = 0;
            //}
            //else
            //{
            //    ck = int.Parse(lailiao) - int.Parse(StraighteningResult.ScrapNum.ToString());

            //}
            StraighteningResult.ProPlanId = proPlanId;
            StraighteningResult.GxPlanNo = gxPlanNo;
            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.saveStraightening", new object[] { StraighteningResult, saveflag }, this.ob);
            if (count > 0)
            {
                MessageBox.Show("炉号【" + StraighteningResult.JudgeStoveNo + "】保存成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            this.straighteningResult1.IsCellSelect = false;
            this.frmStraighteningResult11.IsCellSelect = false;
            this.frmStraighteningResult21.IsCellSelect = false;
            temprstraght = NativeMethod.GetEntityToEntity(temprstraght, StraighteningResult);
            GetRollingCard();


        }

        /// <summary>
        ///  结炉操作
        /// 1、判断上一道工序结炉状态，2、更新实绩表（包括结炉时间,结炉状态），3.更新主表NODE_STATUS
        /// </summary>
        public void StraighteningNode()
        {
            StraighteningSave();
            StraighteningResult.Clear();
            if (this.ultraGridPlan.ActiveRow == null)
            {
                MessageBox.Show("未选择任何炉号，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
            UltraGridRow ugr_roll = this.rollingCard1.UltraGrid4.Rows[0];

            string JudgeStoveNo = ugr_plan.Cells["JUDGE_STOVE_NO"].Value.ToString();
            string resultNo = ugr_plan.Cells["ID"].Value.ToString();
            //string Status = ugr_plan.Cells["IS_START"].Value.ToString();
            string Status = doQueryJugeNoStaus(resultNo, JudgeStoveNo,PlineCode);
            NativeMethodNew na = new NativeMethodNew(this.ob);
            int WaitChangeSeq1 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "1", proPlanId, gxPlanNo);
            int WaitChangeSeq2 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "2", proPlanId, gxPlanNo);
            if (WaitChangeSeq1 > 0)
            {
                MessageBox.Show("序号：【" + WaitChangeSeq1 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (WaitChangeSeq2 > 0)
            {
                MessageBox.Show("序号：【" + WaitChangeSeq2 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (this.PlineCode.Equals("C010"))
            {
                int WaitChangeSeq3 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "3", proPlanId, gxPlanNo);
                if (WaitChangeSeq3 > 0)
                {
                    MessageBox.Show("序号：【" + WaitChangeSeq3 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            if (Status == "1")
            {
                MessageBox.Show("炉号：【" + JudgeStoveNo + "】已完成矫直，不允许进行结炉操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (Status != "0")
            {
                MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不允许结炉！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //查看结炉标识
            DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
            if (dtFlag.Rows.Count > 0)
            {
                if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
                {
                    MessageBox.Show("炉号【" + JudgeStoveNo + "】不能结炉，分切未完成。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }

            if (MessageUtil.ShowYesNoAndQuestion("确认炉号【" + JudgeStoveNo + "】结炉？") == DialogResult.No)
            {
                return;
            }
            if (PlineCode == "C010")
            {
                this.straighteningResult1.UltraGrid2.UpdateData();
                StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
                int i = 0; int j = 0; int k = 0;
                if (ultraGrid_GHDL1.Rows.Count > 0)
                {
                    foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                    {
                        if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                        {
                            i = i + 1;
                        }
                    }
                }
                if (ultraGrid_GHDL2.Rows.Count > 0)
                {
                    foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                    {
                        if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                        {
                            j = j + 1;
                        }
                    }
                }
                if (ultraGrid_GHDL3.Rows.Count > 0)
                {
                    foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
                    {
                        if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                        {
                            k = k + 1;
                        }
                    }
                }
                StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                StraighteningResult.QualifiedNum3 = k - int.Parse(StraighteningResult.ScrapNum3.ToString());
            }
            else
            {
                if (PlineCode == "C017")
                {
                    this.frmStraighteningResult21.UltraGrid2.UpdateData();
                    StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
                    int i = 0; int j = 0; int k = 0;
                    if (ultraGrid_GHDL1.Rows.Count > 0)
                    {
                        foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                        {
                            if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                            {
                                i = i + 1;
                            }
                        }
                    }
                    if (ultraGrid_GHDL2.Rows.Count > 0)
                    {
                        foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                        {
                            if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                            {
                                j = j + 1;
                            }
                        }
                    }
                    StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                    StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                    StraighteningResult.QualifiedNum3 = "0";
                }
                else
                {
                    this.frmStraighteningResult11.UltraGrid4.UpdateData();
                    StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
                    int i = 0; int j = 0; int k = 0;
                    if (ultraGrid_GHDL1.Rows.Count > 0)
                    {
                        foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
                        {
                            if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                            {
                                i = i + 1;
                            }
                        }
                    }
                    if (ultraGrid_GHDL2.Rows.Count > 0)
                    {
                        foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
                        {
                            if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
                            {
                                j = j + 1;
                            }
                        }
                    }
                    StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
                    StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
                    StraighteningResult.QualifiedNum3 = "0";
                }
            }
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
            {
                //来料支数
                StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
                if (int.Parse(StraighteningResult.InMatNum.ToString3()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()))
                {
                    //合格支数
                    StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()) - int.Parse(ugr_roll.Cells["Offline11"].Value.ToString3());
                }
                else
                {
                    MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            else
            {
                if (!string.IsNullOrEmpty(ugr_roll.Cells["QualifiedNum10"].Value.ToString()))
                {
                    //来料支数
                    StraighteningResult.InMatNum = ugr_roll.Cells["QualifiedNum10"].Value.ToString();
                }
                if (int.Parse(StraighteningResult.InMatNum.ToString3()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()))
                {
                    //合格支数
                    StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()) - int.Parse(ugr_roll.Cells["Offline11"].Value.ToString3());
                }
                else
                {
                    MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            

            //合格吨

            double DBHeight = 0;
            double BurnningRate = 0;
            double BurnningRate1 = 0;
            double DBNum = 1;
            NativeMethodNew natemp = new NativeMethodNew(this.ob);
            string JudgeStoveNotemp = BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "-01";
            double percent = natemp.GetLengthPercent(JudgeStoveNotemp, this.ob, 0);

            if (percent == 100.0)
            {
                MessageBox.Show("炉号：【" + JudgeStoveNo + "】尚未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataTable dtDBH = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getDbHeight", new object[] { JudgeStoveNo, ActiveResultNo, proPlanId, gxPlanNo }, this.ob);
            if (dtDBH.Rows.Count > 0)
            {
                if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_HEIGHT"].ToString()))
                {
                    DBHeight = double.Parse(dtDBH.Rows[0]["DB_HEIGHT"].ToString());
                }
                if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNNING_RATE"].ToString()))
                {
                    BurnningRate = double.Parse(dtDBH.Rows[0]["BURNNING_RATE"].ToString());
                }
                if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNINGRATE"].ToString()))
                {
                    BurnningRate1 = double.Parse(dtDBH.Rows[0]["BURNINGRATE"].ToString());
                }
                if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_NUM"].ToString()))
                {
                    DBNum = double.Parse(dtDBH.Rows[0]["DB_NUM"].ToString());
                }
            }
            //分产线 是否经过再加热炉
            if (this.PlineCode == "C009" || PlineCode == "C012" || PlineCode == "C017")
            {
                double temp = DBHeight * (1 - (BurnningRate / 100));
                double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
                StraighteningResult.QaTon = temp * percent / 100 * tempnum;
            }
            else
            {
                double temp = DBHeight * (1 - (BurnningRate / 100)) * (1 - (BurnningRate1 / 100));
                double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
                StraighteningResult.QaTon = temp * percent / 100 * tempnum;
            }


            StraighteningResult.JudgeStoveNo = JudgeStoveNo;
            StraighteningResult.NodeFurFlag = "1";
            StraighteningResult.ColGroup = UserInfo.GetUserGroup();
            StraighteningResult.ColShift = UserInfo.GetUserOrder();
            StraighteningResult.ColUser = UserInfo.GetUserName();
            StraighteningResult.UserId = _UserID;
            StraighteningResult.ProPlanId = proPlanId;
            StraighteningResult.GxPlanNo = gxPlanNo;
            StraighteningResult.LotNo = lotNo;
            StraighteningResult.PlineCode = PlineCode;
            
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
            ccp.MethodName = "updateMilSlab";
            ccp.ServerParams = new object[] { JudgeStoveNo, "9", proPlanId, gxPlanNo };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    //更新进程表，废品入库存
                    ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
                    ccp.MethodName = "updateProcessL";
                    ccp.ServerParams = new object[] { JudgeStoveNo, "9", "9", proPlanId, gxPlanNo, lotNo, PlineCode };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        if (ccp.ReturnInfo.Equals("修改成功!"))
                        {
                            //结炉操作：保存实绩，修改结炉状态
                            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.saveStraighteningNODE", new object[] { StraighteningResult }, this.ob);
                            //MessageBox.Show("结炉操作完成", "提示 :", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            if (count > 0)
                            {
                                //int count2 = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.scrapNodeMat", new object[] { JudgeStoveNo, 8, 0 }, this.ob);
                                ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
                                ccp.MethodName = "assignmentMatNo";
                                ccp.ServerParams = new object[] { JudgeStoveNo, "8", PlineCode, proPlanId, gxPlanNo };
                                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                if (ccp.ReturnCode != -1)
                                {
                                    if (ccp.ReturnInfo.Equals("修改成功!"))
                                    {
                                        //往跟踪记录表插入探伤开始时间
                                        NativeMethodNew nas = new NativeMethodNew(this.ob);
                                        nas.InsertSTAferDoubleClick(JudgeStoveNo, 7, "1", proPlanId, gxPlanNo);
                                        NativeMethod.CheckNodeMatStatus(JudgeStoveNo, proPlanId, gxPlanNo, 7, this.ob);
                                        this.straighteningResult1.IsCellSelect = false;
                                        this.frmStraighteningResult11.IsCellSelect = false;
                                        this.frmStraighteningResult21.IsCellSelect = false;
                                        temprstraght = NativeMethod.GetEntityToEntity(temprstraght, StraighteningResult);
                                        DataTable dt1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
                                        GridHelper.CopyDataToDatatable(ref dt1, ref dtPlan, true);
                                        //ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
                                        ChangeCellName();
                                        foreach (UltraGridRow ugr1 in this.ultraGridPlan.Rows)
                                        {


                                            ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());


                                            if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == JudgeStoveNo)
                                            {
                                                ultraGridPlan.ActiveRow = ugr1;
                                            }
                                        }

                                        this.dataSet2.Clear();
                                        MessageUtil.ShowTips("炉号：【" + JudgeStoveNo + "】结炉成功!");
                                    }
                                }
                                else
                                {
                                    MessageUtil.ShowTips(ccp.ReturnInfo);
                                }

                            }
                        }
                        else
                        {
                            MessageUtil.ShowTips(ccp.ReturnInfo);
                        }
                    }
                }
            }
            
            

        }
        /// <summary>
        /// 
        /// </summary>
        private void NodeBack()
        {

            if (this.ultraGridPlan.ActiveRow == null)
            {
                MessageBox.Show("请选择需要回退的炉号！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            UltraGridRow ugr = ultraGridPlan.ActiveRow;
            string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
            string ResultNo = ugr.Cells["ID"].Value.ToString();
            //string NodeFlag = ugr.Cells["IS_START"].Value.ToString();
            string NodeFlag = doQueryJugeNoStaus(ResultNo, JudgeStoveNo, PlineCode);

            DataTable dtMat = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmOffLine.doQueryMatScrap", new object[] { JudgeStoveNo, PlineCode, proPlanId, gxPlanNo }, this.ob);
            if (dtMat.Rows.Count > 0)
            {
                if (int.Parse(dtMat.Rows[0][0].ToString()) > 0)
                {
                    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】的废品已发运，不能结炉回退！！！！");
                    return;
                }
            }

            DataTable dtKG_FLAG = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetStraightKG_Flag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
            if (dtKG_FLAG.Rows.Count > 0)
            {
                string kgflag = dtKG_FLAG.Rows[0]["KG_FLAG"].ToString();
                //if (kgflag.Equals("1"))
                //{
                //    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】 为探伤返线生成，不允许结炉回退。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //    return;
                //}
            }

            if (NodeFlag != "1")
            {
                MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】未结炉，不能结炉回退！！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.doQueryOffline", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds.Rows.Count > 0)
            {
                MessageUtil.ShowTips("探伤工序存在下线实绩,不允许结炉回退!");
                return;
            }

            DataTable ds1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.doQueryStraighteningOfflineBack", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds1.Rows.Count > 0)
            {
                string BACKLINE_NUM = ds1.Rows[0]["BACKLINE_NUM"].ToString();
                MessageUtil.ShowTips("矫直工序存在离线数据已 返线或者组炉 " + BACKLINE_NUM + "支,不允许结炉回退!");
                return;
            }

            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.doNodeBackCheck", new object[] { JudgeStoveNo, ResultNo, proPlanId, gxPlanNo }, this.ob);
            if (dt.Rows.Count > 0)
            {
                string NodeProcess = ""; //当前炉次结炉工序
                string NodeStatus = dt.Rows[0][0].ToString();
                switch (NodeStatus)
                {
                    case "30":
                        NodeProcess = "穿孔";
                        break;
                    case "40":
                        NodeProcess = "连轧";
                        break;
                    case "50":
                        NodeProcess = "再加热炉";
                        break;
                    case "60":
                        NodeProcess = "定径";
                        break;
                    case "70":
                        NodeProcess = "分切";
                        break;
                    case "80":
                        NodeProcess = "矫直";
                        break;
                    case "90":
                        NodeProcess = "探伤";
                        break;
                    case "96":
                        NodeProcess = "质检";
                        break;


                }
                if (NodeStatus != "80")
                {
                    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】 " + NodeProcess + "工序已结炉，当前工序不能结炉回退", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            ////判断当前炉次下道工序是否结炉  下道工序结炉 - 不允许回退  
            //int Seq = 0;
            //DataTable dt2 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.changeFlagQuery", new object[] { JudgeStoveNo, ResultNo, 7 , proPlanId, gxPlanNo}, this.ob);
            //if (dt2.Rows.Count > 0)
            //{
            //    Seq = int.Parse(dt2.Rows[0][0].ToString());
            //}
            //int count2 = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.nodeBack", new object[] { JudgeStoveNo, ResultNo, 7, PlineCode, Seq, 0 }, this.ob);
            string Group = UserInfo.GetUserGroup();
            string Shift = UserInfo.GetUserOrder();
            //查询结炉班次班组
            DataTable dtNodeGroup = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.doNodeBackCheck", new object[] { JudgeStoveNo, ResultNo, 7, proPlanId, gxPlanNo }, this.ob);

            if (dtNodeGroup.Rows.Count > 0)
            {
                string NodeShift = dtNodeGroup.Rows[0][0].ToString();
                string NodeGroup = dtNodeGroup.Rows[0][1].ToString();

                if (Shift == NodeShift && Group == NodeGroup)
                {
                    NativeMethodNew nas = new NativeMethodNew(this.ob);
                    if (this.ultraTabControl2.Tabs[0].Visible == true)
                    {
                        nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "1", proPlanId, gxPlanNo, lotNo);
                    }
                    if (this.ultraTabControl2.Tabs[1].Visible == true)
                    {
                        nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "2", proPlanId, gxPlanNo, lotNo);
                    }
                    if (this.ultraTabControl2.Tabs[2].Visible == true)
                    {
                        nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "3", proPlanId, gxPlanNo, lotNo);
                    }

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.zgmil.coup.FrmOffLine";
                    ccp.MethodName = "insertMatScrapBack";
                    ccp.ServerParams = new object[] { JudgeStoveNo, proPlanId, gxPlanNo, PlineCode, "9" };
                    ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    { MessageUtil.ShowTips(ccp.ReturnInfo); }

                    ChangeGridColor();

                    PlanQuery();
                }
                else
                {
                    switch (NodeShift)
                    {
                        case "0":
                            NodeShift = "白班";
                            break;
                        case "1":
                            NodeShift = "早班";
                            break;
                        case "2":
                            NodeShift = "中班";
                            break;
                        case "3":
                            NodeShift = "夜班";
                            break;
                    }
                    switch (NodeGroup)
                    {
                        case "1":
                            NodeGroup = "甲班";
                            break;
                        case "2":
                            NodeGroup = "乙班";
                            break;
                        case "3":
                            NodeGroup = "丙班";
                            break;
                        case "4":
                            NodeGroup = "丁班";
                            break;
                    }
                    switch (this.UserInfo.GetUserOrder())
                    {
                        case "0":
                            Shift = "白班";
                            break;
                        case "1":
                            Shift = "早班";
                            break;
                        case "2":
                            Shift = "中班";
                            break;
                        case "3":
                            Shift = "夜班";
                            break;
                    }
                    switch (this.UserInfo.GetUserGroup())
                    {
                        case "1":
                            Group = "甲班";
                            break;
                        case "2":
                            Group = "乙班";
                            break;
                        case "3":
                            Group = "丙班";
                            break;
                        case "4":
                            Group = "丁班";
                            break;
                    }
                    MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】已由" + NodeGroup + "，" + NodeShift + "结炉，当班不能结炉回退");
                    return;
                }
            }

        }

        /// <summary>
        /// 1#剔除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid_GHDL1_ClickCellButton(object sender, CellEventArgs e)
        {
            int countss = 0;
            MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
            UltraGridRow ugr = ultraGrid_GHDL1.ActiveRow;
            UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
            string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
            if (PlanStatuss != "已开始矫直")
            {
                MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不允许操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
            String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
            String Seq = ugr.Cells["seq"].Value.ToString();
            int Seq1 = int.Parse(Seq);
            string Status = ugr1.Cells["IS_START"].Value.ToString();
            string DlSTATUS = ugr.Cells["Status"].Value.ToString();
            string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
            string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
            //if (ActiveOFFLINE_FLAG.Equals("2"))
            //{
            //    if (!offline.Equals("返线"))
            //    {
            //        MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //        return;
            //    }
            //}
            string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
            string group = ugr.Cells["COL_GROUP"].Value.ToString();
            Shift = UserInfo.GetUserOrder();
            Group = UserInfo.GetUserGroup();
            NativeMethodNew nasssss = new NativeMethodNew(this.ob);
            if (nasssss.IsRackOperate(shif, group))
            {
                MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataTable ds = new DataTable();
            DataTable dd = new DataTable();
            if (e.Cell.Column.Key == "SCRAP_SLAB")
            {

                if (Status != "已开始矫直")
                {
                    MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (DlSTATUS == "剔除")
                {
                    MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 8, "1", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "1", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }
                
                if (this.ultraGrid_GHDL1.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    if (e.Cell.Column.Key == "SCRAP_SLAB")
                    {
                        MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    else if (e.Cell.Column.Key == "ChangShift")
                    {
                        MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能进行交班操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                }

                //if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
                //{
                //    return;
                //}

                ScrapSlab.JudgeStoveNo = JudgeStoveNo;
                ScrapSlab.Seq = Seq;
                ScrapSlab.ProcessNo = "9";
                ScrapSlab.Flag = "0";
                ScrapSlab.ColMode = "1";
                ScrapSlab.ColUser = UserInfo.GetUserName();
                ScrapSlab.ColGroup = UserInfo.GetUserGroup();
                ScrapSlab.ColShift = UserInfo.GetUserOrder();
                ScrapSlab.ColNo = "1";
                ScrapSlab.ProPlanId = proPlanId;
                ScrapSlab.GxPlanNo = gxPlanNo;
                //剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
                int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "1" }, this.ob);
                //MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                //CoreClientParam ccp = new CoreClientParam();
                //ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
                //ccp.MethodName = "updatePorcessOcupStaus";
                //ccp.ServerParams = new object[] { ScrapSlab, "9" };
                //if (ccp.ReturnCode != -1)
                //{
                //    if (ccp.ReturnInfo.Equals("修改成功!"))
                //    {
                        ultraGridTC();//查询跟踪记录表
                        GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                        ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                        if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                        {
                            GetRollingCard1();
                        }
                        else
                        {
                            GetRollingCard();//更新流通卡
                        }
                        ChangeGridColor();
                //    }
                //}
            }
            if (e.Cell.Column.Key == "DELBACK")
            {
                //if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
                //{
                //    return;
                //}
                if (!DlSTATUS.Equals("剔除"))
                {
                    MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int counts = 0;
                //if(Flage.Equals("1"))
                //{
                counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0, proPlanId, gxPlanNo);
                //}
                //if (Flage.Equals("2"))
                //{
                //     counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10,1, 0);
                //}
                //if (Flage.Equals("3s"))
                //{
                //     counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0);
                //}

                if (counts > 0)
                {
                    ultraGridTC();//查询跟踪记录表
                    GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                    ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                    if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                    {
                        GetRollingCard1();
                    }
                    else
                    {
                        GetRollingCard();//更新流通卡
                    }
                    ChangeGridColor();
                    //MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
           
            if (e.Cell.Column.Key == "ChangShift")
            {
                string seqlast = "";
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "1", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "1", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }

                if (this.ultraGrid_GHDL1.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
                {
                    MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //找到本台交接班的第一只
                DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "1", Shift, Group, proPlanId, gxPlanNo }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
                    {
                        seqlast = dt.Rows[0]["SEQ"].ToString();
                    }
                    else
                    {
                        //seqlast = "1";
                    }
                }
                else
                {
                    //seqlast = "1";
                }
                if (int.Parse(seqlast) > int.Parse(Seq))
                {
                    MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    //针对矫直探伤需重写
                    //HOTMethod hm = new HOTMethod(this.ob);
                    //hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
                    NativeMethodNew na = new NativeMethodNew(this.ob);
                    na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "1");
                }

            }
            if (e.Cell.Column.Key == "BTNCHANGECOM")
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "1", proPlanId, gxPlanNo);
                if (WaitChangeSeq == 0)
                {
                    MessageBox.Show("没有待交班确认的管号。");
                    return;
                }
                if (WaitChangeSeq != int.Parse(Seq))
                {
                    MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
                {
                    return;
                }
                int count =0;
                //if (ChangeUserID == "")
                //{
                //    FrmChangeGroup frmCg = new FrmChangeGroup(this.ob);
                //    frmCg.ShowDialog();
                //    if (frmCg.DialogResult == DialogResult.OK)
                //    {
                //        ChangeUserID = frmCg._UserID;
                //        //ChangePassWord = frmCg._PassWord;
                //    }
                if (this.DoRelogin(DoCheck))
                {
                    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "1", proPlanId, gxPlanNo);

                }
                //}
                //else
                //{
                //    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "1");
                //}
                 
                if (count < 1)
                {
                    MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

            }
            //过渡方法，接班后重登陆初始化导致Grid.Row为null
            if (ultraGridPlan.Rows == null)
            {
                return;
            }
            ultraGridTC();
            GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
            ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
            {
                GetRollingCard1();
            }
            else
            {
                GetRollingCard();//更新流通卡
            }
            ChangeGridColor();

        }
        /// <summary>
        /// 2#台剔除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid_GHDL2_ClickCellButton(object sender, CellEventArgs e)
        {
            int countss = 0;
            MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
            UltraGridRow ugr = ultraGrid_GHDL2.ActiveRow;
            UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
            string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
            if (PlanStatuss != "已开始矫直")
            {
                MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
            String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
            String Seq = ugr.Cells["seq"].Value.ToString();
            int Seq1 = int.Parse(Seq);
            string Status = ugr1.Cells["IS_START"].Value.ToString();
            string DlSTATUS = ugr.Cells["Status"].Value.ToString();
            string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
            string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
            if (ActiveOFFLINE_FLAG.Equals("2"))
            {
                if (!offline.Equals("返线"))
                {
                    MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
            string group = ugr.Cells["COL_GROUP"].Value.ToString();
            Shift = UserInfo.GetUserOrder();
            Group = UserInfo.GetUserGroup();
            NativeMethodNew nasssss = new NativeMethodNew(this.ob);
            DataTable ds = new DataTable();
            if (nasssss.IsRackOperate(shif, group))
            {
                MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (e.Cell.Column.Key == "SCRAP_SLAB")
            {

                if (Status != "已开始矫直")
                {
                    MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (DlSTATUS == "剔除")
                {
                    MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "2", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "2", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }

                if (this.ultraGrid_GHDL2.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
                //{
                //    return;
                //}

                ScrapSlab.JudgeStoveNo = JudgeStoveNo;
                ScrapSlab.Seq = Seq;
                ScrapSlab.ProcessNo = "9";
                ScrapSlab.Flag = "0";
                ScrapSlab.ColMode = "1";
                ScrapSlab.ColUser = UserInfo.GetUserName();
                ScrapSlab.ColGroup = UserInfo.GetUserGroup();
                ScrapSlab.ColShift = UserInfo.GetUserOrder();
                ScrapSlab.ColNo = "2";
                ScrapSlab.ProPlanId = proPlanId;
                ScrapSlab.GxPlanNo = gxPlanNo;
                //剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
                int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "2" }, this.ob);
                //MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                ultraGridTC();//查询跟踪记录表
                GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                {
                    GetRollingCard1();
                }
                else
                {
                    GetRollingCard();//更新流通卡
                }
                ChangeGridColor();
            }
            if (e.Cell.Column.Key == "DELBACK")
            {
                //if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
                //{
                //    return;
                //}
                if (!DlSTATUS.Equals("剔除"))
                {
                    MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int counts = 0;
                //if (Flage.Equals("1"))
                //{
                //    counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0);
                //}
                //if (Flage.Equals("2"))
                //{
                counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10, 1, 0, proPlanId, gxPlanNo);
                //}
                //if (Flage.Equals("3s"))
                //{
                //    counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0);
                //}

                if (counts > 0)
                {
                    ultraGridTC();//查询跟踪记录表
                    GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                    ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                    if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                    {
                        GetRollingCard1();
                    }
                    else
                    {
                        GetRollingCard();//更新流通卡
                    }
                    ChangeGridColor();
                    //MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
           
            if (e.Cell.Column.Key == "ChangShift")
            {
                string seqlast = "";
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "2", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "2", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }

                if (this.ultraGrid_GHDL2.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
                {
                    MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //找到本台交接班的第一只
                DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "2", Shift, Group, proPlanId, gxPlanNo }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
                    {
                        seqlast = dt.Rows[0]["SEQ"].ToString();
                    }
                    else
                    {
                        //seqlast = "1";
                    }
                }
                else
                {
                    //seqlast = "1";
                }
                if (int.Parse(seqlast) > int.Parse(Seq))
                {
                    MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    //针对矫直探伤需重写
                    //HOTMethod hm = new HOTMethod(this.ob);
                    //hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
                    NativeMethodNew na = new NativeMethodNew(this.ob);
                    na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "2");
                }

            }
            if (e.Cell.Column.Key == "BTNCHANGECOM")
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "2", proPlanId, gxPlanNo);
                if (WaitChangeSeq == 0)
                {
                    MessageBox.Show("没有待交班确认的管号。");
                    return;
                }
                if (WaitChangeSeq != int.Parse(Seq))
                {
                    MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
                {
                    return;
                }
                int count = 0;
                if (this.DoRelogin(DoCheck))
                {
                    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "2", proPlanId, gxPlanNo);
                }
                //else
                //{
                //    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "2");
                //}
                 
                if (count < 1)
                {
                    MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

            }
            if (this.ultraGridPlan.Rows == null)
            {
                return;
            }
            ultraGridTC();
            GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
            ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
            {
                GetRollingCard1();
            }
            else
            {
                GetRollingCard();//更新流通卡
            }
            
            ChangeGridColor();
        }

        /// <summary>
        /// 3#台剔除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid_GHDL3_ClickCellButton(object sender, CellEventArgs e)
        {
            int countss = 0;
            MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
            UltraGridRow ugr = ultraGrid_GHDL3.ActiveRow;
            UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
            string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
            if (PlanStatuss != "已开始矫直")
            {
                MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
            String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
            String Seq = ugr.Cells["seq"].Value.ToString();
            int Seq1 = int.Parse(Seq);
            string Status = ugr1.Cells["IS_START"].Value.ToString();
            string DlSTATUS = ugr.Cells["Status"].Value.ToString();
            string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
            string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
            if (ActiveOFFLINE_FLAG.Equals("2"))
            {
                if (!offline.Equals("返线"))
                {
                    MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
            string group = ugr.Cells["COL_GROUP"].Value.ToString();
            Shift = UserInfo.GetUserOrder();
            Group = UserInfo.GetUserGroup();
            NativeMethodNew nasssss = new NativeMethodNew(this.ob);
            DataTable ds = new DataTable();
            if (nasssss.IsRackOperate(shif, group))
            {
                MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (e.Cell.Column.Key == "SCRAP_SLAB")
            {

                if (Status != "已开始矫直")
                {
                    MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (DlSTATUS == "剔除")
                {
                    MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }

                if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
                //{
                //    return;
                //}

                ScrapSlab.JudgeStoveNo = JudgeStoveNo;
                ScrapSlab.Seq = Seq;
                ScrapSlab.ProcessNo = "9";
                ScrapSlab.Flag = "0";
                ScrapSlab.ColMode = "1";
                ScrapSlab.ColUser = UserInfo.GetUserName();
                ScrapSlab.ColGroup = UserInfo.GetUserGroup();
                ScrapSlab.ColShift = UserInfo.GetUserOrder();
                ScrapSlab.ColNo = "3";
                ScrapSlab.ProPlanId = proPlanId;
                ScrapSlab.GxPlanNo = gxPlanNo;
                //剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
                int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "3" }, this.ob);
                //MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                ultraGridTC();//查询跟踪记录表
                GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                {
                    GetRollingCard1();
                }
                else
                {
                    GetRollingCard();//更新流通卡
                }
                ChangeGridColor();
            }
            if (e.Cell.Column.Key == "DELBACK")
            {
                //if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
                //{
                //    return;
                //}
                if (!DlSTATUS.Equals("剔除"))
                {
                    MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int counts = 0;
                //if (Flage.Equals("1"))
                //{
                //    counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0);
                //}
                //if (Flage.Equals("2"))
                //{
                //counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10, 1, 0);
                //}
                //if (Flage.Equals("3s"))
                //{
                counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0, proPlanId, gxPlanNo);
                //}

                if (counts > 0)
                {
                    ultraGridTC();//查询跟踪记录表
                    GetStraightResult(JudgeStoveNo, plcode);//更新实绩
                    ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
                    if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
                    {
                        GetRollingCard1();
                    }
                    else
                    {
                        GetRollingCard();//更新流通卡
                    }
                    ChangeGridColor();
                    //MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            #region 原来的交接班方法
            //if (e.Cell.Column.Key == "ChangShift")
            //{
            //    int ScrapNumBefore = 0;
            //    DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3" }, this.ob);
            //    ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

            //    DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3" }, this.ob);
            //    if (dtcount.Rows.Count > 0)
            //    {
            //        countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
            //    }

            //    if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
            //    {
            //        MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //        return;
            //    }
            //    NativeMethodNew nas = new NativeMethodNew(this.ob);
            //     Shift = UserInfo.GetUserOrder();
            //     Group = UserInfo.GetUserGroup();
            //    if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("正常"))
            //    {
            //        int count = nas.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3");
            //        if (count < 1)
            //        {
            //            MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //            return;
            //        }
            //    }
            //    if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("交班点"))//回退
            //    {

            //    }

            //}
            #endregion
            if (e.Cell.Column.Key == "ChangShift")
            {
                string seqlast = "";
                int ScrapNumBefore = 0;
                DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3", proPlanId, gxPlanNo }, this.ob);
                ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());

                DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3", proPlanId, gxPlanNo }, this.ob);
                if (dtcount.Rows.Count > 0)
                {
                    countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
                }

                if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
                {
                    MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
                {
                    MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                //找到本台交接班的第一只
                DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "3", Shift, Group, proPlanId, gxPlanNo }, this.ob);
                if (dt.Rows.Count > 0)
                {
                    if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
                    {
                        seqlast = dt.Rows[0]["SEQ"].ToString();
                    }
                    else
                    {
                        //seqlast = "1";
                    }
                }
                else
                {
                    //seqlast = "1";
                }
                if (int.Parse(seqlast) > int.Parse(Seq))
                {
                    MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    //针对矫直探伤需重写
                    //HOTMethod hm = new HOTMethod(this.ob);
                    //hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
                    NativeMethodNew na = new NativeMethodNew(this.ob);
                    na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "3");
                }

            }
            if (e.Cell.Column.Key == "BTNCHANGECOM")
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "3", proPlanId, gxPlanNo);
                if (WaitChangeSeq == 0)
                {
                    MessageBox.Show("没有待交班确认的管号。");
                    return;
                }
                if (WaitChangeSeq != int.Parse(Seq))
                {
                    MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
                {
                    return;
                }
                int count = 0;
                if (this.DoRelogin(DoCheck))
                {
                    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3", proPlanId, gxPlanNo);
                }
                //else
                //{
                //    count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3");
                //}

                if (count < 1)
                {
                    MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

            }
            if (this.ultraGridPlan.Rows == null)
            {
                return;
            }
            ultraGridTC();
            GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
            ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
            if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
            {
                GetRollingCard1();
            }
            else
            {
                GetRollingCard();//更新流通卡
            }

            ChangeGridColor();
        }

        public string DoCheck(CoreUserInfo User)
        {
            return "";
        }

        /// <summary>
        /// ///计划表ROW点击变换判断
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridPlan_BeforeRowActivate(object sender, RowEventArgs e)
        {
            if (this.straighteningResult1.IsCellSelect == true)
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
                {
                    this.straighteningResult1.IsCellSelect = false;
                    return;
                }
                //if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                //{
                this.straighteningResult1.IsCellSelect = false;
                //保存探伤实绩
                //StraighteningSave();
                //}
                //else
                //{
                this.straighteningResult1.IsCellSelect = false;

                foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
                {
                    if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
                    {
                        this.ultraGridPlan.ActiveRow = ugr;
                    }
                }

                return;
                //}

            }
            if (this.frmStraighteningResult11.IsCellSelect == true)
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
                {
                    this.frmStraighteningResult11.IsCellSelect = false;
                    return;
                }
                //if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                //{
                this.frmStraighteningResult11.IsCellSelect = false;
                //保存探伤实绩
                //StraighteningSave();
                //}
                //else
                //{
                this.frmStraighteningResult11.IsCellSelect = false;

                foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
                {
                    if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
                    {
                        this.ultraGridPlan.ActiveRow = ugr;
                    }
                }

                return;
                //}

            }
            if (this.frmStraighteningResult21.IsCellSelect == true)
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
                {
                    this.frmStraighteningResult21.IsCellSelect = false;
                    return;
                }
                //if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                //{
                this.frmStraighteningResult21.IsCellSelect = false;
                //保存探伤实绩
                //StraighteningSave();
                //}
                //else
                //{
                this.frmStraighteningResult21.IsCellSelect = false;

                foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
                {
                    if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
                    {
                        this.ultraGridPlan.ActiveRow = ugr;
                    }
                }

                return;
                //}

            }
        }


        /// <summary>
        /// 查询结炉实绩
        /// </summary>
        public void NodeQuery()
        {
            string Shift = UserInfo.GetUserOrder();
            string Group = UserInfo.GetUserGroup();
            string PliceCode = PlineCode;
            string StartTime = DateTime.Now.ToString("yyyy-MM-dd");
            string EndTime = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
            string Date = StartTime;
            StartTime = StartTime + " 00:00:00";
            EndTime = EndTime + " 00:00:00";
            DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetStraightResultNodeQuery", new object[] { PliceCode, Shift, Group, StartTime, EndTime }, this.ob);
            FrmNodeResultQuery frm = new FrmNodeResultQuery(dt, 10, Date, Shift, Group, this.ob);
            frm.ShowDialog();
        }

        /// <summary>
        /// 矫直离线
        /// </summary>
        public void Offline()
        {

            DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
            if (dtFlag.Rows.Count > 0)
            {
                if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }

            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "JZ";
            beforeQualifiedNum = this.rollingCard1.Value.SawQualifiedNum;
            qualifiedNum = string.IsNullOrEmpty(this.rollingCard1.Value.StraightQualifiedNum) ? "0" : this.rollingCard1.Value.StraightQualifiedNum;
            scrapNum = string.IsNullOrEmpty(this.rollingCard1.Value.StraightScrapNum) ? "0" : this.rollingCard1.Value.StraightScrapNum;
            offineHas = string.IsNullOrEmpty(this.rollingCard1.Value.OfflineStraight) ? "0" : this.rollingCard1.Value.OfflineStraight;
            offineHead = string.IsNullOrEmpty(this.rollingCard1.Value.BacklineStraight) ? "0" : this.rollingCard1.Value.BacklineStraight;
            string numb = (int.Parse(beforeQualifiedNum.ToString3()) - int.Parse(qualifiedNum.ToString3()) - int.Parse(scrapNum.ToString3()) - int.Parse(offineHas.ToString3()) + int.Parse(offineHead.ToString3())).ToString();
            FrmStraighteningOffLine frm = new FrmStraighteningOffLine(Node, this.ob, PlineCode, stoveno, lotno, numb, proPlanId, gxPlanNo);
            frm.ShowDialog();
            PlanQuery();
        }
        public void Offline2()
        {
            DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
            if (dtFlag.Rows.Count > 0)
            {
                if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }

            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "02";

            //FrmOffLineOperation frm = new FrmOffLineOperation(Node, this.ob, PlineCode, stoveno, lotno);
            //if (frm.ShowDialog() == DialogResult.OK)
            //{
            //    ultraGridTC();
            //}
        }
        public void Offline3()
        {
            if (!PlineCode.Equals("C010"))
            {
                MessageBox.Show("本产线不是168产线，没有3#矫直台，不允许执行3#台下线操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
            if (dtFlag.Rows.Count > 0)
            {
                if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
                {
                    MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "03";

            //FrmOffLineOperation frm = new FrmOffLineOperation(Node, this.ob, PlineCode, stoveno, lotno);
            //if (frm.ShowDialog() == DialogResult.OK)
            //{
            //    ultraGridTC();
            //}
        }

        public void BackLine1()
        {
            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "01";

            BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                ultraGridTC();
            }

        }
        public void BackLine2()
        {
            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "02";

            BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                ultraGridTC();
            }

        }
        public void BackLine3()
        {
            if (!PlineCode.Equals("C010"))
            {
                MessageBox.Show("本产线不是168产线，没有3#矫直台，不允许执行3#台下线操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            //工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
            string Node = "03";

            BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
            if (frm.ShowDialog() == DialogResult.OK)
            {
                ultraGridTC();
            }

        }
        private void ChangeShiftBack()
        {
            if (string.IsNullOrEmpty(this.ActiveJUDGE_STOVE_NO))
            {
                MessageBox.Show("您未选择任何计划，不允许进行交班回退操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
            string Status = ugr_plan.Cells["IS_START"].Value.ToString();
            if (Status == "已完成矫直")
            {
                MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】已完成矫直操作，不允许进行交班取消！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (Status == "未开始矫直")
            {
                MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】未开始矫直操作，不允许进行交班取消！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            string Shift = UserInfo.GetUserOrder();
            string Group = UserInfo.GetUserGroup();
            NativeMethodNew na = new NativeMethodNew(this.ob);
            if (na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1") || na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2") || na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3") || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1", proPlanId, gxPlanNo) || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2", proPlanId, gxPlanNo) || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3", proPlanId, gxPlanNo))
            {
                int count = na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1", proPlanId, gxPlanNo);
                na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2", proPlanId, gxPlanNo);
                if (this.PlineCode.Equals("C010"))
                {
                    na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3", proPlanId, gxPlanNo);
                }
                if (count < 1)
                {
                    //MessageBox.Show("交班回退失败， 请确认后重新操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            else
            {
                switch (Shift)
                {
                    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;
                }
                MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】未在" + Group + "，" + Shift + "进行交班操作，不允许进行交班取消操作");
                return;
            }
            GetStraightResult(ActiveJUDGE_STOVE_NO, PlineCode);//更新实绩
            ultraGridTC();
            ChangeGridColor();

        }
        private void PrintResult()
        {
            DateTime SeverTime = NativeMethod.GetSeverTime(this.ob);
            string Time = SeverTime.ToLongTimeString();
            string StartTime = "";
            string EndTime = "";
            string strurl = "";
            switch (PlineCode)
            {
                case "C008":  //250
                    //晚班
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) < 070000)
                    {
                        StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.ToShortDateString() + " 07:00:00";
                        string Date2 = SeverTime.ToString("yyyy-MM-dd");
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult250.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    else
                    {
                        StartTime = SeverTime.ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult250.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    break;
                case "C009":    //258
                    //晚班
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) < 070000)
                    {
                        StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.ToShortDateString() + " 07:00:00";
                        string Date2 = SeverTime.ToString("yyyy-MM-dd");
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult258.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    else
                    {
                        StartTime = SeverTime.ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult258.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    break;
                case "C010":     //168
                    //晚班
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) < 070000)
                    {
                        StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.ToShortDateString() + " 07:00:00";
                        string Date2 = SeverTime.ToString("yyyy-MM-dd");
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult168.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    else
                    {
                        StartTime = SeverTime.ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult168.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    break;
                case "C012":    //Arssel
                    break;
                case "C017":     //460
                    //晚班
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) < 070000)
                    {
                        StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.ToShortDateString() + " 07:00:00";
                        string Date2 = SeverTime.ToString("yyyy-MM-dd");
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult460.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    else
                    {
                        StartTime = SeverTime.ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult460.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    break;
                case "C072":    //508
                    //晚班
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) < 070000)
                    {
                        StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.ToShortDateString() + " 07:00:00";
                        string Date2 = SeverTime.ToString("yyyy-MM-dd");
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult508.cpt&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    else
                    {
                        StartTime = SeverTime.ToShortDateString() + " 07:00:00";
                        EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
                        strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult508.cpt&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
                    }
                    break;
            }

            FrmExcel fre = new FrmExcel(this.ob, strurl);
            //FrmRepExcel fre = new FrmRepExcel(ob, strurl);

            fre.AutoSize = true;
            fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fre.WindowState = FormWindowState.Maximized;
            fre.Show();

        }
        public void colchang()
        {
            if (string.IsNullOrEmpty(ActiveJUDGE_STOVE_NO))
            {
                MessageBox.Show("您未选择任何住计划，不允许执行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
            if (!ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
            {
                DataTable dtResult = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getPerResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
                DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
                if (dtFlag.Rows.Count == 0)
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始分切，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始分切，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (!dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString().Equals("1"))
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】分切工序尚未结炉，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                if (dtResult.Rows.Count == 0)
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;

                }
                if (string.IsNullOrEmpty(dtResult.Rows[0]["NODE_FUR_FLAG"].ToString()))
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;

                }
                if (dtResult.Rows[0]["NODE_FUR_FLAG"].ToString().Equals("1"))
                {
                    MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】已完成矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }
            ColNoChanges col = new ColNoChanges(this.ob, "00", ActiveJUDGE_STOVE_NO, PlineCode, proPlanId, gxPlanNo);
            col.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
            if (col.ShowDialog() == DialogResult.OK)
            {
                PlanQuery();
                GetStraightResult(ActiveJUDGE_STOVE_NO, PlineCode);//更新实绩
                GetRollingCard();//更新流通卡
                ChangeGridColor();
                //this.ultraGridTC();
                //ChangeGridColor();
            }



        }
        #endregion

    }
}