MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/炉计划/FrmPlanStoveE.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
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.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 FrmPlanStoveE : FrmBase
    {
        private ArrayList _EntityList = null;
        private string[] plineCode = null;//获取产线代码
        /// <summary>
        /// 虚拟炉计划id
        /// </summary>
        private string _heatPlanNo = "";
        /// <summary>
        /// 行首背景色
        /// </summary>
        private Color _backColor = new Color();
        public FrmPlanStoveE()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }

        private void FrmPlanStoveE_Load(object sender, EventArgs e)
        {
            //订单排产
            EntityHelper.ShowGridCaption<PlnZyDbkMEntity>(ultraGridZyE.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyDbkReadyEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            //BaseHelper.setOtherColumnReadOnly(ultraGridZyE, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
            BaseHelper.setUltraGridColumnBits(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
            BaseHelper.InitCellPosition(ultraGridZyE, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt",  "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
                "LengthminIn","OutnumCut",      "Aimoutdiameter","Aimwallthick","AimlengthMax","Aimlength","AimlengthMin","LenCutend","LenCuthead","CraftSeq"});
            BaseHelper.GridColumnSum(ultraGridZyE, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW" });
            BaseHelper.GridColumnCount(ultraGridZyE, new string[] { "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" });
            //BaseHelper.InitCellPositionMiddle(ultraGridZyE, new string[] { "Isendgx", "IfWlMatched", "IfMonitorZg" });
            plineCode = PlanHelper.InitDropPlinePower("E", txtLine, this.ValidDataPurviewIds, this.ob);
            StoveHelper.ForbidSort(ultraGridZyE);
            //BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC" });
            BaseHelper.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt"});
            BaseHelper.setUltraGridColumnBits(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum"});
            BaseHelper.InitCellPosition(ultraGrid1, new string[] { "GxProSeq", "GxPlanNo","OrderSeq", "DeliveryNo", "PlnInsingleNum", "PlnInsingleWt",  "PlnIndoubleNum","PlnIndoubleWt","PlnOutsingleNum","PlnOutsingleW" ,"PlnOutdoubleNum","PlnOutdoubleW","OutdiameterIn","WallthickIn","LengthIn","LengthmaxIn",
                "LengthminIn","OutnumCut", "Aimoutdiameter","Aimwallthick","AimlengthMax","Aimlength","AimlengthMin","LenCutend","LenCuthead","CraftSeq","RealOutdoubleWt", "RealIndoubleWt", "RealOutdoubleNum", "RealIndoubleNum"});
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" });
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" });
            StoveHelper.ForbidSort(ultraGrid1);
            InitDate();
            BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnInsingleWt", "PlnOutsingleW", "PlnIndoubleWt", "PlnOutdoubleW", "PlnInsingleNum", "PlnOutsingleNum", "PlnIndoubleNum", "PlnOutdoubleNum" }, "HeatPlanNo");
            InitDate();
            BaseHelper.InitComboEditor(ultraComboEditor1, "com.steering.pss.plnsaleord.planStove.FrmPlanStoveD.doQueryStorageNo", "STORAGE_NO", ob, true);
        }
        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            StoveHelper.CustomMergedCellEvaluator merge = new StoveHelper.CustomMergedCellEvaluator("HeatPlanNo");
            e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["HeatPlanNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["JudgeStoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["StoveNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["StoveNo"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleWt"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleW"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnIndoubleWt"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutdoubleW"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnInsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutsingleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnIndoubleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["PlnOutdoubleNum"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["ZyBatchId"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["GxProSeq"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["GxProSeq"].MergedCellEvaluator = merge;
            e.Layout.Bands[0].Columns["Planstatus"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["Planstatus"].MergedCellEvaluator = merge;
           
        }
        /// <summary>
        /// 初始时间
        /// </summary>
        private void InitDate()
        {
            DateTime datetime = DateTime.Now;
            dateBegin.Value = datetime.AddDays(1 - datetime.Day);
            dateEnd.Value = datetime.AddDays(1 - datetime.Day).AddMonths(1).AddDays(-1);
        }


        private void chcLine_CheckedChanged(object sender, EventArgs e)
        {
            if (chcLine.Checked) { txtLine.Enabled = true; } else { txtLine.Enabled = false; }
            if (chcProPlanId.Checked) { txtProPlanId.Enabled = true; } else { txtProPlanId.Enabled = false; }
            if (chcOrderNo.Checked) { txtOrderNo.Enabled = true; } else { txtOrderNo.Enabled = false; }
            if (chcId.Checked) { txtId.Enabled = true; } else { txtId.Enabled = false; }
            if (chcTime.Checked) { dateBegin.Enabled = true; dateEnd.Enabled = true; }  else { dateBegin.Enabled = false; dateEnd.Enabled = false; }
            if (chcJudgeNo.Checked) { txtJudgeNo.Enabled = true; } else { txtJudgeNo.Enabled = false; }
            if (txtFeedCheck.Checked) { txtFeedHeatNo.Enabled = true; } else { txtFeedHeatNo.Enabled = false; }
        }


        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
                case "UpdateGoWhere":
                    updateGoWhere();
                    break;
                case "UpdateLoadFlag":
                    updateLoadFlag();
                    break;
                case"UpdateIsWeight":
                    updateIsWeight();
                    break;
                case "Export": //导出
                    Export();
                    break;
                case "Close": //关闭
                    this.Close();
                    break;
                default:
                    break;
            }
        }
        /// <summary>
        /// 标记是否过磅
        /// </summary>
        private void updateIsWeight()
        {
            this.ultraGridZyE.UpdateData();
            UltraGridRow row = this.ultraGridZyE.ActiveRow;
            if (row == null)
            {
                return;
            }
            ArrayList parmList = new ArrayList();
            PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
            string plnZgEntity = JSONFormat.Format(plnDbkTity);
            parmList.Add(plnZgEntity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
            ccp.MethodName = "updateIsWeight";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryM();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 标识库位不变
        /// </summary>
        private void updateLoadFlag()
        {
            this.ultraGridZyE.UpdateData();
            UltraGridRow row = this.ultraGridZyE.ActiveRow;
            if (row == null)
            {
                return;
            }
            ArrayList parmList = new ArrayList();
            PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
            string plnZgEntity = JSONFormat.Format(plnDbkTity);
            parmList.Add(plnZgEntity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
            ccp.MethodName = "updateLoadFlag";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryM();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 修改去向
        /// </summary>
        private void updateGoWhere()
        {
            this.ultraGridZyE.UpdateData();
            UltraGridRow row = this.ultraGridZyE.ActiveRow;
            if (row == null)
            {
                return;
            }
            ArrayList parmList = new ArrayList();
            PlnZyDbkMEntity plnDbkTity = (PlnZyDbkMEntity)row.ListObject;
            plnDbkTity.GowhereCode = row.Cells["GowhereCode"].Value.ToString();
            plnDbkTity.GowhereName = row.Cells["GowhereCode"].Text.ToString();
            string plnZgEntity = JSONFormat.Format(plnDbkTity);
            parmList.Add(plnZgEntity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.plnsaleord.planStove.FrmPlanStoveE";
            ccp.MethodName = "updateGoWhere";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryM();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        private void Query()
        {
            if (ultraExpandableGroupBox1.Expanded == false)
            {
                QueryC();
            }
            else
            {
                QueryM();
            }
        }
        private int activation = 0;
        /// <summary>
        /// 导出
        /// </summary>
        private void Export()
        {
            if (activation < 2)
            {
                GridHelper.ulGridToExcel(ultraGridZyE, "镦拔扩炉计划主信息");
            }
            else
            {
                GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩炉计划详情");
            }
        }
        /// <summary>
        /// 查询镦拔虚拟炉计划
        /// </summary>
        private void QueryM()
        {    //产线
            string plineCode = "";
            if (chcLine.Checked)
            {
                plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString();
            }
            //if (txtLine.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("请选择产线!");
            //    return;
            //}

            string timeBegin = "";
            string timeEnd = "";
            if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null)
            {
                timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd");
                timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd");
            }
            string orderNo = "";
            if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
            string proPlanId = "";
            if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
            string heatId = "";
            if (chcId.Checked) { heatId = txtId.Text.Trim(); }
            string judgeNo = "";
            if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); }
            string feedNo = "";
            if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); }
            //执行状态
            string[] statusArr = contorlPlanStatusZy1.statusArr;
            List<PlnZyDbkMEntity> listSource = EntityHelper.GetData<PlnZyDbkMEntity>
            ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveYzE", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob);
            plnZyDbkMEntityBindingSource.DataSource = listSource;
            foreach (UltraGridRow ugr in ultraGridZyE.Rows)
            {
                int countMess = 0;
                if (!_heatPlanNo.Equals(""))
                {
                    if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(_heatPlanNo))
                    {
                        ugr.Activate();
                        break;
                    }
                }
                if (_EntityList != null)
                {
                    for (int i = 0; i < _EntityList.Count; i++)
                    {
                        PlnZyDbkMEntity entity = (PlnZyDbkMEntity)_EntityList[i];
                        if (ugr.Cells["HeatPlanNo"].Text.Trim().Equals(entity.HeatPlanNo))
                        {
                            ugr.Appearance.BackColor = Color.Wheat;
                            ugr.Activate();
                        }
                    }
                }
            }

            _EntityList = null;
            _heatPlanNo = "";
        }
        /// <summary>
        /// 查询镦拔扩实际炉计划
        /// </summary>
        private void QueryC()
        {
            //产线
            string plineCode = "";
            if (chcLine.Checked)
            {
                plineCode = txtLine.Value == null ? "" : txtLine.Value.ToString();
            }
            //if (txtLine.Text.Equals(""))
            //{
            //    MessageUtil.ShowTips("请选择产线!");
            //    return;
            //}

            string timeBegin = "";
            string timeEnd = "";
            if (chcTime.Checked && dateBegin.Value != null && dateEnd.Value != null)
            {
                timeBegin = DateTime.Parse(dateBegin.Value.ToString()).ToString("yyyy-MM-dd");
                timeEnd = DateTime.Parse(dateEnd.Value.ToString()).ToString("yyyy-MM-dd");
            }

            string orderNo = "";
            if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
            string proPlanId = "";
            if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }
            string heatId = "";
            if (chcId.Checked) { heatId = txtId.Text.Trim(); }
            string judgeNo = "";
            if (chcJudgeNo.Checked) { judgeNo = txtJudgeNo.Text.Trim(); }
            string feedNo = "";
            if (txtFeedCheck.Checked) { feedNo = txtFeedHeatNo.Text.Trim(); }
            //执行状态
            string[] statusArr = contorlPlanStatusZy1.statusArr;
            List<PlnZyDbkReadyEntity> listSource = EntityHelper.GetData<PlnZyDbkReadyEntity>
         ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlnZyDbkReadyById", new object[] { timeBegin, timeEnd, plineCode, orderNo, proPlanId, heatId, statusArr, judgeNo, feedNo }, this.ob);
            plnZyDbkReadyEntityBindingSource.DataSource = listSource;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                //没有实际炉计划，主炉计划变颜色
                if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
                {
                    //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
                    ugr.Appearance.BackColor = Color.Orange;
                }
            }
        }

        private void ultraGridZyE_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = ultraGridZyE.ActiveRow;
            if (row == null) return;
            QueryMRow(row.Cells["HeatPlanNo"].Text.ToString().Trim());
        }
        private void QueryMRow(string heatPlanNo)
        {
            List<PlnZyDbkReadyEntity> listSourceM = EntityHelper.GetData<PlnZyDbkReadyEntity>
         ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStoveRow", new object[] { heatPlanNo }, ob);
            plnZyDbkReadyEntityBindingSource.DataSource = listSourceM;
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                //没有实际炉计划，主炉计划变颜色
                if (ugr.Cells["HeatPlanSqe"].Value.ToString().Equals(""))
                {
                    //ugr.RowSelectorAppearance.BackColor = Color.GreenYellow;
                    ugr.Appearance.BackColor = Color.Orange;
                }
            }
        }
        private int splitterDistance = 0;
        int count1 = 0;
        int count2 = 0;
        private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
        {
            if (ultraExpandableGroupBox1.Expanded == false)
            {
                this.splitContainer1.SplitterDistance = 26;
                count1 = 26;
            }
            else
            {
                if (ultraExpandableGroupBox2.Expanded == false)
                {
                    this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26;
                }
                else
                {
                    this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
                }
                count1 = splitContainer1.Size.Height - 26;
            }
        }

        private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
        {
            if (ultraExpandableGroupBox2.Expanded == false)
            {
                if (count1 == 0) { count1 = splitContainer1.Size.Height - 26; }
                this.splitContainer1.SplitterDistance = count1;
            }
            else
            {
                if (ultraExpandableGroupBox1.Expanded == false)
                {
                    this.splitContainer1.SplitterDistance = 26;
                }
                else
                {
                    //this.splitContainer1.SplitterDistance = count1;
                    this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
                }
            }
        }

        private void ultraGridZyE_Click(object sender, EventArgs e)
        {
            activation = 1;
        }

        private void ultraGridZyE_ClickCell(object sender, ClickCellEventArgs e)
        {
            activation = 1;
        }

        private void ultraGrid1_Click(object sender, EventArgs e)
        {
            activation = 2;
        }

        private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
        {
            activation = 2;
        }

        


      
    }
}