MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/炼钢计划/FrmSteelPlnZg.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.PlnSaleOrd.BaseMethod;
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.UltraWinEditors;
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.炼钢计划
{
    public partial class FrmSteelPlnZg : FrmBase
    {
        private string poPlanId;
        private string gxPlanNo;
        private OpeBase ob;
        public bool Flag = false;
        private string furnaceno;
        private string sequenceno;
        private string castNo;
        private string castSeq;
        private string toWeightM;
        private string toNumM;
        private string gradCode;
        private string diammterGp;
        private string plineCode;
        private string[] arrString = null;
        public FrmSteelPlnZg(OpeBase _ob,ArrayList list)
        {
            if (list != null)
            {
                arrString = (string[])list.ToArray(typeof(string));
                ob = _ob;
                poPlanId = arrString[0].ToString();
                gxPlanNo = arrString[1].ToString();
                furnaceno = arrString[2].ToString();
                sequenceno = arrString[3].ToString();
                castNo = arrString[4].ToString();
                toWeightM = arrString[5].ToString();
                toNumM = arrString[6].ToString();
                gradCode = arrString[7].ToString();
                diammterGp = arrString[8].ToString();
                plineCode = arrString[9].ToString();
                InitializeComponent();
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Query":
                    QueryZgS();
                    break;
                case "Library":
                    Library();
                    break;
                case "AddCast":
                    AddCast();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        string cic = "";
        string planRoute = "";
        private void FrmSteelPlnZg_Load(object sender, EventArgs e)
        {
            PlanComm.setGridActivation(ultraGridZgMs.DisplayLayout.Bands[0], "CHC", "NumberRule");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 2,
              "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK",
              "LEN_GP_SINGLE", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 3,
                "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT");
            PlanComm.setGridDigitalCol(ultraGridZgMs.DisplayLayout.Bands[0], 5, 0,
                "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM");
            BaseHelper.GridColumnCount(ultraGridZgMs, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" });
            BaseHelper.GridColumnSum(ultraGridZgMs, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT" });

            PlanComm.setGridActivation(ultraGrid1.DisplayLayout.Bands[0], "CHC", "NumberRule");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 2,
              "DIAMETER_GP", "LENGTH_GP", "ROLL_LENGTH", "DIAMETER_MANDREL", "AIMOUTDIAMETER", "AIMWALLTHICK",
              "LEN_GP_SINGLE", "AIMLENGTH", "OUTDIAMETER_ZG", "WALLTHICK_ZG");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 3,
                "WEIGTH_S", "WEIGTH_S_MIN", "GPREQ_WEIGHT", "MATCH_WT_IN", "ALLOWANCE", "FurnWt", "LjWeight", "OUT_WT", "Reall_WT");
            PlanComm.setGridDigitalCol(ultraGrid1.DisplayLayout.Bands[0], 5, 0,
                "NUM_S", "OUTNUM_CUT", "MULTIPLE_NUM", "PLAN_USETIME", "GPREQ_NUM", "PLANS_NUM", "MATCH_NUM_IN", "FurnNum", "LjNum", "OUT_NUM", "Reall_NUM");
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "MATCH_NUM_IN", "GPREQ_NUM", "Reall_NUM" });
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "MATCH_WT_IN", "GPREQ_WEIGHT", "Reall_WT" });

            //设置列头名称
            EntityHelper.ShowGridCaption<PlnOrderCastSEntity>(ultraGridCast.DisplayLayout.Bands[0]);
            BaseHelper.setOtherColumnReadOnly(ultraGridCast, new string[] { "CHC", "CanNum", "PlineCode", "PlineCodeA", "PlanTimeB", "PlanUsetime", "RepairType", "Memo", "ProgyMemo", "ManualNum", "CraftNo", "CutNumGp" });
            BaseHelper.InitCellPosition(ultraGridCast, new string[] { "GxPlanNo", "OrderSeq", "DeliveryNo", "PlanWtS", "PlanNumS", "PlanUsetime", "GxProSeq", "PlnDivideId", "DiameterLz", "LenGpSingle", "CutNumGp", "CutLoseLen", "LengthLz", "WtCastOne", "CastNumCalc", "FurnaceNumCalc", "FurnaceWt", "PlanedWt", "PlanedNum", "Finishweight", "FinishNum", "CastNum", "FurnaceNum", "AddWtBegin", "AddWtEnd", "AddWtAhead", "AddWtNext", "CanWgt", "CanNum", "GradeSort", "ProcessingCostA", "TotalCostA", "ProcessingCostB", "TotalCostB", "ManualNum", "PlanWtSold", "PlanNumSold" });
            BaseHelper.GridColumnSum(ultraGridCast, new string[] { "PlanWtS", "CanWgt" });
            BaseHelper.GridColumnCount(ultraGridCast, new string[] { "PlanNumS", "CanNum" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridCast, new string[] { "PlanWtS", "CanWgt", "PlanedWt", "PlanWtSold" });
            BaseHelper.setUltraGridColumnBits(ultraGridCast, new string[] { "PlanNumS", "CanNum", "PlanedNum", "ManualNum" });
            PlanHelper.InitRepairType(ultraGridCast, this);
            BaseHelper.ForbidSort(ultraGridCast);
            ultraGridZgMs.DisplayLayout.Bands[0].Columns["SPEC_CIC"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.selectPlanRouteCic", new object[] { furnaceno }, ob);
            if (dt.Rows.Count > 0)
            {
                cic = dt.Rows[0]["CIC"].ToString();
                planRoute = dt.Rows[0]["PLAN_ROUTE"].ToString();
            }

            ultraGroupBox1.Text = ultraGroupBox1.Text + "       炉次余量:" + toWeightM + "     索引码:" + cic + ",工艺路径:" + planRoute;
            QueryZgS();
        }
        //DataTable dtlz = new DataTable();
        private void QueryZgS()
        {
            //dtlz = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryLZDataZg", new object[] { }, ob);
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            { Query(); }
            else if (ultraTabControl1.SelectedTab.Key.Equals("2"))
            {
                QueryGp();
            }
            else
            {
                QueryOrder();
            }
        }
        /// <summary>
        /// 查询无管坯需求轧管订单
        /// </summary>
        private void Query()
        {
            DataTable dtZg = new DataTable();
            if (!diammterGp.Contains("t"))
            {
                dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.selectPlnOrderZgS", new object[] { cic, planRoute, gradCode, diammterGp, "0" }, ob);
            }
            GridHelper.CopyDataToDatatable(dtZg, dataTable1, true);
            //GridHelper.RefreshAndAutoSize(ultraGridZgMs);
          
            #region 赋值LJ，装炉，出库
            foreach (UltraGridRow ugr in ultraGridZgMs.Rows)
            {
                //int numz = 0;
                //double wtz = 0;
                int numLj = 0;
                double wtLj = 0;
                //int batNum = 0;
                //double batWt = 0;
                //if (dtlz.Rows.Count > 0)
                //{
                //    DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");
                //    if (drs != null && drs.Length > 0)
                //    {
                //        if (!drs[0]["装炉支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString();
                //            ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString();
                //            numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString());
                //            wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString());
                //        }
                //        else
                //        {
                //            numz = 0;
                //            wtz = 0;
                //        }
                //        if (!drs[0]["LJ支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString();
                //            ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString();
                //            numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                //            wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //        }
                //        else
                //        {
                //            numLj = 0;
                //            wtLj = 0;
                //        }
                //        if (!drs[0]["出库支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString();
                //            ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString();
                //            batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString());
                //            batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //        }
                //        else
                //        {
                //            batNum = 0;
                //            batWt = 0;
                //        }
                //    }
                //}

                //if (ugr.Cells["BATCHED_NUM"].Text.Equals(""))
                //{
                //    batNum = 0;
                //    batWt = 0;
                //}
                //else
                //{
                //    batNum = int.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //    batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //}

                //if (ugr.Cells["LjNum"].Value.Equals("0"))
                //{
                //    numLj = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                //    wtLj = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                //}
                //else
                //{
                    numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                    wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //}
                int gpNum = 0;
                double gpWt = 0;
                double gpWtMin = 0;
                if (ugr.Cells["GPREQ_NUM"].Text.Equals(""))
                {
                    gpNum = 0;
                    gpWt = 0;
                    gpWtMin = 0;
                }
                else
                {
                    gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString());
                    gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString());
                    //gpWtMin = double.Parse(ugr.Cells["GPREQ_WEIGHT_MIN"].Value.ToString());
                }
                double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                if (gpNum - numLj<= 0)
                {
                    ugr.Cells["Reall_NUM"].Value = "0";
                    ugr.Cells["Reall_WT"].Value = "0";
                    //ugr.Cells["Reall_WT_MIN"].Value = 0;
                }
                else
                {
                    ugr.Cells["Reall_NUM"].Value = (gpNum -numLj).ToString();
                    ugr.Cells["Reall_WT"].Value = (gpWt - wtLj).ToString();
                    //ugr.Cells["Reall_WT_MIN"].Value = (gpWtMin - batWt - wtz - wtLj).ToString();
                }
            }
            #endregion
            //}
            ultraGridZgMs.UpdateData();
            if (radioButton1.Checked)
            {
                dataTable1.DefaultView.RowFilter = "Reall_NUM >0 ";
                DataTable dt = dataTable1.DefaultView.ToTable();
                _data1 = dataTable1.Copy();
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            }

        }
        /// <summary>
        /// 查询有管坯需求轧管订单
        /// </summary>
        private void QueryGp()
        {
            DataTable dtZg = new DataTable();
            if (!diammterGp.Contains("t"))
            {
                dtZg = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.selectPlnOrderZgS", new object[] { cic, planRoute, gradCode, diammterGp, "1" }, ob);
            }
            GridHelper.CopyDataToDatatable(dtZg, dataTable2, true);
            //GridHelper.RefreshAndAutoSize(ultraGridZgMs);

            #region 赋值LJ，装炉，出库
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                //int numz = 0;
                //double wtz = 0;
                int numLj = 0;
                double wtLj = 0;
                //int batNum = 0;
                //double batWt = 0;
                //if (dtlz.Rows.Count > 0)
                //{
                //    DataRow[] drs = dtlz.Select("订单号 ='" + ugr.Cells["PRO_PLAN_ID"].Value.ToString() + "' AND 序号='" + ugr.Cells["GX_PLAN_NO"].Value.ToString() + "'");
                //    if (drs != null && drs.Length > 0)
                //    {
                //        if (!drs[0]["装炉支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["FurnNum"].Value = drs[0]["装炉支"].ToString();
                //            ugr.Cells["FurnWt"].Value = drs[0]["装炉吨"].ToString();
                //            numz = int.Parse(ugr.Cells["FurnNum"].Value.ToString());
                //            wtz = double.Parse(ugr.Cells["FurnWt"].Value.ToString());
                //        }
                //        else
                //        {
                //            numz = 0;
                //            wtz = 0;
                //        }
                //        if (!drs[0]["LJ支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["LjNum"].Value = drs[0]["LJ支"].ToString();
                //            ugr.Cells["LjWeight"].Value = drs[0]["LJ吨"].ToString();
                //            numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                //            wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //        }
                //        else
                //        {
                //            numLj = 0;
                //            wtLj = 0;
                //        }
                //        if (!drs[0]["出库支"].ToString().Equals(""))
                //        {
                //            ugr.Cells["OUT_NUM"].Value = drs[0]["出库支"].ToString();
                //            ugr.Cells["OUT_WT"].Value = drs[0]["出库吨"].ToString();
                //            batNum = int.Parse(ugr.Cells["OUT_NUM"].Value.ToString());
                //            batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //        }
                //        else
                //        {
                //            batNum = 0;
                //            batWt = 0;
                //        }
                //    }
                //}

                //if (ugr.Cells["BATCHED_NUM"].Text.Equals(""))
                //{
                //    batNum = 0;
                //    batWt = 0;
                //}
                //else
                //{
                //    batNum = int.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //    batWt = double.Parse(ugr.Cells["OUT_WT"].Value.ToString());
                //}
                //if (ugr.Cells["LjNum"].Value.Equals("0"))
                //{
                //    numLj = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                //    wtLj = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                //}
                //else
                //{
                numLj = int.Parse(ugr.Cells["LjNum"].Value.ToString());
                wtLj = double.Parse(ugr.Cells["LjWeight"].Value.ToString());
                //}
                int gpNum = 0;
                double gpWt = 0;
                double gpWtMin = 0;
                if (ugr.Cells["GPREQ_NUM"].Text.Equals(""))
                {
                    gpNum = 0;
                    gpWt = 0;
                    gpWtMin = 0;
                }
                else
                {
                    gpNum = int.Parse(ugr.Cells["GPREQ_NUM"].Value.ToString());
                    gpWt = double.Parse(ugr.Cells["GPREQ_WEIGHT"].Value.ToString());
                    //gpWtMin = double.Parse(ugr.Cells["GPREQ_WEIGHT_MIN"].Value.ToString());
                }
                double matcInWt = double.Parse(ugr.Cells["MATCH_WT_IN"].Value.ToString());
                int matcInNum = int.Parse(ugr.Cells["MATCH_NUM_IN"].Value.ToString());
                if (gpNum - numLj < 0)
                {
                    ugr.Cells["Reall_NUM"].Value = "0";
                    ugr.Cells["Reall_WT"].Value = "0";
                    //ugr.Cells["Reall_WT_MIN"].Value = 0;
                }
                else
                {
                    ugr.Cells["Reall_NUM"].Value = (gpNum - numLj).ToString();
                    ugr.Cells["Reall_WT"].Value = (gpWt - wtLj).ToString();
                    //ugr.Cells["Reall_WT_MIN"].Value = (gpWtMin - batWt - wtz - wtLj).ToString();
                }
            }
            #endregion
            //}
            ultraGrid1.UpdateData();
            //if (radioButton1.Checked)
            //{
            dataTable2.DefaultView.RowFilter = "Reall_NUM >0 ";
            DataTable dt = dataTable2.DefaultView.ToTable();
            //_data2 = dataTable2.Copy();
            GridHelper.CopyDataToDatatable(dt, dataTable2, true);
            //}

        }
        private void QueryOrder()
        {
            if (diammterGp.Contains("t"))
            {
                diammterGp = diammterGp.Replace("t","");
            }
            List<PlnOrderCastSEntity> listSourceCast = EntityHelper.GetData<PlnOrderCastSEntity>
      ("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg.getOrderBInfoByContion", new object[] { cic, planRoute, gradCode, diammterGp, plineCode }, ob);

            plnOrderCastSEntityBindingSource.DataSource = listSourceCast;
        }
        /// <summary>
        /// 利库
        /// </summary>
        private void Library()
        {
            string falg = "0";
            string ciclc = "";
            UltraGridRow row = null;
            ArrayList list = new ArrayList();
            string seleTab = "";
            string gracdeZg="";
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                seleTab = "0";
                ultraGridZgMs.UpdateData();
                row = ultraGridZgMs.ActiveRow;
                if (row == null) return;
                if (planRoute.Contains("R"))
                {
                    planRoute = planRoute.Replace("R", "V");
                }
                //if (!row.Cells["STATION_ROAD_LG"].Text.ToString().Equals(planRoute))
                //{
                //    MessageUtil.ShowTips("炼钢工艺路径不同,不能利轧管计划!");
                //    return;
                //}
                if (row.Cells["NumberRule"].Text.ToString().Equals("") || row.Cells["NumberRule"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入倍尺数!");
                    return;
                }
                //if (double.Parse(row.Cells["Reall_WT"].Value.ToString()) - double.Parse(toWeightM) < 0.000002)
                //{
                //    MessageUtil.ShowTips("余材量大于轧管待冶炼量,不能利库!");
                //    return;
                //}
                list.Add(row.Cells["PRO_PLAN_ID"].Text.ToString());
                list.Add(row.Cells["GX_PLAN_NO"].Text.ToString());
                list.Add(row.Cells["NumberRule"].Value.ToString());
                list.Add(row.Cells["Reall_WT"].Value.ToString());
                list.Add(row.Cells["Reall_NUM"].Value.ToString());
                list.Add(row.Cells["LEN_GP_SINGLE"].Value.ToString());
                list.Add(row.Cells["GPREQ_ID"].Text.ToString());
                if (!row.Cells["GRADECODE_LK"].Text.ToString().Equals(""))
                {
                    gracdeZg = row.Cells["GRADECODE_LK"].Value.ToString();
                }
                //else
                //{
                //    gracdeZg = row.Cells["GRADECODE"].Value.ToString();
                //}
                if (gracdeZg.Contains(gradCode))
                {
                    MessageUtil.ShowTips("在该订单下钢种是利库钢种,不能利库!");
                    return;
                }
                list.Add(row.Cells["SPEC_CIC"].Text.ToString());
                if (row.Cells["SPEC_CIC"].Text.Equals(""))
                {
                    MessageUtil.ShowTips("请指定CIC!");
                    return;
                }
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("2"))
            {
                seleTab = "2";
                ultraGrid1.UpdateData();
                row = ultraGrid1.ActiveRow;
                if (row == null) return;
                if (planRoute.Contains("R"))
                {
                    planRoute = planRoute.Replace("R", "V");
                }
                if (!row.Cells["STATION_ROAD_LG"].Text.ToString().Equals(planRoute))
                {
                    MessageUtil.ShowTips("炼钢工艺路径不同,不能利轧管计划!");
                    return;
                }
                if (row.Cells["NumberRule"].Text.ToString().Equals("") || row.Cells["NumberRule"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入倍尺数!");
                    return;
                }
                //if (double.Parse(row.Cells["Reall_WT"].Value.ToString()) - double.Parse(toWeightM) < 0.000002)
                //{
                //    MessageUtil.ShowTips("余材量大于轧管待冶炼量,不能利库!");
                //    return;
                //}
                list.Add(row.Cells["PRO_PLAN_ID"].Text.ToString());
                list.Add(row.Cells["GX_PLAN_NO"].Text.ToString());
                list.Add(row.Cells["NumberRule"].Value.ToString());
                list.Add(row.Cells["Reall_WT"].Value.ToString());
                list.Add(row.Cells["Reall_NUM"].Value.ToString());
                list.Add(row.Cells["LEN_GP_SINGLE"].Value.ToString());
                list.Add(row.Cells["GPREQ_ID"].Text.ToString());
                list.Add("");
            }
           
            //if (!cic.Contains(row.Cells["CIC_GP"].Text.ToString()))
            //{
            //    falg = "1";
            //    ciclc = cic + "," + row.Cells["CIC_GP"].Text.ToString();
            //string[] strArray = ciclc.Split(',').Distinct().ToArray();
            //    Array.Sort(strArray);
            //    ciclc = string.Join(",", strArray);
            //    //    //查询是否存在索引码交集
            //    //    DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelMerge.getQueryCicAll", new object[] { cic }, ob);
            //    //    if (dt.Rows.Count <= 0)
            //    //    {
            //    //        MessageUtil.ShowTips("不存在索引码" + cic + "交集!");
            //    //        return;
            //    //    }    
            //}
            //else
            //{
            //    ciclc = cic;
            //}
            ciclc = cic;
            if (MessageUtil.ShowYesNoAndQuestion("是否利计划?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg";
            ccp.MethodName = "doLibrary";
            ccp.ServerParams = new object[] { list, furnaceno, sequenceno, this.UserInfo.GetUserName(), ciclc, falg, seleTab };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("利计划成功!"))
            {
                if (seleTab.Equals("0"))
                {
                    Query();
                }
                else if (seleTab.Equals("2"))
                {
                    QueryGp();
                }
                Flag = true;
            }

        }
        //利铸造
        private void AddCast()
        {
            ultraGridZgMs.UpdateData();
            UltraGridRow row = ultraGridCast.ActiveRow;
            if (row == null) return;
            ArrayList list = new ArrayList();
            double gpwt = 0;
            list.Add(row.Cells["ProPlanId"].Text.ToString());
            list.Add(row.Cells["GxPlanNo"].Text.ToString());
            string falg = "0";
            string ciclc = "";
            if (!cic.Contains(row.Cells["Cic"].Text.ToString()))
            {
                falg = "1";
                ciclc = cic + "," + row.Cells["Cic"].Text.ToString();
                string[] strArray = ciclc.Split(',').Distinct().ToArray();
                Array.Sort(strArray);
                ciclc = string.Join(",", strArray);
                //    //查询是否存在索引码交集
                //    DataTable dt = ServerHelper.GetData("com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelMerge.getQueryCicAll", new object[] { cic }, ob);
                //    if (dt.Rows.Count <= 0)
                //    {
                //        MessageUtil.ShowTips("不存在索引码" + cic + "交集!");
                //        return;
                //    }    
            }
            else
            {
                ciclc = cic;
            }
            //}
            //if (gpwt<)
            if (MessageUtil.ShowYesNoAndQuestion("是否利计划?") == DialogResult.No)
            {
                return;
            }
            PlanComm.WaitFromOpen(this.Cursor);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.steelMarkingPlan.FrmSteelPlnZg";
            ccp.MethodName = "doAddCast";
            ccp.ServerParams = new object[] { list, furnaceno, sequenceno, this.UserInfo.GetUserName(), ciclc, falg };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            PlanComm.WaitFromColse(this.Cursor);
            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("利计划成功!"))
            {
                QueryOrder();
                Flag = true;
            }
        }
        /// <summary>
        /// 点击列事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridZgMs_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow urg = ultraGridZgMs.ActiveRow;
            ultraGridZgMs.UpdateData();
            string txt = "轧管排产信息" + "       炉次余量:" + toWeightM;       
            //if (e.Cell.Column.Key.Equals("CHC"))
            //{
                 
            //}
            double wt = 0;
            foreach (UltraGridRow row in ultraGridZgMs.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHC"].Text.ToString()) == true)
                {
                    wt += double.Parse(row.Cells["GPREQ_WEIGHT"].Value.ToString());
                }
            }
            ultraGroupBox1.Text = txt + "      轧管需求吨:" + wt;

        }
        /// <summary>
        /// 索引码合并
        /// </summary>
        private void doQueryCicAll()
        {
            List<string> list1 = new List<string>();
            string gradeCode = "";
            string cic = "";
            List<string> list = new List<string>();
            ArrayList arrlist = new ArrayList();
            foreach (UltraGridRow ugr2 in ultraGridZgMs.Rows)
            {
                gradeCode = ugr2.Cells["GradeName"].Text.ToString();
                list.Add(ugr2.Cells["Cic"].Text.ToString());
                //list.Add(ugr.Cells["ProPlanId"].Text.ToString());
            }
            list = list.Distinct().ToList();
            for (int i = 0; i < list.Count; i++)
            {
                foreach (UltraGridRow ugr in ultraGridZgMs.Rows)
                {
                    if (!ugr.Cells["ProPlanId"].Text.Equals(""))
                    {
                        if (ugr.Cells["Cic"].Text.ToString().Equals(list[i]))
                        {
                            ArrayList listar = new ArrayList();
                            list1.Add(ugr.Cells["ProPlanId"].Text.ToString());

                            listar.Add(ugr.Cells["Cic"].Text.ToString());
                            listar.Add(ugr.Cells["ProPlanId"].Text.ToString());
                            listar.Add("1");
                            listar.Add("工艺评审");
                            arrlist.Add(listar);
                        }
                    }
                }
            }
            ArrayList listar1 = new ArrayList();
            listar1.Add("");
            listar1.Add("null");
            listar1.Add("0");
            listar1.Add("基础数据");
            arrlist.Add(listar1);
            this.Cursor = Cursors.WaitCursor;
            AnalysisNkChemPopupLg popup = new AnalysisNkChemPopupLg(list.ToArray(), gradeCode, this.ob, list1.ToArray(), arrlist);
            popup.TopMost = true;
            popup.Load += ((a, b) =>
            {
                this.Cursor = Cursors.Default;
            });
            popup.Show();
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Key.Equals("0"))
            {
                ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = true;
                ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false;
                ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = true;
                Query();
            }
            else if (ultraTabControl1.SelectedTab.Key.Equals("1"))
            {
                ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = false;
                ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = true;
                ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = false;
                QueryOrder();
            }else{
                ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = true;
                ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = false;
                QueryGp();
            }
        }

        private void FrmSteelPlnZg_Shown(object sender, EventArgs e)
        {
            ultraToolbarsManager1.Toolbars[0].Tools["Library"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["AddCast"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["ControlContainerTool1"].SharedProps.Visible = true;
        }
        private DataTable _data1;
        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            ultraGridZgMs.UpdateData();
            //ultraGridZgMs.DataSource = dataTable1.DefaultView;
            if (radioButton1.Checked)
            {
                dataTable1.DefaultView.RowFilter = "Reall_NUM >0 ";
                DataTable dt = dataTable1.DefaultView.ToTable();
                _data1 = dataTable1.Copy();
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            }
            else
            {
                GridHelper.CopyDataToDatatable(_data1, dataTable1, true);
            }
            ultraGridZgMs.Refresh();
            ultraGridZgMs.Update();
        }

        private void entityGrid2_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridZgMs.ActiveRow;
            if (row == null) return;
            if (e.Cell.Column.Key.Equals("CHC"))
            {
                UltraGridRow rowCic = entityGrid2.ActiveRow;
                if (rowCic == null) return;

                row.Cells["SPEC_CIC"].Value = rowCic.Cells["CIC"].Value.ToString();
            }
        }
        DataTable dtCic = new DataTable();
        private void QueryCic(string ordLnDlyPk, string indexSeq, string carftSeq)
        {
            dtCic = ServerHelper.GetData("com.steering.pss.plnsaleord.planStove.StoveHelper.queryCic", new object[] { ordLnDlyPk, indexSeq, carftSeq }, ob);
            GridHelper.CopyDataToDatatable(dtCic, dataTable3, true);
            GridHelper.RefreshAndAutoSize(entityGrid2);
            foreach (UltraGridRow ugr in entityGrid2.Rows)
            {
                ugr.Cells["CHC"].Value = "指定";
            }
        }
        private void ultraGridZgMs_AfterRowActivate(object sender, EventArgs e)
        {

            UltraGridRow row = ultraGridZgMs.ActiveRow;
            if (row == null) return;
            string ordLnDlyPk = row.Cells["ORD_LN_DLY_PK"].Text.ToString();
            string indexSeq = row.Cells["INDEX_SEQ"].Text.ToString();
            string carftSeq = row.Cells["CRAFT_SEQ"].Text.ToString();
            QueryCic(ordLnDlyPk, indexSeq, carftSeq);
            //string gradeName = row.Cells["Gradename"].Text.ToString();
            entityGrid2.UpdateData();
            DataRow[] datarows = dtCic.Select("GRADECODE = '" + gradCode + "'");
            DataTable tab = StoveHelper.ToDataTable(datarows);
            GridHelper.CopyDataToDatatable(tab, dataTable3, true);
            GridHelper.RefreshAndAutoSize(entityGrid2);
            foreach (UltraGridRow ugr in entityGrid2.Rows)
            {
                ugr.Cells["CHC"].Value = "指定";
            }
            entityGrid2.Refresh();
            entityGrid2.Update();
        }

        private void ultraGridZgMs_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridZgMs.ActiveRow;
            if (row == null) return;
            if (e.Cell.Column.Key.Equals("SPEC_CIC"))
            {
                row.Cells["SPEC_CIC"].Value = "";
            }
        }
    }
}