MES_Client/TGMES/Core.StlMes.Client.Mcp/Coupling/FrmDownLineManage.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Common;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.Control.Base;
using Core.StlMes.Client.Mcp.Entity;
using Core.StlMes.Client.PlnSaleOrd;
using Core.StlMes.Client.PlnSaleOrd.JGGXPln;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.Mcp.Coupling
{
    public partial class FrmDownLineManage : FrmBase
    {
        private string departm = "";
        private string deparId = "";
        private string plineCode = "";
        private string storageNo = "";
        private string feedGx = "";
        private string[] plineCodes;

        public FrmDownLineManage()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void FrmVrpDownLineManage_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            departm = UserInfo.GetDepartment();
            plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
            deparId = UserInfo.GetDeptid();
            plineCodes = McpBaseHelper.GetPCodePline(deparId, this.ob);

            EntityHelper.ShowGridCaption<CouplingOfflineResultEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<CouplingOfflineResultEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<CouplingOutsourcResultEntity>(ultraGrid4.DisplayLayout.Bands[0]);
            

            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmDownLineManage.doQuery", new object[] { "7003" }, ob);
            cmbGx.DataSource = dt;
            cmbGx.DisplayMember = "BASENAME";
            cmbGx.ValueMember = "BASECODE";

            ReturnGX.DataSource = dt;
            ReturnGX.DisplayMember = "BASENAME";
            ReturnGX.ValueMember = "BASECODE";

            if (dt.Rows.Count > 0)
            {
                feedGx = dt.Rows[0]["BASECODE"].ToString();
            }

            DataTable dt3 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getStorageDep", new object[] { this.UserInfo.GetDeptid(), Core.Mes.Client.Comm.Server.ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob), "800202", "800302" }, this.ob);
            if (dt3.Rows.Count > 0)
            {
                storageNo = dt3.Rows[0]["STORAGE_NO"].ToString();
            }
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;        
                case "ReturnLine"://返线
                    DoReturnLine();
                    break;
                case "ReturnLineAddPhosphateResult"://返线交库
                    DoReturnLineAddPhosphateResult();
                    break;
                case "CancelReturnLine"://撤销返线
                    DoCancelReturnLine();
                    break;
                case "OutSourc"://委外加工
                    DoOutSourc();
                    break;
                case "CancelOutSourc"://撤销委外加工
                    DoCancelOutSourc();
                    break;
                case "InterDelegation"://委内加工
                    DoInterDelegation();     
                    break;
                case "OrdersSourc":
                    //DoOrdersSourc();委托单打印
                    break;
                case "UpdateFalg"://修改标识炉号
                    DoUpdateStoveNo();
                    break;
                case "OutApply"://委外申请
                    DoOutApply();
                    break;
                case "OutApplyUn"://撤销委外申请
                    DoOutApplyUn();
                    break;
                case "BreakUp"://工单拆分
                    DoBreakUp();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 拆分工单
        /// </summary>
        private void DoBreakUp()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            int countM = 0;
            ArrayList list = new ArrayList();
            int reaNum = 0;//离线支
            int plnNum = 0;//装炉支
            double reaWt = 0;//离线重
            double plnWt = 0;
            double spitRatio = 0;
            foreach (UltraGridRow item in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHK"].Text) == true)
                {
                    countM++;
                    ArrayList list1 = new ArrayList();

                    if (!item.Cells["OfflineNum"].Text.ToString().Equals(""))
                    {
                        reaNum = int.Parse(item.Cells["OfflineNum"].Value.ToString());
                    }
                

                    //if (item.Cells["ZyBillStatus"].Text.ToString().Equals("计划") || item.Cells["ZyBillStatus"].Text.ToString().Equals("下发"))
                    //{
                    //    MessageUtil.ShowTips("选中工单是计划/下发状态,不能拆分!");
                    //    return;
                    //}
                    //if (reaNum == 0)
                    //{
                    //    MessageUtil.ShowTips("选中的炉计划无上料支,不能拆分!");
                    //    return;
                    //}
                    //if (plnNum - reaNum <= 0)
                    //{
                    //    MessageUtil.ShowTips("选中的工单已全部上料,不能拆分!");
                    //    return;
                    //}
                    //plnWt = double.Parse(item.Cells["PlanBlWt"].Value.ToString());
                    reaWt = double.Parse(item.Cells["OfflineWt"].Value.ToString());
                    spitRatio = double.Parse(item.Cells["OfflineWt"].Value.ToString()) / reaNum;
                    list1.Add(item.Cells["WoId"].Text.ToString().Trim());
                    list1.Add(item.Cells["ResultNo"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }
            if (countM == 0)
            {
                MessageUtil.ShowTips("请勾选离线信息!");
                return;
            }
            if (countM > 1)
            {
                MessageUtil.ShowWarning("不能一次性拆分多个工单!");
                return;
            }
            FrmSpitBill spBill = new FrmSpitBill(spitRatio,this.ob, reaWt, reaNum);
            spBill.ShowDialog();
            double spitWgt = spBill.AlreadySpitWgt;
            int spitNum = spBill.AlreadySpitNum;

            if (MessageUtil.ShowYesNoAndQuestion("是否拆分?") == DialogResult.No) return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doBreakUp";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), spitWgt.ToString(), spitNum.ToString() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("拆分成功!"))
            {
                DoQuery();
            }
        }
        /// <summary>
        /// 委内加工
        /// </summary>
        private void DoInterDelegation()
        {
            ultraGrid1.UpdateData();
            var checkMagRows = this.ultraGrid1.Rows.Where(p => (bool)p.Cells["CHK"].Value).ToList();
            if (!checkMagRows.Any())
            {
                MessageUtil.ShowTips("请勾选需要委内的数据!");
                return;
            }

            var List = checkMagRows.Select(p => p.ListObject as CouplingOfflineResultEntity).Where(p => p != null).ToList();


            FrmChangePline FrmChangePline = new FrmChangePline(ob, "H", List.Select(p => p.PlineCode).ToList());
            FrmChangePline.ShowDialog();
            if (FrmChangePline.DialogResult != DialogResult.OK || FrmChangePline.PlineCode == "") return;

            if (MessageUtil.ShowYesNoAndQuestion("是否确认委内生产？") == DialogResult.No) return;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "DoInterDelegation";
            ccp.ServerParams = new object[] { List.Select(p => p.WoId).Distinct().ToList(), FrmChangePline.PlineCode, FrmChangePline.PlineName };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("委内成功！"))
                {
                    DoQuery();
                }
            }
        }


        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
            if (!CheckQuery()) return;
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                DoQueryOffLine();
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
            {
                DoQueryReturnLine();
            }
            else
            {
                DoQueryOutSourc();
            }
        }
        /// <summary>
        /// 查询离线实绩
        /// </summary>
        private void DoQueryOffLine()
        {
            string startTime = "";
            string endTime = "";
            string judgeNo = "";
            string batchNo = "";
            string gx = "";
            if (chkTim.Checked)
            {
                startTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkJugeHeatNo.Checked)
            {
                judgeNo = txtJugeNo.Text.ToString().Trim();
            }
            if (chkBatch.Checked)
            {
                batchNo = txtBatch.Text.ToString().Trim();
            }
            if (chkGx.Checked)
            {
                gx = cmbGx.Value.ToString();
            }
            ArrayList list = new ArrayList();
            list.Add(startTime);
            list.Add(endTime);
            list.Add(judgeNo);
            list.Add(batchNo);
            list.Add(gx);
            List<CouplingOfflineResultEntity> listSource = EntityHelper.GetData<CouplingOfflineResultEntity>(
         "com.steering.mes.mcp.coup.FrmDownLineManage.doQueryOffLine", new object[] { list, plineCodes }, this.ob);
            JgOfflineResultEntitybindingSource.DataSource = listSource;

        }   
        /// <summary>
        /// 返线实绩
        /// </summary> 
        private void DoQueryReturnLine()
        {
            string startTime = "";
            string endTime = "";
            string judgeNo = "";
            string batchNo = "";
            string gx = "";
            if (chkTim.Checked)
            {
                startTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkJugeHeatNo.Checked)
            {
                judgeNo = txtJugeNo.Text.ToString().Trim();
            }
            if (chkBatch.Checked)
            {
                batchNo = txtBatch.Text.ToString().Trim();
            }
            if (chkGx.Checked)
            {
                gx = cmbGx.Value.ToString();
            }
            ArrayList list = new ArrayList();
            list.Add(startTime);
            list.Add(endTime);
            list.Add(judgeNo);
            list.Add(batchNo);
            list.Add(gx);
            List<CouplingOfflineResultEntity> listSource = EntityHelper.GetData<CouplingOfflineResultEntity>(
         "com.steering.mes.mcp.coup.FrmDownLineManage.doQueryReturnLine", new object[] { list, plineCodes }, this.ob);
            JgOfflineResultEntityFX.DataSource = listSource;
        }
        /// <summary>
        /// 委外实绩
        /// 
        /// </summary>
        private void DoQueryOutSourc()
        {
            string startTime = "";
            string endTime = "";
            string judgeNo = "";
            string batchNo = "";
            string strat = "";
            if (chkTim.Checked)
            {
                startTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkJugeHeatNo.Checked)
            {
                judgeNo = txtJugeNo.Text.ToString().Trim();
            }
            if (chkBatch.Checked)
            {
                batchNo = txtBatch.Text.ToString().Trim();
            }
            if (chkStrat.Checked)
            {
                strat = cmbStrat.Value.ToString();
            }
            ArrayList list = new ArrayList();
            list.Add(startTime);
            list.Add(endTime);
            list.Add(judgeNo);
            list.Add(batchNo);
            list.Add(strat);
            List<CouplingOutsourcResultEntity> listSource = EntityHelper.GetData<CouplingOutsourcResultEntity>(
         "com.steering.mes.mcp.coup.FrmDownLineManage.doQueryOutSourc", new object[] { list, plineCodes }, this.ob);
           CouplingOutEntitySource.DataSource = listSource;
            
        }
       

      
        /// <summary>
        /// 返线
        /// </summary>
        private void DoReturnLine()
        {
            this.ultraGrid1.UpdateData();
           
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要返线的炉批信息!");
                return;
            }
            int offlinePro = checkMagRows.GroupBy(a => a.GetValue("stationCode")).Count();
            if (offlinePro > 1)
            {
                MessageUtil.ShowTips("只有同工序的炉信息，才能进行返线!");
                return;
            }
            string pointGx = "";
            string pointGxName = "";
            string plineName = "";
            UltraGridRow uurg = ultraGrid1.ActiveRow;
            if (uurg != null)
            {
                plineName = uurg.Cells["PlineCode"].Value.ToString();
            }
            FrmReturnCon line = new FrmReturnCon(plineName, ob, "7003");
            line.ShowDialog();
            if (line.DialogResult == System.Windows.Forms.DialogResult.OK)
            {
                //获取弹出窗体的属性值
                pointGx = line.RetPro;
                pointGxName = line.RetProNmae;
            }
            else
            {
                //MessageUtil.ShowTips("请选择返线经过工序点!");
                return;
            }
            ArrayList parm = new ArrayList();
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {  
                CouplingOfflineResultEntity milOfflineResultEntity = (CouplingOfflineResultEntity)row.ListObject;
                
                string milOffTity = JSONFormat.Format(milOfflineResultEntity); 
                parm.Add(milOffTity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认返线？") == DialogResult.No) return;
          
            parm2.Add(plineCode);
            parm2.Add(this.UserInfo.GetUserName());
            parm2.Add(this.UserInfo.GetUserGroup());
            parm2.Add(this.UserInfo.GetUserOrder());
            parm2.Add(pointGx);
            parm2.Add(storageNo);
            parm2.Add(UserInfo.GetDepartment());
            parm2.Add(UserInfo.GetDeptid());
            parm2.Add(pointGxName);
            parm2.Add(plineName);
            
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doReturnLine";
            ccp.ServerParams = new object[] { parm, parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("返线成功！"))
                {
                    DoQuery();
                }
            }
        }

        /// <summary>
        /// 返线交库
        /// </summary>
        private void DoReturnLineAddPhosphateResult()
        {
            this.ultraGrid1.UpdateData();

            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要返线的炉批信息!");
                return;
            }
            int offlinePro = checkMagRows.GroupBy(a => a.GetValue("stationCode")).Count();
            if (offlinePro > 1)
            {
                MessageUtil.ShowTips("只有同工序的炉信息，才能进行返线!");
                return;
            }
            string pointGx = "";
            string pointGxName = "";
            string plineName = "";
            UltraGridRow uurg = ultraGrid1.ActiveRow;
            if (uurg != null)
            {
                plineName = uurg.Cells["PlineCode"].Value.ToString();
            }
            //FrmReturnCon line = new FrmReturnCon(plineName, ob, "7003");
            //line.ShowDialog();
            //if (line.DialogResult == System.Windows.Forms.DialogResult.OK)
            //{
            //    //获取弹出窗体的属性值
            //    pointGx = line.RetPro;
            //    pointGxName = line.RetProNmae;
            //}
            //else
            //{
            //    //MessageUtil.ShowTips("请选择返线经过工序点!");
            //    return;
            //}
            ArrayList parm = new ArrayList();
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                CouplingOfflineResultEntity milOfflineResultEntity = (CouplingOfflineResultEntity)row.ListObject;

                string milOffTity = JSONFormat.Format(milOfflineResultEntity);
                parm.Add(milOffTity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认返线？") == DialogResult.No) return;

            parm2.Add(plineCode);
            parm2.Add(this.UserInfo.GetUserName());
            parm2.Add(this.UserInfo.GetUserGroup());
            parm2.Add(this.UserInfo.GetUserOrder());
            parm2.Add("700310");
            parm2.Add(storageNo);
            parm2.Add(UserInfo.GetDepartment());
            parm2.Add(UserInfo.GetDeptid());
            parm2.Add("磷化或镀铜");
            parm2.Add(plineName);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doReturnLineAddPhosphateResult";
            ccp.ServerParams = new object[] { parm, parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("返线交库成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 撤销返线
        /// </summary>
        private void DoCancelReturnLine()
        {
            this.ultraGrid3.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要撤销的返线炉批信息!");
                return;
            }

            ArrayList parm = new ArrayList();
            ArrayList parm2 = new ArrayList();
            //ArrayList parm1 = new ArrayList();
           
            foreach (UltraGridRow row in checkMagRows)
            {
                CouplingOfflineResultEntity milOfflineResultEntity = (CouplingOfflineResultEntity)row.ListObject;
                string milOffTity = JSONFormat.Format(milOfflineResultEntity);
                parm.Add(milOffTity);
            }
            parm2.Add(plineCode);    
            parm2.Add(this.UserInfo.GetUserName());
            parm2.Add(this.UserInfo.GetUserGroup());
            parm2.Add(this.UserInfo.GetUserOrder());
            parm2.Add(storageNo);
            parm2.Add(feedGx);
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销返线？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doCancelReturnLine";
            ccp.ServerParams = new object[] { parm, parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销返线成功！"))
                {
                    DoQuery();
                }
            }
        }

        /// <summary>
        /// 委外加工
        /// </summary>
        private void DoOutSourc()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要委外加工的离线信息!");
                return;
            }
            ArrayList parm = new ArrayList();
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                CouplingOfflineResultEntity milOfflineResultEntity = (CouplingOfflineResultEntity)row.ListObject;            
                string milOffTity = JSONFormat.Format(milOfflineResultEntity);
                parm.Add(milOffTity);
            }
            //FrmOut FrmOut = new FrmOut(ob);
            //FrmOut.ShowDialog();
            //if (FrmOut.DialogResult != DialogResult.OK || FrmOut.PlineCode == "") return;

            FrmOut subCon = new FrmOut(ob);
            if (subCon.ShowDialog() == DialogResult.OK)
            {
                parm2.Add(subCon.Remark);//委外说明
                parm2.Add(subCon.HarshType);//粗加工类型
                parm2.Add(subCon.StationUnitCode);
                parm2.Add(subCon.StationUnitDesc);
            }
            else
            {
                return;
            }
            parm2.Add(plineCode);
            parm2.Add(this.UserInfo.GetUserName());
            parm2.Add(this.UserInfo.GetUserGroup());
            parm2.Add(this.UserInfo.GetUserOrder());
            parm2.Add(storageNo);
            if (MessageUtil.ShowYesNoAndQuestion("是否确认委外加工？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doOutSourc";
            ccp.ServerParams = new object[] { parm, parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("委外加工成功！"))
                {
                    DoQuery();
                }
            }
        }

        /// <summary>
        /// 撤销委外加工
        /// </summary>
        private void DoCancelOutSourc()
        {
            this.ultraGrid4.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要撤销的委外加工信息!");
                return;
            }
           
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList parm = new ArrayList();
                if (!row.Cells["EntrustedLog"].Text.ToString().Equals("未申请"))
                {
                    MessageUtil.ShowTips("选中的委外单不是未申请状态,不能撤销！");
                    return;
                }
                parm.Add(row.Cells["EntrustedNo"].Text.ToString());
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销委外加工？") == DialogResult.No) return;
           
         
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doCancelOutSourc";
            ccp.ServerParams = new object[] {parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销委外加工成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 委外申请
        /// </summary>
        private void DoOutApply()
        {
            this.ultraGrid4.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选委外加工信息!");
                return;
            }

            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList parm = new ArrayList();
                if (!row.Cells["EntrustedLog"].Text.ToString().Equals("未申请"))
                {
                    MessageUtil.ShowTips("选中的委外单不是未申请状态,不能申请！");
                    return;
                }
                parm.Add(row.Cells["EntrustedNo"].Text.ToString());
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认委外申请？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "DoOutApply";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("申请成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 撤销委外申请
        /// </summary>
        private void DoOutApplyUn()
        {
            this.ultraGrid4.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选委外加工信息!");
                return;
            }

            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList parm = new ArrayList();
                if (!row.Cells["EntrustedLog"].Text.ToString().Equals("已申请"))
                {
                    MessageUtil.ShowTips("选中的委外单不是已申请状态,不能撤销申请！");
                    return;
                }
                parm.Add(row.Cells["EntrustedNo"].Text.ToString());
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销委外申请？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "DoOutApplyUn";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销申请成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 修改标识炉号
        /// </summary>
        private void DoUpdateStoveNo()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要修改的主信息!");
                return;
            }
            ArrayList parm = new ArrayList();
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList list = new ArrayList();
                list.Add(row.Cells["FlagStoveNo"].Text.ToString().Trim());
                list.Add(row.Cells["ResultNo"].Text.ToString());
                list.Add(row.Cells["HeatPlanNo"].Text.ToString());
                parm.Add(list);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改标识炉号？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.coup.FrmDownLineManage";
            ccp.MethodName = "doUpdateFlagStoveNo";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("标识炉号修改成功！"))
                {
                    DoQuery();
                }
            }

        }
        /// <summary>
        /// 数据验证
        /// </summary>
        /// <returns></returns>
        private bool CheckQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return false;
            }
            if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入炉号！");
                return false;
            }
            if (this.chkBatch.Checked && string.IsNullOrEmpty(this.txtBatch.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入生产批号！");
                return false;
            }
            if (this.chkGx.Checked && string.IsNullOrEmpty(this.cmbGx.Text.Trim()))
            {
                MessageUtil.ShowWarning("请选择工序点！");
                return false;
            }
            if (this.chkStrat.Checked && string.IsNullOrEmpty(this.cmbStrat.Text.Trim()))
            {
                MessageUtil.ShowWarning("请选择委外状态！");
                return false;
            }
            return true;
        }

        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {
            if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; }
            if (chkBatch.Checked) { txtBatch.Enabled = true; } else { txtBatch.Enabled = false; }
            if (chkGx.Checked) { cmbGx.Enabled = true; } else { cmbGx.Enabled = false; }
            if (chkStrat.Checked) { cmbStrat.Enabled = true; } else { cmbStrat.Enabled = false; }
        }

        private void ultraGrid1_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            UltraGridRow row =ultraGrid1.ActiveRow;
            this.ultraGrid1.UpdateData();
            if (e.Cell.Column.Key == "ProcessOrder")
            {
                //FrmOrderDialog orderZg = new FrmOrderDialog(this.ob, row.Cells["PlineCode"].Text.ToString(), row.Cells["ProPlanId"].Text.ToString(), row.Cells["GxPlanNo"].Text.ToString());
                //orderZg.ShowDialog();
                //SlmOrderLineEntity slmEntity = orderZg.SlmEntity;
                //if (slmEntity == null)
                //{
                //    return;
                //}
                //e.Cell.Row.Cells["ProcessOrder"].Value = slmEntity.OrderNo + "/" + slmEntity.OrderSeq + "/"+slmEntity.DeliveryNo;
                //e.Cell.Row.Cells["OrderNo"].Value = slmEntity.OrderNo;
                //e.Cell.Row.Cells["OrderSeq"].Value = slmEntity.OrderSeq;
                //e.Cell.Row.Cells["DeliveryNo"].Value = slmEntity.DeliveryNo;
                //e.Cell.Row.Cells["OrdLnDlyPk"].Value = slmEntity.OrdLnDlyPk;
                ////e.Cell.Row.Cells["PRO_PLAN_ID"].Value = slmEntity.ProPlanId;
                //e.Cell.Row.Cells["Producname"].Value = slmEntity.Producname;
                //e.Cell.Row.Cells["Produccode"].Value = slmEntity.Produccode;
                //e.Cell.Row.Cells["Steelcode"].Value = slmEntity.Steelcode;
                //e.Cell.Row.Cells["Steelname"].Value = slmEntity.Steelname;            
                ////e.Cell.Row.Cells["SpecName"].Value = slmEntity.SpecName;
                //e.Cell.Row.Cells["ModelCode"].Value = slmEntity.ModelCode;
                //e.Cell.Row.Cells["ModelDesc"].Value = slmEntity.ModelDesc;
                //e.Cell.Row.Cells["StdStyle"].Value = slmEntity.StdStyle;
                //e.Cell.Row.Cells["StdStyleDesc"].Value = slmEntity.StdStyleDesc;
                //e.Cell.Row.Cells["StdCode"].Value = slmEntity.StdCode;
                //e.Cell.Row.Cells["StdName"].Value = slmEntity.StdName;
                //string[] str = slmEntity.SpecName.ToString().Split('x');
                //e.Cell.Row.Cells["ActDimater"].Value = slmEntity.Dimater;
                //e.Cell.Row.Cells["ActHeight"].Value = slmEntity.Height;
                //e.Cell.Row.Cells["ProPlanId"].Value = slmEntity.ProPlanId;
                //e.Cell.Row.Cells["GxPlanNo"].Value = slmEntity.GxPlanNo;
            }
        }

        private void FrmVrpDownLineManage_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
            {
                toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
            {
                toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
            {
                toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
            {
                toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("OutApply"))
            {
                toolMenu.Toolbars[0].Tools["OutApply"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("OutApplyUn"))
            {
                toolMenu.Toolbars[0].Tools["OutApplyUn"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
                {
                    toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLineAddPhosphateResult"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLineAddPhosphateResult"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InterDelegation"))
                {
                    toolMenu.Toolbars[0].Tools["InterDelegation"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApply"))
                {
                    toolMenu.Toolbars[0].Tools["OutApply"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApplyUn"))
                {
                    toolMenu.Toolbars[0].Tools["OutApplyUn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                chkTim.Text = "离线日期";
                chkGx.Visible = true;
                cmbGx.Visible = true;
                chkStrat.Visible = false;
                cmbStrat.Visible = false;
                chkGx.Checked = false;
                chkStrat.Checked = false;
            }
           
            else if (ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
                {
                    toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLineAddPhosphateResult"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLineAddPhosphateResult"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InterDelegation"))
                {
                    toolMenu.Toolbars[0].Tools["InterDelegation"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApply"))
                {
                    toolMenu.Toolbars[0].Tools["OutApply"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApplyUn"))
                {
                    toolMenu.Toolbars[0].Tools["OutApplyUn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                chkTim.Text = "返线日期";
                chkGx.Visible = true;
                cmbGx.Visible = true;
                chkStrat.Visible = false;
                cmbStrat.Visible = false;
                chkGx.Checked = false;
                chkStrat.Checked = false;
            }
            else if (ultraTabControl1.SelectedTab.Key == "2")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("SetFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["SetFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelFurnace"))
                {
                    toolMenu.Toolbars[0].Tools["CancelFurnace"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OnlineComm"))
                {
                    toolMenu.Toolbars[0].Tools["OnlineComm"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ReturnLineAddPhosphateResult"))
                {
                    toolMenu.Toolbars[0].Tools["ReturnLineAddPhosphateResult"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelReturnLine"))
                {
                    toolMenu.Toolbars[0].Tools["CancelReturnLine"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OutSourc"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelOutSourc"))
                {
                    toolMenu.Toolbars[0].Tools["CancelOutSourc"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OrdersSourc"))
                {
                    toolMenu.Toolbars[0].Tools["OrdersSourc"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateFalg"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateFalg"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InterDelegation"))
                {
                    toolMenu.Toolbars[0].Tools["InterDelegation"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApply"))
                {
                    toolMenu.Toolbars[0].Tools["OutApply"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutApplyUn"))
                {
                    toolMenu.Toolbars[0].Tools["OutApplyUn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                chkTim.Text = "委外日期";
               
                chkGx.Visible = false;
                cmbGx.Visible = false;
                chkStrat.Visible = true;
                cmbStrat.Visible = true;
                chkGx.Checked = false;
                chkStrat.Checked = false;
            }
        }
    }
}