MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/JGGXPln/FrmPlnZyJgWorkBill.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.PlnSaleOrd.BaseMethod;
using Core.StlMes.Client.PlnSaleOrd.JGGXPln.Entity;
using Core.StlMes.Client.PlnSaleOrd.工序排产;
using Core.StlMes.Client.PlnSaleOrd.炉计划;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Entity;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Tool;
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.PlnSaleOrd.JGGXPln
{
    public partial class FrmPlnZyJgWorkBill : FrmBase
    {
        public FrmPlnZyJgWorkBill()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }
        private string[] plineC = null;//获取产线代码
        private DataTable dt1;
        private DataTable dt2;
        private ArrayList _entityList = null;
        private void FrmPlnZyJgWorkBill_Load(object sender, EventArgs e)
        {
         
            EntityHelper.ShowGridCaption<PlnZyJgReadyEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnOrderGxJgCEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyJgWorkbillEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyJgWorkbillEntity>(ultraGrid4.DisplayLayout.Bands[0]);
            BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "PlanBlWt", "UseBlWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "PlanBlNum", "PlanJgNum", "UseBlNum", "OutJgNum" });
            BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","PlanBlWt", "Diameter",  "SingleCutNun","PlanBlNum","PlanJgNum","Aimlength","CheckJVal","Outdiameter","Wallthick",
                "LengthMax","LengthMin","AimCutLen","AimlengthBl","MinH","MinD","UseBlNum", "UseBlWt", "OutJgNum"});
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "UseBlWt" });
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "OutJgNum", "UseBlNum" });
            BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlanBlWt", "PlanBlNum", "PlanJgNum" }, "HeatPlanNo");
            plineC = PlanHelper.InitDropPlinePower("H", chcPlineCode, this.ValidDataPurviewIds, this.ob);
            PlanHelper.InitDropPlinePower("H", chcPlineBill, this.ValidDataPurviewIds, this.ob);
            BaseHelper.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHC" });
            BaseHelper.InitCellPosition(ultraGrid2, new string[] { "GroupNumS", "GroupWts", "PlansNum", "ExpectNum", "KcCount", "PlanNum", "PlanWt", "WorkNum", "WorkNumTrant", "WorkNumTranta" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid2, new string[] { "GroupWts", "PlanWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid2, new string[] { "GroupNumS", "PlansNum", "ExpectNum", "KcCount", "PlanNum", "WorkNum", "WorkNumTrant", "WorkNumTranta" });

            BaseHelper.setOtherColumnReadOnly(ultraGrid3, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid3, new string[] { "PlanBlWt", "RealBlWt", "OutWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid3, new string[] { "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });
            BaseHelper.InitCellPosition(ultraGrid3, new string[] { "PlanBlWt", "RealBlWt", "OutWt", "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });
            BaseHelper.GridColumnSum(ultraGrid3, new string[] { "PlanBlWt", "RealBlWt", "OutWt" });
            BaseHelper.GridColumnCount(ultraGrid3, new string[] { "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });

            BaseHelper.setOtherColumnReadOnly(ultraGrid4, new string[] { "CHC", "PlanBlNum", "PlanBlWt", "LatheGrpNm", "LatheCutNm" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid4, new string[] { "PlanBlWt", "RealBlWt", "OutWt" });
            BaseHelper.setUltraGridColumnBits(ultraGrid4, new string[] { "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });
            BaseHelper.InitCellPosition(ultraGrid4, new string[] { "PlanBlWt", "RealBlWt", "OutWt", "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });
            BaseHelper.GridColumnSum(ultraGrid4, new string[] { "PlanBlWt", "RealBlWt", "OutWt" });
            BaseHelper.GridColumnCount(ultraGrid4, new string[] { "PlanJgNum", "CsJgNum", "XqJgNum", "PlanBlNum", "RealBlNum", "OutNum" });
            StoveHelper.ForbidSort(ultraGrid2);
            StoveHelper.ForbidSort(ultraGrid4);
            ultraGrid2.DisplayLayout.Bands[0].Columns["CraftNoJg2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGrid3.DisplayLayout.Bands[0].Columns["CraftNoJg2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGrid4.DisplayLayout.Bands[0].Columns["CraftNoJg2"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;

            dt1 = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryMach", new object[] { plineC, "700305" }, ob);
            ultraComboEditor2.DataSource = dt1;
            ultraComboEditor2.DisplayMember = "MACHINE_NAME";
            ultraComboEditor2.ValueMember = "MACHINE_NO";

            csMachine.DataSource = dt1;
            csMachine.DisplayMember = "MACHINE_NAME";
            csMachine.ValueMember = "MACHINE_NO";



            dt2 = ServerHelper.GetData("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryMachC", new object[] { plineC, "700302" }, ob);
            ultraComboEditor1.DataSource = dt2;
            ultraComboEditor1.DisplayMember = "MACHINE_NAME";
            ultraComboEditor1.ValueMember = "MACHINE_NO";

            cutMachine.DataSource = dt2;
            cutMachine.DisplayMember = "MACHINE_NAME";
            cutMachine.ValueMember = "MACHINE_NO";


            DateTime now = DateTime.Now;
            DateTime d1 = now;
            DateTime d2 = now;
            txtPlanTimeB1.Value = d1.ToString("yyyy-MM-dd") + " 00:00:00";
            txtPlanTimeB2.Value = d2.ToString("yyyy-MM-dd") + " 23:59:59";
            ultraGrid2.DisplayLayout.Bands[0].Columns["CodeJgBl"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGrid2.DisplayLayout.Bands[0].Columns["CodeJg"].CellAppearance.BackColor = Color.GreenYellow;

            DateTime date = new DateTime(now.Year, now.Month, 1);
            cmbDate.Value = DateTime.Parse(date.ToString("yyyy-MM-dd 00:00"));
            cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
            
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
                case "QueryCp"://查询炉计划
                    QueryZyPln("","1");
                    break;
                case "Add"://新增
                    DoAdd();
                    break;
                case "Delete"://删除
                    DoDelete();
                    break;
                case "Issued"://下发
                    DoIssued("0");
                    break;
                case "CanIssued"://取消下发
                    DoIssued("1");
                    break;
                case "Outsourc"://委外处理
                    DoOutsourc("0");
                    break;
                case "OutsourcCancel"://取消委外处理
                    DoOutsourc("1");
                    break;
                case "BreakUp"://工单拆分
                    DoBreakUp();
                    break;
                case "UpdateOrder"://修改工单计划支
                    DoUpdateOrder();
                    break;
                case "UpdateMach"://修改机床
                    DoUpdateMach();
                    break;
                case "Close"://关闭
                    this.Close();
                    break;
                case "IssuedL"://下发
                    doFurnacePlan("0");
                    break;
                case "CanIssuedL"://取消下发
                    doFurnacePlan("1");
                    break;
                case "Export":
                    ExportData();
                    break;
                case "DoPrint":
                    Print();
                    break;
                case "UpdateStauts":
                    updateStatus();
                    break;
                default:
                    break;
            }
        }

        /// <summary>
        /// 打印计划单
        /// </summary>
        private void Print()
        {
            this.ultraGrid4.UpdateData();
            UltraGridRow uRow = this.ultraGrid4.ActiveRow;
            if (uRow == null) return;
            string woId = uRow.Cells["WoId"].Text.Trim();
            string strurl = "";

            strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepJgProductionPlan.cpt" + "&WO_ID=" + woId;
            FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
            fBug.AutoSize = true;
            fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fBug.WindowState = FormWindowState.Maximized;
            fBug.Text = "计划单";
            fBug.Show();
        }
        /// <summary>
        /// 设置工单完成
        /// </summary>
        private void updateStatus()
        {
            this.ultraGrid4.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要操作的工单信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                PlnZyJgWorkbillEntity plWorkBillEntity = (PlnZyJgWorkbillEntity)row.ListObject;
                string plWorkBill = JSONFormat.Format(plWorkBillEntity);
                parmList.Add(plWorkBill);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "updateStatus";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("设置完成成功!"))
                {
                    Query();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }

        }
        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
            GridHelper.ulGridToExcel(ultraGrid4, "工单信息");
        }
        private void Query()
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                QueryZyPln("","0");
                QueryJgOrder("");
            }
            else
            {
                QueryWorkBillPln();
            }
        }

        /// <summary>
        /// 查询炉计划
        /// </summary>
        private void QueryZyPln(string proPlanId,string flag)
        {
            string cpJg = "0";
            if (chkJg.Checked)
            {
                cpJg = "1";
            }
            string heatPlanNo = ""; 
            if (chkHeatPlanNo.Checked)
            {
                if (txtHeatPlanNo.Text.Equals(""))
                {
                    MessageUtil.ShowTips("请输入炉计划ID!");
                    return;
                }
                else
                {
                    heatPlanNo = txtHeatPlanNo.Text.ToString().Trim();
                }
               
            }
            string judgeNo = "";
            if (chkJudNo.Checked )
            {
                if (txtJudNo.Text.Equals(""))
                {
                    MessageUtil.ShowTips("请输入判定炉号!");
                    return;
                }
                else
                {
                    judgeNo = txtJudNo.Text.ToString().Trim();
                }
            }
            string plineCode = "";
            if (chkPlineCode.Checked)
            {
                if (chcPlineCode.Text.Equals(""))
                {
                    MessageUtil.ShowTips("请选择接箍产线!");
                    return;
                }
                else
                {
                    plineCode = chcPlineCode.Value == null ? "" : chcPlineCode.Value.ToString();
                }
            }
            string[] pcStart = { };
            if (chkStrat.Checked && !chcStrat.Text.Equals(""))
            {
                pcStart = (chcStrat.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
            }
            string codeBl = "";
            if (chkBlCode.Checked)
            {
                if (txtBlCode.Text.Equals(""))
                {
                    MessageUtil.ShowTips("请输入备料码!");
                    return;
                }
                else
                {
                    codeBl = txtBlCode.Text.ToString().Trim();
                }
            }
            string str = "1";
            if (ultraCheckEditor6.Checked)
            {
                str = "0";
            }
            string timeB = txtPlanTimeB1.Value.ToString().ToString(); 
            string timeE = txtPlanTimeB2.Value.ToString();
            List<PlnZyJgReadyEntity> listSource = EntityHelper.GetData<PlnZyJgReadyEntity>
            ("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryPlnZyJg", new object[] { heatPlanNo, judgeNo, plineCode, plineC, pcStart, codeBl, str, proPlanId, timeB, timeE, cpJg, flag }, this.ob);
            plnZyJgReadyEntityBindingSource.DataSource = listSource;
            //GridHelper.RefreshAndAutoSize(ultraGrid1);
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                //没有实际炉计划，主炉计划变颜色
                if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
                {
                    ugr.Appearance.BackColor = Color.Orange;
                }
            }
        }
        List<PlnOrderGxJgCEntity> listSource1 = null;
        /// <summary>
        /// 查询成品合同
        /// </summary>
        /// <param name="proPlanId"></param>
        private void QueryJgOrder(string proPlanId)
        {
            string cpJg = "0";
            if (chkJg.Checked)
            {
                cpJg = "1";
            }
            string day = "0";
            if (cpJg.Equals("0"))
            {
                day = txtDay.Value.ToString();
            }
            DateTime dTime = DateTime.Now;

            string timeB = txtPlanTimeB1.Value.ToString().ToString(); //dTime.Date.ToString("yyyy-MM-dd") + " 00:00:00";
            string timeE = txtPlanTimeB2.Value.ToString();//dTime.Date.AddDays(+int.Parse(day)-1).ToString("yyyy-MM-dd") + " 23:59:59";

            string[] pcStart = { };
            if (chkStrat.Checked && !chcStrat.Text.Equals(""))
            {
                pcStart = (chcStrat.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
            }
            listSource1 = EntityHelper.GetData<PlnOrderGxJgCEntity>
           ("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryPlnZyJgOrder", new object[] { proPlanId, timeB, timeE, cpJg, pcStart }, this.ob);
            bindingSource1.DataSource = listSource1;
            //GridHelper.RefreshAndAutoSize(ultraGrid2);
            foreach (UltraGridRow item in ultraGrid2.Rows)
            {
                if (int.Parse(item.Cells["ExpectNum"].Value.ToString()) > 0)
                {
                    item.Cells["WorkNum"].Value = int.Parse(item.Cells["ExpectNum"].Value.ToString()) - int.Parse(item.Cells["WorkNumTranta"].Value.ToString()) - int.Parse(item.Cells["KcCount"].Value.ToString());
                }
                else
                {
                    item.Cells["WorkNum"].Value = int.Parse(item.Cells["PlansNum"].Value.ToString()) - int.Parse(item.Cells["WorkNumTranta"].Value.ToString()) - int.Parse(item.Cells["KcCount"].Value.ToString());
                }
                if (int.Parse(item.Cells["WorkNum"].Value.ToString()) <= 0)
                {
                    item.Cells["WorkNum"].Value = 0;
                } 
            }
        }
        /// <summary>
        /// 查询根据炉计划工单
        /// </summary>
        /// <param name="heatPlanNo"></param>
        private void QueryWorkBill(string heatPlanNo, string heatPlanSqe)
        {
            List<PlnZyJgWorkbillEntity> listSource = EntityHelper.GetData<PlnZyJgWorkbillEntity>
          ("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryPlnZyWorkBill", new object[] { heatPlanNo, heatPlanSqe }, this.ob);
            plnZyJgWorkbillEntitySource.DataSource = listSource;
            //GridHelper.RefreshAndAutoSize(ultraGrid3);
        }
        /// <summary>
        /// 查询工单信息
        /// </summary>
        private void QueryWorkBillPln()
        {
            string date = "";
            string endDate = "";
            if (chkDate.Checked)
            {
                if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0)
                {
                    MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                    return;
                }
                else
                {
                    date = cmbDate.Value.ToString();
                    endDate = cmbEndDate.Value.ToString();
                }
            }
            string workBill = chcWorkBill.Text.ToString().Trim();
            if (chkWorkBill.Checked)
            {
                if (workBill.Equals(""))
                {
                    MessageUtil.ShowTips("请输入工单号!");
                    return;
                }
            }
            else
            {
                workBill = "";
            }

            string judgeNoBill = txtBillJudgeNo.Text.ToString().Trim();
            if (chkBillJudgeNo.Checked)
            {
                if (judgeNoBill.Equals(""))
                {
                    MessageUtil.ShowTips("请输入判定炉号!");
                    return;
                }
            }
            else
            {
                judgeNoBill = "";
            }
            string plineCode = chcPlineBill.Value == null ? "" : chcPlineBill.Value.ToString();
            if (chkPlineBill.Checked)
            {
                if (chcPlineBill.Text.Equals(""))
                {
                    MessageUtil.ShowTips("请选择接箍产线!");
                    return;
                }
            }
            else
            {
                plineCode = "";
            }
            string[] pcStart = { };
            if (chkStratBill.Checked && !chcStratBill.Text.Equals(""))
            {
                pcStart = (chcStratBill.Value as List<object>).Select(p => p.ToString().Trim()).ToArray();
            }
            List<PlnZyJgWorkbillEntity> listSource = EntityHelper.GetData<PlnZyJgWorkbillEntity>
          ("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.queryPlnZyWorkBillPln", new object[] { workBill, judgeNoBill, plineCode, plineC, pcStart, date, endDate }, this.ob);
            bindingSource2.DataSource = listSource;
            //GridHelper.RefreshAndAutoSize(ultraGrid4);
            //激活操作行代码
            if ( _entityList != null)
            {
                foreach (UltraGridRow ugr in ultraGrid4.Rows)
                {
                    if (_entityList != null)
                    {
                        for (int i = 0; i < _entityList.Count; i++)
                        {
                            PlnZyJgWorkbillEntity jgxsEntity = (PlnZyJgWorkbillEntity)_entityList[i];
                            if (ugr.Cells["WoId"].Text.Trim().Equals(jgxsEntity.WoId))
                            {
                                ugr.Appearance.BackColor = Color.Wheat;
                                ugr.Activate();
                            }
                        }
                    }
                }

            }
            _entityList = null;
        }
        /// <summary>
        /// 新增工单
        /// </summary>
        private void DoAdd()
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            //if (!row.Cells["Planstatus"].Text.Equals("计划") && !row.Cells["Planstatus"].Text.Equals("下发"))
            //{
            //    MessageUtil.ShowTips("选中的该炉计划是不计划和下发状态不能新增工单!");
            //    return;
            //}
            string decision = "B";
            if (chkJg.Checked)
            {
                decision = "A";
            }
            int jgNum = int.Parse(row.Cells["UseBlNum"].Value.ToString()) - int.Parse(row.Cells["RealIndoubleNum"].Value.ToString());
            if (jgNum == 0)
            {
                MessageUtil.ShowTips("选中的炉计划已全部生成工单,请重新选择炉计划!");
                return;
            }
            int count = 0;
            string heatPlanNo = row.Cells["HeatPlanNo"].Text.ToString();
            string heatPlanSeq = row.Cells["HeatPlanSqe"].Text.ToString();
            string proPlanId = row.Cells["ProPlanId"].Text.ToString();
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    count++;
                    if (!proPlanId.Equals(item.Cells["ProPlanId"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("请勾选订单号相同的接箍排产订单信息(7+4)");
                        return;
                    }
                    //if (int.Parse(item.Cells["WorkNum"].Value.ToString()) == 0)
                    //{
                    //    if (MessageUtil.ShowYesNoAndQuestion("可做工单支为零,是否继续新增?") == DialogResult.No)
                    //    {
                    //        return;
                    //    }
                    //}
                    if (int.Parse(ultraNumericEditor1.Value.ToString())<= 0)
                    {
                        MessageUtil.ShowTips("可做工单不能为零,请输入!");
                        return;
                    }
                    int singLenCutNum = (int)(double.Parse(row.Cells["AimlengthBl"].Value.ToString()) / ((double.Parse(row.Cells["Aimlength"].Value.ToString()) + 15) / 1000)) - 2;
                   //if(ultraNumericEditor1.Value=)
                    ArrayList list1 = new ArrayList();
                    list1.Add(item.Cells["Key"].Text.ToString());
                    list1.Add(item.Cells["ProPlanId"].Text.ToString());
                    list1.Add(item.Cells["WorkNum"].Value.ToString());
                    list1.Add(ultraNumericEditor1.Value.ToString());
                    list1.Add(singLenCutNum.ToString());
                    list1.Add(item.Cells["XqJgNum"].Value.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请勾选接箍排产订单信息(7+4)");
                return;
            }
            string latheGrpNo = "";
            string latheGrpName = "";
            if (ultraComboEditor2.Text.ToString().Equals(""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("车丝机编号为空是否新增?") == DialogResult.No) return;
            }
            else
            {
                ArrayList listlat = new ArrayList((ultraComboEditor2.Value as List<object>).Select(p => p.ToString().Trim()).ToArray());
                latheGrpNo = string.Join(",", (string[])listlat.ToArray(typeof(string)));
                latheGrpName = ultraComboEditor2.Text.ToString().Trim();
            }
            string latheCutName = "";
            if (ultraComboEditor1.Text.ToString().Equals(""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("切管机编号为空是否新增?") == DialogResult.No) return;
            }
            else
            {
                //ArrayList listlat = new ArrayList((ultraComboEditor2.Value as List<object>).Select(p => p.ToString().Trim()).ToArray());
                //latheGrpNo = string.Join(",", (string[])listlat.ToArray(typeof(string)));
                latheCutName = ultraComboEditor1.Text.ToString().Trim();
            }
            string memo = txtMemo.Text.Trim().ToString();
            if (MessageUtil.ShowYesNoAndQuestion("是否新增工单?") == DialogResult.No) return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doAdd";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), heatPlanNo, heatPlanSeq, latheGrpNo, latheGrpName, latheCutName, memo, decision, ultraNumericEditor1.Value.ToString() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("新增成功!"))
            {
                Query();
            }
            
        }
        /// <summary>
        /// 删除工单
        /// </summary>
        private void DoDelete()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            int count = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    count++;
                    if (!item.Cells["ZyBillStatus"].Text.Equals("计划"))
                    {
                        MessageUtil.ShowTips("选中的工单不是计划状态,不能删除!");
                        return;
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(item.Cells["WoId"].Text.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否删除工单?") == DialogResult.No) return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doDelete";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("删除成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 工单下发/取消下发
        /// </summary>
        /// <param name="flag"></param>
        private void DoIssued(string flag)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            int count = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    count++;
                    if (flag.Equals("0"))
                    {
                        if (!item.Cells["ZyBillStatus"].Text.Equals("计划"))
                        {
                            MessageUtil.ShowTips("选中的工单不是计划状态,不能下发!");
                            return;
                        }
                    }
                    else
                    {
                        if (!item.Cells["ZyBillStatus"].Text.Equals("下发"))
                        {
                            MessageUtil.ShowTips("选中的工单不是下发状态,不能取消下发!");
                            return;
                        }
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(item.Cells["WoId"].Text.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion(flag.Equals("0") ? "是否下发?" : "是否取消下发?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doIssued";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), flag};
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("成功!"))
            {
                Query();
            }
        }
        /// <summary>
        /// 委外处理
        /// </summary>
        private void DoOutsourc(string flag)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            int count = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    count++;


                    if (flag.Equals("0"))
                    {
                        if (!item.Cells["ZyBillStatus"].Text.Equals("计划"))
                        {
                            MessageUtil.ShowTips("选中的工单不是计划状态,不能委外!");
                            return;
                        }
                    }
                    else
                    {
                        if (!item.Cells["ZyBillStatus"].Text.Equals("计划"))
                        {
                            MessageUtil.ShowTips("选中的工单不是下发状态,不能取消委外!");
                            return;
                        }
                    }
                    ArrayList list1 = new ArrayList();
                    list1.Add(item.Cells["WoId"].Text.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion(flag.Equals("0") ? "是否工单委外?" : "是否取消工单委外?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doOutsourc";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), flag };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("成功!"))
            {
                Query();
            }
        }

        /// <summary>
        /// 修改机床
        /// </summary>
        private void DoUpdateMach()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            int countM = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    countM++;
                    ArrayList list1 = new ArrayList();
                    if (item.Cells["ZyBillStatus"].Text.ToString().Equals("关闭"))
                    {
                        MessageUtil.ShowTips("选中工单已关闭,不能修改机床!");
                        return;
                    }
                    list1.Add(item.Cells["LatheGrpNo"].Value.ToString());
                    list1.Add(item.Cells["LatheGrpNm"].Text.ToString());
                    list1.Add(item.Cells["LatheCutNm"].Text.ToString());
                    list1.Add(item.Cells["WoId"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }
            if (countM == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改机床?") == DialogResult.No) return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doUpdateMach";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                QueryWorkBillPln();
            }
        }
        private void chkHeatPlanNo_CheckedChanged(object sender, EventArgs e)
        {
            if (chkHeatPlanNo.Checked) { txtHeatPlanNo.Enabled = true; } else { txtHeatPlanNo.Enabled = false; }
            if (chkPlineCode.Checked) { chcPlineCode.Enabled = true; } else { chcPlineCode.Enabled = false; }
            if (chkJudNo.Checked) { txtJudNo.Enabled = true; } else { txtJudNo.Enabled = false; }
            if (chkWorkBill.Checked) { chcWorkBill.Enabled = true; } else { chcWorkBill.Enabled = false; }
            if (chkBillJudgeNo.Checked) { txtBillJudgeNo.Enabled = true; } else { txtBillJudgeNo.Enabled = false; }
            if (chkPlineBill.Checked) { chcPlineBill.Enabled = true; } else { chcPlineBill.Enabled = false; }
            if (chkStratBill.Checked) { chcStratBill.Enabled = true; } else { chcStratBill.Enabled = false; }
            if (chkBlCode.Checked) { txtBlCode.Enabled = true; } else { txtBlCode.Enabled = false; }
            if (chkDate.Checked) { cmbDate.Enabled = true; } else { cmbDate.Enabled = false; }
            if (chkDate.Checked) { cmbEndDate.Enabled = true; } else { cmbEndDate.Enabled = false; }
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if (chkJg.Checked) { txtDay.Enabled = false; } else { txtDay.Enabled = true; }
        }
        private string proPlanId1 = "";
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;

             proPlanId1 = row.Cells["ProPlanId"].Text.ToString() + "/" + row.Cells["GxPlanNo"].Text.ToString();
             string heatPlanNo = row.Cells["HeatPlanNo"].Text.ToString();
             string heatPlanSqe = row.Cells["HeatPlanSqe"].Text.ToString();
             string plineCode = row.Cells["PlineCode"].Text.ToString();
            QueryWorkBill(heatPlanNo, heatPlanSqe);
           
            ////根据接箍产线过滤车丝机床编号
            //DataRow[] rows = dt1.Select("PLINE_NO='" + plineCode + "'");
            //if (rows.Count()>0)
            //{
            //    DataTable dt3 = rows[0].Table.Clone();
            //    foreach (DataRow drow in rows)
            //    {
            //        dt3.ImportRow(drow); // 将DataRow添加到DataTable中
            //    }
            //    ultraComboEditor2.DataSource = dt3;
            //    ultraComboEditor2.DisplayMember = "MACHINE_NAME";
            //    ultraComboEditor2.ValueMember = "MACHINE_NO";
            //}
            ////根据接箍产线过切割机床编号
            //DataRow[] rows1 = dt2.Select("PLINE_CODE='" + plineCode + "'");
            //if (rows.Count() > 0)
            //{
            //    DataTable dt4 = rows[0].Table.Clone();
            //    foreach (DataRow drow in rows1)
            //    {
            //        dt4.ImportRow(drow); // 将DataRow添加到DataTable中
            //    }
            //    ultraComboEditor1.DataSource = dt4;
            //    ultraComboEditor1.DisplayMember = "MACHINE_NAME";
            //    ultraComboEditor1.ValueMember = "MACHINE_NO";
            //}
            txtMemo.Text = "";
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
              if (toolMenu == null) return;

              if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
              {
                  if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Issued")) { toolMenu.Toolbars[0].Tools["Issued"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("CanIssued")) { toolMenu.Toolbars[0].Tools["CanIssued"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("BreakUp")) { toolMenu.Toolbars[0].Tools["BreakUp"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateOrder")) { toolMenu.Toolbars[0].Tools["UpdateOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("QueryCp")) { toolMenu.Toolbars[0].Tools["QueryCp"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateMach")) { toolMenu.Toolbars[0].Tools["UpdateMach"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("IssuedL")) { toolMenu.Toolbars[0].Tools["IssuedL"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("CanIssuedL")) { toolMenu.Toolbars[0].Tools["CanIssuedL"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateStauts")) { toolMenu.Toolbars[0].Tools["UpdateStauts"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("DoPrint")) { toolMenu.Toolbars[0].Tools["DoPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
              }
              else
              {
                  if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Issued")) { toolMenu.Toolbars[0].Tools["Issued"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("CanIssued")) { toolMenu.Toolbars[0].Tools["CanIssued"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("BreakUp")) { toolMenu.Toolbars[0].Tools["BreakUp"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateOrder")) { toolMenu.Toolbars[0].Tools["UpdateOrder"].InstanceProps.Visible = DefaultableBoolean.True;}
                  if (toolMenu.Toolbars[0].Tools.Exists("QueryCp")) { toolMenu.Toolbars[0].Tools["QueryCp"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateMach")) { toolMenu.Toolbars[0].Tools["UpdateMach"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("IssuedL")) { toolMenu.Toolbars[0].Tools["IssuedL"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("CanIssuedL")) { toolMenu.Toolbars[0].Tools["CanIssuedL"].InstanceProps.Visible = DefaultableBoolean.False; }
                  if (toolMenu.Toolbars[0].Tools.Exists("UpdateStauts")) { toolMenu.Toolbars[0].Tools["UpdateStauts"].InstanceProps.Visible = DefaultableBoolean.True; }
                  if (toolMenu.Toolbars[0].Tools.Exists("DoPrint")) { toolMenu.Toolbars[0].Tools["DoPrint"].InstanceProps.Visible = DefaultableBoolean.True; }
                  
              }
        }

        private void FrmPlnZyJgWorkBill_Shown(object sender, EventArgs e)
        {
            if (toolMenu.Toolbars[0].Tools.Exists("Add")) { toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete")) { toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Issued")) { toolMenu.Toolbars[0].Tools["Issued"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("CanIssued")) { toolMenu.Toolbars[0].Tools["CanIssued"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("BreakUp")) { toolMenu.Toolbars[0].Tools["BreakUp"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("UpdateOrder")) { toolMenu.Toolbars[0].Tools["UpdateOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("QueryCp")) { toolMenu.Toolbars[0].Tools["QueryCp"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("UpdateMach")) { toolMenu.Toolbars[0].Tools["UpdateMach"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("Export")) { toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("IssuedL")) { toolMenu.Toolbars[0].Tools["IssuedL"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("CanIssuedL")) { toolMenu.Toolbars[0].Tools["CanIssuedL"].InstanceProps.Visible = DefaultableBoolean.True; }
            if (toolMenu.Toolbars[0].Tools.Exists("UpdateStauts")) { toolMenu.Toolbars[0].Tools["UpdateStauts"].InstanceProps.Visible = DefaultableBoolean.False; }
            if (toolMenu.Toolbars[0].Tools.Exists("DoPrint")) { toolMenu.Toolbars[0].Tools["DoPrint"].InstanceProps.Visible = DefaultableBoolean.False; }
        }

        private void chkJg_TabIndexChanged(object sender, EventArgs e)
        {
            QueryJgOrder(proPlanId1);
        }

        private void ultraNumericEditor1_ValueChanged(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            int singLenCutNum = (int)(double.Parse(row.Cells["AimlengthBl"].Value.ToString()) / ((double.Parse(row.Cells["Aimlength"].Value.ToString()) + 15) / 1000)) - 2;
            ultraNumericEditor2.Value = int.Parse(ultraNumericEditor1.Value.ToString()) * singLenCutNum;
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
             UltraGridRow row1 = ultraGrid2.ActiveRow;
            if (row1 == null) return;
            int klnum = 0;
            int singLenCutNum = (int)(double.Parse(row.Cells["AimlengthBl"].Value.ToString()) / ((double.Parse(row.Cells["Aimlength"].Value.ToString()) + 15) / 1000)) - 2;
            int jhnum = (int.Parse(row.Cells["UseBlNum"].Value.ToString()) - int.Parse(row.Cells["RealIndoubleNum"].Value.ToString())) * singLenCutNum;
            if (e.Cell.Column.Key.Equals("CHC"))
            {
                foreach (UltraGridRow item in ultraGrid2.Rows)
                {
                    if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                    {
                        klnum += int.Parse(item.Cells["WorkNum"].Value.ToString());
                    }

                }               
                if (klnum >= jhnum)
                {
                    ultraNumericEditor1.Value = int.Parse(row.Cells["UseBlNum"].Value.ToString()) - int.Parse(row.Cells["RealIndoubleNum"].Value.ToString());
                }
                else
                {
                    ultraNumericEditor1.Value = Math.Ceiling(klnum / double.Parse(singLenCutNum.ToString()));
                }        
            }
            
        }
        #region 查看工艺文件
        private void ultraGrid2_ClickCellButton(object sender, CellEventArgs e)
        {
             UltraGridRow row = ultraGrid2.ActiveRow;
             if (row == null) return;
             string orderNo = row.Cells["OrderNoSeq"].Text.ToString();
             string codeJgBl = row.Cells["CodeJgBl"].Text.ToString();
             string codeJg = row.Cells["CodeJg"].Text.ToString();
             string jgOrderno = row.Cells["JgOrderno"].Text.ToString();
             if (e.Cell.Column.Key.Equals("CraftNoJg2"))
             { 
             //if (e.Cell.Column.Key.Equals("CraftNoJg2"))
             //{
             //    string filePath = row.GetValue("CraftPath");
             //    dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
             //    askDown.Show();
             //}
             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();
             }
             else if (e.Cell.Column.Key.Equals("CodeJgBl"))
             {
                 FrmRollTubeLibraryJg down = new FrmRollTubeLibraryJg(ob,codeJgBl);
                 down.Text = "接箍原料利库";
                 //down.Visible = false;
               //  down.Size = new Size(740, this.Height);
                 //down.WindowState = FormWindowState.Minimized;
                 down.ShowDialog();
                 bool flag = down.Flaggd;
                 if (flag) { QueryJgOrder(""); }
             }
             else if (e.Cell.Column.Key.Equals("CodeJg"))
             {
                 FrmJgOrderLk down = new FrmJgOrderLk(ob, codeJg, jgOrderno);
                 down.Text = "接箍合同利库";
                 //down.Visible = false;
                 //  down.Size = new Size(740, this.Height);
                 //down.WindowState = FormWindowState.Minimized;
                 down.ShowDialog();
                 bool flag = down.Flaggd;
                 if (flag) { QueryJgOrder(""); }
             }
        }

        private void ultraGrid3_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid3.ActiveRow;
            if (row == null) return;
            string orderNo = row.Cells["OrderNoSeq"].Text.ToString();
            //if (e.Cell.Column.Key.Equals("CraftNoJg2"))
            //{
            //    string filePath = row.GetValue("CraftPath");
            //    dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
            //    askDown.Show();
            //}
            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 ultraGrid4_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            string orderNo = row.Cells["OrderNoSeq"].Text.ToString();
            //if (e.Cell.Column.Key.Equals("CraftNoJg2"))
            //{
            //    string filePath = row.GetValue("CraftPath");
            //    dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
            //    askDown.Show();
            //}
            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();
        }
        #endregion

        private void ultraGrid4_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid4.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHC"].Value = true;
                }
            }
        }
       /// <summary>
       /// 拆分工单
       /// </summary>
        private void DoBreakUp()
        {
            UltraGridRow row = ultraGrid4.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 ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    countM++;
                    ArrayList list1 = new ArrayList();
                 
                    if (!item.Cells["RealBlNum"].Text.ToString().Equals(""))
                    {
                        reaNum = int.Parse(item.Cells["RealBlNum"].Value.ToString());
                    }
                    if (!item.Cells["PlanBlNum"].Text.ToString().Equals(""))
                    {
                        plnNum = int.Parse(item.Cells["PlanBlNum"].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["RealBlWt"].Value.ToString());
                    spitRatio = double.Parse(item.Cells["PlanBlWt"].Value.ToString()) / plnNum;
                    list1.Add(item.Cells["WoId"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }
            if (countM == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (countM > 1)
            {
                MessageUtil.ShowWarning("不能一次性拆分多个工单!");
                return;
            }
            FrmSpitBill spBill = new FrmSpitBill(plnWt, plnNum, 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.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            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("拆分成功!"))
            {
                QueryWorkBillPln();
            }
        }
        

        /// <summary>
        ///修改工单计划支
        /// </summary>
        private void DoUpdateOrder()
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            int countM = 0;
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    countM++;
                    ArrayList list1 = new ArrayList();
                    if (item.Cells["PlanBlNum"].Value.ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("计划支不能为零或空!");
                        return;
                    }
                    if (item.Cells["PlanBlWt"].Value.ToString().Equals("0"))
                    {
                        MessageUtil.ShowTips("计划吨不能为零或空!");
                        return;
                    }
                    if (item.Cells["ZyBillStatus"].Text.ToString().Equals("关闭"))
                    {
                        MessageUtil.ShowTips("选中工单已关闭,不能修改支吨!");
                        return;
                    }
                    list1.Add(item.Cells["PlanBlNum"].Value.ToString());
                    list1.Add(item.Cells["PlanBlWt"].Value.ToString());
                    list1.Add(item.Cells["WoId"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }
            if (countM == 0)
            {
                MessageUtil.ShowTips("请勾选工单信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改计划支吨?") == DialogResult.No) return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doUpdateOrder";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("修改成功!"))
            {
                QueryWorkBillPln();
            }
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
         
            //计划支
            if (e.Cell.Column.Key.Equals("PlanBlNum"))
            {
                if (e.Cell.Row.Cells["PlanBlNum"].Value == null)
                {
                    e.Cell.Row.Cells["PlanBlNum"].Value = "0";
                }
                else
                {
                    ultraGrid4.UpdateData();
                    string hbConNum = e.Cell.Row.Cells["PlanBlNum"].Value.ToString();
                    if (!StringUtil.IsInt(hbConNum) || hbConNum == "0")
                    {
                        e.Cell.Row.Cells["PlanBlNum"].Value = "0";
                    }
                    
                }
            }
            //计划吨
            if (e.Cell.Column.Key.Equals("PlanBlWt"))
            {
                if (e.Cell.Row.Cells["PlanBlWt"].Value == null)
                {
                    e.Cell.Row.Cells["PlanBlWt"].Value = "0";
                }
                else
                {
                    ultraGrid4.UpdateData();
                    string hbConWt = e.Cell.Row.Cells["PlanBlWt"].Value.ToString();
                    if (!StringUtil.IsFloat(hbConWt) || hbConWt == "0")
                    {
                        e.Cell.Row.Cells["PlanBlWt"].Value = "0";
                    }                
                }
            }
        }

        /// <summary>
        /// 工单调整顺序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid4_MouseDown(object sender, MouseEventArgs e)
        {
            try
            { ultraGrid4.UpdateData(); }
            catch (Exception)
            {
                MessageUtil.ShowWarning("数据异常,请刷新数据!"); return;
            }
            if (e.Button == MouseButtons.Right)
            {
                //移动行
                ArrayList entityList = ProducHelper.GetChcRows<PlnZyJgWorkbillEntity>(ultraGrid4);
                if (entityList == null || entityList.Count == 0)
                {
                    return;
                }
                //定位行
                UIElement myUIElement = ultraGrid4.DisplayLayout.UIElement.ElementFromPoint(new Point(e.X, e.Y));
                UltraGridCell myCell = (UltraGridCell)myUIElement.GetContext(typeof(UltraGridCell));
                if (myCell == null) { return; }
                UltraGridRow ugr = myCell.Row;
                if (ugr == null) { return; }
                PlnZyJgWorkbillEntity entityD = (PlnZyJgWorkbillEntity)ugr.ListObject;
                //定位行计划
                if (entityD.ZyBillStatus.Equals("生产完成") ||entityD.ZyBillStatus.Equals("关闭")) { return; }
                //定位行序号
                string gxProSeqD = entityD.GxProSeq.ToString();
                //移动行序号集合
                ArrayList seqList = new ArrayList();
                ArrayList list = new ArrayList();
                //获取数据库服务器当前时间
                //string time = DateTime.Now.ToString("yyyy-MM");
                //DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.selectSystemTime", null, ob);
                //if (dt.Rows.Count > 0)
                //{
                //    time = dt.Rows[0]["DATIME"].ToString().Substring(0, 7);
                //}
                foreach (object entityM in entityList)
                {
                    PlnZyJgWorkbillEntity entity = (PlnZyJgWorkbillEntity)entityM;
                    //调整行只能为计划中的
                    if (entity.ZyBillStatus.Equals("生产完成") || entity.ZyBillStatus.Equals("关闭")) { return; }
                    seqList.Add(Convert.ToInt32(entity.GxProSeq));
                    list.Add(JSONFormat.Format(entity));
                }
                seqList.Sort();
                //如果鼠标坐标行在调整行的中间,则不允许调整
                if (Convert.ToInt32(gxProSeqD) >= (int)seqList[0] && Convert.ToInt32(gxProSeqD) <= (int)seqList[seqList.Count - 1])
                {
                    return ;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否调整生产顺序至:" + entityD.GxProSeq + "位?") == DialogResult.No)
                {
                    return ;
                }
                string[] param = PlanHelper.SetData("com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill.sortPlanOrder", new object[] { list,  JSONFormat.Format(entityD) }, ob);
                if (param == null) { MessageUtil.ShowTips("服务端处理失败!"); return; }
                else
                {
                    _entityList = entityList;
                    QueryWorkBillPln();
                }
              
                
            }
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            if (row == null) return;
            ultraGrid4.UpdateData();
            string plineCode = row.Cells["PlineCode"].Text.ToString();
            //DataRow[] rows = dt1.Select("PLINE_NO='" + plineCode + "'");
            //if (rows.Count() > 0)
            //{
            //    DataTable dt3 = rows[0].Table.Clone();
            //    foreach (DataRow drow in rows)
            //    {
            //        dt3.ImportRow(drow); // 将DataRow添加到DataTable中
            //    }
            //    csMachine.DataSource = dt3;
            //    csMachine.DisplayMember = "MACHINE_NAME";
            //    csMachine.ValueMember = "MACHINE_NO";
            //}
            ////根据接箍产线过切割机床编号
            //DataRow[] rows1 = dt2.Select("PLINE_CODE='" + plineCode + "'");
            //if (rows.Count() > 0)
            //{
            //    DataTable dt4 = rows[0].Table.Clone();
            //    foreach (DataRow drow in rows1)
            //    {
            //        dt4.ImportRow(drow); // 将DataRow添加到DataTable中
            //    }
            //    cutMachine.DataSource = dt4;
            //    cutMachine.DisplayMember = "MACHINE_NAME";
            //    cutMachine.ValueMember = "MACHINE_NO";
            //}
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row1 = ultraGrid2.ActiveRow;
            if (row1 == null) return;
         string  proPlanId = row1.Cells["ProPlanId"].Text.ToString() + "/" + row1.Cells["GxPlanNo"].Text.ToString();
         //QueryZyPln(proPlanId, "0");

         UltraGridRow row = ultraGrid1.ActiveRow;
         if (row == null) return;
         foreach (UltraGridRow item in ultraGrid2.Rows)
         {
             if (item == null) return;
             if (item.Cells["ProPlanId"].Value.ToString().Equals(row.Cells["ProPlanId"].Text.ToString()))
             {
                 item.Appearance.BackColor = Color.Wheat;
                 item.Activate();
                 string wasteRate = "0";
                 if (!row.Cells["WasteRate"].Text.Equals(""))
                 {
                     wasteRate = row.Cells["WasteRate"].Value.ToString();
                 }
                 item.Cells["XqJgNum"].Value = (int)Math.Ceiling((1 + double.Parse(wasteRate) / 10000) * int.Parse(item.Cells["ExpectNum"].Value.ToString()));
             }
             else
             {
                 item.Appearance.ResetBackColor();
                 item.Cells["XqJgNum"].Value = "0";
             }
             //item.Cells["CHC"].Value = false;
         }
        }
        /// <summary>
        /// 炉计划下发
        /// </summary>
        private void doFurnacePlan(string flag)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;

            int countM = 0;
   
            ArrayList list = new ArrayList();
            foreach (UltraGridRow item in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(item.Cells["CHC"].Text) == true)
                {
                    countM++;
                    ArrayList list1 = new ArrayList();
                    if (flag.Equals("0") && !item.Cells["Planstatus"].Text.ToString().Equals("计划"))
                    {
                        MessageUtil.ShowTips("选中该炉计划已下发,不能重复下发!");
                        return;
                    }
                    if (flag.Equals("1") && item.Cells["Planstatus"].Text.ToString().Equals("计划"))
                    {
                        MessageUtil.ShowTips("选中该炉计划不处于下发状态,不能撤销!");
                        return;
                    }
                    list1.Add(item.Cells["HeatPlanNo"].Text.ToString().Trim());
                    list.Add(list1);
                }
            }

            if (countM == 0)
            {
                MessageUtil.ShowTips("请勾选接箍炉计划信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion((flag.Equals("0") ? "是否下发?" : "是否撤销下发?")) ==
               DialogResult.No)
                return;
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.jggxpln.FrmPlnZyJgWorkBill";
            ccp.MethodName = "doFurnacePlan";
            ccp.ServerParams = new object[] { list, this.UserInfo.GetUserName(), flag };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals(flag.Equals("0") ? "下发成功!" : "撤销成功!"))
            {
                Query();
            }

        }

        private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;

            string proPlanId = row.Cells["ProPlanId"].Text.ToString() + "/" + row.Cells["GxPlanNo"].Text.ToString();
            QueryJgOrder(proPlanId);
            foreach (UltraGridRow item in ultraGrid2.Rows)
            {
                if (item == null) return;
                if (item.Cells["ProPlanId"].Value.ToString().Equals(row.Cells["ProPlanId"].Text.ToString()))
                {
                    item.Appearance.BackColor = Color.Wheat;
                    item.Activate();
                    string wasteRate = "0";
                    if (!row.Cells["WasteRate"].Text.Equals(""))
                    {
                        wasteRate = row.Cells["WasteRate"].Value.ToString();
                    }
                    item.Cells["XqJgNum"].Value = (int)Math.Ceiling((1 + double.Parse(wasteRate) / 10000) * int.Parse(item.Cells["ExpectNum"].Value.ToString()));
                }
                else
                {
                    item.Appearance.ResetBackColor();
                    item.Cells["XqJgNum"].Value = "0";
                }
                //item.Cells["CHC"].Value = false;
            }
        }

        private void ultraGrid2_AfterRowActivate_1(object sender, EventArgs e)
        {
            UltraGridRow row1 = ultraGrid2.ActiveRow;
            if (row1 == null) return;
            string proPlanId = row1.Cells["ProPlanId"].Text.ToString() + "/" + row1.Cells["GxPlanNo"].Text.ToString();
        

            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;
            foreach (UltraGridRow item in ultraGrid1.Rows)
            {
                string proPlanId1 = item.Cells["ProPlanId"].Value.ToString() + "/" + item.Cells["GxPlanNo"].Value.ToString();
                if (item == null) return;
                if (proPlanId1.Equals(proPlanId))
                {
                    item.Appearance.BackColor = Color.Wheat;
                    item.Activate();}
                else
                {
                    item.Appearance.ResetBackColor();
                }
                //item.Cells["CHC"].Value = false;
            }
        }
    }
}