MES_Client/TGMES/Core.StlMes.Client.PlnSaleOrd/工序排产/FrmPlnOrderDbkSQuery.cs

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;
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.工序排产;
using Core.StlMes.Client.PlnSaleOrd.工序排产.entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using Core.StlMes.Client.PlnSaleOrd.炉计划.Tool;
using Core.StlMes.Client.PlnSaleOrd.窗体;

namespace Core.StlMes.Client.PlnSaleOrd
{
    /// <summary>
    /// 镦拔扩排产(CustomInfo 为0  镦拔扩排产查询 1 镦拔扩排产 2 镦拔扩炉计划)
    /// </summary>
    public partial class FrmPlnOrderDbkSQuery : FrmBase
    {
        DataTable dtPlinGroup = null;
        /// <summary>
        ///产线权限
        /// </summary>
        private string[] plinePower = new string[] { "" };
        /// <summary>
        /// 订单编号
        /// </summary>
        private string _ProPlanId = "";
        /// <summary>
        /// 订单排产序号
        /// </summary>
        private string _GxPlanNo = "";
        /// <summary>
        /// 产线
        /// </summary>
        private string _PlineCode = "";
        /// <summary>
        /// 颜色
        /// </summary>
        private Color _color = new Color();
        private string proPlanId = "";
        private string gxPlanNo = "";
        private ArrayList _EntityList = null;
        public FrmPlnOrderDbkSQuery()
        {
            this.IsLoadUserView = true;
            InitializeComponent();

        }

