MES_Client/TGMES/Core.StlMes.Client.Mcp/Coupling/FrmThreadInspectResult.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 com.steering.mes.mcp.entity;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.Mcp.Common;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.CollarMaterial;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.Coupling;
using Core.StlMes.Client.Mcp.Entity;
using Core.StlMes.Client.Mcp.BaseMethod;
using Core.StlMes.Client.Mcp.Report;

namespace Core.StlMes.Client.Coup
{
    public partial class FrmThreadInspectResult : FrmBase
    {
        private string departm = "";//获取部门ID
        private string[] plineCode = null;//获取产线代码
        private string lwGx = "";//螺纹检验工序代码
        private string lwName = "";//螺纹工序名称
        private string LiXian = "";//离线支数
        private string StrMemo = "";//备注
        private string[] plineCodes;
        private int CutPiece = 0;
        private int threadinspPiece = 0;

        ArrayList listF = new ArrayList();
        public FrmThreadInspectResult()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }


        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            this.ultraGrid2.DisplayLayout.Override.AllowAddNew = Infragistics.Win.UltraWinGrid.AllowAddNew.TemplateOnBottom;
            this.ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            this.ultraGrid2.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.Select;

            ////禁控件过滤
            //this.coupWoIdPlanControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            //this.coupThreadInspectControl1.Grid.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //设置计划区控件只读
            //this.coupWoIdPlanControl1.SetAllColumnsActiveOnly();
            //coupWoIdPlanControl1.Ob = this.ob;

            initControl();
        }
        private void FrmThreadInspectResult_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<PlnZyJgWorkbillEntity>(ultraGridWoId.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyJgWorkbillEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            departm = UserInfo.GetDeptid();
            //plineCode = McpBaseHelper.GetPCodePline(departm, this.ob);
            plineCodes = comm.GetPlineCode(this.ValidDataPurviewIds, "H", ob);
            //McpBaseHelper.InitPlineUnit(cmbCname, plineCode, this.ob);



            //获取螺纹工序
            DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700306" }, this.ob);
            if (dt2.Rows.Count > 0)
            {
                lwGx = dt2.Rows[0]["BASECODE"].ToString();
                lwName = dt2.Rows[0]["BASENAME"].ToString();
            }

        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    QuerySinglePlan();
                    break;
                case "DoSave":
                    DoSave();
                    break;
                case "DoUpdate":
                    DoUpdate();
                    break;
                case "DoDelete":
                    DoDelete();
                    break;
                case "DoBeside"://结炉
                    DoBeside();
                    break;
                case "UndoBeside"://撤销结炉
                    UndoBeside();
                    break;
                case "Offline"://离线
                    Offline();
                    break;
                case "unOffline"://撤销离线
                    unOffline();
                    break;
                case "Confirm":
                    confirm();//确认
                    break;
                case "CancelConfirm":
                    cancelConfirm();
                    break;
                case "DoClose":
                    this.Close();
                    break;
            }
        }

        ///
        /// 取消确认
        /// 
        private void cancelConfirm()
        {
            ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; }
            UltraGridRow row = this.ultraGridWoId.ActiveRow;
            if (row == null)
            {
                MessageUtil.ShowTips("无工单信息，不允许此操作！");
            }
            ArrayList list1 = new ArrayList();
            int UpdaCount = 0;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (ugr.Cells["CONFIRM"].Value.ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("选中有没确认实绩，不允许取消确认！");
                        return;
                    }
                    UpdaCount += 1;
                    ArrayList list = new ArrayList();
                    list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
                    list.Add(UserInfo.GetUserName());
                    list.Add(DateTime.Now.ToString());
                    list1.Add(list);
                }
            }
            if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩数据！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否取消确认螺纹检验实绩?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "getCancelConfirm";
                ccp.ServerParams = new object[] { list1 };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("取消确认成功!"))
                {
                    QuerySinglePlan();
                }
            }
        }
        ///
        /// 确认
        /// 
        private void confirm()
        {
            ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; }
            UltraGridRow row = this.ultraGridWoId.ActiveRow;
            if (row == null)
            {
                MessageUtil.ShowTips("无工单信息，不允许此操作！");
            }
            ArrayList list1 = new ArrayList();
            int UpdaCount = 0;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    if (ugr.Cells["CONFIRM"].Value.ToString().Equals("1"))
                    {
                        MessageUtil.ShowTips("选中有已确认实绩，不允许再次确认！");
                        return;
                    }
                    UpdaCount += 1;
                    ArrayList list = new ArrayList();
                    list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
                    list.Add(UserInfo.GetUserName());
                    list.Add(DateTime.Now.ToString());
                    list1.Add(list);
                }
            }
            if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩数据！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认螺纹检验实绩?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "getConfirm";
                ccp.ServerParams = new object[] { list1 };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("确认成功!"))
                {
                    QuerySinglePlan();
                }
            }
        }
        private void Offline()
        {
            string _strat = "";
            //UltraGridRow row1 = ultraGrid1.ActiveRow;
            //if (row1 == null)
            //{
            //    MessageUtil.ShowTips("没有螺纹实绩不能离线！");
            //    return;
            //}
            OffLineCut frm = new OffLineCut();
            frm.ShowDialog();
            LiXian = frm.StrNum;
            _strat = frm.Strat;
            StrMemo = frm.StrMemo;
            if (_strat.Equals("2")) return;
            if (LiXian.Equals("") || LiXian.Equals("0")) { MessageUtil.ShowTips("离线支数不能为空！"); return; }
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) return;
            if (row.Cells["ZyBillStatus"].Value.ToString() == "生产完成")
            {
                MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！");
                return;
            }
            string woId = row.Cells["WoId"].Value.ToString();
            //查询切断实绩支数和
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResult", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob);
            //VrpLoadingResultEntity result1 = new VrpLoadingResultEntity();
            //this.planExpanQuery1.Value = result;   
            string pronum = "";//锯切支数
            string cutnum = "";//锯切个数
            if (dt.Rows.Count > 0)
            {
                pronum = dt.Rows[0]["PRO_NUM"].ToString();
                cutnum = dt.Rows[0]["CUT_NUM"].ToString();
            }
            else
            {
                pronum = "0";
                cutnum = "0";
            }
            if (!row.Cells["Ifsplit"].Value.Equals("1"))
            {
                if (Convert.ToInt32(LiXian) > Convert.ToInt32(cutnum) - Convert.ToInt32(threadinspPiece) - Convert.ToInt32(offlinePiece.Value))
                {
                    MessageUtil.ShowTips("离线个数不能大于锯切个数减去已经喷砂和离线个数的差！");
                    return;
                }
            }
            offlinePiece.Value = Convert.ToInt32(LiXian) + Convert.ToInt32(offlinePiece.Value);
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} 
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryCouplingcominfo", new object[] { woId, lwGx }, this.ob);
            //if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("2"))
            //{
            //    MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
            //    return;
            //}
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            ArrayList list = new ArrayList();
            list.Add(LiXian);
            list.Add(row.Cells["WoId"].Text.ToString());
            list.Add(row.Cells["HeatPlanNo"].Text.ToString());
            list.Add(row.Cells["JudgeStoveNo"].Text.ToString());
            list.Add(row.Cells["BatchNo"].Text.ToString());
            list.Add(row.Cells["PlineCode"].Text.ToString());
            list.Add(row.Cells["PlineName"].Text.ToString());
            list.Add(this.UserInfo.GetUserName());
            list.Add(this.UserInfo.GetUserOrder());
            list.Add(this.UserInfo.GetUserGroup());
            list.Add(time);
            list.Add("");
            list.Add(StrMemo);
            list.Add(row.Cells["BatchGroudNo"].Value.ToString());
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
                ccp.MethodName = "lixianThreadingResult";
                ccp.ServerParams = new object[] { list, lwGx,lwName };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("离线成功!"))
                {
                    QuerySinglePlan();
                    //DoClean();
                }
            }
        }


        //撤销离线
        private void unOffline()
        {
            ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) { MessageUtil.ShowTips("螺纹实绩无数据！"); return; }

            UltraGridRow row = this.ultraGridWoId.ActiveRow;
            if (uRow == null)
            {
                MessageUtil.ShowTips("无工单信息，不允许此操作！");
            }
            if (row.Cells["ZyBillStatus"].Value.ToString() == "生产完成")
            {
                MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！");
                return;
            }
            string woId = row.Cells["WoId"].Value.ToString();
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("生产完成"))
            //{
            //    MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作！");
            //    return;
            //}
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryCouplingcominfo", new object[] { woId, lwGx }, this.ob);
            //if (dt.Rows[0]["STATION_STATUS"].ToString().Equals("2"))
            //{
            //    MessageUtil.ShowTips("此工单工序点已结炉,不允许此操作!");
            //    return;
            //}
            //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
            ArrayList list1 = new ArrayList();
            int UpdaCount = 0;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    UpdaCount += 1;
                    ArrayList list = new ArrayList();
                    list.Add(ugr.Cells["RESULT_NO"].Text.ToString());
                    list.Add(ugr.Cells["OFF_NUM"].Text.ToString());
                    list1.Add(list);
                }
            }
            if (UpdaCount == 0) { MessageUtil.ShowTips("请选择离线数据！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销离线?") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.CoupCutService";
                ccp.MethodName = "unlixianThreadingResult";
                ccp.ServerParams = new object[] { list1, row.Cells["WoId"].Text.ToString(), lwGx };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;



            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("撤销离线成功！"))
            {
                QuerySinglePlan();
            }
        }

        /// <summary>
        /// 按回车键触发查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ContPublic_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                QuerySinglePlan();
            }
        }
        /// <summary>
        /// 简单查询
        /// </summary>
        private void QuerySinglePlan()
        {
            string woId = "";
            string[] starts = { };
            string judgeStoveNo = "";
            string plnNo = "";
            #region  条件
            if (chkStarts.Checked)
            {
                if (string.IsNullOrEmpty(cmbStarts.Text.Trim()))
                {
                    MessageUtil.ShowTips("请选择工单状态！");
                    return;
                }
                else
                {
                    starts = (cmbStarts.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
                }
            }
            if (chkwoId.Checked)
            {
                if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
                {
                    MessageUtil.ShowTips("请输入工单号！");
                    return;
                }
                else
                {
                    woId = txtWoId.Text.ToString().Trim();
                }
            }
            else
            {
                woId = "";
            }

            if (chkPlnNo.Checked)
            {
                if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim()))
                {
                    MessageUtil.ShowTips("请输入炉次计划号！");
                    return;
                }
                else
                {
                    plnNo = txtPlnNo.Text.ToString().Trim();
                }
            }
            else
            {
                plnNo = "";
            }

            if (chkJuNo.Checked)
            {
                if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
                {
                    //MessageUtil.ShowTips("请输入炉号！");
                    //return;
                    judgeStoveNo = "";
                }
                else
                {
                    judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
                }
            }
            else
            {
                judgeStoveNo = "";
            }
         
            #endregion

            List<PlnZyJgWorkbillEntity> listSource = EntityHelper.GetData<PlnZyJgWorkbillEntity>