        private void FrmPlnOrderDbkS_Load(object sender, EventArgs e)
        {


                ultraGridDbks.DisplayLayout.Bands[0].Columns["IsOnloadLine"].Hidden = true;

            BaseHelper.setUltraGridColumnMaxInput(ultraGridDbks, new string[] { "WeigthS" });
            BaseHelper.InitCellPosition(ultraGridDbks, new string[] {"CountNum", "GxPlanNo", "OrderSeq", "DeliveryNo", "WeigthS", "NumS", "PlanUsetime", "GxProSeq", "PlnDivideId", "Outdiameter", "Wallthick", "Lengthmax", "Lengthmin", "Aimlength",
                "OutdiameterIn", "WallthickIn", "LengthmaxIn", "LengthminIn", "Aimoutdiameter", "Aimwallthick", "LenCuthead", "LenCutend" ,"AddWtIn","AddNumIn","MatchWtIn","MatchNumIn",         "BatchedWt","BatchedNum","Finishweight","Finishnum","InNumS","InWeightS","FinishWgt","UnfinishWgt","UnfinishNum","MinWgt","RealBatchWt","RealBatchNum","StockNumMononer","StockNumLiku","ExpectWt","ExpectNum"});

            BaseHelper.setUltraGridColumnMaxInput(ultraGridDbks, new string[] { "MinWgt" });
            BaseHelper.GridColumnSum(ultraGridDbks, new string[] { "WeigthS" });
            BaseHelper.GridColumnCount(ultraGridDbks, new string[] { "NumS" });
            BaseHelper.InitCellPositionMiddle(ultraGridDbks, new string[] { "IsRepairPln", "Isendgx", "IfMonitorDbk", "IsPlanOk", "IfStoveIssued", "IfZyReady", "IfZyM", "IsOnloadLine" });
            BaseHelper.setUltraGridColumnColor(ultraGridDbks, new string[] { "CraftFileNo", "CraftFileLv2G" }, Color.GreenYellow);
            PlanHelper.InitDropPline("E", "", comPline, this.ob);
            PlanHelper.InitRepairType(ultraGridDbks, this);
            PlanHelper.InitEditPline("E", "", ultraGridDbks, this);
            //BaseHelper.setOtherColumnReadOnly(ultraGridDbks, new string[] { "CHC", "PlanTimeB", "RepairType", "PlanUsetime", "PlineCode", "Memo" });
            
            _color = ultraGridDbks.DisplayLayout.Override.RowSelectorAppearance.BackColor;
            InitColorStyle();

            EntityHelper.ShowGridCaption<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyDbkReadyEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            //炉计划
            BaseHelper.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHC", "JudgeStoveNo", "Memo" });
            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", "PlanIndoubleWt","RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum"});
            BaseHelper.GridColumnSum(ultraGrid1, new string[] { "RealOutdoubleWt", "RealIndoubleWt", "PlanIndoubleWt" });
            BaseHelper.GridColumnCount(ultraGrid1, new string[] { "RealOutdoubleNum", "RealIndoubleNum", "PlanIndoubleNum" });
            BaseHelper.setColumnBackColor(ultraGrid1, new string[] { "JudgeStoveNo", "Memo" });
            BaseHelper.SetGroupBySum(ultraGrid1, new string[] { "PlnInsingleWt", "PlnOutsingleW","PlnInsingleNum", "PlnOutsingleNum" }, "HeatPlanNo");
            InitTime();
            ultraGridDbks.DisplayLayout.Bands[0].Columns["PreInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["PreInfo"].CellAppearance.BackColor = Color.GreenYellow;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["AfInfo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["AfInfo"].CellAppearance.BackColor = Color.GreenYellow;
            UltraComboEditor uceAbc = new UltraComboEditor();
            ultraGridDbks.DisplayLayout.Bands[0].Columns["Decision"].EditorComponent = uceAbc;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["Decision"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ValueList vlistSteel = new ValueList(); ;
            vlistSteel.ValueListItems.Insert(0, "A", "A");
            vlistSteel.ValueListItems.Insert(1, "B", "B");
            vlistSteel.ValueListItems.Insert(2, "C", "C");
            ultraGridDbks.DisplayLayout.Bands[0].Columns["Decision"].ValueList = vlistSteel;
        }

        private void InitTime()
        {
            DateTime now = DateTime.Now;
            DateTime d1 = new DateTime(now.Year, now.Month, 1);
            DateTime d2 = d1.AddMonths(1).AddSeconds(-1);
            txtPlanTimeB1.Value = d1;
            txtPlanTimeB2.Value = d2;
            txtPlanTimeE1.Value = d1;
            txtPlanTimeE2.Value = d2;
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query"://查询
                    Query();
                    break;
                case "Export": //导出
                    GridHelper.ulGridToExcel(ultraGridDbks, "镦拔扩排产信息");
                    break;
                case "Close":
                    this.Close();
                    break;
                default:
                    break;
            }
        }


        private void chcPline_CheckedChanged(object sender, EventArgs e)
        {
            if (chcPline.Checked) { comPline.ReadOnly = false; } else { comPline.ReadOnly = true; }
            if (chcProPlanId.Checked) { txtProPlanId.ReadOnly = false; } else { txtProPlanId.ReadOnly = true; }
            if (chcOrderNo.Checked) { txtOrderNo.ReadOnly = false; } else { txtOrderNo.ReadOnly = true; }
            if (chcPlanTimeB.Checked) { txtPlanTimeB1.ReadOnly = false; txtPlanTimeB2.ReadOnly = false; } else { txtPlanTimeB1.ReadOnly = true; txtPlanTimeB2.ReadOnly = true; }
            if (chcPlanTimeE.Checked) { txtPlanTimeE1.ReadOnly = false; txtPlanTimeE2.ReadOnly = false; } else { txtPlanTimeE1.ReadOnly = true; txtPlanTimeE2.ReadOnly = true; }
        }

        /// <summary>
        /// 查询
        /// </summary>
        void Query()
        {
            string plineCode = "";//产线
            if (chcPline.Checked && comPline.Value != null) { plineCode = comPline.Value.ToString(); }
            if (!CustomInfo.Equals("0") && plineCode.Equals(""))
            {
                MessageUtil.ShowTips("请选择产线!");
                return;
            }
                WaitingForm2 wf3 = new WaitingForm2("正在刷新，请稍候....");
            try
            {
                this.Cursor = Cursors.WaitCursor;
            string[] statusArray = contorlPlanStatus1.statusArr;
            string orderNo = "";//合同号
            if (chcOrderNo.Checked) { orderNo = txtOrderNo.Text.Trim(); }
            string proPlanId = ""; //订单编号
            if (chcProPlanId.Checked) { proPlanId = txtProPlanId.Text.Trim(); }

            string planTimeB1 = "";
            string planTimeB2 = "";
            if (chcPlanTimeB.Checked && txtPlanTimeB2.Value != null && txtPlanTimeB1.Value != null)
            {
                planTimeB1 = DateTime.Parse(txtPlanTimeB1.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                planTimeB2 = DateTime.Parse(txtPlanTimeB2.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
            }
            string planTimeE1 = "";
            string planTimeE2 = "";
            if (chcPlanTimeE.Checked && txtPlanTimeE2.Value != null && txtPlanTimeE1.Value != null)
            {
                planTimeE1 = DateTime.Parse(txtPlanTimeE1.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                planTimeE2 = DateTime.Parse(txtPlanTimeE2.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
            }
            string flag = "";//查询下发 的标识 
            if (CustomInfo.Equals("2")) { flag = "1"; }
            List<PlnOrderDbkSOEntity> listSource = EntityHelper.GetData<PlnOrderDbkSOEntity>
                ("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlanOrderE",
                new object[] { plineCode, orderNo, proPlanId, statusArray, plinePower, flag, planTimeB1, planTimeB2, planTimeE1, planTimeE2  }, this.ob);
            plnOrderDbkSOEntityBindingSource.DataSource = listSource;
            dtPlinGroup = ServerHelper.GetData("com.steering.pss.plnsaleord.processOrder.base.ProducHelper.queryPlinCodeGroup", null, this.ob);
                if (listSource == null || listSource.Count == 0)
            {
                //plnZyDbkMEntityBindingSource.Clear();
                plnZyDbkReadyEntityBindingSource.Clear();
            }
            foreach (UltraGridRow ugr in ultraGridDbks.Rows)
            {
                string str = ugr.Cells["PreInfo"].Text.Trim();

                if (str != null && str != "")
                {
                    string[] sArray = str.Split(new char[3] { '天', ',', '条' });
                    //ugr.Cells["TimeDiffer"].Value = sArray[0];
                    ugr.Cells["BefProLin"].Value = sArray[2];
                    ugr.Cells["BefProNum"].Value = sArray[3];
                }
                 string strH = ugr.Cells["AfInfo"].Text.Trim();

                 if (strH != null && strH != "")
                 {
                     string[] sArray = strH.Split(new char[3] { '天', ',', '条' });
                     string plineCodeH = sArray[2];
                     if (dtPlinGroup.Rows.Count > 0)
                     {
                         //for (int i = 0; i < dtPlinGroup.Rows.Count; i++)
                         //{
                         string plinGroup = dtPlinGroup.Rows[0]["PLINE_NAME_M"].ToString() + "/" + dtPlinGroup.Rows[0]["PLINE_NAME_C"].ToString();
                         DataRow[] dr = dtPlinGroup.Select("PLINE_NAME_M='" + ugr.Cells["PlineCode"].Text.ToString() + "' AND PLINE_NAME_C ='" + plineCodeH + "'", "");
                         if (dr == null || dr.Length == 0) { }
                         else
                         {
                             //DataTable tmp = dr.Table.Clone();  // 复制DataRow的表结构

                             //if (tmp.Rows.Count > 0)
                             //{
                             ugr.Cells["StockGroupName"].Value = dr[0]["STOCK_GROUP_NAME"].ToString();
                             //}
                         }
                     }
                 }

            
           //ProducHelper.copyLZData(ultraGridDbks,"E",this.ob);
            if ((!_ProPlanId.Equals("") && !_GxPlanNo.Equals("")) || _EntityList != null)
                //foreach (UltraGridRow ugr in ultraGridDbks.Rows)
                //{
                    if (!_ProPlanId.Equals("") && !_GxPlanNo.Equals(""))
                    {
                        if (ugr.Cells["ProPlanId"].Text.Trim().Equals(_ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(_GxPlanNo))
                        {
                            ugr.Activate();
                            break;
                        }
                    }
                    if (_EntityList != null)
                    {
                        for (int i = 0; i < _EntityList.Count; i++)
                        {
                            PlnOrderDbkSEntity entity = (PlnOrderDbkSEntity)_EntityList[i];
                            if (ugr.Cells["ProPlanId"].Text.Trim().Equals(entity.ProPlanId) && ugr.Cells["GxPlanNo"].Text.Trim().Equals(entity.GxPlanNo))
                            {
                                ugr.Appearance.BackColor = Color.Wheat;
                                ugr.Activate();
                            }
                        }
                    }

            }

            _ProPlanId = "";
            _GxPlanNo = "";
            _EntityList = null;
            if (comPline.Value != null)
            {
                _PlineCode = comPline.Value.ToString();
            }
            }
            finally
            {
                wf3.Close();
                this.Cursor = Cursors.Default;
            }

        }


       


        private void ultraGridDbks_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            PlanHelper.ControlCellEdit(e.Row);
        }

        private void ultraGridDbks_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugrAc = ultraGridDbks.ActiveRow;
            if (ugrAc == null)
            {
                return;
            }
            proPlanId = ugrAc.Cells["ProPlanId"].Text;
            gxPlanNo = ugrAc.Cells["GxPlanNo"].Text;
           QueryZyReadyE(proPlanId, gxPlanNo);
        }
        /// <summary>
        /// 查询镦拔扩虚拟炉计划
        /// </summary>
        /// <param name="proPlanId"></param>
        /// <param name="gxPlanNo"></param>
        private void QueryZyReadyE(string proPlanId, string gxPlanNo)
        {
            List<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyDbkReadyEntity> listSource = EntityHelper.GetData<Core.StlMes.Client.PlnSaleOrd.炉计划.Entity.PlnZyDbkReadyEntity>
         ("com.steering.pss.plnsaleord.planStove.FrmPlanStoveE.queryPlanStovePlanId", new object[] { proPlanId, gxPlanNo }, 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 ultraGridDbks_CellChange(object sender, CellEventArgs e)
        {

        }


      
        private void ultraGridDbks_ClickCellButton(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGridDbks.ActiveRow;
            if (e.Cell.Column.Key.Equals("CraftFileNo"))
            {
                string filePath = row.GetValue("CraftPath");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, filePath);
                askDown.Show();
            }
            else if (e.Cell.Column.Key.Equals("CraftFileLv2G"))
            {
                string craftFileLv2G = row.GetValue("CraftFileLv2G");
                dlgOrderAskDown askDown = new dlgOrderAskDown(this.ob, craftFileLv2G);
                askDown.Show();
            }
            if (e.Cell.Column.Key.Equals("PreInfo"))
            {
                string proPlanId = row.GetValue("ProPlanId");
                string preInfo = row.GetValue("PreInfo");
                if (preInfo == null || preInfo.Length == 0) { return; }
                FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "E", "Pr", this.ob);
                frmPreGxInfo.ShowDialog();
            }
            if (e.Cell.Column.Key.Equals("AfInfo"))
            {
                string proPlanId = row.GetValue("ProPlanId");
                string afInfo = row.GetValue("AfInfo");
                if (afInfo == null || afInfo.Length == 0) { return; }
                FrmPreGxInfo frmPreGxInfo = new FrmPreGxInfo(proPlanId, "E", "Af", this.ob);
                frmPreGxInfo.ShowDialog();
            }
        }

        /// <summary>
        /// 初始化列状态
        /// </summary>
        private void InitColorStyle()
        {
            ultraGridDbks.DisplayLayout.Bands[0].Columns["PlanTimeB"].Format = "yyyy-MM-dd HH:mm:ss";
            ultraGridDbks.DisplayLayout.Bands[0].Columns["PlanTimeB"].MaskInput = "yyyy-mm-dd hh:mm:ss";
            ultraGridDbks.DisplayLayout.Bands[0].Columns["PlanTimeB"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["CraftFileLv2G"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
            ultraGridDbks.DisplayLayout.Bands[0].Columns["CraftFileNo"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.EditButton;
        }


        #region 炉计划层操作
        private int splitterDistance = 0;
        private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
        {
            if (ultraExpandableGroupBox1.Expanded == false)
            {
                this.splitContainer1.SplitterDistance = splitContainer1.Size.Height - 26;
            }
            else
            {
                this.splitContainer1.SplitterDistance = splitterDistance == 0 ? splitContainer1.Size.Height / 2 : splitterDistance;
            }
        }
        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            StoveHelper.CustomMergedCellEvaluator merge = new StoveHelper.CustomMergedCellEvaluator("HeatPlanNo");
            e.Layout.Bands[0].Columns["Memo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["Memo"].MergedCellEvaluator = merge;       
            e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellStyle = MergedCellStyle.Always;
            e.Layout.Bands[0].Columns["FeedHeatNo"].MergedCellEvaluator = merge;
            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;
        }
        #endregion

    }
}