("com.steering.mes.mcp.coup.CoupLoadingService.getQueryWoId1", new object[] { woId, plnNo, judgeStoveNo, starts, plineCodes }, this.ob);
            plnZyJgWorkbillEntitySource.DataSource = listSource;
            //GridHelper.RefreshAndAutoSize(ultraGridWoId);

//            List<PlnZyJgWorkbillEntity> listSource1 = EntityHelper.GetData<PlnZyJgWorkbillEntity>
//("com.steering.mes.mcp.coup.CoupLoadingService.ulgetQueryWoId", new object[] { woId, plnNo, judgeStoveNo, starts, plineCode[0].ToString() }, this.ob);
//            bindingSource1.DataSource = listSource1;
//            GridHelper.RefreshAndAutoSize(ultraGrid1);
        }
        /// <summary>
        /// 螺纹检验详情
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridWoId_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) return;
            string planNO = row.Cells["HeatPlanNo"].Value.ToString();
            string plinCode = row.Cells["PlineCode"].Value.ToString();
            string woId = row.Cells["WoId"].Value.ToString();
            
            //this.coupThreadInspectControl1.Value.QualiriedPcs = BaseHelper.piecesJg(woId, plineCode,ob);
                getCoupThreadInspectResult(woId);
        }

        /// <summary>
        /// 查询螺纹检验实绩
        /// </summary>
        /// <param name="planNo"></param>
        private void getCoupThreadInspectResult(string woId)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getThreadInspectResult", new object[] { woId }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dtSelfChecked, true);
            foreach (UltraGridRow urg in ultraGrid1.Rows)
            {
                if (urg.Cells["CONFIRM"].Value.Equals("1"))
                {
                    urg.Appearance.BackColor = Color.LightGreen;
                }
            }
            if (dt.Rows.Count == 0) { this.initControl(); }

        }


        /// <summary>
        /// 接箍加工计划详情
        /// </summary>
        /// <param name="planNo"></param>
        //private void getCoupProcessPlan(string planNo,string woId)
        //{
        //    DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNo }, this.ob);
        //    if (dt != null && dt.Rows.Count > 0)
        //    {

        //        this.coupWoIdPlanControl1.Value.PlineName = dt.Rows[0]["PLINE_NAME"].ToString();
        //        this.coupWoIdPlanControl1.Value.CutMachGrpNm = dt.Rows[0]["CUT_MACH_GRP_NM"].ToString();
        //        this.coupWoIdPlanControl1.Value.Memo = dt.Rows[0]["MEMO"].ToString();
        //        this.coupWoIdPlanControl1.Value.ZyPlanId = dt.Rows[0]["ZY_PLAN_ID"].ToString();
        //        this.coupWoIdPlanControl1.Value.IfMonitorJg = dt.Rows[0]["IF_MONITOR_JG"].ToString();
        //        this.coupWoIdPlanControl1.Value.LoadPieces = dt.Rows[0]["LOAD_PIECES"].ToString();
        //        this.coupWoIdPlanControl1.Value.LoadWeight = dt.Rows[0]["LOAD_WEIGHT"].ToString();
        //        this.coupWoIdPlanControl1.Value.ProPlanId = dt.Rows[0]["PRO_PLAN_ID"].ToString();
        //        this.coupWoIdPlanControl1.Value.Steelname = dt.Rows[0]["STEELNAME"].ToString();
        //        this.coupWoIdPlanControl1.Value.Gradename = dt.Rows[0]["GRADENAME"].ToString();
        //        this.coupWoIdPlanControl1.Value.JglDesc = dt.Rows[0]["JGL_DESC"].ToString();
        //        this.coupWoIdPlanControl1.Value.CodeJg = dt.Rows[0]["CODE_JG"].ToString();
        //        this.coupWoIdPlanControl1.Value.ModelDesc = dt.Rows[0]["MODEL_DESC"].ToString();
        //        this.coupWoIdPlanControl1.Value.SpecJgDesc = dt.Rows[0]["SPEC_JG_DESC"].ToString();
        //        this.coupWoIdPlanControl1.Value.StyleJg = dt.Rows[0]["STYLE_JG"].ToString();
        //        this.coupWoIdPlanControl1.Value.PlanJgNum = dt.Rows[0]["PLAN_JG_NUM"].ToString();
        //        this.coupWoIdPlanControl1.Value.CsJgNum = dt.Rows[0]["CS_JG_NUM"].ToString();
        //        this.coupWoIdPlanControl1.Value.XqJgNum = dt.Rows[0]["XQ_JG_NUM"].ToString();
        //        this.coupWoIdPlanControl1.Value.InstoreNum = dt.Rows[0]["INSTORE_NUM"].ToString();
        //        this.coupWoIdPlanControl1.Value.BlWlDesc = dt.Rows[0]["BL_WL_DESC"].ToString();
        //        //this.coupWoIdPlanControl1.Value.LoadWeight = "";
        //        this.coupWoIdPlanControl1.UpdateData();
        //    }
        //}

        /// <summary>
        /// 初始化控件
        /// </summary>
        private void initControl()
        {
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) return;
            //查询切断实绩支数和
            DataTable dtCut = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultPiece", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob);
            string pronum = "";
            if (dtCut.Rows.Count > 0)
            {
                pronum = dtCut.Rows[0]["PRO_NUM"].ToString();
            }
            else
            {
                pronum = "0";
            }
            CutPiece = Convert.ToInt32(pronum);
            //查询螺纹检验实绩支数和
            DataTable dtThread = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getthreadinspResult", new object[] { row.Cells["WoId"].Value.ToString() }, this.ob);

            if (dtThread.Rows.Count > 0)
            {
                threadinspPiece = Convert.ToInt32(dtThread.Rows[0]["PRO_NUM"].ToString());
            }
            else
            {
                threadinspPiece = 0;
            }
    
            InspectResult result = new InspectResult();
            //if (CutPiece - threadNum <= 0)
            //{
            //    result.InspectPieces = Convert.ToString(0);
            //    threadinspPiece = 0;
            //}
            //else
            //{
            //    result.InspectPieces = Convert.ToString(CutPiece - threadNum);
            //    threadinspPiece = CutPiece - threadNum;
            //}
            txtBC.Value = UserInfo.GetUserOrder();
            txtBz.Value = UserInfo.GetUserGroup();
            txtUser.Value = UserInfo.GetUserName();
            ProducerTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
            //UltraGridRow row = ultraGrid4.ActiveRow;
            //if (row != null) { result.InspectPieces =row.Cells["LATHE_OK_NUM"].Text.ToString(); }          
        }

        /// <summary>
        /// 判断状态
        /// </summary>
        /// <param name="woId"></param>
        /// <param name="planNO"></param>
        private bool QueryStatusGd(string woId, string planNO)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, planNO }, this.ob);
            if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
            {
                MessageUtil.ShowTips("此工单已生产完成,不允许此操作！");
                return false;
            }
            if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            {
                MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
                return false;
            }
            return true;
        }
        /// <summary>
        ///  保存
        /// </summary>
        private void DoSave()
        {
 
                this.saveThreadInspectResult();
            
        }

        /// <summary>
        /// 螺纹检验实绩保存
        /// </summary>
        private void saveThreadInspectResult()
        {
            string  AddCount = "0";
            UltraGridRow row = ultraGridWoId.ActiveRow;      
            if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; }
            UltraGridRow rowMat = ultraGrid1.ActiveRow;
            //if(!QueryStatusGd(row.Cells["WO_ID"].Value.ToString(), row.Cells["ZY_PLAN_ID"].Value.ToString())) return;
            //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中"))
            //{
            //    MessageUtil.ShowTips("此工单不是生产中,不允许此操作！");
            //    return;
            //}
            string zYgNo = row.Cells["HeatPlanNo"].Value.ToString();
            string woId = row.Cells["WoId"].Value.ToString();
            //ComCoupBug ccb = new ComCoupBug();
            //string fail = ccb.Strat;
            //string failNum = ccb.StrNum;
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} 
            InspectResult result = new InspectResult();
            result.WoId = row.Cells["WoId"].Text.ToString();
            result.PlineCode = row.Cells["PlineCode"].Value.ToString();
            result.RejectedPcs = ultraNumericEditor2.Value.ToString();
            result.QualiriedPcs = numQualified.Value.ToString();
            result.InspectPieces = numPieces.Value.ToString();
            result.ColShft = txtBC.Value.ToString();
            result.ColGroup = txtBz.Value.ToString();
            result.ColTime = ProducerTime.Value.ToString();
            result.ColUser = txtUser.Text.ToString();
            result.Memo = txtMemo.Text.ToString();

            result.RepairedPcs = "0";
           

            ArrayList list = new ArrayList();
            for (int i = 0; i < ultraGrid2.Rows.Count; i++)
            {
                UltraGridRow checkrow = ultraGrid2.Rows[i];
               
                if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                {
                    //UltraGridRow rowug = ultraGrid1.ActiveRow;
                    //if (rowug == null) { MessageUtil.ShowTips("无螺纹实绩信息！"); return; }
                    AddCount = "1";
                    ThreadInspectSelfCheck thsf = getSelfcheck(checkrow);
                    //thsf.ResultNo = rowug.Cells["RESULT_NO"].Value.ToString();
                    thsf.ZyPlanId = zYgNo;
                    thsf.PlineCode = row.Cells["PlineCode"].Value.ToString();
                    thsf.WoId = woId;
                    list.Add(thsf);
                }
            }
            //if (Convert.ToInt32(this.coupThreadInspectControl1.Value.QualiriedPcs) > threadinspPiece)
            //{
            //    MessageUtil.ShowTips("螺纹检验个数大于加工最大可切个数!");
            //    return;
            //}
            //if (AddCount == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; }
            //double PlnCount = 0;//计划个数
            //double CutCount = 0;//实际个数
            //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
            //if (dt1.Rows.Count > 0)
            //{
            //    PlnCount = Double.Parse(dt1.Rows[0]["THREAD_PLN_NUM"].ToString());
            //    CutCount = Double.Parse(dt1.Rows[0]["THREAD_CHK_OK_NUM"].ToString());
            //}
            //// + Double.Parse(numQualified.Value.ToString())
            //if (CutCount > PlnCount)
            //{
            //    if (MessageUtil.ShowYesNoAndQuestion("实际螺纹检验个数超过计划螺纹检验个数是否新增！") == DialogResult.No) { return; }
            //}

            if (MessageUtil.ShowYesNoAndQuestion("是否保存螺纹检验?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "saveThreadInspectResult";
                ccp.ServerParams = new object[] { lwGx, result, list, AddCount, woId, listF };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("保存成功！"))
            {
                QuerySinglePlan();
                DoClean();
            }
        }

        /// <summary>
        /// 保存自检记录数据
        /// </summary>
        private void saveSelfcheckPipNo()
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row != null)
            {
                ArrayList list = new ArrayList();
                for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                {
                    UltraGridRow checkrow = ultraGrid2.Rows[i];

                    if (Convert.ToBoolean(checkrow.Cells["CHECK"].Value))
                    {
                        ThreadInspectSelfCheck thsf = getSelfcheck(checkrow);
                        thsf.ZyPlanId = row.Cells["ZY_PLAN_ID"].Value.ToString();
                        list.Add(thsf);
                    }
                }
                ServerHelper.SetData("com.steering.mes.mcp.coup.ThreadInspectResultService.saveThreadInspectSelfcheck", new object[] { list }, this.ob);
            }
        }

        /// <summary>
        /// 自检记录显示数据
        /// </summary>
        public void selectPipeNO(string planNo,string woId)
        {
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.ThreadInspectResultService.getThreadInspectSelfcheck", new object[] { planNo, woId }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dtInspectPIN, true);
        }

        /// <summary>
        /// 取自检记录行数据
        /// </summary>
        /// <param name="checkrow"></param>
        /// <returns></returns>
        private ThreadInspectSelfCheck getSelfcheck(UltraGridRow checkrow)
        {
            ThreadInspectSelfCheck tisc = new ThreadInspectSelfCheck();
            tisc.CouplingNo = checkrow.Cells["COUPLING_NO"].Value.ToString().Trim();
            tisc.Taper = checkrow.Cells["TAPER"].Value.ToString().Trim();
            tisc.Lead = checkrow.Cells["LEAD"].Value.ToString().Trim();
            tisc.Height = checkrow.Cells["HEIGHT"].Value.ToString().Trim();
            tisc.PdiameterOvality = checkrow.Cells["PDIAMETER_OVALITY"].Value.ToString().Trim();
            tisc.Brokenthread = checkrow.Cells["BROKENTHREAD"].Value.ToString().Trim();
            tisc.Al = checkrow.Cells["AL"].Value.ToString().Trim();
            tisc.RunOut = checkrow.Cells["RUN_OUT"].Value.ToString().Trim();
            tisc.Chamfer = checkrow.Cells["CHAMFER"].Value.ToString().Trim();
            tisc.Threadform = checkrow.Cells["THREADFORM"].Value.ToString().Trim();
            tisc.Result = checkrow.Cells["RESULT"].Value.ToString().Trim();
            tisc.ResultNo = checkrow.Cells["RESULT_NO"].Value.ToString().Trim();
            tisc.ZyPlanId = checkrow.Cells["ZY_PLAN_ID"].Value.ToString().Trim();
            tisc.PlineCode = checkrow.Cells["PLINE_CODE"].Value.ToString().Trim();
            tisc.WoId = checkrow.Cells["WO_ID"].Value.ToString().Trim();
            return tisc;
        }

        /// <summary>
        /// 自检记录序号自加1
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_AfterRowInsert(object sender, Infragistics.Win.UltraWinGrid.RowEventArgs e)
        {
            e.Row.Cells["COUPLING_NO"].Value = e.Row.Index;
                //(e.Row.Index == 0 ? 1 : Convert.ToInt32(((Infragistics.Win.UltraWinGrid.UltraGrid)sender).Rows[e.Row.Index - 1].Cells["COUPLING_NO"].Value) + 1);
            e.Row.Cells["CHECK"].Value = true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        private void DoUpdate() 
        {
            if (ultraTabControl2.Tabs.TabControl.SelectedTab.Key.Equals("0"))
            {
                DoInspUpdate();
            }
            else
            {
                DoThreUpdate();
                
            }
        }
        /// <summary>
        /// 抽检修改
        /// </summary>
        private void DoInspUpdate() 
        {
            ultraGrid2.UpdateData();
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无工单计划！"); return; }
            UltraGridRow rowMat = ultraGrid2.ActiveRow;
            if (rowMat == null) { MessageUtil.ShowTips("无抽检记录！"); return; }
            string woId = row.Cells["WoId"].Value.ToString();
            int update = 0;
            ArrayList list = new ArrayList();
            for (int i = 0; i < ultraGrid2.Rows.Count; i++)
            {
                UltraGridRow checkrow = ultraGrid2.Rows[i];
                if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                {
                    update += 1;
                    if (checkrow.Cells["RESULT_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("有选中未新增的数据，请核对！"); return; }             
                    ThreadInspectSelfCheck thsf = getSelfcheck(checkrow);
                    list.Add(thsf);
                }
            }
            if (update == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改抽检记录?") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "doInspUpdate";
                ccp.ServerParams = new object[] { list, woId };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;



            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改抽检记录成功！"))
            {
                QuerySinglePlan();
                DoClean();
            }

        }

        /// <summary>
        /// 螺纹检验修改
        /// </summary>
        private void DoThreUpdate()
        {
            ultraGrid1.UpdateData();
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; }
            UltraGridRow rowMat = ultraGrid1.ActiveRow;
            if (rowMat == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; }
            if(rowMat.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
            {
                MessageUtil.ShowTips("此工序已经离线，不允许此操作！");
                return;
            }
            //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中"))
            //{
            //    MessageUtil.ShowTips("此工单不是生产中,不允许此操作！");
            //    return;
            //}
            string zYgNo = row.Cells["HeatPlanNo"].Value.ToString();
            string woId = row.Cells["WoId"].Value.ToString();
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} 

            ArrayList list = new ArrayList();
            list.Add(rowMat.Cells["WO_ID"].Value.ToString());
            list.Add(rowMat.Cells["RESULT_NO"].Value.ToString());
            list.Add(rowMat.Cells["PLINE_CODE"].Value.ToString());
            list.Add(rowMat.Cells["INSPECT_PIECES"].Value.ToString());
            list.Add(rowMat.Cells["QUALIRIED_PCS"].Value.ToString());
            list.Add(rowMat.Cells["REJECTED_PCS"].Value.ToString());
            list.Add(rowMat.Cells["COL_SHIFT"].Value.ToString());
            list.Add(rowMat.Cells["COL_GROUP"].Value.ToString());
            list.Add(rowMat.Cells["COL_USER"].Value.ToString());
            list.Add(rowMat.Cells["COL_TIME"].Value.ToString());
            list.Add(rowMat.Cells["MEMO"].Value.ToString());

            //double PlnCount = 0;//计划个数
            //double CutCount = 0;//实际个数
            //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.PhosphateResultService.queryPlanJg", new Object[] { row.Cells["ZY_PLAN_ID"].Text.ToString() }, ob);
            //if (dt1.Rows.Count > 0)
            //{
            //    PlnCount = Double.Parse(dt1.Rows[0]["THREAD_PLN_NUM"].ToString());
            //    CutCount = Double.Parse(dt1.Rows[0]["THREAD_CHK_OK_NUM"].ToString());
            //}
            // + Double.Parse(numQualified.Value.ToString())
            //if (CutCount > PlnCount)
            //{
            //    if (MessageUtil.ShowYesNoAndQuestion("实际螺纹检验个数超过计划螺纹检验个数是否修改！") == DialogResult.No) { return; }
            //}

            if (MessageUtil.ShowYesNoAndQuestion("是否修改螺纹检验实绩?") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "doThreUpdate";
                ccp.ServerParams = new object[] { lwGx, list,woId };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;

            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功！"))
            {
                QuerySinglePlan();
                DoClean();
            }

        }
        /// <summary>
        /// 删除
        /// </summary>
        private void DoDelete()
        {
            if (ultraTabControl2.Tabs.TabControl.SelectedTab.Key.Equals("0"))
            {
                DoInspDelete();
                DoClean();
            }
            else
            {
                DoThreDelete();
                DoClean();
            }
        }

        /// <summary>
        /// 抽检删除
        /// </summary>
        private void DoInspDelete()
        {
            ultraGrid2.UpdateData();
            UltraGridRow rowMat = ultraGrid2.ActiveRow;
            if (rowMat == null) { MessageUtil.ShowTips("无抽检记录！"); return; }

            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; }
            //string zYgNo = rowMat.Cells["ZY_PLAN_ID"].Value.ToString();
            string woId = row.Cells["WoId"].Value.ToString();
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows.Count < 0) return;
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} if (dt.Rows[0]["ZY_BILL_STATUS"].ToString().Equals("生产完成"))
            //{
            //    MessageUtil.ShowTips("此工单已结炉,不允许此操作！");
            //    return;
            //}
            int update = 0;
            ArrayList list = new ArrayList();
            for (int i = 0; i < ultraGrid2.Rows.Count; i++)
            {
                UltraGridRow checkrow = ultraGrid2.Rows[i];
                if (Convert.ToBoolean(checkrow.Cells["CHECK"].Text) == true)
                {
                    update += 1;
                    if (checkrow.Cells["RESULT_NO"].Text.Trim().Equals("")) { MessageUtil.ShowTips("有选中未新增的数据，请核对！"); return; }
                    ThreadInspectSelfCheck thsf = getSelfcheck(checkrow);
                    list.Add(thsf);
                }
            }
            if (update == 0) { MessageUtil.ShowTips("请选择抽检记录！"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否删除抽检记录?") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "doInspDelete";
                ccp.ServerParams = new object[] { list, woId };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("删除抽检记录成功！"))
            {
                QuerySinglePlan();
            }

        }

        /// <summary>
        /// 螺纹实绩删除
        /// </summary>
        private void DoThreDelete()
        {
            ultraGrid1.UpdateData();
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无工单信息！"); return; }
            UltraGridRow rowMat = ultraGrid1.ActiveRow;
            if (rowMat == null) { MessageUtil.ShowTips("无螺纹检验实绩！"); return; }
            if (rowMat.Cells["CONFIRM"].Value.ToString().Equals("1"))
            {
                MessageUtil.ShowTips("选中的螺纹检验实绩已经确认，不允许删除！");
                return;
            }
            //if (!row.Cells["zyBillStatus"].Value.ToString().Equals("生产中"))
            //{
            //    MessageUtil.ShowTips("此工单不是生产中,不允许此操作！");
            //    return;
            //}
            string zYgNo = row.Cells["HeatPlanNo"].Value.ToString();
            string woId = row.Cells["WoId"].Value.ToString();
            string plinCode = row.Cells["PlineCode"].Value.ToString();
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} 
             int UpdaCount = 0;
             ArrayList list1 = new ArrayList();
             foreach (UltraGridRow ugr in ultraGrid1.Rows)
             {
                 if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                 {
                     if (ugr.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("是"))
                     {
                         MessageUtil.ShowTips("此工序已经离线，不允许此操作！");
                         return;
                     }
                     if (ugr.Cells["OFF_NUM"].Text != "0" && ugr.Cells["OFF_NUM"].Text != "")
                     {
                         MessageUtil.ShowTips("存在离线支数，不允许此操作！");
                         return;
                     }
                     UpdaCount += 1;
                     ArrayList list = new ArrayList();
                     list.Add(ugr.Cells["RESULT_NO"].Text.Trim());
                     list.Add(ugr.Cells["PLINE_CODE"].Text.Trim());
                     list.Add(ugr.Cells["REJECTED_PCS"].Text.Trim());
                     list1.Add(list);
                 }
             }
             if (UpdaCount == 0) { MessageUtil.ShowTips("请选择螺纹检验实绩!"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否删除螺纹检验实绩?") == DialogResult.No)
            {
                return;
            }

            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
                ccp.MethodName = "doThreDelete";
                ccp.ServerParams = new object[] { lwGx, list1, woId};
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;



            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("删除成功！"))
            {
                QuerySinglePlan();
            }

        }

        /// <summary>
        /// 结炉
        /// </summary>
        private void DoBeside()
        {
            UltraGridRow uRow = this.ultraGridWoId.ActiveRow;
            if (uRow == null)
            {
                MessageUtil.ShowTips("请选择需要结炉的工单号!");
                return;
            }
            //if (uRow.Cells["ZY_BILL_STATUS"].Value.ToString() == "生产完成")
            //{
            //    MessageUtil.ShowTips("此炉次计划整体已生产完成,不允许此操作！");
            //    return;
            //}
            //string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
            string woId = uRow.Cells["WoId"].Value.ToString();
            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点已结炉,不允许此操作！");
            //    return;
            //} 
            //ArrayList list = new ArrayList();
            //list.Add(zYgNo);
            //list.Add(lwGx);
            //list.Add(woId);
            if (MessageUtil.ShowYesNoAndQuestion("是否结单?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
            ccp.MethodName = "doBeside";
            ccp.ServerParams = new object[] { lwGx,woId };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("结单成功!"))
                {
                    QuerySinglePlan();      
                }

            }
        }

        /// <summary>
        /// 撤销结炉
        /// </summary>
        private void UndoBeside()
        {
            UltraGridRow uRow = this.ultraGridWoId.ActiveRow;
            if (uRow == null)
            {
                MessageUtil.ShowTips("请选择需要撤销结炉的工单号!");
                return;
            }
            //string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
            string woId = uRow.Cells["WoId"].Value.ToString();

            //DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryWoIdDetails", new object[] { woId, zYgNo }, this.ob);
            //if (!dt.Rows[0]["THREAD_CHK_STATUS"].ToString().Equals("检验完成"))
            //{
            //    MessageUtil.ShowTips("此工单螺纹检验工序点未结炉,不允许此操作！");
            //    return;
            //}
            //ArrayList list = new ArrayList();
            //list.Add(zYgNo);
            //list.Add(lwGx);
            //list.Add(woId);
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销结单?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.ThreadInspectResultService";
            ccp.MethodName = "undoBeside";
            ccp.ServerParams = new object[] { lwGx,woId };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销结单成功!"))
                {
                    QuerySinglePlan();               
                }
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            string zYgNo = "";
            string woId = "";
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row != null)
            {
                 zYgNo = row.Cells["RESULT_NO"].Value.ToString();
                 woId = row.Cells["WO_ID"].Value.ToString();
                //if (row.Cells["IF_ALL_OUT_WORK"].Value.ToString().Equals("否"))
                //{
                    //if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
                    //{
                    //this.coupThreadInspectControl1.Value.InspectPieces = row.Cells["INSPECT_PIECES"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.QualiriedPcs = row.Cells["QUALIRIED_PCS"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedPcs = row.Cells["REPAIRED_PCS"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedReason1 = row.Cells["REPAIRED_REASON1"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedPcs1 = row.Cells["REPAIRED_PCS1"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS1"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedReason2 = row.Cells["REPAIRED_REASON2"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedPcs2 = row.Cells["REPAIRED_PCS2"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS2"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedReason3 = row.Cells["REPAIRED_REASON3"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedPcs3 = row.Cells["REPAIRED_PCS3"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS3"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedReason4 = row.Cells["REPAIRED_REASON4"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RepairedPcs4 = row.Cells["REPAIRED_PCS4"].Text.ToString() == "0" ? null : row.Cells["REPAIRED_PCS4"].Text.ToString();
                    //this.coupThreadInspectControl1.Value .ColShft = row.Cells["COL_SHIFT"].Value.ToString();
                    //this.coupThreadInspectControl1.Value.ColGroup = row.Cells["COL_GROUP"].Value.ToString();
                    //this.coupThreadInspectControl1.Value.ColUser = row.Cells["COL_USER"].Text.ToString();
                    ////this.coupThreadInspectControl1.Value.ColTime = row.Cells["COL_TIME"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs = row.Cells["REJECTED_PCS"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs1 = row.Cells["REJECTED_PCS1"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS1"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs2 = row.Cells["REJECTED_PCS2"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS2"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs3 = row.Cells["REJECTED_PCS3"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS3"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs4 = row.Cells["REJECTED_PCS4"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS4"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs5 = row.Cells["REJECTED_PCS5"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS5"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs6 = row.Cells["REJECTED_PCS6"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS6"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs7 = row.Cells["REJECTED_PCS7"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS7"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedPcs8 = row.Cells["REJECTED_PCS8"].Text.ToString() == "0" ? null : row.Cells["REJECTED_PCS8"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason1 = row.Cells["REJECTED_REASON1"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason2 = row.Cells["REJECTED_REASON2"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason3 = row.Cells["REJECTED_REASON3"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason4 = row.Cells["REJECTED_REASON4"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason5 = row.Cells["REJECTED_REASON5"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason6 = row.Cells["REJECTED_REASON6"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason7 = row.Cells["REJECTED_REASON7"].Text.ToString();
                    //this.coupThreadInspectControl1.Value.RejectedReason8 = row.Cells["REJECTED_REASON8"].Text.ToString();
                    //this.coupThreadInspectControl1.UpdateData();
                    //}
                    //else
                    //{
                    //    this.initControl();
                    //}
                //}

                //selectPipeNO(zYgNo, woId);
            }
            else
            {
                this.initControl();
            }
            selectPipeNO(zYgNo, woId);
        }
        private void chkStarts_CheckedChanged(object sender, EventArgs e)
        {
            if (chkStarts.Checked) { cmbStarts.Enabled = true; } else { cmbStarts.Enabled = false; }
            if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
            if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; }
            if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
        }

        private void craftImg_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) return;
            string orderNo = row.Cells["OrderNoSeq"].Text.ToString();
            string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilCouplingProcess2.cpt"
                       + "&ORDER_NO=" + orderNo;
            FrmRepExcel down = new FrmRepExcel(ob, strurl);
            down.Text = "接箍二级工艺";
            down.Visible = false;
            down.Size = new Size(740, this.Height);
            down.WindowState = FormWindowState.Maximized;
            down.ShowDialog();
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {

               UltraGridRow row = ultraGrid1.ActiveRow;
               if (row == null) return;
               if (Convert.ToBoolean(row.Cells["CHK"].Text) == true)
               {
                   numPieces.Value = row.Cells["INSPECT_PIECES"].Text.ToString();
                   numQualified.Value = row.Cells["QUALIRIED_PCS"].Text.ToString();
                   ultraNumericEditor2.Value = row.Cells["REJECTED_PCS"].Text.ToString();
                   txtBC.Value = row.Cells["COL_SHIFT"].Text.ToString();
                   txtBz.Value = row.Cells["COL_GROUP"].Text.ToString();
                   txtUser.Text = row.Cells["COL_USER"].Text.ToString();
                   ProducerTime.Text = row.Cells["COL_TIME"].Text.ToString();
                   txtMemo.Text = row.Cells["MEMO"].Text.ToString();
               }
               else
               {
                   DoClean();
               }

        }

        private void DoClean()
        {
            ultraNumericEditor2.Value = "0";
            numPieces.Value = "0";
            numQualified.Value = "0";           
            txtMemo.Text = "";
        }

        private void numPieces_AfterEnterEditMode(object sender, EventArgs e)
        {
            this.BeginInvoke(new MethodInvoker(this.numPieces.SelectAll));
        }

        private void numQualified_AfterEnterEditMode(object sender, EventArgs e)
        {
            this.BeginInvoke(new MethodInvoker(this.numQualified.SelectAll));
        }

        private void ultraNumericEditor2_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGridWoId.ActiveRow;
            if (row == null) return;
            string woid = row.Cells["WoId"].Text.ToString();
            string judgeNo = row.Cells["JudgeStoveNo"].Text.ToString();
            ComCoupBug ccb = new ComCoupBug(woid, judgeNo, ob);
            ccb.ShowDialog();
            listF = ccb.List;
            ultraNumericEditor2.Value = ccb.SumPieces.ToString();
            //LiXian = frm.StrNum;
            //_strat = frm.Strat;
            //StrMemo = frm.StrMemo;

        }

        private void numPieces_ValueChanged(object sender, EventArgs e)
        {
            if(numPieces.Value!=""&&ultraNumericEditor2.Value=="")
            {
                numQualified.Value = numPieces.Value;
            }
            else if (numPieces.Value != "" && ultraNumericEditor2.Value!="")
            {
                numQualified.Value = Convert.ToInt32(numPieces.Value) - Convert.ToInt32(ultraNumericEditor2.Value);
            }
        }

        private void ultraNumericEditor2_ValueChanged(object sender, EventArgs e)
        {
            if (numPieces.Value == "" && ultraNumericEditor2.Value != "")
            {
                numQualified.Value = ultraNumericEditor2.Value;
            }
            else if (numPieces.Value != "" && ultraNumericEditor2.Value != "")
            {
                numQualified.Value = Convert.ToInt32(numPieces.Value) - Convert.ToInt32(ultraNumericEditor2.Value);
            }
        }


        
    }
}